DBA Data[Home] [Help]

APPS.JTF_CAL_SHIFT_ASSIGN_PKG dependencies on FND_MSG_PUB

Line 42: fnd_msg_pub.initialize;

38:
39: v_error CHAR := 'N';
40: v_jtf_cal_shift_assign_s NUMBER;
41: begin
42: fnd_msg_pub.initialize;
43: select count(*) into count_cal
44: from jtf_cal_shift_assign
45: where calendar_id = X_CALENDAR_ID;
46:

Line 59: fnd_msg_pub.add;

55: If temp_count > 0 THEN
56:
57: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE_ASSIGNMENT');
58: --fnd_message.set_token('P_Name', 'Assignment');
59: fnd_msg_pub.add;
60:
61: v_error := 'Y';
62: END IF;
63:

Line 70: fnd_msg_pub.add;

66: --fnd_message.set_name('JTF', 'DUPLICATE RECORD ENTERED');
67: --app_exception.raise_exception;
68: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE_ASSIGNMENT');
69: --fnd_message.set_token('P_Name', 'Assignment');
70: fnd_msg_pub.add;
71:
72: v_error := 'Y';
73:
74: END IF;

Line 79: fnd_msg_pub.add;

75:
76: IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_seq(X_SHIFT_ID, X_SHIFT_SEQUENCE_NUMBER) = FALSE THEN
77: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');
78: fnd_message.set_token('P_Shift_Seq_Num', X_SHIFT_SEQUENCE_NUMBER);
79: fnd_msg_pub.add;
80: v_error := 'Y';
81: END IF;
82: */
83: END IF;

Line 90: fnd_msg_pub.add;

86: --fnd_message.set_name('JTF', 'SHIFT_ID CANNOT BE NULL');
87: --app_exception.raise_exception;
88: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_NAME');
89: --fnd_message.set_token('P_Name', 'SHIFT');
90: fnd_msg_pub.add;
91:
92: v_error := 'Y';
93: END IF;
94:

Line 99: fnd_msg_pub.add;

95: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_START_DATE) = FALSE THEN
96: --fnd_message.set_name('JTF', 'SHIFT_START_DATE CANNOT BE NULL');
97: --app_exception.raise_exception;
98: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
99: fnd_msg_pub.add;
100: v_error := 'Y';
101: END IF;
102:
103: IF JTF_CAL_SHIFT_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_SHIFT_START_DATE, X_SHIFT_END_DATE) = FALSE THEN

Line 109: fnd_msg_pub.add;

105: --app_exception.raise_exception;
106: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
107: fnd_message.set_token('P_Start_Date', X_SHIFT_START_DATE);
108: fnd_message.set_token('P_End_Date', X_SHIFT_END_DATE);
109: fnd_msg_pub.add;
110: v_error := 'Y';
111: END IF;
112:
113: /*

Line 117: fnd_msg_pub.add;

113: /*
114: IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_seq(X_SHIFT_ID, X_SHIFT_SEQUENCE_NUMBER) = FALSE THEN
115: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');
116: fnd_message.set_token('P_Shift_Seq_Num', X_SHIFT_SEQUENCE_NUMBER);
117: fnd_msg_pub.add;
118: v_error := 'Y';
119: END IF;
120: */
121:

Line 336: fnd_msg_pub.initialize;

332: temp_count number;
333: v_error CHAR := 'N';
334:
335: begin
336: fnd_msg_pub.initialize;
337:
338: select count(*) into temp_count
339: from jtf_cal_shift_assign
340: where calendar_id = X_CALENDAR_ID

Line 349: fnd_msg_pub.add;

345: If temp_count > 1 THEN
346:
347: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE_ASSIGNMENT');
348: --fnd_message.set_token('P_Name', 'Assignment');
349: fnd_msg_pub.add;
350: v_error := 'Y';
351: END IF;
352:
353: /* IF JTF_CAL_SHIFT_ASSIGN_PKG.duplicate_assign(X_CALENDAR_ID,X_SHIFT_ID, X_SHIFT_START_DATE, X_SHIFT_END_DATE)

Line 359: fnd_msg_pub.add;

355: --fnd_message.set_name('JTF', 'DUPLICATE RECORD ENTERED');
356: --app_exception.raise_exception;
357: fnd_message.set_name('JTF', 'JTF_CAL_DUPLICATE_ASSIGNMENT');
358: --fnd_message.set_token('P_Name', 'Assignment');
359: fnd_msg_pub.add;
360:
361: v_error := 'Y';
362:
363: END IF;

Line 370: fnd_msg_pub.add;

366: --fnd_message.set_name('JTF', 'SHIFT_ID CANNOT BE NULL');
367: --app_exception.raise_exception;
368: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_NAME');
369: --fnd_message.set_token('P_Name', 'SHIFT');
370: fnd_msg_pub.add;
371:
372: v_error := 'Y';
373: END IF;
374:

Line 379: fnd_msg_pub.add;

375: IF JTF_CAL_SHIFT_ASSIGN_PKG.NOT_NULL(X_SHIFT_START_DATE) = FALSE THEN
376: --fnd_message.set_name('JTF', 'SHIFT_START_DATE CANNOT BE NULL');
377: --app_exception.raise_exception;
378: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
379: fnd_msg_pub.add;
380: v_error := 'Y';
381: END IF;
382:
383: IF JTF_CAL_SHIFT_ASSIGN_PKG.END_GREATER_THAN_BEGIN(X_SHIFT_START_DATE, X_SHIFT_END_DATE) = FALSE THEN

Line 389: fnd_msg_pub.add;

385: --app_exception.raise_exception;
386: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
387: fnd_message.set_token('P_Start_Date', X_SHIFT_START_DATE);
388: fnd_message.set_token('P_End_Date', X_SHIFT_END_DATE);
389: fnd_msg_pub.add;
390: v_error := 'Y';
391: END IF;
392:
393: IF v_error = 'Y' THEN