APPS.JTF_CAL_EXCEPTION_ASSIGN_PKG dependencies on FND_MSG_PUB

Line 42: fnd_msg_pub.initialize;

38:
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

Line 51: fnd_msg_pub.add;

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:
55: /*IF JTF_CAL_EXCEPTION_ASSIGN_PKG.NOT_NULL(X_EXCEPTION_ID) = FALSE THEN

Line 60: fnd_msg_pub.add;

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: */
64:

Line 69: fnd_msg_pub.add;

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:
73: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN

Line 79: fnd_msg_pub.add;

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:
83: IF v_error = 'Y' THEN

Line 303: fnd_msg_pub.initialize;

299: ) is
300: v_error CHAR := 'N';
301: v_count NUMBER;
302: begin
303: fnd_msg_pub.initialize;
304: -- To check duplication of exception
305: SELECT count(*)
306: INTO v_count
307: FROM jtf_cal_exception_assign

Line 313: fnd_msg_pub.add;

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:
317: /*

Line 320: fnd_msg_pub.add;

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: */
324:

Line 328: fnd_msg_pub.add;

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:
332: IF JTF_CAL_EXCEPTION_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN

Line 336: fnd_msg_pub.add;

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:
340: IF v_error = 'Y' THEN