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_MSG_PUB

Line 329: FND_MSG_PUB.initialize;

325: BEGIN
326:
327: -- Initialize message list if p_init_msg_list is set to TRUE.
328: IF FND_API.to_Boolean(p_init_msg_list) THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:
332: -- Initialize API return status to error, i.e, its not duplicate
333: x_return_status := FND_API.G_RET_STS_ERROR;

Line 377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

373: EXCEPTION
374:
375: WHEN FND_API.G_EXC_ERROR THEN
376: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => 'F');
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 383: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

379: p_encoded => 'F');
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data,
385: p_encoded => 'F');
386:
387: WHEN OTHERS THEN

Line 390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

386:
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389:
390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
391: THEN
392: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
393: END IF;
394:

Line 392: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389:
390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
391: THEN
392: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
393: END IF;
394:
395: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
396: p_data => x_msg_data,

Line 395: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

391: THEN
392: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
393: END IF;
394:
395: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
396: p_data => x_msg_data,
397: p_encoded => 'F');
398:
399: END Check_Duplicate_Entry;

Line 438: FND_MSG_PUB.initialize;

434: BEGIN
435:
436: -- Initialize message list if p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean(p_init_msg_list) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440:
441: -- Initialize API return status to success
442: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 453: FND_MSG_PUB.Add;

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:
457: -- child section id

Line 462: FND_MSG_PUB.Add;

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:
466: -- start_date_active

Line 471: FND_MSG_PUB.Add;

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:
475: --

Line 485: FND_MSG_PUB.Add;

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;
489:

Line 496: FND_MSG_PUB.Add;

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;
500:

Line 514: FND_MSG_PUB.Add;

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');
518: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

Line 519: 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:
523: -- parent section id

Line 534: FND_MSG_PUB.Add;

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');
538: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);

Line 539: 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;
543:

Line 553: FND_MSG_PUB.Add;

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');
557: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);

Line 558: 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:
562: -- Validate if the entry is duplicate

Line 575: FND_MSG_PUB.Add;

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:
579: EXCEPTION

Line 583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

579: EXCEPTION
580:
581: WHEN FND_API.G_EXC_ERROR THEN
582: x_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
584: p_data => x_msg_data,
585: p_encoded => 'F');
586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 589: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

585: p_encoded => 'F');
586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
590: p_data => x_msg_data,
591: p_encoded => 'F');
592:
593: WHEN OTHERS THEN

Line 596: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

592:
593: WHEN OTHERS THEN
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595:
596: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
599: END IF;
600:

Line 598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595:
596: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
599: END IF;
600:
601: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
602: p_data => x_msg_data,

Line 601: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

597: THEN
598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
599: END IF;
600:
601: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
602: p_data => x_msg_data,
603: p_encoded => 'F');
604:
605: END Validate_Create;

Line 645: FND_MSG_PUB.initialize;

641: BEGIN
642:
643: -- Initialize message list if p_init_msg_list is set to TRUE.
644: IF FND_API.to_Boolean(p_init_msg_list) THEN
645: FND_MSG_PUB.initialize;
646: END IF;
647:
648: -- Initialize API return status to success
649: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 658: FND_MSG_PUB.Add;

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:
662: -- start_date_active

Line 665: FND_MSG_PUB.Add;

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:
669: --

Line 679: FND_MSG_PUB.Add;

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;
683:

Line 690: FND_MSG_PUB.Add;

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;
694:

Line 699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

695: EXCEPTION
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
700: p_data => x_msg_data,
701: p_encoded => 'F');
702:
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 705: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

701: p_encoded => 'F');
702:
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => 'F');
708:
709: WHEN OTHERS THEN

Line 712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

708:
709: WHEN OTHERS THEN
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711:
712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
713: THEN
714: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
715: END IF;
716:

Line 714: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711:
712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
713: THEN
714: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
715: END IF;
716:
717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
718: p_data => x_msg_data,

Line 717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

713: THEN
714: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
715: END IF;
716:
717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
718: p_data => x_msg_data,
719: p_encoded => 'F');
720:
721: END Validate_Update;

Line 773: FND_MSG_PUB.initialize;

769: END IF;
770:
771: -- Initialize message list if p_init_msg_list is set to TRUE.
772: IF FND_API.to_Boolean(p_init_msg_list) THEN
773: FND_MSG_PUB.initialize;
774: END IF;
775:
776: -- Initialize API return status to success
777: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 809: FND_MSG_PUB.Add;

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:
813: --

Line 840: FND_MSG_PUB.Add;

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');
844: FND_MSG_PUB.Add;

Line 844: FND_MSG_PUB.Add;

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:
848: --

Line 857: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

853: COMMIT WORK;
854: END IF;
855:
856: -- Standard call to get message count and if count is 1, get message info.
857: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
858: p_data => x_msg_data,
859: p_encoded => 'F');
860:
861: EXCEPTION

Line 866: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

862:
863: WHEN FND_API.G_EXC_ERROR THEN
864: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
867: p_data => x_msg_data,
868: p_encoded => 'F');
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 873: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
874: p_data => x_msg_data,
875: p_encoded => 'F');
876:
877: WHEN OTHERS THEN

Line 881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

877: WHEN OTHERS THEN
878: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
880:
881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
882: THEN
883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
884: END IF;
885:

Line 883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
880:
881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
882: THEN
883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
884: END IF;
885:
886: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
887: p_data => x_msg_data,

Line 886: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

882: THEN
883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
884: END IF;
885:
886: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
887: p_data => x_msg_data,
888: p_encoded => 'F');
889:
890: END Create_MSite_Section_Section;

Line 937: FND_MSG_PUB.initialize;

933: END IF;
934:
935: -- Initialize message list if p_init_msg_list is set to TRUE.
936: IF FND_API.to_Boolean(p_init_msg_list) THEN
937: FND_MSG_PUB.initialize;
938: END IF;
939:
940: -- Initialize API return status to success
941: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 993: FND_MSG_PUB.Add;

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');
997: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

Line 1004: FND_MSG_PUB.Add;

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
1008: -- neither mini_site_section_section_id nor combination of

Line 1011: FND_MSG_PUB.Add;

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:
1015:

Line 1039: FND_MSG_PUB.Add;

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:
1043: -- 2. update row

Line 1061: FND_MSG_PUB.Add;

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');
1065: FND_MSG_PUB.Add;

Line 1065: FND_MSG_PUB.Add;

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:
1069: --

Line 1078: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1074: COMMIT WORK;
1075: END IF;
1076:
1077: -- Standard call to get message count and if count is 1, get message info.
1078: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1079: p_data => x_msg_data,
1080: p_encoded => 'F');
1081:
1082: EXCEPTION

Line 1087: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1083:
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1088: p_data => x_msg_data,
1089: p_encoded => 'F');
1090:
1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1094: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1090:
1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1092: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1095: p_data => x_msg_data,
1096: p_encoded => 'F');
1097:
1098: WHEN OTHERS THEN

Line 1102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1098: WHEN OTHERS THEN
1099: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101:
1102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1103: THEN
1104: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1105: END IF;
1106:

Line 1104: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101:
1102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1103: THEN
1104: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1105: END IF;
1106:
1107: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1108: p_data => x_msg_data,

Line 1107: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1103: THEN
1104: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1105: END IF;
1106:
1107: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1108: p_data => x_msg_data,
1109: p_encoded => 'F');
1110:
1111: END Update_MSite_Section_Section;

Line 1148: FND_MSG_PUB.initialize;

1144: END IF;
1145:
1146: -- Initialize message list if p_init_msg_list is set to TRUE.
1147: IF FND_API.to_Boolean(p_init_msg_list) THEN
1148: FND_MSG_PUB.initialize;
1149: END IF;
1150:
1151: -- Initialize API return status to success
1152: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1202: FND_MSG_PUB.Add;

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');
1206: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);

Line 1213: FND_MSG_PUB.Add;

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:
1217: ELSE

Line 1221: FND_MSG_PUB.Add;

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:
1225: -- delete row

Line 1233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1229:
1230: WHEN FND_API.G_EXC_ERROR THEN
1231: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1234: p_data => x_msg_data,
1235: p_encoded => 'F');
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1241: p_data => x_msg_data,
1242: p_encoded => 'F');
1243:
1244: WHEN OTHERS THEN

Line 1248: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1244: WHEN OTHERS THEN
1245: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247:
1248: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1249: THEN
1250: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1251: END IF;
1252:

Line 1250: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247:
1248: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1249: THEN
1250: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1251: END IF;
1252:
1253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1254: p_data => x_msg_data,

Line 1253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1249: THEN
1250: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1251: END IF;
1252:
1253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1254: p_data => x_msg_data,
1255: p_encoded => 'F');
1256:
1257: END Delete_MSite_Section_Section;

Line 1299: FND_MSG_PUB.initialize;

1295: END IF;
1296:
1297: -- Initialize message list if p_init_msg_list is set to TRUE.
1298: IF FND_API.to_Boolean(p_init_msg_list) THEN
1299: FND_MSG_PUB.initialize;
1300: END IF;
1301:
1302: -- Initialize API return status to success
1303: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1348: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1344: COMMIT WORK;
1345: END IF;
1346:
1347: -- Standard call to get message count and if count is 1, get message info.
1348: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1349: p_data => x_msg_data,
1350: p_encoded => 'F');
1351:
1352: EXCEPTION

Line 1357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1353:
1354: WHEN FND_API.G_EXC_ERROR THEN
1355: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1358: p_data => x_msg_data,
1359: p_encoded => 'F');
1360:
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1360:
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1365: p_data => x_msg_data,
1366: p_encoded => 'F');
1367:
1368: WHEN OTHERS THEN

Line 1372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1368: WHEN OTHERS THEN
1369: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371:
1372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1373: THEN
1374: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1375: END IF;
1376:

Line 1374: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371:
1372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1373: THEN
1374: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1375: END IF;
1376:
1377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1378: p_data => x_msg_data,

Line 1377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1373: THEN
1374: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1375: END IF;
1376:
1377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1378: p_data => x_msg_data,
1379: p_encoded => 'F');
1380:
1381: END Update_MSite_Section_Sections;

Line 1424: FND_MSG_PUB.initialize;

1420: END IF;
1421:
1422: -- Initialize message list if p_init_msg_list is set to TRUE.
1423: IF FND_API.to_Boolean(p_init_msg_list) THEN
1424: FND_MSG_PUB.initialize;
1425: END IF;
1426:
1427: -- Initialize API return status to success
1428: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1501: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1497: COMMIT WORK;
1498: END IF;
1499:
1500: -- Standard call to get message count and if count is 1, get message info.
1501: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1502: p_data => x_msg_data,
1503: p_encoded => 'F');
1504:
1505: EXCEPTION

Line 1510: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1506:
1507: WHEN FND_API.G_EXC_ERROR THEN
1508: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1511: p_data => x_msg_data,
1512: p_encoded => 'F');
1513:
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1513:
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1515: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1518: p_data => x_msg_data,
1519: p_encoded => 'F');
1520:
1521: WHEN OTHERS THEN

Line 1525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1521: WHEN OTHERS THEN
1522: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1524:
1525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1526: THEN
1527: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1528: END IF;
1529:

Line 1527: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1524:
1525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1526: THEN
1527: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1528: END IF;
1529:
1530: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1531: p_data => x_msg_data,

Line 1530: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1526: THEN
1527: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1528: END IF;
1529:
1530: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1531: p_data => x_msg_data,
1532: p_encoded => 'F');
1533:
1534: END Update_Delete_Sct_Scts;