APPS.BOM_BULKLOAD_PVT_PKG dependencies on FND_API

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

138: );
139:
140: 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);
141:
142: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
143: FND_FILE.put_line(FND_FILE.LOG, 'Unable to open error log file. Error => '||l_errbuff);
144: END IF;
145:
146: END IF;--IF c_get_utl_file_dir%FOUND THEN

Line 199: RETURN FND_API.G_MISS_NUM;

195: EXCEPTION
196: WHEN NO_DATA_FOUND THEN
197: RETURN NULL;
198: WHEN OTHERS THEN
199: RETURN FND_API.G_MISS_NUM;
200: END GET_ORGANIZATION_ID;
201:
202:
203: /*******************************************************************

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

1849: INTO l_Bill_Sequence_id, l_Common_Bill_Sequence_Id, l_Source_Bill_Sequence_Id
1850: FROM BOM_STRUCTURES_B
1851: WHERE assembly_item_id = p_assembly_item_id
1852: AND organization_id = p_organization_id
1853: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);
1854:
1855: IF (l_Bill_Sequence_id <> l_Common_Bill_Sequence_Id) THEN
1856:
1857: l_Component_Count := 0;

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

1863: AND Request_Id = p_request_id
1864: AND (p_batch_id IS NULL OR batch_id = p_batch_id)
1865: AND assembly_item_id = p_assembly_item_id
1866: AND organization_id = p_organization_id
1867: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);
1868:
1869: IF (l_Component_Count > 0) THEN
1870: -- Dereference the Bill Header
1871: BOMPCMBM.Dereference_Header( p_bill_sequence_id => l_Bill_Sequence_id);

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

1878: FROM BOM_INVENTORY_COMPONENTS BIC, bom_structures_b bsb
1879: WHERE BIC.bill_sequence_id = bsb.bill_Sequence_id
1880: AND bsb.assembly_item_id = p_assembly_item_id
1881: AND bsb.organization_id = p_organization_id
1882: AND NVL(bsb.alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR)
1883: AND BIC.common_component_sequence_id = BICI.component_sequence_id)
1884: WHERE process_flag = 1
1885: AND UPPER(transaction_type) = G_TXN_UPDATE
1886: AND Request_Id = p_request_id

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

1886: AND Request_Id = p_request_id
1887: AND (p_batch_id IS NULL OR batch_id = p_batch_id)
1888: AND assembly_item_id = p_assembly_item_id
1889: AND organization_id = p_organization_id
1890: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);
1891: END IF;
1892: END IF;
1893:
1894: --Error_Handler.Write_Debug('EBI: Updated the Process_Status to Indicate Succssful/Unsucessful completion.');