Create stock locator by using API (EBS R12)

Import the procurement acceptance interface of Phase I in the projectProgramMake changes and add the location information. Required: Location = sub-inventory + project + task. Because the sub-database enables the dynamic space control, it is necessary to dynamically create a space in the program, so it is a discount.

1. Interface table: rcv_transactions_interface

Field: locator_id

API: inv_loc_wms_pub.create_locator

2. Note: when creating a space dynamically, the space elastic domain will be created first. When creating a space elastic domain, the sub-inventory will be verified (inv_srs_subinv), the value set inv_srs_subinv, whereProfile. mfg_organization_idTherefore, fnd_profile.put ('mfg _ organization_id ', 111) must be processed in concurrent requests. Otherwise, the value set verification fails.

3. sample script

Declare
X_return_status varchar2 (1000 );
X_msg_count number;
X_msg_data varchar2 (1000 );
X_inventory_location_id number;
X_locator_exists varchar2 (100 );
Begin
Begin
Fnd_global.apps_initialize (user_id => 1192,
Resp_id => 51519,
Resp_appl_id = & gt; 211 );
Fnd_profile.put ('mfg _ organization_id ', 111 );
End;
Inv_loc_wms_pub.create_locator (x_return_status => x_return_status,
X_msg_count => x_msg_count,
X_msg_data => x_msg_data,
X_inventory_location_id => x_inventory_location_id,
X_locator_exists => x_locator_exists,
P_organization_id => 111,
P_organization_code => 't01 ',
P_concatenated_segments => '. 1995. pj_test_01.1 ..',
P_description => null,
P_inventory_location_type => 3,
P_picking_order => null,
P_location_maximum_units => null,
P_subinventory_code => '123 ',
P_location_weight_uom_code => null,
P_max_weight => null,
P_volume_uom_code => null,
P_max_cubic_area => null,
P_x_coordinate => null,
P_y_coordinate => null,
P_z_coordinate => null,
P_physical_location_id => null,
P_pick_uom_code => null,
P_dimension_uom_code => null,
P_length => null,
P_width => null,
P_height => null,
P_status_id => 1,
P_dropping_order => null );

Commit;
End;