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_WF_MAPPING_PVT dependencies on FND_MSG_PUB

Line 101: Fnd_Msg_Pub.initialize;

97: Ahl_Debug_Pub.debug( l_full_name ||':Start');
98: END IF;
99:
100: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
101: Fnd_Msg_Pub.initialize;
102: END IF;
103: IF NOT Fnd_Api.compatible_api_call (
104: L_API_VERSION,
105: p_api_version,

Line 177: Fnd_Msg_Pub.count_and_get(

173: -- Standard check of p_commit.
174: IF Fnd_Api.To_Boolean ( p_commit ) THEN
175: COMMIT WORK;
176: END IF;
177: Fnd_Msg_Pub.count_and_get(
178: p_encoded => Fnd_Api.g_false,
179: p_count => x_msg_count,
180: p_data => x_msg_data
181: );

Line 194: Fnd_Msg_Pub.count_and_get(

190: EXCEPTION
191: WHEN Fnd_Api.g_exc_error THEN
192: ROLLBACK TO Process_Wf_Mapping;
193: x_return_status := Fnd_Api.g_ret_sts_error;
194: Fnd_Msg_Pub.count_and_get(
195: p_encoded => Fnd_Api.g_false,
196: p_count => x_msg_count,
197: p_data => x_msg_data
198: );

Line 202: Fnd_Msg_Pub.count_and_get (

198: );
199: WHEN Fnd_Api.g_exc_unexpected_error THEN
200: ROLLBACK TO Process_Wf_Mapping;
201: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
202: Fnd_Msg_Pub.count_and_get (
203: p_encoded => Fnd_Api.g_false,
204: p_count => x_msg_count,
205: p_data => x_msg_data
206: );

Line 210: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN

206: );
207: WHEN OTHERS THEN
208: ROLLBACK TO Process_Wf_Mapping;
209: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
210: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
211: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
212: END IF;
213: Fnd_Msg_Pub.count_and_get (
214: p_encoded => Fnd_Api.g_false,

Line 211: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);

207: WHEN OTHERS THEN
208: ROLLBACK TO Process_Wf_Mapping;
209: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
210: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
211: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
212: END IF;
213: Fnd_Msg_Pub.count_and_get (
214: p_encoded => Fnd_Api.g_false,
215: p_count => x_msg_count,

Line 213: Fnd_Msg_Pub.count_and_get (

209: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
210: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
211: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
212: END IF;
213: Fnd_Msg_Pub.count_and_get (
214: p_encoded => Fnd_Api.g_false,
215: p_count => x_msg_count,
216: p_data => x_msg_data
217: );

Line 291: Fnd_Msg_Pub.initialize;

287: Ahl_Debug_Pub.debug( l_full_name ||':Start');
288: END IF;
289:
290: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
291: Fnd_Msg_Pub.initialize;
292: END IF;
293: IF NOT Fnd_Api.compatible_api_call (
294: L_API_VERSION,
295: p_api_version,

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

395: ELSE
396: OPEN c_appl_usg;
397: FETCH c_appl_usg INTO l_Wf_Mapping_rec.Application_Usg_Code;
398: IF c_appl_usg%NOTFOUND THEN
399: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
400: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
401: Fnd_Msg_Pub.ADD;
402: END IF;
403: RAISE Fnd_Api.g_exc_unexpected_error;

Line 401: Fnd_Msg_Pub.ADD;

397: FETCH c_appl_usg INTO l_Wf_Mapping_rec.Application_Usg_Code;
398: IF c_appl_usg%NOTFOUND THEN
399: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
400: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
401: Fnd_Msg_Pub.ADD;
402: END IF;
403: RAISE Fnd_Api.g_exc_unexpected_error;
404: END IF;
405: END IF;

Line 443: Fnd_Msg_Pub.count_and_get(

439: -- Standard check of p_commit.
440: IF Fnd_Api.To_Boolean ( p_commit ) THEN
441: COMMIT WORK;
442: END IF;
443: Fnd_Msg_Pub.count_and_get(
444: p_encoded => Fnd_Api.g_false,
445: p_count => x_msg_count,
446: p_data => x_msg_data
447: );

Line 458: Fnd_Msg_Pub.count_and_get(

454: EXCEPTION
455: WHEN Fnd_Api.g_exc_error THEN
456: ROLLBACK TO Create_Wf_Mapping;
457: x_return_status := Fnd_Api.g_ret_sts_error;
458: Fnd_Msg_Pub.count_and_get(
459: p_encoded => Fnd_Api.g_false,
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );

Line 466: Fnd_Msg_Pub.count_and_get (

462: );
463: WHEN Fnd_Api.g_exc_unexpected_error THEN
464: ROLLBACK TO Create_Wf_Mapping;
465: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
466: Fnd_Msg_Pub.count_and_get (
467: p_encoded => Fnd_Api.g_false,
468: p_count => x_msg_count,
469: p_data => x_msg_data
470: );

Line 474: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN

470: );
471: WHEN OTHERS THEN
472: ROLLBACK TO Create_Wf_Mapping;
473: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
474: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
475: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
476: END IF;
477: Fnd_Msg_Pub.count_and_get (
478: p_encoded => Fnd_Api.g_false,

Line 475: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);

471: WHEN OTHERS THEN
472: ROLLBACK TO Create_Wf_Mapping;
473: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
474: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
475: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
476: END IF;
477: Fnd_Msg_Pub.count_and_get (
478: p_encoded => Fnd_Api.g_false,
479: p_count => x_msg_count,

Line 477: Fnd_Msg_Pub.count_and_get (

473: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
474: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error) THEN
475: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
476: END IF;
477: Fnd_Msg_Pub.count_and_get (
478: p_encoded => Fnd_Api.g_false,
479: p_count => x_msg_count,
480: p_data => x_msg_data
481: );

Line 536: Fnd_Msg_Pub.initialize;

532: IF G_DEBUG='Y' THEN
533: Ahl_Debug_Pub.debug( l_full_name ||':Start');
534: END IF;
535: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
536: Fnd_Msg_Pub.initialize;
537: END IF;
538: IF NOT Fnd_Api.compatible_api_call(
539: l_api_version,
540: p_api_version,

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

617: ELSE
618: OPEN c_appl_usg;
619: FETCH c_appl_usg INTO l_Wf_Mapping_rec.Application_Usg_Code;
620: IF c_appl_usg%NOTFOUND THEN
621: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
622: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
623: Fnd_Msg_Pub.ADD;
624: END IF;
625: RAISE Fnd_Api.g_exc_unexpected_error;

Line 623: Fnd_Msg_Pub.ADD;

619: FETCH c_appl_usg INTO l_Wf_Mapping_rec.Application_Usg_Code;
620: IF c_appl_usg%NOTFOUND THEN
621: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
622: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
623: Fnd_Msg_Pub.ADD;
624: END IF;
625: RAISE Fnd_Api.g_exc_unexpected_error;
626: END IF;
627: END IF;

Line 653: Fnd_Msg_Pub.count_and_get (

649: -------------------- finish --------------------------
650: IF Fnd_Api.to_boolean (p_commit) THEN
651: COMMIT;
652: END IF;
653: Fnd_Msg_Pub.count_and_get (
654: p_encoded => Fnd_Api.g_false,
655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );

Line 669: Fnd_Msg_Pub.count_and_get (

665: EXCEPTION
666: WHEN Fnd_Api.g_exc_error THEN
667: ROLLBACK TO Update_Wf_Mapping;
668: x_return_status := Fnd_Api.g_ret_sts_error;
669: Fnd_Msg_Pub.count_and_get (
670: p_encoded => Fnd_Api.g_false,
671: p_count => x_msg_count,
672: p_data => x_msg_data
673: );

Line 677: Fnd_Msg_Pub.count_and_get (

673: );
674: WHEN Fnd_Api.g_exc_unexpected_error THEN
675: ROLLBACK TO Update_Wf_Mapping;
676: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
677: Fnd_Msg_Pub.count_and_get (
678: p_encoded => Fnd_Api.g_false,
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );

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

681: );
682: WHEN OTHERS THEN
683: ROLLBACK TO Update_Wf_Mapping;
684: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
685: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
686: THEN
687: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
688: END IF;
689: Fnd_Msg_Pub.count_and_get (

Line 687: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);

683: ROLLBACK TO Update_Wf_Mapping;
684: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
685: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
686: THEN
687: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
688: END IF;
689: Fnd_Msg_Pub.count_and_get (
690: p_encoded => Fnd_Api.g_false,
691: p_count => x_msg_count,

Line 689: Fnd_Msg_Pub.count_and_get (

685: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
686: THEN
687: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
688: END IF;
689: Fnd_Msg_Pub.count_and_get (
690: p_encoded => Fnd_Api.g_false,
691: p_count => x_msg_count,
692: p_data => x_msg_data
693: );

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

759: EXIT WHEN cur_process_name%NOTFOUND;
760: Fetch cur_process_name into cur_process_name_rec;
761: END LOOP;
762: IF cur_process_name%ROWCOUNT = 0 THEN
763: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
764: Fnd_Message.set_name ('AHL', 'AHL_WF_NOT_PROCESS');
765: Fnd_Msg_Pub.ADD;
766: END IF;
767: x_return_status := Fnd_Api.g_ret_sts_error;

Line 765: Fnd_Msg_Pub.ADD;

761: END LOOP;
762: IF cur_process_name%ROWCOUNT = 0 THEN
763: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
764: Fnd_Message.set_name ('AHL', 'AHL_WF_NOT_PROCESS');
765: Fnd_Msg_Pub.ADD;
766: END IF;
767: x_return_status := Fnd_Api.g_ret_sts_error;
768: RETURN;
769: ELSIF cur_process_name%ROWCOUNT > 1 THEN

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

766: END IF;
767: x_return_status := Fnd_Api.g_ret_sts_error;
768: RETURN;
769: ELSIF cur_process_name%ROWCOUNT > 1 THEN
770: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
771: Fnd_Message.set_name ('AHL', 'AHL_WF_PROCESS_USELOV');
772: Fnd_Msg_Pub.ADD;
773: END IF;
774: x_return_status := Fnd_Api.g_ret_sts_error;

Line 772: Fnd_Msg_Pub.ADD;

768: RETURN;
769: ELSIF cur_process_name%ROWCOUNT > 1 THEN
770: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
771: Fnd_Message.set_name ('AHL', 'AHL_WF_PROCESS_USELOV');
772: Fnd_Msg_Pub.ADD;
773: END IF;
774: x_return_status := Fnd_Api.g_ret_sts_error;
775: RETURN;
776: END IF;

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

825: Open check_object(nvl(l_application_usg_code, 'AHL'));
826: Fetch check_object into l_count;
827: IF check_object%found THEN
828: Close check_object ;
829: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
830: Fnd_Message.set_name ('AHL', 'AHL_WF_DEFAULT_NOT_TWO');
831: Fnd_Msg_Pub.ADD;
832: END IF;
833: x_return_status := Fnd_Api.g_ret_sts_error;

Line 831: Fnd_Msg_Pub.ADD;

827: IF check_object%found THEN
828: Close check_object ;
829: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
830: Fnd_Message.set_name ('AHL', 'AHL_WF_DEFAULT_NOT_TWO');
831: Fnd_Msg_Pub.ADD;
832: END IF;
833: x_return_status := Fnd_Api.g_ret_sts_error;
834: RETURN;
835: ELSE

Line 887: Fnd_Msg_Pub.initialize;

883: IF G_DEBUG='Y' THEN
884: Ahl_Debug_Pub.debug( l_full_name ||':Start');
885: END IF;
886: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
887: Fnd_Msg_Pub.initialize;
888: END IF;
889: IF NOT Fnd_Api.compatible_api_call (
890: l_api_version,
891: p_api_version,

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

904: OPEN c_wf_mapping;
905: FETCH c_wf_mapping INTO l_wf_mapping_rec;
906: IF c_wf_mapping%NOTFOUND THEN
907: CLOSE c_wf_mapping;
908: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
909: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
910: Fnd_Msg_Pub.ADD;
911: END IF;
912: RAISE Fnd_Api.g_exc_error;

Line 910: Fnd_Msg_Pub.ADD;

906: IF c_wf_mapping%NOTFOUND THEN
907: CLOSE c_wf_mapping;
908: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
909: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
910: Fnd_Msg_Pub.ADD;
911: END IF;
912: RAISE Fnd_Api.g_exc_error;
913: END IF;
914: CLOSE c_wf_mapping;

Line 920: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)

916:
917: DELETE FROM Ahl_wf_mapping
918: WHERE wf_mapping_id = p_wf_mapping_id;
919: IF (SQL%NOTFOUND) THEN
920: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
921: THEN
922: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
923: Fnd_Msg_Pub.ADD;
924: END IF;

Line 923: Fnd_Msg_Pub.ADD;

919: IF (SQL%NOTFOUND) THEN
920: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)
921: THEN
922: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');
923: Fnd_Msg_Pub.ADD;
924: END IF;
925: RAISE Fnd_Api.g_exc_error;
926: END IF;
927:

Line 932: Fnd_Msg_Pub.count_and_get (

928: -------------------- finish --------------------------
929: IF Fnd_Api.to_boolean (p_commit) THEN
930: COMMIT;
931: END IF;
932: Fnd_Msg_Pub.count_and_get (
933: p_encoded => Fnd_Api.g_false,
934: p_count => x_msg_count,
935: p_data => x_msg_data
936: );

Line 948: Fnd_Msg_Pub.count_and_get (

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

Line 956: Fnd_Msg_Pub.count_and_get (

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

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

960: );
961: WHEN OTHERS THEN
962: ROLLBACK TO Delete_wf_mapping;
963: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
964: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
965: THEN
966: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
967: END IF;
968: Fnd_Msg_Pub.count_and_get (

Line 966: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);

962: ROLLBACK TO Delete_wf_mapping;
963: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
964: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
965: THEN
966: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
967: END IF;
968: Fnd_Msg_Pub.count_and_get (
969: p_encoded => Fnd_Api.g_false,
970: p_count => x_msg_count,

Line 968: Fnd_Msg_Pub.count_and_get (

964: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
965: THEN
966: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
967: END IF;
968: Fnd_Msg_Pub.count_and_get (
969: p_encoded => Fnd_Api.g_false,
970: p_count => x_msg_count,
971: p_data => x_msg_data
972: );

Line 1007: Fnd_Msg_Pub.initialize;

1003: IF G_DEBUG='Y' THEN
1004: Ahl_Debug_Pub.debug( l_full_name ||':Start');
1005: END IF;
1006: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1007: Fnd_Msg_Pub.initialize;
1008: END IF;
1009: IF NOT Fnd_Api.compatible_api_call (
1010: l_api_version,
1011: p_api_version,

Line 1040: Fnd_Msg_Pub.count_and_get (

1036: Ahl_Debug_Pub.debug( l_full_name ||':Check record');
1037: END IF;
1038:
1039: -------------------- finish --------------------------
1040: Fnd_Msg_Pub.count_and_get (
1041: p_encoded => Fnd_Api.g_false,
1042: p_count => x_msg_count,
1043: p_data => x_msg_data
1044: );

Line 1055: Fnd_Msg_Pub.count_and_get (

1051: END IF;
1052: EXCEPTION
1053: WHEN Fnd_Api.g_exc_error THEN
1054: x_return_status := Fnd_Api.g_ret_sts_error;
1055: Fnd_Msg_Pub.count_and_get (
1056: p_encoded => Fnd_Api.g_false,
1057: p_count => x_msg_count,
1058: p_data => x_msg_data
1059: );

Line 1062: Fnd_Msg_Pub.count_and_get (

1058: p_data => x_msg_data
1059: );
1060: WHEN Fnd_Api.g_exc_unexpected_error THEN
1061: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1062: Fnd_Msg_Pub.count_and_get (
1063: p_encoded => Fnd_Api.g_false,
1064: p_count => x_msg_count,
1065: p_data => x_msg_data
1066: );

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

1065: p_data => x_msg_data
1066: );
1067: WHEN OTHERS THEN
1068: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1069: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1070: THEN
1071: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
1072: END IF;
1073: Fnd_Msg_Pub.count_and_get (

Line 1071: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);

1067: WHEN OTHERS THEN
1068: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1069: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1070: THEN
1071: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
1072: END IF;
1073: Fnd_Msg_Pub.count_and_get (
1074: p_encoded => Fnd_Api.g_false,
1075: p_count => x_msg_count,

Line 1073: Fnd_Msg_Pub.count_and_get (

1069: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
1070: THEN
1071: Fnd_Msg_Pub.add_exc_msg (g_pkg_name, l_api_name);
1072: END IF;
1073: Fnd_Msg_Pub.count_and_get (
1074: p_encoded => Fnd_Api.g_false,
1075: p_count => x_msg_count,
1076: p_data => x_msg_data
1077: );

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

1126: OPEN chk_appl_usg_code ;
1127: FETCH chk_appl_usg_code INTO l_count;
1128: IF chk_appl_usg_code%NOTFOUND THEN
1129: CLOSE chk_appl_usg_code;
1130: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1131: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
1132: Fnd_Msg_Pub.ADD;
1133: END IF;
1134: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1132: Fnd_Msg_Pub.ADD;

1128: IF chk_appl_usg_code%NOTFOUND THEN
1129: CLOSE chk_appl_usg_code;
1130: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1131: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');
1132: Fnd_Msg_Pub.ADD;
1133: END IF;
1134: x_return_status := Fnd_Api.g_ret_sts_error;
1135: RETURN;
1136: ELSE

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

1180: OPEN c_Wf_Mapping;
1181: FETCH c_Wf_Mapping INTO l_Wf_Mapping_rec;
1182: IF c_Wf_Mapping%NOTFOUND THEN
1183: CLOSE c_Wf_Mapping;
1184: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1185: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
1186: Fnd_Msg_Pub.ADD;
1187: END IF;
1188: RAISE Fnd_Api.g_exc_error;

Line 1186: Fnd_Msg_Pub.ADD;

1182: IF c_Wf_Mapping%NOTFOUND THEN
1183: CLOSE c_Wf_Mapping;
1184: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1185: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');
1186: Fnd_Msg_Pub.ADD;
1187: END IF;
1188: RAISE Fnd_Api.g_exc_error;
1189: END IF;
1190: CLOSE c_Wf_Mapping;

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

1227: BEGIN
1228: -- FOR PROCESS NAME IF ACTIVE_FLAG IS 'YES' THEN CANNOT BE NULL
1229: IF UPPER(p_Wf_Mapping_rec.ACTIVE_FLAG) = 'Y' THEN
1230: IF p_Wf_Mapping_rec.WF_DISPLAY_NAME IS NULL THEN
1231: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1232: Fnd_Message.set_name ('AHL', 'AHL_WF_PROCESS_NAME_MISSING');
1233: Fnd_Msg_Pub.ADD;
1234: END IF;
1235: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1233: Fnd_Msg_Pub.ADD;

1229: IF UPPER(p_Wf_Mapping_rec.ACTIVE_FLAG) = 'Y' THEN
1230: IF p_Wf_Mapping_rec.WF_DISPLAY_NAME IS NULL THEN
1231: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1232: Fnd_Message.set_name ('AHL', 'AHL_WF_PROCESS_NAME_MISSING');
1233: Fnd_Msg_Pub.ADD;
1234: END IF;
1235: x_return_status := Fnd_Api.g_ret_sts_error;
1236: RETURN;
1237: END IF;

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

1236: RETURN;
1237: END IF;
1238: END IF;
1239: IF p_Wf_Mapping_rec.APPLICATION_USG_CODE IS NULL THEN
1240: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1241: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_ISNULL');
1242: Fnd_Msg_Pub.ADD;
1243: END IF;
1244: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1242: Fnd_Msg_Pub.ADD;

1238: END IF;
1239: IF p_Wf_Mapping_rec.APPLICATION_USG_CODE IS NULL THEN
1240: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1241: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_ISNULL');
1242: Fnd_Msg_Pub.ADD;
1243: END IF;
1244: x_return_status := Fnd_Api.g_ret_sts_error;
1245: RETURN;
1246: END IF;

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

1274: 'AHL_Wf_Mapping',
1275: 'WF_Mapping_ID = ' || p_Wf_Mapping_rec.WF_Mapping_ID
1276: ) = Fnd_Api.g_false
1277: THEN
1278: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1279: Fnd_Message.set_name ('AHL', 'AHL_WF_MAPPING_DUP_ID');
1280: Fnd_Msg_Pub.ADD;
1281: END IF;
1282: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1280: Fnd_Msg_Pub.ADD;

1276: ) = Fnd_Api.g_false
1277: THEN
1278: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1279: Fnd_Message.set_name ('AHL', 'AHL_WF_MAPPING_DUP_ID');
1280: Fnd_Msg_Pub.ADD;
1281: END IF;
1282: x_return_status := Fnd_Api.g_ret_sts_error;
1283: RETURN;
1284: END IF;

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

1307: ''' AND APPLICATION_USG_CODE = ''' || p_Wf_Mapping_rec.application_usg_code ||
1308: ''' AND WF_Mapping_ID <> ' || p_Wf_Mapping_rec.WF_Mapping_ID );
1309: END IF;
1310: IF l_valid_flag = Fnd_Api.g_false THEN
1311: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1312: Fnd_Message.set_name ('AHL', 'AHL_WF_OBJECT_NOT_UNIQUE');
1313: Fnd_Msg_Pub.ADD;
1314: END IF;
1315: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1313: Fnd_Msg_Pub.ADD;

1309: END IF;
1310: IF l_valid_flag = Fnd_Api.g_false THEN
1311: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
1312: Fnd_Message.set_name ('AHL', 'AHL_WF_OBJECT_NOT_UNIQUE');
1313: Fnd_Msg_Pub.ADD;
1314: END IF;
1315: x_return_status := Fnd_Api.g_ret_sts_error;
1316: RETURN;
1317: END IF;