DBA Data[Home] [Help]

APPS.JTF_CAL_SHIFTS_PKG dependencies on FND_MSG_PUB

Line 40: fnd_msg_pub.initialize;

36: v_shift_id NUMBER;
37: cursor C is select ROWID from JTF_CAL_SHIFTS_B
38: where SHIFT_ID = X_SHIFT_ID;
39: begin
40: fnd_msg_pub.initialize;
41: IF JTF_CAL_SHIFTS_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN
42: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
43: --app_exception.raise_exception;
44: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');

Line 45: fnd_msg_pub.add;

41: IF JTF_CAL_SHIFTS_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN
42: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
43: --app_exception.raise_exception;
44: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
45: fnd_msg_pub.add;
46:
47: v_error := 'Y';
48: END IF;
49:

Line 57: fnd_msg_pub.add;

53: --app_exception.raise_exception;
54: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
55: fnd_message.set_token('P_Start_Date', X_START_DATE_ACTIVE);
56: fnd_message.set_token('P_End_Date', X_END_DATE_ACTIVE);
57: fnd_msg_pub.add;
58: v_error := 'Y';
59: END IF;
60:
61: -- Code Added BY Venkata Putcha for UTF8 Compliance

Line 66: fnd_msg_pub.add;

62: -- Update the max length from 80 to 240 for bug # 2863830 By A.Raina
63: if Length(X_SHIFT_NAME) > 240 then
64: fnd_message.set_name('JTF', 'JTF_CAL_UTF8_COMP');
65: fnd_message.set_token('P_NAME', X_SHIFT_NAME);
66: fnd_msg_pub.add;
67: v_error := 'Y';
68: end if;
69:
70: -- Update the max length from 80 to 240 for bug # 2863830 By A.Raina

Line 74: fnd_msg_pub.add;

70: -- Update the max length from 80 to 240 for bug # 2863830 By A.Raina
71: if Length(X_DESCRIPTION) > 240 then
72: fnd_message.set_name('JTF', 'JTF_CAL_UTF8_COMP');
73: fnd_message.set_token('P_NAME', X_DESCRIPTION);
74: fnd_msg_pub.add;
75: v_error := 'Y';
76: end if;
77: -- Up to Here
78:

Line 391: fnd_msg_pub.initialize;

387: ) is
388:
389: v_error CHAR := 'N';
390: begin
391: fnd_msg_pub.initialize;
392: IF JTF_CAL_SHIFTS_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN
393: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
394: --app_exception.raise_exception;
395: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');

Line 396: fnd_msg_pub.add;

392: IF JTF_CAL_SHIFTS_PKG.NOT_NULL(X_START_DATE_ACTIVE) = FALSE THEN
393: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
394: --app_exception.raise_exception;
395: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
396: fnd_msg_pub.add;
397:
398: v_error := 'Y';
399: END IF;
400:

Line 408: fnd_msg_pub.add;

404: --app_exception.raise_exception;
405: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
406: fnd_message.set_token('P_Start_Date', X_START_DATE_ACTIVE);
407: fnd_message.set_token('P_End_Date', X_END_DATE_ACTIVE);
408: fnd_msg_pub.add;
409: v_error := 'Y';
410: END IF;
411:
412: IF v_error = 'Y' THEN