[Home] [Help]
151: , x_return_status => x_return_status
152: , x_msg_count => x_msg_count
153: , x_msg_data => x_msg_data);
154:
155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
156: l_msg_count := FND_MSG_PUB.count_msg;
157: IF l_msg_count = 1 THEN
158: PA_INTERFACE_UTILS_PUB.get_messages
159: (p_encoded => FND_API.G_TRUE,
155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
156: l_msg_count := FND_MSG_PUB.count_msg;
157: IF l_msg_count = 1 THEN
158: PA_INTERFACE_UTILS_PUB.get_messages
159: (p_encoded => FND_API.G_TRUE,
160: p_msg_index => 1,
161: p_msg_count => l_msg_count,
162: p_msg_data => l_msg_data,
163: p_data => l_data,
166: x_msg_count := l_msg_count;
167: ELSE
168: x_msg_count := l_msg_count;
169: END IF;
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: END IF;
172:
173:
174: IF (l_plan_pref_code = 'COST_ONLY' AND x_layout_code IS NULL ) OR
174: IF (l_plan_pref_code = 'COST_ONLY' AND x_layout_code IS NULL ) OR
175: (l_plan_pref_code = 'REVENUE_ONLY' AND x_layout_code IS NULL ) OR
176: (l_plan_pref_code = 'COST_AND_REV_SAME' AND x_layout_code IS NULL) THEN
177:
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179: x_err_msg_code := 'PA_FP_WEBADI_OLD_LAYOUT';
180: RETURN;
181: END IF;
182:
200: IF l_debug_mode = 'Y' THEN
201: pa_debug.g_err_stage:='The custom layout code is not present the system.';
202: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
203: END IF;
204: x_return_status := FND_API.G_RET_STS_SUCCESS;
205: x_err_msg_code := 'PA_FP_WEBADI_OLD_LAYOUT';
206: RETURN;
207: END;
208:
229: AND Lookup_code = l_plan_class_code;
230:
231: IF l_plan_class_code = 'BUDGET' THEN
232:
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234: x_err_msg_code := 'PA_FP_WEBADI_INCRT_BDGT_LAYOUT';
235: RETURN;
236:
237: ELSIF l_plan_class_code = 'FORECAST' THEN
235: RETURN;
236:
237: ELSIF l_plan_class_code = 'FORECAST' THEN
238:
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240: x_err_msg_code := 'PA_FP_WEBADI_INCRT_FCST_LAYOUT';
241: RETURN;
242:
243: END IF;
277: AND l_integrator_code IN ('FINPLAN_BUDGET_PERIODIC','FINPLAN_FORECAST_PERIODIC')) OR
278: (l_plan_pref_code = 'COST_AND_REV_SAME' AND l_all_time_phased_code= 'N'
279: AND l_integrator_code IN ('FINPLAN_BUDGET_PERIODIC','FINPLAN_FORECAST_PERIODIC')) THEN
280:
281: x_return_status := FND_API.G_RET_STS_SUCCESS;
282: x_err_msg_code := 'PA_FP_WEBADI_PER_LAYOUT';
283: RETURN;
284: END IF;
285:
330: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
331: l_msg_count := FND_MSG_PUB.count_msg;
332: IF l_msg_count = 1 THEN
333: PA_INTERFACE_UTILS_PUB.get_messages
334: (p_encoded => FND_API.G_TRUE
335: ,p_msg_index => 1
336: ,p_msg_count => l_msg_count
337: ,p_msg_data => l_msg_data
338: ,p_data => l_data
342: x_msg_count := l_msg_count;
343: ELSE
344: x_msg_count := l_msg_count;
345: END IF;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347:
348: IF l_debug_mode = 'Y' THEN
349: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
350: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
353: -- reset curr function
354: pa_debug.reset_curr_function();
355: RETURN;
356: WHEN OTHERS THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: x_msg_count := 1;
359: x_msg_data := SQLERRM;
360:
361: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_utils'
478: END IF;
479: END IF;
480:
481: EXCEPTION
482: WHEN FND_API.G_EXC_ERROR or PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: l_msg_count := FND_MSG_PUB.count_msg;
485: IF l_msg_count = 1 THEN
486: PA_INTERFACE_UTILS_PUB.get_messages
479: END IF;
480:
481: EXCEPTION
482: WHEN FND_API.G_EXC_ERROR or PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: l_msg_count := FND_MSG_PUB.count_msg;
485: IF l_msg_count = 1 THEN
486: PA_INTERFACE_UTILS_PUB.get_messages
487: (p_encoded => FND_API.G_TRUE,
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: l_msg_count := FND_MSG_PUB.count_msg;
485: IF l_msg_count = 1 THEN
486: PA_INTERFACE_UTILS_PUB.get_messages
487: (p_encoded => FND_API.G_TRUE,
488: p_msg_index => 1,
489: p_msg_count => l_msg_count,
490: p_msg_data => l_msg_data,
491: p_data => l_data,
511: IS
512:
513: BEGIN
514:
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: IF p_task_num is not NULL then
518:
519: BEGIN
526:
527: EXCEPTION
528: When NO_DATA_FOUND THEN
529:
530: x_return_status := FND_API.G_RET_STS_ERROR;
531:
532: END;
533:
534: ELSE x_task_id := 0;
569: where proj_fp_options_id = l_proj_fp_options_id --Sql Performance to avoid FTS fix sql id 16509328
570: and txn_currency_code = p_currency_code;
571: exception
572: When NO_DATA_FOUND THEN
573: x_return_status := FND_API.G_RET_STS_ERROR;
574:
575: end;
576:
577: end if;
648: Exception
649: When NO_DATA_FOUND THEN
650:
651: x_resource_gp_flag := 'Y';
652: x_return_status := FND_API.G_RET_STS_ERROR;
653:
654: return;
655:
656: End;
681:
682: Exception
683: When NO_DATA_FOUND THEN
684: x_resource_alias_flag := 'Y';
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: return;
687: End;
688:
689: x_resource_list_member_id := l_rlm_id_alias;
703:
704: Exception
705: When NO_DATA_FOUND THEN
706: x_resource_alias_flag := 'Y';
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: return;
709: End;
710:
711: END IF; --End if l_group_resource_type_id>0
803: AND prlm.parent_member_id = prlm_parent.resource_list_member_id(+);
804:
805: BEGIN
806: x_msg_count := 0;
807: x_return_status := FND_API.G_RET_STS_SUCCESS;
808: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
809:
810: IF l_debug_mode = 'Y' THEN
811: pa_debug.set_curr_function( p_function => 'GET_RES_ASSIGNMENT_INFO'
823: pa_debug.g_err_stage :='Invalid input parameter';
824: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
825: END IF;
826:
827: x_return_status := FND_API.G_RET_STS_ERROR;
828: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
829: ,p_msg_name => 'PA_FP_INV_PARAM_PASSED');
830: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
831: END IF;
855: IF c_project_level_info%NOTFOUND THEN
856:
857: -- Indicates that the resource assignment id past
858: -- to the API is invalid.
859: x_return_status := FND_API.G_RET_STS_ERROR ;
860:
861: END IF ;
862: -- 4346858.Cursor c_project_level_info is closed.
863: CLOSE c_project_level_info;
883:
884: IF c_task_level_info%NOTFOUND THEN
885: -- Indicates that the resource assignment id past
886: -- to the API is invalid.
887: x_return_status := FND_API.G_RET_STS_ERROR ;
888: END IF ;
889: -- 4346858.Cursor c_task_level_info is closed.
890: CLOSE c_task_level_info;
891: END IF ;
893: pa_debug.reset_curr_function;
894:
895: EXCEPTION
896: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: l_msg_count := FND_MSG_PUB.count_msg;
899: IF l_msg_count = 1 THEN
900: PA_INTERFACE_UTILS_PUB.get_messages
901: (p_encoded => FND_API.G_TRUE,
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: l_msg_count := FND_MSG_PUB.count_msg;
899: IF l_msg_count = 1 THEN
900: PA_INTERFACE_UTILS_PUB.get_messages
901: (p_encoded => FND_API.G_TRUE,
902: p_msg_index => 1,
903: p_msg_count => l_msg_count,
904: p_msg_data => l_msg_data,
905: p_data => l_data,
918: END IF;
919: RETURN;
920: WHEN OTHERS THEN
921:
922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923: x_msg_count := 1;
924: x_msg_data := SQLERRM;
925:
926: FND_MSG_PUB.add_exc_msg
935: pa_debug.write(g_module_name,pa_debug.G_Err_Stage,4);
936: pa_debug.reset_curr_function;
937:
938: END IF;
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940:
941: END GET_RES_ASSIGNMENT_INFO ;
942:
943: /* Bug 5350437: Commented the below API
962: AND LOOKUP_CODE = p_change_reason_code ;
963:
964: BEGIN
965: x_msg_count := 0;
966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
968:
969: IF l_debug_mode = 'Y' THEN
970: pa_debug.set_err_stack('PA_FP_WEBADI_UTILS.VALIDATE_CHANGE_REASON_CODE');
990: pa_debug.g_err_stage:= 'could not find change reason code';
991: pa_debug.write(g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
992: END IF;
993:
994: x_return_status := FND_API.G_RET_STS_ERROR ;
995: END IF ;
996:
997: IF l_debug_mode = 'Y' THEN
998: pa_debug.g_err_stage:= 'Exiting VALIDATE_CHANGE_REASON_CODE';
1003:
1004: EXCEPTION
1005:
1006: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: l_msg_count := FND_MSG_PUB.count_msg;
1009: IF l_msg_count = 1 THEN
1010: PA_INTERFACE_UTILS_PUB.get_messages
1011: (p_encoded => FND_API.G_TRUE,
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: l_msg_count := FND_MSG_PUB.count_msg;
1009: IF l_msg_count = 1 THEN
1010: PA_INTERFACE_UTILS_PUB.get_messages
1011: (p_encoded => FND_API.G_TRUE,
1012: p_msg_index => 1,
1013: p_msg_count => l_msg_count,
1014: p_msg_data => l_msg_data,
1015: p_data => l_data,
1034:
1035: END IF;
1036: RETURN;
1037: WHEN OTHERS THEN
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: x_msg_count := 1;
1040: x_msg_data := SQLERRM;
1041:
1042: FND_MSG_PUB.add_exc_msg
1049: pa_debug.write('VALIDATE_CHANGE_REASON_CODE :' || g_module_name,pa_debug.G_Err_Stack,4);
1050: END IF;
1051: pa_debug.reset_err_stack;
1052:
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054:
1055: END VALIDATE_CHANGE_REASON_CODE ;
1056: */ -- end of bug 5350437
1057:
1080:
1081: BEGIN
1082:
1083: x_msg_count := 0;
1084: x_return_status := FND_API.G_RET_STS_SUCCESS;
1085: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1086:
1087: IF l_debug_mode = 'Y' THEN
1088: pa_debug.set_err_stack('PA_FP_WEBADI_UTILS.VALIDATE_TXN_CURRENCY_CODE');
1138: END LOOP ;
1139: END IF ;
1140:
1141: IF l_curr_found THEN
1142: x_return_status := FND_API.G_RET_STS_SUCCESS;
1143: ELSE
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: END IF;
1146:
1140:
1141: IF l_curr_found THEN
1142: x_return_status := FND_API.G_RET_STS_SUCCESS;
1143: ELSE
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: END IF;
1146:
1147: -- Close the cursor if its open
1148: IF C_TXN_CURR_CODE%ISOPEN THEN
1158: EXCEPTION
1159:
1160: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1161:
1162: x_return_status := FND_API.G_RET_STS_ERROR;
1163: l_msg_count := FND_MSG_PUB.count_msg;
1164:
1165: -- Close the cursor if its open
1166:
1169: END IF ;
1170:
1171: IF l_msg_count = 1 THEN
1172: PA_INTERFACE_UTILS_PUB.get_messages
1173: (p_encoded => FND_API.G_TRUE,
1174: p_msg_index => 1,
1175: p_msg_count => l_msg_count,
1176: p_msg_data => l_msg_data,
1177: p_data => l_data,
1189:
1190: RETURN;
1191: WHEN OTHERS THEN
1192:
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1194: x_msg_count := 1;
1195: x_msg_data := SQLERRM;
1196:
1197: -- Close the cursor if its open
1211: pa_debug.write('VALIDATE_TXN_CURRENCY_CODE :' || g_module_name,pa_debug.G_Err_Stack,4);
1212: END IF;
1213: pa_debug.reset_err_stack;
1214:
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216:
1217:
1218: END VALIDATE_TXN_CURRENCY_CODE ;
1219:
1410: AND ppp.period_profile_id = pbv.period_profile_id ;
1411:
1412: BEGIN
1413: x_msg_count := 0;
1414: x_return_status := FND_API.G_RET_STS_SUCCESS;
1415: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
1416:
1417: IF l_debug_mode = 'Y' THEN
1418: pa_debug.set_err_stack('PA_FP_WEBADI_PKG.GET_VERSION_PERIOD_INFO');
1428: IF l_debug_mode = 'Y' THEN
1429: pa_debug.g_err_stage := 'INVALID INPUT PARAMETER';
1430: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1431: END IF;
1432: x_return_status := FND_API.G_RET_STS_ERROR;
1433: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1434: ,p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1435: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1436: END IF;
1616:
1617: EXCEPTION
1618: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1619:
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621: l_msg_count := FND_MSG_PUB.count_msg;
1622: -- Close the cursor
1623:
1624: IF C_PERIOD_DATES_CUR%ISOPEN THEN
1631: END IF;
1632:
1633: IF l_msg_count = 1 THEN
1634: PA_INTERFACE_UTILS_PUB.get_messages
1635: (p_encoded => FND_API.G_TRUE,
1636: p_msg_index => 1,
1637: p_msg_count => l_msg_count,
1638: p_msg_data => l_msg_data,
1639: p_data => l_data,
1650: END IF ;
1651:
1652: RETURN;
1653: WHEN OTHERS THEN
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: x_msg_count := 1;
1656: x_msg_data := SQLERRM;
1657:
1658: IF C_PERIOD_DATES_CUR%ISOPEN THEN
1669:
1670: IF l_debug_mode = 'Y' THEN
1671: pa_debug.reset_err_stack;
1672: END IF ;
1673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1674:
1675: END GET_VERSION_PERIODS_INFO;
1676: */ -- end of Bug 5350437
1677:
1720: AND a.end_date >= bl.start_date )) ;
1721:
1722: BEGIN
1723: x_msg_count := 0;
1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
1726:
1727: IF l_debug_mode = 'Y' THEN
1728: pa_debug.set_err_stack('PA_FP_WEBADI_PKG.CHECK_OVERLAPPING_DATES');
1738: IF l_debug_mode = 'Y' THEN
1739: pa_debug.g_err_stage := 'INVALID INPUT PARAMETER';
1740: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
1741: END IF;
1742: x_return_status := FND_API.G_RET_STS_ERROR;
1743: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
1744: ,p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1745: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1746: END IF;
1774: END IF ;
1775:
1776: EXCEPTION
1777: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1778: x_return_status := FND_API.G_RET_STS_ERROR;
1779: l_msg_count := FND_MSG_PUB.count_msg;
1780:
1781: -- Close the cursor
1782:
1790: END IF;
1791:
1792: IF l_msg_count = 1 THEN
1793: PA_INTERFACE_UTILS_PUB.get_messages
1794: (p_encoded => FND_API.G_TRUE,
1795: p_msg_index => 1,
1796: p_msg_count => l_msg_count,
1797: p_msg_data => l_msg_data,
1798: p_data => l_data,
1809: END IF ;
1810:
1811: RETURN;
1812: WHEN OTHERS THEN
1813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1814: x_msg_count := 1;
1815: x_msg_data := SQLERRM;
1816:
1817: IF C_OVERLAPPING_CUR%ISOPEN THEN
1829: IF l_debug_mode = 'Y' THEN
1830: pa_debug.reset_err_stack;
1831: END IF ;
1832:
1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1834:
1835: END CHECK_OVERLAPPING_DATES;
1836:
1837: /*==================================================================
1859:
1860: BEGIN
1861:
1862: x_msg_count := 0;
1863: x_return_status := FND_API.G_RET_STS_SUCCESS;
1864: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1865:
1866: IF l_debug_mode = 'Y' THEN
1867: pa_debug.g_err_stage:= 'Entering GET_ERROR_LOOKUP_CODE';
1999: EXCEPTION
2000:
2001: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2002:
2003: x_return_status := FND_API.G_RET_STS_ERROR;
2004: l_msg_count := FND_MSG_PUB.count_msg;
2005:
2006: IF l_msg_count = 1 and x_msg_data IS NULL THEN
2007: PA_INTERFACE_UTILS_PUB.get_messages
2004: l_msg_count := FND_MSG_PUB.count_msg;
2005:
2006: IF l_msg_count = 1 and x_msg_data IS NULL THEN
2007: PA_INTERFACE_UTILS_PUB.get_messages
2008: (p_encoded => FND_API.G_TRUE
2009: ,p_msg_index => 1
2010: ,p_msg_count => l_msg_count
2011: ,p_msg_data => l_msg_data
2012: ,p_data => l_data
2022: RETURN;
2023:
2024: WHEN others THEN
2025:
2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027: x_msg_count := 1;
2028: x_msg_data := SQLERRM;
2029:
2030: FND_MSG_PUB.add_exc_msg
2103:
2104: BEGIN
2105:
2106: x_msg_count := 0;
2107: x_return_status := FND_API.G_RET_STS_SUCCESS;
2108: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2109:
2110: IF l_debug_mode = 'Y' THEN
2111: pa_debug.set_curr_function( p_function => 'CONV_MC_ATTR_MEANING_TO_CODE',
2204: EXCEPTION
2205:
2206: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2207:
2208: x_return_status := FND_API.G_RET_STS_ERROR;
2209: l_msg_count := FND_MSG_PUB.count_msg;
2210:
2211:
2212: IF l_msg_count = 1 and x_msg_data IS NULL THEN
2210:
2211:
2212: IF l_msg_count = 1 and x_msg_data IS NULL THEN
2213: PA_INTERFACE_UTILS_PUB.get_messages
2214: (p_encoded => FND_API.G_TRUE
2215: ,p_msg_index => 1
2216: ,p_msg_count => l_msg_count
2217: ,p_msg_data => l_msg_data
2218: ,p_data => l_data
2228: RETURN;
2229:
2230: WHEN others THEN
2231:
2232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2233: x_msg_count := 1;
2234: x_msg_data := SQLERRM;
2235:
2236: FND_MSG_PUB.add_exc_msg
2298: l_integrator_code VARCHAR2(30);
2299: l_layout_name bne_layouts_tl.user_name%TYPE;
2300: BEGIN
2301: x_msg_count := 0;
2302: x_return_status := FND_API.G_RET_STS_SUCCESS;
2303:
2304: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2305: l_debug_mode := NVL(l_debug_mode, 'Y');
2306:
2363: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2364: l_msg_count := FND_MSG_PUB.count_msg;
2365: IF l_msg_count = 1 THEN
2366: PA_INTERFACE_UTILS_PUB.get_messages
2367: (p_encoded => FND_API.G_TRUE
2368: ,p_msg_index => 1
2369: ,p_msg_count => l_msg_count
2370: ,p_msg_data => l_msg_data
2371: ,p_data => l_data
2375: x_msg_count := l_msg_count;
2376: ELSE
2377: x_msg_count := l_msg_count;
2378: END IF;
2379: x_return_status := FND_API.G_RET_STS_ERROR;
2380:
2381: IF l_debug_mode = 'Y' THEN
2382: pa_debug.g_err_stage:='Invalid Arguments Passed Or called api raised an error';
2383: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
2386: -- reset curr function
2387: pa_debug.reset_curr_function();
2388: RETURN;
2389: WHEN OTHERS THEN
2390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2391: x_msg_count := 1;
2392: x_msg_data := SQLERRM;
2393:
2394: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_utils'
2430: BEGIN
2431: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2432:
2433: x_msg_count := 0;
2434: x_return_status := FND_API.G_RET_STS_SUCCESS;
2435:
2436: PA_DEBUG.Set_Curr_Function(p_function => l_module_name,
2437: p_debug_mode => l_debug_mode );
2438:
2494: ,x_return_status => x_return_status
2495: ,x_msg_count => x_msg_count
2496: ,x_msg_data => x_msg_data);
2497:
2498: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2499: IF l_debug_mode = 'Y' THEN
2500: pa_debug.g_err_stage := 'Call to PA_FP_WEBADI_PKG.delete_xface returned with error';
2501: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2502: END IF;
2529: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2530: l_msg_count := FND_MSG_PUB.count_msg;
2531: IF l_msg_count = 1 THEN
2532: PA_INTERFACE_UTILS_PUB.get_messages
2533: (p_encoded => FND_API.G_TRUE
2534: ,p_msg_index => 1
2535: ,p_msg_count => l_msg_count
2536: ,p_msg_data => l_msg_data
2537: ,p_data => l_data
2576: BEGIN
2577: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2578:
2579: x_msg_count := 0;
2580: x_return_status := FND_API.G_RET_STS_SUCCESS;
2581:
2582: PA_DEBUG.Set_Curr_Function(p_function => l_module_name,
2583: p_debug_mode => l_debug_mode );
2584:
2667: pa_debug.g_err_stage:='The concurrent request Resubmission falied';
2668: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2669: END IF;
2670:
2671: x_return_status := FND_API.G_RET_STS_ERROR;
2672:
2673: UPDATE pa_budget_versions
2674: SET plan_processing_code = 'XLUE'
2675: WHERE budget_version_id = l_budget_version_id;
2714: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2715: l_msg_count := FND_MSG_PUB.count_msg;
2716: IF l_msg_count = 1 THEN
2717: PA_INTERFACE_UTILS_PUB.get_messages
2718: (p_encoded => FND_API.G_TRUE
2719: ,p_msg_index => 1
2720: ,p_msg_count => l_msg_count
2721: ,p_msg_data => l_msg_data
2722: ,p_data => l_data