DBA Data[Home] [Help]

APPS.PSB_WS_POS2 dependencies on FND_MSG_PUB

Line 457: if FND_MSG_PUB.Check_Msg_Level

453: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454:
455: when OTHERS then
456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: if FND_MSG_PUB.Check_Msg_Level
458: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: then
460: FND_MSG_PUB.Add_Exc_Msg
461: (p_pkg_name => G_PKG_NAME,

Line 458: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

454:
455: when OTHERS then
456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: if FND_MSG_PUB.Check_Msg_Level
458: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: then
460: FND_MSG_PUB.Add_Exc_Msg
461: (p_pkg_name => G_PKG_NAME,
462: p_procedure_name => 'Create_Worksheet_Positions');

Line 460: FND_MSG_PUB.Add_Exc_Msg

456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: if FND_MSG_PUB.Check_Msg_Level
458: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: then
460: FND_MSG_PUB.Add_Exc_Msg
461: (p_pkg_name => G_PKG_NAME,
462: p_procedure_name => 'Create_Worksheet_Positions');
463: end if;
464:

Line 1391: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

1387: EXCEPTION
1388:
1389: when FND_API.G_EXC_ERROR then
1390: p_return_status := FND_API.G_RET_STS_ERROR;
1391: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1392: p_data => l_msg_data);
1393:
1394:
1395: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1397: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

1393:
1394:
1395: when FND_API.G_EXC_UNEXPECTED_ERROR then
1396: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1397: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1398: p_data => l_msg_data);
1399:
1400: when OTHERS then
1401: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1403: if FND_MSG_PUB.Check_Msg_Level

1399:
1400: when OTHERS then
1401: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1402:
1403: if FND_MSG_PUB.Check_Msg_Level
1404: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1405: then
1406: FND_MSG_PUB.Add_Exc_Msg
1407: (p_pkg_name => G_PKG_NAME,

Line 1404: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1400: when OTHERS then
1401: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1402:
1403: if FND_MSG_PUB.Check_Msg_Level
1404: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1405: then
1406: FND_MSG_PUB.Add_Exc_Msg
1407: (p_pkg_name => G_PKG_NAME,
1408: p_procedure_name => l_api_name);

Line 1406: FND_MSG_PUB.Add_Exc_Msg

1402:
1403: if FND_MSG_PUB.Check_Msg_Level
1404: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1405: then
1406: FND_MSG_PUB.Add_Exc_Msg
1407: (p_pkg_name => G_PKG_NAME,
1408: p_procedure_name => l_api_name);
1409: end if;
1410:

Line 1411: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

1407: (p_pkg_name => G_PKG_NAME,
1408: p_procedure_name => l_api_name);
1409: end if;
1410:
1411: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1412: p_data => l_msg_data);
1413:
1414: END Calculate_Position_Cost;
1415:

Line 3675: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

3671: EXCEPTION
3672:
3673: when FND_API.G_EXC_ERROR then
3674: p_return_status := FND_API.G_RET_STS_ERROR;
3675: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3676: p_data => l_msg_data);
3677:
3678:
3679: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 3681: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

3677:
3678:
3679: when FND_API.G_EXC_UNEXPECTED_ERROR then
3680: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3681: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3682: p_data => l_msg_data);
3683:
3684: when OTHERS then
3685: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3687: if FND_MSG_PUB.Check_Msg_Level

3683:
3684: when OTHERS then
3685: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3686:
3687: if FND_MSG_PUB.Check_Msg_Level
3688: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3689: then
3690: FND_MSG_PUB.Add_Exc_Msg
3691: (p_pkg_name => G_PKG_NAME,

Line 3688: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3684: when OTHERS then
3685: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3686:
3687: if FND_MSG_PUB.Check_Msg_Level
3688: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3689: then
3690: FND_MSG_PUB.Add_Exc_Msg
3691: (p_pkg_name => G_PKG_NAME,
3692: p_procedure_name => l_api_name);

Line 3690: FND_MSG_PUB.Add_Exc_Msg

3686:
3687: if FND_MSG_PUB.Check_Msg_Level
3688: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3689: then
3690: FND_MSG_PUB.Add_Exc_Msg
3691: (p_pkg_name => G_PKG_NAME,
3692: p_procedure_name => l_api_name);
3693: end if;
3694:

Line 3695: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

3691: (p_pkg_name => G_PKG_NAME,
3692: p_procedure_name => l_api_name);
3693: end if;
3694:
3695: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3696: p_data => l_msg_data);
3697:
3698: END Calculate_Position_Cost_Year;
3699:

Line 3875: if FND_MSG_PUB.Check_Msg_Level

3871: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3872:
3873: when OTHERS then
3874: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3875: if FND_MSG_PUB.Check_Msg_Level
3876: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3877: then
3878: FND_MSG_PUB.Add_Exc_Msg
3879: (p_pkg_name => G_PKG_NAME,

Line 3876: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3872:
3873: when OTHERS then
3874: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3875: if FND_MSG_PUB.Check_Msg_Level
3876: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3877: then
3878: FND_MSG_PUB.Add_Exc_Msg
3879: (p_pkg_name => G_PKG_NAME,
3880: p_procedure_name => 'Cache_FTE_Profile');

Line 3878: FND_MSG_PUB.Add_Exc_Msg

3874: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3875: if FND_MSG_PUB.Check_Msg_Level
3876: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3877: then
3878: FND_MSG_PUB.Add_Exc_Msg
3879: (p_pkg_name => G_PKG_NAME,
3880: p_procedure_name => 'Cache_FTE_Profile');
3881: end if;
3882:

Line 3996: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

3992:
3993:
3994: when FND_API.G_EXC_ERROR then
3995: p_return_status := FND_API.G_RET_STS_ERROR;
3996: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3997: p_data => l_msg_data);
3998:
3999:
4000: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 4002: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

3998:
3999:
4000: when FND_API.G_EXC_UNEXPECTED_ERROR then
4001: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4002: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4003: p_data => l_msg_data);
4004:
4005: when OTHERS then
4006: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4008: if FND_MSG_PUB.Check_Msg_Level

4004:
4005: when OTHERS then
4006: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4007:
4008: if FND_MSG_PUB.Check_Msg_Level
4009: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4010: then
4011: FND_MSG_PUB.Add_Exc_Msg
4012: (p_pkg_name => G_PKG_NAME,

Line 4009: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4005: when OTHERS then
4006: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4007:
4008: if FND_MSG_PUB.Check_Msg_Level
4009: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4010: then
4011: FND_MSG_PUB.Add_Exc_Msg
4012: (p_pkg_name => G_PKG_NAME,
4013: p_procedure_name => l_api_name);

Line 4011: FND_MSG_PUB.Add_Exc_Msg

4007:
4008: if FND_MSG_PUB.Check_Msg_Level
4009: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4010: then
4011: FND_MSG_PUB.Add_Exc_Msg
4012: (p_pkg_name => G_PKG_NAME,
4013: p_procedure_name => l_api_name);
4014: end if;
4015:

Line 4016: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

4012: (p_pkg_name => G_PKG_NAME,
4013: p_procedure_name => l_api_name);
4014: end if;
4015:
4016: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4017: p_data => l_msg_data);
4018: END Distribute_Position_Cost;
4019:
4020: /* ----------------------------------------------------------------------- */

Line 4211: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

4207: EXCEPTION
4208:
4209: when FND_API.G_EXC_ERROR then
4210: p_return_status := FND_API.G_RET_STS_ERROR;
4211: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4212: p_data => l_msg_data);
4213:
4214:
4215: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 4217: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

4213:
4214:
4215: when FND_API.G_EXC_UNEXPECTED_ERROR then
4216: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4217: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4218: p_data => l_msg_data);
4219:
4220: when OTHERS then
4221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4223: if FND_MSG_PUB.Check_Msg_Level

4219:
4220: when OTHERS then
4221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4222:
4223: if FND_MSG_PUB.Check_Msg_Level
4224: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4225: then
4226: FND_MSG_PUB.Add_Exc_Msg
4227: (p_pkg_name => G_PKG_NAME,

Line 4224: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4220: when OTHERS then
4221: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4222:
4223: if FND_MSG_PUB.Check_Msg_Level
4224: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4225: then
4226: FND_MSG_PUB.Add_Exc_Msg
4227: (p_pkg_name => G_PKG_NAME,
4228: p_procedure_name => l_api_name);

Line 4226: FND_MSG_PUB.Add_Exc_Msg

4222:
4223: if FND_MSG_PUB.Check_Msg_Level
4224: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4225: then
4226: FND_MSG_PUB.Add_Exc_Msg
4227: (p_pkg_name => G_PKG_NAME,
4228: p_procedure_name => l_api_name);
4229: end if;
4230:

Line 4231: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

4227: (p_pkg_name => G_PKG_NAME,
4228: p_procedure_name => l_api_name);
4229: end if;
4230:
4231: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4232: p_data => l_msg_data);
4233:
4234: END Distribute_Salary;
4235:

Line 4446: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

4442: EXCEPTION
4443:
4444: when FND_API.G_EXC_ERROR then
4445: p_return_status := FND_API.G_RET_STS_ERROR;
4446: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4447: p_data => l_msg_data);
4448:
4449:
4450: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 4452: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

4448:
4449:
4450: when FND_API.G_EXC_UNEXPECTED_ERROR then
4451: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4452: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4453: p_data => l_msg_data);
4454:
4455: when OTHERS then
4456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4458: if FND_MSG_PUB.Check_Msg_Level

4454:
4455: when OTHERS then
4456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4457:
4458: if FND_MSG_PUB.Check_Msg_Level
4459: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4460: then
4461: FND_MSG_PUB.Add_Exc_Msg
4462: (p_pkg_name => G_PKG_NAME,

Line 4459: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4455: when OTHERS then
4456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4457:
4458: if FND_MSG_PUB.Check_Msg_Level
4459: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4460: then
4461: FND_MSG_PUB.Add_Exc_Msg
4462: (p_pkg_name => G_PKG_NAME,
4463: p_procedure_name => l_api_name);

Line 4461: FND_MSG_PUB.Add_Exc_Msg

4457:
4458: if FND_MSG_PUB.Check_Msg_Level
4459: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4460: then
4461: FND_MSG_PUB.Add_Exc_Msg
4462: (p_pkg_name => G_PKG_NAME,
4463: p_procedure_name => l_api_name);
4464: end if;
4465:

Line 4466: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

4462: (p_pkg_name => G_PKG_NAME,
4463: p_procedure_name => l_api_name);
4464: end if;
4465:
4466: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4467: p_data => l_msg_data);
4468:
4469: END Distribute_Other_Elements;
4470:

Line 5283: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

5279: EXCEPTION
5280:
5281: when FND_API.G_EXC_ERROR then
5282: p_return_status := FND_API.G_RET_STS_ERROR;
5283: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
5284: p_data => l_msg_data);
5285:
5286:
5287: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 5289: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

5285:
5286:
5287: when FND_API.G_EXC_UNEXPECTED_ERROR then
5288: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5289: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
5290: p_data => l_msg_data);
5291:
5292: when OTHERS then
5293: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5295: if FND_MSG_PUB.Check_Msg_Level

5291:
5292: when OTHERS then
5293: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5294:
5295: if FND_MSG_PUB.Check_Msg_Level
5296: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5297: then
5298: FND_MSG_PUB.Add_Exc_Msg
5299: (p_pkg_name => G_PKG_NAME,

Line 5296: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5292: when OTHERS then
5293: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5294:
5295: if FND_MSG_PUB.Check_Msg_Level
5296: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5297: then
5298: FND_MSG_PUB.Add_Exc_Msg
5299: (p_pkg_name => G_PKG_NAME,
5300: p_procedure_name => l_api_name);

Line 5298: FND_MSG_PUB.Add_Exc_Msg

5294:
5295: if FND_MSG_PUB.Check_Msg_Level
5296: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5297: then
5298: FND_MSG_PUB.Add_Exc_Msg
5299: (p_pkg_name => G_PKG_NAME,
5300: p_procedure_name => l_api_name);
5301: end if;
5302:

Line 5303: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

5299: (p_pkg_name => G_PKG_NAME,
5300: p_procedure_name => l_api_name);
5301: end if;
5302:
5303: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
5304: p_data => l_msg_data);
5305:
5306: END Update_Position_Cost;
5307:

Line 5353: FND_MSG_PUB.Add;

5349: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));
5350: end loop;
5351: end if;
5352:
5353: FND_MSG_PUB.Add;
5354:
5355: end if;
5356:
5357: -- Clear Message Token stack