1: PACKAGE BODY Jtf_Cal_Resource_Assign_Pkg AS
2: /* $Header: jtfclrab.pls 115.33 2002/11/15 15:03:08 sukulkar ship $ */
3: PROCEDURE INSERT_ROW (
4: X_ERROR OUT NOCOPY VARCHAR2,
5: X_ROWID IN OUT NOCOPY VARCHAR2,
49: v_shift_id NUMBER;
50: v_cal_resource_assign_id NUMBER;
51: BEGIN
52: Fnd_Msg_Pub.initialize;
53: IF Jtf_Cal_Resource_Assign_Pkg.NOT_NULL(TO_CHAR(X_RESOURCE_ID)) = FALSE THEN
54: Fnd_Message.set_name('JTF', 'JTF_CAL_REQUIRED');
55: Fnd_Message.set_token('P_NAME', X_RESOURCE_ID);
56: Fnd_Msg_Pub.ADD;
57: v_error := 'Y';
56: Fnd_Msg_Pub.ADD;
57: v_error := 'Y';
58: END IF;
59:
60: IF Jtf_Cal_Resource_Assign_Pkg.NOT_NULL(X_START_DATE_TIME) = FALSE THEN
61: Fnd_Message.set_name('JTF', 'JTF_CAL_START_DATE');
62: Fnd_Msg_Pub.ADD;
63:
64: v_error := 'Y';
63:
64: v_error := 'Y';
65: END IF;
66:
67: IF Jtf_Cal_Resource_Assign_Pkg.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN
68: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
69: --app_exception.raise_exception;
70: Fnd_Message.set_name('JTF', 'JTF_CAL_END_DATE');
71: Fnd_Message.set_token('P_Start_Date', X_START_DATE_TIME);
375: v_dup NUMBER := 1;
376: prime_flag_count NUMBER := 0;
377: BEGIN
378: Fnd_Msg_Pub.initialize;
379: IF Jtf_Cal_Resource_Assign_Pkg.NOT_NULL(TO_CHAR(X_RESOURCE_ID)) = FALSE THEN
380: Fnd_Message.set_name('JTF', 'JTF_CAL_REQUIRED');
381: Fnd_Message.set_token('P_NAME', X_RESOURCE_ID);
382: Fnd_Msg_Pub.ADD;
383: v_error := 'Y';
382: Fnd_Msg_Pub.ADD;
383: v_error := 'Y';
384: END IF;
385:
386: IF Jtf_Cal_Resource_Assign_Pkg.NOT_NULL(X_START_DATE_TIME) = FALSE THEN
387: --fnd_message.set_name('JTF', 'START_DATE CANNOT BE NULL');
388: --app_exception.raise_exception;
389: Fnd_Message.set_name('JTF', 'JTF_CAL_START_DATE');
390: Fnd_Msg_Pub.ADD;
391:
392: v_error := 'Y';
393: END IF;
394:
395: IF Jtf_Cal_Resource_Assign_Pkg.END_GREATER_THAN_BEGIN(X_START_DATE_TIME, X_END_DATE_TIME) = FALSE THEN
396: --fnd_message.set_name('JTF', 'END_DATE IS INCORRECT');
397: --app_exception.raise_exception;
398: Fnd_Message.set_name('JTF', 'JTF_CAL_END_DATE');
399: Fnd_Message.set_token('P_Start_Date', X_START_DATE_TIME);
646: END IF;
647: END;
648:
649:
650: END Jtf_Cal_Resource_Assign_Pkg;