DBA Data[Home] [Help]

APPS.JTF_CAL_SHIFTS_PKG dependencies on JTF_CAL_SHIFTS_PKG

Line 1: package body JTF_CAL_SHIFTS_PKG as

1: package body JTF_CAL_SHIFTS_PKG as
2: /* $Header: jtfclshb.pls 115.20 2003/06/09 11:34:24 abraina ship $ */
3: procedure INSERT_ROW (
4: X_ERROR out NOCOPY VARCHAR2,
5: X_ROWID in out NOCOPY VARCHAR2,

Line 41: IF JTF_CAL_SHIFTS_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN

37: cursor C is select ROWID from JTF_CAL_SHIFTS_B
38: where SHIFT_ID = X_SHIFT_ID;
39: begin
40: fnd_msg_pub.initialize;
41: IF JTF_CAL_SHIFTS_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN
42: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
43: --app_exception.raise_exception;
44: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
45: fnd_msg_pub.add;

Line 51: IF JTF_CAL_SHIFTS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN

47: v_error := 'Y';
48: END IF;
49:
50:
51: IF JTF_CAL_SHIFTS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
52: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
53: --app_exception.raise_exception;
54: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
55: fnd_message.set_token('P_Start_Date', X_START_DATE_ACTIVE);

Line 97: 'JTF_CAL_SHIFTS_PKG',

93: /*
94:
95: -- Add User Hook Check for INSERT by Jane Wang on 01/25/02
96: IF jtf_usr_hks.ok_to_execute(
97: 'JTF_CAL_SHIFTS_PKG',
98: 'INSERT_ROW',
99: 'B',
100: 'C')
101: THEN

Line 392: IF JTF_CAL_SHIFTS_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN

388:
389: v_error CHAR := 'N';
390: begin
391: fnd_msg_pub.initialize;
392: IF JTF_CAL_SHIFTS_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN
393: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
394: --app_exception.raise_exception;
395: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
396: fnd_msg_pub.add;

Line 402: IF JTF_CAL_SHIFTS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN

398: v_error := 'Y';
399: END IF;
400:
401:
402: IF JTF_CAL_SHIFTS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
403: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
404: --app_exception.raise_exception;
405: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
406: fnd_message.set_token('P_Start_Date', X_START_DATE_ACTIVE);

Line 425: 'JTF_CAL_SHIFTS_PKG',

421: /*
422: -- Add User Hook Check for UPDATE by Jane Wang on 01/25/02
423:
424: IF jtf_usr_hks.ok_to_execute(
425: 'JTF_CAL_SHIFTS_PKG',
426: 'UPDATE_ROW',
427: 'B',
428: 'C')
429: THEN

Line 543: 'JTF_CAL_SHIFTS_PKG',

539:
540: -- Add User Hook Check for DELETE by Jane Wang on 01/25/02
541:
542: IF jtf_usr_hks.ok_to_execute(
543: 'JTF_CAL_SHIFTS_PKG',
544: 'DELETE_ROW',
545: 'B',
546: 'C')
547: THEN

Line 654: end JTF_CAL_SHIFTS_PKG;

650: ELSE
651: return(TRUE);
652: END IF;
653: END;
654: end JTF_CAL_SHIFTS_PKG;