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');
45: fnd_msg_pub.add;
46:
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');
45: fnd_msg_pub.add;
46:
47: v_error := 'Y';
48: END IF;
48: END IF;
49:
50:
51: IF JTF_CAL_SHIFTS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
52: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
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);
50:
51: IF JTF_CAL_SHIFTS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
52: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
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';
51: IF JTF_CAL_SHIFTS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
52: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
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;
52: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
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:
60:
61: -- Code Added BY Venkata Putcha for UTF8 Compliance
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;
61: -- Code Added BY Venkata Putcha for UTF8 Compliance
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:
68: end if;
69:
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;
69:
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
292: open c;
293: fetch c into recinfo;
294: if (c%notfound) then
295: close c;
296: fnd_message.set_name('JTF', 'FORM_RECORD_DELETED');
297: app_exception.raise_exception;
298: end if;
299: close c;
300: if ( ((recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
336: OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
337: ) then
338: null;
339: else
340: fnd_message.set_name('JTF', 'FORM_RECORD_CHANGED');
341: app_exception.raise_exception;
342: end if;
343:
344: for tlinfo in c1 loop
348: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
349: ) then
350: null;
351: else
352: fnd_message.set_name('JTF', 'FORM_RECORD_CHANGED');
353: app_exception.raise_exception;
354: end if;
355: end if;
356: end loop;
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');
396: fnd_msg_pub.add;
397:
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');
396: fnd_msg_pub.add;
397:
398: v_error := 'Y';
399: END IF;
399: END IF;
400:
401:
402: IF JTF_CAL_SHIFTS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
403: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
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);
401:
402: IF JTF_CAL_SHIFTS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
403: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
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';
402: IF JTF_CAL_SHIFTS_PKG.END_GREATER_THAN_BEGIN(X_START_DATE_ACTIVE, X_END_DATE_ACTIVE) = FALSE THEN
403: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
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;
403: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
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: