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_CAL_SHIFT_CONSTRUCTS_PKG dependencies on JTF_CAL_SHIFT_CONSTRUCTS_PKG

Line 1: PACKAGE BODY jtf_cal_shift_constructs_pkg AS

1: PACKAGE BODY jtf_cal_shift_constructs_pkg AS
2: /* $Header: jtfclscb.pls 120.4 2011/03/22 06:24:46 anangupt ship $ */
3: PROCEDURE insert_row(
4: x_error OUT NOCOPY VARCHAR2
5: , x_rowid IN OUT NOCOPY VARCHAR2

Line 51: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN

47: BEGIN
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;

Line 57: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN

53: fnd_msg_pub.ADD;
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;

Line 63: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN

59: fnd_msg_pub.ADD;
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;

Line 69: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN

65: fnd_msg_pub.ADD;
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', fnd_date.date_to_chardate(dateval=>x_start_date_active,calendar_aware=>fnd_date.calendar_aware));
72: fnd_message.set_token('P_End_Date', fnd_date.date_to_chardate(dateval=>x_end_date_active,calendar_aware=>fnd_date.calendar_aware));
73: fnd_msg_pub.ADD;

Line 78: IF jtf_cal_shift_constructs_pkg.not_null_char(x_availability_type_code) = FALSE THEN

74: v_error := 'Y';
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;

Line 126: 'JTF_CAL_SHIFT_CONSTRUCTS_PKG',

122: /* Add User Hook Check for INSERT by Jane Wang on 01/25/02 */
123: /* Comment the User Hook Check out by Jane Wang on 03/12/02 */
124: /*
125: IF jtf_usr_hks.ok_to_execute(
126: 'JTF_CAL_SHIFT_CONSTRUCTS_PKG',
127: 'INSERT_ROW',
128: 'B',
129: 'C')
130: THEN

Line 413: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN

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

Line 422: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN

418: fnd_msg_pub.ADD;
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');

Line 431: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN

427: fnd_msg_pub.ADD;
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);

Line 441: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN

437: fnd_msg_pub.ADD;
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', fnd_date.date_to_chardate(dateval=>x_start_date_active,calendar_aware=>fnd_date.calendar_aware));

Line 452: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.NOT_NULL(X_AVAILABILITY_TYPE_CODE) = FALSE THEN

448: v_error := 'Y';
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');

Line 461: --IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.VALIDATE_FND_LOOKUPS(X_AVAILABILITY_TYPE_CODE, 'AVAILABILITY TYPE')

457: fnd_msg_pub.add;
458: v_error := 'Y';
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';

Line 468: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.DUPLICATION_SHIFT(X_SHIFT_ID, X_UNIT_OF_TIME_VALUE,

464: -- app_exception.raise_exception;
465: -- v_error := 'Y';
466: --END IF;
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;

Line 479: IF jtf_cal_shift_constructs_pkg.not_null(x_start_date_active) = FALSE THEN

475: fnd_msg_pub.add;
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;

Line 490: IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.OVERLAP_SHIFT(X_SHIFT_ID, X_UNIT_OF_TIME_VALUE,

486:
487: -- Comment out by Jane Wang on 03/12/2002
488: -- To allow a user to define two shift patterns for the same day
489: /*
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');

Line 510: 'JTF_CAL_SHIFT_CONSTRUCTS_PKG',

506: /* Comment the User Hook Check by Jane Wang on 03/12/02 */
507:
508: /*
509: IF jtf_usr_hks.ok_to_execute(
510: 'JTF_CAL_SHIFT_CONSTRUCTS_PKG',
511: 'UPDATE_ROW',
512: 'B',
513: 'C')
514: THEN

Line 883: END jtf_cal_shift_constructs_pkg;

879: END IF;
880: end loop;
881: END overlap_shift;
882: */
883: END jtf_cal_shift_constructs_pkg;