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 1188: IF NOT FND_API.compatible_api_call (

1184: END IF;
1185: --
1186: SAVEPOINT Autopack_SP_Grp;
1187:
1188: IF NOT FND_API.compatible_api_call (
1189: l_api_version,
1190: p_api_version,
1191: l_api_name,
1192: G_PKG_NAME) THEN

Line 1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1189: l_api_version,
1190: p_api_version,
1191: l_api_name,
1192: G_PKG_NAME) THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195:
1196: -- Check p_init_msg_list
1197: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1197: IF FND_API.to_boolean(p_init_msg_list) THEN

1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195:
1196: -- Check p_init_msg_list
1197: IF FND_API.to_boolean(p_init_msg_list) THEN
1198: FND_MSG_PUB.initialize;
1199: END IF;
1200:
1201: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1392: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1393: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1394: RAISE WSH_FAIL_AUTOPACK;
1395: ELSE
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: END IF;
1398: END IF;
1399: --}
1400: END IF;

Line 1405: IF FND_API.TO_BOOLEAN(p_commit) THEN

1401: --
1402: -- K LPN CONV. rv
1403: --
1404: --Bugfix 4070732 {
1405: IF FND_API.TO_BOOLEAN(p_commit) THEN
1406:
1407: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1408:
1409: -- dbms_output.put_line('commit');

Line 1447: IF FND_API.TO_BOOLEAN(p_commit) THEN

1443: --Bugfix 4070732 {
1444: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN --{
1445: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1446:
1447: IF FND_API.TO_BOOLEAN(p_commit) THEN
1448:
1449: IF l_debug_on THEN
1450: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1451: END IF;

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

1467: END IF;
1468:
1469: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1470: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1471: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
1472: rollback to Autopack_SP_Grp;
1473: end if;
1474: END IF;
1475:

Line 1489: , p_encoded => FND_API.G_FALSE

1485:
1486: FND_MSG_PUB.Count_And_Get
1487: ( p_count => x_msg_count
1488: , p_data => x_msg_data
1489: , p_encoded => FND_API.G_FALSE
1490: );
1491:
1492:
1493: --

Line 1543: , p_encoded => FND_API.G_FALSE

1539:
1540: FND_MSG_PUB.Count_And_Get
1541: ( p_count => x_msg_count
1542: , p_data => x_msg_data
1543: , p_encoded => FND_API.G_FALSE
1544: );
1545:
1546: --
1547: -- Debug Statements

Line 1555: WHEN FND_API.G_EXC_ERROR then

1551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');
1552: END IF;
1553: --
1554:
1555: WHEN FND_API.G_EXC_ERROR then
1556: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1557: rollback to Autopack_SP_Grp;
1558:
1559: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 1584: , p_encoded => FND_API.G_FALSE

1580:
1581: FND_MSG_PUB.Count_And_Get
1582: ( p_count => x_msg_count
1583: , p_data => x_msg_data
1584: , p_encoded => FND_API.G_FALSE
1585: );
1586: --Bugfix 4070732 {
1587:
1588: --

Line 1637: , p_encoded => FND_API.G_FALSE

1633:
1634: FND_MSG_PUB.Count_And_Get
1635: ( p_count => x_msg_count
1636: , p_data => x_msg_data
1637: , p_encoded => FND_API.G_FALSE
1638: );
1639: --
1640: -- Debug Statements
1641: --

Line 1689: , p_encoded => FND_API.G_FALSE

1685:
1686: FND_MSG_PUB.Count_And_Get
1687: ( p_count => x_msg_count
1688: , p_data => x_msg_data
1689: , p_encoded => FND_API.G_FALSE
1690: );
1691: --
1692: -- Debug Statements
1693: --

Line 1759: , p_encoded => FND_API.G_FALSE

1755:
1756: FND_MSG_PUB.Count_And_Get
1757: ( p_count => x_msg_count
1758: , p_data => x_msg_data
1759: , p_encoded => FND_API.G_FALSE
1760: );
1761: IF l_debug_on THEN
1762: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1763: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');

Line 1797: , p_encoded => FND_API.G_FALSE

1793:
1794: FND_MSG_PUB.Count_And_Get
1795: ( p_count => x_msg_count
1796: , p_data => x_msg_data
1797: , p_encoded => FND_API.G_FALSE
1798: );
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_AUTOPACK exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_AUTOPACK');

Line 1845: , p_encoded => FND_API.G_FALSE

1841:
1842: FND_MSG_PUB.Count_And_Get
1843: ( p_count => x_msg_count
1844: , p_data => x_msg_data
1845: , p_encoded => FND_API.G_FALSE
1846: );
1847:
1848: --
1849: -- Debug Statements

Line 1895: , p_encoded => FND_API.G_FALSE

1891:
1892: FND_MSG_PUB.Count_And_Get
1893: ( p_count => x_msg_count
1894: , p_data => x_msg_data
1895: , p_encoded => FND_API.G_FALSE
1896: );
1897:
1898: --
1899: -- Debug Statements

Line 1946: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1942:
1943: PROCEDURE Container_Actions (
1944: -- Standard parameters
1945: p_api_version IN NUMBER,
1946: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1947: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1948: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1949: x_return_status OUT NOCOPY VARCHAR2,
1950: x_msg_count OUT NOCOPY NUMBER,

Line 1947: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1943: PROCEDURE Container_Actions (
1944: -- Standard parameters
1945: p_api_version IN NUMBER,
1946: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1947: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1948: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1949: x_return_status OUT NOCOPY VARCHAR2,
1950: x_msg_count OUT NOCOPY NUMBER,
1951: x_msg_data OUT NOCOPY VARCHAR2,

Line 1948: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1944: -- Standard parameters
1945: p_api_version IN NUMBER,
1946: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1947: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1948: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1949: x_return_status OUT NOCOPY VARCHAR2,
1950: x_msg_count OUT NOCOPY NUMBER,
1951: x_msg_data OUT NOCOPY VARCHAR2,
1952: -- program specific parameters

Line 2095: IF FND_API.to_boolean(p_init_msg_list) THEN

2091: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2092: END IF;
2093: --
2094: -- Check p_init_msg_list
2095: IF FND_API.to_boolean(p_init_msg_list) THEN
2096: FND_MSG_PUB.initialize;
2097: END IF;
2098:
2099: IF NOT FND_API.compatible_api_call (

Line 2099: IF NOT FND_API.compatible_api_call (

2095: IF FND_API.to_boolean(p_init_msg_list) THEN
2096: FND_MSG_PUB.initialize;
2097: END IF;
2098:
2099: IF NOT FND_API.compatible_api_call (
2100: l_api_version,
2101: p_api_version,
2102: l_api_name,
2103: G_PKG_NAME) THEN

Line 2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2100: l_api_version,
2101: p_api_version,
2102: l_api_name,
2103: G_PKG_NAME) THEN
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105:
2106: END IF;
2107:
2108: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2404: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2405: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2406: RAISE WSH_FAIL_CONT_ACTION;
2407: ELSE
2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409: END IF;
2410: END IF;
2411: --}
2412: END IF;

Line 2419: IF FND_API.TO_BOOLEAN(p_commit) THEN

2415: --
2416:
2417:
2418: --Bugfix 4070732 {
2419: IF FND_API.TO_BOOLEAN(p_commit) THEN
2420: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2421: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2422: WSH_UTIL_CORE.Process_stops_for_load_tender(
2423: p_reset_flags => FALSE,

Line 2453: IF FND_API.TO_BOOLEAN(p_commit) THEN

2449: --Bugfix 4070732 {
2450: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) <> upper(l_api_session_name)
2451: THEN --{
2452: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
2453: IF FND_API.TO_BOOLEAN(p_commit) THEN
2454:
2455: IF l_debug_on THEN
2456: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
2457: END IF;

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

2475: END IF;
2476:
2477: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
2478: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2479: IF NOT(FND_API.TO_BOOLEAN(p_commit)) THEN
2480: rollback to Container_Action_SP_Grp;
2481: end if;
2482: END IF;
2483: --x_return_status is set to success before the call to fte load tender

Line 2497: , p_encoded => FND_API.G_FALSE

2493:
2494: FND_MSG_PUB.Count_And_Get
2495: ( p_count => x_msg_count
2496: , p_data => x_msg_data
2497: , p_encoded => FND_API.G_FALSE
2498: );
2499: --
2500: IF l_debug_on THEN
2501: WSH_DEBUG_SV.pop(l_module_name);

Line 2564: , p_encoded => FND_API.G_FALSE

2560:
2561: FND_MSG_PUB.Count_And_Get
2562: ( p_count => x_msg_count
2563: , p_data => x_msg_data
2564: , p_encoded => FND_API.G_FALSE
2565: );
2566: IF l_debug_on THEN
2567: WSH_DEBUG_SV.logmsg(l_module_name,'G_RET_STS_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2568: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_RET_STS_WARNING');

Line 2612: , p_encoded => FND_API.G_FALSE

2608:
2609: FND_MSG_PUB.Count_And_Get
2610: ( p_count => x_msg_count
2611: , p_data => x_msg_data
2612: , p_encoded => FND_API.G_FALSE
2613: );
2614: IF l_debug_on THEN
2615: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DETAIL exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2616: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DETAIL');

Line 2659: , p_encoded => FND_API.G_FALSE

2655:
2656: FND_MSG_PUB.Count_And_Get
2657: ( p_count => x_msg_count
2658: , p_data => x_msg_data
2659: , p_encoded => FND_API.G_FALSE
2660: );
2661: IF l_debug_on THEN
2662: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2663: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT');

Line 2706: , p_encoded => FND_API.G_FALSE

2702:
2703: FND_MSG_PUB.Count_And_Get
2704: ( p_count => x_msg_count
2705: , p_data => x_msg_data
2706: , p_encoded => FND_API.G_FALSE
2707: );
2708: IF l_debug_on THEN
2709: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2710: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_DELIVERY');

Line 2753: , p_encoded => FND_API.G_FALSE

2749:
2750: FND_MSG_PUB.Count_And_Get
2751: ( p_count => x_msg_count
2752: , p_data => x_msg_data
2753: , p_encoded => FND_API.G_FALSE
2754: );
2755: IF l_debug_on THEN
2756: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_ACTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_ACTION');

Line 2799: , p_encoded => FND_API.G_FALSE

2795:
2796: FND_MSG_PUB.Count_And_Get
2797: ( p_count => x_msg_count
2798: , p_data => x_msg_data
2799: , p_encoded => FND_API.G_FALSE
2800: );
2801: IF l_debug_on THEN
2802: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2803: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');

Line 2806: WHEN FND_API.G_EXC_ERROR THEN

2802: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ENTITY_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2803: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ENTITY_TYPE');
2804: END IF;
2805: --
2806: WHEN FND_API.G_EXC_ERROR THEN
2807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2808: rollback to Container_Action_SP_Grp;
2809: --Bugfix 4070732 {
2810: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 2835: , p_encoded => FND_API.G_FALSE

2831:
2832: FND_MSG_PUB.Count_And_Get
2833: ( p_count => x_msg_count
2834: , p_data => x_msg_data
2835: , p_encoded => FND_API.G_FALSE
2836: );
2837:
2838: IF l_debug_on THEN
2839: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2838: IF l_debug_on THEN
2839: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2840: WSH_DEBUG_SV.pop(l_module_name);
2841: END IF;
2842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2843: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2844: rollback to Container_Action_SP_Grp;
2845: --Bugfix 4070732 {
2846: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 2868: , p_encoded => FND_API.G_FALSE

2864:
2865: FND_MSG_PUB.Count_And_Get
2866: ( p_count => x_msg_count
2867: , p_data => x_msg_data
2868: , p_encoded => FND_API.G_FALSE
2869: );
2870:
2871: IF l_debug_on THEN
2872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2910: , p_encoded => FND_API.G_FALSE

2906:
2907: FND_MSG_PUB.Count_And_Get
2908: ( p_count => x_msg_count
2909: , p_data => x_msg_data
2910: , p_encoded => FND_API.G_FALSE
2911: );
2912:
2913: IF l_debug_on THEN
2914: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);