690: CLOSE c_get_expired_status;
691:
692: IF l_has_expired_status THEN
693: RETCODE := G_WARNING;
694: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_UIPS_WARNING');
695:
696: IF p_msg_logname = 'FILE' THEN
697: INV_ITEM_MSG.Write_List (p_delete => TRUE);
698: END IF;
738:
739: END LOOP;
740:
741: RETCODE := G_SUCCESS;
742: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_UIPS_SUCCESS');
743:
744: OPEN c_status_pending_items (cp_org_id => P_Org_Id
745: ,cp_item_id => P_Item_Id);
746: LOOP
819: ,p_value2 => TO_CHAR(l_Item_Id)
820: ,p_token3 => 'STATUS_CODE'
821: ,p_value3 => l_status_code);
822: RETCODE := G_WARNING;
823: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_UIPS_WARNING');
824: END LOOP;
825: CLOSE c_status_pending_items;
826:
827: IF p_msg_logname = 'FILE' THEN
839: IF (c_get_control_level%ISOPEN) THEN
840: CLOSE c_get_control_level;
841: END IF;
842: RETCODE := G_ERROR;
843: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_UIPS_FAILURE');
844: INV_ITEM_MSG.Add_Message(p_Msg_Name => SUBSTRB(SQLERRM, 1,240));
845:
846: IF p_msg_logname = 'FILE' THEN
847: INV_ITEM_MSG.Write_List (p_delete => TRUE);
965: IF ( NOT l_return_status ) THEN
966:
967: IF (G_Transactable_status) THEN
968:
969: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTABLE_YES_NO');
970: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
971: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
972: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
973: FND_MSG_PUB.Add;
966:
967: IF (G_Transactable_status) THEN
968:
969: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTABLE_YES_NO');
970: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
971: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
972: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
973: FND_MSG_PUB.Add;
974:
967: IF (G_Transactable_status) THEN
968:
969: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTABLE_YES_NO');
970: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
971: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
972: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
973: FND_MSG_PUB.Add;
974:
975: G_Transactable_status := FALSE;
968:
969: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTABLE_YES_NO');
970: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
971: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
972: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
973: FND_MSG_PUB.Add;
974:
975: G_Transactable_status := FALSE;
976:
977: END IF;
978:
979: IF (G_TRANSACTABLE = 1) THEN
980:
981: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTABLE_UNCHECK');
982: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
983: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
984: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
985: FND_MSG_PUB.Add;
978:
979: IF (G_TRANSACTABLE = 1) THEN
980:
981: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTABLE_UNCHECK');
982: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
983: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
984: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
985: FND_MSG_PUB.Add;
986:
979: IF (G_TRANSACTABLE = 1) THEN
980:
981: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTABLE_UNCHECK');
982: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
983: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
984: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
985: FND_MSG_PUB.Add;
986:
987: G_TRANSACTABLE := 0;
980:
981: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTABLE_UNCHECK');
982: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
983: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
984: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
985: FND_MSG_PUB.Add;
986:
987: G_TRANSACTABLE := 0;
988:
989: END IF;
990:
991: IF (G_ORDERABLE = 1) THEN
992:
993: FND_MESSAGE.SET_NAME('INV','INV_CUST_ORDERABLE_UNCHECK');
994: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
995: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
996: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
997: FND_MSG_PUB.Add;
990:
991: IF (G_ORDERABLE = 1) THEN
992:
993: FND_MESSAGE.SET_NAME('INV','INV_CUST_ORDERABLE_UNCHECK');
994: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
995: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
996: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
997: FND_MSG_PUB.Add;
998:
991: IF (G_ORDERABLE = 1) THEN
992:
993: FND_MESSAGE.SET_NAME('INV','INV_CUST_ORDERABLE_UNCHECK');
994: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
995: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
996: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
997: FND_MSG_PUB.Add;
998:
999: G_ORDERABLE := 0;
992:
993: FND_MESSAGE.SET_NAME('INV','INV_CUST_ORDERABLE_UNCHECK');
994: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
995: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
996: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
997: FND_MSG_PUB.Add;
998:
999: G_ORDERABLE := 0;
1000:
1001: END IF;
1002:
1003: IF (G_PURCHASABLE = 1) THEN
1004:
1005: FND_MESSAGE.SET_NAME('INV','INV_PURCHASABLE_UNCHECK');
1006: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
1007: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
1008: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
1009: FND_MSG_PUB.Add;
1002:
1003: IF (G_PURCHASABLE = 1) THEN
1004:
1005: FND_MESSAGE.SET_NAME('INV','INV_PURCHASABLE_UNCHECK');
1006: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
1007: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
1008: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
1009: FND_MSG_PUB.Add;
1010:
1003: IF (G_PURCHASABLE = 1) THEN
1004:
1005: FND_MESSAGE.SET_NAME('INV','INV_PURCHASABLE_UNCHECK');
1006: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
1007: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
1008: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
1009: FND_MSG_PUB.Add;
1010:
1011: G_PURCHASABLE := 0;
1004:
1005: FND_MESSAGE.SET_NAME('INV','INV_PURCHASABLE_UNCHECK');
1006: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));
1007: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));
1008: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);
1009: FND_MSG_PUB.Add;
1010:
1011: G_PURCHASABLE := 0;
1012: