eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_MESSAGE

Line 283: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');

279: ,'Completed phase 1 successfully.');
280: END IF;
281:
282: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
283: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
284: FND_MESSAGE.set_token('PHASE', '1');
285: FND_MSG_PUB.ADD;
286: END IF;
287:

Line 284: FND_MESSAGE.set_token('PHASE', '1');

280: END IF;
281:
282: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
283: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
284: FND_MESSAGE.set_token('PHASE', '1');
285: FND_MSG_PUB.ADD;
286: END IF;
287:
288: Print_MessageStack;

Line 351: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');

347: ,'Completed phase 2 successfully.');
348: END IF;
349:
350: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
351: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
352: FND_MESSAGE.set_token('PHASE', '2');
353: FND_MSG_PUB.ADD;
354: END IF;
355:

Line 352: FND_MESSAGE.set_token('PHASE', '2');

348: END IF;
349:
350: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
351: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
352: FND_MESSAGE.set_token('PHASE', '2');
353: FND_MSG_PUB.ADD;
354: END IF;
355:
356: Print_MessageStack;

Line 480: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');

476: ,'Completed phase 3 successfully.');
477: END IF;
478:
479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
480: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
481: FND_MESSAGE.set_token('PHASE', '3');
482: FND_MSG_PUB.ADD;
483: END IF;
484:

Line 481: FND_MESSAGE.set_token('PHASE', '3');

477: END IF;
478:
479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
480: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
481: FND_MESSAGE.set_token('PHASE', '3');
482: FND_MSG_PUB.ADD;
483: END IF;
484:
485: Print_MessageStack;

Line 519: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');

515: ,'Completed phase 4 successfully.');
516: END IF;
517:
518: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
519: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
520: FND_MESSAGE.set_token('PHASE', '4');
521: FND_MSG_PUB.ADD;
522: END IF;
523:

Line 520: FND_MESSAGE.set_token('PHASE', '4');

516: END IF;
517:
518: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
519: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
520: FND_MESSAGE.set_token('PHASE', '4');
521: FND_MSG_PUB.ADD;
522: END IF;
523:
524: -- Print the message stack to the log file

Line 549: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');

545:
546: WHEN program_exception THEN
547: x_return_status := fnd_api.g_ret_sts_error;
548:
549: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
550: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
551: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
552: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 550: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

546: WHEN program_exception THEN
547: x_return_status := fnd_api.g_ret_sts_error;
548:
549: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
550: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
551: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
552: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
554: FND_MSG_PUB.ADD;

Line 551: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

547: x_return_status := fnd_api.g_ret_sts_error;
548:
549: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
550: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
551: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
552: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
554: FND_MSG_PUB.ADD;
555: END IF;

Line 552: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

548:
549: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
550: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
551: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
552: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
554: FND_MSG_PUB.ADD;
555: END IF;
556:

Line 589: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

585: ,substrb(SQLERRM,1,250));
586: END IF;
587:
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
590: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
591: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
592: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
593: FND_MSG_PUB.ADD;

Line 590: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

586: END IF;
587:
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
590: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
591: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
592: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
593: FND_MSG_PUB.ADD;
594: END IF;

Line 591: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

587:
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
590: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
591: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
592: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
593: FND_MSG_PUB.ADD;
594: END IF;
595:

Line 592: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
590: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
591: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
592: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
593: FND_MSG_PUB.ADD;
594: END IF;
595:
596: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Match_RevenueCOGS:'||substrb(SQLERRM,1,250) );

Line 773: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_SO_INSERT');

769: );
770:
771: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
772: x_return_status := fnd_api.g_ret_sts_error;
773: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_SO_INSERT');
774: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(cv_so_issues.cogs_om_line_id));
775: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(cv_so_issues.mmt_txn_id));
776: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
777: FND_MSG_PUB.ADD;

Line 774: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(cv_so_issues.cogs_om_line_id));

770:
771: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
772: x_return_status := fnd_api.g_ret_sts_error;
773: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_SO_INSERT');
774: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(cv_so_issues.cogs_om_line_id));
775: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(cv_so_issues.mmt_txn_id));
776: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
777: FND_MSG_PUB.ADD;
778: END IF;

Line 775: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(cv_so_issues.mmt_txn_id));

771: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
772: x_return_status := fnd_api.g_ret_sts_error;
773: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_SO_INSERT');
774: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(cv_so_issues.cogs_om_line_id));
775: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(cv_so_issues.mmt_txn_id));
776: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
777: FND_MSG_PUB.ADD;
778: END IF;
779: IF l_errorLog THEN

Line 814: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

810: ,'Insert_SoIssues ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
811: END IF;
812:
813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
814: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
815: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
816: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
817: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
818: FND_MSG_PUB.ADD;

Line 815: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

811: END IF;
812:
813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
814: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
815: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
816: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
817: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
818: FND_MSG_PUB.ADD;
819: END IF;

Line 816: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

812:
813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
814: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
815: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
816: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
817: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
818: FND_MSG_PUB.ADD;
819: END IF;
820:

Line 817: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
814: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
815: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
816: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
817: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
818: FND_MSG_PUB.ADD;
819: END IF;
820:
821: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_SoIssues:'||substrb(SQLERRM,1,250) );

Line 1447: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');

1443: x_error_message => l_error_message);
1444:
1445: IF (l_return_num <> 0) THEN
1446: x_return_status := fnd_api.g_ret_sts_error;
1447: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
1448: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
1449: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
1450: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1451: FND_MSG_PUB.ADD;

Line 1448: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);

1444:
1445: IF (l_return_num <> 0) THEN
1446: x_return_status := fnd_api.g_ret_sts_error;
1447: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
1448: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
1449: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
1450: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1451: FND_MSG_PUB.ADD;
1452: END IF;

Line 1449: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));

1445: IF (l_return_num <> 0) THEN
1446: x_return_status := fnd_api.g_ret_sts_error;
1447: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
1448: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
1449: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
1450: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1451: FND_MSG_PUB.ADD;
1452: END IF;
1453: IF l_errorLog THEN

Line 1496: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

1492: ,'Insert_RmaReceipts ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
1493: END IF;
1494:
1495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1496: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1497: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1498: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1499: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1500: FND_MSG_PUB.ADD;

Line 1497: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

1493: END IF;
1494:
1495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1496: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1497: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1498: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1499: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1500: FND_MSG_PUB.ADD;
1501: END IF;

Line 1498: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

1494:
1495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1496: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1497: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1498: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1499: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1500: FND_MSG_PUB.ADD;
1501: END IF;
1502: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_RmaReceipts:'||substrb(SQLERRM,1,250) );

Line 1499: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

1495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1496: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1497: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1498: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1499: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1500: FND_MSG_PUB.ADD;
1501: END IF;
1502: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_RmaReceipts:'||substrb(SQLERRM,1,250) );
1503:

Line 1919: FND_MESSAGE.set_name('BOM', 'CST_NO_OPEN_GL_PERIOD');

1915:
1916: EXCEPTION
1917: WHEN NO_DATA_FOUND THEN
1918: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1919: FND_MESSAGE.set_name('BOM', 'CST_NO_OPEN_GL_PERIOD');
1920: FND_MESSAGE.set_token('LEDGER', l_sob); -- to_char(l_sob.set_of_books_id)
1921: FND_MESSAGE.set_token('PERIOD_NAME',l_period_name);
1922: FND_MSG_PUB.ADD;
1923: debug('EXCEPTION- CST_NO_OPEN_GL_PERIOD l_sob:'||l_sob||' - l_period_name:'||l_period_name);

Line 1920: FND_MESSAGE.set_token('LEDGER', l_sob); -- to_char(l_sob.set_of_books_id)

1916: EXCEPTION
1917: WHEN NO_DATA_FOUND THEN
1918: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1919: FND_MESSAGE.set_name('BOM', 'CST_NO_OPEN_GL_PERIOD');
1920: FND_MESSAGE.set_token('LEDGER', l_sob); -- to_char(l_sob.set_of_books_id)
1921: FND_MESSAGE.set_token('PERIOD_NAME',l_period_name);
1922: FND_MSG_PUB.ADD;
1923: debug('EXCEPTION- CST_NO_OPEN_GL_PERIOD l_sob:'||l_sob||' - l_period_name:'||l_period_name);
1924: IF l_errorLog THEN

Line 1921: FND_MESSAGE.set_token('PERIOD_NAME',l_period_name);

1917: WHEN NO_DATA_FOUND THEN
1918: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1919: FND_MESSAGE.set_name('BOM', 'CST_NO_OPEN_GL_PERIOD');
1920: FND_MESSAGE.set_token('LEDGER', l_sob); -- to_char(l_sob.set_of_books_id)
1921: FND_MESSAGE.set_token('PERIOD_NAME',l_period_name);
1922: FND_MSG_PUB.ADD;
1923: debug('EXCEPTION- CST_NO_OPEN_GL_PERIOD l_sob:'||l_sob||' - l_period_name:'||l_period_name);
1924: IF l_errorLog THEN
1925: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);

Line 2404: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');

2400: x_error_message => l_error_message);
2401:
2402: IF (l_return_num <> 0) THEN
2403: x_return_status := fnd_api.g_ret_sts_error;
2404: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
2405: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
2406: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
2407: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2408: FND_MSG_PUB.ADD;

Line 2405: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);

2401:
2402: IF (l_return_num <> 0) THEN
2403: x_return_status := fnd_api.g_ret_sts_error;
2404: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
2405: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
2406: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
2407: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2408: FND_MSG_PUB.ADD;
2409: END IF;

Line 2406: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));

2402: IF (l_return_num <> 0) THEN
2403: x_return_status := fnd_api.g_ret_sts_error;
2404: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
2405: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
2406: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
2407: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2408: FND_MSG_PUB.ADD;
2409: END IF;
2410: IF l_errorLog THEN

Line 2523: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

2519: ROLLBACK TO Create_CogsRecEvents_PVT;
2520: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2521:
2522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2523: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2524: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2525: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2526: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2527: FND_MSG_PUB.ADD;

Line 2524: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

2520: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2521:
2522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2523: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2524: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2525: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2526: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2527: FND_MSG_PUB.ADD;
2528: END IF;

Line 2525: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

2521:
2522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2523: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2524: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2525: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2526: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2527: FND_MSG_PUB.ADD;
2528: END IF;
2529:

Line 2526: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

2522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2523: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2524: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2525: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2526: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2527: FND_MSG_PUB.ADD;
2528: END IF;
2529:
2530: IF l_unexpLog THEN

Line 2680: FND_MESSAGE.set_name('BOM', 'CST_NO_REVENUE_OM_LINE');

2676: x_msg_count => l_msg_count,
2677: x_msg_data => l_msg_data);
2678:
2679: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2680: FND_MESSAGE.set_name('BOM', 'CST_NO_REVENUE_OM_LINE');
2681: FND_MESSAGE.set_token('COGS_LINE_ID', to_char(p_cogs_om_line_id));
2682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2683: FND_MSG_PUB.ADD;
2684: END IF;

Line 2681: FND_MESSAGE.set_token('COGS_LINE_ID', to_char(p_cogs_om_line_id));

2677: x_msg_data => l_msg_data);
2678:
2679: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2680: FND_MESSAGE.set_name('BOM', 'CST_NO_REVENUE_OM_LINE');
2681: FND_MESSAGE.set_token('COGS_LINE_ID', to_char(p_cogs_om_line_id));
2682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2683: FND_MSG_PUB.ADD;
2684: END IF;
2685:

Line 2855: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

2851: ,'Insert_OneSoIssue ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
2852: END IF;
2853:
2854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2855: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2856: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2857: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2858: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2859: FND_MSG_PUB.ADD;

Line 2856: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

2852: END IF;
2853:
2854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2855: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2856: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2857: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2858: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2859: FND_MSG_PUB.ADD;
2860: END IF;

Line 2857: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

2853:
2854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2855: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2856: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2857: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2858: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2859: FND_MSG_PUB.ADD;
2860: END IF;
2861: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_OneSoIssue:'||substrb(SQLERRM,1,250) );

Line 2858: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

2854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2855: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2856: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2857: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2858: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2859: FND_MSG_PUB.ADD;
2860: END IF;
2861: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_OneSoIssue:'||substrb(SQLERRM,1,250) );
2862: END Insert_OneSoIssue;

Line 3351: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');

3347: x_error_message => l_error_message);
3348:
3349: IF (l_return_num <> 0) THEN
3350: x_return_status := fnd_api.g_ret_sts_error;
3351: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
3352: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
3353: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
3354: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3355: FND_MSG_PUB.ADD;

Line 3352: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);

3348:
3349: IF (l_return_num <> 0) THEN
3350: x_return_status := fnd_api.g_ret_sts_error;
3351: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
3352: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
3353: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
3354: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3355: FND_MSG_PUB.ADD;
3356: END IF;

Line 3353: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));

3349: IF (l_return_num <> 0) THEN
3350: x_return_status := fnd_api.g_ret_sts_error;
3351: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
3352: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
3353: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
3354: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3355: FND_MSG_PUB.ADD;
3356: END IF;
3357: IF l_errorLog THEN

Line 3405: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

3401: ,'Insert_OneRmaReceipt '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
3402: END IF;
3403:
3404: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3405: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3406: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3407: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3408: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3409: FND_MSG_PUB.ADD;

Line 3406: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

3402: END IF;
3403:
3404: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3405: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3406: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3407: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3408: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3409: FND_MSG_PUB.ADD;
3410: END IF;

Line 3407: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

3403:
3404: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3405: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3406: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3407: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3408: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3409: FND_MSG_PUB.ADD;
3410: END IF;
3411:

Line 3408: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

3404: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3405: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3406: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3407: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3408: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3409: FND_MSG_PUB.ADD;
3410: END IF;
3411:
3412: FND_MSG_PUB.count_and_get

Line 3596: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

3592: ,'Record_SoIssueCost '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
3593: END IF;
3594:
3595: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3596: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3597: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3598: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3599: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3600: FND_MSG_PUB.ADD;

Line 3597: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

3593: END IF;
3594:
3595: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3596: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3597: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3598: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3599: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3600: FND_MSG_PUB.ADD;
3601: END IF;

Line 3598: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

3594:
3595: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3596: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3597: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3598: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3599: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3600: FND_MSG_PUB.ADD;
3601: END IF;
3602:

Line 3599: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

3595: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3596: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3597: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3598: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3599: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3600: FND_MSG_PUB.ADD;
3601: END IF;
3602:
3603: FND_MSG_PUB.count_and_get

Line 3762: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_RMA_INSERT');

3758: );
3759:
3760: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3761: x_return_status := fnd_api.g_ret_sts_error;
3762: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_RMA_INSERT');
3763: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(p_cogs_om_line_id));
3764: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(p_transaction_id));
3765: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3766: FND_MSG_PUB.ADD;

Line 3763: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(p_cogs_om_line_id));

3759:
3760: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3761: x_return_status := fnd_api.g_ret_sts_error;
3762: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_RMA_INSERT');
3763: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(p_cogs_om_line_id));
3764: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(p_transaction_id));
3765: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3766: FND_MSG_PUB.ADD;
3767: END IF;

Line 3764: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(p_transaction_id));

3760: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3761: x_return_status := fnd_api.g_ret_sts_error;
3762: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_RMA_INSERT');
3763: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(p_cogs_om_line_id));
3764: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(p_transaction_id));
3765: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3766: FND_MSG_PUB.ADD;
3767: END IF;
3768: IF l_errorLog THEN

Line 3902: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');

3898: WHEN program_exception THEN
3899: ROLLBACK TO Process_RmaReceipt_PVT;
3900: x_return_status := fnd_api.g_ret_sts_error ;
3901:
3902: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
3903: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3904: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3905: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3906: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 3903: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

3899: ROLLBACK TO Process_RmaReceipt_PVT;
3900: x_return_status := fnd_api.g_ret_sts_error ;
3901:
3902: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
3903: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3904: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3905: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3906: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3907: FND_MSG_PUB.ADD;

Line 3904: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

3900: x_return_status := fnd_api.g_ret_sts_error ;
3901:
3902: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
3903: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3904: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3905: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3906: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3907: FND_MSG_PUB.ADD;
3908: END IF;

Line 3905: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

3901:
3902: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
3903: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3904: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3905: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3906: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3907: FND_MSG_PUB.ADD;
3908: END IF;
3909:

Line 3930: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

3926: ,'Process_RmaReceipt '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
3927: END IF;
3928:
3929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3930: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3931: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3932: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3933: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3934: FND_MSG_PUB.ADD;

Line 3931: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

3927: END IF;
3928:
3929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3930: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3931: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3932: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3933: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3934: FND_MSG_PUB.ADD;
3935: END IF;

Line 3932: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

3928:
3929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3930: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3931: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3932: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3933: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3934: FND_MSG_PUB.ADD;
3935: END IF;
3936:

Line 3933: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

3929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3930: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3931: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3932: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3933: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3934: FND_MSG_PUB.ADD;
3935: END IF;
3936:
3937: FND_MSG_PUB.count_and_get

Line 4135: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

4131: ,'Process_CogsRecognitionTxn ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
4132: END IF;
4133:
4134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4135: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4136: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4137: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4138: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4139: FND_MSG_PUB.ADD;

Line 4136: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

4132: END IF;
4133:
4134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4135: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4136: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4137: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4138: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4139: FND_MSG_PUB.ADD;
4140: END IF;

Line 4137: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

4133:
4134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4135: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4136: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4137: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4138: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4139: FND_MSG_PUB.ADD;
4140: END IF;
4141:

Line 4138: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

4134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4135: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4136: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4137: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4138: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4139: FND_MSG_PUB.ADD;
4140: END IF;
4141:
4142: FND_MSG_PUB.count_and_get

Line 4614: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

4610: ,'Cost_BulkCogsRecTxns '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
4611: END IF;
4612:
4613: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4614: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4615: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4616: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4617: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4618: FND_MSG_PUB.ADD;

Line 4615: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

4611: END IF;
4612:
4613: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4614: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4615: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4616: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4617: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4618: FND_MSG_PUB.ADD;
4619: END IF;

Line 4616: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

4612:
4613: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4614: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4615: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4616: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4617: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4618: FND_MSG_PUB.ADD;
4619: END IF;
4620:

Line 4617: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

4613: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4614: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4615: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4616: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4617: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4618: FND_MSG_PUB.ADD;
4619: END IF;
4620:
4621: END Cost_BulkCogsRecTxns;

Line 4892: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');

4888: ,'Insert_PacSoIssue ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
4889: END IF;
4890:
4891: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4892: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4893: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4894: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4895: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4896: FND_MSG_PUB.ADD;

Line 4893: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);

4889: END IF;
4890:
4891: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4892: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4893: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4894: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4895: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4896: FND_MSG_PUB.ADD;
4897: END IF;

Line 4894: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

4890:
4891: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4892: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4893: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4894: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4895: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4896: FND_MSG_PUB.ADD;
4897: END IF;
4898:

Line 4895: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));

4891: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4892: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4893: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4894: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4895: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4896: FND_MSG_PUB.ADD;
4897: END IF;
4898:
4899: FND_MSG_PUB.count_and_get

Line 6991: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');

6987: IF ctrx%ISOPEN THEN CLOSE ctrx; END IF;
6988: IF next_inv_period%ISOPEN THEN CLOSE next_inv_period; END IF;
6989: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6990: debug('OTHERS EXCEPTION ensure_mmt_per_and_date:'||SQLERRM);
6991: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');
6992: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');
6993: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');
6994: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));
6995: fnd_msg_pub.ADD;

Line 6992: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');

6988: IF next_inv_period%ISOPEN THEN CLOSE next_inv_period; END IF;
6989: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6990: debug('OTHERS EXCEPTION ensure_mmt_per_and_date:'||SQLERRM);
6991: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');
6992: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');
6993: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');
6994: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));
6995: fnd_msg_pub.ADD;
6996: fnd_msg_pub.count_and_get(

Line 6993: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');

6989: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6990: debug('OTHERS EXCEPTION ensure_mmt_per_and_date:'||SQLERRM);
6991: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');
6992: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');
6993: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');
6994: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));
6995: fnd_msg_pub.ADD;
6996: fnd_msg_pub.count_and_get(
6997: p_encoded => fnd_api.g_false,

Line 6994: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));

6990: debug('OTHERS EXCEPTION ensure_mmt_per_and_date:'||SQLERRM);
6991: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');
6992: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');
6993: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');
6994: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));
6995: fnd_msg_pub.ADD;
6996: fnd_msg_pub.count_and_get(
6997: p_encoded => fnd_api.g_false,
6998: p_count => x_msg_count,