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_DELIVERABLE_PROCESS_PVT dependencies on FND_MSG_PUB

Line 1366: FND_MSG_PUB.Count_And_Get(

1362: IF del_cur %ISOPEN THEN
1363: CLOSE del_cur ;
1364: END IF;
1365: x_return_status := G_RET_STS_ERROR;
1366: FND_MSG_PUB.Count_And_Get(
1367: p_count => x_msg_count,
1368: p_data => x_msg_data
1369: );
1370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1378: FND_MSG_PUB.Count_And_Get(

1374: IF del_cur %ISOPEN THEN
1375: CLOSE del_cur ;
1376: END IF;
1377: x_return_status := G_RET_STS_UNEXP_ERROR;
1378: FND_MSG_PUB.Count_And_Get(
1379: p_count => x_msg_count,
1380: p_data => x_msg_data
1381: );
1382:

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

1387: IF del_cur %ISOPEN THEN
1388: CLOSE del_cur ;
1389: END IF;
1390: x_return_status := G_RET_STS_UNEXP_ERROR;
1391: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1392: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1393: END IF;
1394: FND_MSG_PUB.Count_And_Get(
1395: p_count => x_msg_count,

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

1388: CLOSE del_cur ;
1389: END IF;
1390: x_return_status := G_RET_STS_UNEXP_ERROR;
1391: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1392: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1393: END IF;
1394: FND_MSG_PUB.Count_And_Get(
1395: p_count => x_msg_count,
1396: p_data => x_msg_data

Line 1394: FND_MSG_PUB.Count_And_Get(

1390: x_return_status := G_RET_STS_UNEXP_ERROR;
1391: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1392: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1393: END IF;
1394: FND_MSG_PUB.Count_And_Get(
1395: p_count => x_msg_count,
1396: p_data => x_msg_data
1397: );
1398: END copy_del_for_amendment;

Line 3175: FND_MSG_PUB.Count_And_Get(

3171: IF del_cur %ISOPEN THEN
3172: CLOSE del_cur ;
3173: END IF;
3174: x_return_status := G_RET_STS_ERROR;
3175: FND_MSG_PUB.Count_And_Get(
3176: p_count => x_msg_count,
3177: p_data => x_msg_data
3178: );
3179:

Line 3190: FND_MSG_PUB.Count_And_Get(

3186: IF del_cur %ISOPEN THEN
3187: CLOSE del_cur ;
3188: END IF;
3189: x_return_status := G_RET_STS_UNEXP_ERROR;
3190: FND_MSG_PUB.Count_And_Get(
3191: p_count => x_msg_count,
3192: p_data => x_msg_data
3193: );
3194:

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

3201: IF del_cur %ISOPEN THEN
3202: CLOSE del_cur ;
3203: END IF;
3204: x_return_status := G_RET_STS_UNEXP_ERROR;
3205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3206: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3207: END IF;
3208: FND_MSG_PUB.Count_And_Get(
3209: p_count => x_msg_count,

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

3202: CLOSE del_cur ;
3203: END IF;
3204: x_return_status := G_RET_STS_UNEXP_ERROR;
3205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3206: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3207: END IF;
3208: FND_MSG_PUB.Count_And_Get(
3209: p_count => x_msg_count,
3210: p_data => x_msg_data

Line 3208: FND_MSG_PUB.Count_And_Get(

3204: x_return_status := G_RET_STS_UNEXP_ERROR;
3205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3206: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3207: END IF;
3208: FND_MSG_PUB.Count_And_Get(
3209: p_count => x_msg_count,
3210: p_data => x_msg_data
3211: );
3212:

Line 4267: FND_MSG_PUB.Count_And_Get(

4263: IF del_ins_cur %ISOPEN THEN
4264: CLOSE del_ins_cur ;
4265: END IF;
4266: x_return_status := G_RET_STS_ERROR;
4267: FND_MSG_PUB.Count_And_Get(
4268: p_count => x_msg_count,
4269: p_data => x_msg_data
4270: );
4271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4287: FND_MSG_PUB.Count_And_Get(

4283: IF delStsHist%ISOPEN THEN
4284: CLOSE delStsHist;
4285: END IF;
4286: x_return_status := G_RET_STS_UNEXP_ERROR;
4287: FND_MSG_PUB.Count_And_Get(
4288: p_count => x_msg_count,
4289: p_data => x_msg_data
4290: );
4291:

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

4303: IF delStsHist%ISOPEN THEN
4304: CLOSE delStsHist;
4305: END IF;
4306: x_return_status := G_RET_STS_UNEXP_ERROR;
4307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4308: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4309: END IF;
4310: FND_MSG_PUB.Count_And_Get(
4311: p_count => x_msg_count,

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

4304: CLOSE delStsHist;
4305: END IF;
4306: x_return_status := G_RET_STS_UNEXP_ERROR;
4307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4308: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4309: END IF;
4310: FND_MSG_PUB.Count_And_Get(
4311: p_count => x_msg_count,
4312: p_data => x_msg_data

Line 4310: FND_MSG_PUB.Count_And_Get(

4306: x_return_status := G_RET_STS_UNEXP_ERROR;
4307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4308: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4309: END IF;
4310: FND_MSG_PUB.Count_And_Get(
4311: p_count => x_msg_count,
4312: p_data => x_msg_data
4313: );
4314: END sync_deliverables;

Line 4853: FND_MSG_PUB.Count_And_Get(

4849: IF del_cur %ISOPEN THEN
4850: CLOSE del_cur ;
4851: END IF;
4852: x_return_status := G_RET_STS_ERROR;
4853: FND_MSG_PUB.Count_And_Get(
4854: p_count => x_msg_count,
4855: p_data => x_msg_data
4856: );
4857:

Line 4868: FND_MSG_PUB.Count_And_Get(

4864: IF del_cur %ISOPEN THEN
4865: CLOSE del_cur ;
4866: END IF;
4867: x_return_status := G_RET_STS_UNEXP_ERROR;
4868: FND_MSG_PUB.Count_And_Get(
4869: p_count => x_msg_count,
4870: p_data => x_msg_data
4871: );
4872:

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

4878: IF del_cur %ISOPEN THEN
4879: CLOSE del_cur ;
4880: END IF;
4881: x_return_status := G_RET_STS_UNEXP_ERROR;
4882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4884: END IF;
4885: FND_MSG_PUB.Count_And_Get(
4886: p_count => x_msg_count,

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

4879: CLOSE del_cur ;
4880: END IF;
4881: x_return_status := G_RET_STS_UNEXP_ERROR;
4882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4884: END IF;
4885: FND_MSG_PUB.Count_And_Get(
4886: p_count => x_msg_count,
4887: p_data => x_msg_data

Line 4885: FND_MSG_PUB.Count_And_Get(

4881: x_return_status := G_RET_STS_UNEXP_ERROR;
4882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4884: END IF;
4885: FND_MSG_PUB.Count_And_Get(
4886: p_count => x_msg_count,
4887: p_data => x_msg_data
4888: );
4889: END version_deliverables;

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

5021: IF def_cur %ISOPEN THEN
5022: CLOSE def_cur ;
5023: END IF;
5024: x_return_status := G_RET_STS_UNEXP_ERROR;
5025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5026: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5027: END IF;
5028: FND_MSG_PUB.Count_And_Get(
5029: p_count => x_msg_count,

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

5022: CLOSE def_cur ;
5023: END IF;
5024: x_return_status := G_RET_STS_UNEXP_ERROR;
5025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5026: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5027: END IF;
5028: FND_MSG_PUB.Count_And_Get(
5029: p_count => x_msg_count,
5030: p_data => x_msg_data

Line 5028: FND_MSG_PUB.Count_And_Get(

5024: x_return_status := G_RET_STS_UNEXP_ERROR;
5025: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5026: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5027: END IF;
5028: FND_MSG_PUB.Count_And_Get(
5029: p_count => x_msg_count,
5030: p_data => x_msg_data
5031: );
5032:

Line 5090: FND_MSG_PUB.Count_And_Get(

5086: IF del_cur %ISOPEN THEN
5087: CLOSE del_cur ;
5088: END IF;
5089: x_return_status := G_RET_STS_ERROR;
5090: FND_MSG_PUB.Count_And_Get(
5091: p_count => x_msg_count,
5092: p_data => x_msg_data
5093: );
5094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5102: FND_MSG_PUB.Count_And_Get(

5098: IF del_cur %ISOPEN THEN
5099: CLOSE del_cur ;
5100: END IF;
5101: x_return_status := G_RET_STS_UNEXP_ERROR;
5102: FND_MSG_PUB.Count_And_Get(
5103: p_count => x_msg_count,
5104: p_data => x_msg_data
5105: );
5106:

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

5111: IF del_cur %ISOPEN THEN
5112: CLOSE del_cur ;
5113: END IF;
5114: x_return_status := G_RET_STS_UNEXP_ERROR;
5115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5117: END IF;
5118: FND_MSG_PUB.Count_And_Get(
5119: p_count => x_msg_count,

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

5112: CLOSE del_cur ;
5113: END IF;
5114: x_return_status := G_RET_STS_UNEXP_ERROR;
5115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5117: END IF;
5118: FND_MSG_PUB.Count_And_Get(
5119: p_count => x_msg_count,
5120: p_data => x_msg_data

Line 5118: FND_MSG_PUB.Count_And_Get(

5114: x_return_status := G_RET_STS_UNEXP_ERROR;
5115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5117: END IF;
5118: FND_MSG_PUB.Count_And_Get(
5119: p_count => x_msg_count,
5120: p_data => x_msg_data
5121: );
5122:

Line 5187: FND_MSG_PUB.Count_And_Get(

5183: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5184: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving with G_EXC_ERROR');
5185: END IF;
5186: x_return_status := G_RET_STS_ERROR;
5187: FND_MSG_PUB.Count_And_Get(
5188: p_count => x_msg_count,
5189: p_data => x_msg_data
5190: );
5191:

Line 5197: FND_MSG_PUB.Count_And_Get(

5193: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5194: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
5195: END IF;
5196: x_return_status := G_RET_STS_UNEXP_ERROR;
5197: FND_MSG_PUB.Count_And_Get(
5198: p_count => x_msg_count,
5199: p_data => x_msg_data
5200: );
5201:

Line 5207: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

5203: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5204: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
5205: END IF;
5206: x_return_status := G_RET_STS_UNEXP_ERROR;
5207: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5208: END IF;
5209: FND_MSG_PUB.Count_And_Get(
5210: p_count => x_msg_count,
5211: p_data => x_msg_data

Line 5209: FND_MSG_PUB.Count_And_Get(

5205: END IF;
5206: x_return_status := G_RET_STS_UNEXP_ERROR;
5207: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5208: END IF;
5209: FND_MSG_PUB.Count_And_Get(
5210: p_count => x_msg_count,
5211: p_data => x_msg_data
5212: );
5213: END create_del_status_history;

Line 5442: FND_MSG_PUB.Count_And_Get(

5438: IF del_activate_cur %ISOPEN THEN
5439: CLOSE del_activate_cur ;
5440: END IF;
5441: x_return_status := G_RET_STS_ERROR;
5442: FND_MSG_PUB.Count_And_Get(
5443: p_count => x_msg_count,
5444: p_data => x_msg_data
5445: );
5446:

Line 5455: FND_MSG_PUB.Count_And_Get(

5451: IF del_activate_cur %ISOPEN THEN
5452: CLOSE del_activate_cur ;
5453: END IF;
5454: x_return_status := G_RET_STS_UNEXP_ERROR;
5455: FND_MSG_PUB.Count_And_Get(
5456: p_count => x_msg_count,
5457: p_data => x_msg_data
5458: );
5459:

Line 5468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

5464: IF del_activate_cur %ISOPEN THEN
5465: CLOSE del_activate_cur ;
5466: END IF;
5467: x_return_status := G_RET_STS_UNEXP_ERROR;
5468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5469: END IF;
5470: FND_MSG_PUB.Count_And_Get(
5471: p_count => x_msg_count,
5472: p_data => x_msg_data

Line 5470: FND_MSG_PUB.Count_And_Get(

5466: END IF;
5467: x_return_status := G_RET_STS_UNEXP_ERROR;
5468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5469: END IF;
5470: FND_MSG_PUB.Count_And_Get(
5471: p_count => x_msg_count,
5472: p_data => x_msg_data
5473: );
5474:

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

5529: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.overdue_deliverable_manager with G_EXC_UNEXPECTED_ERROR');
5530: END IF;
5531: retcode := 2;
5532: errbuf := substr(sqlerrm,1,200);
5533: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5534: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5535: END IF;
5536: IF FND_MSG_PUB.Count_Msg > 0 Then
5537: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

5530: END IF;
5531: retcode := 2;
5532: errbuf := substr(sqlerrm,1,200);
5533: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5534: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5535: END IF;
5536: IF FND_MSG_PUB.Count_Msg > 0 Then
5537: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5538: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

Line 5536: IF FND_MSG_PUB.Count_Msg > 0 Then

5532: errbuf := substr(sqlerrm,1,200);
5533: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5534: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5535: END IF;
5536: IF FND_MSG_PUB.Count_Msg > 0 Then
5537: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5538: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5539: END LOOP;
5540: END IF;

Line 5537: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

5533: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5534: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5535: END IF;
5536: IF FND_MSG_PUB.Count_Msg > 0 Then
5537: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5538: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5539: END LOOP;
5540: END IF;
5541: FND_MSG_PUB.initialize;

Line 5538: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

5534: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5535: END IF;
5536: IF FND_MSG_PUB.Count_Msg > 0 Then
5537: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5538: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5539: END LOOP;
5540: END IF;
5541: FND_MSG_PUB.initialize;
5542:

Line 5541: FND_MSG_PUB.initialize;

5537: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5538: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5539: END LOOP;
5540: END IF;
5541: FND_MSG_PUB.initialize;
5542:
5543: END overdue_deliverable_manager;
5544:
5545: /***

Line 5726: FND_MSG_PUB.Count_And_Get(

5722: CLOSE del_cur ;
5723: END IF;
5724:
5725: x_return_status := G_RET_STS_ERROR;
5726: FND_MSG_PUB.Count_And_Get(
5727: p_count => x_msg_count,
5728: p_data => x_msg_data);
5729:
5730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5740: FND_MSG_PUB.Count_And_Get(

5736: CLOSE del_cur ;
5737: END IF;
5738:
5739: x_return_status := G_RET_STS_UNEXP_ERROR;
5740: FND_MSG_PUB.Count_And_Get(
5741: p_count => x_msg_count,
5742: p_data => x_msg_data);
5743:
5744: WHEN OTHERS THEN

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

5751: END IF;
5752:
5753: x_return_status := G_RET_STS_UNEXP_ERROR;
5754:
5755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5756: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5757: END IF;
5758:
5759: FND_MSG_PUB.Count_And_Get(

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

5752:
5753: x_return_status := G_RET_STS_UNEXP_ERROR;
5754:
5755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5756: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5757: END IF;
5758:
5759: FND_MSG_PUB.Count_And_Get(
5760: p_count => x_msg_count,

Line 5759: FND_MSG_PUB.Count_And_Get(

5755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5756: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5757: END IF;
5758:
5759: FND_MSG_PUB.Count_And_Get(
5760: p_count => x_msg_count,
5761: p_data => x_msg_data);
5762: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
5763:

Line 5813: IF FND_MSG_PUB.Count_Msg > 0 Then

5809: EXCEPTION
5810: WHEN E_Resource_Busy THEN
5811: l_return_status := okc_api.g_ret_sts_error;
5812: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5813: IF FND_MSG_PUB.Count_Msg > 0 Then
5814: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5815: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5816: END LOOP;
5817: END IF;

Line 5814: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

5810: WHEN E_Resource_Busy THEN
5811: l_return_status := okc_api.g_ret_sts_error;
5812: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5813: IF FND_MSG_PUB.Count_Msg > 0 Then
5814: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5815: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5816: END LOOP;
5817: END IF;
5818: FND_MSG_PUB.initialize;

Line 5815: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

5811: l_return_status := okc_api.g_ret_sts_error;
5812: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5813: IF FND_MSG_PUB.Count_Msg > 0 Then
5814: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5815: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5816: END LOOP;
5817: END IF;
5818: FND_MSG_PUB.initialize;
5819: WHEN OTHERS THEN

Line 5818: FND_MSG_PUB.initialize;

5814: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5815: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5816: END LOOP;
5817: END IF;
5818: FND_MSG_PUB.initialize;
5819: WHEN OTHERS THEN
5820: retcode := 2;
5821: errbuf := substr(sqlerrm,1,200);
5822: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

5818: FND_MSG_PUB.initialize;
5819: WHEN OTHERS THEN
5820: retcode := 2;
5821: errbuf := substr(sqlerrm,1,200);
5822: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5823: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5824: END IF;
5825: IF FND_MSG_PUB.Count_Msg > 0 Then
5826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

5819: WHEN OTHERS THEN
5820: retcode := 2;
5821: errbuf := substr(sqlerrm,1,200);
5822: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5823: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5824: END IF;
5825: IF FND_MSG_PUB.Count_Msg > 0 Then
5826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5827: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

Line 5825: IF FND_MSG_PUB.Count_Msg > 0 Then

5821: errbuf := substr(sqlerrm,1,200);
5822: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5823: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5824: END IF;
5825: IF FND_MSG_PUB.Count_Msg > 0 Then
5826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5827: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5828: END LOOP;
5829: END IF;

Line 5826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

5822: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5823: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5824: END IF;
5825: IF FND_MSG_PUB.Count_Msg > 0 Then
5826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5827: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5828: END LOOP;
5829: END IF;
5830: FND_MSG_PUB.initialize;

Line 5827: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

5823: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5824: END IF;
5825: IF FND_MSG_PUB.Count_Msg > 0 Then
5826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5827: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5828: END LOOP;
5829: END IF;
5830: FND_MSG_PUB.initialize;
5831:

Line 5830: FND_MSG_PUB.initialize;

5826: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5827: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5828: END LOOP;
5829: END IF;
5830: FND_MSG_PUB.initialize;
5831:
5832: END beforedue_deliverable_manager;
5833:
5834:

Line 6099: FND_MSG_PUB.Count_And_Get(

6095: IF del_cur %ISOPEN THEN
6096: CLOSE del_cur ;
6097: END IF;
6098: x_return_status := G_RET_STS_ERROR;
6099: FND_MSG_PUB.Count_And_Get(
6100: p_count => x_msg_count,
6101: p_data => x_msg_data
6102: );
6103:

Line 6112: FND_MSG_PUB.Count_And_Get(

6108: IF del_cur %ISOPEN THEN
6109: CLOSE del_cur ;
6110: END IF;
6111: x_return_status := G_RET_STS_UNEXP_ERROR;
6112: FND_MSG_PUB.Count_And_Get(
6113: p_count => x_msg_count,
6114: p_data => x_msg_data
6115: );
6116:

Line 6125: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

6121: IF del_cur %ISOPEN THEN
6122: CLOSE del_cur ;
6123: END IF;
6124: x_return_status := G_RET_STS_UNEXP_ERROR;
6125: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6126: END IF;
6127: FND_MSG_PUB.Count_And_Get(
6128: p_count => x_msg_count,
6129: p_data => x_msg_data

Line 6127: FND_MSG_PUB.Count_And_Get(

6123: END IF;
6124: x_return_status := G_RET_STS_UNEXP_ERROR;
6125: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6126: END IF;
6127: FND_MSG_PUB.Count_And_Get(
6128: p_count => x_msg_count,
6129: p_data => x_msg_data
6130: );
6131: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 6181: IF FND_MSG_PUB.Count_Msg > 0 Then

6177: EXCEPTION
6178: WHEN E_Resource_Busy THEN
6179: l_return_status := okc_api.g_ret_sts_error;
6180: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
6181: IF FND_MSG_PUB.Count_Msg > 0 Then
6182: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
6183: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
6184: END LOOP;
6185: END IF;

Line 6182: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

6178: WHEN E_Resource_Busy THEN
6179: l_return_status := okc_api.g_ret_sts_error;
6180: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
6181: IF FND_MSG_PUB.Count_Msg > 0 Then
6182: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
6183: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
6184: END LOOP;
6185: END IF;
6186: FND_MSG_PUB.initialize;

Line 6183: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

6179: l_return_status := okc_api.g_ret_sts_error;
6180: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
6181: IF FND_MSG_PUB.Count_Msg > 0 Then
6182: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
6183: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
6184: END LOOP;
6185: END IF;
6186: FND_MSG_PUB.initialize;
6187: WHEN OTHERS THEN

Line 6186: FND_MSG_PUB.initialize;

6182: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
6183: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
6184: END LOOP;
6185: END IF;
6186: FND_MSG_PUB.initialize;
6187: WHEN OTHERS THEN
6188: retcode := 2;
6189: errbuf := substr(sqlerrm,1,200);
6190: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

6186: FND_MSG_PUB.initialize;
6187: WHEN OTHERS THEN
6188: retcode := 2;
6189: errbuf := substr(sqlerrm,1,200);
6190: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6191: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6192: END IF;
6193: IF FND_MSG_PUB.Count_Msg > 0 Then
6194: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

6187: WHEN OTHERS THEN
6188: retcode := 2;
6189: errbuf := substr(sqlerrm,1,200);
6190: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6191: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6192: END IF;
6193: IF FND_MSG_PUB.Count_Msg > 0 Then
6194: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
6195: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

Line 6193: IF FND_MSG_PUB.Count_Msg > 0 Then

6189: errbuf := substr(sqlerrm,1,200);
6190: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6191: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6192: END IF;
6193: IF FND_MSG_PUB.Count_Msg > 0 Then
6194: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
6195: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
6196: END LOOP;
6197: END IF;

Line 6194: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

6190: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6191: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6192: END IF;
6193: IF FND_MSG_PUB.Count_Msg > 0 Then
6194: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
6195: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
6196: END LOOP;
6197: END IF;
6198: FND_MSG_PUB.initialize;

Line 6195: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

6191: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6192: END IF;
6193: IF FND_MSG_PUB.Count_Msg > 0 Then
6194: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
6195: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
6196: END LOOP;
6197: END IF;
6198: FND_MSG_PUB.initialize;
6199:

Line 6198: FND_MSG_PUB.initialize;

6194: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
6195: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
6196: END LOOP;
6197: END IF;
6198: FND_MSG_PUB.initialize;
6199:
6200: END escalation_deliverable_manager;
6201:
6202:

Line 6464: FND_MSG_PUB.Count_And_Get(

6460: IF del_cur %ISOPEN THEN
6461: CLOSE del_cur ;
6462: END IF;
6463: x_return_status := G_RET_STS_ERROR;
6464: FND_MSG_PUB.Count_And_Get(
6465: p_count => x_msg_count,
6466: p_data => x_msg_data
6467: );
6468:

Line 6477: FND_MSG_PUB.Count_And_Get(

6473: IF del_cur %ISOPEN THEN
6474: CLOSE del_cur ;
6475: END IF;
6476: x_return_status := G_RET_STS_UNEXP_ERROR;
6477: FND_MSG_PUB.Count_And_Get(
6478: p_count => x_msg_count,
6479: p_data => x_msg_data
6480: );
6481:

Line 6490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

6486: IF del_cur %ISOPEN THEN
6487: CLOSE del_cur ;
6488: END IF;
6489: x_return_status := G_RET_STS_UNEXP_ERROR;
6490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6491: END IF;
6492: FND_MSG_PUB.Count_And_Get(
6493: p_count => x_msg_count,
6494: p_data => x_msg_data

Line 6492: FND_MSG_PUB.Count_And_Get(

6488: END IF;
6489: x_return_status := G_RET_STS_UNEXP_ERROR;
6490: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6491: END IF;
6492: FND_MSG_PUB.Count_And_Get(
6493: p_count => x_msg_count,
6494: p_data => x_msg_data
6495: );
6496: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

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

6558: IF att_cur %ISOPEN THEN
6559: CLOSE att_cur ;
6560: END IF;
6561: x_result := G_RET_STS_UNEXP_ERROR;
6562: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6563: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6564: END IF;
6565: FND_MSG_PUB.Count_And_Get(
6566: p_count => x_msg_count,

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

6559: CLOSE att_cur ;
6560: END IF;
6561: x_result := G_RET_STS_UNEXP_ERROR;
6562: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6563: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6564: END IF;
6565: FND_MSG_PUB.Count_And_Get(
6566: p_count => x_msg_count,
6567: p_data => x_msg_data

Line 6565: FND_MSG_PUB.Count_And_Get(

6561: x_result := G_RET_STS_UNEXP_ERROR;
6562: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6563: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6564: END IF;
6565: FND_MSG_PUB.Count_And_Get(
6566: p_count => x_msg_count,
6567: p_data => x_msg_data
6568: );
6569:

Line 6625: FND_MSG_PUB.Count_And_Get(

6621: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6622: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables with G_EXC_ERROR');
6623: END IF;
6624: x_return_status := G_RET_STS_ERROR;
6625: FND_MSG_PUB.Count_And_Get(
6626: p_count => x_msg_count,
6627: p_data => x_msg_data
6628: );
6629:

Line 6635: FND_MSG_PUB.Count_And_Get(

6631: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6632: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables with G_EXC_UNEXPECTED_ERROR');
6633: END IF;
6634: x_return_status := G_RET_STS_UNEXP_ERROR;
6635: FND_MSG_PUB.Count_And_Get(
6636: p_count => x_msg_count,
6637: p_data => x_msg_data
6638: );
6639:

Line 6645: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

6641: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6642: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.purge_doc_deliverables with G_EXC_UNEXPECTED_ERROR');
6643: END IF;
6644: x_return_status := G_RET_STS_UNEXP_ERROR;
6645: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6646: END IF;
6647: FND_MSG_PUB.Count_And_Get(
6648: p_count => x_msg_count,
6649: p_data => x_msg_data

Line 6647: FND_MSG_PUB.Count_And_Get(

6643: END IF;
6644: x_return_status := G_RET_STS_UNEXP_ERROR;
6645: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6646: END IF;
6647: FND_MSG_PUB.Count_And_Get(
6648: p_count => x_msg_count,
6649: p_data => x_msg_data
6650: );
6651:

Line 6792: FND_MSG_PUB.Count_And_Get(

6788: IF del_version_cur %ISOPEN THEN
6789: CLOSE del_version_cur ;
6790: END IF;
6791: x_return_status := G_RET_STS_ERROR;
6792: FND_MSG_PUB.Count_And_Get(
6793: p_count => x_msg_count,
6794: p_data => x_msg_data
6795: );
6796:

Line 6808: FND_MSG_PUB.Count_And_Get(

6804: IF del_version_cur %ISOPEN THEN
6805: CLOSE del_version_cur ;
6806: END IF;
6807: x_return_status := G_RET_STS_UNEXP_ERROR;
6808: FND_MSG_PUB.Count_And_Get(
6809: p_count => x_msg_count,
6810: p_data => x_msg_data
6811: );
6812:

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

6820: IF del_version_cur %ISOPEN THEN
6821: CLOSE del_version_cur ;
6822: END IF;
6823: x_return_status := G_RET_STS_UNEXP_ERROR;
6824: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6825: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6826: END IF;
6827: FND_MSG_PUB.Count_And_Get(
6828: p_count => x_msg_count,

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

6821: CLOSE del_version_cur ;
6822: END IF;
6823: x_return_status := G_RET_STS_UNEXP_ERROR;
6824: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6825: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6826: END IF;
6827: FND_MSG_PUB.Count_And_Get(
6828: p_count => x_msg_count,
6829: p_data => x_msg_data

Line 6827: FND_MSG_PUB.Count_And_Get(

6823: x_return_status := G_RET_STS_UNEXP_ERROR;
6824: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6825: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6826: END IF;
6827: FND_MSG_PUB.Count_And_Get(
6828: p_count => x_msg_count,
6829: p_data => x_msg_data
6830: );
6831:

Line 6891: FND_MSG_PUB.Count_And_Get(

6887: IF del_cur %ISOPEN THEN
6888: CLOSE del_cur ;
6889: END IF;
6890: x_return_status := G_RET_STS_ERROR;
6891: FND_MSG_PUB.Count_And_Get(
6892: p_count => x_msg_count,
6893: p_data => x_msg_data
6894: );
6895:

Line 6905: FND_MSG_PUB.Count_And_Get(

6901: IF del_cur %ISOPEN THEN
6902: CLOSE del_cur ;
6903: END IF;
6904: x_return_status := G_RET_STS_UNEXP_ERROR;
6905: FND_MSG_PUB.Count_And_Get(
6906: p_count => x_msg_count,
6907: p_data => x_msg_data
6908: );
6909:

Line 6919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

6915: IF del_cur %ISOPEN THEN
6916: CLOSE del_cur ;
6917: END IF;
6918: x_return_status := G_RET_STS_UNEXP_ERROR;
6919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6920: END IF;
6921: FND_MSG_PUB.Count_And_Get(
6922: p_count => x_msg_count,
6923: p_data => x_msg_data

Line 6921: FND_MSG_PUB.Count_And_Get(

6917: END IF;
6918: x_return_status := G_RET_STS_UNEXP_ERROR;
6919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6920: END IF;
6921: FND_MSG_PUB.Count_And_Get(
6922: p_count => x_msg_count,
6923: p_data => x_msg_data
6924: );
6925:

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

7012: /*bug# 3641366 IF create_date_cur%ISOPEN THEN
7013: CLOSE create_date_cur;
7014: END IF;*/
7015: x_return_status := G_RET_STS_UNEXP_ERROR ;
7016: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7017: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7018: END IF;
7019: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
7020: , p_count => x_msg_count

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

7013: CLOSE create_date_cur;
7014: END IF;*/
7015: x_return_status := G_RET_STS_UNEXP_ERROR ;
7016: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7017: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7018: END IF;
7019: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
7020: , p_count => x_msg_count
7021: , p_data => x_msg_data );

Line 7019: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'

7015: x_return_status := G_RET_STS_UNEXP_ERROR ;
7016: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
7017: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
7018: END IF;
7019: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
7020: , p_count => x_msg_count
7021: , p_data => x_msg_data );
7022:
7023: RETURN null;

Line 7286: FND_MSG_PUB.Count_And_Get(

7282: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7283: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.get_recurring_dates with OTHER ERROR');
7284: END IF;
7285: x_return_status := OKC_API.G_RET_STS_ERROR;
7286: FND_MSG_PUB.Count_And_Get(
7287: p_count => x_msg_count,
7288: p_data => x_msg_data
7289: );
7290: END get_recurring_dates;

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

7665: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_notifications with OTHERS EXCEPTION');
7666: END IF;
7667:
7668: x_return_status := G_RET_STS_UNEXP_ERROR;
7669: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7670: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7671: END IF;
7672:
7673:

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

7666: END IF;
7667:
7668: x_return_status := G_RET_STS_UNEXP_ERROR;
7669: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7670: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7671: END IF;
7672:
7673:
7674: END check_notifications;

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

7908: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts with OTHERS EXCEPTION');
7909: END IF;
7910:
7911: x_return_status := G_RET_STS_UNEXP_ERROR;
7912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7913: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7914: END IF;
7915:
7916:

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

7909: END IF;
7910:
7911: x_return_status := G_RET_STS_UNEXP_ERROR;
7912: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7913: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7914: END IF;
7915:
7916:
7917: END check_internal_contacts;

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

8058: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_exhibits with OTHERS EXCEPTION');
8059: END IF;
8060:
8061: x_return_status := G_RET_STS_UNEXP_ERROR;
8062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8063: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8064: END IF;
8065:
8066: END check_exhibit_details;

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

8059: END IF;
8060:
8061: x_return_status := G_RET_STS_UNEXP_ERROR;
8062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8063: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8064: END IF;
8065:
8066: END check_exhibit_details;
8067:

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

8248: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts_valid with OTHERS EXCEPTION');
8249: END IF;
8250:
8251: x_return_status := G_RET_STS_UNEXP_ERROR;
8252: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8253: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8254: END IF;
8255:
8256:

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

8249: END IF;
8250:
8251: x_return_status := G_RET_STS_UNEXP_ERROR;
8252: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8253: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8254: END IF;
8255:
8256:
8257: END check_internal_contacts_valid;

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

8429: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_contacts with OTHERS EXCEPTION');
8430: END IF;
8431:
8432: x_return_status := G_RET_STS_UNEXP_ERROR;
8433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8434: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8435: END IF;
8436:
8437:

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

8430: END IF;
8431:
8432: x_return_status := G_RET_STS_UNEXP_ERROR;
8433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8434: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8435: END IF;
8436:
8437:
8438: END check_external_contacts;

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

8868: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_due_dates with OTHERS EXCEPTION');
8869: END IF;
8870:
8871: x_return_status := G_RET_STS_UNEXP_ERROR;
8872: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8873: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8874: END IF;
8875:
8876: END check_due_dates;

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

8869: END IF;
8870:
8871: x_return_status := G_RET_STS_UNEXP_ERROR;
8872: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8873: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8874: END IF;
8875:
8876: END check_due_dates;
8877:

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

8996: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_amendments with OTHERS EXCEPTION');
8997: END IF;
8998:
8999: x_return_status := G_RET_STS_UNEXP_ERROR;
9000: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9001: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9002: END IF;
9003:
9004:

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

8997: END IF;
8998:
8999: x_return_status := G_RET_STS_UNEXP_ERROR;
9000: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9001: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9002: END IF;
9003:
9004:
9005: END check_amendments;

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

9540: ||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_party_exists with OTHERS EXCEPTION');
9541: END IF;
9542: x_return_status := G_RET_STS_UNEXP_ERROR;
9543:
9544: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9545: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9546: END IF;
9547:
9548:

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

9541: END IF;
9542: x_return_status := G_RET_STS_UNEXP_ERROR;
9543:
9544: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9545: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9546: END IF;
9547:
9548:
9549: End check_external_party_exists;

Line 9699: FND_MSG_PUB.initialize;

9695: END IF;
9696:
9697: -- Initialize message list if p_init_msg_list is set to TRUE.
9698: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9699: FND_MSG_PUB.initialize;
9700: END IF;
9701:
9702: --initialize l_qa_result_tbl
9703: l_qa_result_tbl := p_qa_result_tbl;

Line 10278: FND_MSG_PUB.Count_And_Get(

10274: CLOSE check_lookup_code_csr;
10275: END IF;
10276:
10277: x_return_status := G_RET_STS_ERROR;
10278: FND_MSG_PUB.Count_And_Get(
10279: p_count => x_msg_count,
10280: p_data => x_msg_data
10281: );
10282:

Line 10303: FND_MSG_PUB.Count_And_Get(

10299: END IF;
10300:
10301:
10302: x_return_status := G_RET_STS_UNEXP_ERROR;
10303: FND_MSG_PUB.Count_And_Get(
10304: p_count => x_msg_count,
10305: p_data => x_msg_data
10306: );
10307:

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

10322: CLOSE check_lookup_code_csr;
10323: END IF;
10324:
10325: x_return_status := G_RET_STS_UNEXP_ERROR;
10326: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10327: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10328: END IF;
10329: FND_MSG_PUB.Count_And_Get(
10330: p_count => x_msg_count,

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

10323: END IF;
10324:
10325: x_return_status := G_RET_STS_UNEXP_ERROR;
10326: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10327: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10328: END IF;
10329: FND_MSG_PUB.Count_And_Get(
10330: p_count => x_msg_count,
10331: p_data => x_msg_data

Line 10329: FND_MSG_PUB.Count_And_Get(

10325: x_return_status := G_RET_STS_UNEXP_ERROR;
10326: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10327: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10328: END IF;
10329: FND_MSG_PUB.Count_And_Get(
10330: p_count => x_msg_count,
10331: p_data => x_msg_data
10332: );
10333:

Line 10401: FND_MSG_PUB.Count_And_Get(

10397: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach with G_EXC_ERROR');
10398: END IF;
10399:
10400: x_return_status := G_RET_STS_ERROR;
10401: FND_MSG_PUB.Count_And_Get(
10402: p_count => x_msg_count,
10403: p_data => x_msg_data
10404: );
10405:

Line 10412: FND_MSG_PUB.Count_And_Get(

10408: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach with G_EXC_UNEXPECTED_ERROR');
10409: END IF;
10410:
10411: x_return_status := G_RET_STS_UNEXP_ERROR;
10412: FND_MSG_PUB.Count_And_Get(
10413: p_count => x_msg_count,
10414: p_data => x_msg_data
10415: );
10416:

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

10419: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_status_hist_attach with OTHERS EXCEPTION');
10420: END IF;
10421:
10422: x_return_status := G_RET_STS_UNEXP_ERROR;
10423: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10424: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10425: END IF;
10426: FND_MSG_PUB.Count_And_Get(
10427: p_count => x_msg_count,

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

10420: END IF;
10421:
10422: x_return_status := G_RET_STS_UNEXP_ERROR;
10423: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10424: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10425: END IF;
10426: FND_MSG_PUB.Count_And_Get(
10427: p_count => x_msg_count,
10428: p_data => x_msg_data

Line 10426: FND_MSG_PUB.Count_And_Get(

10422: x_return_status := G_RET_STS_UNEXP_ERROR;
10423: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10424: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10425: END IF;
10426: FND_MSG_PUB.Count_And_Get(
10427: p_count => x_msg_count,
10428: p_data => x_msg_data
10429: );
10430: END delete_del_status_hist_attach;

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

10599: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10600: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102:Leaving delete_del_instances with Exception');
10601: END IF;
10602: x_return_status := G_RET_STS_UNEXP_ERROR;
10603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10604: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10605: END IF;
10606: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
10607: p_data => x_msg_data);

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

10600: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102:Leaving delete_del_instances with Exception');
10601: END IF;
10602: x_return_status := G_RET_STS_UNEXP_ERROR;
10603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10604: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10605: END IF;
10606: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
10607: p_data => x_msg_data);
10608: END delete_del_instances;

Line 10606: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

10602: x_return_status := G_RET_STS_UNEXP_ERROR;
10603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10604: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10605: END IF;
10606: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
10607: p_data => x_msg_data);
10608: END delete_del_instances;
10609:
10610:

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

10708: IF del_cur%ISOPEN THEN
10709: CLOSE del_cur;
10710: END IF;
10711: x_return_status := G_RET_STS_UNEXP_ERROR ;
10712: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
10714: END IF;
10715: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
10716: , p_count => x_msg_count

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

10709: CLOSE del_cur;
10710: END IF;
10711: x_return_status := G_RET_STS_UNEXP_ERROR ;
10712: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
10714: END IF;
10715: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
10716: , p_count => x_msg_count
10717: , p_data => x_msg_data );

Line 10715: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'

10711: x_return_status := G_RET_STS_UNEXP_ERROR ;
10712: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
10714: END IF;
10715: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
10716: , p_count => x_msg_count
10717: , p_data => x_msg_data );
10718:
10719: RETURN null;

Line 10770: FND_MSG_PUB.Count_And_Get(

10766: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10767: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_ERROR');
10768: END IF;
10769: x_return_status := G_RET_STS_ERROR;
10770: FND_MSG_PUB.Count_And_Get(
10771: p_count => x_msg_count,
10772: p_data => x_msg_data
10773: );
10774:

Line 10780: FND_MSG_PUB.Count_And_Get(

10776: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10777: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_UNEXPECTED_ERROR');
10778: END IF;
10779: x_return_status := G_RET_STS_UNEXP_ERROR;
10780: FND_MSG_PUB.Count_And_Get(
10781: p_count => x_msg_count,
10782: p_data => x_msg_data
10783: );
10784:

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

10786: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10787: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_UNEXPECTED_ERROR');
10788: END IF;
10789: x_return_status := G_RET_STS_UNEXP_ERROR;
10790: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10791: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10792: END IF;
10793: FND_MSG_PUB.Count_And_Get(
10794: p_count => x_msg_count,

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

10787: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_UNEXPECTED_ERROR');
10788: END IF;
10789: x_return_status := G_RET_STS_UNEXP_ERROR;
10790: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10791: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10792: END IF;
10793: FND_MSG_PUB.Count_And_Get(
10794: p_count => x_msg_count,
10795: p_data => x_msg_data

Line 10793: FND_MSG_PUB.Count_And_Get(

10789: x_return_status := G_RET_STS_UNEXP_ERROR;
10790: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10791: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10792: END IF;
10793: FND_MSG_PUB.Count_And_Get(
10794: p_count => x_msg_count,
10795: p_data => x_msg_data
10796: );
10797:

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

10933: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10934: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_template_deliverables with G_EXC_UNEXPECTED_ERROR');
10935: END IF;
10936: x_return_status := G_RET_STS_UNEXP_ERROR;
10937: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10938: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10939: END IF;
10940: FND_MSG_PUB.Count_And_Get(
10941: p_count => x_msg_count,

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

10934: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_template_deliverables with G_EXC_UNEXPECTED_ERROR');
10935: END IF;
10936: x_return_status := G_RET_STS_UNEXP_ERROR;
10937: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10938: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10939: END IF;
10940: FND_MSG_PUB.Count_And_Get(
10941: p_count => x_msg_count,
10942: p_data => x_msg_data

Line 10940: FND_MSG_PUB.Count_And_Get(

10936: x_return_status := G_RET_STS_UNEXP_ERROR;
10937: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10938: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10939: END IF;
10940: FND_MSG_PUB.Count_And_Get(
10941: p_count => x_msg_count,
10942: p_data => x_msg_data
10943: );
10944:

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

11072: END IF;
11073:
11074: x_return_status := G_RET_STS_UNEXP_ERROR ;
11075:
11076: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
11077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
11078: END IF;
11079: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
11080: , p_count => x_msg_count

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

11073:
11074: x_return_status := G_RET_STS_UNEXP_ERROR ;
11075:
11076: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
11077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
11078: END IF;
11079: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
11080: , p_count => x_msg_count
11081: , p_data => x_msg_data );

Line 11079: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'

11075:
11076: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
11077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
11078: END IF;
11079: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
11080: , p_count => x_msg_count
11081: , p_data => x_msg_data );
11082:
11083: RETURN null;

Line 11894: FND_MSG_PUB.Count_And_Get(

11890: IF del_ins_cur %ISOPEN THEN
11891: CLOSE del_ins_cur ;
11892: END IF;
11893: x_return_status := G_RET_STS_ERROR;
11894: FND_MSG_PUB.Count_And_Get(
11895: p_count => x_msg_count,
11896: p_data => x_msg_data
11897: );
11898:

Line 11914: FND_MSG_PUB.Count_And_Get(

11910: IF del_ins_cur %ISOPEN THEN
11911: CLOSE del_ins_cur ;
11912: END IF;
11913: x_return_status := G_RET_STS_UNEXP_ERROR;
11914: FND_MSG_PUB.Count_And_Get(
11915: p_count => x_msg_count,
11916: p_data => x_msg_data
11917: );
11918:

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

11930: IF del_ins_cur %ISOPEN THEN
11931: CLOSE del_ins_cur ;
11932: END IF;
11933: x_return_status := G_RET_STS_UNEXP_ERROR;
11934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11935: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
11936: END IF;
11937: FND_MSG_PUB.Count_And_Get(
11938: p_count => x_msg_count,

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

11931: CLOSE del_ins_cur ;
11932: END IF;
11933: x_return_status := G_RET_STS_UNEXP_ERROR;
11934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11935: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
11936: END IF;
11937: FND_MSG_PUB.Count_And_Get(
11938: p_count => x_msg_count,
11939: p_data => x_msg_data

Line 11937: FND_MSG_PUB.Count_And_Get(

11933: x_return_status := G_RET_STS_UNEXP_ERROR;
11934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11935: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
11936: END IF;
11937: FND_MSG_PUB.Count_And_Get(
11938: p_count => x_msg_count,
11939: p_data => x_msg_data
11940: );
11941:

Line 12007: FND_MSG_PUB.Count_And_Get(

12003: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
12004: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving with G_EXC_ERROR');
12005: END IF;
12006: x_return_status := G_RET_STS_ERROR;
12007: FND_MSG_PUB.Count_And_Get(
12008: p_count => x_msg_count,
12009: p_data => x_msg_data
12010: );
12011:

Line 12017: FND_MSG_PUB.Count_And_Get(

12013: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
12014: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
12015: END IF;
12016: x_return_status := G_RET_STS_UNEXP_ERROR;
12017: FND_MSG_PUB.Count_And_Get(
12018: p_count => x_msg_count,
12019: p_data => x_msg_data
12020: );
12021:

Line 12027: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

12023: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
12024: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
12025: END IF;
12026: x_return_status := G_RET_STS_UNEXP_ERROR;
12027: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12028: END IF;
12029: FND_MSG_PUB.Count_And_Get(
12030: p_count => x_msg_count,
12031: p_data => x_msg_data

Line 12029: FND_MSG_PUB.Count_And_Get(

12025: END IF;
12026: x_return_status := G_RET_STS_UNEXP_ERROR;
12027: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12028: END IF;
12029: FND_MSG_PUB.Count_And_Get(
12030: p_count => x_msg_count,
12031: p_data => x_msg_data
12032: );
12033: END create_del_status_history;

Line 12100: FND_MSG_PUB.initialize;

12096: END IF;
12097:
12098: -- Initialize message list if p_init_msg_list is set to TRUE.
12099: IF FND_API.to_Boolean( p_init_msg_list ) THEN
12100: FND_MSG_PUB.initialize;
12101: END IF;
12102:
12103: -- Initialize API return status to success
12104: x_return_status := G_RET_STS_SUCCESS;

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

12159: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Unexpected error leaving '||
12160: G_PKG_NAME ||'.'||l_api_name);
12161: END IF;
12162: x_return_status := G_RET_STS_UNEXP_ERROR;
12163: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12164: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12165: END IF;
12166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
12167: p_data => x_msg_data);

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

12160: G_PKG_NAME ||'.'||l_api_name);
12161: END IF;
12162: x_return_status := G_RET_STS_UNEXP_ERROR;
12163: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12164: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12165: END IF;
12166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
12167: p_data => x_msg_data);
12168:

Line 12166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

12162: x_return_status := G_RET_STS_UNEXP_ERROR;
12163: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12164: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12165: END IF;
12166: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
12167: p_data => x_msg_data);
12168:
12169: RETURN(l_return_val);
12170: END deliverable_amendment_exists;

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

12699: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
12700: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision with G_EXC_UNEXPECTED_ERROR');
12701: END IF;
12702: x_return_status := G_RET_STS_UNEXP_ERROR;
12703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12704: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12705: END IF;
12706: FND_MSG_PUB.Count_And_Get(
12707: p_count => x_msg_count,

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

12700: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision with G_EXC_UNEXPECTED_ERROR');
12701: END IF;
12702: x_return_status := G_RET_STS_UNEXP_ERROR;
12703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12704: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12705: END IF;
12706: FND_MSG_PUB.Count_And_Get(
12707: p_count => x_msg_count,
12708: p_data => x_msg_data

Line 12706: FND_MSG_PUB.Count_And_Get(

12702: x_return_status := G_RET_STS_UNEXP_ERROR;
12703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12704: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12705: END IF;
12706: FND_MSG_PUB.Count_And_Get(
12707: p_count => x_msg_count,
12708: p_data => x_msg_data
12709: );
12710:

Line 12916: FND_MSG_PUB.initialize;

12912: END IF;
12913:
12914: -- Initialize message list if p_init_msg_list is set to TRUE.
12915: IF FND_API.to_Boolean( p_init_msg_list ) THEN
12916: FND_MSG_PUB.initialize;
12917: END IF;
12918:
12919: -- If the flag p_revert_dels is "N" then this API is called to delete
12920: -- deliverables with business document version of -99

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

13368: END IF;
13369:
13370: x_return_status := G_RET_STS_UNEXP_ERROR;
13371:
13372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13373: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
13374: END IF;
13375:
13376: FND_MSG_PUB.Count_And_Get(

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

13369:
13370: x_return_status := G_RET_STS_UNEXP_ERROR;
13371:
13372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13373: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
13374: END IF;
13375:
13376: FND_MSG_PUB.Count_And_Get(
13377: p_count => x_msg_count,

Line 13376: FND_MSG_PUB.Count_And_Get(

13372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13373: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
13374: END IF;
13375:
13376: FND_MSG_PUB.Count_And_Get(
13377: p_count => x_msg_count,
13378: p_data => x_msg_data
13379: );
13380:

Line 13426: FND_MSG_PUB.Count_And_Get(

13422: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
13423: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_attach_and_history with G_EXC_ERROR');
13424: END IF;
13425: x_return_status := G_RET_STS_ERROR;
13426: FND_MSG_PUB.Count_And_Get(
13427: p_count => x_msg_count,
13428: p_data => x_msg_data
13429: );
13430:

Line 13436: FND_MSG_PUB.Count_And_Get(

13432: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
13433: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_attach_and_history with G_EXC_UNEXPECTED_ERROR');
13434: END IF;
13435: x_return_status := G_RET_STS_UNEXP_ERROR;
13436: FND_MSG_PUB.Count_And_Get(
13437: p_count => x_msg_count,
13438: p_data => x_msg_data
13439: );
13440:

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

13442: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
13443: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_attach_and_history with G_EXC_UNEXPECTED_ERROR');
13444: END IF;
13445: x_return_status := G_RET_STS_UNEXP_ERROR;
13446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
13448: END IF;
13449: FND_MSG_PUB.Count_And_Get(
13450: p_count => x_msg_count,

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

13443: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_del_attach_and_history with G_EXC_UNEXPECTED_ERROR');
13444: END IF;
13445: x_return_status := G_RET_STS_UNEXP_ERROR;
13446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
13448: END IF;
13449: FND_MSG_PUB.Count_And_Get(
13450: p_count => x_msg_count,
13451: p_data => x_msg_data

Line 13449: FND_MSG_PUB.Count_And_Get(

13445: x_return_status := G_RET_STS_UNEXP_ERROR;
13446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
13448: END IF;
13449: FND_MSG_PUB.Count_And_Get(
13450: p_count => x_msg_count,
13451: p_data => x_msg_data
13452: );
13453: