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

Line 117: fnd_msg_pub.initialize;

113: RAISE fnd_api.g_exc_unexpected_error;
114: END IF;
115:
116: IF fnd_api.to_boolean(p_init_msg_list) THEN
117: fnd_msg_pub.initialize;
118: END IF;
119:
120: --Initializing the Internal User Hook Record parameter values
121:

Line 150: fnd_msg_pub.add;

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

Line 176: fnd_msg_pub.add;

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

Line 189: fnd_msg_pub.add;

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:
193: --Put in all the Validations here

Line 254: fnd_msg_pub.add;

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

Line 344: fnd_msg_pub.add;

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

Line 375: fnd_msg_pub.add;

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

Line 388: fnd_msg_pub.add;

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:
392: /* Standard call for Message Generation */

Line 422: fnd_msg_pub.add;

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

Line 431: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

427:
428: IF fnd_api.to_boolean(p_commit) THEN
429: COMMIT WORK;
430: END IF;
431: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
432:
433: EXCEPTION
434: WHEN fnd_api.g_exc_unexpected_error THEN
435: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 439: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

435: --DBMS_OUTPUT.put_line (' ========================================== ');
436: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
437: ROLLBACK TO create_rs_resource_values_pvt;
438: x_return_status := fnd_api.g_ret_sts_unexp_error;
439: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
440: WHEN OTHERS THEN
441: --DBMS_OUTPUT.put_line (' ========================================== ');
442: --DBMS_OUTPUT.put_line (' =========== Raised Others in Create Resource Values Pvt==============');
443: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 446: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

442: --DBMS_OUTPUT.put_line (' =========== Raised Others in Create Resource Values Pvt==============');
443: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
444: ROLLBACK TO create_rs_resource_values_pvt;
445: x_return_status := fnd_api.g_ret_sts_unexp_error;
446: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
447:
448: END create_rs_resource_values;
449:
450: --Procedure to Update Resource Values based on the input values passed by the calling routines

Line 553: fnd_msg_pub.initialize;

549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551:
552: IF fnd_api.to_boolean(p_init_msg_list) THEN
553: fnd_msg_pub.initialize;
554: END IF;
555:
556: --Initializing the Internal User Hook Record parameter values
557:

Line 583: fnd_msg_pub.add;

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

Line 607: fnd_msg_pub.add;

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

Line 620: fnd_msg_pub.add;

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:
624: --Put all Validations here

Line 634: fnd_msg_pub.add;

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

Line 647: fnd_msg_pub.add;

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:
651: --Get the Resource Param Id, Resource Id, Value Type from the database

Line 754: fnd_msg_pub.add;

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

Line 778: fnd_msg_pub.add;

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

Line 791: fnd_msg_pub.add;

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:
795: /* Standard call for Message Generation */

Line 825: fnd_msg_pub.add;

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

Line 834: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

830:
831: IF fnd_api.to_boolean(p_commit) THEN
832: COMMIT WORK;
833: END IF;
834: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
835:
836: EXCEPTION
837: WHEN fnd_api.g_exc_unexpected_error THEN
838: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 842: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

838: --DBMS_OUTPUT.put_line (' ========================================== ');
839: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
840: ROLLBACK TO update_rs_resource_values_pvt;
841: x_return_status := fnd_api.g_ret_sts_unexp_error;
842: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
843: WHEN OTHERS THEN
844: --DBMS_OUTPUT.put_line (' ========================================== ');
845: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Resource Values Pvt============= ');
846: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 849: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

845: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Resource Values Pvt============= ');
846: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
847: ROLLBACK TO update_rs_resource_values_pvt;
848: x_return_status := fnd_api.g_ret_sts_unexp_error;
849: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
850:
851: END update_rs_resource_values;
852:
853: --Procedure to Delete Resource Values based on the input values provided by the calling routines

Line 885: fnd_msg_pub.initialize;

881: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
882: RAISE fnd_api.g_exc_unexpected_error;
883: END IF;
884: IF fnd_api.to_boolean(p_init_msg_list) THEN
885: fnd_msg_pub.initialize;
886: END IF;
887:
888: --Initializing the Internal User Hook Record parameter values
889:

Line 912: fnd_msg_pub.add;

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

Line 935: fnd_msg_pub.add;

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

Line 949: fnd_msg_pub.add;

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:
953: --Put all Validations here

Line 963: fnd_msg_pub.add;

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

Line 1004: fnd_msg_pub.add;

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

Line 1027: fnd_msg_pub.add;

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

Line 1040: fnd_msg_pub.add;

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:
1044: /* Standard call for Message Generation */

Line 1074: fnd_msg_pub.add;

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

Line 1083: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1079:
1080: IF fnd_api.to_boolean(p_commit) THEN
1081: COMMIT WORK;
1082: END IF;
1083: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1084:
1085: EXCEPTION
1086: WHEN fnd_api.g_exc_unexpected_error THEN
1087: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 1091: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1087: --DBMS_OUTPUT.put_line (' ========================================== ');
1088: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
1089: ROLLBACK TO delete_rs_resource_values_pvt;
1090: x_return_status := fnd_api.g_ret_sts_unexp_error;
1091: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1092: WHEN OTHERS THEN
1093: --DBMS_OUTPUT.put_line (' ========================================== ');
1094: --DBMS_OUTPUT.put_line (' =========== Raised Others in Delete Resource Values Pvt=============');
1095: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 1098: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1094: --DBMS_OUTPUT.put_line (' =========== Raised Others in Delete Resource Values Pvt=============');
1095: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1096: ROLLBACK TO delete_rs_resource_values_pvt;
1097: x_return_status := fnd_api.g_ret_sts_unexp_error;
1098: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1099:
1100: END delete_rs_resource_values;
1101:
1102: --Procedure to Delete all Resource Values based on the Resource Id provided by the calling routines

Line 1137: fnd_msg_pub.initialize;

1133: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1134: RAISE fnd_api.g_exc_unexpected_error;
1135: END IF;
1136: IF fnd_api.to_boolean(p_init_msg_list) THEN
1137: fnd_msg_pub.initialize;
1138: END IF;
1139:
1140: --Initializing the Internal User Hook Record parameter value
1141:

Line 1164: fnd_msg_pub.add;

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

Line 1187: fnd_msg_pub.add;

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

Line 1201: fnd_msg_pub.add;

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:
1205: --Put all Validations here

Line 1235: fnd_msg_pub.add;

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
1239: BEGIN

Line 1248: fnd_msg_pub.add;

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

Line 1273: fnd_msg_pub.add;

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

Line 1296: fnd_msg_pub.add;

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

Line 1309: fnd_msg_pub.add;

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:
1313: IF fnd_api.to_boolean(p_commit) THEN

Line 1316: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1312:
1313: IF fnd_api.to_boolean(p_commit) THEN
1314: COMMIT WORK;
1315: END IF;
1316: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1317:
1318: EXCEPTION
1319: WHEN fnd_api.g_exc_unexpected_error THEN
1320: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 1324: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1320: --DBMS_OUTPUT.put_line (' ========================================== ');
1321: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
1322: ROLLBACK TO delete_all_rs_values_pvt;
1323: x_return_status := fnd_api.g_ret_sts_unexp_error;
1324: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1325: WHEN OTHERS THEN
1326: --DBMS_OUTPUT.put_line (' ========================================== ');
1327: --DBMS_OUTPUT.put_line (' =========== Raised Others in Delete All Resource Values Pvt=============');
1328: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 1331: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1327: --DBMS_OUTPUT.put_line (' =========== Raised Others in Delete All Resource Values Pvt=============');
1328: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1329: ROLLBACK TO delete_all_rs_values_pvt;
1330: x_return_status := fnd_api.g_ret_sts_unexp_error;
1331: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1332:
1333: END delete_all_rs_resource_values;
1334:
1335: --Procedure to Get Resource Values based on the input values passed by the calling routines

Line 1374: fnd_msg_pub.initialize;

1370: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1371: RAISE fnd_api.g_exc_unexpected_error;
1372: END IF;
1373: IF fnd_api.to_boolean(p_init_msg_list) THEN
1374: fnd_msg_pub.initialize;
1375: END IF;
1376:
1377: --Put all Validations here
1378:

Line 1431: fnd_msg_pub.add;

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;
1435: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1435: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
1435: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1436:
1437: EXCEPTION
1438: WHEN fnd_api.g_exc_unexpected_error THEN
1439: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 1443: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1439: --DBMS_OUTPUT.put_line (' ========================================== ');
1440: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
1441: ROLLBACK TO get_rs_resource_values_pvt;
1442: x_return_status := fnd_api.g_ret_sts_unexp_error;
1443: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1444: WHEN OTHERS THEN
1445: --DBMS_OUTPUT.put_line (' ========================================== ');
1446: --DBMS_OUTPUT.put_line (' =========== Raised Others in Get Resource Values Pvt =============');
1447: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 1450: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1446: --DBMS_OUTPUT.put_line (' =========== Raised Others in Get Resource Values Pvt =============');
1447: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1448: ROLLBACK TO get_rs_resource_values_pvt;
1449: x_return_status := fnd_api.g_ret_sts_unexp_error;
1450: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1451:
1452: END get_rs_resource_values;
1453:
1454: --Procedure to Get Resource Param List for the given Application Id and Param Type

Line 1487: fnd_msg_pub.initialize;

1483: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1484: RAISE fnd_api.g_exc_unexpected_error;
1485: END IF;
1486: IF fnd_api.to_boolean(p_init_msg_list) THEN
1487: fnd_msg_pub.initialize;
1488: END IF;
1489:
1490: --Put all Validations here
1491:

Line 1508: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1504:
1505: IF fnd_api.to_boolean(p_commit) THEN
1506: COMMIT WORK;
1507: END IF;
1508: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1509:
1510: EXCEPTION
1511: WHEN fnd_api.g_exc_unexpected_error THEN
1512: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 1516: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1512: --DBMS_OUTPUT.put_line (' ========================================== ');
1513: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
1514: ROLLBACK TO get_rs_param_list_pvt;
1515: x_return_status := fnd_api.g_ret_sts_unexp_error;
1516: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1517: WHEN OTHERS THEN
1518: --DBMS_OUTPUT.put_line (' ========================================== ');
1519: --DBMS_OUTPUT.put_line (' =========== Raised Others in Get Resource Param List Pvt =============');
1520: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 1523: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1519: --DBMS_OUTPUT.put_line (' =========== Raised Others in Get Resource Param List Pvt =============');
1520: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1521: ROLLBACK TO get_rs_param_list_pvt;
1522: x_return_status := fnd_api.g_ret_sts_unexp_error;
1523: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1524:
1525: END get_rs_resource_param_list;
1526:
1527: End JTF_RS_RESOURCE_VALUES_PVT;