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.

[Home] [Help]

APPS.AMS_CHANNEL_PVT dependencies on FND_API

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

40: -- 01/18/2001 rssharma Removed internal_resource attribute from the record and related code
41: ---------------------------------------------------------------------
42: PROCEDURE create_channel(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,

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

41: ---------------------------------------------------------------------
42: PROCEDURE create_channel(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,
49: x_msg_data OUT NOCOPY VARCHAR2,

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

42: PROCEDURE create_channel(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
45: p_commit IN VARCHAR2 := FND_API.g_false,
46: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,
49: x_msg_data OUT NOCOPY VARCHAR2,
50:

Line 86: IF FND_API.to_boolean(p_init_msg_list) THEN

82: AMS_Utility_PVT.debug_message(l_full_name||': start');
83:
84: END IF;
85:
86: IF FND_API.to_boolean(p_init_msg_list) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: IF NOT FND_API.compatible_api_call(

Line 90: IF NOT FND_API.compatible_api_call(

86: IF FND_API.to_boolean(p_init_msg_list) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: IF NOT FND_API.compatible_api_call(
91: l_api_version,
92: p_api_version,
93: l_api_name,
94: g_pkg_name

Line 96: RAISE FND_API.g_exc_unexpected_error;

92: p_api_version,
93: l_api_name,
94: g_pkg_name
95: ) THEN
96: RAISE FND_API.g_exc_unexpected_error;
97: END IF;
98:
99: x_return_status := FND_API.g_ret_sts_success;
100:

Line 99: x_return_status := FND_API.g_ret_sts_success;

95: ) THEN
96: RAISE FND_API.g_exc_unexpected_error;
97: END IF;
98:
99: x_return_status := FND_API.g_ret_sts_success;
100:
101: ----------------------- validate -----------------------
102: IF (AMS_DEBUG_HIGH_ON) THEN
103:

Line 116: IF l_return_status = FND_API.g_ret_sts_error THEN

112: x_msg_count => x_msg_count,
113: x_msg_data => x_msg_data,
114: p_chan_rec => l_chan_rec
115: );
116: IF l_return_status = FND_API.g_ret_sts_error THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;

Line 117: RAISE FND_API.g_exc_error;

113: x_msg_data => x_msg_data,
114: p_chan_rec => l_chan_rec
115: );
116: IF l_return_status = FND_API.g_ret_sts_error THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121:

Line 118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

114: p_chan_rec => l_chan_rec
115: );
116: IF l_return_status = FND_API.g_ret_sts_error THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121:
122: -- try to generate a unique id from the sequence

Line 119: RAISE FND_API.g_exc_unexpected_error;

115: );
116: IF l_return_status = FND_API.g_ret_sts_error THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121:
122: -- try to generate a unique id from the sequence
123: IF l_chan_rec.channel_id IS NULL THEN

Line 274: IF FND_API.to_boolean(p_commit) THEN

270:
271: ------------------------- finish -------------------------------
272: x_chan_id := l_chan_rec.channel_id;
273:
274: IF FND_API.to_boolean(p_commit) THEN
275: COMMIT;
276: END IF;
277:
278: FND_MSG_PUB.count_and_get(

Line 279: p_encoded => FND_API.g_false,

275: COMMIT;
276: END IF;
277:
278: FND_MSG_PUB.count_and_get(
279: p_encoded => FND_API.g_false,
280: p_count => x_msg_count,
281: p_data => x_msg_data
282: );
283:

Line 294: WHEN FND_API.g_exc_error THEN

290: END IF;
291:
292: EXCEPTION
293:
294: WHEN FND_API.g_exc_error THEN
295: ROLLBACK TO create_channel;
296: x_return_status := FND_API.g_ret_sts_error;
297: FND_MSG_PUB.count_and_get(
298: p_encoded => FND_API.g_false,

Line 296: x_return_status := FND_API.g_ret_sts_error;

292: EXCEPTION
293:
294: WHEN FND_API.g_exc_error THEN
295: ROLLBACK TO create_channel;
296: x_return_status := FND_API.g_ret_sts_error;
297: FND_MSG_PUB.count_and_get(
298: p_encoded => FND_API.g_false,
299: p_count => x_msg_count,
300: p_data => x_msg_data

Line 298: p_encoded => FND_API.g_false,

294: WHEN FND_API.g_exc_error THEN
295: ROLLBACK TO create_channel;
296: x_return_status := FND_API.g_ret_sts_error;
297: FND_MSG_PUB.count_and_get(
298: p_encoded => FND_API.g_false,
299: p_count => x_msg_count,
300: p_data => x_msg_data
301: );
302:

Line 303: WHEN FND_API.g_exc_unexpected_error THEN

299: p_count => x_msg_count,
300: p_data => x_msg_data
301: );
302:
303: WHEN FND_API.g_exc_unexpected_error THEN
304: ROLLBACK TO create_channel;
305: x_return_status := FND_API.g_ret_sts_unexp_error ;
306: FND_MSG_PUB.count_and_get(
307: p_encoded => FND_API.g_false,

Line 305: x_return_status := FND_API.g_ret_sts_unexp_error ;

301: );
302:
303: WHEN FND_API.g_exc_unexpected_error THEN
304: ROLLBACK TO create_channel;
305: x_return_status := FND_API.g_ret_sts_unexp_error ;
306: FND_MSG_PUB.count_and_get(
307: p_encoded => FND_API.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data

Line 307: p_encoded => FND_API.g_false,

303: WHEN FND_API.g_exc_unexpected_error THEN
304: ROLLBACK TO create_channel;
305: x_return_status := FND_API.g_ret_sts_unexp_error ;
306: FND_MSG_PUB.count_and_get(
307: p_encoded => FND_API.g_false,
308: p_count => x_msg_count,
309: p_data => x_msg_data
310: );
311:

Line 315: x_return_status := FND_API.g_ret_sts_unexp_error ;

311:
312:
313: WHEN OTHERS THEN
314: ROLLBACK TO create_channel;
315: x_return_status := FND_API.g_ret_sts_unexp_error ;
316:
317: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
318: THEN
319: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 323: p_encoded => FND_API.g_false,

319: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
320: END IF;
321:
322: FND_MSG_PUB.count_and_get(
323: p_encoded => FND_API.g_false,
324: p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327:

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

337: -- 07/11/00 holiu Cannot delete if associated to activities.
338: -----------------------------------------------------------------
339: PROCEDURE delete_channel(
340: p_api_version IN NUMBER,
341: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
342: p_commit IN VARCHAR2 := FND_API.g_false,
343:
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,

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

338: -----------------------------------------------------------------
339: PROCEDURE delete_channel(
340: p_api_version IN NUMBER,
341: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
342: p_commit IN VARCHAR2 := FND_API.g_false,
343:
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,

Line 385: IF FND_API.to_boolean(p_init_msg_list) THEN

381: AMS_Utility_PVT.debug_message(l_full_name||': start');
382:
383: END IF;
384:
385: IF FND_API.to_boolean(p_init_msg_list) THEN
386: FND_MSG_PUB.initialize;
387: END IF;
388:
389: IF NOT FND_API.compatible_api_call(

Line 389: IF NOT FND_API.compatible_api_call(

385: IF FND_API.to_boolean(p_init_msg_list) THEN
386: FND_MSG_PUB.initialize;
387: END IF;
388:
389: IF NOT FND_API.compatible_api_call(
390: l_api_version,
391: p_api_version,
392: l_api_name,
393: g_pkg_name

Line 395: RAISE FND_API.g_exc_unexpected_error;

391: p_api_version,
392: l_api_name,
393: g_pkg_name
394: ) THEN
395: RAISE FND_API.g_exc_unexpected_error;
396: END IF;
397:
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399:

Line 398: x_return_status := FND_API.G_RET_STS_SUCCESS;

394: ) THEN
395: RAISE FND_API.g_exc_unexpected_error;
396: END IF;
397:
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399:
400: -- holiu: the following checking is added for bug 1350477
401: IF (AMS_DEBUG_HIGH_ON) THEN
402:

Line 416: RAISE FND_API.g_exc_error;

412: THEN
413: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_CANNOT_DELETE');
414: FND_MSG_PUB.add;
415: END IF;
416: RAISE FND_API.g_exc_error;
417: END IF;
418:
419: -- Bug fix:2089112. Added by rrajesh on 10/31/01
420: OPEN c_check_schedule_association;

Line 430: RAISE FND_API.g_exc_error;

426: THEN
427: FND_MESSAGE.set_name('AMS', 'AMS_MKTG_MEDIA_IS_USED_BY_CSCH');
428: FND_MSG_PUB.add;
429: END IF;
430: RAISE FND_API.g_exc_error;
431: END IF;
432: -- Bug fix:2089112. 10/31/01
433: ------------------------ delete ------------------------
434: IF (AMS_DEBUG_HIGH_ON) THEN

Line 449: RAISE FND_API.g_exc_error;

445: THEN
446: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
447: FND_MSG_PUB.add;
448: END IF;
449: RAISE FND_API.g_exc_error;
450: END IF;
451:
452: DELETE FROM ams_channels_tl
453: WHERE channel_id = p_chan_id;

Line 461: RAISE FND_API.g_exc_error;

457: THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
459: FND_MSG_PUB.add;
460: END IF;
461: RAISE FND_API.g_exc_error;
462: END IF;
463:
464: -------------------- finish --------------------------
465: IF FND_API.to_boolean(p_commit) THEN

Line 465: IF FND_API.to_boolean(p_commit) THEN

461: RAISE FND_API.g_exc_error;
462: END IF;
463:
464: -------------------- finish --------------------------
465: IF FND_API.to_boolean(p_commit) THEN
466: COMMIT;
467: END IF;
468:
469: FND_MSG_PUB.count_and_get(

Line 470: p_encoded => FND_API.g_false,

466: COMMIT;
467: END IF;
468:
469: FND_MSG_PUB.count_and_get(
470: p_encoded => FND_API.g_false,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );
474:

Line 485: WHEN FND_API.g_exc_error THEN

481: END IF;
482:
483: EXCEPTION
484:
485: WHEN FND_API.g_exc_error THEN
486: ROLLBACK TO delete_channel;
487: x_return_status := FND_API.g_ret_sts_error;
488: FND_MSG_PUB.count_and_get(
489: p_encoded => FND_API.g_false,

Line 487: x_return_status := FND_API.g_ret_sts_error;

483: EXCEPTION
484:
485: WHEN FND_API.g_exc_error THEN
486: ROLLBACK TO delete_channel;
487: x_return_status := FND_API.g_ret_sts_error;
488: FND_MSG_PUB.count_and_get(
489: p_encoded => FND_API.g_false,
490: p_count => x_msg_count,
491: p_data => x_msg_data

Line 489: p_encoded => FND_API.g_false,

485: WHEN FND_API.g_exc_error THEN
486: ROLLBACK TO delete_channel;
487: x_return_status := FND_API.g_ret_sts_error;
488: FND_MSG_PUB.count_and_get(
489: p_encoded => FND_API.g_false,
490: p_count => x_msg_count,
491: p_data => x_msg_data
492: );
493:

Line 494: WHEN FND_API.g_exc_unexpected_error THEN

490: p_count => x_msg_count,
491: p_data => x_msg_data
492: );
493:
494: WHEN FND_API.g_exc_unexpected_error THEN
495: ROLLBACK TO delete_channel;
496: x_return_status := FND_API.g_ret_sts_unexp_error ;
497: FND_MSG_PUB.count_and_get(
498: p_encoded => FND_API.g_false,

Line 496: x_return_status := FND_API.g_ret_sts_unexp_error ;

492: );
493:
494: WHEN FND_API.g_exc_unexpected_error THEN
495: ROLLBACK TO delete_channel;
496: x_return_status := FND_API.g_ret_sts_unexp_error ;
497: FND_MSG_PUB.count_and_get(
498: p_encoded => FND_API.g_false,
499: p_count => x_msg_count,
500: p_data => x_msg_data

Line 498: p_encoded => FND_API.g_false,

494: WHEN FND_API.g_exc_unexpected_error THEN
495: ROLLBACK TO delete_channel;
496: x_return_status := FND_API.g_ret_sts_unexp_error ;
497: FND_MSG_PUB.count_and_get(
498: p_encoded => FND_API.g_false,
499: p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502:

Line 505: x_return_status := FND_API.g_ret_sts_unexp_error ;

501: );
502:
503: WHEN OTHERS THEN
504: ROLLBACK TO delete_channel;
505: x_return_status := FND_API.g_ret_sts_unexp_error ;
506:
507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
508: THEN
509: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 513: p_encoded => FND_API.g_false,

509: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
510: END IF;
511:
512: FND_MSG_PUB.count_and_get(
513: p_encoded => FND_API.g_false,
514: p_count => x_msg_count,
515: p_data => x_msg_data
516: );
517:

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

526: -- 11/23/99 mpande Created.
527: --------------------------------------------------------------------
528: PROCEDURE lock_channel(
529: p_api_version IN NUMBER,
530: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
531:
532: x_return_status OUT NOCOPY VARCHAR2,
533: x_msg_count OUT NOCOPY NUMBER,
534: x_msg_data OUT NOCOPY VARCHAR2,

Line 569: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 573: IF NOT FND_API.compatible_api_call(

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

Line 579: RAISE FND_API.g_exc_unexpected_error;

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

Line 582: x_return_status := FND_API.G_RET_STS_SUCCESS;

578: ) THEN
579: RAISE FND_API.g_exc_unexpected_error;
580: END IF;
581:
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583:
584: ------------------------ lock -------------------------
585: IF (AMS_DEBUG_HIGH_ON) THEN
586:

Line 598: RAISE FND_API.g_exc_error;

594: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
595: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
596: FND_MSG_PUB.add;
597: END IF;
598: RAISE FND_API.g_exc_error;
599: END IF;
600: CLOSE c_chan_b;
601:
602: OPEN c_chan_tl;

Line 607: p_encoded => FND_API.g_false,

603: CLOSE c_chan_tl;
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 677: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

673: -- 01/18/2001 rssharma removed internal_resource attribute
674: ----------------------------------------------------------------------
675: PROCEDURE update_channel(
676: p_api_version IN NUMBER,
677: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
678: p_commit IN VARCHAR2 := FND_API.g_false,
679: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
680:
681: x_return_status OUT NOCOPY VARCHAR2,

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

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

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

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

Line 709: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 713: IF NOT FND_API.compatible_api_call(

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

Line 719: RAISE FND_API.g_exc_unexpected_error;

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

Line 722: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 739: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

735: p_chan_rec => l_chan_rec, -- change from p_chan_rec vmodur
736: p_validation_mode => JTF_PLSQL_API.g_update,
737: x_return_status => l_return_status
738: );
739: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
740: RAISE FND_API.g_exc_unexpected_error;
741: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
742: RAISE FND_API.g_exc_error;
743: END IF;

Line 740: RAISE FND_API.g_exc_unexpected_error;

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

Line 741: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

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

Line 742: RAISE FND_API.g_exc_error;

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

Line 758: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

754: x_return_status => l_return_status
755: );
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: );
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: -- record level

Line 828: RAISE FND_API.g_exc_error;

824: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
825: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
826: FND_MSG_PUB.add;
827: END IF;
828: RAISE FND_API.g_exc_error;
829: END IF;
830:
831: update ams_channels_tl set
832: channel_name = l_chan_rec.channel_name,

Line 846: RAISE FND_API.g_exc_error;

842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
843: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
844: FND_MSG_PUB.add;
845: END IF;
846: RAISE FND_API.g_exc_error;
847: END IF;
848:
849: -------------------- finish --------------------------
850: IF FND_API.to_boolean(p_commit) THEN

Line 850: IF FND_API.to_boolean(p_commit) THEN

846: RAISE FND_API.g_exc_error;
847: END IF;
848:
849: -------------------- finish --------------------------
850: IF FND_API.to_boolean(p_commit) THEN
851: COMMIT;
852: END IF;
853:
854: FND_MSG_PUB.count_and_get(

Line 855: p_encoded => FND_API.g_false,

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

Line 870: WHEN FND_API.g_exc_error THEN

866: END IF;
867:
868: EXCEPTION
869:
870: WHEN FND_API.g_exc_error THEN
871: ROLLBACK TO update_channel;
872: x_return_status := FND_API.g_ret_sts_error;
873: FND_MSG_PUB.count_and_get(
874: p_encoded => FND_API.g_false,

Line 872: x_return_status := FND_API.g_ret_sts_error;

868: EXCEPTION
869:
870: WHEN FND_API.g_exc_error THEN
871: ROLLBACK TO update_channel;
872: x_return_status := FND_API.g_ret_sts_error;
873: FND_MSG_PUB.count_and_get(
874: p_encoded => FND_API.g_false,
875: p_count => x_msg_count,
876: p_data => x_msg_data

Line 874: p_encoded => FND_API.g_false,

870: WHEN FND_API.g_exc_error THEN
871: ROLLBACK TO update_channel;
872: x_return_status := FND_API.g_ret_sts_error;
873: FND_MSG_PUB.count_and_get(
874: p_encoded => FND_API.g_false,
875: p_count => x_msg_count,
876: p_data => x_msg_data
877: );
878:

Line 879: WHEN FND_API.g_exc_unexpected_error THEN

875: p_count => x_msg_count,
876: p_data => x_msg_data
877: );
878:
879: WHEN FND_API.g_exc_unexpected_error THEN
880: ROLLBACK TO update_channel;
881: x_return_status := FND_API.g_ret_sts_unexp_error;
882: FND_MSG_PUB.count_and_get(
883: p_encoded => FND_API.g_false,

Line 881: x_return_status := FND_API.g_ret_sts_unexp_error;

877: );
878:
879: WHEN FND_API.g_exc_unexpected_error THEN
880: ROLLBACK TO update_channel;
881: x_return_status := FND_API.g_ret_sts_unexp_error;
882: FND_MSG_PUB.count_and_get(
883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data

Line 883: p_encoded => FND_API.g_false,

879: WHEN FND_API.g_exc_unexpected_error THEN
880: ROLLBACK TO update_channel;
881: x_return_status := FND_API.g_ret_sts_unexp_error;
882: FND_MSG_PUB.count_and_get(
883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data
886: );
887:

Line 890: x_return_status := FND_API.g_ret_sts_unexp_error;

886: );
887:
888: WHEN OTHERS THEN
889: ROLLBACK TO update_channel;
890: x_return_status := FND_API.g_ret_sts_unexp_error;
891:
892: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
893: THEN
894: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 898: p_encoded => FND_API.g_false,

894: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
895: END IF;
896:
897: FND_MSG_PUB.count_and_get(
898: p_encoded => FND_API.g_false,
899: p_count => x_msg_count,
900: p_data => x_msg_data
901: );
902:

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

913: -- so no validation is done for these columns
914: --------------------------------------------------------------------
915: PROCEDURE validate_channel(
916: p_api_version IN NUMBER,
917: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
918: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
919:
920: x_return_status OUT NOCOPY VARCHAR2,
921: x_msg_count OUT NOCOPY NUMBER,

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

914: --------------------------------------------------------------------
915: PROCEDURE validate_channel(
916: p_api_version IN NUMBER,
917: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
918: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
919:
920: x_return_status OUT NOCOPY VARCHAR2,
921: x_msg_count OUT NOCOPY NUMBER,
922: x_msg_data OUT NOCOPY VARCHAR2,

Line 942: IF FND_API.to_boolean(p_init_msg_list) THEN

938:
939: AMS_Utility_PVT.debug_message(l_full_name||': start');
940: END IF;
941:
942: IF FND_API.to_boolean(p_init_msg_list) THEN
943: FND_MSG_PUB.initialize;
944: END IF;
945:
946: IF NOT FND_API.compatible_api_call(

Line 946: IF NOT FND_API.compatible_api_call(

942: IF FND_API.to_boolean(p_init_msg_list) THEN
943: FND_MSG_PUB.initialize;
944: END IF;
945:
946: IF NOT FND_API.compatible_api_call(
947: l_api_version,
948: p_api_version,
949: l_api_name,
950: g_pkg_name

Line 952: RAISE FND_API.g_exc_unexpected_error;

948: p_api_version,
949: l_api_name,
950: g_pkg_name
951: ) THEN
952: RAISE FND_API.g_exc_unexpected_error;
953: END IF;
954:
955: x_return_status := FND_API.g_ret_sts_success;
956:

Line 955: x_return_status := FND_API.g_ret_sts_success;

951: ) THEN
952: RAISE FND_API.g_exc_unexpected_error;
953: END IF;
954:
955: x_return_status := FND_API.g_ret_sts_success;
956:
957: ---------------------- validate ------------------------
958: IF (AMS_DEBUG_HIGH_ON) THEN
959:

Line 969: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

965: p_chan_rec => p_chan_rec,
966: p_validation_mode => JTF_PLSQL_API.g_create,
967: x_return_status => l_return_status
968: );
969: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
970: RAISE FND_API.g_exc_unexpected_error;
971: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
972: RAISE FND_API.g_exc_error;
973: END IF;

Line 970: RAISE FND_API.g_exc_unexpected_error;

966: p_validation_mode => JTF_PLSQL_API.g_create,
967: x_return_status => l_return_status
968: );
969: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
970: RAISE FND_API.g_exc_unexpected_error;
971: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
972: RAISE FND_API.g_exc_error;
973: END IF;
974: END IF;

Line 971: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

967: x_return_status => l_return_status
968: );
969: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
970: RAISE FND_API.g_exc_unexpected_error;
971: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
972: RAISE FND_API.g_exc_error;
973: END IF;
974: END IF;
975:

Line 972: RAISE FND_API.g_exc_error;

968: );
969: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
970: RAISE FND_API.g_exc_unexpected_error;
971: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
972: RAISE FND_API.g_exc_error;
973: END IF;
974: END IF;
975:
976: --=============================================================================

Line 990: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

986: p_complete_rec => null,
987: x_return_status => l_return_status
988: );
989:
990: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
991: RAISE FND_API.g_exc_unexpected_error;
992: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
993: RAISE FND_API.g_exc_error;
994: END IF;

Line 991: RAISE FND_API.g_exc_unexpected_error;

987: x_return_status => l_return_status
988: );
989:
990: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
991: RAISE FND_API.g_exc_unexpected_error;
992: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
993: RAISE FND_API.g_exc_error;
994: END IF;
995: END IF;

Line 992: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

988: );
989:
990: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
991: RAISE FND_API.g_exc_unexpected_error;
992: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
993: RAISE FND_API.g_exc_error;
994: END IF;
995: END IF;
996:

Line 993: RAISE FND_API.g_exc_error;

989:
990: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
991: RAISE FND_API.g_exc_unexpected_error;
992: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
993: RAISE FND_API.g_exc_error;
994: END IF;
995: END IF;
996:
997: -------------------- finish --------------------------

Line 999: p_encoded => FND_API.g_false,

995: END IF;
996:
997: -------------------- finish --------------------------
998: FND_MSG_PUB.count_and_get(
999: p_encoded => FND_API.g_false,
1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );
1003:

Line 1014: WHEN FND_API.g_exc_error THEN

1010: END IF;
1011:
1012: EXCEPTION
1013:
1014: WHEN FND_API.g_exc_error THEN
1015: x_return_status := FND_API.g_ret_sts_error;
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false,
1018: p_count => x_msg_count,

Line 1015: x_return_status := FND_API.g_ret_sts_error;

1011:
1012: EXCEPTION
1013:
1014: WHEN FND_API.g_exc_error THEN
1015: x_return_status := FND_API.g_ret_sts_error;
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data

Line 1017: p_encoded => FND_API.g_false,

1013:
1014: WHEN FND_API.g_exc_error THEN
1015: x_return_status := FND_API.g_ret_sts_error;
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );
1021:

Line 1022: WHEN FND_API.g_exc_unexpected_error THEN

1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );
1021:
1022: WHEN FND_API.g_exc_unexpected_error THEN
1023: x_return_status := FND_API.g_ret_sts_unexp_error ;
1024: FND_MSG_PUB.count_and_get(
1025: p_encoded => FND_API.g_false,
1026: p_count => x_msg_count,

Line 1023: x_return_status := FND_API.g_ret_sts_unexp_error ;

1019: p_data => x_msg_data
1020: );
1021:
1022: WHEN FND_API.g_exc_unexpected_error THEN
1023: x_return_status := FND_API.g_ret_sts_unexp_error ;
1024: FND_MSG_PUB.count_and_get(
1025: p_encoded => FND_API.g_false,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data

Line 1025: p_encoded => FND_API.g_false,

1021:
1022: WHEN FND_API.g_exc_unexpected_error THEN
1023: x_return_status := FND_API.g_ret_sts_unexp_error ;
1024: FND_MSG_PUB.count_and_get(
1025: p_encoded => FND_API.g_false,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1028: );
1029:

Line 1031: x_return_status := FND_API.g_ret_sts_unexp_error;

1027: p_data => x_msg_data
1028: );
1029:
1030: WHEN OTHERS THEN
1031: x_return_status := FND_API.g_ret_sts_unexp_error;
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1033: THEN
1034: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1035: END IF;

Line 1038: p_encoded => FND_API.g_false,

1034: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1035: END IF;
1036:
1037: FND_MSG_PUB.count_and_get(
1038: p_encoded => FND_API.g_false,
1039: p_count => x_msg_count,
1040: p_data => x_msg_data
1041: );
1042:

Line 1063: x_return_status := FND_API.g_ret_sts_success;

1059: )
1060: IS
1061: BEGIN
1062:
1063: x_return_status := FND_API.g_ret_sts_success;
1064: ------------------------ channel_type --------------------------
1065: IF p_chan_rec.channel_type_code IS NULL THEN
1066: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1067: THEN

Line 1071: x_return_status := FND_API.g_ret_sts_error;

1067: THEN
1068: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_INVALID_TYPE_CODE');
1069: FND_MSG_PUB.add;
1070: END IF;
1071: x_return_status := FND_API.g_ret_sts_error;
1072: RETURN;
1073: END IF;
1074:
1075: ------------------------ channel_name --------------------------

Line 1082: x_return_status := FND_API.g_ret_sts_error;

1078: THEN
1079: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_NO_NAME');
1080: FND_MSG_PUB.add;
1081: END IF;
1082: x_return_status := FND_API.g_ret_sts_error;
1083: RETURN;
1084: END IF;
1085:
1086: -- Added by rrajesh on 12/07/00

Line 1094: x_return_status := FND_API.g_ret_sts_error;

1090: THEN
1091: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_INVALID_COUNTRY_ID');
1092: FND_MSG_PUB.add;
1093: END IF;
1094: x_return_status := FND_API.g_ret_sts_error;
1095: RETURN;
1096: END IF;
1097: -- end rrajesh 12/07/00
1098:

Line 1107: x_return_status := FND_API.g_ret_sts_error;

1103: THEN
1104: FND_MESSAGE.set_name('AMS', 'AMS_MED_CFD_IS_NULL');
1105: FND_MSG_PUB.add;
1106: END IF;
1107: x_return_status := FND_API.g_ret_sts_error;
1108: RETURN;
1109: END IF;
1110: -- end vmodur
1111:

Line 1159: x_return_status := FND_API.g_ret_sts_success;

1155: --end 12/07/00
1156: -- end rrajesh 11/08
1157:
1158: BEGIN
1159: x_return_status := FND_API.g_ret_sts_success;
1160: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Check the uniqueness Count - begin'); END IF;
1161: -- For create_channel, when channel_id is passed in, we need to
1162: -- check if this channel_id is unique.
1163: IF p_validation_mode = JTF_PLSQL_API.g_create

Line 1169: ) = FND_API.g_false

1165: THEN
1166: IF AMS_Utility_PVT.check_uniqueness(
1167: 'ams_channels_vl',
1168: 'channel_id = ' || p_chan_rec.channel_id
1169: ) = FND_API.g_false
1170: THEN
1171: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1172: THEN
1173: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_ID');

Line 1176: x_return_status := FND_API.g_ret_sts_error;

1172: THEN
1173: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_ID');
1174: FND_MSG_PUB.add;
1175: END IF;
1176: x_return_status := FND_API.g_ret_sts_error;
1177: RETURN;
1178: END IF;
1179: END IF;
1180:

Line 1218: --IF l_valid_flag = FND_API.g_false THEN

1214: -- rrajesh start 11/08. Checking the uniqueness against the new cursor,
1215: -- c_name_unique_up
1216: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message('Check the uniqueness Count '|| l_count ); END IF;
1217: IF l_count > 0 THEN
1218: --IF l_valid_flag = FND_API.g_false THEN
1219: -- rrajesh end 11/08
1220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1221: THEN
1222: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_NAME');

Line 1225: x_return_status := FND_API.g_ret_sts_error;

1221: THEN
1222: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_DUPLICATE_NAME');
1223: FND_MSG_PUB.add;
1224: END IF;
1225: x_return_status := FND_API.g_ret_sts_error;
1226: RETURN;
1227: END IF;
1228:
1229: END check_chan_uk_items;

Line 1248: x_return_status := FND_API.g_ret_sts_success;

1244: )
1245: IS
1246: BEGIN
1247:
1248: x_return_status := FND_API.g_ret_sts_success;
1249:
1250: ----------------------- managed_by_person_id ------------------------
1251: IF p_chan_rec.managed_by_person_id <> FND_API.g_miss_num THEN
1252: IF AMS_Utility_PVT.check_fk_exists(

Line 1251: IF p_chan_rec.managed_by_person_id <> FND_API.g_miss_num THEN

1247:
1248: x_return_status := FND_API.g_ret_sts_success;
1249:
1250: ----------------------- managed_by_person_id ------------------------
1251: IF p_chan_rec.managed_by_person_id <> FND_API.g_miss_num THEN
1252: IF AMS_Utility_PVT.check_fk_exists(
1253: 'ams_jtf_rs_emp_v',
1254: 'resource_id',
1255: p_chan_rec.managed_by_person_id

Line 1256: ) = FND_API.g_false

1252: IF AMS_Utility_PVT.check_fk_exists(
1253: 'ams_jtf_rs_emp_v',
1254: 'resource_id',
1255: p_chan_rec.managed_by_person_id
1256: ) = FND_API.g_false
1257: THEN
1258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1259: THEN
1260: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_BAD_MANAGED_BY_ID');

Line 1263: x_return_status := FND_API.g_ret_sts_error;

1259: THEN
1260: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_BAD_MANAGED_BY_ID');
1261: FND_MSG_PUB.add;
1262: END IF;
1263: x_return_status := FND_API.g_ret_sts_error;
1264: RETURN;
1265: END IF;
1266: END IF;
1267:

Line 1269: IF p_chan_rec.preferred_vendor_id <> FND_API.g_miss_num THEN

1265: END IF;
1266: END IF;
1267:
1268: --------------------- preferred_vendor_id ------------------------
1269: IF p_chan_rec.preferred_vendor_id <> FND_API.g_miss_num THEN
1270: IF AMS_Utility_PVT.check_fk_exists(
1271: 'po_vendors',
1272: 'vendor_id',
1273: p_chan_rec.preferred_vendor_id

Line 1274: ) = FND_API.g_false

1270: IF AMS_Utility_PVT.check_fk_exists(
1271: 'po_vendors',
1272: 'vendor_id',
1273: p_chan_rec.preferred_vendor_id
1274: ) = FND_API.g_false
1275: THEN
1276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1277: THEN
1278: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_VENDOR_ID');

Line 1281: x_return_status := FND_API.g_ret_sts_error;

1277: THEN
1278: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_VENDOR_ID');
1279: FND_MSG_PUB.add;
1280: END IF;
1281: x_return_status := FND_API.g_ret_sts_error;
1282: RETURN;
1283: END IF;
1284: END IF;
1285: --------------------- party_id ------------------------

Line 1286: IF p_chan_rec.party_id <> FND_API.g_miss_num THEN

1282: RETURN;
1283: END IF;
1284: END IF;
1285: --------------------- party_id ------------------------
1286: IF p_chan_rec.party_id <> FND_API.g_miss_num THEN
1287: IF AMS_Utility_PVT.check_fk_exists(
1288: 'HZ_PARTIES',
1289: 'party_id',
1290: p_chan_rec.party_id

Line 1291: ) = FND_API.g_false

1287: IF AMS_Utility_PVT.check_fk_exists(
1288: 'HZ_PARTIES',
1289: 'party_id',
1290: p_chan_rec.party_id
1291: ) = FND_API.g_false
1292: THEN
1293: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1294: THEN
1295: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_PARTY_ID');

Line 1298: x_return_status := FND_API.g_ret_sts_error;

1294: THEN
1295: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_PARTY_ID');
1296: FND_MSG_PUB.add;
1297: END IF;
1298: x_return_status := FND_API.g_ret_sts_error;
1299: RETURN;
1300: END IF;
1301: END IF;
1302:

Line 1305: IF p_chan_rec.country_id <> FND_API.g_miss_num THEN

1301: END IF;
1302:
1303: --Added by rrajesh on 12/07/00
1304: --------------------- country_id ------------------------
1305: IF p_chan_rec.country_id <> FND_API.g_miss_num THEN
1306:
1307: -- modified by soagrawa on 31-May-2001
1308: IF AMS_Utility_PVT.check_fk_exists(
1309: p_table_name => 'jtf_loc_hierarchies_vl', --'jtf_loc_areas_vl',

Line 1315: ) = FND_API.g_false

1311: p_pk_value => p_chan_rec.country_id,
1312: p_pk_data_type => AMS_Utility_PVT.G_NUMBER,
1313: -- modified by soagrawa on 28-sep-2001, bug# 2021940
1314: p_additional_where_clause => ' location_type_code = ''COUNTRY'' ' --' location_type_name = ''Country'' '
1315: ) = FND_API.g_false
1316: THEN
1317: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1318: THEN
1319: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_COUNTRY_ID');

Line 1322: x_return_status := FND_API.g_ret_sts_error;

1318: THEN
1319: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_COUNTRY_ID');
1320: FND_MSG_PUB.add;
1321: END IF;
1322: x_return_status := FND_API.g_ret_sts_error;
1323: RETURN;
1324: END IF;
1325: END IF;
1326:

Line 1346: x_return_status := FND_API.g_ret_sts_success;

1342: )
1343: IS
1344: BEGIN
1345:
1346: x_return_status := FND_API.g_ret_sts_success;
1347:
1348: ----------------------- channel_type_code ------------------------
1349: IF p_chan_rec.channel_type_code <> FND_API.g_miss_char THEN
1350: IF AMS_Utility_PVT.check_lookup_exists(

Line 1349: IF p_chan_rec.channel_type_code <> FND_API.g_miss_char THEN

1345:
1346: x_return_status := FND_API.g_ret_sts_success;
1347:
1348: ----------------------- channel_type_code ------------------------
1349: IF p_chan_rec.channel_type_code <> FND_API.g_miss_char THEN
1350: IF AMS_Utility_PVT.check_lookup_exists(
1351: p_lookup_type => 'AMS_CHANNEL_TYPE',
1352: p_lookup_code => p_chan_rec.channel_type_code
1353: ) = FND_API.g_false

Line 1353: ) = FND_API.g_false

1349: IF p_chan_rec.channel_type_code <> FND_API.g_miss_char THEN
1350: IF AMS_Utility_PVT.check_lookup_exists(
1351: p_lookup_type => 'AMS_CHANNEL_TYPE',
1352: p_lookup_code => p_chan_rec.channel_type_code
1353: ) = FND_API.g_false
1354: THEN
1355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1356: THEN
1357: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_WRONG_CHANNEL_TYPE');

Line 1360: x_return_status := FND_API.g_ret_sts_error;

1356: THEN
1357: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_WRONG_CHANNEL_TYPE');
1358: FND_MSG_PUB.add;
1359: END IF;
1360: x_return_status := FND_API.g_ret_sts_error;
1361: RETURN;
1362: END IF;
1363: END IF;
1364:

Line 1366: IF p_chan_rec.rating <> FND_API.g_miss_char

1362: END IF;
1363: END IF;
1364:
1365: ----------------------- rating ------------------------
1366: IF p_chan_rec.rating <> FND_API.g_miss_char
1367: AND p_chan_rec.rating IS NOT NULL
1368: THEN
1369: IF AMS_Utility_PVT.check_lookup_exists(
1370: p_lookup_type => 'AMS_CHANNEL_RATING',

Line 1372: ) = FND_API.g_false

1368: THEN
1369: IF AMS_Utility_PVT.check_lookup_exists(
1370: p_lookup_type => 'AMS_CHANNEL_RATING',
1371: p_lookup_code => p_chan_rec.rating
1372: ) = FND_API.g_false
1373: THEN
1374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1375: THEN
1376: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_RATING_VALUE');

Line 1379: x_return_status := FND_API.g_ret_sts_error;

1375: THEN
1376: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_RATING_VALUE');
1377: FND_MSG_PUB.add;
1378: END IF;
1379: x_return_status := FND_API.g_ret_sts_error;
1380: RETURN;
1381: END IF;
1382: END IF;
1383:

Line 1404: x_return_status := FND_API.g_ret_sts_success;

1400: )
1401: IS
1402: BEGIN
1403:
1404: x_return_status := FND_API.g_ret_sts_success;
1405:
1406: ----------------------- outbound_flag ------------------------
1407: IF p_chan_rec.outbound_flag <> FND_API.g_miss_char
1408: AND p_chan_rec.outbound_flag IS NOT NULL

Line 1407: IF p_chan_rec.outbound_flag <> FND_API.g_miss_char

1403:
1404: x_return_status := FND_API.g_ret_sts_success;
1405:
1406: ----------------------- outbound_flag ------------------------
1407: IF p_chan_rec.outbound_flag <> FND_API.g_miss_char
1408: AND p_chan_rec.outbound_flag IS NOT NULL
1409: THEN
1410: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.outbound_flag) = FND_API.g_false
1411: THEN

Line 1410: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.outbound_flag) = FND_API.g_false

1406: ----------------------- outbound_flag ------------------------
1407: IF p_chan_rec.outbound_flag <> FND_API.g_miss_char
1408: AND p_chan_rec.outbound_flag IS NOT NULL
1409: THEN
1410: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.outbound_flag) = FND_API.g_false
1411: THEN
1412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1413: THEN
1414: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_OUTBOUND_FLAG');

Line 1417: x_return_status := FND_API.g_ret_sts_error;

1413: THEN
1414: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_OUTBOUND_FLAG');
1415: FND_MSG_PUB.add;
1416: END IF;
1417: x_return_status := FND_API.g_ret_sts_error;
1418: RETURN;
1419: END IF;
1420: END IF;
1421:

Line 1423: IF p_chan_rec.inbound_flag <> FND_API.g_miss_char

1419: END IF;
1420: END IF;
1421:
1422: ----------------------- inbound_flag ------------------------
1423: IF p_chan_rec.inbound_flag <> FND_API.g_miss_char
1424: AND p_chan_rec.inbound_flag IS NOT NULL
1425: THEN
1426: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.inbound_flag) = FND_API.g_false
1427: THEN

Line 1426: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.inbound_flag) = FND_API.g_false

1422: ----------------------- inbound_flag ------------------------
1423: IF p_chan_rec.inbound_flag <> FND_API.g_miss_char
1424: AND p_chan_rec.inbound_flag IS NOT NULL
1425: THEN
1426: IF AMS_Utility_PVT.is_Y_or_N(p_chan_rec.inbound_flag) = FND_API.g_false
1427: THEN
1428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1429: THEN
1430: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_INBOUND_FLAG');

Line 1433: x_return_status := FND_API.g_ret_sts_error;

1429: THEN
1430: FND_MESSAGE.set_name('AMS', 'AMS_CHAN_WRONG_INBOUND_FLAG');
1431: FND_MSG_PUB.add;
1432: END IF;
1433: x_return_status := FND_API.g_ret_sts_error;
1434: RETURN;
1435: END IF;
1436: END IF;
1437:

Line 1466: IF x_return_status <> FND_API.g_ret_sts_success THEN

1462: p_chan_rec => p_chan_rec,
1463: x_return_status => x_return_status
1464: );
1465:
1466: IF x_return_status <> FND_API.g_ret_sts_success THEN
1467: RETURN;
1468: END IF;
1469:
1470: check_chan_uk_items(

Line 1476: IF x_return_status <> FND_API.g_ret_sts_success THEN

1472: p_validation_mode => p_validation_mode,
1473: x_return_status => x_return_status
1474: );
1475:
1476: IF x_return_status <> FND_API.g_ret_sts_success THEN
1477: RETURN;
1478: END IF;
1479:
1480: check_chan_fk_items(

Line 1485: IF x_return_status <> FND_API.g_ret_sts_success THEN

1481: p_chan_rec => p_chan_rec,
1482: x_return_status => x_return_status
1483: );
1484:
1485: IF x_return_status <> FND_API.g_ret_sts_success THEN
1486: RETURN;
1487: END IF;
1488:
1489: check_chan_lookup_items(

Line 1494: IF x_return_status <> FND_API.g_ret_sts_success THEN

1490: p_chan_rec => p_chan_rec,
1491: x_return_status => x_return_status
1492: );
1493:
1494: IF x_return_status <> FND_API.g_ret_sts_success THEN
1495: RETURN;
1496: END IF;
1497:
1498: --commented OUT NOCOPY by rrajesh on 12/07/00

Line 1505: IF x_return_status <> FND_API.g_ret_sts_success THEN

1501: -- x_return_status => x_return_status
1502: --);
1503: -- end 12/07/00
1504:
1505: IF x_return_status <> FND_API.g_ret_sts_success THEN
1506: RETURN;
1507: END IF;
1508:
1509: END check_chan_items;

Line 1539: x_return_status := FND_API.g_ret_sts_success;

1535: BEGIN
1536: --
1537: -- Initialize the Out Variable
1538: --
1539: x_return_status := FND_API.g_ret_sts_success;
1540:
1541: -- Check start date time
1542: IF (p_chan_rec.active_from_date IS NOT NULL AND
1543: p_chan_rec.active_from_date <> FND_API.G_MISS_DATE) OR

Line 1543: p_chan_rec.active_from_date <> FND_API.G_MISS_DATE) OR

1539: x_return_status := FND_API.g_ret_sts_success;
1540:
1541: -- Check start date time
1542: IF (p_chan_rec.active_from_date IS NOT NULL AND
1543: p_chan_rec.active_from_date <> FND_API.G_MISS_DATE) OR
1544: (p_chan_rec.active_to_date IS NOT NULL AND
1545: p_chan_rec.active_to_date <> FND_API.G_MISS_DATE)
1546: THEN
1547: IF p_chan_rec.active_from_date = FND_API.G_MISS_DATE THEN

Line 1545: p_chan_rec.active_to_date <> FND_API.G_MISS_DATE)

1541: -- Check start date time
1542: IF (p_chan_rec.active_from_date IS NOT NULL AND
1543: p_chan_rec.active_from_date <> FND_API.G_MISS_DATE) OR
1544: (p_chan_rec.active_to_date IS NOT NULL AND
1545: p_chan_rec.active_to_date <> FND_API.G_MISS_DATE)
1546: THEN
1547: IF p_chan_rec.active_from_date = FND_API.G_MISS_DATE THEN
1548: l_start_date := p_complete_rec.active_from_date;
1549: ELSE

Line 1547: IF p_chan_rec.active_from_date = FND_API.G_MISS_DATE THEN

1543: p_chan_rec.active_from_date <> FND_API.G_MISS_DATE) OR
1544: (p_chan_rec.active_to_date IS NOT NULL AND
1545: p_chan_rec.active_to_date <> FND_API.G_MISS_DATE)
1546: THEN
1547: IF p_chan_rec.active_from_date = FND_API.G_MISS_DATE THEN
1548: l_start_date := p_complete_rec.active_from_date;
1549: ELSE
1550: l_start_date := p_chan_rec.active_from_date;
1551: END IF ;

Line 1553: IF p_chan_rec.active_to_date = FND_API.G_MISS_DATE THEN

1549: ELSE
1550: l_start_date := p_chan_rec.active_from_date;
1551: END IF ;
1552:
1553: IF p_chan_rec.active_to_date = FND_API.G_MISS_DATE THEN
1554: l_end_date := p_complete_rec.active_to_date;
1555: ELSE
1556: l_end_date := p_chan_rec.active_to_date;
1557: END IF ;

Line 1571: x_return_status := FND_API.G_RET_STS_ERROR;

1567: FND_MESSAGE.Set_Name('AMS', 'AMS_MED_FROMDT_GTR_TODT');
1568: -- FND_MESSAGE.Set_Name('AMS', 'AMS_TRIG_INVALID_DT_RANGE');
1569: FND_MSG_PUB.Add;
1570: END IF;
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: -- If any errors happen abort API/Procedure.
1573: RETURN;
1574: END IF;
1575:

Line 1599: x_chan_rec.channel_id := FND_API.g_miss_num;

1595: )
1596: IS
1597: BEGIN
1598:
1599: x_chan_rec.channel_id := FND_API.g_miss_num;
1600: x_chan_rec.last_update_date := FND_API.g_miss_date;
1601: x_chan_rec.last_updated_by := FND_API.g_miss_num;
1602: x_chan_rec.creation_date := FND_API.g_miss_date;
1603: x_chan_rec.created_by := FND_API.g_miss_num;

Line 1600: x_chan_rec.last_update_date := FND_API.g_miss_date;

1596: IS
1597: BEGIN
1598:
1599: x_chan_rec.channel_id := FND_API.g_miss_num;
1600: x_chan_rec.last_update_date := FND_API.g_miss_date;
1601: x_chan_rec.last_updated_by := FND_API.g_miss_num;
1602: x_chan_rec.creation_date := FND_API.g_miss_date;
1603: x_chan_rec.created_by := FND_API.g_miss_num;
1604: x_chan_rec.last_update_login := FND_API.g_miss_num;

Line 1601: x_chan_rec.last_updated_by := FND_API.g_miss_num;

1597: BEGIN
1598:
1599: x_chan_rec.channel_id := FND_API.g_miss_num;
1600: x_chan_rec.last_update_date := FND_API.g_miss_date;
1601: x_chan_rec.last_updated_by := FND_API.g_miss_num;
1602: x_chan_rec.creation_date := FND_API.g_miss_date;
1603: x_chan_rec.created_by := FND_API.g_miss_num;
1604: x_chan_rec.last_update_login := FND_API.g_miss_num;
1605: x_chan_rec.object_version_number := FND_API.g_miss_num;

Line 1602: x_chan_rec.creation_date := FND_API.g_miss_date;

1598:
1599: x_chan_rec.channel_id := FND_API.g_miss_num;
1600: x_chan_rec.last_update_date := FND_API.g_miss_date;
1601: x_chan_rec.last_updated_by := FND_API.g_miss_num;
1602: x_chan_rec.creation_date := FND_API.g_miss_date;
1603: x_chan_rec.created_by := FND_API.g_miss_num;
1604: x_chan_rec.last_update_login := FND_API.g_miss_num;
1605: x_chan_rec.object_version_number := FND_API.g_miss_num;
1606: x_chan_rec.managed_by_person_id := FND_API.g_miss_num;

Line 1603: x_chan_rec.created_by := FND_API.g_miss_num;

1599: x_chan_rec.channel_id := FND_API.g_miss_num;
1600: x_chan_rec.last_update_date := FND_API.g_miss_date;
1601: x_chan_rec.last_updated_by := FND_API.g_miss_num;
1602: x_chan_rec.creation_date := FND_API.g_miss_date;
1603: x_chan_rec.created_by := FND_API.g_miss_num;
1604: x_chan_rec.last_update_login := FND_API.g_miss_num;
1605: x_chan_rec.object_version_number := FND_API.g_miss_num;
1606: x_chan_rec.managed_by_person_id := FND_API.g_miss_num;
1607: x_chan_rec.preferred_vendor_id := FND_API.g_miss_num;

Line 1604: x_chan_rec.last_update_login := FND_API.g_miss_num;

1600: x_chan_rec.last_update_date := FND_API.g_miss_date;
1601: x_chan_rec.last_updated_by := FND_API.g_miss_num;
1602: x_chan_rec.creation_date := FND_API.g_miss_date;
1603: x_chan_rec.created_by := FND_API.g_miss_num;
1604: x_chan_rec.last_update_login := FND_API.g_miss_num;
1605: x_chan_rec.object_version_number := FND_API.g_miss_num;
1606: x_chan_rec.managed_by_person_id := FND_API.g_miss_num;
1607: x_chan_rec.preferred_vendor_id := FND_API.g_miss_num;
1608: x_chan_rec.party_id := FND_API.g_miss_num;

Line 1605: x_chan_rec.object_version_number := FND_API.g_miss_num;

1601: x_chan_rec.last_updated_by := FND_API.g_miss_num;
1602: x_chan_rec.creation_date := FND_API.g_miss_date;
1603: x_chan_rec.created_by := FND_API.g_miss_num;
1604: x_chan_rec.last_update_login := FND_API.g_miss_num;
1605: x_chan_rec.object_version_number := FND_API.g_miss_num;
1606: x_chan_rec.managed_by_person_id := FND_API.g_miss_num;
1607: x_chan_rec.preferred_vendor_id := FND_API.g_miss_num;
1608: x_chan_rec.party_id := FND_API.g_miss_num;
1609: x_chan_rec.channel_type_code := FND_API.g_miss_char;

Line 1606: x_chan_rec.managed_by_person_id := FND_API.g_miss_num;

1602: x_chan_rec.creation_date := FND_API.g_miss_date;
1603: x_chan_rec.created_by := FND_API.g_miss_num;
1604: x_chan_rec.last_update_login := FND_API.g_miss_num;
1605: x_chan_rec.object_version_number := FND_API.g_miss_num;
1606: x_chan_rec.managed_by_person_id := FND_API.g_miss_num;
1607: x_chan_rec.preferred_vendor_id := FND_API.g_miss_num;
1608: x_chan_rec.party_id := FND_API.g_miss_num;
1609: x_chan_rec.channel_type_code := FND_API.g_miss_char;
1610: x_chan_rec.active_from_date := FND_API.g_miss_date;

Line 1607: x_chan_rec.preferred_vendor_id := FND_API.g_miss_num;

1603: x_chan_rec.created_by := FND_API.g_miss_num;
1604: x_chan_rec.last_update_login := FND_API.g_miss_num;
1605: x_chan_rec.object_version_number := FND_API.g_miss_num;
1606: x_chan_rec.managed_by_person_id := FND_API.g_miss_num;
1607: x_chan_rec.preferred_vendor_id := FND_API.g_miss_num;
1608: x_chan_rec.party_id := FND_API.g_miss_num;
1609: x_chan_rec.channel_type_code := FND_API.g_miss_char;
1610: x_chan_rec.active_from_date := FND_API.g_miss_date;
1611: x_chan_rec.active_to_date := FND_API.g_miss_date;

Line 1608: x_chan_rec.party_id := FND_API.g_miss_num;

1604: x_chan_rec.last_update_login := FND_API.g_miss_num;
1605: x_chan_rec.object_version_number := FND_API.g_miss_num;
1606: x_chan_rec.managed_by_person_id := FND_API.g_miss_num;
1607: x_chan_rec.preferred_vendor_id := FND_API.g_miss_num;
1608: x_chan_rec.party_id := FND_API.g_miss_num;
1609: x_chan_rec.channel_type_code := FND_API.g_miss_char;
1610: x_chan_rec.active_from_date := FND_API.g_miss_date;
1611: x_chan_rec.active_to_date := FND_API.g_miss_date;
1612: x_chan_rec.order_sequence := FND_API.g_miss_num;

Line 1609: x_chan_rec.channel_type_code := FND_API.g_miss_char;

1605: x_chan_rec.object_version_number := FND_API.g_miss_num;
1606: x_chan_rec.managed_by_person_id := FND_API.g_miss_num;
1607: x_chan_rec.preferred_vendor_id := FND_API.g_miss_num;
1608: x_chan_rec.party_id := FND_API.g_miss_num;
1609: x_chan_rec.channel_type_code := FND_API.g_miss_char;
1610: x_chan_rec.active_from_date := FND_API.g_miss_date;
1611: x_chan_rec.active_to_date := FND_API.g_miss_date;
1612: x_chan_rec.order_sequence := FND_API.g_miss_num;
1613: x_chan_rec.outbound_flag := FND_API.g_miss_char;

Line 1610: x_chan_rec.active_from_date := FND_API.g_miss_date;

1606: x_chan_rec.managed_by_person_id := FND_API.g_miss_num;
1607: x_chan_rec.preferred_vendor_id := FND_API.g_miss_num;
1608: x_chan_rec.party_id := FND_API.g_miss_num;
1609: x_chan_rec.channel_type_code := FND_API.g_miss_char;
1610: x_chan_rec.active_from_date := FND_API.g_miss_date;
1611: x_chan_rec.active_to_date := FND_API.g_miss_date;
1612: x_chan_rec.order_sequence := FND_API.g_miss_num;
1613: x_chan_rec.outbound_flag := FND_API.g_miss_char;
1614: x_chan_rec.inbound_flag := FND_API.g_miss_char;

Line 1611: x_chan_rec.active_to_date := FND_API.g_miss_date;

1607: x_chan_rec.preferred_vendor_id := FND_API.g_miss_num;
1608: x_chan_rec.party_id := FND_API.g_miss_num;
1609: x_chan_rec.channel_type_code := FND_API.g_miss_char;
1610: x_chan_rec.active_from_date := FND_API.g_miss_date;
1611: x_chan_rec.active_to_date := FND_API.g_miss_date;
1612: x_chan_rec.order_sequence := FND_API.g_miss_num;
1613: x_chan_rec.outbound_flag := FND_API.g_miss_char;
1614: x_chan_rec.inbound_flag := FND_API.g_miss_char;
1615: x_chan_rec.rating := FND_API.g_miss_char;

Line 1612: x_chan_rec.order_sequence := FND_API.g_miss_num;

1608: x_chan_rec.party_id := FND_API.g_miss_num;
1609: x_chan_rec.channel_type_code := FND_API.g_miss_char;
1610: x_chan_rec.active_from_date := FND_API.g_miss_date;
1611: x_chan_rec.active_to_date := FND_API.g_miss_date;
1612: x_chan_rec.order_sequence := FND_API.g_miss_num;
1613: x_chan_rec.outbound_flag := FND_API.g_miss_char;
1614: x_chan_rec.inbound_flag := FND_API.g_miss_char;
1615: x_chan_rec.rating := FND_API.g_miss_char;
1616: x_chan_rec.attribute_category := FND_API.g_miss_char;

Line 1613: x_chan_rec.outbound_flag := FND_API.g_miss_char;

1609: x_chan_rec.channel_type_code := FND_API.g_miss_char;
1610: x_chan_rec.active_from_date := FND_API.g_miss_date;
1611: x_chan_rec.active_to_date := FND_API.g_miss_date;
1612: x_chan_rec.order_sequence := FND_API.g_miss_num;
1613: x_chan_rec.outbound_flag := FND_API.g_miss_char;
1614: x_chan_rec.inbound_flag := FND_API.g_miss_char;
1615: x_chan_rec.rating := FND_API.g_miss_char;
1616: x_chan_rec.attribute_category := FND_API.g_miss_char;
1617: x_chan_rec.attribute1 := FND_API.g_miss_char;

Line 1614: x_chan_rec.inbound_flag := FND_API.g_miss_char;

1610: x_chan_rec.active_from_date := FND_API.g_miss_date;
1611: x_chan_rec.active_to_date := FND_API.g_miss_date;
1612: x_chan_rec.order_sequence := FND_API.g_miss_num;
1613: x_chan_rec.outbound_flag := FND_API.g_miss_char;
1614: x_chan_rec.inbound_flag := FND_API.g_miss_char;
1615: x_chan_rec.rating := FND_API.g_miss_char;
1616: x_chan_rec.attribute_category := FND_API.g_miss_char;
1617: x_chan_rec.attribute1 := FND_API.g_miss_char;
1618: x_chan_rec.attribute2 := FND_API.g_miss_char;

Line 1615: x_chan_rec.rating := FND_API.g_miss_char;

1611: x_chan_rec.active_to_date := FND_API.g_miss_date;
1612: x_chan_rec.order_sequence := FND_API.g_miss_num;
1613: x_chan_rec.outbound_flag := FND_API.g_miss_char;
1614: x_chan_rec.inbound_flag := FND_API.g_miss_char;
1615: x_chan_rec.rating := FND_API.g_miss_char;
1616: x_chan_rec.attribute_category := FND_API.g_miss_char;
1617: x_chan_rec.attribute1 := FND_API.g_miss_char;
1618: x_chan_rec.attribute2 := FND_API.g_miss_char;
1619: x_chan_rec.attribute3 := FND_API.g_miss_char;

Line 1616: x_chan_rec.attribute_category := FND_API.g_miss_char;

1612: x_chan_rec.order_sequence := FND_API.g_miss_num;
1613: x_chan_rec.outbound_flag := FND_API.g_miss_char;
1614: x_chan_rec.inbound_flag := FND_API.g_miss_char;
1615: x_chan_rec.rating := FND_API.g_miss_char;
1616: x_chan_rec.attribute_category := FND_API.g_miss_char;
1617: x_chan_rec.attribute1 := FND_API.g_miss_char;
1618: x_chan_rec.attribute2 := FND_API.g_miss_char;
1619: x_chan_rec.attribute3 := FND_API.g_miss_char;
1620: x_chan_rec.attribute4 := FND_API.g_miss_char;

Line 1617: x_chan_rec.attribute1 := FND_API.g_miss_char;

1613: x_chan_rec.outbound_flag := FND_API.g_miss_char;
1614: x_chan_rec.inbound_flag := FND_API.g_miss_char;
1615: x_chan_rec.rating := FND_API.g_miss_char;
1616: x_chan_rec.attribute_category := FND_API.g_miss_char;
1617: x_chan_rec.attribute1 := FND_API.g_miss_char;
1618: x_chan_rec.attribute2 := FND_API.g_miss_char;
1619: x_chan_rec.attribute3 := FND_API.g_miss_char;
1620: x_chan_rec.attribute4 := FND_API.g_miss_char;
1621: x_chan_rec.attribute5 := FND_API.g_miss_char;

Line 1618: x_chan_rec.attribute2 := FND_API.g_miss_char;

1614: x_chan_rec.inbound_flag := FND_API.g_miss_char;
1615: x_chan_rec.rating := FND_API.g_miss_char;
1616: x_chan_rec.attribute_category := FND_API.g_miss_char;
1617: x_chan_rec.attribute1 := FND_API.g_miss_char;
1618: x_chan_rec.attribute2 := FND_API.g_miss_char;
1619: x_chan_rec.attribute3 := FND_API.g_miss_char;
1620: x_chan_rec.attribute4 := FND_API.g_miss_char;
1621: x_chan_rec.attribute5 := FND_API.g_miss_char;
1622: x_chan_rec.attribute6 := FND_API.g_miss_char;

Line 1619: x_chan_rec.attribute3 := FND_API.g_miss_char;

1615: x_chan_rec.rating := FND_API.g_miss_char;
1616: x_chan_rec.attribute_category := FND_API.g_miss_char;
1617: x_chan_rec.attribute1 := FND_API.g_miss_char;
1618: x_chan_rec.attribute2 := FND_API.g_miss_char;
1619: x_chan_rec.attribute3 := FND_API.g_miss_char;
1620: x_chan_rec.attribute4 := FND_API.g_miss_char;
1621: x_chan_rec.attribute5 := FND_API.g_miss_char;
1622: x_chan_rec.attribute6 := FND_API.g_miss_char;
1623: x_chan_rec.attribute7 := FND_API.g_miss_char;

Line 1620: x_chan_rec.attribute4 := FND_API.g_miss_char;

1616: x_chan_rec.attribute_category := FND_API.g_miss_char;
1617: x_chan_rec.attribute1 := FND_API.g_miss_char;
1618: x_chan_rec.attribute2 := FND_API.g_miss_char;
1619: x_chan_rec.attribute3 := FND_API.g_miss_char;
1620: x_chan_rec.attribute4 := FND_API.g_miss_char;
1621: x_chan_rec.attribute5 := FND_API.g_miss_char;
1622: x_chan_rec.attribute6 := FND_API.g_miss_char;
1623: x_chan_rec.attribute7 := FND_API.g_miss_char;
1624: x_chan_rec.attribute8 := FND_API.g_miss_char;

Line 1621: x_chan_rec.attribute5 := FND_API.g_miss_char;

1617: x_chan_rec.attribute1 := FND_API.g_miss_char;
1618: x_chan_rec.attribute2 := FND_API.g_miss_char;
1619: x_chan_rec.attribute3 := FND_API.g_miss_char;
1620: x_chan_rec.attribute4 := FND_API.g_miss_char;
1621: x_chan_rec.attribute5 := FND_API.g_miss_char;
1622: x_chan_rec.attribute6 := FND_API.g_miss_char;
1623: x_chan_rec.attribute7 := FND_API.g_miss_char;
1624: x_chan_rec.attribute8 := FND_API.g_miss_char;
1625: x_chan_rec.attribute9 := FND_API.g_miss_char;

Line 1622: x_chan_rec.attribute6 := FND_API.g_miss_char;

1618: x_chan_rec.attribute2 := FND_API.g_miss_char;
1619: x_chan_rec.attribute3 := FND_API.g_miss_char;
1620: x_chan_rec.attribute4 := FND_API.g_miss_char;
1621: x_chan_rec.attribute5 := FND_API.g_miss_char;
1622: x_chan_rec.attribute6 := FND_API.g_miss_char;
1623: x_chan_rec.attribute7 := FND_API.g_miss_char;
1624: x_chan_rec.attribute8 := FND_API.g_miss_char;
1625: x_chan_rec.attribute9 := FND_API.g_miss_char;
1626: x_chan_rec.attribute10 := FND_API.g_miss_char;

Line 1623: x_chan_rec.attribute7 := FND_API.g_miss_char;

1619: x_chan_rec.attribute3 := FND_API.g_miss_char;
1620: x_chan_rec.attribute4 := FND_API.g_miss_char;
1621: x_chan_rec.attribute5 := FND_API.g_miss_char;
1622: x_chan_rec.attribute6 := FND_API.g_miss_char;
1623: x_chan_rec.attribute7 := FND_API.g_miss_char;
1624: x_chan_rec.attribute8 := FND_API.g_miss_char;
1625: x_chan_rec.attribute9 := FND_API.g_miss_char;
1626: x_chan_rec.attribute10 := FND_API.g_miss_char;
1627: x_chan_rec.attribute11 := FND_API.g_miss_char;

Line 1624: x_chan_rec.attribute8 := FND_API.g_miss_char;

1620: x_chan_rec.attribute4 := FND_API.g_miss_char;
1621: x_chan_rec.attribute5 := FND_API.g_miss_char;
1622: x_chan_rec.attribute6 := FND_API.g_miss_char;
1623: x_chan_rec.attribute7 := FND_API.g_miss_char;
1624: x_chan_rec.attribute8 := FND_API.g_miss_char;
1625: x_chan_rec.attribute9 := FND_API.g_miss_char;
1626: x_chan_rec.attribute10 := FND_API.g_miss_char;
1627: x_chan_rec.attribute11 := FND_API.g_miss_char;
1628: x_chan_rec.attribute12 := FND_API.g_miss_char;

Line 1625: x_chan_rec.attribute9 := FND_API.g_miss_char;

1621: x_chan_rec.attribute5 := FND_API.g_miss_char;
1622: x_chan_rec.attribute6 := FND_API.g_miss_char;
1623: x_chan_rec.attribute7 := FND_API.g_miss_char;
1624: x_chan_rec.attribute8 := FND_API.g_miss_char;
1625: x_chan_rec.attribute9 := FND_API.g_miss_char;
1626: x_chan_rec.attribute10 := FND_API.g_miss_char;
1627: x_chan_rec.attribute11 := FND_API.g_miss_char;
1628: x_chan_rec.attribute12 := FND_API.g_miss_char;
1629: x_chan_rec.attribute13 := FND_API.g_miss_char;

Line 1626: x_chan_rec.attribute10 := FND_API.g_miss_char;

1622: x_chan_rec.attribute6 := FND_API.g_miss_char;
1623: x_chan_rec.attribute7 := FND_API.g_miss_char;
1624: x_chan_rec.attribute8 := FND_API.g_miss_char;
1625: x_chan_rec.attribute9 := FND_API.g_miss_char;
1626: x_chan_rec.attribute10 := FND_API.g_miss_char;
1627: x_chan_rec.attribute11 := FND_API.g_miss_char;
1628: x_chan_rec.attribute12 := FND_API.g_miss_char;
1629: x_chan_rec.attribute13 := FND_API.g_miss_char;
1630: x_chan_rec.attribute14 := FND_API.g_miss_char;

Line 1627: x_chan_rec.attribute11 := FND_API.g_miss_char;

1623: x_chan_rec.attribute7 := FND_API.g_miss_char;
1624: x_chan_rec.attribute8 := FND_API.g_miss_char;
1625: x_chan_rec.attribute9 := FND_API.g_miss_char;
1626: x_chan_rec.attribute10 := FND_API.g_miss_char;
1627: x_chan_rec.attribute11 := FND_API.g_miss_char;
1628: x_chan_rec.attribute12 := FND_API.g_miss_char;
1629: x_chan_rec.attribute13 := FND_API.g_miss_char;
1630: x_chan_rec.attribute14 := FND_API.g_miss_char;
1631: x_chan_rec.attribute15 := FND_API.g_miss_char;

Line 1628: x_chan_rec.attribute12 := FND_API.g_miss_char;

1624: x_chan_rec.attribute8 := FND_API.g_miss_char;
1625: x_chan_rec.attribute9 := FND_API.g_miss_char;
1626: x_chan_rec.attribute10 := FND_API.g_miss_char;
1627: x_chan_rec.attribute11 := FND_API.g_miss_char;
1628: x_chan_rec.attribute12 := FND_API.g_miss_char;
1629: x_chan_rec.attribute13 := FND_API.g_miss_char;
1630: x_chan_rec.attribute14 := FND_API.g_miss_char;
1631: x_chan_rec.attribute15 := FND_API.g_miss_char;
1632: x_chan_rec.channel_name := FND_API.g_miss_char;

Line 1629: x_chan_rec.attribute13 := FND_API.g_miss_char;

1625: x_chan_rec.attribute9 := FND_API.g_miss_char;
1626: x_chan_rec.attribute10 := FND_API.g_miss_char;
1627: x_chan_rec.attribute11 := FND_API.g_miss_char;
1628: x_chan_rec.attribute12 := FND_API.g_miss_char;
1629: x_chan_rec.attribute13 := FND_API.g_miss_char;
1630: x_chan_rec.attribute14 := FND_API.g_miss_char;
1631: x_chan_rec.attribute15 := FND_API.g_miss_char;
1632: x_chan_rec.channel_name := FND_API.g_miss_char;
1633: x_chan_rec.description := FND_API.g_miss_char;

Line 1630: x_chan_rec.attribute14 := FND_API.g_miss_char;

1626: x_chan_rec.attribute10 := FND_API.g_miss_char;
1627: x_chan_rec.attribute11 := FND_API.g_miss_char;
1628: x_chan_rec.attribute12 := FND_API.g_miss_char;
1629: x_chan_rec.attribute13 := FND_API.g_miss_char;
1630: x_chan_rec.attribute14 := FND_API.g_miss_char;
1631: x_chan_rec.attribute15 := FND_API.g_miss_char;
1632: x_chan_rec.channel_name := FND_API.g_miss_char;
1633: x_chan_rec.description := FND_API.g_miss_char;
1634: --added by rrajesh on 12/07/00

Line 1631: x_chan_rec.attribute15 := FND_API.g_miss_char;

1627: x_chan_rec.attribute11 := FND_API.g_miss_char;
1628: x_chan_rec.attribute12 := FND_API.g_miss_char;
1629: x_chan_rec.attribute13 := FND_API.g_miss_char;
1630: x_chan_rec.attribute14 := FND_API.g_miss_char;
1631: x_chan_rec.attribute15 := FND_API.g_miss_char;
1632: x_chan_rec.channel_name := FND_API.g_miss_char;
1633: x_chan_rec.description := FND_API.g_miss_char;
1634: --added by rrajesh on 12/07/00
1635: x_chan_rec.country_id := FND_API.g_miss_num;

Line 1632: x_chan_rec.channel_name := FND_API.g_miss_char;

1628: x_chan_rec.attribute12 := FND_API.g_miss_char;
1629: x_chan_rec.attribute13 := FND_API.g_miss_char;
1630: x_chan_rec.attribute14 := FND_API.g_miss_char;
1631: x_chan_rec.attribute15 := FND_API.g_miss_char;
1632: x_chan_rec.channel_name := FND_API.g_miss_char;
1633: x_chan_rec.description := FND_API.g_miss_char;
1634: --added by rrajesh on 12/07/00
1635: x_chan_rec.country_id := FND_API.g_miss_num;
1636: -- removed by Rahul Sharma on 01/18/2001

Line 1633: x_chan_rec.description := FND_API.g_miss_char;

1629: x_chan_rec.attribute13 := FND_API.g_miss_char;
1630: x_chan_rec.attribute14 := FND_API.g_miss_char;
1631: x_chan_rec.attribute15 := FND_API.g_miss_char;
1632: x_chan_rec.channel_name := FND_API.g_miss_char;
1633: x_chan_rec.description := FND_API.g_miss_char;
1634: --added by rrajesh on 12/07/00
1635: x_chan_rec.country_id := FND_API.g_miss_num;
1636: -- removed by Rahul Sharma on 01/18/2001
1637: --x_chan_rec.internal_resource := FND_API.g_miss_char;

Line 1635: x_chan_rec.country_id := FND_API.g_miss_num;

1631: x_chan_rec.attribute15 := FND_API.g_miss_char;
1632: x_chan_rec.channel_name := FND_API.g_miss_char;
1633: x_chan_rec.description := FND_API.g_miss_char;
1634: --added by rrajesh on 12/07/00
1635: x_chan_rec.country_id := FND_API.g_miss_num;
1636: -- removed by Rahul Sharma on 01/18/2001
1637: --x_chan_rec.internal_resource := FND_API.g_miss_char;
1638: -- end 01/18/2001
1639: --end addition 12/07/00

Line 1637: --x_chan_rec.internal_resource := FND_API.g_miss_char;

1633: x_chan_rec.description := FND_API.g_miss_char;
1634: --added by rrajesh on 12/07/00
1635: x_chan_rec.country_id := FND_API.g_miss_num;
1636: -- removed by Rahul Sharma on 01/18/2001
1637: --x_chan_rec.internal_resource := FND_API.g_miss_char;
1638: -- end 01/18/2001
1639: --end addition 12/07/00
1640: END init_chan_rec;
1641:

Line 1676: RAISE FND_API.g_exc_error;

1672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1673: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1674: FND_MSG_PUB.add;
1675: END IF;
1676: RAISE FND_API.g_exc_error;
1677: END IF;
1678: CLOSE c_chan;
1679:
1680: IF p_chan_rec.managed_by_person_id = FND_API.g_miss_num THEN

Line 1680: IF p_chan_rec.managed_by_person_id = FND_API.g_miss_num THEN

1676: RAISE FND_API.g_exc_error;
1677: END IF;
1678: CLOSE c_chan;
1679:
1680: IF p_chan_rec.managed_by_person_id = FND_API.g_miss_num THEN
1681: x_complete_rec.managed_by_person_id := l_chan_rec.managed_by_person_id;
1682: END IF;
1683:
1684: IF p_chan_rec.active_from_date = FND_API.g_miss_date

Line 1684: IF p_chan_rec.active_from_date = FND_API.g_miss_date

1680: IF p_chan_rec.managed_by_person_id = FND_API.g_miss_num THEN
1681: x_complete_rec.managed_by_person_id := l_chan_rec.managed_by_person_id;
1682: END IF;
1683:
1684: IF p_chan_rec.active_from_date = FND_API.g_miss_date
1685: THEN
1686: x_complete_rec.active_from_date := l_chan_rec.active_from_date;
1687: END IF;
1688:

Line 1689: IF p_chan_rec.active_to_date = FND_API.g_miss_date

1685: THEN
1686: x_complete_rec.active_from_date := l_chan_rec.active_from_date;
1687: END IF;
1688:
1689: IF p_chan_rec.active_to_date = FND_API.g_miss_date
1690: THEN
1691: x_complete_rec.active_to_date := l_chan_rec.active_to_date;
1692: END IF;
1693:

Line 1694: IF p_chan_rec.outbound_flag = FND_API.g_miss_char THEN

1690: THEN
1691: x_complete_rec.active_to_date := l_chan_rec.active_to_date;
1692: END IF;
1693:
1694: IF p_chan_rec.outbound_flag = FND_API.g_miss_char THEN
1695: x_complete_rec.outbound_flag := l_chan_rec.outbound_flag;
1696: END IF;
1697:
1698: IF p_chan_rec.inbound_flag = FND_API.g_miss_char THEN

Line 1698: IF p_chan_rec.inbound_flag = FND_API.g_miss_char THEN

1694: IF p_chan_rec.outbound_flag = FND_API.g_miss_char THEN
1695: x_complete_rec.outbound_flag := l_chan_rec.outbound_flag;
1696: END IF;
1697:
1698: IF p_chan_rec.inbound_flag = FND_API.g_miss_char THEN
1699: x_complete_rec.inbound_flag := l_chan_rec.inbound_flag;
1700: END IF;
1701:
1702: IF p_chan_rec.order_sequence = FND_API.g_miss_num THEN

Line 1702: IF p_chan_rec.order_sequence = FND_API.g_miss_num THEN

1698: IF p_chan_rec.inbound_flag = FND_API.g_miss_char THEN
1699: x_complete_rec.inbound_flag := l_chan_rec.inbound_flag;
1700: END IF;
1701:
1702: IF p_chan_rec.order_sequence = FND_API.g_miss_num THEN
1703: x_complete_rec.order_sequence := l_chan_rec.order_sequence;
1704: END IF;
1705:
1706: IF p_chan_rec.channel_type_code = FND_API.g_miss_char THEN

Line 1706: IF p_chan_rec.channel_type_code = FND_API.g_miss_char THEN

1702: IF p_chan_rec.order_sequence = FND_API.g_miss_num THEN
1703: x_complete_rec.order_sequence := l_chan_rec.order_sequence;
1704: END IF;
1705:
1706: IF p_chan_rec.channel_type_code = FND_API.g_miss_char THEN
1707: x_complete_rec.channel_type_code := l_chan_rec.channel_type_code;
1708: END IF;
1709:
1710: IF p_chan_rec.rating = FND_API.g_miss_char THEN

Line 1710: IF p_chan_rec.rating = FND_API.g_miss_char THEN

1706: IF p_chan_rec.channel_type_code = FND_API.g_miss_char THEN
1707: x_complete_rec.channel_type_code := l_chan_rec.channel_type_code;
1708: END IF;
1709:
1710: IF p_chan_rec.rating = FND_API.g_miss_char THEN
1711: x_complete_rec.rating := l_chan_rec.rating;
1712: END IF;
1713:
1714: IF p_chan_rec.preferred_vendor_id = FND_API.g_miss_num THEN

Line 1714: IF p_chan_rec.preferred_vendor_id = FND_API.g_miss_num THEN

1710: IF p_chan_rec.rating = FND_API.g_miss_char THEN
1711: x_complete_rec.rating := l_chan_rec.rating;
1712: END IF;
1713:
1714: IF p_chan_rec.preferred_vendor_id = FND_API.g_miss_num THEN
1715: x_complete_rec.preferred_vendor_id:= l_chan_rec.preferred_vendor_id;
1716: END IF;
1717:
1718: IF p_chan_rec.party_id = FND_API.g_miss_num THEN

Line 1718: IF p_chan_rec.party_id = FND_API.g_miss_num THEN

1714: IF p_chan_rec.preferred_vendor_id = FND_API.g_miss_num THEN
1715: x_complete_rec.preferred_vendor_id:= l_chan_rec.preferred_vendor_id;
1716: END IF;
1717:
1718: IF p_chan_rec.party_id = FND_API.g_miss_num THEN
1719: x_complete_rec.party_id:= l_chan_rec.party_id;
1720: END IF;
1721:
1722:

Line 1723: IF p_chan_rec.attribute_category = FND_API.g_miss_char THEN

1719: x_complete_rec.party_id:= l_chan_rec.party_id;
1720: END IF;
1721:
1722:
1723: IF p_chan_rec.attribute_category = FND_API.g_miss_char THEN
1724: x_complete_rec.attribute_category := l_chan_rec.attribute_category;
1725: END IF;
1726:
1727: IF p_chan_rec.attribute1 = FND_API.g_miss_char THEN

Line 1727: IF p_chan_rec.attribute1 = FND_API.g_miss_char THEN

1723: IF p_chan_rec.attribute_category = FND_API.g_miss_char THEN
1724: x_complete_rec.attribute_category := l_chan_rec.attribute_category;
1725: END IF;
1726:
1727: IF p_chan_rec.attribute1 = FND_API.g_miss_char THEN
1728: x_complete_rec.attribute1 := l_chan_rec.attribute1;
1729: END IF;
1730:
1731: IF p_chan_rec.attribute2 = FND_API.g_miss_char THEN

Line 1731: IF p_chan_rec.attribute2 = FND_API.g_miss_char THEN

1727: IF p_chan_rec.attribute1 = FND_API.g_miss_char THEN
1728: x_complete_rec.attribute1 := l_chan_rec.attribute1;
1729: END IF;
1730:
1731: IF p_chan_rec.attribute2 = FND_API.g_miss_char THEN
1732: x_complete_rec.attribute2 := l_chan_rec.attribute2;
1733: END IF;
1734:
1735: IF p_chan_rec.attribute3 = FND_API.g_miss_char THEN

Line 1735: IF p_chan_rec.attribute3 = FND_API.g_miss_char THEN

1731: IF p_chan_rec.attribute2 = FND_API.g_miss_char THEN
1732: x_complete_rec.attribute2 := l_chan_rec.attribute2;
1733: END IF;
1734:
1735: IF p_chan_rec.attribute3 = FND_API.g_miss_char THEN
1736: x_complete_rec.attribute3 := l_chan_rec.attribute3;
1737: END IF;
1738:
1739: IF p_chan_rec.attribute4 = FND_API.g_miss_char THEN

Line 1739: IF p_chan_rec.attribute4 = FND_API.g_miss_char THEN

1735: IF p_chan_rec.attribute3 = FND_API.g_miss_char THEN
1736: x_complete_rec.attribute3 := l_chan_rec.attribute3;
1737: END IF;
1738:
1739: IF p_chan_rec.attribute4 = FND_API.g_miss_char THEN
1740: x_complete_rec.attribute4 := l_chan_rec.attribute4;
1741: END IF;
1742:
1743: IF p_chan_rec.attribute5 = FND_API.g_miss_char THEN

Line 1743: IF p_chan_rec.attribute5 = FND_API.g_miss_char THEN

1739: IF p_chan_rec.attribute4 = FND_API.g_miss_char THEN
1740: x_complete_rec.attribute4 := l_chan_rec.attribute4;
1741: END IF;
1742:
1743: IF p_chan_rec.attribute5 = FND_API.g_miss_char THEN
1744: x_complete_rec.attribute5 := l_chan_rec.attribute5;
1745: END IF;
1746:
1747: IF p_chan_rec.attribute6 = FND_API.g_miss_char THEN

Line 1747: IF p_chan_rec.attribute6 = FND_API.g_miss_char THEN

1743: IF p_chan_rec.attribute5 = FND_API.g_miss_char THEN
1744: x_complete_rec.attribute5 := l_chan_rec.attribute5;
1745: END IF;
1746:
1747: IF p_chan_rec.attribute6 = FND_API.g_miss_char THEN
1748: x_complete_rec.attribute6 := l_chan_rec.attribute6;
1749: END IF;
1750:
1751: IF p_chan_rec.attribute7 = FND_API.g_miss_char THEN

Line 1751: IF p_chan_rec.attribute7 = FND_API.g_miss_char THEN

1747: IF p_chan_rec.attribute6 = FND_API.g_miss_char THEN
1748: x_complete_rec.attribute6 := l_chan_rec.attribute6;
1749: END IF;
1750:
1751: IF p_chan_rec.attribute7 = FND_API.g_miss_char THEN
1752: x_complete_rec.attribute7 := l_chan_rec.attribute7;
1753: END IF;
1754:
1755: IF p_chan_rec.attribute8 = FND_API.g_miss_char THEN

Line 1755: IF p_chan_rec.attribute8 = FND_API.g_miss_char THEN

1751: IF p_chan_rec.attribute7 = FND_API.g_miss_char THEN
1752: x_complete_rec.attribute7 := l_chan_rec.attribute7;
1753: END IF;
1754:
1755: IF p_chan_rec.attribute8 = FND_API.g_miss_char THEN
1756: x_complete_rec.attribute8 := l_chan_rec.attribute8;
1757: END IF;
1758:
1759: IF p_chan_rec.attribute9 = FND_API.g_miss_char THEN

Line 1759: IF p_chan_rec.attribute9 = FND_API.g_miss_char THEN

1755: IF p_chan_rec.attribute8 = FND_API.g_miss_char THEN
1756: x_complete_rec.attribute8 := l_chan_rec.attribute8;
1757: END IF;
1758:
1759: IF p_chan_rec.attribute9 = FND_API.g_miss_char THEN
1760: x_complete_rec.attribute9 := l_chan_rec.attribute9;
1761: END IF;
1762:
1763: IF p_chan_rec.attribute10 = FND_API.g_miss_char THEN

Line 1763: IF p_chan_rec.attribute10 = FND_API.g_miss_char THEN

1759: IF p_chan_rec.attribute9 = FND_API.g_miss_char THEN
1760: x_complete_rec.attribute9 := l_chan_rec.attribute9;
1761: END IF;
1762:
1763: IF p_chan_rec.attribute10 = FND_API.g_miss_char THEN
1764: x_complete_rec.attribute10 := l_chan_rec.attribute10;
1765: END IF;
1766:
1767: IF p_chan_rec.attribute11 = FND_API.g_miss_char THEN

Line 1767: IF p_chan_rec.attribute11 = FND_API.g_miss_char THEN

1763: IF p_chan_rec.attribute10 = FND_API.g_miss_char THEN
1764: x_complete_rec.attribute10 := l_chan_rec.attribute10;
1765: END IF;
1766:
1767: IF p_chan_rec.attribute11 = FND_API.g_miss_char THEN
1768: x_complete_rec.attribute11 := l_chan_rec.attribute11;
1769: END IF;
1770:
1771: IF p_chan_rec.attribute12 = FND_API.g_miss_char THEN

Line 1771: IF p_chan_rec.attribute12 = FND_API.g_miss_char THEN

1767: IF p_chan_rec.attribute11 = FND_API.g_miss_char THEN
1768: x_complete_rec.attribute11 := l_chan_rec.attribute11;
1769: END IF;
1770:
1771: IF p_chan_rec.attribute12 = FND_API.g_miss_char THEN
1772: x_complete_rec.attribute12 := l_chan_rec.attribute12;
1773: END IF;
1774:
1775: IF p_chan_rec.attribute13 = FND_API.g_miss_char THEN

Line 1775: IF p_chan_rec.attribute13 = FND_API.g_miss_char THEN

1771: IF p_chan_rec.attribute12 = FND_API.g_miss_char THEN
1772: x_complete_rec.attribute12 := l_chan_rec.attribute12;
1773: END IF;
1774:
1775: IF p_chan_rec.attribute13 = FND_API.g_miss_char THEN
1776: x_complete_rec.attribute13 := l_chan_rec.attribute13;
1777: END IF;
1778:
1779: IF p_chan_rec.attribute14 = FND_API.g_miss_char THEN

Line 1779: IF p_chan_rec.attribute14 = FND_API.g_miss_char THEN

1775: IF p_chan_rec.attribute13 = FND_API.g_miss_char THEN
1776: x_complete_rec.attribute13 := l_chan_rec.attribute13;
1777: END IF;
1778:
1779: IF p_chan_rec.attribute14 = FND_API.g_miss_char THEN
1780: x_complete_rec.attribute14 := l_chan_rec.attribute14;
1781: END IF;
1782:
1783: IF p_chan_rec.attribute15 = FND_API.g_miss_char THEN

Line 1783: IF p_chan_rec.attribute15 = FND_API.g_miss_char THEN

1779: IF p_chan_rec.attribute14 = FND_API.g_miss_char THEN
1780: x_complete_rec.attribute14 := l_chan_rec.attribute14;
1781: END IF;
1782:
1783: IF p_chan_rec.attribute15 = FND_API.g_miss_char THEN
1784: x_complete_rec.attribute15 := l_chan_rec.attribute15;
1785: END IF;
1786:
1787: IF p_chan_rec.channel_name = FND_API.g_miss_char THEN

Line 1787: IF p_chan_rec.channel_name = FND_API.g_miss_char THEN

1783: IF p_chan_rec.attribute15 = FND_API.g_miss_char THEN
1784: x_complete_rec.attribute15 := l_chan_rec.attribute15;
1785: END IF;
1786:
1787: IF p_chan_rec.channel_name = FND_API.g_miss_char THEN
1788: x_complete_rec.channel_name := l_chan_rec.channel_name;
1789: END IF;
1790:
1791: IF p_chan_rec.description = FND_API.g_miss_char THEN

Line 1791: IF p_chan_rec.description = FND_API.g_miss_char THEN

1787: IF p_chan_rec.channel_name = FND_API.g_miss_char THEN
1788: x_complete_rec.channel_name := l_chan_rec.channel_name;
1789: END IF;
1790:
1791: IF p_chan_rec.description = FND_API.g_miss_char THEN
1792: x_complete_rec.description := l_chan_rec.description;
1793: END IF;
1794:
1795: --Added by rrajesh on 12/07/00

Line 1796: IF p_chan_rec.country_id = FND_API.g_miss_num THEN

1792: x_complete_rec.description := l_chan_rec.description;
1793: END IF;
1794:
1795: --Added by rrajesh on 12/07/00
1796: IF p_chan_rec.country_id = FND_API.g_miss_num THEN
1797: x_complete_rec.country_id := l_chan_rec.country_id;
1798: END IF;
1799:
1800: -- removed by Rahul Sharma on 01/18/2001

Line 1801: --IF p_chan_rec.internal_resource = FND_API.g_miss_char THEN

1797: x_complete_rec.country_id := l_chan_rec.country_id;
1798: END IF;
1799:
1800: -- removed by Rahul Sharma on 01/18/2001
1801: --IF p_chan_rec.internal_resource = FND_API.g_miss_char THEN
1802: --x_complete_rec.internal_resource := l_chan_rec.internal_resource;
1803: --END IF;
1804: --end 01/18/2001
1805: --end 12/07/00