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.

APPS.CST_REVENUECOGSMATCH_PVT dependencies on FND_MSG_PUB

Line 186: FND_MSG_PUB.initialize;

182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END IF;
184:
185: -- Initialize message list if p_init_msg_list is set to TRUE
186: FND_MSG_PUB.initialize;
187:
188: -- Initialize API return status to success
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190:

Line 282: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

278: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'
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;

Line 285: FND_MSG_PUB.ADD;

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;
289:

Line 350: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

346: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'
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;

Line 353: FND_MSG_PUB.ADD;

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;
357:

Line 479: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

475: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'
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;

Line 482: FND_MSG_PUB.ADD;

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;
486:

Line 518: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

514: FND_LOG.string(FND_LOG.LEVEL_EVENT,l_module||'.20'
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;

Line 521: FND_MSG_PUB.ADD;

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
525: Print_MessageStack;

Line 553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

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:
557: IF l_errorLog THEN

Line 554: FND_MSG_PUB.ADD;

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:
557: IF l_errorLog THEN
558: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);

Line 567: fnd_msg_pub.Count_And_Get

563: DECLARE
564: l_cnt NUMBER;
565: l_data VARCHAR2(2000);
566: BEGIN
567: fnd_msg_pub.Count_And_Get
568: (p_encoded => 'T',
569: p_count => l_cnt,
570: p_data => l_data);
571: FND_FILE.put_line

Line 588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

584: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
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));

Line 593: FND_MSG_PUB.ADD;

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) );
597:

Line 776: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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
780: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.10',TRUE);

Line 777: FND_MSG_PUB.ADD;

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
780: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.10',TRUE);
781: END IF;

Line 813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

809: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
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));

Line 818: FND_MSG_PUB.ADD;

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) );
822:

Line 1450: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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
1454: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);

Line 1451: FND_MSG_PUB.ADD;

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
1454: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);
1455: END IF;

Line 1495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1491: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
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));

Line 1500: FND_MSG_PUB.ADD;

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:
1504: END Insert_RmaReceipts;

Line 1918: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

1914: debug(l_stmt_num||'- COGS accounting period l_max_period_num period:'||l_max_period_num);
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;

Line 1922: FND_MSG_PUB.ADD;

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);
1926: END IF;

Line 2407: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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
2411: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);

Line 2408: FND_MSG_PUB.ADD;

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
2411: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);
2412: END IF;

Line 2522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2518: WHEN OTHERS THEN
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));

Line 2527: FND_MSG_PUB.ADD;

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
2531: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

Line 2646: FND_MSG_PUB.initialize;

2642: END IF;
2643:
2644: -- Initialize message list if p_init_msg_list is set to TRUE
2645: IF FND_API.to_Boolean(p_init_msg_list) THEN
2646: FND_MSG_PUB.initialize;
2647: END IF;
2648:
2649: -- Initialize API return status to success
2650: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2682: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

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:
2686: debug(' CST_NO_REVENUE_OM_LINE for p_cogs_om_line_id : '||p_cogs_om_line_id);

Line 2683: FND_MSG_PUB.ADD;

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:
2686: debug(' CST_NO_REVENUE_OM_LINE for p_cogs_om_line_id : '||p_cogs_om_line_id);
2687:

Line 2854: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2850: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
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));

Line 2859: FND_MSG_PUB.ADD;

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;
2863:

Line 2971: FND_MSG_PUB.initialize;

2967: END IF;
2968:
2969: -- Initialize message list if p_init_msg_list is set to TRUE
2970: IF FND_API.to_Boolean(p_init_msg_list) THEN
2971: FND_MSG_PUB.initialize;
2972: END IF;
2973:
2974: -- Initialize API return status to success
2975: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3354: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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
3358: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);

Line 3355: FND_MSG_PUB.ADD;

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
3358: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.'||to_char(l_stmt_num),TRUE);
3359: END IF;

Line 3375: FND_MSG_PUB.count_and_get

3371: x_cogs_percentage := l_cogs_percentage;
3372:
3373: -- End API Body
3374:
3375: FND_MSG_PUB.count_and_get
3376: ( p_count => x_msg_count
3377: , p_data => x_msg_data
3378: );
3379:

Line 3404: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3400: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
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));

Line 3409: FND_MSG_PUB.ADD;

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
3413: ( p_count => x_msg_count

Line 3412: FND_MSG_PUB.count_and_get

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
3413: ( p_count => x_msg_count
3414: , p_data => x_msg_data
3415: );
3416: FND_FILE.put_line(fnd_file.log, 'OTHERS EXCEPTION IN Insert_OneRmaReceipt:'||substrb(SQLERRM,1,250) );

Line 3517: FND_MSG_PUB.initialize;

3513: END IF;
3514:
3515: -- Initialize message list if p_init_msg_list is set to TRUE
3516: IF FND_API.to_Boolean(p_init_msg_list) THEN
3517: FND_MSG_PUB.initialize;
3518: END IF;
3519:
3520: -- Initialize API return status to success
3521: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3570: FND_MSG_PUB.count_and_get

3566: AND nvl(pac_cost_type_id,0) = nvl(p_pac_cost_type_id,0);
3567:
3568: -- End API Body
3569:
3570: FND_MSG_PUB.count_and_get
3571: ( p_count => x_msg_count
3572: , p_data => x_msg_data
3573: , p_encoded => FND_API.g_false
3574: );

Line 3595: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3591: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
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));

Line 3600: FND_MSG_PUB.ADD;

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
3604: ( p_count => x_msg_count

Line 3603: FND_MSG_PUB.count_and_get

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
3604: ( p_count => x_msg_count
3605: , p_data => x_msg_data
3606: , p_encoded => FND_API.g_false
3607: );

Line 3765: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) 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
3769: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.10',TRUE);

Line 3766: FND_MSG_PUB.ADD;

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
3769: FND_LOG.message(FND_LOG.LEVEL_ERROR, l_module||'.10',TRUE);
3770: END IF;

Line 3883: FND_MSG_PUB.count_and_get

3879: WHERE mmt_transaction_id = p_transaction_id;
3880:
3881: -- End API Body
3882:
3883: FND_MSG_PUB.count_and_get
3884: ( p_count => x_msg_count
3885: , p_data => x_msg_data
3886: , p_encoded => FND_API.g_false
3887: );

Line 3906: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

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:
3910: IF l_errorLog THEN

Line 3907: FND_MSG_PUB.ADD;

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:
3910: IF l_errorLog THEN
3911: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);

Line 3914: FND_MSG_PUB.count_and_get

3910: IF l_errorLog THEN
3911: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);
3912: END IF;
3913:
3914: FND_MSG_PUB.count_and_get
3915: ( p_count => x_msg_count,
3916: p_data => x_msg_data,
3917: p_encoded => FND_API.g_false
3918: );

Line 3929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3925: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module||'.'||l_stmt_num
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));

Line 3934: FND_MSG_PUB.ADD;

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
3938: ( p_count => x_msg_count

Line 3937: FND_MSG_PUB.count_and_get

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
3938: ( p_count => x_msg_count
3939: , p_data => x_msg_data
3940: , p_encoded => FND_API.g_false
3941: );

Line 4111: FND_MSG_PUB.count_and_get

4107:
4108:
4109: -- End API Body
4110:
4111: FND_MSG_PUB.count_and_get
4112: ( p_count => x_msg_count
4113: , p_data => x_msg_data
4114: , p_encoded => FND_API.g_false
4115: );

Line 4134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4130: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
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));

Line 4139: FND_MSG_PUB.ADD;

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
4143: ( p_count => x_msg_count

Line 4142: FND_MSG_PUB.count_and_get

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
4143: ( p_count => x_msg_count
4144: , p_data => x_msg_data
4145: , p_encoded => FND_API.g_false
4146: );

Line 4613: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4609: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||l_stmt_num
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));

Line 4618: FND_MSG_PUB.ADD;

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;
4622:

Line 4715: FND_MSG_PUB.initialize;

4711: END IF;
4712:
4713: -- Initialize message list if p_init_msg_list is set to TRUE
4714: IF FND_API.to_Boolean(p_init_msg_list) THEN
4715: FND_MSG_PUB.initialize;
4716: END IF;
4717:
4718: -- Initialize API return status to success
4719: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4872: FND_MSG_PUB.count_and_get

4868: 'x_return_status = '||x_return_status
4869: );
4870: END IF;
4871:
4872: FND_MSG_PUB.count_and_get
4873: ( p_count => x_msg_count
4874: , p_data => x_msg_data
4875: , p_encoded => FND_API.g_false
4876: );

Line 4891: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4887: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
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));

Line 4896: FND_MSG_PUB.ADD;

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
4900: ( p_count => x_msg_count

Line 4899: FND_MSG_PUB.count_and_get

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
4900: ( p_count => x_msg_count
4901: , p_data => x_msg_data
4902: , p_encoded => FND_API.g_false
4903: );

Line 5302: FND_MSG_PUB.count_and_get

5298: procedure Print_MessageStack IS
5299: l_msg_count NUMBER;
5300: l_msg_data VARCHAR2(8000);
5301: BEGIN
5302: FND_MSG_PUB.count_and_get
5303: ( p_count => l_msg_count,
5304: p_data => l_msg_data,
5305: p_encoded => FND_API.g_false
5306: );

Line 5309: l_msg_data := FND_MSG_PUB.get(i, FND_API.g_false);

5305: p_encoded => FND_API.g_false
5306: );
5307: IF (l_msg_count > 1) THEN
5308: FOR i IN 1..l_msg_count LOOP
5309: l_msg_data := FND_MSG_PUB.get(i, FND_API.g_false);
5310: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
5311: END LOOP;
5312: ELSIF (l_msg_count = 1) THEN
5313: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

Line 5317: FND_MSG_PUB.initialize;

5313: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
5314: END IF;
5315:
5316: -- Reinitialize the message list
5317: FND_MSG_PUB.initialize;
5318:
5319: END Print_MessageStack;
5320:
5321: /*===========================================================================*/

Line 5447: fnd_msg_pub.initialize;

5443: dbms_lob.writeappend (l_xml_doc, 8, '');
5444:
5445: -- Initialize message stack
5446:
5447: fnd_msg_pub.initialize;
5448:
5449: -- Standard call to get message count and if count is 1, get message info.
5450:
5451: fnd_msg_pub.Count_And_Get

Line 5451: fnd_msg_pub.Count_And_Get

5447: fnd_msg_pub.initialize;
5448:
5449: -- Standard call to get message count and if count is 1, get message info.
5450:
5451: fnd_msg_pub.Count_And_Get
5452: ( p_count => l_msg_count,
5453: p_data => l_msg_data
5454: );
5455:

Line 5579: fnd_msg_pub.Count_And_Get

5575:
5576: exception
5577: when fnd_api.G_EXC_ERROR then
5578: l_return_status := fnd_api.G_RET_STS_ERROR ;
5579: fnd_msg_pub.Count_And_Get
5580: ( p_count => l_msg_count,
5581: p_data => l_msg_data
5582: );
5583:

Line 5585: fnd_msg_pub.Count_And_Get

5581: p_data => l_msg_data
5582: );
5583:
5584: when fnd_api.G_EXC_UNEXPECTED_ERROR then
5585: fnd_msg_pub.Count_And_Get
5586: ( p_count => l_msg_count,
5587: p_data => l_msg_data
5588: );
5589:

Line 5607: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then

5603: l_module || '.' || l_stmt_num,
5604: substrb(SQLERRM , 1 , 240));
5605: end if;
5606:
5607: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
5608: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5609: end if;
5610:
5611: fnd_msg_pub.Count_And_Get

Line 5608: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME,l_api_name);

5604: substrb(SQLERRM , 1 , 240));
5605: end if;
5606:
5607: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
5608: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5609: end if;
5610:
5611: fnd_msg_pub.Count_And_Get
5612: ( p_count => l_msg_count,

Line 5611: fnd_msg_pub.Count_And_Get

5607: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
5608: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5609: end if;
5610:
5611: fnd_msg_pub.Count_And_Get
5612: ( p_count => l_msg_count,
5613: p_data => l_msg_data
5614: );
5615:

Line 5742: fnd_msg_pub.initialize;

5738:
5739: -- Initialize message list if p_init_msg_list is set to TRUE.
5740:
5741: if(fnd_api.to_boolean( p_init_msg_list )) then
5742: fnd_msg_pub.initialize;
5743: end if;
5744:
5745: -- Initialize API return status to success
5746:

Line 5862: fnd_msg_pub.Count_And_Get

5858: dbms_lob.freetemporary(l_xml_temp);
5859:
5860: -- Standard call to get message count and if count is 1, get message info.
5861:
5862: fnd_msg_pub.Count_And_Get
5863: ( p_count => x_msg_count,
5864: p_data => x_msg_data
5865: );
5866:

Line 5876: fnd_msg_pub.Count_And_Get

5872:
5873: exception
5874: when fnd_api.G_EXC_ERROR then
5875: x_return_status := fnd_api.G_RET_STS_ERROR;
5876: fnd_msg_pub.Count_And_Get
5877: ( p_count => x_msg_count,
5878: p_data => x_msg_data
5879: );
5880:

Line 5883: fnd_msg_pub.Count_And_Get

5879: );
5880:
5881: when fnd_api.G_EXC_UNEXPECTED_ERROR then
5882: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
5883: fnd_msg_pub.Count_And_Get
5884: ( p_count => x_msg_count,
5885: p_data => x_msg_data
5886: );
5887:

Line 5896: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then

5892: l_module || '.' || l_stmt_num,
5893: substrb(SQLERRM , 1 , 240));
5894: end if;
5895:
5896: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
5897: fnd_msg_pub.Add_Exc_Msg
5898: ( G_PKG_NAME,
5899: l_api_name
5900: );

Line 5897: fnd_msg_pub.Add_Exc_Msg

5893: substrb(SQLERRM , 1 , 240));
5894: end if;
5895:
5896: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
5897: fnd_msg_pub.Add_Exc_Msg
5898: ( G_PKG_NAME,
5899: l_api_name
5900: );
5901: end if;

Line 5903: fnd_msg_pub.Count_And_Get

5899: l_api_name
5900: );
5901: end if;
5902:
5903: fnd_msg_pub.Count_And_Get
5904: ( p_count => x_msg_count,
5905: p_data => x_msg_data
5906: );
5907:

Line 6017: fnd_msg_pub.initialize;

6013:
6014: -- Initialize message list if p_init_msg_list is set to TRUE.
6015:
6016: if(fnd_api.to_boolean(p_init_msg_list)) then
6017: fnd_msg_pub.initialize;
6018: end if;
6019:
6020: -- Initialize API return status to success
6021:

Line 6746: fnd_msg_pub.Count_And_Get

6742: dbms_lob.freetemporary(l_xml_temp);
6743:
6744: -- Standard call to get message count and if count is 1, get message info.
6745:
6746: fnd_msg_pub.Count_And_Get
6747: ( p_count => x_msg_count,
6748: p_data => x_msg_data
6749: );
6750:

Line 6760: fnd_msg_pub.Count_And_Get

6756:
6757: exception
6758: when fnd_api.G_EXC_ERROR then
6759: x_return_status := fnd_api.G_RET_STS_ERROR;
6760: fnd_msg_pub.Count_And_Get
6761: ( p_count => x_msg_count,
6762: p_data => x_msg_data
6763: );
6764:

Line 6767: fnd_msg_pub.Count_And_Get

6763: );
6764:
6765: when fnd_api.G_EXC_UNEXPECTED_ERROR then
6766: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
6767: fnd_msg_pub.Count_And_Get
6768: ( p_count => x_msg_count,
6769: p_data => x_msg_data
6770: );
6771:

Line 6780: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then

6776: l_module || '.' || l_stmt_num,
6777: substrb(SQLERRM , 1 , 240));
6778: end if;
6779:
6780: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
6781: fnd_msg_pub.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6782: end if;
6783:
6784: fnd_msg_pub.Count_And_Get

Line 6781: fnd_msg_pub.Add_Exc_Msg (G_PKG_NAME, l_api_name);

6777: substrb(SQLERRM , 1 , 240));
6778: end if;
6779:
6780: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
6781: fnd_msg_pub.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6782: end if;
6783:
6784: fnd_msg_pub.Count_And_Get
6785: ( p_count => x_msg_count,

Line 6784: fnd_msg_pub.Count_And_Get

6780: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
6781: fnd_msg_pub.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6782: end if;
6783:
6784: fnd_msg_pub.Count_And_Get
6785: ( p_count => x_msg_count,
6786: p_data => x_msg_data
6787: );
6788:

Line 6995: fnd_msg_pub.ADD;

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,
6999: p_data => x_msg_data);

Line 6996: fnd_msg_pub.count_and_get(

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,
6999: p_data => x_msg_data);
7000: END ensure_mmt_per_and_date;