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 331: x_return_status := fnd_api.g_ret_sts_error;

327: IF trunc(p_start_date_active) > trunc(p_end_date_active) THEN
328:
329: -- dbms_output.put_line('Start Date cannot be greater than the end date');
330:
331: x_return_status := fnd_api.g_ret_sts_error;
332:
333: fnd_message.set_name('JTF', 'JTF_RS_ERR_STDT_GREATER_EDDT');
334: fnd_msg_pub.add;
335:

Line 364: x_return_status := fnd_api.g_ret_sts_success;

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

Line 373: x_return_status := fnd_api.g_ret_sts_error;

369:
370: fnd_message.set_name('JTF', 'JTF_RS_USAGE_NULL');
371: fnd_msg_pub.add;
372:
373: x_return_status := fnd_api.g_ret_sts_error;
374:
375: END IF;
376:
377: IF p_usage IS NOT NULL THEN

Line 391: x_return_status := fnd_api.g_ret_sts_error;

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

Line 428: x_return_status := fnd_api.g_ret_sts_success;

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

Line 437: x_return_status := fnd_api.g_ret_sts_error;

433:
434: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_CATEGORY_NULL');
435: fnd_msg_pub.add;
436:
437: x_return_status := fnd_api.g_ret_sts_error;
438:
439: END IF;
440:
441: IF p_category IS NOT NULL THEN

Line 455: x_return_status := fnd_api.g_ret_sts_error;

451: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RES_CATEGORY');
452: fnd_message.set_token('P_RESOURCE_CATEGORY', p_category);
453: fnd_msg_pub.add;
454:
455: x_return_status := fnd_api.g_ret_sts_error;
456:
457: END IF;
458:
459: CLOSE c_resource_category;

Line 517: x_return_status := fnd_api.g_ret_sts_success;

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

Line 527: x_return_status := fnd_api.g_ret_sts_error;

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

Line 539: x_return_status := fnd_api.g_ret_sts_error;

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

Line 551: x_return_status := fnd_api.g_ret_sts_error;

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

Line 563: x_return_status := fnd_api.g_ret_sts_error;

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

Line 575: x_return_status := fnd_api.g_ret_sts_error;

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

Line 587: x_return_status := fnd_api.g_ret_sts_error;

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

Line 617: x_return_status := fnd_api.g_ret_sts_success;

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

Line 627: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 668: x_return_status := fnd_api.g_ret_sts_success;

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

Line 677: x_return_status := fnd_api.g_ret_sts_error;

673:
674: fnd_message.set_name('JTF', 'JTF_RS_TIME_ZONE_NULL');
675: fnd_msg_pub.add;
676:
677: x_return_status := fnd_api.g_ret_sts_error;
678:
679: END IF;
680:
681: IF p_time_zone_id IS NOT NULL THEN

Line 695: x_return_status := fnd_api.g_ret_sts_error;

691: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TIME_ZONE');
692: fnd_message.set_token('P_TIME_ZONE_ID', p_time_zone_id);
693: fnd_msg_pub.add;
694:
695: x_return_status := fnd_api.g_ret_sts_error;
696:
697: END IF;
698:
699: CLOSE c_time_zone_id;

Line 723: x_return_status := fnd_api.g_ret_sts_success;

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

Line 732: x_return_status := fnd_api.g_ret_sts_error;

728:
729: fnd_message.set_name('JTF', 'JTF_RS_LANGUAGE_NULL');
730: fnd_msg_pub.add;
731:
732: x_return_status := fnd_api.g_ret_sts_error;
733:
734: END IF;
735:
736: IF p_nls_language IS NOT NULL THEN

Line 750: x_return_status := fnd_api.g_ret_sts_error;

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

Line 781: x_return_status := fnd_api.g_ret_sts_success;

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

Line 790: x_return_status := fnd_api.g_ret_sts_error;

786:
787: fnd_message.set_name('JTF', 'JTF_RS_SUPPORT_SITE_NULL');
788: fnd_msg_pub.add;
789:
790: x_return_status := fnd_api.g_ret_sts_error;
791:
792: END IF;
793:
794: IF p_support_site_id IS NOT NULL THEN

Line 808: x_return_status := fnd_api.g_ret_sts_error;

804: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SUPPORT_SITE');
805: fnd_message.set_token('P_SUPPORT_SITE_ID', p_support_site_id);
806: fnd_msg_pub.add;
807:
808: x_return_status := fnd_api.g_ret_sts_error;
809:
810: END IF;
811:
812: CLOSE c_support_site_id;

Line 841: x_return_status := fnd_api.g_ret_sts_success;

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

Line 856: x_return_status := fnd_api.g_ret_sts_error;

852: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRV_GROUP_ID');
853: fnd_message.set_token('P_SERVER_GROUP_ID', p_server_group_id);
854: fnd_msg_pub.add;
855:
856: x_return_status := fnd_api.g_ret_sts_error;
857:
858: END IF;
859:
860: CLOSE c_server_group_id;

Line 876: x_return_status := fnd_api.g_ret_sts_error;

872: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SVR_GROUP_NAME');
873: fnd_message.set_token('P_SERVER_GROUP_NAME', p_server_group_name);
874: fnd_msg_pub.add;
875:
876: x_return_status := fnd_api.g_ret_sts_error;
877:
878: END IF;
879:
880: CLOSE c_server_group_name;

Line 904: x_return_status := fnd_api.g_ret_sts_success;

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

Line 913: x_return_status := fnd_api.g_ret_sts_error;

909:
910: fnd_message.set_name('JTF', 'JTF_RS_CURRENCY_NULL');
911: fnd_msg_pub.add;
912:
913: x_return_status := fnd_api.g_ret_sts_error;
914:
915: END IF;
916:
917: IF p_currency_code IS NOT NULL THEN

Line 931: x_return_status := fnd_api.g_ret_sts_error;

927: fnd_message.set_name('JTF', 'JTF_RS_INVALID_CURRENCY');
928: fnd_message.set_token('P_CURRENCY', p_currency_code);
929: fnd_msg_pub.add;
930:
931: x_return_status := fnd_api.g_ret_sts_error;
932:
933: END IF;
934:
935: CLOSE c_currency_code;

Line 960: x_return_status := fnd_api.g_ret_sts_success;

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

Line 969: x_return_status := fnd_api.g_ret_sts_error;

965:
966: fnd_message.set_name('JTF', 'JTF_RS_HOLD_REASON_CODE_NULL');
967: fnd_msg_pub.add;
968:
969: x_return_status := fnd_api.g_ret_sts_error;
970:
971: END IF;
972:
973: IF p_hold_reason_code IS NOT NULL THEN

Line 987: x_return_status := fnd_api.g_ret_sts_error;

983: fnd_message.set_name('JTF', 'JTF_RS_INVALID_HOLD_REASON_COD');
984: fnd_message.set_token('P_HOLD_REASON_CODE', p_hold_reason_code);
985: fnd_msg_pub.add;
986:
987: x_return_status := fnd_api.g_ret_sts_error;
988:
989: END IF;
990:
991: CLOSE c_hold_reason_code;

Line 1021: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1030: x_return_status := fnd_api.g_ret_sts_error;

1026:
1027: fnd_message.set_name('JTF', 'JTF_RS_TEAM_NULL');
1028: fnd_msg_pub.add;
1029:
1030: x_return_status := fnd_api.g_ret_sts_error;
1031:
1032: END IF;
1033:
1034:

Line 1049: x_return_status := fnd_api.g_ret_sts_error;

1045: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM');
1046: fnd_message.set_token('P_TEAM_ID', p_team_id);
1047: fnd_msg_pub.add;
1048:
1049: x_return_status := fnd_api.g_ret_sts_error;
1050:
1051: END IF;
1052:
1053: CLOSE c_team_id;

Line 1069: x_return_status := fnd_api.g_ret_sts_error;

1065: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_NUMBER');
1066: fnd_message.set_token('P_TEAM_NUMBER', p_team_number);
1067: fnd_msg_pub.add;
1068:
1069: x_return_status := fnd_api.g_ret_sts_error;
1070:
1071: END IF;
1072:
1073: CLOSE c_team_number;

Line 1101: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1110: x_return_status := fnd_api.g_ret_sts_error;

1106:
1107: fnd_message.set_name('JTF', 'JTF_RS_USER_ID_NULL');
1108: fnd_msg_pub.add;
1109:
1110: x_return_status := fnd_api.g_ret_sts_error;
1111:
1112: END IF;
1113:
1114: IF p_user_id IS NOT NULL THEN

Line 1128: x_return_status := fnd_api.g_ret_sts_error;

1124: fnd_message.set_name('JTF', 'JTF_RS_INVALID_USER_ID');
1125: fnd_message.set_token('P_USER_ID', p_user_id);
1126: fnd_msg_pub.add;
1127:
1128: x_return_status := fnd_api.g_ret_sts_error;
1129:
1130: END IF;
1131:
1132: CLOSE c_user_id;

Line 1160: x_return_status := fnd_api.g_ret_sts_success;

1156: -- AND nvl (org_id,-99) = nvl (p_org_id,-99);
1157: AND org_id = p_org_id;
1158:
1159: BEGIN
1160: x_return_status := fnd_api.g_ret_sts_success;
1161: IF p_salesrep_id IS NULL THEN
1162: -- dbms_output.put_line('Salesrep Id is null');
1163: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_ID_NULL');
1164: fnd_msg_pub.add;

Line 1165: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1175: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1234: x_return_status := fnd_api.g_ret_sts_success;

1230: ;
1231:
1232: BEGIN
1233:
1234: x_return_status := fnd_api.g_ret_sts_success;
1235:
1236: -- if mode is create, p_id is resource_id
1237: IF (p_cr_upd_mode = 'C') THEN
1238: L_SRP_START_DATE := P_SRP_START_DATE;

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

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

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

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

Line 1280: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1286: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1306: x_return_status := fnd_api.g_ret_sts_success;

1302: FROM ra_territories
1303: WHERE territory_id = p_territory_id;
1304:
1305: BEGIN
1306: x_return_status := fnd_api.g_ret_sts_success;
1307: IF p_territory_id IS NULL THEN
1308: -- dbms_output.put_line('Territory Id is null');
1309: fnd_message.set_name('JTF', 'JTF_RS_TERRITORY_ID_NULL');
1310: fnd_msg_pub.add;

Line 1311: x_return_status := fnd_api.g_ret_sts_error;

1307: IF p_territory_id IS NULL THEN
1308: -- dbms_output.put_line('Territory Id is null');
1309: fnd_message.set_name('JTF', 'JTF_RS_TERRITORY_ID_NULL');
1310: fnd_msg_pub.add;
1311: x_return_status := fnd_api.g_ret_sts_error;
1312: END IF;
1313: IF p_territory_id IS NOT NULL THEN
1314: OPEN c_territory_id;
1315: FETCH c_territory_id INTO l_territory_id;

Line 1321: x_return_status := fnd_api.g_ret_sts_error;

1317: -- dbms_output.put_line('Invalid Territory Id');
1318: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TERRITORY_ID');
1319: fnd_message.set_token('P_TERRITORY_ID', p_territory_id);
1320: fnd_msg_pub.add;
1321: x_return_status := fnd_api.g_ret_sts_error;
1322: END IF;
1323: CLOSE c_territory_id;
1324: END IF;
1325: END validate_territory_id;

Line 1350: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1364: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1375: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1403: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1418: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1428: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1512: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1523: x_return_status := FND_API.G_RET_STS_SUCCESS;

1519: OPEN c_res_existence(l_select_id);
1520: FETCH c_res_existence INTO l_temp;
1521: IF c_res_existence%FOUND THEN
1522: x_found := TRUE;
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;
1524: CLOSE c_res_existence;
1525: return;
1526: ELSE
1527: x_found := FALSE;

Line 1528: x_return_status := FND_API.G_RET_STS_SUCCESS;

1524: CLOSE c_res_existence;
1525: return;
1526: ELSE
1527: x_found := FALSE;
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529: CLOSE c_res_existence;
1530: return;
1531: END IF;
1532: else

Line 1570: x_return_status := fnd_api.g_ret_sts_error;

1566:
1567: end if;
1568: ELSE
1569: --if object not found
1570: x_return_status := fnd_api.g_ret_sts_error;
1571: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RL_RES_TYPE');
1572: FND_MSG_PUB.add;
1573:
1574: END IF;

Line 1583: x_return_status := fnd_api.g_ret_sts_error;

1579:
1580: ELSE
1581:
1582: --IF object user code is not valid
1583: x_return_status := fnd_api.g_ret_sts_error;
1584: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_OBJ_USER_CODE');
1585: FND_MSG_PUB.add;
1586:
1587: END IF;

Line 1593: WHEN fnd_api.g_exc_unexpected_error

1589: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1590:
1591: EXCEPTION
1592:
1593: WHEN fnd_api.g_exc_unexpected_error
1594: THEN
1595: if object_code_cur%ISOPEN THEN
1596: close object_code_cur;
1597: end if;

Line 1603: WHEN fnd_api.g_exc_error

1599: close object_dtls_cur;
1600: end if;
1601: fnd_message.set_name ('JTF', 'JTF_OBJECT_ERR');
1602: FND_MSG_PUB.add;
1603: WHEN fnd_api.g_exc_error
1604: THEN
1605: null;
1606:
1607: WHEN OTHERS

Line 1620: x_return_status := fnd_api.g_ret_sts_unexp_error;

1616: fnd_message.set_token('P_SQLCODE',SQLCODE);
1617: fnd_message.set_token('P_SQLERRM',SQLERRM);
1618: fnd_message.set_token('P_API_NAME','CHECK_OBJECT_EXISTENCE');
1619: FND_MSG_PUB.add;
1620: x_return_status := fnd_api.g_ret_sts_unexp_error;
1621:
1622: END check_object_existence;
1623:
1624:

Line 1712: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1747: x_return_status := FND_API.G_RET_STS_SUCCESS;

1743: CLOSE emp_existence;
1744:
1745: if l_temp = 'x' then
1746: x_found := TRUE;
1747: x_return_status := FND_API.G_RET_STS_SUCCESS;
1748: return;
1749: else
1750: x_found := FALSE;
1751: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1751: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1759: x_return_status := FND_API.G_RET_STS_SUCCESS;

1755: OPEN c_party_existence(l_select_id);
1756: FETCH c_party_existence INTO l_party_id;
1757: IF c_party_existence%FOUND THEN
1758: x_found := TRUE;
1759: x_return_status := FND_API.G_RET_STS_SUCCESS;
1760: return;
1761: ELSE
1762: x_found := FALSE;
1763: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1763: x_return_status := FND_API.G_RET_STS_SUCCESS;

1759: x_return_status := FND_API.G_RET_STS_SUCCESS;
1760: return;
1761: ELSE
1762: x_found := FALSE;
1763: x_return_status := FND_API.G_RET_STS_SUCCESS;
1764: return;
1765: END IF;
1766: CLOSE c_party_existence;
1767:

Line 1790: x_return_status := fnd_api.g_ret_sts_unexp_error;

1786: DBMS_SQL.CLOSE_CURSOR(l_cursorid);
1787:
1788: ELSE
1789: --if object not found
1790: x_return_status := fnd_api.g_ret_sts_unexp_error;
1791: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RL_RES_TYPE');
1792: FND_MSG_PUB.add;
1793:
1794: END IF;

Line 1803: x_return_status := fnd_api.g_ret_sts_unexp_error;

1799:
1800: ELSE
1801:
1802: --IF object user code is not valid
1803: x_return_status := fnd_api.g_ret_sts_unexp_error;
1804: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_OBJ_USER_CODE');
1805: FND_MSG_PUB.add;
1806:
1807: END IF;

Line 1813: WHEN fnd_api.g_exc_unexpected_error

1809: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1810:
1811: EXCEPTION
1812:
1813: WHEN fnd_api.g_exc_unexpected_error
1814: THEN
1815: if object_code_cur%ISOPEN then
1816: close object_code_cur;
1817: end if;

Line 1824: x_return_status := fnd_api.g_ret_sts_unexp_error;

1820: end if;
1821:
1822: fnd_message.set_name ('JTF', 'JTF_OBJECT_ERR');
1823: FND_MSG_PUB.add;
1824: x_return_status := fnd_api.g_ret_sts_unexp_error;
1825: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1826:
1827: WHEN fnd_api.g_exc_error
1828: THEN

Line 1827: WHEN fnd_api.g_exc_error

1823: FND_MSG_PUB.add;
1824: x_return_status := fnd_api.g_ret_sts_unexp_error;
1825: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1826:
1827: WHEN fnd_api.g_exc_error
1828: THEN
1829: x_return_status := fnd_api.g_ret_sts_error;
1830: WHEN OTHERS
1831: THEN

Line 1829: x_return_status := fnd_api.g_ret_sts_error;

1825: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1826:
1827: WHEN fnd_api.g_exc_error
1828: THEN
1829: x_return_status := fnd_api.g_ret_sts_error;
1830: WHEN OTHERS
1831: THEN
1832: if object_code_cur%ISOPEN then
1833: close object_code_cur;

Line 1843: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1866: x_return_status := fnd_api.g_ret_sts_success;

1862: WHERE resource_param_id = p_resource_param_id;
1863:
1864: BEGIN
1865:
1866: x_return_status := fnd_api.g_ret_sts_success;
1867:
1868: IF p_resource_param_id IS NULL THEN
1869: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_PARAM_ID_NULL');
1870: fnd_msg_pub.add;

Line 1871: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1883: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1927: x_return_status := fnd_api.g_ret_sts_success;

1923: server_group_check varchar2(100);
1924:
1925: BEGIN
1926:
1927: x_return_status := fnd_api.g_ret_sts_success;
1928:
1929: fnd_profile.get('JTF_RS_SERVER_GROUP_CHECK',server_group_check);
1930:
1931: SELECT application_id

Line 1936: x_return_status := fnd_api.g_ret_sts_success;

1932: INTO c_application_id
1933: FROM jtf_rs_resource_params
1934: WHERE resource_param_id = p_resource_param_id;
1935:
1936: x_return_status := fnd_api.g_ret_sts_success;
1937: IF p_value_type IS NOT NULL THEN
1938:
1939: IF c_application_id = 172 THEN
1940: OPEN c_value_type_m (c_application_id);

Line 1949: x_return_status := fnd_api.g_ret_sts_error;

1945: fnd_message.set_name('JTF', 'JTF_RS_INVALID_VALUE_TYPE');
1946: fnd_message.set_token('P_VALUE_TYPE', p_value_type);
1947: fnd_msg_pub.add;
1948:
1949: x_return_status := fnd_api.g_ret_sts_error;
1950: END IF;
1951:
1952: CLOSE c_value_type_m;
1953:

Line 1962: x_return_status := fnd_api.g_ret_sts_error;

1958: IF c_value_type_no_sg_check%NOTFOUND THEN
1959: fnd_message.set_name('JTF', 'JTF_RS_INVALID_VALUE_TYPE');
1960: fnd_message.set_token('P_VALUE_TYPE', p_value_type);
1961: fnd_msg_pub.add;
1962: x_return_status := fnd_api.g_ret_sts_error;
1963: END IF;
1964: CLOSE c_value_type_no_sg_check;
1965: else
1966: OPEN c_value_type_e (c_application_id);

Line 1972: x_return_status := fnd_api.g_ret_sts_error;

1968: IF c_value_type_e%NOTFOUND THEN
1969: fnd_message.set_name('JTF', 'JTF_RS_INVALID_VALUE_TYPE');
1970: fnd_message.set_token('P_VALUE_TYPE', p_value_type);
1971: fnd_msg_pub.add;
1972: x_return_status := fnd_api.g_ret_sts_error;
1973: END IF;
1974: CLOSE c_value_type_e;
1975: end if;
1976: END IF;

Line 2014: x_return_status := fnd_api.g_ret_sts_success;

2010: FROM jtf_rs_resource_params
2011: WHERE resource_param_id = p_resource_param_id;
2012:
2013: p_length:=LENGTH(p_value);
2014: x_return_status := fnd_api.g_ret_sts_success;
2015: IF p_value IS NULL THEN
2016: fnd_message.set_name('JTF', 'JTF_RS_VALUE_NULL');
2017: fnd_msg_pub.add;
2018: x_return_status := fnd_api.g_ret_sts_error;

Line 2018: x_return_status := fnd_api.g_ret_sts_error;

2014: x_return_status := fnd_api.g_ret_sts_success;
2015: IF p_value IS NULL THEN
2016: fnd_message.set_name('JTF', 'JTF_RS_VALUE_NULL');
2017: fnd_msg_pub.add;
2018: x_return_status := fnd_api.g_ret_sts_error;
2019: END IF;
2020:
2021: OPEN c_lookup_code;
2022: FETCH c_lookup_code INTO l_lookup_code;

Line 2032: x_return_status := fnd_api.g_ret_sts_error;

2028: (SUBSTR(l_value,i,1)='6') or (SUBSTR(l_value,i,1)='7') or (SUBSTR(l_value,i,1)='8') or
2029: (SUBSTR(l_value,i,1)='9')) THEN
2030: fnd_message.set_name('JTF', 'JTF_RS_VALUE_ERR_DATA_TYPE');
2031: fnd_msg_pub.add;
2032: x_return_status := fnd_api.g_ret_sts_error;
2033: END IF;
2034: END LOOP;
2035: END IF;
2036: IF (p_length > to_number(v_length)) or (p_length = 0 ) THEN

Line 2039: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2067: x_return_status := fnd_api.g_ret_sts_success;

2063: FROM jtf_rs_roles_vl
2064: WHERE role_code = p_role_code;
2065:
2066: BEGIN
2067: x_return_status := fnd_api.g_ret_sts_success;
2068: IF p_role_id IS NULL AND p_role_code is NULL THEN
2069: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NULL');
2070: fnd_msg_pub.add;
2071: x_return_status := fnd_api.g_ret_sts_error;

Line 2071: x_return_status := fnd_api.g_ret_sts_error;

2067: x_return_status := fnd_api.g_ret_sts_success;
2068: IF p_role_id IS NULL AND p_role_code is NULL THEN
2069: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NULL');
2070: fnd_msg_pub.add;
2071: x_return_status := fnd_api.g_ret_sts_error;
2072: END IF;
2073:
2074: IF p_role_id IS NOT NULL THEN
2075: OPEN c_role_id;

Line 2081: x_return_status := fnd_api.g_ret_sts_error;

2077: IF c_role_id%NOTFOUND THEN
2078: fnd_message.set_name('JTF', 'JTF_RS_INVALID_ROLE');
2079: fnd_message.set_token('P_ROLE_ID', p_role_id);
2080: fnd_msg_pub.add;
2081: x_return_status := fnd_api.g_ret_sts_error;
2082: END IF;
2083: CLOSE c_role_id;
2084:
2085: ELSIF p_role_code IS NOT NULL THEN

Line 2092: x_return_status := fnd_api.g_ret_sts_error;

2088: IF c_role_code%NOTFOUND THEN
2089: fnd_message.set_name('JTF', 'JTF_RS_INVALID_ROLE_CODE');
2090: fnd_message.set_token('P_ROLE_CODE', p_role_code);
2091: fnd_msg_pub.add;
2092: x_return_status := fnd_api.g_ret_sts_error;
2093: END IF;
2094: CLOSE c_role_code;
2095: END IF;
2096:

Line 2110: x_return_status := fnd_api.g_ret_sts_success;

2106: IS
2107: l_rs_role_flag varchar2(1);
2108:
2109: BEGIN
2110: x_return_status := fnd_api.g_ret_sts_success;
2111: l_rs_role_flag := upper(p_rs_role_flag);
2112: IF ( l_rs_role_flag <> 'Y' and l_rs_role_flag <>'N') THEN
2113: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG');
2114: fnd_message.set_token('P_RS_ROLE_FLAG', p_rs_role_flag);

Line 2116: x_return_status := fnd_api.g_ret_sts_error;

2112: IF ( l_rs_role_flag <> 'Y' and l_rs_role_flag <>'N') THEN
2113: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG');
2114: fnd_message.set_token('P_RS_ROLE_FLAG', p_rs_role_flag);
2115: fnd_msg_pub.add;
2116: x_return_status := fnd_api.g_ret_sts_error;
2117: END IF;
2118: END validate_rs_role_flags;
2119:
2120: /* Function : get_g_miss_char */

Line 2124: return (fnd_api.g_miss_num);

2120: /* Function : get_g_miss_char */
2121:
2122: FUNCTION get_g_miss_num RETURN NUMBER is
2123: begin
2124: return (fnd_api.g_miss_num);
2125: end get_g_miss_num;
2126:
2127: /* Function : get_g_miss_char */
2128:

Line 2131: return (fnd_api.g_miss_char);

2127: /* Function : get_g_miss_char */
2128:
2129: FUNCTION get_g_miss_char RETURN VARCHAR2 is
2130: begin
2131: return (fnd_api.g_miss_char);
2132: end get_g_miss_char;
2133:
2134: /*Function : get_g_miss_date */
2135:

Line 2138: return (fnd_api.g_miss_date);

2134: /*Function : get_g_miss_date */
2135:
2136: FUNCTION get_g_miss_date RETURN DATE is
2137: begin
2138: return (fnd_api.g_miss_date);
2139: end get_g_miss_date;
2140:
2141:
2142: