eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_TASK_PART_PUB dependencies on FND_API

Line 51: -- If(p_opp_rec.lead_source_code is NOT NULL and p_opp_rec.lead_source_code <> FND_API.G_MISS_CHAR)

47: -- Value based parameters should be converted to their equivalent ids.
48: -- Each value should resolve into one and only one id.
49: -- If this condition is not satisfied, API must report an error and assign l_any_errors to TRUE.
50: -- Example: Process Lead Source/Lead Source Code
51: -- If(p_opp_rec.lead_source_code is NOT NULL and p_opp_rec.lead_source_code <> FND_API.G_MISS_CHAR)
52: -- THEN
53: -- p_pvt_opp_rec.lead_source_code := p_opp_rec.lead_source_code;
54: -- IF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
55: -- THEN

Line 54: -- IF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)

50: -- Example: Process Lead Source/Lead Source Code
51: -- If(p_opp_rec.lead_source_code is NOT NULL and p_opp_rec.lead_source_code <> FND_API.G_MISS_CHAR)
52: -- THEN
53: -- p_pvt_opp_rec.lead_source_code := p_opp_rec.lead_source_code;
54: -- IF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
55: -- THEN
56: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
57: -- THEN
58: -- FND_MESSAGE.Set_Name('AS','API_ATTRIBUTE_IGNORED');

Line 63: -- ELSIF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)

59: -- FND_MESSAGE.Set_Token('COLUMN','LEAD_SOURCE',FALSE);
60: -- FND_MSG_PUB.Add;
61: -- END IF;
62: -- END IF;
63: -- ELSIF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
64: -- THEN
65: -- OPEN C_Get_Lookup_Code('LEAD_SOURCE', p_opp_rec.lead_source);
66: -- FETCH C_Get_Lookup_Code INTO l_val;
67: -- CLOSE C_Get_Lookup_Code;

Line 129: raise FND_API.G_EXC_ERROR;

125: */
126: -- If there is an error in conversion precessing, raise an error.
127: IF l_any_errors
128: THEN
129: raise FND_API.G_EXC_ERROR;
130: END IF;
131:
132:
133: END Convert_TASK_PART_Values;

Line 137: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

133: END Convert_TASK_PART_Values;
134:
135: PROCEDURE Create_task_part(
136: P_Api_Version_Number IN NUMBER,
137: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
138: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
141: --Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 138: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

134:
135: PROCEDURE Create_task_part(
136: P_Api_Version_Number IN NUMBER,
137: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
138: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
141: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
142: X_TASK_PART_ID OUT NOCOPY NUMBER,

Line 139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

135: PROCEDURE Create_task_part(
136: P_Api_Version_Number IN NUMBER,
137: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
138: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
139: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140: P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
141: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
142: X_TASK_PART_ID OUT NOCOPY NUMBER,
143: X_Return_Status OUT NOCOPY VARCHAR2,

Line 157: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

153: -- Standard Start of API savepoint
154: SAVEPOINT CREATE_TASK_PART_PUB;
155:
156: -- Standard call to check for call compatibility.
157: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
158: p_api_version_number,
159: l_api_name,
160: G_PKG_NAME)
161: THEN

Line 162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

158: p_api_version_number,
159: l_api_name,
160: G_PKG_NAME)
161: THEN
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164:
165:
166: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 167: IF FND_API.to_Boolean( p_init_msg_list )

163: END IF;
164:
165:
166: -- Initialize message list if p_init_msg_list is set to TRUE.
167: IF FND_API.to_Boolean( p_init_msg_list )
168: THEN
169: FND_MSG_PUB.initialize;
170: END IF;
171:

Line 179: x_return_status := FND_API.G_RET_STS_SUCCESS;

175:
176: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
177:
178: -- Initialize API return status to SUCCESS
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180:
181: --
182: -- API body
183: --

Line 204: p_commit => FND_API.G_FALSE,

200: THEN
201: AS_task_part_CUHK.Create_task_part_Pre(
202: p_api_version_number => 1.0,
203: p_validation_level => p_validation_level,
204: p_commit => FND_API.G_FALSE,
205: p_profile_tbl => p_profile_tbl,
206: p_check_access_flag => p_check_access_flag,
207: p_admin_flag => p_admin_flag,
208: p_admin_group_id => p_admin_group_id,

Line 215: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

211: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
212: x_return_status => x_return_status,
213: x_msg_count => x_msg_count,
214: x_msg_data => x_msg_data);
215: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
216: RAISE fnd_api.g_exc_error;
217: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;

Line 216: RAISE fnd_api.g_exc_error;

212: x_return_status => x_return_status,
213: x_msg_count => x_msg_count,
214: x_msg_data => x_msg_data);
215: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
216: RAISE fnd_api.g_exc_error;
217: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220: END IF;

Line 217: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

213: x_msg_count => x_msg_count,
214: x_msg_data => x_msg_data);
215: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
216: RAISE fnd_api.g_exc_error;
217: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220: END IF;
221: -- USER HOOKS standard : vertical industry pre-processing section - mandatory

Line 218: RAISE fnd_api.g_exc_unexpected_error;

214: x_msg_data => x_msg_data);
215: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
216: RAISE fnd_api.g_exc_error;
217: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220: END IF;
221: -- USER HOOKS standard : vertical industry pre-processing section - mandatory
222: IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Create_task_part','B','V'))

Line 227: p_commit => FND_API.G_FALSE,

223: THEN
224: AS_task_part_VUHK.Create_task_part_Pre(
225: p_api_version_number => 1.0,
226: p_validation_level => p_validation_level,
227: p_commit => FND_API.G_FALSE,
228: p_profile_tbl => p_profile_tbl,
229: p_check_access_flag => p_check_access_flag,
230: p_admin_flag => p_admin_flag,
231: p_admin_group_id => p_admin_group_id,

Line 238: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

234: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
235: x_return_status => x_return_status,
236: x_msg_count => x_msg_count,
237: x_msg_data => x_msg_data);
238: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
239: RAISE fnd_api.g_exc_error;
240: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
241: RAISE fnd_api.g_exc_unexpected_error;
242: END IF;

Line 239: RAISE fnd_api.g_exc_error;

235: x_return_status => x_return_status,
236: x_msg_count => x_msg_count,
237: x_msg_data => x_msg_data);
238: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
239: RAISE fnd_api.g_exc_error;
240: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
241: RAISE fnd_api.g_exc_unexpected_error;
242: END IF;
243: */

Line 240: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

236: x_msg_count => x_msg_count,
237: x_msg_data => x_msg_data);
238: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
239: RAISE fnd_api.g_exc_error;
240: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
241: RAISE fnd_api.g_exc_unexpected_error;
242: END IF;
243: */
244: -- Calling Private package: Create_TASK_PART

Line 241: RAISE fnd_api.g_exc_unexpected_error;

237: x_msg_data => x_msg_data);
238: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
239: RAISE fnd_api.g_exc_error;
240: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
241: RAISE fnd_api.g_exc_unexpected_error;
242: END IF;
243: */
244: -- Calling Private package: Create_TASK_PART
245: -- Hint: Primary key needs to be returned

Line 248: P_Init_Msg_List => FND_API.G_FALSE,

244: -- Calling Private package: Create_TASK_PART
245: -- Hint: Primary key needs to be returned
246: CSP_task_part_PVT.Create_task_part(
247: P_Api_Version_Number => 1.0,
248: P_Init_Msg_List => FND_API.G_FALSE,
249: P_Commit => FND_API.G_FALSE,
250: P_Validation_Level => P_Validation_Level,
251: P_TASK_PART_Rec => l_pvt_TASK_PART_Rec ,
252: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 249: P_Commit => FND_API.G_FALSE,

245: -- Hint: Primary key needs to be returned
246: CSP_task_part_PVT.Create_task_part(
247: P_Api_Version_Number => 1.0,
248: P_Init_Msg_List => FND_API.G_FALSE,
249: P_Commit => FND_API.G_FALSE,
250: P_Validation_Level => P_Validation_Level,
251: P_TASK_PART_Rec => l_pvt_TASK_PART_Rec ,
252: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
253: X_TASK_PART_ID => x_TASK_PART_ID,

Line 261: IF x_return_status = FND_API.G_RET_STS_ERROR then

257:
258:
259:
260: -- Check return status from the above procedure call
261: IF x_return_status = FND_API.G_RET_STS_ERROR then
262: raise FND_API.G_EXC_ERROR;
263: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
264: raise FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;

Line 262: raise FND_API.G_EXC_ERROR;

258:
259:
260: -- Check return status from the above procedure call
261: IF x_return_status = FND_API.G_RET_STS_ERROR then
262: raise FND_API.G_EXC_ERROR;
263: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
264: raise FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:

Line 263: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

259:
260: -- Check return status from the above procedure call
261: IF x_return_status = FND_API.G_RET_STS_ERROR then
262: raise FND_API.G_EXC_ERROR;
263: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
264: raise FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: --

Line 264: raise FND_API.G_EXC_UNEXPECTED_ERROR;

260: -- Check return status from the above procedure call
261: IF x_return_status = FND_API.G_RET_STS_ERROR then
262: raise FND_API.G_EXC_ERROR;
263: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
264: raise FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: --
268: -- End of API body.

Line 272: IF FND_API.to_Boolean( p_commit )

268: -- End of API body.
269: --
270:
271: -- Standard check for p_commit
272: IF FND_API.to_Boolean( p_commit )
273: THEN
274: COMMIT WORK;
275: END IF;
276:

Line 297: p_commit => FND_API.G_FALSE,

293: THEN
294: AS_task_part_VUHK.Create_task_part_Post(
295: p_api_version_number => 1.0,
296: p_validation_level => p_validation_level,
297: p_commit => FND_API.G_FALSE,
298: p_profile_tbl => p_profile_tbl,
299: p_check_access_flag => p_check_access_flag,
300: p_admin_flag => p_admin_flag,
301: p_admin_group_id => p_admin_group_id,

Line 308: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

304: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
305: x_return_status => x_return_status,
306: x_msg_count => x_msg_count,
307: x_msg_data => x_msg_data);
308: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
309: RAISE fnd_api.g_exc_error;
310: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
311: RAISE fnd_api.g_exc_unexpected_error;
312: END IF;

Line 309: RAISE fnd_api.g_exc_error;

305: x_return_status => x_return_status,
306: x_msg_count => x_msg_count,
307: x_msg_data => x_msg_data);
308: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
309: RAISE fnd_api.g_exc_error;
310: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
311: RAISE fnd_api.g_exc_unexpected_error;
312: END IF;
313: END IF;

Line 310: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

306: x_msg_count => x_msg_count,
307: x_msg_data => x_msg_data);
308: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
309: RAISE fnd_api.g_exc_error;
310: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
311: RAISE fnd_api.g_exc_unexpected_error;
312: END IF;
313: END IF;
314: -- USER HOOKS standard : customer pre-processing section - mandatory

Line 311: RAISE fnd_api.g_exc_unexpected_error;

307: x_msg_data => x_msg_data);
308: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
309: RAISE fnd_api.g_exc_error;
310: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
311: RAISE fnd_api.g_exc_unexpected_error;
312: END IF;
313: END IF;
314: -- USER HOOKS standard : customer pre-processing section - mandatory
315: IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Create_task_part','A','C'))

Line 320: p_commit => FND_API.G_FALSE,

316: THEN
317: AS_task_part_CUHK.Create_task_part_Pre(
318: p_api_version_number => 1.0,
319: p_validation_level => p_validation_level,
320: p_commit => FND_API.G_FALSE,
321: p_profile_tbl => p_profile_tbl,
322: p_check_access_flag => p_check_access_flag,
323: p_admin_flag => p_admin_flag,
324: p_admin_group_id => p_admin_group_id,

Line 331: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

327: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
328: x_return_status => x_return_status,
329: x_msg_count => x_msg_count,
330: x_msg_data => x_msg_data);
331: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
332: RAISE fnd_api.g_exc_error;
333: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
334: RAISE fnd_api.g_exc_unexpected_error;
335: END IF;

Line 332: RAISE fnd_api.g_exc_error;

328: x_return_status => x_return_status,
329: x_msg_count => x_msg_count,
330: x_msg_data => x_msg_data);
331: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
332: RAISE fnd_api.g_exc_error;
333: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
334: RAISE fnd_api.g_exc_unexpected_error;
335: END IF;
336: END IF;

Line 333: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

329: x_msg_count => x_msg_count,
330: x_msg_data => x_msg_data);
331: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
332: RAISE fnd_api.g_exc_error;
333: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
334: RAISE fnd_api.g_exc_unexpected_error;
335: END IF;
336: END IF;
337: */

Line 334: RAISE fnd_api.g_exc_unexpected_error;

330: x_msg_data => x_msg_data);
331: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
332: RAISE fnd_api.g_exc_error;
333: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
334: RAISE fnd_api.g_exc_unexpected_error;
335: END IF;
336: END IF;
337: */
338: EXCEPTION

Line 339: WHEN FND_API.G_EXC_ERROR THEN

335: END IF;
336: END IF;
337: */
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
341: P_API_NAME => L_API_NAME
342: ,P_PKG_NAME => G_PKG_NAME
343: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

345: ,X_MSG_COUNT => X_MSG_COUNT
346: ,X_MSG_DATA => X_MSG_DATA
347: ,X_RETURN_STATUS => X_RETURN_STATUS);
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 376: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

372:
373: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
374: PROCEDURE Update_task_part(
375: P_Api_Version_Number IN NUMBER,
376: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
377: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
378: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
379: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
380: X_Return_Status OUT NOCOPY VARCHAR2,

Line 377: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

373: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
374: PROCEDURE Update_task_part(
375: P_Api_Version_Number IN NUMBER,
376: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
377: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
378: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
379: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
380: X_Return_Status OUT NOCOPY VARCHAR2,
381: X_Msg_Count OUT NOCOPY NUMBER,

Line 378: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

374: PROCEDURE Update_task_part(
375: P_Api_Version_Number IN NUMBER,
376: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
377: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
378: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
379: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
380: X_Return_Status OUT NOCOPY VARCHAR2,
381: X_Msg_Count OUT NOCOPY NUMBER,
382: X_Msg_Data OUT NOCOPY VARCHAR2

Line 394: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

390: -- Standard Start of API savepoint
391: SAVEPOINT UPDATE_TASK_PART_PUB;
392:
393: -- Standard call to check for call compatibility.
394: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
395: p_api_version_number,
396: l_api_name,
397: G_PKG_NAME)
398: THEN

Line 399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

395: p_api_version_number,
396: l_api_name,
397: G_PKG_NAME)
398: THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401:
402:
403: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 404: IF FND_API.to_Boolean( p_init_msg_list )

400: END IF;
401:
402:
403: -- Initialize message list if p_init_msg_list is set to TRUE.
404: IF FND_API.to_Boolean( p_init_msg_list )
405: THEN
406: FND_MSG_PUB.initialize;
407: END IF;
408:

Line 416: x_return_status := FND_API.G_RET_STS_SUCCESS;

412:
413: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
414:
415: -- Initialize API return status to SUCCESS
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417:
418: --
419: -- API body
420: --

Line 441: p_commit => FND_API.G_FALSE,

437: THEN
438: AS_task_part_CUHK.Update_task_part_Pre(
439: p_api_version_number => 1.0,
440: p_validation_level => p_validation_level,
441: p_commit => FND_API.G_FALSE,
442: p_profile_tbl => p_profile_tbl,
443: p_check_access_flag => p_check_access_flag,
444: p_admin_flag => p_admin_flag,
445: p_admin_group_id => p_admin_group_id,

Line 452: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

448: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
449: x_return_status => x_return_status,
450: x_msg_count => x_msg_count,
451: x_msg_data => x_msg_data);
452: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
453: RAISE fnd_api.g_exc_error;
454: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
455: RAISE fnd_api.g_exc_unexpected_error;
456: END IF;

Line 453: RAISE fnd_api.g_exc_error;

449: x_return_status => x_return_status,
450: x_msg_count => x_msg_count,
451: x_msg_data => x_msg_data);
452: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
453: RAISE fnd_api.g_exc_error;
454: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
455: RAISE fnd_api.g_exc_unexpected_error;
456: END IF;
457: END IF;

Line 454: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

450: x_msg_count => x_msg_count,
451: x_msg_data => x_msg_data);
452: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
453: RAISE fnd_api.g_exc_error;
454: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
455: RAISE fnd_api.g_exc_unexpected_error;
456: END IF;
457: END IF;
458: -- USER HOOKS standard : vertical industry pre-processing section - mandatory

Line 455: RAISE fnd_api.g_exc_unexpected_error;

451: x_msg_data => x_msg_data);
452: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
453: RAISE fnd_api.g_exc_error;
454: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
455: RAISE fnd_api.g_exc_unexpected_error;
456: END IF;
457: END IF;
458: -- USER HOOKS standard : vertical industry pre-processing section - mandatory
459: IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Update_task_part','B','V'))

Line 464: p_commit => FND_API.G_FALSE,

460: THEN
461: AS_task_part_VUHK.Update_task_part_Pre(
462: p_api_version_number => 1.0,
463: p_validation_level => p_validation_level,
464: p_commit => FND_API.G_FALSE,
465: p_profile_tbl => p_profile_tbl,
466: p_check_access_flag => p_check_access_flag,
467: p_admin_flag => p_admin_flag,
468: p_admin_group_id => p_admin_group_id,

Line 475: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

471: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
472: x_return_status => x_return_status,
473: x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data);
475: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
476: RAISE fnd_api.g_exc_error;
477: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
478: RAISE fnd_api.g_exc_unexpected_error;
479: END IF;

Line 476: RAISE fnd_api.g_exc_error;

472: x_return_status => x_return_status,
473: x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data);
475: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
476: RAISE fnd_api.g_exc_error;
477: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
478: RAISE fnd_api.g_exc_unexpected_error;
479: END IF;
480: */

Line 477: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

473: x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data);
475: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
476: RAISE fnd_api.g_exc_error;
477: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
478: RAISE fnd_api.g_exc_unexpected_error;
479: END IF;
480: */
481: CSP_task_part_PVT.Update_task_part(

Line 478: RAISE fnd_api.g_exc_unexpected_error;

474: x_msg_data => x_msg_data);
475: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
476: RAISE fnd_api.g_exc_error;
477: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
478: RAISE fnd_api.g_exc_unexpected_error;
479: END IF;
480: */
481: CSP_task_part_PVT.Update_task_part(
482: P_Api_Version_Number => 1.0,

Line 483: P_Init_Msg_List => FND_API.G_FALSE,

479: END IF;
480: */
481: CSP_task_part_PVT.Update_task_part(
482: P_Api_Version_Number => 1.0,
483: P_Init_Msg_List => FND_API.G_FALSE,
484: P_Commit => p_commit,
485: P_Validation_Level => P_Validation_Level,
486: P_TASK_PART_Rec => l_pvt_TASK_PART_Rec ,
487: X_Return_Status => x_return_status,

Line 494: IF x_return_status = FND_API.G_RET_STS_ERROR then

490:
491:
492:
493: -- Check return status from the above procedure call
494: IF x_return_status = FND_API.G_RET_STS_ERROR then
495: raise FND_API.G_EXC_ERROR;
496: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
497: raise FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;

Line 495: raise FND_API.G_EXC_ERROR;

491:
492:
493: -- Check return status from the above procedure call
494: IF x_return_status = FND_API.G_RET_STS_ERROR then
495: raise FND_API.G_EXC_ERROR;
496: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
497: raise FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:

Line 496: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

492:
493: -- Check return status from the above procedure call
494: IF x_return_status = FND_API.G_RET_STS_ERROR then
495: raise FND_API.G_EXC_ERROR;
496: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
497: raise FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: --

Line 497: raise FND_API.G_EXC_UNEXPECTED_ERROR;

493: -- Check return status from the above procedure call
494: IF x_return_status = FND_API.G_RET_STS_ERROR then
495: raise FND_API.G_EXC_ERROR;
496: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
497: raise FND_API.G_EXC_UNEXPECTED_ERROR;
498: END IF;
499:
500: --
501: -- End of API body

Line 505: IF FND_API.to_Boolean( p_commit )

501: -- End of API body
502: --
503:
504: -- Standard check for p_commit
505: IF FND_API.to_Boolean( p_commit )
506: THEN
507: COMMIT WORK;
508: END IF;
509:

Line 530: p_commit => FND_API.G_FALSE,

526: THEN
527: AS_task_part_VUHK.Update_task_part_Post(
528: p_api_version_number => 1.0,
529: p_validation_level => p_validation_level,
530: p_commit => FND_API.G_FALSE,
531: p_profile_tbl => p_profile_tbl,
532: p_check_access_flag => p_check_access_flag,
533: p_admin_flag => p_admin_flag,
534: p_admin_group_id => p_admin_group_id,

Line 541: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

537: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
538: x_return_status => x_return_status,
539: x_msg_count => x_msg_count,
540: x_msg_data => x_msg_data);
541: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
542: RAISE fnd_api.g_exc_error;
543: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;

Line 542: RAISE fnd_api.g_exc_error;

538: x_return_status => x_return_status,
539: x_msg_count => x_msg_count,
540: x_msg_data => x_msg_data);
541: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
542: RAISE fnd_api.g_exc_error;
543: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546: END IF;

Line 543: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

539: x_msg_count => x_msg_count,
540: x_msg_data => x_msg_data);
541: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
542: RAISE fnd_api.g_exc_error;
543: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546: END IF;
547: -- USER HOOKS standard : customer pre-processing section - mandatory

Line 544: RAISE fnd_api.g_exc_unexpected_error;

540: x_msg_data => x_msg_data);
541: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
542: RAISE fnd_api.g_exc_error;
543: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546: END IF;
547: -- USER HOOKS standard : customer pre-processing section - mandatory
548: IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Update_task_part','A','C'))

Line 553: p_commit => FND_API.G_FALSE,

549: THEN
550: AS_task_part_CUHK.Update_task_part_Pre(
551: p_api_version_number => 1.0,
552: p_validation_level => p_validation_level,
553: p_commit => FND_API.G_FALSE,
554: p_profile_tbl => p_profile_tbl,
555: p_check_access_flag => p_check_access_flag,
556: p_admin_flag => p_admin_flag,
557: p_admin_group_id => p_admin_group_id,

Line 564: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

560: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
561: x_return_status => x_return_status,
562: x_msg_count => x_msg_count,
563: x_msg_data => x_msg_data);
564: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
565: RAISE fnd_api.g_exc_error;
566: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
567: RAISE fnd_api.g_exc_unexpected_error;
568: END IF;

Line 565: RAISE fnd_api.g_exc_error;

561: x_return_status => x_return_status,
562: x_msg_count => x_msg_count,
563: x_msg_data => x_msg_data);
564: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
565: RAISE fnd_api.g_exc_error;
566: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
567: RAISE fnd_api.g_exc_unexpected_error;
568: END IF;
569: END IF;

Line 566: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

562: x_msg_count => x_msg_count,
563: x_msg_data => x_msg_data);
564: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
565: RAISE fnd_api.g_exc_error;
566: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
567: RAISE fnd_api.g_exc_unexpected_error;
568: END IF;
569: END IF;
570: */

Line 567: RAISE fnd_api.g_exc_unexpected_error;

563: x_msg_data => x_msg_data);
564: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
565: RAISE fnd_api.g_exc_error;
566: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
567: RAISE fnd_api.g_exc_unexpected_error;
568: END IF;
569: END IF;
570: */
571: EXCEPTION

Line 572: WHEN FND_API.G_EXC_ERROR THEN

568: END IF;
569: END IF;
570: */
571: EXCEPTION
572: WHEN FND_API.G_EXC_ERROR THEN
573: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
574: P_API_NAME => L_API_NAME
575: ,P_PKG_NAME => G_PKG_NAME
576: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

578: ,X_MSG_COUNT => X_MSG_COUNT
579: ,X_MSG_DATA => X_MSG_DATA
580: ,X_RETURN_STATUS => X_RETURN_STATUS);
581:
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
584: P_API_NAME => L_API_NAME
585: ,P_PKG_NAME => G_PKG_NAME
586: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 610: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

606: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
607: -- The Master delete procedure may not be needed depends on different business requirements.
608: PROCEDURE Delete_task_part(
609: P_Api_Version_Number IN NUMBER,
610: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
611: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
612: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
613: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
614: X_Return_Status OUT NOCOPY VARCHAR2,

Line 611: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

607: -- The Master delete procedure may not be needed depends on different business requirements.
608: PROCEDURE Delete_task_part(
609: P_Api_Version_Number IN NUMBER,
610: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
611: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
612: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
613: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
614: X_Return_Status OUT NOCOPY VARCHAR2,
615: X_Msg_Count OUT NOCOPY NUMBER,

Line 612: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

608: PROCEDURE Delete_task_part(
609: P_Api_Version_Number IN NUMBER,
610: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
611: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
612: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
613: P_TASK_PART_Rec IN TASK_PART_Rec_Type,
614: X_Return_Status OUT NOCOPY VARCHAR2,
615: X_Msg_Count OUT NOCOPY NUMBER,
616: X_Msg_Data OUT NOCOPY VARCHAR2

Line 628: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

624: -- Standard Start of API savepoint
625: SAVEPOINT DELETE_TASK_PART_PUB;
626:
627: -- Standard call to check for call compatibility.
628: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
629: p_api_version_number,
630: l_api_name,
631: G_PKG_NAME)
632: THEN

Line 633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

629: p_api_version_number,
630: l_api_name,
631: G_PKG_NAME)
632: THEN
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END IF;
635:
636:
637: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 638: IF FND_API.to_Boolean( p_init_msg_list )

634: END IF;
635:
636:
637: -- Initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean( p_init_msg_list )
639: THEN
640: FND_MSG_PUB.initialize;
641: END IF;
642:

Line 650: x_return_status := FND_API.G_RET_STS_SUCCESS;

646:
647: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP', 'Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
648:
649: -- Initialize API return status to SUCCESS
650: x_return_status := FND_API.G_RET_STS_SUCCESS;
651:
652: --
653: -- API body
654: --

Line 668: P_Init_Msg_List => FND_API.G_FALSE,

664: );
665: */
666: CSP_task_part_PVT.Delete_task_part(
667: P_Api_Version_Number => 1.0,
668: P_Init_Msg_List => FND_API.G_FALSE,
669: P_Commit => p_commit,
670: P_Validation_Level => p_Validation_Level,
671: P_TASK_PART_Rec => l_pvt_TASK_PART_Rec,
672: X_Return_Status => x_return_status,

Line 684: p_commit => FND_API.G_FALSE,

680: THEN
681: AS_task_part_CUHK.Delete_task_part_Pre(
682: p_api_version_number => 1.0,
683: p_validation_level => p_validation_level,
684: p_commit => FND_API.G_FALSE,
685: p_profile_tbl => p_profile_tbl,
686: p_check_access_flag => p_check_access_flag,
687: p_admin_flag => p_admin_flag,
688: p_admin_group_id => p_admin_group_id,

Line 695: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

691: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
692: x_return_status => x_return_status,
693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data);
695: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
696: RAISE fnd_api.g_exc_error;
697: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
698: RAISE fnd_api.g_exc_unexpected_error;
699: END IF;

Line 696: RAISE fnd_api.g_exc_error;

692: x_return_status => x_return_status,
693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data);
695: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
696: RAISE fnd_api.g_exc_error;
697: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
698: RAISE fnd_api.g_exc_unexpected_error;
699: END IF;
700: END IF;

Line 697: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data);
695: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
696: RAISE fnd_api.g_exc_error;
697: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
698: RAISE fnd_api.g_exc_unexpected_error;
699: END IF;
700: END IF;
701: -- USER HOOKS standard : vertical industry pre-processing section - mandatory

Line 698: RAISE fnd_api.g_exc_unexpected_error;

694: x_msg_data => x_msg_data);
695: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
696: RAISE fnd_api.g_exc_error;
697: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
698: RAISE fnd_api.g_exc_unexpected_error;
699: END IF;
700: END IF;
701: -- USER HOOKS standard : vertical industry pre-processing section - mandatory
702: IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Delete_task_part','B','V'))

Line 707: p_commit => FND_API.G_FALSE,

703: THEN
704: AS_task_part_VUHK.Delete_task_part_Pre(
705: p_api_version_number => 1.0,
706: p_validation_level => p_validation_level,
707: p_commit => FND_API.G_FALSE,
708: p_profile_tbl => p_profile_tbl,
709: p_check_access_flag => p_check_access_flag,
710: p_admin_flag => p_admin_flag,
711: p_admin_group_id => p_admin_group_id,

Line 718: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

714: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
715: x_return_status => x_return_status,
716: x_msg_count => x_msg_count,
717: x_msg_data => x_msg_data);
718: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
719: RAISE fnd_api.g_exc_error;
720: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
721: RAISE fnd_api.g_exc_unexpected_error;
722: END IF;

Line 719: RAISE fnd_api.g_exc_error;

715: x_return_status => x_return_status,
716: x_msg_count => x_msg_count,
717: x_msg_data => x_msg_data);
718: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
719: RAISE fnd_api.g_exc_error;
720: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
721: RAISE fnd_api.g_exc_unexpected_error;
722: END IF;
723: */

Line 720: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

716: x_msg_count => x_msg_count,
717: x_msg_data => x_msg_data);
718: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
719: RAISE fnd_api.g_exc_error;
720: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
721: RAISE fnd_api.g_exc_unexpected_error;
722: END IF;
723: */
724:

Line 721: RAISE fnd_api.g_exc_unexpected_error;

717: x_msg_data => x_msg_data);
718: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
719: RAISE fnd_api.g_exc_error;
720: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
721: RAISE fnd_api.g_exc_unexpected_error;
722: END IF;
723: */
724:
725:

Line 728: IF x_return_status = FND_API.G_RET_STS_ERROR then

724:
725:
726:
727: -- Check return status from the above procedure call
728: IF x_return_status = FND_API.G_RET_STS_ERROR then
729: raise FND_API.G_EXC_ERROR;
730: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;

Line 729: raise FND_API.G_EXC_ERROR;

725:
726:
727: -- Check return status from the above procedure call
728: IF x_return_status = FND_API.G_RET_STS_ERROR then
729: raise FND_API.G_EXC_ERROR;
730: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:

Line 730: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

726:
727: -- Check return status from the above procedure call
728: IF x_return_status = FND_API.G_RET_STS_ERROR then
729: raise FND_API.G_EXC_ERROR;
730: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:
734: --

Line 731: raise FND_API.G_EXC_UNEXPECTED_ERROR;

727: -- Check return status from the above procedure call
728: IF x_return_status = FND_API.G_RET_STS_ERROR then
729: raise FND_API.G_EXC_ERROR;
730: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
731: raise FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:
734: --
735: -- End of API body

Line 739: IF FND_API.to_Boolean( p_commit )

735: -- End of API body
736: --
737:
738: -- Standard check for p_commit
739: IF FND_API.to_Boolean( p_commit )
740: THEN
741: COMMIT WORK;
742: END IF;
743:

Line 764: p_commit => FND_API.G_FALSE,

760: THEN
761: AS_task_part_VUHK.Delete_task_part_Post(
762: p_api_version_number => 1.0,
763: p_validation_level => p_validation_level,
764: p_commit => FND_API.G_FALSE,
765: p_profile_tbl => p_profile_tbl,
766: p_check_access_flag => p_check_access_flag,
767: p_admin_flag => p_admin_flag,
768: p_admin_group_id => p_admin_group_id,

Line 775: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

771: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
772: x_return_status => x_return_status,
773: x_msg_count => x_msg_count,
774: x_msg_data => x_msg_data);
775: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
776: RAISE fnd_api.g_exc_error;
777: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
778: RAISE fnd_api.g_exc_unexpected_error;
779: END IF;

Line 776: RAISE fnd_api.g_exc_error;

772: x_return_status => x_return_status,
773: x_msg_count => x_msg_count,
774: x_msg_data => x_msg_data);
775: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
776: RAISE fnd_api.g_exc_error;
777: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
778: RAISE fnd_api.g_exc_unexpected_error;
779: END IF;
780: END IF;

Line 777: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

773: x_msg_count => x_msg_count,
774: x_msg_data => x_msg_data);
775: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
776: RAISE fnd_api.g_exc_error;
777: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
778: RAISE fnd_api.g_exc_unexpected_error;
779: END IF;
780: END IF;
781: -- USER HOOKS standard : customer pre-processing section - mandatory

Line 778: RAISE fnd_api.g_exc_unexpected_error;

774: x_msg_data => x_msg_data);
775: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
776: RAISE fnd_api.g_exc_error;
777: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
778: RAISE fnd_api.g_exc_unexpected_error;
779: END IF;
780: END IF;
781: -- USER HOOKS standard : customer pre-processing section - mandatory
782: IF(JTF_USR_HKS.Ok_to_execute('AS_task_part_PUB', 'Delete_task_part','A','C'))

Line 787: p_commit => FND_API.G_FALSE,

783: THEN
784: AS_task_part_CUHK.Delete_task_part_Pre(
785: p_api_version_number => 1.0,
786: p_validation_level => p_validation_level,
787: p_commit => FND_API.G_FALSE,
788: p_profile_tbl => p_profile_tbl,
789: p_check_access_flag => p_check_access_flag,
790: p_admin_flag => p_admin_flag,
791: p_admin_group_id => p_admin_group_id,

Line 798: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

794: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
795: x_return_status => x_return_status,
796: x_msg_count => x_msg_count,
797: x_msg_data => x_msg_data);
798: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
799: RAISE fnd_api.g_exc_error;
800: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
801: RAISE fnd_api.g_exc_unexpected_error;
802: END IF;

Line 799: RAISE fnd_api.g_exc_error;

795: x_return_status => x_return_status,
796: x_msg_count => x_msg_count,
797: x_msg_data => x_msg_data);
798: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
799: RAISE fnd_api.g_exc_error;
800: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
801: RAISE fnd_api.g_exc_unexpected_error;
802: END IF;
803: END IF;

Line 800: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

796: x_msg_count => x_msg_count,
797: x_msg_data => x_msg_data);
798: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
799: RAISE fnd_api.g_exc_error;
800: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
801: RAISE fnd_api.g_exc_unexpected_error;
802: END IF;
803: END IF;
804: */

Line 801: RAISE fnd_api.g_exc_unexpected_error;

797: x_msg_data => x_msg_data);
798: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
799: RAISE fnd_api.g_exc_error;
800: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
801: RAISE fnd_api.g_exc_unexpected_error;
802: END IF;
803: END IF;
804: */
805: EXCEPTION

Line 806: WHEN FND_API.G_EXC_ERROR THEN

802: END IF;
803: END IF;
804: */
805: EXCEPTION
806: WHEN FND_API.G_EXC_ERROR THEN
807: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
808: P_API_NAME => L_API_NAME
809: ,P_PKG_NAME => G_PKG_NAME
810: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

812: ,X_MSG_COUNT => X_MSG_COUNT
813: ,X_MSG_DATA => X_MSG_DATA
814: ,X_RETURN_STATUS => X_RETURN_STATUS);
815:
816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
818: P_API_NAME => L_API_NAME
819: ,P_PKG_NAME => G_PKG_NAME
820: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 842: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

838:
839:
840: PROCEDURE Get_task_part(
841: P_Api_Version_Number IN NUMBER,
842: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
843: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
844: P_TASK_PART_Rec IN CSP_task_part_PUB.TASK_PART_Rec_Type,
845: -- Hint: Add list of bind variables here
846: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

Line 843: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

839:
840: PROCEDURE Get_task_part(
841: P_Api_Version_Number IN NUMBER,
842: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
843: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
844: P_TASK_PART_Rec IN CSP_task_part_PUB.TASK_PART_Rec_Type,
845: -- Hint: Add list of bind variables here
846: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
847: p_start_rec_prt IN NUMBER := 1,

Line 848: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

844: P_TASK_PART_Rec IN CSP_task_part_PUB.TASK_PART_Rec_Type,
845: -- Hint: Add list of bind variables here
846: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
847: p_start_rec_prt IN NUMBER := 1,
848: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
849: -- Hint: user defined record type
850: p_order_by_rec IN CSP_task_part_PUB.TASK_PART_sort_rec_type,
851: x_return_status OUT NOCOPY VARCHAR2,
852: x_msg_count OUT NOCOPY NUMBER,

Line 870: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

866: -- Standard Start of API savepoint
867: SAVEPOINT GET_TASK_PART_PUB;
868:
869: -- Standard call to check for call compatibility.
870: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
871: p_api_version_number,
872: l_api_name,
873: G_PKG_NAME)
874: THEN

Line 875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

871: p_api_version_number,
872: l_api_name,
873: G_PKG_NAME)
874: THEN
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
876: END IF;
877:
878:
879: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 880: IF FND_API.to_Boolean( p_init_msg_list )

876: END IF;
877:
878:
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean( p_init_msg_list )
881: THEN
882: FND_MSG_PUB.initialize;
883: END IF;
884:

Line 892: x_return_status := FND_API.G_RET_STS_SUCCESS;

888:
889: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Start time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
890:
891: -- Initialize API return status to SUCCESS
892: x_return_status := FND_API.G_RET_STS_SUCCESS;
893:
894: --
895: -- API body
896: --

Line 902: P_Init_Msg_List => FND_API.G_FALSE,

898: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'CSP','Public API: - Calling PVT.Get_TASK_PART');
899: /*
900: CSP_task_part_PVT.Get_task_part(
901: P_Api_Version_Number => 1.0,
902: P_Init_Msg_List => FND_API.G_FALSE,
903: p_validation_level => p_validation_level,
904: P_TASK_PART_Rec => P_TASK_PART_Rec,
905: p_rec_requested => p_rec_requested,
906: p_start_rec_prt => p_start_rec_prt,

Line 924: IF x_return_status = FND_API.G_RET_STS_ERROR then

920:
921:
922:
923: -- Check return status from the above procedure call
924: IF x_return_status = FND_API.G_RET_STS_ERROR then
925: raise FND_API.G_EXC_ERROR;
926: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
927: raise FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;

Line 925: raise FND_API.G_EXC_ERROR;

921:
922:
923: -- Check return status from the above procedure call
924: IF x_return_status = FND_API.G_RET_STS_ERROR then
925: raise FND_API.G_EXC_ERROR;
926: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
927: raise FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;
929: */

Line 926: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

922:
923: -- Check return status from the above procedure call
924: IF x_return_status = FND_API.G_RET_STS_ERROR then
925: raise FND_API.G_EXC_ERROR;
926: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
927: raise FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;
929: */
930: --

Line 927: raise FND_API.G_EXC_UNEXPECTED_ERROR;

923: -- Check return status from the above procedure call
924: IF x_return_status = FND_API.G_RET_STS_ERROR then
925: raise FND_API.G_EXC_ERROR;
926: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
927: raise FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;
929: */
930: --
931: -- End of API body

Line 946: WHEN FND_API.G_EXC_ERROR THEN

942: p_data => x_msg_data
943: );
944:
945: EXCEPTION
946: WHEN FND_API.G_EXC_ERROR THEN
947: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
948: P_API_NAME => L_API_NAME
949: ,P_PKG_NAME => G_PKG_NAME
950: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

952: ,X_MSG_COUNT => X_MSG_COUNT
953: ,X_MSG_DATA => X_MSG_DATA
954: ,X_RETURN_STATUS => X_RETURN_STATUS);
955:
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
958: P_API_NAME => L_API_NAME
959: ,P_PKG_NAME => G_PKG_NAME
960: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR