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 222: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');

218: ,'Completed phase 1 successfully.');
219: END IF;
220:
221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
222: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
223: FND_MESSAGE.set_token('PHASE', '1');
224: FND_MSG_PUB.ADD;
225: END IF;
226:

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

219: END IF;
220:
221: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
222: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
223: FND_MESSAGE.set_token('PHASE', '1');
224: FND_MSG_PUB.ADD;
225: END IF;
226:
227: Print_MessageStack;

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

286: ,'Completed phase 2 successfully.');
287: END IF;
288:
289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
290: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
291: FND_MESSAGE.set_token('PHASE', '2');
292: FND_MSG_PUB.ADD;
293: END IF;
294:

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

287: END IF;
288:
289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
290: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
291: FND_MESSAGE.set_token('PHASE', '2');
292: FND_MSG_PUB.ADD;
293: END IF;
294:
295: Print_MessageStack;

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

424: ,'Completed phase 3 successfully.');
425: END IF;
426:
427: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
428: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
429: FND_MESSAGE.set_token('PHASE', '3');
430: FND_MSG_PUB.ADD;
431: END IF;
432:

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

425: END IF;
426:
427: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
428: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
429: FND_MESSAGE.set_token('PHASE', '3');
430: FND_MSG_PUB.ADD;
431: END IF;
432:
433: Print_MessageStack;

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

463: ,'Completed phase 4 successfully.');
464: END IF;
465:
466: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
467: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
468: FND_MESSAGE.set_token('PHASE', '4');
469: FND_MSG_PUB.ADD;
470: END IF;
471:

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

464: END IF;
465:
466: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
467: FND_MESSAGE.set_name('BOM', 'CST_SUCCESSFUL_PHASE');
468: FND_MESSAGE.set_token('PHASE', '4');
469: FND_MSG_PUB.ADD;
470: END IF;
471:
472: -- Print the message stack to the log file

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

494: EXCEPTION
495: WHEN program_exception THEN
496: x_return_status := fnd_api.g_ret_sts_error;
497:
498: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
499: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
500: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
501: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
502: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

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

495: WHEN program_exception THEN
496: x_return_status := fnd_api.g_ret_sts_error;
497:
498: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
499: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
500: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
501: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
502: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
503: FND_MSG_PUB.ADD;

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

496: x_return_status := fnd_api.g_ret_sts_error;
497:
498: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
499: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
500: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
501: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
502: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
503: FND_MSG_PUB.ADD;
504: END IF;

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

497:
498: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
499: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
500: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
501: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
502: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
503: FND_MSG_PUB.ADD;
504: END IF;
505:

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

534: ,substrb(SQLERRM,1,250));
535: END IF;
536:
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
538: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
539: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
540: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
541: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
542: FND_MSG_PUB.ADD;

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

535: END IF;
536:
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
538: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
539: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
540: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
541: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
542: FND_MSG_PUB.ADD;
543: END IF;

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

536:
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
538: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
539: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
540: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
541: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
542: FND_MSG_PUB.ADD;
543: END IF;
544:

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

537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
538: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
539: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
540: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
541: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
542: FND_MSG_PUB.ADD;
543: END IF;
544:
545: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Match_RevenueCOGS:'||substrb(SQLERRM,1,250) );

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

678: );
679:
680: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
681: x_return_status := fnd_api.g_ret_sts_error;
682: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_SO_INSERT');
683: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(cv_so_issues.cogs_om_line_id));
684: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(cv_so_issues.mmt_txn_id));
685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
686: FND_MSG_PUB.ADD;

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

679:
680: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
681: x_return_status := fnd_api.g_ret_sts_error;
682: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_SO_INSERT');
683: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(cv_so_issues.cogs_om_line_id));
684: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(cv_so_issues.mmt_txn_id));
685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
686: FND_MSG_PUB.ADD;
687: END IF;

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

680: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
681: x_return_status := fnd_api.g_ret_sts_error;
682: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_SO_INSERT');
683: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(cv_so_issues.cogs_om_line_id));
684: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(cv_so_issues.mmt_txn_id));
685: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
686: FND_MSG_PUB.ADD;
687: END IF;
688: IF l_errorLog THEN

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

719: ,'Insert_SoIssues ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
720: END IF;
721:
722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
723: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
724: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
725: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
726: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
727: FND_MSG_PUB.ADD;

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

720: END IF;
721:
722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
723: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
724: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
725: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
726: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
727: FND_MSG_PUB.ADD;
728: END IF;

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

721:
722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
723: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
724: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
725: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
726: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
727: FND_MSG_PUB.ADD;
728: END IF;
729:

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

722: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
723: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
724: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
725: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
726: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
727: FND_MSG_PUB.ADD;
728: END IF;
729:
730: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_SoIssues:'||substrb(SQLERRM,1,250) );

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

1262: x_error_message => l_error_message);
1263:
1264: IF (l_return_num <> 0) THEN
1265: x_return_status := fnd_api.g_ret_sts_error;
1266: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
1267: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
1268: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
1269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1270: FND_MSG_PUB.ADD;

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

1263:
1264: IF (l_return_num <> 0) THEN
1265: x_return_status := fnd_api.g_ret_sts_error;
1266: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
1267: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
1268: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
1269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1270: FND_MSG_PUB.ADD;
1271: END IF;

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

1264: IF (l_return_num <> 0) THEN
1265: x_return_status := fnd_api.g_ret_sts_error;
1266: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
1267: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
1268: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
1269: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1270: FND_MSG_PUB.ADD;
1271: END IF;
1272: IF l_errorLog THEN

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

1311: ,'Insert_RmaReceipts ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
1312: END IF;
1313:
1314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1315: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1316: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1317: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1318: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1319: FND_MSG_PUB.ADD;

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

1312: END IF;
1313:
1314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1315: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1316: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1317: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1318: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1319: FND_MSG_PUB.ADD;
1320: END IF;

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

1313:
1314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1315: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1316: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1317: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1318: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1319: FND_MSG_PUB.ADD;
1320: END IF;
1321: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_RmaReceipts:'||substrb(SQLERRM,1,250) );

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

1314: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1315: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1316: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1317: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
1318: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
1319: FND_MSG_PUB.ADD;
1320: END IF;
1321: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_RmaReceipts:'||substrb(SQLERRM,1,250) );
1322:

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

1886: AND effective_period_num = l_cogs_acct_period_num;
1887: EXCEPTION
1888: WHEN NO_DATA_FOUND THEN
1889: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1890: FND_MESSAGE.set_name('BOM', 'CST_NO_OPEN_GL_PERIOD');
1891: FND_MESSAGE.set_token('LEDGER', l_sob); -- to_char(l_sob.set_of_books_id)
1892: FND_MESSAGE.set_token('PERIOD_NAME',l_period_name);
1893: FND_MSG_PUB.ADD;
1894: IF l_errorLog THEN

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

1887: EXCEPTION
1888: WHEN NO_DATA_FOUND THEN
1889: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1890: FND_MESSAGE.set_name('BOM', 'CST_NO_OPEN_GL_PERIOD');
1891: FND_MESSAGE.set_token('LEDGER', l_sob); -- to_char(l_sob.set_of_books_id)
1892: FND_MESSAGE.set_token('PERIOD_NAME',l_period_name);
1893: FND_MSG_PUB.ADD;
1894: IF l_errorLog THEN
1895: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);

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

1888: WHEN NO_DATA_FOUND THEN
1889: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1890: FND_MESSAGE.set_name('BOM', 'CST_NO_OPEN_GL_PERIOD');
1891: FND_MESSAGE.set_token('LEDGER', l_sob); -- to_char(l_sob.set_of_books_id)
1892: FND_MESSAGE.set_token('PERIOD_NAME',l_period_name);
1893: FND_MSG_PUB.ADD;
1894: IF l_errorLog THEN
1895: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);
1896: END IF;

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

2352: x_error_message => l_error_message);
2353:
2354: IF (l_return_num <> 0) THEN
2355: x_return_status := fnd_api.g_ret_sts_error;
2356: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
2357: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
2358: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
2359: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2360: FND_MSG_PUB.ADD;

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

2353:
2354: IF (l_return_num <> 0) THEN
2355: x_return_status := fnd_api.g_ret_sts_error;
2356: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
2357: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
2358: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
2359: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2360: FND_MSG_PUB.ADD;
2361: END IF;

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

2354: IF (l_return_num <> 0) THEN
2355: x_return_status := fnd_api.g_ret_sts_error;
2356: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
2357: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
2358: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
2359: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2360: FND_MSG_PUB.ADD;
2361: END IF;
2362: IF l_errorLog THEN

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

2466: ROLLBACK TO Create_CogsRecEvents_PVT;
2467: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2468:
2469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2470: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2471: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2472: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2473: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2474: FND_MSG_PUB.ADD;

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

2467: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2468:
2469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2470: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2471: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2472: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2473: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2474: FND_MSG_PUB.ADD;
2475: END IF;

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

2468:
2469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2470: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2471: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2472: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2473: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2474: FND_MSG_PUB.ADD;
2475: END IF;
2476:

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

2469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2470: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2471: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2472: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2473: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2474: FND_MSG_PUB.ADD;
2475: END IF;
2476:
2477: IF l_unexpLog THEN

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

2639: x_msg_count => l_msg_count,
2640: x_msg_data => l_msg_data);
2641:
2642: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2643: FND_MESSAGE.set_name('BOM', 'CST_NO_REVENUE_OM_LINE');
2644: FND_MESSAGE.set_token('COGS_LINE_ID', to_char(p_cogs_om_line_id));
2645: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2646: FND_MSG_PUB.ADD;
2647: END IF;

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

2640: x_msg_data => l_msg_data);
2641:
2642: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2643: FND_MESSAGE.set_name('BOM', 'CST_NO_REVENUE_OM_LINE');
2644: FND_MESSAGE.set_token('COGS_LINE_ID', to_char(p_cogs_om_line_id));
2645: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2646: FND_MSG_PUB.ADD;
2647: END IF;
2648:

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

2813: ,'Insert_OneSoIssue ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
2814: END IF;
2815:
2816: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2817: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2818: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2819: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2820: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2821: FND_MSG_PUB.ADD;

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

2814: END IF;
2815:
2816: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2817: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2818: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2819: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2820: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2821: FND_MSG_PUB.ADD;
2822: END IF;

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

2815:
2816: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2817: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2818: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2819: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2820: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2821: FND_MSG_PUB.ADD;
2822: END IF;
2823: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_OneSoIssue:'||substrb(SQLERRM,1,250) );

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

2816: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2817: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2818: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2819: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
2820: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
2821: FND_MSG_PUB.ADD;
2822: END IF;
2823: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_OneSoIssue:'||substrb(SQLERRM,1,250) );
2824: END Insert_OneSoIssue;

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

3321: x_error_message => l_error_message);
3322:
3323: IF (l_return_num <> 0) THEN
3324: x_return_status := fnd_api.g_ret_sts_error;
3325: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
3326: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
3327: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
3328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3329: FND_MSG_PUB.ADD;

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

3322:
3323: IF (l_return_num <> 0) THEN
3324: x_return_status := fnd_api.g_ret_sts_error;
3325: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
3326: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
3327: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
3328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3329: FND_MSG_PUB.ADD;
3330: END IF;

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

3323: IF (l_return_num <> 0) THEN
3324: x_return_status := fnd_api.g_ret_sts_error;
3325: FND_MESSAGE.set_name('BOM', 'CST_FAILED_COGSREC_MMT_INSERT');
3326: FND_MESSAGE.set_token('ERROR_CODE', l_error_code);
3327: FND_MESSAGE.set_token('ERROR_MESSAGE',substr(l_error_message,1,500));
3328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3329: FND_MSG_PUB.ADD;
3330: END IF;
3331: IF l_errorLog THEN

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

3368: ,'Insert_OneRmaReceipt '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
3369: END IF;
3370:
3371: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3372: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3373: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3374: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3375: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3376: FND_MSG_PUB.ADD;

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

3369: END IF;
3370:
3371: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3372: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3373: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3374: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3375: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3376: FND_MSG_PUB.ADD;
3377: END IF;

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

3370:
3371: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3372: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3373: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3374: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3375: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3376: FND_MSG_PUB.ADD;
3377: END IF;
3378:

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

3371: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3372: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3373: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3374: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3375: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3376: FND_MSG_PUB.ADD;
3377: END IF;
3378:
3379: FND_MSG_PUB.count_and_get

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

3559: ,'Record_SoIssueCost '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
3560: END IF;
3561:
3562: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3563: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3564: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3565: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3566: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3567: FND_MSG_PUB.ADD;

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

3560: END IF;
3561:
3562: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3563: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3564: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3565: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3566: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3567: FND_MSG_PUB.ADD;
3568: END IF;

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

3561:
3562: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3563: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3564: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3565: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3566: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3567: FND_MSG_PUB.ADD;
3568: END IF;
3569:

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

3562: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3563: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3564: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3565: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3566: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3567: FND_MSG_PUB.ADD;
3568: END IF;
3569:
3570: FND_MSG_PUB.count_and_get

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

3724: );
3725:
3726: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3727: x_return_status := fnd_api.g_ret_sts_error;
3728: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_RMA_INSERT');
3729: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(p_cogs_om_line_id));
3730: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(p_transaction_id));
3731: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3732: FND_MSG_PUB.ADD;

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

3725:
3726: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3727: x_return_status := fnd_api.g_ret_sts_error;
3728: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_RMA_INSERT');
3729: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(p_cogs_om_line_id));
3730: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(p_transaction_id));
3731: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3732: FND_MSG_PUB.ADD;
3733: END IF;

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

3726: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3727: x_return_status := fnd_api.g_ret_sts_error;
3728: FND_MESSAGE.set_name('BOM', 'CST_FAILED_DEFCOGS_RMA_INSERT');
3729: FND_MESSAGE.set_token('COGS_OM_LINE', to_char(p_cogs_om_line_id));
3730: FND_MESSAGE.set_token('MMT_TXN_ID',to_char(p_transaction_id));
3731: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3732: FND_MSG_PUB.ADD;
3733: END IF;
3734: IF l_errorLog THEN

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

3834: WHEN program_exception THEN
3835: ROLLBACK TO Process_RmaReceipt_PVT;
3836: x_return_status := fnd_api.g_ret_sts_error ;
3837:
3838: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
3839: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3840: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3841: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3842: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

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

3835: ROLLBACK TO Process_RmaReceipt_PVT;
3836: x_return_status := fnd_api.g_ret_sts_error ;
3837:
3838: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
3839: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3840: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3841: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3842: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3843: FND_MSG_PUB.ADD;

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

3836: x_return_status := fnd_api.g_ret_sts_error ;
3837:
3838: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
3839: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3840: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3841: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3842: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3843: FND_MSG_PUB.ADD;
3844: END IF;

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

3837:
3838: FND_MESSAGE.set_name('BOM', 'CST_PLSQL_ERROR');
3839: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3840: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3841: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3842: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3843: FND_MSG_PUB.ADD;
3844: END IF;
3845:

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

3862: ,'Process_RmaReceipt '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
3863: END IF;
3864:
3865: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3866: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3867: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3868: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3869: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3870: FND_MSG_PUB.ADD;

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

3863: END IF;
3864:
3865: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3866: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3867: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3868: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3869: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3870: FND_MSG_PUB.ADD;
3871: END IF;

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

3864:
3865: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3866: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3867: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3868: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3869: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3870: FND_MSG_PUB.ADD;
3871: END IF;
3872:

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

3865: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3866: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
3867: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
3868: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
3869: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
3870: FND_MSG_PUB.ADD;
3871: END IF;
3872:
3873: FND_MSG_PUB.count_and_get

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

4067: ,'Process_CogsRecognitionTxn ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
4068: END IF;
4069:
4070: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4071: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4072: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4073: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4074: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4075: FND_MSG_PUB.ADD;

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

4068: END IF;
4069:
4070: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4071: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4072: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4073: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4074: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4075: FND_MSG_PUB.ADD;
4076: END IF;

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

4069:
4070: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4071: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4072: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4073: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4074: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4075: FND_MSG_PUB.ADD;
4076: END IF;
4077:

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

4070: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4071: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4072: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4073: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4074: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4075: FND_MSG_PUB.ADD;
4076: END IF;
4077:
4078: FND_MSG_PUB.count_and_get

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

4534: ,'Cost_BulkCogsRecTxns '||to_char(l_stmt_num)||' : '||substr(SQLERRM,1,200));
4535: END IF;
4536:
4537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4538: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4539: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4540: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4541: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4542: FND_MSG_PUB.ADD;

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

4535: END IF;
4536:
4537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4538: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4539: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4540: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4541: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4542: FND_MSG_PUB.ADD;
4543: END IF;

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

4536:
4537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4538: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4539: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4540: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4541: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4542: FND_MSG_PUB.ADD;
4543: END IF;
4544:

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

4537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4538: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4539: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4540: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4541: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4542: FND_MSG_PUB.ADD;
4543: END IF;
4544:
4545: END Cost_BulkCogsRecTxns;

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

4782: ,'Insert_PacSoIssue ('||to_char(l_stmt_num)||') : '||substr(SQLERRM,1,200));
4783: END IF;
4784:
4785: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4786: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4787: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4788: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4789: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4790: FND_MSG_PUB.ADD;

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

4783: END IF;
4784:
4785: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4786: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4787: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4788: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4789: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4790: FND_MSG_PUB.ADD;
4791: END IF;

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

4784:
4785: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4786: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4787: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4788: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4789: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4790: FND_MSG_PUB.ADD;
4791: END IF;
4792:

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

4785: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4786: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
4787: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
4788: FND_MESSAGE.set_token('PROCEDURE',l_api_name);
4789: FND_MESSAGE.set_token('STATEMENT',to_char(l_stmt_num));
4790: FND_MSG_PUB.ADD;
4791: END IF;
4792:
4793: FND_MSG_PUB.count_and_get

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

6643: IF ctrx%ISOPEN THEN CLOSE ctrx; END IF;
6644: IF next_inv_period%ISOPEN THEN CLOSE next_inv_period; END IF;
6645: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6646: debug('OTHERS EXCEPTION ensure_mmt_per_and_date:'||SQLERRM);
6647: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');
6648: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');
6649: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');
6650: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));
6651: fnd_msg_pub.ADD;

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

6644: IF next_inv_period%ISOPEN THEN CLOSE next_inv_period; END IF;
6645: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6646: debug('OTHERS EXCEPTION ensure_mmt_per_and_date:'||SQLERRM);
6647: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');
6648: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');
6649: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');
6650: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));
6651: fnd_msg_pub.ADD;
6652: fnd_msg_pub.count_and_get(

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

6645: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6646: debug('OTHERS EXCEPTION ensure_mmt_per_and_date:'||SQLERRM);
6647: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');
6648: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');
6649: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');
6650: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));
6651: fnd_msg_pub.ADD;
6652: fnd_msg_pub.count_and_get(
6653: p_encoded => fnd_api.g_false,

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

6646: debug('OTHERS EXCEPTION ensure_mmt_per_and_date:'||SQLERRM);
6647: fnd_message.set_name('BOM', 'CST_UNEXP_ERROR');
6648: fnd_message.set_token('PACKAGE', 'CST_REVENUECOGSMATCH_PVT');
6649: fnd_message.set_token('PROCEDURE','ensure_mmt_per_and_date');
6650: fnd_message.set_token('STATEMENT',to_char(l_stmt_num));
6651: fnd_msg_pub.ADD;
6652: fnd_msg_pub.count_and_get(
6653: p_encoded => fnd_api.g_false,
6654: p_count => x_msg_count,