DBA Data[Home] [Help]

APPS.JTF_CAL_EXCEPTIONS_PKG dependencies on JTF_CAL_EXCEPTIONS_PKG

Line 1: package body JTF_CAL_EXCEPTIONS_PKG as

1: package body JTF_CAL_EXCEPTIONS_PKG as
2: /* $Header: jtfclexb.pls 120.5 2011/03/22 06:25:42 anangupt ship $ */
3: procedure INSERT_ROW (
4: X_ERROR out NOCOPY VARCHAR2,
5: X_ROWID in out NOCOPY VARCHAR2,

Line 45: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_START_DATE_TIME) = FALSE THEN

41: v_error CHAR := 'N';
42: p_rec NUMBER;
43: begin
44: fnd_msg_pub.initialize;
45: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_START_DATE_TIME) = FALSE THEN
46: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
47: --app_exception.raise_exception;
48: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
49: fnd_msg_pub.add;

Line 54: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_CATEGORY) = FALSE THEN

50:
51: v_error := 'Y';
52: END IF;
53:
54: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_CATEGORY) = FALSE THEN
55: --fnd_message.set_name('JTF', 'EXCEPTION CATEGORY CANNOT BE NULL');
56: --app_exception.raise_exception;
57: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_CATEGORY');
58: --fnd_message.set_token('P_Name', 'EXCEPTION_CATEGORY');

Line 64: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_NAME) = FALSE THEN

60: v_error := 'Y';
61: END IF;
62:
63:
64: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_NAME) = FALSE THEN
65: --fnd_message.set_name('JTF', 'EXCEPTION NAME CANNOT BE NULL');
66: --app_exception.raise_exception;
67: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_NAME');
68: --fnd_message.set_token('P_Name', 'EXCEPTION_NAME');

Line 73: IF JTF_CAL_EXCEPTIONS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN

69: fnd_msg_pub.add;
70: v_error := 'Y';
71: END IF;
72:
73: IF JTF_CAL_EXCEPTIONS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = 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_TIME,calendar_aware=>fnd_date.calendar_aware));

Line 377: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_START_DATE_TIME) = FALSE THEN

373: p_rec NUMBER;
374: begin
375: fnd_msg_pub.initialize;
376:
377: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_START_DATE_TIME) = FALSE THEN
378: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
379: --app_exception.raise_exception;
380: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
381: fnd_msg_pub.add;

Line 386: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_CATEGORY) = FALSE THEN

382:
383: v_error := 'Y';
384: END IF;
385:
386: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_CATEGORY) = FALSE THEN
387: --fnd_message.set_name('JTF', 'EXCEPTION CATEGORY CANNOT BE NULL');
388: --app_exception.raise_exception;
389: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_CATEGORY');
390: --fnd_message.set_token('P_Name', 'EXCEPTION_CATEGORY');

Line 396: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_NAME) = FALSE THEN

392: v_error := 'Y';
393: END IF;
394:
395:
396: IF JTF_CAL_EXCEPTIONS_PKG.NOT_NULL(X_EXCEPTION_NAME) = FALSE THEN
397: --fnd_message.set_name('JTF', 'EXCEPTION NAME CANNOT BE NULL');
398: --app_exception.raise_exception;
399: fnd_message.set_name('JTF', 'JTF_CAL_EXCEPTION_NAME');
400: --fnd_message.set_token('P_Name', 'EXCEPTION_NAME');

Line 405: IF JTF_CAL_EXCEPTIONS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN

401: fnd_msg_pub.add;
402: v_error := 'Y';
403: END IF;
404:
405: IF JTF_CAL_EXCEPTIONS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN
406: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
407: --app_exception.raise_exception;
408: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
409: fnd_message.set_token('P_Start_Date', fnd_date.date_to_chardate(dateval=>X_START_DATE_TIME,calendar_aware=>fnd_date.calendar_aware));

Line 614: end JTF_CAL_EXCEPTIONS_PKG;

610: ELSE
611: return(TRUE);
612: END IF;
613: END;
614: end JTF_CAL_EXCEPTIONS_PKG;