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

Line 44: raise FND_API.G_EXC_ERROR;

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

Line 167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

163: -- Standard Start of API savepoint
164: SAVEPOINT CREATE_PROFILE_CHECK_RULES_PUB;
165:
166: -- Standard call to check for call compatibility.
167: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
168: p_api_version_number,
169: l_api_name,
170: G_PKG_NAME)
171: THEN

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

168: p_api_version_number,
169: l_api_name,
170: G_PKG_NAME)
171: THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174:
175:
176: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 177: IF FND_API.to_Boolean( p_init_msg_list )

173: END IF;
174:
175:
176: -- Initialize message list if p_init_msg_list is set to TRUE.
177: IF FND_API.to_Boolean( p_init_msg_list )
178: THEN
179: FND_MSG_PUB.initialize;
180: END IF;
181:

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: END IF;
181:
182:
183: -- Initialize API return status to SUCCESS
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: --
187: -- API body
188: --

Line 209: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 210: raise FND_API.G_EXC_ERROR;

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

Line 211: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

207:
208: -- Check return status from the above procedure call
209: IF x_return_status = FND_API.G_RET_STS_ERROR then
210: raise FND_API.G_EXC_ERROR;
211: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
212: raise FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214:
215: --

Line 212: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 220: IF FND_API.to_Boolean( p_commit )

216: -- End of API body.
217: --
218:
219: -- Standard check for p_commit
220: IF FND_API.to_Boolean( p_commit )
221: THEN
222: COMMIT WORK;
223: END IF;
224:

Line 233: WHEN FND_API.G_EXC_ERROR THEN

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

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

231:
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: ROLLBACK TO Create_profile_check_rules_PUB;
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: FND_MSG_PUB.Count_And_Get(
237: p_count => x_msg_count,
238: p_data => x_msg_data );
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243: p_count => x_msg_count,
244: p_data => x_msg_data );
245: WHEN OTHERS THEN
246: ROLLBACK TO Create_profile_check_rules_PUB;
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: FND_MSG_PUB.Count_And_Get(
249: p_count => x_msg_count,
250: p_data => x_msg_data );
251:

Line 334: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 344: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 351: x_return_status := FND_API.G_RET_STS_SUCCESS;

347: END IF;
348:
349:
350: -- Initialize API return status to SUCCESS
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: --
354: -- API body
355: --

Line 375: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 376: raise FND_API.G_EXC_ERROR;

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

Line 377: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 378: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 386: IF FND_API.to_Boolean( p_commit )

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

Line 399: WHEN FND_API.G_EXC_ERROR THEN

395: p_data => x_msg_data
396: );
397:
398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN
400: ROLLBACK TO Update_profile_check_rules_PUB;
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: FND_MSG_PUB.Count_And_Get(
403: p_count => x_msg_count,

Line 401: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

401: x_return_status := FND_API.G_RET_STS_ERROR;
402: FND_MSG_PUB.Count_And_Get(
403: p_count => x_msg_count,
404: p_data => x_msg_data );
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: ROLLBACK TO Update_profile_check_rules_PUB;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: FND_MSG_PUB.Count_And_Get(
409: p_count => x_msg_count,

Line 407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

409: p_count => x_msg_count,
410: p_data => x_msg_data );
411: WHEN OTHERS THEN
412: ROLLBACK TO Update_profile_check_rules_PUB;
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: FND_MSG_PUB.Count_And_Get(
415: p_count => x_msg_count,
416: p_data => x_msg_data );
417:

Line 442: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

438: -- Standard Start of API savepoint
439: SAVEPOINT DELETE_PROFILE_CHECK_RULES_PUB;
440:
441: -- Standard call to check for call compatibility.
442: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
443: p_api_version_number,
444: l_api_name,
445: G_PKG_NAME)
446: THEN

Line 447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

443: p_api_version_number,
444: l_api_name,
445: G_PKG_NAME)
446: THEN
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END IF;
449:
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 452: IF FND_API.to_Boolean( p_init_msg_list )

448: END IF;
449:
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list )
453: THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456:

Line 459: x_return_status := FND_API.G_RET_STS_SUCCESS;

455: END IF;
456:
457:
458: -- Initialize API return status to SUCCESS
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461: --
462: -- API body
463: --

Line 480: IF x_return_status = FND_API.G_RET_STS_ERROR then

476: X_Msg_Data => x_msg_data);
477:
478:
479: -- Check return status from the above procedure call
480: IF x_return_status = FND_API.G_RET_STS_ERROR then
481: raise FND_API.G_EXC_ERROR;
482: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
483: raise FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;

Line 481: raise FND_API.G_EXC_ERROR;

477:
478:
479: -- Check return status from the above procedure call
480: IF x_return_status = FND_API.G_RET_STS_ERROR then
481: raise FND_API.G_EXC_ERROR;
482: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
483: raise FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:

Line 482: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

478:
479: -- Check return status from the above procedure call
480: IF x_return_status = FND_API.G_RET_STS_ERROR then
481: raise FND_API.G_EXC_ERROR;
482: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
483: raise FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: --

Line 483: raise FND_API.G_EXC_UNEXPECTED_ERROR;

479: -- Check return status from the above procedure call
480: IF x_return_status = FND_API.G_RET_STS_ERROR then
481: raise FND_API.G_EXC_ERROR;
482: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
483: raise FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: --
487: -- End of API body

Line 491: IF FND_API.to_Boolean( p_commit )

487: -- End of API body
488: --
489:
490: -- Standard check for p_commit
491: IF FND_API.to_Boolean( p_commit )
492: THEN
493: COMMIT WORK;
494: END IF;
495:

Line 503: WHEN FND_API.G_EXC_ERROR THEN

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

Line 505: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

505: x_return_status := FND_API.G_RET_STS_ERROR;
506: FND_MSG_PUB.Count_And_Get(
507: p_count => x_msg_count,
508: p_data => x_msg_data );
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO Delete_profile_check_rules_PUB;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Count_And_Get(
513: p_count => x_msg_count,

Line 511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

507: p_count => x_msg_count,
508: p_data => x_msg_data );
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO Delete_profile_check_rules_PUB;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Count_And_Get(
513: p_count => x_msg_count,
514: p_data => x_msg_data );
515: WHEN OTHERS THEN

Line 517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

513: p_count => x_msg_count,
514: p_data => x_msg_data );
515: WHEN OTHERS THEN
516: ROLLBACK TO Delete_profile_check_rules_PUB;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: FND_MSG_PUB.Count_And_Get(
519: p_count => x_msg_count,
520: p_data => x_msg_data );
521: