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

Line 26: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

22:
23:
24: PROCEDURE Save_Perz_Query
25: ( p_api_version_number IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
27: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
28:
29: p_application_id IN NUMBER,
30: p_profile_id IN NUMBER,

Line 27: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

23:
24: PROCEDURE Save_Perz_Query
25: ( p_api_version_number IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
27: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
28:
29: p_application_id IN NUMBER,
30: p_profile_id IN NUMBER,
31: p_profile_name IN VARCHAR2,

Line 66: -- IF NOT FND_API.Compatible_API_Call (

62: -- Standard Start of API savepoint
63: SAVEPOINT SAVE_JTF_PERZ_QUERY_PUB;
64:
65: -- Standard call to check for call compatibility.
66: -- IF NOT FND_API.Compatible_API_Call (
67: -- l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
68: -- THEN
69: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: -- END IF;

Line 69: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: -- Standard call to check for call compatibility.
66: -- IF NOT FND_API.Compatible_API_Call (
67: -- l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
68: -- THEN
69: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: -- END IF;
71:
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 73: IF Fnd_Api.to_Boolean( p_init_msg_list )

69: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: -- END IF;
71:
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF Fnd_Api.to_Boolean( p_init_msg_list )
74: THEN
75: Fnd_Msg_Pub.initialize;
76: END IF;
77:

Line 79: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

75: Fnd_Msg_Pub.initialize;
76: END IF;
77:
78: -- Initialize API return status to success
79: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
80:
81: Jtf_Perz_Query_Pvt.Save_Perz_Query
82:
83: ( p_api_version_number,

Line 111: IF Fnd_Api.To_Boolean ( p_commit )

107: --
108: -- 7. Commit the whole thing
109:
110: -- Standard check of p_commit.
111: IF Fnd_Api.To_Boolean ( p_commit )
112: THEN
113: COMMIT WORK;
114: END IF;
115:

Line 127: WHEN Fnd_Api.G_EXC_ERROR THEN

123:
124:
125: EXCEPTION
126:
127: WHEN Fnd_Api.G_EXC_ERROR THEN
128:
129: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;
130: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
131:

Line 130: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

126:
127: WHEN Fnd_Api.G_EXC_ERROR THEN
128:
129: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;
130: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
131:
132: Fnd_Msg_Pub.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data

Line 142: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

138: THEN
139: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name );
140: END IF;
141:
142: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
143:
144: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;
145: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
146:

Line 145: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

141:
142: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
143:
144: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;
145: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
146:
147: Fnd_Msg_Pub.Count_And_Get
148: ( p_count => x_msg_count,
149: p_data => x_msg_data

Line 160: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

156:
157: WHEN OTHERS THEN
158:
159: ROLLBACK TO SAVE_JTF_PERZ_QUERY_PUB;
160: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
161:
162: Fnd_Msg_Pub.Count_And_Get
163: ( p_count => x_msg_count,
164: p_data => x_msg_data

Line 175: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

171: END Save_Perz_Query;
172: -- ****************************************************************************
173: PROCEDURE Create_Perz_Query
174: ( p_api_version_number IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
176: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
177:
178: p_application_id IN NUMBER,
179: p_profile_id IN NUMBER,

Line 176: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

172: -- ****************************************************************************
173: PROCEDURE Create_Perz_Query
174: ( p_api_version_number IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
176: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
177:
178: p_application_id IN NUMBER,
179: p_profile_id IN NUMBER,
180: p_profile_name IN VARCHAR2,

Line 214: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

210: -- Standard Start of API savepoint
211: SAVEPOINT CREATE_JTF_PERZ_QUERY_PUB;
212:
213: -- Standard call to check for call compatibility.
214: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
215: -- THEN
216: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: -- END IF;
218:

Line 216: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

212:
213: -- Standard call to check for call compatibility.
214: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
215: -- THEN
216: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: -- END IF;
218:
219: -- Initialize message list if p_init_msg_list is set to TRUE.
220: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 220: IF Fnd_Api.to_Boolean( p_init_msg_list )

216: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: -- END IF;
218:
219: -- Initialize message list if p_init_msg_list is set to TRUE.
220: IF Fnd_Api.to_Boolean( p_init_msg_list )
221: THEN
222: Fnd_Msg_Pub.initialize;
223: END IF;
224:

Line 226: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

222: Fnd_Msg_Pub.initialize;
223: END IF;
224:
225: -- Initialize API return status to success
226: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
227:
228: Jtf_Perz_Query_Pvt.Create_Perz_Query
229: ( p_api_version_number,
230: p_init_msg_list,

Line 256: IF Fnd_Api.To_Boolean ( p_commit )

252: --
253: -- 7. Commit the whole thing
254:
255: -- Standard check of p_commit.
256: IF Fnd_Api.To_Boolean ( p_commit )
257: THEN
258: COMMIT WORK;
259: END IF;
260:

Line 272: WHEN Fnd_Api.G_EXC_ERROR THEN

268:
269:
270: EXCEPTION
271:
272: WHEN Fnd_Api.G_EXC_ERROR THEN
273:
274: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;
275: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
276:

Line 275: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

271:
272: WHEN Fnd_Api.G_EXC_ERROR THEN
273:
274: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;
275: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
276:
277: Fnd_Msg_Pub.Count_And_Get
278: ( p_count => x_msg_count,
279: p_data => x_msg_data

Line 287: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

283: THEN
284: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name );
285: END IF;
286:
287: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
288:
289: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;
290: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
291:

Line 290: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

286:
287: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
288:
289: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;
290: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
291:
292: Fnd_Msg_Pub.Count_And_Get
293: ( p_count => x_msg_count,
294: p_data => x_msg_data

Line 305: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

301:
302: WHEN OTHERS THEN
303:
304: ROLLBACK TO CREATE_JTF_PERZ_QUERY_PUB;
305: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
306:
307: Fnd_Msg_Pub.Count_And_Get
308: ( p_count => x_msg_count,
309: p_data => x_msg_data

Line 322: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

318: -- ****************************************************************************
319:
320: PROCEDURE Get_Perz_Query
321: ( p_api_version_number IN NUMBER,
322: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
323:
324: p_application_id IN NUMBER,
325: p_profile_id IN NUMBER,
326: p_profile_name IN VARCHAR2,

Line 356: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

352:
353: -- ******* Standard Begins ********
354:
355: -- Standard call to check for call compatibility.
356: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
357: -- THEN
358: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
359: -- END IF;
360:

Line 358: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

354:
355: -- Standard call to check for call compatibility.
356: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
357: -- THEN
358: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
359: -- END IF;
360:
361: -- Initialize message list if p_init_msg_list is set to TRUE.
362: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 362: IF Fnd_Api.to_Boolean( p_init_msg_list )

358: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
359: -- END IF;
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 368: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

364: Fnd_Msg_Pub.initialize;
365: END IF;
366:
367: -- Initialize API return status to success
368: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
369:
370: Jtf_Perz_Query_Pvt.Get_Perz_Query
371: ( p_api_version_number,
372: p_init_msg_list,

Line 412: WHEN Fnd_Api.G_EXC_ERROR THEN

408:
409:
410: EXCEPTION
411:
412: WHEN Fnd_Api.G_EXC_ERROR THEN
413:
414: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
415:
416: Fnd_Msg_Pub.Count_And_Get

Line 414: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

410: EXCEPTION
411:
412: WHEN Fnd_Api.G_EXC_ERROR THEN
413:
414: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
415:
416: Fnd_Msg_Pub.Count_And_Get
417: ( p_count => x_msg_count,
418: p_data => x_msg_data

Line 426: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

422: THEN
423: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name );
424: END IF;
425:
426: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
427:
428: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
429:
430: Fnd_Msg_Pub.Count_And_Get

Line 428: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

424: END IF;
425:
426: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
427:
428: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
429:
430: Fnd_Msg_Pub.Count_And_Get
431: ( p_count => x_msg_count,
432: p_data => x_msg_data

Line 443: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

439:
440: WHEN OTHERS THEN
441:
442:
443: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
444:
445: Fnd_Msg_Pub.Count_And_Get
446: ( p_count => x_msg_count,
447: p_data => x_msg_data

Line 461: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

457:
458: -- ****************************************************************************
459: PROCEDURE Get_Perz_Query_Summary
460: ( p_api_version_number IN NUMBER,
461: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
462:
463: p_application_id IN NUMBER,
464: p_profile_id IN NUMBER,
465: p_profile_name IN VARCHAR2,

Line 488: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

484:
485: -- ******* Standard Begins ********
486:
487: -- Standard call to check for call compatibility.
488: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
489: -- THEN
490: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: -- END IF;
492:

Line 490: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

486:
487: -- Standard call to check for call compatibility.
488: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
489: -- THEN
490: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: -- END IF;
492:
493: -- Initialize message list if p_init_msg_list is set to TRUE.
494: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 494: IF Fnd_Api.to_Boolean( p_init_msg_list )

490: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: -- END IF;
492:
493: -- Initialize message list if p_init_msg_list is set to TRUE.
494: IF Fnd_Api.to_Boolean( p_init_msg_list )
495: THEN
496: Fnd_Msg_Pub.initialize;
497: END IF;
498:

Line 500: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

496: Fnd_Msg_Pub.initialize;
497: END IF;
498:
499: -- Initialize API return status to success
500: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
501:
502: Jtf_Perz_Query_Pvt.Get_Perz_Query_Summary
503: ( p_api_version_number,
504: p_init_msg_list,

Line 537: WHEN Fnd_Api.G_EXC_ERROR THEN

533:
534:
535: EXCEPTION
536:
537: WHEN Fnd_Api.G_EXC_ERROR THEN
538:
539: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
540:
541: Fnd_Msg_Pub.Count_And_Get

Line 539: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

535: EXCEPTION
536:
537: WHEN Fnd_Api.G_EXC_ERROR THEN
538:
539: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
540:
541: Fnd_Msg_Pub.Count_And_Get
542: ( p_count => x_msg_count,
543: p_data => x_msg_data

Line 551: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

547: THEN
548: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name );
549: END IF;
550:
551: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
552:
553: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
554:
555: Fnd_Msg_Pub.Count_And_Get

Line 553: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

549: END IF;
550:
551: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
552:
553: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
554:
555: Fnd_Msg_Pub.Count_And_Get
556: ( p_count => x_msg_count,
557: p_data => x_msg_data

Line 568: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

564:
565: WHEN OTHERS THEN
566:
567:
568: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
569:
570: Fnd_Msg_Pub.Count_And_Get
571: ( p_count => x_msg_count,
572: p_data => x_msg_data

Line 583: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

579: END Get_Perz_Query_Summary;
580: -- *****************************************************************************
581: PROCEDURE Update_Perz_Query
582: ( p_api_version_number IN NUMBER,
583: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
584: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
585:
586: p_application_id IN NUMBER,
587: p_profile_id IN NUMBER,

Line 584: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

580: -- *****************************************************************************
581: PROCEDURE Update_Perz_Query
582: ( p_api_version_number IN NUMBER,
583: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
584: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
585:
586: p_application_id IN NUMBER,
587: p_profile_id IN NUMBER,
588:

Line 621: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

617: -- Standard Start of API savepoint
618: SAVEPOINT UPDATE_JTF_PERZ_QUERY_PUB;
619:
620: -- Standard call to check for call compatibility.
621: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
622: -- THEN
623: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: -- END IF;
625:

Line 623: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

619:
620: -- Standard call to check for call compatibility.
621: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
622: -- THEN
623: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: -- END IF;
625:
626: -- Initialize message list if p_init_msg_list is set to TRUE.
627: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 627: IF Fnd_Api.to_Boolean( p_init_msg_list )

623: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: -- END IF;
625:
626: -- Initialize message list if p_init_msg_list is set to TRUE.
627: IF Fnd_Api.to_Boolean( p_init_msg_list )
628: THEN
629: Fnd_Msg_Pub.initialize;
630: END IF;
631:

Line 633: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

629: Fnd_Msg_Pub.initialize;
630: END IF;
631:
632: -- Initialize API return status to success
633: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
634:
635: Jtf_Perz_Query_Pvt.Update_Perz_Query
636: ( p_api_version_number,
637: p_init_msg_list,

Line 663: IF Fnd_Api.To_Boolean ( p_commit )

659: --
660: -- 7. Commit the whole thing
661:
662: -- Standard check of p_commit.
663: IF Fnd_Api.To_Boolean ( p_commit )
664: THEN
665: COMMIT WORK;
666: END IF;
667:

Line 679: WHEN Fnd_Api.G_EXC_ERROR THEN

675:
676:
677: EXCEPTION
678:
679: WHEN Fnd_Api.G_EXC_ERROR THEN
680:
681: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;
682: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
683:

Line 682: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

678:
679: WHEN Fnd_Api.G_EXC_ERROR THEN
680:
681: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;
682: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
683:
684: Fnd_Msg_Pub.Count_And_Get
685: ( p_count => x_msg_count,
686: p_data => x_msg_data

Line 694: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

690: THEN
691: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name );
692: END IF;
693:
694: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
695:
696: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;
697: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
698:

Line 697: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

693:
694: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
695:
696: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;
697: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
698:
699: Fnd_Msg_Pub.Count_And_Get
700: ( p_count => x_msg_count,
701: p_data => x_msg_data

Line 712: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

708:
709: WHEN OTHERS THEN
710:
711: ROLLBACK TO UPDATE_JTF_PERZ_QUERY_PUB;
712: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
713:
714: Fnd_Msg_Pub.Count_And_Get
715: ( p_count => x_msg_count,
716: p_data => x_msg_data

Line 729: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

725: END Update_Perz_Query;
726: -- *****************************************************************************
727: PROCEDURE Delete_Perz_Query
728: ( p_api_version_number IN NUMBER,
729: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
730: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
731:
732: p_application_id IN NUMBER,
733: p_profile_id IN NUMBER,

Line 730: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

726: -- *****************************************************************************
727: PROCEDURE Delete_Perz_Query
728: ( p_api_version_number IN NUMBER,
729: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
730: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
731:
732: p_application_id IN NUMBER,
733: p_profile_id IN NUMBER,
734: p_query_id IN NUMBER,

Line 755: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)

751: -- Standard Start of API savepoint
752: SAVEPOINT DELETE_JTF_PERZ_QUERY_PUB;
753:
754: -- Standard call to check for call compatibility.
755: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
756: -- THEN
757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: -- END IF;
759:

Line 757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

753:
754: -- Standard call to check for call compatibility.
755: -- IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
756: -- THEN
757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: -- END IF;
759:
760: -- Initialize message list if p_init_msg_list is set to TRUE.
761: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 761: IF Fnd_Api.to_Boolean( p_init_msg_list )

757: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: -- END IF;
759:
760: -- Initialize message list if p_init_msg_list is set to TRUE.
761: IF Fnd_Api.to_Boolean( p_init_msg_list )
762: THEN
763: Fnd_Msg_Pub.initialize;
764: END IF;
765:

Line 767: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

763: Fnd_Msg_Pub.initialize;
764: END IF;
765:
766: -- Initialize API return status to success
767: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
768: Jtf_Perz_Query_Pvt.Delete_Perz_Query
769: ( p_api_version_number,
770: p_init_msg_list,
771: p_commit,

Line 789: IF Fnd_Api.To_Boolean ( p_commit )

785: --
786: -- 7. Commit the whole thing
787:
788: -- Standard check of p_commit.
789: IF Fnd_Api.To_Boolean ( p_commit )
790: THEN
791: COMMIT WORK;
792: END IF;
793:

Line 805: WHEN Fnd_Api.G_EXC_ERROR THEN

801:
802:
803: EXCEPTION
804:
805: WHEN Fnd_Api.G_EXC_ERROR THEN
806:
807: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;
808: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
809:

Line 808: x_return_status := Fnd_Api.G_RET_STS_ERROR ;

804:
805: WHEN Fnd_Api.G_EXC_ERROR THEN
806:
807: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;
808: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
809:
810: Fnd_Msg_Pub.Count_And_Get
811: ( p_count => x_msg_count,
812: p_data => x_msg_data

Line 820: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

816: THEN
817: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name );
818: END IF;
819:
820: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
821:
822: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;
823: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
824:

Line 823: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

819:
820: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
821:
822: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;
823: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
824:
825: Fnd_Msg_Pub.Count_And_Get
826: ( p_count => x_msg_count,
827: p_data => x_msg_data

Line 838: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;

834:
835: WHEN OTHERS THEN
836:
837: ROLLBACK TO DELETE_JTF_PERZ_QUERY_PUB;
838: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR ;
839:
840: Fnd_Msg_Pub.Count_And_Get
841: ( p_count => x_msg_count,
842: p_data => x_msg_data