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 260: x_return_status := FND_API.G_RET_STS_ERROR;

256: /* Checking error condition. Added for bug 2218386 */
257: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
258: PA_UTILS.add_message('PA', 'PA_FCST_EXP_CURR_CODE_NULL');
259: END IF;
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: x_msg_count := 1;
262: x_msg_data := 'PA_FCST_EXP_CURR_CODE_NULL';
263:
264: WHEN NO_DATA_FOUND THEN

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: /* Checking error condition. Added for bug 2218386 */
268: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
269: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
270: END IF;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: x_msg_count := 1;
273: x_msg_data := 'PA_FCST_NO_COST_RATE';
274:
275: WHEN l_raw_cost_null THEN

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278: /* Checking error condition. Added for bug 2218386 */
279: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
280: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
281: END IF;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: x_msg_count := 1;
284: x_msg_data := 'PA_FCST_NO_COST_RATE';
285:
286: /*LCE changes*/

Line 291: x_return_status := FND_API.G_RET_STS_ERROR;

287: WHEN user_exception THEN
288: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
289: PA_UTILS.add_message('PA',l_err_code);
290: END IF;
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: x_msg_count := 1;
293: x_msg_data := l_err_code;
294: /*End of LCE changes*/
295:

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

293: x_msg_data := l_err_code;
294: /*End of LCE changes*/
295:
296: WHEN OTHERS THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: x_msg_count := 1;
299: x_msg_data := SUBSTR(SQLERRM,1,30);
300: /* Checking error condition. Added for bug 2218386 */
301: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN

Line 334: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

330: --------------------------------------------
331: -- Initialize the successfull return status
332: --------------------------------------------
333:
334: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
335:
336:
337:
338: l_x_override_to_org_id := NULL;

Line 483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

479:
480:
481: EXCEPTION
482: WHEN OTHERS THEN
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: x_msg_count := 1;
485: x_msg_data := SUBSTR(SQLERRM,1,30);
486: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
487: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */

Line 555: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

551: ']expFuncurr['||px_exp_func_curr_code||']IncOrgId['||p_Incurred_by_organz_id||
552: ']Rawcost['||p_raw_cost||']CostRate['||p_raw_cost_rate||']Qty['||p_quantity||
553: ']OverrideOrgId['||p_override_to_organz_id||']');
554:
555: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
556:
557:
558: ---------------------------------------------------------------------------------------
559: -- Assign Input Raw cost into local variables anc check if input raw cost i null or not

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

625: );
626: print_msg('After get_schedule_id['||l_x_burden_sch_revision_id||']date['||l_x_burden_sch_fixed_date||']');
627:
628:
629: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
630:
631: RAISE l_invalid_schedule_id;
632:
633: END IF;

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

769: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
770: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
771: END IF;
772:
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: x_msg_count := 1;
775: x_msg_data := 'PA_FCST_NO_COST_RATE';
776:
777: WHEN l_done_burden_cost_calc THEN

Line 778: x_return_status := FND_API.G_RET_STS_SUCCESS;

774: x_msg_count := 1;
775: x_msg_data := 'PA_FCST_NO_COST_RATE';
776:
777: WHEN l_done_burden_cost_calc THEN
778: x_return_status := FND_API.G_RET_STS_SUCCESS;
779: x_msg_count := NULL;
780: x_msg_data := NULL;
781:
782: WHEN l_cost_plus_struture_not_found THEN

Line 789: x_return_status := FND_API.G_RET_STS_ERROR;

785: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
786: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_PLUS_ST');
787: END IF;
788:
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: x_msg_count := 1;
791: x_msg_data := 'PA_FCST_NO_COST_PLUS_ST';
792:
793: WHEN l_cost_base_not_found THEN

Line 800: x_return_status := FND_API.G_RET_STS_ERROR;

796: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
797: PA_UTILS.add_message('PA', 'PA_FCST_COST_BASE_NOT_FOUND');
798: END IF;
799:
800: x_return_status := FND_API.G_RET_STS_ERROR;
801: x_msg_count := 1;
802: x_msg_data := 'PA_FCST_COST_BASE_NOT_FOUND';
803:
804: WHEN l_comp_multiplier_not_found THEN

Line 811: x_return_status := FND_API.G_RET_STS_ERROR;

807: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
808: PA_UTILS.add_message('PA', 'PA_FCST_NO_COMPILED_MULTI');
809: END IF;
810:
811: x_return_status := FND_API.G_RET_STS_ERROR;
812: x_msg_count := 1;
813: x_msg_data := 'PA_FCST_NO_COMPILED_MULTI';
814:
815: WHEN l_invalid_schedule_id 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_INVL_BURDEN_SCH_REV_ID');
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_INVL_BURDEN_SCH_REV_ID';
825:
826: WHEN l_burden_cost_null THEN

Line 835: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

836: x_msg_count := 1;
837: x_msg_data := 'PA_FCST_NO_COST_RATE';
838:
839: WHEN OTHERS THEN
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: x_msg_count := 1;
842: x_msg_data := SUBSTR(SQLERRM,1,30);
843: print_msg('Others Exception:l_x_stage['||l_x_stage||']'||SQLERRM||SQLCODE);
844: /* Checking error condition. Added for bug 2218386 */

Line 949: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

945: --------------------------------------------
946: -- Initialize the successfull return status
947: --------------------------------------------
948:
949: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
950:
951:
952:
953: ---------------------------------------------

Line 1397: x_return_status := FND_API.G_RET_STS_ERROR;

1393:
1394:
1395: EXCEPTION
1396: /* WHEN l_conversion_fail THEN Added for bug 2238712
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: x_msg_count := 1;
1399: x_msg_data := SUBSTR(l_status,1,30);
1400: x_projfunc_burden_cost := 0;
1401: x_projfunc_burden_cost_rate := 0;

Line 1414: x_return_status := FND_API.G_RET_STS_ERROR;

1410: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1411: PA_UTILS.add_message('PA', 'PA_FCST_PROJ_CURR_CODE_NULL');
1412: END IF;
1413:
1414: x_return_status := FND_API.G_RET_STS_ERROR;
1415: x_msg_count := 1;
1416: x_msg_data := 'PA_FCST_PROJ_CURR_CODE_NULL';
1417:
1418: WHEN l_exp_func_curr_code_null THEN

Line 1424: x_return_status := FND_API.G_RET_STS_ERROR;

1420: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1421: PA_UTILS.add_message('PA', 'PA_FCST_EXP_CURR_CODE_NULL');
1422: END IF;
1423:
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: x_msg_count := 1;
1426: x_msg_data := 'PA_FCST_EXP_CURR_CODE_NULL';
1427:
1428: WHEN l_invalid_rate_date_type THEN

Line 1434: x_return_status := FND_API.G_RET_STS_ERROR;

1430: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1431: PA_UTILS.add_message('PA', 'PA_FCST_INVL_RATE_DT_TYP');
1432: END IF;
1433:
1434: x_return_status := FND_API.G_RET_STS_ERROR;
1435: x_msg_count := 1;
1436: x_msg_data := 'PA_FCST_INVL_RATE_DT_TYP';
1437:
1438: WHEN l_raw_cost_null THEN

Line 1461: x_return_status := FND_API.G_RET_STS_ERROR;

1457: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1458: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
1459: END IF;
1460:
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: x_msg_count := 1;
1463: x_msg_data := 'PA_FCST_NO_COST_RATE';
1464:
1465: WHEN l_burden_cost_null THEN

Line 1488: x_return_status := FND_API.G_RET_STS_ERROR;

1484: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1485: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
1486: END IF;
1487:
1488: x_return_status := FND_API.G_RET_STS_ERROR;
1489: x_msg_count := 1;
1490: x_msg_data := 'PA_FCST_NO_COST_RATE';
1491:
1492: WHEN l_multi_conversion_fail THEN

Line 1514: x_return_status := FND_API.G_RET_STS_ERROR;

1510: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1511: PA_UTILS.add_message('PA', l_multi_status);
1512: END IF;
1513:
1514: x_return_status := FND_API.G_RET_STS_ERROR;
1515: x_msg_count := 1;
1516: x_msg_data := l_multi_status;
1517:
1518: WHEN OTHERS THEN

Line 1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1515: x_msg_count := 1;
1516: x_msg_data := l_multi_status;
1517:
1518: WHEN OTHERS THEN
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: x_msg_count := 1;
1521: x_msg_data := SUBSTR(SQLERRM,1,30);
1522: /* Checking error condition. Added for bug 2218386 */
1523: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN

Line 1640: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

1636: --------------------------------------------
1637: -- Initialize the successfull return status
1638: --------------------------------------------
1639:
1640: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1641:
1642:
1643:
1644: l_burden_sch_id := NULL;

Line 1959: x_return_status := FND_API.G_RET_STS_ERROR;

1955: /* Checking error condition. Added for bug 2218386 */
1956: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1957: PA_UTILS.add_message('PA', 'PA_FCST_INVL_BURDEN_SCH_REV_ID');
1958: END IF;
1959: x_return_status := FND_API.G_RET_STS_ERROR;
1960: x_msg_count := 1;
1961: x_msg_data := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
1962:
1963: WHEN l_sch_rev_id_found THEN

Line 1964: x_return_status := FND_API.G_RET_STS_SUCCESS;

1960: x_msg_count := 1;
1961: x_msg_data := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
1962:
1963: WHEN l_sch_rev_id_found THEN
1964: x_return_status := FND_API.G_RET_STS_SUCCESS;
1965: x_msg_count := NULL;
1966: x_msg_data := NULL;
1967:
1968: WHEN l_sch_rev_id_not_found THEN

Line 1973: x_return_status := FND_API.G_RET_STS_ERROR;

1969: /* Checking error condition. Added for bug 2218386 */
1970: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1971: PA_UTILS.add_message('PA', 'PA_FCST_INVL_BURDEN_SCH_REV_ID');
1972: END IF;
1973: x_return_status := FND_API.G_RET_STS_ERROR;
1974: x_msg_count := 1;
1975: x_msg_data := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
1976:
1977: WHEN OTHERS THEN

Line 1978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1974: x_msg_count := 1;
1975: x_msg_data := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
1976:
1977: WHEN OTHERS THEN
1978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1979: x_msg_count := 1;
1980: x_msg_data := SUBSTR(SQLERRM,1,30);
1981: /* Checking error condition. Added for bug 2218386 */
1982: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN

Line 2084: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

2080: --------------------------------------------
2081: -- Initialize the successfull return status
2082: --------------------------------------------
2083:
2084: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
2085:
2086:
2087: ---------------------------------------
2088: -- Get the Project Cost Job Id from API.

Line 2289: x_return_status := FND_API.G_RET_STS_ERROR;

2285: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2286: PA_UTILS.add_message('PA', l_status||'_BC_PF'); /* fix for bug 2199203 */
2287: END IF;
2288:
2289: x_return_status := FND_API.G_RET_STS_ERROR;
2290: x_msg_count := 1;
2291: x_msg_data := l_status||'_BC_PF'; /* fix for bug 2199203 */
2292: PA_DEBUG.reset_err_stack;
2293: WHEN NO_DATA_FOUND THEN

Line 2302: x_return_status := FND_API.G_RET_STS_ERROR;

2298: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2299: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
2300: END IF;
2301:
2302: x_return_status := FND_API.G_RET_STS_ERROR;
2303: x_msg_count := 1;
2304: x_msg_data := 'PA_FCST_NO_COST_RATE';
2305: PA_DEBUG.reset_err_stack;
2306: WHEN l_raw_cost_null THEN

Line 2315: x_return_status := FND_API.G_RET_STS_ERROR;

2311: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2312: PA_UTILS.add_message('PA', 'PA_FCST_NO_COST_RATE');
2313: END IF;
2314:
2315: x_return_status := FND_API.G_RET_STS_ERROR;
2316: x_msg_count := 1;
2317: x_msg_data := 'PA_FCST_NO_COST_RATE';
2318: PA_DEBUG.reset_err_stack;
2319:

Line 2325: x_return_status := FND_API.G_RET_STS_ERROR;

2321: WHEN user_exception THEN
2322: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2323: PA_UTILS.add_message('PA',l_err_code);
2324: END IF;
2325: x_return_status := FND_API.G_RET_STS_ERROR;
2326: x_msg_count := 1;
2327: x_msg_data := l_err_code;
2328: PA_DEBUG.reset_err_stack;
2329:

Line 2335: x_return_status := FND_API.G_RET_STS_ERROR;

2331: /* Checking error condition. Added for bug 2218386 */
2332: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2333: PA_UTILS.add_message('PA', 'PA_FCST_EXP_CURR_CODE_NULL');
2334: END IF;
2335: x_return_status := FND_API.G_RET_STS_ERROR;
2336: x_msg_count := 1;
2337: x_msg_data := 'PA_FCST_EXP_CURR_CODE_NULL';
2338: PA_DEBUG.reset_err_stack;
2339: /*LCE changes*/

Line 2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2338: PA_DEBUG.reset_err_stack;
2339: /*LCE changes*/
2340:
2341: WHEN OTHERS THEN
2342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2343: x_msg_count := 1;
2344: x_msg_data := SUBSTR(SQLERRM,1,30);
2345: /* Checking error condition. Added for bug 2218386 */
2346: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN