[Home] [Help]
102: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_NAME',P_DELIVERY_NAME);
103: END IF;
104: --
105:
106: IF NOT FND_API.compatible_api_call( l_api_version,
107: p_api_version,
108: l_api_name,
109: G_PKG_NAME) THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106: IF NOT FND_API.compatible_api_call( l_api_version,
107: p_api_version,
108: l_api_name,
109: G_PKG_NAME) THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:
113: -- Check p_init_msg_list
114: IF FND_API.to_boolean(p_init_msg_list) THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:
113: -- Check p_init_msg_list
114: IF FND_API.to_boolean(p_init_msg_list) THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
142: --
143:
144: wsh_interface_grp.delivery_detail_action(
145: p_api_version_number => p_api_version,
146: p_init_msg_list => FND_API.G_FALSE,
147: p_commit => FND_API.G_FALSE,
148: x_return_status => l_return_status,
149: x_msg_count => l_msg_count,
150: x_msg_data => l_msg_data,
143:
144: wsh_interface_grp.delivery_detail_action(
145: p_api_version_number => p_api_version,
146: p_init_msg_list => FND_API.G_FALSE,
147: p_commit => FND_API.G_FALSE,
148: x_return_status => l_return_status,
149: x_msg_count => l_msg_count,
150: x_msg_data => l_msg_data,
151: p_detail_id_tab => l_TabOfDelDets,
167: x_return_status := wsh_util_core.g_ret_sts_warning;
168: END IF;
169:
170:
171: IF FND_API.TO_BOOLEAN(p_commit) THEN
172: -- dbms_output.put_line('commit');
173: COMMIT WORK;
174: END IF;
175:
176: FND_MSG_PUB.Count_And_Get
177: (
178: p_count => x_msg_count,
179: p_data => x_msg_data,
180: p_encoded => FND_API.G_FALSE
181: );
182:
183: IF l_debug_on THEN
184: WSH_DEBUG_SV.pop(l_module_name);
184: WSH_DEBUG_SV.pop(l_module_name);
185: END IF;
186: --
187: exception
188: WHEN FND_API.G_EXC_ERROR THEN
189: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
190: x_return_status := FND_API.G_RET_STS_ERROR ;
191: wsh_util_core.add_message(x_return_status);
192: FND_MSG_PUB.Count_And_Get
186: --
187: exception
188: WHEN FND_API.G_EXC_ERROR THEN
189: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
190: x_return_status := FND_API.G_RET_STS_ERROR ;
191: wsh_util_core.add_message(x_return_status);
192: FND_MSG_PUB.Count_And_Get
193: (
194: p_count => x_msg_count,
192: FND_MSG_PUB.Count_And_Get
193: (
194: p_count => x_msg_count,
195: p_data => x_msg_data,
196: p_encoded => FND_API.G_FALSE
197: );
198:
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
196: p_encoded => FND_API.G_FALSE
197: );
198:
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
202: END IF;
203: --
204: WHEN WSH_NO_DEL_DET_TBL then
197: );
198:
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
202: END IF;
203: --
204: WHEN WSH_NO_DEL_DET_TBL then
205: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
209: FND_MSG_PUB.Count_And_Get
210: (
211: p_count => x_msg_count,
212: p_data => x_msg_data,
213: p_encoded => FND_API.G_FALSE
214: );
215:
216: IF l_debug_on THEN
217: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_DEL_DET_TBL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
217: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_NO_DEL_DET_TBL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
218: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_NO_DEL_DET_TBL');
219: END IF;
220: --
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: wsh_util_core.add_message(x_return_status, l_module_name);
225: FND_MSG_PUB.Count_And_Get
219: END IF;
220: --
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: wsh_util_core.add_message(x_return_status, l_module_name);
225: FND_MSG_PUB.Count_And_Get
226: (
227: p_count => x_msg_count,
225: FND_MSG_PUB.Count_And_Get
226: (
227: p_count => x_msg_count,
228: p_data => x_msg_data,
229: p_encoded => FND_API.G_FALSE
230: );
231: --
232:
233: IF l_debug_on THEN
230: );
231: --
232:
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
236: END IF;
237: WHEN others then
238: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
231: --
232:
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
236: END IF;
237: WHEN others then
238: ROLLBACK TO DETAIL_TO_DELIVERY_PUB;
239: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY');
241: FND_MSG_PUB.Count_And_Get
242: (
243: p_count => x_msg_count,
244: p_data => x_msg_data,
245: p_encoded => FND_API.G_FALSE
246: );
247:
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
331: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);
332: END IF;
333: --
334:
335: IF NOT FND_API.compatible_api_call(l_api_version,
336: p_api_version,
337: l_api_name,
338: G_PKG_NAME) THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: IF NOT FND_API.compatible_api_call(l_api_version,
336: p_api_version,
337: l_api_name,
338: G_PKG_NAME) THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341: -- Check p_init_msg_list
342: IF FND_API.to_boolean(p_init_msg_list) THEN
343: FND_MSG_PUB.initialize;
338: G_PKG_NAME) THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341: -- Check p_init_msg_list
342: IF FND_API.to_boolean(p_init_msg_list) THEN
343: FND_MSG_PUB.initialize;
344: END IF;
345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
346:
359: END IF;
360:
361: wsh_interface_grp.delivery_detail_action(
362: p_api_version_number => p_api_version,
363: p_init_msg_list => FND_API.G_FALSE,
364: p_commit => FND_API.G_FALSE,
365: x_return_status => l_return_status,
366: x_msg_count => l_msg_count,
367: x_msg_data => l_msg_data,
360:
361: wsh_interface_grp.delivery_detail_action(
362: p_api_version_number => p_api_version,
363: p_init_msg_list => FND_API.G_FALSE,
364: p_commit => FND_API.G_FALSE,
365: x_return_status => l_return_status,
366: x_msg_count => l_msg_count,
367: x_msg_data => l_msg_data,
368: p_detail_id_tab => l_detail_ids,
388: IF l_number_of_warnings > 0 THEN
389: x_return_status := wsh_util_core.g_ret_sts_warning;
390: END IF;
391:
392: IF FND_API.TO_BOOLEAN(p_commit) THEN
393: -- dbms_output.put_line('commit');
394: COMMIT WORK;
395: END IF;
396:
397: FND_MSG_PUB.Count_And_Get
398: (
399: p_count => x_msg_count,
400: p_data => x_msg_data,
401: p_encoded => FND_API.G_FALSE
402: );
403:
404: IF l_debug_on THEN
405: WSH_DEBUG_SV.pop(l_module_name);
405: WSH_DEBUG_SV.pop(l_module_name);
406: END IF;
407: --
408: exception
409: WHEN FND_API.G_EXC_ERROR THEN
410: ROLLBACK TO SPLIT_LINE_PUB;
411: x_return_status := FND_API.G_RET_STS_ERROR ;
412: wsh_util_core.add_message(x_return_status);
413: FND_MSG_PUB.Count_And_Get
407: --
408: exception
409: WHEN FND_API.G_EXC_ERROR THEN
410: ROLLBACK TO SPLIT_LINE_PUB;
411: x_return_status := FND_API.G_RET_STS_ERROR ;
412: wsh_util_core.add_message(x_return_status);
413: FND_MSG_PUB.Count_And_Get
414: (
415: p_count => x_msg_count,
413: FND_MSG_PUB.Count_And_Get
414: (
415: p_count => x_msg_count,
416: p_data => x_msg_data,
417: p_encoded => FND_API.G_FALSE
418: );
419:
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
417: p_encoded => FND_API.G_FALSE
418: );
419:
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
423: END IF;
424: --
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: );
419:
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
423: END IF;
424: --
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: ROLLBACK TO SPLIT_LINE_PUB;
421: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
423: END IF;
424: --
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: ROLLBACK TO SPLIT_LINE_PUB;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: wsh_util_core.add_message(x_return_status, l_module_name);
429: FND_MSG_PUB.Count_And_Get
423: END IF;
424: --
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: ROLLBACK TO SPLIT_LINE_PUB;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: wsh_util_core.add_message(x_return_status, l_module_name);
429: FND_MSG_PUB.Count_And_Get
430: (
431: p_count => x_msg_count,
429: FND_MSG_PUB.Count_And_Get
430: (
431: p_count => x_msg_count,
432: p_data => x_msg_data,
433: p_encoded => FND_API.G_FALSE
434: );
435: --
436:
437: IF l_debug_on THEN
434: );
435: --
436:
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
440: END IF;
441: WHEN OTHERS THEN
442: ROLLBACK TO SPLIT_LINE_PUB;
435: --
436:
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
440: END IF;
441: WHEN OTHERS THEN
442: ROLLBACK TO SPLIT_LINE_PUB;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
440: END IF;
441: WHEN OTHERS THEN
442: ROLLBACK TO SPLIT_LINE_PUB;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: wsh_util_core.add_message(x_return_status, l_module_name);
445: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Split_Line');
446: FND_MSG_PUB.Count_And_Get
447: (
446: FND_MSG_PUB.Count_And_Get
447: (
448: p_count => x_msg_count,
449: p_data => x_msg_data,
450: p_encoded => FND_API.G_FALSE
451: );
452: --
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
462:
463: -- Procedure Init_Changed_Attribute_Rec
464: -- Parameter p_init_rec record that needs to be initialized.
465: -- This procedure takes in a record of WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType and
466: -- initializes its attributes to the default FND_API_G values.
467:
468: Procedure Init_Changed_Attribute_Rec(p_init_rec IN OUT NOCOPY WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType,
469: x_return_status OUT NOCOPY VARCHAR2) IS
470: --
488: WSH_DEBUG_SV.push(l_module_name);
489: END IF;
490: --
491: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
492: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
493: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
494: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
495: p_init_rec.customer_number := FND_API.G_MISS_NUM;
496: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
489: END IF;
490: --
491: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
492: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
493: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
494: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
495: p_init_rec.customer_number := FND_API.G_MISS_NUM;
496: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
497: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
490: --
491: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
492: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
493: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
494: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
495: p_init_rec.customer_number := FND_API.G_MISS_NUM;
496: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
497: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
498: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
491: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
492: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
493: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
494: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
495: p_init_rec.customer_number := FND_API.G_MISS_NUM;
496: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
497: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
498: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
499: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
492: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
493: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
494: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
495: p_init_rec.customer_number := FND_API.G_MISS_NUM;
496: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
497: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
498: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
499: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
500: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
493: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
494: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
495: p_init_rec.customer_number := FND_API.G_MISS_NUM;
496: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
497: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
498: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
499: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
500: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
501: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
494: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
495: p_init_rec.customer_number := FND_API.G_MISS_NUM;
496: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
497: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
498: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
499: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
500: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
501: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
502: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
495: p_init_rec.customer_number := FND_API.G_MISS_NUM;
496: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
497: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
498: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
499: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
500: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
501: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
502: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
503: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
496: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
497: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
498: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
499: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
500: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
501: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
502: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
503: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
504: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
497: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
498: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
499: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
500: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
501: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
502: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
503: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
504: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
505: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
498: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
499: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
500: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
501: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
502: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
503: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
504: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
505: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
506: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
499: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
500: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
501: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
502: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
503: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
504: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
505: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
506: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
507: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
500: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
501: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
502: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
503: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
504: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
505: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
506: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
507: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
508: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
501: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
502: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
503: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
504: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
505: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
506: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
507: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
508: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
509: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
502: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
503: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
504: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
505: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
506: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
507: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
508: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
509: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
510: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
503: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
504: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
505: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
506: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
507: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
508: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
509: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
510: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
511: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
504: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
505: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
506: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
507: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
508: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
509: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
510: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
511: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
512: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
505: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
506: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
507: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
508: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
509: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
510: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
511: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
512: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
513: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
506: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
507: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
508: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
509: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
510: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
511: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
512: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
513: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
514: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
507: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
508: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
509: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
510: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
511: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
512: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
513: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
514: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
515: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
508: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
509: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
510: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
511: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
512: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
513: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
514: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
515: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
516: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
509: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
510: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
511: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
512: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
513: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
514: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
515: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
516: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
517: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
510: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
511: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
512: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
513: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
514: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
515: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
516: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
517: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
518: p_init_rec.revision := FND_API.G_MISS_CHAR;
511: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
512: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
513: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
514: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
515: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
516: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
517: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
518: p_init_rec.revision := FND_API.G_MISS_CHAR;
519: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
512: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
513: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
514: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
515: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
516: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
517: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
518: p_init_rec.revision := FND_API.G_MISS_CHAR;
519: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
520: -- HW OPMCONV - No need for sublot_number
513: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
514: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
515: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
516: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
517: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
518: p_init_rec.revision := FND_API.G_MISS_CHAR;
519: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
520: -- HW OPMCONV - No need for sublot_number
521: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
514: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
515: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
516: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
517: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
518: p_init_rec.revision := FND_API.G_MISS_CHAR;
519: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
520: -- HW OPMCONV - No need for sublot_number
521: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
522: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
515: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
516: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
517: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
518: p_init_rec.revision := FND_API.G_MISS_CHAR;
519: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
520: -- HW OPMCONV - No need for sublot_number
521: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
522: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
523: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
517: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
518: p_init_rec.revision := FND_API.G_MISS_CHAR;
519: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
520: -- HW OPMCONV - No need for sublot_number
521: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
522: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
523: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
524: p_init_rec.locator_id := FND_API.G_MISS_NUM;
525: p_init_rec.date_requested := FND_API.G_MISS_DATE;
518: p_init_rec.revision := FND_API.G_MISS_CHAR;
519: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
520: -- HW OPMCONV - No need for sublot_number
521: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
522: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
523: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
524: p_init_rec.locator_id := FND_API.G_MISS_NUM;
525: p_init_rec.date_requested := FND_API.G_MISS_DATE;
526: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
519: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
520: -- HW OPMCONV - No need for sublot_number
521: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
522: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
523: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
524: p_init_rec.locator_id := FND_API.G_MISS_NUM;
525: p_init_rec.date_requested := FND_API.G_MISS_DATE;
526: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
527: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
520: -- HW OPMCONV - No need for sublot_number
521: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
522: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
523: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
524: p_init_rec.locator_id := FND_API.G_MISS_NUM;
525: p_init_rec.date_requested := FND_API.G_MISS_DATE;
526: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
527: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
528: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
521: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
522: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
523: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
524: p_init_rec.locator_id := FND_API.G_MISS_NUM;
525: p_init_rec.date_requested := FND_API.G_MISS_DATE;
526: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
527: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
528: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
529: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
522: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
523: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
524: p_init_rec.locator_id := FND_API.G_MISS_NUM;
525: p_init_rec.date_requested := FND_API.G_MISS_DATE;
526: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
527: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
528: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
529: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
530: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
523: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
524: p_init_rec.locator_id := FND_API.G_MISS_NUM;
525: p_init_rec.date_requested := FND_API.G_MISS_DATE;
526: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
527: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
528: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
529: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
530: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
531: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
524: p_init_rec.locator_id := FND_API.G_MISS_NUM;
525: p_init_rec.date_requested := FND_API.G_MISS_DATE;
526: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
527: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
528: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
529: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
530: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
531: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
532: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
525: p_init_rec.date_requested := FND_API.G_MISS_DATE;
526: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
527: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
528: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
529: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
530: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
531: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
532: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
533: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
526: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
527: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
528: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
529: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
530: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
531: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
532: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
533: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
534: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
527: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
528: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
529: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
530: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
531: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
532: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
533: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
534: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
535: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
528: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
529: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
530: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
531: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
532: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
533: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
534: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
535: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
536: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
529: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
530: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
531: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
532: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
533: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
534: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
535: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
536: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
537: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
530: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
531: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
532: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
533: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
534: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
535: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
536: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
537: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
538: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
531: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
532: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
533: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
534: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
535: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
536: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
537: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
538: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
539: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
532: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
533: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
534: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
535: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
536: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
537: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
538: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
539: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
540: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
533: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
534: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
535: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
536: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
537: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
538: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
539: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
540: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
541: p_init_rec.net_weight := FND_API.G_MISS_NUM;
534: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
535: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
536: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
537: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
538: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
539: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
540: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
541: p_init_rec.net_weight := FND_API.G_MISS_NUM;
542: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
535: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
536: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
537: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
538: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
539: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
540: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
541: p_init_rec.net_weight := FND_API.G_MISS_NUM;
542: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
543: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
536: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
537: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
538: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
539: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
540: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
541: p_init_rec.net_weight := FND_API.G_MISS_NUM;
542: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
543: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
544: p_init_rec.volume := FND_API.G_MISS_NUM;
537: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
538: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
539: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
540: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
541: p_init_rec.net_weight := FND_API.G_MISS_NUM;
542: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
543: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
544: p_init_rec.volume := FND_API.G_MISS_NUM;
545: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
538: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
539: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
540: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
541: p_init_rec.net_weight := FND_API.G_MISS_NUM;
542: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
543: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
544: p_init_rec.volume := FND_API.G_MISS_NUM;
545: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
546: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
539: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
540: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
541: p_init_rec.net_weight := FND_API.G_MISS_NUM;
542: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
543: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
544: p_init_rec.volume := FND_API.G_MISS_NUM;
545: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
546: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
547: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
540: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
541: p_init_rec.net_weight := FND_API.G_MISS_NUM;
542: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
543: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
544: p_init_rec.volume := FND_API.G_MISS_NUM;
545: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
546: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
547: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
548: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
541: p_init_rec.net_weight := FND_API.G_MISS_NUM;
542: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
543: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
544: p_init_rec.volume := FND_API.G_MISS_NUM;
545: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
546: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
547: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
548: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
549: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
542: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
543: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
544: p_init_rec.volume := FND_API.G_MISS_NUM;
545: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
546: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
547: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
548: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
549: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
550: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
543: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
544: p_init_rec.volume := FND_API.G_MISS_NUM;
545: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
546: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
547: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
548: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
549: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
550: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
551: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
544: p_init_rec.volume := FND_API.G_MISS_NUM;
545: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
546: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
547: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
548: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
549: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
550: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
551: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
552: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
545: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
546: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
547: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
548: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
549: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
550: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
551: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
552: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
553: p_init_rec.released_status := FND_API.G_MISS_CHAR;
546: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
547: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
548: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
549: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
550: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
551: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
552: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
553: p_init_rec.released_status := FND_API.G_MISS_CHAR;
554: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
547: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
548: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
549: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
550: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
551: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
552: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
553: p_init_rec.released_status := FND_API.G_MISS_CHAR;
554: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
555: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
548: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
549: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
550: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
551: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
552: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
553: p_init_rec.released_status := FND_API.G_MISS_CHAR;
554: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
555: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
556: p_init_rec.container_name := FND_API.G_MISS_CHAR;
549: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
550: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
551: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
552: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
553: p_init_rec.released_status := FND_API.G_MISS_CHAR;
554: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
555: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
556: p_init_rec.container_name := FND_API.G_MISS_CHAR;
557: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
550: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
551: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
552: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
553: p_init_rec.released_status := FND_API.G_MISS_CHAR;
554: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
555: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
556: p_init_rec.container_name := FND_API.G_MISS_CHAR;
557: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
558: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
551: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
552: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
553: p_init_rec.released_status := FND_API.G_MISS_CHAR;
554: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
555: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
556: p_init_rec.container_name := FND_API.G_MISS_CHAR;
557: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
558: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
559: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
552: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
553: p_init_rec.released_status := FND_API.G_MISS_CHAR;
554: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
555: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
556: p_init_rec.container_name := FND_API.G_MISS_CHAR;
557: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
558: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
559: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
560: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
553: p_init_rec.released_status := FND_API.G_MISS_CHAR;
554: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
555: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
556: p_init_rec.container_name := FND_API.G_MISS_CHAR;
557: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
558: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
559: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
560: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
561: -- HW OPMCONV - Added Qty2
554: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
555: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
556: p_init_rec.container_name := FND_API.G_MISS_CHAR;
557: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
558: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
559: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
560: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
561: -- HW OPMCONV - Added Qty2
562: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
555: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
556: p_init_rec.container_name := FND_API.G_MISS_CHAR;
557: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
558: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
559: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
560: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
561: -- HW OPMCONV - Added Qty2
562: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
563: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
556: p_init_rec.container_name := FND_API.G_MISS_CHAR;
557: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
558: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
559: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
560: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
561: -- HW OPMCONV - Added Qty2
562: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
563: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
564: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
558: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
559: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
560: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
561: -- HW OPMCONV - Added Qty2
562: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
563: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
564: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
565: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
566: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
559: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
560: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
561: -- HW OPMCONV - Added Qty2
562: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
563: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
564: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
565: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
566: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
567: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
560: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
561: -- HW OPMCONV - Added Qty2
562: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
563: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
564: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
565: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
566: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
567: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
568: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
561: -- HW OPMCONV - Added Qty2
562: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
563: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
564: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
565: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
566: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
567: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
568: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
569: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
562: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
563: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
564: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
565: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
566: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
567: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
568: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
569: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
570: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
563: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
564: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
565: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
566: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
567: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
568: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
569: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
570: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
571: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
564: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
565: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
566: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
567: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
568: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
569: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
570: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
571: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
572: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
565: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
566: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
567: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
568: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
569: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
570: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
571: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
572: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
573: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
566: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
567: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
568: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
569: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
570: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
571: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
572: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
573: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
574: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
567: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
568: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
569: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
570: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
571: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
572: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
573: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
574: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
575: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
568: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
569: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
570: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
571: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
572: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
573: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
574: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
575: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
576: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
569: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
570: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
571: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
572: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
573: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
574: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
575: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
576: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
577: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
570: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
571: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
572: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
573: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
574: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
575: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
576: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
577: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
578: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
571: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
572: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
573: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
574: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
575: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
576: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
577: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
578: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
579: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
572: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
573: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
574: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
575: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
576: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
577: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
578: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
579: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
580: -- J: W/V Changes
573: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
574: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
575: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
576: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
577: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
578: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
579: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
580: -- J: W/V Changes
581: p_init_rec.filled_volume := FND_API.G_MISS_NUM;
574: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
575: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
576: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
577: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
578: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
579: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
580: -- J: W/V Changes
581: p_init_rec.filled_volume := FND_API.G_MISS_NUM;
582:
575: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
576: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
577: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
578: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
579: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
580: -- J: W/V Changes
581: p_init_rec.filled_volume := FND_API.G_MISS_NUM;
582:
583: --
577: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
578: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
579: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
580: -- J: W/V Changes
581: p_init_rec.filled_volume := FND_API.G_MISS_NUM;
582:
583: --
584: -- Debug Statements
585: --
694:
695: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
696:
697: -- Standard call to check for call compatibility
698: IF NOT FND_API.Compatible_API_Call(
699: l_api_version_number,
700: p_api_version_number,
701: l_api_name,
702: G_PKG_NAME) THEN
699: l_api_version_number,
700: p_api_version_number,
701: l_api_name,
702: G_PKG_NAME) THEN
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704: END IF;
705:
706: -- Initialize message stack if required
707: IF FND_API.to_Boolean(p_init_msg_list) THEN
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704: END IF;
705:
706: -- Initialize message stack if required
707: IF FND_API.to_Boolean(p_init_msg_list) THEN
708: FND_MSG_PUB.initialize;
709: END IF;
710:
711: --
709: END IF;
710:
711: --
712: -- sperera source_code has to be 'OE' or 'WSH'
713: IF (NVL(p_source_code, FND_API.G_MISS_CHAR) NOT IN ('WSH', 'OE')) THEN
714: RAISE invalid_source_code;
715: END IF;
716:
717:
730: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
731: END IF;
732: wsh_interface_grp.create_update_delivery_detail(
733: p_api_version_number => p_api_version_number,
734: p_init_msg_list => FND_API.G_FALSE,
735: p_commit => FND_API.G_FALSE,
736: x_return_status => l_return_status,
737: x_msg_count => l_msg_count,
738: x_msg_data => l_msg_data,
731: END IF;
732: wsh_interface_grp.create_update_delivery_detail(
733: p_api_version_number => p_api_version_number,
734: p_init_msg_list => FND_API.G_FALSE,
735: p_commit => FND_API.G_FALSE,
736: x_return_status => l_return_status,
737: x_msg_count => l_msg_count,
738: x_msg_data => l_msg_data,
739: p_detail_info_tab => l_detail_info_tab,
756: x_return_status := wsh_util_core.g_ret_sts_warning;
757: END IF;
758:
759: -- report success
760: IF FND_API.TO_BOOLEAN(p_commit) THEN
761: COMMIT WORK;
762: END IF;
763:
764: FND_MSG_PUB.Count_And_Get (
763:
764: FND_MSG_PUB.Count_And_Get (
765: p_count => x_msg_count,
766: p_data => x_msg_data,
767: p_encoded => FND_API.G_FALSE
768: );
769:
770: IF l_debug_on THEN
771: WSH_DEBUG_SV.pop(l_module_name);
771: WSH_DEBUG_SV.pop(l_module_name);
772: END IF;
773: --
774: EXCEPTION
775: WHEN FND_API.G_EXC_ERROR THEN
776: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
777: x_return_status := FND_API.G_RET_STS_ERROR ;
778: wsh_util_core.add_message(x_return_status);
779: FND_MSG_PUB.Count_And_Get
773: --
774: EXCEPTION
775: WHEN FND_API.G_EXC_ERROR THEN
776: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
777: x_return_status := FND_API.G_RET_STS_ERROR ;
778: wsh_util_core.add_message(x_return_status);
779: FND_MSG_PUB.Count_And_Get
780: (
781: p_count => x_msg_count,
779: FND_MSG_PUB.Count_And_Get
780: (
781: p_count => x_msg_count,
782: p_data => x_msg_data,
783: p_encoded => FND_API.G_FALSE
784: );
785:
786: IF l_debug_on THEN
787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
783: p_encoded => FND_API.G_FALSE
784: );
785:
786: IF l_debug_on THEN
787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
788: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
789: END IF;
790: --
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
784: );
785:
786: IF l_debug_on THEN
787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
788: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
789: END IF;
790: --
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
787: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
788: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
789: END IF;
790: --
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
794: wsh_util_core.add_message(x_return_status, l_module_name);
795: FND_MSG_PUB.Count_And_Get
789: END IF;
790: --
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
794: wsh_util_core.add_message(x_return_status, l_module_name);
795: FND_MSG_PUB.Count_And_Get
796: (
797: p_count => x_msg_count,
795: FND_MSG_PUB.Count_And_Get
796: (
797: p_count => x_msg_count,
798: p_data => x_msg_data,
799: p_encoded => FND_API.G_FALSE
800: );
801: --
802:
803: IF l_debug_on THEN
800: );
801: --
802:
803: IF l_debug_on THEN
804: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
805: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
806: END IF;
807: --
808: WHEN invalid_source_code THEN
801: --
802:
803: IF l_debug_on THEN
804: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
805: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
806: END IF;
807: --
808: WHEN invalid_source_code THEN
809: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
806: END IF;
807: --
808: WHEN invalid_source_code THEN
809: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
812: FND_MESSAGE.SET_TOKEN('SOURCE_CODE',p_source_code );
813: WSH_UTIL_CORE.Add_Message(x_return_status);
814:
815: FND_MSG_PUB.Count_And_Get
816: (
817: p_count => x_msg_count,
818: p_data => x_msg_data,
819: p_encoded => FND_API.G_FALSE
820: );
821:
822: IF l_debug_on THEN
823: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
834: FND_MSG_PUB.Count_And_Get
835: (
836: p_count => x_msg_count,
837: p_data => x_msg_data,
838: p_encoded => FND_API.G_FALSE
839: );
840:
841: IF l_debug_on THEN
842: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
940:
941: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
942:
943: -- Standard call to check for call compatibility
944: IF NOT FND_API.Compatible_API_Call(
945: l_api_version_number,
946: p_api_version_number,
947: l_api_name,
948: G_PKG_NAME) THEN
945: l_api_version_number,
946: p_api_version_number,
947: l_api_name,
948: G_PKG_NAME) THEN
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: END IF;
951:
952: -- Initialize message stack if required
953: IF FND_API.to_Boolean(p_init_msg_list) THEN
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: END IF;
951:
952: -- Initialize message stack if required
953: IF FND_API.to_Boolean(p_init_msg_list) THEN
954: FND_MSG_PUB.initialize;
955: END IF;
956:
957: --
955: END IF;
956:
957: --
958: -- sperera source_code has to be 'OE' or 'WSH'
959: IF (NVL(p_source_code, FND_API.G_MISS_CHAR) NOT IN ('WSH', 'OE')) THEN
960: RAISE invalid_source_code;
961: END IF;
962:
963: -- call the copy procedure here
987: END IF;
988:
989: wsh_delivery_details_grp.create_update_delivery_detail(
990: p_api_version_number => p_api_version_number,
991: p_init_msg_list => FND_API.G_FALSE,
992: p_commit => FND_API.G_FALSE,
993: x_return_status => l_return_status,
994: x_msg_count => l_msg_count,
995: x_msg_data => l_msg_data,
988:
989: wsh_delivery_details_grp.create_update_delivery_detail(
990: p_api_version_number => p_api_version_number,
991: p_init_msg_list => FND_API.G_FALSE,
992: p_commit => FND_API.G_FALSE,
993: x_return_status => l_return_status,
994: x_msg_count => l_msg_count,
995: x_msg_data => l_msg_data,
996: p_detail_info_tab => l_detail_info_tab,
1014: IF l_number_of_warnings > 0 THEN
1015: x_return_status := wsh_util_core.g_ret_sts_warning;
1016: END IF;
1017: -- report success
1018: IF FND_API.TO_BOOLEAN(p_commit) THEN
1019: COMMIT WORK;
1020: END IF;
1021:
1022: FND_MSG_PUB.Count_And_Get (
1021:
1022: FND_MSG_PUB.Count_And_Get (
1023: p_count => x_msg_count,
1024: p_data => x_msg_data,
1025: p_encoded => FND_API.G_FALSE
1026: );
1027:
1028: IF l_debug_on THEN
1029: WSH_DEBUG_SV.pop(l_module_name);
1029: WSH_DEBUG_SV.pop(l_module_name);
1030: END IF;
1031: --
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1035: x_return_status := FND_API.G_RET_STS_ERROR ;
1036: wsh_util_core.add_message(x_return_status);
1037: FND_MSG_PUB.Count_And_Get
1031: --
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1035: x_return_status := FND_API.G_RET_STS_ERROR ;
1036: wsh_util_core.add_message(x_return_status);
1037: FND_MSG_PUB.Count_And_Get
1038: (
1039: p_count => x_msg_count,
1037: FND_MSG_PUB.Count_And_Get
1038: (
1039: p_count => x_msg_count,
1040: p_data => x_msg_data,
1041: p_encoded => FND_API.G_FALSE
1042: );
1043:
1044: IF l_debug_on THEN
1045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1041: p_encoded => FND_API.G_FALSE
1042: );
1043:
1044: IF l_debug_on THEN
1045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1047: END IF;
1048: --
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: );
1043:
1044: IF l_debug_on THEN
1045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1047: END IF;
1048: --
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1047: END IF;
1048: --
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1052: wsh_util_core.add_message(x_return_status, l_module_name);
1053: FND_MSG_PUB.Count_And_Get
1047: END IF;
1048: --
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1052: wsh_util_core.add_message(x_return_status, l_module_name);
1053: FND_MSG_PUB.Count_And_Get
1054: (
1055: p_count => x_msg_count,
1053: FND_MSG_PUB.Count_And_Get
1054: (
1055: p_count => x_msg_count,
1056: p_data => x_msg_data,
1057: p_encoded => FND_API.G_FALSE
1058: );
1059: --
1060:
1061: IF l_debug_on THEN
1058: );
1059: --
1060:
1061: IF l_debug_on THEN
1062: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1063: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1064: END IF;
1065: --
1066: WHEN invalid_source_code THEN
1059: --
1060:
1061: IF l_debug_on THEN
1062: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1063: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1064: END IF;
1065: --
1066: WHEN invalid_source_code THEN
1067: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1064: END IF;
1065: --
1066: WHEN invalid_source_code THEN
1067: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
1070: FND_MESSAGE.SET_TOKEN('SOURCE_CODE',p_source_code );
1071: WSH_UTIL_CORE.Add_Message(x_return_status);
1072:
1073: FND_MSG_PUB.Count_And_Get
1074: (
1075: p_count => x_msg_count,
1076: p_data => x_msg_data,
1077: p_encoded => FND_API.G_FALSE
1078: );
1079:
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1092: FND_MSG_PUB.Count_And_Get
1093: (
1094: p_count => x_msg_count,
1095: p_data => x_msg_data,
1096: p_encoded => FND_API.G_FALSE
1097: );
1098: IF l_debug_on THEN
1099: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1100: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1245: END IF;
1246: --
1247:
1248:
1249: IF NOT FND_API.compatible_api_call(
1250: l_api_version_number,
1251: p_api_version_number,
1252: l_api_name,
1253: G_PKG_NAME) THEN
1250: l_api_version_number,
1251: p_api_version_number,
1252: l_api_name,
1253: G_PKG_NAME) THEN
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256:
1257: -- Check p_init_msg_list
1258: IF FND_API.to_boolean(p_init_msg_list) THEN
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1255: END IF;
1256:
1257: -- Check p_init_msg_list
1258: IF FND_API.to_boolean(p_init_msg_list) THEN
1259: FND_MSG_PUB.initialize;
1260: END IF;
1261: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1262:
1271: END IF;
1272:
1273: wsh_interface_grp.delivery_detail_action(
1274: p_api_version_number => p_api_version_number,
1275: p_init_msg_list => FND_API.G_FALSE,
1276: p_commit => FND_API.G_FALSE,
1277: x_return_status => l_return_status,
1278: x_msg_count => l_msg_count,
1279: x_msg_data => l_msg_data,
1272:
1273: wsh_interface_grp.delivery_detail_action(
1274: p_api_version_number => p_api_version_number,
1275: p_init_msg_list => FND_API.G_FALSE,
1276: p_commit => FND_API.G_FALSE,
1277: x_return_status => l_return_status,
1278: x_msg_count => l_msg_count,
1279: x_msg_data => l_msg_data,
1280: p_detail_id_tab => p_line_rows,
1302: FND_MSG_PUB.Count_And_Get
1303: (
1304: p_count => x_msg_count,
1305: p_data => x_msg_data,
1306: p_encoded => FND_API.G_FALSE
1307: );
1308:
1309:
1310: IF FND_API.TO_BOOLEAN(p_commit) THEN
1306: p_encoded => FND_API.G_FALSE
1307: );
1308:
1309:
1310: IF FND_API.TO_BOOLEAN(p_commit) THEN
1311: COMMIT WORK;
1312: END IF;
1313:
1314:
1316: WSH_DEBUG_SV.pop(l_module_name);
1317: END IF;
1318: --
1319: EXCEPTION
1320: WHEN FND_API.G_EXC_ERROR THEN
1321: ROLLBACK TO AUTOCREATE_DEL_PUB;
1322: x_return_status := FND_API.G_RET_STS_ERROR ;
1323: wsh_util_core.add_message(x_return_status);
1324: FND_MSG_PUB.Count_And_Get
1318: --
1319: EXCEPTION
1320: WHEN FND_API.G_EXC_ERROR THEN
1321: ROLLBACK TO AUTOCREATE_DEL_PUB;
1322: x_return_status := FND_API.G_RET_STS_ERROR ;
1323: wsh_util_core.add_message(x_return_status);
1324: FND_MSG_PUB.Count_And_Get
1325: (
1326: p_count => x_msg_count,
1324: FND_MSG_PUB.Count_And_Get
1325: (
1326: p_count => x_msg_count,
1327: p_data => x_msg_data,
1328: p_encoded => FND_API.G_FALSE
1329: );
1330:
1331: IF l_debug_on THEN
1332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1328: p_encoded => FND_API.G_FALSE
1329: );
1330:
1331: IF l_debug_on THEN
1332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1334: END IF;
1335:
1336: WHEN autocreate_delivery_failed THEN
1329: );
1330:
1331: IF l_debug_on THEN
1332: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1333: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1334: END IF;
1335:
1336: WHEN autocreate_delivery_failed THEN
1337: ROLLBACK TO AUTOCREATE_DEL_PUB;
1339: FND_MSG_PUB.Count_And_Get
1340: (
1341: p_count => x_msg_count,
1342: p_data => x_msg_data,
1343: p_encoded => FND_API.G_FALSE
1344: );
1345:
1346: IF l_debug_on THEN
1347: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_DELIVERY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1347: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_DELIVERY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_DELIVERY_FAILED');
1349: END IF;
1350:
1351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1352: ROLLBACK TO AUTOCREATE_DEL_PUB;
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1354: wsh_util_core.add_message(x_return_status, l_module_name);
1355: FND_MSG_PUB.Count_And_Get
1349: END IF;
1350:
1351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1352: ROLLBACK TO AUTOCREATE_DEL_PUB;
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1354: wsh_util_core.add_message(x_return_status, l_module_name);
1355: FND_MSG_PUB.Count_And_Get
1356: (
1357: p_count => x_msg_count,
1355: FND_MSG_PUB.Count_And_Get
1356: (
1357: p_count => x_msg_count,
1358: p_data => x_msg_data,
1359: p_encoded => FND_API.G_FALSE
1360: );
1361: --
1362:
1363: IF l_debug_on THEN
1360: );
1361: --
1362:
1363: IF l_debug_on THEN
1364: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1365: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1366: END IF;
1367: WHEN OTHERS THEN
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: --
1362:
1363: IF l_debug_on THEN
1364: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1365: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1366: END IF;
1367: WHEN OTHERS THEN
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: ROLLBACK TO AUTOCREATE_DEL_PUB;
1364: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1365: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1366: END IF;
1367: WHEN OTHERS THEN
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369: ROLLBACK TO AUTOCREATE_DEL_PUB;
1370: wsh_util_core.add_message(x_return_status, l_module_name);
1371: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries');
1372: FND_MSG_PUB.Count_And_Get
1372: FND_MSG_PUB.Count_And_Get
1373: (
1374: p_count => x_msg_count,
1375: p_data => x_msg_data,
1376: p_encoded => FND_API.G_FALSE
1377: );
1378: --
1379: IF l_debug_on THEN
1380: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1459:
1460:
1461: WHEN OTHERS THEN
1462:
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1465: wsh_util_core.add_message(x_return_status, l_module_name);
1466: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1467: FND_MSG_PUB.Count_And_Get
1467: FND_MSG_PUB.Count_And_Get
1468: (
1469: p_count => x_msg_count,
1470: p_data => x_msg_data,
1471: p_encoded => FND_API.G_FALSE
1472: );
1473:
1474: IF l_debug_on THEN
1475: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1535: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1536: END IF;
1537: --
1538:
1539: IF NOT FND_API.compatible_api_call(
1540: l_api_version_number,
1541: p_api_version_number,
1542: l_api_name,
1543: G_PKG_NAME) THEN
1540: l_api_version_number,
1541: p_api_version_number,
1542: l_api_name,
1543: G_PKG_NAME) THEN
1544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1545: END IF;
1546:
1547: -- Check p_init_msg_list
1548: IF FND_API.to_boolean(p_init_msg_list) THEN
1544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1545: END IF;
1546:
1547: -- Check p_init_msg_list
1548: IF FND_API.to_boolean(p_init_msg_list) THEN
1549: FND_MSG_PUB.initialize;
1550: END IF;
1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1552:
1561: END IF;
1562:
1563: wsh_interface_grp.delivery_detail_action(
1564: p_api_version_number => p_api_version_number,
1565: p_init_msg_list => FND_API.G_FALSE,
1566: p_commit => FND_API.G_FALSE,
1567: x_return_status => l_return_status,
1568: x_msg_count => l_msg_count,
1569: x_msg_data => l_msg_data,
1562:
1563: wsh_interface_grp.delivery_detail_action(
1564: p_api_version_number => p_api_version_number,
1565: p_init_msg_list => FND_API.G_FALSE,
1566: p_commit => FND_API.G_FALSE,
1567: x_return_status => l_return_status,
1568: x_msg_count => l_msg_count,
1569: x_msg_data => l_msg_data,
1570: p_detail_id_tab => p_line_rows,
1588: IF l_number_of_warnings > 0 THEN
1589: x_return_status := wsh_util_core.g_ret_sts_warning;
1590: END IF;
1591:
1592: IF FND_API.TO_BOOLEAN(p_commit) THEN
1593: COMMIT WORK;
1594: END IF;
1595:
1596: FND_MSG_PUB.Count_And_Get
1596: FND_MSG_PUB.Count_And_Get
1597: (
1598: p_count => x_msg_count,
1599: p_data => x_msg_data,
1600: p_encoded => FND_API.G_FALSE
1601: );
1602:
1603:
1604: IF l_debug_on THEN
1605: WSH_DEBUG_SV.pop(l_module_name);
1606: END IF;
1607:
1608: EXCEPTION
1609: WHEN FND_API.G_EXC_ERROR THEN
1610: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1611: x_return_status := FND_API.G_RET_STS_ERROR ;
1612: wsh_util_core.add_message(x_return_status);
1613: FND_MSG_PUB.Count_And_Get
1607:
1608: EXCEPTION
1609: WHEN FND_API.G_EXC_ERROR THEN
1610: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1611: x_return_status := FND_API.G_RET_STS_ERROR ;
1612: wsh_util_core.add_message(x_return_status);
1613: FND_MSG_PUB.Count_And_Get
1614: (
1615: p_count => x_msg_count,
1613: FND_MSG_PUB.Count_And_Get
1614: (
1615: p_count => x_msg_count,
1616: p_data => x_msg_data,
1617: p_encoded => FND_API.G_FALSE
1618: );
1619:
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1617: p_encoded => FND_API.G_FALSE
1618: );
1619:
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1623: END IF;
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1618: );
1619:
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1623: END IF;
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1621: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1623: END IF;
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1628: wsh_util_core.add_message(x_return_status, l_module_name);
1629: FND_MSG_PUB.Count_And_Get
1623: END IF;
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1628: wsh_util_core.add_message(x_return_status, l_module_name);
1629: FND_MSG_PUB.Count_And_Get
1630: (
1631: p_count => x_msg_count,
1629: FND_MSG_PUB.Count_And_Get
1630: (
1631: p_count => x_msg_count,
1632: p_data => x_msg_data,
1633: p_encoded => FND_API.G_FALSE
1634: );
1635: --
1636:
1637: IF l_debug_on THEN
1634: );
1635: --
1636:
1637: IF l_debug_on THEN
1638: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1640: END IF;
1641:
1642:
1635: --
1636:
1637: IF l_debug_on THEN
1638: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1640: END IF;
1641:
1642:
1643: WHEN autocreate_trip_failed THEN
1646: FND_MSG_PUB.Count_And_Get
1647: (
1648: p_count => x_msg_count,
1649: p_data => x_msg_data,
1650: p_encoded => FND_API.G_FALSE
1651: );
1652:
1653: IF l_debug_on THEN
1654: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_TRIP_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1656: END IF;
1657:
1658: WHEN OTHERS THEN
1659:
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1662: wsh_util_core.add_message(x_return_status, l_module_name);
1663: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1664: FND_MSG_PUB.Count_And_Get
1664: FND_MSG_PUB.Count_And_Get
1665: (
1666: p_count => x_msg_count,
1667: p_data => x_msg_data,
1668: p_encoded => FND_API.G_FALSE
1669: );
1670: --
1671: IF l_debug_on THEN
1672: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1803: /* Start of fix for Bug 2766446
1804: For those attributes that are not available in public api record,
1805: need to send G_MISS values so that the database values are used for such attributes */
1806:
1807: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;
1808: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
1809: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
1810: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
1811: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
1804: For those attributes that are not available in public api record,
1805: need to send G_MISS values so that the database values are used for such attributes */
1806:
1807: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;
1808: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
1809: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
1810: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
1811: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
1812: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
1805: need to send G_MISS values so that the database values are used for such attributes */
1806:
1807: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;
1808: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
1809: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
1810: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
1811: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
1812: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
1813: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
1806:
1807: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;
1808: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
1809: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
1810: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
1811: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
1812: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
1813: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
1814: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
1807: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;
1808: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
1809: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
1810: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
1811: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
1812: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
1813: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
1814: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
1815: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
1808: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
1809: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
1810: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
1811: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
1812: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
1813: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
1814: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
1815: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
1816: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
1809: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
1810: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
1811: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
1812: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
1813: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
1814: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
1815: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
1816: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
1817: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
1810: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
1811: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
1812: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
1813: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
1814: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
1815: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
1816: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
1817: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
1818: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
1811: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
1812: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
1813: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
1814: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
1815: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
1816: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
1817: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
1818: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
1819: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
1812: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
1813: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
1814: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
1815: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
1816: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
1817: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
1818: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
1819: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
1820: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
1813: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
1814: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
1815: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
1816: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
1817: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
1818: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
1819: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
1820: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
1821: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
1814: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
1815: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
1816: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
1817: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
1818: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
1819: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
1820: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
1821: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
1822: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
1815: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
1816: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
1817: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
1818: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
1819: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
1820: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
1821: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
1822: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
1823: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
1816: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
1817: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
1818: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
1819: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
1820: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
1821: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
1822: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
1823: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
1824: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
1817: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
1818: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
1819: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
1820: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
1821: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
1822: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
1823: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
1824: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
1825: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
1818: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
1819: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
1820: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
1821: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
1822: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
1823: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
1824: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
1825: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
1826: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
1819: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
1820: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
1821: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
1822: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
1823: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
1824: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
1825: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
1826: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
1827: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
1820: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
1821: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
1822: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
1823: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
1824: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
1825: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
1826: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
1827: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
1828: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
1821: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
1822: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
1823: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
1824: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
1825: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
1826: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
1827: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
1828: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
1829: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
1822: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
1823: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
1824: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
1825: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
1826: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
1827: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
1828: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
1829: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
1830: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
1823: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
1824: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
1825: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
1826: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
1827: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
1828: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
1829: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
1830: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
1831: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
1824: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
1825: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
1826: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
1827: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
1828: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
1829: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
1830: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
1831: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
1832: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
1825: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
1826: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
1827: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
1828: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
1829: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
1830: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
1831: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
1832: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
1833: -- Bug 4146352 : Need to comment seal_code as this is now added to
1826: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
1827: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
1828: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
1829: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
1830: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
1831: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
1832: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
1833: -- Bug 4146352 : Need to comment seal_code as this is now added to
1834: -- the public api record structure.
1827: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
1828: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
1829: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
1830: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
1831: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
1832: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
1833: -- Bug 4146352 : Need to comment seal_code as this is now added to
1834: -- the public api record structure.
1835: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
1828: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
1829: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
1830: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
1831: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
1832: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
1833: -- Bug 4146352 : Need to comment seal_code as this is now added to
1834: -- the public api record structure.
1835: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
1836: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
1831: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
1832: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
1833: -- Bug 4146352 : Need to comment seal_code as this is now added to
1834: -- the public api record structure.
1835: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
1836: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
1837: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
1838: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
1839: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
1832: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
1833: -- Bug 4146352 : Need to comment seal_code as this is now added to
1834: -- the public api record structure.
1835: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
1836: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
1837: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
1838: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
1839: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
1840: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
1833: -- Bug 4146352 : Need to comment seal_code as this is now added to
1834: -- the public api record structure.
1835: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
1836: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
1837: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
1838: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
1839: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
1840: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
1841: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
1834: -- the public api record structure.
1835: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
1836: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
1837: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
1838: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
1839: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
1840: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
1841: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
1842: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
1835: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
1836: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
1837: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
1838: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
1839: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
1840: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
1841: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
1842: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
1843: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
1836: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
1837: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
1838: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
1839: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
1840: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
1841: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
1842: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
1843: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
1844: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
1837: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
1838: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
1839: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
1840: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
1841: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
1842: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
1843: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
1844: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
1845: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
1838: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
1839: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
1840: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
1841: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
1842: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
1843: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
1844: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
1845: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
1846: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
1839: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
1840: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
1841: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
1842: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
1843: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
1844: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
1845: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
1846: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
1847: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
1840: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
1841: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
1842: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
1843: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
1844: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
1845: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
1846: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
1847: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
1848: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
1841: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
1842: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
1843: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
1844: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
1845: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
1846: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
1847: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
1848: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
1849: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
1842: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
1843: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
1844: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
1845: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
1846: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
1847: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
1848: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
1849: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
1850: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
1843: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
1844: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
1845: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
1846: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
1847: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
1848: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
1849: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
1850: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
1851: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
1844: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
1845: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
1846: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
1847: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
1848: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
1849: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
1850: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
1851: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
1852: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
1845: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
1846: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
1847: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
1848: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
1849: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
1850: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
1851: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
1852: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
1853: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
1846: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
1847: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
1848: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
1849: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
1850: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
1851: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
1852: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
1853: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
1854: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
1847: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
1848: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
1849: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
1850: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
1851: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
1852: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
1853: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
1854: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
1855: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
1848: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
1849: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
1850: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
1851: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
1852: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
1853: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
1854: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
1855: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
1856: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
1849: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
1850: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
1851: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
1852: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
1853: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
1854: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
1855: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
1856: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
1857: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
1850: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
1851: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
1852: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
1853: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
1854: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
1855: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
1856: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
1857: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
1858: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
1851: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
1852: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
1853: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
1854: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
1855: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
1856: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
1857: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
1858: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
1859: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
1852: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
1853: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
1854: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
1855: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
1856: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
1857: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
1858: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
1859: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
1860: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1853: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
1854: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
1855: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
1856: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
1857: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
1858: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
1859: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
1860: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1861: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
1854: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
1855: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
1856: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
1857: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
1858: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
1859: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
1860: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1861: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
1862: -- Bug 4146352 : Need to comment seal_code as this is now added to
1855: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
1856: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
1857: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
1858: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
1859: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
1860: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1861: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
1862: -- Bug 4146352 : Need to comment seal_code as this is now added to
1863: -- the public api record structure.
1856: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
1857: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
1858: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
1859: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
1860: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1861: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
1862: -- Bug 4146352 : Need to comment seal_code as this is now added to
1863: -- the public api record structure.
1864: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
1857: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
1858: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
1859: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
1860: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1861: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
1862: -- Bug 4146352 : Need to comment seal_code as this is now added to
1863: -- the public api record structure.
1864: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
1865: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
1860: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1861: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
1862: -- Bug 4146352 : Need to comment seal_code as this is now added to
1863: -- the public api record structure.
1864: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
1865: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
1866: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
1867: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
1868: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
1861: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
1862: -- Bug 4146352 : Need to comment seal_code as this is now added to
1863: -- the public api record structure.
1864: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
1865: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
1866: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
1867: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
1868: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
1869: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
1862: -- Bug 4146352 : Need to comment seal_code as this is now added to
1863: -- the public api record structure.
1864: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
1865: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
1866: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
1867: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
1868: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
1869: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
1870: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
1863: -- the public api record structure.
1864: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
1865: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
1866: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
1867: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
1868: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
1869: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
1870: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
1871: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
1864: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
1865: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
1866: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
1867: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
1868: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
1869: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
1870: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
1871: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
1872: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
1865: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
1866: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
1867: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
1868: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
1869: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
1870: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
1871: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
1872: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
1873: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
1866: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
1867: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
1868: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
1869: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
1870: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
1871: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
1872: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
1873: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
1874: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
1867: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
1868: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
1869: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
1870: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
1871: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
1872: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
1873: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
1874: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
1875: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
1868: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
1869: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
1870: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
1871: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
1872: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
1873: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
1874: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
1875: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
1876: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
1869: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
1870: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
1871: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
1872: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
1873: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
1874: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
1875: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
1876: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
1877: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1870: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
1871: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
1872: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
1873: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
1874: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
1875: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
1876: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
1877: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1878: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
1871: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
1872: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
1873: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
1874: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
1875: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
1876: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
1877: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1878: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
1879: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
1872: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
1873: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
1874: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
1875: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
1876: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
1877: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1878: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
1879: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
1880: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
1873: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
1874: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
1875: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
1876: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
1877: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1878: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
1879: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
1880: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
1881: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
1874: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
1875: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
1876: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
1877: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1878: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
1879: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
1880: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
1881: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
1882: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
1875: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
1876: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
1877: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1878: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
1879: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
1880: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
1881: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
1882: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
1883: -- J: W/V Changes
1876: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
1877: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1878: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
1879: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
1880: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
1881: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
1882: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
1883: -- J: W/V Changes
1884: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;
1877: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
1878: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
1879: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
1880: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
1881: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
1882: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
1883: -- J: W/V Changes
1884: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;
1885: x_detail_info_tab(l_index).unit_volume := FND_API.G_MISS_NUM;
1878: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
1879: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
1880: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
1881: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
1882: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
1883: -- J: W/V Changes
1884: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;
1885: x_detail_info_tab(l_index).unit_volume := FND_API.G_MISS_NUM;
1886:
1880: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
1881: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
1882: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
1883: -- J: W/V Changes
1884: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;
1885: x_detail_info_tab(l_index).unit_volume := FND_API.G_MISS_NUM;
1886:
1887: /* End of fix for Bug 2766446 */
1888:
1881: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
1882: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
1883: -- J: W/V Changes
1884: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;
1885: x_detail_info_tab(l_index).unit_volume := FND_API.G_MISS_NUM;
1886:
1887: /* End of fix for Bug 2766446 */
1888:
1889: l_index := x_changed_attributes.NEXT(l_index);
1894: END IF;
1895:
1896: EXCEPTION
1897:
1898: WHEN FND_API.G_EXC_ERROR THEN
1899:
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1902: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1897:
1898: WHEN FND_API.G_EXC_ERROR THEN
1899:
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1902: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1903: END IF;
1904: raise;
1905:
1898: WHEN FND_API.G_EXC_ERROR THEN
1899:
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1902: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1903: END IF;
1904: raise;
1905:
1906: