APPS.AHL_UMP_UF_PVT dependencies on FND_MESSAGE

Line 410: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');

406: BEGIN
407:
408: IF(p_x_uf_header_rec.uf_header_id IS NULL) THEN
409: IF(p_x_uf_header_rec.unit_config_header_id IS NULL AND p_x_uf_header_rec.unit_name IS NULL) THEN
410: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');
411: FND_MSG_PUB.ADD;
412: ELSIF (p_x_uf_header_rec.unit_config_header_id IS NULL AND p_x_uf_header_rec.unit_name IS NOT NULL) THEN
413: OPEN unit_config_header_id_csr(p_x_uf_header_rec.unit_name);
414: FETCH unit_config_header_id_csr INTO l_unit_config_header_id;

Line 416: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');

412: ELSIF (p_x_uf_header_rec.unit_config_header_id IS NULL AND p_x_uf_header_rec.unit_name IS NOT NULL) THEN
413: OPEN unit_config_header_id_csr(p_x_uf_header_rec.unit_name);
414: FETCH unit_config_header_id_csr INTO l_unit_config_header_id;
415: IF(unit_config_header_id_csr%NOTFOUND) THEN
416: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');
417: FND_MSG_PUB.ADD;
418: ELSE
419: p_x_uf_header_rec.unit_config_header_id := l_unit_config_header_id;
420: END IF;

Line 429: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');

425: p_x_uf_header_rec.operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE) THEN
426: OPEN uf_header_id_uid_csr(p_x_uf_header_rec.unit_config_header_id);
427: FETCH uf_header_id_uid_csr INTO l_uf_header_id;
428: IF(uf_header_id_uid_csr%NOTFOUND)THEN
429: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
430: FND_MSG_PUB.ADD;
431: ELSE
432: p_x_uf_header_rec.uf_header_id := l_uf_header_id;
433: END IF;

Line 465: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');

461:
462: BEGIN
463: IF(p_x_uf_header_rec.uf_header_id IS NULL) THEN
464: IF(p_x_uf_header_rec.inventory_item_id IS NULL AND p_x_uf_header_rec.inventory_item_name IS NULL) THEN
465: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
466: FND_MSG_PUB.ADD;
467: ELSIF (p_x_uf_header_rec.inventory_item_id IS NULL AND p_x_uf_header_rec.inventory_item_name IS NOT NULL) THEN
468: OPEN inventory_item_id_csr(p_x_uf_header_rec.inventory_item_name);
469: FETCH inventory_item_id_csr INTO l_inventory_item_id;

Line 471: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');

467: ELSIF (p_x_uf_header_rec.inventory_item_id IS NULL AND p_x_uf_header_rec.inventory_item_name IS NOT NULL) THEN
468: OPEN inventory_item_id_csr(p_x_uf_header_rec.inventory_item_name);
469: FETCH inventory_item_id_csr INTO l_inventory_item_id;
470: IF(inventory_item_id_csr%NOTFOUND) THEN
471: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');
472: FND_MSG_PUB.ADD;
473: ELSE
474: p_x_uf_header_rec.inventory_item_id := l_inventory_item_id;
475: END IF;

Line 484: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');

480: p_x_uf_header_rec.operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE) THEN
481: OPEN uf_header_id_pid_csr(p_x_uf_header_rec.inventory_item_id);
482: FETCH uf_header_id_pid_csr INTO l_uf_header_id;
483: IF(uf_header_id_pid_csr%NOTFOUND)THEN
484: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
485: FND_MSG_PUB.ADD;
486: ELSE
487: p_x_uf_header_rec.uf_header_id := l_uf_header_id;
488: END IF;

Line 513: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_NODEID_NLL');

509: BEGIN
510: IF p_x_uf_header_rec.operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE THEN
511: IF(p_x_uf_header_rec.uf_header_id IS NULL) THEN
512: IF(p_x_uf_header_rec.pc_node_id IS NULL) THEN
513: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_NODEID_NLL');
514: FND_MSG_PUB.ADD;
515: ELSE
516: OPEN uf_header_id_nid_csr(p_x_uf_header_rec.pc_node_id);
517: FETCH uf_header_id_nid_csr INTO l_uf_header_id;

Line 519: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');

515: ELSE
516: OPEN uf_header_id_nid_csr(p_x_uf_header_rec.pc_node_id);
517: FETCH uf_header_id_nid_csr INTO l_uf_header_id;
518: IF(uf_header_id_nid_csr%NOTFOUND)THEN
519: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
520: FND_MSG_PUB.ADD;
521: ELSE
522: p_x_uf_header_rec.uf_header_id := l_uf_header_id;
523: END IF;

Line 603: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UF_TYPE');

599: BEGIN
600:
601: -- Operation Flag and Header ID validation.
602: IF (p_uf_header_rec.forecast_type NOT IN(AHL_UMP_UF_PVT.G_UF_TYPE_UNIT,AHL_UMP_UF_PVT.G_UF_TYPE_PART,AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE))THEN
603: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UF_TYPE');
604: FND_MSG_PUB.ADD;
605: ELSIF (p_uf_header_rec.operation_flag IS NOT NULL AND p_uf_header_rec.operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
606: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');
607: FND_MSG_PUB.ADD;

Line 606: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');

602: IF (p_uf_header_rec.forecast_type NOT IN(AHL_UMP_UF_PVT.G_UF_TYPE_UNIT,AHL_UMP_UF_PVT.G_UF_TYPE_PART,AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE))THEN
603: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UF_TYPE');
604: FND_MSG_PUB.ADD;
605: ELSIF (p_uf_header_rec.operation_flag IS NOT NULL AND p_uf_header_rec.operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
606: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');
607: FND_MSG_PUB.ADD;
608: ELSIF ((p_uf_header_rec.uf_header_id IS NULL)
609: AND (p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)) THEN
610: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');

Line 610: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');

606: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');
607: FND_MSG_PUB.ADD;
608: ELSIF ((p_uf_header_rec.uf_header_id IS NULL)
609: AND (p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)) THEN
610: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');
611: FND_MSG_PUB.ADD;
612: ELSIF(p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND
613: p_uf_header_rec.uf_header_id IS NOT NULL ) THEN
614: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_N_NLL');

Line 614: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_N_NLL');

610: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');
611: FND_MSG_PUB.ADD;
612: ELSIF(p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND
613: p_uf_header_rec.uf_header_id IS NOT NULL ) THEN
614: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_N_NLL');
615: FND_MSG_PUB.ADD;
616: END IF;
617:
618:

Line 628: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');

624: IF (( p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE) AND p_uf_header_rec.uf_header_id IS NOT NULL)THEN
625: OPEN uf_header_csr(p_uf_header_rec.uf_header_id);
626: FETCH uf_header_csr INTO l_object_version_number, l_unit_config_header_id,l_pc_node_id,l_inventory_item_id,l_inventory_org_id,l_use_unit_flag;
627: IF (uf_header_csr%NOTFOUND) THEN
628: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
629: FND_MSG_PUB.ADD;
630: ELSIF (l_object_version_number <> p_uf_header_rec.object_version_number)THEN
631: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_HREC_OBJV_MIS');
632: FND_MSG_PUB.ADD;

Line 631: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_HREC_OBJV_MIS');

627: IF (uf_header_csr%NOTFOUND) THEN
628: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
629: FND_MSG_PUB.ADD;
630: ELSIF (l_object_version_number <> p_uf_header_rec.object_version_number)THEN
631: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_HREC_OBJV_MIS');
632: FND_MSG_PUB.ADD;
633: END IF;
634: CLOSE uf_header_csr;
635:

Line 642: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');

638: END IF;
639:
640: IF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_UNIT) THEN
641: IF(p_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM)THEN
642: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');
643: FND_MSG_PUB.ADD;
644: ELSIF (p_uf_header_rec.unit_config_header_id IS NOT NULL AND
645: p_uf_header_rec.unit_config_header_id <> l_unit_config_header_id )THEN FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UCHID_MIS');
646: FND_MSG_PUB.ADD;

Line 645: p_uf_header_rec.unit_config_header_id <> l_unit_config_header_id )THEN FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UCHID_MIS');

641: IF(p_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM)THEN
642: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');
643: FND_MSG_PUB.ADD;
644: ELSIF (p_uf_header_rec.unit_config_header_id IS NOT NULL AND
645: p_uf_header_rec.unit_config_header_id <> l_unit_config_header_id )THEN FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UCHID_MIS');
646: FND_MSG_PUB.ADD;
647: ELSE
648: OPEN unit_status_check_csr(l_unit_config_header_id);
649: FETCH unit_status_check_csr INTO l_unit_config_status_code;

Line 651: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');

647: ELSE
648: OPEN unit_status_check_csr(l_unit_config_header_id);
649: FETCH unit_status_check_csr INTO l_unit_config_status_code;
650: IF (unit_status_check_csr%NOTFOUND) THEN
651: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');
652: FND_MSG_PUB.ADD;
653: ELSIF (l_unit_config_status_code = AHL_UMP_UF_PVT.G_DRAFT_STATUS)THEN
654: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UC_STATUS_DRAFT');
655: FND_MSG_PUB.ADD;

Line 654: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UC_STATUS_DRAFT');

650: IF (unit_status_check_csr%NOTFOUND) THEN
651: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');
652: FND_MSG_PUB.ADD;
653: ELSIF (l_unit_config_status_code = AHL_UMP_UF_PVT.G_DRAFT_STATUS)THEN
654: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UC_STATUS_DRAFT');
655: FND_MSG_PUB.ADD;
656: END IF;
657: CLOSE unit_status_check_csr;
658:

Line 662: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');

658:
659: OPEN pc_status_check_up_csr(l_unit_config_header_id,AHL_UMP_UF_PVT.G_PC_UNIT_ASSOCIATION);
660: FETCH pc_status_check_up_csr INTO l_pc_primary_flag,l_pc_status;
661: IF (pc_status_check_up_csr%NOTFOUND) THEN
662: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
663: FND_MSG_PUB.ADD;
664: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
665: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
666: FND_MSG_PUB.ADD;

Line 665: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');

661: IF (pc_status_check_up_csr%NOTFOUND) THEN
662: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
663: FND_MSG_PUB.ADD;
664: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
665: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
666: FND_MSG_PUB.ADD;
667: END IF;
668: CLOSE pc_status_check_up_csr;
669:

Line 674: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');

670:
671: END IF;
672: ELSIF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART) THEN
673: IF(p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM)THEN
674: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
675: FND_MSG_PUB.ADD;
676: ELSIF (p_uf_header_rec.inventory_item_id IS NOT NULL AND
677: p_uf_header_rec.inventory_item_id <> l_inventory_item_id )THEN
678: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVID_MIS');

Line 678: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVID_MIS');

674: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
675: FND_MSG_PUB.ADD;
676: ELSIF (p_uf_header_rec.inventory_item_id IS NOT NULL AND
677: p_uf_header_rec.inventory_item_id <> l_inventory_item_id )THEN
678: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVID_MIS');
679: FND_MSG_PUB.ADD;
680: ELSE
681: OPEN part_check_csr(l_inventory_item_id);
682: FETCH part_check_csr INTO l_exists;

Line 684: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');

680: ELSE
681: OPEN part_check_csr(l_inventory_item_id);
682: FETCH part_check_csr INTO l_exists;
683: IF (part_check_csr%NOTFOUND) THEN
684: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');
685: FND_MSG_PUB.ADD;
686: END IF;
687: CLOSE part_check_csr;
688:

Line 692: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');

688:
689: OPEN pc_status_check_up_csr(l_inventory_item_id,AHL_UMP_UF_PVT.G_PC_ITEM_ASSOCIATION);
690: FETCH pc_status_check_up_csr INTO l_pc_primary_flag,l_pc_status;
691: IF (pc_status_check_up_csr%NOTFOUND) THEN
692: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
693: FND_MSG_PUB.ADD;
694: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
695: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
696: FND_MSG_PUB.ADD;

Line 695: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');

691: IF (pc_status_check_up_csr%NOTFOUND) THEN
692: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
693: FND_MSG_PUB.ADD;
694: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
695: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
696: FND_MSG_PUB.ADD;
697: END IF;
698: CLOSE pc_status_check_up_csr;
699:

Line 703: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_NODEID_NLL');

699:
700: END IF;
701: ELSIF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE) THEN
702: IF(p_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM)THEN
703: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_NODEID_NLL');
704: FND_MSG_PUB.ADD;
705: ELSIF (p_uf_header_rec.pc_node_id IS NOT NULL AND
706: p_uf_header_rec.pc_node_id <> l_pc_node_id )THEN
707: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODEID_MIS');

Line 707: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODEID_MIS');

703: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_NODEID_NLL');
704: FND_MSG_PUB.ADD;
705: ELSIF (p_uf_header_rec.pc_node_id IS NOT NULL AND
706: p_uf_header_rec.pc_node_id <> l_pc_node_id )THEN
707: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODEID_MIS');
708: FND_MSG_PUB.ADD;
709: ELSE
710: OPEN pc_status_check_n_csr(l_pc_node_id);
711: FETCH pc_status_check_n_csr INTO l_pc_primary_flag,l_pc_status;

Line 713: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');

709: ELSE
710: OPEN pc_status_check_n_csr(l_pc_node_id);
711: FETCH pc_status_check_n_csr INTO l_pc_primary_flag,l_pc_status;
712: IF (pc_status_check_n_csr%NOTFOUND) THEN
713: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
714: FND_MSG_PUB.ADD;
715: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
716: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
717: FND_MSG_PUB.ADD;

Line 716: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');

712: IF (pc_status_check_n_csr%NOTFOUND) THEN
713: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
714: FND_MSG_PUB.ADD;
715: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
716: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
717: FND_MSG_PUB.ADD;
718: END IF;
719: CLOSE pc_status_check_n_csr;
720:

Line 728: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');

724: p_uf_header_rec.uf_header_id IS NULL)THEN
725: IF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_UNIT) THEN
726: IF(p_uf_header_rec.unit_config_header_id IS NULL OR
727: p_uf_header_rec.unit_config_header_id = FND_API.G_MISS_NUM) THEN
728: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFHID_UCHID_NLL');
729: FND_MSG_PUB.ADD;
730: ELSE
731: OPEN unit_status_check_csr(p_uf_header_rec.unit_config_header_id);
732: FETCH unit_status_check_csr INTO l_unit_config_status_code;

Line 734: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');

730: ELSE
731: OPEN unit_status_check_csr(p_uf_header_rec.unit_config_header_id);
732: FETCH unit_status_check_csr INTO l_unit_config_status_code;
733: IF (unit_status_check_csr%NOTFOUND) THEN
734: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');
735: FND_MSG_PUB.ADD;
736: ELSIF (l_unit_config_status_code = AHL_UMP_UF_PVT.G_DRAFT_STATUS)THEN
737: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UC_STATUS_DRAFT');
738: FND_MSG_PUB.ADD;

Line 737: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UC_STATUS_DRAFT');

733: IF (unit_status_check_csr%NOTFOUND) THEN
734: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_INV');
735: FND_MSG_PUB.ADD;
736: ELSIF (l_unit_config_status_code = AHL_UMP_UF_PVT.G_DRAFT_STATUS)THEN
737: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UC_STATUS_DRAFT');
738: FND_MSG_PUB.ADD;
739: END IF;
740: CLOSE unit_status_check_csr;
741:

Line 745: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');

741:
742: OPEN pc_status_check_up_csr(p_uf_header_rec.unit_config_header_id, AHL_UMP_UF_PVT.G_PC_UNIT_ASSOCIATION);
743: FETCH pc_status_check_up_csr INTO l_pc_primary_flag,l_pc_status;
744: IF (pc_status_check_up_csr%NOTFOUND) THEN
745: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
746: FND_MSG_PUB.ADD;
747: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
748: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
749: FND_MSG_PUB.ADD;

Line 748: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');

744: IF (pc_status_check_up_csr%NOTFOUND) THEN
745: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
746: FND_MSG_PUB.ADD;
747: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
748: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UNIT_PC_INV');
749: FND_MSG_PUB.ADD;
750: END IF;
751: CLOSE pc_status_check_up_csr;
752:

Line 757: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');

753: END IF;
754: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART) THEN
755: IF(p_uf_header_rec.inventory_item_id IS NULL OR
756: p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
757: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
758: FND_MSG_PUB.ADD;
759: ELSE
760: OPEN part_check_csr(p_uf_header_rec.inventory_item_id);
761: FETCH part_check_csr INTO l_exists;

Line 763: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');

759: ELSE
760: OPEN part_check_csr(p_uf_header_rec.inventory_item_id);
761: FETCH part_check_csr INTO l_exists;
762: IF (part_check_csr%NOTFOUND) THEN
763: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');
764: FND_MSG_PUB.ADD;
765: END IF;
766: CLOSE part_check_csr;
767:

Line 771: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');

767:
768: OPEN pc_status_check_up_csr(p_uf_header_rec.inventory_item_id, AHL_UMP_UF_PVT.G_PC_ITEM_ASSOCIATION);
769: FETCH pc_status_check_up_csr INTO l_pc_primary_flag,l_pc_status;
770: IF (pc_status_check_up_csr%NOTFOUND) THEN
771: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
772: FND_MSG_PUB.ADD;
773: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
774: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
775: FND_MSG_PUB.ADD;

Line 774: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');

770: IF (pc_status_check_up_csr%NOTFOUND) THEN
771: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
772: FND_MSG_PUB.ADD;
773: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
774: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_PC_INV');
775: FND_MSG_PUB.ADD;
776: END IF;
777: CLOSE pc_status_check_up_csr;
778:

Line 783: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_NODEID_NLL');

779: END IF;
780: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE) THEN
781: IF(p_uf_header_rec.pc_node_id IS NULL OR
782: p_uf_header_rec.pc_node_id = FND_API.G_MISS_NUM) THEN
783: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_NODEID_NLL');
784: FND_MSG_PUB.ADD;
785: ELSE
786: OPEN pc_status_check_n_csr(p_uf_header_rec.pc_node_id);
787: FETCH pc_status_check_n_csr INTO l_pc_primary_flag,l_pc_status;

Line 789: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');

785: ELSE
786: OPEN pc_status_check_n_csr(p_uf_header_rec.pc_node_id);
787: FETCH pc_status_check_n_csr INTO l_pc_primary_flag,l_pc_status;
788: IF (pc_status_check_n_csr%NOTFOUND) THEN
789: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
790: FND_MSG_PUB.ADD;
791: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
792: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
793: FND_MSG_PUB.ADD;

Line 792: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');

788: IF (pc_status_check_n_csr%NOTFOUND) THEN
789: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
790: FND_MSG_PUB.ADD;
791: ELSIF (l_pc_primary_flag <> AHL_UMP_UF_PVT.G_PC_PRIMARY_FLAG OR l_pc_status <> AHL_UMP_UF_PVT.G_COMPLETE_STATUS) THEN
792: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_NODE_PC_INV');
793: FND_MSG_PUB.ADD;
794: END IF;
795: CLOSE pc_status_check_n_csr;
796: END IF;

Line 799: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_HEADER');

795: CLOSE pc_status_check_n_csr;
796: END IF;
797: END IF;
798: ELSE
799: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_HEADER');
800: FND_MSG_PUB.ADD;
801: END IF;
802:
803: IF(FND_MSG_PUB.count_msg > 0)THEN

Line 809: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UNT_FLG');

805: END IF;
806:
807: IF((p_uf_header_rec.use_unit_flag IS NOT NULL OR p_uf_header_rec.use_unit_flag <> FND_API.G_MISS_CHAR)
808: AND p_uf_header_rec.use_unit_flag NOT IN (AHL_UMP_UF_PVT.G_UF_USE_UNIT_DEFAULT,AHL_UMP_UF_PVT.G_UF_USE_UNIT_YES)) THEN
809: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UNT_FLG');
810: FND_MSG_PUB.ADD;
811: END IF;
812:
813: IF(FND_MSG_PUB.count_msg > 0)THEN

Line 866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UF_TYPE');

862:
863: BEGIN
864: -- Operation Flag and Header ID validation.
865: IF (p_uf_header_rec.forecast_type NOT IN(AHL_UMP_UF_PVT.G_UF_TYPE_PART,AHL_UMP_UF_PVT.G_UF_TYPE_INSTANCE))THEN
866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UF_TYPE');
867: FND_MSG_PUB.ADD;
868: ELSIF (p_uf_header_rec.operation_flag IS NOT NULL AND p_uf_header_rec.operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
869: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');
870: FND_MSG_PUB.ADD;

Line 869: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');

865: IF (p_uf_header_rec.forecast_type NOT IN(AHL_UMP_UF_PVT.G_UF_TYPE_PART,AHL_UMP_UF_PVT.G_UF_TYPE_INSTANCE))THEN
866: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UF_TYPE');
867: FND_MSG_PUB.ADD;
868: ELSIF (p_uf_header_rec.operation_flag IS NOT NULL AND p_uf_header_rec.operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
869: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');
870: FND_MSG_PUB.ADD;
871: ELSIF ((p_uf_header_rec.uf_header_id IS NULL)
872: AND (p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)) THEN
873: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');

Line 873: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');

869: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');
870: FND_MSG_PUB.ADD;
871: ELSIF ((p_uf_header_rec.uf_header_id IS NULL)
872: AND (p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)) THEN
873: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');
874: FND_MSG_PUB.ADD;
875: ELSIF(p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND
876: p_uf_header_rec.uf_header_id IS NOT NULL ) THEN
877: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_N_NLL');

Line 877: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_N_NLL');

873: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');
874: FND_MSG_PUB.ADD;
875: ELSIF(p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND
876: p_uf_header_rec.uf_header_id IS NOT NULL ) THEN
877: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_N_NLL');
878: FND_MSG_PUB.ADD;
879: END IF;
880:
881:

Line 891: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');

887: IF (( p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE) AND p_uf_header_rec.uf_header_id IS NOT NULL)THEN
888: OPEN uf_header_csr(p_uf_header_rec.uf_header_id);
889: FETCH uf_header_csr INTO l_object_version_number, l_inventory_item_id,l_csi_item_instance_id,l_use_unit_flag;
890: IF (uf_header_csr%NOTFOUND) THEN
891: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
892: FND_MSG_PUB.ADD;
893: ELSIF (l_object_version_number <> p_uf_header_rec.object_version_number)THEN
894: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_HREC_OBJV_MIS');
895: FND_MSG_PUB.ADD;

Line 894: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_HREC_OBJV_MIS');

890: IF (uf_header_csr%NOTFOUND) THEN
891: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
892: FND_MSG_PUB.ADD;
893: ELSIF (l_object_version_number <> p_uf_header_rec.object_version_number)THEN
894: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_HREC_OBJV_MIS');
895: FND_MSG_PUB.ADD;
896: END IF;
897: CLOSE uf_header_csr;
898:

Line 905: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');

901: END IF;
902:
903: IF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART) THEN
904: IF(p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM)THEN
905: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
906: FND_MSG_PUB.ADD;
907: ELSIF (p_uf_header_rec.inventory_item_id IS NOT NULL AND
908: p_uf_header_rec.inventory_item_id <> l_inventory_item_id )THEN
909: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVID_MIS');

Line 909: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVID_MIS');

905: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
906: FND_MSG_PUB.ADD;
907: ELSIF (p_uf_header_rec.inventory_item_id IS NOT NULL AND
908: p_uf_header_rec.inventory_item_id <> l_inventory_item_id )THEN
909: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVID_MIS');
910: FND_MSG_PUB.ADD;
911: ELSE
912: OPEN part_check_csr(l_inventory_item_id);
913: FETCH part_check_csr INTO l_exists;

Line 915: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');

911: ELSE
912: OPEN part_check_csr(l_inventory_item_id);
913: FETCH part_check_csr INTO l_exists;
914: IF (part_check_csr%NOTFOUND) THEN
915: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');
916: FND_MSG_PUB.ADD;
917: END IF;
918: CLOSE part_check_csr;
919: END IF;

Line 922: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INSTID_NLL');

918: CLOSE part_check_csr;
919: END IF;
920: ELSIF(p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_INSTANCE) THEN
921: IF(p_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM)THEN
922: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INSTID_NLL');
923: FND_MSG_PUB.ADD;
924: ELSIF (p_uf_header_rec.csi_item_instance_id IS NOT NULL AND
925: p_uf_header_rec.csi_item_instance_id <> l_csi_item_instance_id )THEN
926: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INSTID_MIS');

Line 926: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INSTID_MIS');

922: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INSTID_NLL');
923: FND_MSG_PUB.ADD;
924: ELSIF (p_uf_header_rec.csi_item_instance_id IS NOT NULL AND
925: p_uf_header_rec.csi_item_instance_id <> l_csi_item_instance_id )THEN
926: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INSTID_MIS');
927: FND_MSG_PUB.ADD;
928: ELSE
929: OPEN instance_check_csr(l_csi_item_instance_id);
930: FETCH instance_check_csr INTO l_exists;

Line 932: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INST_INV');

928: ELSE
929: OPEN instance_check_csr(l_csi_item_instance_id);
930: FETCH instance_check_csr INTO l_exists;
931: IF (instance_check_csr%NOTFOUND) THEN
932: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INST_INV');
933: FND_MSG_PUB.ADD;
934: END IF;
935: CLOSE instance_check_csr;
936: END IF;

Line 943: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');

939: p_uf_header_rec.uf_header_id IS NULL)THEN
940: IF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART) THEN
941: IF(p_uf_header_rec.inventory_item_id IS NULL OR
942: p_uf_header_rec.inventory_item_id = FND_API.G_MISS_NUM) THEN
943: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INVID_NLL');
944: FND_MSG_PUB.ADD;
945: ELSE
946: OPEN part_check_csr(p_uf_header_rec.inventory_item_id);
947: FETCH part_check_csr INTO l_exists;

Line 949: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');

945: ELSE
946: OPEN part_check_csr(p_uf_header_rec.inventory_item_id);
947: FETCH part_check_csr INTO l_exists;
948: IF (part_check_csr%NOTFOUND) THEN
949: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_PART_INV');
950: FND_MSG_PUB.ADD;
951: END IF;
952: CLOSE part_check_csr;
953: END IF;

Line 957: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INSTID_NLL');

953: END IF;
954: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_INSTANCE) THEN
955: IF(p_uf_header_rec.csi_item_instance_id IS NULL OR
956: p_uf_header_rec.csi_item_instance_id = FND_API.G_MISS_NUM) THEN
957: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UFH_INSTID_NLL');
958: FND_MSG_PUB.ADD;
959: ELSE
960: OPEN instance_check_csr(p_uf_header_rec.csi_item_instance_id);
961: FETCH instance_check_csr INTO l_exists;

Line 963: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INST_INV');

959: ELSE
960: OPEN instance_check_csr(p_uf_header_rec.csi_item_instance_id);
961: FETCH instance_check_csr INTO l_exists;
962: IF (instance_check_csr%NOTFOUND) THEN
963: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INST_INV');
964: FND_MSG_PUB.ADD;
965: END IF;
966: CLOSE instance_check_csr;
967: END IF;

Line 970: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_HEADER');

966: CLOSE instance_check_csr;
967: END IF;
968: END IF;
969: ELSE
970: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_HEADER');
971: FND_MSG_PUB.ADD;
972: END IF;
973:
974: IF(FND_MSG_PUB.count_msg > 0)THEN

Line 980: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UNT_FLG');

976: END IF;
977:
978: IF((p_uf_header_rec.use_unit_flag IS NOT NULL OR p_uf_header_rec.use_unit_flag <> FND_API.G_MISS_CHAR)
979: AND p_uf_header_rec.use_unit_flag NOT IN (AHL_UMP_UF_PVT.G_UF_USE_UNIT_DEFAULT,AHL_UMP_UF_PVT.G_UF_USE_UNIT_YES)) THEN
980: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UNT_FLG');
981: FND_MSG_PUB.ADD;
982: END IF;
983:
984: IF(FND_MSG_PUB.count_msg > 0)THEN

Line 1021: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');

1017: l_uf_header_rec.attribute9, l_uf_header_rec.attribute10, l_uf_header_rec.attribute11,
1018: l_uf_header_rec.attribute12, l_uf_header_rec.attribute13, l_uf_header_rec.attribute14,
1019: l_uf_header_rec.attribute15;
1020: IF (uf_header_csr%NOTFOUND) THEN
1021: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HREC_NOTINDB');
1022: FND_MSG_PUB.ADD;
1023: ELSE
1024: IF (p_x_uf_header_rec.unit_config_header_id is null) THEN
1025: p_x_uf_header_rec.unit_config_header_id := l_uf_header_rec.unit_config_header_id;

Line 1417: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');

1413: l_total := p_x_uf_details_tbl.count;
1414: FOR i IN p_x_uf_details_tbl.FIRST..l_total LOOP
1415: --checking for unexpected errors
1416: IF ( p_x_uf_details_tbl(i).operation_flag IS NOT NULL AND p_x_uf_details_tbl(i).operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
1417: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');
1418: FND_MSG_PUB.ADD;
1419: ELSIF (p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1420: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_OP_DET_HED');
1421: FND_MSG_PUB.ADD;

Line 1420: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_OP_DET_HED');

1416: IF ( p_x_uf_details_tbl(i).operation_flag IS NOT NULL AND p_x_uf_details_tbl(i).operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
1417: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');
1418: FND_MSG_PUB.ADD;
1419: ELSIF (p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1420: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_OP_DET_HED');
1421: FND_MSG_PUB.ADD;
1422: ELSIF ((p_x_uf_details_tbl(i).operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).uf_detail_id IS NULL) OR
1423: (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).uf_detail_id IS NOT NULL)) THEN
1424: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');

Line 1424: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');

1420: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_OP_DET_HED');
1421: FND_MSG_PUB.ADD;
1422: ELSIF ((p_x_uf_details_tbl(i).operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).uf_detail_id IS NULL) OR
1423: (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).uf_detail_id IS NOT NULL)) THEN
1424: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');
1425: FND_MSG_PUB.ADD;
1426: END IF;
1427: -- Raise if unexpected errors
1428: IF FND_MSG_PUB.count_msg > 0 THEN

Line 1441: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_INV_NOTINDB');

1437: ELSIF (p_x_uf_details_tbl(i).operation_flag <> AHL_UMP_UF_PVT.G_OP_CREATE AND p_x_uf_details_tbl(i).uf_detail_id IS NOT NULL)THEN
1438: OPEN uf_details_csr(p_x_uf_details_tbl(i).uf_detail_id);
1439: FETCH uf_details_csr INTO l_object_version_number, l_uf_header_id,l_uom_code,l_start_date,l_end_date,l_usage_per_day;
1440: IF (uf_details_csr%NOTFOUND) THEN
1441: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_INV_NOTINDB');
1442: FND_MSG_PUB.ADD;
1443: ELSIF l_object_version_number <> p_x_uf_details_tbl(i).object_version_number THEN
1444: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_OBJV_MIS');
1445: FND_MSG_PUB.ADD;

Line 1444: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_OBJV_MIS');

1440: IF (uf_details_csr%NOTFOUND) THEN
1441: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_INV_NOTINDB');
1442: FND_MSG_PUB.ADD;
1443: ELSIF l_object_version_number <> p_x_uf_details_tbl(i).object_version_number THEN
1444: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_OBJV_MIS');
1445: FND_MSG_PUB.ADD;
1446: ELSE
1447: IF p_x_uf_details_tbl(i).end_date IS NULL THEN
1448: p_x_uf_details_tbl(i).end_date := l_end_date;

Line 1455: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_DET_UFHID');

1451: END IF;
1452: IF p_x_uf_details_tbl(i).uf_header_id IS NULL THEN
1453: p_x_uf_details_tbl(i).uf_header_id := l_uf_header_id;
1454: ELSIF p_x_uf_details_tbl(i).uf_header_id = FND_API.G_MISS_NUM THEN
1455: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_DET_UFHID');
1456: FND_MSG_PUB.ADD;
1457: ELSIF (p_x_uf_details_tbl(i).uf_header_id <> l_uf_header_id) THEN
1458: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_DET_UFHID');
1459: FND_MSG_PUB.ADD;

Line 1458: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_DET_UFHID');

1454: ELSIF p_x_uf_details_tbl(i).uf_header_id = FND_API.G_MISS_NUM THEN
1455: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_DET_UFHID');
1456: FND_MSG_PUB.ADD;
1457: ELSIF (p_x_uf_details_tbl(i).uf_header_id <> l_uf_header_id) THEN
1458: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_DET_UFHID');
1459: FND_MSG_PUB.ADD;
1460: END IF;
1461: END IF;
1462: CLOSE uf_details_csr;

Line 1473: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE_NLL');

1469: -- checking for expected error if start date , end date,UOM are invalid
1470: IF(p_x_uf_details_tbl(i).operation_flag IN (AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE))THEN
1471: -- checking for start and end dates
1472: IF(p_x_uf_details_tbl(i).start_date IS NULL) THEN
1473: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE_NLL');
1474: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1475: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1476: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1477: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1474: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1470: IF(p_x_uf_details_tbl(i).operation_flag IN (AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE))THEN
1471: -- checking for start and end dates
1472: IF(p_x_uf_details_tbl(i).start_date IS NULL) THEN
1473: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE_NLL');
1474: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1475: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1476: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1477: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1478: FND_MSG_PUB.ADD;

Line 1475: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1471: -- checking for start and end dates
1472: IF(p_x_uf_details_tbl(i).start_date IS NULL) THEN
1473: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE_NLL');
1474: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1475: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1476: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1477: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1478: FND_MSG_PUB.ADD;
1479: ELSIF (p_x_uf_details_tbl(i).end_date IS NOT NULL) THEN

Line 1476: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1472: IF(p_x_uf_details_tbl(i).start_date IS NULL) THEN
1473: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE_NLL');
1474: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1475: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1476: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1477: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1478: FND_MSG_PUB.ADD;
1479: ELSIF (p_x_uf_details_tbl(i).end_date IS NOT NULL) THEN
1480: IF ((TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(p_x_uf_details_tbl(i).start_date)) OR

Line 1477: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1473: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE_NLL');
1474: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1475: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1476: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1477: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1478: FND_MSG_PUB.ADD;
1479: ELSIF (p_x_uf_details_tbl(i).end_date IS NOT NULL) THEN
1480: IF ((TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(p_x_uf_details_tbl(i).start_date)) OR
1481: (TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(SYSDATE)))THEN

Line 1482: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_EDATE');

1478: FND_MSG_PUB.ADD;
1479: ELSIF (p_x_uf_details_tbl(i).end_date IS NOT NULL) THEN
1480: IF ((TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(p_x_uf_details_tbl(i).start_date)) OR
1481: (TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(SYSDATE)))THEN
1482: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_EDATE');
1483: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1484: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1485: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1486: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1483: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1479: ELSIF (p_x_uf_details_tbl(i).end_date IS NOT NULL) THEN
1480: IF ((TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(p_x_uf_details_tbl(i).start_date)) OR
1481: (TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(SYSDATE)))THEN
1482: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_EDATE');
1483: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1484: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1485: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1486: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1487: FND_MSG_PUB.ADD;

Line 1484: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1480: IF ((TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(p_x_uf_details_tbl(i).start_date)) OR
1481: (TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(SYSDATE)))THEN
1482: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_EDATE');
1483: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1484: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1485: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1486: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1487: FND_MSG_PUB.ADD;
1488: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN

Line 1485: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1481: (TRUNC(p_x_uf_details_tbl(i).end_date) < TRUNC(SYSDATE)))THEN
1482: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_EDATE');
1483: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1484: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1485: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1486: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1487: FND_MSG_PUB.ADD;
1488: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1489: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN

Line 1486: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1482: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_EDATE');
1483: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1484: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1485: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1486: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1487: FND_MSG_PUB.ADD;
1488: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1489: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN
1490: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');

Line 1490: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');

1486: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1487: FND_MSG_PUB.ADD;
1488: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1489: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN
1490: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1491: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1492: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1493: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1494: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1491: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1487: FND_MSG_PUB.ADD;
1488: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1489: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN
1490: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1491: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1492: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1493: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1494: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1495: FND_MSG_PUB.ADD;

Line 1492: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1488: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1489: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN
1490: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1491: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1492: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1493: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1494: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1495: FND_MSG_PUB.ADD;
1496: END IF;

Line 1493: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1489: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN
1490: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1491: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1492: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1493: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1494: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1495: FND_MSG_PUB.ADD;
1496: END IF;
1497: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN

Line 1494: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1490: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1491: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1492: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1493: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1494: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1495: FND_MSG_PUB.ADD;
1496: END IF;
1497: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN
1498: IF ( TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) AND

Line 1501: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');

1497: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN
1498: IF ( TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) AND
1499: (TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date) OR
1500: p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1501: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1502: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1503: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1504: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1505: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1502: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1498: IF ( TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) AND
1499: (TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date) OR
1500: p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1501: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1502: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1503: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1504: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1505: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1506: FND_MSG_PUB.ADD;

Line 1503: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1499: (TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date) OR
1500: p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1501: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1502: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1503: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1504: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1505: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1506: FND_MSG_PUB.ADD;
1507: END IF;

Line 1504: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1500: p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1501: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1502: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1503: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1504: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1505: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1506: FND_MSG_PUB.ADD;
1507: END IF;
1508: END IF;

Line 1505: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1501: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1502: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1503: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1504: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1505: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1506: FND_MSG_PUB.ADD;
1507: END IF;
1508: END IF;
1509: ELSIF (p_x_uf_details_tbl(i).end_date IS NULL) THEN

Line 1512: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');

1508: END IF;
1509: ELSIF (p_x_uf_details_tbl(i).end_date IS NULL) THEN
1510: IF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1511: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN
1512: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1513: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1514: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1515: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1516: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1513: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1509: ELSIF (p_x_uf_details_tbl(i).end_date IS NULL) THEN
1510: IF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1511: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN
1512: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1513: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1514: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1515: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1516: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1517: FND_MSG_PUB.ADD;

Line 1514: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1510: IF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_CREATE) THEN
1511: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN
1512: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1513: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1514: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1515: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1516: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1517: FND_MSG_PUB.ADD;
1518: END IF;

Line 1515: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1511: IF(TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE))THEN
1512: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1513: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1514: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1515: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1516: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1517: FND_MSG_PUB.ADD;
1518: END IF;
1519: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN

Line 1516: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1512: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE');
1513: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1514: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1515: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1516: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1517: FND_MSG_PUB.ADD;
1518: END IF;
1519: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN
1520: IF ( TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) AND

Line 1523: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');

1519: ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN
1520: IF ( TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) AND
1521: (TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date) OR
1522: p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1523: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1524: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1525: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1526: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1527: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1524: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1520: IF ( TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) AND
1521: (TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date) OR
1522: p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1523: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1524: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1525: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1526: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1527: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1528: FND_MSG_PUB.ADD;

Line 1525: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1521: (TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date) OR
1522: p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1523: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1524: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1525: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1526: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1527: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1528: FND_MSG_PUB.ADD;
1529: END IF;

Line 1526: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1522: p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1523: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1524: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1525: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1526: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1527: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1528: FND_MSG_PUB.ADD;
1529: END IF;
1530: END IF;

Line 1527: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1523: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1524: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1525: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1526: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1527: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1528: FND_MSG_PUB.ADD;
1529: END IF;
1530: END IF;
1531: END IF;

Line 1535: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UOMCD_NLL');

1531: END IF;
1532:
1533: --checking for expected error if UOM is invalid
1534: IF(p_x_uf_details_tbl(i).uom_code IS NULL) THEN
1535: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UOMCD_NLL');
1536: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1537: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1538: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1539: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1536: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1532:
1533: --checking for expected error if UOM is invalid
1534: IF(p_x_uf_details_tbl(i).uom_code IS NULL) THEN
1535: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UOMCD_NLL');
1536: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1537: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1538: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1539: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1540: FND_MSG_PUB.ADD;

Line 1537: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1533: --checking for expected error if UOM is invalid
1534: IF(p_x_uf_details_tbl(i).uom_code IS NULL) THEN
1535: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UOMCD_NLL');
1536: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1537: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1538: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1539: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1540: FND_MSG_PUB.ADD;
1541: ELSE

Line 1538: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1534: IF(p_x_uf_details_tbl(i).uom_code IS NULL) THEN
1535: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UOMCD_NLL');
1536: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1537: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1538: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1539: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1540: FND_MSG_PUB.ADD;
1541: ELSE
1542: IF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_OP_UPDATE)THEN

Line 1539: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1535: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_UOMCD_NLL');
1536: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1537: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1538: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1539: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1540: FND_MSG_PUB.ADD;
1541: ELSE
1542: IF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_OP_UPDATE)THEN
1543: OPEN unit_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);

Line 1546: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');

1542: IF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_OP_UPDATE)THEN
1543: OPEN unit_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);
1544: FETCH unit_uom_code_ckeck_csr into l_exists;
1545: IF (unit_uom_code_ckeck_csr%NOTFOUND) THEN
1546: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1547: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1548: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1549: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1550: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1547: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1543: OPEN unit_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);
1544: FETCH unit_uom_code_ckeck_csr into l_exists;
1545: IF (unit_uom_code_ckeck_csr%NOTFOUND) THEN
1546: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1547: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1548: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1549: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1550: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1551: FND_MSG_PUB.ADD;

Line 1548: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1544: FETCH unit_uom_code_ckeck_csr into l_exists;
1545: IF (unit_uom_code_ckeck_csr%NOTFOUND) THEN
1546: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1547: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1548: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1549: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1550: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1551: FND_MSG_PUB.ADD;
1552: END IF;

Line 1549: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1545: IF (unit_uom_code_ckeck_csr%NOTFOUND) THEN
1546: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1547: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1548: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1549: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1550: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1551: FND_MSG_PUB.ADD;
1552: END IF;
1553: CLOSE unit_uom_code_ckeck_csr;

Line 1550: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1546: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1547: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1548: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1549: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1550: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1551: FND_MSG_PUB.ADD;
1552: END IF;
1553: CLOSE unit_uom_code_ckeck_csr;
1554: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART)THEN

Line 1558: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');

1554: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PART)THEN
1555: OPEN part_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);
1556: FETCH part_uom_code_ckeck_csr into l_exists;
1557: IF (part_uom_code_ckeck_csr%NOTFOUND) THEN
1558: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1559: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1560: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1561: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1562: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1559: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1555: OPEN part_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);
1556: FETCH part_uom_code_ckeck_csr into l_exists;
1557: IF (part_uom_code_ckeck_csr%NOTFOUND) THEN
1558: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1559: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1560: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1561: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1562: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1563: FND_MSG_PUB.ADD;

Line 1560: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1556: FETCH part_uom_code_ckeck_csr into l_exists;
1557: IF (part_uom_code_ckeck_csr%NOTFOUND) THEN
1558: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1559: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1560: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1561: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1562: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1563: FND_MSG_PUB.ADD;
1564: END IF;

Line 1561: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1557: IF (part_uom_code_ckeck_csr%NOTFOUND) THEN
1558: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1559: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1560: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1561: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1562: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1563: FND_MSG_PUB.ADD;
1564: END IF;
1565: CLOSE part_uom_code_ckeck_csr;

Line 1562: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1558: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1559: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1560: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1561: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1562: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1563: FND_MSG_PUB.ADD;
1564: END IF;
1565: CLOSE part_uom_code_ckeck_csr;
1566: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE)THEN

Line 1570: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');

1566: ELSIF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_UF_TYPE_PC_NODE)THEN
1567: OPEN node_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);
1568: FETCH node_uom_code_ckeck_csr into l_exists;
1569: IF (node_uom_code_ckeck_csr%NOTFOUND) THEN
1570: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1571: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1572: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1573: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1574: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1571: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1567: OPEN node_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);
1568: FETCH node_uom_code_ckeck_csr into l_exists;
1569: IF (node_uom_code_ckeck_csr%NOTFOUND) THEN
1570: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1571: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1572: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1573: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1574: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1575: FND_MSG_PUB.ADD;

Line 1572: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1568: FETCH node_uom_code_ckeck_csr into l_exists;
1569: IF (node_uom_code_ckeck_csr%NOTFOUND) THEN
1570: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1571: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1572: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1573: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1574: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1575: FND_MSG_PUB.ADD;
1576: END IF;

Line 1573: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1569: IF (node_uom_code_ckeck_csr%NOTFOUND) THEN
1570: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1571: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1572: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1573: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1574: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1575: FND_MSG_PUB.ADD;
1576: END IF;
1577: CLOSE node_uom_code_ckeck_csr;

Line 1574: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1570: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_UOMCD');
1571: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1572: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1573: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1574: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1575: FND_MSG_PUB.ADD;
1576: END IF;
1577: CLOSE node_uom_code_ckeck_csr;
1578: END IF;

Line 1588: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');

1584: IF(p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)THEN
1585: IF TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) THEN
1586: IF((TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date))OR
1587: (p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1588: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1589: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1590: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1591: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1592: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

Line 1589: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);

1585: IF TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) THEN
1586: IF((TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date))OR
1587: (p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1588: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1589: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1590: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1591: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1592: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1593: FND_MSG_PUB.ADD;

Line 1590: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);

1586: IF((TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date))OR
1587: (p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1588: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1589: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1590: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1591: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1592: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1593: FND_MSG_PUB.ADD;
1594: ELSIF ((TRUNC(p_x_uf_details_tbl(i).end_date) <> TRUNC(l_end_date))OR

Line 1591: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);

1587: (p_x_uf_details_tbl(i).uom_code <> l_uom_code)) THEN
1588: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1589: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1590: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1591: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1592: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1593: FND_MSG_PUB.ADD;
1594: ELSIF ((TRUNC(p_x_uf_details_tbl(i).end_date) <> TRUNC(l_end_date))OR
1595: (p_x_uf_details_tbl(i).usage_per_day <> l_usage_per_day)) THEN

Line 1592: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);

1588: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');
1589: FND_MESSAGE.Set_Token('START_DATE',p_x_uf_details_tbl(i).start_date);
1590: FND_MESSAGE.Set_Token('END_DATE',p_x_uf_details_tbl(i).end_date);
1591: FND_MESSAGE.Set_Token('UOM_CODE',p_x_uf_details_tbl(i).uom_code);
1592: FND_MESSAGE.Set_Token('USAGE_PER_DAY',p_x_uf_details_tbl(i).usage_per_day);
1593: FND_MSG_PUB.ADD;
1594: ELSIF ((TRUNC(p_x_uf_details_tbl(i).end_date) <> TRUNC(l_end_date))OR
1595: (p_x_uf_details_tbl(i).usage_per_day <> l_usage_per_day)) THEN
1596: -- adding new record

Line 1675: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');

1671: FOR i IN x_uf_details_tbl.FIRST..x_uf_details_tbl.LAST LOOP
1672: IF(x_uf_details_tbl.LAST > i) THEN
1673: IF(x_uf_details_tbl(i).uom_code = x_uf_details_tbl(i+1).uom_code) THEN
1674: IF(x_uf_details_tbl(i).end_date IS NULL) THEN
1675: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');
1676: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1677: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1678: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1679: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);

Line 1676: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);

1672: IF(x_uf_details_tbl.LAST > i) THEN
1673: IF(x_uf_details_tbl(i).uom_code = x_uf_details_tbl(i+1).uom_code) THEN
1674: IF(x_uf_details_tbl(i).end_date IS NULL) THEN
1675: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');
1676: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1677: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1678: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1679: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1680: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);

Line 1677: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);

1673: IF(x_uf_details_tbl(i).uom_code = x_uf_details_tbl(i+1).uom_code) THEN
1674: IF(x_uf_details_tbl(i).end_date IS NULL) THEN
1675: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');
1676: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1677: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1678: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1679: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1680: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1681: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);

Line 1678: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);

1674: IF(x_uf_details_tbl(i).end_date IS NULL) THEN
1675: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');
1676: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1677: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1678: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1679: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1680: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1681: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1682: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);

Line 1679: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);

1675: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');
1676: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1677: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1678: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1679: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1680: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1681: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1682: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1683: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);

Line 1680: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);

1676: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1677: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1678: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1679: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1680: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1681: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1682: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1683: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1684: FND_MSG_PUB.ADD;

Line 1681: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);

1677: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1678: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1679: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1680: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1681: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1682: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1683: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1684: FND_MSG_PUB.ADD;
1685: ELSIF TRUNC(x_uf_details_tbl(i+1).start_date) <> TRUNC(x_uf_details_tbl(i).end_date + 1) THEN

Line 1682: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);

1678: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1679: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1680: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1681: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1682: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1683: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1684: FND_MSG_PUB.ADD;
1685: ELSIF TRUNC(x_uf_details_tbl(i+1).start_date) <> TRUNC(x_uf_details_tbl(i).end_date + 1) THEN
1686: IF(TRUNC(x_uf_details_tbl(i+1).start_date) > TRUNC(x_uf_details_tbl(i).end_date + 1)) THEN

Line 1683: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);

1679: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1680: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1681: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1682: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1683: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1684: FND_MSG_PUB.ADD;
1685: ELSIF TRUNC(x_uf_details_tbl(i+1).start_date) <> TRUNC(x_uf_details_tbl(i).end_date + 1) THEN
1686: IF(TRUNC(x_uf_details_tbl(i+1).start_date) > TRUNC(x_uf_details_tbl(i).end_date + 1)) THEN
1687: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_GAPS_IN_UF');

Line 1687: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_GAPS_IN_UF');

1683: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1684: FND_MSG_PUB.ADD;
1685: ELSIF TRUNC(x_uf_details_tbl(i+1).start_date) <> TRUNC(x_uf_details_tbl(i).end_date + 1) THEN
1686: IF(TRUNC(x_uf_details_tbl(i+1).start_date) > TRUNC(x_uf_details_tbl(i).end_date + 1)) THEN
1687: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_GAPS_IN_UF');
1688: ELSE
1689: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');
1690: END IF;
1691: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);

Line 1689: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');

1685: ELSIF TRUNC(x_uf_details_tbl(i+1).start_date) <> TRUNC(x_uf_details_tbl(i).end_date + 1) THEN
1686: IF(TRUNC(x_uf_details_tbl(i+1).start_date) > TRUNC(x_uf_details_tbl(i).end_date + 1)) THEN
1687: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_GAPS_IN_UF');
1688: ELSE
1689: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');
1690: END IF;
1691: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1692: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1693: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);

Line 1691: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);

1687: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_GAPS_IN_UF');
1688: ELSE
1689: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');
1690: END IF;
1691: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1692: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1693: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1694: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1695: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);

Line 1692: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);

1688: ELSE
1689: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');
1690: END IF;
1691: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1692: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1693: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1694: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1695: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1696: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);

Line 1693: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);

1689: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UF_OLAPS_IN_UF');
1690: END IF;
1691: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1692: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1693: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1694: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1695: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1696: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1697: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);

Line 1694: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);

1690: END IF;
1691: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1692: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1693: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1694: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1695: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1696: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1697: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1698: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);

Line 1695: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);

1691: FND_MESSAGE.Set_Token('FSTART_DATE',x_uf_details_tbl(i).start_date);
1692: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1693: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1694: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1695: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1696: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1697: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1698: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1699: FND_MSG_PUB.ADD;

Line 1696: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);

1692: FND_MESSAGE.Set_Token('FEND_DATE',x_uf_details_tbl(i).end_date);
1693: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1694: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1695: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1696: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1697: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1698: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1699: FND_MSG_PUB.ADD;
1700: END IF;

Line 1697: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);

1693: FND_MESSAGE.Set_Token('FUOM_CODE',x_uf_details_tbl(i).uom_code);
1694: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1695: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1696: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1697: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1698: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1699: FND_MSG_PUB.ADD;
1700: END IF;
1701: END IF;

Line 1698: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);

1694: FND_MESSAGE.Set_Token('FUSAGE_PER_DAY',x_uf_details_tbl(i).usage_per_day);
1695: FND_MESSAGE.Set_Token('NSTART_DATE',x_uf_details_tbl(i+1).start_date);
1696: FND_MESSAGE.Set_Token('NEND_DATE',x_uf_details_tbl(i+1).end_date);
1697: FND_MESSAGE.Set_Token('NUOM_CODE',x_uf_details_tbl(i+1).uom_code);
1698: FND_MESSAGE.Set_Token('NUSAGE_PER_DAY',x_uf_details_tbl(i+1).usage_per_day);
1699: FND_MSG_PUB.ADD;
1700: END IF;
1701: END IF;
1702: END IF;

Line 1738: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_OBJV_MIS');

1734: l_uf_details_rec.attribute3, l_uf_details_rec.attribute4, l_uf_details_rec.attribute5, l_uf_details_rec.attribute6, l_uf_details_rec.attribute7,
1735: l_uf_details_rec.attribute8, l_uf_details_rec.attribute9, l_uf_details_rec.attribute10, l_uf_details_rec.attribute11, l_uf_details_rec.attribute12,
1736: l_uf_details_rec.attribute13, l_uf_details_rec.attribute14, l_uf_details_rec.attribute15;
1737: IF (uf_details_csr%NOTFOUND) THEN
1738: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DET_OBJV_MIS');
1739: FND_MSG_PUB.ADD;
1740: ELSE
1741: IF (p_x_uf_details_tbl(i).uf_header_id is null) THEN
1742: p_x_uf_details_tbl(i).uf_header_id := l_uf_details_rec.uf_header_id;

Line 2297: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_ONLY_ONE_ID');

2293: OR (l_pc_node_id IS NOT NULL AND
2294: l_unit_config_header_id IS NOT NULL)
2295: OR (l_unit_config_header_id IS NOT NULL AND
2296: l_inventory_item_id IS NOT NULL) ) THEN
2297: FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_ONLY_ONE_ID');
2298: FND_MSG_PUB.ADD;
2299: END IF;
2300:
2301: l_msg_count := FND_MSG_PUB.count_msg;

Line 2315: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');

2311: AHL_UMP_UF_PVT.G_COMPLETE_STATUS);
2312: FETCH ahl_check_pc_id_csr INTO l_junk;
2313: IF (ahl_check_pc_id_csr%NOTFOUND) THEN
2314: l_pc_node_id := NULL;
2315: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');
2316: -- FND_MESSAGE.Set_Token('UID',l_pc_node_id);
2317: -- FND_MSG_PUB.ADD;
2318: END IF;
2319: CLOSE ahl_check_pc_id_csr;

Line 2316: -- FND_MESSAGE.Set_Token('UID',l_pc_node_id);

2312: FETCH ahl_check_pc_id_csr INTO l_junk;
2313: IF (ahl_check_pc_id_csr%NOTFOUND) THEN
2314: l_pc_node_id := NULL;
2315: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');
2316: -- FND_MESSAGE.Set_Token('UID',l_pc_node_id);
2317: -- FND_MSG_PUB.ADD;
2318: END IF;
2319: CLOSE ahl_check_pc_id_csr;
2320: END IF;

Line 2337: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');

2333: OPEN ahl_item_id_from_uc_header_csr(l_unit_config_header_id);
2334: FETCH ahl_item_id_from_uc_header_csr INTO l_inventory_item_id;
2335: CLOSE ahl_item_id_from_uc_header_csr;
2336:
2337: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');
2338: -- FND_MESSAGE.Set_Token('UID',l_unit_config_header_id);
2339: -- FND_MSG_PUB.ADD;
2340: END IF;
2341: CLOSE ahl_pc_id_from_assoc_csr;

Line 2338: -- FND_MESSAGE.Set_Token('UID',l_unit_config_header_id);

2334: FETCH ahl_item_id_from_uc_header_csr INTO l_inventory_item_id;
2335: CLOSE ahl_item_id_from_uc_header_csr;
2336:
2337: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');
2338: -- FND_MESSAGE.Set_Token('UID',l_unit_config_header_id);
2339: -- FND_MSG_PUB.ADD;
2340: END IF;
2341: CLOSE ahl_pc_id_from_assoc_csr;
2342:

Line 2443: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');

2439: AHL_UMP_UF_PVT.G_COMPLETE_STATUS);
2440: FETCH ahl_pc_id_from_assoc_csr INTO l_pc_node_id;
2441: IF (ahl_pc_id_from_assoc_csr%NOTFOUND) THEN
2442: l_pc_node_id := NULL;
2443: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');
2444: -- FND_MESSAGE.Set_Token('UID',l_inventory_item_id);
2445: -- FND_MSG_PUB.ADD;
2446: END IF;
2447: CLOSE ahl_pc_id_from_assoc_csr;

Line 2444: -- FND_MESSAGE.Set_Token('UID',l_inventory_item_id);

2440: FETCH ahl_pc_id_from_assoc_csr INTO l_pc_node_id;
2441: IF (ahl_pc_id_from_assoc_csr%NOTFOUND) THEN
2442: l_pc_node_id := NULL;
2443: -- FND_MESSAGE.Set_Name('AHL','AHL_UMP_UTIL_NO_PRIM_PC');
2444: -- FND_MESSAGE.Set_Token('UID',l_inventory_item_id);
2445: -- FND_MSG_PUB.ADD;
2446: END IF;
2447: CLOSE ahl_pc_id_from_assoc_csr;
2448: