APPS.JTF_CAL_SHIFT_ASSIGN_PKG dependencies on JTF_CAL_SHIFT_ASSIGN_PKG

Line 1: package body JTF_CAL_SHIFT_ASSIGN_PKG as

1: package body JTF_CAL_SHIFT_ASSIGN_PKG as
2: /* $Header: jtfclsab.pls 115.19 2002/11/15 14:37:04 sukulkar ship $ */
3: procedure INSERT_ROW (
4: X_ERROR out NOCOPY VARCHAR2,
5: X_ROWID in out NOCOPY VARCHAR2,

Line 64: /* IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_assign(X_CALENDAR_ID,X_SHIFT_ID, X_SHIFT_START_DATE, X_SHIFT_END_DATE)

60:
61: v_error := 'Y';
62: END IF;
63:
64: /* IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_assign(X_CALENDAR_ID,X_SHIFT_ID, X_SHIFT_START_DATE, X_SHIFT_END_DATE)
65: = FALSE THEN
66: --fnd_message.set_name('JTF', 'DUPLICATE RECORD ENTERED');
67: --app_exception.raise_exception;
68: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE_ASSIGNMENT');

Line 76: IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_seq(X_SHIFT_ID, X_SHIFT_SEQUENCE_NUMBER) = FALSE THEN

72: v_error := 'Y';
73:
74: END IF;
75:
76: IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_seq(X_SHIFT_ID, X_SHIFT_SEQUENCE_NUMBER) = FALSE THEN
77: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');
78: fnd_message.set_token('P_Shift_Seq_Num', X_SHIFT_SEQUENCE_NUMBER);
79: fnd_msg_pub.add;
80: v_error := 'Y';

Line 85: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_ID) = FALSE THEN

81: END IF;
82: */
83: END IF;
84:
85: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_ID) = FALSE THEN
86: --fnd_message.set_name('JTF', 'SHIFT_ID CANNOT BE NULL');
87: --app_exception.raise_exception;
88: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_NAME');
89: --fnd_message.set_token('P_Name', 'SHIFT');

Line 95: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_START_DATE) = FALSE THEN

91:
92: v_error := 'Y';
93: END IF;
94:
95: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_START_DATE) = FALSE THEN
96: --fnd_message.set_name('JTF', 'SHIFT_START_DATE CANNOT BE NULL');
97: --app_exception.raise_exception;
98: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
99: fnd_msg_pub.add;

Line 103: IF JTF_CAL_SHIFT_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_SHIFT_START_DATE, X_SHIFT_END_DATE) = FALSE THEN

99: fnd_msg_pub.add;
100: v_error := 'Y';
101: END IF;
102:
103: IF JTF_CAL_SHIFT_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_SHIFT_START_DATE, X_SHIFT_END_DATE) = FALSE THEN
104: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
105: --app_exception.raise_exception;
106: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
107: fnd_message.set_token('P_Start_Date', X_SHIFT_START_DATE);

Line 114: IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_seq(X_SHIFT_ID, X_SHIFT_SEQUENCE_NUMBER) = FALSE THEN

110: v_error := 'Y';
111: END IF;
112:
113: /*
114: IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_seq(X_SHIFT_ID, X_SHIFT_SEQUENCE_NUMBER) = FALSE THEN
115: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');
116: fnd_message.set_token('P_Shift_Seq_Num', X_SHIFT_SEQUENCE_NUMBER);
117: fnd_msg_pub.add;
118: v_error := 'Y';

Line 353: /* IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_assign(X_CALENDAR_ID,X_SHIFT_ID, X_SHIFT_START_DATE, X_SHIFT_END_DATE)

349: fnd_msg_pub.add;
350: v_error := 'Y';
351: END IF;
352:
353: /* IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_assign(X_CALENDAR_ID,X_SHIFT_ID, X_SHIFT_START_DATE, X_SHIFT_END_DATE)
354: = FALSE THEN
355: --fnd_message.set_name('JTF', 'DUPLICATE RECORD ENTERED');
356: --app_exception.raise_exception;
357: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE_ASSIGNMENT');

Line 365: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_ID) = FALSE THEN

361: v_error := 'Y';
362:
363: END IF;
364: */
365: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_ID) = FALSE THEN
366: --fnd_message.set_name('JTF', 'SHIFT_ID CANNOT BE NULL');
367: --app_exception.raise_exception;
368: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_NAME');
369: --fnd_message.set_token('P_Name', 'SHIFT');

Line 375: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_START_DATE) = FALSE THEN

371:
372: v_error := 'Y';
373: END IF;
374:
375: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_START_DATE) = FALSE THEN
376: --fnd_message.set_name('JTF', 'SHIFT_START_DATE CANNOT BE NULL');
377: --app_exception.raise_exception;
378: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
379: fnd_msg_pub.add;

Line 383: IF JTF_CAL_SHIFT_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_SHIFT_START_DATE, X_SHIFT_END_DATE) = FALSE THEN

379: fnd_msg_pub.add;
380: v_error := 'Y';
381: END IF;
382:
383: IF JTF_CAL_SHIFT_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_SHIFT_START_DATE, X_SHIFT_END_DATE) = FALSE THEN
384: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
385: --app_exception.raise_exception;
386: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
387: fnd_message.set_token('P_Start_Date', X_SHIFT_START_DATE);

Line 515: end JTF_CAL_SHIFT_ASSIGN_PKG;

511: close dup;
512: END;
513:
514:
515: end JTF_CAL_SHIFT_ASSIGN_PKG;