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 380: AND (Nvl(c.basis_type,4) = Decode(ci.basis_type, FND_API.G_MISS_NUM,4,ci.basis_type) -- 5214239

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

Line 1546: 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

1542: bom_inventory_components c,
1543: bom_inventory_comps_interface o,
1544: eng_revised_items_interface ri
1545: WHERE (c.item_num = o.item_num OR o.item_num IS NULL)
1546: 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: AND (c.component_quantity = o.component_quantity OR
1548: o.component_quantity IS NULL)
1549: AND (c.component_yield_factor = o.component_yield_factor OR
1550: o.component_yield_factor IS NULL)

Line 1691: 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

1687: eng_revised_items_interface ri
1688: WHERE n.old_component_sequence_id = o.component_sequence_id
1689: AND (n.component_item_id <> o.component_item_id)
1690: AND (c.item_num = o.item_num OR o.item_num IS NULL)
1691: 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: AND (c.component_quantity = o.component_quantity OR
1693: o.component_quantity IS NULL)
1694: AND (c.component_yield_factor = o.component_yield_factor OR
1695: o.component_yield_factor IS NULL)

Line 1839: FND_API.G_MISS_CHAR)) supply_subinventory,

1835: NVL(n.supply_subinventory,
1836: DECODE(o.supply_subinventory,
1837: NULL,
1838: c.supply_subinventory,
1839: FND_API.G_MISS_CHAR)) supply_subinventory,
1840: NVL(n.supply_locator_id,
1841: DECODE(o.supply_locator_id,
1842: NULL,
1843: c.supply_locator_id,

Line 1844: FND_API.G_MISS_NUM)) supply_locator_id,

1840: NVL(n.supply_locator_id,
1841: DECODE(o.supply_locator_id,
1842: NULL,
1843: c.supply_locator_id,
1844: FND_API.G_MISS_NUM)) supply_locator_id,
1845: DECODE(n.component_item_id,
1846: o.component_item_id,
1847: c.from_end_item_unit_number,
1848: NULL) old_from_end_item_unit_number,

Line 1885: 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

1881: bom_inventory_comps_interface o, -- old attributes
1882: eng_revised_items_interface ri
1883: WHERE n.old_component_sequence_id = o.component_sequence_id
1884: AND (c.item_num = o.item_num OR o.item_num IS NULL)
1885: 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: AND (c.component_quantity = o.component_quantity OR
1887: o.component_quantity IS NULL)
1888: AND (c.component_yield_factor = o.component_yield_factor OR
1889: o.component_yield_factor IS NULL)