DBA Data[Home] [Help]

APPS.JTF_CAL_SHIFT_CONSTRUCTS_PKG dependencies on FND_MSG_PUB

Line 48: fnd_msg_pub.initialize;

44: chk_shift NUMBER;
45: v_begin_time DATE;
46: v_end_time DATE;
47: BEGIN
48: fnd_msg_pub.initialize;
49: x_object_version_number := 1;
50:
51: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN
52: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');

Line 53: fnd_msg_pub.ADD;

49: x_object_version_number := 1;
50:
51: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN
52: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');
53: fnd_msg_pub.ADD;
54: v_error := 'Y';
55: END IF;
56:
57: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN

Line 59: fnd_msg_pub.ADD;

55: END IF;
56:
57: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN
58: fnd_message.set_name('JTF', 'JTF_CAL_END_TIME');
59: fnd_msg_pub.ADD;
60: v_error := 'Y';
61: END IF;
62:
63: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN

Line 65: fnd_msg_pub.ADD;

61: END IF;
62:
63: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN
64: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');
65: fnd_msg_pub.ADD;
66: v_error := 'Y';
67: END IF;
68:
69: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN

Line 73: fnd_msg_pub.ADD;

69: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN
70: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
71: fnd_message.set_token('P_Start_Date', x_start_date_active);
72: fnd_message.set_token('P_End_Date', x_end_date_active);
73: fnd_msg_pub.ADD;
74: v_error := 'Y';
75: END IF;
76:
77:

Line 80: fnd_msg_pub.ADD;

76:
77:
78: IF jtf_cal_shift_constructs_pkg.not_null_char(x_availability_type_code) = FALSE THEN
79: fnd_message.set_name('JTF', 'JTF_CAL_AVAILABILITY_TYPE_CODE');
80: fnd_msg_pub.ADD;
81: v_error := 'Y';
82: END IF;
83:
84: SELECT COUNT(*)

Line 91: fnd_msg_pub.ADD;

87: WHERE shift_id = x_shift_id;
88:
89: IF p_rec = 0 THEN
90: fnd_message.set_name('JTF', 'JTF_CAL_PATTERN_SHIFT');
91: fnd_msg_pub.ADD;
92: v_error := 'Y';
93: END IF;
94:
95: --End of Validation

Line 113: fnd_msg_pub.ADD;

109:
110: IF chk_shift > 0 THEN
111: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_SEQ_NUM');
112: fnd_message.set_token('P_SHIFT_SEQ_NUM', v_shift_construct_id);
113: fnd_msg_pub.ADD;
114: v_error := 'Y';
115: x_error := 'Y';
116: RETURN;
117: END IF;

Line 237: fnd_msg_pub.ADD;

233: EXCEPTION
234: WHEN OTHERS THEN
235: -- fnd_message.set_name('JTF', 'JTF_FM_ADMIN_ADDERROR');
236: fnd_message.set_name('JTF', SQLERRM);
237: fnd_msg_pub.ADD;
238: v_error := 'Y';
239: x_error := 'Y';
240: END;
241: /*

Line 311: fnd_msg_pub.initialize;

307: FOR UPDATE OF shift_construct_id NOWAIT;
308:
309: v_error CHAR := 'N';
310: BEGIN
311: fnd_msg_pub.initialize;
312:
313: FOR tlinfo IN c1 LOOP
314: IF (
315: (tlinfo.shift_construct_id = x_shift_construct_id)

Line 353: fnd_msg_pub.ADD;

349: ) THEN
350: NULL;
351: ELSE
352: fnd_message.set_name('JTF', 'FORM_RECORD_CHANGED');
353: fnd_msg_pub.ADD;
354: v_error := 'Y';
355: -- fnd_message.set_name('JTF', 'FORM_RECORD_CHANGED');
356: -- app_exception.raise_exception;
357: END IF;

Line 369: fnd_msg_pub.ADD;

365: RETURN;
366: EXCEPTION
367: WHEN app_exception.record_lock_exception THEN
368: fnd_message.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
369: fnd_msg_pub.ADD;
370: v_error := 'Y';
371:
372: IF v_error = 'Y' THEN
373: x_error := 'Y';

Line 411: fnd_msg_pub.initialize;

407: ) IS
408: v_error CHAR := 'N';
409: l_object_version_number NUMBER;
410: BEGIN
411: fnd_msg_pub.initialize;
412:
413: IF jtf_cal_shift_constructs_pkg.not_null(x_begin_time) = FALSE THEN
414: --fnd_message.set_name('JTF', 'BEGIN_TIME CANNOT BE NULL');
415: --app_exception.raise_exception;

Line 418: fnd_msg_pub.ADD;

414: --fnd_message.set_name('JTF', 'BEGIN_TIME CANNOT BE NULL');
415: --app_exception.raise_exception;
416: fnd_message.set_name('JTF', 'JTF_CAL_BEGIN_TIME');
417: --fnd_message.set_token('P_Name', 'BEGIN_TIME');
418: fnd_msg_pub.ADD;
419: v_error := 'Y';
420: END IF;
421:
422: IF jtf_cal_shift_constructs_pkg.not_null(x_end_time) = FALSE THEN

Line 427: fnd_msg_pub.ADD;

423: --fnd_message.set_name('JTF', 'END_TIME CANNOT BE NULL');
424: --app_exception.raise_exception;
425: fnd_message.set_name('JTF', 'JTF_CAL_END_TIME');
426: --fnd_message.set_token('P_Name', 'END_TIME');
427: fnd_msg_pub.ADD;
428: v_error := 'Y';
429: END IF;
430:
431: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_begin_time, x_end_time) = FALSE THEN

Line 437: fnd_msg_pub.ADD;

433: --app_exception.raise_exception;
434: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_END_TIME');
435: --fnd_message.set_token('P_Start_Date', X_BEGIN_TIME);
436: --fnd_message.set_token('P_End_Date', X_END_TIME);
437: fnd_msg_pub.ADD;
438: v_error := 'Y';
439: END IF;
440:
441: IF jtf_cal_shift_constructs_pkg.end_greater_than_begin(x_start_date_active, x_end_date_active) = FALSE THEN

Line 447: fnd_msg_pub.ADD;

443: --app_exception.raise_exception;
444: fnd_message.set_name('JTF', 'JTF_CAL_END_DATE');
445: fnd_message.set_token('P_Start_Date', x_start_date_active);
446: fnd_message.set_token('P_End_Date', x_end_date_active);
447: fnd_msg_pub.ADD;
448: v_error := 'Y';
449: END IF;
450:
451: /*

Line 457: fnd_msg_pub.add;

453: --fnd_message.set_name('JTF', 'AVAILABILITY_TYPE_CODE CANNOT BE NULL');
454: --app_exception.raise_exception;
455: fnd_message.set_name('JTF', 'JTF_CAL_AVAILABILITY_TYPE_CODE');
456: --fnd_message.set_token('P_Name', 'AVAILABILITY_TYPE_CODE');
457: fnd_msg_pub.add;
458: v_error := 'Y';
459: END IF;
460:
461: --IF JTF_CAL_SHIFT_CONSTRUCTS_PKG.VALIDATE_FND_LOOKUPS(X_AVAILABILITY_TYPE_CODE, 'AVAILABILITY TYPE')

Line 475: fnd_msg_pub.add;

471: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');
472: --app_exception.raise_exception;
473: fnd_message.set_name('JTF', 'JTF_CAL_ALREADY_EXISTS');
474: fnd_message.set_token('P_Name', 'SHIFT');
475: fnd_msg_pub.add;
476: v_error := 'Y';
477: END IF;
478: */
479: IF jtf_cal_shift_constructs_pkg.not_null(x_start_date_active) = FALSE THEN

Line 483: fnd_msg_pub.ADD;

479: IF jtf_cal_shift_constructs_pkg.not_null(x_start_date_active) = FALSE THEN
480: --fnd_message.set_name('JTF', 'START_DATE_ACTIVE CANNOT BE NULL');
481: --app_exception.raise_exception;
482: fnd_message.set_name('JTF', 'JTF_CAL_START_DATE');
483: fnd_msg_pub.ADD;
484: v_error := 'Y';
485: END IF;
486:
487: -- Comment out by Jane Wang on 03/12/2002

Line 497: fnd_msg_pub.add;

493: X_SHIFT_CONSTRUCT_ID) = FALSE THEN
494: --fnd_message.set_name('JTF', 'SHIFT WITH THESE PARAMETERS ALREADY EXISTS');
495: --app_exception.raise_exception;
496: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_PATTERN_OVERLAPS');
497: fnd_msg_pub.add;
498: v_error := 'Y';
499: END IF;
500: */
501: IF v_error = 'Y' THEN

Line 578: fnd_msg_pub.ADD;

574: WHERE shift_construct_id = x_shift_construct_id;
575: EXCEPTION
576: WHEN OTHERS THEN
577: fnd_message.set_name('JTF', 'JTF_FM_ADMIN_EDITERROR');
578: fnd_msg_pub.ADD;
579: v_error := 'Y';
580: x_error := 'Y';
581: END;
582: -- if (sql%notfound) then

Line 606: fnd_msg_pub.ADD;

602: CLOSE c_sh_exist_in_task_assmt;
603:
604: IF NVL(l_exists, 2) = 1 THEN
605: fnd_message.set_name('JTF', 'JTF_CAL_SHIFT_DEL_VAL');
606: fnd_msg_pub.ADD;
607: v_error := 'Y';
608: END IF;
609:
610: IF v_error = 'Y' THEN