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.JTF_DSP_MSITE_SCT_SECT_PVT dependencies on FND_MESSAGE

Line 452: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_MSITE_ID');

448: -- mini site id
449: IF ((p_mini_site_id IS NULL) OR
450: (p_mini_site_id = FND_API.G_MISS_NUM))
451: THEN
452: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_MSITE_ID');
453: FND_MSG_PUB.Add;
454: RAISE FND_API.G_EXC_ERROR;
455: END IF;
456:

Line 461: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_CHILD_SCT_ID');

457: -- child section id
458: IF ((p_child_section_id IS NULL) OR
459: (p_child_section_id = FND_API.G_MISS_NUM))
460: THEN
461: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_CHILD_SCT_ID');
462: FND_MSG_PUB.Add;
463: RAISE FND_API.G_EXC_ERROR;
464: END IF;
465:

Line 470: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');

466: -- start_date_active
467: IF ((p_start_date_active IS NULL) OR
468: (p_start_date_active = FND_API.G_MISS_DATE))
469: THEN
470: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
471: FND_MSG_PUB.Add;
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:

Line 484: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_LVL_NUM');

480: IF ((p_level_number IS NOT NULL) AND
481: (p_level_number <> FND_API.G_MISS_NUM))
482: THEN
483: IF(p_level_number < 0) THEN
484: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_LVL_NUM');
485: FND_MSG_PUB.Add;
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488: END IF;

Line 495: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');

491: IF ((p_sort_order IS NOT NULL) AND
492: (p_sort_order <> FND_API.G_MISS_NUM))
493: THEN
494: IF(p_sort_order < 0) THEN
495: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
496: FND_MSG_PUB.Add;
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499: END IF;

Line 512: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_MSITE_ID');

508: SELECT msite_id INTO l_mini_site_id FROM jtf_msites_b
509: WHERE msite_id = p_mini_site_id;
510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN
512: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_MSITE_ID');
513: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
514: FND_MSG_PUB.Add;
515: RAISE FND_API.G_EXC_ERROR;
516: WHEN OTHERS THEN

Line 513: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

509: WHERE msite_id = p_mini_site_id;
510: EXCEPTION
511: WHEN NO_DATA_FOUND THEN
512: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_MSITE_ID');
513: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
514: FND_MSG_PUB.Add;
515: RAISE FND_API.G_EXC_ERROR;
516: WHEN OTHERS THEN
517: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');

Line 517: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');

513: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
514: FND_MSG_PUB.Add;
515: RAISE FND_API.G_EXC_ERROR;
516: WHEN OTHERS THEN
517: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');
518: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
519: FND_MSG_PUB.Add;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END;

Line 518: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

514: FND_MSG_PUB.Add;
515: RAISE FND_API.G_EXC_ERROR;
516: WHEN OTHERS THEN
517: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');
518: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
519: FND_MSG_PUB.Add;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END;
522:

Line 532: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');

528: SELECT section_id INTO l_parent_section_id FROM jtf_dsp_sections_b
529: WHERE section_id = p_parent_section_id;
530: EXCEPTION
531: WHEN NO_DATA_FOUND THEN
532: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');
533: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
534: FND_MSG_PUB.Add;
535: RAISE FND_API.G_EXC_ERROR;
536: WHEN OTHERS THEN

Line 533: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);

529: WHERE section_id = p_parent_section_id;
530: EXCEPTION
531: WHEN NO_DATA_FOUND THEN
532: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');
533: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
534: FND_MSG_PUB.Add;
535: RAISE FND_API.G_EXC_ERROR;
536: WHEN OTHERS THEN
537: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');

Line 537: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');

533: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
534: FND_MSG_PUB.Add;
535: RAISE FND_API.G_EXC_ERROR;
536: WHEN OTHERS THEN
537: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
538: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
539: FND_MSG_PUB.Add;
540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
541: END;

Line 538: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);

534: FND_MSG_PUB.Add;
535: RAISE FND_API.G_EXC_ERROR;
536: WHEN OTHERS THEN
537: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
538: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
539: FND_MSG_PUB.Add;
540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
541: END;
542: END IF;

Line 551: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');

547: SELECT section_id INTO l_child_section_id FROM jtf_dsp_sections_b
548: WHERE section_id = p_child_section_id;
549: EXCEPTION
550: WHEN NO_DATA_FOUND THEN
551: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');
552: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
553: FND_MSG_PUB.Add;
554: RAISE FND_API.G_EXC_ERROR;
555: WHEN OTHERS THEN

Line 552: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);

548: WHERE section_id = p_child_section_id;
549: EXCEPTION
550: WHEN NO_DATA_FOUND THEN
551: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');
552: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
553: FND_MSG_PUB.Add;
554: RAISE FND_API.G_EXC_ERROR;
555: WHEN OTHERS THEN
556: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');

Line 556: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');

552: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
553: FND_MSG_PUB.Add;
554: RAISE FND_API.G_EXC_ERROR;
555: WHEN OTHERS THEN
556: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
557: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
558: FND_MSG_PUB.Add;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END;

Line 557: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);

553: FND_MSG_PUB.Add;
554: RAISE FND_API.G_EXC_ERROR;
555: WHEN OTHERS THEN
556: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
557: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
558: FND_MSG_PUB.Add;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END;
561:

Line 574: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');

570:
571: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
574: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
577: END IF;
578:

Line 657: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NULL_PRIMARY_KEY');

653: --
654:
655: -- mini_site_section_section_id
656: IF (p_mini_site_section_section_id IS NULL) THEN
657: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NULL_PRIMARY_KEY');
658: FND_MSG_PUB.Add;
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661:

Line 664: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');

660: END IF;
661:
662: -- start_date_active
663: IF (p_start_date_active IS NULL) THEN
664: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
665: FND_MSG_PUB.Add;
666: RAISE FND_API.G_EXC_ERROR;
667: END IF;
668:

Line 678: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_LVL_NUM');

674: IF ((p_level_number IS NOT NULL) AND
675: (p_level_number <> FND_API.G_MISS_NUM))
676: THEN
677: IF(p_level_number < 0) THEN
678: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_LVL_NUM');
679: FND_MSG_PUB.Add;
680: RAISE FND_API.G_EXC_ERROR;
681: END IF;
682: END IF;

Line 689: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');

685: IF ((p_sort_order IS NOT NULL) AND
686: (p_sort_order <> FND_API.G_MISS_NUM))
687: THEN
688: IF(p_sort_order < 0) THEN
689: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
690: FND_MSG_PUB.Add;
691: RAISE FND_API.G_EXC_ERROR;
692: END IF;
693: END IF;

Line 808: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_CREATE');

804:
805: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
808: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_CREATE');
809: FND_MSG_PUB.Add;
810: RAISE FND_API.G_EXC_ERROR; -- invalid
811: END IF;
812:

Line 839: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INSERT_FAIL');

835: x_mini_site_section_section_id
836: );
837: EXCEPTION
838: WHEN NO_DATA_FOUND THEN
839: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INSERT_FAIL');
840: FND_MSG_PUB.Add;
841: RAISE FND_API.G_EXC_ERROR;
842: WHEN OTHERS THEN
843: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INSERT_FAIL');

Line 843: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INSERT_FAIL');

839: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INSERT_FAIL');
840: FND_MSG_PUB.Add;
841: RAISE FND_API.G_EXC_ERROR;
842: WHEN OTHERS THEN
843: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INSERT_FAIL');
844: FND_MSG_PUB.Add;
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END;
847:

Line 985: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');

981: END IF;
982:
983: EXCEPTION
984: WHEN NO_DATA_FOUND THEN
985: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
986: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
987: IF (p_parent_section_id IS NOT NULL) THEN
988: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
989: ELSE

Line 986: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

982:
983: EXCEPTION
984: WHEN NO_DATA_FOUND THEN
985: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
986: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
987: IF (p_parent_section_id IS NOT NULL) THEN
988: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
989: ELSE
990: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

Line 988: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);

984: WHEN NO_DATA_FOUND THEN
985: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
986: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
987: IF (p_parent_section_id IS NOT NULL) THEN
988: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
989: ELSE
990: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
991: END IF;
992: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

Line 990: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

986: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
987: IF (p_parent_section_id IS NOT NULL) THEN
988: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
989: ELSE
990: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
991: END IF;
992: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
993: FND_MSG_PUB.Add;
994: RAISE FND_API.G_EXC_ERROR;

Line 992: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

988: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
989: ELSE
990: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
991: END IF;
992: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
993: FND_MSG_PUB.Add;
994: RAISE FND_API.G_EXC_ERROR;
995: WHEN OTHERS THEN
996: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');

Line 996: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');

992: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
993: FND_MSG_PUB.Add;
994: RAISE FND_API.G_EXC_ERROR;
995: WHEN OTHERS THEN
996: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
997: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
998: IF (p_parent_section_id IS NOT NULL) THEN
999: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1000: ELSE

Line 997: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

993: FND_MSG_PUB.Add;
994: RAISE FND_API.G_EXC_ERROR;
995: WHEN OTHERS THEN
996: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
997: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
998: IF (p_parent_section_id IS NOT NULL) THEN
999: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1000: ELSE
1001: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

Line 999: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);

995: WHEN OTHERS THEN
996: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
997: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
998: IF (p_parent_section_id IS NOT NULL) THEN
999: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1000: ELSE
1001: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1002: END IF;
1003: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

Line 1001: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

997: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
998: IF (p_parent_section_id IS NOT NULL) THEN
999: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1000: ELSE
1001: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1002: END IF;
1003: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1004: FND_MSG_PUB.Add;
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1003: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

999: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1000: ELSE
1001: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1002: END IF;
1003: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1004: FND_MSG_PUB.Add;
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END;
1007: ELSE

Line 1010: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_IDS_SPEC');

1006: END;
1007: ELSE
1008: -- neither mini_site_section_section_id nor combination of
1009: -- mini_site_id, parent_section_id and child_section_id is specified
1010: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_IDS_SPEC');
1011: FND_MSG_PUB.Add;
1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;
1014:

Line 1038: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_UPDATE');

1034:
1035: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1038: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_UPDATE');
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_ERROR; -- invalid
1041: END IF;
1042:

Line 1060: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');

1056: FND_GLOBAL.login_id
1057: );
1058: EXCEPTION
1059: WHEN NO_DATA_FOUND THEN
1060: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');
1061: FND_MSG_PUB.Add;
1062: RAISE FND_API.G_EXC_ERROR;
1063: WHEN OTHERS THEN
1064: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');

Line 1064: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');

1060: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');
1061: FND_MSG_PUB.Add;
1062: RAISE FND_API.G_EXC_ERROR;
1063: WHEN OTHERS THEN
1064: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');
1065: FND_MSG_PUB.Add;
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END;
1068:

Line 1194: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');

1190: END IF;
1191:
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND THEN
1194: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
1195: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1196: IF (p_parent_section_id IS NOT NULL) THEN
1197: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1198: ELSE

Line 1195: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

1191:
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND THEN
1194: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
1195: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1196: IF (p_parent_section_id IS NOT NULL) THEN
1197: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1198: ELSE
1199: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

Line 1197: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);

1193: WHEN NO_DATA_FOUND THEN
1194: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
1195: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1196: IF (p_parent_section_id IS NOT NULL) THEN
1197: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1198: ELSE
1199: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1200: END IF;
1201: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

Line 1199: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

1195: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1196: IF (p_parent_section_id IS NOT NULL) THEN
1197: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1198: ELSE
1199: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1200: END IF;
1201: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1202: FND_MSG_PUB.Add;
1203: RAISE FND_API.G_EXC_ERROR;

Line 1201: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

1197: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1198: ELSE
1199: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1200: END IF;
1201: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1202: FND_MSG_PUB.Add;
1203: RAISE FND_API.G_EXC_ERROR;
1204: WHEN OTHERS THEN
1205: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');

Line 1205: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');

1201: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1202: FND_MSG_PUB.Add;
1203: RAISE FND_API.G_EXC_ERROR;
1204: WHEN OTHERS THEN
1205: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
1206: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1207: IF (p_parent_section_id IS NOT NULL) THEN
1208: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1209: ELSE

Line 1206: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

1202: FND_MSG_PUB.Add;
1203: RAISE FND_API.G_EXC_ERROR;
1204: WHEN OTHERS THEN
1205: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
1206: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1207: IF (p_parent_section_id IS NOT NULL) THEN
1208: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1209: ELSE
1210: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

Line 1208: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);

1204: WHEN OTHERS THEN
1205: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
1206: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1207: IF (p_parent_section_id IS NOT NULL) THEN
1208: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1209: ELSE
1210: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1211: END IF;
1212: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

Line 1210: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');

1206: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1207: IF (p_parent_section_id IS NOT NULL) THEN
1208: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1209: ELSE
1210: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1211: END IF;
1212: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1213: FND_MSG_PUB.Add;
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1212: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);

1208: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', p_parent_section_id);
1209: ELSE
1210: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1211: END IF;
1212: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1213: FND_MSG_PUB.Add;
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END;
1216:

Line 1220: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_IDS_SPEC');

1216:
1217: ELSE
1218: -- neither mini_site_section_section_id nor combination of
1219: -- mini_site_id, parent_section_id and child_section_id is specified
1220: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_IDS_SPEC');
1221: FND_MSG_PUB.Add;
1222: RAISE FND_API.G_EXC_ERROR;
1223: END IF;
1224: