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

APPS.WSH_DELIVERY_DETAILS_PUB dependencies on FND_API

Line 106: IF NOT FND_API.compatible_api_call( l_api_version,

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;

Line 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

Line 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;

Line 146: p_init_msg_list => FND_API.G_FALSE,

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,

Line 147: p_commit => FND_API.G_FALSE,

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,

Line 171: IF FND_API.TO_BOOLEAN(p_commit) THEN

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:

Line 180: p_encoded => FND_API.G_FALSE

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);

Line 188: WHEN FND_API.G_EXC_ERROR THEN

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

Line 190: x_return_status := FND_API.G_RET_STS_ERROR ;

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,

Line 196: p_encoded => FND_API.G_FALSE

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);

Line 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

Line 201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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;

Line 213: p_encoded => FND_API.G_FALSE

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);

Line 221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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,

Line 229: p_encoded => FND_API.G_FALSE

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

Line 234: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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;

Line 235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

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');

Line 245: p_encoded => FND_API.G_FALSE

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);

Line 356: IF NOT FND_API.compatible_api_call(l_api_version,

352: WSH_DEBUG_SV.log(l_module_name,'X_SPLIT_QUANTITY2',X_SPLIT_QUANTITY2);
353: END IF;
354: --
355:
356: IF NOT FND_API.compatible_api_call(l_api_version,
357: p_api_version,
358: l_api_name,
359: G_PKG_NAME) THEN
360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

356: IF NOT FND_API.compatible_api_call(l_api_version,
357: p_api_version,
358: l_api_name,
359: G_PKG_NAME) THEN
360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: END IF;
362: -- Check p_init_msg_list
363: IF FND_API.to_boolean(p_init_msg_list) THEN
364: FND_MSG_PUB.initialize;

Line 363: IF FND_API.to_boolean(p_init_msg_list) THEN

359: G_PKG_NAME) THEN
360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: END IF;
362: -- Check p_init_msg_list
363: IF FND_API.to_boolean(p_init_msg_list) THEN
364: FND_MSG_PUB.initialize;
365: END IF;
366: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
367:

Line 409: RAISE FND_API.G_EXC_ERROR;

405:
406: END IF;
407:
408: IF l_return <> 1 THEN
409: RAISE FND_API.G_EXC_ERROR;
410: END IF;
411: END IF;
412: --MUOM : BUG : 16806520 : End of Changes
413:

Line 421: p_init_msg_list => FND_API.G_FALSE,

417: END IF;
418:
419: wsh_interface_grp.delivery_detail_action(
420: p_api_version_number => p_api_version,
421: p_init_msg_list => FND_API.G_FALSE,
422: p_commit => FND_API.G_FALSE,
423: x_return_status => l_return_status,
424: x_msg_count => l_msg_count,
425: x_msg_data => l_msg_data,

Line 422: p_commit => FND_API.G_FALSE,

418:
419: wsh_interface_grp.delivery_detail_action(
420: p_api_version_number => p_api_version,
421: p_init_msg_list => FND_API.G_FALSE,
422: p_commit => FND_API.G_FALSE,
423: x_return_status => l_return_status,
424: x_msg_count => l_msg_count,
425: x_msg_data => l_msg_data,
426: p_detail_id_tab => l_detail_ids,

Line 450: IF FND_API.TO_BOOLEAN(p_commit) THEN

446: IF l_number_of_warnings > 0 THEN
447: x_return_status := wsh_util_core.g_ret_sts_warning;
448: END IF;
449:
450: IF FND_API.TO_BOOLEAN(p_commit) THEN
451: -- dbms_output.put_line('commit');
452: COMMIT WORK;
453: END IF;
454:

Line 459: p_encoded => FND_API.G_FALSE

455: FND_MSG_PUB.Count_And_Get
456: (
457: p_count => x_msg_count,
458: p_data => x_msg_data,
459: p_encoded => FND_API.G_FALSE
460: );
461:
462: IF l_debug_on THEN
463: WSH_DEBUG_SV.pop(l_module_name);

Line 467: WHEN FND_API.G_EXC_ERROR THEN

463: WSH_DEBUG_SV.pop(l_module_name);
464: END IF;
465: --
466: exception
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO SPLIT_LINE_PUB;
469: x_return_status := FND_API.G_RET_STS_ERROR ;
470: wsh_util_core.add_message(x_return_status);
471: FND_MSG_PUB.Count_And_Get

Line 469: x_return_status := FND_API.G_RET_STS_ERROR ;

465: --
466: exception
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO SPLIT_LINE_PUB;
469: x_return_status := FND_API.G_RET_STS_ERROR ;
470: wsh_util_core.add_message(x_return_status);
471: FND_MSG_PUB.Count_And_Get
472: (
473: p_count => x_msg_count,

Line 475: p_encoded => FND_API.G_FALSE

471: FND_MSG_PUB.Count_And_Get
472: (
473: p_count => x_msg_count,
474: p_data => x_msg_data,
475: p_encoded => FND_API.G_FALSE
476: );
477:
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 479: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

475: p_encoded => FND_API.G_FALSE
476: );
477:
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
480: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
481: END IF;
482: --
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 480: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

476: );
477:
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
480: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
481: END IF;
482: --
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO SPLIT_LINE_PUB;

Line 483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

479: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
480: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
481: END IF;
482: --
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO SPLIT_LINE_PUB;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: wsh_util_core.add_message(x_return_status, l_module_name);
487: FND_MSG_PUB.Count_And_Get

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

481: END IF;
482: --
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO SPLIT_LINE_PUB;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: wsh_util_core.add_message(x_return_status, l_module_name);
487: FND_MSG_PUB.Count_And_Get
488: (
489: p_count => x_msg_count,

Line 491: p_encoded => FND_API.G_FALSE

487: FND_MSG_PUB.Count_And_Get
488: (
489: p_count => x_msg_count,
490: p_data => x_msg_data,
491: p_encoded => FND_API.G_FALSE
492: );
493: --
494:
495: IF l_debug_on THEN

Line 496: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

492: );
493: --
494:
495: IF l_debug_on THEN
496: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
498: END IF;
499: WHEN OTHERS THEN
500: ROLLBACK TO SPLIT_LINE_PUB;

Line 497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

493: --
494:
495: IF l_debug_on THEN
496: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
498: END IF;
499: WHEN OTHERS THEN
500: ROLLBACK TO SPLIT_LINE_PUB;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

497: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
498: END IF;
499: WHEN OTHERS THEN
500: ROLLBACK TO SPLIT_LINE_PUB;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: wsh_util_core.add_message(x_return_status, l_module_name);
503: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Split_Line');
504: FND_MSG_PUB.Count_And_Get
505: (

Line 508: p_encoded => FND_API.G_FALSE

504: FND_MSG_PUB.Count_And_Get
505: (
506: p_count => x_msg_count,
507: p_data => x_msg_data,
508: p_encoded => FND_API.G_FALSE
509: );
510: --
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 524: -- initializes its attributes to the default FND_API_G values.

520:
521: -- Procedure Init_Changed_Attribute_Rec
522: -- Parameter p_init_rec record that needs to be initialized.
523: -- This procedure takes in a record of WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType and
524: -- initializes its attributes to the default FND_API_G values.
525:
526: Procedure Init_Changed_Attribute_Rec(p_init_rec IN OUT NOCOPY WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType,
527: x_return_status OUT NOCOPY VARCHAR2) IS
528: --

Line 550: p_init_rec.source_header_id := FND_API.G_MISS_NUM;

546: WSH_DEBUG_SV.push(l_module_name);
547: END IF;
548: --
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
550: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
551: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
552: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
553: p_init_rec.customer_number := FND_API.G_MISS_NUM;
554: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;

Line 551: p_init_rec.source_line_id := FND_API.G_MISS_NUM;

547: END IF;
548: --
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
550: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
551: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
552: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
553: p_init_rec.customer_number := FND_API.G_MISS_NUM;
554: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
555: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;

Line 552: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;

548: --
549: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
550: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
551: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
552: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
553: p_init_rec.customer_number := FND_API.G_MISS_NUM;
554: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
555: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
556: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;

Line 553: p_init_rec.customer_number := FND_API.G_MISS_NUM;

549: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
550: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
551: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
552: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
553: p_init_rec.customer_number := FND_API.G_MISS_NUM;
554: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
555: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
556: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
557: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;

Line 554: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;

550: p_init_rec.source_header_id := FND_API.G_MISS_NUM;
551: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
552: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
553: p_init_rec.customer_number := FND_API.G_MISS_NUM;
554: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
555: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
556: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
557: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
558: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;

Line 555: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;

551: p_init_rec.source_line_id := FND_API.G_MISS_NUM;
552: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
553: p_init_rec.customer_number := FND_API.G_MISS_NUM;
554: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
555: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
556: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
557: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
558: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
559: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;

Line 556: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;

552: p_init_rec.sold_to_org_id := FND_API.G_MISS_NUM;
553: p_init_rec.customer_number := FND_API.G_MISS_NUM;
554: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
555: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
556: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
557: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
558: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
559: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
560: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;

Line 557: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;

553: p_init_rec.customer_number := FND_API.G_MISS_NUM;
554: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
555: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
556: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
557: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
558: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
559: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
560: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
561: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;

Line 558: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;

554: p_init_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
555: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
556: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
557: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
558: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
559: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
560: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
561: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
562: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;

Line 559: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;

555: p_init_rec.ship_from_org_id := FND_API.G_MISS_NUM;
556: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
557: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
558: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
559: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
560: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
561: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
562: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
563: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;

Line 560: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;

556: p_init_rec.ship_from_org_code := FND_API.G_MISS_CHAR;
557: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
558: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
559: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
560: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
561: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
562: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
563: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
564: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;

Line 561: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;

557: p_init_rec.ship_to_org_id := FND_API.G_MISS_NUM;
558: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
559: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
560: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
561: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
562: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
563: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
564: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
565: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;

Line 562: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;

558: p_init_rec.ship_to_org_code := FND_API.G_MISS_CHAR;
559: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
560: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
561: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
562: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
563: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
564: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
565: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
566: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;

Line 563: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;

559: p_init_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
560: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
561: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
562: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
563: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
564: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
565: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
566: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
567: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;

Line 564: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;

560: p_init_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
561: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
562: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
563: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
564: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
565: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
566: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
567: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
568: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;

Line 565: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;

561: p_init_rec.deliver_to_org_code := FND_API.G_MISS_CHAR;
562: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
563: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
564: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
565: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
566: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
567: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
568: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
569: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;

Line 566: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;

562: p_init_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
563: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
564: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
565: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
566: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
567: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
568: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
569: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
570: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;

Line 567: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;

563: p_init_rec.intmed_ship_to_org_id := FND_API.G_MISS_NUM;
564: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
565: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
566: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
567: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
568: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
569: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
570: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;

Line 568: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;

564: p_init_rec.intmed_ship_to_org_code := FND_API.G_MISS_CHAR;
565: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
566: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
567: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
568: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
569: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
570: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
572: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;

Line 569: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;

565: p_init_rec.intmed_ship_to_contact_id := FND_API.G_MISS_NUM;
566: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
567: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
568: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
569: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
570: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
572: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
573: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;

Line 570: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;

566: p_init_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
567: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
568: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
569: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
570: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
572: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
573: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
574: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;

Line 571: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;

567: p_init_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
568: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
569: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
570: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
572: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
573: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
574: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
575: p_init_rec.subinventory := FND_API.G_MISS_CHAR;

Line 572: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;

568: p_init_rec.ordered_quantity := FND_API.G_MISS_NUM;
569: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
570: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
572: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
573: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
574: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
575: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
576: p_init_rec.revision := FND_API.G_MISS_CHAR;

Line 573: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;

569: p_init_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
570: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
572: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
573: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
574: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
575: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
576: p_init_rec.revision := FND_API.G_MISS_CHAR;
577: p_init_rec.lot_number := FND_API.G_MISS_CHAR;

Line 574: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;

570: p_init_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
571: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
572: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
573: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
574: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
575: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
576: p_init_rec.revision := FND_API.G_MISS_CHAR;
577: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
578: -- HW OPMCONV - No need for sublot_number

Line 575: p_init_rec.subinventory := FND_API.G_MISS_CHAR;

571: p_init_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
572: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
573: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
574: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
575: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
576: p_init_rec.revision := FND_API.G_MISS_CHAR;
577: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
578: -- HW OPMCONV - No need for sublot_number
579: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;

Line 576: p_init_rec.revision := FND_API.G_MISS_CHAR;

572: p_init_rec.preferred_grade := FND_API.G_MISS_CHAR;
573: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
574: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
575: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
576: p_init_rec.revision := FND_API.G_MISS_CHAR;
577: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
578: -- HW OPMCONV - No need for sublot_number
579: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
580: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;

Line 577: p_init_rec.lot_number := FND_API.G_MISS_CHAR;

573: p_init_rec.ordered_qty_unit_of_measure := FND_API.G_MISS_CHAR;
574: p_init_rec.ordered_qty_unit_of_measure2 := FND_API.G_MISS_CHAR;
575: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
576: p_init_rec.revision := FND_API.G_MISS_CHAR;
577: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
578: -- HW OPMCONV - No need for sublot_number
579: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
580: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
581: p_init_rec.serial_number := FND_API.G_MISS_CHAR;

Line 579: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;

575: p_init_rec.subinventory := FND_API.G_MISS_CHAR;
576: p_init_rec.revision := FND_API.G_MISS_CHAR;
577: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
578: -- HW OPMCONV - No need for sublot_number
579: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
580: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
581: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
582: p_init_rec.locator_id := FND_API.G_MISS_NUM;
583: p_init_rec.date_requested := FND_API.G_MISS_DATE;

Line 580: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;

576: p_init_rec.revision := FND_API.G_MISS_CHAR;
577: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
578: -- HW OPMCONV - No need for sublot_number
579: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
580: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
581: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
582: p_init_rec.locator_id := FND_API.G_MISS_NUM;
583: p_init_rec.date_requested := FND_API.G_MISS_DATE;
584: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;

Line 581: p_init_rec.serial_number := FND_API.G_MISS_CHAR;

577: p_init_rec.lot_number := FND_API.G_MISS_CHAR;
578: -- HW OPMCONV - No need for sublot_number
579: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
580: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
581: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
582: p_init_rec.locator_id := FND_API.G_MISS_NUM;
583: p_init_rec.date_requested := FND_API.G_MISS_DATE;
584: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
585: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;

Line 582: p_init_rec.locator_id := FND_API.G_MISS_NUM;

578: -- HW OPMCONV - No need for sublot_number
579: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
580: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
581: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
582: p_init_rec.locator_id := FND_API.G_MISS_NUM;
583: p_init_rec.date_requested := FND_API.G_MISS_DATE;
584: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
585: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
586: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;

Line 583: p_init_rec.date_requested := FND_API.G_MISS_DATE;

579: -- p_init_rec.sublot_number := FND_API.G_MISS_CHAR;
580: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
581: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
582: p_init_rec.locator_id := FND_API.G_MISS_NUM;
583: p_init_rec.date_requested := FND_API.G_MISS_DATE;
584: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
585: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
586: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
587: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;

Line 584: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;

580: p_init_rec.customer_requested_lot_flag := FND_API.G_MISS_CHAR;
581: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
582: p_init_rec.locator_id := FND_API.G_MISS_NUM;
583: p_init_rec.date_requested := FND_API.G_MISS_DATE;
584: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
585: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
586: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
587: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
588: p_init_rec.carrier_id := FND_API.G_MISS_NUM;

Line 585: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;

581: p_init_rec.serial_number := FND_API.G_MISS_CHAR;
582: p_init_rec.locator_id := FND_API.G_MISS_NUM;
583: p_init_rec.date_requested := FND_API.G_MISS_DATE;
584: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
585: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
586: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
587: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
588: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
589: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;

Line 586: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;

582: p_init_rec.locator_id := FND_API.G_MISS_NUM;
583: p_init_rec.date_requested := FND_API.G_MISS_DATE;
584: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
585: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
586: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
587: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
588: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
589: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
590: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;

Line 587: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;

583: p_init_rec.date_requested := FND_API.G_MISS_DATE;
584: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
585: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
586: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
587: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
588: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
589: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
590: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
591: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;

Line 588: p_init_rec.carrier_id := FND_API.G_MISS_NUM;

584: p_init_rec.date_scheduled := FND_API.G_MISS_DATE;
585: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
586: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
587: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
588: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
589: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
590: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
591: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
592: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;

Line 589: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;

585: p_init_rec.master_container_item_id := FND_API.G_MISS_NUM;
586: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
587: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
588: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
589: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
590: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
591: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
592: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
593: p_init_rec.fob_code := FND_API.G_MISS_CHAR;

Line 590: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;

586: p_init_rec.detail_container_item_id := FND_API.G_MISS_NUM;
587: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
588: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
589: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
590: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
591: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
592: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
593: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
594: p_init_rec.fob_name := FND_API.G_MISS_CHAR;

Line 591: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;

587: p_init_rec.shipping_method_code := FND_API.G_MISS_CHAR;
588: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
589: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
590: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
591: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
592: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
593: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
594: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
595: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;

Line 592: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;

588: p_init_rec.carrier_id := FND_API.G_MISS_NUM;
589: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
590: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
591: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
592: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
593: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
594: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
595: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
596: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;

Line 593: p_init_rec.fob_code := FND_API.G_MISS_CHAR;

589: p_init_rec.freight_terms_code := FND_API.G_MISS_CHAR;
590: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
591: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
592: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
593: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
594: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
595: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
596: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
597: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;

Line 594: p_init_rec.fob_name := FND_API.G_MISS_CHAR;

590: p_init_rec.freight_terms_name := FND_API.G_MISS_CHAR;
591: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
592: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
593: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
594: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
595: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
596: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
597: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
598: p_init_rec.gross_weight := FND_API.G_MISS_NUM;

Line 595: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;

591: p_init_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
592: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
593: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
594: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
595: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
596: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
597: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
598: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
599: p_init_rec.net_weight := FND_API.G_MISS_NUM;

Line 596: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;

592: p_init_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
593: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
594: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
595: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
596: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
597: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
598: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
599: p_init_rec.net_weight := FND_API.G_MISS_NUM;
600: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;

Line 597: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;

593: p_init_rec.fob_code := FND_API.G_MISS_CHAR;
594: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
595: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
596: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
597: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
598: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
599: p_init_rec.net_weight := FND_API.G_MISS_NUM;
600: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
601: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;

Line 598: p_init_rec.gross_weight := FND_API.G_MISS_NUM;

594: p_init_rec.fob_name := FND_API.G_MISS_CHAR;
595: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
596: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
597: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
598: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
599: p_init_rec.net_weight := FND_API.G_MISS_NUM;
600: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
601: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
602: p_init_rec.volume := FND_API.G_MISS_NUM;

Line 599: p_init_rec.net_weight := FND_API.G_MISS_NUM;

595: p_init_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
596: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
597: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
598: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
599: p_init_rec.net_weight := FND_API.G_MISS_NUM;
600: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
601: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
602: p_init_rec.volume := FND_API.G_MISS_NUM;
603: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;

Line 600: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;

596: p_init_rec.customer_prod_seq := FND_API.G_MISS_CHAR;
597: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
598: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
599: p_init_rec.net_weight := FND_API.G_MISS_NUM;
600: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
601: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
602: p_init_rec.volume := FND_API.G_MISS_NUM;
603: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
604: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;

Line 601: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;

597: p_init_rec.customer_dock_code := FND_API.G_MISS_CHAR;
598: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
599: p_init_rec.net_weight := FND_API.G_MISS_NUM;
600: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
601: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
602: p_init_rec.volume := FND_API.G_MISS_NUM;
603: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
604: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
605: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;

Line 602: p_init_rec.volume := FND_API.G_MISS_NUM;

598: p_init_rec.gross_weight := FND_API.G_MISS_NUM;
599: p_init_rec.net_weight := FND_API.G_MISS_NUM;
600: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
601: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
602: p_init_rec.volume := FND_API.G_MISS_NUM;
603: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
604: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
605: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
606: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;

Line 603: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;

599: p_init_rec.net_weight := FND_API.G_MISS_NUM;
600: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
601: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
602: p_init_rec.volume := FND_API.G_MISS_NUM;
603: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
604: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
605: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
606: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
607: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;

Line 604: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;

600: p_init_rec.weight_uom_code := FND_API.G_MISS_CHAR;
601: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
602: p_init_rec.volume := FND_API.G_MISS_NUM;
603: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
604: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
605: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
606: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
607: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
608: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;

Line 605: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;

601: p_init_rec.weight_uom_desc := FND_API.G_MISS_CHAR;
602: p_init_rec.volume := FND_API.G_MISS_NUM;
603: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
604: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
605: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
606: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
607: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
608: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
609: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;

Line 606: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;

602: p_init_rec.volume := FND_API.G_MISS_NUM;
603: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
604: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
605: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
606: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
607: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
608: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
609: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
610: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;

Line 607: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;

603: p_init_rec.volume_uom_code := FND_API.G_MISS_CHAR;
604: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
605: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
606: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
607: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
608: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
609: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
610: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
611: p_init_rec.released_status := FND_API.G_MISS_CHAR;

Line 608: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;

604: p_init_rec.volume_uom_desc := FND_API.G_MISS_CHAR;
605: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
606: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
607: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
608: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
609: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
610: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
611: p_init_rec.released_status := FND_API.G_MISS_CHAR;
612: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;

Line 609: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;

605: p_init_rec.top_model_line_id := FND_API.G_MISS_NUM;
606: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
607: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
608: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
609: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
610: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
611: p_init_rec.released_status := FND_API.G_MISS_CHAR;
612: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
613: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;

Line 610: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;

606: p_init_rec.ship_set_id := FND_API.G_MISS_NUM;
607: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
608: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
609: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
610: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
611: p_init_rec.released_status := FND_API.G_MISS_CHAR;
612: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
613: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
614: p_init_rec.container_name := FND_API.G_MISS_CHAR;

Line 611: p_init_rec.released_status := FND_API.G_MISS_CHAR;

607: p_init_rec.ato_line_id := FND_API.G_MISS_NUM;
608: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
609: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
610: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
611: p_init_rec.released_status := FND_API.G_MISS_CHAR;
612: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
613: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
614: p_init_rec.container_name := FND_API.G_MISS_CHAR;
615: p_init_rec.container_flag := FND_API.G_MISS_CHAR;

Line 612: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;

608: p_init_rec.arrival_set_id := FND_API.G_MISS_NUM;
609: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
610: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
611: p_init_rec.released_status := FND_API.G_MISS_CHAR;
612: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
613: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
614: p_init_rec.container_name := FND_API.G_MISS_CHAR;
615: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
616: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;

Line 613: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;

609: p_init_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
610: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
611: p_init_rec.released_status := FND_API.G_MISS_CHAR;
612: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
613: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
614: p_init_rec.container_name := FND_API.G_MISS_CHAR;
615: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
616: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
617: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;

Line 614: p_init_rec.container_name := FND_API.G_MISS_CHAR;

610: p_init_rec.cust_po_number := FND_API.G_MISS_CHAR;
611: p_init_rec.released_status := FND_API.G_MISS_CHAR;
612: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
613: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
614: p_init_rec.container_name := FND_API.G_MISS_CHAR;
615: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
616: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
617: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
618: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;

Line 615: p_init_rec.container_flag := FND_API.G_MISS_CHAR;

611: p_init_rec.released_status := FND_API.G_MISS_CHAR;
612: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
613: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
614: p_init_rec.container_name := FND_API.G_MISS_CHAR;
615: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
616: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
617: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
618: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
619: -- HW OPMCONV - Added Qty2

Line 616: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;

612: p_init_rec.packing_instructions := FND_API.G_MISS_CHAR;
613: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
614: p_init_rec.container_name := FND_API.G_MISS_CHAR;
615: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
616: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
617: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
618: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
619: -- HW OPMCONV - Added Qty2
620: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;

Line 617: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;

613: p_init_rec.shipping_instructions := FND_API.G_MISS_CHAR;
614: p_init_rec.container_name := FND_API.G_MISS_CHAR;
615: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
616: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
617: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
618: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
619: -- HW OPMCONV - Added Qty2
620: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
621: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;

Line 618: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;

614: p_init_rec.container_name := FND_API.G_MISS_CHAR;
615: p_init_rec.container_flag := FND_API.G_MISS_CHAR;
616: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
617: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
618: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
619: -- HW OPMCONV - Added Qty2
620: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
621: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
622: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;

Line 620: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;

616: p_init_rec.delivery_detail_id := FND_API.G_MISS_NUM;
617: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
618: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
619: -- HW OPMCONV - Added Qty2
620: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
621: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
622: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
623: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
624: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 621: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;

617: p_init_rec.shipped_quantity := FND_API.G_MISS_NUM;
618: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
619: -- HW OPMCONV - Added Qty2
620: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
621: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
622: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
623: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
624: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
625: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 622: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;

618: p_init_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
619: -- HW OPMCONV - Added Qty2
620: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
621: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
622: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
623: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
624: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
625: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
626: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 623: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;

619: -- HW OPMCONV - Added Qty2
620: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
621: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
622: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
623: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
624: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
625: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
626: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
627: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 624: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;

620: p_init_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
621: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
622: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
623: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
624: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
625: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
626: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
627: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
628: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 625: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;

621: p_init_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
622: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
623: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
624: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
625: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
626: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
627: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
628: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
629: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 626: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;

622: p_init_rec.tracking_number := FND_API.G_MISS_CHAR;
623: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
624: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
625: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
626: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
627: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
628: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
629: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
630: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 627: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;

623: p_init_rec.attribute1 := FND_API.G_MISS_CHAR;
624: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
625: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
626: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
627: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
628: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
629: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
630: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
631: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 628: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;

624: p_init_rec.attribute2 := FND_API.G_MISS_CHAR;
625: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
626: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
627: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
628: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
629: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
630: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
631: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
632: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 629: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;

625: p_init_rec.attribute3 := FND_API.G_MISS_CHAR;
626: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
627: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
628: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
629: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
630: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
631: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
632: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
633: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 630: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;

626: p_init_rec.attribute4 := FND_API.G_MISS_CHAR;
627: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
628: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
629: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
630: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
631: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
632: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
633: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
634: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 631: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;

627: p_init_rec.attribute5 := FND_API.G_MISS_CHAR;
628: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
629: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
630: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
631: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
632: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
633: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
634: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
635: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 632: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;

628: p_init_rec.attribute6 := FND_API.G_MISS_CHAR;
629: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
630: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
631: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
632: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
633: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
634: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
635: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
636: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 633: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;

629: p_init_rec.attribute7 := FND_API.G_MISS_CHAR;
630: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
631: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
632: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
633: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
634: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
635: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
636: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
637: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 634: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;

630: p_init_rec.attribute8 := FND_API.G_MISS_CHAR;
631: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
632: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
633: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
634: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
635: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
636: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
637: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
638: -- J: W/V Changes

Line 635: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;

631: p_init_rec.attribute9 := FND_API.G_MISS_CHAR;
632: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
633: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
634: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
635: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
636: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
637: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
638: -- J: W/V Changes
639: p_init_rec.filled_volume := FND_API.G_MISS_NUM;

Line 636: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;

632: p_init_rec.attribute10 := FND_API.G_MISS_CHAR;
633: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
634: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
635: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
636: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
637: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
638: -- J: W/V Changes
639: p_init_rec.filled_volume := FND_API.G_MISS_NUM;
640:

Line 637: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;

633: p_init_rec.attribute11 := FND_API.G_MISS_CHAR;
634: p_init_rec.attribute12 := FND_API.G_MISS_CHAR;
635: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
636: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
637: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
638: -- J: W/V Changes
639: p_init_rec.filled_volume := FND_API.G_MISS_NUM;
640:
641: --

Line 639: p_init_rec.filled_volume := FND_API.G_MISS_NUM;

635: p_init_rec.attribute13 := FND_API.G_MISS_CHAR;
636: p_init_rec.attribute14 := FND_API.G_MISS_CHAR;
637: p_init_rec.attribute15 := FND_API.G_MISS_CHAR;
638: -- J: W/V Changes
639: p_init_rec.filled_volume := FND_API.G_MISS_NUM;
640:
641: --
642: -- Debug Statements
643: --

Line 770: IF NOT FND_API.Compatible_API_Call(

766:
767: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
768:
769: -- Standard call to check for call compatibility
770: IF NOT FND_API.Compatible_API_Call(
771: l_api_version_number,
772: p_api_version_number,
773: l_api_name,
774: G_PKG_NAME) THEN

Line 775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

771: l_api_version_number,
772: p_api_version_number,
773: l_api_name,
774: G_PKG_NAME) THEN
775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: -- Initialize message stack if required
779: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 779: IF FND_API.to_Boolean(p_init_msg_list) THEN

775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
776: END IF;
777:
778: -- Initialize message stack if required
779: IF FND_API.to_Boolean(p_init_msg_list) THEN
780: FND_MSG_PUB.initialize;
781: END IF;
782:
783: --

Line 833: RAISE FND_API.G_EXC_ERROR;

829: p_raise_error_flag => FALSE
830: );
831: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
832: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835:
836: END IF;
837: EXCEPTION

Line 838: WHEN FND_API.G_EXC_ERROR THEN

834: END IF;
835:
836: END IF;
837: EXCEPTION
838: WHEN FND_API.G_EXC_ERROR THEN
839: ROLLBACK TO before_lock;
840: IF l_debug_on THEN
841: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
842: END IF;

Line 841: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);

837: EXCEPTION
838: WHEN FND_API.G_EXC_ERROR THEN
839: ROLLBACK TO before_lock;
840: IF l_debug_on THEN
841: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
842: END IF;
843: RAISE FND_API.G_EXC_ERROR ;
844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
845: ROLLBACK TO before_lock;

Line 843: RAISE FND_API.G_EXC_ERROR ;

839: ROLLBACK TO before_lock;
840: IF l_debug_on THEN
841: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
842: END IF;
843: RAISE FND_API.G_EXC_ERROR ;
844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
845: ROLLBACK TO before_lock;
846: IF l_debug_on THEN
847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

840: IF l_debug_on THEN
841: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
842: END IF;
843: RAISE FND_API.G_EXC_ERROR ;
844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
845: ROLLBACK TO before_lock;
846: IF l_debug_on THEN
847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
848: END IF;

Line 847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

843: RAISE FND_API.G_EXC_ERROR ;
844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
845: ROLLBACK TO before_lock;
846: IF l_debug_on THEN
847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
848: END IF;
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: WHEN OTHERS THEN
851: ROLLBACK TO before_lock;

Line 849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

845: ROLLBACK TO before_lock;
846: IF l_debug_on THEN
847: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
848: END IF;
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850: WHEN OTHERS THEN
851: ROLLBACK TO before_lock;
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: IF l_debug_on THEN
853: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
854: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
855: END IF;
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END;
858:
859: /* Patchset I: Harmonization Project. Call group API
860: All validations done by Group API */

Line 867: p_init_msg_list => FND_API.G_FALSE,

863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: wsh_interface_grp.create_update_delivery_detail(
866: p_api_version_number => p_api_version_number,
867: p_init_msg_list => FND_API.G_FALSE,
868: p_commit => FND_API.G_FALSE,
869: x_return_status => l_return_status,
870: x_msg_count => l_msg_count,
871: x_msg_data => l_msg_data,

Line 868: p_commit => FND_API.G_FALSE,

864: END IF;
865: wsh_interface_grp.create_update_delivery_detail(
866: p_api_version_number => p_api_version_number,
867: p_init_msg_list => FND_API.G_FALSE,
868: p_commit => FND_API.G_FALSE,
869: x_return_status => l_return_status,
870: x_msg_count => l_msg_count,
871: x_msg_data => l_msg_data,
872: p_detail_info_tab => l_detail_info_tab,

Line 893: IF FND_API.TO_BOOLEAN(p_commit) THEN

889: x_return_status := wsh_util_core.g_ret_sts_warning;
890: END IF;
891:
892: -- report success
893: IF FND_API.TO_BOOLEAN(p_commit) THEN
894: COMMIT WORK;
895: END IF;
896:
897: FND_MSG_PUB.Count_And_Get (

Line 900: p_encoded => FND_API.G_FALSE

896:
897: FND_MSG_PUB.Count_And_Get (
898: p_count => x_msg_count,
899: p_data => x_msg_data,
900: p_encoded => FND_API.G_FALSE
901: );
902:
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.pop(l_module_name);

Line 908: WHEN FND_API.G_EXC_ERROR THEN

904: WSH_DEBUG_SV.pop(l_module_name);
905: END IF;
906: --
907: EXCEPTION
908: WHEN FND_API.G_EXC_ERROR THEN
909: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
910: x_return_status := FND_API.G_RET_STS_ERROR ;
911: wsh_util_core.add_message(x_return_status);
912: FND_MSG_PUB.Count_And_Get

Line 910: x_return_status := FND_API.G_RET_STS_ERROR ;

906: --
907: EXCEPTION
908: WHEN FND_API.G_EXC_ERROR THEN
909: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
910: x_return_status := FND_API.G_RET_STS_ERROR ;
911: wsh_util_core.add_message(x_return_status);
912: FND_MSG_PUB.Count_And_Get
913: (
914: p_count => x_msg_count,

Line 916: p_encoded => FND_API.G_FALSE

912: FND_MSG_PUB.Count_And_Get
913: (
914: p_count => x_msg_count,
915: p_data => x_msg_data,
916: p_encoded => FND_API.G_FALSE
917: );
918:
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 920: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

916: p_encoded => FND_API.G_FALSE
917: );
918:
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
922: END IF;
923: --
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

917: );
918:
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
922: END IF;
923: --
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
925: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line 924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

920: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
922: END IF;
923: --
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
925: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
927: wsh_util_core.add_message(x_return_status, l_module_name);
928: FND_MSG_PUB.Count_And_Get

Line 926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

922: END IF;
923: --
924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
925: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
927: wsh_util_core.add_message(x_return_status, l_module_name);
928: FND_MSG_PUB.Count_And_Get
929: (
930: p_count => x_msg_count,

Line 932: p_encoded => FND_API.G_FALSE

928: FND_MSG_PUB.Count_And_Get
929: (
930: p_count => x_msg_count,
931: p_data => x_msg_data,
932: p_encoded => FND_API.G_FALSE
933: );
934: --
935:
936: IF l_debug_on THEN

Line 937: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

933: );
934: --
935:
936: IF l_debug_on THEN
937: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
938: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
939: END IF;
940: --
941: WHEN invalid_source_code THEN

Line 938: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

934: --
935:
936: IF l_debug_on THEN
937: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
938: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
939: END IF;
940: --
941: WHEN invalid_source_code THEN
942: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;

Line 943: x_return_status := FND_API.G_RET_STS_ERROR;

939: END IF;
940: --
941: WHEN invalid_source_code THEN
942: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB;
943: x_return_status := FND_API.G_RET_STS_ERROR;
944: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
945: FND_MESSAGE.SET_TOKEN('SOURCE_CODE',p_source_code );
946: WSH_UTIL_CORE.Add_Message(x_return_status);
947: --RTV changes

Line 956: p_encoded => FND_API.G_FALSE

952: FND_MSG_PUB.Count_And_Get
953: (
954: p_count => x_msg_count,
955: p_data => x_msg_data,
956: p_encoded => FND_API.G_FALSE
957: );
958:
959: IF l_debug_on THEN
960: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 975: p_encoded => FND_API.G_FALSE

971: FND_MSG_PUB.Count_And_Get
972: (
973: p_count => x_msg_count,
974: p_data => x_msg_data,
975: p_encoded => FND_API.G_FALSE
976: );
977:
978: IF l_debug_on THEN
979: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1095: IF NOT FND_API.Compatible_API_Call(

1091:
1092: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1093:
1094: -- Standard call to check for call compatibility
1095: IF NOT FND_API.Compatible_API_Call(
1096: l_api_version_number,
1097: p_api_version_number,
1098: l_api_name,
1099: G_PKG_NAME) THEN

Line 1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1096: l_api_version_number,
1097: p_api_version_number,
1098: l_api_name,
1099: G_PKG_NAME) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: END IF;
1102:
1103: -- Initialize message stack if required
1104: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1104: IF FND_API.to_Boolean(p_init_msg_list) THEN

1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: END IF;
1102:
1103: -- Initialize message stack if required
1104: IF FND_API.to_Boolean(p_init_msg_list) THEN
1105: FND_MSG_PUB.initialize;
1106: END IF;
1107:
1108: --

Line 1169: RAISE FND_API.G_EXC_ERROR;

1165: p_raise_error_flag => FALSE
1166: );
1167: IF l_return_status <> wsh_util_core.g_ret_sts_success THEN
1168: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
1169: RAISE FND_API.G_EXC_ERROR;
1170: END IF;
1171:
1172: END IF;
1173: EXCEPTION

Line 1174: WHEN FND_API.G_EXC_ERROR THEN

1170: END IF;
1171:
1172: END IF;
1173: EXCEPTION
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: ROLLBACK TO before_lock;
1176: IF l_debug_on THEN
1177: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1178: END IF;

Line 1177: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1173: EXCEPTION
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: ROLLBACK TO before_lock;
1176: IF l_debug_on THEN
1177: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1178: END IF;
1179: RAISE FND_API.G_EXC_ERROR ;
1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1181: ROLLBACK TO before_lock;

Line 1179: RAISE FND_API.G_EXC_ERROR ;

1175: ROLLBACK TO before_lock;
1176: IF l_debug_on THEN
1177: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1178: END IF;
1179: RAISE FND_API.G_EXC_ERROR ;
1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1181: ROLLBACK TO before_lock;
1182: IF l_debug_on THEN
1183: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1176: IF l_debug_on THEN
1177: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1178: END IF;
1179: RAISE FND_API.G_EXC_ERROR ;
1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1181: ROLLBACK TO before_lock;
1182: IF l_debug_on THEN
1183: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1184: END IF;

Line 1183: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1179: RAISE FND_API.G_EXC_ERROR ;
1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1181: ROLLBACK TO before_lock;
1182: IF l_debug_on THEN
1183: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1184: END IF;
1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1186: WHEN OTHERS THEN
1187: ROLLBACK TO before_lock;

Line 1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1181: ROLLBACK TO before_lock;
1182: IF l_debug_on THEN
1183: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1184: END IF;
1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1186: WHEN OTHERS THEN
1187: ROLLBACK TO before_lock;
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1191: END IF;
1192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1193: END;
1194:
1195: /* Patchset I: Harmonization Project. Call group API
1196: All validations done by Group API */

Line 1204: p_init_msg_list => FND_API.G_FALSE,

1200: END IF;
1201:
1202: wsh_delivery_details_grp.create_update_delivery_detail(
1203: p_api_version_number => p_api_version_number,
1204: p_init_msg_list => FND_API.G_FALSE,
1205: p_commit => FND_API.G_FALSE,
1206: x_return_status => l_return_status,
1207: x_msg_count => l_msg_count,
1208: x_msg_data => l_msg_data,

Line 1205: p_commit => FND_API.G_FALSE,

1201:
1202: wsh_delivery_details_grp.create_update_delivery_detail(
1203: p_api_version_number => p_api_version_number,
1204: p_init_msg_list => FND_API.G_FALSE,
1205: p_commit => FND_API.G_FALSE,
1206: x_return_status => l_return_status,
1207: x_msg_count => l_msg_count,
1208: x_msg_data => l_msg_data,
1209: p_detail_info_tab => l_detail_info_tab,

Line 1231: IF FND_API.TO_BOOLEAN(p_commit) THEN

1227: IF l_number_of_warnings > 0 THEN
1228: x_return_status := wsh_util_core.g_ret_sts_warning;
1229: END IF;
1230: -- report success
1231: IF FND_API.TO_BOOLEAN(p_commit) THEN
1232: COMMIT WORK;
1233: END IF;
1234:
1235: FND_MSG_PUB.Count_And_Get (

Line 1238: p_encoded => FND_API.G_FALSE

1234:
1235: FND_MSG_PUB.Count_And_Get (
1236: p_count => x_msg_count,
1237: p_data => x_msg_data,
1238: p_encoded => FND_API.G_FALSE
1239: );
1240:
1241: IF l_debug_on THEN
1242: WSH_DEBUG_SV.pop(l_module_name);

Line 1246: WHEN FND_API.G_EXC_ERROR THEN

1242: WSH_DEBUG_SV.pop(l_module_name);
1243: END IF;
1244: --
1245: EXCEPTION
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1248: x_return_status := FND_API.G_RET_STS_ERROR ;
1249: wsh_util_core.add_message(x_return_status);
1250: FND_MSG_PUB.Count_And_Get

Line 1248: x_return_status := FND_API.G_RET_STS_ERROR ;

1244: --
1245: EXCEPTION
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1248: x_return_status := FND_API.G_RET_STS_ERROR ;
1249: wsh_util_core.add_message(x_return_status);
1250: FND_MSG_PUB.Count_And_Get
1251: (
1252: p_count => x_msg_count,

Line 1254: p_encoded => FND_API.G_FALSE

1250: FND_MSG_PUB.Count_And_Get
1251: (
1252: p_count => x_msg_count,
1253: p_data => x_msg_data,
1254: p_encoded => FND_API.G_FALSE
1255: );
1256:
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1258: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1254: p_encoded => FND_API.G_FALSE
1255: );
1256:
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1259: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1260: END IF;
1261: --
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1259: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1255: );
1256:
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1259: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1260: END IF;
1261: --
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line 1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1258: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1259: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1260: END IF;
1261: --
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265: wsh_util_core.add_message(x_return_status, l_module_name);
1266: FND_MSG_PUB.Count_And_Get

Line 1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1260: END IF;
1261: --
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265: wsh_util_core.add_message(x_return_status, l_module_name);
1266: FND_MSG_PUB.Count_And_Get
1267: (
1268: p_count => x_msg_count,

Line 1270: p_encoded => FND_API.G_FALSE

1266: FND_MSG_PUB.Count_And_Get
1267: (
1268: p_count => x_msg_count,
1269: p_data => x_msg_data,
1270: p_encoded => FND_API.G_FALSE
1271: );
1272: --
1273:
1274: IF l_debug_on THEN

Line 1275: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1271: );
1272: --
1273:
1274: IF l_debug_on THEN
1275: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1277: END IF;
1278: --
1279: WHEN invalid_source_code THEN

Line 1276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1272: --
1273:
1274: IF l_debug_on THEN
1275: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1277: END IF;
1278: --
1279: WHEN invalid_source_code THEN
1280: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;

Line 1281: x_return_status := FND_API.G_RET_STS_ERROR;

1277: END IF;
1278: --
1279: WHEN invalid_source_code THEN
1280: ROLLBACK TO UPDATE_SHIPPING_ATTR_PUB2;
1281: x_return_status := FND_API.G_RET_STS_ERROR;
1282: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_SOURCE_CODE');
1283: FND_MESSAGE.SET_TOKEN('SOURCE_CODE',p_source_code );
1284: WSH_UTIL_CORE.Add_Message(x_return_status);
1285: --RTV changes

Line 1295: p_encoded => FND_API.G_FALSE

1291: FND_MSG_PUB.Count_And_Get
1292: (
1293: p_count => x_msg_count,
1294: p_data => x_msg_data,
1295: p_encoded => FND_API.G_FALSE
1296: );
1297:
1298: IF l_debug_on THEN
1299: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_SOURCE_CODE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1314: p_encoded => FND_API.G_FALSE

1310: FND_MSG_PUB.Count_And_Get
1311: (
1312: p_count => x_msg_count,
1313: p_data => x_msg_data,
1314: p_encoded => FND_API.G_FALSE
1315: );
1316: IF l_debug_on THEN
1317: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1318: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1467: IF NOT FND_API.compatible_api_call(

1463: END IF;
1464: --
1465:
1466:
1467: IF NOT FND_API.compatible_api_call(
1468: l_api_version_number,
1469: p_api_version_number,
1470: l_api_name,
1471: G_PKG_NAME) THEN

Line 1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1468: l_api_version_number,
1469: p_api_version_number,
1470: l_api_name,
1471: G_PKG_NAME) THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1473: END IF;
1474:
1475: -- Check p_init_msg_list
1476: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1476: IF FND_API.to_boolean(p_init_msg_list) THEN

1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1473: END IF;
1474:
1475: -- Check p_init_msg_list
1476: IF FND_API.to_boolean(p_init_msg_list) THEN
1477: FND_MSG_PUB.initialize;
1478: END IF;
1479: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1480:

Line 1493: p_init_msg_list => FND_API.G_FALSE,

1489: END IF;
1490:
1491: wsh_interface_grp.delivery_detail_action(
1492: p_api_version_number => p_api_version_number,
1493: p_init_msg_list => FND_API.G_FALSE,
1494: p_commit => FND_API.G_FALSE,
1495: x_return_status => l_return_status,
1496: x_msg_count => l_msg_count,
1497: x_msg_data => l_msg_data,

Line 1494: p_commit => FND_API.G_FALSE,

1490:
1491: wsh_interface_grp.delivery_detail_action(
1492: p_api_version_number => p_api_version_number,
1493: p_init_msg_list => FND_API.G_FALSE,
1494: p_commit => FND_API.G_FALSE,
1495: x_return_status => l_return_status,
1496: x_msg_count => l_msg_count,
1497: x_msg_data => l_msg_data,
1498: p_detail_id_tab => p_line_rows,

Line 1524: p_encoded => FND_API.G_FALSE

1520: FND_MSG_PUB.Count_And_Get
1521: (
1522: p_count => x_msg_count,
1523: p_data => x_msg_data,
1524: p_encoded => FND_API.G_FALSE
1525: );
1526:
1527:
1528: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1528: IF FND_API.TO_BOOLEAN(p_commit) THEN

1524: p_encoded => FND_API.G_FALSE
1525: );
1526:
1527:
1528: IF FND_API.TO_BOOLEAN(p_commit) THEN
1529: COMMIT WORK;
1530: END IF;
1531:
1532:

Line 1538: WHEN FND_API.G_EXC_ERROR THEN

1534: WSH_DEBUG_SV.pop(l_module_name);
1535: END IF;
1536: --
1537: EXCEPTION
1538: WHEN FND_API.G_EXC_ERROR THEN
1539: ROLLBACK TO AUTOCREATE_DEL_PUB;
1540: x_return_status := FND_API.G_RET_STS_ERROR ;
1541: wsh_util_core.add_message(x_return_status);
1542: FND_MSG_PUB.Count_And_Get

Line 1540: x_return_status := FND_API.G_RET_STS_ERROR ;

1536: --
1537: EXCEPTION
1538: WHEN FND_API.G_EXC_ERROR THEN
1539: ROLLBACK TO AUTOCREATE_DEL_PUB;
1540: x_return_status := FND_API.G_RET_STS_ERROR ;
1541: wsh_util_core.add_message(x_return_status);
1542: FND_MSG_PUB.Count_And_Get
1543: (
1544: p_count => x_msg_count,

Line 1546: p_encoded => FND_API.G_FALSE

1542: FND_MSG_PUB.Count_And_Get
1543: (
1544: p_count => x_msg_count,
1545: p_data => x_msg_data,
1546: p_encoded => FND_API.G_FALSE
1547: );
1548:
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1550: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1546: p_encoded => FND_API.G_FALSE
1547: );
1548:
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1552: END IF;
1553:
1554: WHEN autocreate_delivery_failed THEN

Line 1551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1547: );
1548:
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1552: END IF;
1553:
1554: WHEN autocreate_delivery_failed THEN
1555: ROLLBACK TO AUTOCREATE_DEL_PUB;

Line 1561: p_encoded => FND_API.G_FALSE

1557: FND_MSG_PUB.Count_And_Get
1558: (
1559: p_count => x_msg_count,
1560: p_data => x_msg_data,
1561: p_encoded => FND_API.G_FALSE
1562: );
1563:
1564: IF l_debug_on THEN
1565: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_DELIVERY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1565: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_DELIVERY_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1566: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:AUTOCREATE_DELIVERY_FAILED');
1567: END IF;
1568:
1569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1570: ROLLBACK TO AUTOCREATE_DEL_PUB;
1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1572: wsh_util_core.add_message(x_return_status, l_module_name);
1573: FND_MSG_PUB.Count_And_Get

Line 1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1567: END IF;
1568:
1569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1570: ROLLBACK TO AUTOCREATE_DEL_PUB;
1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1572: wsh_util_core.add_message(x_return_status, l_module_name);
1573: FND_MSG_PUB.Count_And_Get
1574: (
1575: p_count => x_msg_count,

Line 1577: p_encoded => FND_API.G_FALSE

1573: FND_MSG_PUB.Count_And_Get
1574: (
1575: p_count => x_msg_count,
1576: p_data => x_msg_data,
1577: p_encoded => FND_API.G_FALSE
1578: );
1579: --
1580:
1581: IF l_debug_on THEN

Line 1582: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1578: );
1579: --
1580:
1581: IF l_debug_on THEN
1582: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1584: END IF;
1585: WHEN OTHERS THEN
1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1579: --
1580:
1581: IF l_debug_on THEN
1582: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1584: END IF;
1585: WHEN OTHERS THEN
1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1587: ROLLBACK TO AUTOCREATE_DEL_PUB;

Line 1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1582: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1583: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1584: END IF;
1585: WHEN OTHERS THEN
1586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1587: ROLLBACK TO AUTOCREATE_DEL_PUB;
1588: wsh_util_core.add_message(x_return_status, l_module_name);
1589: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Deliveries');
1590: FND_MSG_PUB.Count_And_Get

Line 1594: p_encoded => FND_API.G_FALSE

1590: FND_MSG_PUB.Count_And_Get
1591: (
1592: p_count => x_msg_count,
1593: p_data => x_msg_data,
1594: p_encoded => FND_API.G_FALSE
1595: );
1596: --
1597: IF l_debug_on THEN
1598: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1677:
1678:
1679: WHEN OTHERS THEN
1680:
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1682: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1683: wsh_util_core.add_message(x_return_status, l_module_name);
1684: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1685: FND_MSG_PUB.Count_And_Get

Line 1689: p_encoded => FND_API.G_FALSE

1685: FND_MSG_PUB.Count_And_Get
1686: (
1687: p_count => x_msg_count,
1688: p_data => x_msg_data,
1689: p_encoded => FND_API.G_FALSE
1690: );
1691:
1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1757: IF NOT FND_API.compatible_api_call(

1753: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1754: END IF;
1755: --
1756:
1757: IF NOT FND_API.compatible_api_call(
1758: l_api_version_number,
1759: p_api_version_number,
1760: l_api_name,
1761: G_PKG_NAME) THEN

Line 1762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1758: l_api_version_number,
1759: p_api_version_number,
1760: l_api_name,
1761: G_PKG_NAME) THEN
1762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1763: END IF;
1764:
1765: -- Check p_init_msg_list
1766: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1766: IF FND_API.to_boolean(p_init_msg_list) THEN

1762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1763: END IF;
1764:
1765: -- Check p_init_msg_list
1766: IF FND_API.to_boolean(p_init_msg_list) THEN
1767: FND_MSG_PUB.initialize;
1768: END IF;
1769: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1770:

Line 1783: p_init_msg_list => FND_API.G_FALSE,

1779: END IF;
1780:
1781: wsh_interface_grp.delivery_detail_action(
1782: p_api_version_number => p_api_version_number,
1783: p_init_msg_list => FND_API.G_FALSE,
1784: p_commit => FND_API.G_FALSE,
1785: x_return_status => l_return_status,
1786: x_msg_count => l_msg_count,
1787: x_msg_data => l_msg_data,

Line 1784: p_commit => FND_API.G_FALSE,

1780:
1781: wsh_interface_grp.delivery_detail_action(
1782: p_api_version_number => p_api_version_number,
1783: p_init_msg_list => FND_API.G_FALSE,
1784: p_commit => FND_API.G_FALSE,
1785: x_return_status => l_return_status,
1786: x_msg_count => l_msg_count,
1787: x_msg_data => l_msg_data,
1788: p_detail_id_tab => p_line_rows,

Line 1810: IF FND_API.TO_BOOLEAN(p_commit) THEN

1806: IF l_number_of_warnings > 0 THEN
1807: x_return_status := wsh_util_core.g_ret_sts_warning;
1808: END IF;
1809:
1810: IF FND_API.TO_BOOLEAN(p_commit) THEN
1811: COMMIT WORK;
1812: END IF;
1813:
1814: FND_MSG_PUB.Count_And_Get

Line 1818: p_encoded => FND_API.G_FALSE

1814: FND_MSG_PUB.Count_And_Get
1815: (
1816: p_count => x_msg_count,
1817: p_data => x_msg_data,
1818: p_encoded => FND_API.G_FALSE
1819: );
1820:
1821:
1822: IF l_debug_on THEN

Line 1827: WHEN FND_API.G_EXC_ERROR THEN

1823: WSH_DEBUG_SV.pop(l_module_name);
1824: END IF;
1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1829: x_return_status := FND_API.G_RET_STS_ERROR ;
1830: wsh_util_core.add_message(x_return_status);
1831: FND_MSG_PUB.Count_And_Get

Line 1829: x_return_status := FND_API.G_RET_STS_ERROR ;

1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1829: x_return_status := FND_API.G_RET_STS_ERROR ;
1830: wsh_util_core.add_message(x_return_status);
1831: FND_MSG_PUB.Count_And_Get
1832: (
1833: p_count => x_msg_count,

Line 1835: p_encoded => FND_API.G_FALSE

1831: FND_MSG_PUB.Count_And_Get
1832: (
1833: p_count => x_msg_count,
1834: p_data => x_msg_data,
1835: p_encoded => FND_API.G_FALSE
1836: );
1837:
1838: IF l_debug_on THEN
1839: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1839: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1835: p_encoded => FND_API.G_FALSE
1836: );
1837:
1838: IF l_debug_on THEN
1839: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1840: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1841: END IF;
1842:
1843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1840: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1836: );
1837:
1838: IF l_debug_on THEN
1839: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1840: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1841: END IF;
1842:
1843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1844: ROLLBACK TO AUTOCREATE_TRIP_PUB;

Line 1843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1839: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1840: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1841: END IF;
1842:
1843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1844: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1846: wsh_util_core.add_message(x_return_status, l_module_name);
1847: FND_MSG_PUB.Count_And_Get

Line 1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1841: END IF;
1842:
1843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1844: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1846: wsh_util_core.add_message(x_return_status, l_module_name);
1847: FND_MSG_PUB.Count_And_Get
1848: (
1849: p_count => x_msg_count,

Line 1851: p_encoded => FND_API.G_FALSE

1847: FND_MSG_PUB.Count_And_Get
1848: (
1849: p_count => x_msg_count,
1850: p_data => x_msg_data,
1851: p_encoded => FND_API.G_FALSE
1852: );
1853: --
1854:
1855: IF l_debug_on THEN

Line 1856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1852: );
1853: --
1854:
1855: IF l_debug_on THEN
1856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1858: END IF;
1859:
1860:

Line 1857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1853: --
1854:
1855: IF l_debug_on THEN
1856: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1857: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1858: END IF;
1859:
1860:
1861: WHEN autocreate_trip_failed THEN

Line 1868: p_encoded => FND_API.G_FALSE

1864: FND_MSG_PUB.Count_And_Get
1865: (
1866: p_count => x_msg_count,
1867: p_data => x_msg_data,
1868: p_encoded => FND_API.G_FALSE
1869: );
1870:
1871: IF l_debug_on THEN
1872: WSH_DEBUG_SV.logmsg(l_module_name,'AUTOCREATE_TRIP_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1874: END IF;
1875:
1876: WHEN OTHERS THEN
1877:
1878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1879: ROLLBACK TO AUTOCREATE_TRIP_PUB;
1880: wsh_util_core.add_message(x_return_status, l_module_name);
1881: WSH_UTIL_CORE.default_handler('WSH_DELIVERY_DETAILS_PUB.Autocreate_Del_Trip');
1882: FND_MSG_PUB.Count_And_Get

Line 1886: p_encoded => FND_API.G_FALSE

1882: FND_MSG_PUB.Count_And_Get
1883: (
1884: p_count => x_msg_count,
1885: p_data => x_msg_data,
1886: p_encoded => FND_API.G_FALSE
1887: );
1888: --
1889: IF l_debug_on THEN
1890: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2025: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;

2021: /* Start of fix for Bug 2766446
2022: For those attributes that are not available in public api record,
2023: need to send G_MISS values so that the database values are used for such attributes */
2024:
2025: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;
2026: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
2027: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
2028: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
2029: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;

Line 2026: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;

2022: For those attributes that are not available in public api record,
2023: need to send G_MISS values so that the database values are used for such attributes */
2024:
2025: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;
2026: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
2027: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
2028: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
2029: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
2030: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;

Line 2027: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;

2023: need to send G_MISS values so that the database values are used for such attributes */
2024:
2025: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;
2026: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
2027: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
2028: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
2029: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
2030: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
2031: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;

Line 2028: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;

2024:
2025: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;
2026: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
2027: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
2028: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
2029: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
2030: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
2031: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
2032: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;

Line 2029: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;

2025: x_detail_info_tab(l_index).batch_id := FND_API.G_MISS_NUM;
2026: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
2027: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
2028: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
2029: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
2030: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
2031: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
2032: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
2033: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;

Line 2030: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;

2026: x_detail_info_tab(l_index).cancelled_quantity := FND_API.G_MISS_NUM;
2027: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
2028: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
2029: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
2030: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
2031: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
2032: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
2033: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
2034: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;

Line 2031: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;

2027: x_detail_info_tab(l_index).cancelled_quantity2 := FND_API.G_MISS_NUM;
2028: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
2029: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
2030: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
2031: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
2032: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
2033: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
2034: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
2035: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;

Line 2032: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;

2028: x_detail_info_tab(l_index).classification := FND_API.G_MISS_CHAR;
2029: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
2030: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
2031: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
2032: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
2033: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
2034: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
2035: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
2036: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;

Line 2033: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;

2029: x_detail_info_tab(l_index).commodity_code_cat_id := FND_API.G_MISS_NUM;
2030: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
2031: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
2032: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
2033: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
2034: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
2035: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
2036: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
2037: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;

Line 2034: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;

2030: x_detail_info_tab(l_index).container_type_code := FND_API.G_MISS_CHAR;
2031: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
2032: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
2033: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
2034: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
2035: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
2036: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
2037: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
2038: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;

Line 2035: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;

2031: x_detail_info_tab(l_index).country_of_origin := FND_API.G_MISS_CHAR;
2032: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
2033: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
2034: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
2035: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
2036: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
2037: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
2038: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
2039: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;

Line 2036: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;

2032: x_detail_info_tab(l_index).currency_code := FND_API.G_MISS_CHAR;
2033: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
2034: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
2035: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
2036: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
2037: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
2038: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
2039: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
2040: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;

Line 2037: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;

2033: x_detail_info_tab(l_index).cust_model_serial_number := FND_API.G_MISS_CHAR;
2034: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
2035: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
2036: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
2037: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
2038: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
2039: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
2040: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
2041: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;

Line 2038: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;

2034: x_detail_info_tab(l_index).customer_id := FND_API.G_MISS_NUM;
2035: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
2036: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
2037: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
2038: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
2039: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
2040: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
2041: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
2042: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;

Line 2039: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;

2035: x_detail_info_tab(l_index).customer_item_id := FND_API.G_MISS_NUM;
2036: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
2037: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
2038: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
2039: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
2040: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
2041: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
2042: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
2043: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;

Line 2040: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;

2036: x_detail_info_tab(l_index).customer_job := FND_API.G_MISS_CHAR;
2037: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
2038: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
2039: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
2040: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
2041: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
2042: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
2043: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
2044: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;

Line 2041: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;

2037: x_detail_info_tab(l_index).customer_production_line := FND_API.G_MISS_CHAR;
2038: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
2039: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
2040: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
2041: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
2042: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
2043: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
2044: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
2045: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;

Line 2042: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;

2038: x_detail_info_tab(l_index).deliver_to_location_id := FND_API.G_MISS_NUM;
2039: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
2040: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
2041: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
2042: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
2043: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
2044: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
2045: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
2046: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;

Line 2043: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;

2039: x_detail_info_tab(l_index).deliver_to_site_use_id := FND_API.G_MISS_NUM;
2040: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
2041: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
2042: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
2043: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
2044: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
2045: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
2046: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
2047: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;

Line 2044: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;

2040: x_detail_info_tab(l_index).delivered_quantity := FND_API.G_MISS_NUM;
2041: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
2042: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
2043: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
2044: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
2045: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
2046: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
2047: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
2048: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;

Line 2045: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;

2041: x_detail_info_tab(l_index).delivered_quantity2 := FND_API.G_MISS_NUM;
2042: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
2043: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
2044: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
2045: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
2046: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
2047: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
2048: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
2049: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;

Line 2046: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;

2042: x_detail_info_tab(l_index).freight_class_cat_id := FND_API.G_MISS_NUM;
2043: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
2044: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
2045: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
2046: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
2047: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
2048: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
2049: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
2050: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;

Line 2047: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;

2043: x_detail_info_tab(l_index).fill_percent := FND_API.G_MISS_NUM;
2044: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
2045: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
2046: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
2047: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
2048: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
2049: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
2050: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
2051: -- Bug 4146352 : Need to comment seal_code as this is now added to

Line 2048: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;

2044: x_detail_info_tab(l_index).hazard_class_id := FND_API.G_MISS_NUM;
2045: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
2046: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
2047: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
2048: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
2049: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
2050: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
2051: -- Bug 4146352 : Need to comment seal_code as this is now added to
2052: -- the public api record structure.

Line 2049: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;

2045: x_detail_info_tab(l_index).hold_code := FND_API.G_MISS_CHAR;
2046: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
2047: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
2048: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
2049: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
2050: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
2051: -- Bug 4146352 : Need to comment seal_code as this is now added to
2052: -- the public api record structure.
2053: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;

Line 2050: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;

2046: x_detail_info_tab(l_index).inspection_flag := FND_API.G_MISS_CHAR;
2047: x_detail_info_tab(l_index).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
2048: x_detail_info_tab(l_index).inv_interfaced_flag := FND_API.G_MISS_CHAR;
2049: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
2050: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
2051: -- Bug 4146352 : Need to comment seal_code as this is now added to
2052: -- the public api record structure.
2053: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
2054: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;

Line 2053: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;

2049: x_detail_info_tab(l_index).inventory_item_id := FND_API.G_MISS_NUM;
2050: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
2051: -- Bug 4146352 : Need to comment seal_code as this is now added to
2052: -- the public api record structure.
2053: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
2054: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
2055: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
2056: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
2057: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;

Line 2054: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;

2050: x_detail_info_tab(l_index).item_description := FND_API.G_MISS_CHAR;
2051: -- Bug 4146352 : Need to comment seal_code as this is now added to
2052: -- the public api record structure.
2053: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
2054: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
2055: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
2056: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
2057: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
2058: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;

Line 2055: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;

2051: -- Bug 4146352 : Need to comment seal_code as this is now added to
2052: -- the public api record structure.
2053: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
2054: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
2055: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
2056: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
2057: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
2058: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
2059: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;

Line 2056: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;

2052: -- the public api record structure.
2053: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
2054: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
2055: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
2056: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
2057: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
2058: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
2059: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
2060: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;

Line 2057: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;

2053: -- x_detail_info_tab(l_index).load_seq_number := FND_API.G_MISS_NUM;
2054: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
2055: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
2056: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
2057: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
2058: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
2059: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
2060: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
2061: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;

Line 2058: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;

2054: x_detail_info_tab(l_index).lpn_id := FND_API.G_MISS_NUM;
2055: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
2056: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
2057: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
2058: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
2059: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
2060: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
2061: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
2062: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;

Line 2059: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;

2055: x_detail_info_tab(l_index).master_serial_number := FND_API.G_MISS_CHAR;
2056: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
2057: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
2058: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
2059: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
2060: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
2061: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
2062: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
2063: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;

Line 2060: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;

2056: x_detail_info_tab(l_index).maximum_load_weight := FND_API.G_MISS_NUM;
2057: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
2058: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
2059: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
2060: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
2061: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
2062: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
2063: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
2064: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;

Line 2061: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;

2057: x_detail_info_tab(l_index).maximum_volume := FND_API.G_MISS_NUM;
2058: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
2059: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
2060: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
2061: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
2062: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
2063: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
2064: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
2065: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;

Line 2062: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;

2058: x_detail_info_tab(l_index).minimum_fill_percent := FND_API.G_MISS_NUM;
2059: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
2060: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
2061: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
2062: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
2063: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
2064: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
2065: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
2066: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;

Line 2063: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;

2059: x_detail_info_tab(l_index).move_order_line_id := FND_API.G_MISS_NUM;
2060: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
2061: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
2062: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
2063: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
2064: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
2065: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
2066: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
2067: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;

Line 2064: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;

2060: x_detail_info_tab(l_index).movement_id := FND_API.G_MISS_NUM;
2061: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
2062: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
2063: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
2064: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
2065: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
2066: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
2067: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
2068: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;

Line 2065: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;

2061: x_detail_info_tab(l_index).mvt_stat_status := FND_API.G_MISS_CHAR;
2062: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
2063: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
2064: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
2065: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
2066: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
2067: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
2068: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
2069: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;

Line 2066: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;

2062: x_detail_info_tab(l_index).oe_interfaced_flag := FND_API.G_MISS_CHAR;
2063: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
2064: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
2065: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
2066: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
2067: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
2068: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
2069: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
2070: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;

Line 2067: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;

2063: x_detail_info_tab(l_index).org_id := FND_API.G_MISS_NUM;
2064: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
2065: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
2066: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
2067: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
2068: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
2069: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
2070: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
2071: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;

Line 2068: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;

2064: x_detail_info_tab(l_index).organization_id := FND_API.G_MISS_NUM;
2065: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
2066: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
2067: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
2068: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
2069: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
2070: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
2071: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
2072: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;

Line 2069: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;

2065: x_detail_info_tab(l_index).original_subinventory := FND_API.G_MISS_CHAR;
2066: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
2067: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
2068: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
2069: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
2070: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
2071: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
2072: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
2073: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;

Line 2070: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;

2066: x_detail_info_tab(l_index).pickable_flag := FND_API.G_MISS_CHAR;
2067: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
2068: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
2069: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
2070: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
2071: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
2072: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
2073: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
2074: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;

Line 2071: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;

2067: x_detail_info_tab(l_index).picked_quantity := FND_API.G_MISS_NUM;
2068: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
2069: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
2070: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
2071: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
2072: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
2073: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
2074: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
2075: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;

Line 2072: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;

2068: x_detail_info_tab(l_index).picked_quantity2 := FND_API.G_MISS_NUM;
2069: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
2070: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
2071: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
2072: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
2073: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
2074: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
2075: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
2076: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;

Line 2073: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;

2069: x_detail_info_tab(l_index).project_id := FND_API.G_MISS_NUM;
2070: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
2071: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
2072: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
2073: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
2074: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
2075: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
2076: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
2077: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;

Line 2074: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;

2070: x_detail_info_tab(l_index).quality_control_quantity := FND_API.G_MISS_NUM;
2071: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
2072: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
2073: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
2074: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
2075: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
2076: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
2077: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
2078: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;

Line 2075: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;

2071: x_detail_info_tab(l_index).quality_control_quantity2 := FND_API.G_MISS_NUM;
2072: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
2073: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
2074: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
2075: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
2076: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
2077: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
2078: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2079: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;

Line 2076: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;

2072: x_detail_info_tab(l_index).received_quantity := FND_API.G_MISS_NUM;
2073: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
2074: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
2075: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
2076: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
2077: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
2078: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2079: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
2080: -- Bug 4146352 : Need to comment seal_code as this is now added to

Line 2077: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;

2073: x_detail_info_tab(l_index).received_quantity2 := FND_API.G_MISS_NUM;
2074: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
2075: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
2076: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
2077: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
2078: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2079: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
2080: -- Bug 4146352 : Need to comment seal_code as this is now added to
2081: -- the public api record structure.

Line 2078: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;

2074: x_detail_info_tab(l_index).released_flag := FND_API.G_MISS_CHAR;
2075: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
2076: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
2077: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
2078: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2079: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
2080: -- Bug 4146352 : Need to comment seal_code as this is now added to
2081: -- the public api record structure.
2082: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;

Line 2079: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;

2075: x_detail_info_tab(l_index).request_id := FND_API.G_MISS_NUM;
2076: x_detail_info_tab(l_index).requested_quantity := FND_API.G_MISS_NUM;
2077: x_detail_info_tab(l_index).requested_quantity_uom := FND_API.G_MISS_CHAR;
2078: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2079: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
2080: -- Bug 4146352 : Need to comment seal_code as this is now added to
2081: -- the public api record structure.
2082: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
2083: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;

Line 2082: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;

2078: x_detail_info_tab(l_index).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2079: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
2080: -- Bug 4146352 : Need to comment seal_code as this is now added to
2081: -- the public api record structure.
2082: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
2083: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
2084: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
2085: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
2086: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;

Line 2083: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;

2079: x_detail_info_tab(l_index).requested_quantity2 := FND_API.G_MISS_NUM;
2080: -- Bug 4146352 : Need to comment seal_code as this is now added to
2081: -- the public api record structure.
2082: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
2083: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
2084: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
2085: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
2086: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
2087: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;

Line 2084: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;

2080: -- Bug 4146352 : Need to comment seal_code as this is now added to
2081: -- the public api record structure.
2082: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
2083: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
2084: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
2085: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
2086: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
2087: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
2088: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;

Line 2085: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;

2081: -- the public api record structure.
2082: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
2083: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
2084: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
2085: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
2086: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
2087: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
2088: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
2089: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;

Line 2086: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;

2082: -- x_detail_info_tab(l_index).seal_code := FND_API.G_MISS_CHAR;
2083: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
2084: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
2085: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
2086: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
2087: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
2088: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
2089: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
2090: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;

Line 2087: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;

2083: x_detail_info_tab(l_index).ship_from_location_id := FND_API.G_MISS_NUM;
2084: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
2085: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
2086: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
2087: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
2088: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
2089: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
2090: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
2091: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;

Line 2088: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;

2084: x_detail_info_tab(l_index).ship_to_location_id := FND_API.G_MISS_NUM;
2085: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
2086: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
2087: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
2088: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
2089: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
2090: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
2091: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
2092: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;

Line 2089: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;

2085: x_detail_info_tab(l_index).ship_to_site_use_id := FND_API.G_MISS_NUM;
2086: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
2087: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
2088: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
2089: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
2090: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
2091: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
2092: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
2093: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;

Line 2090: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;

2086: x_detail_info_tab(l_index).source_code := FND_API.G_MISS_CHAR;
2087: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
2088: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
2089: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
2090: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
2091: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
2092: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
2093: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
2094: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;

Line 2091: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;

2087: x_detail_info_tab(l_index).source_header_number := FND_API.G_MISS_CHAR;
2088: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
2089: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
2090: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
2091: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
2092: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
2093: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
2094: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
2095: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;

Line 2092: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;

2088: x_detail_info_tab(l_index).source_header_type_id := FND_API.G_MISS_NUM;
2089: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
2090: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
2091: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
2092: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
2093: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
2094: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
2095: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2096: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;

Line 2093: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;

2089: x_detail_info_tab(l_index).source_header_type_name := FND_API.G_MISS_CHAR;
2090: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
2091: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
2092: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
2093: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
2094: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
2095: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2096: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
2097: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;

Line 2094: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;

2090: x_detail_info_tab(l_index).source_line_number := FND_API.G_MISS_CHAR;
2091: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
2092: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
2093: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
2094: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
2095: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2096: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
2097: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
2098: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;

Line 2095: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;

2091: x_detail_info_tab(l_index).source_line_set_id := FND_API.G_MISS_NUM;
2092: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
2093: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
2094: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
2095: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2096: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
2097: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
2098: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
2099: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;

Line 2096: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;

2092: x_detail_info_tab(l_index).split_from_detail_id := FND_API.G_MISS_NUM;
2093: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
2094: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
2095: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2096: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
2097: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
2098: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
2099: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
2100: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;

Line 2097: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;

2093: x_detail_info_tab(l_index).src_requested_quantity := FND_API.G_MISS_NUM;
2094: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
2095: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2096: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
2097: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
2098: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
2099: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
2100: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
2101: -- J: W/V Changes

Line 2098: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;

2094: x_detail_info_tab(l_index).src_requested_quantity_uom := FND_API.G_MISS_CHAR;
2095: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2096: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
2097: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
2098: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
2099: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
2100: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
2101: -- J: W/V Changes
2102: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;

Line 2099: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;

2095: x_detail_info_tab(l_index).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
2096: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
2097: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
2098: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
2099: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
2100: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
2101: -- J: W/V Changes
2102: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;
2103: x_detail_info_tab(l_index).unit_volume := FND_API.G_MISS_NUM;

Line 2100: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;

2096: x_detail_info_tab(l_index).src_requested_quantity2 := FND_API.G_MISS_NUM;
2097: x_detail_info_tab(l_index).task_id := FND_API.G_MISS_NUM;
2098: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
2099: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
2100: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
2101: -- J: W/V Changes
2102: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;
2103: x_detail_info_tab(l_index).unit_volume := FND_API.G_MISS_NUM;
2104:

Line 2102: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;

2098: x_detail_info_tab(l_index).transaction_temp_id := FND_API.G_MISS_NUM;
2099: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
2100: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
2101: -- J: W/V Changes
2102: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;
2103: x_detail_info_tab(l_index).unit_volume := FND_API.G_MISS_NUM;
2104:
2105: /* End of fix for Bug 2766446 */
2106:

Line 2103: x_detail_info_tab(l_index).unit_volume := FND_API.G_MISS_NUM;

2099: x_detail_info_tab(l_index).unit_number := FND_API.G_MISS_CHAR;
2100: x_detail_info_tab(l_index).unit_price := FND_API.G_MISS_NUM;
2101: -- J: W/V Changes
2102: x_detail_info_tab(l_index).unit_weight := FND_API.G_MISS_NUM;
2103: x_detail_info_tab(l_index).unit_volume := FND_API.G_MISS_NUM;
2104:
2105: /* End of fix for Bug 2766446 */
2106:
2107: l_index := x_changed_attributes.NEXT(l_index);

Line 2116: WHEN FND_API.G_EXC_ERROR THEN

2112: END IF;
2113:
2114: EXCEPTION
2115:
2116: WHEN FND_API.G_EXC_ERROR THEN
2117:
2118: IF l_debug_on THEN
2119: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 2119: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2115:
2116: WHEN FND_API.G_EXC_ERROR THEN
2117:
2118: IF l_debug_on THEN
2119: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2121: END IF;
2122: raise;
2123:

Line 2120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2116: WHEN FND_API.G_EXC_ERROR THEN
2117:
2118: IF l_debug_on THEN
2119: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2121: END IF;
2122: raise;
2123:
2124: