APPS.CS_TM_LABOR_SCHEDULE_PVT dependencies on FND_MESSAGE

Line 282: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

278:
279: -- Validate Monday Regular Table for Overlap
280: IF lv_tm_mon_reg_tbl_type.count = 0 THEN
281: --error
282: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
283: FND_MESSAGE.set_token('API_NAME', l_api_name);
284: FND_MESSAGE.set_token('VALUE', 'Regular');
285: FND_MESSAGE.set_token('DAY', 'MONDAY');
286: FND_MSG_PUB.add;

Line 283: FND_MESSAGE.set_token('API_NAME', l_api_name);

279: -- Validate Monday Regular Table for Overlap
280: IF lv_tm_mon_reg_tbl_type.count = 0 THEN
281: --error
282: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
283: FND_MESSAGE.set_token('API_NAME', l_api_name);
284: FND_MESSAGE.set_token('VALUE', 'Regular');
285: FND_MESSAGE.set_token('DAY', 'MONDAY');
286: FND_MSG_PUB.add;
287: RAISE FND_API.g_exc_error;

Line 284: FND_MESSAGE.set_token('VALUE', 'Regular');

280: IF lv_tm_mon_reg_tbl_type.count = 0 THEN
281: --error
282: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
283: FND_MESSAGE.set_token('API_NAME', l_api_name);
284: FND_MESSAGE.set_token('VALUE', 'Regular');
285: FND_MESSAGE.set_token('DAY', 'MONDAY');
286: FND_MSG_PUB.add;
287: RAISE FND_API.g_exc_error;
288: ELSE ---Call Function To validate Monday Table

Line 285: FND_MESSAGE.set_token('DAY', 'MONDAY');

281: --error
282: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
283: FND_MESSAGE.set_token('API_NAME', l_api_name);
284: FND_MESSAGE.set_token('VALUE', 'Regular');
285: FND_MESSAGE.set_token('DAY', 'MONDAY');
286: FND_MSG_PUB.add;
287: RAISE FND_API.g_exc_error;
288: ELSE ---Call Function To validate Monday Table
289: VALIDATE_OVERLAP

Line 301: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

297:
298: -- Validate Tuesday Regular Table for Overlap
299: IF lv_tm_tue_reg_tbl_type.count = 0 THEN
300: --error
301: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
302: FND_MESSAGE.set_token('API_NAME', l_api_name);
303: FND_MESSAGE.set_token ('VALUE', 'Regular');
304: FND_MESSAGE.set_token('DAY', 'TUESDAY');
305: FND_MSG_PUB.add;

Line 302: FND_MESSAGE.set_token('API_NAME', l_api_name);

298: -- Validate Tuesday Regular Table for Overlap
299: IF lv_tm_tue_reg_tbl_type.count = 0 THEN
300: --error
301: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
302: FND_MESSAGE.set_token('API_NAME', l_api_name);
303: FND_MESSAGE.set_token ('VALUE', 'Regular');
304: FND_MESSAGE.set_token('DAY', 'TUESDAY');
305: FND_MSG_PUB.add;
306: RAISE FND_API.g_exc_error;

Line 303: FND_MESSAGE.set_token ('VALUE', 'Regular');

299: IF lv_tm_tue_reg_tbl_type.count = 0 THEN
300: --error
301: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
302: FND_MESSAGE.set_token('API_NAME', l_api_name);
303: FND_MESSAGE.set_token ('VALUE', 'Regular');
304: FND_MESSAGE.set_token('DAY', 'TUESDAY');
305: FND_MSG_PUB.add;
306: RAISE FND_API.g_exc_error;
307: ELSE ---Call Function To validate Tuesday Table

Line 304: FND_MESSAGE.set_token('DAY', 'TUESDAY');

300: --error
301: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
302: FND_MESSAGE.set_token('API_NAME', l_api_name);
303: FND_MESSAGE.set_token ('VALUE', 'Regular');
304: FND_MESSAGE.set_token('DAY', 'TUESDAY');
305: FND_MSG_PUB.add;
306: RAISE FND_API.g_exc_error;
307: ELSE ---Call Function To validate Tuesday Table
308: VALIDATE_OVERLAP

Line 320: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

316:
317: -- Validate Wednesday Regular Table for Overlap
318: IF lv_tm_wed_reg_tbl_type.count = 0 THEN
319: --error
320: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
321: FND_MESSAGE.set_token('API_NAME', l_api_name);
322: FND_MESSAGE.set_token ('VALUE', 'Regular');
323: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
324: FND_MSG_PUB.add;

Line 321: FND_MESSAGE.set_token('API_NAME', l_api_name);

317: -- Validate Wednesday Regular Table for Overlap
318: IF lv_tm_wed_reg_tbl_type.count = 0 THEN
319: --error
320: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
321: FND_MESSAGE.set_token('API_NAME', l_api_name);
322: FND_MESSAGE.set_token ('VALUE', 'Regular');
323: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
324: FND_MSG_PUB.add;
325: RAISE FND_API.g_exc_error;

Line 322: FND_MESSAGE.set_token ('VALUE', 'Regular');

318: IF lv_tm_wed_reg_tbl_type.count = 0 THEN
319: --error
320: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
321: FND_MESSAGE.set_token('API_NAME', l_api_name);
322: FND_MESSAGE.set_token ('VALUE', 'Regular');
323: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
324: FND_MSG_PUB.add;
325: RAISE FND_API.g_exc_error;
326: ELSE ---Call Function To validate Wednesday Table

Line 323: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');

319: --error
320: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
321: FND_MESSAGE.set_token('API_NAME', l_api_name);
322: FND_MESSAGE.set_token ('VALUE', 'Regular');
323: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
324: FND_MSG_PUB.add;
325: RAISE FND_API.g_exc_error;
326: ELSE ---Call Function To validate Wednesday Table
327: VALIDATE_OVERLAP

Line 339: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

335:
336: -- Validate Thursday Regular Table for Overlap
337: IF lv_tm_thurs_reg_tbl_type.count = 0 THEN
338: --error
339: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
340: FND_MESSAGE.set_token('API_NAME', l_api_name);
341: FND_MESSAGE.set_token ('VALUE', 'Regular');
342: FND_MESSAGE.set_token('DAY', 'THURSDAY');
343: FND_MSG_PUB.add;

Line 340: FND_MESSAGE.set_token('API_NAME', l_api_name);

336: -- Validate Thursday Regular Table for Overlap
337: IF lv_tm_thurs_reg_tbl_type.count = 0 THEN
338: --error
339: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
340: FND_MESSAGE.set_token('API_NAME', l_api_name);
341: FND_MESSAGE.set_token ('VALUE', 'Regular');
342: FND_MESSAGE.set_token('DAY', 'THURSDAY');
343: FND_MSG_PUB.add;
344: RAISE FND_API.g_exc_error;

Line 341: FND_MESSAGE.set_token ('VALUE', 'Regular');

337: IF lv_tm_thurs_reg_tbl_type.count = 0 THEN
338: --error
339: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
340: FND_MESSAGE.set_token('API_NAME', l_api_name);
341: FND_MESSAGE.set_token ('VALUE', 'Regular');
342: FND_MESSAGE.set_token('DAY', 'THURSDAY');
343: FND_MSG_PUB.add;
344: RAISE FND_API.g_exc_error;
345: ELSE ---Call Function To validate Thursday Table

Line 342: FND_MESSAGE.set_token('DAY', 'THURSDAY');

338: --error
339: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
340: FND_MESSAGE.set_token('API_NAME', l_api_name);
341: FND_MESSAGE.set_token ('VALUE', 'Regular');
342: FND_MESSAGE.set_token('DAY', 'THURSDAY');
343: FND_MSG_PUB.add;
344: RAISE FND_API.g_exc_error;
345: ELSE ---Call Function To validate Thursday Table
346: VALIDATE_OVERLAP

Line 358: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

354:
355: -- Validate Friday Regular Table for Overlap
356: IF lv_tm_fri_reg_tbl_type.count = 0 THEN
357: --error
358: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
359: FND_MESSAGE.set_token('API_NAME', l_api_name);
360: FND_MESSAGE.set_token ('VALUE', 'Regular');
361: FND_MESSAGE.set_token('DAY', 'FRIDAY');
362: FND_MSG_PUB.add;

Line 359: FND_MESSAGE.set_token('API_NAME', l_api_name);

355: -- Validate Friday Regular Table for Overlap
356: IF lv_tm_fri_reg_tbl_type.count = 0 THEN
357: --error
358: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
359: FND_MESSAGE.set_token('API_NAME', l_api_name);
360: FND_MESSAGE.set_token ('VALUE', 'Regular');
361: FND_MESSAGE.set_token('DAY', 'FRIDAY');
362: FND_MSG_PUB.add;
363: RAISE FND_API.g_exc_error;

Line 360: FND_MESSAGE.set_token ('VALUE', 'Regular');

356: IF lv_tm_fri_reg_tbl_type.count = 0 THEN
357: --error
358: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
359: FND_MESSAGE.set_token('API_NAME', l_api_name);
360: FND_MESSAGE.set_token ('VALUE', 'Regular');
361: FND_MESSAGE.set_token('DAY', 'FRIDAY');
362: FND_MSG_PUB.add;
363: RAISE FND_API.g_exc_error;
364: ELSE ---Call Function To validate Friday Table

Line 361: FND_MESSAGE.set_token('DAY', 'FRIDAY');

357: --error
358: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
359: FND_MESSAGE.set_token('API_NAME', l_api_name);
360: FND_MESSAGE.set_token ('VALUE', 'Regular');
361: FND_MESSAGE.set_token('DAY', 'FRIDAY');
362: FND_MSG_PUB.add;
363: RAISE FND_API.g_exc_error;
364: ELSE ---Call Function To validate Friday Table
365: VALIDATE_OVERLAP

Line 377: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

373:
374: -- Validate Saturday Regular Table for Overlap
375: IF lv_tm_sat_reg_tbl_type.count = 0 THEN
376: --error
377: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
378: FND_MESSAGE.set_token('API_NAME', l_api_name);
379: FND_MESSAGE.set_token ('VALUE', 'Regular');
380: FND_MESSAGE.set_token('DAY', 'SATURDAY');
381: FND_MSG_PUB.add;

Line 378: FND_MESSAGE.set_token('API_NAME', l_api_name);

374: -- Validate Saturday Regular Table for Overlap
375: IF lv_tm_sat_reg_tbl_type.count = 0 THEN
376: --error
377: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
378: FND_MESSAGE.set_token('API_NAME', l_api_name);
379: FND_MESSAGE.set_token ('VALUE', 'Regular');
380: FND_MESSAGE.set_token('DAY', 'SATURDAY');
381: FND_MSG_PUB.add;
382: RAISE FND_API.g_exc_error;

Line 379: FND_MESSAGE.set_token ('VALUE', 'Regular');

375: IF lv_tm_sat_reg_tbl_type.count = 0 THEN
376: --error
377: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
378: FND_MESSAGE.set_token('API_NAME', l_api_name);
379: FND_MESSAGE.set_token ('VALUE', 'Regular');
380: FND_MESSAGE.set_token('DAY', 'SATURDAY');
381: FND_MSG_PUB.add;
382: RAISE FND_API.g_exc_error;
383: ELSE ---Call Function To validate Saturday Table

Line 380: FND_MESSAGE.set_token('DAY', 'SATURDAY');

376: --error
377: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
378: FND_MESSAGE.set_token('API_NAME', l_api_name);
379: FND_MESSAGE.set_token ('VALUE', 'Regular');
380: FND_MESSAGE.set_token('DAY', 'SATURDAY');
381: FND_MSG_PUB.add;
382: RAISE FND_API.g_exc_error;
383: ELSE ---Call Function To validate Saturday Table
384: VALIDATE_OVERLAP

Line 396: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

392:
393: -- Validate Sunday Regular Table for Overlap
394: IF lv_tm_sun_reg_tbl_type.count = 0 THEN
395: --error
396: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
397: FND_MESSAGE.set_token('API_NAME', l_api_name);
398: FND_MESSAGE.set_token ('VALUE', 'Regular');
399: FND_MESSAGE.set_token('DAY', 'SUNDAY');
400: FND_MSG_PUB.add;

Line 397: FND_MESSAGE.set_token('API_NAME', l_api_name);

393: -- Validate Sunday Regular Table for Overlap
394: IF lv_tm_sun_reg_tbl_type.count = 0 THEN
395: --error
396: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
397: FND_MESSAGE.set_token('API_NAME', l_api_name);
398: FND_MESSAGE.set_token ('VALUE', 'Regular');
399: FND_MESSAGE.set_token('DAY', 'SUNDAY');
400: FND_MSG_PUB.add;
401: RAISE FND_API.g_exc_error;

Line 398: FND_MESSAGE.set_token ('VALUE', 'Regular');

394: IF lv_tm_sun_reg_tbl_type.count = 0 THEN
395: --error
396: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
397: FND_MESSAGE.set_token('API_NAME', l_api_name);
398: FND_MESSAGE.set_token ('VALUE', 'Regular');
399: FND_MESSAGE.set_token('DAY', 'SUNDAY');
400: FND_MSG_PUB.add;
401: RAISE FND_API.g_exc_error;
402: ELSE ---Call Function To validate Sunday Table

Line 399: FND_MESSAGE.set_token('DAY', 'SUNDAY');

395: --error
396: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
397: FND_MESSAGE.set_token('API_NAME', l_api_name);
398: FND_MESSAGE.set_token ('VALUE', 'Regular');
399: FND_MESSAGE.set_token('DAY', 'SUNDAY');
400: FND_MSG_PUB.add;
401: RAISE FND_API.g_exc_error;
402: ELSE ---Call Function To validate Sunday Table
403: VALIDATE_OVERLAP

Line 416: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

412: -- Validate Monday Holiday Table for Overlap
413: -- Following commented out for 11.5.9 Release.
414: /* IF lv_tm_mon_hol_tbl_type.count = 0 THEN
415: --error
416: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
417: FND_MESSAGE.set_token('API_NAME', l_api_name);
418: FND_MESSAGE.set_token ('VALUE', 'Holiday');
419: FND_MESSAGE.set_token('DAY', 'MONDAY');
420: FND_MSG_PUB.add;

Line 417: FND_MESSAGE.set_token('API_NAME', l_api_name);

413: -- Following commented out for 11.5.9 Release.
414: /* IF lv_tm_mon_hol_tbl_type.count = 0 THEN
415: --error
416: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
417: FND_MESSAGE.set_token('API_NAME', l_api_name);
418: FND_MESSAGE.set_token ('VALUE', 'Holiday');
419: FND_MESSAGE.set_token('DAY', 'MONDAY');
420: FND_MSG_PUB.add;
421: RAISE FND_API.g_exc_error;

Line 418: FND_MESSAGE.set_token ('VALUE', 'Holiday');

414: /* IF lv_tm_mon_hol_tbl_type.count = 0 THEN
415: --error
416: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
417: FND_MESSAGE.set_token('API_NAME', l_api_name);
418: FND_MESSAGE.set_token ('VALUE', 'Holiday');
419: FND_MESSAGE.set_token('DAY', 'MONDAY');
420: FND_MSG_PUB.add;
421: RAISE FND_API.g_exc_error;
422: ELSE ---Call Function To validate Monday Holiday Table

Line 419: FND_MESSAGE.set_token('DAY', 'MONDAY');

415: --error
416: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
417: FND_MESSAGE.set_token('API_NAME', l_api_name);
418: FND_MESSAGE.set_token ('VALUE', 'Holiday');
419: FND_MESSAGE.set_token('DAY', 'MONDAY');
420: FND_MSG_PUB.add;
421: RAISE FND_API.g_exc_error;
422: ELSE ---Call Function To validate Monday Holiday Table
423: VALIDATE_OVERLAP

Line 435: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

431:
432: -- Validate Tuesday Holiday Table for Overlap
433: IF lv_tm_tue_hol_tbl_type.count = 0 THEN
434: --error
435: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
436: FND_MESSAGE.set_token('API_NAME', l_api_name);
437: FND_MESSAGE.set_token ('VALUE', 'Holiday');
438: FND_MESSAGE.set_token('DAY', 'TUESDAY');
439: FND_MSG_PUB.add;

Line 436: FND_MESSAGE.set_token('API_NAME', l_api_name);

432: -- Validate Tuesday Holiday Table for Overlap
433: IF lv_tm_tue_hol_tbl_type.count = 0 THEN
434: --error
435: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
436: FND_MESSAGE.set_token('API_NAME', l_api_name);
437: FND_MESSAGE.set_token ('VALUE', 'Holiday');
438: FND_MESSAGE.set_token('DAY', 'TUESDAY');
439: FND_MSG_PUB.add;
440: RAISE FND_API.g_exc_error;

Line 437: FND_MESSAGE.set_token ('VALUE', 'Holiday');

433: IF lv_tm_tue_hol_tbl_type.count = 0 THEN
434: --error
435: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
436: FND_MESSAGE.set_token('API_NAME', l_api_name);
437: FND_MESSAGE.set_token ('VALUE', 'Holiday');
438: FND_MESSAGE.set_token('DAY', 'TUESDAY');
439: FND_MSG_PUB.add;
440: RAISE FND_API.g_exc_error;
441: ELSE ---Call Function To validate Tuesday Holiday Table

Line 438: FND_MESSAGE.set_token('DAY', 'TUESDAY');

434: --error
435: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
436: FND_MESSAGE.set_token('API_NAME', l_api_name);
437: FND_MESSAGE.set_token ('VALUE', 'Holiday');
438: FND_MESSAGE.set_token('DAY', 'TUESDAY');
439: FND_MSG_PUB.add;
440: RAISE FND_API.g_exc_error;
441: ELSE ---Call Function To validate Tuesday Holiday Table
442: VALIDATE_OVERLAP

Line 454: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

450:
451: -- Validate Wednesday Holiday Table for Overlap
452: IF lv_tm_wed_hol_tbl_type.count = 0 THEN
453: --error
454: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
455: FND_MESSAGE.set_token('API_NAME', l_api_name);
456: FND_MESSAGE.set_token ('VALUE', 'Holiday');
457: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
458: FND_MSG_PUB.add;

Line 455: FND_MESSAGE.set_token('API_NAME', l_api_name);

451: -- Validate Wednesday Holiday Table for Overlap
452: IF lv_tm_wed_hol_tbl_type.count = 0 THEN
453: --error
454: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
455: FND_MESSAGE.set_token('API_NAME', l_api_name);
456: FND_MESSAGE.set_token ('VALUE', 'Holiday');
457: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
458: FND_MSG_PUB.add;
459: RAISE FND_API.g_exc_error;

Line 456: FND_MESSAGE.set_token ('VALUE', 'Holiday');

452: IF lv_tm_wed_hol_tbl_type.count = 0 THEN
453: --error
454: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
455: FND_MESSAGE.set_token('API_NAME', l_api_name);
456: FND_MESSAGE.set_token ('VALUE', 'Holiday');
457: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
458: FND_MSG_PUB.add;
459: RAISE FND_API.g_exc_error;
460: ELSE ---Call Function To validate Wednesday Holiday Table

Line 457: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');

453: --error
454: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
455: FND_MESSAGE.set_token('API_NAME', l_api_name);
456: FND_MESSAGE.set_token ('VALUE', 'Holiday');
457: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
458: FND_MSG_PUB.add;
459: RAISE FND_API.g_exc_error;
460: ELSE ---Call Function To validate Wednesday Holiday Table
461: VALIDATE_OVERLAP

Line 473: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

469:
470: -- Validate Thursday Holiday Table for Overlap
471: IF lv_tm_thurs_hol_tbl_type.count = 0 THEN
472: --error
473: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
474: FND_MESSAGE.set_token('API_NAME', l_api_name);
475: FND_MESSAGE.set_token ('VALUE', 'Holiday');
476: FND_MESSAGE.set_token('DAY', 'THURSDAY');
477: FND_MSG_PUB.add;

Line 474: FND_MESSAGE.set_token('API_NAME', l_api_name);

470: -- Validate Thursday Holiday Table for Overlap
471: IF lv_tm_thurs_hol_tbl_type.count = 0 THEN
472: --error
473: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
474: FND_MESSAGE.set_token('API_NAME', l_api_name);
475: FND_MESSAGE.set_token ('VALUE', 'Holiday');
476: FND_MESSAGE.set_token('DAY', 'THURSDAY');
477: FND_MSG_PUB.add;
478: RAISE FND_API.g_exc_error;

Line 475: FND_MESSAGE.set_token ('VALUE', 'Holiday');

471: IF lv_tm_thurs_hol_tbl_type.count = 0 THEN
472: --error
473: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
474: FND_MESSAGE.set_token('API_NAME', l_api_name);
475: FND_MESSAGE.set_token ('VALUE', 'Holiday');
476: FND_MESSAGE.set_token('DAY', 'THURSDAY');
477: FND_MSG_PUB.add;
478: RAISE FND_API.g_exc_error;
479: ELSE ---Call Function To validate Thursday Holiday Table

Line 476: FND_MESSAGE.set_token('DAY', 'THURSDAY');

472: --error
473: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
474: FND_MESSAGE.set_token('API_NAME', l_api_name);
475: FND_MESSAGE.set_token ('VALUE', 'Holiday');
476: FND_MESSAGE.set_token('DAY', 'THURSDAY');
477: FND_MSG_PUB.add;
478: RAISE FND_API.g_exc_error;
479: ELSE ---Call Function To validate Thursday Holiday Table
480: VALIDATE_OVERLAP

Line 492: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

488:
489: -- Validate Friday Holiday Table for Overlap
490: IF lv_tm_fri_hol_tbl_type.count = 0 THEN
491: --error
492: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
493: FND_MESSAGE.set_token('API_NAME', l_api_name);
494: FND_MESSAGE.set_token ('VALUE', 'Holiday');
495: FND_MESSAGE.set_token('DAY', 'FRIDAY');
496: FND_MSG_PUB.add;

Line 493: FND_MESSAGE.set_token('API_NAME', l_api_name);

489: -- Validate Friday Holiday Table for Overlap
490: IF lv_tm_fri_hol_tbl_type.count = 0 THEN
491: --error
492: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
493: FND_MESSAGE.set_token('API_NAME', l_api_name);
494: FND_MESSAGE.set_token ('VALUE', 'Holiday');
495: FND_MESSAGE.set_token('DAY', 'FRIDAY');
496: FND_MSG_PUB.add;
497: RAISE FND_API.g_exc_error;

Line 494: FND_MESSAGE.set_token ('VALUE', 'Holiday');

490: IF lv_tm_fri_hol_tbl_type.count = 0 THEN
491: --error
492: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
493: FND_MESSAGE.set_token('API_NAME', l_api_name);
494: FND_MESSAGE.set_token ('VALUE', 'Holiday');
495: FND_MESSAGE.set_token('DAY', 'FRIDAY');
496: FND_MSG_PUB.add;
497: RAISE FND_API.g_exc_error;
498: ELSE ---Call Function To validate Friday Holiday Table

Line 495: FND_MESSAGE.set_token('DAY', 'FRIDAY');

491: --error
492: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
493: FND_MESSAGE.set_token('API_NAME', l_api_name);
494: FND_MESSAGE.set_token ('VALUE', 'Holiday');
495: FND_MESSAGE.set_token('DAY', 'FRIDAY');
496: FND_MSG_PUB.add;
497: RAISE FND_API.g_exc_error;
498: ELSE ---Call Function To validate Friday Holiday Table
499: VALIDATE_OVERLAP

Line 511: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

507:
508: -- Validate Saturday Holiday Table for Overlap
509: IF lv_tm_sat_hol_tbl_type.count = 0 THEN
510: --error
511: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
512: FND_MESSAGE.set_token('API_NAME', l_api_name);
513: FND_MESSAGE.set_token ('VALUE', 'Holiday');
514: FND_MESSAGE.set_token('DAY', 'SATURDAY');
515: FND_MSG_PUB.add;

Line 512: FND_MESSAGE.set_token('API_NAME', l_api_name);

508: -- Validate Saturday Holiday Table for Overlap
509: IF lv_tm_sat_hol_tbl_type.count = 0 THEN
510: --error
511: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
512: FND_MESSAGE.set_token('API_NAME', l_api_name);
513: FND_MESSAGE.set_token ('VALUE', 'Holiday');
514: FND_MESSAGE.set_token('DAY', 'SATURDAY');
515: FND_MSG_PUB.add;
516: RAISE FND_API.g_exc_error;

Line 513: FND_MESSAGE.set_token ('VALUE', 'Holiday');

509: IF lv_tm_sat_hol_tbl_type.count = 0 THEN
510: --error
511: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
512: FND_MESSAGE.set_token('API_NAME', l_api_name);
513: FND_MESSAGE.set_token ('VALUE', 'Holiday');
514: FND_MESSAGE.set_token('DAY', 'SATURDAY');
515: FND_MSG_PUB.add;
516: RAISE FND_API.g_exc_error;
517: ELSE ---Call Function To validate Saturday Holiday Table

Line 514: FND_MESSAGE.set_token('DAY', 'SATURDAY');

510: --error
511: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
512: FND_MESSAGE.set_token('API_NAME', l_api_name);
513: FND_MESSAGE.set_token ('VALUE', 'Holiday');
514: FND_MESSAGE.set_token('DAY', 'SATURDAY');
515: FND_MSG_PUB.add;
516: RAISE FND_API.g_exc_error;
517: ELSE ---Call Function To validate Saturday Holiday Table
518: VALIDATE_OVERLAP

Line 530: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

526:
527: -- Validate Sunday Holiday Table for Overlap
528: IF lv_tm_sun_hol_tbl_type.count = 0 THEN
529: --error
530: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
531: FND_MESSAGE.set_token('API_NAME', l_api_name);
532: FND_MESSAGE.set_token ('VALUE', 'Holiday');
533: FND_MESSAGE.set_token('DAY', 'SUNDAY');
534: FND_MSG_PUB.add;

Line 531: FND_MESSAGE.set_token('API_NAME', l_api_name);

527: -- Validate Sunday Holiday Table for Overlap
528: IF lv_tm_sun_hol_tbl_type.count = 0 THEN
529: --error
530: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
531: FND_MESSAGE.set_token('API_NAME', l_api_name);
532: FND_MESSAGE.set_token ('VALUE', 'Holiday');
533: FND_MESSAGE.set_token('DAY', 'SUNDAY');
534: FND_MSG_PUB.add;
535: RAISE FND_API.g_exc_error;

Line 532: FND_MESSAGE.set_token ('VALUE', 'Holiday');

528: IF lv_tm_sun_hol_tbl_type.count = 0 THEN
529: --error
530: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
531: FND_MESSAGE.set_token('API_NAME', l_api_name);
532: FND_MESSAGE.set_token ('VALUE', 'Holiday');
533: FND_MESSAGE.set_token('DAY', 'SUNDAY');
534: FND_MSG_PUB.add;
535: RAISE FND_API.g_exc_error;
536: ELSE ---Call Function To validate Friday Holiday Table

Line 533: FND_MESSAGE.set_token('DAY', 'SUNDAY');

529: --error
530: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
531: FND_MESSAGE.set_token('API_NAME', l_api_name);
532: FND_MESSAGE.set_token ('VALUE', 'Holiday');
533: FND_MESSAGE.set_token('DAY', 'SUNDAY');
534: FND_MSG_PUB.add;
535: RAISE FND_API.g_exc_error;
536: ELSE ---Call Function To validate Friday Holiday Table
537: VALIDATE_OVERLAP

Line 814: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

810:
811: -- Validate Monday Regular Table for Completeness
812: IF lv_tm_mon_reg_tbl_type.count = 0 THEN
813: --error
814: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
815: FND_MESSAGE.set_token('API_NAME', l_api_name);
816: FND_MESSAGE.set_token('VALUE', 'Regular');
817: FND_MESSAGE.set_token('DAY', 'MONDAY');
818: FND_MSG_PUB.add;

Line 815: FND_MESSAGE.set_token('API_NAME', l_api_name);

811: -- Validate Monday Regular Table for Completeness
812: IF lv_tm_mon_reg_tbl_type.count = 0 THEN
813: --error
814: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
815: FND_MESSAGE.set_token('API_NAME', l_api_name);
816: FND_MESSAGE.set_token('VALUE', 'Regular');
817: FND_MESSAGE.set_token('DAY', 'MONDAY');
818: FND_MSG_PUB.add;
819: RAISE FND_API.g_exc_error;

Line 816: FND_MESSAGE.set_token('VALUE', 'Regular');

812: IF lv_tm_mon_reg_tbl_type.count = 0 THEN
813: --error
814: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
815: FND_MESSAGE.set_token('API_NAME', l_api_name);
816: FND_MESSAGE.set_token('VALUE', 'Regular');
817: FND_MESSAGE.set_token('DAY', 'MONDAY');
818: FND_MSG_PUB.add;
819: RAISE FND_API.g_exc_error;
820: ELSE ---Call Function To validate Monday Table

Line 817: FND_MESSAGE.set_token('DAY', 'MONDAY');

813: --error
814: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
815: FND_MESSAGE.set_token('API_NAME', l_api_name);
816: FND_MESSAGE.set_token('VALUE', 'Regular');
817: FND_MESSAGE.set_token('DAY', 'MONDAY');
818: FND_MSG_PUB.add;
819: RAISE FND_API.g_exc_error;
820: ELSE ---Call Function To validate Monday Table
821: VALIDATE_COMPLETE_CHECK

Line 833: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

829:
830: -- Validate Tuesday Regular Table for Completeness
831: IF lv_TM_TUE_REG_TBL_TYPE.COUNT = 0 THEN
832: -- error
833: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
834: FND_MESSAGE.set_token('API_NAME', l_api_name);
835: FND_MESSAGE.set_token('VALUE', 'Regular');
836: FND_MESSAGE.set_token('DAY', 'TUESDAY');
837: FND_MSG_PUB.add;

Line 834: FND_MESSAGE.set_token('API_NAME', l_api_name);

830: -- Validate Tuesday Regular Table for Completeness
831: IF lv_TM_TUE_REG_TBL_TYPE.COUNT = 0 THEN
832: -- error
833: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
834: FND_MESSAGE.set_token('API_NAME', l_api_name);
835: FND_MESSAGE.set_token('VALUE', 'Regular');
836: FND_MESSAGE.set_token('DAY', 'TUESDAY');
837: FND_MSG_PUB.add;
838: RAISE FND_API.g_exc_error;

Line 835: FND_MESSAGE.set_token('VALUE', 'Regular');

831: IF lv_TM_TUE_REG_TBL_TYPE.COUNT = 0 THEN
832: -- error
833: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
834: FND_MESSAGE.set_token('API_NAME', l_api_name);
835: FND_MESSAGE.set_token('VALUE', 'Regular');
836: FND_MESSAGE.set_token('DAY', 'TUESDAY');
837: FND_MSG_PUB.add;
838: RAISE FND_API.g_exc_error;
839: ELSE -- Call Function to validate the Tuesday Table

Line 836: FND_MESSAGE.set_token('DAY', 'TUESDAY');

832: -- error
833: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
834: FND_MESSAGE.set_token('API_NAME', l_api_name);
835: FND_MESSAGE.set_token('VALUE', 'Regular');
836: FND_MESSAGE.set_token('DAY', 'TUESDAY');
837: FND_MSG_PUB.add;
838: RAISE FND_API.g_exc_error;
839: ELSE -- Call Function to validate the Tuesday Table
840: VALIDATE_COMPLETE_CHECK

Line 852: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

848:
849: -- Validate Wednesday Regular Table for Completeness
850: IF lv_TM_WED_REG_TBL_TYPE.COUNT = 0 THEN
851: --error
852: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
853: FND_MESSAGE.set_token('API_NAME', l_api_name);
854: FND_MESSAGE.set_token('VALUE', 'Regular');
855: FND_MESSAGE.set_token('DAY', 'Wednesday');
856: FND_MSG_PUB.add;

Line 853: FND_MESSAGE.set_token('API_NAME', l_api_name);

849: -- Validate Wednesday Regular Table for Completeness
850: IF lv_TM_WED_REG_TBL_TYPE.COUNT = 0 THEN
851: --error
852: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
853: FND_MESSAGE.set_token('API_NAME', l_api_name);
854: FND_MESSAGE.set_token('VALUE', 'Regular');
855: FND_MESSAGE.set_token('DAY', 'Wednesday');
856: FND_MSG_PUB.add;
857: RAISE FND_API.g_exc_error;

Line 854: FND_MESSAGE.set_token('VALUE', 'Regular');

850: IF lv_TM_WED_REG_TBL_TYPE.COUNT = 0 THEN
851: --error
852: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
853: FND_MESSAGE.set_token('API_NAME', l_api_name);
854: FND_MESSAGE.set_token('VALUE', 'Regular');
855: FND_MESSAGE.set_token('DAY', 'Wednesday');
856: FND_MSG_PUB.add;
857: RAISE FND_API.g_exc_error;
858:

Line 855: FND_MESSAGE.set_token('DAY', 'Wednesday');

851: --error
852: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
853: FND_MESSAGE.set_token('API_NAME', l_api_name);
854: FND_MESSAGE.set_token('VALUE', 'Regular');
855: FND_MESSAGE.set_token('DAY', 'Wednesday');
856: FND_MSG_PUB.add;
857: RAISE FND_API.g_exc_error;
858:
859: ELSE -- Call Function to validate

Line 872: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

868:
869: -- Validate Thursday Regular Table for Completeness
870: IF lv_TM_THURS_REG_TBL_TYPE.COUNT = 0 THEN
871: --error
872: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
873: FND_MESSAGE.set_token('API_NAME', l_api_name);
874: FND_MESSAGE.set_token('VALUE', 'Regular');
875: FND_MESSAGE.set_token('DAY', 'THURSDAY');
876: FND_MSG_PUB.add;

Line 873: FND_MESSAGE.set_token('API_NAME', l_api_name);

869: -- Validate Thursday Regular Table for Completeness
870: IF lv_TM_THURS_REG_TBL_TYPE.COUNT = 0 THEN
871: --error
872: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
873: FND_MESSAGE.set_token('API_NAME', l_api_name);
874: FND_MESSAGE.set_token('VALUE', 'Regular');
875: FND_MESSAGE.set_token('DAY', 'THURSDAY');
876: FND_MSG_PUB.add;
877: RAISE FND_API.g_exc_error;

Line 874: FND_MESSAGE.set_token('VALUE', 'Regular');

870: IF lv_TM_THURS_REG_TBL_TYPE.COUNT = 0 THEN
871: --error
872: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
873: FND_MESSAGE.set_token('API_NAME', l_api_name);
874: FND_MESSAGE.set_token('VALUE', 'Regular');
875: FND_MESSAGE.set_token('DAY', 'THURSDAY');
876: FND_MSG_PUB.add;
877: RAISE FND_API.g_exc_error;
878: ELSE -- Call Function to validate

Line 875: FND_MESSAGE.set_token('DAY', 'THURSDAY');

871: --error
872: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
873: FND_MESSAGE.set_token('API_NAME', l_api_name);
874: FND_MESSAGE.set_token('VALUE', 'Regular');
875: FND_MESSAGE.set_token('DAY', 'THURSDAY');
876: FND_MSG_PUB.add;
877: RAISE FND_API.g_exc_error;
878: ELSE -- Call Function to validate
879: VALIDATE_COMPLETE_CHECK

Line 891: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

887:
888: -- Validate Friday Regular Table for Completeness
889: IF lv_TM_FRI_REG_TBL_TYPE.COUNT = 0 THEN
890: --error
891: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
892: FND_MESSAGE.set_token('API_NAME', l_api_name);
893: FND_MESSAGE.set_token('VALUE', 'Regular');
894: FND_MESSAGE.set_token('DAY', 'FRIDAY');
895: FND_MSG_PUB.add;

Line 892: FND_MESSAGE.set_token('API_NAME', l_api_name);

888: -- Validate Friday Regular Table for Completeness
889: IF lv_TM_FRI_REG_TBL_TYPE.COUNT = 0 THEN
890: --error
891: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
892: FND_MESSAGE.set_token('API_NAME', l_api_name);
893: FND_MESSAGE.set_token('VALUE', 'Regular');
894: FND_MESSAGE.set_token('DAY', 'FRIDAY');
895: FND_MSG_PUB.add;
896: RAISE FND_API.g_exc_error;

Line 893: FND_MESSAGE.set_token('VALUE', 'Regular');

889: IF lv_TM_FRI_REG_TBL_TYPE.COUNT = 0 THEN
890: --error
891: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
892: FND_MESSAGE.set_token('API_NAME', l_api_name);
893: FND_MESSAGE.set_token('VALUE', 'Regular');
894: FND_MESSAGE.set_token('DAY', 'FRIDAY');
895: FND_MSG_PUB.add;
896: RAISE FND_API.g_exc_error;
897: ELSE -- Call Function to validate

Line 894: FND_MESSAGE.set_token('DAY', 'FRIDAY');

890: --error
891: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
892: FND_MESSAGE.set_token('API_NAME', l_api_name);
893: FND_MESSAGE.set_token('VALUE', 'Regular');
894: FND_MESSAGE.set_token('DAY', 'FRIDAY');
895: FND_MSG_PUB.add;
896: RAISE FND_API.g_exc_error;
897: ELSE -- Call Function to validate
898: VALIDATE_COMPLETE_CHECK

Line 910: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

906:
907: -- Validate Saturday Regular Table for Completeness
908: IF lv_TM_SAT_REG_TBL_TYPE.COUNT = 0 THEN
909: --error
910: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
911: FND_MESSAGE.set_token('API_NAME', l_api_name);
912: FND_MESSAGE.set_token('VALUE', 'Regular');
913: FND_MESSAGE.set_token('DAY', 'SATURDAY');
914: FND_MSG_PUB.add;

Line 911: FND_MESSAGE.set_token('API_NAME', l_api_name);

907: -- Validate Saturday Regular Table for Completeness
908: IF lv_TM_SAT_REG_TBL_TYPE.COUNT = 0 THEN
909: --error
910: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
911: FND_MESSAGE.set_token('API_NAME', l_api_name);
912: FND_MESSAGE.set_token('VALUE', 'Regular');
913: FND_MESSAGE.set_token('DAY', 'SATURDAY');
914: FND_MSG_PUB.add;
915: RAISE FND_API.g_exc_error;

Line 912: FND_MESSAGE.set_token('VALUE', 'Regular');

908: IF lv_TM_SAT_REG_TBL_TYPE.COUNT = 0 THEN
909: --error
910: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
911: FND_MESSAGE.set_token('API_NAME', l_api_name);
912: FND_MESSAGE.set_token('VALUE', 'Regular');
913: FND_MESSAGE.set_token('DAY', 'SATURDAY');
914: FND_MSG_PUB.add;
915: RAISE FND_API.g_exc_error;
916: ELSE -- Call Function to validate

Line 913: FND_MESSAGE.set_token('DAY', 'SATURDAY');

909: --error
910: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
911: FND_MESSAGE.set_token('API_NAME', l_api_name);
912: FND_MESSAGE.set_token('VALUE', 'Regular');
913: FND_MESSAGE.set_token('DAY', 'SATURDAY');
914: FND_MSG_PUB.add;
915: RAISE FND_API.g_exc_error;
916: ELSE -- Call Function to validate
917: VALIDATE_COMPLETE_CHECK

Line 929: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

925:
926: -- Validate Sunday Regular Table for Completeness
927: IF lv_TM_SUN_REG_TBL_TYPE.COUNT = 0 THEN
928: --error
929: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
930: FND_MESSAGE.set_token('API_NAME', l_api_name);
931: FND_MESSAGE.set_token('VALUE', 'Regular');
932: FND_MESSAGE.set_token('DAY', 'SUNDAY');
933: FND_MSG_PUB.add;

Line 930: FND_MESSAGE.set_token('API_NAME', l_api_name);

926: -- Validate Sunday Regular Table for Completeness
927: IF lv_TM_SUN_REG_TBL_TYPE.COUNT = 0 THEN
928: --error
929: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
930: FND_MESSAGE.set_token('API_NAME', l_api_name);
931: FND_MESSAGE.set_token('VALUE', 'Regular');
932: FND_MESSAGE.set_token('DAY', 'SUNDAY');
933: FND_MSG_PUB.add;
934: RAISE FND_API.g_exc_error;

Line 931: FND_MESSAGE.set_token('VALUE', 'Regular');

927: IF lv_TM_SUN_REG_TBL_TYPE.COUNT = 0 THEN
928: --error
929: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
930: FND_MESSAGE.set_token('API_NAME', l_api_name);
931: FND_MESSAGE.set_token('VALUE', 'Regular');
932: FND_MESSAGE.set_token('DAY', 'SUNDAY');
933: FND_MSG_PUB.add;
934: RAISE FND_API.g_exc_error;
935: ELSE -- Call Function to validate

Line 932: FND_MESSAGE.set_token('DAY', 'SUNDAY');

928: --error
929: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
930: FND_MESSAGE.set_token('API_NAME', l_api_name);
931: FND_MESSAGE.set_token('VALUE', 'Regular');
932: FND_MESSAGE.set_token('DAY', 'SUNDAY');
933: FND_MSG_PUB.add;
934: RAISE FND_API.g_exc_error;
935: ELSE -- Call Function to validate
936: VALIDATE_COMPLETE_CHECK

Line 949: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

945: -- Validate Monday Holiday Table for Completeness
946: -- Following Commented out for 11.5.9 release.
947: /* IF lv_tm_mon_hol_tbl_type.count = 0 THEN
948: --error
949: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
950: FND_MESSAGE.set_token('API_NAME', l_api_name);
951: FND_MESSAGE.set_token('VALUE', 'Holiday');
952: FND_MESSAGE.set_token('DAY', 'MONDAY');
953: FND_MSG_PUB.add;

Line 950: FND_MESSAGE.set_token('API_NAME', l_api_name);

946: -- Following Commented out for 11.5.9 release.
947: /* IF lv_tm_mon_hol_tbl_type.count = 0 THEN
948: --error
949: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
950: FND_MESSAGE.set_token('API_NAME', l_api_name);
951: FND_MESSAGE.set_token('VALUE', 'Holiday');
952: FND_MESSAGE.set_token('DAY', 'MONDAY');
953: FND_MSG_PUB.add;
954: RAISE FND_API.g_exc_error;

Line 951: FND_MESSAGE.set_token('VALUE', 'Holiday');

947: /* IF lv_tm_mon_hol_tbl_type.count = 0 THEN
948: --error
949: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
950: FND_MESSAGE.set_token('API_NAME', l_api_name);
951: FND_MESSAGE.set_token('VALUE', 'Holiday');
952: FND_MESSAGE.set_token('DAY', 'MONDAY');
953: FND_MSG_PUB.add;
954: RAISE FND_API.g_exc_error;
955: ELSE ---Call Function To validate Monday Holiday Table

Line 952: FND_MESSAGE.set_token('DAY', 'MONDAY');

948: --error
949: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
950: FND_MESSAGE.set_token('API_NAME', l_api_name);
951: FND_MESSAGE.set_token('VALUE', 'Holiday');
952: FND_MESSAGE.set_token('DAY', 'MONDAY');
953: FND_MSG_PUB.add;
954: RAISE FND_API.g_exc_error;
955: ELSE ---Call Function To validate Monday Holiday Table
956: VALIDATE_COMPLETE_CHECK

Line 968: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

964:
965: -- Validate Tuesday Holiday Table for Completeness
966: IF lv_tm_tue_hol_tbl_type.count = 0 THEN
967: --error
968: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
969: FND_MESSAGE.set_token('API_NAME', l_api_name);
970: FND_MESSAGE.set_token('VALUE', 'Holiday');
971: FND_MESSAGE.set_token('DAY', 'TUESDAY');
972: FND_MSG_PUB.add;

Line 969: FND_MESSAGE.set_token('API_NAME', l_api_name);

965: -- Validate Tuesday Holiday Table for Completeness
966: IF lv_tm_tue_hol_tbl_type.count = 0 THEN
967: --error
968: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
969: FND_MESSAGE.set_token('API_NAME', l_api_name);
970: FND_MESSAGE.set_token('VALUE', 'Holiday');
971: FND_MESSAGE.set_token('DAY', 'TUESDAY');
972: FND_MSG_PUB.add;
973: RAISE FND_API.g_exc_error;

Line 970: FND_MESSAGE.set_token('VALUE', 'Holiday');

966: IF lv_tm_tue_hol_tbl_type.count = 0 THEN
967: --error
968: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
969: FND_MESSAGE.set_token('API_NAME', l_api_name);
970: FND_MESSAGE.set_token('VALUE', 'Holiday');
971: FND_MESSAGE.set_token('DAY', 'TUESDAY');
972: FND_MSG_PUB.add;
973: RAISE FND_API.g_exc_error;
974: ELSE ---Call Function To validate Tuesday Holiday Table

Line 971: FND_MESSAGE.set_token('DAY', 'TUESDAY');

967: --error
968: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
969: FND_MESSAGE.set_token('API_NAME', l_api_name);
970: FND_MESSAGE.set_token('VALUE', 'Holiday');
971: FND_MESSAGE.set_token('DAY', 'TUESDAY');
972: FND_MSG_PUB.add;
973: RAISE FND_API.g_exc_error;
974: ELSE ---Call Function To validate Tuesday Holiday Table
975: VALIDATE_COMPLETE_CHECK

Line 987: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

983:
984: -- Validate Wednesday Holiday Table for Completeness
985: IF lv_tm_wed_hol_tbl_type.count = 0 THEN
986: --error
987: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
988: FND_MESSAGE.set_token('API_NAME', l_api_name);
989: FND_MESSAGE.set_token('VALUE', 'Holiday');
990: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
991: FND_MSG_PUB.add;

Line 988: FND_MESSAGE.set_token('API_NAME', l_api_name);

984: -- Validate Wednesday Holiday Table for Completeness
985: IF lv_tm_wed_hol_tbl_type.count = 0 THEN
986: --error
987: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
988: FND_MESSAGE.set_token('API_NAME', l_api_name);
989: FND_MESSAGE.set_token('VALUE', 'Holiday');
990: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
991: FND_MSG_PUB.add;
992: RAISE FND_API.g_exc_error;

Line 989: FND_MESSAGE.set_token('VALUE', 'Holiday');

985: IF lv_tm_wed_hol_tbl_type.count = 0 THEN
986: --error
987: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
988: FND_MESSAGE.set_token('API_NAME', l_api_name);
989: FND_MESSAGE.set_token('VALUE', 'Holiday');
990: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
991: FND_MSG_PUB.add;
992: RAISE FND_API.g_exc_error;
993: ELSE ---Call Function To validate Wednesday Holiday Table

Line 990: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');

986: --error
987: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
988: FND_MESSAGE.set_token('API_NAME', l_api_name);
989: FND_MESSAGE.set_token('VALUE', 'Holiday');
990: FND_MESSAGE.set_token('DAY', 'WEDNESDAY');
991: FND_MSG_PUB.add;
992: RAISE FND_API.g_exc_error;
993: ELSE ---Call Function To validate Wednesday Holiday Table
994: VALIDATE_COMPLETE_CHECK

Line 1006: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

1002:
1003: -- Validate Thursday Holiday Table for Completeness
1004: IF lv_tm_thurs_hol_tbl_type.count = 0 THEN
1005: --error
1006: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1007: FND_MESSAGE.set_token('API_NAME', l_api_name);
1008: FND_MESSAGE.set_token('VALUE', 'Holiday');
1009: FND_MESSAGE.set_token('DAY', 'THURSDAY');
1010: FND_MSG_PUB.add;

Line 1007: FND_MESSAGE.set_token('API_NAME', l_api_name);

1003: -- Validate Thursday Holiday Table for Completeness
1004: IF lv_tm_thurs_hol_tbl_type.count = 0 THEN
1005: --error
1006: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1007: FND_MESSAGE.set_token('API_NAME', l_api_name);
1008: FND_MESSAGE.set_token('VALUE', 'Holiday');
1009: FND_MESSAGE.set_token('DAY', 'THURSDAY');
1010: FND_MSG_PUB.add;
1011: RAISE FND_API.g_exc_error;

Line 1008: FND_MESSAGE.set_token('VALUE', 'Holiday');

1004: IF lv_tm_thurs_hol_tbl_type.count = 0 THEN
1005: --error
1006: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1007: FND_MESSAGE.set_token('API_NAME', l_api_name);
1008: FND_MESSAGE.set_token('VALUE', 'Holiday');
1009: FND_MESSAGE.set_token('DAY', 'THURSDAY');
1010: FND_MSG_PUB.add;
1011: RAISE FND_API.g_exc_error;
1012: ELSE ---Call Function To validate Thursday Holiday Table

Line 1009: FND_MESSAGE.set_token('DAY', 'THURSDAY');

1005: --error
1006: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1007: FND_MESSAGE.set_token('API_NAME', l_api_name);
1008: FND_MESSAGE.set_token('VALUE', 'Holiday');
1009: FND_MESSAGE.set_token('DAY', 'THURSDAY');
1010: FND_MSG_PUB.add;
1011: RAISE FND_API.g_exc_error;
1012: ELSE ---Call Function To validate Thursday Holiday Table
1013: VALIDATE_COMPLETE_CHECK

Line 1025: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

1021:
1022: -- Validate Friday Holiday Table for Completeness
1023: IF lv_tm_fri_hol_tbl_type.count = 0 THEN
1024: --error
1025: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1026: FND_MESSAGE.set_token('API_NAME', l_api_name);
1027: FND_MESSAGE.set_token('VALUE', 'Holiday');
1028: FND_MESSAGE.set_token('DAY', 'FRIDAY');
1029: FND_MSG_PUB.add;

Line 1026: FND_MESSAGE.set_token('API_NAME', l_api_name);

1022: -- Validate Friday Holiday Table for Completeness
1023: IF lv_tm_fri_hol_tbl_type.count = 0 THEN
1024: --error
1025: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1026: FND_MESSAGE.set_token('API_NAME', l_api_name);
1027: FND_MESSAGE.set_token('VALUE', 'Holiday');
1028: FND_MESSAGE.set_token('DAY', 'FRIDAY');
1029: FND_MSG_PUB.add;
1030: RAISE FND_API.g_exc_error;

Line 1027: FND_MESSAGE.set_token('VALUE', 'Holiday');

1023: IF lv_tm_fri_hol_tbl_type.count = 0 THEN
1024: --error
1025: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1026: FND_MESSAGE.set_token('API_NAME', l_api_name);
1027: FND_MESSAGE.set_token('VALUE', 'Holiday');
1028: FND_MESSAGE.set_token('DAY', 'FRIDAY');
1029: FND_MSG_PUB.add;
1030: RAISE FND_API.g_exc_error;
1031: ELSE ---Call Function To validate Friday Holiday Table

Line 1028: FND_MESSAGE.set_token('DAY', 'FRIDAY');

1024: --error
1025: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1026: FND_MESSAGE.set_token('API_NAME', l_api_name);
1027: FND_MESSAGE.set_token('VALUE', 'Holiday');
1028: FND_MESSAGE.set_token('DAY', 'FRIDAY');
1029: FND_MSG_PUB.add;
1030: RAISE FND_API.g_exc_error;
1031: ELSE ---Call Function To validate Friday Holiday Table
1032: VALIDATE_COMPLETE_CHECK

Line 1044: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

1040:
1041: -- Validate Saturday Holiday Table for Completeness
1042: IF lv_tm_sat_hol_tbl_type.count = 0 THEN
1043: --error
1044: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1045: FND_MESSAGE.set_token('API_NAME', l_api_name);
1046: FND_MESSAGE.set_token('VALUE', 'Holiday');
1047: FND_MESSAGE.set_token('DAY', 'SATURDAY');
1048: FND_MSG_PUB.add;

Line 1045: FND_MESSAGE.set_token('API_NAME', l_api_name);

1041: -- Validate Saturday Holiday Table for Completeness
1042: IF lv_tm_sat_hol_tbl_type.count = 0 THEN
1043: --error
1044: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1045: FND_MESSAGE.set_token('API_NAME', l_api_name);
1046: FND_MESSAGE.set_token('VALUE', 'Holiday');
1047: FND_MESSAGE.set_token('DAY', 'SATURDAY');
1048: FND_MSG_PUB.add;
1049: RAISE FND_API.g_exc_error;

Line 1046: FND_MESSAGE.set_token('VALUE', 'Holiday');

1042: IF lv_tm_sat_hol_tbl_type.count = 0 THEN
1043: --error
1044: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1045: FND_MESSAGE.set_token('API_NAME', l_api_name);
1046: FND_MESSAGE.set_token('VALUE', 'Holiday');
1047: FND_MESSAGE.set_token('DAY', 'SATURDAY');
1048: FND_MSG_PUB.add;
1049: RAISE FND_API.g_exc_error;
1050: ELSE ---Call Function To validate Saturday Holiday Table

Line 1047: FND_MESSAGE.set_token('DAY', 'SATURDAY');

1043: --error
1044: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1045: FND_MESSAGE.set_token('API_NAME', l_api_name);
1046: FND_MESSAGE.set_token('VALUE', 'Holiday');
1047: FND_MESSAGE.set_token('DAY', 'SATURDAY');
1048: FND_MSG_PUB.add;
1049: RAISE FND_API.g_exc_error;
1050: ELSE ---Call Function To validate Saturday Holiday Table
1051: VALIDATE_COMPLETE_CHECK

Line 1064: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');

1060:
1061: -- Validate Sunday Holiday Table for Completeness
1062: IF lv_tm_sun_hol_tbl_type.count = 0 THEN
1063: --error
1064: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1065: FND_MESSAGE.set_token('API_NAME', l_api_name);
1066: FND_MESSAGE.set_token('VALUE', 'Holiday');
1067: FND_MESSAGE.set_token('DAY', 'SUNDAY');
1068: FND_MSG_PUB.add;

Line 1065: FND_MESSAGE.set_token('API_NAME', l_api_name);

1061: -- Validate Sunday Holiday Table for Completeness
1062: IF lv_tm_sun_hol_tbl_type.count = 0 THEN
1063: --error
1064: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1065: FND_MESSAGE.set_token('API_NAME', l_api_name);
1066: FND_MESSAGE.set_token('VALUE', 'Holiday');
1067: FND_MESSAGE.set_token('DAY', 'SUNDAY');
1068: FND_MSG_PUB.add;
1069: RAISE FND_API.g_exc_error;

Line 1066: FND_MESSAGE.set_token('VALUE', 'Holiday');

1062: IF lv_tm_sun_hol_tbl_type.count = 0 THEN
1063: --error
1064: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1065: FND_MESSAGE.set_token('API_NAME', l_api_name);
1066: FND_MESSAGE.set_token('VALUE', 'Holiday');
1067: FND_MESSAGE.set_token('DAY', 'SUNDAY');
1068: FND_MSG_PUB.add;
1069: RAISE FND_API.g_exc_error;
1070: ELSE ---Call Function To validate Friday Holiday Table

Line 1067: FND_MESSAGE.set_token('DAY', 'SUNDAY');

1063: --error
1064: FND_MESSAGE.set_name('CS','CS_CHG_API_DAY_NOT_SETUP');
1065: FND_MESSAGE.set_token('API_NAME', l_api_name);
1066: FND_MESSAGE.set_token('VALUE', 'Holiday');
1067: FND_MESSAGE.set_token('DAY', 'SUNDAY');
1068: FND_MSG_PUB.add;
1069: RAISE FND_API.g_exc_error;
1070: ELSE ---Call Function To validate Friday Holiday Table
1071: VALIDATE_COMPLETE_CHECK

Line 1184: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');

1180: FETCH tm_validate_csr into l_tm_sched_complete_flag;
1181: IF tm_validate_csr%NOTFOUND THEN
1182: CLOSE tm_validate_csr;
1183:
1184: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1185: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1186: FND_MESSAGE.Set_Token('VALUE', p_business_process_id);
1187: FND_MESSAGE.Set_Token('PARAMETER', 'p_business_process_id');
1188: FND_MSG_PUB.Add;

Line 1185: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1181: IF tm_validate_csr%NOTFOUND THEN
1182: CLOSE tm_validate_csr;
1183:
1184: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1185: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1186: FND_MESSAGE.Set_Token('VALUE', p_business_process_id);
1187: FND_MESSAGE.Set_Token('PARAMETER', 'p_business_process_id');
1188: FND_MSG_PUB.Add;
1189: RAISE FND_API.g_exc_error;

Line 1186: FND_MESSAGE.Set_Token('VALUE', p_business_process_id);

1182: CLOSE tm_validate_csr;
1183:
1184: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1185: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1186: FND_MESSAGE.Set_Token('VALUE', p_business_process_id);
1187: FND_MESSAGE.Set_Token('PARAMETER', 'p_business_process_id');
1188: FND_MSG_PUB.Add;
1189: RAISE FND_API.g_exc_error;
1190:

Line 1187: FND_MESSAGE.Set_Token('PARAMETER', 'p_business_process_id');

1183:
1184: FND_MESSAGE.Set_Name('CS', 'CS_API_ALL_INVALID_ARGUMENT');
1185: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1186: FND_MESSAGE.Set_Token('VALUE', p_business_process_id);
1187: FND_MESSAGE.Set_Token('PARAMETER', 'p_business_process_id');
1188: FND_MSG_PUB.Add;
1189: RAISE FND_API.g_exc_error;
1190:
1191: END IF;

Line 1198: FND_MESSAGE.Set_Name('CS', 'CS_CHG_API_TM_SCHED_INCOMPLETE');

1194: -- If the Tm_sched_complete_flag is 'N' then return error;
1195:
1196: IF l_tm_sched_complete_flag <> 'Y' THEN
1197: --raise error
1198: FND_MESSAGE.Set_Name('CS', 'CS_CHG_API_TM_SCHED_INCOMPLETE');
1199: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1200: FND_MESSAGE.Set_Token('BUSINESS_PROC_ID', p_business_process_id);
1201: FND_MSG_PUB.Add;
1202: RAISE FND_API.g_exc_error;

Line 1199: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1195:
1196: IF l_tm_sched_complete_flag <> 'Y' THEN
1197: --raise error
1198: FND_MESSAGE.Set_Name('CS', 'CS_CHG_API_TM_SCHED_INCOMPLETE');
1199: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1200: FND_MESSAGE.Set_Token('BUSINESS_PROC_ID', p_business_process_id);
1201: FND_MSG_PUB.Add;
1202: RAISE FND_API.g_exc_error;
1203: END IF;

Line 1200: FND_MESSAGE.Set_Token('BUSINESS_PROC_ID', p_business_process_id);

1196: IF l_tm_sched_complete_flag <> 'Y' THEN
1197: --raise error
1198: FND_MESSAGE.Set_Name('CS', 'CS_CHG_API_TM_SCHED_INCOMPLETE');
1199: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1200: FND_MESSAGE.Set_Token('BUSINESS_PROC_ID', p_business_process_id);
1201: FND_MSG_PUB.Add;
1202: RAISE FND_API.g_exc_error;
1203: END IF;
1204:

Line 1356: fnd_message.set_name('CS','CS_CHG_API_GAP_IN_SCHEDULE');

1352: lv_sum := lv_sum + (P_TM_TBL_TYPE(lv_index).end_time - P_TM_TBL_TYPE(lv_index).start_time);
1353: ELSE
1354: IF P_TM_TBL_TYPE(lv_index).start_time <> P_TM_TBL_TYPE(lv_index - 1).end_time THEN
1355: --error
1356: fnd_message.set_name('CS','CS_CHG_API_GAP_IN_SCHEDULE');
1357: fnd_message.set_token('API_NAME', l_api_name);
1358: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1359: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1360: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));

Line 1357: fnd_message.set_token('API_NAME', l_api_name);

1353: ELSE
1354: IF P_TM_TBL_TYPE(lv_index).start_time <> P_TM_TBL_TYPE(lv_index - 1).end_time THEN
1355: --error
1356: fnd_message.set_name('CS','CS_CHG_API_GAP_IN_SCHEDULE');
1357: fnd_message.set_token('API_NAME', l_api_name);
1358: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1359: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1360: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1361: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);

Line 1358: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);

1354: IF P_TM_TBL_TYPE(lv_index).start_time <> P_TM_TBL_TYPE(lv_index - 1).end_time THEN
1355: --error
1356: fnd_message.set_name('CS','CS_CHG_API_GAP_IN_SCHEDULE');
1357: fnd_message.set_token('API_NAME', l_api_name);
1358: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1359: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1360: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1361: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);
1362: fnd_msg_pub.add;

Line 1359: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));

1355: --error
1356: fnd_message.set_name('CS','CS_CHG_API_GAP_IN_SCHEDULE');
1357: fnd_message.set_token('API_NAME', l_api_name);
1358: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1359: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1360: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1361: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);
1362: fnd_msg_pub.add;
1363: RAISE fnd_api.g_exc_error;

Line 1360: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));

1356: fnd_message.set_name('CS','CS_CHG_API_GAP_IN_SCHEDULE');
1357: fnd_message.set_token('API_NAME', l_api_name);
1358: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1359: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1360: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1361: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);
1362: fnd_msg_pub.add;
1363: RAISE fnd_api.g_exc_error;
1364: ELSE

Line 1361: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);

1357: fnd_message.set_token('API_NAME', l_api_name);
1358: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1359: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1360: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1361: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);
1362: fnd_msg_pub.add;
1363: RAISE fnd_api.g_exc_error;
1364: ELSE
1365: lv_sum := lv_sum + (P_TM_TBL_TYPE(lv_index).end_time - P_TM_TBL_TYPE(lv_index).start_time);

Line 1377: fnd_message.set_name('CS','CS_CHG_API_COMPLETE_CHECK_FAIL');

1373:
1374: IF lv_sum < .9993 THEN
1375: --error
1376: --RAISE e_comp_chk_failure;
1377: fnd_message.set_name('CS','CS_CHG_API_COMPLETE_CHECK_FAIL');
1378: fnd_message.set_token('API_NAME', l_api_name);
1379: fnd_msg_pub.add;
1380: RAISE fnd_api.g_exc_error;
1381:

Line 1378: fnd_message.set_token('API_NAME', l_api_name);

1374: IF lv_sum < .9993 THEN
1375: --error
1376: --RAISE e_comp_chk_failure;
1377: fnd_message.set_name('CS','CS_CHG_API_COMPLETE_CHECK_FAIL');
1378: fnd_message.set_token('API_NAME', l_api_name);
1379: fnd_msg_pub.add;
1380: RAISE fnd_api.g_exc_error;
1381:
1382: END IF;

Line 1422: fnd_message.set_name('CS','CS_CHG_API_OVERLAP_FOUND');

1418: LOOP
1419: IF lv_index <> P_TM_TBL_TYPE.FIRST THEN
1420: IF P_TM_TBL_TYPE(lv_index).start_time < P_TM_TBL_TYPE(lv_index - 1).end_time THEN
1421: --error
1422: fnd_message.set_name('CS','CS_CHG_API_OVERLAP_FOUND');
1423: fnd_message.set_token('API_NAME', l_api_name);
1424: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1425: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1426: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));

Line 1423: fnd_message.set_token('API_NAME', l_api_name);

1419: IF lv_index <> P_TM_TBL_TYPE.FIRST THEN
1420: IF P_TM_TBL_TYPE(lv_index).start_time < P_TM_TBL_TYPE(lv_index - 1).end_time THEN
1421: --error
1422: fnd_message.set_name('CS','CS_CHG_API_OVERLAP_FOUND');
1423: fnd_message.set_token('API_NAME', l_api_name);
1424: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1425: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1426: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1427: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);

Line 1424: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);

1420: IF P_TM_TBL_TYPE(lv_index).start_time < P_TM_TBL_TYPE(lv_index - 1).end_time THEN
1421: --error
1422: fnd_message.set_name('CS','CS_CHG_API_OVERLAP_FOUND');
1423: fnd_message.set_token('API_NAME', l_api_name);
1424: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1425: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1426: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1427: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);
1428: fnd_msg_pub.add;

Line 1425: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));

1421: --error
1422: fnd_message.set_name('CS','CS_CHG_API_OVERLAP_FOUND');
1423: fnd_message.set_token('API_NAME', l_api_name);
1424: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1425: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1426: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1427: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);
1428: fnd_msg_pub.add;
1429: RAISE fnd_api.g_exc_error;

Line 1426: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));

1422: fnd_message.set_name('CS','CS_CHG_API_OVERLAP_FOUND');
1423: fnd_message.set_token('API_NAME', l_api_name);
1424: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1425: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1426: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1427: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);
1428: fnd_msg_pub.add;
1429: RAISE fnd_api.g_exc_error;
1430: ELSE

Line 1427: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);

1423: fnd_message.set_token('API_NAME', l_api_name);
1424: fnd_message.set_token('DAY', P_TM_TBL_TYPE(lv_index).day);
1425: fnd_message.set_token('START_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index).start_time,'HH24:MI'));
1426: fnd_message.set_token('PREVIOUS_END_TIME', TO_CHAR(P_TM_TBL_TYPE(lv_index - 1).end_time, 'HH24:MI'));
1427: --fnd_message.set_token('HOLIDAY_FLAG', P_TM_TBL_TYPE(lv_index).holiday_flag);
1428: fnd_msg_pub.add;
1429: RAISE fnd_api.g_exc_error;
1430: ELSE
1431: null;