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

Line 39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

35: -- *****************************************************************************
36: --
37: PROCEDURE save_data_default
38: ( p_api_version_number IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR := FND_API.G_FALSE,
41:
42: p_application_id IN NUMBER,
43:

Line 40: p_commit IN VARCHAR := FND_API.G_FALSE,

36: --
37: PROCEDURE save_data_default
38: ( p_api_version_number IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR := FND_API.G_FALSE,
41:
42: p_application_id IN NUMBER,
43:
44: p_profile_id IN NUMBER,

Line 70: --l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;

66: -- Following variables are needed to adhere to standards
67: l_api_version_number NUMBER := p_api_version_number;
68: l_api_name CONSTANT VARCHAR2(30) := 'save_data_default';
69: -- Following variables are needed for implementation
70: --l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
71:
72: BEGIN
73:
74:

Line 81: -- IF NOT FND_API.Compatible_API_Call (

77: -- Standard Start of API savepoint
78: SAVEPOINT SAVE_PERZ_DDF_PUB;
79:
80: -- Standard call to check for call compatibility.
81: -- IF NOT FND_API.Compatible_API_Call (
82: -- l_api_version_number,
83: -- p_api_version_number,
84: -- l_api_name,
85: -- G_PKG_NAME)

Line 87: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

83: -- p_api_version_number,
84: -- l_api_name,
85: -- G_PKG_NAME)
86: -- THEN
87: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: -- END IF;
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list )

Line 91: IF FND_API.to_Boolean( p_init_msg_list )

87: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: -- END IF;
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list )
92: THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Initialize API return status to success
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: JTF_PERZ_DDF_PVT.save_data_default
100: ( p_api_version_number ,
101: p_init_msg_list ,

Line 135: IF FND_API.To_Boolean ( p_commit )

131: --
132: -- 7. Commit the whole thing
133:
134: -- Standard check of p_commit.
135: IF FND_API.To_Boolean ( p_commit )
136: THEN
137: COMMIT WORK;
138: END IF;
139:

Line 151: WHEN FND_API.G_EXC_ERROR THEN

147:
148:
149: EXCEPTION
150:
151: WHEN FND_API.G_EXC_ERROR THEN
152:
153: ROLLBACK TO SAVE_PERZ_DDF_PUB;
154: x_return_status := FND_API.G_RET_STS_ERROR ;
155:

Line 154: x_return_status := FND_API.G_RET_STS_ERROR ;

150:
151: WHEN FND_API.G_EXC_ERROR THEN
152:
153: ROLLBACK TO SAVE_PERZ_DDF_PUB;
154: x_return_status := FND_API.G_RET_STS_ERROR ;
155:
156: FND_MSG_PUB.Count_And_Get
157: ( p_count => x_msg_count,
158: p_data => x_msg_data

Line 166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

162: THEN
163: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
164: END IF;
165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167:
168: ROLLBACK TO SAVE_PERZ_DDF_PUB;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170:

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167:
168: ROLLBACK TO SAVE_PERZ_DDF_PUB;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170:
171: FND_MSG_PUB.Count_And_Get
172: ( p_count => x_msg_count,
173: p_data => x_msg_data

Line 184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

180:
181: WHEN OTHERS THEN
182:
183: ROLLBACK TO SAVE_PERZ_DDF_PUB;
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
185:
186: FND_MSG_PUB.Count_And_Get
187: ( p_count => x_msg_count,
188: p_data => x_msg_data

Line 229: --l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;

225: -- Following variables are needed to adhere to standards
226: l_api_version_number NUMBER := p_api_version_number;
227: l_api_name CONSTANT VARCHAR2(30) := 'save_data_default';
228: -- Following variables are needed for implementation
229: --l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
230:
231: BEGIN
232:
233:

Line 240: -- IF NOT FND_API.Compatible_API_Call (

236: -- Standard Start of API savepoint
237: SAVEPOINT CREATE_PERZ_DDF_PUB;
238:
239: -- Standard call to check for call compatibility.
240: -- IF NOT FND_API.Compatible_API_Call (
241: -- l_api_version_number,
242: -- p_api_version_number,
243: -- l_api_name,
244: -- G_PKG_NAME)

Line 246: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

242: -- p_api_version_number,
243: -- l_api_name,
244: -- G_PKG_NAME)
245: -- THEN
246: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: -- END IF;
248:
249: -- Initialize message list if p_init_msg_list is set to TRUE.
250: IF FND_API.to_Boolean( p_init_msg_list )

Line 250: IF FND_API.to_Boolean( p_init_msg_list )

246: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: -- END IF;
248:
249: -- Initialize message list if p_init_msg_list is set to TRUE.
250: IF FND_API.to_Boolean( p_init_msg_list )
251: THEN
252: FND_MSG_PUB.initialize;
253: END IF;
254:

Line 256: x_return_status := FND_API.G_RET_STS_SUCCESS;

252: FND_MSG_PUB.initialize;
253: END IF;
254:
255: -- Initialize API return status to success
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: JTF_PERZ_DDF_PVT.create_data_default
259: (
260: p_api_version_number ,

Line 293: IF FND_API.To_Boolean ( p_commit )

289: --
290: -- 7. Commit the whole thing
291:
292: -- Standard check of p_commit.
293: IF FND_API.To_Boolean ( p_commit )
294: THEN
295: COMMIT WORK;
296: END IF;
297:

Line 309: WHEN FND_API.G_EXC_ERROR THEN

305:
306:
307: EXCEPTION
308:
309: WHEN FND_API.G_EXC_ERROR THEN
310:
311: ROLLBACK TO CREATE_PERZ_DDF_PUB;
312: x_return_status := FND_API.G_RET_STS_ERROR ;
313:

Line 312: x_return_status := FND_API.G_RET_STS_ERROR ;

308:
309: WHEN FND_API.G_EXC_ERROR THEN
310:
311: ROLLBACK TO CREATE_PERZ_DDF_PUB;
312: x_return_status := FND_API.G_RET_STS_ERROR ;
313:
314: FND_MSG_PUB.Count_And_Get
315: ( p_count => x_msg_count,
316: p_data => x_msg_data

Line 324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

320: THEN
321: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
322: END IF;
323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325:
326: ROLLBACK TO CREATE_PERZ_DDF_PUB;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328:

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325:
326: ROLLBACK TO CREATE_PERZ_DDF_PUB;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328:
329: FND_MSG_PUB.Count_And_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data

Line 342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

338:
339: WHEN OTHERS THEN
340:
341: ROLLBACK TO CREATE_PERZ_DDF_PUB;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
343:
344: FND_MSG_PUB.Count_And_Get
345: ( p_count => x_msg_count,
346: p_data => x_msg_data

Line 386: --l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;

382: -- Following variables are needed to adhere to standards
383: l_api_version_number NUMBER := p_api_version_number;
384: l_api_name CONSTANT VARCHAR2(30) := 'save_data_default';
385: -- Following variables are needed for implementation
386: --l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
387:
388: BEGIN
389:
390:

Line 394: -- IF NOT FND_API.Compatible_API_Call (

390:
391: -- ******* save_data_default Standard Begins ********
392:
393: -- Standard call to check for call compatibility.
394: -- IF NOT FND_API.Compatible_API_Call (
395: -- l_api_version_number,
396: -- p_api_version_number,
397: -- l_api_name,
398: -- G_PKG_NAME)

Line 400: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: -- p_api_version_number,
397: -- l_api_name,
398: -- G_PKG_NAME)
399: -- THEN
400: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: -- END IF;
402:
403: -- Initialize message list if p_init_msg_list is set to TRUE.
404: IF FND_API.to_Boolean( p_init_msg_list )

Line 404: IF FND_API.to_Boolean( p_init_msg_list )

400: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: -- END IF;
402:
403: -- Initialize message list if p_init_msg_list is set to TRUE.
404: IF FND_API.to_Boolean( p_init_msg_list )
405: THEN
406: FND_MSG_PUB.initialize;
407: END IF;
408:

Line 410: x_return_status := FND_API.G_RET_STS_SUCCESS;

406: FND_MSG_PUB.initialize;
407: END IF;
408:
409: -- Initialize API return status to success
410: x_return_status := FND_API.G_RET_STS_SUCCESS;
411:
412: JTF_PERZ_DDF_PVT.get_data_default
413: ( p_api_version_number ,
414: p_init_msg_list ,

Line 452: WHEN FND_API.G_EXC_ERROR THEN

448:
449:
450: EXCEPTION
451:
452: WHEN FND_API.G_EXC_ERROR THEN
453:
454: x_return_status := FND_API.G_RET_STS_ERROR ;
455:
456: FND_MSG_PUB.Count_And_Get

Line 454: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

462: THEN
463: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
464: END IF;
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
469:
470: FND_MSG_PUB.Count_And_Get

Line 468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

464: END IF;
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
469:
470: FND_MSG_PUB.Count_And_Get
471: ( p_count => x_msg_count,
472: p_data => x_msg_data

Line 482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

478: END IF;
479:
480: WHEN OTHERS THEN
481:
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
483:
484: FND_MSG_PUB.Count_And_Get
485: ( p_count => x_msg_count,
486: p_data => x_msg_data

Line 527: --l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;

523: -- Following variables are needed to adhere to standards
524: l_api_version_number NUMBER := p_api_version_number;
525: l_api_name CONSTANT VARCHAR2(30) := 'save_data_default';
526: -- Following variables are needed for implementation
527: --l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
528:
529: BEGIN
530:
531:

Line 538: -- IF NOT FND_API.Compatible_API_Call (

534: -- Standard Start of API savepoint
535: SAVEPOINT UPDATE_PERZ_DDF_PUB;
536:
537: -- Standard call to check for call compatibility.
538: -- IF NOT FND_API.Compatible_API_Call (
539: -- l_api_version_number,
540: -- p_api_version_number,
541: -- l_api_name,
542: -- G_PKG_NAME)

Line 544: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

540: -- p_api_version_number,
541: -- l_api_name,
542: -- G_PKG_NAME)
543: -- THEN
544: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: -- END IF;
546:
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list )

Line 548: IF FND_API.to_Boolean( p_init_msg_list )

544: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: -- END IF;
546:
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list )
549: THEN
550: FND_MSG_PUB.initialize;
551: END IF;
552:

Line 554: x_return_status := FND_API.G_RET_STS_SUCCESS;

550: FND_MSG_PUB.initialize;
551: END IF;
552:
553: -- Initialize API return status to success
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555:
556: JTF_PERZ_DDF_PVT.update_data_default
557: (
558: p_api_version_number ,

Line 590: IF FND_API.To_Boolean ( p_commit )

586: --
587: -- 7. Commit the whole thing
588:
589: -- Standard check of p_commit.
590: IF FND_API.To_Boolean ( p_commit )
591: THEN
592: COMMIT WORK;
593: END IF;
594:

Line 606: WHEN FND_API.G_EXC_ERROR THEN

602:
603:
604: EXCEPTION
605:
606: WHEN FND_API.G_EXC_ERROR THEN
607:
608: ROLLBACK TO UPDATE_PERZ_DDF_PUB;
609: x_return_status := FND_API.G_RET_STS_ERROR ;
610:

Line 609: x_return_status := FND_API.G_RET_STS_ERROR ;

605:
606: WHEN FND_API.G_EXC_ERROR THEN
607:
608: ROLLBACK TO UPDATE_PERZ_DDF_PUB;
609: x_return_status := FND_API.G_RET_STS_ERROR ;
610:
611: FND_MSG_PUB.Count_And_Get
612: ( p_count => x_msg_count,
613: p_data => x_msg_data

Line 621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

617: THEN
618: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
619: END IF;
620:
621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
622:
623: ROLLBACK TO UPDATE_PERZ_DDF_PUB;
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
625:

Line 624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

620:
621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
622:
623: ROLLBACK TO UPDATE_PERZ_DDF_PUB;
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
625:
626: FND_MSG_PUB.Count_And_Get
627: ( p_count => x_msg_count,
628: p_data => x_msg_data

Line 639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

635:
636: WHEN OTHERS THEN
637:
638: ROLLBACK TO UPDATE_PERZ_DDF_PUB;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
640:
641: FND_MSG_PUB.Count_And_Get
642: ( p_count => x_msg_count,
643: p_data => x_msg_data

Line 658: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

654: -- *****************************************************************************
655:
656: PROCEDURE delete_data_default
657: ( p_api_version_number IN NUMBER,
658: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
659: p_commit IN VARCHAR := FND_API.G_FALSE,
660:
661: p_application_id IN NUMBER,
662: p_profile_id IN NUMBER,

Line 659: p_commit IN VARCHAR := FND_API.G_FALSE,

655:
656: PROCEDURE delete_data_default
657: ( p_api_version_number IN NUMBER,
658: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
659: p_commit IN VARCHAR := FND_API.G_FALSE,
660:
661: p_application_id IN NUMBER,
662: p_profile_id IN NUMBER,
663: p_perz_ddf_id IN NUMBER,

Line 674: --l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;

670: -- Following variables are needed to adhere to standards
671: l_api_version_number NUMBER := p_api_version_number;
672: l_api_name CONSTANT VARCHAR2(30) := 'save_data_default';
673: -- Following variables are needed for implementation
674: --l_return_status VARCHAR2(240) := FND_API.G_RET_STS_SUCCESS;
675:
676: BEGIN
677:
678:

Line 685: -- IF NOT FND_API.Compatible_API_Call (

681: -- Standard Start of API savepoint
682: SAVEPOINT UPDATE_PERZ_DDF_PUB;
683:
684: -- Standard call to check for call compatibility.
685: -- IF NOT FND_API.Compatible_API_Call (
686: -- l_api_version_number,
687: -- p_api_version_number,
688: -- l_api_name,
689: -- G_PKG_NAME)

Line 691: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

687: -- p_api_version_number,
688: -- l_api_name,
689: -- G_PKG_NAME)
690: -- THEN
691: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: -- END IF;
693:
694: -- Initialize message list if p_init_msg_list is set to TRUE.
695: IF FND_API.to_Boolean( p_init_msg_list )

Line 695: IF FND_API.to_Boolean( p_init_msg_list )

691: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: -- END IF;
693:
694: -- Initialize message list if p_init_msg_list is set to TRUE.
695: IF FND_API.to_Boolean( p_init_msg_list )
696: THEN
697: FND_MSG_PUB.initialize;
698: END IF;
699:

Line 701: x_return_status := FND_API.G_RET_STS_SUCCESS;

697: FND_MSG_PUB.initialize;
698: END IF;
699:
700: -- Initialize API return status to success
701: x_return_status := FND_API.G_RET_STS_SUCCESS;
702:
703: JTF_PERZ_DDF_PVT.delete_data_default
704: ( p_api_version_number ,
705: p_init_msg_list ,

Line 724: IF FND_API.To_Boolean ( p_commit )

720: --
721: -- 7. Commit the whole thing
722:
723: -- Standard check of p_commit.
724: IF FND_API.To_Boolean ( p_commit )
725: THEN
726: COMMIT WORK;
727: END IF;
728:

Line 740: WHEN FND_API.G_EXC_ERROR THEN

736:
737:
738: EXCEPTION
739:
740: WHEN FND_API.G_EXC_ERROR THEN
741:
742: ROLLBACK TO DELETE_PERZ_DDF_PUB;
743: x_return_status := FND_API.G_RET_STS_ERROR ;
744:

Line 743: x_return_status := FND_API.G_RET_STS_ERROR ;

739:
740: WHEN FND_API.G_EXC_ERROR THEN
741:
742: ROLLBACK TO DELETE_PERZ_DDF_PUB;
743: x_return_status := FND_API.G_RET_STS_ERROR ;
744:
745: FND_MSG_PUB.Count_And_Get
746: ( p_count => x_msg_count,
747: p_data => x_msg_data

Line 755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

751: THEN
752: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
753: END IF;
754:
755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
756:
757: ROLLBACK TO DELETE_PERZ_DDF_PUB;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759:

Line 758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

754:
755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
756:
757: ROLLBACK TO DELETE_PERZ_DDF_PUB;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
759:
760: FND_MSG_PUB.Count_And_Get
761: ( p_count => x_msg_count,
762: p_data => x_msg_data

Line 773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

769:
770: WHEN OTHERS THEN
771:
772: ROLLBACK TO DELETE_PERZ_DDF_PUB;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
774:
775: FND_MSG_PUB.Count_And_Get
776: ( p_count => x_msg_count,
777: p_data => x_msg_data