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_MESSAGE

Line 100: fnd_message.set_name ('JTF', 'JTF_RS_MISSING_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 ;
103: --x_return_status :=fnd_api.g_ret_sts_error;
104: RAISE fnd_api.g_exc_error;

Line 101: fnd_message.set_token('P_PROCEDURE',i.hook_PACKAGE || '.' ||i.hook_api);

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 ;
103: --x_return_status :=fnd_api.g_ret_sts_error;
104: RAISE fnd_api.g_exc_error;
105: END IF;

Line 108: fnd_message.set_name ('JTF', 'JTF_RS_MISSING_RETURN_STATUS');

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');
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 ;

Line 122: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_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);
124: fnd_message.set_token('P_SQLERRM',SQLERRM);
125: fnd_message.set_token('P_API_NAME','CALL_INTERNAL_HOOK');
126: FND_MSG_PUB.add;

Line 123: fnd_message.set_token('P_SQLCODE',SQLCODE);

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);
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;

Line 124: fnd_message.set_token('P_SQLERRM',SQLERRM);

120: WHEN OTHERS
121: THEN
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:

Line 125: fnd_message.set_token('P_API_NAME','CALL_INTERNAL_HOOK');

121: THEN
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;

Line 160: fnd_message.set_name('JTF', 'JTF_RS_GROUP_NULL');

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');
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:

Line 178: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');

174: IF c_group_id%NOTFOUND THEN
175:
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;

Line 179: fnd_message.set_token('P_GROUP_ID', p_group_id);

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

Line 198: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP_NUMBER');

194: IF c_group_number%NOTFOUND THEN
195:
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;

Line 199: fnd_message.set_token('P_GROUP_NUMBER', p_group_number);

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

Line 245: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');

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');
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:

Line 263: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');

259: IF c_resource_id%NOTFOUND THEN
260:
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;

Line 264: fnd_message.set_token('P_RESOURCE_ID', p_resource_id);

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

Line 283: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');

279: IF c_resource_number%NOTFOUND THEN
280:
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;

Line 284: fnd_message.set_token('P_RESOURCE_NUMBER', p_resource_number);

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

Line 315: fnd_message.set_name('JTF', 'JTF_RS_START_DATE_NULL');

311: IF p_start_date_active IS NULL THEN
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:

Line 335: fnd_message.set_name('JTF', 'JTF_RS_ERR_STDT_GREATER_EDDT');

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

Line 372: fnd_message.set_name('JTF', 'JTF_RS_USAGE_NULL');

368: IF p_usage IS NULL THEN
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:

Line 389: fnd_message.set_name('JTF', 'JTF_RS_INVALID_USAGE');

385: IF c_usage%NOTFOUND THEN
386:
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;

Line 390: fnd_message.set_token('P_USAGE', p_usage);

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

Line 436: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_CATEGORY_NULL');

432: IF p_category IS NULL THEN
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:

Line 453: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RES_CATEGORY');

449: IF c_resource_category%NOTFOUND THEN
450:
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;

Line 454: fnd_message.set_token('P_RESOURCE_CATEGORY', p_category);

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

Line 526: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');

522: OPEN c_emp_dup_source_id;
523: FETCH c_emp_dup_source_id into check_num;
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;

Line 527: fnd_message.set_token('P_SOURCE_ID', p_source_id);

523: FETCH c_emp_dup_source_id into check_num;
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;

Line 538: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');

534: ELSIF p_category = 'WORKER' THEN
535: OPEN c_cwk_dup_source_id;
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;

Line 539: fnd_message.set_token('P_SOURCE_ID', p_source_id);

535: OPEN c_cwk_dup_source_id;
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;

Line 550: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');

546: OPEN c_party_dup_source_id;
547: FETCH c_party_dup_source_id into check_num;
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;

Line 551: fnd_message.set_token('P_SOURCE_ID', p_source_id);

547: FETCH c_party_dup_source_id into check_num;
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;

Line 562: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');

558: OPEN c_vend_dup_source_id;
559: FETCH c_vend_dup_source_id into check_num;
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;

Line 563: fnd_message.set_token('P_SOURCE_ID', p_source_id);

559: FETCH c_vend_dup_source_id into check_num;
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;

Line 574: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');

570: OPEN c_partner_dup_source_id;
571: FETCH c_partner_dup_source_id into check_num;
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;

Line 575: fnd_message.set_token('P_SOURCE_ID', p_source_id);

571: FETCH c_partner_dup_source_id into check_num;
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;

Line 586: fnd_message.set_name('JTF', 'JTF_RS_DUP_SOURCE_ID');

582: OPEN c_ven_dup_source_id;
583: FETCH c_ven_dup_source_id into check_num;
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;

Line 587: fnd_message.set_token('P_SOURCE_ID', p_source_id);

583: FETCH c_ven_dup_source_id into check_num;
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;

Line 626: fnd_message.set_name('JTF', 'JTF_RS_INVALID_EMP_RESOURCE_ID');

622: OPEN c_ppf_person_id;
623: FETCH c_ppf_person_id INTO x_emp_resource_id;
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;

Line 627: fnd_message.set_token('P_EMP_RESOURCE_ID', p_emp_resource_id);

623: FETCH c_ppf_person_id INTO x_emp_resource_id;
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;

Line 638: -- fnd_message.set_name('JTF', 'JTF_RS_INVALID_EMP_RES_NUMBER');

634: -- OPEN c_ppf_emp_num;
635: -- FETCH c_ppf_emp_num INTO x_emp_resource_id;
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;

Line 639: -- fnd_message.set_token('P_EMP_RESOURCE_NUMBER', p_emp_resource_number);

635: -- FETCH c_ppf_emp_num INTO x_emp_resource_id;
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;

Line 676: fnd_message.set_name('JTF', 'JTF_RS_TIME_ZONE_NULL');

672: IF p_time_zone_id IS NULL THEN
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:

Line 693: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TIME_ZONE');

689: IF c_time_zone_id%NOTFOUND THEN
690:
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;

Line 694: fnd_message.set_token('P_TIME_ZONE_ID', p_time_zone_id);

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

Line 731: fnd_message.set_name('JTF', 'JTF_RS_LANGUAGE_NULL');

727: IF p_nls_language IS NULL THEN
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:

Line 748: fnd_message.set_name('JTF', 'JTF_RS_INVALID_LANGUAGE');

744: IF c_nls_language%NOTFOUND THEN
745:
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;

Line 749: fnd_message.set_token('P_LANGUAGE', p_nls_language);

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

Line 789: fnd_message.set_name('JTF', 'JTF_RS_SUPPORT_SITE_NULL');

785: IF p_support_site_id IS NULL THEN
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:

Line 806: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SUPPORT_SITE');

802: IF c_support_site_id%NOTFOUND THEN
803:
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;

Line 807: fnd_message.set_token('P_SUPPORT_SITE_ID', p_support_site_id);

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

Line 854: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRV_GROUP_ID');

850: IF c_server_group_id%NOTFOUND THEN
851:
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;

Line 855: fnd_message.set_token('P_SERVER_GROUP_ID', p_server_group_id);

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

Line 874: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SVR_GROUP_NAME');

870: IF c_server_group_name%NOTFOUND THEN
871:
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;

Line 875: fnd_message.set_token('P_SERVER_GROUP_NAME', p_server_group_name);

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

Line 912: fnd_message.set_name('JTF', 'JTF_RS_CURRENCY_NULL');

908: IF p_currency_code IS NULL THEN
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:

Line 929: fnd_message.set_name('JTF', 'JTF_RS_INVALID_CURRENCY');

925: IF c_currency_code%NOTFOUND THEN
926:
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;

Line 930: fnd_message.set_token('P_CURRENCY', p_currency_code);

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

Line 968: fnd_message.set_name('JTF', 'JTF_RS_HOLD_REASON_CODE_NULL');

964: IF p_hold_reason_code IS NULL THEN
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:

Line 985: fnd_message.set_name('JTF', 'JTF_RS_INVALID_HOLD_REASON_COD');

981: IF c_hold_reason_code%NOTFOUND THEN
982:
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;

Line 986: fnd_message.set_token('P_HOLD_REASON_CODE', p_hold_reason_code);

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

Line 1029: fnd_message.set_name('JTF', 'JTF_RS_TEAM_NULL');

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');
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:

Line 1047: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM');

1043: IF c_team_id%NOTFOUND THEN
1044:
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;

Line 1048: fnd_message.set_token('P_TEAM_ID', p_team_id);

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

Line 1067: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_NUMBER');

1063: IF c_team_number%NOTFOUND THEN
1064:
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;

Line 1068: fnd_message.set_token('P_TEAM_NUMBER', p_team_number);

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

Line 1109: fnd_message.set_name('JTF', 'JTF_RS_USER_ID_NULL');

1105: IF p_user_id IS NULL THEN
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:

Line 1126: fnd_message.set_name('JTF', 'JTF_RS_INVALID_USER_ID');

1122: IF c_user_id%NOTFOUND THEN
1123:
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;

Line 1127: fnd_message.set_token('P_USER_ID', p_user_id);

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

Line 1165: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_ID_NULL');

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;
1167: x_return_status := fnd_api.g_ret_sts_error;
1168: END IF;
1169: IF p_salesrep_id IS NOT NULL THEN

Line 1174: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');

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

Line 1175: fnd_message.set_token('P_SALESREP_ID', p_salesrep_id);

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

Line 1282: fnd_message.set_name('JTF', 'JTF_RS_SRP_STDT_GRTR_RES_STDT');

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

Line 1288: fnd_message.set_name('JTF', 'JTF_RS_SRP_EDDT_GRTR_RES_EDDT');

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');
1289: fnd_msg_pub.add;
1290: x_return_status := fnd_api.g_ret_sts_error;
1291: END IF;
1292:

Line 1313: fnd_message.set_name('JTF', 'JTF_RS_TERRITORY_ID_NULL');

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;
1315: x_return_status := fnd_api.g_ret_sts_error;
1316: END IF;
1317: IF p_territory_id IS NOT NULL THEN

Line 1322: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TERRITORY_ID');

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

Line 1323: fnd_message.set_token('P_TERRITORY_ID', p_territory_id);

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

Line 1364: fnd_message.set_name('JTF', 'JTF_RS_ERR_SALESREP_NUMBER');

1360:
1361: FETCH c_salesrep_number INTO l_val;
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;

Line 1365: fnd_message.set_token('P_SALESREP_NUMBER', p_salesrep_number);

1361: FETCH c_salesrep_number INTO l_val;
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:

Line 1376: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_NUMBER_NULL');

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

Line 1418: fnd_message.set_name('JTF', 'JTF_RS_ERR_SALES_CREDIT_TYPE');

1414: FETCH c_credit_type INTO l_val;
1415:
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;

Line 1419: fnd_message.set_token('P_SALES_CREDIT_TYPE_ID', p_sales_credit_type_id);

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

Line 1430: fnd_message.set_name('JTF', 'JTF_RS_SALES_CREDIT_TYPE_NULL');

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

Line 1575: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RL_RES_TYPE');

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

Line 1588: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_OBJ_USER_CODE');

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

Line 1605: fnd_message.set_name ('JTF', 'JTF_OBJECT_ERR');

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

Line 1619: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1615: end if;
1616: if object_dtls_cur%ISOPEN THEN
1617: close object_dtls_cur;
1618: end if;
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;

Line 1620: fnd_message.set_token('P_SQLCODE',SQLCODE);

1616: if object_dtls_cur%ISOPEN THEN
1617: close object_dtls_cur;
1618: end if;
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;

Line 1621: fnd_message.set_token('P_SQLERRM',SQLERRM);

1617: close object_dtls_cur;
1618: end if;
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:

Line 1622: fnd_message.set_token('P_API_NAME','CHECK_OBJECT_EXISTENCE');

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

Line 1795: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RL_RES_TYPE');

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

Line 1808: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_OBJ_USER_CODE');

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

Line 1826: fnd_message.set_name ('JTF', 'JTF_OBJECT_ERR');

1822: if object_dtls_cur%ISOPEN then
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:

Line 1842: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1838: end if;
1839: if object_dtls_cur%ISOPEN then
1840: close object_dtls_cur;
1841: end if;
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;

Line 1843: fnd_message.set_token('P_SQLCODE',SQLCODE);

1839: if object_dtls_cur%ISOPEN then
1840: close object_dtls_cur;
1841: end if;
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;

Line 1844: fnd_message.set_token('P_SQLERRM',SQLERRM);

1840: close object_dtls_cur;
1841: end if;
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);

Line 1845: fnd_message.set_token('P_API_NAME','CHECK_OBJECT_EXISTENCE_MIGR');

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

Line 1873: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_PARAM_ID_NULL');

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;
1875: x_return_status := fnd_api.g_ret_sts_error;
1876: END IF;
1877:

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

1880: OPEN c_resource_param_id;
1881: FETCH c_resource_param_id INTO l_resource_param_id;
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;

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

1881: FETCH c_resource_param_id INTO l_resource_param_id;
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;

Line 1949: fnd_message.set_name('JTF', 'JTF_RS_INVALID_VALUE_TYPE');

1945: FETCH c_value_type_m INTO l_value_type;
1946:
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;

Line 1950: fnd_message.set_token('P_VALUE_TYPE', p_value_type);

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

Line 1963: fnd_message.set_name('JTF', 'JTF_RS_INVALID_VALUE_TYPE');

1959: if server_group_check = 'N' then
1960: OPEN c_value_type_no_sg_check;
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;

Line 1964: fnd_message.set_token('P_VALUE_TYPE', p_value_type);

1960: OPEN c_value_type_no_sg_check;
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;

Line 1973: fnd_message.set_name('JTF', 'JTF_RS_INVALID_VALUE_TYPE');

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

Line 1974: fnd_message.set_token('P_VALUE_TYPE', p_value_type);

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

Line 2020: fnd_message.set_name('JTF', 'JTF_RS_VALUE_NULL');

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

Line 2034: fnd_message.set_name('JTF', 'JTF_RS_VALUE_ERR_DATA_TYPE');

2030: IF NOT ((SUBSTR(l_value,i,1)='0') or (SUBSTR(l_value,i,1)='1') or (SUBSTR(l_value,i,1)='2') or
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;

Line 2041: fnd_message.set_name('JTF', 'JTF_RS_VALUE_INCORRECT_LENGTH');

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

Line 2073: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NULL');

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

Line 2082: fnd_message.set_name('JTF', 'JTF_RS_INVALID_ROLE');

2078: IF p_role_id IS NOT NULL THEN
2079: OPEN c_role_id;
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;

Line 2083: fnd_message.set_token('P_ROLE_ID', p_role_id);

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

Line 2093: fnd_message.set_name('JTF', 'JTF_RS_INVALID_ROLE_CODE');

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

Line 2094: fnd_message.set_token('P_ROLE_CODE', p_role_code);

2090: OPEN c_role_code;
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;

Line 2117: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG');

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);
2119: fnd_msg_pub.add;
2120: x_return_status := fnd_api.g_ret_sts_error;
2121: END IF;

Line 2118: fnd_message.set_token('P_RS_ROLE_FLAG', p_rs_role_flag);

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);
2119: fnd_msg_pub.add;
2120: x_return_status := fnd_api.g_ret_sts_error;
2121: END IF;
2122: END validate_rs_role_flags;