DBA Data[Home] [Help]

APPS.ENG_ROUTING_PKG dependencies on ENG_BOM_RTG_TRANSFER_PKG

Line 75: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'ROUTING_UPDATE',

71: END IF;
72:
73: EXCEPTION
74: WHEN OTHERS THEN
75: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'ROUTING_UPDATE',
76: stmt_num => X_stmt_num,
77: message_name => 'ENG_ENUBRT_ERROR',
78: token => SQLERRM);
79:

Line 259: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'ROUTING_TRANSFER',

255: OR
256: X_designator_option = 1);
257: EXCEPTION
258: WHEN OTHERS THEN
259: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'ROUTING_TRANSFER',
260: stmt_num => X_stmt_num,
261: message_name => 'ENG_ENUBRT_ERROR',
262: token => SQLERRM);
263: END;

Line 271: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN

267: /* THIS ERES CALL IS NOT MOVED TO A PLACE BELOW.
268: -- ERES BEGIN
269: -- If there is a parent eRecord, log a child record to accompany it
270: -- ================================================================
271: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN
272: FOR ROUTING IN RTG_COPIES LOOP
273: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
274: ( p_event_name =>'oracle.apps.bom.routingCreate'
275: , p_event_key =>to_char(ROUTING.routing_sequence_id)

Line 273: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord

269: -- If there is a parent eRecord, log a child record to accompany it
270: -- ================================================================
271: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN
272: FOR ROUTING IN RTG_COPIES LOOP
273: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
274: ( p_event_name =>'oracle.apps.bom.routingCreate'
275: , p_event_key =>to_char(ROUTING.routing_sequence_id)
276: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
277: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||ROUTING.alternate_routing_designator

Line 276: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME

272: FOR ROUTING IN RTG_COPIES LOOP
273: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
274: ( p_event_name =>'oracle.apps.bom.routingCreate'
275: , p_event_key =>to_char(ROUTING.routing_sequence_id)
276: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
277: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||ROUTING.alternate_routing_designator
278: , p_parent_event_key =>to_char(X_eng_item_id)||'-'||to_char(X_org_id)
279: ||'-'||to_char(X_mfg_item_id)
280: );

Line 277: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||ROUTING.alternate_routing_designator

273: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
274: ( p_event_name =>'oracle.apps.bom.routingCreate'
275: , p_event_key =>to_char(ROUTING.routing_sequence_id)
276: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
277: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||ROUTING.alternate_routing_designator
278: , p_parent_event_key =>to_char(X_eng_item_id)||'-'||to_char(X_org_id)
279: ||'-'||to_char(X_mfg_item_id)
280: );
281: END LOOP;

Line 299: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'ROUTING_TRANSFER',

295: AND ASSEMBLY_ITEM_ID = X_eng_item_id
296: AND NVL(ALTERNATE_ROUTING_DESIGNATOR,'NONE') = NVL(RTG.ALTERNATE_ROUTING_DESIGNATOR,'NONE');
297: EXCEPTION
298: WHEN OTHERS THEN
299: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'ROUTING_TRANSFER',
300: stmt_num => X_stmt_num,
301: message_name => 'ENG_ENUBRT_ERROR',
302: token => SQLERRM);
303: END;

Line 328: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN

324: -- in order to get the routing revisions.
325: -- ERES BEGIN
326: -- If there is a parent eRecord, log a child record to accompany it
327: -- ================================================================
328: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN
329: FOR ROUTING IN RTG_COPIES LOOP
330: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
331: ( p_event_name =>'oracle.apps.bom.routingCreate'
332: , p_event_key =>to_char(ROUTING.routing_sequence_id)

Line 330: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord

326: -- If there is a parent eRecord, log a child record to accompany it
327: -- ================================================================
328: IF ENG_BOM_RTG_TRANSFER_PKG.G_PARENT_ERECORD_ID is NOT NULL THEN
329: FOR ROUTING IN RTG_COPIES LOOP
330: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
331: ( p_event_name =>'oracle.apps.bom.routingCreate'
332: , p_event_key =>to_char(ROUTING.routing_sequence_id)
333: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
334: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||ROUTING.alternate_routing_designator

Line 333: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME

329: FOR ROUTING IN RTG_COPIES LOOP
330: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
331: ( p_event_name =>'oracle.apps.bom.routingCreate'
332: , p_event_key =>to_char(ROUTING.routing_sequence_id)
333: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
334: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||ROUTING.alternate_routing_designator
335: , p_parent_event_key =>to_char(X_eng_item_id)||'-'||to_char(X_org_id)
336: ||'-'||to_char(X_mfg_item_id)
337: );

Line 334: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||ROUTING.alternate_routing_designator

330: ENG_BOM_RTG_TRANSFER_PKG.Process_Erecord
331: ( p_event_name =>'oracle.apps.bom.routingCreate'
332: , p_event_key =>to_char(ROUTING.routing_sequence_id)
333: , p_user_key =>ENG_BOM_RTG_TRANSFER_PKG.G_ITEM_NAME
334: ||'-'||ENG_BOM_RTG_TRANSFER_PKG.G_ORG_CODE||'-'||ROUTING.alternate_routing_designator
335: , p_parent_event_key =>to_char(X_eng_item_id)||'-'||to_char(X_org_id)
336: ||'-'||to_char(X_mfg_item_id)
337: );
338: END LOOP;