330:
331: WHEN fnd_api.g_exc_error THEN
332: X_retcode := FND_API.g_ret_sts_error;
333: IF l_errorLog THEN
334: fnd_message.set_name('BOM','CST_ERROR');
335: fnd_message.set_token('SQLERRM',SQLERRM);
336: fnd_msg_pub.add;
337: fnd_log.message(
338: fnd_log.level_error,
331: WHEN fnd_api.g_exc_error THEN
332: X_retcode := FND_API.g_ret_sts_error;
333: IF l_errorLog THEN
334: fnd_message.set_name('BOM','CST_ERROR');
335: fnd_message.set_token('SQLERRM',SQLERRM);
336: fnd_msg_pub.add;
337: fnd_log.message(
338: fnd_log.level_error,
339: l_module||'.'||l_stmt_num,
345:
346: WHEN OTHERS THEN
347: X_retcode := FND_API.g_ret_sts_unexp_error;
348: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
349: fnd_message.set_name('BOM','CST_UNEXPECTED');
350: fnd_message.set_token('SQLERRM',SQLERRM);
351: fnd_msg_pub.add;
352: fnd_log.message(
353: fnd_log.level_unexpected,
346: WHEN OTHERS THEN
347: X_retcode := FND_API.g_ret_sts_unexp_error;
348: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
349: fnd_message.set_name('BOM','CST_UNEXPECTED');
350: fnd_message.set_token('SQLERRM',SQLERRM);
351: fnd_msg_pub.add;
352: fnd_log.message(
353: fnd_log.level_unexpected,
354: l_module||'.'||l_stmt_num,
553:
554: WHEN fnd_api.g_exc_error THEN
555: X_retcode := FND_API.g_ret_sts_error;
556: IF l_errorLog THEN
557: fnd_message.set_name('BOM','CST_ERROR');
558: fnd_message.set_token('SQLERRM',SQLERRM);
559: fnd_msg_pub.add;
560: fnd_log.message(
561: fnd_log.level_error,
554: WHEN fnd_api.g_exc_error THEN
555: X_retcode := FND_API.g_ret_sts_error;
556: IF l_errorLog THEN
557: fnd_message.set_name('BOM','CST_ERROR');
558: fnd_message.set_token('SQLERRM',SQLERRM);
559: fnd_msg_pub.add;
560: fnd_log.message(
561: fnd_log.level_error,
562: l_module||'.'||l_stmt_num,
568:
569: WHEN OTHERS THEN
570: X_retcode := FND_API.g_ret_sts_unexp_error;
571: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
572: fnd_message.set_name('BOM','CST_UNEXPECTED');
573: fnd_message.set_token('SQLERRM',SQLERRM);
574: fnd_msg_pub.add;
575: fnd_log.message(
576: fnd_log.level_unexpected,
569: WHEN OTHERS THEN
570: X_retcode := FND_API.g_ret_sts_unexp_error;
571: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
572: fnd_message.set_name('BOM','CST_UNEXPECTED');
573: fnd_message.set_token('SQLERRM',SQLERRM);
574: fnd_msg_pub.add;
575: fnd_log.message(
576: fnd_log.level_unexpected,
577: l_module||'.'||l_stmt_num,
775:
776: WHEN fnd_api.g_exc_error THEN
777: X_retcode := FND_API.g_ret_sts_error;
778: IF l_errorLog THEN
779: fnd_message.set_name('BOM','CST_ERROR');
780: fnd_message.set_token('SQLERRM',SQLERRM);
781: fnd_msg_pub.add;
782: fnd_log.message(
783: fnd_log.level_error,
776: WHEN fnd_api.g_exc_error THEN
777: X_retcode := FND_API.g_ret_sts_error;
778: IF l_errorLog THEN
779: fnd_message.set_name('BOM','CST_ERROR');
780: fnd_message.set_token('SQLERRM',SQLERRM);
781: fnd_msg_pub.add;
782: fnd_log.message(
783: fnd_log.level_error,
784: l_module||'.'||l_stmt_num,
790:
791: WHEN OTHERS THEN
792: X_retcode := FND_API.g_ret_sts_unexp_error;
793: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
794: fnd_message.set_name('BOM','CST_UNEXPECTED');
795: fnd_message.set_token('SQLERRM',SQLERRM);
796: fnd_msg_pub.add;
797: fnd_log.message(
798: fnd_log.level_unexpected,
791: WHEN OTHERS THEN
792: X_retcode := FND_API.g_ret_sts_unexp_error;
793: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
794: fnd_message.set_name('BOM','CST_UNEXPECTED');
795: fnd_message.set_token('SQLERRM',SQLERRM);
796: fnd_msg_pub.add;
797: fnd_log.message(
798: fnd_log.level_unexpected,
799: l_module||'.'||l_stmt_num,
996:
997: WHEN fnd_api.g_exc_error THEN
998: X_retcode := FND_API.g_ret_sts_error;
999: IF l_errorLog THEN
1000: fnd_message.set_name('BOM','CST_ERROR');
1001: fnd_message.set_token('SQLERRM',SQLERRM);
1002: fnd_msg_pub.add;
1003: fnd_log.message(
1004: fnd_log.level_error,
997: WHEN fnd_api.g_exc_error THEN
998: X_retcode := FND_API.g_ret_sts_error;
999: IF l_errorLog THEN
1000: fnd_message.set_name('BOM','CST_ERROR');
1001: fnd_message.set_token('SQLERRM',SQLERRM);
1002: fnd_msg_pub.add;
1003: fnd_log.message(
1004: fnd_log.level_error,
1005: l_module||'.'||l_stmt_num,
1011:
1012: WHEN OTHERS THEN
1013: X_retcode := FND_API.g_ret_sts_unexp_error;
1014: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1015: fnd_message.set_name('BOM','CST_UNEXPECTED');
1016: fnd_message.set_token('SQLERRM',SQLERRM);
1017: fnd_msg_pub.add;
1018: fnd_log.message(
1019: fnd_log.level_unexpected,
1012: WHEN OTHERS THEN
1013: X_retcode := FND_API.g_ret_sts_unexp_error;
1014: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1015: fnd_message.set_name('BOM','CST_UNEXPECTED');
1016: fnd_message.set_token('SQLERRM',SQLERRM);
1017: fnd_msg_pub.add;
1018: fnd_log.message(
1019: fnd_log.level_unexpected,
1020: l_module||'.'||l_stmt_num,
1214: EXCEPTION
1215: WHEN update_subledger_exception THEN
1216: ROLLBACK;
1217: IF l_errorLog THEN
1218: fnd_message.set_name('BOM','CST_ERROR');
1219: fnd_message.set_token('SQLERRM',SQLERRM);
1220: fnd_msg_pub.add;
1221: fnd_log.message(
1222: fnd_log.level_error,
1215: WHEN update_subledger_exception THEN
1216: ROLLBACK;
1217: IF l_errorLog THEN
1218: fnd_message.set_name('BOM','CST_ERROR');
1219: fnd_message.set_token('SQLERRM',SQLERRM);
1220: fnd_msg_pub.add;
1221: fnd_log.message(
1222: fnd_log.level_error,
1223: l_module||'.'||l_stmt_num,
1248: WHEN fnd_api.g_exc_error THEN
1249: ROLLBACK;
1250: X_retcode := FND_API.g_ret_sts_error;
1251: IF l_errorLog THEN
1252: fnd_message.set_name('BOM','CST_ERROR');
1253: fnd_message.set_token('SQLERRM',SQLERRM);
1254: fnd_msg_pub.add;
1255: fnd_log.message(
1256: fnd_log.level_error,
1249: ROLLBACK;
1250: X_retcode := FND_API.g_ret_sts_error;
1251: IF l_errorLog THEN
1252: fnd_message.set_name('BOM','CST_ERROR');
1253: fnd_message.set_token('SQLERRM',SQLERRM);
1254: fnd_msg_pub.add;
1255: fnd_log.message(
1256: fnd_log.level_error,
1257: l_module||'.'||l_stmt_num,
1264: WHEN OTHERS THEN
1265: ROLLBACK;
1266: X_retcode := FND_API.g_ret_sts_unexp_error;
1267: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1268: fnd_message.set_name('BOM','CST_UNEXPECTED');
1269: fnd_message.set_token('SQLERRM',SQLERRM);
1270: fnd_msg_pub.add;
1271: fnd_log.message(
1272: fnd_log.level_unexpected,
1265: ROLLBACK;
1266: X_retcode := FND_API.g_ret_sts_unexp_error;
1267: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1268: fnd_message.set_name('BOM','CST_UNEXPECTED');
1269: fnd_message.set_token('SQLERRM',SQLERRM);
1270: fnd_msg_pub.add;
1271: fnd_log.message(
1272: fnd_log.level_unexpected,
1273: l_module||'.'||l_stmt_num,
1464: EXCEPTION
1465: WHEN update_subledger_exception THEN
1466: ROLLBACK;
1467: IF l_errorLog THEN
1468: fnd_message.set_name('BOM','CST_ERROR');
1469: fnd_message.set_token('SQLERRM',SQLERRM);
1470: fnd_msg_pub.add;
1471: fnd_log.message(
1472: fnd_log.level_error,
1465: WHEN update_subledger_exception THEN
1466: ROLLBACK;
1467: IF l_errorLog THEN
1468: fnd_message.set_name('BOM','CST_ERROR');
1469: fnd_message.set_token('SQLERRM',SQLERRM);
1470: fnd_msg_pub.add;
1471: fnd_log.message(
1472: fnd_log.level_error,
1473: l_module||'.'||l_stmt_num,
1498: WHEN fnd_api.g_exc_error THEN
1499: ROLLBACK;
1500: X_retcode := FND_API.g_ret_sts_error;
1501: IF l_errorLog THEN
1502: fnd_message.set_name('BOM','CST_ERROR');
1503: fnd_message.set_token('SQLERRM',SQLERRM);
1504: fnd_msg_pub.add;
1505: fnd_log.message(
1506: fnd_log.level_error,
1499: ROLLBACK;
1500: X_retcode := FND_API.g_ret_sts_error;
1501: IF l_errorLog THEN
1502: fnd_message.set_name('BOM','CST_ERROR');
1503: fnd_message.set_token('SQLERRM',SQLERRM);
1504: fnd_msg_pub.add;
1505: fnd_log.message(
1506: fnd_log.level_error,
1507: l_module||'.'||l_stmt_num,
1514: WHEN OTHERS THEN
1515: ROLLBACK;
1516: X_retcode := FND_API.g_ret_sts_unexp_error;
1517: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1518: fnd_message.set_name('BOM','CST_UNEXPECTED');
1519: fnd_message.set_token('SQLERRM',SQLERRM);
1520: fnd_msg_pub.add;
1521: fnd_log.message(
1522: fnd_log.level_unexpected,
1515: ROLLBACK;
1516: X_retcode := FND_API.g_ret_sts_unexp_error;
1517: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1518: fnd_message.set_name('BOM','CST_UNEXPECTED');
1519: fnd_message.set_token('SQLERRM',SQLERRM);
1520: fnd_msg_pub.add;
1521: fnd_log.message(
1522: fnd_log.level_unexpected,
1523: l_module||'.'||l_stmt_num,
1737: EXCEPTION
1738: WHEN update_subledger_exception THEN
1739: ROLLBACK;
1740: IF l_errorLog THEN
1741: fnd_message.set_name('BOM','CST_ERROR');
1742: fnd_message.set_token('SQLERRM',SQLERRM);
1743: fnd_msg_pub.add;
1744: fnd_log.message(
1745: fnd_log.level_error,
1738: WHEN update_subledger_exception THEN
1739: ROLLBACK;
1740: IF l_errorLog THEN
1741: fnd_message.set_name('BOM','CST_ERROR');
1742: fnd_message.set_token('SQLERRM',SQLERRM);
1743: fnd_msg_pub.add;
1744: fnd_log.message(
1745: fnd_log.level_error,
1746: l_module||'.'||l_stmt_num,
1771: WHEN fnd_api.g_exc_error THEN
1772: ROLLBACK;
1773: X_retcode := FND_API.g_ret_sts_error;
1774: IF l_errorLog THEN
1775: fnd_message.set_name('BOM','CST_ERROR');
1776: fnd_message.set_token('SQLERRM',SQLERRM);
1777: fnd_msg_pub.add;
1778: fnd_log.message(
1779: fnd_log.level_error,
1772: ROLLBACK;
1773: X_retcode := FND_API.g_ret_sts_error;
1774: IF l_errorLog THEN
1775: fnd_message.set_name('BOM','CST_ERROR');
1776: fnd_message.set_token('SQLERRM',SQLERRM);
1777: fnd_msg_pub.add;
1778: fnd_log.message(
1779: fnd_log.level_error,
1780: l_module||'.'||l_stmt_num,
1785: WHEN OTHERS THEN
1786: ROLLBACK;
1787: X_retcode := FND_API.g_ret_sts_unexp_error;
1788: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1789: fnd_message.set_name('BOM','CST_UNEXPECTED');
1790: fnd_message.set_token('SQLERRM',SQLERRM);
1791: fnd_msg_pub.add;
1792: fnd_log.message(
1793: fnd_log.level_unexpected,
1786: ROLLBACK;
1787: X_retcode := FND_API.g_ret_sts_unexp_error;
1788: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
1789: fnd_message.set_name('BOM','CST_UNEXPECTED');
1790: fnd_message.set_token('SQLERRM',SQLERRM);
1791: fnd_msg_pub.add;
1792: fnd_log.message(
1793: fnd_log.level_unexpected,
1794: l_module||'.'||l_stmt_num,
2592: WHEN fnd_api.g_exc_error THEN
2593: ROLLBACK;
2594: X_retcode := FND_API.g_ret_sts_error;
2595: IF l_errorLog THEN
2596: fnd_message.set_name('BOM','CST_ERROR');
2597: fnd_message.set_token('SQLERRM',SQLERRM);
2598: fnd_msg_pub.add;
2599: fnd_log.message(
2600: fnd_log.level_error,
2593: ROLLBACK;
2594: X_retcode := FND_API.g_ret_sts_error;
2595: IF l_errorLog THEN
2596: fnd_message.set_name('BOM','CST_ERROR');
2597: fnd_message.set_token('SQLERRM',SQLERRM);
2598: fnd_msg_pub.add;
2599: fnd_log.message(
2600: fnd_log.level_error,
2601: l_module||'.'||l_stmt_num,
2606: WHEN OTHERS THEN
2607: ROLLBACK;
2608: X_retcode := FND_API.g_ret_sts_unexp_error;
2609: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
2610: fnd_message.set_name('BOM','CST_UNEXPECTED');
2611: fnd_message.set_token('SQLERRM',SQLERRM);
2612: fnd_msg_pub.add;
2613: fnd_log.message(
2614: fnd_log.level_unexpected,
2607: ROLLBACK;
2608: X_retcode := FND_API.g_ret_sts_unexp_error;
2609: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
2610: fnd_message.set_name('BOM','CST_UNEXPECTED');
2611: fnd_message.set_token('SQLERRM',SQLERRM);
2612: fnd_msg_pub.add;
2613: fnd_log.message(
2614: fnd_log.level_unexpected,
2615: l_module||'.'||l_stmt_num,
3142: WHEN fnd_api.g_exc_error THEN
3143: ROLLBACK;
3144: X_retcode := FND_API.g_ret_sts_error;
3145: IF l_errorLog THEN
3146: fnd_message.set_name('BOM','CST_ERROR');
3147: fnd_message.set_token('SQLERRM',SQLERRM);
3148: fnd_msg_pub.add;
3149: fnd_log.message(
3150: fnd_log.level_error,
3143: ROLLBACK;
3144: X_retcode := FND_API.g_ret_sts_error;
3145: IF l_errorLog THEN
3146: fnd_message.set_name('BOM','CST_ERROR');
3147: fnd_message.set_token('SQLERRM',SQLERRM);
3148: fnd_msg_pub.add;
3149: fnd_log.message(
3150: fnd_log.level_error,
3151: l_module||'.'||l_stmt_num,
3156: WHEN OTHERS THEN
3157: ROLLBACK;
3158: X_retcode := FND_API.g_ret_sts_unexp_error;
3159: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
3160: fnd_message.set_name('BOM','CST_UNEXPECTED');
3161: fnd_message.set_token('SQLERRM',SQLERRM);
3162: fnd_msg_pub.add;
3163: fnd_log.message(
3164: fnd_log.level_unexpected,
3157: ROLLBACK;
3158: X_retcode := FND_API.g_ret_sts_unexp_error;
3159: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
3160: fnd_message.set_name('BOM','CST_UNEXPECTED');
3161: fnd_message.set_token('SQLERRM',SQLERRM);
3162: fnd_msg_pub.add;
3163: fnd_log.message(
3164: fnd_log.level_unexpected,
3165: l_module||'.'||l_stmt_num,
3708: WHEN fnd_api.g_exc_error THEN
3709: ROLLBACK;
3710: X_retcode := FND_API.g_ret_sts_error;
3711: IF l_errorLog THEN
3712: fnd_message.set_name('BOM','CST_ERROR');
3713: fnd_message.set_token('SQLERRM',SQLERRM);
3714: fnd_msg_pub.add;
3715: fnd_log.message(
3716: fnd_log.level_error,
3709: ROLLBACK;
3710: X_retcode := FND_API.g_ret_sts_error;
3711: IF l_errorLog THEN
3712: fnd_message.set_name('BOM','CST_ERROR');
3713: fnd_message.set_token('SQLERRM',SQLERRM);
3714: fnd_msg_pub.add;
3715: fnd_log.message(
3716: fnd_log.level_error,
3717: l_module||'.'||l_stmt_num,
3722: WHEN OTHERS THEN
3723: ROLLBACK;
3724: X_retcode := FND_API.g_ret_sts_unexp_error;
3725: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
3726: fnd_message.set_name('BOM','CST_UNEXPECTED');
3727: fnd_message.set_token('SQLERRM',SQLERRM);
3728: fnd_msg_pub.add;
3729: fnd_log.message(
3730: fnd_log.level_unexpected,
3723: ROLLBACK;
3724: X_retcode := FND_API.g_ret_sts_unexp_error;
3725: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
3726: fnd_message.set_name('BOM','CST_UNEXPECTED');
3727: fnd_message.set_token('SQLERRM',SQLERRM);
3728: fnd_msg_pub.add;
3729: fnd_log.message(
3730: fnd_log.level_unexpected,
3731: l_module||'.'||l_stmt_num,