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.AMS_DELIVKITITEM_PVT dependencies on FND_API

Line 21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

17:
18: PROCEDURE create_deliv_kit_item
19: (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
22: p_commit IN VARCHAR2 := FND_API.g_false,
23: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
24:
25: x_return_status OUT NOCOPY VARCHAR2,

Line 22: p_commit IN VARCHAR2 := FND_API.g_false,

18: PROCEDURE create_deliv_kit_item
19: (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
22: p_commit IN VARCHAR2 := FND_API.g_false,
23: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
24:
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,

Line 23: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

19: (
20: p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
22: p_commit IN VARCHAR2 := FND_API.g_false,
23: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
24:
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,

Line 75: IF FND_API.to_boolean(p_init_msg_list) THEN

71: IF (AMS_DEBUG_HIGH_ON) THEN
72: AMS_Utility_PVT.debug_message(l_full_name||': start');
73: END IF;
74:
75: IF FND_API.to_boolean(p_init_msg_list) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: IF NOT FND_API.compatible_api_call

Line 79: IF NOT FND_API.compatible_api_call

75: IF FND_API.to_boolean(p_init_msg_list) THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: IF NOT FND_API.compatible_api_call
80: (
81: l_api_version,
82: p_api_version,
83: l_api_name,

Line 86: RAISE FND_API.g_exc_unexpected_error;

82: p_api_version,
83: l_api_name,
84: g_pkg_name
85: ) THEN
86: RAISE FND_API.g_exc_unexpected_error;
87: END IF;
88:
89: x_return_status := FND_API.g_ret_sts_success;
90:

Line 89: x_return_status := FND_API.g_ret_sts_success;

85: ) THEN
86: RAISE FND_API.g_exc_unexpected_error;
87: END IF;
88:
89: x_return_status := FND_API.g_ret_sts_success;
90:
91: ----------------------- validate -----------------------
92: IF (AMS_DEBUG_HIGH_ON) THEN
93:

Line 108: IF l_return_status = FND_API.g_ret_sts_error THEN

104: x_msg_data => x_msg_data,
105: p_deliv_kit_item_rec => l_deliv_kit_item_rec
106: );
107:
108: IF l_return_status = FND_API.g_ret_sts_error THEN
109: RAISE FND_API.g_exc_error;
110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
111: RAISE FND_API.g_exc_unexpected_error;
112: END IF;

Line 109: RAISE FND_API.g_exc_error;

105: p_deliv_kit_item_rec => l_deliv_kit_item_rec
106: );
107:
108: IF l_return_status = FND_API.g_ret_sts_error THEN
109: RAISE FND_API.g_exc_error;
110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
111: RAISE FND_API.g_exc_unexpected_error;
112: END IF;
113:

Line 110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

106: );
107:
108: IF l_return_status = FND_API.g_ret_sts_error THEN
109: RAISE FND_API.g_exc_error;
110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
111: RAISE FND_API.g_exc_unexpected_error;
112: END IF;
113:
114: -------------------------- insert --------------------------

Line 111: RAISE FND_API.g_exc_unexpected_error;

107:
108: IF l_return_status = FND_API.g_ret_sts_error THEN
109: RAISE FND_API.g_exc_error;
110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
111: RAISE FND_API.g_exc_unexpected_error;
112: END IF;
113:
114: -------------------------- insert --------------------------
115: IF (AMS_DEBUG_HIGH_ON) THEN

Line 132: RAISE FND_API.g_exc_error;

128: THEN
129: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_KITPART_NOT_KIT');
130: FND_MSG_PUB.add;
131: END IF;
132: RAISE FND_API.g_exc_error;
133: END IF;
134:
135: /*
136: OPEN c_deliv_kit_part_count(l_deliv_kit_item_rec.deliverable_kit_id);

Line 147: RAISE FND_API.g_exc_error;

143: THEN
144: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_KIT_NOT_KITPART');
145: FND_MSG_PUB.add;
146: END IF;
147: RAISE FND_API.g_exc_error;
148: END IF;
149: */
150:
151: IF l_deliv_kit_item_rec.deliverable_kit_item_id IS NULL THEN

Line 244: -- p_init_msg_list => FND_API.g_false,

240: -- added by khung 03/22/2000
241: -- indicate kit has been defined for this deliverable
242: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
243: -- p_api_version => l_api_version,
244: -- p_init_msg_list => FND_API.g_false,
245: -- p_commit => FND_API.g_false,
246: -- p_validation_level => FND_API.g_valid_level_full,
247: --
248: -- x_return_status => l_return_status,

Line 245: -- p_commit => FND_API.g_false,

241: -- indicate kit has been defined for this deliverable
242: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
243: -- p_api_version => l_api_version,
244: -- p_init_msg_list => FND_API.g_false,
245: -- p_commit => FND_API.g_false,
246: -- p_validation_level => FND_API.g_valid_level_full,
247: --
248: -- x_return_status => l_return_status,
249: -- x_msg_count => x_msg_count,

Line 246: -- p_validation_level => FND_API.g_valid_level_full,

242: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
243: -- p_api_version => l_api_version,
244: -- p_init_msg_list => FND_API.g_false,
245: -- p_commit => FND_API.g_false,
246: -- p_validation_level => FND_API.g_valid_level_full,
247: --
248: -- x_return_status => l_return_status,
249: -- x_msg_count => x_msg_count,
250: -- x_msg_data => x_msg_data,

Line 257: --IF l_return_status = FND_API.g_ret_sts_error THEN

253: -- p_object_id => l_deliv_kit_item_rec.deliverable_kit_id,
254: -- p_attr => 'INVK',
255: -- p_attr_defined_flag => 'Y'
256: -- );
257: --IF l_return_status = FND_API.g_ret_sts_error THEN
258: -- RAISE FND_API.g_exc_error;
259: --ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
260: -- RAISE FND_API.g_exc_unexpected_error;
261: --END IF;

Line 258: -- RAISE FND_API.g_exc_error;

254: -- p_attr => 'INVK',
255: -- p_attr_defined_flag => 'Y'
256: -- );
257: --IF l_return_status = FND_API.g_ret_sts_error THEN
258: -- RAISE FND_API.g_exc_error;
259: --ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
260: -- RAISE FND_API.g_exc_unexpected_error;
261: --END IF;
262: */

Line 259: --ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

255: -- p_attr_defined_flag => 'Y'
256: -- );
257: --IF l_return_status = FND_API.g_ret_sts_error THEN
258: -- RAISE FND_API.g_exc_error;
259: --ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
260: -- RAISE FND_API.g_exc_unexpected_error;
261: --END IF;
262: */
263: ------------------------- finish -------------------------------

Line 260: -- RAISE FND_API.g_exc_unexpected_error;

256: -- );
257: --IF l_return_status = FND_API.g_ret_sts_error THEN
258: -- RAISE FND_API.g_exc_error;
259: --ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
260: -- RAISE FND_API.g_exc_unexpected_error;
261: --END IF;
262: */
263: ------------------------- finish -------------------------------
264: x_deliv_kit_item_id := l_deliv_kit_item_rec.deliverable_kit_item_id;

Line 266: IF FND_API.to_boolean(p_commit) THEN

262: */
263: ------------------------- finish -------------------------------
264: x_deliv_kit_item_id := l_deliv_kit_item_rec.deliverable_kit_item_id;
265:
266: IF FND_API.to_boolean(p_commit) THEN
267: COMMIT;
268: END IF;
269:
270: FND_MSG_PUB.count_and_get(

Line 271: p_encoded => FND_API.g_false,

267: COMMIT;
268: END IF;
269:
270: FND_MSG_PUB.count_and_get(
271: p_encoded => FND_API.g_false,
272: p_count => x_msg_count,
273: p_data => x_msg_data
274: );
275:

Line 286: WHEN FND_API.g_exc_error THEN

282: END IF;
283:
284: EXCEPTION
285:
286: WHEN FND_API.g_exc_error THEN
287: ROLLBACK TO create_deliv_kit_item;
288: x_return_status := FND_API.g_ret_sts_error;
289: FND_MSG_PUB.count_and_get(
290: p_encoded => FND_API.g_false,

Line 288: x_return_status := FND_API.g_ret_sts_error;

284: EXCEPTION
285:
286: WHEN FND_API.g_exc_error THEN
287: ROLLBACK TO create_deliv_kit_item;
288: x_return_status := FND_API.g_ret_sts_error;
289: FND_MSG_PUB.count_and_get(
290: p_encoded => FND_API.g_false,
291: p_count => x_msg_count,
292: p_data => x_msg_data

Line 290: p_encoded => FND_API.g_false,

286: WHEN FND_API.g_exc_error THEN
287: ROLLBACK TO create_deliv_kit_item;
288: x_return_status := FND_API.g_ret_sts_error;
289: FND_MSG_PUB.count_and_get(
290: p_encoded => FND_API.g_false,
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );
294:

Line 295: WHEN FND_API.g_exc_unexpected_error THEN

291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );
294:
295: WHEN FND_API.g_exc_unexpected_error THEN
296: ROLLBACK TO create_deliv_kit_item;
297: x_return_status := FND_API.g_ret_sts_unexp_error ;
298: FND_MSG_PUB.count_and_get(
299: p_encoded => FND_API.g_false,

Line 297: x_return_status := FND_API.g_ret_sts_unexp_error ;

293: );
294:
295: WHEN FND_API.g_exc_unexpected_error THEN
296: ROLLBACK TO create_deliv_kit_item;
297: x_return_status := FND_API.g_ret_sts_unexp_error ;
298: FND_MSG_PUB.count_and_get(
299: p_encoded => FND_API.g_false,
300: p_count => x_msg_count,
301: p_data => x_msg_data

Line 299: p_encoded => FND_API.g_false,

295: WHEN FND_API.g_exc_unexpected_error THEN
296: ROLLBACK TO create_deliv_kit_item;
297: x_return_status := FND_API.g_ret_sts_unexp_error ;
298: FND_MSG_PUB.count_and_get(
299: p_encoded => FND_API.g_false,
300: p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303:

Line 307: x_return_status := FND_API.g_ret_sts_unexp_error ;

303:
304:
305: WHEN OTHERS THEN
306: ROLLBACK TO create_deliv_kit_item;
307: x_return_status := FND_API.g_ret_sts_unexp_error ;
308:
309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
310: THEN
311: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 315: p_encoded => FND_API.g_false,

311: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
312: END IF;
313:
314: FND_MSG_PUB.count_and_get(
315: p_encoded => FND_API.g_false,
316: p_count => x_msg_count,
317: p_data => x_msg_data
318: );
319:

Line 334: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

330:
331: PROCEDURE delete_deliv_kit_item
332: (
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336:
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY NUMBER,

Line 335: p_commit IN VARCHAR2 := FND_API.g_false,

331: PROCEDURE delete_deliv_kit_item
332: (
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336:
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY NUMBER,
339: x_msg_data OUT NOCOPY VARCHAR2,

Line 380: IF FND_API.to_boolean(p_init_msg_list) THEN

376: AMS_Utility_PVT.debug_message(l_full_name||': start');
377:
378: END IF;
379:
380: IF FND_API.to_boolean(p_init_msg_list) THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: IF NOT FND_API.compatible_api_call(

Line 384: IF NOT FND_API.compatible_api_call(

380: IF FND_API.to_boolean(p_init_msg_list) THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: IF NOT FND_API.compatible_api_call(
385: l_api_version,
386: p_api_version,
387: l_api_name,
388: g_pkg_name

Line 390: RAISE FND_API.g_exc_unexpected_error;

386: p_api_version,
387: l_api_name,
388: g_pkg_name
389: ) THEN
390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;
392:
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:

Line 393: x_return_status := FND_API.G_RET_STS_SUCCESS;

389: ) THEN
390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;
392:
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: ------------------------ delete ------------------------
396: IF (AMS_DEBUG_HIGH_ON) THEN
397:

Line 419: RAISE FND_API.g_exc_error;

415: THEN
416: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
417: FND_MSG_PUB.add;
418: END IF;
419: RAISE FND_API.g_exc_error;
420: END IF;
421:
422: IF (AMS_DEBUG_HIGH_ON) THEN
423:

Line 452: -- p_init_msg_list => FND_API.g_false,

448: -- remove the 'check' icon when there is no kit item associated with
449: -- this deliverable
450: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
451: -- p_api_version => l_api_version,
452: -- p_init_msg_list => FND_API.g_false,
453: -- p_commit => FND_API.g_false,
454: -- x_return_status => x_return_status,
455: -- x_msg_count => x_msg_count,
456: -- x_msg_data => x_msg_data,

Line 453: -- p_commit => FND_API.g_false,

449: -- this deliverable
450: -- AMS_ObjectAttribute_PVT.modify_object_attribute(
451: -- p_api_version => l_api_version,
452: -- p_init_msg_list => FND_API.g_false,
453: -- p_commit => FND_API.g_false,
454: -- x_return_status => x_return_status,
455: -- x_msg_count => x_msg_count,
456: -- x_msg_data => x_msg_data,
457: -- p_object_type => 'DELV',

Line 462: -- IF x_return_status = FND_API.g_ret_sts_error THEN

458: -- p_object_id => l_kit_id,
459: -- p_attr => 'INVK',
460: -- p_attr_defined_flag => 'N'
461: -- );
462: -- IF x_return_status = FND_API.g_ret_sts_error THEN
463: -- RAISE FND_API.g_exc_error;
464: -- ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
465: -- RAISE FND_API.g_exc_unexpected_error;
466: -- END IF;

Line 463: -- RAISE FND_API.g_exc_error;

459: -- p_attr => 'INVK',
460: -- p_attr_defined_flag => 'N'
461: -- );
462: -- IF x_return_status = FND_API.g_ret_sts_error THEN
463: -- RAISE FND_API.g_exc_error;
464: -- ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
465: -- RAISE FND_API.g_exc_unexpected_error;
466: -- END IF;
467:

Line 464: -- ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

460: -- p_attr_defined_flag => 'N'
461: -- );
462: -- IF x_return_status = FND_API.g_ret_sts_error THEN
463: -- RAISE FND_API.g_exc_error;
464: -- ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
465: -- RAISE FND_API.g_exc_unexpected_error;
466: -- END IF;
467:
468: -- END IF;

Line 465: -- RAISE FND_API.g_exc_unexpected_error;

461: -- );
462: -- IF x_return_status = FND_API.g_ret_sts_error THEN
463: -- RAISE FND_API.g_exc_error;
464: -- ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
465: -- RAISE FND_API.g_exc_unexpected_error;
466: -- END IF;
467:
468: -- END IF;
469:

Line 473: IF FND_API.to_boolean(p_commit) THEN

469:
470: */
471:
472: -------------------- finish --------------------------
473: IF FND_API.to_boolean(p_commit) THEN
474: COMMIT;
475: END IF;
476:
477: FND_MSG_PUB.count_and_get(

Line 478: p_encoded => FND_API.g_false,

474: COMMIT;
475: END IF;
476:
477: FND_MSG_PUB.count_and_get(
478: p_encoded => FND_API.g_false,
479: p_count => x_msg_count,
480: p_data => x_msg_data
481: );
482:

Line 493: WHEN FND_API.g_exc_error THEN

489: END IF;
490:
491: EXCEPTION
492:
493: WHEN FND_API.g_exc_error THEN
494: ROLLBACK TO delete_deliv_kit_item;
495: x_return_status := FND_API.g_ret_sts_error;
496: FND_MSG_PUB.count_and_get(
497: p_encoded => FND_API.g_false,

Line 495: x_return_status := FND_API.g_ret_sts_error;

491: EXCEPTION
492:
493: WHEN FND_API.g_exc_error THEN
494: ROLLBACK TO delete_deliv_kit_item;
495: x_return_status := FND_API.g_ret_sts_error;
496: FND_MSG_PUB.count_and_get(
497: p_encoded => FND_API.g_false,
498: p_count => x_msg_count,
499: p_data => x_msg_data

Line 497: p_encoded => FND_API.g_false,

493: WHEN FND_API.g_exc_error THEN
494: ROLLBACK TO delete_deliv_kit_item;
495: x_return_status := FND_API.g_ret_sts_error;
496: FND_MSG_PUB.count_and_get(
497: p_encoded => FND_API.g_false,
498: p_count => x_msg_count,
499: p_data => x_msg_data
500: );
501:

Line 502: WHEN FND_API.g_exc_unexpected_error THEN

498: p_count => x_msg_count,
499: p_data => x_msg_data
500: );
501:
502: WHEN FND_API.g_exc_unexpected_error THEN
503: ROLLBACK TO delete_deliv_kit_item;
504: x_return_status := FND_API.g_ret_sts_unexp_error ;
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,

Line 504: x_return_status := FND_API.g_ret_sts_unexp_error ;

500: );
501:
502: WHEN FND_API.g_exc_unexpected_error THEN
503: ROLLBACK TO delete_deliv_kit_item;
504: x_return_status := FND_API.g_ret_sts_unexp_error ;
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,
507: p_count => x_msg_count,
508: p_data => x_msg_data

Line 506: p_encoded => FND_API.g_false,

502: WHEN FND_API.g_exc_unexpected_error THEN
503: ROLLBACK TO delete_deliv_kit_item;
504: x_return_status := FND_API.g_ret_sts_unexp_error ;
505: FND_MSG_PUB.count_and_get(
506: p_encoded => FND_API.g_false,
507: p_count => x_msg_count,
508: p_data => x_msg_data
509: );
510:

Line 513: x_return_status := FND_API.g_ret_sts_unexp_error ;

509: );
510:
511: WHEN OTHERS THEN
512: ROLLBACK TO delete_deliv_kit_item;
513: x_return_status := FND_API.g_ret_sts_unexp_error ;
514:
515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
516: THEN
517: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 521: p_encoded => FND_API.g_false,

517: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
518: END IF;
519:
520: FND_MSG_PUB.count_and_get(
521: p_encoded => FND_API.g_false,
522: p_count => x_msg_count,
523: p_data => x_msg_data
524: );
525:

Line 539: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

535:
536: PROCEDURE lock_deliv_kit_item
537: (
538: p_api_version IN NUMBER,
539: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
540:
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
543: x_msg_data OUT NOCOPY VARCHAR2,

Line 572: IF FND_API.to_boolean(p_init_msg_list) THEN

568:
569: AMS_Utility_PVT.debug_message(l_full_name||': start');
570: END IF;
571:
572: IF FND_API.to_boolean(p_init_msg_list) THEN
573: FND_MSG_PUB.initialize;
574: END IF;
575:
576: IF NOT FND_API.compatible_api_call(

Line 576: IF NOT FND_API.compatible_api_call(

572: IF FND_API.to_boolean(p_init_msg_list) THEN
573: FND_MSG_PUB.initialize;
574: END IF;
575:
576: IF NOT FND_API.compatible_api_call(
577: l_api_version,
578: p_api_version,
579: l_api_name,
580: g_pkg_name

Line 582: RAISE FND_API.g_exc_unexpected_error;

578: p_api_version,
579: l_api_name,
580: g_pkg_name
581: ) THEN
582: RAISE FND_API.g_exc_unexpected_error;
583: END IF;
584:
585: x_return_status := FND_API.G_RET_STS_SUCCESS;
586:

Line 585: x_return_status := FND_API.G_RET_STS_SUCCESS;

581: ) THEN
582: RAISE FND_API.g_exc_unexpected_error;
583: END IF;
584:
585: x_return_status := FND_API.G_RET_STS_SUCCESS;
586:
587: ------------------------ lock -------------------------
588: IF (AMS_DEBUG_HIGH_ON) THEN
589:

Line 601: RAISE FND_API.g_exc_error;

597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
598: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
599: FND_MSG_PUB.add;
600: END IF;
601: RAISE FND_API.g_exc_error;
602: END IF;
603: CLOSE c_deliv_kit_item;
604:
605: -------------------- finish --------------------------

Line 607: p_encoded => FND_API.g_false,

603: CLOSE c_deliv_kit_item;
604:
605: -------------------- finish --------------------------
606: FND_MSG_PUB.count_and_get(
607: p_encoded => FND_API.g_false,
608: p_count => x_msg_count,
609: p_data => x_msg_data
610: );
611:

Line 623: x_return_status := FND_API.g_ret_sts_error;

619:
620: EXCEPTION
621:
622: WHEN AMS_Utility_PVT.resource_locked THEN
623: x_return_status := FND_API.g_ret_sts_error;
624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
625: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
626: FND_MSG_PUB.add;
627: END IF;

Line 630: p_encoded => FND_API.g_false,

626: FND_MSG_PUB.add;
627: END IF;
628:
629: FND_MSG_PUB.count_and_get(
630: p_encoded => FND_API.g_false,
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634:

Line 635: WHEN FND_API.g_exc_error THEN

631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634:
635: WHEN FND_API.g_exc_error THEN
636: x_return_status := FND_API.g_ret_sts_error;
637: FND_MSG_PUB.count_and_get(
638: p_encoded => FND_API.g_false,
639: p_count => x_msg_count,

Line 636: x_return_status := FND_API.g_ret_sts_error;

632: p_data => x_msg_data
633: );
634:
635: WHEN FND_API.g_exc_error THEN
636: x_return_status := FND_API.g_ret_sts_error;
637: FND_MSG_PUB.count_and_get(
638: p_encoded => FND_API.g_false,
639: p_count => x_msg_count,
640: p_data => x_msg_data

Line 638: p_encoded => FND_API.g_false,

634:
635: WHEN FND_API.g_exc_error THEN
636: x_return_status := FND_API.g_ret_sts_error;
637: FND_MSG_PUB.count_and_get(
638: p_encoded => FND_API.g_false,
639: p_count => x_msg_count,
640: p_data => x_msg_data
641: );
642:

Line 643: WHEN FND_API.g_exc_unexpected_error THEN

639: p_count => x_msg_count,
640: p_data => x_msg_data
641: );
642:
643: WHEN FND_API.g_exc_unexpected_error THEN
644: x_return_status := FND_API.g_ret_sts_unexp_error ;
645: FND_MSG_PUB.count_and_get(
646: p_encoded => FND_API.g_false,
647: p_count => x_msg_count,

Line 644: x_return_status := FND_API.g_ret_sts_unexp_error ;

640: p_data => x_msg_data
641: );
642:
643: WHEN FND_API.g_exc_unexpected_error THEN
644: x_return_status := FND_API.g_ret_sts_unexp_error ;
645: FND_MSG_PUB.count_and_get(
646: p_encoded => FND_API.g_false,
647: p_count => x_msg_count,
648: p_data => x_msg_data

Line 646: p_encoded => FND_API.g_false,

642:
643: WHEN FND_API.g_exc_unexpected_error THEN
644: x_return_status := FND_API.g_ret_sts_unexp_error ;
645: FND_MSG_PUB.count_and_get(
646: p_encoded => FND_API.g_false,
647: p_count => x_msg_count,
648: p_data => x_msg_data
649: );
650:

Line 652: x_return_status := FND_API.g_ret_sts_unexp_error ;

648: p_data => x_msg_data
649: );
650:
651: WHEN OTHERS THEN
652: x_return_status := FND_API.g_ret_sts_unexp_error ;
653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
654: THEN
655: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
656: END IF;

Line 659: p_encoded => FND_API.g_false,

655: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
656: END IF;
657:
658: FND_MSG_PUB.count_and_get(
659: p_encoded => FND_API.g_false,
660: p_count => x_msg_count,
661: p_data => x_msg_data
662: );
663:

Line 678: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

674:
675: PROCEDURE update_deliv_kit_item
676: (
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
679: p_commit IN VARCHAR2 := FND_API.g_false,
680: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
681:
682: x_return_status OUT NOCOPY VARCHAR2,

Line 679: p_commit IN VARCHAR2 := FND_API.g_false,

675: PROCEDURE update_deliv_kit_item
676: (
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
679: p_commit IN VARCHAR2 := FND_API.g_false,
680: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
681:
682: x_return_status OUT NOCOPY VARCHAR2,
683: x_msg_count OUT NOCOPY NUMBER,

Line 680: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

676: (
677: p_api_version IN NUMBER,
678: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
679: p_commit IN VARCHAR2 := FND_API.g_false,
680: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
681:
682: x_return_status OUT NOCOPY VARCHAR2,
683: x_msg_count OUT NOCOPY NUMBER,
684: x_msg_data OUT NOCOPY VARCHAR2,

Line 711: IF FND_API.to_boolean(p_init_msg_list) THEN

707: AMS_Utility_PVT.debug_message(l_full_name||': start');
708:
709: END IF;
710:
711: IF FND_API.to_boolean(p_init_msg_list) THEN
712: FND_MSG_PUB.initialize;
713: END IF;
714:
715: IF NOT FND_API.compatible_api_call(

Line 715: IF NOT FND_API.compatible_api_call(

711: IF FND_API.to_boolean(p_init_msg_list) THEN
712: FND_MSG_PUB.initialize;
713: END IF;
714:
715: IF NOT FND_API.compatible_api_call(
716: l_api_version,
717: p_api_version,
718: l_api_name,
719: g_pkg_name

Line 721: RAISE FND_API.g_exc_unexpected_error;

717: p_api_version,
718: l_api_name,
719: g_pkg_name
720: ) THEN
721: RAISE FND_API.g_exc_unexpected_error;
722: END IF;
723:
724: x_return_status := FND_API.G_RET_STS_SUCCESS;
725:

Line 724: x_return_status := FND_API.G_RET_STS_SUCCESS;

720: ) THEN
721: RAISE FND_API.g_exc_unexpected_error;
722: END IF;
723:
724: x_return_status := FND_API.G_RET_STS_SUCCESS;
725:
726: ----------------------- validate ----------------------
727: IF (AMS_DEBUG_HIGH_ON) THEN
728:

Line 740: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

736: p_validation_mode => JTF_PLSQL_API.g_update,
737: x_return_status => l_return_status
738: );
739:
740: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
741: RAISE FND_API.g_exc_unexpected_error;
742: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
743: RAISE FND_API.g_exc_error;
744: END IF;

Line 741: RAISE FND_API.g_exc_unexpected_error;

737: x_return_status => l_return_status
738: );
739:
740: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
741: RAISE FND_API.g_exc_unexpected_error;
742: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
743: RAISE FND_API.g_exc_error;
744: END IF;
745: END IF;

Line 742: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

738: );
739:
740: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
741: RAISE FND_API.g_exc_unexpected_error;
742: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
743: RAISE FND_API.g_exc_error;
744: END IF;
745: END IF;
746:

Line 743: RAISE FND_API.g_exc_error;

739:
740: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
741: RAISE FND_API.g_exc_unexpected_error;
742: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
743: RAISE FND_API.g_exc_error;
744: END IF;
745: END IF;
746:
747: -- replace g_miss_char/num/date with current column values

Line 758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

754: p_complete_rec => l_deliv_kit_item_rec,
755: x_return_status => l_return_status
756: );
757:
758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
759: RAISE FND_API.g_exc_unexpected_error;
760: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
761: RAISE FND_API.g_exc_error;
762: END IF;

Line 759: RAISE FND_API.g_exc_unexpected_error;

755: x_return_status => l_return_status
756: );
757:
758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
759: RAISE FND_API.g_exc_unexpected_error;
760: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
761: RAISE FND_API.g_exc_error;
762: END IF;
763: END IF;

Line 760: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

756: );
757:
758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
759: RAISE FND_API.g_exc_unexpected_error;
760: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
761: RAISE FND_API.g_exc_error;
762: END IF;
763: END IF;
764:

Line 761: RAISE FND_API.g_exc_error;

757:
758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
759: RAISE FND_API.g_exc_unexpected_error;
760: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
761: RAISE FND_API.g_exc_error;
762: END IF;
763: END IF;
764:
765: -------------------------- update --------------------

Line 804: RAISE FND_API.g_exc_error;

800: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
801: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
802: FND_MSG_PUB.add;
803: END IF;
804: RAISE FND_API.g_exc_error;
805: END IF;
806:
807: -------------------- finish --------------------------
808: IF FND_API.to_boolean(p_commit) THEN

Line 808: IF FND_API.to_boolean(p_commit) THEN

804: RAISE FND_API.g_exc_error;
805: END IF;
806:
807: -------------------- finish --------------------------
808: IF FND_API.to_boolean(p_commit) THEN
809: COMMIT;
810: END IF;
811:
812: FND_MSG_PUB.count_and_get(

Line 813: p_encoded => FND_API.g_false,

809: COMMIT;
810: END IF;
811:
812: FND_MSG_PUB.count_and_get(
813: p_encoded => FND_API.g_false,
814: p_count => x_msg_count,
815: p_data => x_msg_data
816: );
817:

Line 828: WHEN FND_API.g_exc_error THEN

824: END IF;
825:
826: EXCEPTION
827:
828: WHEN FND_API.g_exc_error THEN
829: ROLLBACK TO update_deliv_kit_item;
830: x_return_status := FND_API.g_ret_sts_error;
831: FND_MSG_PUB.count_and_get(
832: p_encoded => FND_API.g_false,

Line 830: x_return_status := FND_API.g_ret_sts_error;

826: EXCEPTION
827:
828: WHEN FND_API.g_exc_error THEN
829: ROLLBACK TO update_deliv_kit_item;
830: x_return_status := FND_API.g_ret_sts_error;
831: FND_MSG_PUB.count_and_get(
832: p_encoded => FND_API.g_false,
833: p_count => x_msg_count,
834: p_data => x_msg_data

Line 832: p_encoded => FND_API.g_false,

828: WHEN FND_API.g_exc_error THEN
829: ROLLBACK TO update_deliv_kit_item;
830: x_return_status := FND_API.g_ret_sts_error;
831: FND_MSG_PUB.count_and_get(
832: p_encoded => FND_API.g_false,
833: p_count => x_msg_count,
834: p_data => x_msg_data
835: );
836:

Line 837: WHEN FND_API.g_exc_unexpected_error THEN

833: p_count => x_msg_count,
834: p_data => x_msg_data
835: );
836:
837: WHEN FND_API.g_exc_unexpected_error THEN
838: ROLLBACK TO update_deliv_kit_item;
839: x_return_status := FND_API.g_ret_sts_unexp_error ;
840: FND_MSG_PUB.count_and_get(
841: p_encoded => FND_API.g_false,

Line 839: x_return_status := FND_API.g_ret_sts_unexp_error ;

835: );
836:
837: WHEN FND_API.g_exc_unexpected_error THEN
838: ROLLBACK TO update_deliv_kit_item;
839: x_return_status := FND_API.g_ret_sts_unexp_error ;
840: FND_MSG_PUB.count_and_get(
841: p_encoded => FND_API.g_false,
842: p_count => x_msg_count,
843: p_data => x_msg_data

Line 841: p_encoded => FND_API.g_false,

837: WHEN FND_API.g_exc_unexpected_error THEN
838: ROLLBACK TO update_deliv_kit_item;
839: x_return_status := FND_API.g_ret_sts_unexp_error ;
840: FND_MSG_PUB.count_and_get(
841: p_encoded => FND_API.g_false,
842: p_count => x_msg_count,
843: p_data => x_msg_data
844: );
845:

Line 848: x_return_status := FND_API.g_ret_sts_unexp_error ;

844: );
845:
846: WHEN OTHERS THEN
847: ROLLBACK TO update_deliv_kit_item;
848: x_return_status := FND_API.g_ret_sts_unexp_error ;
849:
850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
851: THEN
852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 856: p_encoded => FND_API.g_false,

852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854:
855: FND_MSG_PUB.count_and_get(
856: p_encoded => FND_API.g_false,
857: p_count => x_msg_count,
858: p_data => x_msg_data
859: );
860:

Line 874: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

870:
871: PROCEDURE validate_deliv_kit_item
872: (
873: p_api_version IN NUMBER,
874: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
875: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
876:
877: x_return_status OUT NOCOPY VARCHAR2,
878: x_msg_count OUT NOCOPY NUMBER,

Line 875: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

871: PROCEDURE validate_deliv_kit_item
872: (
873: p_api_version IN NUMBER,
874: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
875: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
876:
877: x_return_status OUT NOCOPY VARCHAR2,
878: x_msg_count OUT NOCOPY NUMBER,
879: x_msg_data OUT NOCOPY VARCHAR2,

Line 898: IF FND_API.to_boolean(p_init_msg_list) THEN

894: IF (AMS_DEBUG_HIGH_ON) THEN
895: AMS_Utility_PVT.debug_message(l_full_name||': start');
896: END IF;
897:
898: IF FND_API.to_boolean(p_init_msg_list) THEN
899: FND_MSG_PUB.initialize;
900: END IF;
901:
902: IF NOT FND_API.compatible_api_call(

Line 902: IF NOT FND_API.compatible_api_call(

898: IF FND_API.to_boolean(p_init_msg_list) THEN
899: FND_MSG_PUB.initialize;
900: END IF;
901:
902: IF NOT FND_API.compatible_api_call(
903: l_api_version,
904: p_api_version,
905: l_api_name,
906: g_pkg_name

Line 908: RAISE FND_API.g_exc_unexpected_error;

904: p_api_version,
905: l_api_name,
906: g_pkg_name
907: ) THEN
908: RAISE FND_API.g_exc_unexpected_error;
909: END IF;
910:
911: x_return_status := FND_API.g_ret_sts_success;
912:

Line 911: x_return_status := FND_API.g_ret_sts_success;

907: ) THEN
908: RAISE FND_API.g_exc_unexpected_error;
909: END IF;
910:
911: x_return_status := FND_API.g_ret_sts_success;
912:
913: ---------------------- validate ------------------------
914: IF (AMS_DEBUG_HIGH_ON) THEN
915: AMS_Utility_PVT.debug_message(l_full_name||': check items');

Line 926: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

922: p_validation_mode => JTF_PLSQL_API.g_create,
923: x_return_status => l_return_status
924: );
925:
926: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
927: RAISE FND_API.g_exc_unexpected_error;
928: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
929: RAISE FND_API.g_exc_error;
930: END IF;

Line 927: RAISE FND_API.g_exc_unexpected_error;

923: x_return_status => l_return_status
924: );
925:
926: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
927: RAISE FND_API.g_exc_unexpected_error;
928: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
929: RAISE FND_API.g_exc_error;
930: END IF;
931: END IF;

Line 928: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

924: );
925:
926: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
927: RAISE FND_API.g_exc_unexpected_error;
928: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
929: RAISE FND_API.g_exc_error;
930: END IF;
931: END IF;
932:

Line 929: RAISE FND_API.g_exc_error;

925:
926: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
927: RAISE FND_API.g_exc_unexpected_error;
928: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
929: RAISE FND_API.g_exc_error;
930: END IF;
931: END IF;
932:
933: IF (AMS_DEBUG_HIGH_ON) THEN

Line 945: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

941: p_complete_rec => NULL,
942: x_return_status => l_return_status
943: );
944:
945: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
946: RAISE FND_API.g_exc_unexpected_error;
947: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
948: RAISE FND_API.g_exc_error;
949: END IF;

Line 946: RAISE FND_API.g_exc_unexpected_error;

942: x_return_status => l_return_status
943: );
944:
945: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
946: RAISE FND_API.g_exc_unexpected_error;
947: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
948: RAISE FND_API.g_exc_error;
949: END IF;
950: END IF;

Line 947: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

943: );
944:
945: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
946: RAISE FND_API.g_exc_unexpected_error;
947: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
948: RAISE FND_API.g_exc_error;
949: END IF;
950: END IF;
951:

Line 948: RAISE FND_API.g_exc_error;

944:
945: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
946: RAISE FND_API.g_exc_unexpected_error;
947: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
948: RAISE FND_API.g_exc_error;
949: END IF;
950: END IF;
951:
952: -------------------- finish --------------------------

Line 955: p_encoded => FND_API.g_false,

951:
952: -------------------- finish --------------------------
953: FND_MSG_PUB.count_and_get
954: (
955: p_encoded => FND_API.g_false,
956: p_count => x_msg_count,
957: p_data => x_msg_data
958: );
959:

Line 970: WHEN FND_API.g_exc_error THEN

966: END IF;
967:
968: EXCEPTION
969:
970: WHEN FND_API.g_exc_error THEN
971: x_return_status := FND_API.g_ret_sts_error;
972: FND_MSG_PUB.count_and_get(
973: p_encoded => FND_API.g_false,
974: p_count => x_msg_count,

Line 971: x_return_status := FND_API.g_ret_sts_error;

967:
968: EXCEPTION
969:
970: WHEN FND_API.g_exc_error THEN
971: x_return_status := FND_API.g_ret_sts_error;
972: FND_MSG_PUB.count_and_get(
973: p_encoded => FND_API.g_false,
974: p_count => x_msg_count,
975: p_data => x_msg_data

Line 973: p_encoded => FND_API.g_false,

969:
970: WHEN FND_API.g_exc_error THEN
971: x_return_status := FND_API.g_ret_sts_error;
972: FND_MSG_PUB.count_and_get(
973: p_encoded => FND_API.g_false,
974: p_count => x_msg_count,
975: p_data => x_msg_data
976: );
977:

Line 978: WHEN FND_API.g_exc_unexpected_error THEN

974: p_count => x_msg_count,
975: p_data => x_msg_data
976: );
977:
978: WHEN FND_API.g_exc_unexpected_error THEN
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: FND_MSG_PUB.count_and_get(
981: p_encoded => FND_API.g_false,
982: p_count => x_msg_count,

Line 979: x_return_status := FND_API.g_ret_sts_unexp_error ;

975: p_data => x_msg_data
976: );
977:
978: WHEN FND_API.g_exc_unexpected_error THEN
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: FND_MSG_PUB.count_and_get(
981: p_encoded => FND_API.g_false,
982: p_count => x_msg_count,
983: p_data => x_msg_data

Line 981: p_encoded => FND_API.g_false,

977:
978: WHEN FND_API.g_exc_unexpected_error THEN
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: FND_MSG_PUB.count_and_get(
981: p_encoded => FND_API.g_false,
982: p_count => x_msg_count,
983: p_data => x_msg_data
984: );
985:

Line 987: x_return_status := FND_API.g_ret_sts_unexp_error;

983: p_data => x_msg_data
984: );
985:
986: WHEN OTHERS THEN
987: x_return_status := FND_API.g_ret_sts_unexp_error;
988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
989: THEN
990: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
991: END IF;

Line 995: p_encoded => FND_API.g_false,

991: END IF;
992:
993: FND_MSG_PUB.count_and_get
994: (
995: p_encoded => FND_API.g_false,
996: p_count => x_msg_count,
997: p_data => x_msg_data
998: );
999:

Line 1020: x_return_status := FND_API.g_ret_sts_success;

1016: IS
1017:
1018: BEGIN
1019:
1020: x_return_status := FND_API.g_ret_sts_success;
1021:
1022: -------------------- put required items here ---------------------
1023:
1024: IF p_deliv_kit_item_rec.deliverable_kit_id IS NULL THEN

Line 1031: x_return_status := FND_API.g_ret_sts_error;

1027: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_KIT_NO_KIT_ID');
1028: FND_MSG_PUB.add;
1029: END IF;
1030:
1031: x_return_status := FND_API.g_ret_sts_error;
1032: RETURN;
1033: END IF;
1034:
1035: IF p_deliv_kit_item_rec.deliverable_kit_part_id IS NULL THEN

Line 1042: x_return_status := FND_API.g_ret_sts_error;

1038: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_KIT_NO_KIT_PART_ID');
1039: FND_MSG_PUB.add;
1040: END IF;
1041:
1042: x_return_status := FND_API.g_ret_sts_error;
1043: RETURN;
1044: END IF;
1045:
1046: END check_deliv_kit_item_req_items;

Line 1067: x_return_status := FND_API.g_ret_sts_success;

1063: l_valid_flag VARCHAR2(1);
1064:
1065: BEGIN
1066:
1067: x_return_status := FND_API.g_ret_sts_success;
1068:
1069: -- For create_deliv_kit_item, when deliverable_kit_item_id is passed in, we need to
1070: -- check if this deliverable_kit_item_id is unique.
1071: IF p_validation_mode = JTF_PLSQL_API.g_create

Line 1077: ) = FND_API.g_false

1073: THEN
1074: IF AMS_Utility_PVT.check_uniqueness(
1075: 'ams_deliv_kit_items',
1076: 'deliverable_kit_item_id = ' || p_deliv_kit_item_rec.deliverable_kit_item_id
1077: ) = FND_API.g_false
1078: THEN
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1080: THEN
1081: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_KIT_ITEM_DUP_ID');

Line 1084: x_return_status := FND_API.g_ret_sts_error;

1080: THEN
1081: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_KIT_ITEM_DUP_ID');
1082: FND_MSG_PUB.add;
1083: END IF;
1084: x_return_status := FND_API.g_ret_sts_error;
1085: RETURN;
1086: END IF;
1087: END IF;
1088:

Line 1109: x_return_status := FND_API.g_ret_sts_success;

1105: IS
1106:
1107: BEGIN
1108:
1109: x_return_status := FND_API.g_ret_sts_success;
1110:
1111: --------------------- deliverable_kit_id ----------------------------
1112: IF p_deliv_kit_item_rec.deliverable_kit_id <> FND_API.g_miss_num
1113: AND p_deliv_kit_item_rec.deliverable_kit_id IS NOT NULL

Line 1112: IF p_deliv_kit_item_rec.deliverable_kit_id <> FND_API.g_miss_num

1108:
1109: x_return_status := FND_API.g_ret_sts_success;
1110:
1111: --------------------- deliverable_kit_id ----------------------------
1112: IF p_deliv_kit_item_rec.deliverable_kit_id <> FND_API.g_miss_num
1113: AND p_deliv_kit_item_rec.deliverable_kit_id IS NOT NULL
1114: THEN
1115: IF AMS_Utility_PVT.check_fk_exists(
1116: 'ams_deliverables_all_b',

Line 1121: ) = FND_API.g_false

1117: 'deliverable_id',
1118: p_deliv_kit_item_rec.deliverable_kit_id,
1119: AMS_Utility_PVT.g_number,
1120: NULL
1121: ) = FND_API.g_false
1122: THEN
1123: AMS_Utility_PVT.Error_Message('AMS_DELIV_KIT_NO_KIT_ID');
1124: x_return_status := FND_API.g_ret_sts_error;
1125: RETURN;

Line 1124: x_return_status := FND_API.g_ret_sts_error;

1120: NULL
1121: ) = FND_API.g_false
1122: THEN
1123: AMS_Utility_PVT.Error_Message('AMS_DELIV_KIT_NO_KIT_ID');
1124: x_return_status := FND_API.g_ret_sts_error;
1125: RETURN;
1126: END IF;
1127: END IF;
1128:

Line 1130: IF p_deliv_kit_item_rec.deliverable_kit_part_id <> FND_API.g_miss_num

1126: END IF;
1127: END IF;
1128:
1129: --------------------- deliverable_kit_part_id ----------------------------
1130: IF p_deliv_kit_item_rec.deliverable_kit_part_id <> FND_API.g_miss_num
1131: AND p_deliv_kit_item_rec.deliverable_kit_part_id IS NOT NULL
1132: THEN
1133: IF AMS_Utility_PVT.check_fk_exists(
1134: 'ams_deliverables_all_b',

Line 1139: ) = FND_API.g_false

1135: 'deliverable_id',
1136: p_deliv_kit_item_rec.deliverable_kit_part_id,
1137: AMS_Utility_PVT.g_number,
1138: NULL
1139: ) = FND_API.g_false
1140: THEN
1141: AMS_Utility_PVT.Error_Message('AMS_DELV_KIT_TIP');
1142: x_return_status := FND_API.g_ret_sts_error;
1143: RETURN;

Line 1142: x_return_status := FND_API.g_ret_sts_error;

1138: NULL
1139: ) = FND_API.g_false
1140: THEN
1141: AMS_Utility_PVT.Error_Message('AMS_DELV_KIT_TIP');
1142: x_return_status := FND_API.g_ret_sts_error;
1143: RETURN;
1144: END IF;
1145: END IF;
1146:

Line 1167: x_return_status := FND_API.g_ret_sts_success;

1163: IS
1164:
1165: BEGIN
1166:
1167: x_return_status := FND_API.g_ret_sts_success;
1168:
1169: -- check other lookup codes
1170:
1171: END check_deliv_kit_item_lk_items;

Line 1209: x_return_status := FND_API.g_ret_sts_success;

1205: l_kit_part_rec get_detail%ROWTYPE;
1206:
1207: BEGIN
1208:
1209: x_return_status := FND_API.g_ret_sts_success;
1210:
1211: -- getting the type of kit
1212: OPEN get_type(p_deliv_kit_item_rec.deliverable_kit_id);
1213: FETCH get_type INTO l_kit_type;

Line 1226: x_return_status := FND_API.g_ret_sts_error;

1222: THEN
1223: AMS_Utility_PVT.Error_Message('AMS_DELV_PHY_ELE_MISMATCH');
1224: -- The Deliverable kit and kit part are of different types. Please select you want to create kit for electronic
1225: -- deliverable or physical deliverable.
1226: x_return_status := FND_API.g_ret_sts_error;
1227: RETURN;
1228: END IF;
1229:
1230: IF l_kit_type ='PHYS'

Line 1247: x_return_status := FND_API.g_ret_sts_error;

1243: THEN
1244: AMS_Utility_PVT.Error_Message('AMS_DELV_STO_INV_MISMATCH');
1245: -- The Deliverable kit and kit part are of different types. Please select whether you want to create kit for physically inventoried
1246: -- deliverable or physically stocked manual deliverable.
1247: x_return_status := FND_API.g_ret_sts_error;
1248: RETURN;
1249: END IF;
1250:
1251: IF l_kit_rec.type = 'PHYS'

Line 1257: x_return_status := FND_API.g_ret_sts_error;

1253: OR l_kit_part_rec.quantity = -99999)
1254: THEN
1255: AMS_Utility_PVT.Error_Message('AMS_DELV_KIT_NO_STOCK');
1256: -- Please make this physical deliverable kit or kit part as stock manually, by adding the quantity .
1257: x_return_status := FND_API.g_ret_sts_error;
1258: RETURN;
1259: END IF;
1260:
1261: END IF;

Line 1281: x_return_status := FND_API.g_ret_sts_success;

1277: IS
1278:
1279: BEGIN
1280:
1281: x_return_status := FND_API.g_ret_sts_success;
1282:
1283: -- check other flags
1284:
1285: END check_deliv_kit_item_fg_items;

Line 1312: IF x_return_status <> FND_API.g_ret_sts_success THEN

1308: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
1309: x_return_status => x_return_status
1310: );
1311:
1312: IF x_return_status <> FND_API.g_ret_sts_success THEN
1313: RETURN;
1314: END IF;
1315:
1316: check_deliv_kit_item_uk_items

Line 1323: IF x_return_status <> FND_API.g_ret_sts_success THEN

1319: p_validation_mode => p_validation_mode,
1320: x_return_status => x_return_status
1321: );
1322:
1323: IF x_return_status <> FND_API.g_ret_sts_success THEN
1324: RETURN;
1325: END IF;
1326:
1327: check_deliv_kit_item_fk_items

Line 1333: IF x_return_status <> FND_API.g_ret_sts_success THEN

1329: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
1330: x_return_status => x_return_status
1331: );
1332:
1333: IF x_return_status <> FND_API.g_ret_sts_success THEN
1334: RETURN;
1335: END IF;
1336:
1337: check_deliv_kit_item_lk_items

Line 1343: IF x_return_status <> FND_API.g_ret_sts_success THEN

1339: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
1340: x_return_status => x_return_status
1341: );
1342:
1343: IF x_return_status <> FND_API.g_ret_sts_success THEN
1344: RETURN;
1345: END IF;
1346:
1347: check_deliv_kit_item_fg_items

Line 1353: IF x_return_status <> FND_API.g_ret_sts_success THEN

1349: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
1350: x_return_status => x_return_status
1351: );
1352:
1353: IF x_return_status <> FND_API.g_ret_sts_success THEN
1354: RETURN;
1355: END IF;
1356:
1357: check_kit_types

Line 1363: IF x_return_status <> FND_API.g_ret_sts_success THEN

1359: p_deliv_kit_item_rec => p_deliv_kit_item_rec,
1360: x_return_status => x_return_status
1361: );
1362:
1363: IF x_return_status <> FND_API.g_ret_sts_success THEN
1364: RETURN;
1365: END IF;
1366:
1367:

Line 1390: x_return_status := FND_API.g_ret_sts_success;

1386: IS
1387:
1388: BEGIN
1389:
1390: x_return_status := FND_API.g_ret_sts_success;
1391:
1392: -- do other record level checkings
1393:
1394: END check_deliv_kit_item_record;

Line 1413: x_deliv_kit_item_rec.deliverable_kit_item_id := FND_API.g_miss_num;

1409: IS
1410:
1411: BEGIN
1412:
1413: x_deliv_kit_item_rec.deliverable_kit_item_id := FND_API.g_miss_num;
1414: x_deliv_kit_item_rec.last_update_date := FND_API.g_miss_date;
1415: x_deliv_kit_item_rec.last_updated_by := FND_API.g_miss_num;
1416: x_deliv_kit_item_rec.creation_date := FND_API.g_miss_date;
1417: x_deliv_kit_item_rec.created_by := FND_API.g_miss_num;

Line 1414: x_deliv_kit_item_rec.last_update_date := FND_API.g_miss_date;

1410:
1411: BEGIN
1412:
1413: x_deliv_kit_item_rec.deliverable_kit_item_id := FND_API.g_miss_num;
1414: x_deliv_kit_item_rec.last_update_date := FND_API.g_miss_date;
1415: x_deliv_kit_item_rec.last_updated_by := FND_API.g_miss_num;
1416: x_deliv_kit_item_rec.creation_date := FND_API.g_miss_date;
1417: x_deliv_kit_item_rec.created_by := FND_API.g_miss_num;
1418: x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;

Line 1415: x_deliv_kit_item_rec.last_updated_by := FND_API.g_miss_num;

1411: BEGIN
1412:
1413: x_deliv_kit_item_rec.deliverable_kit_item_id := FND_API.g_miss_num;
1414: x_deliv_kit_item_rec.last_update_date := FND_API.g_miss_date;
1415: x_deliv_kit_item_rec.last_updated_by := FND_API.g_miss_num;
1416: x_deliv_kit_item_rec.creation_date := FND_API.g_miss_date;
1417: x_deliv_kit_item_rec.created_by := FND_API.g_miss_num;
1418: x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;
1419: x_deliv_kit_item_rec.object_version_number := FND_API.g_miss_num;

Line 1416: x_deliv_kit_item_rec.creation_date := FND_API.g_miss_date;

1412:
1413: x_deliv_kit_item_rec.deliverable_kit_item_id := FND_API.g_miss_num;
1414: x_deliv_kit_item_rec.last_update_date := FND_API.g_miss_date;
1415: x_deliv_kit_item_rec.last_updated_by := FND_API.g_miss_num;
1416: x_deliv_kit_item_rec.creation_date := FND_API.g_miss_date;
1417: x_deliv_kit_item_rec.created_by := FND_API.g_miss_num;
1418: x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;
1419: x_deliv_kit_item_rec.object_version_number := FND_API.g_miss_num;
1420: x_deliv_kit_item_rec.deliverable_kit_id := FND_API.g_miss_num;

Line 1417: x_deliv_kit_item_rec.created_by := FND_API.g_miss_num;

1413: x_deliv_kit_item_rec.deliverable_kit_item_id := FND_API.g_miss_num;
1414: x_deliv_kit_item_rec.last_update_date := FND_API.g_miss_date;
1415: x_deliv_kit_item_rec.last_updated_by := FND_API.g_miss_num;
1416: x_deliv_kit_item_rec.creation_date := FND_API.g_miss_date;
1417: x_deliv_kit_item_rec.created_by := FND_API.g_miss_num;
1418: x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;
1419: x_deliv_kit_item_rec.object_version_number := FND_API.g_miss_num;
1420: x_deliv_kit_item_rec.deliverable_kit_id := FND_API.g_miss_num;
1421: x_deliv_kit_item_rec.deliverable_kit_part_id := FND_API.g_miss_num;

Line 1418: x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;

1414: x_deliv_kit_item_rec.last_update_date := FND_API.g_miss_date;
1415: x_deliv_kit_item_rec.last_updated_by := FND_API.g_miss_num;
1416: x_deliv_kit_item_rec.creation_date := FND_API.g_miss_date;
1417: x_deliv_kit_item_rec.created_by := FND_API.g_miss_num;
1418: x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;
1419: x_deliv_kit_item_rec.object_version_number := FND_API.g_miss_num;
1420: x_deliv_kit_item_rec.deliverable_kit_id := FND_API.g_miss_num;
1421: x_deliv_kit_item_rec.deliverable_kit_part_id := FND_API.g_miss_num;
1422: x_deliv_kit_item_rec.kit_part_included_from_kit_id := FND_API.g_miss_num;

Line 1419: x_deliv_kit_item_rec.object_version_number := FND_API.g_miss_num;

1415: x_deliv_kit_item_rec.last_updated_by := FND_API.g_miss_num;
1416: x_deliv_kit_item_rec.creation_date := FND_API.g_miss_date;
1417: x_deliv_kit_item_rec.created_by := FND_API.g_miss_num;
1418: x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;
1419: x_deliv_kit_item_rec.object_version_number := FND_API.g_miss_num;
1420: x_deliv_kit_item_rec.deliverable_kit_id := FND_API.g_miss_num;
1421: x_deliv_kit_item_rec.deliverable_kit_part_id := FND_API.g_miss_num;
1422: x_deliv_kit_item_rec.kit_part_included_from_kit_id := FND_API.g_miss_num;
1423: x_deliv_kit_item_rec.quantity := FND_API.g_miss_num;

Line 1420: x_deliv_kit_item_rec.deliverable_kit_id := FND_API.g_miss_num;

1416: x_deliv_kit_item_rec.creation_date := FND_API.g_miss_date;
1417: x_deliv_kit_item_rec.created_by := FND_API.g_miss_num;
1418: x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;
1419: x_deliv_kit_item_rec.object_version_number := FND_API.g_miss_num;
1420: x_deliv_kit_item_rec.deliverable_kit_id := FND_API.g_miss_num;
1421: x_deliv_kit_item_rec.deliverable_kit_part_id := FND_API.g_miss_num;
1422: x_deliv_kit_item_rec.kit_part_included_from_kit_id := FND_API.g_miss_num;
1423: x_deliv_kit_item_rec.quantity := FND_API.g_miss_num;
1424:

Line 1421: x_deliv_kit_item_rec.deliverable_kit_part_id := FND_API.g_miss_num;

1417: x_deliv_kit_item_rec.created_by := FND_API.g_miss_num;
1418: x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;
1419: x_deliv_kit_item_rec.object_version_number := FND_API.g_miss_num;
1420: x_deliv_kit_item_rec.deliverable_kit_id := FND_API.g_miss_num;
1421: x_deliv_kit_item_rec.deliverable_kit_part_id := FND_API.g_miss_num;
1422: x_deliv_kit_item_rec.kit_part_included_from_kit_id := FND_API.g_miss_num;
1423: x_deliv_kit_item_rec.quantity := FND_API.g_miss_num;
1424:
1425: x_deliv_kit_item_rec.attribute_category := FND_API.g_miss_char;

Line 1422: x_deliv_kit_item_rec.kit_part_included_from_kit_id := FND_API.g_miss_num;

1418: x_deliv_kit_item_rec.last_update_login := FND_API.g_miss_num;
1419: x_deliv_kit_item_rec.object_version_number := FND_API.g_miss_num;
1420: x_deliv_kit_item_rec.deliverable_kit_id := FND_API.g_miss_num;
1421: x_deliv_kit_item_rec.deliverable_kit_part_id := FND_API.g_miss_num;
1422: x_deliv_kit_item_rec.kit_part_included_from_kit_id := FND_API.g_miss_num;
1423: x_deliv_kit_item_rec.quantity := FND_API.g_miss_num;
1424:
1425: x_deliv_kit_item_rec.attribute_category := FND_API.g_miss_char;
1426: x_deliv_kit_item_rec.attribute1 := FND_API.g_miss_char;

Line 1423: x_deliv_kit_item_rec.quantity := FND_API.g_miss_num;

1419: x_deliv_kit_item_rec.object_version_number := FND_API.g_miss_num;
1420: x_deliv_kit_item_rec.deliverable_kit_id := FND_API.g_miss_num;
1421: x_deliv_kit_item_rec.deliverable_kit_part_id := FND_API.g_miss_num;
1422: x_deliv_kit_item_rec.kit_part_included_from_kit_id := FND_API.g_miss_num;
1423: x_deliv_kit_item_rec.quantity := FND_API.g_miss_num;
1424:
1425: x_deliv_kit_item_rec.attribute_category := FND_API.g_miss_char;
1426: x_deliv_kit_item_rec.attribute1 := FND_API.g_miss_char;
1427: x_deliv_kit_item_rec.attribute2 := FND_API.g_miss_char;

Line 1425: x_deliv_kit_item_rec.attribute_category := FND_API.g_miss_char;

1421: x_deliv_kit_item_rec.deliverable_kit_part_id := FND_API.g_miss_num;
1422: x_deliv_kit_item_rec.kit_part_included_from_kit_id := FND_API.g_miss_num;
1423: x_deliv_kit_item_rec.quantity := FND_API.g_miss_num;
1424:
1425: x_deliv_kit_item_rec.attribute_category := FND_API.g_miss_char;
1426: x_deliv_kit_item_rec.attribute1 := FND_API.g_miss_char;
1427: x_deliv_kit_item_rec.attribute2 := FND_API.g_miss_char;
1428: x_deliv_kit_item_rec.attribute3 := FND_API.g_miss_char;
1429: x_deliv_kit_item_rec.attribute4 := FND_API.g_miss_char;

Line 1426: x_deliv_kit_item_rec.attribute1 := FND_API.g_miss_char;

1422: x_deliv_kit_item_rec.kit_part_included_from_kit_id := FND_API.g_miss_num;
1423: x_deliv_kit_item_rec.quantity := FND_API.g_miss_num;
1424:
1425: x_deliv_kit_item_rec.attribute_category := FND_API.g_miss_char;
1426: x_deliv_kit_item_rec.attribute1 := FND_API.g_miss_char;
1427: x_deliv_kit_item_rec.attribute2 := FND_API.g_miss_char;
1428: x_deliv_kit_item_rec.attribute3 := FND_API.g_miss_char;
1429: x_deliv_kit_item_rec.attribute4 := FND_API.g_miss_char;
1430: x_deliv_kit_item_rec.attribute5 := FND_API.g_miss_char;

Line 1427: x_deliv_kit_item_rec.attribute2 := FND_API.g_miss_char;

1423: x_deliv_kit_item_rec.quantity := FND_API.g_miss_num;
1424:
1425: x_deliv_kit_item_rec.attribute_category := FND_API.g_miss_char;
1426: x_deliv_kit_item_rec.attribute1 := FND_API.g_miss_char;
1427: x_deliv_kit_item_rec.attribute2 := FND_API.g_miss_char;
1428: x_deliv_kit_item_rec.attribute3 := FND_API.g_miss_char;
1429: x_deliv_kit_item_rec.attribute4 := FND_API.g_miss_char;
1430: x_deliv_kit_item_rec.attribute5 := FND_API.g_miss_char;
1431: x_deliv_kit_item_rec.attribute6 := FND_API.g_miss_char;

Line 1428: x_deliv_kit_item_rec.attribute3 := FND_API.g_miss_char;

1424:
1425: x_deliv_kit_item_rec.attribute_category := FND_API.g_miss_char;
1426: x_deliv_kit_item_rec.attribute1 := FND_API.g_miss_char;
1427: x_deliv_kit_item_rec.attribute2 := FND_API.g_miss_char;
1428: x_deliv_kit_item_rec.attribute3 := FND_API.g_miss_char;
1429: x_deliv_kit_item_rec.attribute4 := FND_API.g_miss_char;
1430: x_deliv_kit_item_rec.attribute5 := FND_API.g_miss_char;
1431: x_deliv_kit_item_rec.attribute6 := FND_API.g_miss_char;
1432: x_deliv_kit_item_rec.attribute7 := FND_API.g_miss_char;

Line 1429: x_deliv_kit_item_rec.attribute4 := FND_API.g_miss_char;

1425: x_deliv_kit_item_rec.attribute_category := FND_API.g_miss_char;
1426: x_deliv_kit_item_rec.attribute1 := FND_API.g_miss_char;
1427: x_deliv_kit_item_rec.attribute2 := FND_API.g_miss_char;
1428: x_deliv_kit_item_rec.attribute3 := FND_API.g_miss_char;
1429: x_deliv_kit_item_rec.attribute4 := FND_API.g_miss_char;
1430: x_deliv_kit_item_rec.attribute5 := FND_API.g_miss_char;
1431: x_deliv_kit_item_rec.attribute6 := FND_API.g_miss_char;
1432: x_deliv_kit_item_rec.attribute7 := FND_API.g_miss_char;
1433: x_deliv_kit_item_rec.attribute8 := FND_API.g_miss_char;

Line 1430: x_deliv_kit_item_rec.attribute5 := FND_API.g_miss_char;

1426: x_deliv_kit_item_rec.attribute1 := FND_API.g_miss_char;
1427: x_deliv_kit_item_rec.attribute2 := FND_API.g_miss_char;
1428: x_deliv_kit_item_rec.attribute3 := FND_API.g_miss_char;
1429: x_deliv_kit_item_rec.attribute4 := FND_API.g_miss_char;
1430: x_deliv_kit_item_rec.attribute5 := FND_API.g_miss_char;
1431: x_deliv_kit_item_rec.attribute6 := FND_API.g_miss_char;
1432: x_deliv_kit_item_rec.attribute7 := FND_API.g_miss_char;
1433: x_deliv_kit_item_rec.attribute8 := FND_API.g_miss_char;
1434: x_deliv_kit_item_rec.attribute9 := FND_API.g_miss_char;

Line 1431: x_deliv_kit_item_rec.attribute6 := FND_API.g_miss_char;

1427: x_deliv_kit_item_rec.attribute2 := FND_API.g_miss_char;
1428: x_deliv_kit_item_rec.attribute3 := FND_API.g_miss_char;
1429: x_deliv_kit_item_rec.attribute4 := FND_API.g_miss_char;
1430: x_deliv_kit_item_rec.attribute5 := FND_API.g_miss_char;
1431: x_deliv_kit_item_rec.attribute6 := FND_API.g_miss_char;
1432: x_deliv_kit_item_rec.attribute7 := FND_API.g_miss_char;
1433: x_deliv_kit_item_rec.attribute8 := FND_API.g_miss_char;
1434: x_deliv_kit_item_rec.attribute9 := FND_API.g_miss_char;
1435: x_deliv_kit_item_rec.attribute10 := FND_API.g_miss_char;

Line 1432: x_deliv_kit_item_rec.attribute7 := FND_API.g_miss_char;

1428: x_deliv_kit_item_rec.attribute3 := FND_API.g_miss_char;
1429: x_deliv_kit_item_rec.attribute4 := FND_API.g_miss_char;
1430: x_deliv_kit_item_rec.attribute5 := FND_API.g_miss_char;
1431: x_deliv_kit_item_rec.attribute6 := FND_API.g_miss_char;
1432: x_deliv_kit_item_rec.attribute7 := FND_API.g_miss_char;
1433: x_deliv_kit_item_rec.attribute8 := FND_API.g_miss_char;
1434: x_deliv_kit_item_rec.attribute9 := FND_API.g_miss_char;
1435: x_deliv_kit_item_rec.attribute10 := FND_API.g_miss_char;
1436: x_deliv_kit_item_rec.attribute11 := FND_API.g_miss_char;

Line 1433: x_deliv_kit_item_rec.attribute8 := FND_API.g_miss_char;

1429: x_deliv_kit_item_rec.attribute4 := FND_API.g_miss_char;
1430: x_deliv_kit_item_rec.attribute5 := FND_API.g_miss_char;
1431: x_deliv_kit_item_rec.attribute6 := FND_API.g_miss_char;
1432: x_deliv_kit_item_rec.attribute7 := FND_API.g_miss_char;
1433: x_deliv_kit_item_rec.attribute8 := FND_API.g_miss_char;
1434: x_deliv_kit_item_rec.attribute9 := FND_API.g_miss_char;
1435: x_deliv_kit_item_rec.attribute10 := FND_API.g_miss_char;
1436: x_deliv_kit_item_rec.attribute11 := FND_API.g_miss_char;
1437: x_deliv_kit_item_rec.attribute12 := FND_API.g_miss_char;

Line 1434: x_deliv_kit_item_rec.attribute9 := FND_API.g_miss_char;

1430: x_deliv_kit_item_rec.attribute5 := FND_API.g_miss_char;
1431: x_deliv_kit_item_rec.attribute6 := FND_API.g_miss_char;
1432: x_deliv_kit_item_rec.attribute7 := FND_API.g_miss_char;
1433: x_deliv_kit_item_rec.attribute8 := FND_API.g_miss_char;
1434: x_deliv_kit_item_rec.attribute9 := FND_API.g_miss_char;
1435: x_deliv_kit_item_rec.attribute10 := FND_API.g_miss_char;
1436: x_deliv_kit_item_rec.attribute11 := FND_API.g_miss_char;
1437: x_deliv_kit_item_rec.attribute12 := FND_API.g_miss_char;
1438: x_deliv_kit_item_rec.attribute13 := FND_API.g_miss_char;

Line 1435: x_deliv_kit_item_rec.attribute10 := FND_API.g_miss_char;

1431: x_deliv_kit_item_rec.attribute6 := FND_API.g_miss_char;
1432: x_deliv_kit_item_rec.attribute7 := FND_API.g_miss_char;
1433: x_deliv_kit_item_rec.attribute8 := FND_API.g_miss_char;
1434: x_deliv_kit_item_rec.attribute9 := FND_API.g_miss_char;
1435: x_deliv_kit_item_rec.attribute10 := FND_API.g_miss_char;
1436: x_deliv_kit_item_rec.attribute11 := FND_API.g_miss_char;
1437: x_deliv_kit_item_rec.attribute12 := FND_API.g_miss_char;
1438: x_deliv_kit_item_rec.attribute13 := FND_API.g_miss_char;
1439: x_deliv_kit_item_rec.attribute14 := FND_API.g_miss_char;

Line 1436: x_deliv_kit_item_rec.attribute11 := FND_API.g_miss_char;

1432: x_deliv_kit_item_rec.attribute7 := FND_API.g_miss_char;
1433: x_deliv_kit_item_rec.attribute8 := FND_API.g_miss_char;
1434: x_deliv_kit_item_rec.attribute9 := FND_API.g_miss_char;
1435: x_deliv_kit_item_rec.attribute10 := FND_API.g_miss_char;
1436: x_deliv_kit_item_rec.attribute11 := FND_API.g_miss_char;
1437: x_deliv_kit_item_rec.attribute12 := FND_API.g_miss_char;
1438: x_deliv_kit_item_rec.attribute13 := FND_API.g_miss_char;
1439: x_deliv_kit_item_rec.attribute14 := FND_API.g_miss_char;
1440: x_deliv_kit_item_rec.attribute15 := FND_API.g_miss_char;

Line 1437: x_deliv_kit_item_rec.attribute12 := FND_API.g_miss_char;

1433: x_deliv_kit_item_rec.attribute8 := FND_API.g_miss_char;
1434: x_deliv_kit_item_rec.attribute9 := FND_API.g_miss_char;
1435: x_deliv_kit_item_rec.attribute10 := FND_API.g_miss_char;
1436: x_deliv_kit_item_rec.attribute11 := FND_API.g_miss_char;
1437: x_deliv_kit_item_rec.attribute12 := FND_API.g_miss_char;
1438: x_deliv_kit_item_rec.attribute13 := FND_API.g_miss_char;
1439: x_deliv_kit_item_rec.attribute14 := FND_API.g_miss_char;
1440: x_deliv_kit_item_rec.attribute15 := FND_API.g_miss_char;
1441:

Line 1438: x_deliv_kit_item_rec.attribute13 := FND_API.g_miss_char;

1434: x_deliv_kit_item_rec.attribute9 := FND_API.g_miss_char;
1435: x_deliv_kit_item_rec.attribute10 := FND_API.g_miss_char;
1436: x_deliv_kit_item_rec.attribute11 := FND_API.g_miss_char;
1437: x_deliv_kit_item_rec.attribute12 := FND_API.g_miss_char;
1438: x_deliv_kit_item_rec.attribute13 := FND_API.g_miss_char;
1439: x_deliv_kit_item_rec.attribute14 := FND_API.g_miss_char;
1440: x_deliv_kit_item_rec.attribute15 := FND_API.g_miss_char;
1441:
1442: END init_deliv_kit_ite_rec;

Line 1439: x_deliv_kit_item_rec.attribute14 := FND_API.g_miss_char;

1435: x_deliv_kit_item_rec.attribute10 := FND_API.g_miss_char;
1436: x_deliv_kit_item_rec.attribute11 := FND_API.g_miss_char;
1437: x_deliv_kit_item_rec.attribute12 := FND_API.g_miss_char;
1438: x_deliv_kit_item_rec.attribute13 := FND_API.g_miss_char;
1439: x_deliv_kit_item_rec.attribute14 := FND_API.g_miss_char;
1440: x_deliv_kit_item_rec.attribute15 := FND_API.g_miss_char;
1441:
1442: END init_deliv_kit_ite_rec;
1443:

Line 1440: x_deliv_kit_item_rec.attribute15 := FND_API.g_miss_char;

1436: x_deliv_kit_item_rec.attribute11 := FND_API.g_miss_char;
1437: x_deliv_kit_item_rec.attribute12 := FND_API.g_miss_char;
1438: x_deliv_kit_item_rec.attribute13 := FND_API.g_miss_char;
1439: x_deliv_kit_item_rec.attribute14 := FND_API.g_miss_char;
1440: x_deliv_kit_item_rec.attribute15 := FND_API.g_miss_char;
1441:
1442: END init_deliv_kit_ite_rec;
1443:
1444:

Line 1479: RAISE FND_API.g_exc_error;

1475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1476: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1477: FND_MSG_PUB.add;
1478: END IF;
1479: RAISE FND_API.g_exc_error;
1480: END IF;
1481: CLOSE c_deliv_kit_item;
1482:
1483: IF p_deliv_kit_item_rec.deliverable_kit_id = FND_API.g_miss_num THEN

Line 1483: IF p_deliv_kit_item_rec.deliverable_kit_id = FND_API.g_miss_num THEN

1479: RAISE FND_API.g_exc_error;
1480: END IF;
1481: CLOSE c_deliv_kit_item;
1482:
1483: IF p_deliv_kit_item_rec.deliverable_kit_id = FND_API.g_miss_num THEN
1484: x_complete_rec.deliverable_kit_id := l_deliv_kit_item_rec.deliverable_kit_id;
1485: END IF;
1486:
1487: IF p_deliv_kit_item_rec.deliverable_kit_part_id = FND_API.g_miss_num THEN

Line 1487: IF p_deliv_kit_item_rec.deliverable_kit_part_id = FND_API.g_miss_num THEN

1483: IF p_deliv_kit_item_rec.deliverable_kit_id = FND_API.g_miss_num THEN
1484: x_complete_rec.deliverable_kit_id := l_deliv_kit_item_rec.deliverable_kit_id;
1485: END IF;
1486:
1487: IF p_deliv_kit_item_rec.deliverable_kit_part_id = FND_API.g_miss_num THEN
1488: x_complete_rec.deliverable_kit_part_id := l_deliv_kit_item_rec.deliverable_kit_part_id;
1489: END IF;
1490:
1491: IF p_deliv_kit_item_rec.kit_part_included_from_kit_id = FND_API.g_miss_num THEN

Line 1491: IF p_deliv_kit_item_rec.kit_part_included_from_kit_id = FND_API.g_miss_num THEN

1487: IF p_deliv_kit_item_rec.deliverable_kit_part_id = FND_API.g_miss_num THEN
1488: x_complete_rec.deliverable_kit_part_id := l_deliv_kit_item_rec.deliverable_kit_part_id;
1489: END IF;
1490:
1491: IF p_deliv_kit_item_rec.kit_part_included_from_kit_id = FND_API.g_miss_num THEN
1492: x_complete_rec.kit_part_included_from_kit_id := l_deliv_kit_item_rec.kit_part_included_from_kit_id;
1493: END IF;
1494:
1495: IF p_deliv_kit_item_rec.quantity = FND_API.g_miss_num THEN

Line 1495: IF p_deliv_kit_item_rec.quantity = FND_API.g_miss_num THEN

1491: IF p_deliv_kit_item_rec.kit_part_included_from_kit_id = FND_API.g_miss_num THEN
1492: x_complete_rec.kit_part_included_from_kit_id := l_deliv_kit_item_rec.kit_part_included_from_kit_id;
1493: END IF;
1494:
1495: IF p_deliv_kit_item_rec.quantity = FND_API.g_miss_num THEN
1496: x_complete_rec.quantity := l_deliv_kit_item_rec.quantity;
1497: END IF;
1498:
1499: IF p_deliv_kit_item_rec.attribute_category = FND_API.g_miss_char THEN

Line 1499: IF p_deliv_kit_item_rec.attribute_category = FND_API.g_miss_char THEN

1495: IF p_deliv_kit_item_rec.quantity = FND_API.g_miss_num THEN
1496: x_complete_rec.quantity := l_deliv_kit_item_rec.quantity;
1497: END IF;
1498:
1499: IF p_deliv_kit_item_rec.attribute_category = FND_API.g_miss_char THEN
1500: x_complete_rec.attribute_category := l_deliv_kit_item_rec.attribute_category;
1501: END IF;
1502:
1503: IF p_deliv_kit_item_rec.attribute1 = FND_API.g_miss_char THEN

Line 1503: IF p_deliv_kit_item_rec.attribute1 = FND_API.g_miss_char THEN

1499: IF p_deliv_kit_item_rec.attribute_category = FND_API.g_miss_char THEN
1500: x_complete_rec.attribute_category := l_deliv_kit_item_rec.attribute_category;
1501: END IF;
1502:
1503: IF p_deliv_kit_item_rec.attribute1 = FND_API.g_miss_char THEN
1504: x_complete_rec.attribute1 := l_deliv_kit_item_rec.attribute1;
1505: END IF;
1506:
1507: IF p_deliv_kit_item_rec.attribute2 = FND_API.g_miss_char THEN

Line 1507: IF p_deliv_kit_item_rec.attribute2 = FND_API.g_miss_char THEN

1503: IF p_deliv_kit_item_rec.attribute1 = FND_API.g_miss_char THEN
1504: x_complete_rec.attribute1 := l_deliv_kit_item_rec.attribute1;
1505: END IF;
1506:
1507: IF p_deliv_kit_item_rec.attribute2 = FND_API.g_miss_char THEN
1508: x_complete_rec.attribute2 := l_deliv_kit_item_rec.attribute2;
1509: END IF;
1510:
1511: IF p_deliv_kit_item_rec.attribute3 = FND_API.g_miss_char THEN

Line 1511: IF p_deliv_kit_item_rec.attribute3 = FND_API.g_miss_char THEN

1507: IF p_deliv_kit_item_rec.attribute2 = FND_API.g_miss_char THEN
1508: x_complete_rec.attribute2 := l_deliv_kit_item_rec.attribute2;
1509: END IF;
1510:
1511: IF p_deliv_kit_item_rec.attribute3 = FND_API.g_miss_char THEN
1512: x_complete_rec.attribute3 := l_deliv_kit_item_rec.attribute3;
1513: END IF;
1514:
1515: IF p_deliv_kit_item_rec.attribute4 = FND_API.g_miss_char THEN

Line 1515: IF p_deliv_kit_item_rec.attribute4 = FND_API.g_miss_char THEN

1511: IF p_deliv_kit_item_rec.attribute3 = FND_API.g_miss_char THEN
1512: x_complete_rec.attribute3 := l_deliv_kit_item_rec.attribute3;
1513: END IF;
1514:
1515: IF p_deliv_kit_item_rec.attribute4 = FND_API.g_miss_char THEN
1516: x_complete_rec.attribute4 := l_deliv_kit_item_rec.attribute4;
1517: END IF;
1518:
1519: IF p_deliv_kit_item_rec.attribute5 = FND_API.g_miss_char THEN

Line 1519: IF p_deliv_kit_item_rec.attribute5 = FND_API.g_miss_char THEN

1515: IF p_deliv_kit_item_rec.attribute4 = FND_API.g_miss_char THEN
1516: x_complete_rec.attribute4 := l_deliv_kit_item_rec.attribute4;
1517: END IF;
1518:
1519: IF p_deliv_kit_item_rec.attribute5 = FND_API.g_miss_char THEN
1520: x_complete_rec.attribute5 := l_deliv_kit_item_rec.attribute5;
1521: END IF;
1522:
1523: IF p_deliv_kit_item_rec.attribute6 = FND_API.g_miss_char THEN

Line 1523: IF p_deliv_kit_item_rec.attribute6 = FND_API.g_miss_char THEN

1519: IF p_deliv_kit_item_rec.attribute5 = FND_API.g_miss_char THEN
1520: x_complete_rec.attribute5 := l_deliv_kit_item_rec.attribute5;
1521: END IF;
1522:
1523: IF p_deliv_kit_item_rec.attribute6 = FND_API.g_miss_char THEN
1524: x_complete_rec.attribute6 := l_deliv_kit_item_rec.attribute6;
1525: END IF;
1526:
1527: IF p_deliv_kit_item_rec.attribute7 = FND_API.g_miss_char THEN

Line 1527: IF p_deliv_kit_item_rec.attribute7 = FND_API.g_miss_char THEN

1523: IF p_deliv_kit_item_rec.attribute6 = FND_API.g_miss_char THEN
1524: x_complete_rec.attribute6 := l_deliv_kit_item_rec.attribute6;
1525: END IF;
1526:
1527: IF p_deliv_kit_item_rec.attribute7 = FND_API.g_miss_char THEN
1528: x_complete_rec.attribute7 := l_deliv_kit_item_rec.attribute7;
1529: END IF;
1530:
1531: IF p_deliv_kit_item_rec.attribute8 = FND_API.g_miss_char THEN

Line 1531: IF p_deliv_kit_item_rec.attribute8 = FND_API.g_miss_char THEN

1527: IF p_deliv_kit_item_rec.attribute7 = FND_API.g_miss_char THEN
1528: x_complete_rec.attribute7 := l_deliv_kit_item_rec.attribute7;
1529: END IF;
1530:
1531: IF p_deliv_kit_item_rec.attribute8 = FND_API.g_miss_char THEN
1532: x_complete_rec.attribute8 := l_deliv_kit_item_rec.attribute8;
1533: END IF;
1534:
1535: IF p_deliv_kit_item_rec.attribute9 = FND_API.g_miss_char THEN

Line 1535: IF p_deliv_kit_item_rec.attribute9 = FND_API.g_miss_char THEN

1531: IF p_deliv_kit_item_rec.attribute8 = FND_API.g_miss_char THEN
1532: x_complete_rec.attribute8 := l_deliv_kit_item_rec.attribute8;
1533: END IF;
1534:
1535: IF p_deliv_kit_item_rec.attribute9 = FND_API.g_miss_char THEN
1536: x_complete_rec.attribute9 := l_deliv_kit_item_rec.attribute9;
1537: END IF;
1538:
1539: IF p_deliv_kit_item_rec.attribute10 = FND_API.g_miss_char THEN

Line 1539: IF p_deliv_kit_item_rec.attribute10 = FND_API.g_miss_char THEN

1535: IF p_deliv_kit_item_rec.attribute9 = FND_API.g_miss_char THEN
1536: x_complete_rec.attribute9 := l_deliv_kit_item_rec.attribute9;
1537: END IF;
1538:
1539: IF p_deliv_kit_item_rec.attribute10 = FND_API.g_miss_char THEN
1540: x_complete_rec.attribute10 := l_deliv_kit_item_rec.attribute10;
1541: END IF;
1542:
1543: IF p_deliv_kit_item_rec.attribute11 = FND_API.g_miss_char THEN

Line 1543: IF p_deliv_kit_item_rec.attribute11 = FND_API.g_miss_char THEN

1539: IF p_deliv_kit_item_rec.attribute10 = FND_API.g_miss_char THEN
1540: x_complete_rec.attribute10 := l_deliv_kit_item_rec.attribute10;
1541: END IF;
1542:
1543: IF p_deliv_kit_item_rec.attribute11 = FND_API.g_miss_char THEN
1544: x_complete_rec.attribute11 := l_deliv_kit_item_rec.attribute11;
1545: END IF;
1546:
1547: IF p_deliv_kit_item_rec.attribute12 = FND_API.g_miss_char THEN

Line 1547: IF p_deliv_kit_item_rec.attribute12 = FND_API.g_miss_char THEN

1543: IF p_deliv_kit_item_rec.attribute11 = FND_API.g_miss_char THEN
1544: x_complete_rec.attribute11 := l_deliv_kit_item_rec.attribute11;
1545: END IF;
1546:
1547: IF p_deliv_kit_item_rec.attribute12 = FND_API.g_miss_char THEN
1548: x_complete_rec.attribute12 := l_deliv_kit_item_rec.attribute12;
1549: END IF;
1550:
1551: IF p_deliv_kit_item_rec.attribute13 = FND_API.g_miss_char THEN

Line 1551: IF p_deliv_kit_item_rec.attribute13 = FND_API.g_miss_char THEN

1547: IF p_deliv_kit_item_rec.attribute12 = FND_API.g_miss_char THEN
1548: x_complete_rec.attribute12 := l_deliv_kit_item_rec.attribute12;
1549: END IF;
1550:
1551: IF p_deliv_kit_item_rec.attribute13 = FND_API.g_miss_char THEN
1552: x_complete_rec.attribute13 := l_deliv_kit_item_rec.attribute13;
1553: END IF;
1554:
1555: IF p_deliv_kit_item_rec.attribute14 = FND_API.g_miss_char THEN

Line 1555: IF p_deliv_kit_item_rec.attribute14 = FND_API.g_miss_char THEN

1551: IF p_deliv_kit_item_rec.attribute13 = FND_API.g_miss_char THEN
1552: x_complete_rec.attribute13 := l_deliv_kit_item_rec.attribute13;
1553: END IF;
1554:
1555: IF p_deliv_kit_item_rec.attribute14 = FND_API.g_miss_char THEN
1556: x_complete_rec.attribute14 := l_deliv_kit_item_rec.attribute14;
1557: END IF;
1558:
1559: IF p_deliv_kit_item_rec.attribute15 = FND_API.g_miss_char THEN

Line 1559: IF p_deliv_kit_item_rec.attribute15 = FND_API.g_miss_char THEN

1555: IF p_deliv_kit_item_rec.attribute14 = FND_API.g_miss_char THEN
1556: x_complete_rec.attribute14 := l_deliv_kit_item_rec.attribute14;
1557: END IF;
1558:
1559: IF p_deliv_kit_item_rec.attribute15 = FND_API.g_miss_char THEN
1560: x_complete_rec.attribute15 := l_deliv_kit_item_rec.attribute15;
1561: END IF;
1562:
1563: