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_API

Line 86: x_return_status := fnd_api.g_ret_sts_success;

82: v_dummy integer;
83: l_hook_package varchar2(30);
84: l_hook_api varchar2 (30);
85: BEGIN
86: x_return_status := fnd_api.g_ret_sts_success;
87:
88: FOR i IN c1 LOOP
89: v_cursorid := dbms_sql.open_cursor ;
90: /* BINDVAR_SCAN_IGNORE [1] */

Line 98: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

94: v_dummy := dbms_sql.execute(v_cursorid);
95: dbms_sql.variable_value( v_cursorid , ':1' , x_return_status );
96: dbms_sql.close_cursor(v_cursorid);
97:
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 ;

Line 103: --x_return_status :=fnd_api.g_ret_sts_error;

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:
107: IF X_RETURN_status IS null then

Line 104: RAISE fnd_api.g_exc_error;

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:
107: IF X_RETURN_status IS null then
108: fnd_message.set_name ('JTF', 'JTF_RS_MISSING_RETURN_STATUS');

Line 110: x_return_status := fnd_api.g_ret_sts_error;

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:
114: END LOOP;

Line 111: RAISE fnd_api.g_exc_error;

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:
114: END LOOP;
115:

Line 117: WHEN fnd_api.g_exc_unexpected_error

113:
114: END LOOP;
115:
116: EXCEPTION
117: WHEN fnd_api.g_exc_unexpected_error
118: THEN
119: x_return_status := fnd_api.g_ret_sts_unexp_error;
120: WHEN OTHERS
121: THEN

Line 119: x_return_status := fnd_api.g_ret_sts_unexp_error;

115:
116: EXCEPTION
117: WHEN fnd_api.g_exc_unexpected_error
118: THEN
119: x_return_status := fnd_api.g_ret_sts_unexp_error;
120: WHEN OTHERS
121: THEN
122: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
123: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 127: x_return_status := fnd_api.g_ret_sts_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:
131:

Line 154: x_return_status := fnd_api.g_ret_sts_success;

150:
151:
152: BEGIN
153:
154: x_return_status := fnd_api.g_ret_sts_success;
155:
156: IF p_group_id IS NULL AND p_group_number is NULL THEN
157:
158: -- dbms_output.put_line('Group Id and Group Number are null');

Line 163: x_return_status := fnd_api.g_ret_sts_error;

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;
166:
167:

Line 182: x_return_status := fnd_api.g_ret_sts_error;

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;
185:
186: CLOSE c_group_id;

Line 202: x_return_status := fnd_api.g_ret_sts_error;

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;
205:
206: CLOSE c_group_number;

Line 239: x_return_status := fnd_api.g_ret_sts_success;

235: trunc(end_date_active) >= trunc(sysdate) );
236:
237: BEGIN
238:
239: x_return_status := fnd_api.g_ret_sts_success;
240:
241: IF p_resource_id IS NULL AND p_resource_number is NULL THEN
242:
243: -- dbms_output.put_line('Resource Id and Resource Number are null');

Line 248: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;
251:
252:

Line 267: x_return_status := fnd_api.g_ret_sts_error;

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;
270:
271: CLOSE c_resource_id;

Line 287: x_return_status := fnd_api.g_ret_sts_error;

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;
290:
291: CLOSE c_resource_number;

Line 309: x_return_status := fnd_api.g_ret_sts_success;

305: ) IS
306:
307: BEGIN
308:
309: x_return_status := fnd_api.g_ret_sts_success;
310:
311: IF p_start_date_active IS NULL THEN
312:
313: -- dbms_output.put_line('Start Date Active cannot be null');

Line 318: x_return_status := fnd_api.g_ret_sts_error;

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;
321:
322:

Line 333: x_return_status := fnd_api.g_ret_sts_error;

329: IF to_date(to_char(p_start_date_active,'MM/DD/RRRR'),'MM/DD/RRRR') > to_date(to_char(p_end_date_active,'MM/DD/RRRR'),'MM/DD/RRRR') THEN
330:
331: -- dbms_output.put_line('Start Date cannot be greater than the end date');
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:

Line 366: x_return_status := fnd_api.g_ret_sts_success;

362: AND enabled_flag = p_enabled_flag;
363:
364: BEGIN
365:
366: x_return_status := fnd_api.g_ret_sts_success;
367:
368: IF p_usage IS NULL THEN
369:
370: -- dbms_output.put_line('Usage is null');

Line 375: x_return_status := fnd_api.g_ret_sts_error;

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;
378:
379: IF p_usage IS NOT NULL THEN

Line 393: x_return_status := fnd_api.g_ret_sts_error;

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;
396:
397: CLOSE c_usage;

Line 430: x_return_status := fnd_api.g_ret_sts_success;

426: AND trunc(nvl(jo.end_date_active, sysdate)) >= trunc(sysdate);
427:
428: BEGIN
429:
430: x_return_status := fnd_api.g_ret_sts_success;
431:
432: IF p_category IS NULL THEN
433:
434: -- dbms_output.put_line('Resource Category is null');

Line 439: x_return_status := fnd_api.g_ret_sts_error;

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;
442:
443: IF p_category IS NOT NULL THEN

Line 457: x_return_status := fnd_api.g_ret_sts_error;

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;
460:
461: CLOSE c_resource_category;

Line 519: x_return_status := fnd_api.g_ret_sts_success;

515: check_num number;
516:
517: BEGIN
518:
519: x_return_status := fnd_api.g_ret_sts_success;
520:
521: IF p_category = 'EMPLOYEE' THEN
522: OPEN c_emp_dup_source_id;
523: FETCH c_emp_dup_source_id into check_num;

Line 529: x_return_status := fnd_api.g_ret_sts_error;

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 */
533: /*

Line 541: x_return_status := fnd_api.g_ret_sts_error;

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: */
545: ELSIF p_category = 'PARTY' THEN

Line 553: x_return_status := fnd_api.g_ret_sts_error;

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:
557: ELSIF p_category = 'SUPPLIER_CONTACT' THEN

Line 565: x_return_status := fnd_api.g_ret_sts_error;

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:
569: ELSIF p_category = 'PARTNER' THEN

Line 577: x_return_status := fnd_api.g_ret_sts_error;

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:
581: ELSIF p_category = 'VENUE' THEN

Line 589: x_return_status := fnd_api.g_ret_sts_error;

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

Line 619: x_return_status := fnd_api.g_ret_sts_success;

615: --WHERE employee_number = p_emp_resource_number;
616:
617: BEGIN
618:
619: x_return_status := fnd_api.g_ret_sts_success;
620:
621: IF p_emp_resource_id IS NOT NULL THEN
622: OPEN c_ppf_person_id;
623: FETCH c_ppf_person_id INTO x_emp_resource_id;

Line 629: x_return_status := fnd_api.g_ret_sts_error;

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:
633: --ELSIF p_emp_resource_number IS NOT NULL THEN

Line 641: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 670: x_return_status := fnd_api.g_ret_sts_success;

666: WHERE upgrade_tz_id = p_time_zone_id;
667:
668: BEGIN
669:
670: x_return_status := fnd_api.g_ret_sts_success;
671:
672: IF p_time_zone_id IS NULL THEN
673:
674: -- dbms_output.put_line('Time Zone Id is null');

Line 679: x_return_status := fnd_api.g_ret_sts_error;

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;
682:
683: IF p_time_zone_id IS NOT NULL THEN

Line 697: x_return_status := fnd_api.g_ret_sts_error;

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;
700:
701: CLOSE c_time_zone_id;

Line 725: x_return_status := fnd_api.g_ret_sts_success;

721: WHERE nls_language = p_nls_language;
722:
723: BEGIN
724:
725: x_return_status := fnd_api.g_ret_sts_success;
726:
727: IF p_nls_language IS NULL THEN
728:
729: -- dbms_output.put_line('Language is null');

Line 734: x_return_status := fnd_api.g_ret_sts_error;

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;
737:
738: IF p_nls_language IS NOT NULL THEN

Line 752: x_return_status := fnd_api.g_ret_sts_error;

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;
755:
756: CLOSE c_nls_language;

Line 783: x_return_status := fnd_api.g_ret_sts_success;

779: AND hps.party_site_id = p_support_site_id;
780:
781: BEGIN
782:
783: x_return_status := fnd_api.g_ret_sts_success;
784:
785: IF p_support_site_id IS NULL THEN
786:
787: -- dbms_output.put_line('Support Site is null');

Line 792: x_return_status := fnd_api.g_ret_sts_error;

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;
795:
796: IF p_support_site_id IS NOT NULL THEN

Line 810: x_return_status := fnd_api.g_ret_sts_error;

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;
813:
814: CLOSE c_support_site_id;

Line 843: x_return_status := fnd_api.g_ret_sts_success;

839: WHERE group_name = p_server_group_name;
840:
841: BEGIN
842:
843: x_return_status := fnd_api.g_ret_sts_success;
844:
845: IF p_server_group_id IS NOT NULL THEN
846: OPEN c_server_group_id;
847:

Line 858: x_return_status := fnd_api.g_ret_sts_error;

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;
861:
862: CLOSE c_server_group_id;

Line 878: x_return_status := fnd_api.g_ret_sts_error;

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;
881:
882: CLOSE c_server_group_name;

Line 906: x_return_status := fnd_api.g_ret_sts_success;

902: WHERE currency_code = p_currency_code;
903:
904: BEGIN
905:
906: x_return_status := fnd_api.g_ret_sts_success;
907:
908: IF p_currency_code IS NULL THEN
909:
910: -- dbms_output.put_line('Currency Code is null');

Line 915: x_return_status := fnd_api.g_ret_sts_error;

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;
918:
919: IF p_currency_code IS NOT NULL THEN

Line 933: x_return_status := fnd_api.g_ret_sts_error;

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;
936:
937: CLOSE c_currency_code;

Line 962: x_return_status := fnd_api.g_ret_sts_success;

958: AND lookup_code = p_hold_reason_code;
959:
960: BEGIN
961:
962: x_return_status := fnd_api.g_ret_sts_success;
963:
964: IF p_hold_reason_code IS NULL THEN
965:
966: -- dbms_output.put_line('Hold Reason Code is null');

Line 971: x_return_status := fnd_api.g_ret_sts_error;

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;
974:
975: IF p_hold_reason_code IS NOT NULL THEN

Line 989: x_return_status := fnd_api.g_ret_sts_error;

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;
992:
993: CLOSE c_hold_reason_code;

Line 1023: x_return_status := fnd_api.g_ret_sts_success;

1019:
1020:
1021: BEGIN
1022:
1023: x_return_status := fnd_api.g_ret_sts_success;
1024:
1025: IF p_team_id IS NULL AND p_team_number is NULL THEN
1026:
1027: -- dbms_output.put_line('Team Id and Team Number are null');

Line 1032: x_return_status := fnd_api.g_ret_sts_error;

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;
1035:
1036:

Line 1051: x_return_status := fnd_api.g_ret_sts_error;

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;
1054:
1055: CLOSE c_team_id;

Line 1071: x_return_status := fnd_api.g_ret_sts_error;

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;
1074:
1075: CLOSE c_team_number;

Line 1103: x_return_status := fnd_api.g_ret_sts_success;

1099: AND user_id = p_user_id;
1100:
1101: BEGIN
1102:
1103: x_return_status := fnd_api.g_ret_sts_success;
1104:
1105: IF p_user_id IS NULL THEN
1106:
1107: -- dbms_output.put_line('User Id is null');

Line 1112: x_return_status := fnd_api.g_ret_sts_error;

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;
1115:
1116: IF p_user_id IS NOT NULL THEN

Line 1130: x_return_status := fnd_api.g_ret_sts_error;

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;
1133:
1134: CLOSE c_user_id;

Line 1162: x_return_status := fnd_api.g_ret_sts_success;

1158: -- AND nvl (org_id,-99) = nvl (p_org_id,-99);
1159: AND org_id = p_org_id;
1160:
1161: BEGIN
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;

Line 1167: x_return_status := fnd_api.g_ret_sts_error;

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;
1171: FETCH c_salesrep_id INTO l_salesrep_id;

Line 1177: x_return_status := fnd_api.g_ret_sts_error;

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;
1181: END validate_salesrep_id;

Line 1238: x_return_status := fnd_api.g_ret_sts_success;

1234: ;
1235:
1236: BEGIN
1237:
1238: x_return_status := fnd_api.g_ret_sts_success;
1239:
1240: -- if mode is create, p_id is resource_id
1241: IF (p_cr_upd_mode = 'C') THEN
1242: L_SRP_START_DATE := P_SRP_START_DATE;

Line 1257: IF (P_SRP_START_DATE = FND_API.G_MISS_DATE) THEN

1253: END IF;
1254:
1255: -- if mode is create, p_id is salesrep_id
1256: IF (p_cr_upd_mode = 'U') THEN
1257: IF (P_SRP_START_DATE = FND_API.G_MISS_DATE) THEN
1258: OPEN c_get_srp_start_date(p_id, p_org_id);
1259: FETCH c_get_srp_start_date INTO L_SRP_START_DATE;
1260: CLOSE c_get_srp_start_date;
1261: ELSE

Line 1265: IF (P_SRP_END_DATE = FND_API.G_MISS_DATE) THEN

1261: ELSE
1262: L_SRP_START_DATE := P_SRP_START_DATE;
1263: END IF;
1264:
1265: IF (P_SRP_END_DATE = FND_API.G_MISS_DATE) THEN
1266: OPEN c_get_srp_end_date(p_id, p_org_id);
1267: FETCH c_get_srp_end_date INTO L_SRP_END_DATE;
1268: CLOSE c_get_srp_end_date;
1269: ELSIF (P_SRP_END_DATE IS NOT NULL) THEN

Line 1284: x_return_status := fnd_api.g_ret_sts_error;

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
1288: fnd_message.set_name('JTF', 'JTF_RS_SRP_EDDT_GRTR_RES_EDDT');

Line 1290: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1310: x_return_status := fnd_api.g_ret_sts_success;

1306: FROM ra_territories
1307: WHERE territory_id = p_territory_id;
1308:
1309: BEGIN
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;

Line 1315: x_return_status := fnd_api.g_ret_sts_error;

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;
1319: FETCH c_territory_id INTO l_territory_id;

Line 1325: x_return_status := fnd_api.g_ret_sts_error;

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;
1329: END validate_territory_id;

Line 1354: x_return_status := fnd_api.g_ret_sts_success;

1350: l_val VARCHAR2(1);
1351:
1352: BEGIN
1353:
1354: x_return_status := fnd_api.g_ret_sts_success;
1355:
1356: /* Record is being inserted, check that salesrep number does not already exist */
1357: IF (p_salesrep_number IS NOT NULL) THEN
1358:

Line 1368: x_return_status := fnd_api.g_ret_sts_error;

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;
1371:
1372: CLOSE c_salesrep_number;

Line 1379: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1407: x_return_status := fnd_api.g_ret_sts_success;

1403: l_val VARCHAR2(1);
1404:
1405: BEGIN
1406:
1407: x_return_status := fnd_api.g_ret_sts_success;
1408:
1409: /* Check credit type id is NOT NULL or not*/
1410:
1411: IF (p_sales_credit_type_id is NOT NULL) THEN

Line 1422: x_return_status := fnd_api.g_ret_sts_error;

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;
1425:
1426: CLOSE c_credit_type;

Line 1432: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1516: x_return_status := fnd_api.g_ret_sts_success;

1512: THEN
1513: if object_dtls_cur%ISOPEN THEN
1514: close object_dtls_cur;
1515: end if;
1516: x_return_status := fnd_api.g_ret_sts_success;
1517: /* Added the below code to fix the bug # 3357906
1518: Changed the object existence validation for 'RS_INDIVIDUAL' to jtf_rs_resource_extns from jtf_objects,
1519: because we do not have enough time to investigate the impact of changing the
1520: jtf_objects definition for the object type 'RS_INDIVIDUAL'. */

Line 1527: x_return_status := FND_API.G_RET_STS_SUCCESS;

1523: OPEN c_res_existence(l_select_id);
1524: FETCH c_res_existence INTO l_temp;
1525: IF c_res_existence%FOUND THEN
1526: x_found := TRUE;
1527: x_return_status := FND_API.G_RET_STS_SUCCESS;
1528: CLOSE c_res_existence;
1529: return;
1530: ELSE
1531: x_found := FALSE;

Line 1532: x_return_status := FND_API.G_RET_STS_SUCCESS;

1528: CLOSE c_res_existence;
1529: return;
1530: ELSE
1531: x_found := FALSE;
1532: x_return_status := FND_API.G_RET_STS_SUCCESS;
1533: CLOSE c_res_existence;
1534: return;
1535: END IF;
1536: else

Line 1574: x_return_status := fnd_api.g_ret_sts_error;

1570:
1571: end if;
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;

Line 1587: x_return_status := fnd_api.g_ret_sts_error;

1583:
1584: ELSE
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;

Line 1597: WHEN fnd_api.g_exc_unexpected_error

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
1598: THEN
1599: if object_code_cur%ISOPEN THEN
1600: close object_code_cur;
1601: end if;

Line 1607: WHEN fnd_api.g_exc_error

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:
1611: WHEN OTHERS

Line 1624: x_return_status := fnd_api.g_ret_sts_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:
1628:

Line 1716: x_return_status := fnd_api.g_ret_sts_success;

1712: THEN
1713: if object_dtls_cur%ISOPEN then
1714: close object_dtls_cur;
1715: end if;
1716: x_return_status := fnd_api.g_ret_sts_success;
1717:
1718: --create the sql staement based on the values fetched from jtf_objects_b
1719:
1720: IF (P_OBJECT_CODE <> 'EMPLOYEE' and P_OBJECT_CODE <> 'PARTY') THEN

Line 1751: x_return_status := FND_API.G_RET_STS_SUCCESS;

1747: CLOSE emp_existence;
1748:
1749: if l_temp = 'x' then
1750: x_found := TRUE;
1751: x_return_status := FND_API.G_RET_STS_SUCCESS;
1752: return;
1753: else
1754: x_found := FALSE;
1755: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1755: x_return_status := fnd_api.g_ret_sts_unexp_error;

1751: x_return_status := FND_API.G_RET_STS_SUCCESS;
1752: return;
1753: else
1754: x_found := FALSE;
1755: x_return_status := fnd_api.g_ret_sts_unexp_error;
1756: end if;
1757: END IF;
1758: ELSIF P_OBJECT_CODE = 'PARTY' THEN
1759: OPEN c_party_existence(l_select_id);

Line 1763: x_return_status := FND_API.G_RET_STS_SUCCESS;

1759: OPEN c_party_existence(l_select_id);
1760: FETCH c_party_existence INTO l_party_id;
1761: IF c_party_existence%FOUND THEN
1762: x_found := TRUE;
1763: x_return_status := FND_API.G_RET_STS_SUCCESS;
1764: return;
1765: ELSE
1766: x_found := FALSE;
1767: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1767: x_return_status := FND_API.G_RET_STS_SUCCESS;

1763: x_return_status := FND_API.G_RET_STS_SUCCESS;
1764: return;
1765: ELSE
1766: x_found := FALSE;
1767: x_return_status := FND_API.G_RET_STS_SUCCESS;
1768: return;
1769: END IF;
1770: CLOSE c_party_existence;
1771:

Line 1794: x_return_status := fnd_api.g_ret_sts_unexp_error;

1790: DBMS_SQL.CLOSE_CURSOR(l_cursorid);
1791:
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;

Line 1807: x_return_status := fnd_api.g_ret_sts_unexp_error;

1803:
1804: ELSE
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;

Line 1817: WHEN fnd_api.g_exc_unexpected_error

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
1818: THEN
1819: if object_code_cur%ISOPEN then
1820: close object_code_cur;
1821: end if;

Line 1828: x_return_status := fnd_api.g_ret_sts_unexp_error;

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
1832: THEN

Line 1831: WHEN fnd_api.g_exc_error

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;
1834: WHEN OTHERS
1835: THEN

Line 1833: x_return_status := fnd_api.g_ret_sts_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;
1834: WHEN OTHERS
1835: THEN
1836: if object_code_cur%ISOPEN then
1837: close object_code_cur;

Line 1847: x_return_status := fnd_api.g_ret_sts_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:
1851:

Line 1870: x_return_status := fnd_api.g_ret_sts_success;

1866: WHERE resource_param_id = p_resource_param_id;
1867:
1868: BEGIN
1869:
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;

Line 1875: x_return_status := fnd_api.g_ret_sts_error;

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
1879:

Line 1887: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1931: x_return_status := fnd_api.g_ret_sts_success;

1927: server_group_check varchar2(100);
1928:
1929: BEGIN
1930:
1931: x_return_status := fnd_api.g_ret_sts_success;
1932:
1933: fnd_profile.get('JTF_RS_SERVER_GROUP_CHECK',server_group_check);
1934:
1935: SELECT application_id

Line 1940: x_return_status := fnd_api.g_ret_sts_success;

1936: INTO c_application_id
1937: FROM jtf_rs_resource_params
1938: WHERE resource_param_id = p_resource_param_id;
1939:
1940: x_return_status := fnd_api.g_ret_sts_success;
1941: IF p_value_type IS NOT NULL THEN
1942:
1943: IF c_application_id = 172 THEN
1944: OPEN c_value_type_m (c_application_id);

Line 1953: x_return_status := fnd_api.g_ret_sts_error;

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:
1956: CLOSE c_value_type_m;
1957:

Line 1966: x_return_status := fnd_api.g_ret_sts_error;

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
1970: OPEN c_value_type_e (c_application_id);

Line 1976: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2018: x_return_status := fnd_api.g_ret_sts_success;

2014: FROM jtf_rs_resource_params
2015: WHERE resource_param_id = p_resource_param_id;
2016:
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;

Line 2022: x_return_status := fnd_api.g_ret_sts_error;

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;
2026: FETCH c_lookup_code INTO l_lookup_code;

Line 2036: x_return_status := fnd_api.g_ret_sts_error;

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;
2040: IF (p_length > to_number(v_length)) or (p_length = 0 ) THEN

Line 2043: x_return_status := fnd_api.g_ret_sts_error;

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;
2047: END validate_resource_value;

Line 2071: x_return_status := fnd_api.g_ret_sts_success;

2067: FROM jtf_rs_roles_vl
2068: WHERE role_code = p_role_code;
2069:
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;

Line 2075: x_return_status := fnd_api.g_ret_sts_error;

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
2079: OPEN c_role_id;

Line 2085: x_return_status := fnd_api.g_ret_sts_error;

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:
2089: ELSIF p_role_code IS NOT NULL THEN

Line 2096: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2114: x_return_status := fnd_api.g_ret_sts_success;

2110: IS
2111: l_rs_role_flag varchar2(1);
2112:
2113: BEGIN
2114: x_return_status := fnd_api.g_ret_sts_success;
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);

Line 2120: x_return_status := fnd_api.g_ret_sts_error;

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:
2124: /* Function : get_g_miss_char */

Line 2128: return (fnd_api.g_miss_num);

2124: /* Function : get_g_miss_char */
2125:
2126: FUNCTION get_g_miss_num RETURN NUMBER is
2127: begin
2128: return (fnd_api.g_miss_num);
2129: end get_g_miss_num;
2130:
2131: /* Function : get_g_miss_char */
2132:

Line 2135: return (fnd_api.g_miss_char);

2131: /* Function : get_g_miss_char */
2132:
2133: FUNCTION get_g_miss_char RETURN VARCHAR2 is
2134: begin
2135: return (fnd_api.g_miss_char);
2136: end get_g_miss_char;
2137:
2138: /*Function : get_g_miss_date */
2139:

Line 2142: return (fnd_api.g_miss_date);

2138: /*Function : get_g_miss_date */
2139:
2140: FUNCTION get_g_miss_date RETURN DATE is
2141: begin
2142: return (fnd_api.g_miss_date);
2143: end get_g_miss_date;
2144:
2145:
2146: