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

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

56: PRAGMA EXCEPTION_INIT(apps_exception, -20001);
57:
58: PROCEDURE Update_Privacy(
59: p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,

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

57:
58: PROCEDURE Update_Privacy(
59: p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2,

Line 62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

58: PROCEDURE Update_Privacy(
59: p_api_version IN NUMBER,
60: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61: p_commit IN VARCHAR2 := FND_API.G_FALSE,
62: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2,
66: x_privacy_level_id OUT NOCOPY NUMBER,

Line 101: IF NOT FND_API.Compatible_API_Call (l_api_version,

97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT Update_Privacy;
100: -- Standard call to check for call compatibility.
101: IF NOT FND_API.Compatible_API_Call (l_api_version,
102: p_api_version,
103: l_api_name,
104: G_PKG_NAME)
105: THEN

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102: p_api_version,
103: l_api_name,
104: G_PKG_NAME)
105: THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: IF FND_API.to_Boolean (p_init_msg_list) THEN
111: FND_MSG_PUB.initialize;
112: END IF;
113: -- Bug # 3311720

Line 110: IF FND_API.to_Boolean (p_init_msg_list) THEN

106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: IF FND_API.to_Boolean (p_init_msg_list) THEN
111: FND_MSG_PUB.initialize;
112: END IF;
113: -- Bug # 3311720
114: FND_MSG_PUB.initialize;

Line 181: IF FND_API.To_Boolean( p_commit ) THEN

177: );
178: END IF;
179: -- End of API body.
180: -- Standard check of p_commit.
181: IF FND_API.To_Boolean( p_commit ) THEN
182: COMMIT WORK;
183: END IF;
184: -- Standard call to get message count and if count is 1, get message info.
185: FND_MSG_PUB.Count_And_Get

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

188: );
189: EXCEPTION
190: WHEN apps_exception THEN
191: ROLLBACK TO Update_Privacy;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
194: p_data => x_msg_data );
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO Update_Privacy;

Line 195: WHEN FND_API.G_EXC_ERROR THEN

191: ROLLBACK TO Update_Privacy;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
194: p_data => x_msg_data );
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO Update_Privacy;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
199: p_data => x_msg_data );

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
194: p_data => x_msg_data );
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO Update_Privacy;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
199: p_data => x_msg_data );
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO Update_Privacy;

Line 200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

196: ROLLBACK TO Update_Privacy;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
199: p_data => x_msg_data );
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO Update_Privacy;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
204: p_data => x_msg_data );

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
199: p_data => x_msg_data );
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO Update_Privacy;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
204: p_data => x_msg_data );
205: WHEN OTHERS THEN
206: ROLLBACK TO Update_Privacy;

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

203: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
204: p_data => x_msg_data );
205: WHEN OTHERS THEN
206: ROLLBACK TO Update_Privacy;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
209: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
210: END IF;
211: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 305: x_return_status := FND_API.G_RET_STS_SUCCESS;

301: -- Standard Start of API savepoint
302: SAVEPOINT Update_Person;
303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: FND_MSG_PUB.initialize;
308: -- API body
309: /* 1. Get the Preferred Person Id Type

Line 381: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

377: x_attribute22 => p_attribute22,
378: x_attribute23 => p_attribute23,
379: x_attribute24 => p_attribute24
380: );
381: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
382: raise FND_API.G_EXC_ERROR;
383: END IF;
384: END LOOP;
385: -- End of API body.

Line 382: raise FND_API.G_EXC_ERROR;

378: x_attribute23 => p_attribute23,
379: x_attribute24 => p_attribute24
380: );
381: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
382: raise FND_API.G_EXC_ERROR;
383: END IF;
384: END LOOP;
385: -- End of API body.
386:

Line 406: x_return_status := FND_API.G_RET_STS_ERROR;

402: FND_MESSAGE.SET_TOKEN('ALT_ID_DESC2', pref_id_rec.description);
403: IGS_GE_MSG_STACK.ADD;
404: END IF;
405:
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
408: p_data => x_msg_data );
409:
410: WHEN FND_API.G_EXC_ERROR THEN

Line 410: WHEN FND_API.G_EXC_ERROR THEN

406: x_return_status := FND_API.G_RET_STS_ERROR;
407: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
408: p_data => x_msg_data );
409:
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO Update_Person;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
414: p_data => x_msg_data );

Line 412: x_return_status := FND_API.G_RET_STS_ERROR;

408: p_data => x_msg_data );
409:
410: WHEN FND_API.G_EXC_ERROR THEN
411: ROLLBACK TO Update_Person;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
414: p_data => x_msg_data );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO Update_Person;

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

411: ROLLBACK TO Update_Person;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
414: p_data => x_msg_data );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO Update_Person;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
419: p_data => x_msg_data );

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

413: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
414: p_data => x_msg_data );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO Update_Person;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
419: p_data => x_msg_data );
420: WHEN OTHERS THEN
421: ROLLBACK TO Update_Person;

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

418: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
419: p_data => x_msg_data );
420: WHEN OTHERS THEN
421: ROLLBACK TO Update_Person;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
424: p_data => x_msg_data );
425: END Update_Person;
426:

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

425: END Update_Person;
426:
427: PROCEDURE Update_Contact(
428: p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,

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

426:
427: PROCEDURE Update_Contact(
428: p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,

Line 431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

427: PROCEDURE Update_Contact(
428: p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
430: p_commit IN VARCHAR2 := FND_API.G_FALSE,
431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,
435: x_id OUT NOCOPY NUMBER,

Line 523: IF NOT FND_API.Compatible_API_Call (l_api_version,

519: BEGIN
520: -- Standard Start of API savepoint
521: SAVEPOINT Update_Phone;
522: -- Standard call to check for call compatibility.
523: IF NOT FND_API.Compatible_API_Call (l_api_version,
524: p_api_version,
525: l_api_name,
526: G_PKG_NAME)
527: THEN

Line 528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

524: p_api_version,
525: l_api_name,
526: G_PKG_NAME)
527: THEN
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;
530: -- Initialize message list if p_init_msg_list is set to TRUE.
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 531: x_return_status := FND_API.G_RET_STS_SUCCESS;

527: THEN
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;
530: -- Initialize message list if p_init_msg_list is set to TRUE.
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532: IF FND_API.to_Boolean (p_init_msg_list) THEN
533: FND_MSG_PUB.initialize;
534: END IF;
535:

Line 532: IF FND_API.to_Boolean (p_init_msg_list) THEN

528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;
530: -- Initialize message list if p_init_msg_list is set to TRUE.
531: x_return_status := FND_API.G_RET_STS_SUCCESS;
532: IF FND_API.to_Boolean (p_init_msg_list) THEN
533: FND_MSG_PUB.initialize;
534: END IF;
535:
536: FND_MSG_PUB.initialize;

Line 661: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

657: p_attribute19 => c_contacs_rec.attribute19,
658: p_attribute20 => c_contacs_rec.attribute20
659: ) ;
660: END IF;
661: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
662: raise FND_API.G_EXC_ERROR;
663: END IF;
664: END LOOP;
665: ELSIF l_mode ='INSERT' THEN

Line 662: raise FND_API.G_EXC_ERROR;

658: p_attribute20 => c_contacs_rec.attribute20
659: ) ;
660: END IF;
661: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
662: raise FND_API.G_EXC_ERROR;
663: END IF;
664: END LOOP;
665: ELSIF l_mode ='INSERT' THEN
666: IF (p_email_format IS NULL) THEN -- Insert phone

Line 702: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

698: p_contact_point_id => l_contact_point_id,
699: p_contact_point_ovn => p_contact_point_ovn
700: ) ;
701: END IF;
702: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
703: raise FND_API.G_EXC_ERROR;
704: END IF;
705: END IF;
706: x_id := l_contact_point_id;

Line 703: raise FND_API.G_EXC_ERROR;

699: p_contact_point_ovn => p_contact_point_ovn
700: ) ;
701: END IF;
702: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
703: raise FND_API.G_EXC_ERROR;
704: END IF;
705: END IF;
706: x_id := l_contact_point_id;
707: -- End of API body.

Line 709: IF FND_API.To_Boolean( p_commit ) THEN

705: END IF;
706: x_id := l_contact_point_id;
707: -- End of API body.
708: -- Standard check of p_commit.
709: IF FND_API.To_Boolean( p_commit ) THEN
710: COMMIT WORK;
711: END IF;
712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get

Line 720: x_return_status := FND_API.G_RET_STS_ERROR;

716: );
717: EXCEPTION
718: WHEN apps_exception THEN
719: ROLLBACK TO Update_Phone;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
722: p_data => x_msg_data );
723: WHEN FND_API.G_EXC_ERROR THEN
724: ROLLBACK TO Update_Phone;

Line 723: WHEN FND_API.G_EXC_ERROR THEN

719: ROLLBACK TO Update_Phone;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
722: p_data => x_msg_data );
723: WHEN FND_API.G_EXC_ERROR THEN
724: ROLLBACK TO Update_Phone;
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
727: p_data => x_msg_data );

Line 725: x_return_status := FND_API.G_RET_STS_ERROR;

721: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
722: p_data => x_msg_data );
723: WHEN FND_API.G_EXC_ERROR THEN
724: ROLLBACK TO Update_Phone;
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
727: p_data => x_msg_data );
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO Update_Person;

Line 728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

724: ROLLBACK TO Update_Phone;
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
727: p_data => x_msg_data );
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO Update_Person;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
732: p_data => x_msg_data );

Line 730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

726: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
727: p_data => x_msg_data );
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO Update_Person;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
732: p_data => x_msg_data );
733: WHEN OTHERS THEN
734: ROLLBACK TO Update_Phone;

Line 735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

731: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
732: p_data => x_msg_data );
733: WHEN OTHERS THEN
734: ROLLBACK TO Update_Phone;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
737: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
738: END IF;
739: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

741: END Update_Contact;
742:
743: PROCEDURE Update_Address(
744: p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
746: p_commit IN VARCHAR2 := FND_API.G_FALSE,
747: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
748: x_return_status OUT NOCOPY VARCHAR2,
749: x_msg_count OUT NOCOPY NUMBER,

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

742:
743: PROCEDURE Update_Address(
744: p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
746: p_commit IN VARCHAR2 := FND_API.G_FALSE,
747: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
748: x_return_status OUT NOCOPY VARCHAR2,
749: x_msg_count OUT NOCOPY NUMBER,
750: x_msg_data OUT NOCOPY VARCHAR2,

Line 747: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

743: PROCEDURE Update_Address(
744: p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
746: p_commit IN VARCHAR2 := FND_API.G_FALSE,
747: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
748: x_return_status OUT NOCOPY VARCHAR2,
749: x_msg_count OUT NOCOPY NUMBER,
750: x_msg_data OUT NOCOPY VARCHAR2,
751: x_id OUT NOCOPY NUMBER,

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

779: END Update_Address;
780:
781: PROCEDURE Update_Usage(
782: p_api_version IN NUMBER,
783: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
784: p_commit IN VARCHAR2 := FND_API.G_FALSE,
785: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
786: x_return_status OUT NOCOPY VARCHAR2,
787: x_msg_count OUT NOCOPY NUMBER,

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

780:
781: PROCEDURE Update_Usage(
782: p_api_version IN NUMBER,
783: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
784: p_commit IN VARCHAR2 := FND_API.G_FALSE,
785: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
786: x_return_status OUT NOCOPY VARCHAR2,
787: x_msg_count OUT NOCOPY NUMBER,
788: x_msg_data OUT NOCOPY VARCHAR2,

Line 785: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

781: PROCEDURE Update_Usage(
782: p_api_version IN NUMBER,
783: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
784: p_commit IN VARCHAR2 := FND_API.G_FALSE,
785: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
786: x_return_status OUT NOCOPY VARCHAR2,
787: x_msg_count OUT NOCOPY NUMBER,
788: x_msg_data OUT NOCOPY VARCHAR2,
789: x_id OUT NOCOPY NUMBER,

Line 837: IF NOT FND_API.Compatible_API_Call (l_api_version,

833: BEGIN
834: -- Standard Start of API savepoint
835: SAVEPOINT Update_Usage;
836: -- Standard call to check for call compatibility.
837: IF NOT FND_API.Compatible_API_Call (l_api_version,
838: p_api_version,
839: l_api_name,
840: G_PKG_NAME)
841: THEN

Line 842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

838: p_api_version,
839: l_api_name,
840: G_PKG_NAME)
841: THEN
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844: -- Initialize message list if p_init_msg_list is set to TRUE.
845: x_return_status := FND_API.G_RET_STS_SUCCESS;
846: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 845: x_return_status := FND_API.G_RET_STS_SUCCESS;

841: THEN
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844: -- Initialize message list if p_init_msg_list is set to TRUE.
845: x_return_status := FND_API.G_RET_STS_SUCCESS;
846: IF FND_API.to_Boolean (p_init_msg_list) THEN
847: FND_MSG_PUB.initialize;
848: END IF;
849:

Line 846: IF FND_API.to_Boolean (p_init_msg_list) THEN

842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END IF;
844: -- Initialize message list if p_init_msg_list is set to TRUE.
845: x_return_status := FND_API.G_RET_STS_SUCCESS;
846: IF FND_API.to_Boolean (p_init_msg_list) THEN
847: FND_MSG_PUB.initialize;
848: END IF;
849:
850: FND_MSG_PUB.initialize;

Line 885: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

881: p_profile_last_update_date => l_date,
882: p_status => p_active,
883: p_hz_party_site_use_ovn => p_hz_party_site_use_ovn
884: );
885: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
886: raise FND_API.G_EXC_ERROR;
887: END IF;
888: x_id := l_party_site_use_id;
889: -- End of API body.

Line 886: raise FND_API.G_EXC_ERROR;

882: p_status => p_active,
883: p_hz_party_site_use_ovn => p_hz_party_site_use_ovn
884: );
885: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
886: raise FND_API.G_EXC_ERROR;
887: END IF;
888: x_id := l_party_site_use_id;
889: -- End of API body.
890: -- Standard check of p_commit.

Line 891: IF FND_API.To_Boolean( p_commit ) THEN

887: END IF;
888: x_id := l_party_site_use_id;
889: -- End of API body.
890: -- Standard check of p_commit.
891: IF FND_API.To_Boolean( p_commit ) THEN
892: COMMIT WORK;
893: END IF;
894: -- Standard call to get message count and if count is 1, get message info.
895: FND_MSG_PUB.Count_And_Get

Line 902: x_return_status := FND_API.G_RET_STS_ERROR;

898: );
899: EXCEPTION
900: WHEN apps_exception THEN
901: ROLLBACK TO Update_Usage;
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
904: p_data => x_msg_data );
905: WHEN FND_API.G_EXC_ERROR THEN
906: ROLLBACK TO Update_Usage;

Line 905: WHEN FND_API.G_EXC_ERROR THEN

901: ROLLBACK TO Update_Usage;
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
904: p_data => x_msg_data );
905: WHEN FND_API.G_EXC_ERROR THEN
906: ROLLBACK TO Update_Usage;
907: x_return_status := FND_API.G_RET_STS_ERROR;
908: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
909: p_data => x_msg_data );

Line 907: x_return_status := FND_API.G_RET_STS_ERROR;

903: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
904: p_data => x_msg_data );
905: WHEN FND_API.G_EXC_ERROR THEN
906: ROLLBACK TO Update_Usage;
907: x_return_status := FND_API.G_RET_STS_ERROR;
908: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
909: p_data => x_msg_data );
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: ROLLBACK TO Update_Usage;

Line 910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

906: ROLLBACK TO Update_Usage;
907: x_return_status := FND_API.G_RET_STS_ERROR;
908: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
909: p_data => x_msg_data );
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: ROLLBACK TO Update_Usage;
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
914: p_data => x_msg_data );

Line 912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

908: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
909: p_data => x_msg_data );
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: ROLLBACK TO Update_Usage;
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
914: p_data => x_msg_data );
915: WHEN OTHERS THEN
916: ROLLBACK TO Update_Usage;

Line 917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

913: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
914: p_data => x_msg_data );
915: WHEN OTHERS THEN
916: ROLLBACK TO Update_Usage;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
919: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
920: END IF;
921: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

923: END Update_Usage;
924:
925: PROCEDURE Update_Employment(
926: p_api_version IN NUMBER,
927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
928: p_commit IN VARCHAR2 := FND_API.G_FALSE,
929: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
930: x_return_status OUT NOCOPY VARCHAR2,
931: x_msg_count OUT NOCOPY NUMBER,

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

924:
925: PROCEDURE Update_Employment(
926: p_api_version IN NUMBER,
927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
928: p_commit IN VARCHAR2 := FND_API.G_FALSE,
929: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
930: x_return_status OUT NOCOPY VARCHAR2,
931: x_msg_count OUT NOCOPY NUMBER,
932: x_msg_data OUT NOCOPY VARCHAR2,

Line 929: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

925: PROCEDURE Update_Employment(
926: p_api_version IN NUMBER,
927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
928: p_commit IN VARCHAR2 := FND_API.G_FALSE,
929: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
930: x_return_status OUT NOCOPY VARCHAR2,
931: x_msg_count OUT NOCOPY NUMBER,
932: x_msg_data OUT NOCOPY VARCHAR2,
933: x_id OUT NOCOPY NUMBER,

Line 976: IF NOT FND_API.Compatible_API_Call (l_api_version,

972: BEGIN
973: -- Standard Start of API savepoint
974: SAVEPOINT Update_Employment;
975: -- Standard call to check for call compatibility.
976: IF NOT FND_API.Compatible_API_Call (l_api_version,
977: p_api_version,
978: l_api_name,
979: G_PKG_NAME)
980: THEN

Line 981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

977: p_api_version,
978: l_api_name,
979: G_PKG_NAME)
980: THEN
981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
982: END IF;
983: -- Initialize message list if p_init_msg_list is set to TRUE.
984: x_return_status := FND_API.G_RET_STS_SUCCESS;
985: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 984: x_return_status := FND_API.G_RET_STS_SUCCESS;

980: THEN
981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
982: END IF;
983: -- Initialize message list if p_init_msg_list is set to TRUE.
984: x_return_status := FND_API.G_RET_STS_SUCCESS;
985: IF FND_API.to_Boolean (p_init_msg_list) THEN
986: FND_MSG_PUB.initialize;
987: END IF;
988:

Line 985: IF FND_API.to_Boolean (p_init_msg_list) THEN

981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
982: END IF;
983: -- Initialize message list if p_init_msg_list is set to TRUE.
984: x_return_status := FND_API.G_RET_STS_SUCCESS;
985: IF FND_API.to_Boolean (p_init_msg_list) THEN
986: FND_MSG_PUB.initialize;
987: END IF;
988:
989: FND_MSG_PUB.initialize;

Line 1034: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1030: x_employed_by_party_id => c_rowid_rec.employed_by_party_id,
1031: x_reason_for_leaving => c_rowid_rec.reason_for_leaving,
1032: x_msg_data => l_msg_data );
1033:
1034: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1035: raise FND_API.G_EXC_ERROR;
1036: END IF;
1037: END LOOP;
1038: ELSIF p_mode='INSERT' THEN

Line 1035: raise FND_API.G_EXC_ERROR;

1031: x_reason_for_leaving => c_rowid_rec.reason_for_leaving,
1032: x_msg_data => l_msg_data );
1033:
1034: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1035: raise FND_API.G_EXC_ERROR;
1036: END IF;
1037: END LOOP;
1038: ELSIF p_mode='INSERT' THEN
1039: igs_ad_emp_dtl_pkg.insert_row(

Line 1066: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1062: x_object_version_number => p_object_version_number,
1063: x_employed_by_party_id => p_employed_by_party_id,
1064: x_reason_for_leaving => p_reason_for_leaving
1065: );
1066: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1067: raise FND_API.G_EXC_ERROR;
1068: END IF;
1069: ELSIF p_mode='DELETE' THEN
1070: FOR c_rowid_rec IN c_rowid LOOP

Line 1067: raise FND_API.G_EXC_ERROR;

1063: x_employed_by_party_id => p_employed_by_party_id,
1064: x_reason_for_leaving => p_reason_for_leaving
1065: );
1066: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1067: raise FND_API.G_EXC_ERROR;
1068: END IF;
1069: ELSIF p_mode='DELETE' THEN
1070: FOR c_rowid_rec IN c_rowid LOOP
1071: l_rowid := c_rowid_rec.row_id;

Line 1079: IF FND_API.To_Boolean( p_commit ) THEN

1075: END IF;
1076: x_id := l_employment_history_id;
1077: -- End of API body.
1078: -- Standard check of p_commit.
1079: IF FND_API.To_Boolean( p_commit ) THEN
1080: COMMIT WORK;
1081: END IF;
1082: -- Standard call to get message count and if count is 1, get message info.
1083: FND_MSG_PUB.Count_And_Get

Line 1090: x_return_status := FND_API.G_RET_STS_ERROR;

1086: );
1087: EXCEPTION
1088: WHEN apps_exception THEN
1089: ROLLBACK TO Update_Employment;
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1092: p_data => x_msg_data );
1093: WHEN FND_API.G_EXC_ERROR THEN
1094: ROLLBACK TO Update_Employment;

Line 1093: WHEN FND_API.G_EXC_ERROR THEN

1089: ROLLBACK TO Update_Employment;
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1092: p_data => x_msg_data );
1093: WHEN FND_API.G_EXC_ERROR THEN
1094: ROLLBACK TO Update_Employment;
1095: x_return_status := FND_API.G_RET_STS_ERROR;
1096: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1097: p_data => x_msg_data );

Line 1095: x_return_status := FND_API.G_RET_STS_ERROR;

1091: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1092: p_data => x_msg_data );
1093: WHEN FND_API.G_EXC_ERROR THEN
1094: ROLLBACK TO Update_Employment;
1095: x_return_status := FND_API.G_RET_STS_ERROR;
1096: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1097: p_data => x_msg_data );
1098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1099: ROLLBACK TO Update_Employment;

Line 1098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1094: ROLLBACK TO Update_Employment;
1095: x_return_status := FND_API.G_RET_STS_ERROR;
1096: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1097: p_data => x_msg_data );
1098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1099: ROLLBACK TO Update_Employment;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1102: p_data => x_msg_data );

Line 1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1096: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1097: p_data => x_msg_data );
1098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1099: ROLLBACK TO Update_Employment;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1102: p_data => x_msg_data );
1103: WHEN OTHERS THEN
1104: ROLLBACK TO Update_Employment;

Line 1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1101: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1102: p_data => x_msg_data );
1103: WHEN OTHERS THEN
1104: ROLLBACK TO Update_Employment;
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1107: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1108: END IF;
1109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

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

1111: END Update_Employment;
1112:
1113: PROCEDURE Update_Emergency(
1114: p_api_version IN NUMBER,
1115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1118: x_return_status OUT NOCOPY VARCHAR2,
1119: x_msg_count OUT NOCOPY NUMBER,

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

1112:
1113: PROCEDURE Update_Emergency(
1114: p_api_version IN NUMBER,
1115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1118: x_return_status OUT NOCOPY VARCHAR2,
1119: x_msg_count OUT NOCOPY NUMBER,
1120: x_msg_data OUT NOCOPY VARCHAR2,

Line 1117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

1113: PROCEDURE Update_Emergency(
1114: p_api_version IN NUMBER,
1115: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1116: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1117: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1118: x_return_status OUT NOCOPY VARCHAR2,
1119: x_msg_count OUT NOCOPY NUMBER,
1120: x_msg_data OUT NOCOPY VARCHAR2,
1121: x_id OUT NOCOPY NUMBER,

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

1141: END Update_Emergency;
1142:
1143: PROCEDURE Update_Dates(
1144: p_api_version IN NUMBER,
1145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1148: x_return_status OUT NOCOPY VARCHAR2,
1149: x_msg_count OUT NOCOPY NUMBER,

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

1142:
1143: PROCEDURE Update_Dates(
1144: p_api_version IN NUMBER,
1145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1148: x_return_status OUT NOCOPY VARCHAR2,
1149: x_msg_count OUT NOCOPY NUMBER,
1150: x_msg_data OUT NOCOPY VARCHAR2,

Line 1147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

1143: PROCEDURE Update_Dates(
1144: p_api_version IN NUMBER,
1145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1148: x_return_status OUT NOCOPY VARCHAR2,
1149: x_msg_count OUT NOCOPY NUMBER,
1150: x_msg_data OUT NOCOPY VARCHAR2,
1151: p_person_id IN NUMBER,

Line 1176: IF NOT FND_API.Compatible_API_Call (l_api_version,

1172: BEGIN
1173: -- Standard Start of API savepoint
1174: SAVEPOINT Update_Dates;
1175: -- Standard call to check for call compatibility.
1176: IF NOT FND_API.Compatible_API_Call (l_api_version,
1177: p_api_version,
1178: l_api_name,
1179: G_PKG_NAME)
1180: THEN

Line 1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1177: p_api_version,
1178: l_api_name,
1179: G_PKG_NAME)
1180: THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183: -- Initialize message list if p_init_msg_list is set to TRUE.
1184: x_return_status := FND_API.G_RET_STS_SUCCESS;
1185: FND_MSG_PUB.initialize;

Line 1184: x_return_status := FND_API.G_RET_STS_SUCCESS;

1180: THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: END IF;
1183: -- Initialize message list if p_init_msg_list is set to TRUE.
1184: x_return_status := FND_API.G_RET_STS_SUCCESS;
1185: FND_MSG_PUB.initialize;
1186:
1187: IF P_ACTION = 'LOCK' THEN
1188: FOR l_stdnt_ps_attempt_dtls_rec IN c_get_stdnt_ps_att_dtls(p_person_id, p_course_cd) LOOP

Line 1350: IF FND_API.To_Boolean( p_commit ) THEN

1346: END LOOP;
1347: END IF;
1348: -- End of API body.
1349: -- Standard check of p_commit.
1350: IF FND_API.To_Boolean( p_commit ) THEN
1351: COMMIT WORK;
1352: END IF;
1353: -- Standard call to get message count and if count is 1, get message info.
1354: FND_MSG_PUB.Count_And_Get

Line 1361: x_return_status := FND_API.G_RET_STS_ERROR;

1357: );
1358: EXCEPTION
1359: WHEN apps_exception THEN
1360: ROLLBACK TO Update_Dates;
1361: x_return_status := FND_API.G_RET_STS_ERROR;
1362: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1363: p_data => x_msg_data );
1364: WHEN FND_API.G_EXC_ERROR THEN
1365: ROLLBACK TO Update_Dates;

Line 1364: WHEN FND_API.G_EXC_ERROR THEN

1360: ROLLBACK TO Update_Dates;
1361: x_return_status := FND_API.G_RET_STS_ERROR;
1362: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1363: p_data => x_msg_data );
1364: WHEN FND_API.G_EXC_ERROR THEN
1365: ROLLBACK TO Update_Dates;
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1368: p_data => x_msg_data );

Line 1366: x_return_status := FND_API.G_RET_STS_ERROR;

1362: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1363: p_data => x_msg_data );
1364: WHEN FND_API.G_EXC_ERROR THEN
1365: ROLLBACK TO Update_Dates;
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1368: p_data => x_msg_data );
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: ROLLBACK TO Update_Dates;

Line 1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1365: ROLLBACK TO Update_Dates;
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1368: p_data => x_msg_data );
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: ROLLBACK TO Update_Dates;
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1372: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1373: p_data => x_msg_data );

Line 1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1367: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1368: p_data => x_msg_data );
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: ROLLBACK TO Update_Dates;
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1372: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1373: p_data => x_msg_data );
1374: WHEN OTHERS THEN
1375: ROLLBACK TO Update_Dates;

Line 1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1372: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1373: p_data => x_msg_data );
1374: WHEN OTHERS THEN
1375: ROLLBACK TO Update_Dates;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1378: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1379: END IF;
1380: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 1524: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1520: l_religion igs_pe_stat_v.religion%TYPE;
1521: BEGIN
1522: SAVEPOINT Update_Biographic;
1523: -- Initialize message list if p_init_msg_list is set to TRUE.
1524: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1525: FND_MSG_PUB.initialize;
1526:
1527: -- API body
1528:

Line 1726: p_return_status := FND_API.G_RET_STS_ERROR;

1722:
1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: ROLLBACK TO Update_Biographic;
1726: p_return_status := FND_API.G_RET_STS_ERROR;
1727: p_msg_data := SQLERRM;
1728: END Update_Biographic;
1729:
1730: PROCEDURE CREATEUPDATE_PERS_ALTID (

Line 1802: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1798:
1799: BEGIN
1800:
1801: -- Initialize message list if p_init_msg_list is set to TRUE.
1802: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1803: FND_MSG_PUB.initialize;
1804:
1805: l_api_person_id := UPPER(p_api_person_id);
1806:

Line 1950: p_return_status := FND_API.G_RET_STS_ERROR;

1946: FND_MESSAGE.SET_TOKEN('ALT_ID_DESC1', l_alt_id_desc);
1947: FND_MESSAGE.SET_TOKEN('ALT_ID_DESC2', l_alt_id_desc);
1948: IGS_GE_MSG_STACK.ADD;
1949: END IF;
1950: p_return_status := FND_API.G_RET_STS_ERROR;
1951: p_msg_data := SQLERRM;
1952:
1953: END createupdate_pers_altid;
1954:

Line 1985: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1981:
1982: record_info_rec record_info_cur%ROWTYPE;
1983: l_test_date DATE;
1984: BEGIN
1985: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1986: FND_MSG_PUB.initialize;
1987:
1988: /*
1989: IF for the P_TEST_RESULT_ID and P_TEST_SEGMENT_ID combination there are no records,

Line 2113: p_return_status := FND_API.G_RET_STS_ERROR;

2109: END IF;
2110:
2111: EXCEPTION
2112: WHEN OTHERS THEN
2113: p_return_status := FND_API.G_RET_STS_ERROR;
2114: p_msg_data := SQLERRM;
2115: END UPDATE_TEST_RESULT_DETAILS;
2116:
2117: FUNCTION CHECK_DUPLICATE_LOC(

Line 2417: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2413: l_relationship_id NUMBER;
2414: BEGIN
2415: FND_MSG_PUB.initialize;
2416: SAVEPOINT CreateUpdate_Relationship;
2417: P_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2418:
2419: OPEN c_existing_rel(p_first_name,p_last_name,p_subject_id,p_rel_code);
2420: FETCH c_existing_rel INTO l_object_id, l_relationship_id;
2421: CLOSE c_existing_rel;

Line 2496: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2492: X_ATTRIBUTE23 => NULL,
2493: X_ATTRIBUTE24 => NULL
2494: );
2495:
2496: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2497: RAISE FND_API.G_EXC_ERROR;
2498: END IF;
2499:
2500: UPDATE_BIOGRAPHIC(

Line 2497: RAISE FND_API.G_EXC_ERROR;

2493: X_ATTRIBUTE24 => NULL
2494: );
2495:
2496: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2497: RAISE FND_API.G_EXC_ERROR;
2498: END IF;
2499:
2500: UPDATE_BIOGRAPHIC(
2501: P_PERSON_ID => P_OBJECT_ID,

Line 2515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2511: P_MSG_COUNT => P_MSG_COUNT,
2512: P_MSG_DATA => l_msg_data,
2513: P_CALLER => 'RELATIONSHIP_SS'
2514: );
2515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518:
2519: IF P_JOINT_MAILING = 'Y' THEN

Line 2516: RAISE FND_API.G_EXC_ERROR;

2512: P_MSG_DATA => l_msg_data,
2513: P_CALLER => 'RELATIONSHIP_SS'
2514: );
2515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518:
2519: IF P_JOINT_MAILING = 'Y' THEN
2520: l_primary := 'N';

Line 2583: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2579: p_party_site_ovn => l_party_site_ovn,
2580: p_location_ovn => l_location_ovn,
2581: p_status => rec_student_addr.status
2582: );
2583: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2584: RAISE FND_API.G_EXC_ERROR;
2585: END IF;
2586:
2587: FOR rec_site_detail IN c_site_detail(rec_student_addr.party_site_id)

Line 2584: RAISE FND_API.G_EXC_ERROR;

2580: p_location_ovn => l_location_ovn,
2581: p_status => rec_student_addr.status
2582: );
2583: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2584: RAISE FND_API.G_EXC_ERROR;
2585: END IF;
2586:
2587: FOR rec_site_detail IN c_site_detail(rec_student_addr.party_site_id)
2588: LOOP

Line 2604: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2600: p_profile_last_update_date => l_profile_last_update_date,
2601: p_status => 'A',
2602: P_HZ_PARTY_SITE_USE_OVN => l_object_version_number
2603: );
2604: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: END IF;
2607: END LOOP;
2608: ELSE

Line 2605: RAISE FND_API.G_EXC_ERROR;

2601: p_status => 'A',
2602: P_HZ_PARTY_SITE_USE_OVN => l_object_version_number
2603: );
2604: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2605: RAISE FND_API.G_EXC_ERROR;
2606: END IF;
2607: END LOOP;
2608: ELSE
2609: CLOSE c_location;

Line 2651: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2647: P_REP_ALUMNI => P_REP_ALUMNI,
2648: P_DIRECTIONAL_FLAG => P_DIRECTIONAL_FLAG,
2649: P_EMERGENCY_CONTACT_FLAG => P_EMERGENCY_CONTACT
2650: );
2651: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2652: RAISE FND_API.G_EXC_ERROR;
2653: END IF;
2654:
2655: ELSIF (P_MODE = 'UPDATE') OR (P_MODE = 'INSERT' AND l_object_id <> -1) THEN

Line 2652: RAISE FND_API.G_EXC_ERROR;

2648: P_DIRECTIONAL_FLAG => P_DIRECTIONAL_FLAG,
2649: P_EMERGENCY_CONTACT_FLAG => P_EMERGENCY_CONTACT
2650: );
2651: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2652: RAISE FND_API.G_EXC_ERROR;
2653: END IF;
2654:
2655: ELSIF (P_MODE = 'UPDATE') OR (P_MODE = 'INSERT' AND l_object_id <> -1) THEN
2656: --update mode called.

Line 2742: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2738: X_ATTRIBUTE22 => l_person.ATTRIBUTE22,
2739: X_ATTRIBUTE23 => l_person.ATTRIBUTE23,
2740: X_ATTRIBUTE24 => l_person.ATTRIBUTE24
2741: );
2742: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2743: RAISE FND_API.G_EXC_ERROR;
2744: END IF;
2745:
2746: UPDATE_BIOGRAPHIC(

Line 2743: RAISE FND_API.G_EXC_ERROR;

2739: X_ATTRIBUTE23 => l_person.ATTRIBUTE23,
2740: X_ATTRIBUTE24 => l_person.ATTRIBUTE24
2741: );
2742: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2743: RAISE FND_API.G_EXC_ERROR;
2744: END IF;
2745:
2746: UPDATE_BIOGRAPHIC(
2747: P_PERSON_ID => P_OBJECT_ID,

Line 2761: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2757: P_MSG_COUNT => P_MSG_COUNT,
2758: P_MSG_DATA => p_msg_data,
2759: P_CALLER => 'RELATIONSHIP_SS'
2760: );
2761: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2762: RAISE FND_API.G_EXC_ERROR;
2763: END IF;
2764: ELSE
2765: err_msg_data :='IGS_PE_HR_PERS_RELATION';

Line 2762: RAISE FND_API.G_EXC_ERROR;

2758: P_MSG_DATA => p_msg_data,
2759: P_CALLER => 'RELATIONSHIP_SS'
2760: );
2761: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2762: RAISE FND_API.G_EXC_ERROR;
2763: END IF;
2764: ELSE
2765: err_msg_data :='IGS_PE_HR_PERS_RELATION';
2766: END IF;

Line 2831: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2827: P_DIRECTIONAL_FLAG => P_DIRECTIONAL_FLAG,
2828: P_EMERGENCY_CONTACT_FLAG => P_EMERGENCY_CONTACT
2829: );
2830:
2831: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2832: RAISE FND_API.G_EXC_ERROR;
2833: END IF;
2834:
2835: IF P_COPY_PRIMARY_ADDR = 'Y' THEN

Line 2832: RAISE FND_API.G_EXC_ERROR;

2828: P_EMERGENCY_CONTACT_FLAG => P_EMERGENCY_CONTACT
2829: );
2830:
2831: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2832: RAISE FND_API.G_EXC_ERROR;
2833: END IF;
2834:
2835: IF P_COPY_PRIMARY_ADDR = 'Y' THEN
2836:

Line 2901: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2897: p_party_site_ovn => l_party_site_ovn,
2898: p_location_ovn => l_location_ovn,
2899: p_status => rec_student_addr.status
2900: );
2901: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2902: RAISE FND_API.G_EXC_ERROR;
2903: END IF;
2904:
2905: FOR rec_site_detail IN c_site_detail(rec_student_addr.party_site_id)

Line 2902: RAISE FND_API.G_EXC_ERROR;

2898: p_location_ovn => l_location_ovn,
2899: p_status => rec_student_addr.status
2900: );
2901: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2902: RAISE FND_API.G_EXC_ERROR;
2903: END IF;
2904:
2905: FOR rec_site_detail IN c_site_detail(rec_student_addr.party_site_id)
2906: LOOP

Line 2922: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2918: p_profile_last_update_date => l_profile_last_update_date,
2919: p_status => 'A',
2920: P_HZ_PARTY_SITE_USE_OVN => l_object_version_number
2921: );
2922: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2923: RAISE FND_API.G_EXC_ERROR;
2924: END IF;
2925: END LOOP;
2926: END IF;

Line 2923: RAISE FND_API.G_EXC_ERROR;

2919: p_status => 'A',
2920: P_HZ_PARTY_SITE_USE_OVN => l_object_version_number
2921: );
2922: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2923: RAISE FND_API.G_EXC_ERROR;
2924: END IF;
2925: END LOOP;
2926: END IF;
2927: END IF;

Line 2965: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2961: P_REP_STUDENT => P_REP_STUDENT,
2962: P_REP_ALUMNI => P_REP_ALUMNI,
2963: P_DIRECTIONAL_FLAG => P_DIRECTIONAL_FLAG
2964: );
2965: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;
2968: -- Delete functionality ends
2969: END IF; --(P_MODE = 'UPDATE') or (P_MODE = 'INSERT' and l_object_id <> -1)

Line 2966: RAISE FND_API.G_EXC_ERROR;

2962: P_REP_ALUMNI => P_REP_ALUMNI,
2963: P_DIRECTIONAL_FLAG => P_DIRECTIONAL_FLAG
2964: );
2965: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2966: RAISE FND_API.G_EXC_ERROR;
2967: END IF;
2968: -- Delete functionality ends
2969: END IF; --(P_MODE = 'UPDATE') or (P_MODE = 'INSERT' and l_object_id <> -1)
2970:

Line 2975: p_return_status := FND_API.G_RET_STS_ERROR;

2971: p_msg_data := err_msg_data;
2972: EXCEPTION
2973: WHEN OTHERS THEN
2974: ROLLBACK TO CreateUpdate_Relationship;
2975: p_return_status := FND_API.G_RET_STS_ERROR;
2976: p_msg_data := SQLERRM;
2977: END createupdate_relationship;
2978:
2979: END IGS_PE_PERSON_SS_PKG;