DBA Data[Home] [Help]

APPS.AHL_WF_MAPPING_PVT dependencies on FND_MESSAGE

Line 400: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');

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;
404: END IF;

Line 622: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');

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;
626: END IF;

Line 764: Fnd_Message.set_name ('AHL', 'AHL_WF_NOT_PROCESS');

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;
768: RETURN;

Line 771: Fnd_Message.set_name ('AHL', 'AHL_WF_PROCESS_USELOV');

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;
775: RETURN;

Line 830: Fnd_Message.set_name ('AHL', 'AHL_WF_DEFAULT_NOT_TWO');

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;
834: RETURN;

Line 909: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');

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;
913: END IF;

Line 922: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

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;
925: RAISE Fnd_Api.g_exc_error;
926: END IF;

Line 1131: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_INVALID');

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;
1135: RETURN;

Line 1185: Fnd_Message.set_name('AHL', 'AHL_API_RECORD_NOT_FOUND');

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;
1189: END IF;

Line 1232: Fnd_Message.set_name ('AHL', 'AHL_WF_PROCESS_NAME_MISSING');

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;
1236: RETURN;

Line 1241: Fnd_Message.set_name ('AHL', 'AHL_APPR_APPUSG_ISNULL');

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;
1245: RETURN;

Line 1279: Fnd_Message.set_name ('AHL', 'AHL_WF_MAPPING_DUP_ID');

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;
1283: RETURN;

Line 1312: Fnd_Message.set_name ('AHL', 'AHL_WF_OBJECT_NOT_UNIQUE');

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;
1316: RETURN;