eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_TM_LABOR_SCHEDULE_PVT dependencies on FND_API

Line 39: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

35: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36: X_MSG_COUNT OUT NOCOPY NUMBER,
37: X_MSG_DATA OUT NOCOPY VARCHAR2,
38: P_API_VERSION IN NUMBER,
39: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
40: ) IS
41:
42: lv_return_status VARCHAR2(1);
43: lv_return_message VARCHAR2(2000);

Line 88: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

84:
85: BEGIN
86:
87: -- Standard call to check for call compatibility
88: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
89: G_PKG_NAME) THEN
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92:

Line 90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

86:
87: -- Standard call to check for call compatibility
88: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
89: G_PKG_NAME) THEN
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92:
93:
94: /**-- Initialize the message list if p_init_msg_list is set to TRUE

Line 95: IF FND_API.To_Boolean(p_init_msg_list) THEN

91: END IF;
92:
93:
94: /**-- Initialize the message list if p_init_msg_list is set to TRUE
95: IF FND_API.To_Boolean(p_init_msg_list) THEN
96: FND_MSG_PUB.Initialize;
97: END IF;**/
98:
99:

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

97: END IF;**/
98:
99:
100: -- Initialize API return status to success
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102:
103: -- Begin the validate overlap functionality check
104: -- The table passed in this api will be sorted by holiday flag and start time
105:

Line 287: RAISE FND_API.g_exc_error;

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
290: (p_tm_tbl_type => lv_tm_mon_reg_tbl_type,
291: x_return_status => lv_return_status

Line 293: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

289: VALIDATE_OVERLAP
290: (p_tm_tbl_type => lv_tm_mon_reg_tbl_type,
291: x_return_status => lv_return_status
292: );
293: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
294: RAISE fnd_api.g_exc_error;
295: END IF;
296: END IF;
297:

Line 294: RAISE fnd_api.g_exc_error;

290: (p_tm_tbl_type => lv_tm_mon_reg_tbl_type,
291: x_return_status => lv_return_status
292: );
293: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
294: RAISE fnd_api.g_exc_error;
295: END IF;
296: END IF;
297:
298: -- Validate Tuesday Regular Table for Overlap

Line 306: RAISE FND_API.g_exc_error;

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
309: (p_tm_tbl_type => lv_tm_tue_reg_tbl_type,
310: x_return_status => lv_return_status

Line 312: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

308: VALIDATE_OVERLAP
309: (p_tm_tbl_type => lv_tm_tue_reg_tbl_type,
310: x_return_status => lv_return_status
311: );
312: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
313: RAISE fnd_api.g_exc_error;
314: END IF;
315: END IF;
316:

Line 313: RAISE fnd_api.g_exc_error;

309: (p_tm_tbl_type => lv_tm_tue_reg_tbl_type,
310: x_return_status => lv_return_status
311: );
312: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
313: RAISE fnd_api.g_exc_error;
314: END IF;
315: END IF;
316:
317: -- Validate Wednesday Regular Table for Overlap

Line 325: RAISE FND_API.g_exc_error;

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
328: (p_tm_tbl_type => lv_tm_wed_reg_tbl_type,
329: x_return_status => lv_return_status

Line 331: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

327: VALIDATE_OVERLAP
328: (p_tm_tbl_type => lv_tm_wed_reg_tbl_type,
329: x_return_status => lv_return_status
330: );
331: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
332: RAISE fnd_api.g_exc_error;
333: END IF;
334: END IF;
335:

Line 332: RAISE fnd_api.g_exc_error;

328: (p_tm_tbl_type => lv_tm_wed_reg_tbl_type,
329: x_return_status => lv_return_status
330: );
331: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
332: RAISE fnd_api.g_exc_error;
333: END IF;
334: END IF;
335:
336: -- Validate Thursday Regular Table for Overlap

Line 344: RAISE FND_API.g_exc_error;

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
347: (p_tm_tbl_type => lv_tm_thurs_reg_tbl_type,
348: x_return_status => lv_return_status

Line 350: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

346: VALIDATE_OVERLAP
347: (p_tm_tbl_type => lv_tm_thurs_reg_tbl_type,
348: x_return_status => lv_return_status
349: );
350: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
351: RAISE fnd_api.g_exc_error;
352: END IF;
353: END IF;
354:

Line 351: RAISE fnd_api.g_exc_error;

347: (p_tm_tbl_type => lv_tm_thurs_reg_tbl_type,
348: x_return_status => lv_return_status
349: );
350: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
351: RAISE fnd_api.g_exc_error;
352: END IF;
353: END IF;
354:
355: -- Validate Friday Regular Table for Overlap

Line 363: RAISE FND_API.g_exc_error;

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
366: (p_tm_tbl_type => lv_tm_fri_reg_tbl_type,
367: x_return_status => lv_return_status

Line 369: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

365: VALIDATE_OVERLAP
366: (p_tm_tbl_type => lv_tm_fri_reg_tbl_type,
367: x_return_status => lv_return_status
368: );
369: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
370: RAISE fnd_api.g_exc_error;
371: END IF;
372: END IF;
373:

Line 370: RAISE fnd_api.g_exc_error;

366: (p_tm_tbl_type => lv_tm_fri_reg_tbl_type,
367: x_return_status => lv_return_status
368: );
369: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
370: RAISE fnd_api.g_exc_error;
371: END IF;
372: END IF;
373:
374: -- Validate Saturday Regular Table for Overlap

Line 382: RAISE FND_API.g_exc_error;

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
385: (p_tm_tbl_type => lv_tm_sat_reg_tbl_type,
386: x_return_status => lv_return_status

Line 388: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

384: VALIDATE_OVERLAP
385: (p_tm_tbl_type => lv_tm_sat_reg_tbl_type,
386: x_return_status => lv_return_status
387: );
388: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
389: RAISE fnd_api.g_exc_error;
390: END IF;
391: END IF;
392:

Line 389: RAISE fnd_api.g_exc_error;

385: (p_tm_tbl_type => lv_tm_sat_reg_tbl_type,
386: x_return_status => lv_return_status
387: );
388: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
389: RAISE fnd_api.g_exc_error;
390: END IF;
391: END IF;
392:
393: -- Validate Sunday Regular Table for Overlap

Line 401: RAISE FND_API.g_exc_error;

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
404: (p_tm_tbl_type => lv_tm_sun_reg_tbl_type,
405: x_return_status => lv_return_status

Line 407: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

403: VALIDATE_OVERLAP
404: (p_tm_tbl_type => lv_tm_sun_reg_tbl_type,
405: x_return_status => lv_return_status
406: );
407: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
408: RAISE fnd_api.g_exc_error;
409: END IF;
410: END IF;
411:

Line 408: RAISE fnd_api.g_exc_error;

404: (p_tm_tbl_type => lv_tm_sun_reg_tbl_type,
405: x_return_status => lv_return_status
406: );
407: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
408: RAISE fnd_api.g_exc_error;
409: END IF;
410: END IF;
411:
412: -- Validate Monday Holiday Table for Overlap

Line 421: RAISE FND_API.g_exc_error;

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
424: (p_tm_tbl_type => lv_tm_mon_hol_tbl_type,
425: x_return_status => lv_return_status

Line 427: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

423: VALIDATE_OVERLAP
424: (p_tm_tbl_type => lv_tm_mon_hol_tbl_type,
425: x_return_status => lv_return_status
426: );
427: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
428: RAISE fnd_api.g_exc_error;
429: END IF;
430: END IF;
431:

Line 428: RAISE fnd_api.g_exc_error;

424: (p_tm_tbl_type => lv_tm_mon_hol_tbl_type,
425: x_return_status => lv_return_status
426: );
427: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
428: RAISE fnd_api.g_exc_error;
429: END IF;
430: END IF;
431:
432: -- Validate Tuesday Holiday Table for Overlap

Line 440: RAISE FND_API.g_exc_error;

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
443: (p_tm_tbl_type => lv_tm_tue_hol_tbl_type,
444: x_return_status => lv_return_status

Line 446: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

442: VALIDATE_OVERLAP
443: (p_tm_tbl_type => lv_tm_tue_hol_tbl_type,
444: x_return_status => lv_return_status
445: );
446: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
447: RAISE fnd_api.g_exc_error;
448: END IF;
449: END IF;
450:

Line 447: RAISE fnd_api.g_exc_error;

443: (p_tm_tbl_type => lv_tm_tue_hol_tbl_type,
444: x_return_status => lv_return_status
445: );
446: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
447: RAISE fnd_api.g_exc_error;
448: END IF;
449: END IF;
450:
451: -- Validate Wednesday Holiday Table for Overlap

Line 459: RAISE FND_API.g_exc_error;

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
462: (p_tm_tbl_type => lv_tm_wed_hol_tbl_type,
463: x_return_status => lv_return_status

Line 465: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

461: VALIDATE_OVERLAP
462: (p_tm_tbl_type => lv_tm_wed_hol_tbl_type,
463: x_return_status => lv_return_status
464: );
465: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
466: RAISE fnd_api.g_exc_error;
467: END IF;
468: END IF;
469:

Line 466: RAISE fnd_api.g_exc_error;

462: (p_tm_tbl_type => lv_tm_wed_hol_tbl_type,
463: x_return_status => lv_return_status
464: );
465: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
466: RAISE fnd_api.g_exc_error;
467: END IF;
468: END IF;
469:
470: -- Validate Thursday Holiday Table for Overlap

Line 478: RAISE FND_API.g_exc_error;

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
481: (p_tm_tbl_type => lv_tm_thurs_hol_tbl_type,
482: x_return_status => lv_return_status

Line 484: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

480: VALIDATE_OVERLAP
481: (p_tm_tbl_type => lv_tm_thurs_hol_tbl_type,
482: x_return_status => lv_return_status
483: );
484: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
485: RAISE fnd_api.g_exc_error;
486: END IF;
487: END IF;
488:

Line 485: RAISE fnd_api.g_exc_error;

481: (p_tm_tbl_type => lv_tm_thurs_hol_tbl_type,
482: x_return_status => lv_return_status
483: );
484: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
485: RAISE fnd_api.g_exc_error;
486: END IF;
487: END IF;
488:
489: -- Validate Friday Holiday Table for Overlap

Line 497: RAISE FND_API.g_exc_error;

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
500: (p_tm_tbl_type => lv_tm_fri_hol_tbl_type,
501: x_return_status => lv_return_status

Line 503: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

499: VALIDATE_OVERLAP
500: (p_tm_tbl_type => lv_tm_fri_hol_tbl_type,
501: x_return_status => lv_return_status
502: );
503: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
504: RAISE fnd_api.g_exc_error;
505: END IF;
506: END IF;
507:

Line 504: RAISE fnd_api.g_exc_error;

500: (p_tm_tbl_type => lv_tm_fri_hol_tbl_type,
501: x_return_status => lv_return_status
502: );
503: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
504: RAISE fnd_api.g_exc_error;
505: END IF;
506: END IF;
507:
508: -- Validate Saturday Holiday Table for Overlap

Line 516: RAISE FND_API.g_exc_error;

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
519: (p_tm_tbl_type => lv_tm_sat_hol_tbl_type,
520: x_return_status => lv_return_status

Line 522: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

518: VALIDATE_OVERLAP
519: (p_tm_tbl_type => lv_tm_sat_hol_tbl_type,
520: x_return_status => lv_return_status
521: );
522: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
523: RAISE fnd_api.g_exc_error;
524: END IF;
525: END IF;
526:

Line 523: RAISE fnd_api.g_exc_error;

519: (p_tm_tbl_type => lv_tm_sat_hol_tbl_type,
520: x_return_status => lv_return_status
521: );
522: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
523: RAISE fnd_api.g_exc_error;
524: END IF;
525: END IF;
526:
527: -- Validate Sunday Holiday Table for Overlap

Line 535: RAISE FND_API.g_exc_error;

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
538: (p_tm_tbl_type => lv_tm_sun_hol_tbl_type,
539: x_return_status => lv_return_status

Line 541: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

537: VALIDATE_OVERLAP
538: (p_tm_tbl_type => lv_tm_sun_hol_tbl_type,
539: x_return_status => lv_return_status
540: );
541: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
542: RAISE fnd_api.g_exc_error;
543: END IF;
544: END IF;
545:

Line 542: RAISE fnd_api.g_exc_error;

538: (p_tm_tbl_type => lv_tm_sun_hol_tbl_type,
539: x_return_status => lv_return_status
540: );
541: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
542: RAISE fnd_api.g_exc_error;
543: END IF;
544: END IF;
545:
546: */

Line 550: WHEN fnd_api.g_exc_error THEN

546: */
547:
548: EXCEPTION
549:
550: WHEN fnd_api.g_exc_error THEN
551: x_return_status := fnd_api.g_ret_sts_error;
552: x_msg_data := fnd_msg_pub.get;
553:
554:

Line 551: x_return_status := fnd_api.g_ret_sts_error;

547:
548: EXCEPTION
549:
550: WHEN fnd_api.g_exc_error THEN
551: x_return_status := fnd_api.g_ret_sts_error;
552: x_msg_data := fnd_msg_pub.get;
553:
554:
555: WHEN OTHERS THEN

Line 556: x_return_status := fnd_api.g_ret_sts_error;

552: x_msg_data := fnd_msg_pub.get;
553:
554:
555: WHEN OTHERS THEN
556: x_return_status := fnd_api.g_ret_sts_error;
557:
558:
559:
560: END VALIDATE_SCHEDULE_OVERLAP; -- End of Procedure Validate_Schedule_Overlap

Line 573: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

569: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
570: X_MSG_COUNT OUT NOCOPY NUMBER,
571: X_MSG_DATA OUT NOCOPY VARCHAR2,
572: P_API_VERSION IN NUMBER,
573: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
574: ) IS
575:
576: -- assuming the the record will be sorted by holiday_flag and start_time
577:

Line 624: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

620:
621: BEGIN
622:
623: -- Standard call to check for call compatibility
624: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
625: G_PKG_NAME) THEN
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628:

Line 626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

622:
623: -- Standard call to check for call compatibility
624: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
625: G_PKG_NAME) THEN
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628:
629: /* -- Initialize message list if p_init_msg_list is set to TRUE
630: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 630: IF FND_API.To_Boolean(p_init_msg_list) THEN

626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628:
629: /* -- Initialize message list if p_init_msg_list is set to TRUE
630: IF FND_API.To_Boolean(p_init_msg_list) THEN
631: FND_MSG_PUB.Initialize;
632: END IF;
633: */
634:

Line 636: x_return_status := FND_API.G_RET_STS_SUCCESS;

632: END IF;
633: */
634:
635: -- Initialize API return status to success
636: x_return_status := FND_API.G_RET_STS_SUCCESS;
637:
638: FOR lv_temp IN 1..P_LABOR_SCHEDULE_TBL.COUNT LOOP
639: IF ((p_labor_schedule_tbl(lv_temp).monday_flag = 'Y') AND
640: (p_labor_schedule_tbl(lv_temp).holiday_flag = 'N')) THEN

Line 819: RAISE FND_API.g_exc_error;

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
822: (p_tm_tbl_type => lv_tm_mon_reg_tbl_type,
823: x_return_status => lv_return_status

Line 825: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

821: VALIDATE_COMPLETE_CHECK
822: (p_tm_tbl_type => lv_tm_mon_reg_tbl_type,
823: x_return_status => lv_return_status
824: );
825: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
826: RAISE fnd_api.g_exc_error;
827: END IF;
828: END IF;
829:

Line 826: RAISE fnd_api.g_exc_error;

822: (p_tm_tbl_type => lv_tm_mon_reg_tbl_type,
823: x_return_status => lv_return_status
824: );
825: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
826: RAISE fnd_api.g_exc_error;
827: END IF;
828: END IF;
829:
830: -- Validate Tuesday Regular Table for Completeness

Line 838: RAISE FND_API.g_exc_error;

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
841: (p_tm_tbl_type => lv_tm_tue_reg_tbl_type,
842: x_return_status => lv_return_status

Line 844: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

840: VALIDATE_COMPLETE_CHECK
841: (p_tm_tbl_type => lv_tm_tue_reg_tbl_type,
842: x_return_status => lv_return_status
843: );
844: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
845: RAISE fnd_api.g_exc_error;
846: END IF;
847: END IF;
848:

Line 845: RAISE fnd_api.g_exc_error;

841: (p_tm_tbl_type => lv_tm_tue_reg_tbl_type,
842: x_return_status => lv_return_status
843: );
844: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
845: RAISE fnd_api.g_exc_error;
846: END IF;
847: END IF;
848:
849: -- Validate Wednesday Regular Table for Completeness

Line 857: RAISE FND_API.g_exc_error;

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
860: VALIDATE_COMPLETE_CHECK
861: (p_tm_tbl_type => lv_tm_wed_reg_tbl_type,

Line 864: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

860: VALIDATE_COMPLETE_CHECK
861: (p_tm_tbl_type => lv_tm_wed_reg_tbl_type,
862: x_return_status => lv_return_status
863: );
864: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
865: RAISE fnd_api.g_exc_error;
866: END IF;
867: END IF;
868:

Line 865: RAISE fnd_api.g_exc_error;

861: (p_tm_tbl_type => lv_tm_wed_reg_tbl_type,
862: x_return_status => lv_return_status
863: );
864: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
865: RAISE fnd_api.g_exc_error;
866: END IF;
867: END IF;
868:
869: -- Validate Thursday Regular Table for Completeness

Line 877: RAISE FND_API.g_exc_error;

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
880: (p_tm_tbl_type => lv_tm_thurs_reg_tbl_type,
881: x_return_status => lv_return_status

Line 883: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

879: VALIDATE_COMPLETE_CHECK
880: (p_tm_tbl_type => lv_tm_thurs_reg_tbl_type,
881: x_return_status => lv_return_status
882: );
883: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
884: RAISE fnd_api.g_exc_error;
885: END IF;
886: END IF;
887:

Line 884: RAISE fnd_api.g_exc_error;

880: (p_tm_tbl_type => lv_tm_thurs_reg_tbl_type,
881: x_return_status => lv_return_status
882: );
883: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
884: RAISE fnd_api.g_exc_error;
885: END IF;
886: END IF;
887:
888: -- Validate Friday Regular Table for Completeness

Line 896: RAISE FND_API.g_exc_error;

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
899: (p_tm_tbl_type => lv_tm_fri_reg_tbl_type,
900: x_return_status => lv_return_status

Line 902: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

898: VALIDATE_COMPLETE_CHECK
899: (p_tm_tbl_type => lv_tm_fri_reg_tbl_type,
900: x_return_status => lv_return_status
901: );
902: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
903: RAISE fnd_api.g_exc_error;
904: END IF;
905: END IF;
906:

Line 903: RAISE fnd_api.g_exc_error;

899: (p_tm_tbl_type => lv_tm_fri_reg_tbl_type,
900: x_return_status => lv_return_status
901: );
902: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
903: RAISE fnd_api.g_exc_error;
904: END IF;
905: END IF;
906:
907: -- Validate Saturday Regular Table for Completeness

Line 915: RAISE FND_API.g_exc_error;

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
918: (p_tm_tbl_type => lv_tm_sat_reg_tbl_type,
919: x_return_status => lv_return_status

Line 921: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

917: VALIDATE_COMPLETE_CHECK
918: (p_tm_tbl_type => lv_tm_sat_reg_tbl_type,
919: x_return_status => lv_return_status
920: );
921: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
922: RAISE fnd_api.g_exc_error;
923: END IF;
924: END IF;
925:

Line 922: RAISE fnd_api.g_exc_error;

918: (p_tm_tbl_type => lv_tm_sat_reg_tbl_type,
919: x_return_status => lv_return_status
920: );
921: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
922: RAISE fnd_api.g_exc_error;
923: END IF;
924: END IF;
925:
926: -- Validate Sunday Regular Table for Completeness

Line 934: RAISE FND_API.g_exc_error;

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
937: (p_tm_tbl_type => lv_tm_sun_reg_tbl_type,
938: x_return_status => lv_return_status

Line 940: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

936: VALIDATE_COMPLETE_CHECK
937: (p_tm_tbl_type => lv_tm_sun_reg_tbl_type,
938: x_return_status => lv_return_status
939: );
940: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
941: RAISE fnd_api.g_exc_error;
942: END IF;
943: END IF;
944:

Line 941: RAISE fnd_api.g_exc_error;

937: (p_tm_tbl_type => lv_tm_sun_reg_tbl_type,
938: x_return_status => lv_return_status
939: );
940: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
941: RAISE fnd_api.g_exc_error;
942: END IF;
943: END IF;
944:
945: -- Validate Monday Holiday Table for Completeness

Line 954: RAISE FND_API.g_exc_error;

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
957: (p_tm_tbl_type => lv_tm_mon_hol_tbl_type,
958: x_return_status => lv_return_status

Line 960: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

956: VALIDATE_COMPLETE_CHECK
957: (p_tm_tbl_type => lv_tm_mon_hol_tbl_type,
958: x_return_status => lv_return_status
959: );
960: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
961: RAISE fnd_api.g_exc_error;
962: END IF;
963: END IF;
964:

Line 961: RAISE fnd_api.g_exc_error;

957: (p_tm_tbl_type => lv_tm_mon_hol_tbl_type,
958: x_return_status => lv_return_status
959: );
960: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
961: RAISE fnd_api.g_exc_error;
962: END IF;
963: END IF;
964:
965: -- Validate Tuesday Holiday Table for Completeness

Line 973: RAISE FND_API.g_exc_error;

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
976: (p_tm_tbl_type => lv_tm_tue_hol_tbl_type,
977: x_return_status => lv_return_status

Line 979: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

975: VALIDATE_COMPLETE_CHECK
976: (p_tm_tbl_type => lv_tm_tue_hol_tbl_type,
977: x_return_status => lv_return_status
978: );
979: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
980: RAISE fnd_api.g_exc_error;
981: END IF;
982: END IF;
983:

Line 980: RAISE fnd_api.g_exc_error;

976: (p_tm_tbl_type => lv_tm_tue_hol_tbl_type,
977: x_return_status => lv_return_status
978: );
979: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
980: RAISE fnd_api.g_exc_error;
981: END IF;
982: END IF;
983:
984: -- Validate Wednesday Holiday Table for Completeness

Line 992: RAISE FND_API.g_exc_error;

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
995: (p_tm_tbl_type => lv_tm_wed_hol_tbl_type,
996: x_return_status => lv_return_status

Line 998: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

994: VALIDATE_COMPLETE_CHECK
995: (p_tm_tbl_type => lv_tm_wed_hol_tbl_type,
996: x_return_status => lv_return_status
997: );
998: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
999: RAISE fnd_api.g_exc_error;
1000: END IF;
1001: END IF;
1002:

Line 999: RAISE fnd_api.g_exc_error;

995: (p_tm_tbl_type => lv_tm_wed_hol_tbl_type,
996: x_return_status => lv_return_status
997: );
998: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
999: RAISE fnd_api.g_exc_error;
1000: END IF;
1001: END IF;
1002:
1003: -- Validate Thursday Holiday Table for Completeness

Line 1011: RAISE FND_API.g_exc_error;

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
1014: (p_tm_tbl_type => lv_tm_thurs_hol_tbl_type,
1015: x_return_status => lv_return_status

Line 1017: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

1013: VALIDATE_COMPLETE_CHECK
1014: (p_tm_tbl_type => lv_tm_thurs_hol_tbl_type,
1015: x_return_status => lv_return_status
1016: );
1017: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
1018: RAISE fnd_api.g_exc_error;
1019: END IF;
1020: END IF;
1021:

Line 1018: RAISE fnd_api.g_exc_error;

1014: (p_tm_tbl_type => lv_tm_thurs_hol_tbl_type,
1015: x_return_status => lv_return_status
1016: );
1017: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
1018: RAISE fnd_api.g_exc_error;
1019: END IF;
1020: END IF;
1021:
1022: -- Validate Friday Holiday Table for Completeness

Line 1030: RAISE FND_API.g_exc_error;

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
1033: (p_tm_tbl_type => lv_tm_fri_hol_tbl_type,
1034: x_return_status => lv_return_status

Line 1036: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

1032: VALIDATE_COMPLETE_CHECK
1033: (p_tm_tbl_type => lv_tm_fri_hol_tbl_type,
1034: x_return_status => lv_return_status
1035: );
1036: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
1037: RAISE fnd_api.g_exc_error;
1038: END IF;
1039: END IF;
1040:

Line 1037: RAISE fnd_api.g_exc_error;

1033: (p_tm_tbl_type => lv_tm_fri_hol_tbl_type,
1034: x_return_status => lv_return_status
1035: );
1036: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
1037: RAISE fnd_api.g_exc_error;
1038: END IF;
1039: END IF;
1040:
1041: -- Validate Saturday Holiday Table for Completeness

Line 1049: RAISE FND_API.g_exc_error;

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
1052: (p_tm_tbl_type => lv_tm_sat_hol_tbl_type,
1053: x_return_status => lv_return_status

Line 1056: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

1052: (p_tm_tbl_type => lv_tm_sat_hol_tbl_type,
1053: x_return_status => lv_return_status
1054: );
1055:
1056: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
1057: RAISE fnd_api.g_exc_error;
1058: END IF;
1059: END IF;
1060:

Line 1057: RAISE fnd_api.g_exc_error;

1053: x_return_status => lv_return_status
1054: );
1055:
1056: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
1057: RAISE fnd_api.g_exc_error;
1058: END IF;
1059: END IF;
1060:
1061: -- Validate Sunday Holiday Table for Completeness

Line 1069: RAISE FND_API.g_exc_error;

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
1072: (p_tm_tbl_type => lv_tm_sun_hol_tbl_type,
1073: x_return_status => lv_return_status

Line 1075: IF lv_return_status <> fnd_api.g_ret_sts_success THEN

1071: VALIDATE_COMPLETE_CHECK
1072: (p_tm_tbl_type => lv_tm_sun_hol_tbl_type,
1073: x_return_status => lv_return_status
1074: );
1075: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
1076: RAISE fnd_api.g_exc_error;
1077: END IF;
1078: END IF;
1079: */

Line 1076: RAISE fnd_api.g_exc_error;

1072: (p_tm_tbl_type => lv_tm_sun_hol_tbl_type,
1073: x_return_status => lv_return_status
1074: );
1075: IF lv_return_status <> fnd_api.g_ret_sts_success THEN
1076: RAISE fnd_api.g_exc_error;
1077: END IF;
1078: END IF;
1079: */
1080:

Line 1083: WHEN fnd_api.g_exc_error THEN

1079: */
1080:
1081: EXCEPTION
1082:
1083: WHEN fnd_api.g_exc_error THEN
1084: x_return_status := fnd_api.g_ret_sts_error;
1085: x_msg_data := fnd_msg_pub.get;
1086:
1087: WHEN OTHERS THEN

Line 1084: x_return_status := fnd_api.g_ret_sts_error;

1080:
1081: EXCEPTION
1082:
1083: WHEN fnd_api.g_exc_error THEN
1084: x_return_status := fnd_api.g_ret_sts_error;
1085: x_msg_data := fnd_msg_pub.get;
1086:
1087: WHEN OTHERS THEN
1088:

Line 1158: IF NOT FND_API.Compatible_API_CALL(l_api_version,

1154:
1155: BEGIN
1156:
1157: -- Standard Call to check API Compatibility
1158: IF NOT FND_API.Compatible_API_CALL(l_api_version,
1159: p_api_version,
1160: l_api_name,
1161: G_PKG_NAME) THEN
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1158: IF NOT FND_API.Compatible_API_CALL(l_api_version,
1159: p_api_version,
1160: l_api_name,
1161: G_PKG_NAME) THEN
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163: END IF;
1164:
1165: -- Initialize the message list if p_init_msg_list is set to TRUE
1166: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1166: IF FND_API.To_Boolean(p_init_msg_list) THEN

1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163: END IF;
1164:
1165: -- Initialize the message list if p_init_msg_list is set to TRUE
1166: IF FND_API.To_Boolean(p_init_msg_list) THEN
1167: FND_MSG_PUB.Initialize;
1168: END IF;
1169:
1170: -- Initialize the API Return Success to TRUE

Line 1171: x_return_status := FND_API.G_RET_STS_SUCCESS;

1167: FND_MSG_PUB.Initialize;
1168: END IF;
1169:
1170: -- Initialize the API Return Success to TRUE
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: -- Added to resolve bug # 2933203 - mviswana
1174:
1175: -- Check if the Time and Material Labor Schedule is valid for the business

Line 1189: RAISE FND_API.g_exc_error;

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;
1192: CLOSE tm_validate_csr;
1193:

Line 1202: RAISE FND_API.g_exc_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:
1205: -- Check to see if activity occurs in the same day
1206: IF trunc(p_activity_end_date_time) - trunc(p_activity_start_date_time) = 0 THEN

Line 1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1237: time_card_table.holiday_flag := 'N';
1238:
1239: ELSE
1240: -- END activity does not end on the same day as START activity (outside the scope of this program)
1241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1242: END IF;
1243:
1244:
1245: l_stmt := 'SELECT trunc(sysdate)+(start_hour/24)+(start_minute/(24*60)) START_TIME, ';

Line 1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1306: CLOSE tmpl_csr;
1307:
1308: EXCEPTION
1309:
1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1311: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 1311: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1307:
1308: EXCEPTION
1309:
1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1311: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1315:

Line 1313: WHEN FND_API.G_EXC_ERROR THEN

1309:
1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1311: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1315:
1316: WHEN OTHERS THEN
1317: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1314: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1311: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1315:
1316: WHEN OTHERS THEN
1317: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1318:

Line 1317: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

1313: WHEN FND_API.G_EXC_ERROR THEN
1314: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1315:
1316: WHEN OTHERS THEN
1317: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1318:
1319: END GET_LABOR_COVERAGES;
1320:
1321:

Line 1363: RAISE fnd_api.g_exc_error;

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);
1366: END IF;
1367: END IF;

Line 1380: RAISE fnd_api.g_exc_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;
1383:
1384: EXCEPTION

Line 1386: WHEN fnd_api.g_exc_error THEN

1382: END IF;
1383:
1384: EXCEPTION
1385:
1386: WHEN fnd_api.g_exc_error THEN
1387: x_return_status := fnd_api.g_ret_sts_error;
1388:
1389: WHEN OTHERS THEN
1390: l_errm := SQLERRM;

Line 1387: x_return_status := fnd_api.g_ret_sts_error;

1383:
1384: EXCEPTION
1385:
1386: WHEN fnd_api.g_exc_error THEN
1387: x_return_status := fnd_api.g_ret_sts_error;
1388:
1389: WHEN OTHERS THEN
1390: l_errm := SQLERRM;
1391: END VALIDATE_COMPLETE_CHECK;

Line 1429: RAISE fnd_api.g_exc_error;

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;
1432: END IF;
1433: END IF;

Line 1441: WHEN fnd_api.g_exc_error THEN

1437: END LOOP;
1438:
1439: EXCEPTION
1440:
1441: WHEN fnd_api.g_exc_error THEN
1442: x_return_status := fnd_api.g_ret_sts_error;
1443:
1444: WHEN NO_DATA_FOUND THEN
1445: x_return_status := fnd_api.g_ret_sts_error;

Line 1442: x_return_status := fnd_api.g_ret_sts_error;

1438:
1439: EXCEPTION
1440:
1441: WHEN fnd_api.g_exc_error THEN
1442: x_return_status := fnd_api.g_ret_sts_error;
1443:
1444: WHEN NO_DATA_FOUND THEN
1445: x_return_status := fnd_api.g_ret_sts_error;
1446:

Line 1445: x_return_status := fnd_api.g_ret_sts_error;

1441: WHEN fnd_api.g_exc_error THEN
1442: x_return_status := fnd_api.g_ret_sts_error;
1443:
1444: WHEN NO_DATA_FOUND THEN
1445: x_return_status := fnd_api.g_ret_sts_error;
1446:
1447: WHEN OTHERS THEN
1448: --l_errm := SQLERRM;
1449: x_return_status := fnd_api.g_ret_sts_error;

Line 1449: x_return_status := fnd_api.g_ret_sts_error;

1445: x_return_status := fnd_api.g_ret_sts_error;
1446:
1447: WHEN OTHERS THEN
1448: --l_errm := SQLERRM;
1449: x_return_status := fnd_api.g_ret_sts_error;
1450:
1451: END VALIDATE_OVERLAP;
1452:
1453: END CS_TM_LABOR_SCHEDULE_PVT;