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_MESSAGES_PVT dependencies on FND_API

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

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

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

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

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

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

Line 53: IF FND_API.to_boolean(p_init_msg_list) THEN

49: BEGIN
50: -- initialize
51: SAVEPOINT create_msg;
52:
53: IF FND_API.to_boolean(p_init_msg_list) THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
57:

Line 69: IF NOT FND_API.compatible_api_call

65:
66:
67: END IF;
68:
69: IF NOT FND_API.compatible_api_call
70: (
71: l_api_version,
72: p_api_version,
73: l_api_name,

Line 77: RAISE FND_API.g_exc_unexpected_error;

73: l_api_name,
74: g_pkg_name
75: )
76: THEN
77: RAISE FND_API.g_exc_unexpected_error;
78: END IF;
79:
80: x_return_status := FND_API.g_ret_sts_success;
81:

Line 80: x_return_status := FND_API.g_ret_sts_success;

76: THEN
77: RAISE FND_API.g_exc_unexpected_error;
78: END IF;
79:
80: x_return_status := FND_API.g_ret_sts_success;
81:
82: -- validate
83: IF (AMS_DEBUG_HIGH_ON) THEN
84:

Line 98: IF l_return_status = FND_API.g_ret_sts_error THEN

94: x_msg_data => x_msg_data,
95: p_msg_rec => l_msg_rec
96: );
97:
98: IF l_return_status = FND_API.g_ret_sts_error THEN
99: RAISE FND_API.g_exc_error;
100: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
101: RAISE FND_API.g_exc_unexpected_error;
102: END IF;

Line 99: RAISE FND_API.g_exc_error;

95: p_msg_rec => l_msg_rec
96: );
97:
98: IF l_return_status = FND_API.g_ret_sts_error THEN
99: RAISE FND_API.g_exc_error;
100: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
101: RAISE FND_API.g_exc_unexpected_error;
102: END IF;
103:

Line 100: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

96: );
97:
98: IF l_return_status = FND_API.g_ret_sts_error THEN
99: RAISE FND_API.g_exc_error;
100: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
101: RAISE FND_API.g_exc_unexpected_error;
102: END IF;
103:
104: -- insert

Line 101: RAISE FND_API.g_exc_unexpected_error;

97:
98: IF l_return_status = FND_API.g_ret_sts_error THEN
99: RAISE FND_API.g_exc_error;
100: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
101: RAISE FND_API.g_exc_unexpected_error;
102: END IF;
103:
104: -- insert
105: IF (AMS_DEBUG_HIGH_ON) THEN

Line 243: IF FND_API.to_boolean(p_commit) THEN

239:
240: -- finish
241: x_msg_id := l_msg_rec.message_id;
242:
243: IF FND_API.to_boolean(p_commit) THEN
244: COMMIT;
245: END IF;
246:
247: FND_MSG_PUB.count_and_get

Line 249: p_encoded => FND_API.g_false,

245: END IF;
246:
247: FND_MSG_PUB.count_and_get
248: (
249: p_encoded => FND_API.g_false,
250: p_count => x_msg_count,
251: p_data => x_msg_data
252: );
253:

Line 264: WHEN FND_API.g_exc_error THEN

260: END IF;
261:
262: EXCEPTION
263:
264: WHEN FND_API.g_exc_error THEN
265: ROLLBACK TO create_msg;
266: x_return_status := FND_API.g_ret_sts_error;
267: FND_MSG_PUB.count_and_get
268: (

Line 266: x_return_status := FND_API.g_ret_sts_error;

262: EXCEPTION
263:
264: WHEN FND_API.g_exc_error THEN
265: ROLLBACK TO create_msg;
266: x_return_status := FND_API.g_ret_sts_error;
267: FND_MSG_PUB.count_and_get
268: (
269: p_encoded => FND_API.g_false,
270: p_count => x_msg_count,

Line 269: p_encoded => FND_API.g_false,

265: ROLLBACK TO create_msg;
266: x_return_status := FND_API.g_ret_sts_error;
267: FND_MSG_PUB.count_and_get
268: (
269: p_encoded => FND_API.g_false,
270: p_count => x_msg_count,
271: p_data => x_msg_data
272: );
273:

Line 274: WHEN FND_API.g_exc_unexpected_error THEN

270: p_count => x_msg_count,
271: p_data => x_msg_data
272: );
273:
274: WHEN FND_API.g_exc_unexpected_error THEN
275: ROLLBACK TO create_msg;
276: x_return_status := FND_API.g_ret_sts_unexp_error;
277: FND_MSG_PUB.count_and_get
278: (

Line 276: x_return_status := FND_API.g_ret_sts_unexp_error;

272: );
273:
274: WHEN FND_API.g_exc_unexpected_error THEN
275: ROLLBACK TO create_msg;
276: x_return_status := FND_API.g_ret_sts_unexp_error;
277: FND_MSG_PUB.count_and_get
278: (
279: p_encoded => FND_API.g_false,
280: p_count => x_msg_count,

Line 279: p_encoded => FND_API.g_false,

275: ROLLBACK TO create_msg;
276: x_return_status := FND_API.g_ret_sts_unexp_error;
277: FND_MSG_PUB.count_and_get
278: (
279: p_encoded => FND_API.g_false,
280: p_count => x_msg_count,
281: p_data => x_msg_data
282: );
283:

Line 286: x_return_status :=FND_API.g_ret_sts_unexp_error;

282: );
283:
284: WHEN OTHERS THEN
285: ROLLBACK TO create_msg;
286: x_return_status :=FND_API.g_ret_sts_unexp_error;
287: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
288: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
289: END IF;
290: FND_MSG_PUB.count_and_get

Line 292: p_encoded => FND_API.g_false,

288: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
289: END IF;
290: FND_MSG_PUB.count_and_get
291: (
292: p_encoded => FND_API.g_false,
293: p_count => x_msg_count,
294: p_data => x_msg_data
295: );
296:

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

305: -------------------------------------------------------------------------------
306: PROCEDURE update_msg
307: (
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
310: p_commit IN VARCHAR2 := FND_API.g_false,
311: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
312:
313: x_return_status OUT NOCOPY VARCHAR2,

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

306: PROCEDURE update_msg
307: (
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
310: p_commit IN VARCHAR2 := FND_API.g_false,
311: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
312:
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,

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

307: (
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
310: p_commit IN VARCHAR2 := FND_API.g_false,
311: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
312:
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,

Line 332: IF FND_API.to_boolean(p_init_msg_list) THEN

328:
329: -- initialize
330: SAVEPOINT update_msg;
331:
332: IF FND_API.to_boolean(p_init_msg_list) THEN
333: FND_MSG_PUB.initialize;
334: END IF;
335:
336: IF (AMS_DEBUG_HIGH_ON) THEN

Line 344: IF NOT FND_API.compatible_api_call

340: AMS_Utility_PVT.debug_message(l_full_name || ': start');
341:
342: END IF;
343:
344: IF NOT FND_API.compatible_api_call
345: (
346: l_api_version,
347: p_api_version,
348: l_api_name,

Line 352: RAISE FND_API.g_exc_unexpected_error;

348: l_api_name,
349: g_pkg_name
350: )
351: THEN
352: RAISE FND_API.g_exc_unexpected_error;
353: END IF;
354:
355: x_return_status := FND_API.g_ret_sts_success;
356:

Line 355: x_return_status := FND_API.g_ret_sts_success;

351: THEN
352: RAISE FND_API.g_exc_unexpected_error;
353: END IF;
354:
355: x_return_status := FND_API.g_ret_sts_success;
356:
357: -- complete record
358: complete_msg_rec
359: (

Line 378: IF l_return_status = FND_API.g_ret_sts_error THEN

374: x_return_status => l_return_status,
375: p_msg_rec => l_msg_rec
376: );
377:
378: IF l_return_status = FND_API.g_ret_sts_error THEN
379: RAISE FND_API.g_exc_error;
380: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
381: RAISE FND_API.g_exc_unexpected_error;
382: END IF;

Line 379: RAISE FND_API.g_exc_error;

375: p_msg_rec => l_msg_rec
376: );
377:
378: IF l_return_status = FND_API.g_ret_sts_error THEN
379: RAISE FND_API.g_exc_error;
380: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
381: RAISE FND_API.g_exc_unexpected_error;
382: END IF;
383: END IF;

Line 380: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

376: );
377:
378: IF l_return_status = FND_API.g_ret_sts_error THEN
379: RAISE FND_API.g_exc_error;
380: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
381: RAISE FND_API.g_exc_unexpected_error;
382: END IF;
383: END IF;
384: /*

Line 381: RAISE FND_API.g_exc_unexpected_error;

377:
378: IF l_return_status = FND_API.g_ret_sts_error THEN
379: RAISE FND_API.g_exc_error;
380: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
381: RAISE FND_API.g_exc_unexpected_error;
382: END IF;
383: END IF;
384: /*
385: -- complete record

Line 405: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

401: p_complete_rec => l_msg_rec,
402: x_return_status => l_return_status
403: );
404:
405: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
406: RAISE FND_API.g_exc_unexpected_error;
407: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
408: RAISE FND_API.g_exc_error;
409: END IF;

Line 406: RAISE FND_API.g_exc_unexpected_error;

402: x_return_status => l_return_status
403: );
404:
405: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
406: RAISE FND_API.g_exc_unexpected_error;
407: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
408: RAISE FND_API.g_exc_error;
409: END IF;
410: END IF;

Line 407: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

403: );
404:
405: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
406: RAISE FND_API.g_exc_unexpected_error;
407: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
408: RAISE FND_API.g_exc_error;
409: END IF;
410: END IF;
411:

Line 408: RAISE FND_API.g_exc_error;

404:
405: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
406: RAISE FND_API.g_exc_unexpected_error;
407: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
408: RAISE FND_API.g_exc_error;
409: END IF;
410: END IF;
411:
412: -- update

Line 452: RAISE FND_API.g_exc_error;

448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
449: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
450: FND_MSG_PUB.add;
451: END IF;
452: RAISE FND_API.g_exc_error;
453: END IF;
454:
455: UPDATE AMS_MESSAGES_TL SET
456: last_update_date = SYSDATE,

Line 470: RAISE FND_API.g_exc_error;

466: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
467: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
468: FND_MSG_PUB.add;
469: END IF;
470: RAISE FND_API.g_exc_error;
471: END IF;
472:
473: -- finish
474: IF FND_API.to_boolean(p_commit) THEN

Line 474: IF FND_API.to_boolean(p_commit) THEN

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

Line 480: P_ENCODED => FND_API.g_false,

476: END IF;
477:
478: FND_MSG_PUB.count_and_get
479: (
480: P_ENCODED => FND_API.g_false,
481: p_count => x_msg_count,
482: p_data => x_msg_data
483: );
484:

Line 495: WHEN FND_API.g_exc_error THEN

491: END IF;
492:
493: EXCEPTION
494:
495: WHEN FND_API.g_exc_error THEN
496: ROLLBACK TO update_msg;
497: x_return_status := FND_API.g_ret_sts_error;
498: FND_MSG_PUB.count_and_get
499: (

Line 497: x_return_status := FND_API.g_ret_sts_error;

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

Line 500: p_encoded => FND_API.g_false,

496: ROLLBACK TO update_msg;
497: x_return_status := FND_API.g_ret_sts_error;
498: FND_MSG_PUB.count_and_get
499: (
500: p_encoded => FND_API.g_false,
501: p_count => x_msg_count,
502: p_data => x_msg_data
503: );
504:

Line 505: WHEN FND_API.g_exc_unexpected_error THEN

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

Line 507: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 510: p_encoded => FND_API.g_false,

506: ROLLBACK TO update_msg;
507: x_return_status := FND_API.g_ret_sts_unexp_error;
508: FND_MSG_PUB.count_and_get
509: (
510: p_encoded => FND_API.g_false,
511: p_count => x_msg_count,
512: p_data => x_msg_data
513: );
514:

Line 517: x_return_status :=FND_API.g_ret_sts_unexp_error;

513: );
514:
515: WHEN OTHERS THEN
516: ROLLBACK TO update_msg;
517: x_return_status :=FND_API.g_ret_sts_unexp_error;
518: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
519: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
520: END IF;
521: FND_MSG_PUB.count_and_get

Line 523: p_encoded => FND_API.g_false,

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

Line 540: P_init_msg_list IN VARCHAR2 := FND_API.g_false,

536: -------------------------------------------------------------------------------
537: PROCEDURE delete_msg
538: (
539: p_api_version IN NUMBER,
540: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
541: p_commit IN VARCHAR2 := FND_API.g_false,
542:
543: x_return_status OUT NOCOPY VARCHAR2,
544: x_msg_count OUT NOCOPY NUMBER,

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

537: PROCEDURE delete_msg
538: (
539: p_api_version IN NUMBER,
540: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
541: p_commit IN VARCHAR2 := FND_API.g_false,
542:
543: x_return_status OUT NOCOPY VARCHAR2,
544: x_msg_count OUT NOCOPY NUMBER,
545: x_msg_data OUT NOCOPY VARCHAR2,

Line 568: IF FND_API.to_boolean(p_init_msg_list) THEN

564: AMS_Utility_PVT.debug_message(l_full_name || ': start');
565:
566: END IF;
567:
568: IF FND_API.to_boolean(p_init_msg_list) THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571:
572: IF NOT FND_API.compatible_api_call

Line 572: IF NOT FND_API.compatible_api_call

568: IF FND_API.to_boolean(p_init_msg_list) THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571:
572: IF NOT FND_API.compatible_api_call
573: (
574: l_api_version,
575: p_api_version,
576: l_api_name,

Line 580: RAISE FND_API.g_exc_unexpected_error;

576: l_api_name,
577: g_pkg_name
578: )
579: THEN
580: RAISE FND_API.g_exc_unexpected_error;
581: END IF;
582:
583: x_return_status := FND_API.g_ret_sts_success;
584:

Line 583: x_return_status := FND_API.g_ret_sts_success;

579: THEN
580: RAISE FND_API.g_exc_unexpected_error;
581: END IF;
582:
583: x_return_status := FND_API.g_ret_sts_success;
584:
585: -- delete
586: IF (AMS_DEBUG_HIGH_ON) THEN
587:

Line 599: RAISE FND_API.g_exc_error;

595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
596: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
597: FND_MSG_PUB.add;
598: END IF;
599: RAISE FND_API.g_exc_error;
600: END IF;
601:
602: DELETE FROM AMS_MESSAGES_B
603: WHERE message_id = p_msg_id

Line 611: RAISE FND_API.g_exc_error;

607: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
608: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
609: FND_MSG_PUB.add;
610: END IF;
611: RAISE FND_API.g_exc_error;
612: END IF;
613:
614: -- finish
615: IF FND_API.to_boolean(p_commit) THEN

Line 615: IF FND_API.to_boolean(p_commit) THEN

611: RAISE FND_API.g_exc_error;
612: END IF;
613:
614: -- finish
615: IF FND_API.to_boolean(p_commit) THEN
616: COMMIT;
617: END IF;
618:
619: FND_MSG_PUB.count_and_get

Line 621: P_ENCODED => FND_API.g_false,

617: END IF;
618:
619: FND_MSG_PUB.count_and_get
620: (
621: P_ENCODED => FND_API.g_false,
622: p_count => x_msg_count,
623: p_data => x_msg_data
624: );
625:

Line 636: WHEN FND_API.g_exc_error THEN

632: END IF;
633:
634: EXCEPTION
635:
636: WHEN FND_API.g_exc_error THEN
637: ROLLBACK TO delete_msg;
638: x_return_status := FND_API.g_ret_sts_error;
639: FND_MSG_PUB.count_and_get
640: (

Line 638: x_return_status := FND_API.g_ret_sts_error;

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

Line 641: p_encoded => FND_API.g_false,

637: ROLLBACK TO delete_msg;
638: x_return_status := FND_API.g_ret_sts_error;
639: FND_MSG_PUB.count_and_get
640: (
641: p_encoded => FND_API.g_false,
642: p_count => x_msg_count,
643: p_data => x_msg_data
644: );
645:

Line 646: WHEN FND_API.g_exc_unexpected_error THEN

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

Line 648: x_return_status := FND_API.g_ret_sts_unexp_error;

644: );
645:
646: WHEN FND_API.g_exc_unexpected_error THEN
647: ROLLBACK TO delete_msg;
648: x_return_status := FND_API.g_ret_sts_unexp_error;
649: FND_MSG_PUB.count_and_get
650: (
651: p_encoded => FND_API.g_false,
652: p_count => x_msg_count,

Line 651: p_encoded => FND_API.g_false,

647: ROLLBACK TO delete_msg;
648: x_return_status := FND_API.g_ret_sts_unexp_error;
649: FND_MSG_PUB.count_and_get
650: (
651: p_encoded => FND_API.g_false,
652: p_count => x_msg_count,
653: p_data => x_msg_data
654: );
655:

Line 658: x_return_status :=FND_API.g_ret_sts_unexp_error;

654: );
655:
656: WHEN OTHERS THEN
657: ROLLBACK TO delete_msg;
658: x_return_status :=FND_API.g_ret_sts_unexp_error;
659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
660: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
661: END IF;
662: FND_MSG_PUB.count_and_get

Line 664: p_encoded => FND_API.g_false,

660: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
661: END IF;
662: FND_MSG_PUB.count_and_get
663: (
664: p_encoded => FND_API.g_false,
665: p_count => x_msg_count,
666: p_data => x_msg_data
667: );
668:

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

677: -------------------------------------------------------------------------------
678: PROCEDURE lock_msg
679: (
680: p_api_version IN NUMBER,
681: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
682:
683: x_return_status OUT NOCOPY VARCHAR2,
684: x_msg_count OUT NOCOPY NUMBER,
685: x_msg_data OUT NOCOPY VARCHAR2,

Line 718: IF FND_API.to_boolean(p_init_msg_list) THEN

714:
715: AMS_Utility_PVT.debug_message(l_full_name || ': start');
716: END IF;
717:
718: IF FND_API.to_boolean(p_init_msg_list) THEN
719: FND_MSG_PUB.initialize;
720: END IF;
721:
722: IF NOT FND_API.compatible_api_call

Line 722: IF NOT FND_API.compatible_api_call

718: IF FND_API.to_boolean(p_init_msg_list) THEN
719: FND_MSG_PUB.initialize;
720: END IF;
721:
722: IF NOT FND_API.compatible_api_call
723: (
724: l_api_version,
725: p_api_version,
726: l_api_name,

Line 730: RAISE FND_API.g_exc_unexpected_error;

726: l_api_name,
727: g_pkg_name
728: )
729: THEN
730: RAISE FND_API.g_exc_unexpected_error;
731: END IF;
732:
733: x_return_status := FND_API.g_ret_sts_success;
734:

Line 733: x_return_status := FND_API.g_ret_sts_success;

729: THEN
730: RAISE FND_API.g_exc_unexpected_error;
731: END IF;
732:
733: x_return_status := FND_API.g_ret_sts_success;
734:
735: -- lock
736: IF (AMS_DEBUG_HIGH_ON) THEN
737:

Line 749: RAISE FND_API.g_exc_error;

745: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
746: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
747: FND_MSG_PUB.add;
748: END IF;
749: RAISE FND_API.g_exc_error;
750: END IF;
751: CLOSE c_msg_b;
752:
753: OPEN c_msg_tl;

Line 761: RAISE FND_API.g_exc_error;

757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
758: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
759: FND_MSG_PUB.add;
760: END IF;
761: RAISE FND_API.g_exc_error;
762: END IF;
763: CLOSE c_msg_tl;
764:
765: -- finish

Line 768: p_encoded => FND_API.g_false,

764:
765: -- finish
766: FND_MSG_PUB.count_and_get
767: (
768: p_encoded => FND_API.g_false,
769: p_count => x_msg_count,
770: p_data => x_msg_data
771: );
772:

Line 784: x_return_status := FND_API.g_ret_sts_error;

780:
781: EXCEPTION
782:
783: WHEN AMS_Utility_PVT.resource_locked THEN
784: x_return_status := FND_API.g_ret_sts_error;
785: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
786: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
787: FND_MSG_PUB.add;
788: END IF;

Line 791: p_encoded => FND_API.g_false,

787: FND_MSG_PUB.add;
788: END IF;
789: FND_MSG_PUB.count_and_get
790: (
791: p_encoded => FND_API.g_false,
792: p_count => x_msg_count,
793: p_data => x_msg_data
794: );
795:

Line 796: WHEN FND_API.g_exc_error THEN

792: p_count => x_msg_count,
793: p_data => x_msg_data
794: );
795:
796: WHEN FND_API.g_exc_error THEN
797: x_return_status := FND_API.g_ret_sts_error;
798: FND_MSG_PUB.count_and_get
799: (
800: p_encoded => FND_API.g_false,

Line 797: x_return_status := FND_API.g_ret_sts_error;

793: p_data => x_msg_data
794: );
795:
796: WHEN FND_API.g_exc_error THEN
797: x_return_status := FND_API.g_ret_sts_error;
798: FND_MSG_PUB.count_and_get
799: (
800: p_encoded => FND_API.g_false,
801: p_count => x_msg_count,

Line 800: p_encoded => FND_API.g_false,

796: WHEN FND_API.g_exc_error THEN
797: x_return_status := FND_API.g_ret_sts_error;
798: FND_MSG_PUB.count_and_get
799: (
800: p_encoded => FND_API.g_false,
801: p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804:

Line 805: WHEN FND_API.g_exc_unexpected_error THEN

801: p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804:
805: WHEN FND_API.g_exc_unexpected_error THEN
806: x_return_status := FND_API.g_ret_sts_unexp_error;
807: FND_MSG_PUB.count_and_get
808: (
809: p_encoded => FND_API.g_false,

Line 806: x_return_status := FND_API.g_ret_sts_unexp_error;

802: p_data => x_msg_data
803: );
804:
805: WHEN FND_API.g_exc_unexpected_error THEN
806: x_return_status := FND_API.g_ret_sts_unexp_error;
807: FND_MSG_PUB.count_and_get
808: (
809: p_encoded => FND_API.g_false,
810: p_count => x_msg_count,

Line 809: p_encoded => FND_API.g_false,

805: WHEN FND_API.g_exc_unexpected_error THEN
806: x_return_status := FND_API.g_ret_sts_unexp_error;
807: FND_MSG_PUB.count_and_get
808: (
809: p_encoded => FND_API.g_false,
810: p_count => x_msg_count,
811: p_data => x_msg_data
812: );
813:

Line 815: x_return_status :=FND_API.g_ret_sts_unexp_error;

811: p_data => x_msg_data
812: );
813:
814: WHEN OTHERS THEN
815: x_return_status :=FND_API.g_ret_sts_unexp_error;
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
817: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
818: END IF;
819: FND_MSG_PUB.count_and_get

Line 821: p_encoded => FND_API.g_false,

817: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
818: END IF;
819: FND_MSG_PUB.count_and_get
820: (
821: p_encoded => FND_API.g_false,
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );
825:

Line 839: P_init_msg_list IN VARCHAR2 := FND_API.g_false,

835: --------------------------------------------------------------------
836: PROCEDURE validate_msg
837: (
838: p_api_version IN NUMBER,
839: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
840: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
841:
842: x_return_status OUT NOCOPY VARCHAR2,
843: x_msg_count OUT NOCOPY NUMBER,

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

836: PROCEDURE validate_msg
837: (
838: p_api_version IN NUMBER,
839: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
840: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
841:
842: x_return_status OUT NOCOPY VARCHAR2,
843: x_msg_count OUT NOCOPY NUMBER,
844: x_msg_data OUT NOCOPY VARCHAR2,

Line 864: IF NOT FND_API.compatible_api_call

860:
861: AMS_Utility_PVT.debug_message(l_full_name||': start');
862: END IF;
863:
864: IF NOT FND_API.compatible_api_call
865: (
866: l_api_version,
867: p_api_version,
868: l_api_name,

Line 872: RAISE FND_API.g_exc_unexpected_error;

868: l_api_name,
869: g_pkg_name
870: )
871: THEN
872: RAISE FND_API.g_exc_unexpected_error;
873: END IF;
874:
875: x_return_status := FND_API.g_ret_sts_success;
876:

Line 875: x_return_status := FND_API.g_ret_sts_success;

871: THEN
872: RAISE FND_API.g_exc_unexpected_error;
873: END IF;
874:
875: x_return_status := FND_API.g_ret_sts_success;
876:
877: ---------------------- validate ------------------------
878: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
879: IF (AMS_DEBUG_HIGH_ON) THEN

Line 890: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

886: x_return_status => l_return_status,
887: p_msg_rec => p_msg_rec
888: );
889:
890: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
891: RAISE FND_API.g_exc_unexpected_error;
892: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
893: RAISE FND_API.g_exc_error;
894: END IF;

Line 891: RAISE FND_API.g_exc_unexpected_error;

887: p_msg_rec => p_msg_rec
888: );
889:
890: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
891: RAISE FND_API.g_exc_unexpected_error;
892: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
893: RAISE FND_API.g_exc_error;
894: END IF;
895: END IF;

Line 892: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

888: );
889:
890: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
891: RAISE FND_API.g_exc_unexpected_error;
892: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
893: RAISE FND_API.g_exc_error;
894: END IF;
895: END IF;
896:

Line 893: RAISE FND_API.g_exc_error;

889:
890: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
891: RAISE FND_API.g_exc_unexpected_error;
892: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
893: RAISE FND_API.g_exc_error;
894: END IF;
895: END IF;
896:
897: -- record level

Line 910: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

906: p_complete_rec => p_msg_rec,
907: x_return_status => l_return_status
908: );
909:
910: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
911: RAISE FND_API.g_exc_unexpected_error;
912: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
913: RAISE FND_API.g_exc_error;
914: END IF;

Line 911: RAISE FND_API.g_exc_unexpected_error;

907: x_return_status => l_return_status
908: );
909:
910: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
911: RAISE FND_API.g_exc_unexpected_error;
912: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
913: RAISE FND_API.g_exc_error;
914: END IF;
915: END IF;

Line 912: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

908: );
909:
910: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
911: RAISE FND_API.g_exc_unexpected_error;
912: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
913: RAISE FND_API.g_exc_error;
914: END IF;
915: END IF;
916: -------------------- finish --------------------------

Line 913: RAISE FND_API.g_exc_error;

909:
910: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
911: RAISE FND_API.g_exc_unexpected_error;
912: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
913: RAISE FND_API.g_exc_error;
914: END IF;
915: END IF;
916: -------------------- finish --------------------------
917: FND_MSG_PUB.count_and_get

Line 919: p_encoded => FND_API.g_false,

915: END IF;
916: -------------------- finish --------------------------
917: FND_MSG_PUB.count_and_get
918: (
919: p_encoded => FND_API.g_false,
920: p_count => x_msg_count,
921: p_data => x_msg_data
922: );
923:

Line 933: WHEN FND_API.g_exc_error THEN

929:
930: END IF;
931:
932: EXCEPTION
933: WHEN FND_API.g_exc_error THEN
934: x_return_status := FND_API.g_ret_sts_error;
935: FND_MSG_PUB.count_and_get
936: (
937: p_encoded => FND_API.g_false,

Line 934: x_return_status := FND_API.g_ret_sts_error;

930: END IF;
931:
932: EXCEPTION
933: WHEN FND_API.g_exc_error THEN
934: x_return_status := FND_API.g_ret_sts_error;
935: FND_MSG_PUB.count_and_get
936: (
937: p_encoded => FND_API.g_false,
938: p_count => x_msg_count,

Line 937: p_encoded => FND_API.g_false,

933: WHEN FND_API.g_exc_error THEN
934: x_return_status := FND_API.g_ret_sts_error;
935: FND_MSG_PUB.count_and_get
936: (
937: p_encoded => FND_API.g_false,
938: p_count => x_msg_count,
939: p_data => x_msg_data
940: );
941:

Line 942: WHEN FND_API.g_exc_unexpected_error THEN

938: p_count => x_msg_count,
939: p_data => x_msg_data
940: );
941:
942: WHEN FND_API.g_exc_unexpected_error THEN
943: x_return_status := FND_API.g_ret_sts_unexp_error ;
944: FND_MSG_PUB.count_and_get
945: (
946: p_encoded => FND_API.g_false,

Line 943: x_return_status := FND_API.g_ret_sts_unexp_error ;

939: p_data => x_msg_data
940: );
941:
942: WHEN FND_API.g_exc_unexpected_error THEN
943: x_return_status := FND_API.g_ret_sts_unexp_error ;
944: FND_MSG_PUB.count_and_get
945: (
946: p_encoded => FND_API.g_false,
947: p_count => x_msg_count,

Line 946: p_encoded => FND_API.g_false,

942: WHEN FND_API.g_exc_unexpected_error THEN
943: x_return_status := FND_API.g_ret_sts_unexp_error ;
944: FND_MSG_PUB.count_and_get
945: (
946: p_encoded => FND_API.g_false,
947: p_count => x_msg_count,
948: p_data => x_msg_data
949: );
950:

Line 952: x_return_status := FND_API.g_ret_sts_unexp_error;

948: p_data => x_msg_data
949: );
950:
951: WHEN OTHERS THEN
952: x_return_status := FND_API.g_ret_sts_unexp_error;
953: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
954: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
955: END IF;
956:

Line 959: p_encoded => FND_API.g_false,

955: END IF;
956:
957: FND_MSG_PUB.count_and_get
958: (
959: p_encoded => FND_API.g_false,
960: p_count => x_msg_count,
961: p_data => x_msg_data
962: );
963:

Line 991: x_return_status := FND_API.g_ret_sts_success;

987:
988: AMS_Utility_PVT.debug_message(l_full_name || ': start');
989: END IF;
990:
991: x_return_status := FND_API.g_ret_sts_success;
992:
993: -- check required items
994: IF (AMS_DEBUG_HIGH_ON) THEN
995:

Line 1005: IF x_return_status <> FND_API.g_ret_sts_success THEN

1001: p_msg_rec => p_msg_rec,
1002: x_return_status => x_return_status
1003: );
1004:
1005: IF x_return_status <> FND_API.g_ret_sts_success THEN
1006: RETURN;
1007: END IF;
1008:
1009: -- check unique key items

Line 1021: IF x_return_status <> FND_API.g_ret_sts_success THEN

1017: p_msg_rec => p_msg_rec,
1018: x_return_status => x_return_status
1019: );
1020:
1021: IF x_return_status <> FND_API.g_ret_sts_success THEN
1022: RETURN;
1023: END IF;
1024:
1025: END check_items;

Line 1044: x_return_status := FND_API.g_ret_sts_success;

1040: IS
1041:
1042: BEGIN
1043:
1044: x_return_status := FND_API.g_ret_sts_success;
1045:
1046: -- check message_id
1047: IF p_msg_rec.message_id IS NULL
1048: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 1054: x_return_status := FND_API.g_ret_sts_error;

1050: FND_MESSAGE.set_name('AMS', 'AMS_MSG_NO_MSG_ID');
1051: FND_MSG_PUB.add;
1052: END IF;
1053:
1054: x_return_status := FND_API.g_ret_sts_error;
1055: RETURN;
1056: END IF;
1057:
1058: -- check object_version_number

Line 1067: x_return_status := FND_API.g_ret_sts_error;

1063: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
1064: FND_MSG_PUB.add;
1065: END IF;
1066:
1067: x_return_status := FND_API.g_ret_sts_error;
1068: RETURN;
1069: END IF;
1070:
1071: -- check active_flag

Line 1078: x_return_status := FND_API.g_ret_sts_error;

1074: FND_MESSAGE.set_name('AMS', 'AMS_MSG_BAD_ACTIVE_FLAG');
1075: FND_MSG_PUB.add;
1076: END IF;
1077:
1078: x_return_status := FND_API.g_ret_sts_error;
1079: RETURN;
1080: END IF;
1081:
1082: IF p_msg_rec.active_flag <> 'Y'

Line 1084: AND p_msg_rec.active_flag <> FND_API.g_miss_char

1080: END IF;
1081:
1082: IF p_msg_rec.active_flag <> 'Y'
1083: AND p_msg_rec.active_flag <> 'N'
1084: AND p_msg_rec.active_flag <> FND_API.g_miss_char
1085: THEN
1086: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1087: FND_MESSAGE.set_name('AMS', 'AMS_MSG_BAD_ACTIVE_FLAG');
1088: FND_MSG_PUB.add;

Line 1091: x_return_status := FND_API.g_ret_sts_error;

1087: FND_MESSAGE.set_name('AMS', 'AMS_MSG_BAD_ACTIVE_FLAG');
1088: FND_MSG_PUB.add;
1089: END IF;
1090:
1091: x_return_status := FND_API.g_ret_sts_error;
1092: RETURN;
1093: END IF;
1094:
1095: -- check message_name

Line 1102: x_return_status := FND_API.g_ret_sts_error;

1098: FND_MESSAGE.set_name('AMS', 'AMS_MSG_NO_MSG_NAME');
1099: FND_MSG_PUB.add;
1100: END IF;
1101:
1102: x_return_status := FND_API.g_ret_sts_error;
1103: RETURN;
1104: END IF;
1105:
1106: END check_req_items;

Line 1143: x_return_status := FND_API.g_ret_sts_success;

1139: l_flag VARCHAR2(1);
1140:
1141: BEGIN
1142:
1143: x_return_status := FND_API.g_ret_sts_success;
1144:
1145: -- check PK, if message_id is passed in, must check if it is duplicate
1146: IF p_validation_mode = JTF_PLSQL_API.g_create
1147: AND p_msg_rec.message_id IS NOT NULL

Line 1156: IF l_uk_flag = FND_API.g_false THEN

1152: 'message_id = ' || p_msg_rec.message_id
1153: );
1154: END IF;
1155:
1156: IF l_uk_flag = FND_API.g_false THEN
1157: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1158: FND_MESSAGE.set_name('AMS', 'AMS_MSG_DUPLICATE_MSG_ID');
1159: FND_MSG_PUB.add;
1160: END IF;

Line 1162: x_return_status := FND_API.g_ret_sts_error;

1158: FND_MESSAGE.set_name('AMS', 'AMS_MSG_DUPLICATE_MSG_ID');
1159: FND_MSG_PUB.add;
1160: END IF;
1161:
1162: x_return_status := FND_API.g_ret_sts_error;
1163: RETURN;
1164: END IF;
1165:
1166: -- check message_name, language

Line 1186: IF l_uk_flag = FND_API.g_false THEN

1182: ||''' AND language = ''' || USERENV('LANG') || ''''
1183: );
1184: END IF;
1185:
1186: IF l_uk_flag = FND_API.g_false THEN
1187: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1188: FND_MESSAGE.set_name('AMS', 'AMS_MSG_DUP_NAME_LANG');
1189: FND_MSG_PUB.add;
1190: END IF;

Line 1217: x_return_status := FND_API.g_ret_sts_error;

1213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1214: FND_MESSAGE.set_name('AMS', 'AMS_MSG_DUP_NAME_LANG');
1215: FND_MSG_PUB.add;
1216: END IF;
1217: x_return_status := FND_API.g_ret_sts_error;
1218: RETURN;
1219: END IF;
1220:
1221: END check_uk_items;

Line 1244: x_return_status := FND_API.g_ret_sts_success;

1240: l_date_to DATE;
1241:
1242: BEGIN
1243:
1244: x_return_status := FND_API.g_ret_sts_success;
1245:
1246: -- check that date_effective_from <= date_effective_to
1247: IF p_complete_rec.date_effective_from <> FND_API.g_miss_date
1248: AND p_complete_rec.date_effective_from IS NOT NULL

Line 1247: IF p_complete_rec.date_effective_from <> FND_API.g_miss_date

1243:
1244: x_return_status := FND_API.g_ret_sts_success;
1245:
1246: -- check that date_effective_from <= date_effective_to
1247: IF p_complete_rec.date_effective_from <> FND_API.g_miss_date
1248: AND p_complete_rec.date_effective_from IS NOT NULL
1249: AND p_complete_rec.date_effective_to <> FND_API.g_miss_date
1250: AND p_complete_rec.date_effective_to IS NOT NULL
1251: THEN

Line 1249: AND p_complete_rec.date_effective_to <> FND_API.g_miss_date

1245:
1246: -- check that date_effective_from <= date_effective_to
1247: IF p_complete_rec.date_effective_from <> FND_API.g_miss_date
1248: AND p_complete_rec.date_effective_from IS NOT NULL
1249: AND p_complete_rec.date_effective_to <> FND_API.g_miss_date
1250: AND p_complete_rec.date_effective_to IS NOT NULL
1251: THEN
1252: l_date_from := p_complete_rec.date_effective_from;
1253: l_date_to := p_complete_rec.date_effective_to;

Line 1260: x_return_status := FND_API.g_ret_sts_error;

1256: FND_MESSAGE.set_name('AMS', 'AMS_MESG_INVALID_DATES');
1257: FND_MSG_PUB.add;
1258: END IF;
1259:
1260: x_return_status := FND_API.g_ret_sts_error;
1261: RETURN;
1262: END IF;
1263: END IF;
1264:

Line 1299: RAISE FND_API.g_exc_error;

1295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1296: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1297: FND_MSG_PUB.add;
1298: END IF;
1299: RAISE FND_API.g_exc_error;
1300: END IF;
1301: CLOSE c_msg;
1302:
1303: IF p_msg_rec.date_effective_from = FND_API.g_miss_date THEN

Line 1303: IF p_msg_rec.date_effective_from = FND_API.g_miss_date THEN

1299: RAISE FND_API.g_exc_error;
1300: END IF;
1301: CLOSE c_msg;
1302:
1303: IF p_msg_rec.date_effective_from = FND_API.g_miss_date THEN
1304: x_complete_rec.date_effective_from := l_msg_rec.date_effective_from;
1305: END IF;
1306:
1307: IF p_msg_rec.date_effective_to = FND_API.g_miss_date THEN

Line 1307: IF p_msg_rec.date_effective_to = FND_API.g_miss_date THEN

1303: IF p_msg_rec.date_effective_from = FND_API.g_miss_date THEN
1304: x_complete_rec.date_effective_from := l_msg_rec.date_effective_from;
1305: END IF;
1306:
1307: IF p_msg_rec.date_effective_to = FND_API.g_miss_date THEN
1308: x_complete_rec.date_effective_to := l_msg_rec.date_effective_to;
1309: END IF;
1310:
1311: IF p_msg_rec.active_flag = FND_API.g_miss_char THEN

Line 1311: IF p_msg_rec.active_flag = FND_API.g_miss_char THEN

1307: IF p_msg_rec.date_effective_to = FND_API.g_miss_date THEN
1308: x_complete_rec.date_effective_to := l_msg_rec.date_effective_to;
1309: END IF;
1310:
1311: IF p_msg_rec.active_flag = FND_API.g_miss_char THEN
1312: x_complete_rec.active_flag := l_msg_rec.active_flag;
1313: END IF;
1314:
1315: IF p_msg_rec.message_name = FND_API.g_miss_char THEN

Line 1315: IF p_msg_rec.message_name = FND_API.g_miss_char THEN

1311: IF p_msg_rec.active_flag = FND_API.g_miss_char THEN
1312: x_complete_rec.active_flag := l_msg_rec.active_flag;
1313: END IF;
1314:
1315: IF p_msg_rec.message_name = FND_API.g_miss_char THEN
1316: x_complete_rec.message_name := l_msg_rec.message_name;
1317: END IF;
1318:
1319: IF p_msg_rec.description = FND_API.g_miss_char THEN

Line 1319: IF p_msg_rec.description = FND_API.g_miss_char THEN

1315: IF p_msg_rec.message_name = FND_API.g_miss_char THEN
1316: x_complete_rec.message_name := l_msg_rec.message_name;
1317: END IF;
1318:
1319: IF p_msg_rec.description = FND_API.g_miss_char THEN
1320: x_complete_rec.description := l_msg_rec.description;
1321: END IF;
1322:
1323: IF p_msg_rec.owner_user_id = FND_API.g_miss_num THEN

Line 1323: IF p_msg_rec.owner_user_id = FND_API.g_miss_num THEN

1319: IF p_msg_rec.description = FND_API.g_miss_char THEN
1320: x_complete_rec.description := l_msg_rec.description;
1321: END IF;
1322:
1323: IF p_msg_rec.owner_user_id = FND_API.g_miss_num THEN
1324: x_complete_rec.owner_user_id := l_msg_rec.owner_user_id;
1325: END IF;
1326:
1327: IF p_msg_rec.message_type_code = FND_API.g_miss_char THEN

Line 1327: IF p_msg_rec.message_type_code = FND_API.g_miss_char THEN

1323: IF p_msg_rec.owner_user_id = FND_API.g_miss_num THEN
1324: x_complete_rec.owner_user_id := l_msg_rec.owner_user_id;
1325: END IF;
1326:
1327: IF p_msg_rec.message_type_code = FND_API.g_miss_char THEN
1328: x_complete_rec.message_type_code := l_msg_rec.message_type_code;
1329: END IF;
1330:
1331: END complete_msg_rec;

Line 1349: x_msg_rec.message_id := FND_API.g_miss_num;

1345: IS
1346:
1347: BEGIN
1348:
1349: x_msg_rec.message_id := FND_API.g_miss_num;
1350: x_msg_rec.country_id := FND_API.g_miss_num;
1351: x_msg_rec.last_update_date := FND_API.g_miss_date;
1352: x_msg_rec.last_updated_by := FND_API.g_miss_num;
1353: x_msg_rec.creation_date := FND_API.g_miss_date;

Line 1350: x_msg_rec.country_id := FND_API.g_miss_num;

1346:
1347: BEGIN
1348:
1349: x_msg_rec.message_id := FND_API.g_miss_num;
1350: x_msg_rec.country_id := FND_API.g_miss_num;
1351: x_msg_rec.last_update_date := FND_API.g_miss_date;
1352: x_msg_rec.last_updated_by := FND_API.g_miss_num;
1353: x_msg_rec.creation_date := FND_API.g_miss_date;
1354: x_msg_rec.created_by := FND_API.g_miss_num;

Line 1351: x_msg_rec.last_update_date := FND_API.g_miss_date;

1347: BEGIN
1348:
1349: x_msg_rec.message_id := FND_API.g_miss_num;
1350: x_msg_rec.country_id := FND_API.g_miss_num;
1351: x_msg_rec.last_update_date := FND_API.g_miss_date;
1352: x_msg_rec.last_updated_by := FND_API.g_miss_num;
1353: x_msg_rec.creation_date := FND_API.g_miss_date;
1354: x_msg_rec.created_by := FND_API.g_miss_num;
1355: x_msg_rec.last_update_login := FND_API.g_miss_num;

Line 1352: x_msg_rec.last_updated_by := FND_API.g_miss_num;

1348:
1349: x_msg_rec.message_id := FND_API.g_miss_num;
1350: x_msg_rec.country_id := FND_API.g_miss_num;
1351: x_msg_rec.last_update_date := FND_API.g_miss_date;
1352: x_msg_rec.last_updated_by := FND_API.g_miss_num;
1353: x_msg_rec.creation_date := FND_API.g_miss_date;
1354: x_msg_rec.created_by := FND_API.g_miss_num;
1355: x_msg_rec.last_update_login := FND_API.g_miss_num;
1356: x_msg_rec.object_version_number := FND_API.g_miss_num;

Line 1353: x_msg_rec.creation_date := FND_API.g_miss_date;

1349: x_msg_rec.message_id := FND_API.g_miss_num;
1350: x_msg_rec.country_id := FND_API.g_miss_num;
1351: x_msg_rec.last_update_date := FND_API.g_miss_date;
1352: x_msg_rec.last_updated_by := FND_API.g_miss_num;
1353: x_msg_rec.creation_date := FND_API.g_miss_date;
1354: x_msg_rec.created_by := FND_API.g_miss_num;
1355: x_msg_rec.last_update_login := FND_API.g_miss_num;
1356: x_msg_rec.object_version_number := FND_API.g_miss_num;
1357: x_msg_rec.date_effective_from := FND_API.g_miss_date;

Line 1354: x_msg_rec.created_by := FND_API.g_miss_num;

1350: x_msg_rec.country_id := FND_API.g_miss_num;
1351: x_msg_rec.last_update_date := FND_API.g_miss_date;
1352: x_msg_rec.last_updated_by := FND_API.g_miss_num;
1353: x_msg_rec.creation_date := FND_API.g_miss_date;
1354: x_msg_rec.created_by := FND_API.g_miss_num;
1355: x_msg_rec.last_update_login := FND_API.g_miss_num;
1356: x_msg_rec.object_version_number := FND_API.g_miss_num;
1357: x_msg_rec.date_effective_from := FND_API.g_miss_date;
1358: x_msg_rec.date_effective_to := FND_API.g_miss_date;

Line 1355: x_msg_rec.last_update_login := FND_API.g_miss_num;

1351: x_msg_rec.last_update_date := FND_API.g_miss_date;
1352: x_msg_rec.last_updated_by := FND_API.g_miss_num;
1353: x_msg_rec.creation_date := FND_API.g_miss_date;
1354: x_msg_rec.created_by := FND_API.g_miss_num;
1355: x_msg_rec.last_update_login := FND_API.g_miss_num;
1356: x_msg_rec.object_version_number := FND_API.g_miss_num;
1357: x_msg_rec.date_effective_from := FND_API.g_miss_date;
1358: x_msg_rec.date_effective_to := FND_API.g_miss_date;
1359: x_msg_rec.active_flag := 'Y';

Line 1356: x_msg_rec.object_version_number := FND_API.g_miss_num;

1352: x_msg_rec.last_updated_by := FND_API.g_miss_num;
1353: x_msg_rec.creation_date := FND_API.g_miss_date;
1354: x_msg_rec.created_by := FND_API.g_miss_num;
1355: x_msg_rec.last_update_login := FND_API.g_miss_num;
1356: x_msg_rec.object_version_number := FND_API.g_miss_num;
1357: x_msg_rec.date_effective_from := FND_API.g_miss_date;
1358: x_msg_rec.date_effective_to := FND_API.g_miss_date;
1359: x_msg_rec.active_flag := 'Y';
1360: x_msg_rec.message_type_code := FND_API.g_miss_char;

Line 1357: x_msg_rec.date_effective_from := FND_API.g_miss_date;

1353: x_msg_rec.creation_date := FND_API.g_miss_date;
1354: x_msg_rec.created_by := FND_API.g_miss_num;
1355: x_msg_rec.last_update_login := FND_API.g_miss_num;
1356: x_msg_rec.object_version_number := FND_API.g_miss_num;
1357: x_msg_rec.date_effective_from := FND_API.g_miss_date;
1358: x_msg_rec.date_effective_to := FND_API.g_miss_date;
1359: x_msg_rec.active_flag := 'Y';
1360: x_msg_rec.message_type_code := FND_API.g_miss_char;
1361: x_msg_rec.owner_user_id := FND_API.g_miss_num;

Line 1358: x_msg_rec.date_effective_to := FND_API.g_miss_date;

1354: x_msg_rec.created_by := FND_API.g_miss_num;
1355: x_msg_rec.last_update_login := FND_API.g_miss_num;
1356: x_msg_rec.object_version_number := FND_API.g_miss_num;
1357: x_msg_rec.date_effective_from := FND_API.g_miss_date;
1358: x_msg_rec.date_effective_to := FND_API.g_miss_date;
1359: x_msg_rec.active_flag := 'Y';
1360: x_msg_rec.message_type_code := FND_API.g_miss_char;
1361: x_msg_rec.owner_user_id := FND_API.g_miss_num;
1362: x_msg_rec.message_name := FND_API.g_miss_char;

Line 1360: x_msg_rec.message_type_code := FND_API.g_miss_char;

1356: x_msg_rec.object_version_number := FND_API.g_miss_num;
1357: x_msg_rec.date_effective_from := FND_API.g_miss_date;
1358: x_msg_rec.date_effective_to := FND_API.g_miss_date;
1359: x_msg_rec.active_flag := 'Y';
1360: x_msg_rec.message_type_code := FND_API.g_miss_char;
1361: x_msg_rec.owner_user_id := FND_API.g_miss_num;
1362: x_msg_rec.message_name := FND_API.g_miss_char;
1363: x_msg_rec.description := FND_API.g_miss_char;
1364:

Line 1361: x_msg_rec.owner_user_id := FND_API.g_miss_num;

1357: x_msg_rec.date_effective_from := FND_API.g_miss_date;
1358: x_msg_rec.date_effective_to := FND_API.g_miss_date;
1359: x_msg_rec.active_flag := 'Y';
1360: x_msg_rec.message_type_code := FND_API.g_miss_char;
1361: x_msg_rec.owner_user_id := FND_API.g_miss_num;
1362: x_msg_rec.message_name := FND_API.g_miss_char;
1363: x_msg_rec.description := FND_API.g_miss_char;
1364:
1365: END init_rec;

Line 1362: x_msg_rec.message_name := FND_API.g_miss_char;

1358: x_msg_rec.date_effective_to := FND_API.g_miss_date;
1359: x_msg_rec.active_flag := 'Y';
1360: x_msg_rec.message_type_code := FND_API.g_miss_char;
1361: x_msg_rec.owner_user_id := FND_API.g_miss_num;
1362: x_msg_rec.message_name := FND_API.g_miss_char;
1363: x_msg_rec.description := FND_API.g_miss_char;
1364:
1365: END init_rec;
1366:

Line 1363: x_msg_rec.description := FND_API.g_miss_char;

1359: x_msg_rec.active_flag := 'Y';
1360: x_msg_rec.message_type_code := FND_API.g_miss_char;
1361: x_msg_rec.owner_user_id := FND_API.g_miss_num;
1362: x_msg_rec.message_name := FND_API.g_miss_char;
1363: x_msg_rec.description := FND_API.g_miss_char;
1364:
1365: END init_rec;
1366:
1367: END AMS_Messages_PVT;