APPS.BOM_BULKLOAD_PVT_PKG dependencies on FND_API

Line 154: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

150: );
151:
152: FND_FILE.put_line(FND_FILE.LOG, ' Log file location --> '||l_log_output_dir||'/'||G_ERROR_FILE_NAME ||' created with status '|| l_log_return_status);
153:
154: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
155: FND_FILE.put_line(FND_FILE.LOG, 'Unable to open error log file. Error => '||l_errbuff);
156: END IF;
157:
158: END IF;--IF c_get_utl_file_dir%FOUND THEN

Line 211: RETURN FND_API.G_MISS_NUM;

207: EXCEPTION
208: WHEN NO_DATA_FOUND THEN
209: RETURN NULL;
210: WHEN OTHERS THEN
211: RETURN FND_API.G_MISS_NUM;
212: END GET_ORGANIZATION_ID;
213:
214:
215: /*******************************************************************

Line 1943: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);

1939: INTO l_Bill_Sequence_id, l_Common_Bill_Sequence_Id, l_Source_Bill_Sequence_Id
1940: FROM BOM_STRUCTURES_B
1941: WHERE assembly_item_id = p_assembly_item_id
1942: AND organization_id = p_organization_id
1943: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);
1944:
1945: IF (l_Bill_Sequence_id <> l_Common_Bill_Sequence_Id) THEN
1946:
1947: l_Component_Count := 0;

Line 1957: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);

1953: AND Request_Id = p_request_id
1954: AND (p_batch_id IS NULL OR batch_id = p_batch_id)
1955: AND assembly_item_id = p_assembly_item_id
1956: AND organization_id = p_organization_id
1957: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);
1958:
1959: IF (l_Component_Count > 0) THEN
1960: -- Dereference the Bill Header
1961: BOMPCMBM.Dereference_Header( p_bill_sequence_id => l_Bill_Sequence_id);

Line 1972: AND NVL(bsb.alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR)

1968: FROM BOM_INVENTORY_COMPONENTS BIC, bom_structures_b bsb
1969: WHERE BIC.bill_sequence_id = bsb.bill_Sequence_id
1970: AND bsb.assembly_item_id = p_assembly_item_id
1971: AND bsb.organization_id = p_organization_id
1972: AND NVL(bsb.alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR)
1973: AND BIC.common_component_sequence_id = BICI.component_sequence_id)
1974: WHERE process_flag = 1
1975: AND UPPER(transaction_type) = G_TXN_UPDATE
1976: AND Request_Id = p_request_id

Line 1980: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);

1976: AND Request_Id = p_request_id
1977: AND (p_batch_id IS NULL OR batch_id = p_batch_id)
1978: AND assembly_item_id = p_assembly_item_id
1979: AND organization_id = p_organization_id
1980: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);
1981: END IF;
1982: END IF;
1983:
1984: --Error_Handler.Write_Debug('EBI: Updated the Process_Status to Indicate Succssful/Unsucessful completion.');