DBA Data[Home] [Help]

APPS.PA_ALTERNATE_TASK_PVT dependencies on FND_API

Line 28: elsif p_char IS NOT NULL and p_char = FND_API.G_MISS_CHAR THEN

24: begin
25:
26: if p_char IS NOT NULL and p_char = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
27: return to_char(NULL);
28: elsif p_char IS NOT NULL and p_char = FND_API.G_MISS_CHAR THEN
29: return to_char(NULL);
30: elsif p_char IS NULL THEN
31: return fnd_api.g_miss_char;
32: else

Line 31: return fnd_api.g_miss_char;

27: return to_char(NULL);
28: elsif p_char IS NOT NULL and p_char = FND_API.G_MISS_CHAR THEN
29: return to_char(NULL);
30: elsif p_char IS NULL THEN
31: return fnd_api.g_miss_char;
32: else
33: return p_char;
34: end if;
35:

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88: l_attribute15 SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
89:
90: BEGIN
91:
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: x_msg_data := NULL;
94: x_msg_count := 0;
95:
96: IF p_pa_debug_mode = 'Y' Then

Line 260: x_return_status := FND_API.G_RET_STS_SUCCESS;

256: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
257: BEGIN
258:
259:
260: x_return_status := FND_API.G_RET_STS_SUCCESS;
261: x_msg_data := NULL;
262: x_msg_count := 0;
263:
264: IF p_pa_debug_mode = 'Y' Then

Line 842: x_return_status := FND_API.G_RET_STS_SUCCESS;

838:
839: BEGIN
840:
841: print_msg('PA_ALTERNATE_TASK_PVT.Copy_Cost_Codes_From_Task :: Start');
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843: x_msg_data := NULL;
844: x_msg_count := 0;
845:
846: select CBS_ELEMENT_ID

Line 952: x_return_status := FND_API.G_RET_STS_SUCCESS;

948: L_TEMP VARCHAR2(1) := 'N';
949:
950: BEGIN
951: print_msg('PA_ALTERNATE_TASK_PVT.Is_Cost_Element_Valid :: Start');
952: x_return_status := FND_API.G_RET_STS_SUCCESS;
953: x_msg_data := NULL;
954: x_msg_count := 0;
955: print_msg('Input paramters to PA_ALTERNATE_TASK_PVT.Is_Cost_Element_Valid');
956: print_msg('p_Cbs_Element_Id :: ' || p_Cbs_Element_Id);

Line 963: x_return_status := FND_API.G_RET_STS_ERROR;

959:
960: l_Cbs_Enabled := PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(p_Project_Id => P_PROJECT_ID);
961:
962: IF l_Cbs_Enabled = 'N' THEN
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: x_msg_data := 'PA_CBS_PROJ_NOT_ENABLED';
965: x_msg_count := 1;
966: ELSE
967: OPEN validateCBSStructure(p_Project_Id, p_Cbs_Element_Id);

Line 976: x_return_status := FND_API.G_RET_STS_ERROR;

972: ELSE
973: l_Cbs_Struct_Valid := 'N';
974: END IF;
975: IF l_Cbs_Struct_Valid = 'N' THEN
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: x_msg_data := 'PA_CBS_INVALID_CBS_ELEM_ID';
978: x_msg_count := 1;
979: ELSE
980: L_TEMP := 'N';

Line 990: x_return_status := FND_API.G_RET_STS_ERROR;

986: ELSE
987: l_Cost_Code_Valid := 'N';
988: END IF;
989: IF l_Cost_Code_Valid = 'N' THEN
990: x_return_status := FND_API.G_RET_STS_ERROR;
991: x_msg_data := 'PA_CBS_ELEM_MISMATCH';
992: x_msg_count := 1;
993: END IF;
994: END IF;

Line 1050: x_return_status := FND_API.G_RET_STS_SUCCESS;

1046: L_TEMP VARCHAR2(1) := 'N';
1047:
1048: BEGIN
1049: print_msg('PA_ALTERNATE_TASK_PVT.Is_Cost_Code_Valid :: Start');
1050: x_return_status := FND_API.G_RET_STS_SUCCESS;
1051: x_msg_data := NULL;
1052: x_msg_count := 0;
1053: print_msg('Input paramters to PA_ALTERNATE_TASK_PVT.Is_Cost_Code_Valid');
1054: print_msg('p_Cost_Code :: ' || p_Cost_Code);

Line 1061: x_return_status := FND_API.G_RET_STS_ERROR;

1057:
1058: l_Cbs_Enabled := PA_ALTERNATE_TASK_PVT.Is_Cbs_Enabled(p_Project_Id => P_PROJECT_ID);
1059:
1060: IF l_Cbs_Enabled = 'N' THEN
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: x_msg_data := 'PA_CBS_PROJ_NOT_ENABLED';
1063: x_msg_count := 1;
1064: ELSE
1065: OPEN validateCBSStructure(p_Project_Id, p_Cost_Code);

Line 1074: x_return_status := FND_API.G_RET_STS_ERROR;

1070: ELSE
1071: l_Cbs_Struct_Valid := 'N';
1072: END IF;
1073: IF l_Cbs_Struct_Valid = 'N' THEN
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: x_msg_data := 'PA_CBS_INVALID_CBS_ELEM_ID';
1076: x_msg_count := 1;
1077: ELSE
1078: L_TEMP := 'N';

Line 1088: x_return_status := FND_API.G_RET_STS_ERROR;

1084: ELSE
1085: l_Cost_Code_Valid := 'N';
1086: END IF;
1087: IF l_Cost_Code_Valid = 'N' THEN
1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089: x_msg_data := 'PA_CBS_ELEM_MISMATCH';
1090: x_msg_count := 1;
1091: END IF;
1092: END IF;

Line 1164: x_return_status := FND_API.G_RET_STS_SUCCESS;

1160: L_TEMP VARCHAR2(1) := 'N';
1161:
1162: BEGIN
1163: print_msg('PA_ALTERNATE_TASK_PVT.Is_Planning_Options_Valid :: Start');
1164: x_return_status := FND_API.G_RET_STS_SUCCESS;
1165: x_msg_data := NULL;
1166: x_msg_count := 0;
1167: print_msg('Input paramters to PA_ALTERNATE_TASK_PVT.Is_Planning_Options_Valid');
1168: print_msg('p_budget_version_id :: ' || p_budget_version_id);

Line 1184: x_return_status := FND_API.G_RET_STS_ERROR;

1180: OPEN validateLowestTask;
1181: FETCH validateLowestTask INTO L_TEMP;
1182: CLOSE validateLowestTask;
1183: IF L_TEMP='Y' THEN
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: x_msg_data := 'PA_CBS_INVALID_LEVEL';
1186: x_msg_count := 1;
1187: END IF;
1188:

Line 1194: x_return_status := FND_API.G_RET_STS_ERROR;

1190: OPEN validateStaffPlan;
1191: FETCH validateStaffPlan INTO L_TEMP;
1192: CLOSE validateStaffPlan;
1193: IF L_TEMP='Y' THEN
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: x_msg_data := 'PA_CBS_INVALID_STAFF_PLAN';
1196: x_msg_count := 1;
1197: END IF;
1198:

Line 1204: x_return_status := FND_API.G_RET_STS_ERROR;

1200: OPEN validateBillEvent;
1201: FETCH validateBillEvent INTO L_TEMP;
1202: CLOSE validateBillEvent;
1203: IF L_TEMP='Y' THEN
1204: x_return_status := FND_API.G_RET_STS_ERROR;
1205: x_msg_data := 'PA_CBS_INVALID_BILL_EVENT';
1206: x_msg_count := 1;
1207: END IF;
1208:

Line 1214: x_return_status := FND_API.G_RET_STS_ERROR;

1210: OPEN validateRevDerv;
1211: FETCH validateRevDerv INTO L_TEMP;
1212: CLOSE validateRevDerv;
1213: IF L_TEMP='Y' THEN
1214: x_return_status := FND_API.G_RET_STS_ERROR;
1215: x_msg_data := 'PA_CBS_INVALID_REV_DERV';
1216: x_msg_count := 1;
1217: END IF;
1218:

Line 1285: x_return_status := FND_API.G_RET_STS_SUCCESS;

1281:
1282: BEGIN
1283:
1284:
1285: x_return_status := FND_API.G_RET_STS_SUCCESS;
1286: x_msg_data := NULL;
1287: x_msg_count := 0;
1288:
1289: IF p_pa_debug_mode = 'Y' Then