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

Line 161: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

157: -- Standard Start of API savepoint
158: SAVEPOINT CREATE_PROFILE_GROUPS_PUB;
159:
160: -- Standard call to check for call compatibility.
161: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
162: p_api_version_number,
163: l_api_name,
164: G_PKG_NAME)
165: THEN

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162: p_api_version_number,
163: l_api_name,
164: G_PKG_NAME)
165: THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: END IF;
168:
169:
170: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 171: IF FND_API.to_Boolean( p_init_msg_list )

167: END IF;
168:
169:
170: -- Initialize message list if p_init_msg_list is set to TRUE.
171: IF FND_API.to_Boolean( p_init_msg_list )
172: THEN
173: FND_MSG_PUB.initialize;
174: END IF;
175:

Line 178: x_return_status := FND_API.G_RET_STS_SUCCESS;

174: END IF;
175:
176:
177: -- Initialize API return status to SUCCESS
178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: --
181: -- API body
182: --

Line 205: IF x_return_status = FND_API.G_RET_STS_ERROR then

201:
202:
203:
204: -- Check return status from the above procedure call
205: IF x_return_status = FND_API.G_RET_STS_ERROR then
206: raise FND_API.G_EXC_ERROR;
207: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
208: raise FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;

Line 206: raise FND_API.G_EXC_ERROR;

202:
203:
204: -- Check return status from the above procedure call
205: IF x_return_status = FND_API.G_RET_STS_ERROR then
206: raise FND_API.G_EXC_ERROR;
207: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
208: raise FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:

Line 207: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

203:
204: -- Check return status from the above procedure call
205: IF x_return_status = FND_API.G_RET_STS_ERROR then
206: raise FND_API.G_EXC_ERROR;
207: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
208: raise FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:
211: --

Line 208: raise FND_API.G_EXC_UNEXPECTED_ERROR;

204: -- Check return status from the above procedure call
205: IF x_return_status = FND_API.G_RET_STS_ERROR then
206: raise FND_API.G_EXC_ERROR;
207: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
208: raise FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:
211: --
212: -- End of API body.

Line 216: IF FND_API.to_Boolean( p_commit )

212: -- End of API body.
213: --
214:
215: -- Standard check for p_commit
216: IF FND_API.to_Boolean( p_commit )
217: THEN
218: COMMIT WORK;
219: END IF;
220:

Line 230: WHEN FND_API.G_EXC_ERROR THEN

226: p_data => x_msg_data
227: );
228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO Create_profile_groups_PUB;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: FND_MSG_PUB.Count_And_Get
234: ( p_count => x_msg_count,

Line 232: x_return_status := FND_API.G_RET_STS_ERROR;

228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO Create_profile_groups_PUB;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: FND_MSG_PUB.Count_And_Get
234: ( p_count => x_msg_count,
235: p_data => x_msg_data
236: );

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

233: FND_MSG_PUB.Count_And_Get
234: ( p_count => x_msg_count,
235: p_data => x_msg_data
236: );
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO Create_profile_groups_PUB;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count,

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: p_data => x_msg_data
236: );
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO Create_profile_groups_PUB;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count,
242: p_data => x_msg_data
243: );

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242: p_data => x_msg_data
243: );
244: WHEN OTHERS THEN
245: ROLLBACK TO Create_profile_groups_PUB;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
248: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
249: END IF;
250: FND_MSG_PUB.Count_And_Get

Line 335: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

331: -- Standard Start of API savepoint
332: SAVEPOINT UPDATE_PROFILE_GROUPS_PUB;
333:
334: -- Standard call to check for call compatibility.
335: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
336: p_api_version_number,
337: l_api_name,
338: G_PKG_NAME)
339: THEN

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336: p_api_version_number,
337: l_api_name,
338: G_PKG_NAME)
339: THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343:
344: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 345: IF FND_API.to_Boolean( p_init_msg_list )

341: END IF;
342:
343:
344: -- Initialize message list if p_init_msg_list is set to TRUE.
345: IF FND_API.to_Boolean( p_init_msg_list )
346: THEN
347: FND_MSG_PUB.initialize;
348: END IF;
349:

Line 353: x_return_status := FND_API.G_RET_STS_SUCCESS;

349:
350:
351:
352: -- Initialize API return status to SUCCESS
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354:
355: --
356: -- API body
357: --

Line 377: IF x_return_status = FND_API.G_RET_STS_ERROR then

373:
374:
375:
376: -- Check return status from the above procedure call
377: IF x_return_status = FND_API.G_RET_STS_ERROR then
378: raise FND_API.G_EXC_ERROR;
379: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
380: raise FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;

Line 378: raise FND_API.G_EXC_ERROR;

374:
375:
376: -- Check return status from the above procedure call
377: IF x_return_status = FND_API.G_RET_STS_ERROR then
378: raise FND_API.G_EXC_ERROR;
379: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
380: raise FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382:

Line 379: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

375:
376: -- Check return status from the above procedure call
377: IF x_return_status = FND_API.G_RET_STS_ERROR then
378: raise FND_API.G_EXC_ERROR;
379: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
380: raise FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382:
383: --

Line 380: raise FND_API.G_EXC_UNEXPECTED_ERROR;

376: -- Check return status from the above procedure call
377: IF x_return_status = FND_API.G_RET_STS_ERROR then
378: raise FND_API.G_EXC_ERROR;
379: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
380: raise FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382:
383: --
384: -- End of API body

Line 388: IF FND_API.to_Boolean( p_commit )

384: -- End of API body
385: --
386:
387: -- Standard check for p_commit
388: IF FND_API.to_Boolean( p_commit )
389: THEN
390: COMMIT WORK;
391: END IF;
392:

Line 402: WHEN FND_API.G_EXC_ERROR THEN

398: p_data => x_msg_data
399: );
400:
401: EXCEPTION
402: WHEN FND_API.G_EXC_ERROR THEN
403: ROLLBACK TO Update_profile_groups_PUB;
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: FND_MSG_PUB.Count_And_Get
406: ( p_count => x_msg_count,

Line 404: x_return_status := FND_API.G_RET_STS_ERROR;

400:
401: EXCEPTION
402: WHEN FND_API.G_EXC_ERROR THEN
403: ROLLBACK TO Update_profile_groups_PUB;
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: FND_MSG_PUB.Count_And_Get
406: ( p_count => x_msg_count,
407: p_data => x_msg_data
408: );

Line 409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

405: FND_MSG_PUB.Count_And_Get
406: ( p_count => x_msg_count,
407: p_data => x_msg_data
408: );
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK TO Update_profile_groups_PUB;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count,

Line 411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

407: p_data => x_msg_data
408: );
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: ROLLBACK TO Update_profile_groups_PUB;
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: FND_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count,
414: p_data => x_msg_data
415: );

Line 418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

414: p_data => x_msg_data
415: );
416: WHEN OTHERS THEN
417: ROLLBACK TO Update_profile_groups_PUB;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
420: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
421: END IF;
422: FND_MSG_PUB.Count_And_Get

Line 449: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

445: -- Standard Start of API savepoint
446: SAVEPOINT DELETE_PROFILE_GROUPS_PUB;
447:
448: -- Standard call to check for call compatibility.
449: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
450: p_api_version_number,
451: l_api_name,
452: G_PKG_NAME)
453: THEN

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450: p_api_version_number,
451: l_api_name,
452: G_PKG_NAME)
453: THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457:
458: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 459: IF FND_API.to_Boolean( p_init_msg_list )

455: END IF;
456:
457:
458: -- Initialize message list if p_init_msg_list is set to TRUE.
459: IF FND_API.to_Boolean( p_init_msg_list )
460: THEN
461: FND_MSG_PUB.initialize;
462: END IF;
463:

Line 467: x_return_status := FND_API.G_RET_STS_SUCCESS;

463:
464:
465:
466: -- Initialize API return status to SUCCESS
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
468:
469: --
470: -- API body
471: --

Line 488: IF x_return_status = FND_API.G_RET_STS_ERROR then

484:
485:
486:
487: -- Check return status from the above procedure call
488: IF x_return_status = FND_API.G_RET_STS_ERROR then
489: raise FND_API.G_EXC_ERROR;
490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;

Line 489: raise FND_API.G_EXC_ERROR;

485:
486:
487: -- Check return status from the above procedure call
488: IF x_return_status = FND_API.G_RET_STS_ERROR then
489: raise FND_API.G_EXC_ERROR;
490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:

Line 490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

486:
487: -- Check return status from the above procedure call
488: IF x_return_status = FND_API.G_RET_STS_ERROR then
489: raise FND_API.G_EXC_ERROR;
490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: --

Line 491: raise FND_API.G_EXC_UNEXPECTED_ERROR;

487: -- Check return status from the above procedure call
488: IF x_return_status = FND_API.G_RET_STS_ERROR then
489: raise FND_API.G_EXC_ERROR;
490: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
491: raise FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: --
495: -- End of API body

Line 499: IF FND_API.to_Boolean( p_commit )

495: -- End of API body
496: --
497:
498: -- Standard check for p_commit
499: IF FND_API.to_Boolean( p_commit )
500: THEN
501: COMMIT WORK;
502: END IF;
503:

Line 512: WHEN FND_API.G_EXC_ERROR THEN

508: p_data => x_msg_data
509: );
510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO Delete_profile_groups_PUB;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: FND_MSG_PUB.Count_And_Get
516: ( p_count => x_msg_count,

Line 514: x_return_status := FND_API.G_RET_STS_ERROR;

510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO Delete_profile_groups_PUB;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: FND_MSG_PUB.Count_And_Get
516: ( p_count => x_msg_count,
517: p_data => x_msg_data
518: );

Line 519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

515: FND_MSG_PUB.Count_And_Get
516: ( p_count => x_msg_count,
517: p_data => x_msg_data
518: );
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO Delete_profile_groups_PUB;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MSG_PUB.Count_And_Get
523: ( p_count => x_msg_count,

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517: p_data => x_msg_data
518: );
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO Delete_profile_groups_PUB;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MSG_PUB.Count_And_Get
523: ( p_count => x_msg_count,
524: p_data => x_msg_data
525: );

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

524: p_data => x_msg_data
525: );
526: WHEN OTHERS THEN
527: ROLLBACK TO Delete_profile_groups_PUB;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
530: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
531: END IF;
532: FND_MSG_PUB.Count_And_Get