DBA Data[Home] [Help]

APPS.INV_ITEM_STATUS_CP dependencies on FND_MESSAGE

Line 694: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_UIPS_WARNING');

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;

Line 742: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_UIPS_SUCCESS');

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

Line 823: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_UIPS_WARNING');

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

Line 843: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_UIPS_FAILURE');

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);

Line 969: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTABLE_YES_NO');

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;

Line 970: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));

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:

Line 971: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));

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;

Line 972: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);

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:

Line 981: FND_MESSAGE.SET_NAME('INV','INV_TRANSACTABLE_UNCHECK');

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;

Line 982: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));

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:

Line 983: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));

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;

Line 984: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);

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:

Line 993: FND_MESSAGE.SET_NAME('INV','INV_CUST_ORDERABLE_UNCHECK');

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;

Line 994: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));

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:

Line 995: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));

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;

Line 996: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);

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:

Line 1005: FND_MESSAGE.SET_NAME('INV','INV_PURCHASABLE_UNCHECK');

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;

Line 1006: FND_MESSAGE.SET_TOKEN('ORG_ID',TO_CHAR(p_org_Id));

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:

Line 1007: FND_MESSAGE.SET_TOKEN('ITEM_ID',TO_CHAR(p_inventory_item_id));

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;

Line 1008: FND_MESSAGE.SET_TOKEN('STATUS_CODE',l_status_code);

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: