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

Line 102: fnd_msg_pub.add ;

98: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
99: THEN
100: fnd_message.set_name ('JTF', 'JTF_RS_MISSING_RETURN_STATUS');
101: fnd_message.set_token('P_PROCEDURE',i.hook_PACKAGE || '.' ||i.hook_api);
102: fnd_msg_pub.add ;
103: --x_return_status :=fnd_api.g_ret_sts_error;
104: RAISE fnd_api.g_exc_error;
105: END IF;
106:

Line 109: fnd_msg_pub.add ;

105: END IF;
106:
107: IF X_RETURN_status IS null then
108: fnd_message.set_name ('JTF', 'JTF_RS_MISSING_RETURN_STATUS');
109: fnd_msg_pub.add ;
110: x_return_status := fnd_api.g_ret_sts_error;
111: RAISE fnd_api.g_exc_error;
112: END IF ;
113:

Line 126: FND_MSG_PUB.add;

122: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
123: fnd_message.set_token('P_SQLCODE',SQLCODE);
124: fnd_message.set_token('P_SQLERRM',SQLERRM);
125: fnd_message.set_token('P_API_NAME','CALL_INTERNAL_HOOK');
126: FND_MSG_PUB.add;
127: x_return_status := fnd_api.g_ret_sts_unexp_error;
128:
129: END call_internal_hook;
130:

Line 161: fnd_msg_pub.add;

157:
158: -- dbms_output.put_line('Group Id and Group Number are null');
159:
160: fnd_message.set_name('JTF', 'JTF_RS_GROUP_NULL');
161: fnd_msg_pub.add;
162:
163: x_return_status := fnd_api.g_ret_sts_error;
164:
165: END IF;

Line 180: fnd_msg_pub.add;

176: -- dbms_output.put_line('Invalid Group Id');
177:
178: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');
179: fnd_message.set_token('P_GROUP_ID', p_group_id);
180: fnd_msg_pub.add;
181:
182: x_return_status := fnd_api.g_ret_sts_error;
183:
184: END IF;

Line 200: fnd_msg_pub.add;

196: -- dbms_output.put_line('Invalid Group Number');
197:
198: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP_NUMBER');
199: fnd_message.set_token('P_GROUP_NUMBER', p_group_number);
200: fnd_msg_pub.add;
201:
202: x_return_status := fnd_api.g_ret_sts_error;
203:
204: END IF;

Line 246: fnd_msg_pub.add;

242:
243: -- dbms_output.put_line('Resource Id and Resource Number are null');
244:
245: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
246: fnd_msg_pub.add;
247:
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249:
250: END IF;

Line 265: fnd_msg_pub.add;

261: -- dbms_output.put_line('Invalid or Inactive Resource');
262:
263: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
264: fnd_message.set_token('P_RESOURCE_ID', p_resource_id);
265: fnd_msg_pub.add;
266:
267: x_return_status := fnd_api.g_ret_sts_error;
268:
269: END IF;

Line 285: fnd_msg_pub.add;

281: -- dbms_output.put_line('Invalid or Inactive Resource');
282:
283: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');
284: fnd_message.set_token('P_RESOURCE_NUMBER', p_resource_number);
285: fnd_msg_pub.add;
286:
287: x_return_status := fnd_api.g_ret_sts_error;
288:
289: END IF;

Line 316: fnd_msg_pub.add;

312:
313: -- dbms_output.put_line('Start Date Active cannot be null');
314:
315: fnd_message.set_name('JTF', 'JTF_RS_START_DATE_NULL');
316: fnd_msg_pub.add;
317:
318: x_return_status := fnd_api.g_ret_sts_error;
319:
320: END IF;

Line 336: fnd_msg_pub.add;

332:
333: x_return_status := fnd_api.g_ret_sts_error;
334:
335: fnd_message.set_name('JTF', 'JTF_RS_ERR_STDT_GREATER_EDDT');
336: fnd_msg_pub.add;
337:
338: END IF;
339:
340: END IF;

Line 373: fnd_msg_pub.add;

369:
370: -- dbms_output.put_line('Usage is null');
371:
372: fnd_message.set_name('JTF', 'JTF_RS_USAGE_NULL');
373: fnd_msg_pub.add;
374:
375: x_return_status := fnd_api.g_ret_sts_error;
376:
377: END IF;

Line 391: fnd_msg_pub.add;

387: -- dbms_output.put_line('Invalid Usage');
388:
389: fnd_message.set_name('JTF', 'JTF_RS_INVALID_USAGE');
390: fnd_message.set_token('P_USAGE', p_usage);
391: fnd_msg_pub.add;
392:
393: x_return_status := fnd_api.g_ret_sts_error;
394:
395: END IF;

Line 437: fnd_msg_pub.add;

433:
434: -- dbms_output.put_line('Resource Category is null');
435:
436: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_CATEGORY_NULL');
437: fnd_msg_pub.add;
438:
439: x_return_status := fnd_api.g_ret_sts_error;
440:
441: END IF;

Line 455: fnd_msg_pub.add;

451: -- dbms_output.put_line('Invalid Resource Category');
452:
453: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RES_CATEGORY');
454: fnd_message.set_token('P_RESOURCE_CATEGORY', p_category);
455: fnd_msg_pub.add;
456:
457: x_return_status := fnd_api.g_ret_sts_error;
458:
459: END IF;

Line 528: fnd_msg_pub.add;

524: IF c_emp_dup_source_id%FOUND THEN
525: -- dbms_output.put_line('Source ID already exists ');
526: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');
527: fnd_message.set_token('P_SOURCE_ID', p_source_id);
528: fnd_msg_pub.add;
529: x_return_status := fnd_api.g_ret_sts_error;
530: END IF;
531: CLOSE c_emp_dup_source_id;
532: /* Removed the below code for bug # 3455951 */

Line 540: fnd_msg_pub.add;

536: FETCH c_cwk_dup_source_id into check_num;
537: IF c_cwk_dup_source_id%FOUND THEN
538: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');
539: fnd_message.set_token('P_SOURCE_ID', p_source_id);
540: fnd_msg_pub.add;
541: x_return_status := fnd_api.g_ret_sts_error;
542: END IF;
543: CLOSE c_cwk_dup_source_id;
544: */

Line 552: fnd_msg_pub.add;

548: IF c_party_dup_source_id%FOUND THEN
549: -- dbms_output.put_line('Source ID already exists ');
550: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');
551: fnd_message.set_token('P_SOURCE_ID', p_source_id);
552: fnd_msg_pub.add;
553: x_return_status := fnd_api.g_ret_sts_error;
554: END IF;
555: CLOSE c_party_dup_source_id;
556:

Line 564: fnd_msg_pub.add;

560: IF c_vend_dup_source_id%FOUND THEN
561: -- dbms_output.put_line('Source ID already exists ');
562: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');
563: fnd_message.set_token('P_SOURCE_ID', p_source_id);
564: fnd_msg_pub.add;
565: x_return_status := fnd_api.g_ret_sts_error;
566: END IF;
567: CLOSE c_vend_dup_source_id;
568:

Line 576: fnd_msg_pub.add;

572: IF c_partner_dup_source_id%FOUND THEN
573: -- dbms_output.put_line('Source ID already exists ');
574: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');
575: fnd_message.set_token('P_SOURCE_ID', p_source_id);
576: fnd_msg_pub.add;
577: x_return_status := fnd_api.g_ret_sts_error;
578: END IF;
579: CLOSE c_partner_dup_source_id;
580:

Line 588: fnd_msg_pub.add;

584: IF c_ven_dup_source_id%FOUND THEN
585: -- dbms_output.put_line('Source ID already exists ');
586: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');
587: fnd_message.set_token('P_SOURCE_ID', p_source_id);
588: fnd_msg_pub.add;
589: x_return_status := fnd_api.g_ret_sts_error;
590: END IF;
591: CLOSE c_ven_dup_source_id;
592:

Line 628: fnd_msg_pub.add;

624: IF c_ppf_person_id%NOTFOUND THEN
625: -- dbms_output.put_line('Invalid or Inactive Employee Resource');
626: fnd_message.set_name('JTF', 'JTF_RS_INVALID_EMP_RESOURCE_ID');
627: fnd_message.set_token('P_EMP_RESOURCE_ID', p_emp_resource_id);
628: fnd_msg_pub.add;
629: x_return_status := fnd_api.g_ret_sts_error;
630: END IF;
631: CLOSE c_ppf_person_id;
632:

Line 640: -- fnd_msg_pub.add;

636: -- IF c_ppf_emp_num%NOTFOUND THEN
637: -- dbms_output.put_line('Invalid or Inactive Employee Resource');
638: -- fnd_message.set_name('JTF', 'JTF_RS_INVALID_EMP_RES_NUMBER');
639: -- fnd_message.set_token('P_EMP_RESOURCE_NUMBER', p_emp_resource_number);
640: -- fnd_msg_pub.add;
641: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
642: -- END IF;
643: -- CLOSE c_ppf_emp_num;
644:

Line 677: fnd_msg_pub.add;

673:
674: -- dbms_output.put_line('Time Zone Id is null');
675:
676: fnd_message.set_name('JTF', 'JTF_RS_TIME_ZONE_NULL');
677: fnd_msg_pub.add;
678:
679: x_return_status := fnd_api.g_ret_sts_error;
680:
681: END IF;

Line 695: fnd_msg_pub.add;

691: -- dbms_output.put_line('Invalid Time Zone');
692:
693: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TIME_ZONE');
694: fnd_message.set_token('P_TIME_ZONE_ID', p_time_zone_id);
695: fnd_msg_pub.add;
696:
697: x_return_status := fnd_api.g_ret_sts_error;
698:
699: END IF;

Line 732: fnd_msg_pub.add;

728:
729: -- dbms_output.put_line('Language is null');
730:
731: fnd_message.set_name('JTF', 'JTF_RS_LANGUAGE_NULL');
732: fnd_msg_pub.add;
733:
734: x_return_status := fnd_api.g_ret_sts_error;
735:
736: END IF;

Line 750: fnd_msg_pub.add;

746: -- dbms_output.put_line('Invalid Language');
747:
748: fnd_message.set_name('JTF', 'JTF_RS_INVALID_LANGUAGE');
749: fnd_message.set_token('P_LANGUAGE', p_nls_language);
750: fnd_msg_pub.add;
751:
752: x_return_status := fnd_api.g_ret_sts_error;
753:
754: END IF;

Line 790: fnd_msg_pub.add;

786:
787: -- dbms_output.put_line('Support Site is null');
788:
789: fnd_message.set_name('JTF', 'JTF_RS_SUPPORT_SITE_NULL');
790: fnd_msg_pub.add;
791:
792: x_return_status := fnd_api.g_ret_sts_error;
793:
794: END IF;

Line 808: fnd_msg_pub.add;

804: -- dbms_output.put_line('Invalid Support Site');
805:
806: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SUPPORT_SITE');
807: fnd_message.set_token('P_SUPPORT_SITE_ID', p_support_site_id);
808: fnd_msg_pub.add;
809:
810: x_return_status := fnd_api.g_ret_sts_error;
811:
812: END IF;

Line 856: fnd_msg_pub.add;

852: -- dbms_output.put_line('Invalid Server Group Id');
853:
854: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRV_GROUP_ID');
855: fnd_message.set_token('P_SERVER_GROUP_ID', p_server_group_id);
856: fnd_msg_pub.add;
857:
858: x_return_status := fnd_api.g_ret_sts_error;
859:
860: END IF;

Line 876: fnd_msg_pub.add;

872: -- dbms_output.put_line('Invalid Interaction Center Name');
873:
874: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SVR_GROUP_NAME');
875: fnd_message.set_token('P_SERVER_GROUP_NAME', p_server_group_name);
876: fnd_msg_pub.add;
877:
878: x_return_status := fnd_api.g_ret_sts_error;
879:
880: END IF;

Line 913: fnd_msg_pub.add;

909:
910: -- dbms_output.put_line('Currency Code is null');
911:
912: fnd_message.set_name('JTF', 'JTF_RS_CURRENCY_NULL');
913: fnd_msg_pub.add;
914:
915: x_return_status := fnd_api.g_ret_sts_error;
916:
917: END IF;

Line 931: fnd_msg_pub.add;

927: -- dbms_output.put_line('Invalid Currency Code');
928:
929: fnd_message.set_name('JTF', 'JTF_RS_INVALID_CURRENCY');
930: fnd_message.set_token('P_CURRENCY', p_currency_code);
931: fnd_msg_pub.add;
932:
933: x_return_status := fnd_api.g_ret_sts_error;
934:
935: END IF;

Line 969: fnd_msg_pub.add;

965:
966: -- dbms_output.put_line('Hold Reason Code is null');
967:
968: fnd_message.set_name('JTF', 'JTF_RS_HOLD_REASON_CODE_NULL');
969: fnd_msg_pub.add;
970:
971: x_return_status := fnd_api.g_ret_sts_error;
972:
973: END IF;

Line 987: fnd_msg_pub.add;

983: -- dbms_output.put_line('Invalid Hold Reason Code');
984:
985: fnd_message.set_name('JTF', 'JTF_RS_INVALID_HOLD_REASON_COD');
986: fnd_message.set_token('P_HOLD_REASON_CODE', p_hold_reason_code);
987: fnd_msg_pub.add;
988:
989: x_return_status := fnd_api.g_ret_sts_error;
990:
991: END IF;

Line 1030: fnd_msg_pub.add;

1026:
1027: -- dbms_output.put_line('Team Id and Team Number are null');
1028:
1029: fnd_message.set_name('JTF', 'JTF_RS_TEAM_NULL');
1030: fnd_msg_pub.add;
1031:
1032: x_return_status := fnd_api.g_ret_sts_error;
1033:
1034: END IF;

Line 1049: fnd_msg_pub.add;

1045: -- dbms_output.put_line('Invalid Team Id');
1046:
1047: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM');
1048: fnd_message.set_token('P_TEAM_ID', p_team_id);
1049: fnd_msg_pub.add;
1050:
1051: x_return_status := fnd_api.g_ret_sts_error;
1052:
1053: END IF;

Line 1069: fnd_msg_pub.add;

1065: -- dbms_output.put_line('Invalid Team Number');
1066:
1067: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_NUMBER');
1068: fnd_message.set_token('P_TEAM_NUMBER', p_team_number);
1069: fnd_msg_pub.add;
1070:
1071: x_return_status := fnd_api.g_ret_sts_error;
1072:
1073: END IF;

Line 1110: fnd_msg_pub.add;

1106:
1107: -- dbms_output.put_line('User Id is null');
1108:
1109: fnd_message.set_name('JTF', 'JTF_RS_USER_ID_NULL');
1110: fnd_msg_pub.add;
1111:
1112: x_return_status := fnd_api.g_ret_sts_error;
1113:
1114: END IF;

Line 1128: fnd_msg_pub.add;

1124: -- dbms_output.put_line('Invalid User Id');
1125:
1126: fnd_message.set_name('JTF', 'JTF_RS_INVALID_USER_ID');
1127: fnd_message.set_token('P_USER_ID', p_user_id);
1128: fnd_msg_pub.add;
1129:
1130: x_return_status := fnd_api.g_ret_sts_error;
1131:
1132: END IF;

Line 1166: fnd_msg_pub.add;

1162: x_return_status := fnd_api.g_ret_sts_success;
1163: IF p_salesrep_id IS NULL THEN
1164: -- dbms_output.put_line('Salesrep Id is null');
1165: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_ID_NULL');
1166: fnd_msg_pub.add;
1167: x_return_status := fnd_api.g_ret_sts_error;
1168: END IF;
1169: IF p_salesrep_id IS NOT NULL THEN
1170: OPEN c_salesrep_id;

Line 1176: fnd_msg_pub.add;

1172: IF c_salesrep_id%NOTFOUND THEN
1173: -- dbms_output.put_line('Invalid Salesrep Id');
1174: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');
1175: fnd_message.set_token('P_SALESREP_ID', p_salesrep_id);
1176: fnd_msg_pub.add;
1177: x_return_status := fnd_api.g_ret_sts_error;
1178: END IF;
1179: CLOSE c_salesrep_id;
1180: END IF;

Line 1283: fnd_msg_pub.add;

1279: END IF;
1280:
1281: IF (l_srp_start_date < l_res_start_date) THEN
1282: fnd_message.set_name('JTF', 'JTF_RS_SRP_STDT_GRTR_RES_STDT');
1283: fnd_msg_pub.add;
1284: x_return_status := fnd_api.g_ret_sts_error;
1285: END IF;
1286:
1287: IF (l_srp_end_date > l_res_end_date) THEN

Line 1289: fnd_msg_pub.add;

1285: END IF;
1286:
1287: IF (l_srp_end_date > l_res_end_date) THEN
1288: fnd_message.set_name('JTF', 'JTF_RS_SRP_EDDT_GRTR_RES_EDDT');
1289: fnd_msg_pub.add;
1290: x_return_status := fnd_api.g_ret_sts_error;
1291: END IF;
1292:
1293: END validate_salesrep_dates;

Line 1314: fnd_msg_pub.add;

1310: x_return_status := fnd_api.g_ret_sts_success;
1311: IF p_territory_id IS NULL THEN
1312: -- dbms_output.put_line('Territory Id is null');
1313: fnd_message.set_name('JTF', 'JTF_RS_TERRITORY_ID_NULL');
1314: fnd_msg_pub.add;
1315: x_return_status := fnd_api.g_ret_sts_error;
1316: END IF;
1317: IF p_territory_id IS NOT NULL THEN
1318: OPEN c_territory_id;

Line 1324: fnd_msg_pub.add;

1320: IF c_territory_id%NOTFOUND THEN
1321: -- dbms_output.put_line('Invalid Territory Id');
1322: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TERRITORY_ID');
1323: fnd_message.set_token('P_TERRITORY_ID', p_territory_id);
1324: fnd_msg_pub.add;
1325: x_return_status := fnd_api.g_ret_sts_error;
1326: END IF;
1327: CLOSE c_territory_id;
1328: END IF;

Line 1366: fnd_msg_pub.add;

1362:
1363: IF (c_salesrep_number%FOUND) THEN
1364: fnd_message.set_name('JTF', 'JTF_RS_ERR_SALESREP_NUMBER');
1365: fnd_message.set_token('P_SALESREP_NUMBER', p_salesrep_number);
1366: fnd_msg_pub.add;
1367: -- dbms_output.put_line('Salesrep already exists');
1368: x_return_status := fnd_api.g_ret_sts_error;
1369:
1370: END IF;

Line 1377: fnd_msg_pub.add;

1373:
1374: ELSE
1375:
1376: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_NUMBER_NULL');
1377: fnd_msg_pub.add;
1378: -- dbms_output.put_line('Salesrep number is null');
1379: x_return_status := fnd_api.g_ret_sts_error;
1380: /* Commented the below line to fix the bug # 3436895 */
1381: -- CLOSE c_salesrep_number;

Line 1420: fnd_msg_pub.add;

1416: IF (c_credit_type%NOTFOUND) THEN
1417:
1418: fnd_message.set_name('JTF', 'JTF_RS_ERR_SALES_CREDIT_TYPE');
1419: fnd_message.set_token('P_SALES_CREDIT_TYPE_ID', p_sales_credit_type_id);
1420: fnd_msg_pub.add;
1421: -- dbms_output.put_line('Invalid Sales Credit Type');
1422: x_return_status := fnd_api.g_ret_sts_error;
1423:
1424: END IF;

Line 1431: fnd_msg_pub.add;

1427:
1428: ELSE
1429:
1430: fnd_message.set_name('JTF', 'JTF_RS_SALES_CREDIT_TYPE_NULL');
1431: fnd_msg_pub.add;
1432: x_return_status := fnd_api.g_ret_sts_error;
1433: -- dbms_output.put_line('Sales Credit type id is NULL');
1434:
1435: END IF;

Line 1576: FND_MSG_PUB.add;

1572: ELSE
1573: --if object not found
1574: x_return_status := fnd_api.g_ret_sts_error;
1575: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RL_RES_TYPE');
1576: FND_MSG_PUB.add;
1577:
1578: END IF;
1579:
1580: if object_dtls_cur%ISOPEN THEN

Line 1589: FND_MSG_PUB.add;

1585:
1586: --IF object user code is not valid
1587: x_return_status := fnd_api.g_ret_sts_error;
1588: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_OBJ_USER_CODE');
1589: FND_MSG_PUB.add;
1590:
1591: END IF;
1592:
1593: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1593: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1589: FND_MSG_PUB.add;
1590:
1591: END IF;
1592:
1593: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1594:
1595: EXCEPTION
1596:
1597: WHEN fnd_api.g_exc_unexpected_error

Line 1606: FND_MSG_PUB.add;

1602: if object_dtls_cur%ISOPEN THEN
1603: close object_dtls_cur;
1604: end if;
1605: fnd_message.set_name ('JTF', 'JTF_OBJECT_ERR');
1606: FND_MSG_PUB.add;
1607: WHEN fnd_api.g_exc_error
1608: THEN
1609: null;
1610:

Line 1623: FND_MSG_PUB.add;

1619: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1620: fnd_message.set_token('P_SQLCODE',SQLCODE);
1621: fnd_message.set_token('P_SQLERRM',SQLERRM);
1622: fnd_message.set_token('P_API_NAME','CHECK_OBJECT_EXISTENCE');
1623: FND_MSG_PUB.add;
1624: x_return_status := fnd_api.g_ret_sts_unexp_error;
1625:
1626: END check_object_existence;
1627:

Line 1796: FND_MSG_PUB.add;

1792: ELSE
1793: --if object not found
1794: x_return_status := fnd_api.g_ret_sts_unexp_error;
1795: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RL_RES_TYPE');
1796: FND_MSG_PUB.add;
1797:
1798: END IF;
1799:
1800: if object_dtls_cur%ISOPEN then

Line 1809: FND_MSG_PUB.add;

1805:
1806: --IF object user code is not valid
1807: x_return_status := fnd_api.g_ret_sts_unexp_error;
1808: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_OBJ_USER_CODE');
1809: FND_MSG_PUB.add;
1810:
1811: END IF;
1812:
1813: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1813: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1809: FND_MSG_PUB.add;
1810:
1811: END IF;
1812:
1813: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1814:
1815: EXCEPTION
1816:
1817: WHEN fnd_api.g_exc_unexpected_error

Line 1827: FND_MSG_PUB.add;

1823: close object_dtls_cur;
1824: end if;
1825:
1826: fnd_message.set_name ('JTF', 'JTF_OBJECT_ERR');
1827: FND_MSG_PUB.add;
1828: x_return_status := fnd_api.g_ret_sts_unexp_error;
1829: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1830:
1831: WHEN fnd_api.g_exc_error

Line 1829: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1825:
1826: fnd_message.set_name ('JTF', 'JTF_OBJECT_ERR');
1827: FND_MSG_PUB.add;
1828: x_return_status := fnd_api.g_ret_sts_unexp_error;
1829: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1830:
1831: WHEN fnd_api.g_exc_error
1832: THEN
1833: x_return_status := fnd_api.g_ret_sts_error;

Line 1846: FND_MSG_PUB.add;

1842: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1843: fnd_message.set_token('P_SQLCODE',SQLCODE);
1844: fnd_message.set_token('P_SQLERRM',SQLERRM);
1845: fnd_message.set_token('P_API_NAME','CHECK_OBJECT_EXISTENCE_MIGR');
1846: FND_MSG_PUB.add;
1847: x_return_status := fnd_api.g_ret_sts_unexp_error;
1848: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1849: END check_object_existence_migr;
1850:

Line 1848: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1844: fnd_message.set_token('P_SQLERRM',SQLERRM);
1845: fnd_message.set_token('P_API_NAME','CHECK_OBJECT_EXISTENCE_MIGR');
1846: FND_MSG_PUB.add;
1847: x_return_status := fnd_api.g_ret_sts_unexp_error;
1848: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1849: END check_object_existence_migr;
1850:
1851:
1852:

Line 1874: fnd_msg_pub.add;

1870: x_return_status := fnd_api.g_ret_sts_success;
1871:
1872: IF p_resource_param_id IS NULL THEN
1873: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_PARAM_ID_NULL');
1874: fnd_msg_pub.add;
1875: x_return_status := fnd_api.g_ret_sts_error;
1876: END IF;
1877:
1878: IF p_resource_param_id IS NOT NULL THEN

Line 1886: fnd_msg_pub.add;

1882:
1883: IF c_resource_param_id%NOTFOUND THEN
1884: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RS_PRM_ID');
1885: fnd_message.set_token('P_RESOURCE_PARAM_ID', p_resource_param_id);
1886: fnd_msg_pub.add;
1887: x_return_status := fnd_api.g_ret_sts_error;
1888: END IF;
1889: CLOSE c_resource_param_id;
1890: END IF;

Line 1951: fnd_msg_pub.add;

1947: IF c_value_type_m%NOTFOUND THEN
1948:
1949: fnd_message.set_name('JTF', 'JTF_RS_INVALID_VALUE_TYPE');
1950: fnd_message.set_token('P_VALUE_TYPE', p_value_type);
1951: fnd_msg_pub.add;
1952:
1953: x_return_status := fnd_api.g_ret_sts_error;
1954: END IF;
1955:

Line 1965: fnd_msg_pub.add;

1961: FETCH c_value_type_no_sg_check INTO l_value_type;
1962: IF c_value_type_no_sg_check%NOTFOUND THEN
1963: fnd_message.set_name('JTF', 'JTF_RS_INVALID_VALUE_TYPE');
1964: fnd_message.set_token('P_VALUE_TYPE', p_value_type);
1965: fnd_msg_pub.add;
1966: x_return_status := fnd_api.g_ret_sts_error;
1967: END IF;
1968: CLOSE c_value_type_no_sg_check;
1969: else

Line 1975: fnd_msg_pub.add;

1971: FETCH c_value_type_e INTO l_value_type;
1972: IF c_value_type_e%NOTFOUND THEN
1973: fnd_message.set_name('JTF', 'JTF_RS_INVALID_VALUE_TYPE');
1974: fnd_message.set_token('P_VALUE_TYPE', p_value_type);
1975: fnd_msg_pub.add;
1976: x_return_status := fnd_api.g_ret_sts_error;
1977: END IF;
1978: CLOSE c_value_type_e;
1979: end if;

Line 2021: fnd_msg_pub.add;

2017: p_length:=LENGTH(p_value);
2018: x_return_status := fnd_api.g_ret_sts_success;
2019: IF p_value IS NULL THEN
2020: fnd_message.set_name('JTF', 'JTF_RS_VALUE_NULL');
2021: fnd_msg_pub.add;
2022: x_return_status := fnd_api.g_ret_sts_error;
2023: END IF;
2024:
2025: OPEN c_lookup_code;

Line 2035: fnd_msg_pub.add;

2031: (SUBSTR(l_value,i,1)='3') or (SUBSTR(l_value,i,1)='4') or (SUBSTR(l_value,i,1)='5') or
2032: (SUBSTR(l_value,i,1)='6') or (SUBSTR(l_value,i,1)='7') or (SUBSTR(l_value,i,1)='8') or
2033: (SUBSTR(l_value,i,1)='9')) THEN
2034: fnd_message.set_name('JTF', 'JTF_RS_VALUE_ERR_DATA_TYPE');
2035: fnd_msg_pub.add;
2036: x_return_status := fnd_api.g_ret_sts_error;
2037: END IF;
2038: END LOOP;
2039: END IF;

Line 2042: fnd_msg_pub.add;

2038: END LOOP;
2039: END IF;
2040: IF (p_length > to_number(v_length)) or (p_length = 0 ) THEN
2041: fnd_message.set_name('JTF', 'JTF_RS_VALUE_INCORRECT_LENGTH');
2042: fnd_msg_pub.add;
2043: x_return_status := fnd_api.g_ret_sts_error;
2044: END IF;
2045: END IF;
2046: CLOSE c_lookup_code;

Line 2074: fnd_msg_pub.add;

2070: BEGIN
2071: x_return_status := fnd_api.g_ret_sts_success;
2072: IF p_role_id IS NULL AND p_role_code is NULL THEN
2073: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NULL');
2074: fnd_msg_pub.add;
2075: x_return_status := fnd_api.g_ret_sts_error;
2076: END IF;
2077:
2078: IF p_role_id IS NOT NULL THEN

Line 2084: fnd_msg_pub.add;

2080: FETCH c_role_id INTO x_role_id;
2081: IF c_role_id%NOTFOUND THEN
2082: fnd_message.set_name('JTF', 'JTF_RS_INVALID_ROLE');
2083: fnd_message.set_token('P_ROLE_ID', p_role_id);
2084: fnd_msg_pub.add;
2085: x_return_status := fnd_api.g_ret_sts_error;
2086: END IF;
2087: CLOSE c_role_id;
2088:

Line 2095: fnd_msg_pub.add;

2091: FETCH c_role_code INTO x_role_id;
2092: IF c_role_code%NOTFOUND THEN
2093: fnd_message.set_name('JTF', 'JTF_RS_INVALID_ROLE_CODE');
2094: fnd_message.set_token('P_ROLE_CODE', p_role_code);
2095: fnd_msg_pub.add;
2096: x_return_status := fnd_api.g_ret_sts_error;
2097: END IF;
2098: CLOSE c_role_code;
2099: END IF;

Line 2119: fnd_msg_pub.add;

2115: l_rs_role_flag := upper(p_rs_role_flag);
2116: IF ( l_rs_role_flag <> 'Y' and l_rs_role_flag <>'N') THEN
2117: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG');
2118: fnd_message.set_token('P_RS_ROLE_FLAG', p_rs_role_flag);
2119: fnd_msg_pub.add;
2120: x_return_status := fnd_api.g_ret_sts_error;
2121: END IF;
2122: END validate_rs_role_flags;
2123: