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

Line 89: -- DEFAULT = FND_API.G_FALSE

85: -- Parameters:
86: -- IN : p_api_version IN NUMBER (required)
87: -- API Version of this procedure
88: -- p_init_msg_level IN VARCHAR2 (optional)
89: -- DEFAULT = FND_API.G_FALSE
90: -- Indicates whether the message stack needs to be cleared
91: -- p_commit IN VARCHAR2 (optional)
92: -- DEFAULT = FND_API.G_FALSE
93: -- Indicates whether the data should be committed

Line 92: -- DEFAULT = FND_API.G_FALSE

88: -- p_init_msg_level IN VARCHAR2 (optional)
89: -- DEFAULT = FND_API.G_FALSE
90: -- Indicates whether the message stack needs to be cleared
91: -- p_commit IN VARCHAR2 (optional)
92: -- DEFAULT = FND_API.G_FALSE
93: -- Indicates whether the data should be committed
94: -- p_subject_id IN NUMBER (required)
95: -- Subject on which the relationship needs to be created
96: -- Eg., A person

Line 114: -- p_relationship_type IN VARCHAR2 := fnd_api.g_MISS_CHAR

110: -- Table in which the object is available
111: -- Eg., HZ_PARTIES
112: -- p_relationship_code IN VARCHAR2 (required)
113: -- Current values are MEMBER_OF wrt subject
114: -- p_relationship_type IN VARCHAR2 := fnd_api.g_MISS_CHAR
115: -- Forward OR Backward. Default is Bi-directional
116: -- p_program_name IN VARCHAR2 (required)
117: -- Program name to identify the creator of the record
118: -- p_start_date IN DATE (required)

Line 123: -- FND_API.G_RET_STS_SUCCESS if success

119: -- Record is valid from..
120: --
121: -- OUT : x_return_status OUT NUMBER
122: -- Result of all the operations
123: -- FND_API.G_RET_STS_SUCCESS if success
124: -- FND_API.G_RET_STS_ERROR if error
125: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
126: -- x_msg_count OUT NUMBER
127: -- number of messages in the message list

Line 124: -- FND_API.G_RET_STS_ERROR if error

120: --
121: -- OUT : x_return_status OUT NUMBER
122: -- Result of all the operations
123: -- FND_API.G_RET_STS_SUCCESS if success
124: -- FND_API.G_RET_STS_ERROR if error
125: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
126: -- x_msg_count OUT NUMBER
127: -- number of messages in the message list
128: -- x_msg_data OUT VARCHAR2

Line 125: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

121: -- OUT : x_return_status OUT NUMBER
122: -- Result of all the operations
123: -- FND_API.G_RET_STS_SUCCESS if success
124: -- FND_API.G_RET_STS_ERROR if error
125: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
126: -- x_msg_count OUT NUMBER
127: -- number of messages in the message list
128: -- x_msg_data OUT VARCHAR2
129: -- if number of messages is 1, then this parameter

Line 203: x_return_status := FND_API.G_RET_STS_ERROR;

199:
200: --
201: IF l_member_already_exists THEN
202: x_relationship_id := l_relationship_id;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: x_msg_count := 1;
205: fnd_message.set_name('EGO','EGO_RELATION_EXISTS');
206: fnd_msg_pub.add;
207: ELSE

Line 209: IF FND_API.TO_BOOLEAN(p_commit) THEN

205: fnd_message.set_name('EGO','EGO_RELATION_EXISTS');
206: fnd_msg_pub.add;
207: ELSE
208: -- Standard Start of API savepoint
209: IF FND_API.TO_BOOLEAN(p_commit) THEN
210: SAVEPOINT EGO_CREATE_RELATIONSHIP;
211: END IF;
212: mdebug('. CREATE_RELATIONSHIP: Creating Relationship .....1...... ');
213: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 213: IF NOT FND_API.Compatible_API_Call (l_api_version,

209: IF FND_API.TO_BOOLEAN(p_commit) THEN
210: SAVEPOINT EGO_CREATE_RELATIONSHIP;
211: END IF;
212: mdebug('. CREATE_RELATIONSHIP: Creating Relationship .....1...... ');
213: IF NOT FND_API.Compatible_API_Call (l_api_version,
214: p_api_version,
215: l_api_name,
216: G_PKG_NAME)
217: THEN

Line 218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

214: p_api_version,
215: l_api_name,
216: G_PKG_NAME)
217: THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220: -- Initialize API message list if necessary.
221: -- Initialize message list if p_init_msg_list is set to TRUE.
222: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 222: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220: -- Initialize API message list if necessary.
221: -- Initialize message list if p_init_msg_list is set to TRUE.
222: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
223: FND_MSG_PUB.initialize;
224: END IF;
225:
226: l_party_rel_rec.subject_id := p_subject_id;

Line 268: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN

264: -- mdebug('. CREATE_RELATIONSHIP: x_msg_count ' || x_msg_count);
265:
266: END IF; -- member already exists
267: -- Standard check of p_commit.
268: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
269: COMMIT WORK;
270: END IF;
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272: -- Standard call to get message count and if count is 1,

Line 271: x_return_status := FND_API.G_RET_STS_SUCCESS;

267: -- Standard check of p_commit.
268: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
269: COMMIT WORK;
270: END IF;
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272: -- Standard call to get message count and if count is 1,
273: -- get message info.
274: -- The client will directly display the x_msg_data (which is already
275: -- translated) if the x_msg_count = 1;

Line 285: WHEN FND_API.G_EXC_ERROR THEN

281: ( p_count => x_msg_count,
282: p_data => x_msg_data
283: );
284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: IF FND_API.TO_BOOLEAN(p_commit) THEN
287: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
288: END IF;
289: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');

Line 286: IF FND_API.TO_BOOLEAN(p_commit) THEN

282: p_data => x_msg_data
283: );
284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: IF FND_API.TO_BOOLEAN(p_commit) THEN
287: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
288: END IF;
289: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
290: x_return_status := FND_API.G_RET_STS_ERROR;

Line 289: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');

285: WHEN FND_API.G_EXC_ERROR THEN
286: IF FND_API.TO_BOOLEAN(p_commit) THEN
287: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
288: END IF;
289: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
290: x_return_status := FND_API.G_RET_STS_ERROR;
291: FND_MSG_PUB.Count_And_Get
292: (p_count => x_msg_count,
293: p_data => x_msg_data

Line 290: x_return_status := FND_API.G_RET_STS_ERROR;

286: IF FND_API.TO_BOOLEAN(p_commit) THEN
287: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
288: END IF;
289: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
290: x_return_status := FND_API.G_RET_STS_ERROR;
291: FND_MSG_PUB.Count_And_Get
292: (p_count => x_msg_count,
293: p_data => x_msg_data
294: );

Line 295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

291: FND_MSG_PUB.Count_And_Get
292: (p_count => x_msg_count,
293: p_data => x_msg_data
294: );
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: IF FND_API.TO_BOOLEAN(p_commit) THEN
297: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
298: END IF;
299: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');

Line 296: IF FND_API.TO_BOOLEAN(p_commit) THEN

292: (p_count => x_msg_count,
293: p_data => x_msg_data
294: );
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: IF FND_API.TO_BOOLEAN(p_commit) THEN
297: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
298: END IF;
299: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 299: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');

295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: IF FND_API.TO_BOOLEAN(p_commit) THEN
297: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
298: END IF;
299: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301: FND_MSG_PUB.Count_And_Get
302: (p_count => x_msg_count,
303: p_data => x_msg_data

Line 300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

296: IF FND_API.TO_BOOLEAN(p_commit) THEN
297: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
298: END IF;
299: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301: FND_MSG_PUB.Count_And_Get
302: (p_count => x_msg_count,
303: p_data => x_msg_data
304: );

Line 306: IF FND_API.TO_BOOLEAN(p_commit) THEN

302: (p_count => x_msg_count,
303: p_data => x_msg_data
304: );
305: WHEN OTHERS THEN
306: IF FND_API.TO_BOOLEAN(p_commit) THEN
307: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
308: END IF;
309: mdebug('. CREATE_RELATIONSHIP: Ending : Returning UNEXPECTED ERROR');
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

306: IF FND_API.TO_BOOLEAN(p_commit) THEN
307: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
308: END IF;
309: mdebug('. CREATE_RELATIONSHIP: Ending : Returning UNEXPECTED ERROR');
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
313: END IF;
314: FND_MSG_PUB.Count_And_Get

Line 344: -- DEFAULT = FND_API.G_FALSE

340: -- Parameters:
341: -- IN : p_api_version IN NUMBER (required)
342: -- API Version of this procedure
343: -- p_init_msg_level IN VARCHAR2 (optional)
344: -- DEFAULT = FND_API.G_FALSE
345: -- Indicates whether the message stack needs to be cleared
346: -- p_commit IN VARCHAR2 (optional)
347: -- DEFAULT = FND_API.G_FALSE
348: -- Indicates whether the data should be committed

Line 347: -- DEFAULT = FND_API.G_FALSE

343: -- p_init_msg_level IN VARCHAR2 (optional)
344: -- DEFAULT = FND_API.G_FALSE
345: -- Indicates whether the message stack needs to be cleared
346: -- p_commit IN VARCHAR2 (optional)
347: -- DEFAULT = FND_API.G_FALSE
348: -- Indicates whether the data should be committed
349: -- p_party_rel_rec IN NUMBER (required)
350: -- The party relation record that needs to be updated
351: -- Record type -> HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE

Line 359: -- FND_API.G_RET_STS_SUCCESS if success

355: -- Returns the version of the record after updation
356: --
357: -- OUT : x_return_status OUT NUMBER
358: -- Result of all the operations
359: -- FND_API.G_RET_STS_SUCCESS if success
360: -- FND_API.G_RET_STS_ERROR if error
361: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
362: -- x_msg_count OUT NUMBER
363: -- number of messages in the message list

Line 360: -- FND_API.G_RET_STS_ERROR if error

356: --
357: -- OUT : x_return_status OUT NUMBER
358: -- Result of all the operations
359: -- FND_API.G_RET_STS_SUCCESS if success
360: -- FND_API.G_RET_STS_ERROR if error
361: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
362: -- x_msg_count OUT NUMBER
363: -- number of messages in the message list
364: -- x_msg_data OUT VARCHAR2

Line 361: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

357: -- OUT : x_return_status OUT NUMBER
358: -- Result of all the operations
359: -- FND_API.G_RET_STS_SUCCESS if success
360: -- FND_API.G_RET_STS_ERROR if error
361: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
362: -- x_msg_count OUT NUMBER
363: -- number of messages in the message list
364: -- x_msg_data OUT VARCHAR2
365: -- if number of messages is 1, then this parameter

Line 390: IF FND_API.TO_BOOLEAN(p_commit) THEN

386: l_number NUMBER ; -- Fix For Bug 2835026
387:
388: BEGIN
389: -- Standard Start of API savepoint
390: IF FND_API.TO_BOOLEAN(p_commit) THEN
391: SAVEPOINT EGO_UPDATE_RELATIONSHIP;
392: END IF;
393: l_number := FND_API.G_MISS_NUM ; -- Fix For Bug 2835026
394:

Line 393: l_number := FND_API.G_MISS_NUM ; -- Fix For Bug 2835026

389: -- Standard Start of API savepoint
390: IF FND_API.TO_BOOLEAN(p_commit) THEN
391: SAVEPOINT EGO_UPDATE_RELATIONSHIP;
392: END IF;
393: l_number := FND_API.G_MISS_NUM ; -- Fix For Bug 2835026
394:
395: IF NOT FND_API.Compatible_API_Call (l_api_version,
396: p_api_version,
397: l_api_name,

Line 395: IF NOT FND_API.Compatible_API_Call (l_api_version,

391: SAVEPOINT EGO_UPDATE_RELATIONSHIP;
392: END IF;
393: l_number := FND_API.G_MISS_NUM ; -- Fix For Bug 2835026
394:
395: IF NOT FND_API.Compatible_API_Call (l_api_version,
396: p_api_version,
397: l_api_name,
398: G_PKG_NAME)
399: THEN

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: p_api_version,
397: l_api_name,
398: G_PKG_NAME)
399: THEN
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:
403: -- Initialize API message list if necessary.
404: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 404: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:
403: -- Initialize API message list if necessary.
404: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
405: FND_MSG_PUB.initialize;
406: END IF;
407:
408: HZ_RELATIONSHIP_V2PUB.update_relationship

Line 423: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN

419: mdebug('. UPDATE_RELATIONSHIP: return_status '|| x_return_status);
420: mdebug('. UPDATE_RELATIONSHIP: x_msg_data ' || x_msg_data);
421:
422: -- Standard check of p_commit.
423: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
424: COMMIT WORK;
425: END IF;
426:
427: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 427: x_return_status := FND_API.G_RET_STS_SUCCESS;

423: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
424: COMMIT WORK;
425: END IF;
426:
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428: -- Standard call to get message count and if count is 1,
429: -- get message info.
430: -- The client will directly display the x_msg_data (which is already
431: -- translated) if the x_msg_count = 1;

Line 443: WHEN FND_API.G_EXC_ERROR THEN

439: p_data => x_msg_data
440: );
441:
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: IF FND_API.TO_BOOLEAN(p_commit) THEN
445: ROLLBACK TO EGO_UPDATE_RELATIONSHIP;
446: END IF;
447: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');

Line 444: IF FND_API.TO_BOOLEAN(p_commit) THEN

440: );
441:
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: IF FND_API.TO_BOOLEAN(p_commit) THEN
445: ROLLBACK TO EGO_UPDATE_RELATIONSHIP;
446: END IF;
447: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
448: x_return_status := FND_API.G_RET_STS_ERROR;

Line 447: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');

443: WHEN FND_API.G_EXC_ERROR THEN
444: IF FND_API.TO_BOOLEAN(p_commit) THEN
445: ROLLBACK TO EGO_UPDATE_RELATIONSHIP;
446: END IF;
447: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MSG_PUB.Count_And_Get
450: (p_count => x_msg_count,
451: p_data => x_msg_data

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: IF FND_API.TO_BOOLEAN(p_commit) THEN
445: ROLLBACK TO EGO_UPDATE_RELATIONSHIP;
446: END IF;
447: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MSG_PUB.Count_And_Get
450: (p_count => x_msg_count,
451: p_data => x_msg_data
452: );

Line 453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

449: FND_MSG_PUB.Count_And_Get
450: (p_count => x_msg_count,
451: p_data => x_msg_data
452: );
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: IF FND_API.TO_BOOLEAN(p_commit) THEN
455: ROLLBACK TO EGO_UPDATE_RELATIONSHIP;
456: END IF;
457: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');

Line 454: IF FND_API.TO_BOOLEAN(p_commit) THEN

450: (p_count => x_msg_count,
451: p_data => x_msg_data
452: );
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: IF FND_API.TO_BOOLEAN(p_commit) THEN
455: ROLLBACK TO EGO_UPDATE_RELATIONSHIP;
456: END IF;
457: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 457: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');

453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: IF FND_API.TO_BOOLEAN(p_commit) THEN
455: ROLLBACK TO EGO_UPDATE_RELATIONSHIP;
456: END IF;
457: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: FND_MSG_PUB.Count_And_Get
460: (p_count => x_msg_count,
461: p_data => x_msg_data

Line 458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

454: IF FND_API.TO_BOOLEAN(p_commit) THEN
455: ROLLBACK TO EGO_UPDATE_RELATIONSHIP;
456: END IF;
457: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: FND_MSG_PUB.Count_And_Get
460: (p_count => x_msg_count,
461: p_data => x_msg_data
462: );

Line 464: IF FND_API.TO_BOOLEAN(p_commit) THEN

460: (p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463: WHEN OTHERS THEN
464: IF FND_API.TO_BOOLEAN(p_commit) THEN
465: ROLLBACK TO EGO_UPDATE_RELATIONSHIP;
466: END IF;
467: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning UNEXPECTED ERROR');
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

464: IF FND_API.TO_BOOLEAN(p_commit) THEN
465: ROLLBACK TO EGO_UPDATE_RELATIONSHIP;
466: END IF;
467: mdebug('. UPDATE_RELATIONSHIP: Ending : Returning UNEXPECTED ERROR');
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
470: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
471: END IF;
472: FND_MSG_PUB.Count_And_Get

Line 627: x_return_status := FND_API.G_RET_STS_ERROR;

623: ) THEN
624: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
625: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
626: fnd_msg_pub.add;
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: x_msg_count := 1;
629: fnd_msg_pub.Count_And_Get
630: (p_count => x_msg_count
631: ,p_data => x_msg_data

Line 636: IF FND_API.TO_BOOLEAN(p_commit) THEN

632: );
633: RETURN;
634: END IF;
635: -- Standard Start of API savepoint
636: IF FND_API.TO_BOOLEAN(p_commit) THEN
637: SAVEPOINT EGO_CREATE_GROUP;
638: END IF;
639:
640: mdebug('CREATE_GROUP: ....1....');

Line 644: IF NOT FND_API.Compatible_API_Call (l_api_version,

640: mdebug('CREATE_GROUP: ....1....');
641: --
642: -- checking if the caller is calling with correct name and version
643: --
644: IF NOT FND_API.Compatible_API_Call (l_api_version,
645: p_api_version,
646: l_api_name,
647: G_PKG_NAME)
648: THEN

Line 649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

645: p_api_version,
646: l_api_name,
647: G_PKG_NAME)
648: THEN
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651:
652: -- Initialize API message list if necessary.
653: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 653: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END IF;
651:
652: -- Initialize API message list if necessary.
653: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
654: FND_MSG_PUB.initialize;
655: END IF;
656:
657: l_group_rec.group_name := p_group_name;

Line 659: IF ( p_group_type IS NULL OR p_group_type = fnd_api.g_MISS_CHAR ) THEN

655: END IF;
656:
657: l_group_rec.group_name := p_group_name;
658:
659: IF ( p_group_type IS NULL OR p_group_type = fnd_api.g_MISS_CHAR ) THEN
660: l_group_rec.group_type := 'GROUP';
661: ELSE
662: l_group_rec.group_type := p_group_type;
663: END IF;

Line 665: -- INFORMATION REGARDING USING FND_API.G_MISS_CHAR

661: ELSE
662: l_group_rec.group_type := p_group_type;
663: END IF;
664: ---------------------------------------------------------------------
665: -- INFORMATION REGARDING USING FND_API.G_MISS_CHAR
666: -- while inserting data the following code is used by API
667: -- DECODE( X_LOCATION, FND_API.G_MISS_CHAR, NULL, X_LOCATION)
668: ---------------------------------------------------------------------
669: --

Line 667: -- DECODE( X_LOCATION, FND_API.G_MISS_CHAR, NULL, X_LOCATION)

663: END IF;
664: ---------------------------------------------------------------------
665: -- INFORMATION REGARDING USING FND_API.G_MISS_CHAR
666: -- while inserting data the following code is used by API
667: -- DECODE( X_LOCATION, FND_API.G_MISS_CHAR, NULL, X_LOCATION)
668: ---------------------------------------------------------------------
669: --
670: -- getting the application id
671: --

Line 690: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

686: );
687: mdebug('CREATE_GROUP: HZ_PARTY_V2PUB.create_group call complete : groupId => '||l_group_id);
688: mdebug('CREATE_GROUP: return_status '|| x_return_status);
689:
690: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
691: IF FND_API.TO_BOOLEAN(p_commit) THEN
692: ROLLBACK TO EGO_CREATE_GROUP;
693: END IF;
694: RETURN;

Line 691: IF FND_API.TO_BOOLEAN(p_commit) THEN

687: mdebug('CREATE_GROUP: HZ_PARTY_V2PUB.create_group call complete : groupId => '||l_group_id);
688: mdebug('CREATE_GROUP: return_status '|| x_return_status);
689:
690: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
691: IF FND_API.TO_BOOLEAN(p_commit) THEN
692: ROLLBACK TO EGO_CREATE_GROUP;
693: END IF;
694: RETURN;
695: ELSE

Line 730: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

726: ,x_msg_count => x_msg_count
727: ,x_msg_data => x_msg_data
728: );
729: mdebug('CREATE_GROUP: Returning after call to create_contact_point => '|| to_char(l_contact_point_id));
730: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
731: IF FND_API.TO_BOOLEAN(p_commit) THEN
732: ROLLBACK TO EGO_CREATE_GROUP;
733: END IF;
734: RETURN;

Line 731: IF FND_API.TO_BOOLEAN(p_commit) THEN

727: ,x_msg_data => x_msg_data
728: );
729: mdebug('CREATE_GROUP: Returning after call to create_contact_point => '|| to_char(l_contact_point_id));
730: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
731: IF FND_API.TO_BOOLEAN(p_commit) THEN
732: ROLLBACK TO EGO_CREATE_GROUP;
733: END IF;
734: RETURN;
735: END IF;

Line 772: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

768: -- -- Output commands to test if Group successfully created.
769: -- mdebug('CREATE_GROUP: created owner for the group');
770: -- mdebug('CREATE_GROUP: group_owner_rel_id '|| to_char(l_group_owner_rel_id));
771: mdebug('CREATE_GROUP: return_status '|| x_return_status);
772: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
773: IF FND_API.TO_BOOLEAN(p_commit) THEN
774: ROLLBACK TO EGO_CREATE_GROUP;
775: END IF;
776: RETURN;

Line 773: IF FND_API.TO_BOOLEAN(p_commit) THEN

769: -- mdebug('CREATE_GROUP: created owner for the group');
770: -- mdebug('CREATE_GROUP: group_owner_rel_id '|| to_char(l_group_owner_rel_id));
771: mdebug('CREATE_GROUP: return_status '|| x_return_status);
772: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
773: IF FND_API.TO_BOOLEAN(p_commit) THEN
774: ROLLBACK TO EGO_CREATE_GROUP;
775: END IF;
776: RETURN;
777: END IF;

Line 804: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

800:
801: mdebug('CREATE_GROUP: Successfully exited from Add_Group_Member');
802: mdebug('CREATE_GROUP: group_member_rel_id '|| to_char(l_group_member_rel_id));
803: mdebug('CREATE_GROUP: return status '|| x_return_status );
804: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
805: IF FND_API.TO_BOOLEAN(p_commit) THEN
806: ROLLBACK TO EGO_CREATE_GROUP;
807: END IF;
808: RETURN;

Line 805: IF FND_API.TO_BOOLEAN(p_commit) THEN

801: mdebug('CREATE_GROUP: Successfully exited from Add_Group_Member');
802: mdebug('CREATE_GROUP: group_member_rel_id '|| to_char(l_group_member_rel_id));
803: mdebug('CREATE_GROUP: return status '|| x_return_status );
804: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
805: IF FND_API.TO_BOOLEAN(p_commit) THEN
806: ROLLBACK TO EGO_CREATE_GROUP;
807: END IF;
808: RETURN;
809: END IF;

Line 812: x_return_status := FND_API.G_RET_STS_SUCCESS;

808: RETURN;
809: END IF;
810: -- before returning to the caller, set appropriate OUT values
811: x_group_id := l_group_id;
812: x_return_status := FND_API.G_RET_STS_SUCCESS;
813: -- Standard call to get message count and if count is 1,
814: -- get message info.
815: -- The client will directly display the x_msg_data (which is already
816: -- translated) if the x_msg_count = 1;

Line 828: WHEN FND_API.G_EXC_ERROR THEN

824: p_data => x_msg_data
825: );
826:
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829: IF FND_API.TO_BOOLEAN(p_commit) THEN
830: ROLLBACK TO EGO_CREATE_GROUP;
831: END IF;
832: mdebug('CREATE_GROUP: Ending - Returning ''FND_API.G_EXC_ERROR''');

Line 829: IF FND_API.TO_BOOLEAN(p_commit) THEN

825: );
826:
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829: IF FND_API.TO_BOOLEAN(p_commit) THEN
830: ROLLBACK TO EGO_CREATE_GROUP;
831: END IF;
832: mdebug('CREATE_GROUP: Ending - Returning ''FND_API.G_EXC_ERROR''');
833: x_return_status := FND_API.G_RET_STS_ERROR;

Line 832: mdebug('CREATE_GROUP: Ending - Returning ''FND_API.G_EXC_ERROR''');

828: WHEN FND_API.G_EXC_ERROR THEN
829: IF FND_API.TO_BOOLEAN(p_commit) THEN
830: ROLLBACK TO EGO_CREATE_GROUP;
831: END IF;
832: mdebug('CREATE_GROUP: Ending - Returning ''FND_API.G_EXC_ERROR''');
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: FND_MSG_PUB.Count_And_Get
835: (p_count => x_msg_count,
836: p_data => x_msg_data

Line 833: x_return_status := FND_API.G_RET_STS_ERROR;

829: IF FND_API.TO_BOOLEAN(p_commit) THEN
830: ROLLBACK TO EGO_CREATE_GROUP;
831: END IF;
832: mdebug('CREATE_GROUP: Ending - Returning ''FND_API.G_EXC_ERROR''');
833: x_return_status := FND_API.G_RET_STS_ERROR;
834: FND_MSG_PUB.Count_And_Get
835: (p_count => x_msg_count,
836: p_data => x_msg_data
837: );

Line 838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

834: FND_MSG_PUB.Count_And_Get
835: (p_count => x_msg_count,
836: p_data => x_msg_data
837: );
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: IF FND_API.TO_BOOLEAN(p_commit) THEN
840: ROLLBACK TO EGO_CREATE_GROUP;
841: END IF;
842: mdebug('CREATE_GROUP: Ending - Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');

Line 839: IF FND_API.TO_BOOLEAN(p_commit) THEN

835: (p_count => x_msg_count,
836: p_data => x_msg_data
837: );
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: IF FND_API.TO_BOOLEAN(p_commit) THEN
840: ROLLBACK TO EGO_CREATE_GROUP;
841: END IF;
842: mdebug('CREATE_GROUP: Ending - Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 842: mdebug('CREATE_GROUP: Ending - Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');

838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: IF FND_API.TO_BOOLEAN(p_commit) THEN
840: ROLLBACK TO EGO_CREATE_GROUP;
841: END IF;
842: mdebug('CREATE_GROUP: Ending - Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data

Line 843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

839: IF FND_API.TO_BOOLEAN(p_commit) THEN
840: ROLLBACK TO EGO_CREATE_GROUP;
841: END IF;
842: mdebug('CREATE_GROUP: Ending - Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data
847: );

Line 849: IF FND_API.TO_BOOLEAN(p_commit) THEN

845: ( p_count => x_msg_count,
846: p_data => x_msg_data
847: );
848: WHEN OTHERS THEN
849: IF FND_API.TO_BOOLEAN(p_commit) THEN
850: ROLLBACK TO EGO_CREATE_GROUP;
851: END IF;
852: mdebug('CREATE_GROUP: Ending - Returning UNEXPECTED ERROR');
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

849: IF FND_API.TO_BOOLEAN(p_commit) THEN
850: ROLLBACK TO EGO_CREATE_GROUP;
851: END IF;
852: mdebug('CREATE_GROUP: Ending - Returning UNEXPECTED ERROR');
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
854: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
855: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
856: END IF;
857: FND_MSG_PUB.Count_And_Get

Line 989: x_return_status := FND_API.G_RET_STS_ERROR;

985: ) THEN
986: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
987: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
988: fnd_msg_pub.add;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: x_msg_count := 1;
991: fnd_msg_pub.Count_And_Get
992: (p_count => x_msg_count
993: ,p_data => x_msg_data

Line 999: IF FND_API.TO_BOOLEAN(p_commit) THEN

995: RETURN;
996: END IF;
997: mdebug('UPDATE_GROUP: All required params are passed ');
998: -- Standard Start of API savepoint
999: IF FND_API.TO_BOOLEAN(p_commit) THEN
1000: SAVEPOINT EGO_UPDATE_GROUP;
1001: END IF;
1002:
1003: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1003: IF NOT FND_API.Compatible_API_Call (l_api_version,

999: IF FND_API.TO_BOOLEAN(p_commit) THEN
1000: SAVEPOINT EGO_UPDATE_GROUP;
1001: END IF;
1002:
1003: IF NOT FND_API.Compatible_API_Call (l_api_version,
1004: p_api_version,
1005: l_api_name,
1006: G_PKG_NAME)
1007: THEN

Line 1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1004: p_api_version,
1005: l_api_name,
1006: G_PKG_NAME)
1007: THEN
1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1009: END IF;
1010:
1011: -- Initialize API message list if necessary.
1012: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 1012: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

1008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1009: END IF;
1010:
1011: -- Initialize API message list if necessary.
1012: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
1013: FND_MSG_PUB.initialize;
1014: END IF;
1015:
1016: l_group_rec.party_rec.party_id := p_group_id;

Line 1030: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1026: ,x_msg_count => l_msg_count
1027: ,x_msg_data => l_msg_data
1028: );
1029: mdebug('UPDATE_GROUP: Existed out of HZ_PARTY_V2PUB.update_group with status '''|| l_return_status||'''');
1030: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1031: IF FND_API.TO_BOOLEAN(p_commit) THEN
1032: ROLLBACK TO EGO_UPDATE_GROUP;
1033: END IF;
1034: RETURN;

Line 1031: IF FND_API.TO_BOOLEAN(p_commit) THEN

1027: ,x_msg_data => l_msg_data
1028: );
1029: mdebug('UPDATE_GROUP: Existed out of HZ_PARTY_V2PUB.update_group with status '''|| l_return_status||'''');
1030: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1031: IF FND_API.TO_BOOLEAN(p_commit) THEN
1032: ROLLBACK TO EGO_UPDATE_GROUP;
1033: END IF;
1034: RETURN;
1035: ELSE

Line 1079: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1075: ,x_return_status => x_return_status
1076: ,x_msg_count => x_msg_count
1077: ,x_msg_data => x_msg_data
1078: );
1079: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1080: IF FND_API.TO_BOOLEAN(p_commit) THEN
1081: ROLLBACK TO EGO_UPDATE_GROUP;
1082: END IF;
1083: RETURN;

Line 1080: IF FND_API.TO_BOOLEAN(p_commit) THEN

1076: ,x_msg_count => x_msg_count
1077: ,x_msg_data => x_msg_data
1078: );
1079: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1080: IF FND_API.TO_BOOLEAN(p_commit) THEN
1081: ROLLBACK TO EGO_UPDATE_GROUP;
1082: END IF;
1083: RETURN;
1084: END IF;

Line 1117: IF FND_API.TO_BOOLEAN(p_commit) THEN

1113: ,x_msg_data => l_msg_data
1114: );
1115: mdebug('UPDATE_GROUP: Exited from HZ_CONTACT_POINT_V2PUB.update_contact_point with status '''||l_return_status||'''');
1116: IF l_return_status <> 'S' THEN
1117: IF FND_API.TO_BOOLEAN(p_commit) THEN
1118: ROLLBACK TO EGO_UPDATE_GROUP;
1119: END IF;
1120: RETURN;
1121: END IF;

Line 1179: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1175: -- ,x_return_status => x_return_status
1176: -- ,x_msg_count => x_msg_count
1177: -- ,x_msg_data => x_msg_data
1178: -- );
1179: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1180: -- ROLLBACK TO EGO_UPDATE_GROUP;
1181: -- RETURN;
1182: -- END IF;
1183: -- mdebug('UPDATE_GROUP: Deactivated the current relationship for owner with status '''||x_return_status||'''');

Line 1209: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1205: -- x_relationship_id => l_group_owner_rel_id
1206: -- );
1207: -- mdebug('UPDATE_GROUP: New owner relationship created with status '''||x_return_status||'''');
1208: -- mdebug('UPDATE_GROUP: New owner relationship id '||to_char(l_group_owner_rel_id));
1209: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1210: -- ROLLBACK TO EGO_UPDATE_GROUP;
1211: -- RETURN;
1212: -- END IF;
1213: -- IF l_create_member THEN

Line 1232: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1228: -- x_relationship_id => l_group_member_rel_id
1229: -- );
1230: -- mdebug('UPDATE_GROUP: new owner added as member to the group with status ' ||x_return_status);
1231: -- mdebug('UPDATE_GROUP: new owner''s membership id ' ||to_char(l_group_member_rel_id));
1232: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1233: -- ROLLBACK TO EGO_UPDATE_GROUP;
1234: -- RETURN;
1235: -- END IF;
1236: -- END IF;

Line 1243: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN

1239: -- Output commands to test if Group successfully created.
1240: mdebug('UPDATE_GROUP updated group '|| to_char(p_group_id));
1241:
1242: -- Standard check of p_commit.
1243: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
1244: COMMIT WORK;
1245: END IF;
1246:
1247: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1247: x_return_status := FND_API.G_RET_STS_SUCCESS;

1243: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
1244: COMMIT WORK;
1245: END IF;
1246:
1247: x_return_status := FND_API.G_RET_STS_SUCCESS;
1248: -- Standard call to get message count and if count is 1,
1249: -- get message info.
1250: -- The client will directly display the x_msg_data (which is already
1251: -- translated) if the x_msg_count = 1;

Line 1263: WHEN FND_API.G_EXC_ERROR THEN

1259: p_data => x_msg_data
1260: );
1261:
1262: EXCEPTION
1263: WHEN FND_API.G_EXC_ERROR THEN
1264: IF FND_API.TO_BOOLEAN(p_commit) THEN
1265: ROLLBACK TO EGO_UPDATE_GROUP;
1266: END IF;
1267: mdebug('UPDATE_GROUP Ending : Returning ''FND_API.G_EXC_ERROR'' ERROR');

Line 1264: IF FND_API.TO_BOOLEAN(p_commit) THEN

1260: );
1261:
1262: EXCEPTION
1263: WHEN FND_API.G_EXC_ERROR THEN
1264: IF FND_API.TO_BOOLEAN(p_commit) THEN
1265: ROLLBACK TO EGO_UPDATE_GROUP;
1266: END IF;
1267: mdebug('UPDATE_GROUP Ending : Returning ''FND_API.G_EXC_ERROR'' ERROR');
1268: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1267: mdebug('UPDATE_GROUP Ending : Returning ''FND_API.G_EXC_ERROR'' ERROR');

1263: WHEN FND_API.G_EXC_ERROR THEN
1264: IF FND_API.TO_BOOLEAN(p_commit) THEN
1265: ROLLBACK TO EGO_UPDATE_GROUP;
1266: END IF;
1267: mdebug('UPDATE_GROUP Ending : Returning ''FND_API.G_EXC_ERROR'' ERROR');
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: FND_MSG_PUB.Count_And_Get
1270: (p_count => x_msg_count,
1271: p_data => x_msg_data

Line 1268: x_return_status := FND_API.G_RET_STS_ERROR;

1264: IF FND_API.TO_BOOLEAN(p_commit) THEN
1265: ROLLBACK TO EGO_UPDATE_GROUP;
1266: END IF;
1267: mdebug('UPDATE_GROUP Ending : Returning ''FND_API.G_EXC_ERROR'' ERROR');
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: FND_MSG_PUB.Count_And_Get
1270: (p_count => x_msg_count,
1271: p_data => x_msg_data
1272: );

Line 1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1269: FND_MSG_PUB.Count_And_Get
1270: (p_count => x_msg_count,
1271: p_data => x_msg_data
1272: );
1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1274: IF FND_API.TO_BOOLEAN(p_commit) THEN
1275: ROLLBACK TO EGO_UPDATE_GROUP;
1276: END IF;
1277: mdebug('UPDATE_GROUP Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR'' ERROR');

Line 1274: IF FND_API.TO_BOOLEAN(p_commit) THEN

1270: (p_count => x_msg_count,
1271: p_data => x_msg_data
1272: );
1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1274: IF FND_API.TO_BOOLEAN(p_commit) THEN
1275: ROLLBACK TO EGO_UPDATE_GROUP;
1276: END IF;
1277: mdebug('UPDATE_GROUP Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR'' ERROR');
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1277: mdebug('UPDATE_GROUP Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR'' ERROR');

1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1274: IF FND_API.TO_BOOLEAN(p_commit) THEN
1275: ROLLBACK TO EGO_UPDATE_GROUP;
1276: END IF;
1277: mdebug('UPDATE_GROUP Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR'' ERROR');
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1279: FND_MSG_PUB.Count_And_Get
1280: (p_count => x_msg_count,
1281: p_data => x_msg_data

Line 1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1274: IF FND_API.TO_BOOLEAN(p_commit) THEN
1275: ROLLBACK TO EGO_UPDATE_GROUP;
1276: END IF;
1277: mdebug('UPDATE_GROUP Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR'' ERROR');
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1279: FND_MSG_PUB.Count_And_Get
1280: (p_count => x_msg_count,
1281: p_data => x_msg_data
1282: );

Line 1284: IF FND_API.TO_BOOLEAN(p_commit) THEN

1280: (p_count => x_msg_count,
1281: p_data => x_msg_data
1282: );
1283: WHEN OTHERS THEN
1284: IF FND_API.TO_BOOLEAN(p_commit) THEN
1285: ROLLBACK TO EGO_UPDATE_GROUP;
1286: END IF;
1287: -- IF c_get_owner_details%ISOPEN THEN
1288: -- CLOSE c_get_owner_details;

Line 1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1293: IF c_get_contact_details%ISOPEN THEN
1294: CLOSE c_get_contact_details;
1295: END IF;
1296: mdebug('UPDATE_GROUP Ending : Returning UNEXPECTED ERROR');
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1298: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1300: END IF;
1301: FND_MSG_PUB.Count_And_Get

Line 1397: x_return_status := FND_API.G_RET_STS_ERROR;

1393: ) THEN
1394: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
1395: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
1396: fnd_msg_pub.add;
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: x_msg_count := 1;
1399: fnd_msg_pub.Count_And_Get
1400: (p_count => x_msg_count
1401: ,p_data => x_msg_data

Line 1406: IF FND_API.TO_BOOLEAN(p_commit) THEN

1402: );
1403: RETURN;
1404: END IF;
1405: -- Standard Start of API savepoint
1406: IF FND_API.TO_BOOLEAN(p_commit) THEN
1407: SAVEPOINT EGO_DELETE_GROUP;
1408: END IF;
1409:
1410: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1410: IF NOT FND_API.Compatible_API_Call (l_api_version,

1406: IF FND_API.TO_BOOLEAN(p_commit) THEN
1407: SAVEPOINT EGO_DELETE_GROUP;
1408: END IF;
1409:
1410: IF NOT FND_API.Compatible_API_Call (l_api_version,
1411: p_api_version,
1412: l_api_name,
1413: G_PKG_NAME)
1414: THEN

Line 1415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1411: p_api_version,
1412: l_api_name,
1413: G_PKG_NAME)
1414: THEN
1415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1416: END IF;
1417: -- Initialize API message list if necessary.
1418: -- Initialize message list if p_init_msg_list is set to TRUE.
1419: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 1419: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

1415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1416: END IF;
1417: -- Initialize API message list if necessary.
1418: -- Initialize message list if p_init_msg_list is set to TRUE.
1419: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
1420: FND_MSG_PUB.initialize;
1421: END IF;
1422: --
1423: -- delete all the members of the Group

Line 1443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1439: ,x_return_status => x_return_status
1440: ,x_msg_count => x_msg_count
1441: ,x_msg_data => x_msg_data
1442: );
1443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1444: IF FND_API.TO_BOOLEAN(p_commit) THEN
1445: ROLLBACK TO EGO_DELETE_GROUP;
1446: END IF;
1447: EXIT;

Line 1444: IF FND_API.TO_BOOLEAN(p_commit) THEN

1440: ,x_msg_count => x_msg_count
1441: ,x_msg_data => x_msg_data
1442: );
1443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1444: IF FND_API.TO_BOOLEAN(p_commit) THEN
1445: ROLLBACK TO EGO_DELETE_GROUP;
1446: END IF;
1447: EXIT;
1448: END IF;

Line 1450: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1446: END IF;
1447: EXIT;
1448: END IF;
1449: END LOOP;
1450: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1451: RETURN;
1452: END IF;
1453: --
1454: -- The Owner relatioships does not exist any more

Line 1477: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1473: -- ,x_return_status => x_return_status
1474: -- ,x_msg_count => x_msg_count
1475: -- ,x_msg_data => x_msg_data
1476: -- );
1477: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1478: -- ROLLBACK TO EGO_DELETE_GROUP;
1479: -- EXIT;
1480: -- END IF;
1481: -- END LOOP;

Line 1482: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1478: -- ROLLBACK TO EGO_DELETE_GROUP;
1479: -- EXIT;
1480: -- END IF;
1481: -- END LOOP;
1482: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1483: -- RETURN;
1484: -- END IF;
1485: --
1486: -- remove the contact point(s)

Line 1508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1504: ,x_return_status => x_return_status
1505: ,x_msg_count => x_msg_count
1506: ,x_msg_data => x_msg_data
1507: );
1508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1509: IF FND_API.TO_BOOLEAN(p_commit) THEN
1510: ROLLBACK TO EGO_DELETE_GROUP;
1511: END IF;
1512: EXIT;

Line 1509: IF FND_API.TO_BOOLEAN(p_commit) THEN

1505: ,x_msg_count => x_msg_count
1506: ,x_msg_data => x_msg_data
1507: );
1508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1509: IF FND_API.TO_BOOLEAN(p_commit) THEN
1510: ROLLBACK TO EGO_DELETE_GROUP;
1511: END IF;
1512: EXIT;
1513: END IF;

Line 1515: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1511: END IF;
1512: EXIT;
1513: END IF;
1514: END LOOP;
1515: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1516: RETURN;
1517: END IF;
1518: --
1519: -- delete the Group

Line 1532: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1528: ,x_return_status => x_return_status
1529: ,x_msg_count => x_msg_count
1530: ,x_msg_data => x_msg_data
1531: );
1532: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1533: IF FND_API.TO_BOOLEAN(p_commit) THEN
1534: ROLLBACK TO EGO_DELETE_GROUP;
1535: END IF;
1536: RETURN;

Line 1533: IF FND_API.TO_BOOLEAN(p_commit) THEN

1529: ,x_msg_count => x_msg_count
1530: ,x_msg_data => x_msg_data
1531: );
1532: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1533: IF FND_API.TO_BOOLEAN(p_commit) THEN
1534: ROLLBACK TO EGO_DELETE_GROUP;
1535: END IF;
1536: RETURN;
1537: END IF;

Line 1541: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN

1537: END IF;
1538:
1539:
1540: -- Standard check of p_commit.
1541: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
1542: COMMIT WORK;
1543: END IF;
1544:
1545: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1545: x_return_status := FND_API.G_RET_STS_SUCCESS;

1541: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
1542: COMMIT WORK;
1543: END IF;
1544:
1545: x_return_status := FND_API.G_RET_STS_SUCCESS;
1546: -- Standard call to get message count and if count is 1,
1547: -- get message info.
1548: -- The client will directly display the x_msg_data (which is already
1549: -- translated) if the x_msg_count = 1;

Line 1562: WHEN FND_API.G_EXC_ERROR THEN

1558: );
1559:
1560:
1561: EXCEPTION
1562: WHEN FND_API.G_EXC_ERROR THEN
1563: IF FND_API.TO_BOOLEAN(p_commit) THEN
1564: ROLLBACK TO EGO_DELETE_GROUP;
1565: END IF;
1566: mdebug('DELETE_GROUP Ending : Returning ''FND_API.G_EXC_ERROR'' ERROR');

Line 1563: IF FND_API.TO_BOOLEAN(p_commit) THEN

1559:
1560:
1561: EXCEPTION
1562: WHEN FND_API.G_EXC_ERROR THEN
1563: IF FND_API.TO_BOOLEAN(p_commit) THEN
1564: ROLLBACK TO EGO_DELETE_GROUP;
1565: END IF;
1566: mdebug('DELETE_GROUP Ending : Returning ''FND_API.G_EXC_ERROR'' ERROR');
1567: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1566: mdebug('DELETE_GROUP Ending : Returning ''FND_API.G_EXC_ERROR'' ERROR');

1562: WHEN FND_API.G_EXC_ERROR THEN
1563: IF FND_API.TO_BOOLEAN(p_commit) THEN
1564: ROLLBACK TO EGO_DELETE_GROUP;
1565: END IF;
1566: mdebug('DELETE_GROUP Ending : Returning ''FND_API.G_EXC_ERROR'' ERROR');
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: FND_MSG_PUB.Count_And_Get
1569: (p_count => x_msg_count,
1570: p_data => x_msg_data

Line 1567: x_return_status := FND_API.G_RET_STS_ERROR;

1563: IF FND_API.TO_BOOLEAN(p_commit) THEN
1564: ROLLBACK TO EGO_DELETE_GROUP;
1565: END IF;
1566: mdebug('DELETE_GROUP Ending : Returning ''FND_API.G_EXC_ERROR'' ERROR');
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: FND_MSG_PUB.Count_And_Get
1569: (p_count => x_msg_count,
1570: p_data => x_msg_data
1571: );

Line 1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1568: FND_MSG_PUB.Count_And_Get
1569: (p_count => x_msg_count,
1570: p_data => x_msg_data
1571: );
1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1573: IF FND_API.TO_BOOLEAN(p_commit) THEN
1574: ROLLBACK TO EGO_DELETE_GROUP;
1575: END IF;
1576: mdebug('DELETE_GROUP Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR'' ERROR');

Line 1573: IF FND_API.TO_BOOLEAN(p_commit) THEN

1569: (p_count => x_msg_count,
1570: p_data => x_msg_data
1571: );
1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1573: IF FND_API.TO_BOOLEAN(p_commit) THEN
1574: ROLLBACK TO EGO_DELETE_GROUP;
1575: END IF;
1576: mdebug('DELETE_GROUP Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR'' ERROR');
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1576: mdebug('DELETE_GROUP Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR'' ERROR');

1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1573: IF FND_API.TO_BOOLEAN(p_commit) THEN
1574: ROLLBACK TO EGO_DELETE_GROUP;
1575: END IF;
1576: mdebug('DELETE_GROUP Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR'' ERROR');
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1578: FND_MSG_PUB.Count_And_Get
1579: (p_count => x_msg_count,
1580: p_data => x_msg_data

Line 1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1573: IF FND_API.TO_BOOLEAN(p_commit) THEN
1574: ROLLBACK TO EGO_DELETE_GROUP;
1575: END IF;
1576: mdebug('DELETE_GROUP Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR'' ERROR');
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1578: FND_MSG_PUB.Count_And_Get
1579: (p_count => x_msg_count,
1580: p_data => x_msg_data
1581: );

Line 1583: IF FND_API.TO_BOOLEAN(p_commit) THEN

1579: (p_count => x_msg_count,
1580: p_data => x_msg_data
1581: );
1582: WHEN OTHERS THEN
1583: IF FND_API.TO_BOOLEAN(p_commit) THEN
1584: ROLLBACK TO EGO_DELETE_GROUP;
1585: END IF;
1586: mdebug('DELETE_GROPU Ending : Returning UNEXPECTED ERROR');
1587: IF c_get_group_members%ISOPEN THEN

Line 1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1589: END IF;
1590: -- IF c_get_group_owner%ISOPEN THEN
1591: -- CLOSE c_get_group_owner;
1592: -- END IF;
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1594: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1595: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1596: END IF;
1597: FND_MSG_PUB.Count_And_Get

Line 1667: x_return_status := FND_API.G_RET_STS_ERROR;

1663: OR p_member_id IS NULL) THEN
1664: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
1665: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
1666: fnd_msg_pub.add;
1667: x_return_status := FND_API.G_RET_STS_ERROR;
1668: x_msg_count := 1;
1669: fnd_msg_pub.Count_And_Get
1670: (p_count => x_msg_count
1671: ,p_data => x_msg_data

Line 1676: IF FND_API.TO_BOOLEAN(p_commit) THEN

1672: );
1673: RETURN;
1674: END IF;
1675: -- Standard Start of API savepoint
1676: IF FND_API.TO_BOOLEAN(p_commit) THEN
1677: SAVEPOINT EGO_ADD_GROUP_MEMBER;
1678: END IF;
1679:
1680: mdebug('ADD_GROUP_MEMBER: ........1........ ');

Line 1681: IF NOT FND_API.Compatible_API_Call (l_api_version,

1677: SAVEPOINT EGO_ADD_GROUP_MEMBER;
1678: END IF;
1679:
1680: mdebug('ADD_GROUP_MEMBER: ........1........ ');
1681: IF NOT FND_API.Compatible_API_Call (l_api_version,
1682: p_api_version,
1683: l_api_name,
1684: G_PKG_NAME)
1685: THEN

Line 1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1682: p_api_version,
1683: l_api_name,
1684: G_PKG_NAME)
1685: THEN
1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1687: END IF;
1688: -- Initialize API message list if necessary.
1689: -- Initialize message list if p_init_msg_list is set to TRUE.
1690: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 1690: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1687: END IF;
1688: -- Initialize API message list if necessary.
1689: -- Initialize message list if p_init_msg_list is set to TRUE.
1690: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
1691: FND_MSG_PUB.initialize;
1692: END IF;
1693:
1694: mdebug('ADD_GROUP_MEMBER: Setting local values ');

Line 1720: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1716: -- mdebug('ADD_GROUP_MEMBER: created party_relationship');
1717: -- mdebug('ADD_GROUP_MEMBER: party_rel_id '|| to_char(x_relationship_id)||' return_status '|| x_return_status);
1718: -- mdebug('ADD_GROUP_MEMBER: party_id '|| to_char(p_member_id)||' group_id '|| to_char(p_group_id));
1719: -- mdebug('ADD_GROUP_MEMBER: x_msg_data ' || x_msg_data);
1720: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1721: IF FND_API.TO_BOOLEAN(p_commit) THEN
1722: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1723: END IF;
1724: RETURN;

Line 1721: IF FND_API.TO_BOOLEAN(p_commit) THEN

1717: -- mdebug('ADD_GROUP_MEMBER: party_rel_id '|| to_char(x_relationship_id)||' return_status '|| x_return_status);
1718: -- mdebug('ADD_GROUP_MEMBER: party_id '|| to_char(p_member_id)||' group_id '|| to_char(p_group_id));
1719: -- mdebug('ADD_GROUP_MEMBER: x_msg_data ' || x_msg_data);
1720: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1721: IF FND_API.TO_BOOLEAN(p_commit) THEN
1722: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1723: END IF;
1724: RETURN;
1725: END IF;

Line 1766: -- x_return_status := FND_API.G_RET_STS_ERROR;

1762: -- -- EGO Security pub returns T if the action is success
1763: -- -- and F on failure
1764: -- --
1765: -- IF l_return_status <> 'T' THEN
1766: -- x_return_status := FND_API.G_RET_STS_ERROR;
1767: -- ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1768: -- RETURN;
1769: -- ELSE
1770: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1770: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

1766: -- x_return_status := FND_API.G_RET_STS_ERROR;
1767: -- ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1768: -- RETURN;
1769: -- ELSE
1770: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
1771: -- END IF;
1772: -- -- Standard check of p_commit.
1773: -- Commenting by Sridhar ends here (conf call with Wasi on 12-feb-2003)
1774:

Line 1775: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN

1771: -- END IF;
1772: -- -- Standard check of p_commit.
1773: -- Commenting by Sridhar ends here (conf call with Wasi on 12-feb-2003)
1774:
1775: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
1776: COMMIT WORK;
1777: END IF;
1778:
1779: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1779: x_return_status := FND_API.G_RET_STS_SUCCESS;

1775: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
1776: COMMIT WORK;
1777: END IF;
1778:
1779: x_return_status := FND_API.G_RET_STS_SUCCESS;
1780: -- Standard call to get message count and if count is 1,
1781: -- get message info.
1782: -- The client will directly display the x_msg_data (which is already
1783: -- translated) if the x_msg_count = 1;

Line 1796: WHEN FND_API.G_EXC_ERROR THEN

1792: );
1793:
1794:
1795: EXCEPTION
1796: WHEN FND_API.G_EXC_ERROR THEN
1797: IF FND_API.TO_BOOLEAN(p_commit) THEN
1798: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1799: END IF;
1800: mdebug('ADD_GROUP_MEMBER Ending : Returning ''FND_API.G_EXC_ERROR''');

Line 1797: IF FND_API.TO_BOOLEAN(p_commit) THEN

1793:
1794:
1795: EXCEPTION
1796: WHEN FND_API.G_EXC_ERROR THEN
1797: IF FND_API.TO_BOOLEAN(p_commit) THEN
1798: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1799: END IF;
1800: mdebug('ADD_GROUP_MEMBER Ending : Returning ''FND_API.G_EXC_ERROR''');
1801: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1800: mdebug('ADD_GROUP_MEMBER Ending : Returning ''FND_API.G_EXC_ERROR''');

1796: WHEN FND_API.G_EXC_ERROR THEN
1797: IF FND_API.TO_BOOLEAN(p_commit) THEN
1798: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1799: END IF;
1800: mdebug('ADD_GROUP_MEMBER Ending : Returning ''FND_API.G_EXC_ERROR''');
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: FND_MSG_PUB.Count_And_Get
1803: (p_count => x_msg_count,
1804: p_data => x_msg_data

Line 1801: x_return_status := FND_API.G_RET_STS_ERROR;

1797: IF FND_API.TO_BOOLEAN(p_commit) THEN
1798: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1799: END IF;
1800: mdebug('ADD_GROUP_MEMBER Ending : Returning ''FND_API.G_EXC_ERROR''');
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: FND_MSG_PUB.Count_And_Get
1803: (p_count => x_msg_count,
1804: p_data => x_msg_data
1805: );

Line 1806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1802: FND_MSG_PUB.Count_And_Get
1803: (p_count => x_msg_count,
1804: p_data => x_msg_data
1805: );
1806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1807: IF FND_API.TO_BOOLEAN(p_commit) THEN
1808: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1809: END IF;
1810: mdebug('ADD_GROUP_MEMBER Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');

Line 1807: IF FND_API.TO_BOOLEAN(p_commit) THEN

1803: (p_count => x_msg_count,
1804: p_data => x_msg_data
1805: );
1806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1807: IF FND_API.TO_BOOLEAN(p_commit) THEN
1808: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1809: END IF;
1810: mdebug('ADD_GROUP_MEMBER Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1810: mdebug('ADD_GROUP_MEMBER Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');

1806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1807: IF FND_API.TO_BOOLEAN(p_commit) THEN
1808: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1809: END IF;
1810: mdebug('ADD_GROUP_MEMBER Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1812: FND_MSG_PUB.Count_And_Get
1813: (p_count => x_msg_count,
1814: p_data => x_msg_data

Line 1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1807: IF FND_API.TO_BOOLEAN(p_commit) THEN
1808: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1809: END IF;
1810: mdebug('ADD_GROUP_MEMBER Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1812: FND_MSG_PUB.Count_And_Get
1813: (p_count => x_msg_count,
1814: p_data => x_msg_data
1815: );

Line 1817: IF FND_API.TO_BOOLEAN(p_commit) THEN

1813: (p_count => x_msg_count,
1814: p_data => x_msg_data
1815: );
1816: WHEN OTHERS THEN
1817: IF FND_API.TO_BOOLEAN(p_commit) THEN
1818: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1819: END IF;
1820: mdebug('ADD_GROUP_MEMBER Ending : Returning UNEXPECTED ERROR');
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1817: IF FND_API.TO_BOOLEAN(p_commit) THEN
1818: ROLLBACK TO EGO_ADD_GROUP_MEMBER;
1819: END IF;
1820: mdebug('ADD_GROUP_MEMBER Ending : Returning UNEXPECTED ERROR');
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1822: IF FND_MSG_PUB.Check_Msg_Level
1823: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1824: THEN
1825: FND_MSG_PUB.Add_Exc_Msg

Line 1905: x_return_status := FND_API.G_RET_STS_ERROR;

1901: ) THEN
1902: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
1903: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
1904: fnd_msg_pub.add;
1905: x_return_status := FND_API.G_RET_STS_ERROR;
1906: x_msg_count := 1;
1907: fnd_msg_pub.Count_And_Get
1908: (p_count => x_msg_count
1909: ,p_data => x_msg_data

Line 1914: IF FND_API.TO_BOOLEAN(p_commit) THEN

1910: );
1911: RETURN;
1912: END IF;
1913: -- Standard Start of API savepoint
1914: IF FND_API.TO_BOOLEAN(p_commit) THEN
1915: SAVEPOINT EGO_REMOVE_GROUP_MEMBER;
1916: END IF;
1917:
1918: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1918: IF NOT FND_API.Compatible_API_Call (l_api_version,

1914: IF FND_API.TO_BOOLEAN(p_commit) THEN
1915: SAVEPOINT EGO_REMOVE_GROUP_MEMBER;
1916: END IF;
1917:
1918: IF NOT FND_API.Compatible_API_Call (l_api_version,
1919: p_api_version,
1920: l_api_name,
1921: G_PKG_NAME)
1922: THEN

Line 1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1919: p_api_version,
1920: l_api_name,
1921: G_PKG_NAME)
1922: THEN
1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: END IF;
1925: -- Initialize API message list if necessary.
1926: -- Initialize message list if p_init_msg_list is set to TRUE.
1927: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 1927: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: END IF;
1925: -- Initialize API message list if necessary.
1926: -- Initialize message list if p_init_msg_list is set to TRUE.
1927: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
1928: FND_MSG_PUB.initialize;
1929: END IF;
1930: IF (p_relationship_id IS NOT NULL) THEN
1931: -- added Directional flag in where clause since two records are getting returned for each relationship one forward and one backward

Line 1952: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1948: ,x_return_status => x_return_status
1949: ,x_msg_count => x_msg_count
1950: ,x_msg_data => x_msg_data
1951: );
1952: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1953: IF FND_API.TO_BOOLEAN(p_commit) THEN
1954: ROLLBACK TO EGO_REMOVE_GROUP_MEMBER;
1955: END IF;
1956: RETURN;

Line 1953: IF FND_API.TO_BOOLEAN(p_commit) THEN

1949: ,x_msg_count => x_msg_count
1950: ,x_msg_data => x_msg_data
1951: );
1952: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1953: IF FND_API.TO_BOOLEAN(p_commit) THEN
1954: ROLLBACK TO EGO_REMOVE_GROUP_MEMBER;
1955: END IF;
1956: RETURN;
1957: END IF;

Line 1962: RAISE fnd_api.g_EXC_ERROR;

1958: ELSE
1959: mdebug('No member id provided!');
1960: FND_MESSAGE.Set_Name('EGO', 'EGO_GRP_MEMB_CANNOT_DELETE');
1961: FND_MSG_PUB.Add;
1962: RAISE fnd_api.g_EXC_ERROR;
1963: END IF;
1964: OPEN get_grant_guid_cur (cp_party_id => l_member_id,
1965: cp_instance_id => l_group_id);
1966: FETCH get_grant_guid_cur INTO l_grant_guid;

Line 1981: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN

1977: CLOSE get_grant_guid_cur;
1978: END IF;
1979:
1980: -- Standard check of p_commit.
1981: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
1982: COMMIT WORK;
1983: END IF;
1984:
1985: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1985: x_return_status := FND_API.G_RET_STS_SUCCESS;

1981: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
1982: COMMIT WORK;
1983: END IF;
1984:
1985: x_return_status := FND_API.G_RET_STS_SUCCESS;
1986: -- Standard call to get message count and if count is 1,
1987: -- get message info.
1988: -- The client will directly display the x_msg_data (which is already
1989: -- translated) if the x_msg_count = 1;

Line 2002: WHEN FND_API.G_EXC_ERROR THEN

1998: );
1999:
2000:
2001: EXCEPTION
2002: WHEN FND_API.G_EXC_ERROR THEN
2003: IF FND_API.TO_BOOLEAN(p_commit) THEN
2004: ROLLBACK TO EGO_REMOVE_GROUP_MEMBER;
2005: END IF;
2006: mdebug('Ending : Returning ERROR');

Line 2003: IF FND_API.TO_BOOLEAN(p_commit) THEN

1999:
2000:
2001: EXCEPTION
2002: WHEN FND_API.G_EXC_ERROR THEN
2003: IF FND_API.TO_BOOLEAN(p_commit) THEN
2004: ROLLBACK TO EGO_REMOVE_GROUP_MEMBER;
2005: END IF;
2006: mdebug('Ending : Returning ERROR');
2007: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2007: x_return_status := FND_API.G_RET_STS_ERROR;

2003: IF FND_API.TO_BOOLEAN(p_commit) THEN
2004: ROLLBACK TO EGO_REMOVE_GROUP_MEMBER;
2005: END IF;
2006: mdebug('Ending : Returning ERROR');
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MSG_PUB.Count_And_Get
2009: (p_count => x_msg_count,
2010: p_data => x_msg_data
2011: );

Line 2012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2008: FND_MSG_PUB.Count_And_Get
2009: (p_count => x_msg_count,
2010: p_data => x_msg_data
2011: );
2012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2013: IF FND_API.TO_BOOLEAN(p_commit) THEN
2014: ROLLBACK TO EGO_REMOVE_GROUP_MEMBER;
2015: END IF;
2016: mdebug('Ending : Returning UNEXPECTED ERROR');

Line 2013: IF FND_API.TO_BOOLEAN(p_commit) THEN

2009: (p_count => x_msg_count,
2010: p_data => x_msg_data
2011: );
2012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2013: IF FND_API.TO_BOOLEAN(p_commit) THEN
2014: ROLLBACK TO EGO_REMOVE_GROUP_MEMBER;
2015: END IF;
2016: mdebug('Ending : Returning UNEXPECTED ERROR');
2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2013: IF FND_API.TO_BOOLEAN(p_commit) THEN
2014: ROLLBACK TO EGO_REMOVE_GROUP_MEMBER;
2015: END IF;
2016: mdebug('Ending : Returning UNEXPECTED ERROR');
2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2018: FND_MSG_PUB.Count_And_Get
2019: (p_count => x_msg_count,
2020: p_data => x_msg_data
2021: );

Line 2023: IF FND_API.TO_BOOLEAN(p_commit) THEN

2019: (p_count => x_msg_count,
2020: p_data => x_msg_data
2021: );
2022: WHEN OTHERS THEN
2023: IF FND_API.TO_BOOLEAN(p_commit) THEN
2024: ROLLBACK TO EGO_REMOVE_GROUP_MEMBER;
2025: END IF;
2026: mdebug('Ending : Returning UNEXPECTED ERROR');
2027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2023: IF FND_API.TO_BOOLEAN(p_commit) THEN
2024: ROLLBACK TO EGO_REMOVE_GROUP_MEMBER;
2025: END IF;
2026: mdebug('Ending : Returning UNEXPECTED ERROR');
2027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2028: IF FND_MSG_PUB.Check_Msg_Level
2029: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2030: THEN
2031: FND_MSG_PUB.Add_Exc_Msg

Line 2128: x_return_status := FND_API.G_RET_STS_ERROR;

2124: ) THEN
2125: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
2126: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
2127: fnd_msg_pub.add;
2128: x_return_status := FND_API.G_RET_STS_ERROR;
2129: x_msg_count := 1;
2130: fnd_msg_pub.Count_And_Get
2131: (p_count => x_msg_count
2132: ,p_data => x_msg_data

Line 2137: IF FND_API.TO_BOOLEAN(p_commit) THEN

2133: );
2134: RETURN;
2135: END IF;
2136: -- Standard Start of API savepoint
2137: IF FND_API.TO_BOOLEAN(p_commit) THEN
2138: SAVEPOINT EGO_GET_EMAIL_ADDRESS;
2139: END IF;
2140:
2141: mdebug('GET_EMAIL_ADDRESSES: ....1......');

Line 2143: IF NOT FND_API.Compatible_API_Call (l_api_version,

2139: END IF;
2140:
2141: mdebug('GET_EMAIL_ADDRESSES: ....1......');
2142:
2143: IF NOT FND_API.Compatible_API_Call (l_api_version,
2144: p_api_version,
2145: l_api_name,
2146: G_PKG_NAME)
2147: THEN

Line 2148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2144: p_api_version,
2145: l_api_name,
2146: G_PKG_NAME)
2147: THEN
2148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2149: END IF;
2150: -- Initialize API message list if necessary.
2151: -- Initialize message list if p_init_msg_list is set to TRUE.
2152: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 2152: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

2148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2149: END IF;
2150: -- Initialize API message list if necessary.
2151: -- Initialize message list if p_init_msg_list is set to TRUE.
2152: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
2153: FND_MSG_PUB.initialize;
2154: END IF;
2155:
2156: mdebug('GET_EMAIL_ADDRESSES: selecting party type ');

Line 2190: RAISE fnd_api.g_EXC_ERROR;

2186: );
2187: ELSE -- neither PERSON nor GROUP
2188: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_PARTY_TYPE');
2189: FND_MSG_PUB.Add;
2190: RAISE fnd_api.g_EXC_ERROR;
2191: END IF;
2192:
2193: --finally assign prepared e-mail list to the OUT parameter.
2194: x_email_address := l_concat_email_addresses;

Line 2200: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN

2196: mdebug('GET_EMAIL_ADDRESSES: x_return_status '|| x_return_status);
2197: mdebug('GET_EMAIL_ADDRESSES: x_msg_data ' || x_msg_data);
2198:
2199: -- Standard check of p_commit.
2200: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
2201: COMMIT WORK;
2202: END IF;
2203:
2204: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2204: x_return_status := FND_API.G_RET_STS_SUCCESS;

2200: IF FND_API.To_Boolean( NVL(p_commit, 'F') ) THEN
2201: COMMIT WORK;
2202: END IF;
2203:
2204: x_return_status := FND_API.G_RET_STS_SUCCESS;
2205:
2206: -- Standard call to get message count and if count is 1,
2207: -- get message info.
2208: -- The client will directly display the x_msg_data (which is already

Line 2219: WHEN FND_API.G_EXC_ERROR THEN

2215: p_data => x_msg_data
2216: );
2217:
2218: EXCEPTION
2219: WHEN FND_API.G_EXC_ERROR THEN
2220: IF FND_API.TO_BOOLEAN(p_commit) THEN
2221: ROLLBACK TO EGO_GET_EMAIL_ADDRESS;
2222: END IF;
2223: mdebug('GET_EMAIL_ADDRESSES: Ending : Returning FND_API.G_EXC_ERROR ');

Line 2220: IF FND_API.TO_BOOLEAN(p_commit) THEN

2216: );
2217:
2218: EXCEPTION
2219: WHEN FND_API.G_EXC_ERROR THEN
2220: IF FND_API.TO_BOOLEAN(p_commit) THEN
2221: ROLLBACK TO EGO_GET_EMAIL_ADDRESS;
2222: END IF;
2223: mdebug('GET_EMAIL_ADDRESSES: Ending : Returning FND_API.G_EXC_ERROR ');
2224: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2223: mdebug('GET_EMAIL_ADDRESSES: Ending : Returning FND_API.G_EXC_ERROR ');

2219: WHEN FND_API.G_EXC_ERROR THEN
2220: IF FND_API.TO_BOOLEAN(p_commit) THEN
2221: ROLLBACK TO EGO_GET_EMAIL_ADDRESS;
2222: END IF;
2223: mdebug('GET_EMAIL_ADDRESSES: Ending : Returning FND_API.G_EXC_ERROR ');
2224: x_return_status := FND_API.G_RET_STS_ERROR;
2225: FND_MSG_PUB.Count_And_Get
2226: (p_count => x_msg_count,
2227: p_data => x_msg_data

Line 2224: x_return_status := FND_API.G_RET_STS_ERROR;

2220: IF FND_API.TO_BOOLEAN(p_commit) THEN
2221: ROLLBACK TO EGO_GET_EMAIL_ADDRESS;
2222: END IF;
2223: mdebug('GET_EMAIL_ADDRESSES: Ending : Returning FND_API.G_EXC_ERROR ');
2224: x_return_status := FND_API.G_RET_STS_ERROR;
2225: FND_MSG_PUB.Count_And_Get
2226: (p_count => x_msg_count,
2227: p_data => x_msg_data
2228: );

Line 2229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2225: FND_MSG_PUB.Count_And_Get
2226: (p_count => x_msg_count,
2227: p_data => x_msg_data
2228: );
2229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2230: IF FND_API.TO_BOOLEAN(p_commit) THEN
2231: ROLLBACK TO EGO_GET_EMAIL_ADDRESS;
2232: END IF;
2233: mdebug('GET_EMAIL_ADDRESSES: Ending : FND_API.G_EXC_UNEXPECTED_ERROR ');

Line 2230: IF FND_API.TO_BOOLEAN(p_commit) THEN

2226: (p_count => x_msg_count,
2227: p_data => x_msg_data
2228: );
2229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2230: IF FND_API.TO_BOOLEAN(p_commit) THEN
2231: ROLLBACK TO EGO_GET_EMAIL_ADDRESS;
2232: END IF;
2233: mdebug('GET_EMAIL_ADDRESSES: Ending : FND_API.G_EXC_UNEXPECTED_ERROR ');
2234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2233: mdebug('GET_EMAIL_ADDRESSES: Ending : FND_API.G_EXC_UNEXPECTED_ERROR ');

2229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2230: IF FND_API.TO_BOOLEAN(p_commit) THEN
2231: ROLLBACK TO EGO_GET_EMAIL_ADDRESS;
2232: END IF;
2233: mdebug('GET_EMAIL_ADDRESSES: Ending : FND_API.G_EXC_UNEXPECTED_ERROR ');
2234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2235: FND_MSG_PUB.Count_And_Get
2236: ( p_count => x_msg_count,
2237: p_data => x_msg_data

Line 2234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2230: IF FND_API.TO_BOOLEAN(p_commit) THEN
2231: ROLLBACK TO EGO_GET_EMAIL_ADDRESS;
2232: END IF;
2233: mdebug('GET_EMAIL_ADDRESSES: Ending : FND_API.G_EXC_UNEXPECTED_ERROR ');
2234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2235: FND_MSG_PUB.Count_And_Get
2236: ( p_count => x_msg_count,
2237: p_data => x_msg_data
2238: );

Line 2240: IF FND_API.TO_BOOLEAN(p_commit) THEN

2236: ( p_count => x_msg_count,
2237: p_data => x_msg_data
2238: );
2239: WHEN OTHERS THEN
2240: IF FND_API.TO_BOOLEAN(p_commit) THEN
2241: ROLLBACK TO EGO_GET_EMAIL_ADDRESS;
2242: END IF;
2243: mdebug('GET_EMAIL_ADDRESSES: Ending : Returning UNEXPECTED ERROR');
2244: IF c_grp_member_emailaddr%ISOPEN THEN

Line 2247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2243: mdebug('GET_EMAIL_ADDRESSES: Ending : Returning UNEXPECTED ERROR');
2244: IF c_grp_member_emailaddr%ISOPEN THEN
2245: CLOSE c_grp_member_emailaddr;
2246: END IF;
2247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2248: IF FND_MSG_PUB.Check_Msg_Level
2249: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2250: THEN
2251: FND_MSG_PUB.Add_Exc_Msg

Line 2310: x_return_status := FND_API.G_RET_STS_ERROR;

2306: ) THEN
2307: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
2308: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
2309: fnd_msg_pub.add;
2310: x_return_status := FND_API.G_RET_STS_ERROR;
2311: x_msg_count := 1;
2312: fnd_msg_pub.Count_And_Get
2313: (p_count => x_msg_count
2314: ,p_data => x_msg_data

Line 2319: IF FND_API.TO_BOOLEAN(p_commit) THEN

2315: );
2316: RETURN;
2317: END IF;
2318: -- Standard Start of API savepoint
2319: IF FND_API.TO_BOOLEAN(p_commit) THEN
2320: SAVEPOINT EGO_CREATE_CODE_ASSIGNMENT;
2321: END IF;
2322:
2323: mdebug('CREATE_CODE_ASSIGNMENT: ....1......');

Line 2325: IF NOT FND_API.Compatible_API_Call (l_api_version,

2321: END IF;
2322:
2323: mdebug('CREATE_CODE_ASSIGNMENT: ....1......');
2324:
2325: IF NOT FND_API.Compatible_API_Call (l_api_version,
2326: p_api_version,
2327: l_api_name,
2328: G_PKG_NAME)
2329: THEN

Line 2330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2326: p_api_version,
2327: l_api_name,
2328: G_PKG_NAME)
2329: THEN
2330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2331: END IF;
2332: -- Initialize API message list if necessary.
2333: -- Initialize message list if p_init_msg_list is set to TRUE.
2334: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 2334: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

2330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2331: END IF;
2332: -- Initialize API message list if necessary.
2333: -- Initialize message list if p_init_msg_list is set to TRUE.
2334: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
2335: FND_MSG_PUB.initialize;
2336: END IF;
2337:
2338:

Line 2364: FND_API.G_FALSE,

2360: l_code_assignment_rec.application_id := APPLICATION_ID;
2361:
2362: HZ_CLASSIFICATION_V2PUB.create_code_assignment
2363: (
2364: FND_API.G_FALSE,
2365: l_code_assignment_rec,
2366: x_return_status,
2367: x_msg_count,
2368: x_msg_data,

Line 2374: IF FND_API.TO_BOOLEAN(p_commit) THEN

2370: );
2371:
2372: EXCEPTION
2373: WHEN OTHERS THEN
2374: IF FND_API.TO_BOOLEAN(p_commit) THEN
2375: ROLLBACK TO EGO_CREATE_CODE_ASSIGNMENT;
2376: END IF;
2377: x_return_status := 'F';
2378: END create_code_assignment;

Line 2430: x_return_status := FND_API.G_RET_STS_ERROR;

2426: ) THEN
2427: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
2428: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
2429: fnd_msg_pub.add;
2430: x_return_status := FND_API.G_RET_STS_ERROR;
2431: x_msg_count := 1;
2432: fnd_msg_pub.Count_And_Get
2433: (p_count => x_msg_count
2434: ,p_data => x_msg_data

Line 2439: IF FND_API.TO_BOOLEAN(p_commit) THEN

2435: );
2436: RETURN;
2437: END IF;
2438: -- Standard Start of API savepoint
2439: IF FND_API.TO_BOOLEAN(p_commit) THEN
2440: ROLLBACK TO EGO_UPDATE_CODE_ASSIGNMENT;
2441: END IF;
2442:
2443: mdebug('UPDATE_CODE_ASSIGNMENT: ....1......');

Line 2445: IF NOT FND_API.Compatible_API_Call (l_api_version,

2441: END IF;
2442:
2443: mdebug('UPDATE_CODE_ASSIGNMENT: ....1......');
2444:
2445: IF NOT FND_API.Compatible_API_Call (l_api_version,
2446: p_api_version,
2447: l_api_name,
2448: G_PKG_NAME)
2449: THEN

Line 2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2446: p_api_version,
2447: l_api_name,
2448: G_PKG_NAME)
2449: THEN
2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2451: END IF;
2452: -- Initialize API message list if necessary.
2453: -- Initialize message list if p_init_msg_list is set to TRUE.
2454: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

Line 2454: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN

2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2451: END IF;
2452: -- Initialize API message list if necessary.
2453: -- Initialize message list if p_init_msg_list is set to TRUE.
2454: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
2455: FND_MSG_PUB.initialize;
2456: END IF;
2457:
2458:

Line 2480: FND_API.G_FALSE,

2476: l_code_assignment_rec.application_id := APPLICATION_ID;
2477:
2478: HZ_CLASSIFICATION_V2PUB.update_code_assignment
2479: (
2480: FND_API.G_FALSE,
2481: l_code_assignment_rec,
2482: l_version_number,
2483: x_return_status,
2484: x_msg_count,

Line 2516: x_return_status := FND_API.G_RET_STS_SUCCESS;

2512: code_debug (p_log_level => G_DEBUG_LEVEL_PROCEDURE
2513: ,p_module => l_api_name
2514: ,p_message => 'Started with 4 params: company_id: '||p_company_id
2515: );
2516: x_return_status := FND_API.G_RET_STS_SUCCESS;
2517: x_msg_count := 0;
2518: x_msg_data := NULL;
2519: SELECT hca.owner_table_id
2520: INTO l_party_id

Line 2593: x_return_status := FND_API.G_RET_STS_ERROR;

2589: code_debug (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2590: ,p_module => l_api_name
2591: ,p_message => 'EXCEPTION '||SQLERRM
2592: );
2593: x_return_status := FND_API.G_RET_STS_ERROR;
2594: x_msg_count := 1;
2595: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
2596: END setup_enterprise_user;
2597:

Line 2667: p_init_msg_list => FND_API.G_FALSE,

2663: FOR user_rec IN INTERNAL_USERS_WC LOOP
2664: BEGIN
2665: Create_Relationship (
2666: p_api_version => l_api_version,
2667: p_init_msg_list => FND_API.G_FALSE,
2668: p_commit => FND_API.G_FALSE,
2669: p_subject_id => user_rec.PERSON_ID,
2670: p_subject_type => 'PERSON',
2671: p_subject_table_name => 'HZ_PARTIES',

Line 2668: p_commit => FND_API.G_FALSE,

2664: BEGIN
2665: Create_Relationship (
2666: p_api_version => l_api_version,
2667: p_init_msg_list => FND_API.G_FALSE,
2668: p_commit => FND_API.G_FALSE,
2669: p_subject_id => user_rec.PERSON_ID,
2670: p_subject_type => 'PERSON',
2671: p_subject_table_name => 'HZ_PARTIES',
2672: p_object_id => l_org_id,