DBA Data[Home] [Help]

APPS.PA_FORECAST_COST dependencies on FND_API

Line 47: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

43: --------------------------------------------
44: -- Initialize the successfull return status
45: --------------------------------------------
46:
47: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
48:
49:
50:
51: -----------------------------------------------------------

Line 153: x_return_status := FND_API.G_RET_STS_ERROR;

149:
150: EXCEPTION
151: WHEN l_exp_func_curr_code_null THEN
152: PA_UTILS.add_message('PA', 'PA_EXP_FUNC_CURR_CODE_NULL');
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: x_msg_count := 1;
155: x_msg_data := 'PA_EXP_FUNC_CURR_CODE_NULL';
156:
157: WHEN NO_DATA_FOUND THEN

Line 159: x_return_status := FND_API.G_RET_STS_ERROR;

155: x_msg_data := 'PA_EXP_FUNC_CURR_CODE_NULL';
156:
157: WHEN NO_DATA_FOUND THEN
158: PA_UTILS.add_message('PA', 'PA_NO_LABOR_COST_RATE');
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: x_msg_count := 1;
161: x_msg_data := 'PA_NO_LABOR_COST_RATE';
162:
163: WHEN l_raw_cost_null THEN

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161: x_msg_data := 'PA_NO_LABOR_COST_RATE';
162:
163: WHEN l_raw_cost_null THEN
164: PA_UTILS.add_message('PA', 'PA_RAW_COST_NULL');
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: x_msg_count := 1;
167: x_msg_data := 'PA_RAW_COST_NULL';
168:
169: WHEN OTHERS THEN

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

166: x_msg_count := 1;
167: x_msg_data := 'PA_RAW_COST_NULL';
168:
169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: x_msg_count := 1;
172: x_msg_data := SQLERRM;
173:
174: /* ATG Changes */

Line 210: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

206: --------------------------------------------
207: -- Initialize the successfull return status
208: --------------------------------------------
209:
210: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
211:
212:
213:
214: l_x_override_to_org_id := NULL;

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

356:
357: EXCEPTION
358: WHEN l_override_organz_id_null THEN
359: PA_UTILS.add_message('PA', 'PA_OVERRIDE_TO_ORGANZ_ID_NULL');
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: x_msg_count := 1;
362: x_msg_data := 'PA_OVERRIDE_TO_ORGANZ_ID_NULL';
363:
364: WHEN OTHERS THEN

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

361: x_msg_count := 1;
362: x_msg_data := 'PA_OVERRIDE_TO_ORGANZ_ID_NULL';
363:
364: WHEN OTHERS THEN
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: x_msg_count := 1;
367: x_msg_data := SQLERRM;
368:
369: X_overr_to_organization_id := null;

Line 435: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

431: --------------------------------------------
432: -- Initialize the successfull return status
433: --------------------------------------------
434:
435: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
436:
437:
438: ---------------------------------------------------------------------------------------
439: -- Assign Input Raw cost into local variables anc check if input raw cost i null or not

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

501: x_msg_data
502: );
503:
504:
505: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
506:
507: RAISE l_invalid_schedule_id;
508:
509: END IF;

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

622:
623: EXCEPTION
624: WHEN NO_DATA_FOUND THEN
625: PA_UTILS.add_message('PA', 'PA_NO_BURDEN_COST_FLAG');
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: x_msg_count := 1;
628: x_msg_data := 'PA_NO_BURDEN_COST_FLAG';
629:
630: WHEN l_raw_cost_null THEN

Line 632: x_return_status := FND_API.G_RET_STS_ERROR;

628: x_msg_data := 'PA_NO_BURDEN_COST_FLAG';
629:
630: WHEN l_raw_cost_null THEN
631: PA_UTILS.add_message('PA', 'PA_RAW_COST_NULL');
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: x_msg_count := 1;
634: x_msg_data := 'PA_RAW_COST_NULL';
635:
636: WHEN l_done_burden_cost_calc THEN

Line 637: x_return_status := FND_API.G_RET_STS_SUCCESS;

633: x_msg_count := 1;
634: x_msg_data := 'PA_RAW_COST_NULL';
635:
636: WHEN l_done_burden_cost_calc THEN
637: x_return_status := FND_API.G_RET_STS_SUCCESS;
638: x_msg_count := NULL;
639: x_msg_data := NULL;
640:
641: WHEN l_cost_plus_struture_not_found THEN

Line 643: x_return_status := FND_API.G_RET_STS_ERROR;

639: x_msg_data := NULL;
640:
641: WHEN l_cost_plus_struture_not_found THEN
642: PA_UTILS.add_message('PA', 'PA_NO_COST_PLUS_STRUCTURE');
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: x_msg_count := 1;
645: x_msg_data := 'PA_NO_COST_PLUS_STRUCTURE';
646:
647: WHEN l_cost_base_not_found THEN

Line 649: x_return_status := FND_API.G_RET_STS_ERROR;

645: x_msg_data := 'PA_NO_COST_PLUS_STRUCTURE';
646:
647: WHEN l_cost_base_not_found THEN
648: PA_UTILS.add_message('PA', 'PA_COST_BASE_NOT_FOUND');
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: x_msg_count := 1;
651: x_msg_data := 'PA_COST_BASE_NOT_FOUND';
652:
653: WHEN l_comp_multiplier_not_found THEN

Line 655: x_return_status := FND_API.G_RET_STS_ERROR;

651: x_msg_data := 'PA_COST_BASE_NOT_FOUND';
652:
653: WHEN l_comp_multiplier_not_found THEN
654: PA_UTILS.add_message('PA', 'PA_NO_COMPILED_MULTIPLIER');
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: x_msg_count := 1;
657: x_msg_data := 'PA_NO_COMPILED_MULTIPLIER';
658:
659: WHEN l_invalid_schedule_id THEN

Line 660: x_return_status := FND_API.G_RET_STS_ERROR;

656: x_msg_count := 1;
657: x_msg_data := 'PA_NO_COMPILED_MULTIPLIER';
658:
659: WHEN l_invalid_schedule_id THEN
660: x_return_status := FND_API.G_RET_STS_ERROR;
661: x_msg_count := 1;
662: x_msg_data := 'PA_INVALID_SCH_REV_ID';
663:
664: WHEN l_burden_cost_null THEN

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

662: x_msg_data := 'PA_INVALID_SCH_REV_ID';
663:
664: WHEN l_burden_cost_null THEN
665: PA_UTILS.add_message('PA', 'PA_BURDEN_COST_NULL');
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: x_msg_count := 1;
668: x_msg_data := 'PA_BURDEN_COST_NULL';
669:
670: WHEN OTHERS THEN

Line 671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

667: x_msg_count := 1;
668: x_msg_data := 'PA_BURDEN_COST_NULL';
669:
670: WHEN OTHERS THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: x_msg_count := 1;
673: x_msg_data := SQLERRM;
674:
675: p_exp_func_curr_code := l_exp_func_curr_code;

Line 740: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

736: --------------------------------------------
737: -- Initialize the successfull return status
738: --------------------------------------------
739:
740: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
741:
742:
743:
744: ---------------------------------------------

Line 965: x_return_status := FND_API.G_RET_STS_SUCCESS;

961:
962:
963: EXCEPTION
964: WHEN l_done_proj_cost_calc THEN
965: x_return_status := FND_API.G_RET_STS_SUCCESS;
966: x_msg_count := NULL;
967: x_msg_data := NULL;
968:
969: WHEN l_proj_func_curr_code_null THEN

Line 971: x_return_status := FND_API.G_RET_STS_ERROR;

967: x_msg_data := NULL;
968:
969: WHEN l_proj_func_curr_code_null THEN
970: PA_UTILS.add_message('PA', 'PA_PROJ_FUNC_CURR_CODE_NULL');
971: x_return_status := FND_API.G_RET_STS_ERROR;
972: x_msg_count := 1;
973: x_msg_data := 'PA_PROJ_FUNC_CURR_CODE_NULL';
974:
975: WHEN l_exp_func_curr_code_null THEN

Line 977: x_return_status := FND_API.G_RET_STS_ERROR;

973: x_msg_data := 'PA_PROJ_FUNC_CURR_CODE_NULL';
974:
975: WHEN l_exp_func_curr_code_null THEN
976: PA_UTILS.add_message('PA', 'PA_EXP_FUNC_CURR_CODE_NULL');
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: x_msg_count := 1;
979: x_msg_data := 'PA_EXP_FUNC_CURR_CODE_NULL';
980:
981: WHEN l_invalid_rate_date_type THEN

Line 983: x_return_status := FND_API.G_RET_STS_ERROR;

979: x_msg_data := 'PA_EXP_FUNC_CURR_CODE_NULL';
980:
981: WHEN l_invalid_rate_date_type THEN
982: PA_UTILS.add_message('PA', 'PA_INVALID_RATE_DATE_TYPE');
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: x_msg_count := 1;
985: x_msg_data := 'PA_INVALID_RATE_DATE_TYPE';
986:
987: WHEN l_raw_cost_null THEN

Line 989: x_return_status := FND_API.G_RET_STS_ERROR;

985: x_msg_data := 'PA_INVALID_RATE_DATE_TYPE';
986:
987: WHEN l_raw_cost_null THEN
988: PA_UTILS.add_message('PA', 'PA_RAW_COST_NULL');
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: x_msg_count := 1;
991: x_msg_data := 'PA_PA_PROJ_RAW_COST_NULL';
992:
993: WHEN l_burden_cost_null THEN

Line 995: x_return_status := FND_API.G_RET_STS_ERROR;

991: x_msg_data := 'PA_PA_PROJ_RAW_COST_NULL';
992:
993: WHEN l_burden_cost_null THEN
994: PA_UTILS.add_message('PA', 'PA_BURDEN_COST_NULL');
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: x_msg_count := 1;
997: x_msg_data := 'PA_BURDEN_COST_NULL';
998:
999: WHEN OTHERS THEN

Line 1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

996: x_msg_count := 1;
997: x_msg_data := 'PA_BURDEN_COST_NULL';
998:
999: WHEN OTHERS THEN
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: x_msg_count := 1;
1002: x_msg_data := SQLERRM;
1003:
1004: /* ATG Changes */

Line 1117: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

1113: --------------------------------------------
1114: -- Initialize the successfull return status
1115: --------------------------------------------
1116:
1117: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1118:
1119:
1120:
1121: l_burden_sch_id := NULL;

Line 1426: x_return_status := FND_API.G_RET_STS_ERROR;

1422:
1423: EXCEPTION
1424: WHEN l_invalid_revision_by_date THEN
1425: PA_UTILS.add_message('PA', 'PA_SCH_REV_NOT_FOUND');
1426: x_return_status := FND_API.G_RET_STS_ERROR;
1427: x_msg_count := 1;
1428: x_msg_data := 'PA_SCH_REV_NOT_FOUND';
1429:
1430: WHEN l_sch_rev_id_found THEN

Line 1431: x_return_status := FND_API.G_RET_STS_SUCCESS;

1427: x_msg_count := 1;
1428: x_msg_data := 'PA_SCH_REV_NOT_FOUND';
1429:
1430: WHEN l_sch_rev_id_found THEN
1431: x_return_status := FND_API.G_RET_STS_SUCCESS;
1432: x_msg_count := NULL;
1433: x_msg_data := NULL;
1434:
1435: WHEN l_sch_rev_id_not_found THEN

Line 1437: x_return_status := FND_API.G_RET_STS_ERROR;

1433: x_msg_data := NULL;
1434:
1435: WHEN l_sch_rev_id_not_found THEN
1436: PA_UTILS.add_message('PA', 'PA_SCH_REV_ID_NOT_FOUND');
1437: x_return_status := FND_API.G_RET_STS_ERROR;
1438: x_msg_count := 1;
1439: x_msg_data := 'PA_SCH_REV_ID_NOT_FOUND';
1440:
1441: WHEN OTHERS THEN

Line 1442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1438: x_msg_count := 1;
1439: x_msg_data := 'PA_SCH_REV_ID_NOT_FOUND';
1440:
1441: WHEN OTHERS THEN
1442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1443: x_msg_count := 1;
1444: x_msg_data := SQLERRM;
1445:
1446:

Line 1495: l_x_return_status := FND_API.G_RET_STS_SUCCESS;

1491: --------------------------------------------
1492: -- Initialize the successfull return status
1493: --------------------------------------------
1494:
1495: l_x_return_status := FND_API.G_RET_STS_SUCCESS;
1496:
1497:
1498: ---------------------------------------
1499: -- Get the Project Cost Job Id from API.

Line 1547: x_return_status := FND_API.G_RET_STS_ERROR;

1543:
1544: EXCEPTION
1545: WHEN NO_DATA_FOUND THEN
1546: PA_UTILS.add_message('PA', 'PA_NO_COST_RATE');
1547: x_return_status := FND_API.G_RET_STS_ERROR;
1548: x_msg_count := 1;
1549: x_msg_data := 'PA_NO_COST_RATE';
1550:
1551: WHEN l_raw_cost_null THEN

Line 1553: x_return_status := FND_API.G_RET_STS_ERROR;

1549: x_msg_data := 'PA_NO_COST_RATE';
1550:
1551: WHEN l_raw_cost_null THEN
1552: PA_UTILS.add_message('PA', 'PA_RAW_COST_NULL');
1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554: x_msg_count := 1;
1555: x_msg_data := 'PA_RAW_COST_NULL';
1556:
1557: WHEN OTHERS THEN

Line 1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1554: x_msg_count := 1;
1555: x_msg_data := 'PA_RAW_COST_NULL';
1556:
1557: WHEN OTHERS THEN
1558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559: x_msg_count := 1;
1560: x_msg_data := SQLERRM;
1561:
1562: /* ATG Changes */