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 154: FND_MSG_PUB.initialize;

150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152:
153: -- Initialize message list if p_init_msg_list is set to TRUE
154: FND_MSG_PUB.initialize;
155:
156: -- Initialize API return status to success
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158:

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

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

Line 224: FND_MSG_PUB.ADD;

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

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

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

Line 292: FND_MSG_PUB.ADD;

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

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

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

Line 430: FND_MSG_PUB.ADD;

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

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

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

Line 469: FND_MSG_PUB.ADD;

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

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

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

Line 503: FND_MSG_PUB.ADD;

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

Line 516: fnd_msg_pub.Count_And_Get

512: DECLARE
513: l_cnt NUMBER;
514: l_data VARCHAR2(2000);
515: BEGIN
516: fnd_msg_pub.Count_And_Get
517: (p_encoded => 'T',
518: p_count => l_cnt,
519: p_data => l_data);
520: FND_FILE.put_line

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

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

Line 542: FND_MSG_PUB.ADD;

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

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

Line 686: FND_MSG_PUB.ADD;

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

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

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

Line 727: FND_MSG_PUB.ADD;

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

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

Line 1270: FND_MSG_PUB.ADD;

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

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

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

Line 1319: FND_MSG_PUB.ADD;

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

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

1885: AND ledger_id = l_sob --l_sob.set_of_books_id
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;

Line 1893: FND_MSG_PUB.ADD;

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

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

Line 2360: FND_MSG_PUB.ADD;

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

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

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

Line 2474: FND_MSG_PUB.ADD;

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

Line 2609: FND_MSG_PUB.initialize;

2605: END IF;
2606:
2607: -- Initialize message list if p_init_msg_list is set to TRUE
2608: IF FND_API.to_Boolean(p_init_msg_list) THEN
2609: FND_MSG_PUB.initialize;
2610: END IF;
2611:
2612: -- Initialize API return status to success
2613: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

Line 2646: FND_MSG_PUB.ADD;

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

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

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

Line 2821: FND_MSG_PUB.ADD;

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

Line 2947: FND_MSG_PUB.initialize;

2943: END IF;
2944:
2945: -- Initialize message list if p_init_msg_list is set to TRUE
2946: IF FND_API.to_Boolean(p_init_msg_list) THEN
2947: FND_MSG_PUB.initialize;
2948: END IF;
2949:
2950: -- Initialize API return status to success
2951: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3329: FND_MSG_PUB.ADD;

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

Line 3342: FND_MSG_PUB.count_and_get

3338: x_cogs_percentage := l_cogs_percentage;
3339:
3340: -- End API Body
3341:
3342: FND_MSG_PUB.count_and_get
3343: ( p_count => x_msg_count
3344: , p_data => x_msg_data
3345: );
3346:

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

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

Line 3376: FND_MSG_PUB.ADD;

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

Line 3379: FND_MSG_PUB.count_and_get

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

Line 3484: FND_MSG_PUB.initialize;

3480: END IF;
3481:
3482: -- Initialize message list if p_init_msg_list is set to TRUE
3483: IF FND_API.to_Boolean(p_init_msg_list) THEN
3484: FND_MSG_PUB.initialize;
3485: END IF;
3486:
3487: -- Initialize API return status to success
3488: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3537: FND_MSG_PUB.count_and_get

3533: AND nvl(pac_cost_type_id,0) = nvl(p_pac_cost_type_id,0);
3534:
3535: -- End API Body
3536:
3537: FND_MSG_PUB.count_and_get
3538: ( p_count => x_msg_count
3539: , p_data => x_msg_data
3540: , p_encoded => FND_API.g_false
3541: );

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

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

Line 3567: FND_MSG_PUB.ADD;

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

Line 3570: FND_MSG_PUB.count_and_get

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
3571: ( p_count => x_msg_count
3572: , p_data => x_msg_data
3573: , p_encoded => FND_API.g_false
3574: );

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

Line 3732: FND_MSG_PUB.ADD;

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

Line 3819: FND_MSG_PUB.count_and_get

3815: WHERE mmt_transaction_id = p_transaction_id;
3816:
3817: -- End API Body
3818:
3819: FND_MSG_PUB.count_and_get
3820: ( p_count => x_msg_count
3821: , p_data => x_msg_data
3822: , p_encoded => FND_API.g_false
3823: );

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

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

Line 3843: FND_MSG_PUB.ADD;

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

Line 3850: FND_MSG_PUB.count_and_get

3846: IF l_errorLog THEN
3847: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,l_module||'.'||l_stmt_num,TRUE);
3848: END IF;
3849:
3850: FND_MSG_PUB.count_and_get
3851: ( p_count => x_msg_count,
3852: p_data => x_msg_data,
3853: p_encoded => FND_API.g_false
3854: );

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

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

Line 3870: FND_MSG_PUB.ADD;

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

Line 3873: FND_MSG_PUB.count_and_get

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
3874: ( p_count => x_msg_count
3875: , p_data => x_msg_data
3876: , p_encoded => FND_API.g_false
3877: );

Line 4047: FND_MSG_PUB.count_and_get

4043:
4044:
4045: -- End API Body
4046:
4047: FND_MSG_PUB.count_and_get
4048: ( p_count => x_msg_count
4049: , p_data => x_msg_data
4050: , p_encoded => FND_API.g_false
4051: );

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

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

Line 4075: FND_MSG_PUB.ADD;

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

Line 4078: FND_MSG_PUB.count_and_get

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
4079: ( p_count => x_msg_count
4080: , p_data => x_msg_data
4081: , p_encoded => FND_API.g_false
4082: );

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

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

Line 4542: FND_MSG_PUB.ADD;

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

Line 4638: FND_MSG_PUB.initialize;

4634: END IF;
4635:
4636: -- Initialize message list if p_init_msg_list is set to TRUE
4637: IF FND_API.to_Boolean(p_init_msg_list) THEN
4638: FND_MSG_PUB.initialize;
4639: END IF;
4640:
4641: -- Initialize API return status to success
4642: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4766: FND_MSG_PUB.count_and_get

4762: 'x_return_status = '||x_return_status
4763: );
4764: END IF;
4765:
4766: FND_MSG_PUB.count_and_get
4767: ( p_count => x_msg_count
4768: , p_data => x_msg_data
4769: , p_encoded => FND_API.g_false
4770: );

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

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

Line 4790: FND_MSG_PUB.ADD;

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

Line 4793: FND_MSG_PUB.count_and_get

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
4794: ( p_count => x_msg_count
4795: , p_data => x_msg_data
4796: , p_encoded => FND_API.g_false
4797: );

Line 5187: FND_MSG_PUB.count_and_get

5183: procedure Print_MessageStack IS
5184: l_msg_count NUMBER;
5185: l_msg_data VARCHAR2(8000);
5186: BEGIN
5187: FND_MSG_PUB.count_and_get
5188: ( p_count => l_msg_count,
5189: p_data => l_msg_data,
5190: p_encoded => FND_API.g_false
5191: );

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

5190: p_encoded => FND_API.g_false
5191: );
5192: IF (l_msg_count > 1) THEN
5193: FOR i IN 1..l_msg_count LOOP
5194: l_msg_data := FND_MSG_PUB.get(i, FND_API.g_false);
5195: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
5196: END LOOP;
5197: ELSIF (l_msg_count = 1) THEN
5198: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

Line 5202: FND_MSG_PUB.initialize;

5198: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);
5199: END IF;
5200:
5201: -- Reinitialize the message list
5202: FND_MSG_PUB.initialize;
5203:
5204: END Print_MessageStack;
5205:
5206: /*===========================================================================*/

Line 5328: fnd_msg_pub.initialize;

5324: dbms_lob.writeappend (l_xml_doc, 8, '');
5325:
5326: -- Initialize message stack
5327:
5328: fnd_msg_pub.initialize;
5329:
5330: -- Standard call to get message count and if count is 1, get message info.
5331:
5332: fnd_msg_pub.Count_And_Get

Line 5332: fnd_msg_pub.Count_And_Get

5328: fnd_msg_pub.initialize;
5329:
5330: -- Standard call to get message count and if count is 1, get message info.
5331:
5332: fnd_msg_pub.Count_And_Get
5333: ( p_count => l_msg_count,
5334: p_data => l_msg_data
5335: );
5336:

Line 5465: fnd_msg_pub.Count_And_Get

5461:
5462: exception
5463: when fnd_api.G_EXC_ERROR then
5464: l_return_status := fnd_api.G_RET_STS_ERROR ;
5465: fnd_msg_pub.Count_And_Get
5466: ( p_count => l_msg_count,
5467: p_data => l_msg_data
5468: );
5469:

Line 5471: fnd_msg_pub.Count_And_Get

5467: p_data => l_msg_data
5468: );
5469:
5470: when fnd_api.G_EXC_UNEXPECTED_ERROR then
5471: fnd_msg_pub.Count_And_Get
5472: ( p_count => l_msg_count,
5473: p_data => l_msg_data
5474: );
5475:

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

5489: l_module || '.' || l_stmt_num,
5490: substrb(SQLERRM , 1 , 240));
5491: end if;
5492:
5493: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
5494: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5495: end if;
5496:
5497: fnd_msg_pub.Count_And_Get

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

5490: substrb(SQLERRM , 1 , 240));
5491: end if;
5492:
5493: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
5494: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5495: end if;
5496:
5497: fnd_msg_pub.Count_And_Get
5498: ( p_count => l_msg_count,

Line 5497: fnd_msg_pub.Count_And_Get

5493: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
5494: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5495: end if;
5496:
5497: fnd_msg_pub.Count_And_Get
5498: ( p_count => l_msg_count,
5499: p_data => l_msg_data
5500: );
5501:

Line 5627: fnd_msg_pub.initialize;

5623:
5624: -- Initialize message list if p_init_msg_list is set to TRUE.
5625:
5626: if(fnd_api.to_boolean( p_init_msg_list )) then
5627: fnd_msg_pub.initialize;
5628: end if;
5629:
5630: -- Initialize API return status to success
5631:

Line 5745: fnd_msg_pub.Count_And_Get

5741: dbms_lob.freetemporary(l_xml_temp);
5742:
5743: -- Standard call to get message count and if count is 1, get message info.
5744:
5745: fnd_msg_pub.Count_And_Get
5746: ( p_count => x_msg_count,
5747: p_data => x_msg_data
5748: );
5749:

Line 5761: fnd_msg_pub.Count_And_Get

5757:
5758: exception
5759: when fnd_api.G_EXC_ERROR then
5760: x_return_status := fnd_api.G_RET_STS_ERROR;
5761: fnd_msg_pub.Count_And_Get
5762: ( p_count => x_msg_count,
5763: p_data => x_msg_data
5764: );
5765:

Line 5768: fnd_msg_pub.Count_And_Get

5764: );
5765:
5766: when fnd_api.G_EXC_UNEXPECTED_ERROR then
5767: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
5768: fnd_msg_pub.Count_And_Get
5769: ( p_count => x_msg_count,
5770: p_data => x_msg_data
5771: );
5772:

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

5777: l_module || '.' || l_stmt_num,
5778: substrb(SQLERRM , 1 , 240));
5779: end if;
5780:
5781: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
5782: fnd_msg_pub.Add_Exc_Msg
5783: ( G_PKG_NAME,
5784: l_api_name
5785: );

Line 5782: fnd_msg_pub.Add_Exc_Msg

5778: substrb(SQLERRM , 1 , 240));
5779: end if;
5780:
5781: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
5782: fnd_msg_pub.Add_Exc_Msg
5783: ( G_PKG_NAME,
5784: l_api_name
5785: );
5786: end if;

Line 5788: fnd_msg_pub.Count_And_Get

5784: l_api_name
5785: );
5786: end if;
5787:
5788: fnd_msg_pub.Count_And_Get
5789: ( p_count => x_msg_count,
5790: p_data => x_msg_data
5791: );
5792:

Line 5902: fnd_msg_pub.initialize;

5898:
5899: -- Initialize message list if p_init_msg_list is set to TRUE.
5900:
5901: if(fnd_api.to_boolean(p_init_msg_list)) then
5902: fnd_msg_pub.initialize;
5903: end if;
5904:
5905: -- Initialize API return status to success
5906:

Line 6409: fnd_msg_pub.Count_And_Get

6405: dbms_lob.freetemporary(l_xml_temp);
6406:
6407: -- Standard call to get message count and if count is 1, get message info.
6408:
6409: fnd_msg_pub.Count_And_Get
6410: ( p_count => x_msg_count,
6411: p_data => x_msg_data
6412: );
6413:

Line 6425: fnd_msg_pub.Count_And_Get

6421:
6422: exception
6423: when fnd_api.G_EXC_ERROR then
6424: x_return_status := fnd_api.G_RET_STS_ERROR;
6425: fnd_msg_pub.Count_And_Get
6426: ( p_count => x_msg_count,
6427: p_data => x_msg_data
6428: );
6429:

Line 6432: fnd_msg_pub.Count_And_Get

6428: );
6429:
6430: when fnd_api.G_EXC_UNEXPECTED_ERROR then
6431: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
6432: fnd_msg_pub.Count_And_Get
6433: ( p_count => x_msg_count,
6434: p_data => x_msg_data
6435: );
6436:

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

6441: l_module || '.' || l_stmt_num,
6442: substrb(SQLERRM , 1 , 240));
6443: end if;
6444:
6445: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
6446: fnd_msg_pub.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6447: end if;
6448:
6449: fnd_msg_pub.Count_And_Get

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

6442: substrb(SQLERRM , 1 , 240));
6443: end if;
6444:
6445: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
6446: fnd_msg_pub.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6447: end if;
6448:
6449: fnd_msg_pub.Count_And_Get
6450: ( p_count => x_msg_count,

Line 6449: fnd_msg_pub.Count_And_Get

6445: if(fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR)) then
6446: fnd_msg_pub.Add_Exc_Msg (G_PKG_NAME, l_api_name);
6447: end if;
6448:
6449: fnd_msg_pub.Count_And_Get
6450: ( p_count => x_msg_count,
6451: p_data => x_msg_data
6452: );
6453:

Line 6651: fnd_msg_pub.ADD;

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

Line 6652: fnd_msg_pub.count_and_get(

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