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 1284: FND_MSG_PUB.Count_And_Get(

1280: IF del_cur %ISOPEN THEN
1281: CLOSE del_cur ;
1282: END IF;
1283: x_return_status := G_RET_STS_ERROR;
1284: FND_MSG_PUB.Count_And_Get(
1285: p_count => x_msg_count,
1286: p_data => x_msg_data
1287: );
1288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1296: FND_MSG_PUB.Count_And_Get(

1292: IF del_cur %ISOPEN THEN
1293: CLOSE del_cur ;
1294: END IF;
1295: x_return_status := G_RET_STS_UNEXP_ERROR;
1296: FND_MSG_PUB.Count_And_Get(
1297: p_count => x_msg_count,
1298: p_data => x_msg_data
1299: );
1300:

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

1305: IF del_cur %ISOPEN THEN
1306: CLOSE del_cur ;
1307: END IF;
1308: x_return_status := G_RET_STS_UNEXP_ERROR;
1309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1310: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1311: END IF;
1312: FND_MSG_PUB.Count_And_Get(
1313: p_count => x_msg_count,

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

1306: CLOSE del_cur ;
1307: END IF;
1308: x_return_status := G_RET_STS_UNEXP_ERROR;
1309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1310: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1311: END IF;
1312: FND_MSG_PUB.Count_And_Get(
1313: p_count => x_msg_count,
1314: p_data => x_msg_data

Line 1312: FND_MSG_PUB.Count_And_Get(

1308: x_return_status := G_RET_STS_UNEXP_ERROR;
1309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1310: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1311: END IF;
1312: FND_MSG_PUB.Count_And_Get(
1313: p_count => x_msg_count,
1314: p_data => x_msg_data
1315: );
1316: END copy_del_for_amendment;

Line 2999: FND_MSG_PUB.Count_And_Get(

2995: IF del_cur %ISOPEN THEN
2996: CLOSE del_cur ;
2997: END IF;
2998: x_return_status := G_RET_STS_ERROR;
2999: FND_MSG_PUB.Count_And_Get(
3000: p_count => x_msg_count,
3001: p_data => x_msg_data
3002: );
3003:

Line 3014: FND_MSG_PUB.Count_And_Get(

3010: IF del_cur %ISOPEN THEN
3011: CLOSE del_cur ;
3012: END IF;
3013: x_return_status := G_RET_STS_UNEXP_ERROR;
3014: FND_MSG_PUB.Count_And_Get(
3015: p_count => x_msg_count,
3016: p_data => x_msg_data
3017: );
3018:

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

3025: IF del_cur %ISOPEN THEN
3026: CLOSE del_cur ;
3027: END IF;
3028: x_return_status := G_RET_STS_UNEXP_ERROR;
3029: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3030: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3031: END IF;
3032: FND_MSG_PUB.Count_And_Get(
3033: p_count => x_msg_count,

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

3026: CLOSE del_cur ;
3027: END IF;
3028: x_return_status := G_RET_STS_UNEXP_ERROR;
3029: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3030: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3031: END IF;
3032: FND_MSG_PUB.Count_And_Get(
3033: p_count => x_msg_count,
3034: p_data => x_msg_data

Line 3032: FND_MSG_PUB.Count_And_Get(

3028: x_return_status := G_RET_STS_UNEXP_ERROR;
3029: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3030: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3031: END IF;
3032: FND_MSG_PUB.Count_And_Get(
3033: p_count => x_msg_count,
3034: p_data => x_msg_data
3035: );
3036:

Line 4029: FND_MSG_PUB.Count_And_Get(

4025: IF del_ins_cur %ISOPEN THEN
4026: CLOSE del_ins_cur ;
4027: END IF;
4028: x_return_status := G_RET_STS_ERROR;
4029: FND_MSG_PUB.Count_And_Get(
4030: p_count => x_msg_count,
4031: p_data => x_msg_data
4032: );
4033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4049: FND_MSG_PUB.Count_And_Get(

4045: IF delStsHist%ISOPEN THEN
4046: CLOSE delStsHist;
4047: END IF;
4048: x_return_status := G_RET_STS_UNEXP_ERROR;
4049: FND_MSG_PUB.Count_And_Get(
4050: p_count => x_msg_count,
4051: p_data => x_msg_data
4052: );
4053:

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

4065: IF delStsHist%ISOPEN THEN
4066: CLOSE delStsHist;
4067: END IF;
4068: x_return_status := G_RET_STS_UNEXP_ERROR;
4069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4070: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4071: END IF;
4072: FND_MSG_PUB.Count_And_Get(
4073: p_count => x_msg_count,

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

4066: CLOSE delStsHist;
4067: END IF;
4068: x_return_status := G_RET_STS_UNEXP_ERROR;
4069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4070: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4071: END IF;
4072: FND_MSG_PUB.Count_And_Get(
4073: p_count => x_msg_count,
4074: p_data => x_msg_data

Line 4072: FND_MSG_PUB.Count_And_Get(

4068: x_return_status := G_RET_STS_UNEXP_ERROR;
4069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4070: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4071: END IF;
4072: FND_MSG_PUB.Count_And_Get(
4073: p_count => x_msg_count,
4074: p_data => x_msg_data
4075: );
4076: END sync_deliverables;

Line 4564: FND_MSG_PUB.Count_And_Get(

4560: IF del_cur %ISOPEN THEN
4561: CLOSE del_cur ;
4562: END IF;
4563: x_return_status := G_RET_STS_ERROR;
4564: FND_MSG_PUB.Count_And_Get(
4565: p_count => x_msg_count,
4566: p_data => x_msg_data
4567: );
4568:

Line 4579: FND_MSG_PUB.Count_And_Get(

4575: IF del_cur %ISOPEN THEN
4576: CLOSE del_cur ;
4577: END IF;
4578: x_return_status := G_RET_STS_UNEXP_ERROR;
4579: FND_MSG_PUB.Count_And_Get(
4580: p_count => x_msg_count,
4581: p_data => x_msg_data
4582: );
4583:

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

4589: IF del_cur %ISOPEN THEN
4590: CLOSE del_cur ;
4591: END IF;
4592: x_return_status := G_RET_STS_UNEXP_ERROR;
4593: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4594: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4595: END IF;
4596: FND_MSG_PUB.Count_And_Get(
4597: p_count => x_msg_count,

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

4590: CLOSE del_cur ;
4591: END IF;
4592: x_return_status := G_RET_STS_UNEXP_ERROR;
4593: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4594: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4595: END IF;
4596: FND_MSG_PUB.Count_And_Get(
4597: p_count => x_msg_count,
4598: p_data => x_msg_data

Line 4596: FND_MSG_PUB.Count_And_Get(

4592: x_return_status := G_RET_STS_UNEXP_ERROR;
4593: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4594: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4595: END IF;
4596: FND_MSG_PUB.Count_And_Get(
4597: p_count => x_msg_count,
4598: p_data => x_msg_data
4599: );
4600: END version_deliverables;

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

4724: IF def_cur %ISOPEN THEN
4725: CLOSE def_cur ;
4726: END IF;
4727: x_return_status := G_RET_STS_UNEXP_ERROR;
4728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4729: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4730: END IF;
4731: FND_MSG_PUB.Count_And_Get(
4732: p_count => x_msg_count,

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

4725: CLOSE def_cur ;
4726: END IF;
4727: x_return_status := G_RET_STS_UNEXP_ERROR;
4728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4729: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4730: END IF;
4731: FND_MSG_PUB.Count_And_Get(
4732: p_count => x_msg_count,
4733: p_data => x_msg_data

Line 4731: FND_MSG_PUB.Count_And_Get(

4727: x_return_status := G_RET_STS_UNEXP_ERROR;
4728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4729: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4730: END IF;
4731: FND_MSG_PUB.Count_And_Get(
4732: p_count => x_msg_count,
4733: p_data => x_msg_data
4734: );
4735:

Line 4793: FND_MSG_PUB.Count_And_Get(

4789: IF del_cur %ISOPEN THEN
4790: CLOSE del_cur ;
4791: END IF;
4792: x_return_status := G_RET_STS_ERROR;
4793: FND_MSG_PUB.Count_And_Get(
4794: p_count => x_msg_count,
4795: p_data => x_msg_data
4796: );
4797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4805: FND_MSG_PUB.Count_And_Get(

4801: IF del_cur %ISOPEN THEN
4802: CLOSE del_cur ;
4803: END IF;
4804: x_return_status := G_RET_STS_UNEXP_ERROR;
4805: FND_MSG_PUB.Count_And_Get(
4806: p_count => x_msg_count,
4807: p_data => x_msg_data
4808: );
4809:

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

4814: IF del_cur %ISOPEN THEN
4815: CLOSE del_cur ;
4816: END IF;
4817: x_return_status := G_RET_STS_UNEXP_ERROR;
4818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4819: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4820: END IF;
4821: FND_MSG_PUB.Count_And_Get(
4822: p_count => x_msg_count,

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

4815: CLOSE del_cur ;
4816: END IF;
4817: x_return_status := G_RET_STS_UNEXP_ERROR;
4818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4819: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4820: END IF;
4821: FND_MSG_PUB.Count_And_Get(
4822: p_count => x_msg_count,
4823: p_data => x_msg_data

Line 4821: FND_MSG_PUB.Count_And_Get(

4817: x_return_status := G_RET_STS_UNEXP_ERROR;
4818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4819: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4820: END IF;
4821: FND_MSG_PUB.Count_And_Get(
4822: p_count => x_msg_count,
4823: p_data => x_msg_data
4824: );
4825:

Line 4890: FND_MSG_PUB.Count_And_Get(

4886: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4887: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving with G_EXC_ERROR');
4888: END IF;
4889: x_return_status := G_RET_STS_ERROR;
4890: FND_MSG_PUB.Count_And_Get(
4891: p_count => x_msg_count,
4892: p_data => x_msg_data
4893: );
4894:

Line 4900: FND_MSG_PUB.Count_And_Get(

4896: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4897: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
4898: END IF;
4899: x_return_status := G_RET_STS_UNEXP_ERROR;
4900: FND_MSG_PUB.Count_And_Get(
4901: p_count => x_msg_count,
4902: p_data => x_msg_data
4903: );
4904:

Line 4910: 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);

4906: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4907: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
4908: END IF;
4909: x_return_status := G_RET_STS_UNEXP_ERROR;
4910: 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);
4911: END IF;
4912: FND_MSG_PUB.Count_And_Get(
4913: p_count => x_msg_count,
4914: p_data => x_msg_data

Line 4912: FND_MSG_PUB.Count_And_Get(

4908: END IF;
4909: x_return_status := G_RET_STS_UNEXP_ERROR;
4910: 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);
4911: END IF;
4912: FND_MSG_PUB.Count_And_Get(
4913: p_count => x_msg_count,
4914: p_data => x_msg_data
4915: );
4916: END create_del_status_history;

Line 5145: FND_MSG_PUB.Count_And_Get(

5141: IF del_activate_cur %ISOPEN THEN
5142: CLOSE del_activate_cur ;
5143: END IF;
5144: x_return_status := G_RET_STS_ERROR;
5145: FND_MSG_PUB.Count_And_Get(
5146: p_count => x_msg_count,
5147: p_data => x_msg_data
5148: );
5149:

Line 5158: FND_MSG_PUB.Count_And_Get(

5154: IF del_activate_cur %ISOPEN THEN
5155: CLOSE del_activate_cur ;
5156: END IF;
5157: x_return_status := G_RET_STS_UNEXP_ERROR;
5158: FND_MSG_PUB.Count_And_Get(
5159: p_count => x_msg_count,
5160: p_data => x_msg_data
5161: );
5162:

Line 5171: 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);

5167: IF del_activate_cur %ISOPEN THEN
5168: CLOSE del_activate_cur ;
5169: END IF;
5170: x_return_status := G_RET_STS_UNEXP_ERROR;
5171: 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);
5172: END IF;
5173: FND_MSG_PUB.Count_And_Get(
5174: p_count => x_msg_count,
5175: p_data => x_msg_data

Line 5173: FND_MSG_PUB.Count_And_Get(

5169: END IF;
5170: x_return_status := G_RET_STS_UNEXP_ERROR;
5171: 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);
5172: END IF;
5173: FND_MSG_PUB.Count_And_Get(
5174: p_count => x_msg_count,
5175: p_data => x_msg_data
5176: );
5177:

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

5232: 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');
5233: END IF;
5234: retcode := 2;
5235: errbuf := substr(sqlerrm,1,200);
5236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5237: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5238: END IF;
5239: IF FND_MSG_PUB.Count_Msg > 0 Then
5240: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

5233: END IF;
5234: retcode := 2;
5235: errbuf := substr(sqlerrm,1,200);
5236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5237: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5238: END IF;
5239: IF FND_MSG_PUB.Count_Msg > 0 Then
5240: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5241: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

Line 5239: IF FND_MSG_PUB.Count_Msg > 0 Then

5235: errbuf := substr(sqlerrm,1,200);
5236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5237: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5238: END IF;
5239: IF FND_MSG_PUB.Count_Msg > 0 Then
5240: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5241: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5242: END LOOP;
5243: END IF;

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

5236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5237: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5238: END IF;
5239: IF FND_MSG_PUB.Count_Msg > 0 Then
5240: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5241: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5242: END LOOP;
5243: END IF;
5244: FND_MSG_PUB.initialize;

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

5237: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5238: END IF;
5239: IF FND_MSG_PUB.Count_Msg > 0 Then
5240: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5241: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5242: END LOOP;
5243: END IF;
5244: FND_MSG_PUB.initialize;
5245:

Line 5244: FND_MSG_PUB.initialize;

5240: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5241: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5242: END LOOP;
5243: END IF;
5244: FND_MSG_PUB.initialize;
5245:
5246: END overdue_deliverable_manager;
5247:
5248: /***

Line 5422: FND_MSG_PUB.Count_And_Get(

5418: CLOSE del_cur ;
5419: END IF;
5420:
5421: x_return_status := G_RET_STS_ERROR;
5422: FND_MSG_PUB.Count_And_Get(
5423: p_count => x_msg_count,
5424: p_data => x_msg_data);
5425:
5426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5436: FND_MSG_PUB.Count_And_Get(

5432: CLOSE del_cur ;
5433: END IF;
5434:
5435: x_return_status := G_RET_STS_UNEXP_ERROR;
5436: FND_MSG_PUB.Count_And_Get(
5437: p_count => x_msg_count,
5438: p_data => x_msg_data);
5439:
5440: WHEN OTHERS THEN

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

5447: END IF;
5448:
5449: x_return_status := G_RET_STS_UNEXP_ERROR;
5450:
5451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5452: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5453: END IF;
5454:
5455: FND_MSG_PUB.Count_And_Get(

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

5448:
5449: x_return_status := G_RET_STS_UNEXP_ERROR;
5450:
5451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5452: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5453: END IF;
5454:
5455: FND_MSG_PUB.Count_And_Get(
5456: p_count => x_msg_count,

Line 5455: FND_MSG_PUB.Count_And_Get(

5451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5452: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5453: END IF;
5454:
5455: FND_MSG_PUB.Count_And_Get(
5456: p_count => x_msg_count,
5457: p_data => x_msg_data);
5458: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
5459:

Line 5509: IF FND_MSG_PUB.Count_Msg > 0 Then

5505: EXCEPTION
5506: WHEN E_Resource_Busy THEN
5507: l_return_status := okc_api.g_ret_sts_error;
5508: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5509: IF FND_MSG_PUB.Count_Msg > 0 Then
5510: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5511: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5512: END LOOP;
5513: END IF;

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

5506: WHEN E_Resource_Busy THEN
5507: l_return_status := okc_api.g_ret_sts_error;
5508: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5509: IF FND_MSG_PUB.Count_Msg > 0 Then
5510: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5511: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5512: END LOOP;
5513: END IF;
5514: FND_MSG_PUB.initialize;

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

5507: l_return_status := okc_api.g_ret_sts_error;
5508: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5509: IF FND_MSG_PUB.Count_Msg > 0 Then
5510: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5511: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5512: END LOOP;
5513: END IF;
5514: FND_MSG_PUB.initialize;
5515: WHEN OTHERS THEN

Line 5514: FND_MSG_PUB.initialize;

5510: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5511: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5512: END LOOP;
5513: END IF;
5514: FND_MSG_PUB.initialize;
5515: WHEN OTHERS THEN
5516: retcode := 2;
5517: errbuf := substr(sqlerrm,1,200);
5518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

5514: FND_MSG_PUB.initialize;
5515: WHEN OTHERS THEN
5516: retcode := 2;
5517: errbuf := substr(sqlerrm,1,200);
5518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5520: END IF;
5521: IF FND_MSG_PUB.Count_Msg > 0 Then
5522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

5515: WHEN OTHERS THEN
5516: retcode := 2;
5517: errbuf := substr(sqlerrm,1,200);
5518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5520: END IF;
5521: IF FND_MSG_PUB.Count_Msg > 0 Then
5522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5523: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

Line 5521: IF FND_MSG_PUB.Count_Msg > 0 Then

5517: errbuf := substr(sqlerrm,1,200);
5518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5520: END IF;
5521: IF FND_MSG_PUB.Count_Msg > 0 Then
5522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5523: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5524: END LOOP;
5525: END IF;

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

5518: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5520: END IF;
5521: IF FND_MSG_PUB.Count_Msg > 0 Then
5522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5523: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5524: END LOOP;
5525: END IF;
5526: FND_MSG_PUB.initialize;

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

5519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5520: END IF;
5521: IF FND_MSG_PUB.Count_Msg > 0 Then
5522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5523: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5524: END LOOP;
5525: END IF;
5526: FND_MSG_PUB.initialize;
5527:

Line 5526: FND_MSG_PUB.initialize;

5522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5523: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5524: END LOOP;
5525: END IF;
5526: FND_MSG_PUB.initialize;
5527:
5528: END beforedue_deliverable_manager;
5529:
5530:

Line 5786: FND_MSG_PUB.Count_And_Get(

5782: IF del_cur %ISOPEN THEN
5783: CLOSE del_cur ;
5784: END IF;
5785: x_return_status := G_RET_STS_ERROR;
5786: FND_MSG_PUB.Count_And_Get(
5787: p_count => x_msg_count,
5788: p_data => x_msg_data
5789: );
5790:

Line 5799: FND_MSG_PUB.Count_And_Get(

5795: IF del_cur %ISOPEN THEN
5796: CLOSE del_cur ;
5797: END IF;
5798: x_return_status := G_RET_STS_UNEXP_ERROR;
5799: FND_MSG_PUB.Count_And_Get(
5800: p_count => x_msg_count,
5801: p_data => x_msg_data
5802: );
5803:

Line 5812: 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);

5808: IF del_cur %ISOPEN THEN
5809: CLOSE del_cur ;
5810: END IF;
5811: x_return_status := G_RET_STS_UNEXP_ERROR;
5812: 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);
5813: END IF;
5814: FND_MSG_PUB.Count_And_Get(
5815: p_count => x_msg_count,
5816: p_data => x_msg_data

Line 5814: FND_MSG_PUB.Count_And_Get(

5810: END IF;
5811: x_return_status := G_RET_STS_UNEXP_ERROR;
5812: 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);
5813: END IF;
5814: FND_MSG_PUB.Count_And_Get(
5815: p_count => x_msg_count,
5816: p_data => x_msg_data
5817: );
5818: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 5868: IF FND_MSG_PUB.Count_Msg > 0 Then

5864: EXCEPTION
5865: WHEN E_Resource_Busy THEN
5866: l_return_status := okc_api.g_ret_sts_error;
5867: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5868: IF FND_MSG_PUB.Count_Msg > 0 Then
5869: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5870: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5871: END LOOP;
5872: END IF;

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

5865: WHEN E_Resource_Busy THEN
5866: l_return_status := okc_api.g_ret_sts_error;
5867: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5868: IF FND_MSG_PUB.Count_Msg > 0 Then
5869: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5870: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5871: END LOOP;
5872: END IF;
5873: FND_MSG_PUB.initialize;

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

5866: l_return_status := okc_api.g_ret_sts_error;
5867: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
5868: IF FND_MSG_PUB.Count_Msg > 0 Then
5869: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5870: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5871: END LOOP;
5872: END IF;
5873: FND_MSG_PUB.initialize;
5874: WHEN OTHERS THEN

Line 5873: FND_MSG_PUB.initialize;

5869: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5870: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5871: END LOOP;
5872: END IF;
5873: FND_MSG_PUB.initialize;
5874: WHEN OTHERS THEN
5875: retcode := 2;
5876: errbuf := substr(sqlerrm,1,200);
5877: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

5873: FND_MSG_PUB.initialize;
5874: WHEN OTHERS THEN
5875: retcode := 2;
5876: errbuf := substr(sqlerrm,1,200);
5877: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5878: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5879: END IF;
5880: IF FND_MSG_PUB.Count_Msg > 0 Then
5881: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

5874: WHEN OTHERS THEN
5875: retcode := 2;
5876: errbuf := substr(sqlerrm,1,200);
5877: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5878: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5879: END IF;
5880: IF FND_MSG_PUB.Count_Msg > 0 Then
5881: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5882: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

Line 5880: IF FND_MSG_PUB.Count_Msg > 0 Then

5876: errbuf := substr(sqlerrm,1,200);
5877: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5878: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5879: END IF;
5880: IF FND_MSG_PUB.Count_Msg > 0 Then
5881: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5882: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5883: END LOOP;
5884: END IF;

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

5877: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5878: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5879: END IF;
5880: IF FND_MSG_PUB.Count_Msg > 0 Then
5881: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5882: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5883: END LOOP;
5884: END IF;
5885: FND_MSG_PUB.initialize;

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

5878: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5879: END IF;
5880: IF FND_MSG_PUB.Count_Msg > 0 Then
5881: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5882: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5883: END LOOP;
5884: END IF;
5885: FND_MSG_PUB.initialize;
5886:

Line 5885: FND_MSG_PUB.initialize;

5881: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
5882: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
5883: END LOOP;
5884: END IF;
5885: FND_MSG_PUB.initialize;
5886:
5887: END escalation_deliverable_manager;
5888:
5889:

Line 6143: FND_MSG_PUB.Count_And_Get(

6139: IF del_cur %ISOPEN THEN
6140: CLOSE del_cur ;
6141: END IF;
6142: x_return_status := G_RET_STS_ERROR;
6143: FND_MSG_PUB.Count_And_Get(
6144: p_count => x_msg_count,
6145: p_data => x_msg_data
6146: );
6147:

Line 6156: FND_MSG_PUB.Count_And_Get(

6152: IF del_cur %ISOPEN THEN
6153: CLOSE del_cur ;
6154: END IF;
6155: x_return_status := G_RET_STS_UNEXP_ERROR;
6156: FND_MSG_PUB.Count_And_Get(
6157: p_count => x_msg_count,
6158: p_data => x_msg_data
6159: );
6160:

Line 6169: 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);

6165: IF del_cur %ISOPEN THEN
6166: CLOSE del_cur ;
6167: END IF;
6168: x_return_status := G_RET_STS_UNEXP_ERROR;
6169: 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);
6170: END IF;
6171: FND_MSG_PUB.Count_And_Get(
6172: p_count => x_msg_count,
6173: p_data => x_msg_data

Line 6171: FND_MSG_PUB.Count_And_Get(

6167: END IF;
6168: x_return_status := G_RET_STS_UNEXP_ERROR;
6169: 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);
6170: END IF;
6171: FND_MSG_PUB.Count_And_Get(
6172: p_count => x_msg_count,
6173: p_data => x_msg_data
6174: );
6175: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

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

6231: IF att_cur %ISOPEN THEN
6232: CLOSE att_cur ;
6233: END IF;
6234: x_result := G_RET_STS_UNEXP_ERROR;
6235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6237: END IF;
6238: FND_MSG_PUB.Count_And_Get(
6239: p_count => x_msg_count,

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

6232: CLOSE att_cur ;
6233: END IF;
6234: x_result := G_RET_STS_UNEXP_ERROR;
6235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6237: END IF;
6238: FND_MSG_PUB.Count_And_Get(
6239: p_count => x_msg_count,
6240: p_data => x_msg_data

Line 6238: FND_MSG_PUB.Count_And_Get(

6234: x_result := G_RET_STS_UNEXP_ERROR;
6235: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6237: END IF;
6238: FND_MSG_PUB.Count_And_Get(
6239: p_count => x_msg_count,
6240: p_data => x_msg_data
6241: );
6242:

Line 6298: FND_MSG_PUB.Count_And_Get(

6294: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6295: 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');
6296: END IF;
6297: x_return_status := G_RET_STS_ERROR;
6298: FND_MSG_PUB.Count_And_Get(
6299: p_count => x_msg_count,
6300: p_data => x_msg_data
6301: );
6302:

Line 6308: FND_MSG_PUB.Count_And_Get(

6304: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6305: 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');
6306: END IF;
6307: x_return_status := G_RET_STS_UNEXP_ERROR;
6308: FND_MSG_PUB.Count_And_Get(
6309: p_count => x_msg_count,
6310: p_data => x_msg_data
6311: );
6312:

Line 6318: 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);

6314: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6315: 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');
6316: END IF;
6317: x_return_status := G_RET_STS_UNEXP_ERROR;
6318: 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);
6319: END IF;
6320: FND_MSG_PUB.Count_And_Get(
6321: p_count => x_msg_count,
6322: p_data => x_msg_data

Line 6320: FND_MSG_PUB.Count_And_Get(

6316: END IF;
6317: x_return_status := G_RET_STS_UNEXP_ERROR;
6318: 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);
6319: END IF;
6320: FND_MSG_PUB.Count_And_Get(
6321: p_count => x_msg_count,
6322: p_data => x_msg_data
6323: );
6324:

Line 6417: FND_MSG_PUB.Count_And_Get(

6413: IF del_version_cur %ISOPEN THEN
6414: CLOSE del_version_cur ;
6415: END IF;
6416: x_return_status := G_RET_STS_ERROR;
6417: FND_MSG_PUB.Count_And_Get(
6418: p_count => x_msg_count,
6419: p_data => x_msg_data
6420: );
6421:

Line 6433: FND_MSG_PUB.Count_And_Get(

6429: IF del_version_cur %ISOPEN THEN
6430: CLOSE del_version_cur ;
6431: END IF;
6432: x_return_status := G_RET_STS_UNEXP_ERROR;
6433: FND_MSG_PUB.Count_And_Get(
6434: p_count => x_msg_count,
6435: p_data => x_msg_data
6436: );
6437:

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

6445: IF del_version_cur %ISOPEN THEN
6446: CLOSE del_version_cur ;
6447: END IF;
6448: x_return_status := G_RET_STS_UNEXP_ERROR;
6449: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6450: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6451: END IF;
6452: FND_MSG_PUB.Count_And_Get(
6453: p_count => x_msg_count,

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

6446: CLOSE del_version_cur ;
6447: END IF;
6448: x_return_status := G_RET_STS_UNEXP_ERROR;
6449: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6450: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6451: END IF;
6452: FND_MSG_PUB.Count_And_Get(
6453: p_count => x_msg_count,
6454: p_data => x_msg_data

Line 6452: FND_MSG_PUB.Count_And_Get(

6448: x_return_status := G_RET_STS_UNEXP_ERROR;
6449: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6450: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
6451: END IF;
6452: FND_MSG_PUB.Count_And_Get(
6453: p_count => x_msg_count,
6454: p_data => x_msg_data
6455: );
6456:

Line 6516: FND_MSG_PUB.Count_And_Get(

6512: IF del_cur %ISOPEN THEN
6513: CLOSE del_cur ;
6514: END IF;
6515: x_return_status := G_RET_STS_ERROR;
6516: FND_MSG_PUB.Count_And_Get(
6517: p_count => x_msg_count,
6518: p_data => x_msg_data
6519: );
6520:

Line 6530: FND_MSG_PUB.Count_And_Get(

6526: IF del_cur %ISOPEN THEN
6527: CLOSE del_cur ;
6528: END IF;
6529: x_return_status := G_RET_STS_UNEXP_ERROR;
6530: FND_MSG_PUB.Count_And_Get(
6531: p_count => x_msg_count,
6532: p_data => x_msg_data
6533: );
6534:

Line 6544: 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);

6540: IF del_cur %ISOPEN THEN
6541: CLOSE del_cur ;
6542: END IF;
6543: x_return_status := G_RET_STS_UNEXP_ERROR;
6544: 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);
6545: END IF;
6546: FND_MSG_PUB.Count_And_Get(
6547: p_count => x_msg_count,
6548: p_data => x_msg_data

Line 6546: FND_MSG_PUB.Count_And_Get(

6542: END IF;
6543: x_return_status := G_RET_STS_UNEXP_ERROR;
6544: 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);
6545: END IF;
6546: FND_MSG_PUB.Count_And_Get(
6547: p_count => x_msg_count,
6548: p_data => x_msg_data
6549: );
6550:

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

6637: /*bug# 3641366 IF create_date_cur%ISOPEN THEN
6638: CLOSE create_date_cur;
6639: END IF;*/
6640: x_return_status := G_RET_STS_UNEXP_ERROR ;
6641: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6642: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6643: END IF;
6644: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
6645: , p_count => x_msg_count

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

6638: CLOSE create_date_cur;
6639: END IF;*/
6640: x_return_status := G_RET_STS_UNEXP_ERROR ;
6641: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6642: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6643: END IF;
6644: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
6645: , p_count => x_msg_count
6646: , p_data => x_msg_data );

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

6640: x_return_status := G_RET_STS_UNEXP_ERROR ;
6641: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6642: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6643: END IF;
6644: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
6645: , p_count => x_msg_count
6646: , p_data => x_msg_data );
6647:
6648: RETURN null;

Line 6885: FND_MSG_PUB.Count_And_Get(

6881: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6882: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.get_recurring_dates with OTHER ERROR');
6883: END IF;
6884: x_return_status := OKC_API.G_RET_STS_ERROR;
6885: FND_MSG_PUB.Count_And_Get(
6886: p_count => x_msg_count,
6887: p_data => x_msg_data
6888: );
6889: END get_recurring_dates;

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

7244: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_notifications with OTHERS EXCEPTION');
7245: END IF;
7246:
7247: x_return_status := G_RET_STS_UNEXP_ERROR;
7248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7249: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7250: END IF;
7251:
7252:

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

7245: END IF;
7246:
7247: x_return_status := G_RET_STS_UNEXP_ERROR;
7248: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7249: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7250: END IF;
7251:
7252:
7253: END check_notifications;

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

7421: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_internal_contacts with OTHERS EXCEPTION');
7422: END IF;
7423:
7424: x_return_status := G_RET_STS_UNEXP_ERROR;
7425: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7426: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7427: END IF;
7428:
7429:

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

7422: END IF;
7423:
7424: x_return_status := G_RET_STS_UNEXP_ERROR;
7425: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7426: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7427: END IF;
7428:
7429:
7430: END check_internal_contacts;

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

7583: 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');
7584: END IF;
7585:
7586: x_return_status := G_RET_STS_UNEXP_ERROR;
7587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7588: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7589: END IF;
7590:
7591:

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

7584: END IF;
7585:
7586: x_return_status := G_RET_STS_UNEXP_ERROR;
7587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7588: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7589: END IF;
7590:
7591:
7592: END check_internal_contacts_valid;

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

7727: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_contacts with OTHERS EXCEPTION');
7728: END IF;
7729:
7730: x_return_status := G_RET_STS_UNEXP_ERROR;
7731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7732: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7733: END IF;
7734:
7735:

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

7728: END IF;
7729:
7730: x_return_status := G_RET_STS_UNEXP_ERROR;
7731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7732: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7733: END IF;
7734:
7735:
7736: END check_external_contacts;

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

8097: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_due_dates with OTHERS EXCEPTION');
8098: END IF;
8099:
8100: x_return_status := G_RET_STS_UNEXP_ERROR;
8101: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8102: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8103: END IF;
8104:
8105: END check_due_dates;

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

8098: END IF;
8099:
8100: x_return_status := G_RET_STS_UNEXP_ERROR;
8101: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8102: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8103: END IF;
8104:
8105: END check_due_dates;
8106:

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

8201: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_amendments with OTHERS EXCEPTION');
8202: END IF;
8203:
8204: x_return_status := G_RET_STS_UNEXP_ERROR;
8205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8206: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8207: END IF;
8208:
8209:

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

8202: END IF;
8203:
8204: x_return_status := G_RET_STS_UNEXP_ERROR;
8205: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8206: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8207: END IF;
8208:
8209:
8210: END check_amendments;

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

8714: ||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.check_external_party_exists with OTHERS EXCEPTION');
8715: END IF;
8716: x_return_status := G_RET_STS_UNEXP_ERROR;
8717:
8718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8719: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8720: END IF;
8721:
8722:

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

8715: END IF;
8716: x_return_status := G_RET_STS_UNEXP_ERROR;
8717:
8718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8719: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8720: END IF;
8721:
8722:
8723: End check_external_party_exists;

Line 8873: FND_MSG_PUB.initialize;

8869: END IF;
8870:
8871: -- Initialize message list if p_init_msg_list is set to TRUE.
8872: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8873: FND_MSG_PUB.initialize;
8874: END IF;
8875:
8876: --initialize l_qa_result_tbl
8877: l_qa_result_tbl := p_qa_result_tbl;

Line 9387: FND_MSG_PUB.Count_And_Get(

9383: CLOSE check_lookup_code_csr;
9384: END IF;
9385:
9386: x_return_status := G_RET_STS_ERROR;
9387: FND_MSG_PUB.Count_And_Get(
9388: p_count => x_msg_count,
9389: p_data => x_msg_data
9390: );
9391:

Line 9412: FND_MSG_PUB.Count_And_Get(

9408: END IF;
9409:
9410:
9411: x_return_status := G_RET_STS_UNEXP_ERROR;
9412: FND_MSG_PUB.Count_And_Get(
9413: p_count => x_msg_count,
9414: p_data => x_msg_data
9415: );
9416:

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

9431: CLOSE check_lookup_code_csr;
9432: END IF;
9433:
9434: x_return_status := G_RET_STS_UNEXP_ERROR;
9435: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9436: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9437: END IF;
9438: FND_MSG_PUB.Count_And_Get(
9439: p_count => x_msg_count,

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

9432: END IF;
9433:
9434: x_return_status := G_RET_STS_UNEXP_ERROR;
9435: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9436: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9437: END IF;
9438: FND_MSG_PUB.Count_And_Get(
9439: p_count => x_msg_count,
9440: p_data => x_msg_data

Line 9438: FND_MSG_PUB.Count_And_Get(

9434: x_return_status := G_RET_STS_UNEXP_ERROR;
9435: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9436: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9437: END IF;
9438: FND_MSG_PUB.Count_And_Get(
9439: p_count => x_msg_count,
9440: p_data => x_msg_data
9441: );
9442:

Line 9510: FND_MSG_PUB.Count_And_Get(

9506: 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');
9507: END IF;
9508:
9509: x_return_status := G_RET_STS_ERROR;
9510: FND_MSG_PUB.Count_And_Get(
9511: p_count => x_msg_count,
9512: p_data => x_msg_data
9513: );
9514:

Line 9521: FND_MSG_PUB.Count_And_Get(

9517: 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');
9518: END IF;
9519:
9520: x_return_status := G_RET_STS_UNEXP_ERROR;
9521: FND_MSG_PUB.Count_And_Get(
9522: p_count => x_msg_count,
9523: p_data => x_msg_data
9524: );
9525:

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

9528: 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');
9529: END IF;
9530:
9531: x_return_status := G_RET_STS_UNEXP_ERROR;
9532: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9533: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9534: END IF;
9535: FND_MSG_PUB.Count_And_Get(
9536: p_count => x_msg_count,

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

9529: END IF;
9530:
9531: x_return_status := G_RET_STS_UNEXP_ERROR;
9532: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9533: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9534: END IF;
9535: FND_MSG_PUB.Count_And_Get(
9536: p_count => x_msg_count,
9537: p_data => x_msg_data

Line 9535: FND_MSG_PUB.Count_And_Get(

9531: x_return_status := G_RET_STS_UNEXP_ERROR;
9532: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9533: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9534: END IF;
9535: FND_MSG_PUB.Count_And_Get(
9536: p_count => x_msg_count,
9537: p_data => x_msg_data
9538: );
9539: END delete_del_status_hist_attach;

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

9704: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9705: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102:Leaving delete_del_instances with Exception');
9706: END IF;
9707: x_return_status := G_RET_STS_UNEXP_ERROR;
9708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9709: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9710: END IF;
9711: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
9712: p_data => x_msg_data);

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

9705: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'102:Leaving delete_del_instances with Exception');
9706: END IF;
9707: x_return_status := G_RET_STS_UNEXP_ERROR;
9708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9709: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9710: END IF;
9711: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
9712: p_data => x_msg_data);
9713: END delete_del_instances;

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

9707: x_return_status := G_RET_STS_UNEXP_ERROR;
9708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9709: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9710: END IF;
9711: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
9712: p_data => x_msg_data);
9713: END delete_del_instances;
9714:
9715:

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

9813: IF del_cur%ISOPEN THEN
9814: CLOSE del_cur;
9815: END IF;
9816: x_return_status := G_RET_STS_UNEXP_ERROR ;
9817: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9818: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9819: END IF;
9820: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
9821: , p_count => x_msg_count

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

9814: CLOSE del_cur;
9815: END IF;
9816: x_return_status := G_RET_STS_UNEXP_ERROR ;
9817: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9818: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9819: END IF;
9820: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
9821: , p_count => x_msg_count
9822: , p_data => x_msg_data );

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

9816: x_return_status := G_RET_STS_UNEXP_ERROR ;
9817: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
9818: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
9819: END IF;
9820: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
9821: , p_count => x_msg_count
9822: , p_data => x_msg_data );
9823:
9824: RETURN null;

Line 9871: FND_MSG_PUB.Count_And_Get(

9867: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9868: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.delete_deliverable with G_EXC_ERROR');
9869: END IF;
9870: x_return_status := G_RET_STS_ERROR;
9871: FND_MSG_PUB.Count_And_Get(
9872: p_count => x_msg_count,
9873: p_data => x_msg_data
9874: );
9875:

Line 9881: FND_MSG_PUB.Count_And_Get(

9877: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9878: 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');
9879: END IF;
9880: x_return_status := G_RET_STS_UNEXP_ERROR;
9881: FND_MSG_PUB.Count_And_Get(
9882: p_count => x_msg_count,
9883: p_data => x_msg_data
9884: );
9885:

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

9887: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9888: 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');
9889: END IF;
9890: x_return_status := G_RET_STS_UNEXP_ERROR;
9891: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9892: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9893: END IF;
9894: FND_MSG_PUB.Count_And_Get(
9895: p_count => x_msg_count,

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

9888: 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');
9889: END IF;
9890: x_return_status := G_RET_STS_UNEXP_ERROR;
9891: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9892: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9893: END IF;
9894: FND_MSG_PUB.Count_And_Get(
9895: p_count => x_msg_count,
9896: p_data => x_msg_data

Line 9894: FND_MSG_PUB.Count_And_Get(

9890: x_return_status := G_RET_STS_UNEXP_ERROR;
9891: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9892: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9893: END IF;
9894: FND_MSG_PUB.Count_And_Get(
9895: p_count => x_msg_count,
9896: p_data => x_msg_data
9897: );
9898:

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

9974: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9975: 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');
9976: END IF;
9977: x_return_status := G_RET_STS_UNEXP_ERROR;
9978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9980: END IF;
9981: FND_MSG_PUB.Count_And_Get(
9982: p_count => x_msg_count,

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

9975: 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');
9976: END IF;
9977: x_return_status := G_RET_STS_UNEXP_ERROR;
9978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9980: END IF;
9981: FND_MSG_PUB.Count_And_Get(
9982: p_count => x_msg_count,
9983: p_data => x_msg_data

Line 9981: FND_MSG_PUB.Count_And_Get(

9977: x_return_status := G_RET_STS_UNEXP_ERROR;
9978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
9980: END IF;
9981: FND_MSG_PUB.Count_And_Get(
9982: p_count => x_msg_count,
9983: p_data => x_msg_data
9984: );
9985:

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

10113: END IF;
10114:
10115: x_return_status := G_RET_STS_UNEXP_ERROR ;
10116:
10117: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10118: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
10119: END IF;
10120: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
10121: , p_count => x_msg_count

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

10114:
10115: x_return_status := G_RET_STS_UNEXP_ERROR ;
10116:
10117: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10118: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
10119: END IF;
10120: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
10121: , p_count => x_msg_count
10122: , p_data => x_msg_data );

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

10116:
10117: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
10118: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
10119: END IF;
10120: FND_MSG_PUB.Count_And_Get(p_encoded=>'F'
10121: , p_count => x_msg_count
10122: , p_data => x_msg_data );
10123:
10124: RETURN null;

Line 10875: FND_MSG_PUB.Count_And_Get(

10871: IF del_ins_cur %ISOPEN THEN
10872: CLOSE del_ins_cur ;
10873: END IF;
10874: x_return_status := G_RET_STS_ERROR;
10875: FND_MSG_PUB.Count_And_Get(
10876: p_count => x_msg_count,
10877: p_data => x_msg_data
10878: );
10879:

Line 10895: FND_MSG_PUB.Count_And_Get(

10891: IF del_ins_cur %ISOPEN THEN
10892: CLOSE del_ins_cur ;
10893: END IF;
10894: x_return_status := G_RET_STS_UNEXP_ERROR;
10895: FND_MSG_PUB.Count_And_Get(
10896: p_count => x_msg_count,
10897: p_data => x_msg_data
10898: );
10899:

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

10911: IF del_ins_cur %ISOPEN THEN
10912: CLOSE del_ins_cur ;
10913: END IF;
10914: x_return_status := G_RET_STS_UNEXP_ERROR;
10915: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10916: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10917: END IF;
10918: FND_MSG_PUB.Count_And_Get(
10919: p_count => x_msg_count,

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

10912: CLOSE del_ins_cur ;
10913: END IF;
10914: x_return_status := G_RET_STS_UNEXP_ERROR;
10915: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10916: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10917: END IF;
10918: FND_MSG_PUB.Count_And_Get(
10919: p_count => x_msg_count,
10920: p_data => x_msg_data

Line 10918: FND_MSG_PUB.Count_And_Get(

10914: x_return_status := G_RET_STS_UNEXP_ERROR;
10915: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10916: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
10917: END IF;
10918: FND_MSG_PUB.Count_And_Get(
10919: p_count => x_msg_count,
10920: p_data => x_msg_data
10921: );
10922:

Line 10988: FND_MSG_PUB.Count_And_Get(

10984: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10985: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'100: leaving with G_EXC_ERROR');
10986: END IF;
10987: x_return_status := G_RET_STS_ERROR;
10988: FND_MSG_PUB.Count_And_Get(
10989: p_count => x_msg_count,
10990: p_data => x_msg_data
10991: );
10992:

Line 10998: FND_MSG_PUB.Count_And_Get(

10994: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
10995: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
10996: END IF;
10997: x_return_status := G_RET_STS_UNEXP_ERROR;
10998: FND_MSG_PUB.Count_And_Get(
10999: p_count => x_msg_count,
11000: p_data => x_msg_data
11001: );
11002:

Line 11008: 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);

11004: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11005: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving with G_EXC_UNEXPECTED_ERROR');
11006: END IF;
11007: x_return_status := G_RET_STS_UNEXP_ERROR;
11008: 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);
11009: END IF;
11010: FND_MSG_PUB.Count_And_Get(
11011: p_count => x_msg_count,
11012: p_data => x_msg_data

Line 11010: FND_MSG_PUB.Count_And_Get(

11006: END IF;
11007: x_return_status := G_RET_STS_UNEXP_ERROR;
11008: 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);
11009: END IF;
11010: FND_MSG_PUB.Count_And_Get(
11011: p_count => x_msg_count,
11012: p_data => x_msg_data
11013: );
11014: END create_del_status_history;

Line 11081: FND_MSG_PUB.initialize;

11077: END IF;
11078:
11079: -- Initialize message list if p_init_msg_list is set to TRUE.
11080: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11081: FND_MSG_PUB.initialize;
11082: END IF;
11083:
11084: -- Initialize API return status to success
11085: x_return_status := G_RET_STS_SUCCESS;

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

11140: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Unexpected error leaving '||
11141: G_PKG_NAME ||'.'||l_api_name);
11142: END IF;
11143: x_return_status := G_RET_STS_UNEXP_ERROR;
11144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
11146: END IF;
11147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
11148: p_data => x_msg_data);

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

11141: G_PKG_NAME ||'.'||l_api_name);
11142: END IF;
11143: x_return_status := G_RET_STS_UNEXP_ERROR;
11144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
11146: END IF;
11147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
11148: p_data => x_msg_data);
11149:

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

11143: x_return_status := G_RET_STS_UNEXP_ERROR;
11144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11145: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
11146: END IF;
11147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
11148: p_data => x_msg_data);
11149:
11150: RETURN(l_return_val);
11151: END deliverable_amendment_exists;

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

11653: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
11654: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision with G_EXC_UNEXPECTED_ERROR');
11655: END IF;
11656: x_return_status := G_RET_STS_UNEXP_ERROR;
11657: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11658: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
11659: END IF;
11660: FND_MSG_PUB.Count_And_Get(
11661: p_count => x_msg_count,

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

11654: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving OKC_DELIVERABLE_PROCESS_PVT.CopyDelForTemplateRevision with G_EXC_UNEXPECTED_ERROR');
11655: END IF;
11656: x_return_status := G_RET_STS_UNEXP_ERROR;
11657: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11658: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
11659: END IF;
11660: FND_MSG_PUB.Count_And_Get(
11661: p_count => x_msg_count,
11662: p_data => x_msg_data

Line 11660: FND_MSG_PUB.Count_And_Get(

11656: x_return_status := G_RET_STS_UNEXP_ERROR;
11657: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11658: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
11659: END IF;
11660: FND_MSG_PUB.Count_And_Get(
11661: p_count => x_msg_count,
11662: p_data => x_msg_data
11663: );
11664:

Line 11854: FND_MSG_PUB.initialize;

11850: END IF;
11851:
11852: -- Initialize message list if p_init_msg_list is set to TRUE.
11853: IF FND_API.to_Boolean( p_init_msg_list ) THEN
11854: FND_MSG_PUB.initialize;
11855: END IF;
11856:
11857: -- If the flag p_revert_dels is "N" then this API is called to delete
11858: -- deliverables with business document version of -99

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

12264: END IF;
12265:
12266: x_return_status := G_RET_STS_UNEXP_ERROR;
12267:
12268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12270: END IF;
12271:
12272: FND_MSG_PUB.Count_And_Get(

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

12265:
12266: x_return_status := G_RET_STS_UNEXP_ERROR;
12267:
12268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12270: END IF;
12271:
12272: FND_MSG_PUB.Count_And_Get(
12273: p_count => x_msg_count,

Line 12272: FND_MSG_PUB.Count_And_Get(

12268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
12270: END IF;
12271:
12272: FND_MSG_PUB.Count_And_Get(
12273: p_count => x_msg_count,
12274: p_data => x_msg_data
12275: );
12276: