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

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

25: G_FILE_NAME CONSTANT VARCHAR2(12):='jtfpplfb.pls';
26:
27: PROCEDURE Create_lf_object
28: ( p_api_version_number IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31:
32: p_profile_id IN NUMBER,
33: p_profile_name IN VARCHAR2,

Line 30: p_commit IN VARCHAR2 := FND_API.G_FALSE,

26:
27: PROCEDURE Create_lf_object
28: ( p_api_version_number IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31:
32: p_profile_id IN NUMBER,
33: p_profile_name IN VARCHAR2,
34:

Line 56: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

52: -- ******* Local Variables ********
53:
54: l_api_version_number NUMBER := p_api_version_number;
55: l_api_name CONSTANT VARCHAR2(30) := 'Create Object';
56: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
57:
58: BEGIN
59:
60: -- ******* Standard Begins ********

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

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

Line 68: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 72: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 78: l_return_status := FND_API.G_RET_STS_SUCCESS;

74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: -- Initialize API return status to success
78: l_return_status := FND_API.G_RET_STS_SUCCESS;
79:
80: JTF_PERZ_LF_PVT. Create_lf_object
81: ( p_api_version_number,
82: p_init_msg_list,

Line 107: IF FND_API.To_Boolean ( p_commit )

103: --
104: -- 7. Commit the whole thing
105:
106: -- Standard check of p_commit.
107: IF FND_API.To_Boolean ( p_commit )
108: THEN
109: COMMIT WORK;
110: END IF;
111:

Line 123: WHEN FND_API.G_EXC_ERROR THEN

119:
120:
121: EXCEPTION
122:
123: WHEN FND_API.G_EXC_ERROR THEN
124:
125: ROLLBACK TO CREATE_PERZ_LF_PUB;
126: x_return_status := FND_API.G_RET_STS_ERROR ;
127:

Line 126: x_return_status := FND_API.G_RET_STS_ERROR ;

122:
123: WHEN FND_API.G_EXC_ERROR THEN
124:
125: ROLLBACK TO CREATE_PERZ_LF_PUB;
126: x_return_status := FND_API.G_RET_STS_ERROR ;
127:
128: FND_MSG_PUB.Count_And_Get
129: ( p_count => x_msg_count,
130: p_data => x_msg_data

Line 138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

134: THEN
135: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
136: END IF;
137:
138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
139:
140: ROLLBACK TO CREATE_PERZ_LF_PUB;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142:

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

137:
138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
139:
140: ROLLBACK TO CREATE_PERZ_LF_PUB;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142:
143: FND_MSG_PUB.Count_And_Get
144: ( p_count => x_msg_count,
145: p_data => x_msg_data

Line 156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

152:
153: WHEN OTHERS THEN
154:
155: ROLLBACK TO CREATE_PERZ_LF_PUB;
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
157:
158: FND_MSG_PUB.Count_And_Get
159: ( p_count => x_msg_count,
160: p_data => x_msg_data

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

170:
171: -- *****************************************************************************
172: PROCEDURE Update_lf_object
173: ( p_api_version_number IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176:
177: p_profile_id IN NUMBER,
178: p_profile_name IN VARCHAR2,

Line 175: p_commit IN VARCHAR2 := FND_API.G_FALSE,

171: -- *****************************************************************************
172: PROCEDURE Update_lf_object
173: ( p_api_version_number IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176:
177: p_profile_id IN NUMBER,
178: p_profile_name IN VARCHAR2,
179:

Line 201: l_return_status VARCHAR2(1) := FND_API.G_TRUE;

197:
198: -- ******* Update_lf_object Local Variables ********
199: l_api_version_number NUMBER := p_api_version_number;
200: l_api_name VARCHAR2(60) := 'Update Object';
201: l_return_status VARCHAR2(1) := FND_API.G_TRUE;
202:
203: BEGIN
204:
205: -- ******* Standard Begins ********

Line 211: --IF NOT FND_API.Compatible_API_Call

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

Line 214: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 218: IF FND_API.to_Boolean( p_init_msg_list ) THEN

214: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: --END IF;
216:
217: -- Initialize message list if p_init_msg_list is set to TRUE.
218: IF FND_API.to_Boolean( p_init_msg_list ) THEN
219: FND_MSG_PUB.initialize;
220: END IF;
221:
222: -- Initialize API return status to success

Line 251: IF FND_API.To_Boolean ( p_commit )

247: --
248: -- 5. Commit the whole thing
249:
250: -- Standard check of p_commit.
251: IF FND_API.To_Boolean ( p_commit )
252: THEN
253: COMMIT WORK;
254: END IF;
255:

Line 266: WHEN FND_API.G_EXC_ERROR THEN

262:
263:
264: EXCEPTION
265:
266: WHEN FND_API.G_EXC_ERROR THEN
267:
268: ROLLBACK TO UPDATE_PERZ_LF_PUB;
269: x_return_status := FND_API.G_RET_STS_ERROR ;
270:

Line 269: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

278: THEN
279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
280: END IF;
281:
282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
283:
284: ROLLBACK TO UPDATE_PERZ_LF_PUB;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
286:

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

281:
282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
283:
284: ROLLBACK TO UPDATE_PERZ_LF_PUB;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
286:
287: FND_MSG_PUB.Count_And_Get
288: ( p_count => x_msg_count,
289: p_data => x_msg_data

Line 300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

296:
297: WHEN OTHERS THEN
298:
299: ROLLBACK TO UPDATE_PERZ_LF_PUB;
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301:
302: FND_MSG_PUB.Count_And_Get
303: ( p_count => x_msg_count,
304: p_data => x_msg_data

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

312: -- *****************************************************************************
313:
314: PROCEDURE save_lf_object
315: ( p_api_version_number IN NUMBER,
316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
317: p_commit IN VARCHAR2 := FND_API.G_FALSE,
318: p_profile_id IN NUMBER,
319: p_profile_name IN VARCHAR2,
320: p_profile_type IN VARCHAR2,

Line 317: p_commit IN VARCHAR2 := FND_API.G_FALSE,

313:
314: PROCEDURE save_lf_object
315: ( p_api_version_number IN NUMBER,
316: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
317: p_commit IN VARCHAR2 := FND_API.G_FALSE,
318: p_profile_id IN NUMBER,
319: p_profile_name IN VARCHAR2,
320: p_profile_type IN VARCHAR2,
321: p_profile_attrib_tbl IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE

Line 342: l_return_status VARCHAR2(60) := FND_API.G_RET_STS_SUCCESS;

338: )IS
339:
340: -- ******* save_lf_object Local Variables ********
341: l_api_version_number NUMBER := p_api_version_number;
342: l_return_status VARCHAR2(60) := FND_API.G_RET_STS_SUCCESS;
343: l_api_name CONSTANT VARCHAR2(30) := 'Personalize LF Object';
344:
345: BEGIN
346:

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

349: -- Standard Start of API savepoint
350: SAVEPOINT PERSONALIZE_LF_OBJECT_PUB;
351:
352: -- Standard call to check for call compatibility.
353: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
354: THEN
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: END IF;
357:

Line 355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 359: IF FND_API.to_Boolean( p_init_msg_list )

355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: END IF;
357:
358: -- Initialize message list if p_init_msg_list is set to TRUE.
359: IF FND_API.to_Boolean( p_init_msg_list )
360: THEN
361: FND_MSG_PUB.initialize;
362: END IF;
363:

Line 390: if (l_return_status = FND_API.G_RET_STS_SUCCESS) then

386:
387: x_return_status := l_return_status;
388:
389: -- update the description of the object, not being done in the PVT package !
390: if (l_return_status = FND_API.G_RET_STS_SUCCESS) then
391: UPDATE JTF_PERZ_LF_OBJECT SET OBJECT_DESCRIPTION = p_object_description WHERE OBJECT_ID = x_object_id;
392: end if;
393:
394:

Line 401: IF FND_API.To_Boolean ( p_commit )

397: -- End of API body.
398: --
399:
400: -- Standard check of p_commit.
401: IF FND_API.To_Boolean ( p_commit )
402: THEN
403: COMMIT WORK;
404: END IF;
405:

Line 416: WHEN FND_API.G_EXC_ERROR THEN

412:
413:
414: EXCEPTION
415:
416: WHEN FND_API.G_EXC_ERROR THEN
417:
418: ROLLBACK TO PERSONALIZE_LF_OBJECT_PUB;
419: x_return_status := FND_API.G_RET_STS_ERROR ;
420:

Line 419: x_return_status := FND_API.G_RET_STS_ERROR ;

415:
416: WHEN FND_API.G_EXC_ERROR THEN
417:
418: ROLLBACK TO PERSONALIZE_LF_OBJECT_PUB;
419: x_return_status := FND_API.G_RET_STS_ERROR ;
420:
421: FND_MSG_PUB.Count_And_Get
422: ( p_count => x_msg_count,
423: p_data => x_msg_data

Line 431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

427: THEN
428: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
429: END IF;
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432:
433: ROLLBACK TO PERSONALIZE_LF_OBJECT_PUB;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435:

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432:
433: ROLLBACK TO PERSONALIZE_LF_OBJECT_PUB;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435:
436: FND_MSG_PUB.Count_And_Get
437: ( p_count => x_msg_count,
438: p_data => x_msg_data

Line 449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

445:
446: WHEN OTHERS THEN
447:
448: ROLLBACK TO PERSONALIZE_LF_OBJECT_PUB;
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
450:
451: FND_MSG_PUB.Count_And_Get
452: ( p_count => x_msg_count,
453: p_data => x_msg_data

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

461:
462: -- ***************************************************************************
463: PROCEDURE Get_lf_object
464: ( p_api_version_number IN NUMBER,
465: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
466:
467: p_application_id IN NUMBER,
468: p_priority IN NUMBER,
469: p_profile_id IN NUMBER,

Line 481: l_return_status VARCHAR2(60) := FND_API.G_RET_STS_SUCCESS;

477: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
478: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
479: )IS
480: l_api_version_number NUMBER := p_api_version_number;
481: l_return_status VARCHAR2(60) := FND_API.G_RET_STS_SUCCESS;
482: l_api_name CONSTANT VARCHAR2(30) := 'Personalize LF Object';
483:
484: BEGIN
485:

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

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

Line 491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 495: IF FND_API.to_Boolean( p_init_msg_list )

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

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

525:
526: -- ***************************************************************************
527: PROCEDURE save_lf_object_type
528: ( p_api_version_number IN NUMBER,
529: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
530: p_commit IN VARCHAR2 := FND_API.G_FALSE,
531:
532: p_object_type_id IN NUMBER,
533: p_object_type IN VARCHAR2,

Line 530: p_commit IN VARCHAR2 := FND_API.G_FALSE,

526: -- ***************************************************************************
527: PROCEDURE save_lf_object_type
528: ( p_api_version_number IN NUMBER,
529: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
530: p_commit IN VARCHAR2 := FND_API.G_FALSE,
531:
532: p_object_type_id IN NUMBER,
533: p_object_type IN VARCHAR2,
534: p_object_type_desc IN VARCHAR2,

Line 547: l_return_status VARCHAR2(60) := FND_API.G_RET_STS_SUCCESS;

543: )IS
544:
545: -- ******* save_lf_object Local Variables ********
546: l_api_version_number NUMBER := p_api_version_number;
547: l_return_status VARCHAR2(60) := FND_API.G_RET_STS_SUCCESS;
548: l_api_name CONSTANT VARCHAR2(30) := 'Personalize LF Object';
549:
550: l_obj_type_map_tbl JTF_PERZ_LF_PVT.OBJ_TYPE_MAP_TBL_TYPE;
551: BEGIN

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

555: -- Standard Start of API savepoint
556: SAVEPOINT save_lf_object_type;
557:
558: -- Standard call to check for call compatibility.
559: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
560: THEN
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;
563:

Line 561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

557:
558: -- Standard call to check for call compatibility.
559: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
560: THEN
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;
563:
564: -- Initialize message list if p_init_msg_list is set to TRUE.
565: IF FND_API.to_Boolean( p_init_msg_list )

Line 565: IF FND_API.to_Boolean( p_init_msg_list )

561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562: END IF;
563:
564: -- Initialize message list if p_init_msg_list is set to TRUE.
565: IF FND_API.to_Boolean( p_init_msg_list )
566: THEN
567: FND_MSG_PUB.initialize;
568: END IF;
569:

Line 593: IF FND_API.To_Boolean ( p_commit )

589: -- End of API body.
590: --
591:
592: -- Standard check of p_commit.
593: IF FND_API.To_Boolean ( p_commit )
594: THEN
595: COMMIT WORK;
596: END IF;
597:

Line 608: WHEN FND_API.G_EXC_ERROR THEN

604:
605:
606: EXCEPTION
607:
608: WHEN FND_API.G_EXC_ERROR THEN
609:
610: ROLLBACK TO save_lf_object_type;
611: x_return_status := FND_API.G_RET_STS_ERROR ;
612:

Line 611: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

652: END save_lf_object_type;
653: -- ***************************************************************************
654: PROCEDURE Get_lf_object_type
655: ( p_api_version_number IN NUMBER,
656: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
657:
658: p_Object_type IN VARCHAR,
659: p_Object_type_Id IN NUMBER,
660:

Line 671: l_return_status VARCHAR2(60) := FND_API.G_RET_STS_SUCCESS;

667: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
668: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
669: )IS
670: l_api_version_number NUMBER := p_api_version_number;
671: l_return_status VARCHAR2(60) := FND_API.G_RET_STS_SUCCESS;
672: l_api_name CONSTANT VARCHAR2(30) := 'Personalize LF Object';
673:
674: BEGIN
675:

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

675:
676: -- ******* Standard Begins ********
677:
678: -- Standard call to check for call compatibility.
679: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
680: THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: END IF;
683:

Line 681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

677:
678: -- Standard call to check for call compatibility.
679: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number, l_api_name, G_PKG_NAME)
680: THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: END IF;
683:
684: -- Initialize message list if p_init_msg_list is set to TRUE.
685: IF FND_API.to_Boolean( p_init_msg_list )

Line 685: IF FND_API.to_Boolean( p_init_msg_list )

681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: END IF;
683:
684: -- Initialize message list if p_init_msg_list is set to TRUE.
685: IF FND_API.to_Boolean( p_init_msg_list )
686: THEN
687: FND_MSG_PUB.initialize;
688: END IF;
689: