DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_VALUES_PVT dependencies on FND_MESSAGE

Line 149: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

145: );
146:
147: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
150: fnd_msg_pub.add;
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153: END IF;

Line 175: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

171: );
172:
173: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
176: fnd_msg_pub.add;
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;
179: END IF;

Line 188: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

184: );
185:
186: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
189: fnd_msg_pub.add;
190: RAISE fnd_api.g_exc_unexpected_error;
191: END IF;
192:

Line 253: fnd_message.set_name ('JTF', 'JTF_RS_MDW_DUP_VALUE');

249: --Validate for Duplicate Resource Param ID, Resource ID, Value Type Combination
250: OPEN c_rs_values_dup;
251: FETCH c_rs_values_dup INTO l_check_char;
252: IF c_rs_values_dup%FOUND THEN
253: fnd_message.set_name ('JTF', 'JTF_RS_MDW_DUP_VALUE');
254: fnd_msg_pub.add;
255: x_return_status := fnd_api.g_ret_sts_unexp_error;
256: END IF;
257: CLOSE c_rs_values_dup;

Line 343: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

339: );
340:
341: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
342: x_return_status := fnd_api.g_ret_sts_unexp_error;
343: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
344: fnd_msg_pub.add;
345: RAISE fnd_api.g_exc_unexpected_error;
346: END IF;
347: END IF;

Line 374: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

370: );
371:
372: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
373: x_return_status := fnd_api.g_ret_sts_unexp_error;
374: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
375: fnd_msg_pub.add;
376: RAISE fnd_api.g_exc_unexpected_error;
377: END IF;
378: END IF;

Line 387: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

383: X_RETURN_STATUS => x_return_status
384: );
385: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
386: x_return_status := fnd_api.g_ret_sts_unexp_error;
387: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
388: fnd_msg_pub.add;
389: RAISE fnd_api.g_exc_unexpected_error;
390: END IF;
391:

Line 421: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

417: x_return_code => x_return_status);
418: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
419: --dbms_output.put_line('Returned Error status from the Message Generation API');
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
422: fnd_msg_pub.add;
423: RAISE fnd_api.g_exc_unexpected_error;
424: END IF;
425: END IF;

Line 582: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

578: );
579:
580: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
581: x_return_status := fnd_api.g_ret_sts_unexp_error;
582: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
583: fnd_msg_pub.add;
584: RAISE fnd_api.g_exc_unexpected_error;
585: END IF;
586: END IF;

Line 606: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

602: );
603:
604: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
605: x_return_status := fnd_api.g_ret_sts_unexp_error;
606: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
607: fnd_msg_pub.add;
608: RAISE fnd_api.g_exc_unexpected_error;
609: END IF;
610: END IF;

Line 619: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

615: X_RETURN_STATUS => x_return_status
616: );
617: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
618: x_return_status := fnd_api.g_ret_sts_unexp_error;
619: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
620: fnd_msg_pub.add;
621: RAISE fnd_api.g_exc_unexpected_error;
622: END IF;
623:

Line 632: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_VALUE_ID');

628: FETCH c_resource_param_value_id INTO l_resource_param_value_id;
629: IF c_resource_param_value_id%NOTFOUND THEN
630: --dbms_output.put_line('Resource Param Value Id not found');
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_VALUE_ID');
633: fnd_message.set_token('P_RESOURCE_PARAM_VALUE_ID', l_resource_param_value_id);
634: fnd_msg_pub.add;
635: CLOSE c_resource_param_value_id;
636: RAISE fnd_api.g_exc_unexpected_error;

Line 633: fnd_message.set_token('P_RESOURCE_PARAM_VALUE_ID', l_resource_param_value_id);

629: IF c_resource_param_value_id%NOTFOUND THEN
630: --dbms_output.put_line('Resource Param Value Id not found');
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_VALUE_ID');
633: fnd_message.set_token('P_RESOURCE_PARAM_VALUE_ID', l_resource_param_value_id);
634: fnd_msg_pub.add;
635: CLOSE c_resource_param_value_id;
636: RAISE fnd_api.g_exc_unexpected_error;
637: END IF;

Line 645: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_VALUE_ID');

641: FETCH c_resource_param_value_update INTO resource_param_value_rec;
642: IF c_resource_param_value_update%NOTFOUND THEN
643: CLOSE c_resource_param_value_update;
644: x_return_status := fnd_api.g_ret_sts_unexp_error;
645: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_VALUE_ID');
646: fnd_message.set_token('P_RESOURCE_PARAM_VALUE_ID', l_resource_param_value_id);
647: fnd_msg_pub.add;
648: RAISE fnd_api.g_exc_unexpected_error;
649: END IF;

Line 646: fnd_message.set_token('P_RESOURCE_PARAM_VALUE_ID', l_resource_param_value_id);

642: IF c_resource_param_value_update%NOTFOUND THEN
643: CLOSE c_resource_param_value_update;
644: x_return_status := fnd_api.g_ret_sts_unexp_error;
645: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_VALUE_ID');
646: fnd_message.set_token('P_RESOURCE_PARAM_VALUE_ID', l_resource_param_value_id);
647: fnd_msg_pub.add;
648: RAISE fnd_api.g_exc_unexpected_error;
649: END IF;
650:

Line 753: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

749: );
750:
751: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
752: x_return_status := fnd_api.g_ret_sts_unexp_error;
753: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
754: fnd_msg_pub.add;
755: RAISE fnd_api.g_exc_unexpected_error;
756: END IF;
757: END IF;

Line 777: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

773: );
774:
775: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
776: x_return_status := fnd_api.g_ret_sts_unexp_error;
777: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
778: fnd_msg_pub.add;
779: RAISE fnd_api.g_exc_unexpected_error;
780: END IF;
781: END IF;

Line 790: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

786: X_RETURN_STATUS => x_return_status
787: );
788: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
789: x_return_status := fnd_api.g_ret_sts_unexp_error;
790: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
791: fnd_msg_pub.add;
792: RAISE fnd_api.g_exc_unexpected_error;
793: END IF;
794:

Line 824: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

820: x_return_code => x_return_status);
821: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
822: --dbms_output.put_line('Returned Error status from the Message Generation API');
823: x_return_status := fnd_api.g_ret_sts_unexp_error;
824: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
825: fnd_msg_pub.add;
826: RAISE fnd_api.g_exc_unexpected_error;
827: END IF;
828: END IF;

Line 911: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

907: );
908:
909: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
910: x_return_status := fnd_api.g_ret_sts_unexp_error;
911: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
912: fnd_msg_pub.add;
913: RAISE fnd_api.g_exc_unexpected_error;
914: END IF;
915: END IF;

Line 934: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

930: );
931:
932: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
935: fnd_msg_pub.add;
936: RAISE fnd_api.g_exc_unexpected_error;
937: END IF;
938: END IF;

Line 948: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

944: );
945:
946: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
947: x_return_status := fnd_api.g_ret_sts_unexp_error;
948: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
949: fnd_msg_pub.add;
950: RAISE fnd_api.g_exc_unexpected_error;
951: END IF;
952:

Line 961: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_VALUE_ID');

957: FETCH c_resource_param_value_id INTO m_resource_param_value_id;
958: IF c_resource_param_value_id%NOTFOUND THEN
959: --dbms_output.put_line('Resource Param Value Id not found');
960: x_return_status := fnd_api.g_ret_sts_unexp_error;
961: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_VALUE_ID');
962: fnd_message.set_token('P_RESOURCE_PARAM_VALUE_ID', l_resource_param_value_id);
963: fnd_msg_pub.add;
964: CLOSE c_resource_param_value_id;
965: RAISE fnd_api.g_exc_unexpected_error;

Line 962: fnd_message.set_token('P_RESOURCE_PARAM_VALUE_ID', l_resource_param_value_id);

958: IF c_resource_param_value_id%NOTFOUND THEN
959: --dbms_output.put_line('Resource Param Value Id not found');
960: x_return_status := fnd_api.g_ret_sts_unexp_error;
961: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_VALUE_ID');
962: fnd_message.set_token('P_RESOURCE_PARAM_VALUE_ID', l_resource_param_value_id);
963: fnd_msg_pub.add;
964: CLOSE c_resource_param_value_id;
965: RAISE fnd_api.g_exc_unexpected_error;
966: END IF;

Line 1003: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

999: );
1000:
1001: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1002: x_return_status := fnd_api.g_ret_sts_unexp_error;
1003: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1004: fnd_msg_pub.add;
1005: RAISE fnd_api.g_exc_unexpected_error;
1006: END IF;
1007: END IF;

Line 1026: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

1022: );
1023:
1024: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1025: x_return_status := fnd_api.g_ret_sts_unexp_error;
1026: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1027: fnd_msg_pub.add;
1028: RAISE fnd_api.g_exc_unexpected_error;
1029: END IF;
1030: END IF;

Line 1039: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

1035: X_RETURN_STATUS => x_return_status
1036: );
1037: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1038: x_return_status := fnd_api.g_ret_sts_unexp_error;
1039: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1040: fnd_msg_pub.add;
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;
1043:

Line 1073: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

1069: x_return_code => x_return_status);
1070: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1071: --dbms_output.put_line('Returned Error status from the Message Generation API');
1072: x_return_status := fnd_api.g_ret_sts_unexp_error;
1073: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1074: fnd_msg_pub.add;
1075: RAISE fnd_api.g_exc_unexpected_error;
1076: END IF;
1077: END IF;

Line 1163: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

1159: );
1160:
1161: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1162: x_return_status := fnd_api.g_ret_sts_unexp_error;
1163: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1164: fnd_msg_pub.add;
1165: RAISE fnd_api.g_exc_unexpected_error;
1166: END IF;
1167: END IF;

Line 1186: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

1182: );
1183:
1184: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1185: x_return_status := fnd_api.g_ret_sts_unexp_error;
1186: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1187: fnd_msg_pub.add;
1188: RAISE fnd_api.g_exc_unexpected_error;
1189: END IF;
1190: END IF;

Line 1200: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

1196: );
1197:
1198: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1199: x_return_status := fnd_api.g_ret_sts_unexp_error;
1200: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1201: fnd_msg_pub.add;
1202: RAISE fnd_api.g_exc_unexpected_error;
1203: END IF;
1204:

Line 1234: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

1230: EXCEPTION
1231: WHEN NO_DATA_FOUND THEN
1232: --dbms_output.put_line('Error in Table Handler');
1233: x_return_status := fnd_api.g_ret_sts_unexp_error;
1234: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1235: fnd_msg_pub.add;
1236: RAISE fnd_api.g_exc_unexpected_error;
1237: END;
1238: --Call Table Handler to Delete the Selected Records

Line 1247: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

1243: EXCEPTION
1244: WHEN NO_DATA_FOUND THEN
1245: --dbms_output.put_line('Error in Table Handler');
1246: x_return_status := fnd_api.g_ret_sts_unexp_error;
1247: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1248: fnd_msg_pub.add;
1249: RAISE fnd_api.g_exc_unexpected_error;
1250: END;
1251: END LOOP;

Line 1272: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

1268: );
1269:
1270: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1271: x_return_status := fnd_api.g_ret_sts_unexp_error;
1272: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1273: fnd_msg_pub.add;
1274: RAISE fnd_api.g_exc_unexpected_error;
1275: END IF;
1276: END IF;

Line 1295: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

1291: );
1292:
1293: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1294: x_return_status := fnd_api.g_ret_sts_unexp_error;
1295: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1296: fnd_msg_pub.add;
1297: RAISE fnd_api.g_exc_unexpected_error;
1298: END IF;
1299: END IF;

Line 1308: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

1304: X_RETURN_STATUS => x_return_status
1305: );
1306: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1307: x_return_status := fnd_api.g_ret_sts_unexp_error;
1308: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1309: fnd_msg_pub.add;
1310: RAISE fnd_api.g_exc_unexpected_error;
1311: END IF;
1312:

Line 1429: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_ID');

1425: OPEN c_rs_resource_values;
1426: FETCH c_rs_resource_values into x_resource_param_value_id, x_value;
1427: IF c_rs_resource_values%NOTFOUND THEN
1428: CLOSE c_rs_resource_values;
1429: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_ID');
1430: fnd_message.set_token('P_RESOURCE_PARAM_ID', p_resource_param_id);
1431: fnd_msg_pub.add;
1432: x_return_status := fnd_api.g_ret_sts_unexp_error;
1433: RAISE fnd_api.g_exc_unexpected_error;

Line 1430: fnd_message.set_token('P_RESOURCE_PARAM_ID', p_resource_param_id);

1426: FETCH c_rs_resource_values into x_resource_param_value_id, x_value;
1427: IF c_rs_resource_values%NOTFOUND THEN
1428: CLOSE c_rs_resource_values;
1429: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_ID');
1430: fnd_message.set_token('P_RESOURCE_PARAM_ID', p_resource_param_id);
1431: fnd_msg_pub.add;
1432: x_return_status := fnd_api.g_ret_sts_unexp_error;
1433: RAISE fnd_api.g_exc_unexpected_error;
1434: END IF;