DBA Data[Home] [Help]

APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on FND_MESSAGE

Line 412: Fnd_Message.set_name ('AHL', 'AHL_PP_OPER_SEQ_MISSING');

408: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
409: IF G_DEBUG='Y' THEN
410: Ahl_Debug_Pub.debug ( 'OPERATION_SEQUENCE NUMBER PROB');
411: END IF;
412: Fnd_Message.set_name ('AHL', 'AHL_PP_OPER_SEQ_MISSING');
413: Fnd_Msg_Pub.ADD;
414: END IF;
415: x_return_status := Fnd_Api.g_ret_sts_error;
416: RETURN;

Line 426: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');

422: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
423: IF G_DEBUG='Y' THEN
424: Ahl_Debug_Pub.debug ( 'ONLY POSITIVE');
425: END IF;
426: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
427: Fnd_Msg_Pub.ADD;
428: END IF;
429: x_return_status := Fnd_Api.g_ret_sts_error;
430: RETURN;

Line 437: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_SEQ_MISSING');

433:
434: -- RESOURCE_SEQ_NUMBER
435: IF (p_resrc_Require_rec.RESOURCE_SEQ_NUMBER IS NULL OR p_resrc_Require_rec.RESOURCE_SEQ_NUMBER = Fnd_Api.G_MISS_NUM) THEN
436: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
437: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_SEQ_MISSING');
438: Fnd_Msg_Pub.ADD;
439: END IF;
440: x_return_status := Fnd_Api.g_ret_sts_error;
441: RETURN;

Line 448: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');

444: -- RESOURCE_SEQ_NUMBER -- Positive / Multiples of 10
445: IF (p_resrc_Require_rec.RESOURCE_SEQ_NUMBER IS NOT NULL AND p_resrc_Require_rec.RESOURCE_SEQ_NUMBER <> Fnd_Api.G_MISS_NUM) THEN
446: IF p_resrc_Require_rec.RESOURCE_SEQ_NUMBER < 0 THEN
447: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
448: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
449: Fnd_Msg_Pub.ADD;
450: END IF;
451: x_return_status := Fnd_Api.g_ret_sts_error;
452: RETURN;

Line 457: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_SEQ_MULTI_OF_TEN');

453: END IF;
454:
455: IF (p_resrc_Require_rec.RESOURCE_SEQ_NUMBER mod 10) <> 0 THEN
456: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
457: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_SEQ_MULTI_OF_TEN');
458: Fnd_Msg_Pub.ADD;
459: END IF;
460: x_return_status := Fnd_Api.g_ret_sts_error;
461: RETURN;

Line 484: Fnd_Message.set_name ('AHL', 'AHL_COM_SCHED_SEQ_INV');

480: )
481: THEN
482:
483: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
484: Fnd_Message.set_name ('AHL', 'AHL_COM_SCHED_SEQ_INV');
485: Fnd_Msg_Pub.ADD;
486: END IF;
487: x_return_status := Fnd_Api.g_ret_sts_error;
488: RETURN;

Line 503: Fnd_Message.set_name ('AHL', 'AHL_PP_RESOURCE_MISSING');

499: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items' || '-- RESOURCE_NAME ='|| p_resrc_Require_rec.RESOURCE_NAME);
500: END IF;
501:
502: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
503: Fnd_Message.set_name ('AHL', 'AHL_PP_RESOURCE_MISSING');
504: Fnd_Msg_Pub.ADD;
505: END IF;
506: x_return_status := Fnd_Api.g_ret_sts_error;
507: RETURN;

Line 520: Fnd_Message.set_name ('AHL', 'AHL_PP_DURATION_MISSING');

516: IF G_DEBUG='Y' THEN
517: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items' || '-- Duration =' || p_resrc_Require_rec.Duration);
518: END IF;
519: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
520: Fnd_Message.set_name ('AHL', 'AHL_PP_DURATION_MISSING');
521: Fnd_Msg_Pub.ADD;
522: END IF;
523: x_return_status := Fnd_Api.g_ret_sts_error;
524: RETURN;

Line 530: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');

526: -- DURATION - Positive
527: IF (p_resrc_Require_rec.Duration IS NOT NULL AND p_resrc_Require_rec.Duration <> Fnd_Api.G_MISS_NUM) THEN
528: IF p_resrc_Require_rec.Duration < 0 THEN
529: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
530: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
531: Fnd_Msg_Pub.ADD;
532: END IF;
533: x_return_status := Fnd_Api.g_ret_sts_error;
534: RETURN;

Line 546: Fnd_Message.set_name ('AHL', 'AHL_PP_QUANTITY_MISSING');

542:
543: IF (p_resrc_Require_rec.QUANTITY IS NULL OR p_resrc_Require_rec.QUANTITY = Fnd_Api.G_MISS_NUM) THEN
544: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items' || '-- Quantity =' || p_resrc_Require_rec.quantity);
545: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
546: Fnd_Message.set_name ('AHL', 'AHL_PP_QUANTITY_MISSING');
547: Fnd_Msg_Pub.ADD;
548: END IF;
549: x_return_status := Fnd_Api.g_ret_sts_error;
550: RETURN;

Line 557: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');

553: -- QUANTITY - Positive
554: IF (p_resrc_Require_rec.QUANTITY IS NOT NULL AND p_resrc_Require_rec.QUANTITY <> Fnd_Api.G_MISS_NUM) THEN
555: IF p_resrc_Require_rec.QUANTITY < 0 THEN
556: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
557: Fnd_Message.set_name ('AHL', 'AHL_PP_ONLY_POSITIVE_VALUE');
558: Fnd_Msg_Pub.ADD;
559: END IF;
560: x_return_status := Fnd_Api.g_ret_sts_error;
561: RETURN;

Line 572: Fnd_Message.set_name ('AHL', 'AHL_PP_REQUIRE_ST_DT_MISSING');

568: END IF;
569:
570: IF (p_resrc_Require_rec.REQ_START_DATE IS NULL OR p_resrc_Require_rec.REQ_START_DATE = Fnd_Api.G_MISS_DATE) THEN
571: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
572: Fnd_Message.set_name ('AHL', 'AHL_PP_REQUIRE_ST_DT_MISSING');
573: Fnd_Msg_Pub.ADD;
574: END IF;
575: x_return_status := Fnd_Api.g_ret_sts_error;
576: RETURN;

Line 586: Fnd_Message.set_name ('AHL', 'AHL_PP_REQUIRE_END_DT_MISSING');

582: END IF;
583:
584: IF (p_resrc_Require_rec.REQ_END_DATE IS NULL OR p_resrc_Require_rec.REQ_END_DATE = Fnd_Api.G_MISS_DATE) THEN
585: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
586: Fnd_Message.set_name ('AHL', 'AHL_PP_REQUIRE_END_DT_MISSING');
587: Fnd_Msg_Pub.ADD;
588: END IF;
589: x_return_status := Fnd_Api.g_ret_sts_error;
590: RETURN;

Line 612: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_FROMDT_GTR_TODT');

608: -- Validate the active dates.
609: IF l_Require_start_date IS NOT NULL AND l_Require_end_date IS NOT NULL THEN
610: IF l_Require_start_date > l_Require_end_date THEN
611: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
612: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_FROMDT_GTR_TODT');
613: Fnd_Msg_Pub.ADD;
614: END IF;
615: x_return_status := Fnd_Api.g_ret_sts_error;
616: RETURN;

Line 628: Fnd_Message.SET_NAME('AHL','AHL_PP_WORKORDER_NOT_EXISTS');

624: FETCH c_wo_oper INTO l_eff_st_date, l_eff_end_date, l_sch_st_date, l_sch_end_date;
625: IF c_wo_oper%NOTFOUND THEN
626: CLOSE c_wo_oper;
627: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items' || '--If condition--');
628: Fnd_Message.SET_NAME('AHL','AHL_PP_WORKORDER_NOT_EXISTS');
629: Fnd_Msg_Pub.ADD;
630: ELSE
631: CLOSE c_wo_oper;
632: END IF;

Line 638: Fnd_Message.SET_NAME('AHL','AHL_PP_WORKORDER_OPER_NOT_EXISTS');

634: OPEN c_oper_req(p_resrc_Require_rec.OPERATION_RESOURCE_ID);
635: FETCH c_oper_req INTO c_oper_req_rec;
636: IF c_oper_req%NOTFOUND THEN
637: CLOSE c_oper_req;
638: Fnd_Message.SET_NAME('AHL','AHL_PP_WORKORDER_OPER_NOT_EXISTS');
639: Fnd_Msg_Pub.ADD;
640: ELSE
641: CLOSE c_oper_req;
642: OPEN c_wo_oper(c_oper_req_rec.WORKORDER_OPERATION_ID);

Line 647: Fnd_Message.SET_NAME('AHL','AHL_PP_WORKORDER_NOT_EXISTS');

643: FETCH c_wo_oper INTO l_eff_st_date, l_eff_end_date, l_sch_st_date, l_sch_end_date;
644: IF c_wo_oper%NOTFOUND THEN
645: CLOSE c_wo_oper;
646: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items' || '--Else If condition--');
647: Fnd_Message.SET_NAME('AHL','AHL_PP_WORKORDER_NOT_EXISTS');
648: Fnd_Msg_Pub.ADD;
649: ELSE
650: CLOSE c_wo_oper;
651: END IF;

Line 679: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_STDT_LESS_ACT_STDT');

675: /* IF l_eff_st_date IS NOT NULL THEN
676: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items AAA' || '-- Actual Start Date =' || l_eff_st_date);
677: IF l_Require_start_date < l_eff_st_date THEN
678: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
679: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_STDT_LESS_ACT_STDT');
680: Fnd_Msg_Pub.ADD;
681: END IF;
682: x_return_status := Fnd_Api.g_ret_sts_error;
683: RETURN;

Line 690: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_STDT_LESS_SCH_STDT');

686: IF l_sch_st_date IS NOT NULL THEN
687: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items AAA' || '-- Scheduled Start Date =' || l_sch_st_date);
688: IF l_Require_start_date < l_sch_st_date THEN
689: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
690: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_STDT_LESS_SCH_STDT');
691: Fnd_Msg_Pub.ADD;
692: END IF;
693: x_return_status := Fnd_Api.g_ret_sts_error;
694: RETURN;

Line 702: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_STDT_MORE_ACT_EDDT');

698: /* IF l_eff_end_date IS NOT NULL THEN
699: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items AAA' || '-- Actual Start Date =' || l_eff_st_date);
700: IF l_Require_start_date > l_eff_end_date THEN
701: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
702: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_STDT_MORE_ACT_EDDT');
703: Fnd_Msg_Pub.ADD;
704: END IF;
705: x_return_status := Fnd_Api.g_ret_sts_error;
706: RETURN;

Line 713: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_STDT_MORE_SCH_EDDT');

709: IF l_sch_end_date IS NOT NULL THEN
710: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items AAA' || '-- Scheduled End Date =' || l_sch_end_date);
711: IF l_Require_start_date > l_sch_end_date THEN
712: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
713: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_STDT_MORE_SCH_EDDT');
714: Fnd_Msg_Pub.ADD;
715: END IF;
716: x_return_status := Fnd_Api.g_ret_sts_error;
717: RETURN;

Line 728: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_EDDT_MORE_ACT_EDDT');

724: /* IF l_eff_end_date IS NOT NULL THEN
725: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items BBB' || '-- Actual End Date =' || l_eff_end_date);
726: IF l_Require_end_date > l_eff_end_date THEN
727: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
728: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_EDDT_MORE_ACT_EDDT');
729: Fnd_Msg_Pub.ADD;
730: END IF;
731: x_return_status := Fnd_Api.g_ret_sts_error;
732: RETURN;

Line 739: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_EDDT_MORE_SCH_EDDT');

735: IF l_sch_end_date IS NOT NULL THEN
736: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items BBB' || '-- Scheduled End Date =' || l_sch_end_date);
737: IF l_Require_end_date > l_sch_end_date THEN
738: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
739: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_EDDT_MORE_SCH_EDDT');
740: Fnd_Msg_Pub.ADD;
741: END IF;
742: x_return_status := Fnd_Api.g_ret_sts_error;
743: RETURN;

Line 751: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_EDDT_LESS_ACT_STDT');

747: /* IF l_eff_st_date IS NOT NULL THEN
748: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items BBB' || '-- Actual Start Date =' || l_eff_st_date);
749: IF l_Require_end_date < l_eff_st_date THEN
750: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
751: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_EDDT_LESS_ACT_STDT');
752: Fnd_Msg_Pub.ADD;
753: END IF;
754: x_return_status := Fnd_Api.g_ret_sts_error;
755: RETURN;

Line 762: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_EDDT_LESS_SCH_STDT');

758: IF l_sch_st_date IS NOT NULL THEN
759: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items BBB' || '-- Scheduled Start Date =' || l_sch_st_date);
760: IF l_Require_end_date < l_sch_st_date THEN
761: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
762: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_EDDT_LESS_SCH_STDT');
763: Fnd_Msg_Pub.ADD;
764: END IF;
765: x_return_status := Fnd_Api.g_ret_sts_error;
766: RETURN;

Line 831: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_NOT_UNIQUE');

827: IF l_valid_flag = Fnd_Api.g_false
828: THEN
829:
830: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
831: Fnd_Message.set_name ('AHL', 'AHL_PP_REQ_NOT_UNIQUE');
832: Fnd_Msg_Pub.ADD;
833: END IF;
834: x_return_status := Fnd_Api.g_ret_sts_error;
835: RETURN;

Line 966: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_SCHEDULE_TYPE' );

962: ELSE
963: l_resource_type_code := p_resrc_Require_rec.resource_type_code;
964: END IF;
965: IF (l_resource_type_code NOT IN (1,2)) AND p_resrc_Require_rec.scheduled_type_code = 1 THEN
966: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_SCHEDULE_TYPE' );
967: Fnd_Msg_Pub.ADD;
968: RAISE Fnd_Api.g_exc_error;
969: END IF;
970: END IF;

Line 1437: Fnd_Message.SET_NAME('AHL','AHL_PP_OPER_SEQ_NOT_EXISTS');

1433: FETCH c_wo_oper INTO l_wo_operation_id;
1434: IF c_wo_oper%NOTFOUND THEN
1435: CLOSE c_wo_oper;
1436: Ahl_Debug_Pub.debug('NO SEQ');
1437: Fnd_Message.SET_NAME('AHL','AHL_PP_OPER_SEQ_NOT_EXISTS');
1438: Fnd_Msg_Pub.ADD;
1439: ELSE
1440: CLOSE c_wo_oper;
1441: l_Resrc_Require_Rec.workorder_operation_id := l_wo_operation_id;

Line 1453: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_SEQ_NOT_UNIQUE');

1449: IF l_count > 0 THEN
1450: IF G_DEBUG='Y' THEN
1451: Ahl_Debug_Pub.debug('UNIQ 1');
1452: END IF;
1453: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_SEQ_NOT_UNIQUE');
1454: Fnd_Msg_Pub.ADD;
1455: END IF;
1456: END IF; -- Check resrc sequence number
1457: END IF; -- Check c_wo_oper%NOTFOUND

Line 1461: Fnd_Message.SET_NAME('AHL','AHL_PP_JOB_NOT_EXISTS');

1457: END IF; -- Check c_wo_oper%NOTFOUND
1458:
1459: END IF; -- Check of Oper sequence number
1460: ELSE
1461: Fnd_Message.SET_NAME('AHL','AHL_PP_JOB_NOT_EXISTS');
1462: Fnd_Msg_Pub.ADD;
1463: END IF; -- Check of work order id
1464:
1465: --rroy

Line 1472: Fnd_Message.SET_NAME('AHL','AHL_PP_WORKORDER_NOT_EXISTS');

1468:
1469: OPEN c_workorder(l_Resrc_Require_Rec.workorder_id);
1470: FETCH c_workorder INTO c_workorder_rec;
1471: IF c_workorder%NOTFOUND THEN
1472: Fnd_Message.SET_NAME('AHL','AHL_PP_WORKORDER_NOT_EXISTS');
1473: Fnd_Msg_Pub.ADD;
1474: END IF;
1475: CLOSE c_workorder;
1476: END IF;

Line 1484: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_RESREQ_UNTLCKD');

1480: p_ue_id => NULL,
1481: p_visit_id => NULL,
1482: p_item_instance_id => NULL);
1483: IF l_return_status = FND_API.G_TRUE THEN
1484: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_CRT_RESREQ_UNTLCKD');
1485: FND_MSG_PUB.ADD;
1486: RAISE FND_API.G_EXC_ERROR;
1487: END IF;
1488: --rroy

Line 1573: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_TYPE_NOT_EXISTS');

1569: x_return_status => l_return_status);
1570:
1571: IF NVL(l_return_status, 'X') <> 'S'
1572: THEN
1573: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_TYPE_NOT_EXISTS');
1574: Fnd_Msg_Pub.ADD;
1575: RAISE Fnd_Api.G_EXC_ERROR;
1576: END IF;
1577: END IF;

Line 1601: Fnd_Message.SET_NAME('AHL','AHL_PP_RESOURCE_NOT_EXISTS');

1597: );
1598:
1599: IF NVL(l_return_status, 'X') <> 'S'
1600: THEN
1601: Fnd_Message.SET_NAME('AHL','AHL_PP_RESOURCE_NOT_EXISTS');
1602: Fnd_Msg_Pub.ADD;
1603: RAISE Fnd_Api.G_EXC_ERROR;
1604: END IF;
1605: END IF;

Line 1623: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_DEPT_NOT_EXISTS');

1619: --
1620: OPEN c_resources(l_Resrc_Require_Rec.Resource_Id);
1621: FETCH c_resources INTO l_resrc_dept_id;
1622: IF c_resources%NOTFOUND THEN
1623: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_DEPT_NOT_EXISTS');
1624: Fnd_Msg_Pub.ADD;
1625: END IF;
1626: CLOSE c_resources;
1627:

Line 1630: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_DEPT_NOT_EXISTS');

1626: CLOSE c_resources;
1627:
1628: -- check resource id dept matches the operation dept.
1629: IF (l_resrc_dept_id <> l_department_id) THEN
1630: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_DEPT_NOT_EXISTS');
1631: Fnd_Msg_Pub.ADD;
1632: END IF;
1633:
1634: --Convert Uom code

Line 1648: Fnd_Message.SET_NAME('AHL','AHL_PP_UOM_NOT_EXISTS');

1644: OPEN c_UOM(l_Resrc_Require_Rec.UOM_NAME);
1645: FETCH c_UOM INTO l_Resrc_Require_Rec.UOM_CODE;
1646: IF c_UOM%NOTFOUND THEN
1647: CLOSE c_UOM;
1648: Fnd_Message.SET_NAME('AHL','AHL_PP_UOM_NOT_EXISTS');
1649: Fnd_Msg_Pub.ADD;
1650: ELSE
1651: CLOSE c_UOM;
1652: END IF;

Line 1669: Fnd_Message.SET_NAME('AHL','AHL_PP_CHARGE_TYPE_NOT_EXISTS');

1665: x_return_status => l_return_status);
1666:
1667: IF NVL(l_return_status, 'X') <> 'S'
1668: THEN
1669: Fnd_Message.SET_NAME('AHL','AHL_PP_CHARGE_TYPE_NOT_EXISTS');
1670: Fnd_Msg_Pub.ADD;
1671: RAISE Fnd_Api.G_EXC_ERROR;
1672: END IF;
1673: END IF;

Line 1693: Fnd_Message.SET_NAME('AHL','AHL_PP_COST_BASIS_NOT_EXISTS');

1689: x_return_status => l_return_status);
1690:
1691: IF NVL(l_return_status, 'X') <> 'S'
1692: THEN
1693: Fnd_Message.SET_NAME('AHL','AHL_PP_COST_BASIS_NOT_EXISTS');
1694: Fnd_Msg_Pub.ADD;
1695: RAISE Fnd_Api.G_EXC_ERROR;
1696: END IF;
1697: END IF;

Line 1717: Fnd_Message.SET_NAME('AHL','AHL_PP_SCHED_TYPE_NOT_EXISTS');

1713: x_return_status => l_return_status);
1714:
1715: IF NVL(l_return_status, 'X') <> 'S'
1716: THEN
1717: Fnd_Message.SET_NAME('AHL','AHL_PP_SCHED_TYPE_NOT_EXISTS');
1718: Fnd_Msg_Pub.ADD;
1719: RAISE Fnd_Api.G_EXC_ERROR;
1720: END IF;
1721: END IF;

Line 2111: Fnd_Message.SET_NAME('AHL','AHL_PP_SEQUENCE_NO_EXISTS');

2107: FETCH Sch_id_exists INTO l_dummy;
2108: CLOSE Sch_id_exists;
2109: --
2110: IF l_dummy IS NOT NULL THEN
2111: Fnd_Message.SET_NAME('AHL','AHL_PP_SEQUENCE_NO_EXISTS');
2112: Fnd_Msg_Pub.ADD;
2113: RAISE FND_API.G_EXC_ERROR;
2114: END IF;
2115: IF G_DEBUG='Y' THEN

Line 2508: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_RESREQ_UNTLCKD');

2504: p_ue_id => NULL,
2505: p_visit_id => NULL,
2506: p_item_instance_id => NULL);
2507: IF l_return_status = FND_API.G_TRUE THEN
2508: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_UPD_RESREQ_UNTLCKD');
2509: FND_MSG_PUB.ADD;
2510: RAISE FND_API.G_EXC_ERROR;
2511: END IF;
2512:

Line 2618: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_TYPE_NOT_EXISTS');

2614: x_return_status => l_return_status);
2615:
2616: IF NVL(l_return_status, 'X') <> 'S'
2617: THEN
2618: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_TYPE_NOT_EXISTS');
2619: Fnd_Msg_Pub.ADD;
2620: RAISE Fnd_Api.G_EXC_ERROR;
2621: END IF;
2622: END IF;

Line 2642: Fnd_Message.SET_NAME('AHL','AHL_PP_RESOURCE_NOT_EXISTS');

2638: );
2639:
2640: IF NVL(l_return_status, 'X') <> 'S'
2641: THEN
2642: Fnd_Message.SET_NAME('AHL','AHL_PP_RESOURCE_NOT_EXISTS');
2643: Fnd_Msg_Pub.ADD;
2644: RAISE Fnd_Api.G_EXC_ERROR;
2645: END IF;
2646: END IF;

Line 2657: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_TYPE_MISSING');

2653: -- RESOURCE_TYPE_NAME
2654: IF (l_Resrc_Require_Rec.RESOURCE_TYPE_NAME IS NULL OR l_Resrc_Require_Rec.RESOURCE_TYPE_NAME = Fnd_Api.G_MISS_CHAR) THEN
2655: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items' || '-- Resource Type Name =' || l_Resrc_Require_Rec.RESOURCE_TYPE_NAME);
2656: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2657: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_TYPE_MISSING');
2658: Fnd_Msg_Pub.ADD;
2659: END IF;
2660: END IF;
2661:

Line 2667: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_NAME_MISSING');

2663: -- RESOURCE_NAME
2664: IF (l_Resrc_Require_Rec.RESOURCE_NAME IS NULL OR l_Resrc_Require_Rec.RESOURCE_NAME = Fnd_Api.G_MISS_CHAR) THEN
2665: Ahl_Debug_Pub.debug('Check_Resrc_Require_Req_Items' || '-- Resource Name =' || l_Resrc_Require_Rec.RESOURCE_NAME);
2666: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2667: Fnd_Message.set_name ('AHL', 'AHL_PP_RESRC_NAME_MISSING');
2668: Fnd_Msg_Pub.ADD;
2669: END IF;
2670: END IF;
2671:

Line 2677: Fnd_Message.SET_NAME('AHL','AHL_PP_WORKORDER_NOT_EXISTS');

2673: /*OPEN c_workorder(l_Resrc_Require_Rec.workorder_id);
2674: FETCH c_workorder INTO c_workorder_rec;
2675: IF c_workorder%NOTFOUND THEN
2676: CLOSE c_workorder;
2677: Fnd_Message.SET_NAME('AHL','AHL_PP_WORKORDER_NOT_EXISTS');
2678: Fnd_Msg_Pub.ADD;
2679: ELSE
2680: CLOSE c_workorder;*/
2681:

Line 2686: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_DEPT_NOT_EXISTS');

2682: OPEN c_resources(l_Resrc_Require_Rec.Resource_Id);
2683: FETCH c_resources INTO l_resrc_dept_id;
2684: IF c_resources%NOTFOUND THEN
2685: CLOSE c_resources;
2686: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_DEPT_NOT_EXISTS');
2687: Fnd_Msg_Pub.ADD;
2688: ELSE
2689: CLOSE c_resources;
2690: --IF l_resrc_dept_id = c_workorder_rec.department_id THEN

Line 2692: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_DEPT_NOT_EXISTS');

2688: ELSE
2689: CLOSE c_resources;
2690: --IF l_resrc_dept_id = c_workorder_rec.department_id THEN
2691: IF l_resrc_dept_id <> l_department_id THEN
2692: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_DEPT_NOT_EXISTS');
2693: Fnd_Msg_Pub.ADD;
2694: END IF;
2695: END IF;
2696:

Line 2711: Fnd_Message.SET_NAME('AHL','AHL_PP_UOM_NOT_EXISTS');

2707: OPEN c_UOM(l_Resrc_Require_Rec.UOM_NAME);
2708: FETCH c_UOM INTO l_Resrc_Require_Rec.UOM_CODE;
2709: IF c_UOM%NOTFOUND THEN
2710: CLOSE c_UOM;
2711: Fnd_Message.SET_NAME('AHL','AHL_PP_UOM_NOT_EXISTS');
2712: Fnd_Msg_Pub.ADD;
2713: ELSE
2714: CLOSE c_UOM;
2715: END IF;

Line 2743: Fnd_Message.SET_NAME('AHL','AHL_PP_CHARGE_TYPE_NOT_EXISTS');

2739: x_return_status => l_return_status);
2740:
2741: IF NVL(l_return_status, 'X') <> 'S'
2742: THEN
2743: Fnd_Message.SET_NAME('AHL','AHL_PP_CHARGE_TYPE_NOT_EXISTS');
2744: Fnd_Msg_Pub.ADD;
2745: RAISE Fnd_Api.G_EXC_ERROR;
2746: END IF;
2747: END IF;

Line 2767: Fnd_Message.SET_NAME('AHL','AHL_PP_COST_BASIS_NOT_EXISTS');

2763: x_return_status => l_return_status);
2764:
2765: IF NVL(l_return_status, 'X') <> 'S'
2766: THEN
2767: Fnd_Message.SET_NAME('AHL','AHL_PP_COST_BASIS_NOT_EXISTS');
2768: Fnd_Msg_Pub.ADD;
2769: RAISE Fnd_Api.G_EXC_ERROR;
2770: END IF;
2771: END IF;

Line 2791: Fnd_Message.SET_NAME('AHL','AHL_PP_SCHED_TYPE_NOT_EXISTS');

2787: x_return_status => l_return_status);
2788:
2789: IF NVL(l_return_status, 'X') <> 'S'
2790: THEN
2791: Fnd_Message.SET_NAME('AHL','AHL_PP_SCHED_TYPE_NOT_EXISTS');
2792: Fnd_Msg_Pub.ADD;
2793: RAISE Fnd_Api.G_EXC_ERROR;
2794: END IF;
2795: END IF;

Line 2965: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

2961: Ahl_Debug_Pub.debug ( l_full_name || ' Cursor Object Version Nubmer = ' || c_oper_req_rec.object_version_number);
2962: END IF;
2963: IF (c_oper_req_rec.object_version_number <> l_Resrc_Require_Rec.object_version_number)
2964: THEN
2965: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2966: Fnd_Msg_Pub.ADD;
2967: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2968: --
2969: END IF;

Line 3706: Fnd_Message.Set_Name('AHL','AHL_PP_RECORD_INVALID');

3702: --
3703: OPEN Get_resource_cur (p_x_resrc_Require_tbl(i).operation_resource_id);
3704: FETCH Get_resource_cur INTO l_resource_rec;
3705: IF Get_resource_cur%NOTFOUND THEN
3706: Fnd_Message.Set_Name('AHL','AHL_PP_RECORD_INVALID');
3707: Fnd_Msg_Pub.ADD;
3708: CLOSE Get_resource_cur;
3709: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3710: END IF;

Line 3725: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

3721: THEN
3722: IF(p_x_resrc_Require_tbl(i).object_version_number <> l_resource_rec.object_version_number )
3723: THEN
3724: --
3725: Fnd_Message.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
3726: Fnd_Msg_Pub.ADD;
3727: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3728: END IF;
3729: END IF;

Line 3760: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_RESREQ_UNTLCKD');

3756: p_ue_id => NULL,
3757: p_visit_id => NULL,
3758: p_item_instance_id => NULL);
3759: IF l_return_status = FND_API.G_TRUE THEN
3760: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_RESREQ_UNTLCKD');
3761: FND_MSG_PUB.ADD;
3762: RAISE FND_API.G_EXC_ERROR;
3763: END IF;
3764:

Line 3774: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_RESREQ_RESTXN');

3770: l_wo_oper_rec.operation_sequence_num,
3771: l_resource_rec.resource_sequence_num);
3772: FETCH check_resrc_txn INTO l_junk;
3773: IF (check_resrc_txn%FOUND) THEN
3774: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_RESREQ_RESTXN');
3775: FND_MESSAGE.Set_Token('OPER_RES', l_wo_oper_rec.operation_sequence_num || '-' || l_resource_rec.resource_sequence_num);
3776: FND_MSG_PUB.ADD;
3777: CLOSE check_resrc_txn;
3778: RAISE FND_API.G_EXC_ERROR;

Line 3775: FND_MESSAGE.Set_Token('OPER_RES', l_wo_oper_rec.operation_sequence_num || '-' || l_resource_rec.resource_sequence_num);

3771: l_resource_rec.resource_sequence_num);
3772: FETCH check_resrc_txn INTO l_junk;
3773: IF (check_resrc_txn%FOUND) THEN
3774: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_DEL_RESREQ_RESTXN');
3775: FND_MESSAGE.Set_Token('OPER_RES', l_wo_oper_rec.operation_sequence_num || '-' || l_resource_rec.resource_sequence_num);
3776: FND_MSG_PUB.ADD;
3777: CLOSE check_resrc_txn;
3778: RAISE FND_API.G_EXC_ERROR;
3779: END IF;

Line 3899: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_ASSIGN_EXITS');

3895: CLOSE c_chk_assgn;
3896:
3897: IF l_count > 0 THEN
3898: Ahl_Debug_Pub.debug ('Count in Assignments table' || l_count);
3899: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_ASSIGN_EXITS');
3900: FND_MESSAGE.SET_TOKEN('RECORD',p_x_resrc_Require_tbl(i).RESOURCE_SEQ_NUMBER,FALSE);
3901: Fnd_Msg_Pub.ADD;
3902: ELSE
3903: Ahl_Debug_Pub.debug ('Count in Assignments table' || l_count);

Line 3900: FND_MESSAGE.SET_TOKEN('RECORD',p_x_resrc_Require_tbl(i).RESOURCE_SEQ_NUMBER,FALSE);

3896:
3897: IF l_count > 0 THEN
3898: Ahl_Debug_Pub.debug ('Count in Assignments table' || l_count);
3899: Fnd_Message.SET_NAME('AHL','AHL_PP_RESRC_ASSIGN_EXITS');
3900: FND_MESSAGE.SET_TOKEN('RECORD',p_x_resrc_Require_tbl(i).RESOURCE_SEQ_NUMBER,FALSE);
3901: Fnd_Msg_Pub.ADD;
3902: ELSE
3903: Ahl_Debug_Pub.debug ('Count in Assignments table' || l_count);
3904: Ahl_Debug_Pub.debug ('BEFORE DELETE RESOURCES' || p_x_resrc_Require_tbl(i).Operation_Resource_Id);