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_EXCEPTION_ASSIGN_PKG dependencies on JTF_CAL_EXCEPTION_ASSIGN

Line 1: package body JTF_CAL_EXCEPTION_ASSIGN_PKG as

1: package body JTF_CAL_EXCEPTION_ASSIGN_PKG as
2: /* $Header: jtfcleab.pls 120.2 2011/03/22 06:29:43 anangupt ship $ */
3: procedure INSERT_ROW (
4: X_ERROR out NOCOPY VARCHAR2,
5: X_ROWID in out NOCOPY VARCHAR2,

Line 36: cursor C is select ROWID from JTF_CAL_EXCEPTION_ASSIGN

32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35:
36: cursor C is select ROWID from JTF_CAL_EXCEPTION_ASSIGN
37: where CAL_EXCEPTION_ASSIGN_ID = X_CAL_EXCEPTION_ASSIGN_ID;
38:
39: v_error CHAR := 'N';
40: v_cal_exception_assign_id_s NUMBER;

Line 43: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.duplicate_excep(X_CALENDAR_ID,X_EXCEPTION_ID,

39: v_error CHAR := 'N';
40: v_cal_exception_assign_id_s NUMBER;
41: begin
42: fnd_msg_pub.initialize;
43: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.duplicate_excep(X_CALENDAR_ID,X_EXCEPTION_ID,
44: X_EXCEPTION_REASON, X_START_DATE_ACTIVE,
45: -- nvl(X_END_DATE_ACTIVE,'31-DEC-4712')) = FALSE THEN
46: --changed this for nls issue inavlid month .. sudarsana 12th Nov 2001
47: nvl(X_END_DATE_ACTIVE,fnd_api.g_miss_date)) = FALSE THEN

Line 55: /*IF JTF_CAL_EXCEPTION_ASSIGN_PKG.NOT_NULL(X_EXCEPTION_ID) = FALSE THEN

51: fnd_msg_pub.add;
52: v_error := 'Y';
53: END IF;
54:
55: /*IF JTF_CAL_EXCEPTION_ASSIGN_PKG.NOT_NULL(X_EXCEPTION_ID) = FALSE THEN
56: --fnd_message.set_name('JTF', 'EXCEPTION_ID CANNOT BE NULL');
57: --app_exception.raise_exception;
58: fnd_message.set_name('JTF', 'JTF_CAL_REQUIRED');
59: fnd_message.set_token('P_Name', X_EXCEPTION_ID);

Line 65: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN

61: v_error := 'Y';
62: END IF;
63: */
64:
65: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN
66: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
67: --app_exception.raise_exception;
68: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
69: fnd_msg_pub.add;

Line 73: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN

69: fnd_msg_pub.add;
70: v_error := 'Y';
71: END IF;
72:
73: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
74: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
75: --app_exception.raise_exception;
76: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
77: fnd_message.set_token('P_Start_Date', fnd_date.date_to_chardate(dateval=>X_START_DATE_ACTIVE,calendar_aware=>fnd_date.calendar_aware));

Line 88: SELECT jtf_cal_exception_assign_s.nextval

84: X_ERROR := 'Y';
85: return;
86: ELSE
87:
88: SELECT jtf_cal_exception_assign_s.nextval
89: INTO v_cal_exception_assign_id_s
90: FROM dual;
91: X_CAL_EXCEPTION_ASSIGN_ID := v_cal_exception_assign_id_s;
92:

Line 93: insert into JTF_CAL_EXCEPTION_ASSIGN (

89: INTO v_cal_exception_assign_id_s
90: FROM dual;
91: X_CAL_EXCEPTION_ASSIGN_ID := v_cal_exception_assign_id_s;
92:
93: insert into JTF_CAL_EXCEPTION_ASSIGN (
94: OBJECT_VERSION_NUMBER,
95: CAL_EXCEPTION_ASSIGN_ID,
96: EXCEPTION_REASON,
97: CALENDAR_ID,

Line 211: from JTF_CAL_EXCEPTION_ASSIGN

207: ATTRIBUTE14,
208: ATTRIBUTE15,
209: ATTRIBUTE_CATEGORY,
210: CAL_EXCEPTION_ASSIGN_ID
211: from JTF_CAL_EXCEPTION_ASSIGN
212: where CAL_EXCEPTION_ASSIGN_ID = X_CAL_EXCEPTION_ASSIGN_ID
213: for update of CAL_EXCEPTION_ASSIGN_ID nowait;
214: begin
215: for tlinfo in c1 loop

Line 307: FROM jtf_cal_exception_assign

303: fnd_msg_pub.initialize;
304: -- To check duplication of exception
305: SELECT count(*)
306: INTO v_count
307: FROM jtf_cal_exception_assign
308: WHERE calendar_id = X_CALENDAR_ID
309: and exception_id = X_EXCEPTION_ID;
310:
311: IF v_count > 1 THEN

Line 318: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.duplicate_excep(X_CALENDAR_ID,X_EXCEPTION_ID, X_EXCEPTION_REASON,X_START_DATE_ACTIVE, nvl(X_END_DATE_ACTIVE,'31-DEC-4712')) = FALSE THEN

314: v_error := 'Y';
315: END IF;
316:
317: /*
318: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.duplicate_excep(X_CALENDAR_ID,X_EXCEPTION_ID, X_EXCEPTION_REASON,X_START_DATE_ACTIVE, nvl(X_END_DATE_ACTIVE,'31-DEC-4712')) = FALSE THEN
319: fnd_message.set_name('JTF','JTF_CAL_EXCEPTION_EXISTS');
320: fnd_msg_pub.add;
321: v_error := 'Y';
322: END IF;

Line 326: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN

322: END IF;
323: */
324:
325:
326: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN
327: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
328: fnd_msg_pub.add;
329: v_error := 'Y';
330: END IF;

Line 332: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN

328: fnd_msg_pub.add;
329: v_error := 'Y';
330: END IF;
331:
332: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
333: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
334: fnd_message.set_token('P_Start_Date', fnd_date.date_to_chardate(dateval=>X_START_DATE_ACTIVE,calendar_aware=>fnd_date.calendar_aware));
335: fnd_message.set_token('P_End_Date', fnd_date.date_to_chardate(dateval=>X_END_DATE_ACTIVE,calendar_aware=>fnd_date.calendar_aware));
336: fnd_msg_pub.add;

Line 347: update JTF_CAL_EXCEPTION_ASSIGN set

343: ELSE
344: X_ERROR := 'N';
345: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;
346:
347: update JTF_CAL_EXCEPTION_ASSIGN set
348: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
349: EXCEPTION_REASON = X_EXCEPTION_REASON,
350: CALENDAR_ID = X_CALENDAR_ID,
351: EXCEPTION_ID = X_EXCEPTION_ID,

Line 386: delete from JTF_CAL_EXCEPTION_ASSIGN

382: procedure DELETE_ROW (
383: X_CAL_EXCEPTION_ASSIGN_ID in NUMBER
384: ) is
385: begin
386: delete from JTF_CAL_EXCEPTION_ASSIGN
387: where CAL_EXCEPTION_ASSIGN_ID = X_CAL_EXCEPTION_ASSIGN_ID;
388:
389: if (sql%notfound) then
390: raise no_data_found;

Line 419: from jtf_cal_exception_assign

415: X_FOUND CHAR := 'N';
416: -- Just check the duplication by name.
417: cursor dup is
418: select 'x'
419: from jtf_cal_exception_assign
420: where calendar_id = X_CALENDAR_ID
421: and exception_id = X_EXCEPTION_ID
422: -- and exception_reason= X_EXCEPTION_REASON
423: -- and (( X_START_DATE_ACTIVE <= start_date_active and nvl(X_END_DATE_ACTIVE,'31-DEC-4712') >= end_date_active )

Line 442: end JTF_CAL_EXCEPTION_ASSIGN_PKG;

438: end if;
439: close dup;
440:
441: END;
442: end JTF_CAL_EXCEPTION_ASSIGN_PKG;