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.OKC_TERMS_DEVIATIONS_PVT dependencies on FND_MSG_PUB

Line 176: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

172: '140: Leaving Populate_Teamplate_articles because of EXCEPTION: '||sqlerrm);
173: END IF;
174:
175: x_return_status := G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
177: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
178: END IF;
179:
180: End Populate_Template_Articles;

Line 177: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

173: END IF;
174:
175: x_return_status := G_RET_STS_UNEXP_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
177: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
178: END IF;
179:
180: End Populate_Template_Articles;
181:

Line 289: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

285: '230: Leaving Populate_Expert_articles because of EXCEPTION: '||sqlerrm);
286: END IF;
287:
288: x_return_status := G_RET_STS_UNEXP_ERROR;
289: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
290: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
291: END IF;
292: end Populate_Expert_Articles;
293:

Line 290: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

286: END IF;
287:
288: x_return_status := G_RET_STS_UNEXP_ERROR;
289: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
290: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
291: END IF;
292: end Populate_Expert_Articles;
293:
294: /*

Line 506: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

502: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
503: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'730: Leaving Update_Deviation_details : FND_API.G_EXC_UNEXPECTED_ERROR');
504: END IF;
505: x_return_status := G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
507: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
508: END IF;
509: end;
510:

Line 507: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

503: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'730: Leaving Update_Deviation_details : FND_API.G_EXC_UNEXPECTED_ERROR');
504: END IF;
505: x_return_status := G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
507: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
508: END IF;
509: end;
510:
511: /*

Line 550: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

546: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'810: Leaving remove_duplicate_deviations : FND_API.G_EXC_UNEXPECTED_ERROR');
548: END IF;
549: x_return_status := G_RET_STS_UNEXP_ERROR;
550: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
552: END IF;
553:
554: end;

Line 551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

547: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'810: Leaving remove_duplicate_deviations : FND_API.G_EXC_UNEXPECTED_ERROR');
548: END IF;
549: x_return_status := G_RET_STS_UNEXP_ERROR;
550: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
552: END IF;
553:
554: end;
555:

Line 566: FND_MSG_PUB.initialize;

562: x_include_exp := 'N';
563: l_init_msg_list := FND_API.G_FALSE;
564: l_api_version := 1;
565:
566: FND_MSG_PUB.initialize;
567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
569: '300: Entered GENERATE_DEVIATIONS');
570: END IF;

Line 1280: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1276: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1277: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'200: Leaving Generate_Deviations : FND_API.G_EXC_UNEXPECTED_ERROR');
1278: END IF;
1279: x_return_status := G_RET_STS_UNEXP_ERROR ;
1280: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1281:
1282: WHEN OTHERS THEN
1283: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1284: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving Generate_Deviations because of EXCEPTION: '||sqlerrm);

Line 1292: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1288: CLOSE dev_cat;
1289: END IF;
1290:
1291: x_return_status := G_RET_STS_UNEXP_ERROR ;
1292: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1293: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1294: END IF;
1295: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1296: end Generate_Terms_Deviations;

Line 1293: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1289: END IF;
1290:
1291: x_return_status := G_RET_STS_UNEXP_ERROR ;
1292: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1293: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1294: END IF;
1295: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1296: end Generate_Terms_Deviations;
1297:

Line 1295: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1291: x_return_status := G_RET_STS_UNEXP_ERROR ;
1292: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1293: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1294: END IF;
1295: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1296: end Generate_Terms_Deviations;
1297:
1298: -- this procedure will insert data into
1299: -- okc_terms_deviations_t table

Line 1410: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1406: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,
1407: '530: Leaving Insert_Deviations because of EXCEPTION: '||sqlerrm);
1408: END IF;
1409: x_return_status := G_RET_STS_UNEXP_ERROR;
1410: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1411: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1412: END IF;
1413: end Insert_deviations;
1414:

Line 1411: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1407: '530: Leaving Insert_Deviations because of EXCEPTION: '||sqlerrm);
1408: END IF;
1409: x_return_status := G_RET_STS_UNEXP_ERROR;
1410: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1411: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1412: END IF;
1413: end Insert_deviations;
1414:
1415:

Line 1432: FND_MSG_PUB.initialize;

1428: for update of doc_article_id nowait;
1429: begin
1430: SAVEPOINT purge_deviations_data;
1431: l_return_status := G_RET_STS_SUCCESS;
1432: FND_MSG_PUB.initialize;
1433:
1434: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_num_days: '||p_num_days);
1435: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entered into Purge Deviations');
1436:

Line 1470: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1466: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1467: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'660: Other exception');
1468: END IF;
1469: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception Others: '|| sqlerrm);
1470: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1471: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1472: END IF;
1473:
1474:

Line 1471: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1467: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_api_name,'660: Other exception');
1468: END IF;
1469: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception Others: '|| sqlerrm);
1470: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1471: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1472: END IF;
1473:
1474:
1475: end purge_deviations_data;