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_MODULE_GROUPS_PUB dependencies on FND_API

Line 43: raise FND_API.G_EXC_ERROR;

39:
40: -- If there is an error in conversion precessing, raise an error.
41: IF l_any_errors
42: THEN
43: raise FND_API.G_EXC_ERROR;
44: END IF;
45:
46: END Convert_pub_to_pvt_Rec;
47:

Line 174: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

170: -- Standard Start of API savepoint
171: SAVEPOINT CREATE_PROF_MODULE_GROUPS_PUB;
172:
173: -- Standard call to check for call compatibility.
174: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
175: p_api_version_number,
176: l_api_name,
177: G_PKG_NAME)
178: THEN

Line 179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

175: p_api_version_number,
176: l_api_name,
177: G_PKG_NAME)
178: THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181:
182:
183: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 184: IF FND_API.to_Boolean( p_init_msg_list )

180: END IF;
181:
182:
183: -- Initialize message list if p_init_msg_list is set to TRUE.
184: IF FND_API.to_Boolean( p_init_msg_list )
185: THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:

Line 192: x_return_status := FND_API.G_RET_STS_SUCCESS;

188:
189:
190:
191: -- Initialize API return status to SUCCESS
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193:
194: --
195: -- API body
196: --

Line 209: P_Init_Msg_List => FND_API.G_FALSE,

205: -- Calling Private package: Create_PROF_MODULE_GROUPS
206: -- Hint: Primary key needs to be returned
207: CSC_prof_module_groups_PVT.Create_prof_module_groups(
208: P_Api_Version_Number => 2.0,
209: P_Init_Msg_List => FND_API.G_FALSE,
210: P_Commit => FND_API.G_FALSE,
211: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
212: P_PROF_MODULE_GRP_Rec => l_pvt_PROF_MODULE_GRP_Rec ,
213: PX_MODULE_GROUP_ID => px_MODULE_GROUP_ID,

Line 210: P_Commit => FND_API.G_FALSE,

206: -- Hint: Primary key needs to be returned
207: CSC_prof_module_groups_PVT.Create_prof_module_groups(
208: P_Api_Version_Number => 2.0,
209: P_Init_Msg_List => FND_API.G_FALSE,
210: P_Commit => FND_API.G_FALSE,
211: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
212: P_PROF_MODULE_GRP_Rec => l_pvt_PROF_MODULE_GRP_Rec ,
213: PX_MODULE_GROUP_ID => px_MODULE_GROUP_ID,
214: X_Return_Status => x_return_status,

Line 211: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

207: CSC_prof_module_groups_PVT.Create_prof_module_groups(
208: P_Api_Version_Number => 2.0,
209: P_Init_Msg_List => FND_API.G_FALSE,
210: P_Commit => FND_API.G_FALSE,
211: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
212: P_PROF_MODULE_GRP_Rec => l_pvt_PROF_MODULE_GRP_Rec ,
213: PX_MODULE_GROUP_ID => px_MODULE_GROUP_ID,
214: X_Return_Status => x_return_status,
215: X_Msg_Count => x_msg_count,

Line 221: IF x_return_status = FND_API.G_RET_STS_ERROR then

217:
218:
219:
220: -- Check return status from the above procedure call
221: IF x_return_status = FND_API.G_RET_STS_ERROR then
222: raise FND_API.G_EXC_ERROR;
223: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
224: raise FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;

Line 222: raise FND_API.G_EXC_ERROR;

218:
219:
220: -- Check return status from the above procedure call
221: IF x_return_status = FND_API.G_RET_STS_ERROR then
222: raise FND_API.G_EXC_ERROR;
223: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
224: raise FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:

Line 223: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

219:
220: -- Check return status from the above procedure call
221: IF x_return_status = FND_API.G_RET_STS_ERROR then
222: raise FND_API.G_EXC_ERROR;
223: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
224: raise FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: --

Line 224: raise FND_API.G_EXC_UNEXPECTED_ERROR;

220: -- Check return status from the above procedure call
221: IF x_return_status = FND_API.G_RET_STS_ERROR then
222: raise FND_API.G_EXC_ERROR;
223: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
224: raise FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: --
228: -- End of API body.

Line 232: IF FND_API.to_Boolean( p_commit )

228: -- End of API body.
229: --
230:
231: -- Standard check for p_commit
232: IF FND_API.to_Boolean( p_commit )
233: THEN
234: COMMIT WORK;
235: END IF;
236:

Line 246: WHEN FND_API.G_EXC_ERROR THEN

242: p_data => x_msg_data
243: );
244:
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
248: x_return_status := FND_API.G_RET_STS_ERROR ;
249: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
250: p_data => x_msg_data) ;

Line 248: x_return_status := FND_API.G_RET_STS_ERROR ;

244:
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
248: x_return_status := FND_API.G_RET_STS_ERROR ;
249: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
250: p_data => x_msg_data) ;
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

248: x_return_status := FND_API.G_RET_STS_ERROR ;
249: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
250: p_data => x_msg_data) ;
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
255: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
256: p_data => x_msg_data) ;

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

250: p_data => x_msg_data) ;
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
255: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
256: p_data => x_msg_data) ;
257:
258: WHEN OTHERS THEN

Line 260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

256: p_data => x_msg_data) ;
257:
258: WHEN OTHERS THEN
259: ROLLBACK TO CREATE_PROF_MODULE_GROUPS_PUB;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
261: IF FND_MSG_PUB.Check_Msg_Level
262: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
263: THEN
264: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

348: -- Standard Start of API savepoint
349: SAVEPOINT UPDATE_PROF_MODULE_GROUPS_PUB;
350:
351: -- Standard call to check for call compatibility.
352: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
353: p_api_version_number,
354: l_api_name,
355: G_PKG_NAME)
356: THEN

Line 357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

353: p_api_version_number,
354: l_api_name,
355: G_PKG_NAME)
356: THEN
357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
358: END IF;
359:
360:
361: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 362: IF FND_API.to_Boolean( p_init_msg_list )

358: END IF;
359:
360:
361: -- Initialize message list if p_init_msg_list is set to TRUE.
362: IF FND_API.to_Boolean( p_init_msg_list )
363: THEN
364: FND_MSG_PUB.initialize;
365: END IF;
366:

Line 370: x_return_status := FND_API.G_RET_STS_SUCCESS;

366:
367:
368:
369: -- Initialize API return status to SUCCESS
370: x_return_status := FND_API.G_RET_STS_SUCCESS;
371:
372: --
373: -- API body
374: --

Line 385: P_Init_Msg_List => FND_API.G_FALSE,

381: );
382:
383: CSC_prof_module_groups_PVT.Update_prof_module_groups(
384: P_Api_Version_Number => 1.0,
385: P_Init_Msg_List => FND_API.G_FALSE,
386: P_Commit => p_commit,
387: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
388: P_PROF_MODULE_GRP_Rec => l_pvt_PROF_MODULE_GRP_Rec ,
389: X_Return_Status => x_return_status,

Line 387: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

383: CSC_prof_module_groups_PVT.Update_prof_module_groups(
384: P_Api_Version_Number => 1.0,
385: P_Init_Msg_List => FND_API.G_FALSE,
386: P_Commit => p_commit,
387: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
388: P_PROF_MODULE_GRP_Rec => l_pvt_PROF_MODULE_GRP_Rec ,
389: X_Return_Status => x_return_status,
390: X_Msg_Count => x_msg_count,
391: X_Msg_Data => x_msg_data);

Line 396: IF x_return_status = FND_API.G_RET_STS_ERROR then

392:
393:
394:
395: -- Check return status from the above procedure call
396: IF x_return_status = FND_API.G_RET_STS_ERROR then
397: raise FND_API.G_EXC_ERROR;
398: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
399: raise FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;

Line 397: raise FND_API.G_EXC_ERROR;

393:
394:
395: -- Check return status from the above procedure call
396: IF x_return_status = FND_API.G_RET_STS_ERROR then
397: raise FND_API.G_EXC_ERROR;
398: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
399: raise FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401:

Line 398: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

394:
395: -- Check return status from the above procedure call
396: IF x_return_status = FND_API.G_RET_STS_ERROR then
397: raise FND_API.G_EXC_ERROR;
398: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
399: raise FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401:
402: --

Line 399: raise FND_API.G_EXC_UNEXPECTED_ERROR;

395: -- Check return status from the above procedure call
396: IF x_return_status = FND_API.G_RET_STS_ERROR then
397: raise FND_API.G_EXC_ERROR;
398: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
399: raise FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401:
402: --
403: -- End of API body

Line 407: IF FND_API.to_Boolean( p_commit )

403: -- End of API body
404: --
405:
406: -- Standard check for p_commit
407: IF FND_API.to_Boolean( p_commit )
408: THEN
409: COMMIT WORK;
410: END IF;
411:

Line 421: WHEN FND_API.G_EXC_ERROR THEN

417: p_data => x_msg_data
418: );
419:
420: EXCEPTION
421: WHEN FND_API.G_EXC_ERROR THEN
422: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;
423: x_return_status := FND_API.G_RET_STS_ERROR ;
424: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
425: p_data => x_msg_data) ;

Line 423: x_return_status := FND_API.G_RET_STS_ERROR ;

419:
420: EXCEPTION
421: WHEN FND_API.G_EXC_ERROR THEN
422: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;
423: x_return_status := FND_API.G_RET_STS_ERROR ;
424: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
425: p_data => x_msg_data) ;
426:
427:

Line 428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

424: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
425: p_data => x_msg_data) ;
426:
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
431: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
432: p_data => x_msg_data) ;

Line 430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

426:
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
431: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
432: p_data => x_msg_data) ;
433:
434: WHEN OTHERS THEN

Line 436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

432: p_data => x_msg_data) ;
433:
434: WHEN OTHERS THEN
435: ROLLBACK TO UPDATE_PROF_MODULE_GROUPS_PUB;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
437: IF FND_MSG_PUB.Check_Msg_Level
438: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
439: THEN
440: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 467: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

463: -- Standard Start of API savepoint
464: SAVEPOINT DELETE_PROF_MODULE_GROUPS_PUB;
465:
466: -- Standard call to check for call compatibility.
467: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
468: p_api_version_number,
469: l_api_name,
470: G_PKG_NAME)
471: THEN

Line 472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

468: p_api_version_number,
469: l_api_name,
470: G_PKG_NAME)
471: THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474:
475:
476: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 477: IF FND_API.to_Boolean( p_init_msg_list )

473: END IF;
474:
475:
476: -- Initialize message list if p_init_msg_list is set to TRUE.
477: IF FND_API.to_Boolean( p_init_msg_list )
478: THEN
479: FND_MSG_PUB.initialize;
480: END IF;
481:

Line 485: x_return_status := FND_API.G_RET_STS_SUCCESS;

481:
482:
483:
484: -- Initialize API return status to SUCCESS
485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486:
487: --
488: -- API body
489: --

Line 501: P_Init_Msg_List => FND_API.G_FALSE,

497: -- Convert the values to ids
498: --
499: CSC_prof_module_groups_PVT.Delete_prof_module_groups(
500: P_Api_Version_Number => 1.0,
501: P_Init_Msg_List => FND_API.G_FALSE,
502: P_Commit => p_commit,
503: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
504: P_PROF_MODULE_GRP_Id => l_pvt_PROF_MODULE_GRP_Rec.module_group_id,
505: X_Return_Status => x_return_status,

Line 503: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

499: CSC_prof_module_groups_PVT.Delete_prof_module_groups(
500: P_Api_Version_Number => 1.0,
501: P_Init_Msg_List => FND_API.G_FALSE,
502: P_Commit => p_commit,
503: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
504: P_PROF_MODULE_GRP_Id => l_pvt_PROF_MODULE_GRP_Rec.module_group_id,
505: X_Return_Status => x_return_status,
506: X_Msg_Count => x_msg_count,
507: X_Msg_Data => x_msg_data);

Line 512: IF x_return_status = FND_API.G_RET_STS_ERROR then

508:
509:
510:
511: -- Check return status from the above procedure call
512: IF x_return_status = FND_API.G_RET_STS_ERROR then
513: raise FND_API.G_EXC_ERROR;
514: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
515: raise FND_API.G_EXC_UNEXPECTED_ERROR;
516: END IF;

Line 513: raise FND_API.G_EXC_ERROR;

509:
510:
511: -- Check return status from the above procedure call
512: IF x_return_status = FND_API.G_RET_STS_ERROR then
513: raise FND_API.G_EXC_ERROR;
514: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
515: raise FND_API.G_EXC_UNEXPECTED_ERROR;
516: END IF;
517:

Line 514: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

510:
511: -- Check return status from the above procedure call
512: IF x_return_status = FND_API.G_RET_STS_ERROR then
513: raise FND_API.G_EXC_ERROR;
514: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
515: raise FND_API.G_EXC_UNEXPECTED_ERROR;
516: END IF;
517:
518: --

Line 515: raise FND_API.G_EXC_UNEXPECTED_ERROR;

511: -- Check return status from the above procedure call
512: IF x_return_status = FND_API.G_RET_STS_ERROR then
513: raise FND_API.G_EXC_ERROR;
514: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
515: raise FND_API.G_EXC_UNEXPECTED_ERROR;
516: END IF;
517:
518: --
519: -- End of API body

Line 523: IF FND_API.to_Boolean( p_commit )

519: -- End of API body
520: --
521:
522: -- Standard check for p_commit
523: IF FND_API.to_Boolean( p_commit )
524: THEN
525: COMMIT WORK;
526: END IF;
527:

Line 537: WHEN FND_API.G_EXC_ERROR THEN

533: p_data => x_msg_data
534: );
535:
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535:
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );

Line 545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: FND_MSG_PUB.Count_And_Get
549: ( p_count => x_msg_count,

Line 547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

543: );
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: FND_MSG_PUB.Count_And_Get
549: ( p_count => x_msg_count,
550: p_data => x_msg_data
551: );

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

551: );
552:
553: WHEN OTHERS THEN
554: ROLLBACK TO DELETE_PROF_MODULE_GROUPS_PUB;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
557: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
558: END IF;
559: FND_MSG_PUB.Count_And_Get