DBA Data[Home] [Help]

APPS.OKE_K_ACCESS_PVT dependencies on FND_API

Line 51: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

47: FETCH c INTO L_Role_ID;
48:
49: IF ( c%notfound ) THEN
50: CLOSE c;
51: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
52: RETURN;
53: END IF;
54:
55: CLOSE c;

Line 64: X_Return_Status := FND_API.G_RET_STS_ERROR;

60: FND_MESSAGE.Set_Name('OKE' , 'OKE_SEC_OVERLAP_ROLE_ASSIGNED');
61: END IF;
62: FND_MESSAGE.Set_Token('EMP' , pa_utils.GetEmpName(P_Person_ID));
63: FND_MSG_PUB.Add;
64: X_Return_Status := FND_API.G_RET_STS_ERROR;
65:
66: EXCEPTION
67: WHEN OTHERS THEN
68: FND_MSG_PUB.ADD_EXC_MSG( p_pkg_name => 'OKE_K_ACCESS_PVT'

Line 71: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

67: WHEN OTHERS THEN
68: FND_MSG_PUB.ADD_EXC_MSG( p_pkg_name => 'OKE_K_ACCESS_PVT'
69: , p_procedure_name => 'ASSIGNMENT_EXISTS'
70: , p_error_text => substr(sqlerrm , 1 , 240) );
71: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
72:
73: END ASSIGNMENT_EXISTS;
74:
75:

Line 88: X_Return_Status := FND_API.G_RET_STS_ERROR;

84: IF ( P_End_Date_Active IS NOT NULL
85: AND P_End_Date_Active < P_Start_Date_Active ) THEN
86: FND_MESSAGE.Set_Name('OKE' , 'OKE_INVALID_EFFDATE_PAIR');
87: FND_MSG_PUB.Add;
88: X_Return_Status := FND_API.G_RET_STS_ERROR;
89: ELSE
90: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
91: RETURN;
92: END IF;

Line 90: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

86: FND_MESSAGE.Set_Name('OKE' , 'OKE_INVALID_EFFDATE_PAIR');
87: FND_MSG_PUB.Add;
88: X_Return_Status := FND_API.G_RET_STS_ERROR;
89: ELSE
90: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
91: RETURN;
92: END IF;
93:
94: END VALIDATE_START_END_DATES;

Line 131: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN

127: , P_End_Date_Active => P_End_Date_Active
128: , X_Return_Status => X_Return_Status
129: );
130:
131: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN
132: RETURN;
133: END IF;
134:
135: Assignment_Exists

Line 146: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN

142: , P_End_Date_Active => P_End_Date_Active
143: , X_Return_Status => X_Return_Status
144: );
145:
146: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN
147: RETURN;
148: END IF;
149:
150: PA_PROJECT_PARTIES_PVT.Create_Project_Party

Line 152: , P_Validate_Only => FND_API.G_FALSE

148: END IF;
149:
150: PA_PROJECT_PARTIES_PVT.Create_Project_Party
151: ( P_Commit => P_Commit
152: , P_Validate_Only => FND_API.G_FALSE
153: , P_Validation_Level => FND_API.G_VALID_LEVEL_FULL
154: , P_Debug_Mode => 'N'
155: , P_Object_ID => P_Object_ID
156: , P_Object_Type => P_Object_Type

Line 153: , P_Validation_Level => FND_API.G_VALID_LEVEL_FULL

149:
150: PA_PROJECT_PARTIES_PVT.Create_Project_Party
151: ( P_Commit => P_Commit
152: , P_Validate_Only => FND_API.G_FALSE
153: , P_Validation_Level => FND_API.G_VALID_LEVEL_FULL
154: , P_Debug_Mode => 'N'
155: , P_Object_ID => P_Object_ID
156: , P_Object_Type => P_Object_Type
157: , P_Resource_Type_ID => 101

Line 177: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN

173: , X_Msg_Count => X_Msg_Count
174: , X_Msg_Data => X_Msg_Data
175: );
176:
177: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN
178: RETURN;
179: END IF;
180:
181: OPEN c;

Line 185: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

181: OPEN c;
182: FETCH c INTO X_Record_Version_Number;
183: IF ( c%notfound ) THEN
184: CLOSE c;
185: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
186: END IF;
187: CLOSE c;
188:
189: END CREATE_CONTRACT_ACCESS;

Line 250: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN

246: , P_End_Date_Active => P_End_Date_Active
247: , X_Return_Status => X_Return_Status
248: );
249:
250: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN
251: RETURN;
252: END IF;
253:
254: Assignment_Exists

Line 265: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN

261: , P_End_Date_Active => P_End_Date_Active
262: , X_Return_Status => X_Return_Status
263: );
264:
265: IF ( X_Return_Status <> FND_API.G_RET_STS_SUCCESS ) THEN
266: RETURN;
267: END IF;
268:
269: PA_PROJECT_PARTIES_PVT.Update_Project_Party

Line 271: , P_Validate_Only => FND_API.G_FALSE

267: END IF;
268:
269: PA_PROJECT_PARTIES_PVT.Update_Project_Party
270: ( P_Commit => P_Commit
271: , P_Validate_Only => FND_API.G_FALSE
272: , P_Validation_Level => FND_API.G_VALID_LEVEL_FULL
273: , P_Debug_Mode => 'N'
274: , P_Object_ID => P_Object_ID
275: , P_Object_Type => P_Object_Type

Line 272: , P_Validation_Level => FND_API.G_VALID_LEVEL_FULL

268:
269: PA_PROJECT_PARTIES_PVT.Update_Project_Party
270: ( P_Commit => P_Commit
271: , P_Validate_Only => FND_API.G_FALSE
272: , P_Validation_Level => FND_API.G_VALID_LEVEL_FULL
273: , P_Debug_Mode => 'N'
274: , P_Object_ID => P_Object_ID
275: , P_Object_Type => P_Object_Type
276: , P_Project_Role_ID => P_Role_ID

Line 287: , P_Assignment_ID => FND_API.G_MISS_NUM

283: , P_Calling_Module => 'FORM'
284: , P_Project_ID => NULL
285: , P_Project_End_Date => NULL
286: , P_Project_Party_ID => P_Project_Party_ID
287: , P_Assignment_ID => FND_API.G_MISS_NUM
288: , P_Assign_Record_Version_Number => FND_API.G_MISS_NUM
289: , P_End_Date_Active => P_End_Date_Active
290: , X_Assignment_ID => X_Assignment_ID
291: , X_WF_Type => WF_Type

Line 288: , P_Assign_Record_Version_Number => FND_API.G_MISS_NUM

284: , P_Project_ID => NULL
285: , P_Project_End_Date => NULL
286: , P_Project_Party_ID => P_Project_Party_ID
287: , P_Assignment_ID => FND_API.G_MISS_NUM
288: , P_Assign_Record_Version_Number => FND_API.G_MISS_NUM
289: , P_End_Date_Active => P_End_Date_Active
290: , X_Assignment_ID => X_Assignment_ID
291: , X_WF_Type => WF_Type
292: , X_WF_Item_Type => WF_Item_Type