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

APPS.WSH_CONTAINER_GRP dependencies on FND_API

Line 39: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 40: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

36: PROCEDURE Create_Containers (
37: -- Standard parameters
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,

Line 41: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

37: -- Standard parameters
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
45:

Line 149: IF NOT FND_API.compatible_api_call (

145: END IF;
146: --
147: SAVEPOINT Create_Containers_SP_GRP;
148:
149: IF NOT FND_API.compatible_api_call (
150: l_api_version,
151: p_api_version,
152: l_api_name,
153: G_PKG_NAME) THEN

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: l_api_version,
151: p_api_version,
152: l_api_name,
153: G_PKG_NAME) THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157: -- Check p_init_msg_list
158: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 158: IF FND_API.to_boolean(p_init_msg_list) THEN

154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157: -- Check p_init_msg_list
158: IF FND_API.to_boolean(p_init_msg_list) THEN
159: FND_MSG_PUB.initialize;
160: END IF;
161:
162: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 174: RAISE FND_API.G_EXC_ERROR;

170: IF p_caller NOT LIKE 'WMS%' THEN
171: IF l_debug_on THEN
172: WSH_DEBUG_SV.log(l_module_name,'Invalid caller',p_caller);
173: END IF;
174: RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:
177: IF p_lpn_ids.COUNT = 0 THEN
178: IF l_debug_on THEN

Line 184: RAISE FND_API.G_EXC_ERROR;

180: END IF;
181: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
182: FND_MESSAGE.SET_TOKEN('FIELD_NAME','LPN_ID');
183: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
184: RAISE FND_API.G_EXC_ERROR;
185: ELSIF p_lpn_ids(1) = NULL THEN
186: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
187: FND_MESSAGE.SET_TOKEN('FIELD_NAME','LPN_ID');
188: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 189: RAISE FND_API.G_EXC_ERROR;

185: ELSIF p_lpn_ids(1) = NULL THEN
186: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
187: FND_MESSAGE.SET_TOKEN('FIELD_NAME','LPN_ID');
188: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:
192: -- Bug fix 2657429
193: IF p_validation_level <> C_DELIVERY_DETAIL_CALL THEN

Line 222: raise fnd_api.g_exc_error;

218: x_return_status);
219: IF x_return_status <> wsh_util_core.g_ret_sts_success THEN
220: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ORG');
221: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
222: raise fnd_api.g_exc_error;
223: END IF;
224:
225: END IF;
226:

Line 280: RAISE FND_API.G_EXC_ERROR;

276: ELSE
277: fnd_message.set_name('WSH', 'WSH_INCORRECT_ORG');
278: fnd_message.set_token('ORG_CODE', l_organization_code);
279: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
280: RAISE FND_API.G_EXC_ERROR;
281: END IF; -- wms_enabled
282: END IF;
283:
284:

Line 315: IF FND_API.TO_BOOLEAN(p_commit) THEN

311: x_container_ids := l_OUT_rec.detail_ids;
312:
313:
314:
315: IF FND_API.TO_BOOLEAN(p_commit) THEN
316: -- dbms_output.put_line('commit');
317: COMMIT;
318: END IF;
319:

Line 323: , p_encoded => FND_API.G_FALSE

319:
320: FND_MSG_PUB.Count_And_Get
321: ( p_count => x_msg_count
322: , p_data => x_msg_data
323: , p_encoded => FND_API.G_FALSE
324: );
325:
326:
327: IF l_debug_on THEN

Line 332: WHEN FND_API.G_EXC_ERROR THEN

328: WSH_DEBUG_SV.pop(l_module_name);
329: END IF;
330: --
331: EXCEPTION
332: WHEN FND_API.G_EXC_ERROR THEN
333: ROLLBACK TO Create_Containers_SP_GRP;
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: FND_MSG_PUB.Count_And_Get
336: (

Line 334: x_return_status := FND_API.G_RET_STS_ERROR ;

330: --
331: EXCEPTION
332: WHEN FND_API.G_EXC_ERROR THEN
333: ROLLBACK TO Create_Containers_SP_GRP;
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: FND_MSG_PUB.Count_And_Get
336: (
337: p_count => x_msg_count,
338: p_data => x_msg_data,

Line 339: p_encoded => FND_API.G_FALSE

335: FND_MSG_PUB.Count_And_Get
336: (
337: p_count => x_msg_count,
338: p_data => x_msg_data,
339: p_encoded => FND_API.G_FALSE
340: );
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

339: p_encoded => FND_API.G_FALSE
340: );
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
345: END IF;
346:
347: WHEN WSH_NO_INV_ITEM then

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

340: );
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
345: END IF;
346:
347: WHEN WSH_NO_INV_ITEM then
348: rollback to Create_Containers_SP_GRP;

Line 354: , p_encoded => FND_API.G_FALSE

350:
351: FND_MSG_PUB.Count_And_Get
352: ( p_count => x_msg_count
353: , p_data => x_msg_data
354: , p_encoded => FND_API.G_FALSE
355: );
356:
357:
358: IF l_debug_on THEN

Line 372: , p_encoded => FND_API.G_FALSE

368:
369: FND_MSG_PUB.Count_And_Get
370: ( p_count => x_msg_count
371: , p_data => x_msg_data
372: , p_encoded => FND_API.G_FALSE
373: );
374:
375: IF l_debug_on THEN
376: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_QTY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 389: , p_encoded => FND_API.G_FALSE

385:
386: FND_MSG_PUB.Count_And_Get
387: ( p_count => x_msg_count
388: , p_data => x_msg_data
389: , p_encoded => FND_API.G_FALSE
390: );
391:
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_CREATION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 406: , p_encoded => FND_API.G_FALSE

402:
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count
405: , p_data => x_msg_data
406: , p_encoded => FND_API.G_FALSE
407: );
408:
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_LPN_COUNT_INVALID exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 421: , p_encoded => FND_API.G_FALSE

417: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
418: FND_MSG_PUB.Count_And_Get
419: ( p_count => x_msg_count
420: , p_data => x_msg_data
421: , p_encoded => FND_API.G_FALSE
422: );
423:
424: IF l_debug_on THEN
425: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 452: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

448:
449: PROCEDURE Update_Container (
450: -- Standard parameters
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
453: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
454: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
455: x_return_status OUT NOCOPY VARCHAR2,
456: x_msg_count OUT NOCOPY NUMBER,

Line 453: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

449: PROCEDURE Update_Container (
450: -- Standard parameters
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
453: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
454: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
455: x_return_status OUT NOCOPY VARCHAR2,
456: x_msg_count OUT NOCOPY NUMBER,
457: x_msg_data OUT NOCOPY VARCHAR2,

Line 454: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

450: -- Standard parameters
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
453: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
454: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
455: x_return_status OUT NOCOPY VARCHAR2,
456: x_msg_count OUT NOCOPY NUMBER,
457: x_msg_data OUT NOCOPY VARCHAR2,
458:

Line 547: IF NOT FND_API.compatible_api_call (

543: END IF;
544: --
545: SAVEPOINT Update_Containers_SP_Grp;
546:
547: IF NOT FND_API.compatible_api_call (
548: l_api_version,
549: p_api_version,
550: l_api_name,
551: G_PKG_NAME) THEN

Line 552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

548: l_api_version,
549: p_api_version,
550: l_api_name,
551: G_PKG_NAME) THEN
552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;
554:
555: -- Check p_init_msg_list
556: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 556: IF FND_API.to_boolean(p_init_msg_list) THEN

552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;
554:
555: -- Check p_init_msg_list
556: IF FND_API.to_boolean(p_init_msg_list) THEN
557: FND_MSG_PUB.initialize;
558: END IF;
559:
560: /*

Line 565: RAISE FND_API.G_EXC_ERROR;

561: IF p_caller NOT LIKE 'WMS%' THEN
562: IF l_debug_on THEN
563: WSH_DEBUG_SV.log(l_module_name,'Invalid caller',p_caller);
564: END IF;
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567: p_caller does not exist
568: */
569:

Line 798: (p_container_rec(1).lpn_id = FND_API.G_MISS_NUM)

794:
795: l_detail_info_tab(1).lpn_id := p_container_rec(1).lpn_id ;
796:
797: IF( p_container_rec(1).lpn_id IS NULL ) OR
798: (p_container_rec(1).lpn_id = FND_API.G_MISS_NUM)
799: THEN
800: IF p_container_rec(1).lpn_id IS NULL THEN
801: l_IN_rec.action_code := 'UPDATE_NULL';
802: END IF;

Line 816: l_detail_info_tab(1).ship_from_location_id := FND_API.G_MISS_NUM;

812: l_detail_info_tab(1).picked_quantity2 := p_container_rec(1).picked_quantity2 ;
813: l_detail_info_tab(1).received_quantity := p_container_rec(1).received_quantity ;
814: l_detail_info_tab(1).received_quantity2 := p_container_rec(1).received_quantity2 ;
815: l_detail_info_tab(1).source_line_set_id := p_container_rec(1).source_line_set_id ;
816: l_detail_info_tab(1).ship_from_location_id := FND_API.G_MISS_NUM;
817: l_detail_info_tab(1).ship_to_location_id := FND_API.G_MISS_NUM;
818: l_detail_info_tab(1).deliver_to_location_id := FND_API.G_MISS_NUM;
819: l_detail_info_tab(1).deliver_to_site_use_id := p_container_rec(1).deliver_to_org_id;
820: l_detail_info_tab(1).intmed_ship_to_location_id := FND_API.G_MISS_NUM;

Line 817: l_detail_info_tab(1).ship_to_location_id := FND_API.G_MISS_NUM;

813: l_detail_info_tab(1).received_quantity := p_container_rec(1).received_quantity ;
814: l_detail_info_tab(1).received_quantity2 := p_container_rec(1).received_quantity2 ;
815: l_detail_info_tab(1).source_line_set_id := p_container_rec(1).source_line_set_id ;
816: l_detail_info_tab(1).ship_from_location_id := FND_API.G_MISS_NUM;
817: l_detail_info_tab(1).ship_to_location_id := FND_API.G_MISS_NUM;
818: l_detail_info_tab(1).deliver_to_location_id := FND_API.G_MISS_NUM;
819: l_detail_info_tab(1).deliver_to_site_use_id := p_container_rec(1).deliver_to_org_id;
820: l_detail_info_tab(1).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
821: l_detail_info_tab(1).requested_quantity := FND_API.G_MISS_NUM;

Line 818: l_detail_info_tab(1).deliver_to_location_id := FND_API.G_MISS_NUM;

814: l_detail_info_tab(1).received_quantity2 := p_container_rec(1).received_quantity2 ;
815: l_detail_info_tab(1).source_line_set_id := p_container_rec(1).source_line_set_id ;
816: l_detail_info_tab(1).ship_from_location_id := FND_API.G_MISS_NUM;
817: l_detail_info_tab(1).ship_to_location_id := FND_API.G_MISS_NUM;
818: l_detail_info_tab(1).deliver_to_location_id := FND_API.G_MISS_NUM;
819: l_detail_info_tab(1).deliver_to_site_use_id := p_container_rec(1).deliver_to_org_id;
820: l_detail_info_tab(1).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
821: l_detail_info_tab(1).requested_quantity := FND_API.G_MISS_NUM;
822: l_detail_info_tab(1).requested_quantity_uom := FND_API.G_MISS_CHAR;

Line 820: l_detail_info_tab(1).intmed_ship_to_location_id := FND_API.G_MISS_NUM;

816: l_detail_info_tab(1).ship_from_location_id := FND_API.G_MISS_NUM;
817: l_detail_info_tab(1).ship_to_location_id := FND_API.G_MISS_NUM;
818: l_detail_info_tab(1).deliver_to_location_id := FND_API.G_MISS_NUM;
819: l_detail_info_tab(1).deliver_to_site_use_id := p_container_rec(1).deliver_to_org_id;
820: l_detail_info_tab(1).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
821: l_detail_info_tab(1).requested_quantity := FND_API.G_MISS_NUM;
822: l_detail_info_tab(1).requested_quantity_uom := FND_API.G_MISS_CHAR;
823: l_detail_info_tab(1).ship_method_code := p_container_rec(1).shipping_method_code;
824: l_detail_info_tab(1).created_by := FND_API.G_MISS_NUM;

Line 821: l_detail_info_tab(1).requested_quantity := FND_API.G_MISS_NUM;

817: l_detail_info_tab(1).ship_to_location_id := FND_API.G_MISS_NUM;
818: l_detail_info_tab(1).deliver_to_location_id := FND_API.G_MISS_NUM;
819: l_detail_info_tab(1).deliver_to_site_use_id := p_container_rec(1).deliver_to_org_id;
820: l_detail_info_tab(1).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
821: l_detail_info_tab(1).requested_quantity := FND_API.G_MISS_NUM;
822: l_detail_info_tab(1).requested_quantity_uom := FND_API.G_MISS_CHAR;
823: l_detail_info_tab(1).ship_method_code := p_container_rec(1).shipping_method_code;
824: l_detail_info_tab(1).created_by := FND_API.G_MISS_NUM;
825: l_detail_info_tab(1).creation_date := FND_API.G_MISS_DATE;

Line 822: l_detail_info_tab(1).requested_quantity_uom := FND_API.G_MISS_CHAR;

818: l_detail_info_tab(1).deliver_to_location_id := FND_API.G_MISS_NUM;
819: l_detail_info_tab(1).deliver_to_site_use_id := p_container_rec(1).deliver_to_org_id;
820: l_detail_info_tab(1).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
821: l_detail_info_tab(1).requested_quantity := FND_API.G_MISS_NUM;
822: l_detail_info_tab(1).requested_quantity_uom := FND_API.G_MISS_CHAR;
823: l_detail_info_tab(1).ship_method_code := p_container_rec(1).shipping_method_code;
824: l_detail_info_tab(1).created_by := FND_API.G_MISS_NUM;
825: l_detail_info_tab(1).creation_date := FND_API.G_MISS_DATE;
826: l_detail_info_tab(1).last_update_date := FND_API.G_MISS_DATE;

Line 824: l_detail_info_tab(1).created_by := FND_API.G_MISS_NUM;

820: l_detail_info_tab(1).intmed_ship_to_location_id := FND_API.G_MISS_NUM;
821: l_detail_info_tab(1).requested_quantity := FND_API.G_MISS_NUM;
822: l_detail_info_tab(1).requested_quantity_uom := FND_API.G_MISS_CHAR;
823: l_detail_info_tab(1).ship_method_code := p_container_rec(1).shipping_method_code;
824: l_detail_info_tab(1).created_by := FND_API.G_MISS_NUM;
825: l_detail_info_tab(1).creation_date := FND_API.G_MISS_DATE;
826: l_detail_info_tab(1).last_update_date := FND_API.G_MISS_DATE;
827: l_detail_info_tab(1).last_update_login := FND_API.G_MISS_NUM;
828: l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;

Line 825: l_detail_info_tab(1).creation_date := FND_API.G_MISS_DATE;

821: l_detail_info_tab(1).requested_quantity := FND_API.G_MISS_NUM;
822: l_detail_info_tab(1).requested_quantity_uom := FND_API.G_MISS_CHAR;
823: l_detail_info_tab(1).ship_method_code := p_container_rec(1).shipping_method_code;
824: l_detail_info_tab(1).created_by := FND_API.G_MISS_NUM;
825: l_detail_info_tab(1).creation_date := FND_API.G_MISS_DATE;
826: l_detail_info_tab(1).last_update_date := FND_API.G_MISS_DATE;
827: l_detail_info_tab(1).last_update_login := FND_API.G_MISS_NUM;
828: l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;
829: l_detail_info_tab(1).program_application_id := FND_API.G_MISS_NUM;

Line 826: l_detail_info_tab(1).last_update_date := FND_API.G_MISS_DATE;

822: l_detail_info_tab(1).requested_quantity_uom := FND_API.G_MISS_CHAR;
823: l_detail_info_tab(1).ship_method_code := p_container_rec(1).shipping_method_code;
824: l_detail_info_tab(1).created_by := FND_API.G_MISS_NUM;
825: l_detail_info_tab(1).creation_date := FND_API.G_MISS_DATE;
826: l_detail_info_tab(1).last_update_date := FND_API.G_MISS_DATE;
827: l_detail_info_tab(1).last_update_login := FND_API.G_MISS_NUM;
828: l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;
829: l_detail_info_tab(1).program_application_id := FND_API.G_MISS_NUM;
830: l_detail_info_tab(1).program_id := FND_API.G_MISS_NUM;

Line 827: l_detail_info_tab(1).last_update_login := FND_API.G_MISS_NUM;

823: l_detail_info_tab(1).ship_method_code := p_container_rec(1).shipping_method_code;
824: l_detail_info_tab(1).created_by := FND_API.G_MISS_NUM;
825: l_detail_info_tab(1).creation_date := FND_API.G_MISS_DATE;
826: l_detail_info_tab(1).last_update_date := FND_API.G_MISS_DATE;
827: l_detail_info_tab(1).last_update_login := FND_API.G_MISS_NUM;
828: l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;
829: l_detail_info_tab(1).program_application_id := FND_API.G_MISS_NUM;
830: l_detail_info_tab(1).program_id := FND_API.G_MISS_NUM;
831: l_detail_info_tab(1).program_update_date := FND_API.G_MISS_DATE;

Line 828: l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;

824: l_detail_info_tab(1).created_by := FND_API.G_MISS_NUM;
825: l_detail_info_tab(1).creation_date := FND_API.G_MISS_DATE;
826: l_detail_info_tab(1).last_update_date := FND_API.G_MISS_DATE;
827: l_detail_info_tab(1).last_update_login := FND_API.G_MISS_NUM;
828: l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;
829: l_detail_info_tab(1).program_application_id := FND_API.G_MISS_NUM;
830: l_detail_info_tab(1).program_id := FND_API.G_MISS_NUM;
831: l_detail_info_tab(1).program_update_date := FND_API.G_MISS_DATE;
832: l_detail_info_tab(1).released_flag := FND_API.G_MISS_CHAR;

Line 829: l_detail_info_tab(1).program_application_id := FND_API.G_MISS_NUM;

825: l_detail_info_tab(1).creation_date := FND_API.G_MISS_DATE;
826: l_detail_info_tab(1).last_update_date := FND_API.G_MISS_DATE;
827: l_detail_info_tab(1).last_update_login := FND_API.G_MISS_NUM;
828: l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;
829: l_detail_info_tab(1).program_application_id := FND_API.G_MISS_NUM;
830: l_detail_info_tab(1).program_id := FND_API.G_MISS_NUM;
831: l_detail_info_tab(1).program_update_date := FND_API.G_MISS_DATE;
832: l_detail_info_tab(1).released_flag := FND_API.G_MISS_CHAR;
833: l_detail_info_tab(1).split_from_detail_id := p_container_rec(1).split_from_delivery_detail_id;

Line 830: l_detail_info_tab(1).program_id := FND_API.G_MISS_NUM;

826: l_detail_info_tab(1).last_update_date := FND_API.G_MISS_DATE;
827: l_detail_info_tab(1).last_update_login := FND_API.G_MISS_NUM;
828: l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;
829: l_detail_info_tab(1).program_application_id := FND_API.G_MISS_NUM;
830: l_detail_info_tab(1).program_id := FND_API.G_MISS_NUM;
831: l_detail_info_tab(1).program_update_date := FND_API.G_MISS_DATE;
832: l_detail_info_tab(1).released_flag := FND_API.G_MISS_CHAR;
833: l_detail_info_tab(1).split_from_detail_id := p_container_rec(1).split_from_delivery_detail_id;
834: l_detail_info_tab(1).source_line_number := FND_API.G_MISS_CHAR;

Line 831: l_detail_info_tab(1).program_update_date := FND_API.G_MISS_DATE;

827: l_detail_info_tab(1).last_update_login := FND_API.G_MISS_NUM;
828: l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;
829: l_detail_info_tab(1).program_application_id := FND_API.G_MISS_NUM;
830: l_detail_info_tab(1).program_id := FND_API.G_MISS_NUM;
831: l_detail_info_tab(1).program_update_date := FND_API.G_MISS_DATE;
832: l_detail_info_tab(1).released_flag := FND_API.G_MISS_CHAR;
833: l_detail_info_tab(1).split_from_detail_id := p_container_rec(1).split_from_delivery_detail_id;
834: l_detail_info_tab(1).source_line_number := FND_API.G_MISS_CHAR;
835: l_detail_info_tab(1).src_requested_quantity2 := FND_API.G_MISS_NUM;

Line 832: l_detail_info_tab(1).released_flag := FND_API.G_MISS_CHAR;

828: l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;
829: l_detail_info_tab(1).program_application_id := FND_API.G_MISS_NUM;
830: l_detail_info_tab(1).program_id := FND_API.G_MISS_NUM;
831: l_detail_info_tab(1).program_update_date := FND_API.G_MISS_DATE;
832: l_detail_info_tab(1).released_flag := FND_API.G_MISS_CHAR;
833: l_detail_info_tab(1).split_from_detail_id := p_container_rec(1).split_from_delivery_detail_id;
834: l_detail_info_tab(1).source_line_number := FND_API.G_MISS_CHAR;
835: l_detail_info_tab(1).src_requested_quantity2 := FND_API.G_MISS_NUM;
836: l_detail_info_tab(1).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;

Line 834: l_detail_info_tab(1).source_line_number := FND_API.G_MISS_CHAR;

830: l_detail_info_tab(1).program_id := FND_API.G_MISS_NUM;
831: l_detail_info_tab(1).program_update_date := FND_API.G_MISS_DATE;
832: l_detail_info_tab(1).released_flag := FND_API.G_MISS_CHAR;
833: l_detail_info_tab(1).split_from_detail_id := p_container_rec(1).split_from_delivery_detail_id;
834: l_detail_info_tab(1).source_line_number := FND_API.G_MISS_CHAR;
835: l_detail_info_tab(1).src_requested_quantity2 := FND_API.G_MISS_NUM;
836: l_detail_info_tab(1).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
837: l_detail_info_tab(1).requested_quantity2 := FND_API.G_MISS_NUM;
838: l_detail_info_tab(1).requested_quantity_uom2 := FND_API.G_MISS_CHAR;

Line 835: l_detail_info_tab(1).src_requested_quantity2 := FND_API.G_MISS_NUM;

831: l_detail_info_tab(1).program_update_date := FND_API.G_MISS_DATE;
832: l_detail_info_tab(1).released_flag := FND_API.G_MISS_CHAR;
833: l_detail_info_tab(1).split_from_detail_id := p_container_rec(1).split_from_delivery_detail_id;
834: l_detail_info_tab(1).source_line_number := FND_API.G_MISS_CHAR;
835: l_detail_info_tab(1).src_requested_quantity2 := FND_API.G_MISS_NUM;
836: l_detail_info_tab(1).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
837: l_detail_info_tab(1).requested_quantity2 := FND_API.G_MISS_NUM;
838: l_detail_info_tab(1).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
839: l_detail_info_tab(1).batch_id := FND_API.G_MISS_NUM;

Line 836: l_detail_info_tab(1).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;

832: l_detail_info_tab(1).released_flag := FND_API.G_MISS_CHAR;
833: l_detail_info_tab(1).split_from_detail_id := p_container_rec(1).split_from_delivery_detail_id;
834: l_detail_info_tab(1).source_line_number := FND_API.G_MISS_CHAR;
835: l_detail_info_tab(1).src_requested_quantity2 := FND_API.G_MISS_NUM;
836: l_detail_info_tab(1).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
837: l_detail_info_tab(1).requested_quantity2 := FND_API.G_MISS_NUM;
838: l_detail_info_tab(1).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
839: l_detail_info_tab(1).batch_id := FND_API.G_MISS_NUM;
840: --l_detail_info_tab(1).ROWID := FND_API.G_MISS_CHAR;

Line 837: l_detail_info_tab(1).requested_quantity2 := FND_API.G_MISS_NUM;

833: l_detail_info_tab(1).split_from_detail_id := p_container_rec(1).split_from_delivery_detail_id;
834: l_detail_info_tab(1).source_line_number := FND_API.G_MISS_CHAR;
835: l_detail_info_tab(1).src_requested_quantity2 := FND_API.G_MISS_NUM;
836: l_detail_info_tab(1).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
837: l_detail_info_tab(1).requested_quantity2 := FND_API.G_MISS_NUM;
838: l_detail_info_tab(1).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
839: l_detail_info_tab(1).batch_id := FND_API.G_MISS_NUM;
840: --l_detail_info_tab(1).ROWID := FND_API.G_MISS_CHAR;
841: l_detail_info_tab(1).transaction_id := FND_API.G_MISS_NUM;

Line 838: l_detail_info_tab(1).requested_quantity_uom2 := FND_API.G_MISS_CHAR;

834: l_detail_info_tab(1).source_line_number := FND_API.G_MISS_CHAR;
835: l_detail_info_tab(1).src_requested_quantity2 := FND_API.G_MISS_NUM;
836: l_detail_info_tab(1).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
837: l_detail_info_tab(1).requested_quantity2 := FND_API.G_MISS_NUM;
838: l_detail_info_tab(1).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
839: l_detail_info_tab(1).batch_id := FND_API.G_MISS_NUM;
840: --l_detail_info_tab(1).ROWID := FND_API.G_MISS_CHAR;
841: l_detail_info_tab(1).transaction_id := FND_API.G_MISS_NUM;
842: l_detail_info_tab(1).VENDOR_ID := FND_API.G_MISS_NUM;

Line 839: l_detail_info_tab(1).batch_id := FND_API.G_MISS_NUM;

835: l_detail_info_tab(1).src_requested_quantity2 := FND_API.G_MISS_NUM;
836: l_detail_info_tab(1).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
837: l_detail_info_tab(1).requested_quantity2 := FND_API.G_MISS_NUM;
838: l_detail_info_tab(1).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
839: l_detail_info_tab(1).batch_id := FND_API.G_MISS_NUM;
840: --l_detail_info_tab(1).ROWID := FND_API.G_MISS_CHAR;
841: l_detail_info_tab(1).transaction_id := FND_API.G_MISS_NUM;
842: l_detail_info_tab(1).VENDOR_ID := FND_API.G_MISS_NUM;
843: l_detail_info_tab(1).SHIP_FROM_SITE_ID := FND_API.G_MISS_NUM;

Line 840: --l_detail_info_tab(1).ROWID := FND_API.G_MISS_CHAR;

836: l_detail_info_tab(1).src_requested_quantity_uom2 := FND_API.G_MISS_CHAR;
837: l_detail_info_tab(1).requested_quantity2 := FND_API.G_MISS_NUM;
838: l_detail_info_tab(1).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
839: l_detail_info_tab(1).batch_id := FND_API.G_MISS_NUM;
840: --l_detail_info_tab(1).ROWID := FND_API.G_MISS_CHAR;
841: l_detail_info_tab(1).transaction_id := FND_API.G_MISS_NUM;
842: l_detail_info_tab(1).VENDOR_ID := FND_API.G_MISS_NUM;
843: l_detail_info_tab(1).SHIP_FROM_SITE_ID := FND_API.G_MISS_NUM;
844: l_detail_info_tab(1).LINE_DIRECTION := FND_API.G_MISS_CHAR;

Line 841: l_detail_info_tab(1).transaction_id := FND_API.G_MISS_NUM;

837: l_detail_info_tab(1).requested_quantity2 := FND_API.G_MISS_NUM;
838: l_detail_info_tab(1).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
839: l_detail_info_tab(1).batch_id := FND_API.G_MISS_NUM;
840: --l_detail_info_tab(1).ROWID := FND_API.G_MISS_CHAR;
841: l_detail_info_tab(1).transaction_id := FND_API.G_MISS_NUM;
842: l_detail_info_tab(1).VENDOR_ID := FND_API.G_MISS_NUM;
843: l_detail_info_tab(1).SHIP_FROM_SITE_ID := FND_API.G_MISS_NUM;
844: l_detail_info_tab(1).LINE_DIRECTION := FND_API.G_MISS_CHAR;
845: l_detail_info_tab(1).PARTY_ID := FND_API.G_MISS_NUM;

Line 842: l_detail_info_tab(1).VENDOR_ID := FND_API.G_MISS_NUM;

838: l_detail_info_tab(1).requested_quantity_uom2 := FND_API.G_MISS_CHAR;
839: l_detail_info_tab(1).batch_id := FND_API.G_MISS_NUM;
840: --l_detail_info_tab(1).ROWID := FND_API.G_MISS_CHAR;
841: l_detail_info_tab(1).transaction_id := FND_API.G_MISS_NUM;
842: l_detail_info_tab(1).VENDOR_ID := FND_API.G_MISS_NUM;
843: l_detail_info_tab(1).SHIP_FROM_SITE_ID := FND_API.G_MISS_NUM;
844: l_detail_info_tab(1).LINE_DIRECTION := FND_API.G_MISS_CHAR;
845: l_detail_info_tab(1).PARTY_ID := FND_API.G_MISS_NUM;
846: l_detail_info_tab(1).ROUTING_REQ_ID := FND_API.G_MISS_NUM;

Line 843: l_detail_info_tab(1).SHIP_FROM_SITE_ID := FND_API.G_MISS_NUM;

839: l_detail_info_tab(1).batch_id := FND_API.G_MISS_NUM;
840: --l_detail_info_tab(1).ROWID := FND_API.G_MISS_CHAR;
841: l_detail_info_tab(1).transaction_id := FND_API.G_MISS_NUM;
842: l_detail_info_tab(1).VENDOR_ID := FND_API.G_MISS_NUM;
843: l_detail_info_tab(1).SHIP_FROM_SITE_ID := FND_API.G_MISS_NUM;
844: l_detail_info_tab(1).LINE_DIRECTION := FND_API.G_MISS_CHAR;
845: l_detail_info_tab(1).PARTY_ID := FND_API.G_MISS_NUM;
846: l_detail_info_tab(1).ROUTING_REQ_ID := FND_API.G_MISS_NUM;
847: l_detail_info_tab(1).SHIPPING_CONTROL := FND_API.G_MISS_CHAR;

Line 844: l_detail_info_tab(1).LINE_DIRECTION := FND_API.G_MISS_CHAR;

840: --l_detail_info_tab(1).ROWID := FND_API.G_MISS_CHAR;
841: l_detail_info_tab(1).transaction_id := FND_API.G_MISS_NUM;
842: l_detail_info_tab(1).VENDOR_ID := FND_API.G_MISS_NUM;
843: l_detail_info_tab(1).SHIP_FROM_SITE_ID := FND_API.G_MISS_NUM;
844: l_detail_info_tab(1).LINE_DIRECTION := FND_API.G_MISS_CHAR;
845: l_detail_info_tab(1).PARTY_ID := FND_API.G_MISS_NUM;
846: l_detail_info_tab(1).ROUTING_REQ_ID := FND_API.G_MISS_NUM;
847: l_detail_info_tab(1).SHIPPING_CONTROL := FND_API.G_MISS_CHAR;
848: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := FND_API.G_MISS_NUM;

Line 845: l_detail_info_tab(1).PARTY_ID := FND_API.G_MISS_NUM;

841: l_detail_info_tab(1).transaction_id := FND_API.G_MISS_NUM;
842: l_detail_info_tab(1).VENDOR_ID := FND_API.G_MISS_NUM;
843: l_detail_info_tab(1).SHIP_FROM_SITE_ID := FND_API.G_MISS_NUM;
844: l_detail_info_tab(1).LINE_DIRECTION := FND_API.G_MISS_CHAR;
845: l_detail_info_tab(1).PARTY_ID := FND_API.G_MISS_NUM;
846: l_detail_info_tab(1).ROUTING_REQ_ID := FND_API.G_MISS_NUM;
847: l_detail_info_tab(1).SHIPPING_CONTROL := FND_API.G_MISS_CHAR;
848: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := FND_API.G_MISS_NUM;
849: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := FND_API.G_MISS_NUM;

Line 846: l_detail_info_tab(1).ROUTING_REQ_ID := FND_API.G_MISS_NUM;

842: l_detail_info_tab(1).VENDOR_ID := FND_API.G_MISS_NUM;
843: l_detail_info_tab(1).SHIP_FROM_SITE_ID := FND_API.G_MISS_NUM;
844: l_detail_info_tab(1).LINE_DIRECTION := FND_API.G_MISS_CHAR;
845: l_detail_info_tab(1).PARTY_ID := FND_API.G_MISS_NUM;
846: l_detail_info_tab(1).ROUTING_REQ_ID := FND_API.G_MISS_NUM;
847: l_detail_info_tab(1).SHIPPING_CONTROL := FND_API.G_MISS_CHAR;
848: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := FND_API.G_MISS_NUM;
849: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := FND_API.G_MISS_NUM;
850: l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;

Line 847: l_detail_info_tab(1).SHIPPING_CONTROL := FND_API.G_MISS_CHAR;

843: l_detail_info_tab(1).SHIP_FROM_SITE_ID := FND_API.G_MISS_NUM;
844: l_detail_info_tab(1).LINE_DIRECTION := FND_API.G_MISS_CHAR;
845: l_detail_info_tab(1).PARTY_ID := FND_API.G_MISS_NUM;
846: l_detail_info_tab(1).ROUTING_REQ_ID := FND_API.G_MISS_NUM;
847: l_detail_info_tab(1).SHIPPING_CONTROL := FND_API.G_MISS_CHAR;
848: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := FND_API.G_MISS_NUM;
849: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := FND_API.G_MISS_NUM;
850: l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
851: l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := FND_API.G_MISS_NUM;

Line 848: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := FND_API.G_MISS_NUM;

844: l_detail_info_tab(1).LINE_DIRECTION := FND_API.G_MISS_CHAR;
845: l_detail_info_tab(1).PARTY_ID := FND_API.G_MISS_NUM;
846: l_detail_info_tab(1).ROUTING_REQ_ID := FND_API.G_MISS_NUM;
847: l_detail_info_tab(1).SHIPPING_CONTROL := FND_API.G_MISS_CHAR;
848: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := FND_API.G_MISS_NUM;
849: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := FND_API.G_MISS_NUM;
850: l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
851: l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := FND_API.G_MISS_NUM;
852: l_detail_info_tab(1).RETURNED_QUANTITY := FND_API.G_MISS_NUM;

Line 849: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := FND_API.G_MISS_NUM;

845: l_detail_info_tab(1).PARTY_ID := FND_API.G_MISS_NUM;
846: l_detail_info_tab(1).ROUTING_REQ_ID := FND_API.G_MISS_NUM;
847: l_detail_info_tab(1).SHIPPING_CONTROL := FND_API.G_MISS_CHAR;
848: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := FND_API.G_MISS_NUM;
849: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := FND_API.G_MISS_NUM;
850: l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
851: l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := FND_API.G_MISS_NUM;
852: l_detail_info_tab(1).RETURNED_QUANTITY := FND_API.G_MISS_NUM;
853: l_detail_info_tab(1).RETURNED_QUANTITY2 := FND_API.G_MISS_NUM;

Line 850: l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;

846: l_detail_info_tab(1).ROUTING_REQ_ID := FND_API.G_MISS_NUM;
847: l_detail_info_tab(1).SHIPPING_CONTROL := FND_API.G_MISS_CHAR;
848: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := FND_API.G_MISS_NUM;
849: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := FND_API.G_MISS_NUM;
850: l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
851: l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := FND_API.G_MISS_NUM;
852: l_detail_info_tab(1).RETURNED_QUANTITY := FND_API.G_MISS_NUM;
853: l_detail_info_tab(1).RETURNED_QUANTITY2 := FND_API.G_MISS_NUM;
854: l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;

Line 851: l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := FND_API.G_MISS_NUM;

847: l_detail_info_tab(1).SHIPPING_CONTROL := FND_API.G_MISS_CHAR;
848: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := FND_API.G_MISS_NUM;
849: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := FND_API.G_MISS_NUM;
850: l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
851: l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := FND_API.G_MISS_NUM;
852: l_detail_info_tab(1).RETURNED_QUANTITY := FND_API.G_MISS_NUM;
853: l_detail_info_tab(1).RETURNED_QUANTITY2 := FND_API.G_MISS_NUM;
854: l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
855: l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := FND_API.G_MISS_CHAR;

Line 852: l_detail_info_tab(1).RETURNED_QUANTITY := FND_API.G_MISS_NUM;

848: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_ID := FND_API.G_MISS_NUM;
849: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := FND_API.G_MISS_NUM;
850: l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
851: l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := FND_API.G_MISS_NUM;
852: l_detail_info_tab(1).RETURNED_QUANTITY := FND_API.G_MISS_NUM;
853: l_detail_info_tab(1).RETURNED_QUANTITY2 := FND_API.G_MISS_NUM;
854: l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
855: l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
856: l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := FND_API.G_MISS_CHAR;

Line 853: l_detail_info_tab(1).RETURNED_QUANTITY2 := FND_API.G_MISS_NUM;

849: l_detail_info_tab(1).SOURCE_BLANKET_REFERENCE_NUM := FND_API.G_MISS_NUM;
850: l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
851: l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := FND_API.G_MISS_NUM;
852: l_detail_info_tab(1).RETURNED_QUANTITY := FND_API.G_MISS_NUM;
853: l_detail_info_tab(1).RETURNED_QUANTITY2 := FND_API.G_MISS_NUM;
854: l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
855: l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
856: l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := FND_API.G_MISS_CHAR;
857: l_detail_info_tab(1).IGNORE_FOR_PLANNING := FND_API.G_MISS_CHAR;

Line 854: l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;

850: l_detail_info_tab(1).PO_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
851: l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := FND_API.G_MISS_NUM;
852: l_detail_info_tab(1).RETURNED_QUANTITY := FND_API.G_MISS_NUM;
853: l_detail_info_tab(1).RETURNED_QUANTITY2 := FND_API.G_MISS_NUM;
854: l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
855: l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
856: l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := FND_API.G_MISS_CHAR;
857: l_detail_info_tab(1).IGNORE_FOR_PLANNING := FND_API.G_MISS_CHAR;
858: l_detail_info_tab(1).EARLIEST_PICKUP_DATE := FND_API.G_MISS_DATE;

Line 855: l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := FND_API.G_MISS_CHAR;

851: l_detail_info_tab(1).PO_SHIPMENT_LINE_NUMBER := FND_API.G_MISS_NUM;
852: l_detail_info_tab(1).RETURNED_QUANTITY := FND_API.G_MISS_NUM;
853: l_detail_info_tab(1).RETURNED_QUANTITY2 := FND_API.G_MISS_NUM;
854: l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
855: l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
856: l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := FND_API.G_MISS_CHAR;
857: l_detail_info_tab(1).IGNORE_FOR_PLANNING := FND_API.G_MISS_CHAR;
858: l_detail_info_tab(1).EARLIEST_PICKUP_DATE := FND_API.G_MISS_DATE;
859: l_detail_info_tab(1).LATEST_PICKUP_DATE := FND_API.G_MISS_DATE;

Line 856: l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := FND_API.G_MISS_CHAR;

852: l_detail_info_tab(1).RETURNED_QUANTITY := FND_API.G_MISS_NUM;
853: l_detail_info_tab(1).RETURNED_QUANTITY2 := FND_API.G_MISS_NUM;
854: l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
855: l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
856: l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := FND_API.G_MISS_CHAR;
857: l_detail_info_tab(1).IGNORE_FOR_PLANNING := FND_API.G_MISS_CHAR;
858: l_detail_info_tab(1).EARLIEST_PICKUP_DATE := FND_API.G_MISS_DATE;
859: l_detail_info_tab(1).LATEST_PICKUP_DATE := FND_API.G_MISS_DATE;
860: l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := FND_API.G_MISS_DATE;

Line 857: l_detail_info_tab(1).IGNORE_FOR_PLANNING := FND_API.G_MISS_CHAR;

853: l_detail_info_tab(1).RETURNED_QUANTITY2 := FND_API.G_MISS_NUM;
854: l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
855: l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
856: l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := FND_API.G_MISS_CHAR;
857: l_detail_info_tab(1).IGNORE_FOR_PLANNING := FND_API.G_MISS_CHAR;
858: l_detail_info_tab(1).EARLIEST_PICKUP_DATE := FND_API.G_MISS_DATE;
859: l_detail_info_tab(1).LATEST_PICKUP_DATE := FND_API.G_MISS_DATE;
860: l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
861: l_detail_info_tab(1).LATEST_DROPOFF_DATE := FND_API.G_MISS_DATE;

Line 858: l_detail_info_tab(1).EARLIEST_PICKUP_DATE := FND_API.G_MISS_DATE;

854: l_detail_info_tab(1).RCV_SHIPMENT_LINE_ID := FND_API.G_MISS_NUM;
855: l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
856: l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := FND_API.G_MISS_CHAR;
857: l_detail_info_tab(1).IGNORE_FOR_PLANNING := FND_API.G_MISS_CHAR;
858: l_detail_info_tab(1).EARLIEST_PICKUP_DATE := FND_API.G_MISS_DATE;
859: l_detail_info_tab(1).LATEST_PICKUP_DATE := FND_API.G_MISS_DATE;
860: l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
861: l_detail_info_tab(1).LATEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
862: l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := FND_API.G_MISS_CHAR;

Line 859: l_detail_info_tab(1).LATEST_PICKUP_DATE := FND_API.G_MISS_DATE;

855: l_detail_info_tab(1).SOURCE_LINE_TYPE_CODE := FND_API.G_MISS_CHAR;
856: l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := FND_API.G_MISS_CHAR;
857: l_detail_info_tab(1).IGNORE_FOR_PLANNING := FND_API.G_MISS_CHAR;
858: l_detail_info_tab(1).EARLIEST_PICKUP_DATE := FND_API.G_MISS_DATE;
859: l_detail_info_tab(1).LATEST_PICKUP_DATE := FND_API.G_MISS_DATE;
860: l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
861: l_detail_info_tab(1).LATEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
862: l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := FND_API.G_MISS_CHAR;
863: l_detail_info_tab(1).tp_delivery_detail_id := FND_API.G_MISS_NUM;

Line 860: l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := FND_API.G_MISS_DATE;

856: l_detail_info_tab(1).SUPPLIER_ITEM_NUMBER := FND_API.G_MISS_CHAR;
857: l_detail_info_tab(1).IGNORE_FOR_PLANNING := FND_API.G_MISS_CHAR;
858: l_detail_info_tab(1).EARLIEST_PICKUP_DATE := FND_API.G_MISS_DATE;
859: l_detail_info_tab(1).LATEST_PICKUP_DATE := FND_API.G_MISS_DATE;
860: l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
861: l_detail_info_tab(1).LATEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
862: l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := FND_API.G_MISS_CHAR;
863: l_detail_info_tab(1).tp_delivery_detail_id := FND_API.G_MISS_NUM;
864: l_detail_info_tab(1).source_document_type_id := FND_API.G_MISS_NUM;

Line 861: l_detail_info_tab(1).LATEST_DROPOFF_DATE := FND_API.G_MISS_DATE;

857: l_detail_info_tab(1).IGNORE_FOR_PLANNING := FND_API.G_MISS_CHAR;
858: l_detail_info_tab(1).EARLIEST_PICKUP_DATE := FND_API.G_MISS_DATE;
859: l_detail_info_tab(1).LATEST_PICKUP_DATE := FND_API.G_MISS_DATE;
860: l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
861: l_detail_info_tab(1).LATEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
862: l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := FND_API.G_MISS_CHAR;
863: l_detail_info_tab(1).tp_delivery_detail_id := FND_API.G_MISS_NUM;
864: l_detail_info_tab(1).source_document_type_id := FND_API.G_MISS_NUM;
865: l_detail_info_tab(1).unit_weight := FND_API.G_MISS_NUM;

Line 862: l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := FND_API.G_MISS_CHAR;

858: l_detail_info_tab(1).EARLIEST_PICKUP_DATE := FND_API.G_MISS_DATE;
859: l_detail_info_tab(1).LATEST_PICKUP_DATE := FND_API.G_MISS_DATE;
860: l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
861: l_detail_info_tab(1).LATEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
862: l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := FND_API.G_MISS_CHAR;
863: l_detail_info_tab(1).tp_delivery_detail_id := FND_API.G_MISS_NUM;
864: l_detail_info_tab(1).source_document_type_id := FND_API.G_MISS_NUM;
865: l_detail_info_tab(1).unit_weight := FND_API.G_MISS_NUM;
866: l_detail_info_tab(1).unit_volume := FND_API.G_MISS_NUM;

Line 863: l_detail_info_tab(1).tp_delivery_detail_id := FND_API.G_MISS_NUM;

859: l_detail_info_tab(1).LATEST_PICKUP_DATE := FND_API.G_MISS_DATE;
860: l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
861: l_detail_info_tab(1).LATEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
862: l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := FND_API.G_MISS_CHAR;
863: l_detail_info_tab(1).tp_delivery_detail_id := FND_API.G_MISS_NUM;
864: l_detail_info_tab(1).source_document_type_id := FND_API.G_MISS_NUM;
865: l_detail_info_tab(1).unit_weight := FND_API.G_MISS_NUM;
866: l_detail_info_tab(1).unit_volume := FND_API.G_MISS_NUM;
867: l_detail_info_tab(1).filled_volume := FND_API.G_MISS_NUM;

Line 864: l_detail_info_tab(1).source_document_type_id := FND_API.G_MISS_NUM;

860: l_detail_info_tab(1).EARLIEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
861: l_detail_info_tab(1).LATEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
862: l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := FND_API.G_MISS_CHAR;
863: l_detail_info_tab(1).tp_delivery_detail_id := FND_API.G_MISS_NUM;
864: l_detail_info_tab(1).source_document_type_id := FND_API.G_MISS_NUM;
865: l_detail_info_tab(1).unit_weight := FND_API.G_MISS_NUM;
866: l_detail_info_tab(1).unit_volume := FND_API.G_MISS_NUM;
867: l_detail_info_tab(1).filled_volume := FND_API.G_MISS_NUM;
868: l_detail_info_tab(1).wv_frozen_flag := FND_API.G_MISS_CHAR;

Line 865: l_detail_info_tab(1).unit_weight := FND_API.G_MISS_NUM;

861: l_detail_info_tab(1).LATEST_DROPOFF_DATE := FND_API.G_MISS_DATE;
862: l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := FND_API.G_MISS_CHAR;
863: l_detail_info_tab(1).tp_delivery_detail_id := FND_API.G_MISS_NUM;
864: l_detail_info_tab(1).source_document_type_id := FND_API.G_MISS_NUM;
865: l_detail_info_tab(1).unit_weight := FND_API.G_MISS_NUM;
866: l_detail_info_tab(1).unit_volume := FND_API.G_MISS_NUM;
867: l_detail_info_tab(1).filled_volume := FND_API.G_MISS_NUM;
868: l_detail_info_tab(1).wv_frozen_flag := FND_API.G_MISS_CHAR;
869: l_detail_info_tab(1).mode_of_transport := FND_API.G_MISS_CHAR;

Line 866: l_detail_info_tab(1).unit_volume := FND_API.G_MISS_NUM;

862: l_detail_info_tab(1).REQUEST_DATE_TYPE_CODE := FND_API.G_MISS_CHAR;
863: l_detail_info_tab(1).tp_delivery_detail_id := FND_API.G_MISS_NUM;
864: l_detail_info_tab(1).source_document_type_id := FND_API.G_MISS_NUM;
865: l_detail_info_tab(1).unit_weight := FND_API.G_MISS_NUM;
866: l_detail_info_tab(1).unit_volume := FND_API.G_MISS_NUM;
867: l_detail_info_tab(1).filled_volume := FND_API.G_MISS_NUM;
868: l_detail_info_tab(1).wv_frozen_flag := FND_API.G_MISS_CHAR;
869: l_detail_info_tab(1).mode_of_transport := FND_API.G_MISS_CHAR;
870: l_detail_info_tab(1).service_level := FND_API.G_MISS_CHAR;

Line 867: l_detail_info_tab(1).filled_volume := FND_API.G_MISS_NUM;

863: l_detail_info_tab(1).tp_delivery_detail_id := FND_API.G_MISS_NUM;
864: l_detail_info_tab(1).source_document_type_id := FND_API.G_MISS_NUM;
865: l_detail_info_tab(1).unit_weight := FND_API.G_MISS_NUM;
866: l_detail_info_tab(1).unit_volume := FND_API.G_MISS_NUM;
867: l_detail_info_tab(1).filled_volume := FND_API.G_MISS_NUM;
868: l_detail_info_tab(1).wv_frozen_flag := FND_API.G_MISS_CHAR;
869: l_detail_info_tab(1).mode_of_transport := FND_API.G_MISS_CHAR;
870: l_detail_info_tab(1).service_level := FND_API.G_MISS_CHAR;
871: l_detail_info_tab(1).po_revision_number := FND_API.G_MISS_NUM;

Line 868: l_detail_info_tab(1).wv_frozen_flag := FND_API.G_MISS_CHAR;

864: l_detail_info_tab(1).source_document_type_id := FND_API.G_MISS_NUM;
865: l_detail_info_tab(1).unit_weight := FND_API.G_MISS_NUM;
866: l_detail_info_tab(1).unit_volume := FND_API.G_MISS_NUM;
867: l_detail_info_tab(1).filled_volume := FND_API.G_MISS_NUM;
868: l_detail_info_tab(1).wv_frozen_flag := FND_API.G_MISS_CHAR;
869: l_detail_info_tab(1).mode_of_transport := FND_API.G_MISS_CHAR;
870: l_detail_info_tab(1).service_level := FND_API.G_MISS_CHAR;
871: l_detail_info_tab(1).po_revision_number := FND_API.G_MISS_NUM;
872: l_detail_info_tab(1).release_revision_number := FND_API.G_MISS_NUM;

Line 869: l_detail_info_tab(1).mode_of_transport := FND_API.G_MISS_CHAR;

865: l_detail_info_tab(1).unit_weight := FND_API.G_MISS_NUM;
866: l_detail_info_tab(1).unit_volume := FND_API.G_MISS_NUM;
867: l_detail_info_tab(1).filled_volume := FND_API.G_MISS_NUM;
868: l_detail_info_tab(1).wv_frozen_flag := FND_API.G_MISS_CHAR;
869: l_detail_info_tab(1).mode_of_transport := FND_API.G_MISS_CHAR;
870: l_detail_info_tab(1).service_level := FND_API.G_MISS_CHAR;
871: l_detail_info_tab(1).po_revision_number := FND_API.G_MISS_NUM;
872: l_detail_info_tab(1).release_revision_number := FND_API.G_MISS_NUM;
873:

Line 870: l_detail_info_tab(1).service_level := FND_API.G_MISS_CHAR;

866: l_detail_info_tab(1).unit_volume := FND_API.G_MISS_NUM;
867: l_detail_info_tab(1).filled_volume := FND_API.G_MISS_NUM;
868: l_detail_info_tab(1).wv_frozen_flag := FND_API.G_MISS_CHAR;
869: l_detail_info_tab(1).mode_of_transport := FND_API.G_MISS_CHAR;
870: l_detail_info_tab(1).service_level := FND_API.G_MISS_CHAR;
871: l_detail_info_tab(1).po_revision_number := FND_API.G_MISS_NUM;
872: l_detail_info_tab(1).release_revision_number := FND_API.G_MISS_NUM;
873:
874: WSH_WMS_LPN_GRP.create_update_containers

Line 871: l_detail_info_tab(1).po_revision_number := FND_API.G_MISS_NUM;

867: l_detail_info_tab(1).filled_volume := FND_API.G_MISS_NUM;
868: l_detail_info_tab(1).wv_frozen_flag := FND_API.G_MISS_CHAR;
869: l_detail_info_tab(1).mode_of_transport := FND_API.G_MISS_CHAR;
870: l_detail_info_tab(1).service_level := FND_API.G_MISS_CHAR;
871: l_detail_info_tab(1).po_revision_number := FND_API.G_MISS_NUM;
872: l_detail_info_tab(1).release_revision_number := FND_API.G_MISS_NUM;
873:
874: WSH_WMS_LPN_GRP.create_update_containers
875: ( p_api_version => p_api_version,

Line 872: l_detail_info_tab(1).release_revision_number := FND_API.G_MISS_NUM;

868: l_detail_info_tab(1).wv_frozen_flag := FND_API.G_MISS_CHAR;
869: l_detail_info_tab(1).mode_of_transport := FND_API.G_MISS_CHAR;
870: l_detail_info_tab(1).service_level := FND_API.G_MISS_CHAR;
871: l_detail_info_tab(1).po_revision_number := FND_API.G_MISS_NUM;
872: l_detail_info_tab(1).release_revision_number := FND_API.G_MISS_NUM;
873:
874: WSH_WMS_LPN_GRP.create_update_containers
875: ( p_api_version => p_api_version,
876: p_init_msg_list => p_init_msg_list,

Line 894: IF FND_API.TO_BOOLEAN(p_commit) THEN

890:
891: END IF; -- if p_container_rec is not null
892:
893:
894: IF FND_API.TO_BOOLEAN(p_commit) THEN
895: -- dbms_output.put_line('commit');
896: COMMIT;
897: END IF;
898:

Line 902: , p_encoded => FND_API.G_FALSE

898:
899: FND_MSG_PUB.Count_And_Get
900: ( p_count => x_msg_count
901: , p_data => x_msg_data
902: , p_encoded => FND_API.G_FALSE
903: );
904:
905:
906: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 933: , p_encoded => FND_API.G_FALSE

929: */
930: FND_MSG_PUB.Count_And_Get
931: ( p_count => x_msg_count
932: , p_data => x_msg_data
933: , p_encoded => FND_API.G_FALSE
934: );
935:
936: --
937: -- Debug Statements

Line 960: , p_encoded => FND_API.G_FALSE

956: */
957: FND_MSG_PUB.Count_And_Get
958: ( p_count => x_msg_count
959: , p_data => x_msg_data
960: , p_encoded => FND_API.G_FALSE
961: );
962: --
963: -- Debug Statements
964: --

Line 986: , p_encoded => FND_API.G_FALSE

982: */
983: FND_MSG_PUB.Count_And_Get
984: ( p_count => x_msg_count
985: , p_data => x_msg_data
986: , p_encoded => FND_API.G_FALSE
987: );
988:
989: --
990: -- Debug Statements

Line 1014: , p_encoded => FND_API.G_FALSE

1010: */
1011: FND_MSG_PUB.Count_And_Get
1012: ( p_count => x_msg_count
1013: , p_data => x_msg_data
1014: , p_encoded => FND_API.G_FALSE
1015: );
1016:
1017:
1018: --

Line 1065: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1061:
1062: PROCEDURE Auto_Pack (
1063: -- Standard parameters
1064: p_api_version IN NUMBER,
1065: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1066: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1067: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1068: x_return_status OUT NOCOPY VARCHAR2,
1069: x_msg_count OUT NOCOPY NUMBER,

Line 1066: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1062: PROCEDURE Auto_Pack (
1063: -- Standard parameters
1064: p_api_version IN NUMBER,
1065: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1066: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1067: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1068: x_return_status OUT NOCOPY VARCHAR2,
1069: x_msg_count OUT NOCOPY NUMBER,
1070: x_msg_data OUT NOCOPY VARCHAR2,

Line 1067: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1063: -- Standard parameters
1064: p_api_version IN NUMBER,
1065: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1066: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1067: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1068: x_return_status OUT NOCOPY VARCHAR2,
1069: x_msg_count OUT NOCOPY NUMBER,
1070: x_msg_data OUT NOCOPY VARCHAR2,
1071:

Line 1222: IF NOT FND_API.compatible_api_call (

1218: END IF;
1219: --
1220: SAVEPOINT Autopack_SP_Grp;
1221:
1222: IF NOT FND_API.compatible_api_call (
1223: l_api_version,
1224: p_api_version,
1225: l_api_name,
1226: G_PKG_NAME) THEN

Line 1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1223: l_api_version,
1224: p_api_version,
1225: l_api_name,
1226: G_PKG_NAME) THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: END IF;
1229:
1230: -- Check p_init_msg_list
1231: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1231: IF FND_API.to_boolean(p_init_msg_list) THEN

1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: END IF;
1229:
1230: -- Check p_init_msg_list
1231: IF FND_API.to_boolean(p_init_msg_list) THEN
1232: FND_MSG_PUB.initialize;
1233: END IF;
1234:
1235: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1454: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1455: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1456: RAISE WSH_FAIL_AUTOPACK;
1457: ELSE
1458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1459: END IF;
1460: END IF;
1461: --}
1462: END IF;

Line 1467: IF FND_API.TO_BOOLEAN(p_commit) THEN

1463: --
1464: -- K LPN CONV. rv
1465: --
1466: --Bugfix 4070732 {
1467: IF FND_API.TO_BOOLEAN(p_commit) THEN
1468:
1469: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1470:
1471: -- dbms_output.put_line('commit');

Line 1509: IF FND_API.TO_BOOLEAN(p_commit) THEN

1505: --Bugfix 4070732 {
1506: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN --{
1507: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1508:
1509: IF FND_API.TO_BOOLEAN(p_commit) THEN
1510:
1511: IF l_debug_on THEN
1512: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1513: END IF;

Line 1533: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN

1529: END IF;
1530:
1531: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1532: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1533: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
1534: rollback to Autopack_SP_Grp;
1535: end if;
1536: END IF;
1537:

Line 1551: , p_encoded => FND_API.G_FALSE

1547:
1548: FND_MSG_PUB.Count_And_Get
1549: ( p_count => x_msg_count
1550: , p_data => x_msg_data
1551: , p_encoded => FND_API.G_FALSE
1552: );
1553:
1554:
1555: --

Line 1605: , p_encoded => FND_API.G_FALSE

1601:
1602: FND_MSG_PUB.Count_And_Get
1603: ( p_count => x_msg_count
1604: , p_data => x_msg_data
1605: , p_encoded => FND_API.G_FALSE
1606: );
1607:
1608: --
1609: -- Debug Statements

Line 1617: WHEN FND_API.G_EXC_ERROR then

1613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
1614: END IF;
1615: --
1616:
1617: WHEN FND_API.G_EXC_ERROR then
1618: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1619: rollback to Autopack_SP_Grp;
1620:
1621: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 1646: , p_encoded => FND_API.G_FALSE

1642:
1643: FND_MSG_PUB.Count_And_Get
1644: ( p_count => x_msg_count
1645: , p_data => x_msg_data
1646: , p_encoded => FND_API.G_FALSE
1647: );
1648: --Bugfix 4070732 {
1649:
1650: --

Line 1699: , p_encoded => FND_API.G_FALSE

1695:
1696: FND_MSG_PUB.Count_And_Get
1697: ( p_count => x_msg_count
1698: , p_data => x_msg_data
1699: , p_encoded => FND_API.G_FALSE
1700: );
1701: --
1702: -- Debug Statements
1703: --

Line 1751: , p_encoded => FND_API.G_FALSE

1747:
1748: FND_MSG_PUB.Count_And_Get
1749: ( p_count => x_msg_count
1750: , p_data => x_msg_data
1751: , p_encoded => FND_API.G_FALSE
1752: );
1753: --
1754: -- Debug Statements
1755: --

Line 1821: , p_encoded => FND_API.G_FALSE

1817:
1818: FND_MSG_PUB.Count_And_Get
1819: ( p_count => x_msg_count
1820: , p_data => x_msg_data
1821: , p_encoded => FND_API.G_FALSE
1822: );
1823: IF l_debug_on THEN
1824: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1825: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');

Line 1859: , p_encoded => FND_API.G_FALSE

1855:
1856: FND_MSG_PUB.Count_And_Get
1857: ( p_count => x_msg_count
1858: , p_data => x_msg_data
1859: , p_encoded => FND_API.G_FALSE
1860: );
1861: IF l_debug_on THEN
1862: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_AUTOPACK exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1863: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_AUTOPACK');

Line 1907: , p_encoded => FND_API.G_FALSE

1903:
1904: FND_MSG_PUB.Count_And_Get
1905: ( p_count => x_msg_count
1906: , p_data => x_msg_data
1907: , p_encoded => FND_API.G_FALSE
1908: );
1909:
1910: --
1911: -- Debug Statements

Line 1957: , p_encoded => FND_API.G_FALSE

1953:
1954: FND_MSG_PUB.Count_And_Get
1955: ( p_count => x_msg_count
1956: , p_data => x_msg_data
1957: , p_encoded => FND_API.G_FALSE
1958: );
1959:
1960: --
1961: -- Debug Statements

Line 2008: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2004:
2005: PROCEDURE Container_Actions (
2006: -- Standard parameters
2007: p_api_version IN NUMBER,
2008: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2009: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2010: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
2011: x_return_status OUT NOCOPY VARCHAR2,
2012: x_msg_count OUT NOCOPY NUMBER,

Line 2009: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2005: PROCEDURE Container_Actions (
2006: -- Standard parameters
2007: p_api_version IN NUMBER,
2008: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2009: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2010: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
2011: x_return_status OUT NOCOPY VARCHAR2,
2012: x_msg_count OUT NOCOPY NUMBER,
2013: x_msg_data OUT NOCOPY VARCHAR2,

Line 2010: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

2006: -- Standard parameters
2007: p_api_version IN NUMBER,
2008: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2009: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2010: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
2011: x_return_status OUT NOCOPY VARCHAR2,
2012: x_msg_count OUT NOCOPY NUMBER,
2013: x_msg_data OUT NOCOPY VARCHAR2,
2014: -- program specific parameters

Line 2157: IF FND_API.to_boolean(p_init_msg_list) THEN

2153: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2154: END IF;
2155: --
2156: -- Check p_init_msg_list
2157: IF FND_API.to_boolean(p_init_msg_list) THEN
2158: FND_MSG_PUB.initialize;
2159: END IF;
2160:
2161: IF NOT FND_API.compatible_api_call (

Line 2161: IF NOT FND_API.compatible_api_call (

2157: IF FND_API.to_boolean(p_init_msg_list) THEN
2158: FND_MSG_PUB.initialize;
2159: END IF;
2160:
2161: IF NOT FND_API.compatible_api_call (
2162: l_api_version,
2163: p_api_version,
2164: l_api_name,
2165: G_PKG_NAME) THEN

Line 2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2162: l_api_version,
2163: p_api_version,
2164: l_api_name,
2165: G_PKG_NAME) THEN
2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2167:
2168: END IF;
2169:
2170: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2466: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2467: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2468: RAISE WSH_FAIL_CONT_ACTION;
2469: ELSE
2470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2471: END IF;
2472: END IF;
2473: --}
2474: END IF;

Line 2481: IF FND_API.TO_BOOLEAN(p_commit) THEN

2477: --
2478:
2479:
2480: --Bugfix 4070732 {
2481: IF FND_API.TO_BOOLEAN(p_commit) THEN
2482: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2483: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2484: WSH_UTIL_CORE.Process_stops_for_load_tender(
2485: p_reset_flags => FALSE,

Line 2515: IF FND_API.TO_BOOLEAN(p_commit) THEN

2511: --Bugfix 4070732 {
2512: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) <> upper(l_api_session_name)
2513: THEN --{
2514: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2515: IF FND_API.TO_BOOLEAN(p_commit) THEN
2516:
2517: IF l_debug_on THEN
2518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2519: END IF;

Line 2541: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN

2537: END IF;
2538:
2539: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
2540: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2541: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
2542: rollback to Container_Action_SP_Grp;
2543: end if;
2544: END IF;
2545: --x_return_status is set to success before the call to fte load tender

Line 2559: , p_encoded => FND_API.G_FALSE

2555:
2556: FND_MSG_PUB.Count_And_Get
2557: ( p_count => x_msg_count
2558: , p_data => x_msg_data
2559: , p_encoded => FND_API.G_FALSE
2560: );
2561: --
2562: IF l_debug_on THEN
2563: WSH_DEBUG_SV.pop(l_module_name);

Line 2626: , p_encoded => FND_API.G_FALSE

2622:
2623: FND_MSG_PUB.Count_And_Get
2624: ( p_count => x_msg_count
2625: , p_data => x_msg_data
2626: , p_encoded => FND_API.G_FALSE
2627: );
2628: IF l_debug_on THEN
2629: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');

Line 2674: , p_encoded => FND_API.G_FALSE

2670:
2671: FND_MSG_PUB.Count_And_Get
2672: ( p_count => x_msg_count
2673: , p_data => x_msg_data
2674: , p_encoded => FND_API.G_FALSE
2675: );
2676: IF l_debug_on THEN
2677: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2678: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');

Line 2721: , p_encoded => FND_API.G_FALSE

2717:
2718: FND_MSG_PUB.Count_And_Get
2719: ( p_count => x_msg_count
2720: , p_data => x_msg_data
2721: , p_encoded => FND_API.G_FALSE
2722: );
2723: IF l_debug_on THEN
2724: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2725: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');

Line 2768: , p_encoded => FND_API.G_FALSE

2764:
2765: FND_MSG_PUB.Count_And_Get
2766: ( p_count => x_msg_count
2767: , p_data => x_msg_data
2768: , p_encoded => FND_API.G_FALSE
2769: );
2770: IF l_debug_on THEN
2771: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2772: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');

Line 2815: , p_encoded => FND_API.G_FALSE

2811:
2812: FND_MSG_PUB.Count_And_Get
2813: ( p_count => x_msg_count
2814: , p_data => x_msg_data
2815: , p_encoded => FND_API.G_FALSE
2816: );
2817: IF l_debug_on THEN
2818: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_ACTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2819: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_ACTION');

Line 2861: , p_encoded => FND_API.G_FALSE

2857:
2858: FND_MSG_PUB.Count_And_Get
2859: ( p_count => x_msg_count
2860: , p_data => x_msg_data
2861: , p_encoded => FND_API.G_FALSE
2862: );
2863: IF l_debug_on THEN
2864: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2865: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');

Line 2868: WHEN FND_API.G_EXC_ERROR THEN

2864: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2865: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
2866: END IF;
2867: --
2868: WHEN FND_API.G_EXC_ERROR THEN
2869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2870: rollback to Container_Action_SP_Grp;
2871: --Bugfix 4070732 {
2872: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 2897: , p_encoded => FND_API.G_FALSE

2893:
2894: FND_MSG_PUB.Count_And_Get
2895: ( p_count => x_msg_count
2896: , p_data => x_msg_data
2897: , p_encoded => FND_API.G_FALSE
2898: );
2899:
2900: IF l_debug_on THEN
2901: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2900: IF l_debug_on THEN
2901: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2902: WSH_DEBUG_SV.pop(l_module_name);
2903: END IF;
2904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2905: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2906: rollback to Container_Action_SP_Grp;
2907: --Bugfix 4070732 {
2908: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 2930: , p_encoded => FND_API.G_FALSE

2926:
2927: FND_MSG_PUB.Count_And_Get
2928: ( p_count => x_msg_count
2929: , p_data => x_msg_data
2930: , p_encoded => FND_API.G_FALSE
2931: );
2932:
2933: IF l_debug_on THEN
2934: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2972: , p_encoded => FND_API.G_FALSE

2968:
2969: FND_MSG_PUB.Count_And_Get
2970: ( p_count => x_msg_count
2971: , p_data => x_msg_data
2972: , p_encoded => FND_API.G_FALSE
2973: );
2974:
2975: IF l_debug_on THEN
2976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);