788: EXCEPTION
789: WHEN OTHERS THEN
790: rollback;
791: err_text := 'Cancel_Eco' || '(' || stmt_num || ')' || SQLERRM;
792: FND_MESSAGE.SET_NAME('BOM', 'BOM_SQL_ERR');
793: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
794: APP_EXCEPTION.RAISE_EXCEPTION;
795: END Cancel_ECO;
796:
789: WHEN OTHERS THEN
790: rollback;
791: err_text := 'Cancel_Eco' || '(' || stmt_num || ')' || SQLERRM;
792: FND_MESSAGE.SET_NAME('BOM', 'BOM_SQL_ERR');
793: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
794: APP_EXCEPTION.RAISE_EXCEPTION;
795: END Cancel_ECO;
796:
797: Procedure Cancel_Revised_Item (
1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: rollback;
1131: err_text := 'Cancel_Revised_Item' || '(' || stmt_num || ')' || SQLERRM;
1132: FND_MESSAGE.SET_NAME('BOM', 'BOM_SQL_ERR');
1133: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
1134: APP_EXCEPTION.RAISE_EXCEPTION;
1135: END Cancel_Revised_Item;
1136:
1129: WHEN OTHERS THEN
1130: rollback;
1131: err_text := 'Cancel_Revised_Item' || '(' || stmt_num || ')' || SQLERRM;
1132: FND_MESSAGE.SET_NAME('BOM', 'BOM_SQL_ERR');
1133: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
1134: APP_EXCEPTION.RAISE_EXCEPTION;
1135: END Cancel_Revised_Item;
1136:
1137: Procedure Cancel_Revised_Component (
1313: WHEN OTHERS THEN
1314: rollback;
1315: err_text := 'Cancel_Revised_Component' || '(' || stmt_num || ')' ||
1316: SQLERRM;
1317: FND_MESSAGE.SET_NAME('BOM', 'BOM_SQL_ERR');
1318: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
1319: APP_EXCEPTION.RAISE_EXCEPTION;
1320: END Cancel_Revised_Component;
1321:
1314: rollback;
1315: err_text := 'Cancel_Revised_Component' || '(' || stmt_num || ')' ||
1316: SQLERRM;
1317: FND_MESSAGE.SET_NAME('BOM', 'BOM_SQL_ERR');
1318: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
1319: APP_EXCEPTION.RAISE_EXCEPTION;
1320: END Cancel_Revised_Component;
1321:
1322: /*
1341: EXCEPTION
1342: WHEN OTHERS THEN
1343: rollback;
1344: err_text := 'Change_Attachment_Status' || '(' || ')' || SQLERRM;
1345: FND_MESSAGE.SET_NAME('BOM', 'BOM_SQL_ERR');
1346: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
1347: APP_EXCEPTION.RAISE_EXCEPTION;
1348: END Change_Att_Status;
1349:
1342: WHEN OTHERS THEN
1343: rollback;
1344: err_text := 'Change_Attachment_Status' || '(' || ')' || SQLERRM;
1345: FND_MESSAGE.SET_NAME('BOM', 'BOM_SQL_ERR');
1346: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
1347: APP_EXCEPTION.RAISE_EXCEPTION;
1348: END Change_Att_Status;
1349:
1350: /**
1375: WHEN OTHERS THEN
1376:
1377: rollback;
1378: err_text := 'delete_Revised_Item' || '(' || stmt_num || ')' || SQLERRM;
1379: FND_MESSAGE.SET_NAME('ENG', 'BOM_SQL_ERR');
1380: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
1381: APP_EXCEPTION.RAISE_EXCEPTION;
1382: END Delete_Revised_Item;
1383:
1376:
1377: rollback;
1378: err_text := 'delete_Revised_Item' || '(' || stmt_num || ')' || SQLERRM;
1379: FND_MESSAGE.SET_NAME('ENG', 'BOM_SQL_ERR');
1380: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
1381: APP_EXCEPTION.RAISE_EXCEPTION;
1382: END Delete_Revised_Item;
1383:
1384: /**
1398: EXCEPTION
1399: WHEN OTHERS THEN
1400: rollback;
1401: err_text := 'Delete_Pending_structure, ' || SQLERRM;
1402: FND_MESSAGE.SET_NAME('ENG', 'BOM_SQL_ERR');
1403: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
1404: APP_EXCEPTION.RAISE_EXCEPTION;
1405: END Delete_Pending_structure;
1406:
1399: WHEN OTHERS THEN
1400: rollback;
1401: err_text := 'Delete_Pending_structure, ' || SQLERRM;
1402: FND_MESSAGE.SET_NAME('ENG', 'BOM_SQL_ERR');
1403: FND_MESSAGE.SET_TOKEN('ENTITY', err_text);
1404: APP_EXCEPTION.RAISE_EXCEPTION;
1405: END Delete_Pending_structure;
1406:
1407: