DBA Data[Home] [Help]

APPS.EAM_EXPLODE_ACTIVITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 484: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Starting Activity Explosion'); end if;

480:
481: BEGIN
482:
483:
484: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Starting Activity Explosion'); end if;
485:
486:
487: -- **************************** OPERATIONS ******************
488: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Exploding Operations'); end if;

Line 488: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Exploding Operations'); end if;

484: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Starting Activity Explosion'); end if;
485:
486:
487: -- **************************** OPERATIONS ******************
488: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Exploding Operations'); end if;
489: FOR oprec IN ActivityOP LOOP
490:
491: j:=j+1; --counter for operations
492: l_eam_op_tbl(j).BATCH_ID :=oprec.BATCH_ID;

Line 534: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Exploding Resource Requirements'); end if;

530:
531:
532:
533: -- **************************** RESOURCES ******************
534: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Exploding Resource Requirements'); end if;
535: FOR resrec IN ActivityRES LOOP
536:
537:
538: k:=k+1; --counter for resources

Line 586: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Exploding Operation Networks'); end if;

582: END LOOP;
583:
584:
585: -- **************************** OPERATION NETWORKS ******************
586: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Exploding Operation Networks'); end if;
587: FOR opnetworkrec IN ActivityOPN LOOP
588:
589: m:=m+1; --counter for operation networks
590:

Line 618: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Exploding Material Requirements'); end if;

614: l_eam_op_network_tbl(m).TRANSACTION_TYPE := opnetworkrec.TRANSACTION_TYPE;
615: END LOOP;
616:
617:
618: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Exploding Material Requirements'); end if;
619:
620: BEGIN
621:
622: --delete any previous explosions as effectivity/disable dates could be changed

Line 633: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Explosion Group Id = ' || l_group_id); end if;

629: from dual;
630:
631:
632:
633: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Explosion Group Id = ' || l_group_id); end if;
634:
635:
636: bompexpl.exploder_userexit
637: ( item_id => l_eam_wo_rec.asset_activity_id

Line 667: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Fetching ' || matreqrec.INVENTORY_ITEM_ID); end if;

663: end if;
664:
665: n := n + 1;
666:
667: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Fetching ' || matreqrec.INVENTORY_ITEM_ID); end if;
668:
669: l_eam_mat_req_tbl(n).BATCH_ID := matreqrec.BATCH_ID;
670: l_eam_mat_req_tbl(n).HEADER_ID := matreqrec.HEADER_ID;
671: l_eam_mat_req_tbl(n).WIP_ENTITY_ID := matreqrec.WIP_ENTITY_ID;

Line 805: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Activity Explosion completed'); end if;

801:
802: end;
803:
804:
805: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Activity Explosion completed'); end if;
806:
807: begin
808:
809: select bill_sequence_id

Line 822: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('BOM not present hence no attachments need to be copied from Activity BOM'); end if;

818: -- Fix for Bug 2787347 Activities having routing and no BOM are failing
819: exception
820:
821: when others then
822: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('BOM not present hence no attachments need to be copied from Activity BOM'); end if;
823:
824: x_return_status := fnd_api.g_ret_sts_success;
825:
826: -- Fix for Bug 2787347 Activities having routing and no BOM are failing

Line 831: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Coping attachment'); end if;

827:
828: end;
829:
830:
831: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Coping attachment'); end if;
832:
833: COPY_ATTACHMENT
834: ( p_organization_id => l_eam_wo_rec.organization_id
835: , p_asset_activity_id => l_eam_wo_rec.asset_activity_id