APPS.JTF_CAL_EXCEPTION_ASSIGN_PKG dependencies on JTF_CAL_EXCEPTION_ASSIGN_PKG

Line 1: package body JTF_CAL_EXCEPTION_ASSIGN_PKG as

1: package body JTF_CAL_EXCEPTION_ASSIGN_PKG as
2: /* $Header: jtfcleab.pls 115.18 2002/11/15 14:42:10 sukulkar ship $ */
3: procedure INSERT_ROW (
4: X_ERROR out NOCOPY VARCHAR2,
5: X_ROWID in out NOCOPY VARCHAR2,

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', X_START_DATE_ACTIVE);

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', X_START_DATE_ACTIVE);
335: fnd_message.set_token('P_End_Date', X_END_DATE_ACTIVE);
336: fnd_msg_pub.add;

Line 442: end JTF_CAL_EXCEPTION_ASSIGN_PKG;

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