DBA Data[Home] [Help]

APPS.CST_SLA_UPDATE_PKG dependencies on FND_MESSAGE

Line 334: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 335: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 349: fnd_message.set_name('BOM','CST_UNEXPECTED');

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,

Line 350: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 557: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 558: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 572: fnd_message.set_name('BOM','CST_UNEXPECTED');

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,

Line 573: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 779: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 780: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 794: fnd_message.set_name('BOM','CST_UNEXPECTED');

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,

Line 795: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1000: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 1001: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1015: fnd_message.set_name('BOM','CST_UNEXPECTED');

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,

Line 1016: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1218: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 1219: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1252: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 1253: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1268: fnd_message.set_name('BOM','CST_UNEXPECTED');

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,

Line 1269: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1468: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 1469: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1502: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 1503: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1518: fnd_message.set_name('BOM','CST_UNEXPECTED');

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,

Line 1519: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1741: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 1742: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1775: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 1776: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 1789: fnd_message.set_name('BOM','CST_UNEXPECTED');

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,

Line 1790: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 2596: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 2597: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 2610: fnd_message.set_name('BOM','CST_UNEXPECTED');

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,

Line 2611: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 3146: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 3147: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 3160: fnd_message.set_name('BOM','CST_UNEXPECTED');

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,

Line 3161: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 3712: fnd_message.set_name('BOM','CST_ERROR');

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,

Line 3713: fnd_message.set_token('SQLERRM',SQLERRM);

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,

Line 3726: fnd_message.set_name('BOM','CST_UNEXPECTED');

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,

Line 3727: fnd_message.set_token('SQLERRM',SQLERRM);

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,