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

Line 154: -- Default = FND_API.G_FALSE

150: -- Pre-reqs : None.
151: -- Parameters :
152: -- IN : p_api_version IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_commit IN VARCHAR2 Optional
156: -- Default = FND_API.G_FALSE
157: -- p_validation_level IN NUMBER Optional
158: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 156: -- Default = FND_API.G_FALSE

152: -- IN : p_api_version IN NUMBER Required
153: -- p_init_msg_list IN VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_commit IN VARCHAR2 Optional
156: -- Default = FND_API.G_FALSE
157: -- p_validation_level IN NUMBER Optional
158: -- Default = FND_API.G_VALID_LEVEL_FULL
159: -- p_default_all
160: -- p_type

Line 158: -- Default = FND_API.G_VALID_LEVEL_FULL

154: -- Default = FND_API.G_FALSE
155: -- p_commit IN VARCHAR2 Optional
156: -- Default = FND_API.G_FALSE
157: -- p_validation_level IN NUMBER Optional
158: -- Default = FND_API.G_VALID_LEVEL_FULL
159: -- p_default_all
160: -- p_type
161: -- OUT : x_return_status OUT VARCHAR2(1)
162: -- x_msg_count OUT NUMBER

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

172: -- End of comments
173:
174: PROCEDURE Get_Valid_Plan_Statuses
175: ( p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_default_all IN VARCHAR2 := FND_API.G_FALSE,
180: p_type IN VARCHAR2 := 'COMPPLANPROCESS',

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

173:
174: PROCEDURE Get_Valid_Plan_Statuses
175: ( p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_default_all IN VARCHAR2 := FND_API.G_FALSE,
180: p_type IN VARCHAR2 := 'COMPPLANPROCESS',
181: x_values_tab OUT NOCOPY string_tabletype,

Line 178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

174: PROCEDURE Get_Valid_Plan_Statuses
175: ( p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_default_all IN VARCHAR2 := FND_API.G_FALSE,
180: p_type IN VARCHAR2 := 'COMPPLANPROCESS',
181: x_values_tab OUT NOCOPY string_tabletype,
182: x_meanings_tab OUT NOCOPY string_tabletype,

Line 179: p_default_all IN VARCHAR2 := FND_API.G_FALSE,

175: ( p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179: p_default_all IN VARCHAR2 := FND_API.G_FALSE,
180: p_type IN VARCHAR2 := 'COMPPLANPROCESS',
181: x_values_tab OUT NOCOPY string_tabletype,
182: x_meanings_tab OUT NOCOPY string_tabletype,
183: x_return_status OUT NOCOPY VARCHAR2 ,

Line 209: IF NOT FND_API.compatible_api_call

205: BEGIN
206:
207: SAVEPOINT Get_Valid_Plan_Statuses;
208: -- Standard call to check for call compatibility.
209: IF NOT FND_API.compatible_api_call
210: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
211: THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: -- Standard call to check for call compatibility.
209: IF NOT FND_API.compatible_api_call
210: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
211: THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214:
215: -- Initialize message list if p_init_msg_list is set to TRUE.
216: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 216: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 220: x_return_status := FND_API.G_RET_STS_SUCCESS;

216: IF FND_API.to_Boolean( p_init_msg_list ) THEN
217: FND_MSG_PUB.initialize;
218: END IF;
219: -- Initialize API return status to success
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221:
222: -- API body
223: l_resp_group := FND_PROFILE.VALUE('CN_SFP_RESP_GROUP');
224:

Line 231: RAISE FND_API.G_EXC_ERROR;

227: THEN
228: FND_MESSAGE.SET_NAME('CN', 'CN_QM_NO_RESP_GROUP');
229: FND_MSG_PUB.Add;
230: END IF;
231: RAISE FND_API.G_EXC_ERROR;
232: END IF;
233:
234: -- Comp Plan Process (Many types can be added)
235:

Line 265: IF (p_default_all = FND_API.G_TRUE) THEN

261:
262:
263: -- Rest of the logic should remain the same
264:
265: IF (p_default_all = FND_API.G_TRUE) THEN
266: x_values_tab(l_counter) := '%';
267: x_meanings_tab(l_counter) := FND_MESSAGE.GET_STRING('CN','CN_ALL');
268: END IF;
269:

Line 286: IF FND_API.To_Boolean( p_commit ) THEN

282: << end_Get_Valid_Plan_Statuses >>
283: NULL;
284:
285: -- Standard check of p_commit.
286: IF FND_API.To_Boolean( p_commit ) THEN
287: COMMIT WORK;
288: END IF;
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get

Line 294: p_encoded => FND_API.G_FALSE

290: FND_MSG_PUB.Count_And_Get
291: (
292: p_count => x_msg_count ,
293: p_data => x_msg_data ,
294: p_encoded => FND_API.G_FALSE
295: );
296:
297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN

Line 298: WHEN FND_API.G_EXC_ERROR THEN

294: p_encoded => FND_API.G_FALSE
295: );
296:
297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN
299: ROLLBACK TO Get_Valid_Plan_Statuses ;
300: x_return_status := FND_API.G_RET_STS_ERROR ;
301: FND_MSG_PUB.Count_And_Get
302: (

Line 300: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 305: p_encoded => FND_API.G_FALSE

301: FND_MSG_PUB.Count_And_Get
302: (
303: p_count => x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE
306: );
307:
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309: ROLLBACK TO Get_Valid_Plan_Statuses ;

Line 308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

304: p_data => x_msg_data ,
305: p_encoded => FND_API.G_FALSE
306: );
307:
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309: ROLLBACK TO Get_Valid_Plan_Statuses ;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: FND_MSG_PUB.Count_And_Get
312: (

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

306: );
307:
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309: ROLLBACK TO Get_Valid_Plan_Statuses ;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: FND_MSG_PUB.Count_And_Get
312: (
313: p_count => x_msg_count ,
314: p_data => x_msg_data ,

Line 315: p_encoded => FND_API.G_FALSE

311: FND_MSG_PUB.Count_And_Get
312: (
313: p_count => x_msg_count ,
314: p_data => x_msg_data ,
315: p_encoded => FND_API.G_FALSE
316: );
317: WHEN OTHERS THEN
318: ROLLBACK TO Get_Valid_Plan_Statuses ;
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

315: p_encoded => FND_API.G_FALSE
316: );
317: WHEN OTHERS THEN
318: ROLLBACK TO Get_Valid_Plan_Statuses ;
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320: FND_MSG_PUB.Count_And_Get
321: (
322: p_count => x_msg_count ,
323: p_data => x_msg_data ,

Line 324: p_encoded => FND_API.G_FALSE

320: FND_MSG_PUB.Count_And_Get
321: (
322: p_count => x_msg_count ,
323: p_data => x_msg_data ,
324: p_encoded => FND_API.G_FALSE
325: );
326: END Get_Valid_Plan_Statuses;
327:
328:

Line 339: -- Default = FND_API.G_FALSE

335: -- Prereqs : None.
336: -- Parameters :
337: -- IN : p_api_version IN NUMBER Required
338: -- p_init_msg_list IN VARCHAR2 Optional
339: -- Default = FND_API.G_FALSE
340: -- p_commit IN VARCHAR2 Optional
341: -- Default = FND_API.G_FALSE
342: -- p_validation_level IN NUMBER Optional
343: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 341: -- Default = FND_API.G_FALSE

337: -- IN : p_api_version IN NUMBER Required
338: -- p_init_msg_list IN VARCHAR2 Optional
339: -- Default = FND_API.G_FALSE
340: -- p_commit IN VARCHAR2 Optional
341: -- Default = FND_API.G_FALSE
342: -- p_validation_level IN NUMBER Optional
343: -- Default = FND_API.G_VALID_LEVEL_FULL
344: -- x_update_groups OUT DBMS_SQL.NUMBER_TABLE,
345: -- x_view_groups OUT DBMS_SQL.NUMBER_TABLE,

Line 343: -- Default = FND_API.G_VALID_LEVEL_FULL

339: -- Default = FND_API.G_FALSE
340: -- p_commit IN VARCHAR2 Optional
341: -- Default = FND_API.G_FALSE
342: -- p_validation_level IN NUMBER Optional
343: -- Default = FND_API.G_VALID_LEVEL_FULL
344: -- x_update_groups OUT DBMS_SQL.NUMBER_TABLE,
345: -- x_view_groups OUT DBMS_SQL.NUMBER_TABLE,
346: -- OUT : x_return_status OUT VARCHAR2(1)
347: -- x_msg_count OUT NUMBER

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

356: -- End of comments
357:
358: PROCEDURE Get_All_Groups_Access
359: ( p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
361: p_commit IN VARCHAR2 := FND_API.G_FALSE,
362: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
363: p_org_code IN VARCHAR2 := NULL,
364: p_date IN VARCHAR2,

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

357:
358: PROCEDURE Get_All_Groups_Access
359: ( p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
361: p_commit IN VARCHAR2 := FND_API.G_FALSE,
362: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
363: p_org_code IN VARCHAR2 := NULL,
364: p_date IN VARCHAR2,
365: x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

Line 362: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

358: PROCEDURE Get_All_Groups_Access
359: ( p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
361: p_commit IN VARCHAR2 := FND_API.G_FALSE,
362: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
363: p_org_code IN VARCHAR2 := NULL,
364: p_date IN VARCHAR2,
365: x_update_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
366: x_view_groups OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

Line 412: IF NOT FND_API.compatible_api_call

408:
409: BEGIN
410: SAVEPOINT Get_All_Groups_Access;
411: -- Standard call to check for call compatibility.
412: IF NOT FND_API.compatible_api_call
413: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
414: THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;

Line 415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

411: -- Standard call to check for call compatibility.
412: IF NOT FND_API.compatible_api_call
413: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
414: THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 419: IF FND_API.to_Boolean( p_init_msg_list ) THEN

415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean( p_init_msg_list ) THEN
420: FND_MSG_PUB.initialize;
421: END IF;
422: -- Initialize API return status to success
423: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 423: x_return_status := FND_API.G_RET_STS_SUCCESS;

419: IF FND_API.to_Boolean( p_init_msg_list ) THEN
420: FND_MSG_PUB.initialize;
421: END IF;
422: -- Initialize API return status to success
423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424:
425: l_resp_group := fnd_profile.value('CN_SFP_RESP_GROUP');
426: IF l_resp_group IS null THEN
427: IF FND_MSG_PUB.Check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 432: RAISE FND_API.G_EXC_ERROR;

428: THEN
429: FND_MESSAGE.SET_NAME('CN', 'CN_QM_NO_RESP_GROUP');
430: FND_MSG_PUB.Add;
431: END IF;
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;
434:
435: IF l_resp_group <> 'CN_SF_FINANCE_MGR' THEN
436: RETURN ;

Line 486: WHEN FND_API.G_EXC_ERROR THEN

482: END IF ;
483:
484:
485: EXCEPTION
486: WHEN FND_API.G_EXC_ERROR THEN
487: ROLLBACK TO Get_All_Groups_Access ;
488: x_return_status := FND_API.G_RET_STS_ERROR ;
489: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
490: p_data => x_msg_data ,

Line 488: x_return_status := FND_API.G_RET_STS_ERROR ;

484:
485: EXCEPTION
486: WHEN FND_API.G_EXC_ERROR THEN
487: ROLLBACK TO Get_All_Groups_Access ;
488: x_return_status := FND_API.G_RET_STS_ERROR ;
489: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
490: p_data => x_msg_data ,
491: p_encoded => FND_API.G_FALSE);
492:

Line 491: p_encoded => FND_API.G_FALSE);

487: ROLLBACK TO Get_All_Groups_Access ;
488: x_return_status := FND_API.G_RET_STS_ERROR ;
489: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
490: p_data => x_msg_data ,
491: p_encoded => FND_API.G_FALSE);
492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: ROLLBACK TO Get_All_Groups_Access ;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

489: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
490: p_data => x_msg_data ,
491: p_encoded => FND_API.G_FALSE);
492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: ROLLBACK TO Get_All_Groups_Access ;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
497: p_data => x_msg_data ,

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

491: p_encoded => FND_API.G_FALSE);
492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494: ROLLBACK TO Get_All_Groups_Access ;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
497: p_data => x_msg_data ,
498: p_encoded => FND_API.G_FALSE);
499: WHEN OTHERS THEN

Line 498: p_encoded => FND_API.G_FALSE);

494: ROLLBACK TO Get_All_Groups_Access ;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
497: p_data => x_msg_data ,
498: p_encoded => FND_API.G_FALSE);
499: WHEN OTHERS THEN
500: ROLLBACK TO Get_All_Groups_Access ;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

497: p_data => x_msg_data ,
498: p_encoded => FND_API.G_FALSE);
499: WHEN OTHERS THEN
500: ROLLBACK TO Get_All_Groups_Access ;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
503: THEN
504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
505: END IF ;

Line 509: p_encoded => FND_API.G_FALSE);

505: END IF ;
506: cn_message_pkg.debug(G_PKG_NAME || ' ' || l_api_name ||' '||TO_CHAR(SQLCODE)||': '||SQLERRM) ;
507: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
508: p_data => x_msg_data ,
509: p_encoded => FND_API.G_FALSE);
510: END Get_All_Groups_Access;
511:
512:
513: -- Start of comments

Line 521: -- Default = FND_API.G_FALSE

517: -- Prereqs : None.
518: -- Parameters :
519: -- IN : p_api_version IN NUMBER Required
520: -- p_init_msg_list IN VARCHAR2 Optional
521: -- Default = FND_API.G_FALSE
522: -- p_commit IN VARCHAR2 Optional
523: -- Default = FND_API.G_FALSE
524: -- p_validation_level IN NUMBER Optional
525: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 523: -- Default = FND_API.G_FALSE

519: -- IN : p_api_version IN NUMBER Required
520: -- p_init_msg_list IN VARCHAR2 Optional
521: -- Default = FND_API.G_FALSE
522: -- p_commit IN VARCHAR2 Optional
523: -- Default = FND_API.G_FALSE
524: -- p_validation_level IN NUMBER Optional
525: -- Default = FND_API.G_VALID_LEVEL_FULL
526: -- p_default_all
527: -- p_group_id

Line 525: -- Default = FND_API.G_VALID_LEVEL_FULL

521: -- Default = FND_API.G_FALSE
522: -- p_commit IN VARCHAR2 Optional
523: -- Default = FND_API.G_FALSE
524: -- p_validation_level IN NUMBER Optional
525: -- Default = FND_API.G_VALID_LEVEL_FULL
526: -- p_default_all
527: -- p_group_id
528: -- p_update_groups IN DBMS_SQL.NUMBER_TABLE,
529: -- p_view_groups IN DBMS_SQL.NUMBER_TABLE,

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

539: -- End of comments
540:
541: PROCEDURE Get_Group_Access
542: ( p_api_version IN NUMBER,
543: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
544: p_commit IN VARCHAR2 := FND_API.G_FALSE,
545: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
546: p_group_id IN NUMBER,
547: p_update_groups IN DBMS_SQL.NUMBER_TABLE,

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

540:
541: PROCEDURE Get_Group_Access
542: ( p_api_version IN NUMBER,
543: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
544: p_commit IN VARCHAR2 := FND_API.G_FALSE,
545: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
546: p_group_id IN NUMBER,
547: p_update_groups IN DBMS_SQL.NUMBER_TABLE,
548: p_view_groups IN DBMS_SQL.NUMBER_TABLE,

Line 545: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

541: PROCEDURE Get_Group_Access
542: ( p_api_version IN NUMBER,
543: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
544: p_commit IN VARCHAR2 := FND_API.G_FALSE,
545: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
546: p_group_id IN NUMBER,
547: p_update_groups IN DBMS_SQL.NUMBER_TABLE,
548: p_view_groups IN DBMS_SQL.NUMBER_TABLE,
549: x_privilege OUT NOCOPY VARCHAR2,

Line 561: IF NOT FND_API.compatible_api_call

557:
558: BEGIN
559: SAVEPOINT Get_Group_Access;
560: -- Standard call to check for call compatibility.
561: IF NOT FND_API.compatible_api_call
562: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
563: THEN
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END IF;

Line 564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

560: -- Standard call to check for call compatibility.
561: IF NOT FND_API.compatible_api_call
562: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
563: THEN
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END IF;
566:
567: -- Initialize message list if p_init_msg_list is set to TRUE.
568: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 568: IF FND_API.to_Boolean( p_init_msg_list ) THEN

564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565: END IF;
566:
567: -- Initialize message list if p_init_msg_list is set to TRUE.
568: IF FND_API.to_Boolean( p_init_msg_list ) THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571: -- Initialize API return status to success
572: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 572: x_return_status := FND_API.G_RET_STS_SUCCESS;

568: IF FND_API.to_Boolean( p_init_msg_list ) THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571: -- Initialize API return status to success
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573:
574: IF contains(p_group_id,p_update_groups) THEN
575: --dbms_output.put_line('IRead Only');
576: x_privilege := 'WRITE' ;

Line 589: WHEN FND_API.G_EXC_ERROR THEN

585:
586: x_privilege := 'NO_READ' ;
587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: ROLLBACK TO Get_Group_Access ;
591: x_return_status := FND_API.G_RET_STS_ERROR ;
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
593: p_data => x_msg_data ,

Line 591: x_return_status := FND_API.G_RET_STS_ERROR ;

587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: ROLLBACK TO Get_Group_Access ;
591: x_return_status := FND_API.G_RET_STS_ERROR ;
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
593: p_data => x_msg_data ,
594: p_encoded => FND_API.G_FALSE);
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 594: p_encoded => FND_API.G_FALSE);

590: ROLLBACK TO Get_Group_Access ;
591: x_return_status := FND_API.G_RET_STS_ERROR ;
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
593: p_data => x_msg_data ,
594: p_encoded => FND_API.G_FALSE);
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO Get_Group_Access ;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,

Line 595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

591: x_return_status := FND_API.G_RET_STS_ERROR ;
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
593: p_data => x_msg_data ,
594: p_encoded => FND_API.G_FALSE);
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO Get_Group_Access ;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
599: p_data => x_msg_data ,

Line 597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

593: p_data => x_msg_data ,
594: p_encoded => FND_API.G_FALSE);
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO Get_Group_Access ;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
599: p_data => x_msg_data ,
600: p_encoded => FND_API.G_FALSE);
601: WHEN OTHERS THEN

Line 600: p_encoded => FND_API.G_FALSE);

596: ROLLBACK TO Get_Group_Access ;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
599: p_data => x_msg_data ,
600: p_encoded => FND_API.G_FALSE);
601: WHEN OTHERS THEN
602: ROLLBACK TO Get_Group_Access ;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
604: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

599: p_data => x_msg_data ,
600: p_encoded => FND_API.G_FALSE);
601: WHEN OTHERS THEN
602: ROLLBACK TO Get_Group_Access ;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
604: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
605: THEN
606: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
607: END IF ;

Line 610: p_encoded => FND_API.G_FALSE);

606: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name) ;
607: END IF ;
608: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count ,
609: p_data => x_msg_data ,
610: p_encoded => FND_API.G_FALSE);
611: END Get_Group_Access;
612:
613: END CN_SFP_SRP_UTIL_PVT;