DBA Data[Home] [Help]

APPS.PSB_WS_POS3 dependencies on FND_MSG_PUB

Line 475: if FND_MSG_PUB.Check_Msg_Level

471:
472: when OTHERS then
473: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474:
475: if FND_MSG_PUB.Check_Msg_Level
476: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
477: then
478: FND_MSG_PUB.Add_Exc_Msg
479: (p_pkg_name => G_PKG_NAME,

Line 476: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

472: when OTHERS then
473: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474:
475: if FND_MSG_PUB.Check_Msg_Level
476: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
477: then
478: FND_MSG_PUB.Add_Exc_Msg
479: (p_pkg_name => G_PKG_NAME,
480: p_procedure_name => l_api_name);

Line 478: FND_MSG_PUB.Add_Exc_Msg

474:
475: if FND_MSG_PUB.Check_Msg_Level
476: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
477: then
478: FND_MSG_PUB.Add_Exc_Msg
479: (p_pkg_name => G_PKG_NAME,
480: p_procedure_name => l_api_name);
481: end if;
482:

Line 808: if FND_MSG_PUB.Check_Msg_Level

804: when OTHERS then
805: rollback to Revise_Element_Projections_Pvt;
806: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807:
808: if FND_MSG_PUB.Check_Msg_Level
809: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
810: then
811: FND_MSG_PUB.Add_Exc_Msg
812: (p_pkg_name => G_PKG_NAME,

Line 809: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

805: rollback to Revise_Element_Projections_Pvt;
806: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807:
808: if FND_MSG_PUB.Check_Msg_Level
809: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
810: then
811: FND_MSG_PUB.Add_Exc_Msg
812: (p_pkg_name => G_PKG_NAME,
813: p_procedure_name => l_api_name);

Line 811: FND_MSG_PUB.Add_Exc_Msg

807:
808: if FND_MSG_PUB.Check_Msg_Level
809: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
810: then
811: FND_MSG_PUB.Add_Exc_Msg
812: (p_pkg_name => G_PKG_NAME,
813: p_procedure_name => l_api_name);
814: end if;
815:

Line 989: if FND_MSG_PUB.Check_Msg_Level

985: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
986:
987: when OTHERS then
988: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: if FND_MSG_PUB.Check_Msg_Level
990: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
991: then
992: FND_MSG_PUB.Add_Exc_Msg
993: (p_pkg_name => G_PKG_NAME,

Line 990: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

986:
987: when OTHERS then
988: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: if FND_MSG_PUB.Check_Msg_Level
990: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
991: then
992: FND_MSG_PUB.Add_Exc_Msg
993: (p_pkg_name => G_PKG_NAME,
994: p_procedure_name => 'Process_ElemParam');

Line 992: FND_MSG_PUB.Add_Exc_Msg

988: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: if FND_MSG_PUB.Check_Msg_Level
990: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
991: then
992: FND_MSG_PUB.Add_Exc_Msg
993: (p_pkg_name => G_PKG_NAME,
994: p_procedure_name => 'Process_ElemParam');
995: end if;
996:

Line 1098: if FND_MSG_PUB.Check_Msg_Level

1094: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095:
1096: when OTHERS then
1097: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098: if FND_MSG_PUB.Check_Msg_Level
1099: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1100: then
1101: FND_MSG_PUB.Add_Exc_Msg
1102: (p_pkg_name => G_PKG_NAME,

Line 1099: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1095:
1096: when OTHERS then
1097: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098: if FND_MSG_PUB.Check_Msg_Level
1099: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1100: then
1101: FND_MSG_PUB.Add_Exc_Msg
1102: (p_pkg_name => G_PKG_NAME,
1103: p_procedure_name => 'Process_ElemParam_Option');

Line 1101: FND_MSG_PUB.Add_Exc_Msg

1097: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098: if FND_MSG_PUB.Check_Msg_Level
1099: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1100: then
1101: FND_MSG_PUB.Add_Exc_Msg
1102: (p_pkg_name => G_PKG_NAME,
1103: p_procedure_name => 'Process_ElemParam_Option');
1104: end if;
1105:

Line 1235: if FND_MSG_PUB.Check_Msg_Level

1231: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1232:
1233: when OTHERS then
1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: if FND_MSG_PUB.Check_Msg_Level
1236: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1237: then
1238: FND_MSG_PUB.Add_Exc_Msg
1239: (p_pkg_name => G_PKG_NAME,

Line 1236: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1232:
1233: when OTHERS then
1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: if FND_MSG_PUB.Check_Msg_Level
1236: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1237: then
1238: FND_MSG_PUB.Add_Exc_Msg
1239: (p_pkg_name => G_PKG_NAME,
1240: p_procedure_name => 'Process_ElemParam_PI');

Line 1238: FND_MSG_PUB.Add_Exc_Msg

1234: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: if FND_MSG_PUB.Check_Msg_Level
1236: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1237: then
1238: FND_MSG_PUB.Add_Exc_Msg
1239: (p_pkg_name => G_PKG_NAME,
1240: p_procedure_name => 'Process_ElemParam_PI');
1241: end if;
1242:

Line 1430: if FND_MSG_PUB.Check_Msg_Level

1426: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427:
1428: when OTHERS then
1429: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: if FND_MSG_PUB.Check_Msg_Level
1431: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1432: then
1433: FND_MSG_PUB.Add_Exc_Msg
1434: (p_pkg_name => G_PKG_NAME,

Line 1431: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1427:
1428: when OTHERS then
1429: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: if FND_MSG_PUB.Check_Msg_Level
1431: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1432: then
1433: FND_MSG_PUB.Add_Exc_Msg
1434: (p_pkg_name => G_PKG_NAME,
1435: p_procedure_name => 'Process_ElemParam_AutoInc');

Line 1433: FND_MSG_PUB.Add_Exc_Msg

1429: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: if FND_MSG_PUB.Check_Msg_Level
1431: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1432: then
1433: FND_MSG_PUB.Add_Exc_Msg
1434: (p_pkg_name => G_PKG_NAME,
1435: p_procedure_name => 'Process_ElemParam_AutoInc');
1436: end if;
1437:

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

1732: EXCEPTION
1733:
1734: when FND_API.G_EXC_ERROR then
1735: p_return_status := FND_API.G_RET_STS_ERROR;
1736: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1737: p_data => x_msg_data);
1738:
1739:
1740: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

1738:
1739:
1740: when FND_API.G_EXC_UNEXPECTED_ERROR then
1741: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1742: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1743: p_data => x_msg_data);
1744:
1745: when OTHERS then
1746: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1748: if FND_MSG_PUB.Check_Msg_Level

1744:
1745: when OTHERS then
1746: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747:
1748: if FND_MSG_PUB.Check_Msg_Level
1749: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1750: then
1751: FND_MSG_PUB.Add_Exc_Msg
1752: (p_pkg_name => G_PKG_NAME,

Line 1749: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1745: when OTHERS then
1746: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747:
1748: if FND_MSG_PUB.Check_Msg_Level
1749: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1750: then
1751: FND_MSG_PUB.Add_Exc_Msg
1752: (p_pkg_name => G_PKG_NAME,
1753: p_procedure_name => l_api_name);

Line 1751: FND_MSG_PUB.Add_Exc_Msg

1747:
1748: if FND_MSG_PUB.Check_Msg_Level
1749: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1750: then
1751: FND_MSG_PUB.Add_Exc_Msg
1752: (p_pkg_name => G_PKG_NAME,
1753: p_procedure_name => l_api_name);
1754: end if;
1755:

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

1752: (p_pkg_name => G_PKG_NAME,
1753: p_procedure_name => l_api_name);
1754: end if;
1755:
1756: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1757: p_data => x_msg_data);
1758:
1759: END Revise_Position_Projections;
1760:

Line 2071: if FND_MSG_PUB.Check_Msg_Level

2067:
2068: when OTHERS then
2069: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070:
2071: if FND_MSG_PUB.Check_Msg_Level
2072: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2073: then
2074: FND_MSG_PUB.Add_Exc_Msg
2075: (p_pkg_name => G_PKG_NAME,

Line 2072: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2068: when OTHERS then
2069: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070:
2071: if FND_MSG_PUB.Check_Msg_Level
2072: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2073: then
2074: FND_MSG_PUB.Add_Exc_Msg
2075: (p_pkg_name => G_PKG_NAME,
2076: p_procedure_name => l_api_name);

Line 2074: FND_MSG_PUB.Add_Exc_Msg

2070:
2071: if FND_MSG_PUB.Check_Msg_Level
2072: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2073: then
2074: FND_MSG_PUB.Add_Exc_Msg
2075: (p_pkg_name => G_PKG_NAME,
2076: p_procedure_name => l_api_name);
2077: end if;
2078:

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

2353: EXCEPTION
2354:
2355: when FND_API.G_EXC_ERROR then
2356: p_return_status := FND_API.G_RET_STS_ERROR;
2357: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2358: p_data => l_msg_data);
2359:
2360:
2361: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

2359:
2360:
2361: when FND_API.G_EXC_UNEXPECTED_ERROR then
2362: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2363: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2364: p_data => l_msg_data);
2365:
2366: when OTHERS then
2367: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2369: if FND_MSG_PUB.Check_Msg_Level

2365:
2366: when OTHERS then
2367: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2368:
2369: if FND_MSG_PUB.Check_Msg_Level
2370: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2371: then
2372: FND_MSG_PUB.Add_Exc_Msg
2373: (p_pkg_name => G_PKG_NAME,

Line 2370: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2366: when OTHERS then
2367: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2368:
2369: if FND_MSG_PUB.Check_Msg_Level
2370: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2371: then
2372: FND_MSG_PUB.Add_Exc_Msg
2373: (p_pkg_name => G_PKG_NAME,
2374: p_procedure_name => l_api_name);

Line 2372: FND_MSG_PUB.Add_Exc_Msg

2368:
2369: if FND_MSG_PUB.Check_Msg_Level
2370: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2371: then
2372: FND_MSG_PUB.Add_Exc_Msg
2373: (p_pkg_name => G_PKG_NAME,
2374: p_procedure_name => l_api_name);
2375: end if;
2376:

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

2373: (p_pkg_name => G_PKG_NAME,
2374: p_procedure_name => l_api_name);
2375: end if;
2376:
2377: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2378: p_data => l_msg_data);
2379:
2380: END Process_PosParam_Detailed;
2381:

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

2615: EXCEPTION
2616:
2617: when FND_API.G_EXC_ERROR then
2618: p_return_status := FND_API.G_RET_STS_ERROR;
2619: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2620: p_data => x_msg_data);
2621:
2622:
2623: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

2621:
2622:
2623: when FND_API.G_EXC_UNEXPECTED_ERROR then
2624: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2625: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2626: p_data => x_msg_data);
2627:
2628: when OTHERS then
2629: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2631: if FND_MSG_PUB.Check_Msg_Level

2627:
2628: when OTHERS then
2629: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2630:
2631: if FND_MSG_PUB.Check_Msg_Level
2632: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2633: then
2634: FND_MSG_PUB.Add_Exc_Msg
2635: (p_pkg_name => G_PKG_NAME,

Line 2632: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2628: when OTHERS then
2629: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2630:
2631: if FND_MSG_PUB.Check_Msg_Level
2632: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2633: then
2634: FND_MSG_PUB.Add_Exc_Msg
2635: (p_pkg_name => G_PKG_NAME,
2636: p_procedure_name => l_api_name);

Line 2634: FND_MSG_PUB.Add_Exc_Msg

2630:
2631: if FND_MSG_PUB.Check_Msg_Level
2632: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2633: then
2634: FND_MSG_PUB.Add_Exc_Msg
2635: (p_pkg_name => G_PKG_NAME,
2636: p_procedure_name => l_api_name);
2637: end if;
2638:

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

2874: EXCEPTION
2875:
2876: when FND_API.G_EXC_ERROR then
2877: p_return_status := FND_API.G_RET_STS_ERROR;
2878: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2879: p_data => l_msg_data);
2880:
2881:
2882: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

2880:
2881:
2882: when FND_API.G_EXC_UNEXPECTED_ERROR then
2883: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2884: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2885: p_data => l_msg_data);
2886:
2887: when OTHERS then
2888: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2890: if FND_MSG_PUB.Check_Msg_Level

2886:
2887: when OTHERS then
2888: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2889:
2890: if FND_MSG_PUB.Check_Msg_Level
2891: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2892: then
2893: FND_MSG_PUB.Add_Exc_Msg
2894: (p_pkg_name => G_PKG_NAME,

Line 2891: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2887: when OTHERS then
2888: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2889:
2890: if FND_MSG_PUB.Check_Msg_Level
2891: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2892: then
2893: FND_MSG_PUB.Add_Exc_Msg
2894: (p_pkg_name => G_PKG_NAME,
2895: p_procedure_name => l_api_name);

Line 2893: FND_MSG_PUB.Add_Exc_Msg

2889:
2890: if FND_MSG_PUB.Check_Msg_Level
2891: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2892: then
2893: FND_MSG_PUB.Add_Exc_Msg
2894: (p_pkg_name => G_PKG_NAME,
2895: p_procedure_name => l_api_name);
2896: end if;
2897:

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

3167: EXCEPTION
3168:
3169: when FND_API.G_EXC_ERROR then
3170: p_return_status := FND_API.G_RET_STS_ERROR;
3171: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
3172: p_data => x_msg_data);
3173:
3174:
3175: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

3173:
3174:
3175: when FND_API.G_EXC_UNEXPECTED_ERROR then
3176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3177: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
3178: p_data => x_msg_data);
3179:
3180: when OTHERS then
3181: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3183: if FND_MSG_PUB.Check_Msg_Level

3179:
3180: when OTHERS then
3181: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3182:
3183: if FND_MSG_PUB.Check_Msg_Level
3184: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3185: then
3186: FND_MSG_PUB.Add_Exc_Msg
3187: (p_pkg_name => G_PKG_NAME,

Line 3184: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3180: when OTHERS then
3181: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3182:
3183: if FND_MSG_PUB.Check_Msg_Level
3184: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3185: then
3186: FND_MSG_PUB.Add_Exc_Msg
3187: (p_pkg_name => G_PKG_NAME,
3188: p_procedure_name => l_api_name);

Line 3186: FND_MSG_PUB.Add_Exc_Msg

3182:
3183: if FND_MSG_PUB.Check_Msg_Level
3184: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3185: then
3186: FND_MSG_PUB.Add_Exc_Msg
3187: (p_pkg_name => G_PKG_NAME,
3188: p_procedure_name => l_api_name);
3189: end if;
3190:

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

3684: EXCEPTION
3685:
3686: when FND_API.G_EXC_ERROR then
3687: p_return_status := FND_API.G_RET_STS_ERROR;
3688: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3689: p_data => l_msg_data);
3690:
3691:
3692: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

3690:
3691:
3692: when FND_API.G_EXC_UNEXPECTED_ERROR then
3693: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3694: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3695: p_data => l_msg_data);
3696:
3697: when OTHERS then
3698: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3700: if FND_MSG_PUB.Check_Msg_Level

3696:
3697: when OTHERS then
3698: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3699:
3700: if FND_MSG_PUB.Check_Msg_Level
3701: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3702: then
3703: FND_MSG_PUB.Add_Exc_Msg
3704: (p_pkg_name => G_PKG_NAME,

Line 3701: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3697: when OTHERS then
3698: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3699:
3700: if FND_MSG_PUB.Check_Msg_Level
3701: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3702: then
3703: FND_MSG_PUB.Add_Exc_Msg
3704: (p_pkg_name => G_PKG_NAME,
3705: p_procedure_name => l_api_name);

Line 3703: FND_MSG_PUB.Add_Exc_Msg

3699:
3700: if FND_MSG_PUB.Check_Msg_Level
3701: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3702: then
3703: FND_MSG_PUB.Add_Exc_Msg
3704: (p_pkg_name => G_PKG_NAME,
3705: p_procedure_name => l_api_name);
3706: end if;
3707:

Line 3954: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

3950:
3951: when OTHERS then
3952: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3953:
3954: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
3955: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3956: l_api_name);
3957: end if;
3958:

Line 3955: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

3951: when OTHERS then
3952: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3953:
3954: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
3955: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
3956: l_api_name);
3957: end if;
3958:
3959: END Redistribute_Follow_Salary;

Line 4539: if FND_MSG_PUB.Check_Msg_Level

4535: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4536:
4537: when OTHERS then
4538: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4539: if FND_MSG_PUB.Check_Msg_Level
4540: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4541: then
4542: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4543: 'Redist_Follow_Salary_Year');

Line 4540: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4536:
4537: when OTHERS then
4538: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4539: if FND_MSG_PUB.Check_Msg_Level
4540: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4541: then
4542: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4543: 'Redist_Follow_Salary_Year');
4544: end if;

Line 4542: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

4538: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4539: if FND_MSG_PUB.Check_Msg_Level
4540: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4541: then
4542: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4543: 'Redist_Follow_Salary_Year');
4544: end if;
4545:
4546: END Redist_Follow_Salary_Year;

Line 4613: if FND_MSG_PUB.Check_Msg_Level

4609: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4610:
4611: when OTHERS then
4612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4613: if FND_MSG_PUB.Check_Msg_Level
4614: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4615: then
4616: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4617: 'Apply_Element_Constraints');

Line 4614: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4610:
4611: when OTHERS then
4612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4613: if FND_MSG_PUB.Check_Msg_Level
4614: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4615: then
4616: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4617: 'Apply_Element_Constraints');
4618: end if;

Line 4616: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

4612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4613: if FND_MSG_PUB.Check_Msg_Level
4614: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4615: then
4616: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4617: 'Apply_Element_Constraints');
4618: end if;
4619:
4620: END Apply_Element_Constraints;

Line 4723: if FND_MSG_PUB.Check_Msg_Level

4719: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4720:
4721: when OTHERS then
4722: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4723: if FND_MSG_PUB.Check_Msg_Level
4724: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4725: then
4726: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4727: 'Process_ElemCons_Detailed');

Line 4724: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4720:
4721: when OTHERS then
4722: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4723: if FND_MSG_PUB.Check_Msg_Level
4724: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4725: then
4726: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4727: 'Process_ElemCons_Detailed');
4728: end if;

Line 4726: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

4722: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4723: if FND_MSG_PUB.Check_Msg_Level
4724: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4725: then
4726: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4727: 'Process_ElemCons_Detailed');
4728: end if;
4729:
4730: END Process_ElemCons_Detailed;

Line 4934: if FND_MSG_PUB.Check_Msg_Level

4930: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4931:
4932: when OTHERS then
4933: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4934: if FND_MSG_PUB.Check_Msg_Level
4935: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4936: then
4937: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4938: 'Apply_Position_Constraints');

Line 4935: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4931:
4932: when OTHERS then
4933: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4934: if FND_MSG_PUB.Check_Msg_Level
4935: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4936: then
4937: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4938: 'Apply_Position_Constraints');
4939: end if;

Line 4937: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

4933: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4934: if FND_MSG_PUB.Check_Msg_Level
4935: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4936: then
4937: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4938: 'Apply_Position_Constraints');
4939: end if;
4940:
4941: END Apply_Position_Constraints;

Line 5077: if FND_MSG_PUB.Check_Msg_Level

5073: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5074:
5075: when OTHERS then
5076: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5077: if FND_MSG_PUB.Check_Msg_Level
5078: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5079: then
5080: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5081: 'Process_PosCons_Detailed');

Line 5078: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5074:
5075: when OTHERS then
5076: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5077: if FND_MSG_PUB.Check_Msg_Level
5078: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5079: then
5080: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5081: 'Process_PosCons_Detailed');
5082: end if;

Line 5080: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

5076: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5077: if FND_MSG_PUB.Check_Msg_Level
5078: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5079: then
5080: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5081: 'Process_PosCons_Detailed');
5082: end if;
5083:
5084: END Process_PosCons_Detailed;

Line 5189: if FND_MSG_PUB.Check_Msg_Level

5185: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5186:
5187: when OTHERS then
5188: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5189: if FND_MSG_PUB.Check_Msg_Level
5190: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5191: then
5192: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5193: 'Process_PosCons');

Line 5190: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5186:
5187: when OTHERS then
5188: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5189: if FND_MSG_PUB.Check_Msg_Level
5190: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5191: then
5192: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5193: 'Process_PosCons');
5194: end if;

Line 5192: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

5188: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5189: if FND_MSG_PUB.Check_Msg_Level
5190: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5191: then
5192: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5193: 'Process_PosCons');
5194: end if;
5195:
5196: END Process_PosCons;

Line 5560: l_description := FND_MSG_PUB.Get

5556: message_token('NAME', p_position_name);
5557: message_token('YEAR', p_budget_year_name);
5558: add_message('PSB', 'PSB_CONSTRAINT_FAILURE');
5559:
5560: l_description := FND_MSG_PUB.Get
5561: (p_encoded => FND_API.G_FALSE);
5562: FND_MSG_PUB.Delete_Msg;
5563:
5564: insert into PSB_ERROR_MESSAGES

Line 5562: FND_MSG_PUB.Delete_Msg;

5558: add_message('PSB', 'PSB_CONSTRAINT_FAILURE');
5559:
5560: l_description := FND_MSG_PUB.Get
5561: (p_encoded => FND_API.G_FALSE);
5562: FND_MSG_PUB.Delete_Msg;
5563:
5564: insert into PSB_ERROR_MESSAGES
5565: (Concurrent_Request_ID,
5566: Process_ID,

Line 5673: l_description := FND_MSG_PUB.Get

5669: message_token('NAME', c_SalaryNeqAll_Rec.position_name);
5670: message_token('YEAR', p_budget_year_name);
5671: add_message('PSB', 'PSB_CONSTRAINT_FAILURE');
5672:
5673: l_description := FND_MSG_PUB.Get
5674: (p_encoded => FND_API.G_FALSE);
5675: FND_MSG_PUB.Delete_Msg;
5676:
5677: insert into PSB_ERROR_MESSAGES

Line 5675: FND_MSG_PUB.Delete_Msg;

5671: add_message('PSB', 'PSB_CONSTRAINT_FAILURE');
5672:
5673: l_description := FND_MSG_PUB.Get
5674: (p_encoded => FND_API.G_FALSE);
5675: FND_MSG_PUB.Delete_Msg;
5676:
5677: insert into PSB_ERROR_MESSAGES
5678: (Concurrent_Request_ID,
5679: Process_ID,

Line 5797: l_description := FND_MSG_PUB.Get

5793:
5794: message_token('YEAR', p_budget_year_name);
5795: add_message('PSB', 'PSB_CONSTRAINT_FAILURE');
5796:
5797: l_description := FND_MSG_PUB.Get
5798: (p_encoded => FND_API.G_FALSE);
5799: FND_MSG_PUB.Delete_Msg;
5800:
5801: insert into PSB_ERROR_MESSAGES

Line 5799: FND_MSG_PUB.Delete_Msg;

5795: add_message('PSB', 'PSB_CONSTRAINT_FAILURE');
5796:
5797: l_description := FND_MSG_PUB.Get
5798: (p_encoded => FND_API.G_FALSE);
5799: FND_MSG_PUB.Delete_Msg;
5800:
5801: insert into PSB_ERROR_MESSAGES
5802: (Concurrent_Request_ID,
5803: Process_ID,

Line 5836: if FND_MSG_PUB.Check_Msg_Level

5832: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5833:
5834: when OTHERS then
5835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5836: if FND_MSG_PUB.Check_Msg_Level
5837: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5838: then
5839: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5840: 'Process_PosCons_Step');

Line 5837: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5833:
5834: when OTHERS then
5835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5836: if FND_MSG_PUB.Check_Msg_Level
5837: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5838: then
5839: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5840: 'Process_PosCons_Step');
5841: end if;

Line 5839: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

5835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5836: if FND_MSG_PUB.Check_Msg_Level
5837: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5838: then
5839: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5840: 'Process_PosCons_Step');
5841: end if;
5842:
5843: END Process_PosCons_Step;

Line 6083: l_description := FND_MSG_PUB.Get

6079:
6080: message_token('YEAR', p_budget_year_name);
6081: add_message('PSB', 'PSB_CONSTRAINT_FAILURE');
6082:
6083: l_description := FND_MSG_PUB.Get
6084: (p_encoded => FND_API.G_FALSE);
6085: FND_MSG_PUB.Delete_Msg;
6086:
6087: insert into PSB_ERROR_MESSAGES

Line 6085: FND_MSG_PUB.Delete_Msg;

6081: add_message('PSB', 'PSB_CONSTRAINT_FAILURE');
6082:
6083: l_description := FND_MSG_PUB.Get
6084: (p_encoded => FND_API.G_FALSE);
6085: FND_MSG_PUB.Delete_Msg;
6086:
6087: insert into PSB_ERROR_MESSAGES
6088: (Concurrent_Request_ID,
6089: Process_ID,

Line 6124: if FND_MSG_PUB.Check_Msg_Level

6120: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6121:
6122: when OTHERS then
6123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6124: if FND_MSG_PUB.Check_Msg_Level
6125: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6126: then
6127: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6128: 'Process_FTECons');

Line 6125: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6121:
6122: when OTHERS then
6123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6124: if FND_MSG_PUB.Check_Msg_Level
6125: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6126: then
6127: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6128: 'Process_FTECons');
6129: end if;

Line 6127: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

6123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6124: if FND_MSG_PUB.Check_Msg_Level
6125: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6126: then
6127: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6128: 'Process_FTECons');
6129: end if;
6130:
6131: END Process_FTECons;

Line 6178: FND_MSG_PUB.Add;

6174: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));
6175: end loop;
6176: end if;
6177:
6178: FND_MSG_PUB.Add;
6179:
6180: end if;
6181:
6182: -- Clear Message Token stack