DBA Data[Home] [Help]

APPS.CST_SLA_UPDATE_PKG dependencies on FND_MSG_PUB

Line 162: FND_MSG_PUB.initialize;

158: if (submit_req = TRUE) then
159:
160: -- Initialize message list if X_init_msg_list is set to TRUE
161: IF FND_API.to_Boolean(X_init_msg_list) THEN
162: FND_MSG_PUB.initialize;
163: END IF;
164:
165:
166: x_retcode := FND_API.G_RET_STS_SUCCESS;

Line 283: fnd_msg_pub.add_exc_msg(

279:
280: WHEN CST_UPGRADE_RUNNING THEN
281: X_retcode := FND_API.g_ret_sts_unexp_error;
282: IF l_exceptionlog THEN
283: fnd_msg_pub.add_exc_msg(
284: p_pkg_name => 'CST_SLA_UPDATE_PKG',
285: p_procedure_name => 'Update_Proc_MGR',
286: p_error_text => 'Another Costing Upgrade Manager is running.'
287: );

Line 300: fnd_msg_pub.add_exc_msg(

296:
297: WHEN submit_conc_failed THEN
298: X_retcode := FND_API.g_ret_sts_unexp_error;
299: IF l_exceptionlog THEN
300: fnd_msg_pub.add_exc_msg(
301: p_pkg_name => 'CST_SLA_UPDATE_PKG',
302: p_procedure_name => 'Update_Proc_MGR',
303: p_error_text => 'Submit concurrent request failed.'
304: );

Line 317: fnd_msg_pub.add_exc_msg(

313:
314: WHEN fnd_api.g_exc_unexpected_error THEN
315: X_retcode := FND_API.g_ret_sts_unexp_error;
316: IF l_exceptionlog THEN
317: fnd_msg_pub.add_exc_msg(
318: p_pkg_name => 'CST_SLA_UPDATE_PKG',
319: p_procedure_name => 'Update_Proc_MGR',
320: p_error_text => 'An exception has occurred.'
321: );

Line 336: fnd_msg_pub.add;

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,
340: FALSE

Line 351: fnd_msg_pub.add;

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,
355: FALSE

Line 459: FND_MSG_PUB.initialize;

455: END IF;
456:
457: -- Initialize message list if X_init_msg_list is set to TRUE
458: IF FND_API.to_Boolean(X_init_msg_list) THEN
459: FND_MSG_PUB.initialize;
460: END IF;
461:
462: x_retcode := FND_API.G_RET_STS_SUCCESS;
463:

Line 540: fnd_msg_pub.add_exc_msg(

536:
537: WHEN fnd_api.g_exc_unexpected_error THEN
538: X_retcode := FND_API.g_ret_sts_unexp_error;
539: IF l_exceptionlog THEN
540: fnd_msg_pub.add_exc_msg(
541: p_pkg_name => 'CST_SLA_UPDATE_PKG',
542: p_procedure_name => 'Update_Proc_INV_MGR',
543: p_error_text => 'An exception has occurred.'
544: );

Line 559: fnd_msg_pub.add;

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,
563: FALSE

Line 574: fnd_msg_pub.add;

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,
578: FALSE

Line 682: FND_MSG_PUB.initialize;

678: END IF;
679:
680: -- Initialize message list if X_init_msg_list is set to TRUE
681: IF FND_API.to_Boolean(X_init_msg_list) THEN
682: FND_MSG_PUB.initialize;
683: END IF;
684:
685: x_retcode := FND_API.G_RET_STS_SUCCESS;
686:

Line 762: fnd_msg_pub.add_exc_msg(

758:
759: WHEN fnd_api.g_exc_unexpected_error THEN
760: X_retcode := FND_API.g_ret_sts_unexp_error;
761: IF l_exceptionlog THEN
762: fnd_msg_pub.add_exc_msg(
763: p_pkg_name => 'CST_SLA_UPDATE_PKG',
764: p_procedure_name => 'Update_Proc_WIP_MGR',
765: p_error_text => 'An exception has occurred.'
766: );

Line 781: fnd_msg_pub.add;

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,
785: FALSE

Line 796: fnd_msg_pub.add;

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,
800: FALSE

Line 904: FND_MSG_PUB.initialize;

900: END IF;
901:
902: -- Initialize message list if X_init_msg_list is set to TRUE
903: IF FND_API.to_Boolean(X_init_msg_list) THEN
904: FND_MSG_PUB.initialize;
905: END IF;
906:
907: x_retcode := FND_API.G_RET_STS_SUCCESS;
908:

Line 983: fnd_msg_pub.add_exc_msg(

979:
980: WHEN fnd_api.g_exc_unexpected_error THEN
981: X_retcode := FND_API.g_ret_sts_unexp_error;
982: IF l_exceptionlog THEN
983: fnd_msg_pub.add_exc_msg(
984: p_pkg_name => 'CST_SLA_UPDATE_PKG',
985: p_procedure_name => 'Update_Proc_RCV_MGR',
986: p_error_text => 'An exception has occurred.'
987: );

Line 1002: fnd_msg_pub.add;

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,
1006: FALSE

Line 1017: fnd_msg_pub.add;

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,
1021: FALSE

Line 1220: fnd_msg_pub.add;

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,
1224: FALSE

Line 1234: fnd_msg_pub.add_exc_msg(

1230: WHEN fnd_api.g_exc_unexpected_error THEN
1231: ROLLBACK;
1232: X_retcode := FND_API.g_ret_sts_unexp_error;
1233: IF l_exceptionlog THEN
1234: fnd_msg_pub.add_exc_msg(
1235: p_pkg_name => 'CST_SLA_UPDATE_PKG',
1236: p_procedure_name => 'Update_Proc_INV_WKR',
1237: p_error_text => 'An exception has occurred.'
1238: );

Line 1254: fnd_msg_pub.add;

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,
1258: FALSE

Line 1270: fnd_msg_pub.add;

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,
1274: FALSE

Line 1470: fnd_msg_pub.add;

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,
1474: FALSE

Line 1484: fnd_msg_pub.add_exc_msg(

1480: WHEN fnd_api.g_exc_unexpected_error THEN
1481: ROLLBACK;
1482: X_retcode := FND_API.g_ret_sts_unexp_error;
1483: IF l_exceptionlog THEN
1484: fnd_msg_pub.add_exc_msg(
1485: p_pkg_name => 'CST_SLA_UPDATE_PKG',
1486: p_procedure_name => 'Update_Proc_WIP_WKR',
1487: p_error_text => 'An exception has occurred.'
1488: );

Line 1504: fnd_msg_pub.add;

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,
1508: FALSE

Line 1520: fnd_msg_pub.add;

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,
1524: FALSE

Line 1743: fnd_msg_pub.add;

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,
1747: FALSE

Line 1757: fnd_msg_pub.add_exc_msg(

1753: WHEN fnd_api.g_exc_unexpected_error THEN
1754: ROLLBACK;
1755: X_retcode := FND_API.g_ret_sts_unexp_error;
1756: IF l_exceptionlog THEN
1757: fnd_msg_pub.add_exc_msg(
1758: p_pkg_name => 'CST_SLA_UPDATE_PKG',
1759: p_procedure_name => 'Update_Proc_RCV_WKR',
1760: p_error_text => 'An exception has occurred.'
1761: );

Line 1777: fnd_msg_pub.add;

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,
1781: FALSE

Line 1791: fnd_msg_pub.add;

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,
1795: FALSE

Line 2580: fnd_msg_pub.add_exc_msg(

2576: WHEN fnd_api.g_exc_unexpected_error THEN
2577: ROLLBACK;
2578: X_retcode := FND_API.g_ret_sts_unexp_error;
2579: IF l_exceptionlog THEN
2580: fnd_msg_pub.add_exc_msg(
2581: p_pkg_name => 'CST_SLA_UPDATE_PKG',
2582: p_procedure_name => 'Update_Inventory_Subledger',
2583: p_error_text => 'An exception has occurred.'
2584: );

Line 2598: fnd_msg_pub.add;

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,
2602: FALSE

Line 2612: fnd_msg_pub.add;

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,
2616: FALSE

Line 3130: fnd_msg_pub.add_exc_msg(

3126: WHEN fnd_api.g_exc_unexpected_error THEN
3127: ROLLBACK;
3128: X_retcode := FND_API.g_ret_sts_unexp_error;
3129: IF l_exceptionlog THEN
3130: fnd_msg_pub.add_exc_msg(
3131: p_pkg_name => 'CST_SLA_UPDATE_PKG',
3132: p_procedure_name => 'Update_WIP_Subledger',
3133: p_error_text => 'An exception has occurred.'
3134: );

Line 3148: fnd_msg_pub.add;

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,
3152: FALSE

Line 3162: fnd_msg_pub.add;

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,
3166: FALSE

Line 3679: fnd_msg_pub.add_exc_msg(

3675: WHEN CST_RCV_MRC_UPG_EXCEPTION THEN
3676: ROLLBACK;
3677: X_retcode := FND_API.g_ret_sts_unexp_error;
3678: IF l_exceptionlog THEN
3679: fnd_msg_pub.add_exc_msg(
3680: p_pkg_name => 'CST_SLA_UPDATE_PKG',
3681: p_procedure_name => 'Update_Receiving_Subledger',
3682: p_error_text => 'An exception has occurred in upgrade of receiving MRC table.'
3683: );

Line 3696: fnd_msg_pub.add_exc_msg(

3692: WHEN fnd_api.g_exc_unexpected_error THEN
3693: ROLLBACK;
3694: X_retcode := FND_API.g_ret_sts_unexp_error;
3695: IF l_exceptionlog THEN
3696: fnd_msg_pub.add_exc_msg(
3697: p_pkg_name => 'CST_SLA_UPDATE_PKG',
3698: p_procedure_name => 'Update_Receiving_Subledger',
3699: p_error_text => 'An exception has occurred.'
3700: );

Line 3714: fnd_msg_pub.add;

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,
3718: FALSE

Line 3728: fnd_msg_pub.add;

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,
3732: FALSE