eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CONTAINER_PUB dependencies on FND_API

Line 35: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

31:
32: PROCEDURE Create_Containers (
33: -- Standard parameters
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,

Line 36: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

32: PROCEDURE Create_Containers (
33: -- Standard parameters
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,

Line 37: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

33: -- Standard parameters
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41:

Line 126: IF NOT FND_API.compatible_api_call (

122: p_ucc_128_suffix_flag);
123: END IF;
124:
125:
126: IF NOT FND_API.compatible_api_call (
127: l_api_version,
128: p_api_version,
129: l_api_name,
130: G_PKG_NAME) THEN

Line 131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

127: l_api_version,
128: p_api_version,
129: l_api_name,
130: G_PKG_NAME) THEN
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133:
134: -- Check p_init_msg_list
135: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 135: IF FND_API.to_boolean(p_init_msg_list) THEN

131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133:
134: -- Check p_init_msg_list
135: IF FND_API.to_boolean(p_init_msg_list) THEN
136: FND_MSG_PUB.initialize;
137: END IF;
138:
139: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 167: p_init_msg_list => FND_API.G_FALSE,

163: l_detail_rec.lpn_ids := l_lpn_ids;
164:
165: wsh_interface_grp.Create_Update_Delivery_Detail(
166: p_api_version_number => 1.0,
167: p_init_msg_list => FND_API.G_FALSE,
168: p_commit => FND_API.G_FALSE,
169: x_return_status => x_return_status,
170: x_msg_count => x_msg_count,
171: x_msg_data => x_msg_data,

Line 168: p_commit => FND_API.G_FALSE,

164:
165: wsh_interface_grp.Create_Update_Delivery_Detail(
166: p_api_version_number => 1.0,
167: p_init_msg_list => FND_API.G_FALSE,
168: p_commit => FND_API.G_FALSE,
169: x_return_status => x_return_status,
170: x_msg_count => x_msg_count,
171: x_msg_data => x_msg_data,
172: p_detail_info_tab => l_detail_tab,

Line 192: IF FND_API.TO_BOOLEAN(p_commit) THEN

188: IF l_out_rec.detail_ids.COUNT > 0 THEN
189: x_container_ids := l_out_rec.detail_ids;
190: END IF;
191:
192: IF FND_API.TO_BOOLEAN(p_commit) THEN
193: -- dbms_output.put_line('commit');
194: COMMIT;
195: END IF;
196:

Line 202: p_encoded => FND_API.G_FALSE

198: FND_MSG_PUB.Count_And_Get
199: (
200: p_count => x_msg_count,
201: p_data => x_msg_data,
202: p_encoded => FND_API.G_FALSE
203: );
204: --
205:
206: IF l_debug_on THEN

Line 222: p_encoded => FND_API.G_FALSE

218: FND_MSG_PUB.Count_And_Get
219: (
220: p_count => x_msg_count,
221: p_data => x_msg_data,
222: p_encoded => FND_API.G_FALSE
223: );
224: --
225: IF l_debug_on THEN
226: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_QTY');

Line 239: p_encoded => FND_API.G_FALSE

235: FND_MSG_PUB.Count_And_Get
236: (
237: p_count => x_msg_count,
238: p_data => x_msg_data,
239: p_encoded => FND_API.G_FALSE
240: );
241: --
242: IF l_debug_on THEN
243: WSH_DEBUG_SV.pop(l_module_name,

Line 257: p_encoded => FND_API.G_FALSE

253: FND_MSG_PUB.Count_And_Get
254: (
255: p_count => x_msg_count,
256: p_data => x_msg_data,
257: p_encoded => FND_API.G_FALSE
258: );
259: --
260: IF l_debug_on THEN
261: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 295: p_outrec.source_code := FND_API.G_MISS_CHAR;

291: IF l_debug_on THEN
292: WSH_DEBUG_SV.push(l_module_name);
293: END IF;
294: p_outrec.delivery_detail_id := p_in_rec.delivery_detail_id;
295: p_outrec.source_code := FND_API.G_MISS_CHAR;
296: p_outrec.source_header_id := p_in_rec.source_header_id;
297: p_outrec.source_line_id := p_in_rec.source_line_id;
298: p_outrec.customer_id := FND_API.G_MISS_NUM;
299: p_outrec.sold_to_contact_id := p_in_rec.sold_to_contact_id;

Line 298: p_outrec.customer_id := FND_API.G_MISS_NUM;

294: p_outrec.delivery_detail_id := p_in_rec.delivery_detail_id;
295: p_outrec.source_code := FND_API.G_MISS_CHAR;
296: p_outrec.source_header_id := p_in_rec.source_header_id;
297: p_outrec.source_line_id := p_in_rec.source_line_id;
298: p_outrec.customer_id := FND_API.G_MISS_NUM;
299: p_outrec.sold_to_contact_id := p_in_rec.sold_to_contact_id;
300: p_outrec.inventory_item_id := FND_API.G_MISS_NUM;
301: p_outrec.item_description := FND_API.G_MISS_CHAR;
302: p_outrec.hazard_class_id := FND_API.G_MISS_NUM;

Line 300: p_outrec.inventory_item_id := FND_API.G_MISS_NUM;

296: p_outrec.source_header_id := p_in_rec.source_header_id;
297: p_outrec.source_line_id := p_in_rec.source_line_id;
298: p_outrec.customer_id := FND_API.G_MISS_NUM;
299: p_outrec.sold_to_contact_id := p_in_rec.sold_to_contact_id;
300: p_outrec.inventory_item_id := FND_API.G_MISS_NUM;
301: p_outrec.item_description := FND_API.G_MISS_CHAR;
302: p_outrec.hazard_class_id := FND_API.G_MISS_NUM;
303: p_outrec.country_of_origin := FND_API.G_MISS_CHAR;
304: p_outrec.classification := FND_API.G_MISS_CHAR;

Line 301: p_outrec.item_description := FND_API.G_MISS_CHAR;

297: p_outrec.source_line_id := p_in_rec.source_line_id;
298: p_outrec.customer_id := FND_API.G_MISS_NUM;
299: p_outrec.sold_to_contact_id := p_in_rec.sold_to_contact_id;
300: p_outrec.inventory_item_id := FND_API.G_MISS_NUM;
301: p_outrec.item_description := FND_API.G_MISS_CHAR;
302: p_outrec.hazard_class_id := FND_API.G_MISS_NUM;
303: p_outrec.country_of_origin := FND_API.G_MISS_CHAR;
304: p_outrec.classification := FND_API.G_MISS_CHAR;
305: p_outrec.ship_from_location_id := FND_API.G_MISS_NUM;

Line 302: p_outrec.hazard_class_id := FND_API.G_MISS_NUM;

298: p_outrec.customer_id := FND_API.G_MISS_NUM;
299: p_outrec.sold_to_contact_id := p_in_rec.sold_to_contact_id;
300: p_outrec.inventory_item_id := FND_API.G_MISS_NUM;
301: p_outrec.item_description := FND_API.G_MISS_CHAR;
302: p_outrec.hazard_class_id := FND_API.G_MISS_NUM;
303: p_outrec.country_of_origin := FND_API.G_MISS_CHAR;
304: p_outrec.classification := FND_API.G_MISS_CHAR;
305: p_outrec.ship_from_location_id := FND_API.G_MISS_NUM;
306: p_outrec.ship_to_location_id := FND_API.G_MISS_NUM;

Line 303: p_outrec.country_of_origin := FND_API.G_MISS_CHAR;

299: p_outrec.sold_to_contact_id := p_in_rec.sold_to_contact_id;
300: p_outrec.inventory_item_id := FND_API.G_MISS_NUM;
301: p_outrec.item_description := FND_API.G_MISS_CHAR;
302: p_outrec.hazard_class_id := FND_API.G_MISS_NUM;
303: p_outrec.country_of_origin := FND_API.G_MISS_CHAR;
304: p_outrec.classification := FND_API.G_MISS_CHAR;
305: p_outrec.ship_from_location_id := FND_API.G_MISS_NUM;
306: p_outrec.ship_to_location_id := FND_API.G_MISS_NUM;
307: p_outrec.ship_to_contact_id := p_in_rec.ship_to_contact_id;

Line 304: p_outrec.classification := FND_API.G_MISS_CHAR;

300: p_outrec.inventory_item_id := FND_API.G_MISS_NUM;
301: p_outrec.item_description := FND_API.G_MISS_CHAR;
302: p_outrec.hazard_class_id := FND_API.G_MISS_NUM;
303: p_outrec.country_of_origin := FND_API.G_MISS_CHAR;
304: p_outrec.classification := FND_API.G_MISS_CHAR;
305: p_outrec.ship_from_location_id := FND_API.G_MISS_NUM;
306: p_outrec.ship_to_location_id := FND_API.G_MISS_NUM;
307: p_outrec.ship_to_contact_id := p_in_rec.ship_to_contact_id;
308: p_outrec.ship_to_site_use_id := FND_API.G_MISS_NUM;

Line 305: p_outrec.ship_from_location_id := FND_API.G_MISS_NUM;

301: p_outrec.item_description := FND_API.G_MISS_CHAR;
302: p_outrec.hazard_class_id := FND_API.G_MISS_NUM;
303: p_outrec.country_of_origin := FND_API.G_MISS_CHAR;
304: p_outrec.classification := FND_API.G_MISS_CHAR;
305: p_outrec.ship_from_location_id := FND_API.G_MISS_NUM;
306: p_outrec.ship_to_location_id := FND_API.G_MISS_NUM;
307: p_outrec.ship_to_contact_id := p_in_rec.ship_to_contact_id;
308: p_outrec.ship_to_site_use_id := FND_API.G_MISS_NUM;
309: p_outrec.deliver_to_location_id := FND_API.G_MISS_NUM;

Line 306: p_outrec.ship_to_location_id := FND_API.G_MISS_NUM;

302: p_outrec.hazard_class_id := FND_API.G_MISS_NUM;
303: p_outrec.country_of_origin := FND_API.G_MISS_CHAR;
304: p_outrec.classification := FND_API.G_MISS_CHAR;
305: p_outrec.ship_from_location_id := FND_API.G_MISS_NUM;
306: p_outrec.ship_to_location_id := FND_API.G_MISS_NUM;
307: p_outrec.ship_to_contact_id := p_in_rec.ship_to_contact_id;
308: p_outrec.ship_to_site_use_id := FND_API.G_MISS_NUM;
309: p_outrec.deliver_to_location_id := FND_API.G_MISS_NUM;
310: p_outrec.deliver_to_contact_id := p_in_rec.deliver_to_contact_id;

Line 308: p_outrec.ship_to_site_use_id := FND_API.G_MISS_NUM;

304: p_outrec.classification := FND_API.G_MISS_CHAR;
305: p_outrec.ship_from_location_id := FND_API.G_MISS_NUM;
306: p_outrec.ship_to_location_id := FND_API.G_MISS_NUM;
307: p_outrec.ship_to_contact_id := p_in_rec.ship_to_contact_id;
308: p_outrec.ship_to_site_use_id := FND_API.G_MISS_NUM;
309: p_outrec.deliver_to_location_id := FND_API.G_MISS_NUM;
310: p_outrec.deliver_to_contact_id := p_in_rec.deliver_to_contact_id;
311: p_outrec.deliver_to_site_use_id := FND_API.G_MISS_NUM;
312: p_outrec.intmed_ship_to_location_id := FND_API.G_MISS_NUM;

Line 309: p_outrec.deliver_to_location_id := FND_API.G_MISS_NUM;

305: p_outrec.ship_from_location_id := FND_API.G_MISS_NUM;
306: p_outrec.ship_to_location_id := FND_API.G_MISS_NUM;
307: p_outrec.ship_to_contact_id := p_in_rec.ship_to_contact_id;
308: p_outrec.ship_to_site_use_id := FND_API.G_MISS_NUM;
309: p_outrec.deliver_to_location_id := FND_API.G_MISS_NUM;
310: p_outrec.deliver_to_contact_id := p_in_rec.deliver_to_contact_id;
311: p_outrec.deliver_to_site_use_id := FND_API.G_MISS_NUM;
312: p_outrec.intmed_ship_to_location_id := FND_API.G_MISS_NUM;
313: p_outrec.intmed_ship_to_contact_id := p_in_rec.intmed_ship_to_contact_id;

Line 311: p_outrec.deliver_to_site_use_id := FND_API.G_MISS_NUM;

307: p_outrec.ship_to_contact_id := p_in_rec.ship_to_contact_id;
308: p_outrec.ship_to_site_use_id := FND_API.G_MISS_NUM;
309: p_outrec.deliver_to_location_id := FND_API.G_MISS_NUM;
310: p_outrec.deliver_to_contact_id := p_in_rec.deliver_to_contact_id;
311: p_outrec.deliver_to_site_use_id := FND_API.G_MISS_NUM;
312: p_outrec.intmed_ship_to_location_id := FND_API.G_MISS_NUM;
313: p_outrec.intmed_ship_to_contact_id := p_in_rec.intmed_ship_to_contact_id;
314: p_outrec.hold_code := FND_API.G_MISS_CHAR;
315: p_outrec.ship_tolerance_above := p_in_rec.ship_tolerance_above;

Line 312: p_outrec.intmed_ship_to_location_id := FND_API.G_MISS_NUM;

308: p_outrec.ship_to_site_use_id := FND_API.G_MISS_NUM;
309: p_outrec.deliver_to_location_id := FND_API.G_MISS_NUM;
310: p_outrec.deliver_to_contact_id := p_in_rec.deliver_to_contact_id;
311: p_outrec.deliver_to_site_use_id := FND_API.G_MISS_NUM;
312: p_outrec.intmed_ship_to_location_id := FND_API.G_MISS_NUM;
313: p_outrec.intmed_ship_to_contact_id := p_in_rec.intmed_ship_to_contact_id;
314: p_outrec.hold_code := FND_API.G_MISS_CHAR;
315: p_outrec.ship_tolerance_above := p_in_rec.ship_tolerance_above;
316: p_outrec.ship_tolerance_below := p_in_rec.ship_tolerance_below;

Line 314: p_outrec.hold_code := FND_API.G_MISS_CHAR;

310: p_outrec.deliver_to_contact_id := p_in_rec.deliver_to_contact_id;
311: p_outrec.deliver_to_site_use_id := FND_API.G_MISS_NUM;
312: p_outrec.intmed_ship_to_location_id := FND_API.G_MISS_NUM;
313: p_outrec.intmed_ship_to_contact_id := p_in_rec.intmed_ship_to_contact_id;
314: p_outrec.hold_code := FND_API.G_MISS_CHAR;
315: p_outrec.ship_tolerance_above := p_in_rec.ship_tolerance_above;
316: p_outrec.ship_tolerance_below := p_in_rec.ship_tolerance_below;
317: p_outrec.requested_quantity := FND_API.G_MISS_NUM;
318: p_outrec.shipped_quantity := p_in_rec.shipped_quantity;

Line 317: p_outrec.requested_quantity := FND_API.G_MISS_NUM;

313: p_outrec.intmed_ship_to_contact_id := p_in_rec.intmed_ship_to_contact_id;
314: p_outrec.hold_code := FND_API.G_MISS_CHAR;
315: p_outrec.ship_tolerance_above := p_in_rec.ship_tolerance_above;
316: p_outrec.ship_tolerance_below := p_in_rec.ship_tolerance_below;
317: p_outrec.requested_quantity := FND_API.G_MISS_NUM;
318: p_outrec.shipped_quantity := p_in_rec.shipped_quantity;
319: p_outrec.delivered_quantity := FND_API.G_MISS_NUM;
320: p_outrec.requested_quantity_uom := FND_API.G_MISS_CHAR;
321: p_outrec.subinventory := p_in_rec.subinventory;

Line 319: p_outrec.delivered_quantity := FND_API.G_MISS_NUM;

315: p_outrec.ship_tolerance_above := p_in_rec.ship_tolerance_above;
316: p_outrec.ship_tolerance_below := p_in_rec.ship_tolerance_below;
317: p_outrec.requested_quantity := FND_API.G_MISS_NUM;
318: p_outrec.shipped_quantity := p_in_rec.shipped_quantity;
319: p_outrec.delivered_quantity := FND_API.G_MISS_NUM;
320: p_outrec.requested_quantity_uom := FND_API.G_MISS_CHAR;
321: p_outrec.subinventory := p_in_rec.subinventory;
322: p_outrec.revision := p_in_rec.revision;
323: p_outrec.lot_number := p_in_rec.lot_number;

Line 320: p_outrec.requested_quantity_uom := FND_API.G_MISS_CHAR;

316: p_outrec.ship_tolerance_below := p_in_rec.ship_tolerance_below;
317: p_outrec.requested_quantity := FND_API.G_MISS_NUM;
318: p_outrec.shipped_quantity := p_in_rec.shipped_quantity;
319: p_outrec.delivered_quantity := FND_API.G_MISS_NUM;
320: p_outrec.requested_quantity_uom := FND_API.G_MISS_CHAR;
321: p_outrec.subinventory := p_in_rec.subinventory;
322: p_outrec.revision := p_in_rec.revision;
323: p_outrec.lot_number := p_in_rec.lot_number;
324: p_outrec.customer_requested_lot_flag := p_in_rec.customer_requested_lot_flag;

Line 331: p_outrec.load_seq_number := FND_API.G_MISS_NUM;

327: p_outrec.date_requested := p_in_rec.date_requested;
328: p_outrec.date_scheduled := p_in_rec.date_scheduled;
329: p_outrec.master_container_item_id := p_in_rec.master_container_item_id;
330: p_outrec.detail_container_item_id := p_in_rec.detail_container_item_id;
331: p_outrec.load_seq_number := FND_API.G_MISS_NUM;
332: p_outrec.ship_method_code := FND_API.G_MISS_CHAR;
333: p_outrec.carrier_id := p_in_rec.carrier_id;
334: p_outrec.freight_terms_code := p_in_rec.freight_terms_code;
335: p_outrec.shipment_priority_code := p_in_rec.shipment_priority_code;

Line 332: p_outrec.ship_method_code := FND_API.G_MISS_CHAR;

328: p_outrec.date_scheduled := p_in_rec.date_scheduled;
329: p_outrec.master_container_item_id := p_in_rec.master_container_item_id;
330: p_outrec.detail_container_item_id := p_in_rec.detail_container_item_id;
331: p_outrec.load_seq_number := FND_API.G_MISS_NUM;
332: p_outrec.ship_method_code := FND_API.G_MISS_CHAR;
333: p_outrec.carrier_id := p_in_rec.carrier_id;
334: p_outrec.freight_terms_code := p_in_rec.freight_terms_code;
335: p_outrec.shipment_priority_code := p_in_rec.shipment_priority_code;
336: p_outrec.fob_code := p_in_rec.fob_code;

Line 337: p_outrec.customer_item_id := FND_API.G_MISS_NUM;

333: p_outrec.carrier_id := p_in_rec.carrier_id;
334: p_outrec.freight_terms_code := p_in_rec.freight_terms_code;
335: p_outrec.shipment_priority_code := p_in_rec.shipment_priority_code;
336: p_outrec.fob_code := p_in_rec.fob_code;
337: p_outrec.customer_item_id := FND_API.G_MISS_NUM;
338: p_outrec.dep_plan_required_flag := p_in_rec.dep_plan_required_flag;
339: p_outrec.customer_prod_seq := p_in_rec.customer_prod_seq;
340: p_outrec.customer_dock_code := p_in_rec.customer_dock_code;
341: p_outrec.cust_model_serial_number := FND_API.G_MISS_CHAR;

Line 341: p_outrec.cust_model_serial_number := FND_API.G_MISS_CHAR;

337: p_outrec.customer_item_id := FND_API.G_MISS_NUM;
338: p_outrec.dep_plan_required_flag := p_in_rec.dep_plan_required_flag;
339: p_outrec.customer_prod_seq := p_in_rec.customer_prod_seq;
340: p_outrec.customer_dock_code := p_in_rec.customer_dock_code;
341: p_outrec.cust_model_serial_number := FND_API.G_MISS_CHAR;
342: p_outrec.customer_job := FND_API.G_MISS_CHAR;
343: p_outrec.customer_production_line := FND_API.G_MISS_CHAR;
344: p_outrec.net_weight := p_in_rec.net_weight;
345: p_outrec.weight_uom_code := p_in_rec.weight_uom_code;

Line 342: p_outrec.customer_job := FND_API.G_MISS_CHAR;

338: p_outrec.dep_plan_required_flag := p_in_rec.dep_plan_required_flag;
339: p_outrec.customer_prod_seq := p_in_rec.customer_prod_seq;
340: p_outrec.customer_dock_code := p_in_rec.customer_dock_code;
341: p_outrec.cust_model_serial_number := FND_API.G_MISS_CHAR;
342: p_outrec.customer_job := FND_API.G_MISS_CHAR;
343: p_outrec.customer_production_line := FND_API.G_MISS_CHAR;
344: p_outrec.net_weight := p_in_rec.net_weight;
345: p_outrec.weight_uom_code := p_in_rec.weight_uom_code;
346: p_outrec.volume := p_in_rec.volume;

Line 343: p_outrec.customer_production_line := FND_API.G_MISS_CHAR;

339: p_outrec.customer_prod_seq := p_in_rec.customer_prod_seq;
340: p_outrec.customer_dock_code := p_in_rec.customer_dock_code;
341: p_outrec.cust_model_serial_number := FND_API.G_MISS_CHAR;
342: p_outrec.customer_job := FND_API.G_MISS_CHAR;
343: p_outrec.customer_production_line := FND_API.G_MISS_CHAR;
344: p_outrec.net_weight := p_in_rec.net_weight;
345: p_outrec.weight_uom_code := p_in_rec.weight_uom_code;
346: p_outrec.volume := p_in_rec.volume;
347: -- J: W/V Changes

Line 367: p_outrec.attribute_category := FND_API.G_MISS_CHAR;

363: p_outrec.tp_attribute12 := p_in_rec.tp_attribute12;
364: p_outrec.tp_attribute13 := p_in_rec.tp_attribute13;
365: p_outrec.tp_attribute14 := p_in_rec.tp_attribute14;
366: p_outrec.tp_attribute15 := p_in_rec.tp_attribute15;
367: p_outrec.attribute_category := FND_API.G_MISS_CHAR;
368: p_outrec.attribute1 := p_in_rec.attribute1;
369: p_outrec.attribute2 := p_in_rec.attribute2;
370: p_outrec.attribute3 := p_in_rec.attribute3;
371: p_outrec.attribute4 := p_in_rec.attribute4;

Line 383: p_outrec.created_by := FND_API.G_MISS_NUM;

379: p_outrec.attribute12 := p_in_rec.attribute12;
380: p_outrec.attribute13 := p_in_rec.attribute13;
381: p_outrec.attribute14 := p_in_rec.attribute14;
382: p_outrec.attribute15 := p_in_rec.attribute15;
383: p_outrec.created_by := FND_API.G_MISS_NUM;
384: p_outrec.creation_date := FND_API.G_MISS_DATE;
385: p_outrec.last_update_date := FND_API.G_MISS_DATE;
386: p_outrec.last_update_login := FND_API.G_MISS_NUM;
387: p_outrec.last_updated_by := FND_API.G_MISS_NUM;

Line 384: p_outrec.creation_date := FND_API.G_MISS_DATE;

380: p_outrec.attribute13 := p_in_rec.attribute13;
381: p_outrec.attribute14 := p_in_rec.attribute14;
382: p_outrec.attribute15 := p_in_rec.attribute15;
383: p_outrec.created_by := FND_API.G_MISS_NUM;
384: p_outrec.creation_date := FND_API.G_MISS_DATE;
385: p_outrec.last_update_date := FND_API.G_MISS_DATE;
386: p_outrec.last_update_login := FND_API.G_MISS_NUM;
387: p_outrec.last_updated_by := FND_API.G_MISS_NUM;
388: p_outrec.program_application_id := FND_API.G_MISS_NUM;

Line 385: p_outrec.last_update_date := FND_API.G_MISS_DATE;

381: p_outrec.attribute14 := p_in_rec.attribute14;
382: p_outrec.attribute15 := p_in_rec.attribute15;
383: p_outrec.created_by := FND_API.G_MISS_NUM;
384: p_outrec.creation_date := FND_API.G_MISS_DATE;
385: p_outrec.last_update_date := FND_API.G_MISS_DATE;
386: p_outrec.last_update_login := FND_API.G_MISS_NUM;
387: p_outrec.last_updated_by := FND_API.G_MISS_NUM;
388: p_outrec.program_application_id := FND_API.G_MISS_NUM;
389: p_outrec.program_id := FND_API.G_MISS_NUM;

Line 386: p_outrec.last_update_login := FND_API.G_MISS_NUM;

382: p_outrec.attribute15 := p_in_rec.attribute15;
383: p_outrec.created_by := FND_API.G_MISS_NUM;
384: p_outrec.creation_date := FND_API.G_MISS_DATE;
385: p_outrec.last_update_date := FND_API.G_MISS_DATE;
386: p_outrec.last_update_login := FND_API.G_MISS_NUM;
387: p_outrec.last_updated_by := FND_API.G_MISS_NUM;
388: p_outrec.program_application_id := FND_API.G_MISS_NUM;
389: p_outrec.program_id := FND_API.G_MISS_NUM;
390: p_outrec.program_update_date := FND_API.G_MISS_DATE;

Line 387: p_outrec.last_updated_by := FND_API.G_MISS_NUM;

383: p_outrec.created_by := FND_API.G_MISS_NUM;
384: p_outrec.creation_date := FND_API.G_MISS_DATE;
385: p_outrec.last_update_date := FND_API.G_MISS_DATE;
386: p_outrec.last_update_login := FND_API.G_MISS_NUM;
387: p_outrec.last_updated_by := FND_API.G_MISS_NUM;
388: p_outrec.program_application_id := FND_API.G_MISS_NUM;
389: p_outrec.program_id := FND_API.G_MISS_NUM;
390: p_outrec.program_update_date := FND_API.G_MISS_DATE;
391: p_outrec.request_id := FND_API.G_MISS_NUM;

Line 388: p_outrec.program_application_id := FND_API.G_MISS_NUM;

384: p_outrec.creation_date := FND_API.G_MISS_DATE;
385: p_outrec.last_update_date := FND_API.G_MISS_DATE;
386: p_outrec.last_update_login := FND_API.G_MISS_NUM;
387: p_outrec.last_updated_by := FND_API.G_MISS_NUM;
388: p_outrec.program_application_id := FND_API.G_MISS_NUM;
389: p_outrec.program_id := FND_API.G_MISS_NUM;
390: p_outrec.program_update_date := FND_API.G_MISS_DATE;
391: p_outrec.request_id := FND_API.G_MISS_NUM;
392: p_outrec.mvt_stat_status := FND_API.G_MISS_CHAR;

Line 389: p_outrec.program_id := FND_API.G_MISS_NUM;

385: p_outrec.last_update_date := FND_API.G_MISS_DATE;
386: p_outrec.last_update_login := FND_API.G_MISS_NUM;
387: p_outrec.last_updated_by := FND_API.G_MISS_NUM;
388: p_outrec.program_application_id := FND_API.G_MISS_NUM;
389: p_outrec.program_id := FND_API.G_MISS_NUM;
390: p_outrec.program_update_date := FND_API.G_MISS_DATE;
391: p_outrec.request_id := FND_API.G_MISS_NUM;
392: p_outrec.mvt_stat_status := FND_API.G_MISS_CHAR;
393: p_outrec.released_flag := FND_API.G_MISS_CHAR;

Line 390: p_outrec.program_update_date := FND_API.G_MISS_DATE;

386: p_outrec.last_update_login := FND_API.G_MISS_NUM;
387: p_outrec.last_updated_by := FND_API.G_MISS_NUM;
388: p_outrec.program_application_id := FND_API.G_MISS_NUM;
389: p_outrec.program_id := FND_API.G_MISS_NUM;
390: p_outrec.program_update_date := FND_API.G_MISS_DATE;
391: p_outrec.request_id := FND_API.G_MISS_NUM;
392: p_outrec.mvt_stat_status := FND_API.G_MISS_CHAR;
393: p_outrec.released_flag := FND_API.G_MISS_CHAR;
394: p_outrec.organization_id := FND_API.G_MISS_NUM;

Line 391: p_outrec.request_id := FND_API.G_MISS_NUM;

387: p_outrec.last_updated_by := FND_API.G_MISS_NUM;
388: p_outrec.program_application_id := FND_API.G_MISS_NUM;
389: p_outrec.program_id := FND_API.G_MISS_NUM;
390: p_outrec.program_update_date := FND_API.G_MISS_DATE;
391: p_outrec.request_id := FND_API.G_MISS_NUM;
392: p_outrec.mvt_stat_status := FND_API.G_MISS_CHAR;
393: p_outrec.released_flag := FND_API.G_MISS_CHAR;
394: p_outrec.organization_id := FND_API.G_MISS_NUM;
395: p_outrec.transaction_temp_id := FND_API.G_MISS_NUM;

Line 392: p_outrec.mvt_stat_status := FND_API.G_MISS_CHAR;

388: p_outrec.program_application_id := FND_API.G_MISS_NUM;
389: p_outrec.program_id := FND_API.G_MISS_NUM;
390: p_outrec.program_update_date := FND_API.G_MISS_DATE;
391: p_outrec.request_id := FND_API.G_MISS_NUM;
392: p_outrec.mvt_stat_status := FND_API.G_MISS_CHAR;
393: p_outrec.released_flag := FND_API.G_MISS_CHAR;
394: p_outrec.organization_id := FND_API.G_MISS_NUM;
395: p_outrec.transaction_temp_id := FND_API.G_MISS_NUM;
396: p_outrec.ship_set_id := p_in_rec.ship_set_id;

Line 393: p_outrec.released_flag := FND_API.G_MISS_CHAR;

389: p_outrec.program_id := FND_API.G_MISS_NUM;
390: p_outrec.program_update_date := FND_API.G_MISS_DATE;
391: p_outrec.request_id := FND_API.G_MISS_NUM;
392: p_outrec.mvt_stat_status := FND_API.G_MISS_CHAR;
393: p_outrec.released_flag := FND_API.G_MISS_CHAR;
394: p_outrec.organization_id := FND_API.G_MISS_NUM;
395: p_outrec.transaction_temp_id := FND_API.G_MISS_NUM;
396: p_outrec.ship_set_id := p_in_rec.ship_set_id;
397: p_outrec.arrival_set_id := p_in_rec.arrival_set_id;

Line 394: p_outrec.organization_id := FND_API.G_MISS_NUM;

390: p_outrec.program_update_date := FND_API.G_MISS_DATE;
391: p_outrec.request_id := FND_API.G_MISS_NUM;
392: p_outrec.mvt_stat_status := FND_API.G_MISS_CHAR;
393: p_outrec.released_flag := FND_API.G_MISS_CHAR;
394: p_outrec.organization_id := FND_API.G_MISS_NUM;
395: p_outrec.transaction_temp_id := FND_API.G_MISS_NUM;
396: p_outrec.ship_set_id := p_in_rec.ship_set_id;
397: p_outrec.arrival_set_id := p_in_rec.arrival_set_id;
398: p_outrec.ship_model_complete_flag := p_in_rec.ship_model_complete_flag;

Line 395: p_outrec.transaction_temp_id := FND_API.G_MISS_NUM;

391: p_outrec.request_id := FND_API.G_MISS_NUM;
392: p_outrec.mvt_stat_status := FND_API.G_MISS_CHAR;
393: p_outrec.released_flag := FND_API.G_MISS_CHAR;
394: p_outrec.organization_id := FND_API.G_MISS_NUM;
395: p_outrec.transaction_temp_id := FND_API.G_MISS_NUM;
396: p_outrec.ship_set_id := p_in_rec.ship_set_id;
397: p_outrec.arrival_set_id := p_in_rec.arrival_set_id;
398: p_outrec.ship_model_complete_flag := p_in_rec.ship_model_complete_flag;
399: p_outrec.top_model_line_id := p_in_rec.top_model_line_id;

Line 400: p_outrec.source_header_number := FND_API.G_MISS_CHAR;

396: p_outrec.ship_set_id := p_in_rec.ship_set_id;
397: p_outrec.arrival_set_id := p_in_rec.arrival_set_id;
398: p_outrec.ship_model_complete_flag := p_in_rec.ship_model_complete_flag;
399: p_outrec.top_model_line_id := p_in_rec.top_model_line_id;
400: p_outrec.source_header_number := FND_API.G_MISS_CHAR;
401: p_outrec.source_header_type_id := FND_API.G_MISS_NUM;
402: p_outrec.source_header_type_name := FND_API.G_MISS_CHAR;
403: p_outrec.cust_po_number := p_in_rec.cust_po_number;
404: p_outrec.ato_line_id := p_in_rec.ato_line_id;

Line 401: p_outrec.source_header_type_id := FND_API.G_MISS_NUM;

397: p_outrec.arrival_set_id := p_in_rec.arrival_set_id;
398: p_outrec.ship_model_complete_flag := p_in_rec.ship_model_complete_flag;
399: p_outrec.top_model_line_id := p_in_rec.top_model_line_id;
400: p_outrec.source_header_number := FND_API.G_MISS_CHAR;
401: p_outrec.source_header_type_id := FND_API.G_MISS_NUM;
402: p_outrec.source_header_type_name := FND_API.G_MISS_CHAR;
403: p_outrec.cust_po_number := p_in_rec.cust_po_number;
404: p_outrec.ato_line_id := p_in_rec.ato_line_id;
405: p_outrec.src_requested_quantity := FND_API.G_MISS_NUM;

Line 402: p_outrec.source_header_type_name := FND_API.G_MISS_CHAR;

398: p_outrec.ship_model_complete_flag := p_in_rec.ship_model_complete_flag;
399: p_outrec.top_model_line_id := p_in_rec.top_model_line_id;
400: p_outrec.source_header_number := FND_API.G_MISS_CHAR;
401: p_outrec.source_header_type_id := FND_API.G_MISS_NUM;
402: p_outrec.source_header_type_name := FND_API.G_MISS_CHAR;
403: p_outrec.cust_po_number := p_in_rec.cust_po_number;
404: p_outrec.ato_line_id := p_in_rec.ato_line_id;
405: p_outrec.src_requested_quantity := FND_API.G_MISS_NUM;
406: p_outrec.src_requested_quantity_uom := FND_API.G_MISS_CHAR;

Line 405: p_outrec.src_requested_quantity := FND_API.G_MISS_NUM;

401: p_outrec.source_header_type_id := FND_API.G_MISS_NUM;
402: p_outrec.source_header_type_name := FND_API.G_MISS_CHAR;
403: p_outrec.cust_po_number := p_in_rec.cust_po_number;
404: p_outrec.ato_line_id := p_in_rec.ato_line_id;
405: p_outrec.src_requested_quantity := FND_API.G_MISS_NUM;
406: p_outrec.src_requested_quantity_uom := FND_API.G_MISS_CHAR;
407: p_outrec.move_order_line_id := FND_API.G_MISS_NUM;
408: p_outrec.cancelled_quantity := FND_API.G_MISS_NUM;
409: p_outrec.quality_control_quantity := FND_API.G_MISS_NUM;

Line 406: p_outrec.src_requested_quantity_uom := FND_API.G_MISS_CHAR;

402: p_outrec.source_header_type_name := FND_API.G_MISS_CHAR;
403: p_outrec.cust_po_number := p_in_rec.cust_po_number;
404: p_outrec.ato_line_id := p_in_rec.ato_line_id;
405: p_outrec.src_requested_quantity := FND_API.G_MISS_NUM;
406: p_outrec.src_requested_quantity_uom := FND_API.G_MISS_CHAR;
407: p_outrec.move_order_line_id := FND_API.G_MISS_NUM;
408: p_outrec.cancelled_quantity := FND_API.G_MISS_NUM;
409: p_outrec.quality_control_quantity := FND_API.G_MISS_NUM;
410: p_outrec.cycle_count_quantity := p_in_rec.cycle_count_quantity;

Line 407: p_outrec.move_order_line_id := FND_API.G_MISS_NUM;

403: p_outrec.cust_po_number := p_in_rec.cust_po_number;
404: p_outrec.ato_line_id := p_in_rec.ato_line_id;
405: p_outrec.src_requested_quantity := FND_API.G_MISS_NUM;
406: p_outrec.src_requested_quantity_uom := FND_API.G_MISS_CHAR;
407: p_outrec.move_order_line_id := FND_API.G_MISS_NUM;
408: p_outrec.cancelled_quantity := FND_API.G_MISS_NUM;
409: p_outrec.quality_control_quantity := FND_API.G_MISS_NUM;
410: p_outrec.cycle_count_quantity := p_in_rec.cycle_count_quantity;
411: p_outrec.tracking_number := p_in_rec.tracking_number;

Line 408: p_outrec.cancelled_quantity := FND_API.G_MISS_NUM;

404: p_outrec.ato_line_id := p_in_rec.ato_line_id;
405: p_outrec.src_requested_quantity := FND_API.G_MISS_NUM;
406: p_outrec.src_requested_quantity_uom := FND_API.G_MISS_CHAR;
407: p_outrec.move_order_line_id := FND_API.G_MISS_NUM;
408: p_outrec.cancelled_quantity := FND_API.G_MISS_NUM;
409: p_outrec.quality_control_quantity := FND_API.G_MISS_NUM;
410: p_outrec.cycle_count_quantity := p_in_rec.cycle_count_quantity;
411: p_outrec.tracking_number := p_in_rec.tracking_number;
412: p_outrec.movement_id := FND_API.G_MISS_NUM;

Line 409: p_outrec.quality_control_quantity := FND_API.G_MISS_NUM;

405: p_outrec.src_requested_quantity := FND_API.G_MISS_NUM;
406: p_outrec.src_requested_quantity_uom := FND_API.G_MISS_CHAR;
407: p_outrec.move_order_line_id := FND_API.G_MISS_NUM;
408: p_outrec.cancelled_quantity := FND_API.G_MISS_NUM;
409: p_outrec.quality_control_quantity := FND_API.G_MISS_NUM;
410: p_outrec.cycle_count_quantity := p_in_rec.cycle_count_quantity;
411: p_outrec.tracking_number := p_in_rec.tracking_number;
412: p_outrec.movement_id := FND_API.G_MISS_NUM;
413: p_outrec.shipping_instructions := p_in_rec.shipping_instructions;

Line 412: p_outrec.movement_id := FND_API.G_MISS_NUM;

408: p_outrec.cancelled_quantity := FND_API.G_MISS_NUM;
409: p_outrec.quality_control_quantity := FND_API.G_MISS_NUM;
410: p_outrec.cycle_count_quantity := p_in_rec.cycle_count_quantity;
411: p_outrec.tracking_number := p_in_rec.tracking_number;
412: p_outrec.movement_id := FND_API.G_MISS_NUM;
413: p_outrec.shipping_instructions := p_in_rec.shipping_instructions;
414: p_outrec.packing_instructions := p_in_rec.packing_instructions;
415: p_outrec.project_id := FND_API.G_MISS_NUM;
416: p_outrec.task_id := FND_API.G_MISS_NUM;

Line 415: p_outrec.project_id := FND_API.G_MISS_NUM;

411: p_outrec.tracking_number := p_in_rec.tracking_number;
412: p_outrec.movement_id := FND_API.G_MISS_NUM;
413: p_outrec.shipping_instructions := p_in_rec.shipping_instructions;
414: p_outrec.packing_instructions := p_in_rec.packing_instructions;
415: p_outrec.project_id := FND_API.G_MISS_NUM;
416: p_outrec.task_id := FND_API.G_MISS_NUM;
417: p_outrec.org_id := FND_API.G_MISS_NUM;
418: p_outrec.oe_interfaced_flag := FND_API.G_MISS_CHAR;
419: p_outrec.split_from_detail_id := FND_API.G_MISS_NUM;

Line 416: p_outrec.task_id := FND_API.G_MISS_NUM;

412: p_outrec.movement_id := FND_API.G_MISS_NUM;
413: p_outrec.shipping_instructions := p_in_rec.shipping_instructions;
414: p_outrec.packing_instructions := p_in_rec.packing_instructions;
415: p_outrec.project_id := FND_API.G_MISS_NUM;
416: p_outrec.task_id := FND_API.G_MISS_NUM;
417: p_outrec.org_id := FND_API.G_MISS_NUM;
418: p_outrec.oe_interfaced_flag := FND_API.G_MISS_CHAR;
419: p_outrec.split_from_detail_id := FND_API.G_MISS_NUM;
420: p_outrec.inv_interfaced_flag := FND_API.G_MISS_CHAR;

Line 417: p_outrec.org_id := FND_API.G_MISS_NUM;

413: p_outrec.shipping_instructions := p_in_rec.shipping_instructions;
414: p_outrec.packing_instructions := p_in_rec.packing_instructions;
415: p_outrec.project_id := FND_API.G_MISS_NUM;
416: p_outrec.task_id := FND_API.G_MISS_NUM;
417: p_outrec.org_id := FND_API.G_MISS_NUM;
418: p_outrec.oe_interfaced_flag := FND_API.G_MISS_CHAR;
419: p_outrec.split_from_detail_id := FND_API.G_MISS_NUM;
420: p_outrec.inv_interfaced_flag := FND_API.G_MISS_CHAR;
421: p_outrec.source_line_number := FND_API.G_MISS_CHAR;

Line 418: p_outrec.oe_interfaced_flag := FND_API.G_MISS_CHAR;

414: p_outrec.packing_instructions := p_in_rec.packing_instructions;
415: p_outrec.project_id := FND_API.G_MISS_NUM;
416: p_outrec.task_id := FND_API.G_MISS_NUM;
417: p_outrec.org_id := FND_API.G_MISS_NUM;
418: p_outrec.oe_interfaced_flag := FND_API.G_MISS_CHAR;
419: p_outrec.split_from_detail_id := FND_API.G_MISS_NUM;
420: p_outrec.inv_interfaced_flag := FND_API.G_MISS_CHAR;
421: p_outrec.source_line_number := FND_API.G_MISS_CHAR;
422: p_outrec.inspection_flag := FND_API.G_MISS_CHAR;

Line 419: p_outrec.split_from_detail_id := FND_API.G_MISS_NUM;

415: p_outrec.project_id := FND_API.G_MISS_NUM;
416: p_outrec.task_id := FND_API.G_MISS_NUM;
417: p_outrec.org_id := FND_API.G_MISS_NUM;
418: p_outrec.oe_interfaced_flag := FND_API.G_MISS_CHAR;
419: p_outrec.split_from_detail_id := FND_API.G_MISS_NUM;
420: p_outrec.inv_interfaced_flag := FND_API.G_MISS_CHAR;
421: p_outrec.source_line_number := FND_API.G_MISS_CHAR;
422: p_outrec.inspection_flag := FND_API.G_MISS_CHAR;
423: p_outrec.released_status := p_in_rec.released_status;

Line 420: p_outrec.inv_interfaced_flag := FND_API.G_MISS_CHAR;

416: p_outrec.task_id := FND_API.G_MISS_NUM;
417: p_outrec.org_id := FND_API.G_MISS_NUM;
418: p_outrec.oe_interfaced_flag := FND_API.G_MISS_CHAR;
419: p_outrec.split_from_detail_id := FND_API.G_MISS_NUM;
420: p_outrec.inv_interfaced_flag := FND_API.G_MISS_CHAR;
421: p_outrec.source_line_number := FND_API.G_MISS_CHAR;
422: p_outrec.inspection_flag := FND_API.G_MISS_CHAR;
423: p_outrec.released_status := p_in_rec.released_status;
424: p_outrec.container_flag := p_in_rec.container_flag;

Line 421: p_outrec.source_line_number := FND_API.G_MISS_CHAR;

417: p_outrec.org_id := FND_API.G_MISS_NUM;
418: p_outrec.oe_interfaced_flag := FND_API.G_MISS_CHAR;
419: p_outrec.split_from_detail_id := FND_API.G_MISS_NUM;
420: p_outrec.inv_interfaced_flag := FND_API.G_MISS_CHAR;
421: p_outrec.source_line_number := FND_API.G_MISS_CHAR;
422: p_outrec.inspection_flag := FND_API.G_MISS_CHAR;
423: p_outrec.released_status := p_in_rec.released_status;
424: p_outrec.container_flag := p_in_rec.container_flag;
425: p_outrec.container_type_code := FND_API.G_MISS_CHAR;

Line 422: p_outrec.inspection_flag := FND_API.G_MISS_CHAR;

418: p_outrec.oe_interfaced_flag := FND_API.G_MISS_CHAR;
419: p_outrec.split_from_detail_id := FND_API.G_MISS_NUM;
420: p_outrec.inv_interfaced_flag := FND_API.G_MISS_CHAR;
421: p_outrec.source_line_number := FND_API.G_MISS_CHAR;
422: p_outrec.inspection_flag := FND_API.G_MISS_CHAR;
423: p_outrec.released_status := p_in_rec.released_status;
424: p_outrec.container_flag := p_in_rec.container_flag;
425: p_outrec.container_type_code := FND_API.G_MISS_CHAR;
426: p_outrec.container_name := p_in_rec.container_name;

Line 425: p_outrec.container_type_code := FND_API.G_MISS_CHAR;

421: p_outrec.source_line_number := FND_API.G_MISS_CHAR;
422: p_outrec.inspection_flag := FND_API.G_MISS_CHAR;
423: p_outrec.released_status := p_in_rec.released_status;
424: p_outrec.container_flag := p_in_rec.container_flag;
425: p_outrec.container_type_code := FND_API.G_MISS_CHAR;
426: p_outrec.container_name := p_in_rec.container_name;
427: p_outrec.fill_percent := FND_API.G_MISS_NUM;
428: p_outrec.gross_weight := p_in_rec.gross_weight;
429: p_outrec.master_serial_number := FND_API.G_MISS_CHAR;

Line 427: p_outrec.fill_percent := FND_API.G_MISS_NUM;

423: p_outrec.released_status := p_in_rec.released_status;
424: p_outrec.container_flag := p_in_rec.container_flag;
425: p_outrec.container_type_code := FND_API.G_MISS_CHAR;
426: p_outrec.container_name := p_in_rec.container_name;
427: p_outrec.fill_percent := FND_API.G_MISS_NUM;
428: p_outrec.gross_weight := p_in_rec.gross_weight;
429: p_outrec.master_serial_number := FND_API.G_MISS_CHAR;
430: p_outrec.maximum_load_weight := FND_API.G_MISS_NUM;
431: p_outrec.maximum_volume := FND_API.G_MISS_NUM;

Line 429: p_outrec.master_serial_number := FND_API.G_MISS_CHAR;

425: p_outrec.container_type_code := FND_API.G_MISS_CHAR;
426: p_outrec.container_name := p_in_rec.container_name;
427: p_outrec.fill_percent := FND_API.G_MISS_NUM;
428: p_outrec.gross_weight := p_in_rec.gross_weight;
429: p_outrec.master_serial_number := FND_API.G_MISS_CHAR;
430: p_outrec.maximum_load_weight := FND_API.G_MISS_NUM;
431: p_outrec.maximum_volume := FND_API.G_MISS_NUM;
432: p_outrec.minimum_fill_percent := FND_API.G_MISS_NUM;
433: p_outrec.seal_code := FND_API.G_MISS_CHAR;

Line 430: p_outrec.maximum_load_weight := FND_API.G_MISS_NUM;

426: p_outrec.container_name := p_in_rec.container_name;
427: p_outrec.fill_percent := FND_API.G_MISS_NUM;
428: p_outrec.gross_weight := p_in_rec.gross_weight;
429: p_outrec.master_serial_number := FND_API.G_MISS_CHAR;
430: p_outrec.maximum_load_weight := FND_API.G_MISS_NUM;
431: p_outrec.maximum_volume := FND_API.G_MISS_NUM;
432: p_outrec.minimum_fill_percent := FND_API.G_MISS_NUM;
433: p_outrec.seal_code := FND_API.G_MISS_CHAR;
434: p_outrec.unit_number := FND_API.G_MISS_CHAR;

Line 431: p_outrec.maximum_volume := FND_API.G_MISS_NUM;

427: p_outrec.fill_percent := FND_API.G_MISS_NUM;
428: p_outrec.gross_weight := p_in_rec.gross_weight;
429: p_outrec.master_serial_number := FND_API.G_MISS_CHAR;
430: p_outrec.maximum_load_weight := FND_API.G_MISS_NUM;
431: p_outrec.maximum_volume := FND_API.G_MISS_NUM;
432: p_outrec.minimum_fill_percent := FND_API.G_MISS_NUM;
433: p_outrec.seal_code := FND_API.G_MISS_CHAR;
434: p_outrec.unit_number := FND_API.G_MISS_CHAR;
435: p_outrec.unit_price := FND_API.G_MISS_NUM;

Line 432: p_outrec.minimum_fill_percent := FND_API.G_MISS_NUM;

428: p_outrec.gross_weight := p_in_rec.gross_weight;
429: p_outrec.master_serial_number := FND_API.G_MISS_CHAR;
430: p_outrec.maximum_load_weight := FND_API.G_MISS_NUM;
431: p_outrec.maximum_volume := FND_API.G_MISS_NUM;
432: p_outrec.minimum_fill_percent := FND_API.G_MISS_NUM;
433: p_outrec.seal_code := FND_API.G_MISS_CHAR;
434: p_outrec.unit_number := FND_API.G_MISS_CHAR;
435: p_outrec.unit_price := FND_API.G_MISS_NUM;
436: p_outrec.currency_code := FND_API.G_MISS_CHAR;

Line 433: p_outrec.seal_code := FND_API.G_MISS_CHAR;

429: p_outrec.master_serial_number := FND_API.G_MISS_CHAR;
430: p_outrec.maximum_load_weight := FND_API.G_MISS_NUM;
431: p_outrec.maximum_volume := FND_API.G_MISS_NUM;
432: p_outrec.minimum_fill_percent := FND_API.G_MISS_NUM;
433: p_outrec.seal_code := FND_API.G_MISS_CHAR;
434: p_outrec.unit_number := FND_API.G_MISS_CHAR;
435: p_outrec.unit_price := FND_API.G_MISS_NUM;
436: p_outrec.currency_code := FND_API.G_MISS_CHAR;
437: p_outrec.freight_class_cat_id := FND_API.G_MISS_NUM;

Line 434: p_outrec.unit_number := FND_API.G_MISS_CHAR;

430: p_outrec.maximum_load_weight := FND_API.G_MISS_NUM;
431: p_outrec.maximum_volume := FND_API.G_MISS_NUM;
432: p_outrec.minimum_fill_percent := FND_API.G_MISS_NUM;
433: p_outrec.seal_code := FND_API.G_MISS_CHAR;
434: p_outrec.unit_number := FND_API.G_MISS_CHAR;
435: p_outrec.unit_price := FND_API.G_MISS_NUM;
436: p_outrec.currency_code := FND_API.G_MISS_CHAR;
437: p_outrec.freight_class_cat_id := FND_API.G_MISS_NUM;
438: p_outrec.commodity_code_cat_id := FND_API.G_MISS_NUM;

Line 435: p_outrec.unit_price := FND_API.G_MISS_NUM;

431: p_outrec.maximum_volume := FND_API.G_MISS_NUM;
432: p_outrec.minimum_fill_percent := FND_API.G_MISS_NUM;
433: p_outrec.seal_code := FND_API.G_MISS_CHAR;
434: p_outrec.unit_number := FND_API.G_MISS_CHAR;
435: p_outrec.unit_price := FND_API.G_MISS_NUM;
436: p_outrec.currency_code := FND_API.G_MISS_CHAR;
437: p_outrec.freight_class_cat_id := FND_API.G_MISS_NUM;
438: p_outrec.commodity_code_cat_id := FND_API.G_MISS_NUM;
439: p_outrec.preferred_grade := p_in_rec.preferred_grade;

Line 436: p_outrec.currency_code := FND_API.G_MISS_CHAR;

432: p_outrec.minimum_fill_percent := FND_API.G_MISS_NUM;
433: p_outrec.seal_code := FND_API.G_MISS_CHAR;
434: p_outrec.unit_number := FND_API.G_MISS_CHAR;
435: p_outrec.unit_price := FND_API.G_MISS_NUM;
436: p_outrec.currency_code := FND_API.G_MISS_CHAR;
437: p_outrec.freight_class_cat_id := FND_API.G_MISS_NUM;
438: p_outrec.commodity_code_cat_id := FND_API.G_MISS_NUM;
439: p_outrec.preferred_grade := p_in_rec.preferred_grade;
440: p_outrec.src_requested_quantity2 := FND_API.G_MISS_NUM;

Line 437: p_outrec.freight_class_cat_id := FND_API.G_MISS_NUM;

433: p_outrec.seal_code := FND_API.G_MISS_CHAR;
434: p_outrec.unit_number := FND_API.G_MISS_CHAR;
435: p_outrec.unit_price := FND_API.G_MISS_NUM;
436: p_outrec.currency_code := FND_API.G_MISS_CHAR;
437: p_outrec.freight_class_cat_id := FND_API.G_MISS_NUM;
438: p_outrec.commodity_code_cat_id := FND_API.G_MISS_NUM;
439: p_outrec.preferred_grade := p_in_rec.preferred_grade;
440: p_outrec.src_requested_quantity2 := FND_API.G_MISS_NUM;
441: p_outrec.src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;

Line 438: p_outrec.commodity_code_cat_id := FND_API.G_MISS_NUM;

434: p_outrec.unit_number := FND_API.G_MISS_CHAR;
435: p_outrec.unit_price := FND_API.G_MISS_NUM;
436: p_outrec.currency_code := FND_API.G_MISS_CHAR;
437: p_outrec.freight_class_cat_id := FND_API.G_MISS_NUM;
438: p_outrec.commodity_code_cat_id := FND_API.G_MISS_NUM;
439: p_outrec.preferred_grade := p_in_rec.preferred_grade;
440: p_outrec.src_requested_quantity2 := FND_API.G_MISS_NUM;
441: p_outrec.src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
442: p_outrec.requested_quantity2 := FND_API.G_MISS_NUM;

Line 440: p_outrec.src_requested_quantity2 := FND_API.G_MISS_NUM;

436: p_outrec.currency_code := FND_API.G_MISS_CHAR;
437: p_outrec.freight_class_cat_id := FND_API.G_MISS_NUM;
438: p_outrec.commodity_code_cat_id := FND_API.G_MISS_NUM;
439: p_outrec.preferred_grade := p_in_rec.preferred_grade;
440: p_outrec.src_requested_quantity2 := FND_API.G_MISS_NUM;
441: p_outrec.src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
442: p_outrec.requested_quantity2 := FND_API.G_MISS_NUM;
443: p_outrec.shipped_quantity2 := FND_API.G_MISS_NUM;
444: p_outrec.delivered_quantity2 := FND_API.G_MISS_NUM;

Line 441: p_outrec.src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;

437: p_outrec.freight_class_cat_id := FND_API.G_MISS_NUM;
438: p_outrec.commodity_code_cat_id := FND_API.G_MISS_NUM;
439: p_outrec.preferred_grade := p_in_rec.preferred_grade;
440: p_outrec.src_requested_quantity2 := FND_API.G_MISS_NUM;
441: p_outrec.src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
442: p_outrec.requested_quantity2 := FND_API.G_MISS_NUM;
443: p_outrec.shipped_quantity2 := FND_API.G_MISS_NUM;
444: p_outrec.delivered_quantity2 := FND_API.G_MISS_NUM;
445: p_outrec.cancelled_quantity2 := FND_API.G_MISS_NUM;

Line 442: p_outrec.requested_quantity2 := FND_API.G_MISS_NUM;

438: p_outrec.commodity_code_cat_id := FND_API.G_MISS_NUM;
439: p_outrec.preferred_grade := p_in_rec.preferred_grade;
440: p_outrec.src_requested_quantity2 := FND_API.G_MISS_NUM;
441: p_outrec.src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
442: p_outrec.requested_quantity2 := FND_API.G_MISS_NUM;
443: p_outrec.shipped_quantity2 := FND_API.G_MISS_NUM;
444: p_outrec.delivered_quantity2 := FND_API.G_MISS_NUM;
445: p_outrec.cancelled_quantity2 := FND_API.G_MISS_NUM;
446: p_outrec.quality_control_quantity2 := FND_API.G_MISS_NUM;

Line 443: p_outrec.shipped_quantity2 := FND_API.G_MISS_NUM;

439: p_outrec.preferred_grade := p_in_rec.preferred_grade;
440: p_outrec.src_requested_quantity2 := FND_API.G_MISS_NUM;
441: p_outrec.src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
442: p_outrec.requested_quantity2 := FND_API.G_MISS_NUM;
443: p_outrec.shipped_quantity2 := FND_API.G_MISS_NUM;
444: p_outrec.delivered_quantity2 := FND_API.G_MISS_NUM;
445: p_outrec.cancelled_quantity2 := FND_API.G_MISS_NUM;
446: p_outrec.quality_control_quantity2 := FND_API.G_MISS_NUM;
447: p_outrec.cycle_count_quantity2 := FND_API.G_MISS_NUM;

Line 444: p_outrec.delivered_quantity2 := FND_API.G_MISS_NUM;

440: p_outrec.src_requested_quantity2 := FND_API.G_MISS_NUM;
441: p_outrec.src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
442: p_outrec.requested_quantity2 := FND_API.G_MISS_NUM;
443: p_outrec.shipped_quantity2 := FND_API.G_MISS_NUM;
444: p_outrec.delivered_quantity2 := FND_API.G_MISS_NUM;
445: p_outrec.cancelled_quantity2 := FND_API.G_MISS_NUM;
446: p_outrec.quality_control_quantity2 := FND_API.G_MISS_NUM;
447: p_outrec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
448: p_outrec.requested_quantity_uom2 := FND_API.G_MISS_CHAR;

Line 445: p_outrec.cancelled_quantity2 := FND_API.G_MISS_NUM;

441: p_outrec.src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
442: p_outrec.requested_quantity2 := FND_API.G_MISS_NUM;
443: p_outrec.shipped_quantity2 := FND_API.G_MISS_NUM;
444: p_outrec.delivered_quantity2 := FND_API.G_MISS_NUM;
445: p_outrec.cancelled_quantity2 := FND_API.G_MISS_NUM;
446: p_outrec.quality_control_quantity2 := FND_API.G_MISS_NUM;
447: p_outrec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
448: p_outrec.requested_quantity_uom2 := FND_API.G_MISS_CHAR;
449: -- HW OPMCONV - No need for sublot_number

Line 446: p_outrec.quality_control_quantity2 := FND_API.G_MISS_NUM;

442: p_outrec.requested_quantity2 := FND_API.G_MISS_NUM;
443: p_outrec.shipped_quantity2 := FND_API.G_MISS_NUM;
444: p_outrec.delivered_quantity2 := FND_API.G_MISS_NUM;
445: p_outrec.cancelled_quantity2 := FND_API.G_MISS_NUM;
446: p_outrec.quality_control_quantity2 := FND_API.G_MISS_NUM;
447: p_outrec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
448: p_outrec.requested_quantity_uom2 := FND_API.G_MISS_CHAR;
449: -- HW OPMCONV - No need for sublot_number
450: -- p_outrec.sublot_number := p_in_rec.sublot_number;

Line 447: p_outrec.cycle_count_quantity2 := FND_API.G_MISS_NUM;

443: p_outrec.shipped_quantity2 := FND_API.G_MISS_NUM;
444: p_outrec.delivered_quantity2 := FND_API.G_MISS_NUM;
445: p_outrec.cancelled_quantity2 := FND_API.G_MISS_NUM;
446: p_outrec.quality_control_quantity2 := FND_API.G_MISS_NUM;
447: p_outrec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
448: p_outrec.requested_quantity_uom2 := FND_API.G_MISS_CHAR;
449: -- HW OPMCONV - No need for sublot_number
450: -- p_outrec.sublot_number := p_in_rec.sublot_number;
451: p_outrec.lpn_id := FND_API.G_MISS_NUM;

Line 448: p_outrec.requested_quantity_uom2 := FND_API.G_MISS_CHAR;

444: p_outrec.delivered_quantity2 := FND_API.G_MISS_NUM;
445: p_outrec.cancelled_quantity2 := FND_API.G_MISS_NUM;
446: p_outrec.quality_control_quantity2 := FND_API.G_MISS_NUM;
447: p_outrec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
448: p_outrec.requested_quantity_uom2 := FND_API.G_MISS_CHAR;
449: -- HW OPMCONV - No need for sublot_number
450: -- p_outrec.sublot_number := p_in_rec.sublot_number;
451: p_outrec.lpn_id := FND_API.G_MISS_NUM;
452: p_outrec.pickable_flag := FND_API.G_MISS_CHAR;

Line 451: p_outrec.lpn_id := FND_API.G_MISS_NUM;

447: p_outrec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
448: p_outrec.requested_quantity_uom2 := FND_API.G_MISS_CHAR;
449: -- HW OPMCONV - No need for sublot_number
450: -- p_outrec.sublot_number := p_in_rec.sublot_number;
451: p_outrec.lpn_id := FND_API.G_MISS_NUM;
452: p_outrec.pickable_flag := FND_API.G_MISS_CHAR;
453: p_outrec.original_subinventory := FND_API.G_MISS_CHAR;
454: p_outrec.to_serial_number := FND_API.G_MISS_CHAR;
455: p_outrec.picked_quantity := FND_API.G_MISS_NUM;

Line 452: p_outrec.pickable_flag := FND_API.G_MISS_CHAR;

448: p_outrec.requested_quantity_uom2 := FND_API.G_MISS_CHAR;
449: -- HW OPMCONV - No need for sublot_number
450: -- p_outrec.sublot_number := p_in_rec.sublot_number;
451: p_outrec.lpn_id := FND_API.G_MISS_NUM;
452: p_outrec.pickable_flag := FND_API.G_MISS_CHAR;
453: p_outrec.original_subinventory := FND_API.G_MISS_CHAR;
454: p_outrec.to_serial_number := FND_API.G_MISS_CHAR;
455: p_outrec.picked_quantity := FND_API.G_MISS_NUM;
456: p_outrec.picked_quantity2 := FND_API.G_MISS_NUM;

Line 453: p_outrec.original_subinventory := FND_API.G_MISS_CHAR;

449: -- HW OPMCONV - No need for sublot_number
450: -- p_outrec.sublot_number := p_in_rec.sublot_number;
451: p_outrec.lpn_id := FND_API.G_MISS_NUM;
452: p_outrec.pickable_flag := FND_API.G_MISS_CHAR;
453: p_outrec.original_subinventory := FND_API.G_MISS_CHAR;
454: p_outrec.to_serial_number := FND_API.G_MISS_CHAR;
455: p_outrec.picked_quantity := FND_API.G_MISS_NUM;
456: p_outrec.picked_quantity2 := FND_API.G_MISS_NUM;
457: p_outrec.received_quantity := FND_API.G_MISS_NUM;

Line 454: p_outrec.to_serial_number := FND_API.G_MISS_CHAR;

450: -- p_outrec.sublot_number := p_in_rec.sublot_number;
451: p_outrec.lpn_id := FND_API.G_MISS_NUM;
452: p_outrec.pickable_flag := FND_API.G_MISS_CHAR;
453: p_outrec.original_subinventory := FND_API.G_MISS_CHAR;
454: p_outrec.to_serial_number := FND_API.G_MISS_CHAR;
455: p_outrec.picked_quantity := FND_API.G_MISS_NUM;
456: p_outrec.picked_quantity2 := FND_API.G_MISS_NUM;
457: p_outrec.received_quantity := FND_API.G_MISS_NUM;
458: p_outrec.received_quantity2 := FND_API.G_MISS_NUM;

Line 455: p_outrec.picked_quantity := FND_API.G_MISS_NUM;

451: p_outrec.lpn_id := FND_API.G_MISS_NUM;
452: p_outrec.pickable_flag := FND_API.G_MISS_CHAR;
453: p_outrec.original_subinventory := FND_API.G_MISS_CHAR;
454: p_outrec.to_serial_number := FND_API.G_MISS_CHAR;
455: p_outrec.picked_quantity := FND_API.G_MISS_NUM;
456: p_outrec.picked_quantity2 := FND_API.G_MISS_NUM;
457: p_outrec.received_quantity := FND_API.G_MISS_NUM;
458: p_outrec.received_quantity2 := FND_API.G_MISS_NUM;
459: p_outrec.source_line_set_id := FND_API.G_MISS_NUM;

Line 456: p_outrec.picked_quantity2 := FND_API.G_MISS_NUM;

452: p_outrec.pickable_flag := FND_API.G_MISS_CHAR;
453: p_outrec.original_subinventory := FND_API.G_MISS_CHAR;
454: p_outrec.to_serial_number := FND_API.G_MISS_CHAR;
455: p_outrec.picked_quantity := FND_API.G_MISS_NUM;
456: p_outrec.picked_quantity2 := FND_API.G_MISS_NUM;
457: p_outrec.received_quantity := FND_API.G_MISS_NUM;
458: p_outrec.received_quantity2 := FND_API.G_MISS_NUM;
459: p_outrec.source_line_set_id := FND_API.G_MISS_NUM;
460:

Line 457: p_outrec.received_quantity := FND_API.G_MISS_NUM;

453: p_outrec.original_subinventory := FND_API.G_MISS_CHAR;
454: p_outrec.to_serial_number := FND_API.G_MISS_CHAR;
455: p_outrec.picked_quantity := FND_API.G_MISS_NUM;
456: p_outrec.picked_quantity2 := FND_API.G_MISS_NUM;
457: p_outrec.received_quantity := FND_API.G_MISS_NUM;
458: p_outrec.received_quantity2 := FND_API.G_MISS_NUM;
459: p_outrec.source_line_set_id := FND_API.G_MISS_NUM;
460:
461:

Line 458: p_outrec.received_quantity2 := FND_API.G_MISS_NUM;

454: p_outrec.to_serial_number := FND_API.G_MISS_CHAR;
455: p_outrec.picked_quantity := FND_API.G_MISS_NUM;
456: p_outrec.picked_quantity2 := FND_API.G_MISS_NUM;
457: p_outrec.received_quantity := FND_API.G_MISS_NUM;
458: p_outrec.received_quantity2 := FND_API.G_MISS_NUM;
459: p_outrec.source_line_set_id := FND_API.G_MISS_NUM;
460:
461:
462: IF l_debug_on THEN

Line 459: p_outrec.source_line_set_id := FND_API.G_MISS_NUM;

455: p_outrec.picked_quantity := FND_API.G_MISS_NUM;
456: p_outrec.picked_quantity2 := FND_API.G_MISS_NUM;
457: p_outrec.received_quantity := FND_API.G_MISS_NUM;
458: p_outrec.received_quantity2 := FND_API.G_MISS_NUM;
459: p_outrec.source_line_set_id := FND_API.G_MISS_NUM;
460:
461:
462: IF l_debug_on THEN
463: WSH_DEBUG_SV.pop(l_module_name);

Line 476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
473:
474: END IF;
475:
476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
477:
478: END populate_record;
479:
480:

Line 499: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

495:
496: PROCEDURE Update_Container (
497: -- Standard parameters
498: p_api_version IN NUMBER,
499: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
500: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
501: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
502: x_return_status OUT NOCOPY VARCHAR2,
503: x_msg_count OUT NOCOPY NUMBER,

Line 500: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

496: PROCEDURE Update_Container (
497: -- Standard parameters
498: p_api_version IN NUMBER,
499: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
500: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
501: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
502: x_return_status OUT NOCOPY VARCHAR2,
503: x_msg_count OUT NOCOPY NUMBER,
504: x_msg_data OUT NOCOPY VARCHAR2,

Line 501: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

497: -- Standard parameters
498: p_api_version IN NUMBER,
499: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
500: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
501: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
502: x_return_status OUT NOCOPY VARCHAR2,
503: x_msg_count OUT NOCOPY NUMBER,
504: x_msg_data OUT NOCOPY VARCHAR2,
505:

Line 561: IF NOT FND_API.compatible_api_call (

557: WSH_DEBUG_SV.log(l_module_name,'delivery_detail_id',
558: p_container_rec.delivery_detail_id);
559: END IF;
560:
561: IF NOT FND_API.compatible_api_call (
562: l_api_version,
563: p_api_version,
564: l_api_name,
565: G_PKG_NAME) THEN

Line 566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

562: l_api_version,
563: p_api_version,
564: l_api_name,
565: G_PKG_NAME) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: END IF;
568:
569: -- Check p_init_msg_list
570: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 570: IF FND_API.to_boolean(p_init_msg_list) THEN

566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: END IF;
568:
569: -- Check p_init_msg_list
570: IF FND_API.to_boolean(p_init_msg_list) THEN
571: FND_MSG_PUB.initialize;
572: END IF;
573:
574: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 593: p_init_msg_list => FND_API.G_FALSE,

589: l_detail_rec.lpn_ids := l_lpn_ids;
590: --
591: wsh_interface_grp.Create_Update_Delivery_Detail(
592: p_api_version_number => 1.0,
593: p_init_msg_list => FND_API.G_FALSE,
594: p_commit => FND_API.G_FALSE,
595: x_return_status => x_return_status,
596: x_msg_count => x_msg_count,
597: x_msg_data => x_msg_data,

Line 594: p_commit => FND_API.G_FALSE,

590: --
591: wsh_interface_grp.Create_Update_Delivery_Detail(
592: p_api_version_number => 1.0,
593: p_init_msg_list => FND_API.G_FALSE,
594: p_commit => FND_API.G_FALSE,
595: x_return_status => x_return_status,
596: x_msg_count => x_msg_count,
597: x_msg_data => x_msg_data,
598: p_detail_info_tab => l_detail_info_tab,

Line 613: IF FND_API.TO_BOOLEAN(p_commit) THEN

609: IF x_return_status IN (wsh_util_core.g_ret_sts_error, wsh_util_core.G_RET_STS_UNEXP_ERROR ) THEN
610: raise WSH_FAIL_CONT_UPDATE;
611: END IF;
612:
613: IF FND_API.TO_BOOLEAN(p_commit) THEN
614: -- dbms_output.put_line('commit');
615: COMMIT;
616: END IF;
617:

Line 623: p_encoded => FND_API.G_FALSE

619: FND_MSG_PUB.Count_And_Get
620: (
621: p_count => x_msg_count,
622: p_data => x_msg_data,
623: p_encoded => FND_API.G_FALSE
624: );
625: --
626:
627:

Line 645: p_encoded => FND_API.G_FALSE

641: FND_MSG_PUB.Count_And_Get
642: (
643: p_count => x_msg_count,
644: p_data => x_msg_data,
645: p_encoded => FND_API.G_FALSE
646: );
647: --
648:
649: IF l_debug_on THEN

Line 663: p_encoded => FND_API.G_FALSE

659: FND_MSG_PUB.Count_And_Get
660: (
661: p_count => x_msg_count,
662: p_data => x_msg_data,
663: p_encoded => FND_API.G_FALSE
664: );
665: --
666: IF l_debug_on THEN
667: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_UPDATE');

Line 679: p_encoded => FND_API.G_FALSE

675: FND_MSG_PUB.Count_And_Get
676: (
677: p_count => x_msg_count,
678: p_data => x_msg_data,
679: p_encoded => FND_API.G_FALSE
680: );
681: --
682:
683: IF l_debug_on THEN

Line 727: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

723:
724: PROCEDURE Auto_Pack (
725: -- Standard parameters
726: p_api_version IN NUMBER,
727: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
728: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
729: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
730: x_return_status OUT NOCOPY VARCHAR2,
731: x_msg_count OUT NOCOPY NUMBER,

Line 728: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

724: PROCEDURE Auto_Pack (
725: -- Standard parameters
726: p_api_version IN NUMBER,
727: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
728: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
729: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
730: x_return_status OUT NOCOPY VARCHAR2,
731: x_msg_count OUT NOCOPY NUMBER,
732: x_msg_data OUT NOCOPY VARCHAR2,

Line 729: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

725: -- Standard parameters
726: p_api_version IN NUMBER,
727: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
728: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
729: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
730: x_return_status OUT NOCOPY VARCHAR2,
731: x_msg_count OUT NOCOPY NUMBER,
732: x_msg_data OUT NOCOPY VARCHAR2,
733:

Line 802: IF NOT FND_API.compatible_api_call (

798: WSH_DEBUG_SV.log(l_module_name,'p_entity_type', p_entity_type);
799: WSH_DEBUG_SV.log(l_module_name,'p_pack_cont_flag',p_pack_cont_flag);
800: END IF;
801:
802: IF NOT FND_API.compatible_api_call (
803: l_api_version,
804: p_api_version,
805: l_api_name,
806: G_PKG_NAME) THEN

Line 807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

803: l_api_version,
804: p_api_version,
805: l_api_name,
806: G_PKG_NAME) THEN
807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
808: END IF;
809:
810: -- Check p_init_msg_list
811: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 811: IF FND_API.to_boolean(p_init_msg_list) THEN

807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
808: END IF;
809:
810: -- Check p_init_msg_list
811: IF FND_API.to_boolean(p_init_msg_list) THEN
812: FND_MSG_PUB.initialize;
813: END IF;
814:
815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 848: p_init_msg_list => FND_API.G_FALSE,

844: END IF;
845:
846: wsh_interface_grp.Delivery_Detail_Action(
847: p_api_version_number => 1.0,
848: p_init_msg_list => FND_API.G_FALSE,
849: p_commit => FND_API.G_FALSE,
850: x_return_status =>x_return_status,
851: x_msg_count => x_msg_count,
852: x_msg_data => x_msg_data,

Line 849: p_commit => FND_API.G_FALSE,

845:
846: wsh_interface_grp.Delivery_Detail_Action(
847: p_api_version_number => 1.0,
848: p_init_msg_list => FND_API.G_FALSE,
849: p_commit => FND_API.G_FALSE,
850: x_return_status =>x_return_status,
851: x_msg_count => x_msg_count,
852: x_msg_data => x_msg_data,
853: p_detail_id_tab =>l_entity_tab,

Line 887: p_init_msg_list => FND_API.G_FALSE,

883: END IF;
884:
885: wsh_interface_grp.Delivery_Action(
886: p_api_version_number => 1.0,
887: p_init_msg_list => FND_API.G_FALSE,
888: p_commit => FND_API.G_FALSE,
889: p_action_prms => l_action_prms_dl,
890: p_delivery_id_tab => l_entity_tab,
891: x_delivery_out_rec => l_delivery_out_rec,

Line 888: p_commit => FND_API.G_FALSE,

884:
885: wsh_interface_grp.Delivery_Action(
886: p_api_version_number => 1.0,
887: p_init_msg_list => FND_API.G_FALSE,
888: p_commit => FND_API.G_FALSE,
889: p_action_prms => l_action_prms_dl,
890: p_delivery_id_tab => l_entity_tab,
891: x_delivery_out_rec => l_delivery_out_rec,
892: x_return_status => x_return_status,

Line 915: IF FND_API.TO_BOOLEAN(p_commit) THEN

911: ELSE
912: RAISE WSH_INVALID_ENTITY_TYPE;
913: END IF;
914:
915: IF FND_API.TO_BOOLEAN(p_commit) THEN
916: -- dbms_output.put_line('commit');
917: COMMIT;
918: END IF;
919:

Line 925: p_encoded => FND_API.G_FALSE

921: FND_MSG_PUB.Count_And_Get
922: (
923: p_count => x_msg_count,
924: p_data => x_msg_data,
925: p_encoded => FND_API.G_FALSE
926: );
927: --
928:
929: IF l_debug_on THEN

Line 945: p_encoded => FND_API.G_FALSE

941: FND_MSG_PUB.Count_And_Get
942: (
943: p_count => x_msg_count,
944: p_data => x_msg_data,
945: p_encoded => FND_API.G_FALSE
946: );
947: --
948: IF l_debug_on THEN
949: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');

Line 962: p_encoded => FND_API.G_FALSE

958: FND_MSG_PUB.Count_And_Get
959: (
960: p_count => x_msg_count,
961: p_data => x_msg_data,
962: p_encoded => FND_API.G_FALSE
963: );
964: --
965:
966: IF l_debug_on THEN

Line 979: p_encoded => FND_API.G_FALSE

975: FND_MSG_PUB.Count_And_Get
976: (
977: p_count => x_msg_count,
978: p_data => x_msg_data,
979: p_encoded => FND_API.G_FALSE
980: );
981: --
982: IF l_debug_on THEN
983: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_AUTOPACK');

Line 996: p_encoded => FND_API.G_FALSE

992: FND_MSG_PUB.Count_And_Get
993: (
994: p_count => x_msg_count,
995: p_data => x_msg_data,
996: p_encoded => FND_API.G_FALSE
997: );
998: --
999:
1000: IF l_debug_on THEN

Line 1013: p_encoded => FND_API.G_FALSE

1009: FND_MSG_PUB.Count_And_Get
1010: (
1011: p_count => x_msg_count,
1012: p_data => x_msg_data,
1013: p_encoded => FND_API.G_FALSE
1014: );
1015: --
1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1056: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1052:
1053: PROCEDURE Container_Actions (
1054: -- Standard parameters
1055: p_api_version IN NUMBER,
1056: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1057: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1058: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1059: x_return_status OUT NOCOPY VARCHAR2,
1060: x_msg_count OUT NOCOPY NUMBER,

Line 1057: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1053: PROCEDURE Container_Actions (
1054: -- Standard parameters
1055: p_api_version IN NUMBER,
1056: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1057: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1058: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1059: x_return_status OUT NOCOPY VARCHAR2,
1060: x_msg_count OUT NOCOPY NUMBER,
1061: x_msg_data OUT NOCOPY VARCHAR2,

Line 1058: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1054: -- Standard parameters
1055: p_api_version IN NUMBER,
1056: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1057: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1058: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1059: x_return_status OUT NOCOPY VARCHAR2,
1060: x_msg_count OUT NOCOPY NUMBER,
1061: x_msg_data OUT NOCOPY VARCHAR2,
1062:

Line 1125: IF NOT FND_API.compatible_api_call (

1121: wsh_debug_sv.log (l_module_name,'p_delivery_name', p_delivery_name);
1122: wsh_debug_sv.log (l_module_name,'p_action_code', p_action_code);
1123: END IF;
1124:
1125: IF NOT FND_API.compatible_api_call (
1126: l_api_version,
1127: p_api_version,
1128: l_api_name,
1129: G_PKG_NAME) THEN

Line 1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1126: l_api_version,
1127: p_api_version,
1128: l_api_name,
1129: G_PKG_NAME) THEN
1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132:
1133: -- Check p_init_msg_list
1134: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1134: IF FND_API.to_boolean(p_init_msg_list) THEN

1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132:
1133: -- Check p_init_msg_list
1134: IF FND_API.to_boolean(p_init_msg_list) THEN
1135: FND_MSG_PUB.initialize;
1136: END IF;
1137:
1138: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1159: p_init_msg_list => FND_API.G_FALSE,

1155:
1156:
1157: wsh_interface_grp.Delivery_Detail_Action(
1158: p_api_version_number => 1.0,
1159: p_init_msg_list => FND_API.G_FALSE,
1160: p_commit => FND_API.G_FALSE,
1161: x_return_status =>l_return_status,
1162: x_msg_count => x_msg_count,
1163: x_msg_data => x_msg_data,

Line 1160: p_commit => FND_API.G_FALSE,

1156:
1157: wsh_interface_grp.Delivery_Detail_Action(
1158: p_api_version_number => 1.0,
1159: p_init_msg_list => FND_API.G_FALSE,
1160: p_commit => FND_API.G_FALSE,
1161: x_return_status =>l_return_status,
1162: x_msg_count => x_msg_count,
1163: x_msg_data => x_msg_data,
1164: p_detail_id_tab =>p_detail_tab,

Line 1176: IF FND_API.TO_BOOLEAN(p_commit) THEN

1172: x_num_errors =>l_num_errors);
1173:
1174: x_return_status := l_return_status;
1175:
1176: IF FND_API.TO_BOOLEAN(p_commit) THEN
1177: COMMIT;
1178: END IF;
1179:
1180: --

Line 1185: p_encoded => FND_API.G_FALSE

1181: FND_MSG_PUB.Count_And_Get
1182: (
1183: p_count => x_msg_count,
1184: p_data => x_msg_data,
1185: p_encoded => FND_API.G_FALSE
1186: );
1187: --
1188:
1189:

Line 1205: p_encoded => FND_API.G_FALSE

1201: FND_MSG_PUB.Count_And_Get
1202: (
1203: p_count => x_msg_count,
1204: p_data => x_msg_data,
1205: p_encoded => FND_API.G_FALSE
1206: );
1207: --
1208:
1209: IF l_debug_on THEN

Line 1214: WHEN FND_API.G_EXC_ERROR THEN

1210: wsh_debug_sv.log (l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
1211: WSH_DEBUG_SV.pop(l_module_name);
1212: END IF;
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: rollback to Container_Action_SP;
1216: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1217:
1218: --

Line 1223: p_encoded => FND_API.G_FALSE

1219: FND_MSG_PUB.Count_And_Get
1220: (
1221: p_count => x_msg_count,
1222: p_data => x_msg_data,
1223: p_encoded => FND_API.G_FALSE
1224: );
1225: --
1226:
1227: IF l_debug_on THEN

Line 1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1230: END IF;
1231:
1232:
1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235: rollback to Container_Action_SP;
1236: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1237: --
1238: FND_MSG_PUB.Count_And_Get

Line 1242: p_encoded => FND_API.G_FALSE

1238: FND_MSG_PUB.Count_And_Get
1239: (
1240: p_count => x_msg_count,
1241: p_data => x_msg_data,
1242: p_encoded => FND_API.G_FALSE
1243: );
1244: --
1245: IF l_debug_on THEN
1246: wsh_debug_sv.log (l_module_name,'EXCEPTION:G_RET_STS_UNEXP_ERROR');

Line 1257: p_encoded => FND_API.G_FALSE

1253: FND_MSG_PUB.Count_And_Get
1254: (
1255: p_count => x_msg_count,
1256: p_data => x_msg_data,
1257: p_encoded => FND_API.G_FALSE
1258: );
1259: --
1260:
1261: IF l_debug_on THEN

Line 1275: p_encoded => FND_API.G_FALSE

1271: FND_MSG_PUB.Count_And_Get
1272: (
1273: p_count => x_msg_count,
1274: p_data => x_msg_data,
1275: p_encoded => FND_API.G_FALSE
1276: );
1277: --
1278: IF l_debug_on THEN
1279: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));