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.CSC_PROF_GROUP_CAT_PUB dependencies on FND_API

Line 39: raise FND_API.G_EXC_ERROR;

35:
36: -- If there is an error in conversion precessing, raise an error.
37: IF l_any_errors
38: THEN
39: raise FND_API.G_EXC_ERROR;
40: END IF;
41:
42: END Convert_pub_to_pvt_Rec;
43:

Line 146: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

142: -- Standard Start of API savepoint
143: SAVEPOINT CREATE_CSC_PROF_GROUP_CAT_PUB;
144:
145: -- Standard call to check for call compatibility.
146: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
147: p_api_version_number,
148: l_api_name,
149: G_PKG_NAME)
150: THEN

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

147: p_api_version_number,
148: l_api_name,
149: G_PKG_NAME)
150: THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153:
154:
155: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 156: IF FND_API.to_Boolean( p_init_msg_list )

152: END IF;
153:
154:
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list )
157: THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160:

Line 163: x_return_status := FND_API.G_RET_STS_SUCCESS;

159: END IF;
160:
161:
162: -- Initialize API return status to SUCCESS
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: --
166: -- API body
167: --

Line 181: P_Init_Msg_List => FND_API.G_FALSE,

177: -- Calling Private package: Create_CSC_PROF_GROUP_CAT
178: -- Hint: Primary key needs to be returned
179: csc_prof_group_cat_PVT.Create_csc_prof_group_cat(
180: P_Api_Version_Number => 1.0,
181: P_Init_Msg_List => FND_API.G_FALSE,
182: P_Commit => FND_API.G_FALSE,
183: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
184: P_PROF_GRP_CAT_Rec => l_pvt_PROF_GRP_CAT_Rec ,
185: PX_GROUP_CATEGORY_ID => Px_GROUP_CATEGORY_ID,

Line 182: P_Commit => FND_API.G_FALSE,

178: -- Hint: Primary key needs to be returned
179: csc_prof_group_cat_PVT.Create_csc_prof_group_cat(
180: P_Api_Version_Number => 1.0,
181: P_Init_Msg_List => FND_API.G_FALSE,
182: P_Commit => FND_API.G_FALSE,
183: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
184: P_PROF_GRP_CAT_Rec => l_pvt_PROF_GRP_CAT_Rec ,
185: PX_GROUP_CATEGORY_ID => Px_GROUP_CATEGORY_ID,
186: X_Return_Status => x_return_status,

Line 183: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

179: csc_prof_group_cat_PVT.Create_csc_prof_group_cat(
180: P_Api_Version_Number => 1.0,
181: P_Init_Msg_List => FND_API.G_FALSE,
182: P_Commit => FND_API.G_FALSE,
183: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
184: P_PROF_GRP_CAT_Rec => l_pvt_PROF_GRP_CAT_Rec ,
185: PX_GROUP_CATEGORY_ID => Px_GROUP_CATEGORY_ID,
186: X_Return_Status => x_return_status,
187: X_Msg_Count => x_msg_count,

Line 193: IF x_return_status = FND_API.G_RET_STS_ERROR then

189:
190:
191:
192: -- Check return status from the above procedure call
193: IF x_return_status = FND_API.G_RET_STS_ERROR then
194: raise FND_API.G_EXC_ERROR;
195: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
196: raise FND_API.G_EXC_UNEXPECTED_ERROR;
197: END IF;

Line 194: raise FND_API.G_EXC_ERROR;

190:
191:
192: -- Check return status from the above procedure call
193: IF x_return_status = FND_API.G_RET_STS_ERROR then
194: raise FND_API.G_EXC_ERROR;
195: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
196: raise FND_API.G_EXC_UNEXPECTED_ERROR;
197: END IF;
198:

Line 195: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

191:
192: -- Check return status from the above procedure call
193: IF x_return_status = FND_API.G_RET_STS_ERROR then
194: raise FND_API.G_EXC_ERROR;
195: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
196: raise FND_API.G_EXC_UNEXPECTED_ERROR;
197: END IF;
198:
199: --

Line 196: raise FND_API.G_EXC_UNEXPECTED_ERROR;

192: -- Check return status from the above procedure call
193: IF x_return_status = FND_API.G_RET_STS_ERROR then
194: raise FND_API.G_EXC_ERROR;
195: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
196: raise FND_API.G_EXC_UNEXPECTED_ERROR;
197: END IF;
198:
199: --
200: -- End of API body.

Line 204: IF FND_API.to_Boolean( p_commit )

200: -- End of API body.
201: --
202:
203: -- Standard check for p_commit
204: IF FND_API.to_Boolean( p_commit )
205: THEN
206: COMMIT WORK;
207: END IF;
208:

Line 218: WHEN FND_API.G_EXC_ERROR THEN

214: p_data => x_msg_data
215: );
216:
217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
222: p_data => x_msg_data) ;

Line 220: x_return_status := FND_API.G_RET_STS_ERROR ;

216:
217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
222: p_data => x_msg_data) ;
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
222: p_data => x_msg_data) ;
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
228: p_data => x_msg_data) ;

Line 226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

222: p_data => x_msg_data) ;
223:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
228: p_data => x_msg_data) ;
229:
230: WHEN OTHERS THEN

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

228: p_data => x_msg_data) ;
229:
230: WHEN OTHERS THEN
231: ROLLBACK TO CREATE_CSC_PROF_GROUP_CAT_PUB;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: IF FND_MSG_PUB.Check_Msg_Level
234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 314: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

310: -- Standard Start of API savepoint
311: SAVEPOINT UPDATE_CSC_PROF_GROUP_CAT_PUB;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
315: p_api_version_number,
316: l_api_name,
317: G_PKG_NAME)
318: THEN

Line 319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

315: p_api_version_number,
316: l_api_name,
317: G_PKG_NAME)
318: THEN
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321:
322:
323: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 324: IF FND_API.to_Boolean( p_init_msg_list )

320: END IF;
321:
322:
323: -- Initialize message list if p_init_msg_list is set to TRUE.
324: IF FND_API.to_Boolean( p_init_msg_list )
325: THEN
326: FND_MSG_PUB.initialize;
327: END IF;
328:

Line 332: x_return_status := FND_API.G_RET_STS_SUCCESS;

328:
329:
330:
331: -- Initialize API return status to SUCCESS
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:
334: --
335: -- API body
336: --

Line 347: P_Init_Msg_List => FND_API.G_FALSE,

343: );
344:
345: csc_prof_group_cat_PVT.Update_csc_prof_group_cat(
346: P_Api_Version_Number => 1.0,
347: P_Init_Msg_List => FND_API.G_FALSE,
348: P_Commit => p_commit,
349: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
350: P_PROF_GRP_CAT_Rec => l_pvt_PROF_GRP_CAT_Rec ,
351: X_Return_Status => x_return_status,

Line 349: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

345: csc_prof_group_cat_PVT.Update_csc_prof_group_cat(
346: P_Api_Version_Number => 1.0,
347: P_Init_Msg_List => FND_API.G_FALSE,
348: P_Commit => p_commit,
349: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
350: P_PROF_GRP_CAT_Rec => l_pvt_PROF_GRP_CAT_Rec ,
351: X_Return_Status => x_return_status,
352: X_Msg_Count => x_msg_count,
353: X_Msg_Data => x_msg_data);

Line 358: IF x_return_status = FND_API.G_RET_STS_ERROR then

354:
355:
356:
357: -- Check return status from the above procedure call
358: IF x_return_status = FND_API.G_RET_STS_ERROR then
359: raise FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: raise FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;

Line 359: raise FND_API.G_EXC_ERROR;

355:
356:
357: -- Check return status from the above procedure call
358: IF x_return_status = FND_API.G_RET_STS_ERROR then
359: raise FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: raise FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:

Line 360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

356:
357: -- Check return status from the above procedure call
358: IF x_return_status = FND_API.G_RET_STS_ERROR then
359: raise FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: raise FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:
364: --

Line 361: raise FND_API.G_EXC_UNEXPECTED_ERROR;

357: -- Check return status from the above procedure call
358: IF x_return_status = FND_API.G_RET_STS_ERROR then
359: raise FND_API.G_EXC_ERROR;
360: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
361: raise FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363:
364: --
365: -- End of API body

Line 369: IF FND_API.to_Boolean( p_commit )

365: -- End of API body
366: --
367:
368: -- Standard check for p_commit
369: IF FND_API.to_Boolean( p_commit )
370: THEN
371: COMMIT WORK;
372: END IF;
373:

Line 383: WHEN FND_API.G_EXC_ERROR THEN

379: p_data => x_msg_data
380: );
381:
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
387: p_data => x_msg_data) ;

Line 385: x_return_status := FND_API.G_RET_STS_ERROR ;

381:
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
387: p_data => x_msg_data) ;
388:
389:

Line 390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

386: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
387: p_data => x_msg_data) ;
388:
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
394: p_data => x_msg_data) ;

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

388:
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
394: p_data => x_msg_data) ;
395:
396: WHEN OTHERS THEN

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

394: p_data => x_msg_data) ;
395:
396: WHEN OTHERS THEN
397: ROLLBACK TO UPDATE_CSC_PROF_GROUP_CAT_PUB;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: IF FND_MSG_PUB.Check_Msg_Level
400: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 431: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

427: -- Standard Start of API savepoint
428: SAVEPOINT DELETE_CSC_PROF_GROUP_CAT_PUB;
429:
430: -- Standard call to check for call compatibility.
431: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
432: p_api_version_number,
433: l_api_name,
434: G_PKG_NAME)
435: THEN

Line 436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

432: p_api_version_number,
433: l_api_name,
434: G_PKG_NAME)
435: THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439:
440: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 441: IF FND_API.to_Boolean( p_init_msg_list )

437: END IF;
438:
439:
440: -- Initialize message list if p_init_msg_list is set to TRUE.
441: IF FND_API.to_Boolean( p_init_msg_list )
442: THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445:
446:
447:
448: -- Initialize API return status to SUCCESS
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: --
452: -- API body
453: --

Line 463: P_Init_Msg_List => FND_API.G_FALSE,

459: );
460:
461: csc_prof_group_cat_PVT.Delete_csc_prof_group_cat(
462: P_Api_Version_Number => 1.0,
463: P_Init_Msg_List => FND_API.G_FALSE,
464: P_Commit => p_commit,
465: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
466: P_PROF_GRP_CAT_Rec => l_pvt_PROF_GRP_CAT_Rec,
467: X_Return_Status => x_return_status,

Line 465: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

461: csc_prof_group_cat_PVT.Delete_csc_prof_group_cat(
462: P_Api_Version_Number => 1.0,
463: P_Init_Msg_List => FND_API.G_FALSE,
464: P_Commit => p_commit,
465: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
466: P_PROF_GRP_CAT_Rec => l_pvt_PROF_GRP_CAT_Rec,
467: X_Return_Status => x_return_status,
468: X_Msg_Count => x_msg_count,
469: X_Msg_Data => x_msg_data);

Line 474: IF x_return_status = FND_API.G_RET_STS_ERROR then

470:
471:
472:
473: -- Check return status from the above procedure call
474: IF x_return_status = FND_API.G_RET_STS_ERROR then
475: raise FND_API.G_EXC_ERROR;
476: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
477: raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;

Line 475: raise FND_API.G_EXC_ERROR;

471:
472:
473: -- Check return status from the above procedure call
474: IF x_return_status = FND_API.G_RET_STS_ERROR then
475: raise FND_API.G_EXC_ERROR;
476: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
477: raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:

Line 476: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

472:
473: -- Check return status from the above procedure call
474: IF x_return_status = FND_API.G_RET_STS_ERROR then
475: raise FND_API.G_EXC_ERROR;
476: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
477: raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:
480: --

Line 477: raise FND_API.G_EXC_UNEXPECTED_ERROR;

473: -- Check return status from the above procedure call
474: IF x_return_status = FND_API.G_RET_STS_ERROR then
475: raise FND_API.G_EXC_ERROR;
476: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
477: raise FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:
480: --
481: -- End of API body

Line 485: IF FND_API.to_Boolean( p_commit )

481: -- End of API body
482: --
483:
484: -- Standard check for p_commit
485: IF FND_API.to_Boolean( p_commit )
486: THEN
487: COMMIT WORK;
488: END IF;
489:

Line 499: WHEN FND_API.G_EXC_ERROR THEN

495: p_data => x_msg_data
496: );
497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
501: x_return_status := FND_API.G_RET_STS_ERROR ;
502: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
503: p_data => x_msg_data) ;

Line 501: x_return_status := FND_API.G_RET_STS_ERROR ;

497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
501: x_return_status := FND_API.G_RET_STS_ERROR ;
502: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
503: p_data => x_msg_data) ;
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

501: x_return_status := FND_API.G_RET_STS_ERROR ;
502: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
503: p_data => x_msg_data) ;
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
508: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
509: p_data => x_msg_data) ;

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

503: p_data => x_msg_data) ;
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
508: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
509: p_data => x_msg_data) ;
510:
511: WHEN OTHERS THEN

Line 513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

509: p_data => x_msg_data) ;
510:
511: WHEN OTHERS THEN
512: ROLLBACK TO DELETE_CSC_PROF_GROUP_CAT_PUB;
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
514: IF FND_MSG_PUB.Check_Msg_Level
515: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
516: THEN
517: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);