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.AHL_PP_RESRC_ASSIGN_PVT dependencies on FND_MSG_PUB

Line 506: Fnd_Msg_Pub.ADD;

502: END IF;
503:
504: /*IF SQL%rowcount = 0 THEN
505: Fnd_Message.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
506: Fnd_Msg_Pub.ADD;
507: END IF;*/
508: END UPDATE_ROW;
509:
510: ---------------------------------------------------------------------

Line 541: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

537:
538: IF (p_resrc_assign_rec.ASSIGNMENT_ID IS NULL OR p_resrc_assign_rec.ASSIGNMENT_ID = Fnd_Api.G_MISS_NUM) THEN
539: -- OPERATION_SEQ_NUMBER
540: IF (p_resrc_assign_rec.OPERATION_SEQ_NUMBER IS NULL OR p_resrc_assign_rec.OPERATION_SEQ_NUMBER = Fnd_Api.G_MISS_NUM) THEN
541: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
542: Fnd_Message.set_name ('AHL', 'AHL_PP_OPER_SEQ_MISSING');
543: Fnd_Msg_Pub.ADD;
544: END IF;
545: x_return_status := Fnd_Api.g_ret_sts_error;

Line 543: Fnd_Msg_Pub.ADD;

539: -- OPERATION_SEQ_NUMBER
540: IF (p_resrc_assign_rec.OPERATION_SEQ_NUMBER IS NULL OR p_resrc_assign_rec.OPERATION_SEQ_NUMBER = Fnd_Api.G_MISS_NUM) THEN
541: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
542: Fnd_Message.set_name ('AHL', 'AHL_PP_OPER_SEQ_MISSING');
543: Fnd_Msg_Pub.ADD;
544: END IF;
545: x_return_status := Fnd_Api.g_ret_sts_error;
546: RETURN;
547: END IF;

Line 552: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

548:
549: -- OPERATION_SEQ_NUMBER - Positive
550: IF (p_resrc_assign_rec.OPERATION_SEQ_NUMBER IS NOT NULL AND p_resrc_assign_rec.OPERATION_SEQ_NUMBER <> Fnd_Api.G_MISS_NUM) THEN
551: IF p_resrc_assign_rec.OPERATION_SEQ_NUMBER < 0 THEN
552: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
553: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
554: Fnd_Msg_Pub.ADD;
555: END IF;
556: x_return_status := Fnd_Api.g_ret_sts_error;

Line 554: Fnd_Msg_Pub.ADD;

550: IF (p_resrc_assign_rec.OPERATION_SEQ_NUMBER IS NOT NULL AND p_resrc_assign_rec.OPERATION_SEQ_NUMBER <> Fnd_Api.G_MISS_NUM) THEN
551: IF p_resrc_assign_rec.OPERATION_SEQ_NUMBER < 0 THEN
552: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
553: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
554: Fnd_Msg_Pub.ADD;
555: END IF;
556: x_return_status := Fnd_Api.g_ret_sts_error;
557: RETURN;
558: END IF;

Line 563: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

559: END IF;
560:
561: -- RESOURCE_SEQ_NUMBER
562: IF (p_resrc_assign_rec.RESOURCE_SEQ_NUMBER IS NULL OR p_resrc_assign_rec.RESOURCE_SEQ_NUMBER = Fnd_Api.G_MISS_NUM) THEN
563: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
564: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_SEQ_MISSING');
565: Fnd_Msg_Pub.ADD;
566: RAISE FND_API.G_EXC_ERROR;
567: END IF;

Line 565: Fnd_Msg_Pub.ADD;

561: -- RESOURCE_SEQ_NUMBER
562: IF (p_resrc_assign_rec.RESOURCE_SEQ_NUMBER IS NULL OR p_resrc_assign_rec.RESOURCE_SEQ_NUMBER = Fnd_Api.G_MISS_NUM) THEN
563: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
564: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_SEQ_MISSING');
565: Fnd_Msg_Pub.ADD;
566: RAISE FND_API.G_EXC_ERROR;
567: END IF;
568: x_return_status := Fnd_Api.g_ret_sts_error;
569: RETURN;

Line 575: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

571:
572: -- RESOURCE_SEQ_NUMBER - Positive
573: IF (p_resrc_assign_rec.RESOURCE_SEQ_NUMBER IS NOT NULL AND p_resrc_assign_rec.RESOURCE_SEQ_NUMBER <> Fnd_Api.G_MISS_NUM) THEN
574: IF p_resrc_assign_rec.RESOURCE_SEQ_NUMBER < 0 THEN
575: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
576: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
577: Fnd_Msg_Pub.ADD;
578: END IF;
579: x_return_status := Fnd_Api.g_ret_sts_error;

Line 577: Fnd_Msg_Pub.ADD;

573: IF (p_resrc_assign_rec.RESOURCE_SEQ_NUMBER IS NOT NULL AND p_resrc_assign_rec.RESOURCE_SEQ_NUMBER <> Fnd_Api.G_MISS_NUM) THEN
574: IF p_resrc_assign_rec.RESOURCE_SEQ_NUMBER < 0 THEN
575: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
576: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
577: Fnd_Msg_Pub.ADD;
578: END IF;
579: x_return_status := Fnd_Api.g_ret_sts_error;
580: RETURN;
581: END IF;

Line 603: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

599: IF G_DEBUG='Y' THEN
600: Ahl_Debug_Pub.debug( ': Resource Type 22222= ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);
601: END IF;
602:
603: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
604: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_NUM_MISSING');
605: Fnd_Msg_Pub.ADD;
606: END IF;
607: x_return_status := Fnd_Api.g_ret_sts_error;

Line 605: Fnd_Msg_Pub.ADD;

601: END IF;
602:
603: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
604: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_NUM_MISSING');
605: Fnd_Msg_Pub.ADD;
606: END IF;
607: x_return_status := Fnd_Api.g_ret_sts_error;
608: RETURN;
609: END IF; */

Line 616: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

612: IF G_DEBUG='Y' THEN
613: Ahl_Debug_Pub.debug( ': Resource Type 22222= ' || p_resrc_assign_rec.RESOURCE_TYPE_CODE);
614: END IF;
615:
616: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
617: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_NUM_MISSING');
618: Fnd_Msg_Pub.ADD;
619: END IF;
620: x_return_status := Fnd_Api.g_ret_sts_error;

Line 618: Fnd_Msg_Pub.ADD;

614: END IF;
615:
616: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
617: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_NUM_MISSING');
618: Fnd_Msg_Pub.ADD;
619: END IF;
620: x_return_status := Fnd_Api.g_ret_sts_error;
621: RETURN;
622: END IF;

Line 628: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

624:
625: IF p_resrc_assign_rec.RESOURCE_TYPE_CODE <> 2 THEN
626: -- SERIAL NUMBER
627: IF (p_resrc_assign_rec.SERIAL_NUMBER IS NULL OR p_resrc_assign_rec.SERIAL_NUMBER = Fnd_Api.G_MISS_CHAR) THEN
628: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
629: Fnd_Message.set_name ('AHL', 'AHL_PP_SERIAL_MISSING');
630: Fnd_Msg_Pub.ADD;
631: END IF;
632: x_return_status := Fnd_Api.g_ret_sts_error;

Line 630: Fnd_Msg_Pub.ADD;

626: -- SERIAL NUMBER
627: IF (p_resrc_assign_rec.SERIAL_NUMBER IS NULL OR p_resrc_assign_rec.SERIAL_NUMBER = Fnd_Api.G_MISS_CHAR) THEN
628: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
629: Fnd_Message.set_name ('AHL', 'AHL_PP_SERIAL_MISSING');
630: Fnd_Msg_Pub.ADD;
631: END IF;
632: x_return_status := Fnd_Api.g_ret_sts_error;
633: RETURN;
634: END IF;

Line 639: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

635: END IF;
636:
637: -- ASSIGN_START_DATE
638: IF (p_resrc_assign_rec.ASSIGN_START_DATE IS NULL OR p_resrc_assign_rec.ASSIGN_START_DATE = Fnd_Api.G_MISS_DATE)THEN
639: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
640: Fnd_Message.set_name ('AHL', 'AHL_PP_ASSIGN_ST_DT_MISSING');
641: Fnd_Msg_Pub.ADD;
642: END IF;
643: x_return_status := Fnd_Api.g_ret_sts_error;

Line 641: Fnd_Msg_Pub.ADD;

637: -- ASSIGN_START_DATE
638: IF (p_resrc_assign_rec.ASSIGN_START_DATE IS NULL OR p_resrc_assign_rec.ASSIGN_START_DATE = Fnd_Api.G_MISS_DATE)THEN
639: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
640: Fnd_Message.set_name ('AHL', 'AHL_PP_ASSIGN_ST_DT_MISSING');
641: Fnd_Msg_Pub.ADD;
642: END IF;
643: x_return_status := Fnd_Api.g_ret_sts_error;
644: RETURN;
645: END IF;

Line 649: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

645: END IF;
646:
647: -- ASSIGN_END_DATE
648: IF (p_resrc_assign_rec.ASSIGN_END_DATE IS NULL OR p_resrc_assign_rec.ASSIGN_END_DATE = Fnd_Api.G_MISS_DATE)THEN
649: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
650: Fnd_Message.set_name ('AHL', 'AHL_PP_ASSIGN_END_DT_MISSING');
651: Fnd_Msg_Pub.ADD;
652: END IF;
653: x_return_status := Fnd_Api.g_ret_sts_error;

Line 651: Fnd_Msg_Pub.ADD;

647: -- ASSIGN_END_DATE
648: IF (p_resrc_assign_rec.ASSIGN_END_DATE IS NULL OR p_resrc_assign_rec.ASSIGN_END_DATE = Fnd_Api.G_MISS_DATE)THEN
649: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
650: Fnd_Message.set_name ('AHL', 'AHL_PP_ASSIGN_END_DT_MISSING');
651: Fnd_Msg_Pub.ADD;
652: END IF;
653: x_return_status := Fnd_Api.g_ret_sts_error;
654: RETURN;
655: END IF;

Line 782: Fnd_Msg_Pub.initialize;

778: Ahl_Debug_Pub.debug( l_full_name ||':Start');
779: END IF;
780:
781: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
782: Fnd_Msg_Pub.initialize;
783: END IF;
784:
785: IF NOT Fnd_Api.compatible_api_call (
786: l_api_version,

Line 832: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

828:
829: ---End date must be greater than or equal to Start Date
830:
831: IF l_assign_start_date > l_assign_end_date THEN
832: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
833: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_FROMDT_GTR_TODT');
834: Fnd_Msg_Pub.ADD;
835: END IF;
836: x_return_status := Fnd_Api.g_ret_sts_error;

Line 834: Fnd_Msg_Pub.ADD;

830:
831: IF l_assign_start_date > l_assign_end_date THEN
832: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
833: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_FROMDT_GTR_TODT');
834: Fnd_Msg_Pub.ADD;
835: END IF;
836: x_return_status := Fnd_Api.g_ret_sts_error;
837: RETURN;
838: END IF;

Line 853: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

849: IF l_actual_start_date is not null or l_actual_end_date is not null THEN
850:
851: IF l_actual_start_date is not null and l_assign_start_date < l_actual_start_date THEN
852:
853: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
854: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_EARLY_ACTUAL');
855: Fnd_Msg_Pub.ADD;
856: END IF;
857: x_return_status := Fnd_Api.g_ret_sts_error;

Line 855: Fnd_Msg_Pub.ADD;

851: IF l_actual_start_date is not null and l_assign_start_date < l_actual_start_date THEN
852:
853: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
854: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_EARLY_ACTUAL');
855: Fnd_Msg_Pub.ADD;
856: END IF;
857: x_return_status := Fnd_Api.g_ret_sts_error;
858: RETURN;
859: END IF;

Line 863: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

859: END IF;
860:
861: IF l_actual_end_date is not null and l_assign_end_date > l_actual_end_date THEN
862:
863: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
864: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_LATER_ACTUAL');
865: Fnd_Msg_Pub.ADD;
866: END IF;
867: x_return_status := Fnd_Api.g_ret_sts_error;

Line 865: Fnd_Msg_Pub.ADD;

861: IF l_actual_end_date is not null and l_assign_end_date > l_actual_end_date THEN
862:
863: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
864: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_LATER_ACTUAL');
865: Fnd_Msg_Pub.ADD;
866: END IF;
867: x_return_status := Fnd_Api.g_ret_sts_error;
868: RETURN;
869: END IF;

Line 875: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

871: ELSE
872:
873: IF l_scheduled_start_date is not null and l_assign_start_date < l_scheduled_start_date THEN
874:
875: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
876: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_EARLY_SCHEDULE');
877: Fnd_Msg_Pub.ADD;
878: END IF;
879: x_return_status := Fnd_Api.g_ret_sts_error;

Line 877: Fnd_Msg_Pub.ADD;

873: IF l_scheduled_start_date is not null and l_assign_start_date < l_scheduled_start_date THEN
874:
875: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
876: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_EARLY_SCHEDULE');
877: Fnd_Msg_Pub.ADD;
878: END IF;
879: x_return_status := Fnd_Api.g_ret_sts_error;
880: RETURN;
881: END IF;

Line 885: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

881: END IF;
882:
883: IF l_scheduled_end_date is not null and l_assign_end_date > l_scheduled_end_date THEN
884:
885: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
886: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_LATER_SCHEDULE');
887: Fnd_Msg_Pub.ADD;
888: END IF;
889: x_return_status := Fnd_Api.g_ret_sts_error;

Line 887: Fnd_Msg_Pub.ADD;

883: IF l_scheduled_end_date is not null and l_assign_end_date > l_scheduled_end_date THEN
884:
885: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
886: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_LATER_SCHEDULE');
887: Fnd_Msg_Pub.ADD;
888: END IF;
889: x_return_status := Fnd_Api.g_ret_sts_error;
890: RETURN;
891: END IF;

Line 910: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

906:
907: END IF;
908: /*
909: IF trunc(l_assign_start_date) < trunc(l_eff_st_date) THEN
910: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
911: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_STDT_GTR_EMP_STDT');
912: Fnd_Msg_Pub.ADD;
913: END IF;
914: x_return_status := Fnd_Api.g_ret_sts_error;

Line 912: Fnd_Msg_Pub.ADD;

908: /*
909: IF trunc(l_assign_start_date) < trunc(l_eff_st_date) THEN
910: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
911: Fnd_Message.set_name ('AHL', 'AHL_PP_ASG_STDT_GTR_EMP_STDT');
912: Fnd_Msg_Pub.ADD;
913: END IF;
914: x_return_status := Fnd_Api.g_ret_sts_error;
915: RETURN;
916: END IF;

Line 919: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

915: RETURN;
916: END IF;
917: */
918: IF trunc(l_assign_end_date) > trunc(l_eff_end_date) THEN
919: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
920: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_ENDDT_GTR_ASG_ENDDT');
921: Fnd_Msg_Pub.ADD;
922: END IF;
923: x_return_status := Fnd_Api.g_ret_sts_error;

Line 921: Fnd_Msg_Pub.ADD;

917: */
918: IF trunc(l_assign_end_date) > trunc(l_eff_end_date) THEN
919: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
920: Fnd_Message.set_name ('AHL', 'AHL_PP_EMP_ENDDT_GTR_ASG_ENDDT');
921: Fnd_Msg_Pub.ADD;
922: END IF;
923: x_return_status := Fnd_Api.g_ret_sts_error;
924: RETURN;
925: END IF;

Line 929: Fnd_Msg_Pub.count_and_get (

925: END IF;
926: END IF;
927:
928: -------------------- finish --------------------------
929: Fnd_Msg_Pub.count_and_get (
930: p_encoded => Fnd_Api.g_false,
931: p_count => x_msg_count,
932: p_data => x_msg_data
933: );

Line 947: Fnd_Msg_Pub.count_and_get (

943:
944: EXCEPTION
945: WHEN Fnd_Api.g_exc_error THEN
946: x_return_status := Fnd_Api.g_ret_sts_error;
947: Fnd_Msg_Pub.count_and_get (
948: p_encoded => Fnd_Api.g_false,
949: p_count => x_msg_count,
950: p_data => x_msg_data
951: );

Line 954: Fnd_Msg_Pub.count_and_get (

950: p_data => x_msg_data
951: );
952: WHEN Fnd_Api.g_exc_unexpected_error THEN
953: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
954: Fnd_Msg_Pub.count_and_get (
955: p_encoded => Fnd_Api.g_false,
956: p_count => x_msg_count,
957: p_data => x_msg_data
958: );

Line 961: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

957: p_data => x_msg_data
958: );
959: WHEN OTHERS THEN
960: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
961: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
962: THEN
963: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
964: END IF;
965:

Line 963: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

959: WHEN OTHERS THEN
960: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
961: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
962: THEN
963: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
964: END IF;
965:
966: Fnd_Msg_Pub.count_and_get (
967: p_encoded => Fnd_Api.g_false,

Line 966: Fnd_Msg_Pub.count_and_get (

962: THEN
963: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
964: END IF;
965:
966: Fnd_Msg_Pub.count_and_get (
967: p_encoded => Fnd_Api.g_false,
968: p_count => x_msg_count,
969: p_data => x_msg_data
970: );

Line 1216: FND_MSG_PUB.initialize;

1212:
1213: -- Standard call to check for call compatibility.
1214: IF FND_API.to_boolean(p_init_msg_list)
1215: THEN
1216: FND_MSG_PUB.initialize;
1217: END IF;
1218:
1219: -- Initialize API return status to success
1220: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1259: Fnd_Msg_Pub.ADD;

1255: FETCH c_oper_resrc INTO l_oper_resrc_id, l_wo_operation_id,l_resource_id;
1256: IF c_oper_resrc%NOTFOUND THEN
1257: AHL_DEBUG_PUB.debug(l_full_name || 'c_oper_resrc i.e Cursor not found');
1258: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_REQ_NOT_EXISTS');
1259: Fnd_Msg_Pub.ADD;
1260: RAISE Fnd_Api.G_EXC_ERROR;
1261: END IF;
1262: CLOSE c_oper_resrc;
1263:

Line 1267: Fnd_Msg_Pub.ADD;

1263:
1264: END IF; -- Check resrc sequence number
1265: ELSE
1266: Fnd_Message.SET_NAME('AHL','AHL_PP_JOB_NOT_EXISTS');
1267: Fnd_Msg_Pub.ADD;
1268: END IF; -- Check of work order id
1269:
1270: -- rroy
1271: -- ACL Changes

Line 1278: FND_MSG_PUB.ADD;

1274: p_visit_id => NULL,
1275: p_item_instance_id => NULL);
1276: IF l_return_status = FND_API.G_TRUE THEN
1277: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_RESASG_UNTLCKD');
1278: FND_MSG_PUB.ADD;
1279: RAISE FND_API.G_EXC_ERROR;
1280: END IF;
1281: -- rroy
1282: -- ACL Changes

Line 1307: Fnd_Msg_Pub.ADD;

1303: END IF;
1304:
1305: CLOSE c_resource;
1306: Fnd_Message.SET_NAME('AHL','AHL_PP_NO_RES_TYPE_FOUND');
1307: Fnd_Msg_Pub.ADD;
1308: RAISE Fnd_Api.G_EXC_ERROR;
1309: END IF;
1310:
1311: Ahl_Debug_Pub.debug( 'l_resource_type = ' || l_resource_type);

Line 1442: Fnd_Msg_Pub.ADD;

1438: Ot
1439: (l_Resrc_Assign_Rec.employee_name IS NOT NULL AND l_Resrc_Assign_Rec.employee_name <> Fnd_Api.G_MISS_CHAR))
1440: THEN
1441: Fnd_Message.SET_NAME('AHL','AHL_PP_EMPLOYEE_NOT_REQ');
1442: Fnd_Msg_Pub.ADD;
1443: RAISE Fnd_Api.G_EXC_ERROR;
1444: END IF;*/
1445:
1446: -- Convert serial number to instance/ serial id

Line 1473: Fnd_Msg_Pub.ADD;

1469:
1470: IF NVL(l_return_status,'x') <> 'S'
1471: THEN
1472: Fnd_Message.SET_NAME('AHL','AHL_PP_SERIAL_NOT_EXISTS');
1473: Fnd_Msg_Pub.ADD;
1474: RAISE Fnd_Api.G_EXC_ERROR;
1475: END IF;
1476: END IF;
1477:

Line 1500: Fnd_Msg_Pub.ADD;

1496:
1497: /*IF (l_Resrc_Assign_Rec.serial_number IS NOT NULL AND l_Resrc_Assign_Rec.serial_number <> Fnd_Api.G_MISS_CHAR)
1498: THEN
1499: Fnd_Message.SET_NAME('AHL','AHL_PP_EMPLOYEE_NOT_REQ');
1500: Fnd_Msg_Pub.ADD;
1501: RAISE Fnd_Api.G_EXC_ERROR;
1502: END IF;*/
1503: IF G_DEBUG='Y' THEN
1504: AHL_DEBUG_PUB.debug(l_full_name || 'RESOURCE TYPE in record -- ' || p_x_resrc_assign_tbl(i).resource_type_code);

Line 1529: Fnd_Msg_Pub.ADD;

1525:
1526: IF NVL(l_return_status, 'X') <> 'S'
1527: THEN
1528: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NUM_NOT_EXISTS');
1529: Fnd_Msg_Pub.ADD;
1530: RAISE Fnd_Api.G_EXC_ERROR;
1531: END IF;
1532:
1533: END IF;

Line 1557: Fnd_Msg_Pub.ADD;

1553:
1554: IF NVL(l_return_status, 'X') <> 'S'
1555: THEN
1556: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');
1557: Fnd_Msg_Pub.ADD;
1558: RAISE Fnd_Api.G_EXC_ERROR;
1559: END IF;
1560:
1561: IF p_x_resrc_assign_tbl(i).employee_id <> l_employee_id THEN

Line 1563: Fnd_Msg_Pub.ADD;

1559: END IF;
1560:
1561: IF p_x_resrc_assign_tbl(i).employee_id <> l_employee_id THEN
1562: Fnd_Message.SET_NAME('AHL','AHL_PP_USE_EMP_NAME_LOV');
1563: Fnd_Msg_Pub.ADD;
1564: END IF;
1565:
1566: IF p_x_resrc_assign_tbl(i).employee_name <> l_employee_name THEN
1567: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');

Line 1568: Fnd_Msg_Pub.ADD;

1564: END IF;
1565:
1566: IF p_x_resrc_assign_tbl(i).employee_name <> l_employee_name THEN
1567: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');
1568: Fnd_Msg_Pub.ADD;
1569: END IF;
1570:
1571: --
1572: p_x_resrc_assign_tbl(i).employee_id := l_employee_id;

Line 1611: l_msg_count := Fnd_Msg_Pub.count_msg;

1607:
1608: END LOOP;
1609: END IF;
1610: --Standard check to count messages
1611: l_msg_count := Fnd_Msg_Pub.count_msg;
1612:
1613: IF l_msg_count > 0 THEN
1614: X_msg_count := l_msg_count;
1615: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1816: l_msg_count := Fnd_Msg_Pub.count_msg;

1812: l_Resrc_Assign_tbl(i).attribute15 := p_x_resrc_assign_tbl(i).attribute15;
1813: END IF;
1814:
1815: --Standard check to count messages
1816: l_msg_count := Fnd_Msg_Pub.count_msg;
1817:
1818: IF l_msg_count > 0 THEN
1819: X_msg_count := l_msg_count;
1820: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1836: Fnd_Msg_Pub.ADD;

1832: CLOSE Sch_id_exists;
1833: --
1834: IF l_dummy IS NOT NULL THEN
1835: Fnd_Message.SET_NAME('AHL','AHL_PP_SEQUENCE_NO_EXISTS');
1836: Fnd_Msg_Pub.ADD;
1837: RAISE FND_API.G_EXC_ERROR;
1838: END IF;
1839:
1840:

Line 1885: l_msg_count := Fnd_Msg_Pub.count_msg;

1881: END IF; -- Count > 0
1882: END IF; -- Return status from Eam Api
1883: ------------------------End of Body---------------------------------------
1884: --Standard check to count messages
1885: l_msg_count := Fnd_Msg_Pub.count_msg;
1886:
1887: IF l_msg_count > 0 THEN
1888: X_msg_count := l_msg_count;
1889: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1908: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1904: EXCEPTION
1905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1906: ROLLBACK TO Create_Resrc_Assign;
1907: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1908: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1909: p_count => x_msg_count,
1910: p_data => x_msg_data);
1911:
1912: IF G_DEBUG='Y' THEN

Line 1923: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1919:
1920: WHEN FND_API.G_EXC_ERROR THEN
1921: ROLLBACK TO Create_Resrc_Assign;
1922: X_return_status := FND_API.G_RET_STS_ERROR;
1923: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1924: p_count => x_msg_count,
1925: p_data => X_msg_data);
1926: IF G_DEBUG='Y' THEN
1927: -- Debug info.

Line 1938: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1934:
1935: WHEN OTHERS THEN
1936: ROLLBACK TO Create_Resrc_Assign;
1937: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1939: THEN
1940: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
1941: p_procedure_name => 'CREATE_Resrc_Assign',
1942: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1940: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',

1936: ROLLBACK TO Create_Resrc_Assign;
1937: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1939: THEN
1940: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
1941: p_procedure_name => 'CREATE_Resrc_Assign',
1942: p_error_text => SUBSTR(SQLERRM,1,240));
1943: END IF;
1944: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1944: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1940: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
1941: p_procedure_name => 'CREATE_Resrc_Assign',
1942: p_error_text => SUBSTR(SQLERRM,1,240));
1943: END IF;
1944: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1945: p_count => x_msg_count,
1946: p_data => X_msg_data);
1947:
1948: IF G_DEBUG='Y' THEN

Line 2181: FND_MSG_PUB.initialize;

2177:
2178: -- Standard call to check for call compatibility.
2179: IF FND_API.to_boolean(p_init_msg_list)
2180: THEN
2181: FND_MSG_PUB.initialize;
2182: END IF;
2183:
2184: -- Initialize API return status to success
2185: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2244: FND_MSG_PUB.ADD;

2240: p_visit_id => NULL,
2241: p_item_instance_id => NULL);
2242: IF l_return_status = FND_API.G_TRUE THEN
2243: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_RESASG_UNTLCKD');
2244: FND_MSG_PUB.ADD;
2245: RAISE FND_API.G_EXC_ERROR;
2246: END IF;
2247:
2248: -- rroy

Line 2393: Fnd_Msg_Pub.ADD;

2389:
2390: IF NVL(l_return_status,'x') <> 'S'
2391: THEN
2392: Fnd_Message.SET_NAME('AHL','AHL_PP_SERIAL_NOT_EXISTS');
2393: Fnd_Msg_Pub.ADD;
2394: RAISE Fnd_Api.G_EXC_ERROR;
2395: END IF;
2396: END IF;
2397:

Line 2433: Fnd_Msg_Pub.ADD;

2429:
2430: IF NVL(l_return_status, 'X') <> 'S'
2431: THEN
2432: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NUM_NOT_EXISTS');
2433: Fnd_Msg_Pub.ADD;
2434: RAISE Fnd_Api.G_EXC_ERROR;
2435: END IF;
2436:
2437: -- For Employee Name

Line 2457: Fnd_Msg_Pub.ADD;

2453:
2454: IF NVL(l_return_status, 'X') <> 'S'
2455: THEN
2456: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');
2457: Fnd_Msg_Pub.ADD;
2458: RAISE Fnd_Api.G_EXC_ERROR;
2459: END IF;
2460:
2461: IF p_x_resrc_assign_tbl(i).employee_id <> l_employee_id THEN

Line 2463: Fnd_Msg_Pub.ADD;

2459: END IF;
2460:
2461: IF p_x_resrc_assign_tbl(i).employee_id <> l_employee_id THEN
2462: Fnd_Message.SET_NAME('AHL','AHL_PP_USE_EMP_NAME_LOV');
2463: Fnd_Msg_Pub.ADD;
2464: END IF;
2465:
2466: IF p_x_resrc_assign_tbl(i).employee_name <> l_employee_name THEN
2467: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');

Line 2468: Fnd_Msg_Pub.ADD;

2464: END IF;
2465:
2466: IF p_x_resrc_assign_tbl(i).employee_name <> l_employee_name THEN
2467: Fnd_Message.SET_NAME('AHL','AHL_PP_EMP_NAME_NOT_EXISTS');
2468: Fnd_Msg_Pub.ADD;
2469: END IF;
2470: END IF;
2471: END IF;
2472: --Assign

Line 2511: l_msg_count := Fnd_Msg_Pub.count_msg;

2507: END LOOP;
2508: END IF;
2509:
2510: --Standard check to count messages
2511: l_msg_count := Fnd_Msg_Pub.count_msg;
2512:
2513: IF l_msg_count > 0 THEN
2514: X_msg_count := l_msg_count;
2515: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2589: Fnd_Msg_Pub.ADD;

2585: -- Check Object version number.
2586: IF (p_x_resrc_assign_tbl(i).object_version_number <> c_assign_rec.object_version_number) THEN
2587: AHL_DEBUG_PUB.debug(l_full_name || 'Inside OVN comparison');
2588: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2589: Fnd_Msg_Pub.ADD;
2590: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2591: END IF;
2592:
2593: IF p_x_resrc_assign_tbl(i).Assignment_id <> FND_API.G_MISS_NUM THEN

Line 2772: l_msg_count := Fnd_Msg_Pub.count_msg;

2768: END IF;
2769: */
2770:
2771: --Standard check to count messages
2772: l_msg_count := Fnd_Msg_Pub.count_msg;
2773:
2774: IF l_msg_count > 0 THEN
2775: x_msg_count := l_msg_count;
2776: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2829: l_msg_count := Fnd_Msg_Pub.count_msg;

2825:
2826: END IF; -- Return status from Ahl Eam Api
2827: ------------------------End of Body---------------------------------------
2828: --Standard check to count messages
2829: l_msg_count := Fnd_Msg_Pub.count_msg;
2830:
2831: IF l_msg_count > 0 THEN
2832: X_msg_count := l_msg_count;
2833: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2852: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2848: EXCEPTION
2849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2850: ROLLBACK TO update_Resrc_Assign;
2851: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2852: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2853: p_count => x_msg_count,
2854: p_data => x_msg_data);
2855: IF G_DEBUG='Y' THEN
2856: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data, 'ERROR' );

Line 2865: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2861: END IF;
2862: WHEN FND_API.G_EXC_ERROR THEN
2863: ROLLBACK TO update_Resrc_Assign;
2864: X_return_status := FND_API.G_RET_STS_ERROR;
2865: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2866: p_count => x_msg_count,
2867: p_data => X_msg_data);
2868: IF G_DEBUG='Y' THEN
2869: -- Debug info.

Line 2879: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2875: END IF;
2876: WHEN OTHERS THEN
2877: ROLLBACK TO update_Resrc_Assign;
2878: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2879: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2880: THEN
2881: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
2882: p_procedure_name => 'UPDATE_Resrc_Assign',
2883: p_error_text => SUBSTR(SQLERRM,1,240));

Line 2881: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',

2877: ROLLBACK TO update_Resrc_Assign;
2878: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2879: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2880: THEN
2881: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
2882: p_procedure_name => 'UPDATE_Resrc_Assign',
2883: p_error_text => SUBSTR(SQLERRM,1,240));
2884: END IF;
2885: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2885: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2881: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
2882: p_procedure_name => 'UPDATE_Resrc_Assign',
2883: p_error_text => SUBSTR(SQLERRM,1,240));
2884: END IF;
2885: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2886: p_count => x_msg_count,
2887: p_data => X_msg_data);
2888:
2889: IF G_DEBUG='Y' THEN

Line 2972: Fnd_Msg_Pub.initialize;

2968: END IF;
2969: -- Standard call to check for call compatibility.
2970: IF Fnd_Api.to_boolean(p_init_msg_list)
2971: THEN
2972: Fnd_Msg_Pub.initialize;
2973: END IF;
2974:
2975: -- Initialize API return status to success
2976: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 3000: Fnd_Msg_Pub.ADD;

2996: OPEN get_resrc_assign_cur(p_x_resrc_assign_tbl(i).assignment_id);
2997: FETCH get_resrc_assign_cur INTO l_resrc_assign_rec;
2998: IF get_resrc_assign_cur%NOTFOUND THEN
2999: Fnd_Message.Set_Name('AHL','AHL_COM_INVALID_RECORD');
3000: Fnd_Msg_Pub.ADD;
3001: CLOSE get_resrc_assign_cur;
3002: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3003: END IF;
3004: --

Line 3011: Fnd_Msg_Pub.ADD;

3007: --Check for object version number
3008: IF p_x_resrc_assign_tbl(i).object_version_number <> l_resrc_assign_rec.object_version_number
3009: THEN
3010: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
3011: Fnd_Msg_Pub.ADD;
3012: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3013: END IF;
3014: --
3015: -- Get Wip entity ,operation resource details

Line 3047: l_msg_count := Fnd_Msg_Pub.count_msg;

3043: END LOOP;
3044: END IF;
3045:
3046: --Standard check to count messages
3047: l_msg_count := Fnd_Msg_Pub.count_msg;
3048:
3049: IF l_msg_count > 0 THEN
3050: x_msg_count := l_msg_count;
3051: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3108: l_msg_count := Fnd_Msg_Pub.count_msg;

3104:
3105: END IF;
3106: ---------------------------End of Body---------------------------------------
3107: --Standard check to count messages
3108: l_msg_count := Fnd_Msg_Pub.count_msg;
3109:
3110: IF l_msg_count > 0 THEN
3111: X_msg_count := l_msg_count;
3112: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3131: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

3127: EXCEPTION
3128: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3129: ROLLBACK TO Remove_Resource_Assignment;
3130: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3131: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3132: p_count => x_msg_count,
3133: p_data => x_msg_data);
3134: IF G_DEBUG='Y' THEN
3135: Ahl_Debug_Pub.log_app_messages (

Line 3145: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

3141:
3142: WHEN Fnd_Api.G_EXC_ERROR THEN
3143: ROLLBACK TO remove_Resource_Assignment;
3144: X_return_status := Fnd_Api.G_RET_STS_ERROR;
3145: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3146: p_count => x_msg_count,
3147: p_data => X_msg_data);
3148: IF G_DEBUG='Y' THEN
3149: -- Debug info.

Line 3160: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

3156:
3157: WHEN OTHERS THEN
3158: ROLLBACK TO remove_Resource_Assignment;
3159: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3160: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3161: THEN
3162: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
3163: p_procedure_name => 'REMOVE_Resource_Assignment',
3164: p_error_text => SUBSTR(SQLERRM,1,240));

Line 3162: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',

3158: ROLLBACK TO remove_Resource_Assignment;
3159: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3160: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3161: THEN
3162: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
3163: p_procedure_name => 'REMOVE_Resource_Assignment',
3164: p_error_text => SUBSTR(SQLERRM,1,240));
3165: END IF;
3166: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 3166: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

3162: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
3163: p_procedure_name => 'REMOVE_Resource_Assignment',
3164: p_error_text => SUBSTR(SQLERRM,1,240));
3165: END IF;
3166: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
3167: p_count => x_msg_count,
3168: p_data => X_msg_data);
3169: IF G_DEBUG='Y' THEN
3170: -- Debug info.

Line 3247: FND_MSG_PUB.initialize;

3243: END IF;
3244: -- Standard call to check for call compatibility.
3245: IF FND_API.to_boolean(p_init_msg_list)
3246: THEN
3247: FND_MSG_PUB.initialize;
3248: END IF;
3249:
3250: -- Initialize API return status to success
3251: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3321: l_msg_count := Fnd_Msg_Pub.count_msg;

3317: END IF;
3318: END IF;
3319: ------------------------End of Body---------------------------------------
3320: --Standard check to count messages
3321: l_msg_count := Fnd_Msg_Pub.count_msg;
3322:
3323: IF l_msg_count > 0 THEN
3324: x_msg_count := l_msg_count;
3325: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3347: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3343: EXCEPTION
3344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3345: ROLLBACK TO Process_Resrc_Assign;
3346: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3347: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3348: p_count => x_msg_count,
3349: p_data => x_msg_data);
3350: IF G_DEBUG='Y' THEN
3351: AHL_DEBUG_PUB.log_app_messages (

Line 3360: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3356:
3357: WHEN FND_API.G_EXC_ERROR THEN
3358: ROLLBACK TO Process_Resrc_Assign;
3359: X_return_status := FND_API.G_RET_STS_ERROR;
3360: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3361: p_count => x_msg_count,
3362: p_data => X_msg_data);
3363: IF G_DEBUG='Y' THEN
3364: -- Debug info.

Line 3373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3369: END IF;
3370: WHEN OTHERS THEN
3371: ROLLBACK TO Process_Resrc_Assign;
3372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3374: THEN
3375: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
3376: p_procedure_name => 'Process_Resrc_Assign',
3377: p_error_text => SUBSTR(SQLERRM,1,240));

Line 3375: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',

3371: ROLLBACK TO Process_Resrc_Assign;
3372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3374: THEN
3375: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
3376: p_procedure_name => 'Process_Resrc_Assign',
3377: p_error_text => SUBSTR(SQLERRM,1,240));
3378: END IF;
3379: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3379: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3375: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_PP_RESRC_ASSIGN_PVT',
3376: p_procedure_name => 'Process_Resrc_Assign',
3377: p_error_text => SUBSTR(SQLERRM,1,240));
3378: END IF;
3379: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3380: p_count => x_msg_count,
3381: p_data => X_msg_data);
3382: IF G_DEBUG='Y' THEN
3383: -- Debug info.