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.PA_FP_EDIT_LINE_PKG dependencies on FND_API

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

65: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
66: l_debug_mode := NVL(l_debug_mode, 'Y');
67:
68: -- Initialize the return status to success
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
71:
72: pa_debug.g_err_stage := 'In PA_FP_EDIT_LINE_PKG.Populate_Local_Variables ';
73: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 140: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

136: ,x_number_of_periods => l_number_of_periods
137: ,x_return_status => l_return_status
138: ,x_msg_data => l_msg_data );
139:
140: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
141: RAISE FND_API.G_EXC_ERROR;
142: /* PA_PRJ_PERIOD_PROFILE_UTILS.GET_PRJ_PERIOD_PROFILE_DTLS doesn't
143: raise error and hence this error trapping is done */
144: END IF;

Line 141: RAISE FND_API.G_EXC_ERROR;

137: ,x_return_status => l_return_status
138: ,x_msg_data => l_msg_data );
139:
140: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
141: RAISE FND_API.G_EXC_ERROR;
142: /* PA_PRJ_PERIOD_PROFILE_UTILS.GET_PRJ_PERIOD_PROFILE_DTLS doesn't
143: raise error and hence this error trapping is done */
144: END IF;
145:

Line 170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

166: ,x_return_status => x_return_status
167: ,x_msg_count => x_msg_count
168: ,x_msg_data => x_msg_data);
169:
170: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
171: IF P_PA_DEBUG_MODE = 'Y' THEN
172: pa_debug.g_err_stage := 'Call to derive_pd_sd_start_end_dates errored... ';
173: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
174: END IF;

Line 221: WHEN FND_API.G_EXC_ERROR or PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

217:
218: pa_debug.reset_err_stack; /* Bug 2699888 */
219:
220: EXCEPTION
221: WHEN FND_API.G_EXC_ERROR or PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: l_msg_count := FND_MSG_PUB.count_msg;
224: IF l_msg_count = 1 THEN
225: PA_INTERFACE_UTILS_PUB.get_messages

Line 222: x_return_status := FND_API.G_RET_STS_ERROR;

218: pa_debug.reset_err_stack; /* Bug 2699888 */
219:
220: EXCEPTION
221: WHEN FND_API.G_EXC_ERROR or PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: l_msg_count := FND_MSG_PUB.count_msg;
224: IF l_msg_count = 1 THEN
225: PA_INTERFACE_UTILS_PUB.get_messages
226: (p_encoded => FND_API.G_TRUE,

Line 226: (p_encoded => FND_API.G_TRUE,

222: x_return_status := FND_API.G_RET_STS_ERROR;
223: l_msg_count := FND_MSG_PUB.count_msg;
224: IF l_msg_count = 1 THEN
225: PA_INTERFACE_UTILS_PUB.get_messages
226: (p_encoded => FND_API.G_TRUE,
227: p_msg_index => 1,
228: p_msg_count => l_msg_count,
229: p_msg_data => l_msg_data,
230: p_data => l_data,

Line 248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

244:
245: RAISE;
246:
247: WHEN OTHERS THEN
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: x_msg_count := 1;
250: x_msg_data := SQLERRM;
251: FND_MSG_PUB.add_exc_msg
252: ( p_pkg_name => 'PA_FP_EDIT_LINE_PKG.Populate_Local_Variables'

Line 260: raise FND_API.G_EXC_UNEXPECTED_ERROR;

256: pa_debug.write('POPULATE_LOCAL_VARIABLES: ' || l_module_name,pa_debug.G_Err_Stack,5);
257: END IF;
258: pa_debug.reset_err_stack;
259:
260: raise FND_API.G_EXC_UNEXPECTED_ERROR;
261: END POPULATE_LOCAL_VARIABLES;
262:
263: /* This API first looks into pa_budget_lines to see if PD/SD records for the resource assignment id
264: and txn currency code can be found. If found it returns these values (done in

Line 303: x_return_status := FND_API.G_RET_STS_SUCCESS;

299:
300: BEGIN
301:
302: x_msg_count := 0;
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305: IF p_pa_debug_mode = 'Y' THEN
306: pa_debug.set_err_stack('PA_FP_EDIT_LINE_PKG.DERIVE_PD_SD_START_END_DATES');
307: pa_debug.set_process('PLSQL','LOG',p_pa_debug_mode);

Line 407: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

403: ,x_return_status => x_return_status
404: ,x_msg_count => x_msg_count
405: ,x_msg_data => x_msg_data);
406:
407: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
408: IF P_PA_DEBUG_MODE = 'Y' THEN
409: pa_debug.g_err_stage := 'Call to get_peceding_suceeding_pd_info errored... ';
410: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
411: END IF;

Line 529: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

525: ,x_return_status => x_return_status
526: ,x_msg_count => x_msg_count
527: ,x_msg_data => x_msg_data);
528:
529: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
530: IF P_PA_DEBUG_MODE = 'Y' THEN
531: pa_debug.g_err_stage := 'calling get_period_info - FAILED...';
532: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
533: END IF;

Line 589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

585: ,x_return_status => x_return_status
586: ,x_msg_count => x_msg_count
587: ,x_msg_data => x_msg_data);
588:
589: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
590: IF P_PA_DEBUG_MODE = 'Y' THEN
591: pa_debug.g_err_stage := 'calling get_period_info - FAILED...';
592: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
593: END IF;

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

610: EXCEPTION
611:
612: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
613:
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: l_msg_count := FND_MSG_PUB.count_msg;
616:
617: IF l_msg_count = 1 THEN
618: PA_INTERFACE_UTILS_PUB.get_messages

Line 619: (p_encoded => FND_API.G_TRUE

615: l_msg_count := FND_MSG_PUB.count_msg;
616:
617: IF l_msg_count = 1 THEN
618: PA_INTERFACE_UTILS_PUB.get_messages
619: (p_encoded => FND_API.G_TRUE
620: ,p_msg_index => 1
621: ,p_msg_count => l_msg_count
622: ,p_msg_data => l_msg_data
623: ,p_data => l_data

Line 638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

634: RAISE;
635:
636: WHEN OTHERS THEN
637:
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: x_msg_count := 1;
640: x_msg_data := SQLERRM;
641: FND_MSG_PUB.add_exc_msg
642: ( p_pkg_name => 'PA_FP_EDIT_LINE_PKG'

Line 850: x_return_status := FND_API.G_RET_STS_SUCCESS;

846: l_debug_mode := NVL(l_debug_mode, 'Y');
847:
848: -- Initialize the return status to success
849: /* #2598389: Uncommented the following assignment. */
850: x_return_status := FND_API.G_RET_STS_SUCCESS;
851:
852: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
853:
854: -- Validating input parameters

Line 862: x_return_status := FND_API.G_RET_STS_ERROR;

858: IF P_PA_DEBUG_MODE = 'Y' THEN
859: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.g_err_stage,5);
860: END IF;
861:
862: x_return_status := FND_API.G_RET_STS_ERROR;
863:
864: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
865: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
866:

Line 878: x_return_status := FND_API.G_RET_STS_ERROR;

874: IF P_PA_DEBUG_MODE = 'Y' THEN
875: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.g_err_stage,5);
876: END IF;
877:
878: x_return_status := FND_API.G_RET_STS_ERROR;
879:
880: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
881: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
882:

Line 907: x_return_status := FND_API.G_RET_STS_ERROR;

903: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.g_err_stage,5);
904: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.g_err_stage,5);
905: END IF;
906:
907: x_return_status := FND_API.G_RET_STS_ERROR;
908:
909: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
910: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
911:

Line 1060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1056: ,x_return_status => l_return_status
1057: ,x_msg_count => l_msg_count
1058: ,x_msg_data => l_msg_data);
1059:
1060: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1062: END IF;
1063: END IF;
1064:

Line 1108: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1104: ,x_return_status => l_return_status
1105: ,x_msg_count => l_msg_count
1106: ,x_msg_data => l_msg_data);
1107:
1108: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1109: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1110: END IF;
1111:
1112: /* Fix for enhancement bug # 2604957 ends*/

Line 1603: x_return_status := FND_API.G_RET_STS_ERROR;

1599: pa_debug.reset_err_stack; /* Bug 2699888 */
1600:
1601: EXCEPTION
1602: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604: l_msg_count := FND_MSG_PUB.count_msg;
1605: IF l_msg_count = 1 THEN
1606: PA_INTERFACE_UTILS_PUB.get_messages
1607: (p_encoded => FND_API.G_TRUE,

Line 1607: (p_encoded => FND_API.G_TRUE,

1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604: l_msg_count := FND_MSG_PUB.count_msg;
1605: IF l_msg_count = 1 THEN
1606: PA_INTERFACE_UTILS_PUB.get_messages
1607: (p_encoded => FND_API.G_TRUE,
1608: p_msg_index => 1,
1609: p_msg_count => l_msg_count,
1610: p_msg_data => l_msg_data,
1611: p_data => l_data,

Line 1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1625:
1626: RETURN;
1627:
1628: WHEN OTHERS THEN
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: x_msg_count := 1;
1631: x_msg_data := SQLERRM;
1632: FND_MSG_PUB.add_exc_msg
1633: ( p_pkg_name => 'PA_FP_EDIT_LINE_PKG.POPULATE_ROLLUP_TMP'

Line 1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1637: pa_debug.write('POPULATE_ROLLUP_TMP: ' || l_module_name,pa_debug.G_Err_Stack,4);
1638: END IF;
1639: pa_debug.reset_err_stack;
1640:
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642:
1643: END POPULATE_ROLLUP_TMP;
1644:
1645: /* bug 2645574: Making this process more generic. Now this procedure can be used from places

Line 1709: x_return_status := FND_API.G_RET_STS_SUCCESS;

1705: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1706: l_debug_mode := NVL(l_debug_mode, 'Y');
1707:
1708: -- Initialize the return status to success
1709: x_return_status := FND_API.G_RET_STS_SUCCESS;
1710:
1711: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1712:
1713: pa_debug.g_err_stage := TO_CHAR(l_stage)||':In PA_FP_EDIT_LINE_PKG.PROCESS_MODIFIED_LINES ';

Line 1727: x_return_status := FND_API.G_RET_STS_ERROR;

1723: IF P_PA_DEBUG_MODE = 'Y' THEN
1724: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,5);
1725: END IF;
1726:
1727: x_return_status := FND_API.G_RET_STS_ERROR;
1728:
1729: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1730: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1731:

Line 1806: x_return_status := FND_API.G_RET_STS_ERROR;

1802: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Input res assmt id not found in pa_resource_assignments';
1803: IF P_PA_DEBUG_MODE = 'Y' THEN
1804: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,5);
1805: END IF;
1806: x_return_status := FND_API.G_RET_STS_ERROR;
1807: IF p_calling_context = PA_FP_CONSTANTS_PKG.G_EDIT_PLAN_LINE_PAGE THEN
1808: x_msg_data := 'PA_FP_EPL_TASK_UPDATED';
1809: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1810: ELSE

Line 1844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN /* Bug# 2644641 */

1840: ,x_return_status =>x_return_status
1841: ,x_msg_count =>x_msg_count
1842: ,x_msg_data =>x_msg_data) ;
1843:
1844: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN /* Bug# 2644641 */
1845: pa_debug.g_err_stage := 'MC Api returned error...';
1846: IF P_PA_DEBUG_MODE = 'Y' THEN
1847: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);
1848: pa_debug.g_err_stage := 'calling context : '|| p_calling_context; -- WEBADI UT

Line 2293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2289: x_msg_count => x_msg_count,
2290: x_msg_data => x_msg_data);
2291: END IF;
2292:
2293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2294: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Unexpected exception in MRC API '||sqlerrm;
2295: IF P_PA_DEBUG_MODE = 'Y' THEN
2296: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.g_err_stage,3);
2297: END IF;

Line 2324: x_return_status := FND_API.G_RET_STS_ERROR;

2320: pa_debug.reset_err_stack; /* 2641475 */
2321:
2322: EXCEPTION
2323: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2324: x_return_status := FND_API.G_RET_STS_ERROR;
2325: l_msg_count := FND_MSG_PUB.count_msg;
2326: IF l_msg_count = 1 THEN
2327: PA_INTERFACE_UTILS_PUB.get_messages
2328: (p_encoded => FND_API.G_TRUE,

Line 2328: (p_encoded => FND_API.G_TRUE,

2324: x_return_status := FND_API.G_RET_STS_ERROR;
2325: l_msg_count := FND_MSG_PUB.count_msg;
2326: IF l_msg_count = 1 THEN
2327: PA_INTERFACE_UTILS_PUB.get_messages
2328: (p_encoded => FND_API.G_TRUE,
2329: p_msg_index => 1,
2330: p_msg_count => l_msg_count,
2331: p_msg_data => l_msg_data,
2332: p_data => l_data,

Line 2365: x_return_status := FND_API.G_RET_STS_ERROR;

2361: ( x_return_status => x_return_status
2362: ,x_msg_count => x_msg_count
2363: ,x_msg_data => x_msg_data);
2364:
2365: x_return_status := FND_API.G_RET_STS_ERROR;
2366: pa_debug.reset_err_stack;
2367: RETURN;
2368:
2369: WHEN OTHERS THEN

Line 2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2366: pa_debug.reset_err_stack;
2367: RETURN;
2368:
2369: WHEN OTHERS THEN
2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2371: x_msg_count := 1;
2372: x_msg_data := SQLERRM;
2373:
2374: FND_MSG_PUB.add_exc_msg

Line 2384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2380: pa_debug.write('PROCESS_MODIFIED_LINES: ' || l_module_name,pa_debug.G_Err_Stack,4);
2381: END IF;
2382: pa_debug.reset_err_stack;
2383:
2384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2385:
2386: END PROCESS_MODIFIED_LINES;
2387:
2388: PROCEDURE GET_ELEMENT_AMOUNT_INFO

Line 2480: x_return_status := FND_API.G_RET_STS_SUCCESS;

2476: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2477: l_debug_mode := NVL(l_debug_mode, 'Y');
2478:
2479: -- Initialize the return status to success
2480: x_return_status := FND_API.G_RET_STS_SUCCESS;
2481:
2482: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2483:
2484: pa_debug.g_err_stage := TO_CHAR(l_stage)||':In PA_FP_EDIT_LINE_PKG.GET_ELEMENT_AMOUNT_INFO ';

Line 2498: x_return_status := FND_API.G_RET_STS_ERROR;

2494: IF P_PA_DEBUG_MODE = 'Y' THEN
2495: pa_debug.write('GET_ELEMENT_AMOUNT_INFO: ' || l_module_name,pa_debug.g_err_stage,5);
2496: END IF;
2497:
2498: x_return_status := FND_API.G_RET_STS_ERROR;
2499:
2500: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2501: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2502:

Line 2514: x_return_status := FND_API.G_RET_STS_ERROR;

2510: IF P_PA_DEBUG_MODE = 'Y' THEN
2511: pa_debug.write('GET_ELEMENT_AMOUNT_INFO: ' || l_module_name,pa_debug.g_err_stage,5);
2512: END IF;
2513:
2514: x_return_status := FND_API.G_RET_STS_ERROR;
2515:
2516: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2517: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2518:

Line 2543: x_return_status := FND_API.G_RET_STS_ERROR;

2539: pa_debug.write('GET_ELEMENT_AMOUNT_INFO: ' || l_module_name,pa_debug.g_err_stage,5);
2540: pa_debug.write('GET_ELEMENT_AMOUNT_INFO: ' || l_module_name,pa_debug.g_err_stage,5);
2541: END IF;
2542:
2543: x_return_status := FND_API.G_RET_STS_ERROR;
2544:
2545: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2546: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2547:

Line 2705: x_return_status := FND_API.G_RET_STS_ERROR;

2701: pa_debug.reset_err_stack; /* Bug 2699888 */
2702:
2703: EXCEPTION
2704: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2705: x_return_status := FND_API.G_RET_STS_ERROR;
2706: l_msg_count := FND_MSG_PUB.count_msg;
2707: IF l_msg_count = 1 THEN
2708: PA_INTERFACE_UTILS_PUB.get_messages
2709: (p_encoded => FND_API.G_TRUE,

Line 2709: (p_encoded => FND_API.G_TRUE,

2705: x_return_status := FND_API.G_RET_STS_ERROR;
2706: l_msg_count := FND_MSG_PUB.count_msg;
2707: IF l_msg_count = 1 THEN
2708: PA_INTERFACE_UTILS_PUB.get_messages
2709: (p_encoded => FND_API.G_TRUE,
2710: p_msg_index => 1,
2711: p_msg_count => l_msg_count,
2712: p_msg_data => l_msg_data,
2713: p_data => l_data,

Line 2729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2725: END IF;
2726: pa_debug.reset_err_stack;
2727:
2728: WHEN OTHERS THEN
2729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2730: x_msg_count := 1;
2731: x_msg_data := SQLERRM;
2732: FND_MSG_PUB.add_exc_msg
2733: ( p_pkg_name => 'PA_FP_EDIT_LINE_PKG.GET_ELEMENT_AMOUNT_INFO'

Line 2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2737: pa_debug.write('GET_ELEMENT_AMOUNT_INFO: ' || l_module_name,pa_debug.G_Err_Stack,4);
2738: END IF;
2739: pa_debug.reset_err_stack;
2740:
2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2742:
2743: END GET_ELEMENT_AMOUNT_INFO;
2744:
2745: PROCEDURE CALL_CLIENT_EXTENSIONS

Line 2786: x_return_status := FND_API.G_RET_STS_SUCCESS;

2782:
2783: BEGIN
2784:
2785: x_msg_count := 0;
2786: x_return_status := FND_API.G_RET_STS_SUCCESS;
2787: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
2788:
2789: IF l_debug_mode = 'Y' THEN
2790: pa_debug.set_curr_function( p_function => 'CALL_CLIENT_EXTENSIONS'

Line 2805: x_return_status := FND_API.G_RET_STS_ERROR;

2801: pa_debug.g_err_stage := TO_CHAR(l_stage)||':Invalid Input Parameters';
2802: pa_debug.write('CALL_CLIENT_EXTENSIONS: ' || l_module_name,pa_debug.g_err_stage,1);
2803:
2804: END IF;
2805: x_return_status := FND_API.G_RET_STS_ERROR;
2806: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2807: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2808: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2809: END IF;

Line 2862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2858: ,x_msg_data => x_msg_data
2859: ) ;
2860:
2861:
2862: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2863: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2864: END IF ;
2865:
2866: IF l_debug_mode = 'Y' THEN

Line 2874: x_return_status := FND_API.G_RET_STS_ERROR;

2870: END IF;
2871:
2872: EXCEPTION
2873: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2874: x_return_status := FND_API.G_RET_STS_ERROR;
2875: l_msg_count := FND_MSG_PUB.count_msg;
2876: IF l_debug_mode = 'Y' THEN
2877: pa_debug.g_err_stage := 'inside invalid arg exception of call_client_extensions';
2878: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);

Line 2882: (p_encoded => FND_API.G_TRUE,

2878: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
2879: END IF;
2880: IF l_msg_count = 1 THEN
2881: PA_INTERFACE_UTILS_PUB.get_messages
2882: (p_encoded => FND_API.G_TRUE,
2883: p_msg_index => 1,
2884: p_msg_count => l_msg_count,
2885: p_msg_data => l_msg_data,
2886: p_data => l_data,

Line 2898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2894: pa_debug.reset_curr_function;
2895: END IF ;
2896: RETURN;
2897: WHEN OTHERS THEN
2898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2899: x_msg_count := 1;
2900: x_msg_data := SQLERRM;
2901: FND_MSG_PUB.add_exc_msg
2902: ( p_pkg_name => 'PA_FP_LINE_EDIT_PKG'

Line 2912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2908: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
2909: pa_debug.G_Err_Stack := SQLERRM;
2910: pa_debug.reset_curr_function;
2911: END IF;
2912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2913: END CALL_CLIENT_EXTENSIONS;
2914:
2915: PROCEDURE POPULATE_ELIGIBLE_PERIODS
2916: ( p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

Line 2942: x_return_status := FND_API.G_RET_STS_SUCCESS;

2938: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2939: l_debug_mode := NVL(l_debug_mode, 'Y');
2940:
2941: -- Initialize the return status to success
2942: x_return_status := FND_API.G_RET_STS_SUCCESS;
2943:
2944: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2945:
2946: pa_debug.g_err_stage := TO_CHAR(l_stage)||':In PA_FP_EDIT_LINE_PKG.POPULATE_ELIGIBLE_PERIODS ';

Line 2956: x_return_status := FND_API.G_RET_STS_ERROR;

2952: pa_debug.g_err_stage := TO_CHAR(l_stage)||':Invalid Input Parameters';
2953: IF P_PA_DEBUG_MODE = 'Y' THEN
2954: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,1);
2955: END IF;
2956: x_return_status := FND_API.G_RET_STS_ERROR;
2957: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2958: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2959: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2960: END IF;

Line 3173: x_return_status := FND_API.G_RET_STS_ERROR;

3169:
3170: EXCEPTION
3171: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3172:
3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: l_msg_count := FND_MSG_PUB.count_msg;
3175: IF l_msg_count = 1 THEN
3176: PA_INTERFACE_UTILS_PUB.get_messages
3177: (p_encoded => FND_API.G_TRUE,

Line 3177: (p_encoded => FND_API.G_TRUE,

3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: l_msg_count := FND_MSG_PUB.count_msg;
3175: IF l_msg_count = 1 THEN
3176: PA_INTERFACE_UTILS_PUB.get_messages
3177: (p_encoded => FND_API.G_TRUE,
3178: p_msg_index => 1,
3179: p_msg_count => l_msg_count,
3180: p_msg_data => l_msg_data,
3181: p_data => l_data,

Line 3197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3193: pa_debug.reset_err_stack;
3194:
3195: RAISE;
3196: WHEN OTHERS THEN
3197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3198: x_msg_count := 1;
3199: x_msg_data := SQLERRM;
3200: FND_MSG_PUB.add_exc_msg
3201: ( p_pkg_name => 'PA_FP_EDIT_LINE_PKG.POPULATE_ELIGIBLE_PERIODS'

Line 3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3205: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.G_Err_Stack,4);
3206: END IF;
3207: pa_debug.reset_err_stack;
3208:
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210:
3211: END POPULATE_ELIGIBLE_PERIODS;
3212:
3213: /*

Line 3256: x_return_status := FND_API.G_RET_STS_SUCCESS;

3252:
3253: BEGIN
3254:
3255: x_msg_count := 0;
3256: x_return_status := FND_API.G_RET_STS_SUCCESS;
3257: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3258:
3259: pa_debug.set_curr_function( p_function => 'GET_PD_SD_AMT_IN_PC_PFC',
3260: p_debug_mode => l_debug_mode );

Line 3358: IF nvl(x_return_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS THEN

3354: EXCEPTION
3355:
3356: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3357:
3358: IF nvl(x_return_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS THEN
3359: x_return_status := FND_API.G_RET_STS_ERROR;
3360: END IF;
3361:
3362: l_msg_count := FND_MSG_PUB.count_msg;

Line 3359: x_return_status := FND_API.G_RET_STS_ERROR;

3355:
3356: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3357:
3358: IF nvl(x_return_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS THEN
3359: x_return_status := FND_API.G_RET_STS_ERROR;
3360: END IF;
3361:
3362: l_msg_count := FND_MSG_PUB.count_msg;
3363:

Line 3366: (p_encoded => FND_API.G_TRUE

3362: l_msg_count := FND_MSG_PUB.count_msg;
3363:
3364: IF l_msg_count = 1 and x_msg_data IS NULL THEN
3365: PA_INTERFACE_UTILS_PUB.get_messages
3366: (p_encoded => FND_API.G_TRUE
3367: ,p_msg_index => 1
3368: ,p_msg_count => l_msg_count
3369: ,p_msg_data => l_msg_data
3370: ,p_data => l_data

Line 3382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3378: RETURN;
3379:
3380: WHEN others THEN
3381:
3382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3383: x_msg_count := 1;
3384: x_msg_data := SQLERRM;
3385:
3386: FND_MSG_PUB.add_exc_msg

Line 3444: x_return_status := FND_API.G_RET_STS_SUCCESS;

3440:
3441: pa_debug.set_err_stack('PA_FP_EDIT_LINE_PKG.GET_PRECEDING_SUCCEEDING_AMT');
3442:
3443: -- Initialize the return status to success
3444: x_return_status := FND_API.G_RET_STS_SUCCESS;
3445:
3446: pa_debug.g_err_stage := 'In PA_FP_EDIT_LINE_PKG.GET_PRECEDING_SUCCEEDING_AMT ';
3447: IF P_PA_DEBUG_MODE = 'Y' THEN
3448: pa_debug.write('GET_PRECEDING_SUCCEEDING_AMT: ' || l_module_name,pa_debug.g_err_stage,3);

Line 3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3495: WHEN OTHERS THEN
3496: IF P_PA_DEBUG_MODE = 'Y' THEN
3497: pa_debug.write('GET_PRECEDING_SUCCEEDING_AMT: ' || l_module_name,'SQLERRM = ' || SQLERRM,5);
3498: END IF;
3499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3500: pa_debug.reset_err_stack; /* Bug 2699888 */
3501: RAISE;
3502: END GET_PRECEDING_SUCCEEDING_AMT;
3503:

Line 3548: x_return_status := FND_API.G_RET_STS_SUCCESS;

3544: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
3545:
3546: BEGIN
3547: x_msg_count := 0;
3548: x_return_status := FND_API.G_RET_STS_SUCCESS;
3549: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'Y');
3550:
3551: IF l_debug_mode = 'Y' THEN
3552: pa_debug.set_curr_function( p_function => 'CALL_CLIENT_EXTENSIONS'

Line 3567: x_return_status := FND_API.G_RET_STS_ERROR;

3563: pa_debug.g_err_stage := TO_CHAR(l_stage)||':Invalid Input Parameters';
3564: pa_debug.write('CALL_CLIENT_EXTENSIONS: ' || l_module_name,pa_debug.g_err_stage,1);
3565:
3566: END IF;
3567: x_return_status := FND_API.G_RET_STS_ERROR;
3568: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3569: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3570: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3571: END IF;

Line 3656: x_return_status := FND_API.G_RET_STS_ERROR;

3652: );
3653:
3654: IF l_err_code > 0 THEN
3655:
3656: x_return_status := FND_API.G_RET_STS_ERROR;
3657: IF l_debug_mode = 'Y' THEN
3658: pa_debug.G_Err_Stage := 'l_err_code = ' || l_err_code;
3659: pa_debug.write('CALL_CLIENT_EXTENSIONS: ' || l_module_name,pa_debug.G_Err_Stage,5);
3660: pa_debug.G_Err_Stage := 'l_err_message = ' || l_err_message;

Line 3685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3681: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
3682:
3683: END IF;
3684:
3685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3687: END IF;
3688:
3689: PA_CLIENT_EXTN_BUDGET.CALC_BURDENED_COST

Line 3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3682:
3683: END IF;
3684:
3685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3687: END IF;
3688:
3689: PA_CLIENT_EXTN_BUDGET.CALC_BURDENED_COST
3690: (x_budget_version_id => p_budget_version_id,

Line 3711: x_return_status := FND_API.G_RET_STS_ERROR;

3707:
3708:
3709: IF l_err_code > 0 THEN
3710:
3711: x_return_status := FND_API.G_RET_STS_ERROR;
3712:
3713: IF l_debug_mode = 'Y' THEN
3714: pa_debug.G_Err_Stage := 'l_err_code = ' || l_err_code;
3715: pa_debug.write('CALL_CLIENT_EXTENSIONS: ' || l_module_name,pa_debug.G_Err_Stage,5);

Line 3744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3740: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
3741:
3742: END IF;
3743:
3744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3746:
3747: END IF;
3748: END IF; -- preference code is cost only or cost and rev same

Line 3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3741:
3742: END IF;
3743:
3744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3746:
3747: END IF;
3748: END IF; -- preference code is cost only or cost and rev same
3749:

Line 3771: x_return_status := FND_API.G_RET_STS_ERROR;

3767: x_txn_currency_code => p_txn_currency_code_tbl(i)
3768: );
3769:
3770: IF l_err_code > 0 THEN
3771: x_return_status := FND_API.G_RET_STS_ERROR;
3772: IF l_debug_mode = 'Y' THEN
3773: pa_debug.G_Err_Stage := 'l_err_code = ' || l_err_code;
3774: pa_debug.write('CALL_CLIENT_EXTENSIONS: ' || l_module_name,pa_debug.G_Err_Stage,5);
3775: pa_debug.G_Err_Stage := 'l_err_message = ' || l_err_message;

Line 3798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3794: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
3795:
3796: END IF;
3797:
3798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3800:
3801: END IF;
3802: END IF;

Line 3799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3795:
3796: END IF;
3797:
3798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3800:
3801: END IF;
3802: END IF;
3803:

Line 3820: RAISE FND_API.G_EXC_ERROR;

3816: IF l_debug_mode = 'Y' THEN
3817: pa_debug.g_err_stage := 'inside expected error occured';
3818: pa_debug.write('CALL_CLIENT_EXTENSIONS: ' || l_module_name,pa_debug.g_err_stage,5);
3819: END IF;
3820: RAISE FND_API.G_EXC_ERROR;
3821: END IF;
3822:
3823: IF l_debug_mode = 'Y' THEN
3824: pa_debug.g_err_stage := TO_CHAR(l_stage)||'leaving client extension ';

Line 3830: WHEN FND_API.G_EXC_ERROR OR PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3826: pa_debug.reset_curr_function;
3827: END IF;
3828:
3829: EXCEPTION
3830: WHEN FND_API.G_EXC_ERROR OR PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3831:
3832: ROLLBACK to call_client_extns;
3833: x_return_status := FND_API.G_RET_STS_ERROR;
3834: l_msg_count := FND_MSG_PUB.count_msg;

Line 3833: x_return_status := FND_API.G_RET_STS_ERROR;

3829: EXCEPTION
3830: WHEN FND_API.G_EXC_ERROR OR PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3831:
3832: ROLLBACK to call_client_extns;
3833: x_return_status := FND_API.G_RET_STS_ERROR;
3834: l_msg_count := FND_MSG_PUB.count_msg;
3835: IF l_debug_mode = 'Y' THEN
3836: pa_debug.g_err_stage := 'inside invalid arg exception of process_xface_lines';
3837: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);

Line 3841: (p_encoded => FND_API.G_TRUE,

3837: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
3838: END IF;
3839: IF l_msg_count = 1 THEN
3840: PA_INTERFACE_UTILS_PUB.get_messages
3841: (p_encoded => FND_API.G_TRUE,
3842: p_msg_index => 1,
3843: p_msg_count => l_msg_count,
3844: p_msg_data => l_msg_data,
3845: p_data => l_data,

Line 3859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3855: RETURN;
3856: WHEN OTHERS THEN
3857:
3858: ROLLBACK to call_client_extns;
3859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3860: x_msg_count := 1;
3861: x_msg_data := SQLERRM;
3862: FND_MSG_PUB.add_exc_msg
3863: ( p_pkg_name => 'PA_FP_EDIT_LINE_PKG'

Line 3873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3869: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
3870: pa_debug.G_Err_Stack := SQLERRM;
3871: pa_debug.reset_curr_function;
3872: END IF;
3873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3874: END CALL_CLIENT_EXTENSIONS ;
3875:
3876: -- This procedure finds out the all the records in pa_fp_rollup_tmp with same
3877: -- budget start date, txn currency code and resource assignment. This

Line 3923: x_return_status := FND_API.G_RET_STS_SUCCESS;

3919: l_count NUMBER;
3920:
3921: BEGIN
3922: x_msg_count := 0;
3923: x_return_status := FND_API.G_RET_STS_SUCCESS;
3924: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3925:
3926: pa_debug.set_curr_function( p_function => 'Find_dup_rows_in_rollup_tmp',
3927: p_debug_mode => l_debug_mode );

Line 3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3941: pa_debug.g_err_stage:= 'The Cursor l_res_assignment_details_csr did not return rows';
3942: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3943: END IF;
3944: CLOSE l_res_assignment_details_csr;
3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3946: END IF;
3947: CLOSE l_res_assignment_details_csr;
3948: /* bug 3326976 Included substrb */
3949: l_task_number := substrb((pa_interface_utils_pub.get_task_number_amg

Line 4023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4019: pa_debug.reset_curr_function;
4020:
4021: EXCEPTION
4022: WHEN OTHERS THEN
4023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4024: x_msg_count := 1;
4025: x_msg_data := SQLERRM;
4026:
4027: FND_MSG_PUB.add_exc_msg

Line 4072: x_return_status := FND_API.G_RET_STS_SUCCESS;

4068:
4069: BEGIN
4070:
4071: x_msg_count := 0;
4072: x_return_status := FND_API.G_RET_STS_SUCCESS;
4073: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4074:
4075: pa_debug.set_curr_function( p_function => 'PROCESS_BDGTLINES_FOR_VERSION',
4076: p_debug_mode => l_debug_mode );

Line 4108: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4104: ,x_return_status => x_return_status
4105: ,x_msg_count => x_msg_count
4106: ,x_msg_data => x_msg_data);
4107:
4108: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4109: IF P_PA_DEBUG_MODE = 'Y' THEN
4110: pa_debug.g_err_stage := 'Call to PA_FP_MULTI_CURRENCY_PKG.CONVERT_TXN_CURRENCY errored... ';
4111: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
4112: END IF;

Line 4148: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4144: x_msg_count => x_msg_count,
4145: x_msg_data => x_msg_data);
4146: END IF;
4147:
4148: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4149: IF P_PA_DEBUG_MODE = 'Y' THEN
4150: pa_debug.g_err_stage := 'Unexpected exception in checking MRC Install '||sqlerrm;
4151: pa_debug.write('PROCESS_BDGTLINES_FOR_VERSION: ' || l_module_name,pa_debug.g_err_stage,l_debug_level5);
4152: END IF;

Line 4167: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4163: x_msg_count => x_msg_count,
4164: x_msg_data => x_msg_data);
4165: END IF;
4166:
4167: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4168: IF P_PA_DEBUG_MODE = 'Y' THEN
4169: pa_debug.g_err_stage := 'Unexpected exception in MRC API '||sqlerrm;
4170: pa_debug.write('PROCESS_BDGTLINES_FOR_VERSION: ' || l_module_name,pa_debug.g_err_stage,l_debug_level5);
4171: END IF;

Line 4190: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4186: ,x_msg_count => x_msg_count
4187: ,x_msg_data => x_msg_data ) ;
4188:
4189:
4190: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4191: IF P_PA_DEBUG_MODE = 'Y' THEN
4192: pa_debug.g_err_stage := 'Call to PA_FP_ROLLUP_PKG errored... ';
4193: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
4194: END IF;

Line 4209: x_return_status := FND_API.G_RET_STS_ERROR;

4205: EXCEPTION
4206:
4207: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4208:
4209: x_return_status := FND_API.G_RET_STS_ERROR;
4210: l_msg_count := FND_MSG_PUB.count_msg;
4211:
4212: IF l_msg_count = 1 and x_msg_data IS NULL THEN
4213: PA_INTERFACE_UTILS_PUB.get_messages

Line 4214: (p_encoded => FND_API.G_TRUE

4210: l_msg_count := FND_MSG_PUB.count_msg;
4211:
4212: IF l_msg_count = 1 and x_msg_data IS NULL THEN
4213: PA_INTERFACE_UTILS_PUB.get_messages
4214: (p_encoded => FND_API.G_TRUE
4215: ,p_msg_index => 1
4216: ,p_msg_count => l_msg_count
4217: ,p_msg_data => l_msg_data
4218: ,p_data => l_data

Line 4230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4226: RETURN;
4227:
4228: WHEN others THEN
4229:
4230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4231: x_msg_count := 1;
4232: x_msg_data := SQLERRM;
4233:
4234: FND_MSG_PUB.add_exc_msg