102: WHERE INVENTORY_ITEM_ID = X_eng_item_id
103: AND ORGANIZATION_ID = X_org_id;
104: EXCEPTION
105: WHEN OTHERS THEN
106: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'ITEM_TRANSFER',
107: stmt_num => X_stmt_num,
108: message_name => 'ENG_ENUBRT_ERROR',
109: token => SQLERRM);
110: END;
120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN
122: X_master_org := X_org_id;
123: WHEN OTHERS THEN
124: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'ITEM_TRANSFER',
125: stmt_num => X_stmt_num,
126: message_name => 'ENG_ENUBRT_ERROR',
127: token => SQLERRM);
128: END;
151: AND ORGANIZATION_ID = X_master_org
152: AND ENG_ITEM_FLAG <> 'N';
153: EXCEPTION
154: WHEN OTHERS THEN
155: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'ITEM_TRANSFER',
156: stmt_num => X_stmt_num,
157: message_name => 'ENG_ENUBRT_ERROR',
158: token => SQLERRM);
159: END;
169: EXCEPTION
170: WHEN NO_DATA_FOUND THEN
171: X_master_org := X_org_id;
172: WHEN OTHERS THEN
173: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'ITEM_TRANSFER',
174: stmt_num => X_stmt_num,
175: message_name => 'ENG_ENUBRT_ERROR',
176: token => SQLERRM);
177: END;
573:
574:
575: EXCEPTION
576: WHEN OTHERS THEN
577: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'COMPONENT_TRANSFER',
578: stmt_num => X_stmt_num,
579: message_name => 'ENG_ENUBRT_ERROR',
580: token => SQLERRM);
581: END;
612:
613:
614: EXCEPTION
615: WHEN OTHERS THEN
616: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'COMPONENT_TRANSFER',
617: stmt_num => X_stmt_num,
618: message_name => 'ENG_ENUBRT_ERROR',
619: token => SQLERRM);
620: END;
632: EXCEPTION
633: WHEN NO_DATA_FOUND THEN
634: X_master_org := X_org_id;
635: WHEN OTHERS THEN
636: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'COMPONENT_TRANSFER',
637: stmt_num => X_stmt_num,
638: message_name => 'ENG_ENUBRT_ERROR',
639: token => SQLERRM);
640: END;
663:
664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'COMPONENT_TRANSFER',
668: stmt_num => X_stmt_num,
669: message_name => 'ENG_ENUBRT_ERROR',
670: token => SQLERRM);
671: END;
795: END IF;
796:
797: EXCEPTION
798: WHEN OTHERS THEN
799: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'SET_OP_SEQ',
800: stmt_num => X_stmt_num,
801: message_name => 'ENG_ENUBRT_ERROR',
802: token => SQLERRM);
803: END;
823: WHEN DUP_VAL_ON_INDEX THEN
824: FND_MESSAGE.SET_NAME('ENG', 'ENG_COMP_OP_COMBINATION');
825: APP_EXCEPTION.RAISE_EXCEPTION;
826: WHEN OTHERS THEN
827: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'SET_OP_SEQ',
828: stmt_num => X_stmt_num,
829: message_name => 'ENG_ENUBRT_ERROR',
830: token => SQLERRM);
831: END;
867: AND NVL(BIC.DISABLE_DATE - 1, BIC2.EFFECTIVITY_DATE + 1)))
868: );
869: EXCEPTION
870: WHEN OTHERS THEN
871: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'SET_OP_SEQ',
872: stmt_num => X_stmt_num,
873: message_name => 'ENG_ENUBRT_ERROR',
874: token => SQLERRM);
875: END;
914: OR
915: (X_designator_option = 1)));
916: EXCEPTION
917: WHEN OTHERS THEN
918: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'SET_OP_SEQ',
919: stmt_num => X_stmt_num,
920: message_name => 'ENG_ENUBRT_ERROR',
921: token => SQLERRM);
922: END;