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
48: fnd_message.set_name('JTF','JTF_CAL_EXCEPTION_EXISTS');
49: -- fnd_message.set_name('JTF', 'JTF_CAL_ALREADY_EXISTS');
50: -- fnd_message.set_token('P_Name', X_EXCEPTION_REASON);
51: fnd_msg_pub.add;
52: v_error := 'Y';
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
48: fnd_message.set_name('JTF','JTF_CAL_EXCEPTION_EXISTS');
49: -- fnd_message.set_name('JTF', 'JTF_CAL_ALREADY_EXISTS');
50: -- fnd_message.set_token('P_Name', X_EXCEPTION_REASON);
51: fnd_msg_pub.add;
52: v_error := 'Y';
53: END IF;
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
48: fnd_message.set_name('JTF','JTF_CAL_EXCEPTION_EXISTS');
49: -- fnd_message.set_name('JTF', 'JTF_CAL_ALREADY_EXISTS');
50: -- fnd_message.set_token('P_Name', X_EXCEPTION_REASON);
51: fnd_msg_pub.add;
52: v_error := 'Y';
53: END IF;
54:
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);
60: fnd_msg_pub.add;
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);
60: fnd_msg_pub.add;
61: v_error := 'Y';
62: END IF;
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);
60: fnd_msg_pub.add;
61: v_error := 'Y';
62: END IF;
63: */
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;
70: v_error := 'Y';
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;
70: v_error := 'Y';
71: END IF;
72:
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);
78: fnd_message.set_token('P_End_Date', X_END_DATE_ACTIVE);
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);
78: fnd_message.set_token('P_End_Date', X_END_DATE_ACTIVE);
79: fnd_msg_pub.add;
80: v_error := 'Y';
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);
78: fnd_message.set_token('P_End_Date', X_END_DATE_ACTIVE);
79: fnd_msg_pub.add;
80: v_error := 'Y';
81: END IF;
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);
78: fnd_message.set_token('P_End_Date', X_END_DATE_ACTIVE);
79: fnd_msg_pub.add;
80: v_error := 'Y';
81: END IF;
82:
259: OR ((tlinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
260: ) then
261: null;
262: else
263: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
264: app_exception.raise_exception;
265: end if;
266: -- end if;
267: end loop;
308: WHERE calendar_id = X_CALENDAR_ID
309: and exception_id = X_EXCEPTION_ID;
310:
311: IF v_count > 1 THEN
312: fnd_message.set_name('JTF','JTF_CAL_EXCEPTION_EXISTS');
313: fnd_msg_pub.add;
314: v_error := 'Y';
315: END IF;
316:
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;
323: */
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;
331:
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;
337: 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;
337: v_error := 'Y';
338: 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;
337: v_error := 'Y';
338: END IF;
339: