DBA Data[Home] [Help]

APPS.JTF_CAL_RESOURCE_ASSIGN_PKG dependencies on FND_MSG_PUB

Line 52: Fnd_Msg_Pub.initialize;

48: v_error CHAR := 'N';
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;

Line 56: Fnd_Msg_Pub.ADD;

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';
58: END IF;
59:
60: IF Jtf_Cal_Resource_Assign_Pkg.NOT_NULL(X_START_DATE_TIME) = FALSE THEN

Line 62: Fnd_Msg_Pub.ADD;

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';
65: END IF;
66:

Line 73: Fnd_Msg_Pub.ADD;

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);
72: Fnd_Message.set_token('P_End_Date', X_END_DATE_TIME);
73: Fnd_Msg_Pub.ADD;
74: v_error := 'Y';
75: END IF;
76:
77: SELECT COUNT(*) INTO prime_flag_count FROM jtf_cal_resource_assign

Line 115: Fnd_Msg_Pub.ADD;

111: */
112:
113: IF prime_flag_count >= 1 AND X_PRIMARY_CALENDAR_FLAG = 'Y' THEN
114: Fnd_Message.set_name('JTF', 'JTF_CAL_DUP_PRIMARY_CAL_FLAG');
115: Fnd_Msg_Pub.ADD;
116: v_error := 'Y';
117: END IF;
118:
119: SELECT COUNT(*) INTO v_count FROM jtf_cal_resource_assign

Line 144: Fnd_Msg_Pub.ADD;

140: */
141: -- IF v_count > 0 OR v_dup > 1 THEN
142: IF v_count >= 1 AND X_PRIMARY_CALENDAR_FLAG = 'N' THEN
143: Fnd_Message.set_name('JTF', 'JTF_CAL_DUPLICATE_ROW');
144: Fnd_Msg_Pub.ADD;
145: v_error := 'Y';
146: END IF;
147:
148:

Line 378: Fnd_Msg_Pub.initialize;

374: v_count NUMBER := 1;
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;

Line 382: Fnd_Msg_Pub.ADD;

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';
384: END IF;
385:
386: IF Jtf_Cal_Resource_Assign_Pkg.NOT_NULL(X_START_DATE_TIME) = FALSE THEN

Line 390: Fnd_Msg_Pub.ADD;

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:

Line 401: Fnd_Msg_Pub.ADD;

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);
400: Fnd_Message.set_token('P_End_Date', X_END_DATE_TIME);
401: Fnd_Msg_Pub.ADD;
402: v_error := 'Y';
403: END IF;
404:
405: SELECT COUNT(*) INTO prime_flag_count FROM jtf_cal_resource_assign

Line 421: Fnd_Msg_Pub.ADD;

417: < NVL(end_date_time,Fnd_Api.g_miss_date))));
418:
419: IF prime_flag_count = 1 AND X_PRIMARY_CALENDAR_FLAG = 'Y' THEN
420: Fnd_Message.set_name('JTF', 'JTF_CAL_DUP_PRIMARY_CAL_FLAG');
421: Fnd_Msg_Pub.ADD;
422: v_error := 'Y';
423: END IF;
424:
425: SELECT COUNT(*) INTO v_count FROM jtf_cal_resource_assign

Line 450: Fnd_Msg_Pub.ADD;

446: */
447: -- IF v_count > 1 or v_dup = 1 THEN
448: IF v_count = 1 AND X_PRIMARY_CALENDAR_FLAG = 'N' THEN
449: Fnd_Message.set_name('JTF', 'JTF_CAL_DUPLICATE_ROW');
450: Fnd_Msg_Pub.ADD;
451: v_error := 'Y';
452: END IF;
453:
454: IF v_error = 'Y' THEN

Line 558: --fnd_msg_pub.initialize;

554: AND RESOURCE_TYPE_CODE = X_RESOURCE_TYPE_CODE
555: AND TRUNC(start_date_time) = TRUNC(v_start_date_time)
556: AND TRUNC(end_date_time) = TRUNC(v_end_date_time);
557:
558: --fnd_msg_pub.initialize;
559:
560: v_count := 0;
561:
562: IF temp_count < 1 THEN