DBA Data[Home] [Help]

APPS.BOMPKMUD dependencies on FND_API

Line 121: x_return_status := FND_API.G_FALSE;

117: RAISE_ERES_EVENT_ERROR EXCEPTION;
118: SEND_ACKN_ERROR EXCEPTION;
119: BEGIN
120:
121: x_return_status := FND_API.G_FALSE;
122:
123: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning the ERES part for org_id='||p_organization_id||', change_notice='||p_change_notice);
124:
125: -- Get Parent Event record id :

Line 129: , p_init_msg_list => FND_API.G_TRUE

125: -- Get Parent Event record id :
126: -- The error is not trapped, so that the execution can carry on.
127: QA_EDR_STANDARD.GET_ERECORD_ID
128: ( p_api_version => 1.0
129: , p_init_msg_list => FND_API.G_TRUE
130: , x_return_status => x_return_status
131: , x_msg_count => x_msg_count
132: , x_msg_data => l_msg_data
133: , p_event_name => 'oracle.apps.eng.massChangeBill'

Line 191: , p_init_msg_list => FND_API.G_FALSE

187: l_event.event_status := l_event_status;
188:
189: QA_EDR_STANDARD.RAISE_ERES_EVENT
190: ( p_api_version => 1.0
191: , p_init_msg_list => FND_API.G_FALSE
192: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
193: , x_return_status => x_return_status
194: , x_msg_count => x_msg_count
195: , x_msg_data => l_msg_data

Line 192: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

188:
189: QA_EDR_STANDARD.RAISE_ERES_EVENT
190: ( p_api_version => 1.0
191: , p_init_msg_list => FND_API.G_FALSE
192: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
193: , x_return_status => x_return_status
194: , x_msg_count => x_msg_count
195: , x_msg_data => l_msg_data
196: , p_child_erecords => l_child_record

Line 199: IF (NVL(x_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)

195: , x_msg_data => l_msg_data
196: , p_child_erecords => l_child_record
197: , x_event => l_event);
198:
199: IF (NVL(x_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
200: AND (x_msg_count > 0)
201: THEN
202: RAISE RAISE_ERES_EVENT_ERROR;
203:

Line 228: , p_init_msg_list => FND_API.G_FALSE

224: l_ackn_by := FND_MESSAGE.GET;
225:
226: QA_EDR_STANDARD.SEND_ACKN
227: ( p_api_version => 1.0
228: , p_init_msg_list => FND_API.G_FALSE
229: , x_return_status => x_return_status
230: , x_msg_count => x_msg_count
231: , x_msg_data => l_msg_data
232: , p_event_name => l_event.event_name

Line 238: , p_autonomous_commit => FND_API.G_FALSE);

234: , p_erecord_id => l_event.erecord_id
235: , p_trans_status => l_trans_status
236: , p_ackn_by => l_ackn_by
237: , p_ackn_note => '(organization_id, change_notice)='||TO_CHAR(p_organization_id)||', '||p_change_notice||')'
238: , p_autonomous_commit => FND_API.G_FALSE);
239:
240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||x_msg_count);
241: IF (NVL(x_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
242: AND (x_msg_count > 0)

Line 241: IF (NVL(x_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)

237: , p_ackn_note => '(organization_id, change_notice)='||TO_CHAR(p_organization_id)||', '||p_change_notice||')'
238: , p_autonomous_commit => FND_API.G_FALSE);
239:
240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'After QA_EDR_STANDARD.SEND_ACKN msg='||x_msg_count);
241: IF (NVL(x_return_status, FND_API.G_FALSE) <> FND_API.G_TRUE)
242: AND (x_msg_count > 0)
243: THEN
244: RAISE SEND_ACKN_ERROR;
245: END IF;

Line 257: p_encoded => FND_API.G_FALSE,

253: -- Get the message and raise the procedure exception.
254: FND_MSG_PUB.Get(
255: p_msg_index => 1,
256: p_data => l_message,
257: p_encoded => FND_API.G_FALSE,
258: p_msg_index_out => l_dummy_cnt);
259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error='||l_message);
260:
261: WHEN SEND_ACKN_ERROR THEN

Line 267: p_encoded => FND_API.G_FALSE,

263: -- Get the message and raise the procedure exception.
264: FND_MSG_PUB.Get(
265: p_msg_index => 1,
266: p_data => l_message,
267: p_encoded => FND_API.G_FALSE,
268: p_msg_index_out => l_dummy_cnt);
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error='||l_message);
270:
271: WHEN OTHERS THEN

Line 381: AND (Nvl(c.basis_type,4) = Decode(ci.basis_type, FND_API.G_MISS_NUM,4,ci.basis_type) -- 5214239

377: AND ( (l.alternate_designator IS NULL AND b.alternate_bom_designator IS NULL)
378: OR (b.alternate_bom_designator = l.alternate_designator) )
379: AND (c.item_num = ci.item_num
380: OR ci.item_num IS NULL)
381: AND (Nvl(c.basis_type,4) = Decode(ci.basis_type, FND_API.G_MISS_NUM,4,ci.basis_type) -- 5214239
382: OR ci.basis_type is NULL)
383: AND (c.component_quantity = ci.component_quantity
384: OR ci.component_quantity IS NULL)
385: AND (c.component_yield_factor = ci.component_yield_factor

Line 1266: OR i.inventory_item_status_code = nvl(bp.bom_delete_status_code, FND_API.G_MISS_CHAR)

1262: FROM eng_revised_items_interface r,
1263: mtl_system_items_b i,
1264: bom_parameters bp
1265: WHERE (i.inventory_item_status_code in ('Obsolete','Inactive')
1266: OR i.inventory_item_status_code = nvl(bp.bom_delete_status_code, FND_API.G_MISS_CHAR)
1267: OR i.bom_enabled_flag = 'N' )-- Modified for bug 13362684
1268: AND i.organization_id = bp.organization_id -- Added for bug 13362684
1269: AND i.organization_id = r.organization_id
1270: AND i.inventory_item_id = l.assembly_item_id

Line 1551: AND (Nvl(c.basis_type,4) = Decode(o.basis_type,FND_API.G_MISS_NUM,4,o.basis_type) OR o.basis_type is NULL) -- 5214239

1547: bom_inventory_components c,
1548: bom_inventory_comps_interface o,
1549: eng_revised_items_interface ri
1550: WHERE (c.item_num = o.item_num OR o.item_num IS NULL)
1551: AND (Nvl(c.basis_type,4) = Decode(o.basis_type,FND_API.G_MISS_NUM,4,o.basis_type) OR o.basis_type is NULL) -- 5214239
1552: AND (c.component_quantity = o.component_quantity OR
1553: o.component_quantity IS NULL)
1554: AND (c.component_yield_factor = o.component_yield_factor OR
1555: o.component_yield_factor IS NULL)

Line 1696: AND (Nvl(c.basis_type,4) = Decode(o.basis_type,FND_API.G_MISS_NUM,4,o.basis_type) OR o.basis_type IS NULL) -- 5214239

1692: eng_revised_items_interface ri
1693: WHERE n.old_component_sequence_id = o.component_sequence_id
1694: AND (n.component_item_id <> o.component_item_id)
1695: AND (c.item_num = o.item_num OR o.item_num IS NULL)
1696: AND (Nvl(c.basis_type,4) = Decode(o.basis_type,FND_API.G_MISS_NUM,4,o.basis_type) OR o.basis_type IS NULL) -- 5214239
1697: AND (c.component_quantity = o.component_quantity OR
1698: o.component_quantity IS NULL)
1699: AND (c.component_yield_factor = o.component_yield_factor OR
1700: o.component_yield_factor IS NULL)

Line 1839: c.wip_supply_type, FND_API.G_MISS_NUM)) wip_supply_type, /* bug fix : 9019348 */

1835: ecg_action_change,
1836: ecg_action_add) acd_type,
1837: NVL(n.wip_supply_type,
1838: DECODE(o.wip_supply_type, NULL,
1839: c.wip_supply_type, FND_API.G_MISS_NUM)) wip_supply_type, /* bug fix : 9019348 */
1840: NVL(n.supply_subinventory,
1841: DECODE(o.supply_subinventory,
1842: NULL,
1843: c.supply_subinventory,

Line 1844: FND_API.G_MISS_CHAR)) supply_subinventory,

1840: NVL(n.supply_subinventory,
1841: DECODE(o.supply_subinventory,
1842: NULL,
1843: c.supply_subinventory,
1844: FND_API.G_MISS_CHAR)) supply_subinventory,
1845: NVL(n.supply_locator_id,
1846: DECODE(o.supply_locator_id,
1847: NULL,
1848: c.supply_locator_id,

Line 1849: FND_API.G_MISS_NUM)) supply_locator_id,

1845: NVL(n.supply_locator_id,
1846: DECODE(o.supply_locator_id,
1847: NULL,
1848: c.supply_locator_id,
1849: FND_API.G_MISS_NUM)) supply_locator_id,
1850: DECODE(n.component_item_id,
1851: o.component_item_id,
1852: c.from_end_item_unit_number,
1853: NULL) old_from_end_item_unit_number,

Line 1890: AND (Nvl(c.basis_type,4) = Decode(o.basis_type,FND_API.G_MISS_NUM,4,o.basis_type) OR o.basis_type is NULL) -- 5214239

1886: bom_inventory_comps_interface o, -- old attributes
1887: eng_revised_items_interface ri
1888: WHERE n.old_component_sequence_id = o.component_sequence_id
1889: AND (c.item_num = o.item_num OR o.item_num IS NULL)
1890: AND (Nvl(c.basis_type,4) = Decode(o.basis_type,FND_API.G_MISS_NUM,4,o.basis_type) OR o.basis_type is NULL) -- 5214239
1891: AND (c.component_quantity = o.component_quantity OR
1892: o.component_quantity IS NULL)
1893: AND (c.component_yield_factor = o.component_yield_factor OR
1894: o.component_yield_factor IS NULL)