DBA Data[Home] [Help]

APPS.JTF_CAL_SHIFT_CONSTRUCTS_PKG dependencies on FND_MESSAGE

Line 52: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');

48: fnd_msg_pub.initialize;
49: x_object_version_number := 1;
50:
51: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN
52: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');
53: fnd_msg_pub.ADD;
54: v_error := 'Y';
55: END IF;
56:

Line 58: fnd_message.set_name('JTF', 'JTF_CAL_END_TIME');

54: v_error := 'Y';
55: END IF;
56:
57: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN
58: fnd_message.set_name('JTF', 'JTF_CAL_END_TIME');
59: fnd_msg_pub.ADD;
60: v_error := 'Y';
61: END IF;
62:

Line 64: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');

60: v_error := 'Y';
61: END IF;
62:
63: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN
64: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');
65: fnd_msg_pub.ADD;
66: v_error := 'Y';
67: END IF;
68:

Line 70: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');

66: v_error := 'Y';
67: END IF;
68:
69: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN
70: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
71: fnd_message.set_token('P_Start_Date', x_start_date_active);
72: fnd_message.set_token('P_End_Date', x_end_date_active);
73: fnd_msg_pub.ADD;
74: v_error := 'Y';

Line 71: fnd_message.set_token('P_Start_Date', x_start_date_active);

67: END IF;
68:
69: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN
70: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
71: fnd_message.set_token('P_Start_Date', x_start_date_active);
72: fnd_message.set_token('P_End_Date', x_end_date_active);
73: fnd_msg_pub.ADD;
74: v_error := 'Y';
75: END IF;

Line 72: fnd_message.set_token('P_End_Date', x_end_date_active);

68:
69: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN
70: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
71: fnd_message.set_token('P_Start_Date', x_start_date_active);
72: fnd_message.set_token('P_End_Date', x_end_date_active);
73: fnd_msg_pub.ADD;
74: v_error := 'Y';
75: END IF;
76:

Line 79: fnd_message.set_name('JTF', 'JTF_CAL_AVAILABILITY_TYPE_CODE');

75: END IF;
76:
77:
78: IF jtf_cal_shift_constructs_pkg.not_null_char(x_availability_type_code) = FALSE THEN
79: fnd_message.set_name('JTF', 'JTF_CAL_AVAILABILITY_TYPE_CODE');
80: fnd_msg_pub.ADD;
81: v_error := 'Y';
82: END IF;
83:

Line 90: fnd_message.set_name('JTF', 'JTF_CAL_PATTERN_SHIFT');

86: FROM jtf_cal_shifts_b
87: WHERE shift_id = x_shift_id;
88:
89: IF p_rec = 0 THEN
90: fnd_message.set_name('JTF', 'JTF_CAL_PATTERN_SHIFT');
91: fnd_msg_pub.ADD;
92: v_error := 'Y';
93: END IF;
94:

Line 111: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');

107: FROM jtf_cal_shift_constructs
108: WHERE shift_construct_id = v_shift_construct_id;
109:
110: IF chk_shift > 0 THEN
111: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');
112: fnd_message.set_token('P_SHIFT_SEQ_NUM', v_shift_construct_id);
113: fnd_msg_pub.ADD;
114: v_error := 'Y';
115: x_error := 'Y';

Line 112: fnd_message.set_token('P_SHIFT_SEQ_NUM', v_shift_construct_id);

108: WHERE shift_construct_id = v_shift_construct_id;
109:
110: IF chk_shift > 0 THEN
111: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');
112: fnd_message.set_token('P_SHIFT_SEQ_NUM', v_shift_construct_id);
113: fnd_msg_pub.ADD;
114: v_error := 'Y';
115: x_error := 'Y';
116: RETURN;

Line 235: -- fnd_message.set_name('JTF', 'JTF_FM_ADMIN_ADDERROR');

231: , x_object_version_number
232: );
233: EXCEPTION
234: WHEN OTHERS THEN
235: -- fnd_message.set_name('JTF', 'JTF_FM_ADMIN_ADDERROR');
236: fnd_message.set_name('JTF', SQLERRM);
237: fnd_msg_pub.ADD;
238: v_error := 'Y';
239: x_error := 'Y';

Line 236: fnd_message.set_name('JTF', SQLERRM);

232: );
233: EXCEPTION
234: WHEN OTHERS THEN
235: -- fnd_message.set_name('JTF', 'JTF_FM_ADMIN_ADDERROR');
236: fnd_message.set_name('JTF', SQLERRM);
237: fnd_msg_pub.ADD;
238: v_error := 'Y';
239: x_error := 'Y';
240: END;

Line 352: fnd_message.set_name('JTF', 'FORM_RECORD_CHANGED');

348: )
349: ) THEN
350: NULL;
351: ELSE
352: fnd_message.set_name('JTF', 'FORM_RECORD_CHANGED');
353: fnd_msg_pub.ADD;
354: v_error := 'Y';
355: -- fnd_message.set_name('JTF', 'FORM_RECORD_CHANGED');
356: -- app_exception.raise_exception;

Line 355: -- fnd_message.set_name('JTF', 'FORM_RECORD_CHANGED');

351: ELSE
352: fnd_message.set_name('JTF', 'FORM_RECORD_CHANGED');
353: fnd_msg_pub.ADD;
354: v_error := 'Y';
355: -- fnd_message.set_name('JTF', 'FORM_RECORD_CHANGED');
356: -- app_exception.raise_exception;
357: END IF;
358:
359: IF v_error = 'Y' THEN

Line 368: fnd_message.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');

364:
365: RETURN;
366: EXCEPTION
367: WHEN app_exception.record_lock_exception THEN
368: fnd_message.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
369: fnd_msg_pub.ADD;
370: v_error := 'Y';
371:
372: IF v_error = 'Y' THEN

Line 414: --fnd_message.set_name('JTF', 'BEGIN_TIME CANNOT BE NULL');

410: BEGIN
411: fnd_msg_pub.initialize;
412:
413: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN
414: --fnd_message.set_name('JTF', 'BEGIN_TIME CANNOT BE NULL');
415: --app_exception.raise_exception;
416: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');
417: --fnd_message.set_token('P_Name', 'BEGIN_TIME');
418: fnd_msg_pub.ADD;

Line 416: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');

412:
413: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN
414: --fnd_message.set_name('JTF', 'BEGIN_TIME CANNOT BE NULL');
415: --app_exception.raise_exception;
416: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');
417: --fnd_message.set_token('P_Name', 'BEGIN_TIME');
418: fnd_msg_pub.ADD;
419: v_error := 'Y';
420: END IF;

Line 417: --fnd_message.set_token('P_Name', 'BEGIN_TIME');

413: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN
414: --fnd_message.set_name('JTF', 'BEGIN_TIME CANNOT BE NULL');
415: --app_exception.raise_exception;
416: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');
417: --fnd_message.set_token('P_Name', 'BEGIN_TIME');
418: fnd_msg_pub.ADD;
419: v_error := 'Y';
420: END IF;
421:

Line 423: --fnd_message.set_name('JTF', 'END_TIME CANNOT BE NULL');

419: v_error := 'Y';
420: END IF;
421:
422: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN
423: --fnd_message.set_name('JTF', 'END_TIME CANNOT BE NULL');
424: --app_exception.raise_exception;
425: fnd_message.set_name('JTF', 'JTF_CAL_END_TIME');
426: --fnd_message.set_token('P_Name', 'END_TIME');
427: fnd_msg_pub.ADD;

Line 425: fnd_message.set_name('JTF', 'JTF_CAL_END_TIME');

421:
422: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN
423: --fnd_message.set_name('JTF', 'END_TIME CANNOT BE NULL');
424: --app_exception.raise_exception;
425: fnd_message.set_name('JTF', 'JTF_CAL_END_TIME');
426: --fnd_message.set_token('P_Name', 'END_TIME');
427: fnd_msg_pub.ADD;
428: v_error := 'Y';
429: END IF;

Line 426: --fnd_message.set_token('P_Name', 'END_TIME');

422: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN
423: --fnd_message.set_name('JTF', 'END_TIME CANNOT BE NULL');
424: --app_exception.raise_exception;
425: fnd_message.set_name('JTF', 'JTF_CAL_END_TIME');
426: --fnd_message.set_token('P_Name', 'END_TIME');
427: fnd_msg_pub.ADD;
428: v_error := 'Y';
429: END IF;
430:

Line 432: --fnd_message.set_name('JTF', 'START_TIME IS GREATER THAN END_TIME');

428: v_error := 'Y';
429: END IF;
430:
431: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN
432: --fnd_message.set_name('JTF', 'START_TIME IS GREATER THAN END_TIME');
433: --app_exception.raise_exception;
434: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');
435: --fnd_message.set_token('P_Start_Date', X_BEGIN_TIME);
436: --fnd_message.set_token('P_End_Date', X_END_TIME);

Line 434: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');

430:
431: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN
432: --fnd_message.set_name('JTF', 'START_TIME IS GREATER THAN END_TIME');
433: --app_exception.raise_exception;
434: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');
435: --fnd_message.set_token('P_Start_Date', X_BEGIN_TIME);
436: --fnd_message.set_token('P_End_Date', X_END_TIME);
437: fnd_msg_pub.ADD;
438: v_error := 'Y';

Line 435: --fnd_message.set_token('P_Start_Date', X_BEGIN_TIME);

431: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN
432: --fnd_message.set_name('JTF', 'START_TIME IS GREATER THAN END_TIME');
433: --app_exception.raise_exception;
434: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');
435: --fnd_message.set_token('P_Start_Date', X_BEGIN_TIME);
436: --fnd_message.set_token('P_End_Date', X_END_TIME);
437: fnd_msg_pub.ADD;
438: v_error := 'Y';
439: END IF;

Line 436: --fnd_message.set_token('P_End_Date', X_END_TIME);

432: --fnd_message.set_name('JTF', 'START_TIME IS GREATER THAN END_TIME');
433: --app_exception.raise_exception;
434: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');
435: --fnd_message.set_token('P_Start_Date', X_BEGIN_TIME);
436: --fnd_message.set_token('P_End_Date', X_END_TIME);
437: fnd_msg_pub.ADD;
438: v_error := 'Y';
439: END IF;
440:

Line 442: --fnd_message.set_name('JTF', 'START_DATE IS GREATER THAN END DATE');

438: v_error := 'Y';
439: END IF;
440:
441: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN
442: --fnd_message.set_name('JTF', 'START_DATE IS GREATER THAN END DATE');
443: --app_exception.raise_exception;
444: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
445: fnd_message.set_token('P_Start_Date', x_start_date_active);
446: fnd_message.set_token('P_End_Date', x_end_date_active);

Line 444: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');

440:
441: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN
442: --fnd_message.set_name('JTF', 'START_DATE IS GREATER THAN END DATE');
443: --app_exception.raise_exception;
444: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
445: fnd_message.set_token('P_Start_Date', x_start_date_active);
446: fnd_message.set_token('P_End_Date', x_end_date_active);
447: fnd_msg_pub.ADD;
448: v_error := 'Y';

Line 445: fnd_message.set_token('P_Start_Date', x_start_date_active);

441: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN
442: --fnd_message.set_name('JTF', 'START_DATE IS GREATER THAN END DATE');
443: --app_exception.raise_exception;
444: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
445: fnd_message.set_token('P_Start_Date', x_start_date_active);
446: fnd_message.set_token('P_End_Date', x_end_date_active);
447: fnd_msg_pub.ADD;
448: v_error := 'Y';
449: END IF;

Line 446: fnd_message.set_token('P_End_Date', x_end_date_active);

442: --fnd_message.set_name('JTF', 'START_DATE IS GREATER THAN END DATE');
443: --app_exception.raise_exception;
444: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
445: fnd_message.set_token('P_Start_Date', x_start_date_active);
446: fnd_message.set_token('P_End_Date', x_end_date_active);
447: fnd_msg_pub.ADD;
448: v_error := 'Y';
449: END IF;
450:

Line 453: --fnd_message.set_name('JTF', 'AVAILABILITY_TYPE_CODE CANNOT BE NULL');

449: END IF;
450:
451: /*
452: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.NOT_NULL(X_AVAILABILITY_TYPE_CODE) = FALSE THEN
453: --fnd_message.set_name('JTF', 'AVAILABILITY_TYPE_CODE CANNOT BE NULL');
454: --app_exception.raise_exception;
455: fnd_message.set_name('JTF', 'JTF_CAL_AVAILABILITY_TYPE_CODE');
456: --fnd_message.set_token('P_Name', 'AVAILABILITY_TYPE_CODE');
457: fnd_msg_pub.add;

Line 455: fnd_message.set_name('JTF', 'JTF_CAL_AVAILABILITY_TYPE_CODE');

451: /*
452: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.NOT_NULL(X_AVAILABILITY_TYPE_CODE) = FALSE THEN
453: --fnd_message.set_name('JTF', 'AVAILABILITY_TYPE_CODE CANNOT BE NULL');
454: --app_exception.raise_exception;
455: fnd_message.set_name('JTF', 'JTF_CAL_AVAILABILITY_TYPE_CODE');
456: --fnd_message.set_token('P_Name', 'AVAILABILITY_TYPE_CODE');
457: fnd_msg_pub.add;
458: v_error := 'Y';
459: END IF;

Line 456: --fnd_message.set_token('P_Name', 'AVAILABILITY_TYPE_CODE');

452: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.NOT_NULL(X_AVAILABILITY_TYPE_CODE) = FALSE THEN
453: --fnd_message.set_name('JTF', 'AVAILABILITY_TYPE_CODE CANNOT BE NULL');
454: --app_exception.raise_exception;
455: fnd_message.set_name('JTF', 'JTF_CAL_AVAILABILITY_TYPE_CODE');
456: --fnd_message.set_token('P_Name', 'AVAILABILITY_TYPE_CODE');
457: fnd_msg_pub.add;
458: v_error := 'Y';
459: END IF;
460:

Line 463: -- fnd_message.set_name('JTF', 'AVAILABILITY_TYPE_CODE DOES NOT EXIST IN FND_LOOKUPS');

459: END IF;
460:
461: --IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.VALIDATE_FND_LOOKUPS(X_AVAILABILITY_TYPE_CODE, 'AVAILABILITY TYPE')
462: -- = FALSE THEN
463: -- fnd_message.set_name('JTF', 'AVAILABILITY_TYPE_CODE DOES NOT EXIST IN FND_LOOKUPS');
464: -- app_exception.raise_exception;
465: -- v_error := 'Y';
466: --END IF;
467:

Line 471: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');

467:
468: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.DUPLICATION_SHIFT(X_SHIFT_ID, X_UNIT_OF_TIME_VALUE,
469: X_BEGIN_TIME, X_END_TIME,
470: X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
471: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');
472: --app_exception.raise_exception;
473: fnd_message.set_name('JTF', 'JTF_CAL_ALREADY_EXISTS');
474: fnd_message.set_token('P_Name', 'SHIFT');
475: fnd_msg_pub.add;

Line 473: fnd_message.set_name('JTF', 'JTF_CAL_ALREADY_EXISTS');

469: X_BEGIN_TIME, X_END_TIME,
470: X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
471: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');
472: --app_exception.raise_exception;
473: fnd_message.set_name('JTF', 'JTF_CAL_ALREADY_EXISTS');
474: fnd_message.set_token('P_Name', 'SHIFT');
475: fnd_msg_pub.add;
476: v_error := 'Y';
477: END IF;

Line 474: fnd_message.set_token('P_Name', 'SHIFT');

470: X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
471: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');
472: --app_exception.raise_exception;
473: fnd_message.set_name('JTF', 'JTF_CAL_ALREADY_EXISTS');
474: fnd_message.set_token('P_Name', 'SHIFT');
475: fnd_msg_pub.add;
476: v_error := 'Y';
477: END IF;
478: */

Line 480: --fnd_message.set_name('JTF', 'START_DATE_ACTIVE CANNOT BE NULL');

476: v_error := 'Y';
477: END IF;
478: */
479: IF jtf_cal_shift_constructs_pkg.not_null(x_start_date_active) = FALSE THEN
480: --fnd_message.set_name('JTF', 'START_DATE_ACTIVE CANNOT BE NULL');
481: --app_exception.raise_exception;
482: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
483: fnd_msg_pub.ADD;
484: v_error := 'Y';

Line 482: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');

478: */
479: IF jtf_cal_shift_constructs_pkg.not_null(x_start_date_active) = FALSE THEN
480: --fnd_message.set_name('JTF', 'START_DATE_ACTIVE CANNOT BE NULL');
481: --app_exception.raise_exception;
482: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
483: fnd_msg_pub.ADD;
484: v_error := 'Y';
485: END IF;
486:

Line 494: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');

490: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.OVERLAP_SHIFT(X_SHIFT_ID, X_UNIT_OF_TIME_VALUE,
491: X_BEGIN_TIME, X_END_TIME,
492: X_START_DATE_ACTIVE, X_END_DATE_ACTIVE,
493: X_SHIFT_CONSTRUCT_ID) = FALSE THEN
494: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');
495: --app_exception.raise_exception;
496: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_PATTERN_OVERLAPS');
497: fnd_msg_pub.add;
498: v_error := 'Y';

Line 496: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_PATTERN_OVERLAPS');

492: X_START_DATE_ACTIVE, X_END_DATE_ACTIVE,
493: X_SHIFT_CONSTRUCT_ID) = FALSE THEN
494: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');
495: --app_exception.raise_exception;
496: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_PATTERN_OVERLAPS');
497: fnd_msg_pub.add;
498: v_error := 'Y';
499: END IF;
500: */

Line 577: fnd_message.set_name('JTF', 'JTF_FM_ADMIN_EDITERROR');

573: , object_version_number = NVL(object_version_number, 0) + 1
574: WHERE shift_construct_id = x_shift_construct_id;
575: EXCEPTION
576: WHEN OTHERS THEN
577: fnd_message.set_name('JTF', 'JTF_FM_ADMIN_EDITERROR');
578: fnd_msg_pub.ADD;
579: v_error := 'Y';
580: x_error := 'Y';
581: END;

Line 605: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_DEL_VAL');

601:
602: CLOSE c_sh_exist_in_task_assmt;
603:
604: IF NVL(l_exists, 2) = 1 THEN
605: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_DEL_VAL');
606: fnd_msg_pub.ADD;
607: v_error := 'Y';
608: END IF;
609: