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

Line 62: -- p_CATEGORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,

58: p_THRESHOLD_RATING_CODE IN VARCHAR2,
59: p_CHECK_UPPER_LOWER_FLAG IN VARCHAR2,
60: p_THRESHOLD_COLOR_CODE IN VARCHAR2,
61: p_CHECK_LEVEL IN VARCHAR2,
62: -- p_CATEGORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_CREATED_BY IN NUMBER,
64: p_CREATION_DATE IN DATE,
65: p_LAST_UPDATED_BY IN NUMBER,
66: p_LAST_UPDATE_DATE IN DATE,

Line 119: --p_CATEGORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,

115: p_THRESHOLD_RATING_CODE IN VARCHAR2,
116: p_CHECK_UPPER_LOWER_FLAG IN VARCHAR2,
117: p_THRESHOLD_COLOR_CODE IN VARCHAR2,
118: p_CHECK_LEVEL IN VARCHAR2,
119: --p_CATEGORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_CREATED_BY IN NUMBER,
121: p_CREATION_DATE IN DATE,
122: p_LAST_UPDATED_BY IN NUMBER,
123: p_LAST_UPDATE_DATE IN DATE,

Line 196: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

192: -- Standard Start of API savepoint
193: SAVEPOINT CREATE_PROFILE_CHECK_PUB;
194:
195: -- Standard call to check for call compatibility.
196: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
197: p_api_version_number,
198: l_api_name,
199: G_PKG_NAME)
200: THEN

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

197: p_api_version_number,
198: l_api_name,
199: G_PKG_NAME)
200: THEN
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: END IF;
203:
204:
205: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 206: IF FND_API.to_Boolean( p_init_msg_list )

202: END IF;
203:
204:
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: IF FND_API.to_Boolean( p_init_msg_list )
207: THEN
208: FND_MSG_PUB.initialize;
209: END IF;
210:

Line 213: x_return_status := FND_API.G_RET_STS_SUCCESS;

209: END IF;
210:
211:
212: -- Initialize API return status to SUCCESS
213: x_return_status := FND_API.G_RET_STS_SUCCESS;
214:
215: Convert_Pub_to_Pvt_Rec(
216: p_check_Rec => p_check_rec,
217: x_pvt_check_rec => l_pvt_check_rec

Line 225: P_Init_Msg_List => FND_API.G_FALSE,

221: -- API body
222: --
223: CSC_Profile_check_PVT.Create_Profile_check(
224: P_Api_Version_Number => 1.0,
225: P_Init_Msg_List => FND_API.G_FALSE,
226: P_Commit => FND_API.G_FALSE,
227: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
228: P_CHECK_Rec => l_pvt_CHECK_Rec ,
229: X_CHECK_ID => x_CHECK_ID,

Line 226: P_Commit => FND_API.G_FALSE,

222: --
223: CSC_Profile_check_PVT.Create_Profile_check(
224: P_Api_Version_Number => 1.0,
225: P_Init_Msg_List => FND_API.G_FALSE,
226: P_Commit => FND_API.G_FALSE,
227: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
228: P_CHECK_Rec => l_pvt_CHECK_Rec ,
229: X_CHECK_ID => x_CHECK_ID,
230: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,

Line 227: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

223: CSC_Profile_check_PVT.Create_Profile_check(
224: P_Api_Version_Number => 1.0,
225: P_Init_Msg_List => FND_API.G_FALSE,
226: P_Commit => FND_API.G_FALSE,
227: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
228: P_CHECK_Rec => l_pvt_CHECK_Rec ,
229: X_CHECK_ID => x_CHECK_ID,
230: X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
231: X_Return_Status => x_return_status,

Line 237: IF x_return_status = FND_API.G_RET_STS_ERROR then

233: X_Msg_Data => x_msg_data);
234:
235:
236: -- Check return status from the above procedure call
237: IF x_return_status = FND_API.G_RET_STS_ERROR then
238: raise FND_API.G_EXC_ERROR;
239: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
240: raise FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;

Line 238: raise FND_API.G_EXC_ERROR;

234:
235:
236: -- Check return status from the above procedure call
237: IF x_return_status = FND_API.G_RET_STS_ERROR then
238: raise FND_API.G_EXC_ERROR;
239: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
240: raise FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242:

Line 239: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

235:
236: -- Check return status from the above procedure call
237: IF x_return_status = FND_API.G_RET_STS_ERROR then
238: raise FND_API.G_EXC_ERROR;
239: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
240: raise FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242:
243: --

Line 240: raise FND_API.G_EXC_UNEXPECTED_ERROR;

236: -- Check return status from the above procedure call
237: IF x_return_status = FND_API.G_RET_STS_ERROR then
238: raise FND_API.G_EXC_ERROR;
239: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
240: raise FND_API.G_EXC_UNEXPECTED_ERROR;
241: END IF;
242:
243: --
244: -- End of API body.

Line 247: IF FND_API.to_Boolean( p_commit )

243: --
244: -- End of API body.
245: --
246: -- Standard check for p_commit
247: IF FND_API.to_Boolean( p_commit )
248: THEN
249: COMMIT WORK;
250: END IF;
251:

Line 260: WHEN FND_API.G_EXC_ERROR THEN

256: p_data => x_msg_data
257: );
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO Create_Profile_Check_PUB;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,

Line 262: x_return_status := FND_API.G_RET_STS_ERROR;

258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO Create_Profile_Check_PUB;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,
265: p_data => x_msg_data
266: );

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,
265: p_data => x_msg_data
266: );
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO Create_Profile_Check_PUB;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: FND_MSG_PUB.Count_And_Get
271: ( p_count => x_msg_count,

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

265: p_data => x_msg_data
266: );
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO Create_Profile_Check_PUB;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: FND_MSG_PUB.Count_And_Get
271: ( p_count => x_msg_count,
272: p_data => x_msg_data
273: );

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

272: p_data => x_msg_data
273: );
274: WHEN OTHERS THEN
275: ROLLBACK TO Create_Profile_Check_PUB;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
278: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
279: END IF;
280: FND_MSG_PUB.Count_And_Get

Line 307: -- p_CATEGORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,

303: p_THRESHOLD_RATING_CODE IN VARCHAR2,
304: p_CHECK_UPPER_LOWER_FLAG IN VARCHAR2,
305: p_THRESHOLD_COLOR_CODE IN VARCHAR2,
306: p_CHECK_LEVEL IN VARCHAR2,
307: -- p_CATEGORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_CREATED_BY IN NUMBER,
309: p_CREATION_DATE IN DATE,
310: p_LAST_UPDATED_BY IN NUMBER,
311: p_LAST_UPDATE_DATE IN DATE,

Line 387: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

383: -- Standard Start of API savepoint
384: SAVEPOINT UPDATE_CHECK_PUB;
385:
386: -- Standard call to check for call compatibility.
387: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
388: p_api_version_number,
389: l_api_name,
390: G_PKG_NAME)
391: THEN

Line 392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

388: p_api_version_number,
389: l_api_name,
390: G_PKG_NAME)
391: THEN
392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
393: END IF;
394:
395:
396: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 397: IF FND_API.to_Boolean( p_init_msg_list )

393: END IF;
394:
395:
396: -- Initialize message list if p_init_msg_list is set to TRUE.
397: IF FND_API.to_Boolean( p_init_msg_list )
398: THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:

Line 404: x_return_status := FND_API.G_RET_STS_SUCCESS;

400: END IF;
401:
402:
403: -- Initialize API return status to SUCCESS
404: x_return_status := FND_API.G_RET_STS_SUCCESS;
405:
406: --
407: -- API body
408: --

Line 418: P_Init_Msg_List => FND_API.G_FALSE,

414:
415:
416: CSC_Profile_check_PVT.Update_Profile_check(
417: P_Api_Version_Number => 1.0,
418: P_Init_Msg_List => FND_API.G_FALSE,
419: P_Commit => p_commit,
420: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
421: P_CHECK_Rec => l_pvt_CHECK_Rec ,
422: Px_OBJECT_VERSION_NUMBER => Px_OBJECT_VERSION_NUMBER,

Line 420: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

416: CSC_Profile_check_PVT.Update_Profile_check(
417: P_Api_Version_Number => 1.0,
418: P_Init_Msg_List => FND_API.G_FALSE,
419: P_Commit => p_commit,
420: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
421: P_CHECK_Rec => l_pvt_CHECK_Rec ,
422: Px_OBJECT_VERSION_NUMBER => Px_OBJECT_VERSION_NUMBER,
423: X_Return_Status => x_return_status,
424: X_Msg_Count => x_msg_count,

Line 429: IF x_return_status = FND_API.G_RET_STS_ERROR then

425: X_Msg_Data => x_msg_data);
426:
427:
428: -- Check return status from the above procedure call
429: IF x_return_status = FND_API.G_RET_STS_ERROR then
430: raise FND_API.G_EXC_ERROR;
431: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
432: raise FND_API.G_EXC_UNEXPECTED_ERROR;
433: END IF;

Line 430: raise FND_API.G_EXC_ERROR;

426:
427:
428: -- Check return status from the above procedure call
429: IF x_return_status = FND_API.G_RET_STS_ERROR then
430: raise FND_API.G_EXC_ERROR;
431: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
432: raise FND_API.G_EXC_UNEXPECTED_ERROR;
433: END IF;
434:

Line 431: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

427:
428: -- Check return status from the above procedure call
429: IF x_return_status = FND_API.G_RET_STS_ERROR then
430: raise FND_API.G_EXC_ERROR;
431: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
432: raise FND_API.G_EXC_UNEXPECTED_ERROR;
433: END IF;
434:
435: --

Line 432: raise FND_API.G_EXC_UNEXPECTED_ERROR;

428: -- Check return status from the above procedure call
429: IF x_return_status = FND_API.G_RET_STS_ERROR then
430: raise FND_API.G_EXC_ERROR;
431: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
432: raise FND_API.G_EXC_UNEXPECTED_ERROR;
433: END IF;
434:
435: --
436: -- End of API body

Line 440: IF FND_API.to_Boolean( p_commit )

436: -- End of API body
437: --
438:
439: -- Standard check for p_commit
440: IF FND_API.to_Boolean( p_commit )
441: THEN
442: COMMIT WORK;
443: END IF;
444:

Line 453: WHEN FND_API.G_EXC_ERROR THEN

449: p_data => x_msg_data
450: );
451:
452: EXCEPTION
453: WHEN FND_API.G_EXC_ERROR THEN
454: ROLLBACK TO Update_Profile_Check_PUB;
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: FND_MSG_PUB.Count_And_Get
457: ( p_count => x_msg_count,

Line 455: x_return_status := FND_API.G_RET_STS_ERROR;

451:
452: EXCEPTION
453: WHEN FND_API.G_EXC_ERROR THEN
454: ROLLBACK TO Update_Profile_Check_PUB;
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: FND_MSG_PUB.Count_And_Get
457: ( p_count => x_msg_count,
458: p_data => x_msg_data
459: );

Line 460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

456: FND_MSG_PUB.Count_And_Get
457: ( p_count => x_msg_count,
458: p_data => x_msg_data
459: );
460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
461: ROLLBACK TO Update_Profile_Check_PUB;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,

Line 462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

458: p_data => x_msg_data
459: );
460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
461: ROLLBACK TO Update_Profile_Check_PUB;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
466: );

Line 469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

465: p_data => x_msg_data
466: );
467: WHEN OTHERS THEN
468: ROLLBACK TO Update_Profile_Check_PUB;
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
471: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
472: END IF;
473: FND_MSG_PUB.Count_And_Get

Line 498: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

494: -- Standard Start of API savepoint
495: SAVEPOINT DELETE_CHECK_PUB;
496:
497: -- Standard call to check for call compatibility.
498: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
499: p_api_version_number,
500: l_api_name,
501: G_PKG_NAME)
502: THEN

Line 503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

499: p_api_version_number,
500: l_api_name,
501: G_PKG_NAME)
502: THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: END IF;
505:
506:
507: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 508: IF FND_API.to_Boolean( p_init_msg_list )

504: END IF;
505:
506:
507: -- Initialize message list if p_init_msg_list is set to TRUE.
508: IF FND_API.to_Boolean( p_init_msg_list )
509: THEN
510: FND_MSG_PUB.initialize;
511: END IF;
512:

Line 515: x_return_status := FND_API.G_RET_STS_SUCCESS;

511: END IF;
512:
513:
514: -- Initialize API return status to SUCCESS
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: --
518: -- API body
519: --

Line 523: P_Init_Msg_List => FND_API.G_FALSE,

519: --
520:
521: CSC_Profile_check_PVT.Delete_Profile_check(
522: P_Api_Version_Number => 1.0,
523: P_Init_Msg_List => FND_API.G_FALSE,
524: P_Commit => p_commit,
525: P_VALidation_level => FND_API.G_VALID_LEVEL_FULL,
526: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
527: P_CHECK_Id => p_CHECK_Id,

Line 525: P_VALidation_level => FND_API.G_VALID_LEVEL_FULL,

521: CSC_Profile_check_PVT.Delete_Profile_check(
522: P_Api_Version_Number => 1.0,
523: P_Init_Msg_List => FND_API.G_FALSE,
524: P_Commit => p_commit,
525: P_VALidation_level => FND_API.G_VALID_LEVEL_FULL,
526: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
527: P_CHECK_Id => p_CHECK_Id,
528: X_Return_Status => x_return_status,
529: X_Msg_Count => x_msg_count,

Line 533: IF x_return_status = FND_API.G_RET_STS_ERROR then

529: X_Msg_Count => x_msg_count,
530: X_Msg_Data => x_msg_data);
531:
532: -- Check return status from the above procedure call
533: IF x_return_status = FND_API.G_RET_STS_ERROR then
534: raise FND_API.G_EXC_ERROR;
535: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
536: raise FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;

Line 534: raise FND_API.G_EXC_ERROR;

530: X_Msg_Data => x_msg_data);
531:
532: -- Check return status from the above procedure call
533: IF x_return_status = FND_API.G_RET_STS_ERROR then
534: raise FND_API.G_EXC_ERROR;
535: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
536: raise FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:

Line 535: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

531:
532: -- Check return status from the above procedure call
533: IF x_return_status = FND_API.G_RET_STS_ERROR then
534: raise FND_API.G_EXC_ERROR;
535: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
536: raise FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:
539: --

Line 536: raise FND_API.G_EXC_UNEXPECTED_ERROR;

532: -- Check return status from the above procedure call
533: IF x_return_status = FND_API.G_RET_STS_ERROR then
534: raise FND_API.G_EXC_ERROR;
535: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
536: raise FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:
539: --
540: -- End of API body

Line 544: IF FND_API.to_Boolean( p_commit )

540: -- End of API body
541: --
542:
543: -- Standard check for p_commit
544: IF FND_API.to_Boolean( p_commit )
545: THEN
546: COMMIT WORK;
547: END IF;
548:

Line 558: WHEN FND_API.G_EXC_ERROR THEN

554: p_data => x_msg_data
555: );
556:
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO Delete_Profile_Check_PUB;
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: FND_MSG_PUB.Count_And_Get
562: ( p_count => x_msg_count,

Line 560: x_return_status := FND_API.G_RET_STS_ERROR;

556:
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO Delete_Profile_Check_PUB;
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: FND_MSG_PUB.Count_And_Get
562: ( p_count => x_msg_count,
563: p_data => x_msg_data
564: );

Line 565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

561: FND_MSG_PUB.Count_And_Get
562: ( p_count => x_msg_count,
563: p_data => x_msg_data
564: );
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO Delete_Profile_Check_PUB;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count,

Line 567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

563: p_data => x_msg_data
564: );
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO Delete_Profile_Check_PUB;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count,
570: p_data => x_msg_data
571: );

Line 574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

570: p_data => x_msg_data
571: );
572: WHEN OTHERS THEN
573: ROLLBACK TO Delete_Profile_Check_PUB;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
576: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
577: END IF;
578: FND_MSG_PUB.Count_And_Get