DBA Data[Home] [Help]

APPS.ENG_BOM_PKG dependencies on ENG_BOM_RTG_TRANSFER_PKG

Line 134: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'BOM_UPDATE',

130: );
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
134: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'BOM_UPDATE',
135: stmt_num => X_stmt_num,
136: message_name => 'ENG_ENUBRT_ERROR',
137: token => SQLERRM);
138:

Line 328: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'BOM_TRANSFER',

324:
325:
326: EXCEPTION
327: WHEN OTHERS THEN
328: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'BOM_TRANSFER',
329: stmt_num => X_stmt_num,
330: message_name => 'ENG_ENUBRT_ERROR',
331: token => SQLERRM);
332: END;

Line 339: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN

335: /* THIS ERES CALL IS NOT MOVED TO A PLACE BELOW.
336: -- ERES BEGIN
337: -- If there is a parent eRecord, log a child record to accompany it
338: -- ================================================================
339: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN
340: FOR BILL IN BOM_COPIES LOOP -- BUG 3503220
341: -- Log an erecord for each new bill inserted above -- BUG 3503220
342:
343: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord

Line 343: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord

339: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN
340: FOR BILL IN BOM_COPIES LOOP -- BUG 3503220
341: -- Log an erecord for each new bill inserted above -- BUG 3503220
342:
343: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
344: ( p_event_name =>'oracle.apps.bom.billCreate'
345: , p_event_key =>to_char(BILL.bill_sequence_id)
346: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
347: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||BILL.alternate_bom_designator

Line 346: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME

342:
343: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
344: ( p_event_name =>'oracle.apps.bom.billCreate'
345: , p_event_key =>to_char(BILL.bill_sequence_id)
346: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
347: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||BILL.alternate_bom_designator
348: , p_parent_event_key =>to_char(X_eng_item_id)||'-'||to_char(X_org_id)
349: ||'-'||to_char(X_mfg_item_id)
350: );

Line 347: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||BILL.alternate_bom_designator

343: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
344: ( p_event_name =>'oracle.apps.bom.billCreate'
345: , p_event_key =>to_char(BILL.bill_sequence_id)
346: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
347: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||BILL.alternate_bom_designator
348: , p_parent_event_key =>to_char(X_eng_item_id)||'-'||to_char(X_org_id)
349: ||'-'||to_char(X_mfg_item_id)
350: );
351: END LOOP;

Line 369: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'BOM_TRANSFER',

365: AND ASSEMBLY_ITEM_ID = X_eng_item_id
366: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(BOM1.ALTERNATE_BOM_DESIGNATOR,'NONE');
367: EXCEPTION
368: WHEN OTHERS THEN
369: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'BOM_TRANSFER',
370: stmt_num => X_stmt_num,
371: message_name => 'ENG_ENUBRT_ERROR',
372: token => SQLERRM);
373: END;

Line 432: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN

428: -- in order to get the routing revisions.
429: -- ERES BEGIN
430: -- If there is a parent eRecord, log a child record to accompany it
431: -- ================================================================
432: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN
433: FOR BILL IN BOM_COPIES LOOP -- BUG 3503220
434: -- Log an erecord for each new bill inserted above -- BUG 3503220
435:
436: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord

Line 436: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord

432: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN
433: FOR BILL IN BOM_COPIES LOOP -- BUG 3503220
434: -- Log an erecord for each new bill inserted above -- BUG 3503220
435:
436: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
437: ( p_event_name =>'oracle.apps.bom.billCreate'
438: , p_event_key =>to_char(BILL.bill_sequence_id)
439: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
440: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||BILL.alternate_bom_designator

Line 439: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME

435:
436: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
437: ( p_event_name =>'oracle.apps.bom.billCreate'
438: , p_event_key =>to_char(BILL.bill_sequence_id)
439: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
440: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||BILL.alternate_bom_designator
441: , p_parent_event_key =>to_char(X_eng_item_id)||'-'||to_char(X_org_id)
442: ||'-'||to_char(X_mfg_item_id)
443: );

Line 440: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||BILL.alternate_bom_designator

436: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
437: ( p_event_name =>'oracle.apps.bom.billCreate'
438: , p_event_key =>to_char(BILL.bill_sequence_id)
439: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
440: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||BILL.alternate_bom_designator
441: , p_parent_event_key =>to_char(X_eng_item_id)||'-'||to_char(X_org_id)
442: ||'-'||to_char(X_mfg_item_id)
443: );
444: END LOOP;