DBA Data[Home] [Help]

APPS.PA_COST dependencies on FND_API

Line 85: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

81: --------------------------------------------
82: -- Initialize the successfull return status
83: --------------------------------------------
84:
85: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: /*****Commented for LCE Changes
88:
89: -----------------------------------------------------------

Line 277: x_return_status := FND_API.G_RET_STS_ERROR;

273: /* Checking error condition. Added for bug 2218386 */
274: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
275: PA_UTILS.add_message('PA', 'PA_FCST_EXP_CURR_CODE_NULL');
276: END IF;
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: x_msg_count := 1;
279: x_msg_data := 'PA_FCST_EXP_CURR_CODE_NULL';
280:
281: WHEN NO_DATA_FOUND THEN

Line 290: x_return_status := FND_API.G_RET_STS_ERROR;

286: /* Checking error condition. Added for bug 2218386 */
287: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
288: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
289: END IF;
290: x_return_status := FND_API.G_RET_STS_ERROR;
291: x_msg_count := 1;
292: x_msg_data := 'PA_FCST_NO_COST_RATE';
293:
294: WHEN l_raw_cost_null THEN

Line 303: x_return_status := FND_API.G_RET_STS_ERROR;

299: /* Checking error condition. Added for bug 2218386 */
300: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
301: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
302: END IF;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: x_msg_count := 1;
305: x_msg_data := 'PA_FCST_NO_COST_RATE';
306:
307: /*LCE changes*/

Line 314: x_return_status := FND_API.G_RET_STS_ERROR;

310:
311: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
312: PA_UTILS.add_message('PA',l_err_code);
313: END IF;
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: x_msg_count := 1;
316: x_msg_data := l_err_code;
317: /*End of LCE changes*/
318:

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

318:
319: WHEN OTHERS THEN
320: pa_cc_utils.log_message('inside others exception '||SUBSTR(SQLERRM,1,300));
321:
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: x_msg_count := 1;
324: x_msg_data := SUBSTR(SQLERRM,1,30);
325: /* Checking error condition. Added for bug 2218386 */
326: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN

Line 359: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

355: --------------------------------------------
356: -- Initialize the successfull return status
357: --------------------------------------------
358:
359: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
360:
361:
362:
363: l_x_override_to_org_id := NULL;

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

504:
505:
506: EXCEPTION
507: WHEN OTHERS THEN
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: x_msg_count := 1;
510: x_msg_data := SUBSTR(SQLERRM,1,30);
511: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
512: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */

Line 580: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

576: ']expFuncurr['||px_exp_func_curr_code||']IncOrgId['||p_Incurred_by_organz_id||
577: ']Rawcost['||p_raw_cost||']CostRate['||p_raw_cost_rate||']Qty['||p_quantity||
578: ']OverrideOrgId['||p_override_to_organz_id||']');
579:
580: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
581:
582:
583: ---------------------------------------------------------------------------------------
584: -- Assign Input Raw cost into local variables anc check if input raw cost i null or not

Line 662: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

658: );
659: print_msg('After get_schedule_id['||l_x_burden_sch_revision_id||']date['||l_x_burden_sch_fixed_date||']');
660:
661:
662: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
663:
664: RAISE l_invalid_schedule_id;
665:
666: END IF;

Line 806: x_return_status := FND_API.G_RET_STS_ERROR;

802: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
803: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
804: END IF;
805:
806: x_return_status := FND_API.G_RET_STS_ERROR;
807: x_msg_count := 1;
808: x_msg_data := 'PA_FCST_NO_COST_RATE';
809:
810: WHEN l_done_burden_cost_calc THEN

Line 811: x_return_status := FND_API.G_RET_STS_SUCCESS;

807: x_msg_count := 1;
808: x_msg_data := 'PA_FCST_NO_COST_RATE';
809:
810: WHEN l_done_burden_cost_calc THEN
811: x_return_status := FND_API.G_RET_STS_SUCCESS;
812: x_msg_count := NULL;
813: x_msg_data := NULL;
814:
815: WHEN l_cost_plus_struture_not_found THEN

Line 822: x_return_status := FND_API.G_RET_STS_ERROR;

818: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
819: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_PLUS_ST');
820: END IF;
821:
822: x_return_status := FND_API.G_RET_STS_ERROR;
823: x_msg_count := 1;
824: x_msg_data := 'PA_FCST_NO_COST_PLUS_ST';
825:
826: WHEN l_cost_base_not_found THEN

Line 833: x_return_status := FND_API.G_RET_STS_ERROR;

829: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
830: PA_UTILS.add_message('PA', 'PA_FCST_COST_BASE_NOT_FOUND');
831: END IF;
832:
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: x_msg_count := 1;
835: x_msg_data := 'PA_FCST_COST_BASE_NOT_FOUND';
836:
837: WHEN l_comp_multiplier_not_found THEN

Line 844: x_return_status := FND_API.G_RET_STS_ERROR;

840: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
841: PA_UTILS.add_message('PA', 'PA_FCST_NO_COMPILED_MULTI');
842: END IF;
843:
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: x_msg_count := 1;
846: x_msg_data := 'PA_FCST_NO_COMPILED_MULTI';
847:
848: WHEN l_invalid_schedule_id THEN

Line 855: x_return_status := FND_API.G_RET_STS_ERROR;

851: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
852: PA_UTILS.add_message('PA', 'PA_FCST_INVL_BURDEN_SCH_REV_ID');
853: END IF;
854:
855: x_return_status := FND_API.G_RET_STS_ERROR;
856: x_msg_count := 1;
857: x_msg_data := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
858:
859: WHEN l_burden_cost_null THEN

Line 868: x_return_status := FND_API.G_RET_STS_ERROR;

864: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
865: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
866: END IF;
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: x_msg_count := 1;
870: x_msg_data := 'PA_FCST_NO_COST_RATE';
871:
872: WHEN OTHERS THEN

Line 873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

869: x_msg_count := 1;
870: x_msg_data := 'PA_FCST_NO_COST_RATE';
871:
872: WHEN OTHERS THEN
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: x_msg_count := 1;
875: x_msg_data := SUBSTR(SQLERRM,1,30);
876: print_msg('Others Exception:l_x_stage['||l_x_stage||']'||SQLERRM||SQLCODE);
877: /* Checking error condition. Added for bug 2218386 */

Line 982: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

978: --------------------------------------------
979: -- Initialize the successfull return status
980: --------------------------------------------
981:
982: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
983:
984:
985:
986: ---------------------------------------------

Line 1430: x_return_status := FND_API.G_RET_STS_ERROR;

1426:
1427:
1428: EXCEPTION
1429: /* WHEN l_conversion_fail THEN Added for bug 2238712
1430: x_return_status := FND_API.G_RET_STS_ERROR;
1431: x_msg_count := 1;
1432: x_msg_data := SUBSTR(l_status,1,30);
1433: x_projfunc_burden_cost := 0;
1434: x_projfunc_burden_cost_rate := 0;

Line 1447: x_return_status := FND_API.G_RET_STS_ERROR;

1443: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1444: PA_UTILS.add_message('PA', 'PA_FCST_PROJ_CURR_CODE_NULL');
1445: END IF;
1446:
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: x_msg_count := 1;
1449: x_msg_data := 'PA_FCST_PROJ_CURR_CODE_NULL';
1450:
1451: WHEN l_exp_func_curr_code_null THEN

Line 1457: x_return_status := FND_API.G_RET_STS_ERROR;

1453: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1454: PA_UTILS.add_message('PA', 'PA_FCST_EXP_CURR_CODE_NULL');
1455: END IF;
1456:
1457: x_return_status := FND_API.G_RET_STS_ERROR;
1458: x_msg_count := 1;
1459: x_msg_data := 'PA_FCST_EXP_CURR_CODE_NULL';
1460:
1461: WHEN l_invalid_rate_date_type THEN

Line 1467: x_return_status := FND_API.G_RET_STS_ERROR;

1463: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1464: PA_UTILS.add_message('PA', 'PA_FCST_INVL_RATE_DT_TYP');
1465: END IF;
1466:
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: x_msg_count := 1;
1469: x_msg_data := 'PA_FCST_INVL_RATE_DT_TYP';
1470:
1471: WHEN l_raw_cost_null THEN

Line 1494: x_return_status := FND_API.G_RET_STS_ERROR;

1490: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1491: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
1492: END IF;
1493:
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: x_msg_count := 1;
1496: x_msg_data := 'PA_FCST_NO_COST_RATE';
1497:
1498: WHEN l_burden_cost_null THEN

Line 1521: x_return_status := FND_API.G_RET_STS_ERROR;

1517: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1518: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
1519: END IF;
1520:
1521: x_return_status := FND_API.G_RET_STS_ERROR;
1522: x_msg_count := 1;
1523: x_msg_data := 'PA_FCST_NO_COST_RATE';
1524:
1525: WHEN l_multi_conversion_fail THEN

Line 1547: x_return_status := FND_API.G_RET_STS_ERROR;

1543: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1544: PA_UTILS.add_message('PA', l_multi_status);
1545: END IF;
1546:
1547: x_return_status := FND_API.G_RET_STS_ERROR;
1548: x_msg_count := 1;
1549: x_msg_data := l_multi_status;
1550:
1551: WHEN OTHERS THEN

Line 1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1548: x_msg_count := 1;
1549: x_msg_data := l_multi_status;
1550:
1551: WHEN OTHERS THEN
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: x_msg_count := 1;
1554: x_msg_data := SUBSTR(SQLERRM,1,30);
1555: /* Checking error condition. Added for bug 2218386 */
1556: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN

Line 1673: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

1669: --------------------------------------------
1670: -- Initialize the successfull return status
1671: --------------------------------------------
1672:
1673: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1674:
1675:
1676:
1677: l_burden_sch_id := NULL;

Line 1992: x_return_status := FND_API.G_RET_STS_ERROR;

1988: /* Checking error condition. Added for bug 2218386 */
1989: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1990: PA_UTILS.add_message('PA', 'PA_FCST_INVL_BURDEN_SCH_REV_ID');
1991: END IF;
1992: x_return_status := FND_API.G_RET_STS_ERROR;
1993: x_msg_count := 1;
1994: x_msg_data := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
1995:
1996: WHEN l_sch_rev_id_found THEN

Line 1997: x_return_status := FND_API.G_RET_STS_SUCCESS;

1993: x_msg_count := 1;
1994: x_msg_data := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
1995:
1996: WHEN l_sch_rev_id_found THEN
1997: x_return_status := FND_API.G_RET_STS_SUCCESS;
1998: x_msg_count := NULL;
1999: x_msg_data := NULL;
2000:
2001: WHEN l_sch_rev_id_not_found THEN

Line 2006: x_return_status := FND_API.G_RET_STS_ERROR;

2002: /* Checking error condition. Added for bug 2218386 */
2003: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2004: PA_UTILS.add_message('PA', 'PA_FCST_INVL_BURDEN_SCH_REV_ID');
2005: END IF;
2006: x_return_status := FND_API.G_RET_STS_ERROR;
2007: x_msg_count := 1;
2008: x_msg_data := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
2009:
2010: WHEN OTHERS THEN

Line 2011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2007: x_msg_count := 1;
2008: x_msg_data := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
2009:
2010: WHEN OTHERS THEN
2011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2012: x_msg_count := 1;
2013: x_msg_data := SUBSTR(SQLERRM,1,30);
2014: /* Checking error condition. Added for bug 2218386 */
2015: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN

Line 2117: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

2113: --------------------------------------------
2114: -- Initialize the successfull return status
2115: --------------------------------------------
2116:
2117: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
2118:
2119:
2120: ---------------------------------------
2121: -- Get the Project Cost Job Id from API.

Line 2322: x_return_status := FND_API.G_RET_STS_ERROR;

2318: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2319: PA_UTILS.add_message('PA', l_status||'_BC_PF'); /* fix for bug 2199203 */
2320: END IF;
2321:
2322: x_return_status := FND_API.G_RET_STS_ERROR;
2323: x_msg_count := 1;
2324: x_msg_data := l_status||'_BC_PF'; /* fix for bug 2199203 */
2325: PA_DEBUG.reset_err_stack;
2326: WHEN NO_DATA_FOUND THEN

Line 2335: x_return_status := FND_API.G_RET_STS_ERROR;

2331: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2332: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
2333: END IF;
2334:
2335: x_return_status := FND_API.G_RET_STS_ERROR;
2336: x_msg_count := 1;
2337: x_msg_data := 'PA_FCST_NO_COST_RATE';
2338: PA_DEBUG.reset_err_stack;
2339: WHEN l_raw_cost_null THEN

Line 2348: x_return_status := FND_API.G_RET_STS_ERROR;

2344: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2345: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
2346: END IF;
2347:
2348: x_return_status := FND_API.G_RET_STS_ERROR;
2349: x_msg_count := 1;
2350: x_msg_data := 'PA_FCST_NO_COST_RATE';
2351: PA_DEBUG.reset_err_stack;
2352:

Line 2358: x_return_status := FND_API.G_RET_STS_ERROR;

2354: WHEN user_exception THEN
2355: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2356: PA_UTILS.add_message('PA',l_err_code);
2357: END IF;
2358: x_return_status := FND_API.G_RET_STS_ERROR;
2359: x_msg_count := 1;
2360: x_msg_data := l_err_code;
2361: PA_DEBUG.reset_err_stack;
2362:

Line 2368: x_return_status := FND_API.G_RET_STS_ERROR;

2364: /* Checking error condition. Added for bug 2218386 */
2365: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2366: PA_UTILS.add_message('PA', 'PA_FCST_EXP_CURR_CODE_NULL');
2367: END IF;
2368: x_return_status := FND_API.G_RET_STS_ERROR;
2369: x_msg_count := 1;
2370: x_msg_data := 'PA_FCST_EXP_CURR_CODE_NULL';
2371: PA_DEBUG.reset_err_stack;
2372: /*LCE changes*/

Line 2375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2371: PA_DEBUG.reset_err_stack;
2372: /*LCE changes*/
2373:
2374: WHEN OTHERS THEN
2375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2376: x_msg_count := 1;
2377: x_msg_data := SUBSTR(SQLERRM,1,30);
2378: /* Checking error condition. Added for bug 2218386 */
2379: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN