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

Line 5: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,

1: PACKAGE BODY IGW_SETUP_PERSONS_PVT AS
2: --$Header: igwvspeb.pls 115.5 2002/11/15 00:48:33 ashkumar noship $
3:
4: PROCEDURE CREATE_PERSON (
5: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
6: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
7: p_commit IN VARCHAR2 := Fnd_Api.G_False,
8: p_status IN VARCHAR2,
9: p_person_pre_name_adjunct IN VARCHAR2,

Line 6: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,

2: --$Header: igwvspeb.pls 115.5 2002/11/15 00:48:33 ashkumar noship $
3:
4: PROCEDURE CREATE_PERSON (
5: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
6: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
7: p_commit IN VARCHAR2 := Fnd_Api.G_False,
8: p_status IN VARCHAR2,
9: p_person_pre_name_adjunct IN VARCHAR2,
10: p_person_first_name IN VARCHAR2,

Line 7: p_commit IN VARCHAR2 := Fnd_Api.G_False,

3:
4: PROCEDURE CREATE_PERSON (
5: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
6: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
7: p_commit IN VARCHAR2 := Fnd_Api.G_False,
8: p_status IN VARCHAR2,
9: p_person_pre_name_adjunct IN VARCHAR2,
10: p_person_first_name IN VARCHAR2,
11: p_person_middle_name IN VARCHAR2,

Line 42: IF Fnd_Api.To_Boolean(p_commit) THEN

38: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
39: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
40:
41: BEGIN
42: IF Fnd_Api.To_Boolean(p_commit) THEN
43: SAVEPOINT Create_Person_Pvt;
44: END IF;
45:
46: x_return_status := Fnd_Api.G_Ret_Sts_Success;

Line 46: x_return_status := Fnd_Api.G_Ret_Sts_Success;

42: IF Fnd_Api.To_Boolean(p_commit) THEN
43: SAVEPOINT Create_Person_Pvt;
44: END IF;
45:
46: x_return_status := Fnd_Api.G_Ret_Sts_Success;
47:
48: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
49: Fnd_Msg_Pub.Initialize;
50: END IF;

Line 48: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

44: END IF;
45:
46: x_return_status := Fnd_Api.G_Ret_Sts_Success;
47:
48: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
49: Fnd_Msg_Pub.Initialize;
50: END IF;
51:
52: -- get country_code from country_name if country_code is null

Line 83: p_init_msg_list => FND_API.g_false,

79:
80:
81: Hz_Party_V2pub.Create_Person
82: (
83: p_init_msg_list => FND_API.g_false,
84: p_person_rec => l_person_rec,
85: x_party_id => x_party_id,
86: x_party_number => x_party_number,
87: x_profile_id => x_profile_id,

Line 107: P_INIT_MSG_LIST => FND_API.g_false,

103: l_location_rec.created_by_module := 'IGW';
104:
105: Hz_Location_V2pub.Create_Location
106: (
107: P_INIT_MSG_LIST => FND_API.g_false,
108: p_location_rec => l_location_rec,
109: x_location_id => x_location_id,
110: X_RETURN_STATUS => X_RETURN_STATUS,
111: X_MSG_COUNT => X_MSG_COUNT,

Line 130: P_INIT_MSG_LIST => FND_API.g_false,

126: END IF;
127:
128: Hz_Party_Site_V2pub.Create_Party_Site
129: (
130: P_INIT_MSG_LIST => FND_API.g_false,
131: p_party_site_rec => l_party_site_rec,
132: x_party_site_id => l_party_site_id,
133: x_party_site_number => l_party_site_number,
134: X_RETURN_STATUS => X_RETURN_STATUS,

Line 143: IF Fnd_Api.To_Boolean(p_commit) THEN

139: check_errors;
140:
141:
142:
143: IF Fnd_Api.To_Boolean(p_commit) THEN
144:
145: COMMIT;
146:
147: END IF;

Line 150: WHEN FND_API.G_EXC_ERROR THEN

146:
147: END IF;
148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: IF p_commit = FND_API.G_TRUE THEN
152: ROLLBACK TO Create_Person_Pvt;
153: END IF;
154:

Line 151: IF p_commit = FND_API.G_TRUE THEN

147: END IF;
148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: IF p_commit = FND_API.G_TRUE THEN
152: ROLLBACK TO Create_Person_Pvt;
153: END IF;
154:
155: x_return_status := FND_API.G_RET_STS_ERROR;

Line 155: x_return_status := FND_API.G_RET_STS_ERROR;

151: IF p_commit = FND_API.G_TRUE THEN
152: ROLLBACK TO Create_Person_Pvt;
153: END IF;
154:
155: x_return_status := FND_API.G_RET_STS_ERROR;
156:
157: fnd_msg_pub.count_and_get(p_count => x_msg_count,
158: p_data => x_msg_data);
159:

Line 162: IF p_commit = FND_API.G_TRUE THEN

158: p_data => x_msg_data);
159:
160:
161: WHEN OTHERS THEN
162: IF p_commit = FND_API.G_TRUE THEN
163: ROLLBACK TO Create_Person_Pvt;
164: END IF;
165:
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

162: IF p_commit = FND_API.G_TRUE THEN
163: ROLLBACK TO Create_Person_Pvt;
164: END IF;
165:
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167:
168: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SETUP_PERSONS_PVT',
169: p_procedure_name => 'CREATE_PERSON',
170: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 180: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,

176: END CREATE_PERSON;
177:
178: --------------------------------------------------------------------------------------------------------
179: PROCEDURE UPDATE_PERSON (
180: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
181: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
182: p_commit IN VARCHAR2 := Fnd_Api.G_False,
183: p_party_id IN NUMBER,
184: p_location_id IN NUMBER,

Line 181: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,

177:
178: --------------------------------------------------------------------------------------------------------
179: PROCEDURE UPDATE_PERSON (
180: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
181: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
182: p_commit IN VARCHAR2 := Fnd_Api.G_False,
183: p_party_id IN NUMBER,
184: p_location_id IN NUMBER,
185: p_status IN VARCHAR2,

Line 182: p_commit IN VARCHAR2 := Fnd_Api.G_False,

178: --------------------------------------------------------------------------------------------------------
179: PROCEDURE UPDATE_PERSON (
180: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
181: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
182: p_commit IN VARCHAR2 := Fnd_Api.G_False,
183: p_party_id IN NUMBER,
184: p_location_id IN NUMBER,
185: p_status IN VARCHAR2,
186: p_person_pre_name_adjunct IN VARCHAR2,

Line 220: IF Fnd_Api.To_Boolean(p_commit) THEN

216: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
217: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
218:
219: BEGIN
220: IF Fnd_Api.To_Boolean(p_commit) THEN
221: SAVEPOINT Update_Person_Pvt;
222: END IF;
223:
224: x_return_status := Fnd_Api.G_Ret_Sts_Success;

Line 224: x_return_status := Fnd_Api.G_Ret_Sts_Success;

220: IF Fnd_Api.To_Boolean(p_commit) THEN
221: SAVEPOINT Update_Person_Pvt;
222: END IF;
223:
224: x_return_status := Fnd_Api.G_Ret_Sts_Success;
225:
226: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
227: Fnd_Msg_Pub.Initialize;
228: END IF;

Line 226: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

222: END IF;
223:
224: x_return_status := Fnd_Api.G_Ret_Sts_Success;
225:
226: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
227: Fnd_Msg_Pub.Initialize;
228: END IF;
229:
230: -- get country_code from country_name if country_code is null

Line 255: p_init_msg_list => FND_API.g_false,

251:
252:
253: Hz_Party_V2pub.Update_Person
254: (
255: p_init_msg_list => FND_API.g_false,
256: p_person_rec => l_person_rec,
257: p_party_object_version_number => l_party_object_version_number,
258: x_profile_id => x_profile_id,
259: X_RETURN_STATUS => X_RETURN_STATUS,

Line 279: P_INIT_MSG_LIST => FND_API.g_false,

275: l_location_rec.created_by_module := 'IGW';
276:
277: Hz_Location_V2pub.Update_Location
278: (
279: P_INIT_MSG_LIST => FND_API.g_false,
280: p_location_rec => l_location_rec,
281: p_object_version_number => l_loc_object_version_number,
282: X_RETURN_STATUS => X_RETURN_STATUS,
283: X_MSG_COUNT => X_MSG_COUNT,

Line 288: IF Fnd_Api.To_Boolean(p_commit) THEN

284: X_MSG_DATA => X_MSG_DATA
285: );
286: check_errors;
287:
288: IF Fnd_Api.To_Boolean(p_commit) THEN
289:
290: COMMIT;
291:
292: END IF;

Line 295: WHEN FND_API.G_EXC_ERROR THEN

291:
292: END IF;
293:
294: EXCEPTION
295: WHEN FND_API.G_EXC_ERROR THEN
296: IF p_commit = FND_API.G_TRUE THEN
297: ROLLBACK TO Update_Person_Pvt;
298: END IF;
299:

Line 296: IF p_commit = FND_API.G_TRUE THEN

292: END IF;
293:
294: EXCEPTION
295: WHEN FND_API.G_EXC_ERROR THEN
296: IF p_commit = FND_API.G_TRUE THEN
297: ROLLBACK TO Update_Person_Pvt;
298: END IF;
299:
300: x_return_status := FND_API.G_RET_STS_ERROR;

Line 300: x_return_status := FND_API.G_RET_STS_ERROR;

296: IF p_commit = FND_API.G_TRUE THEN
297: ROLLBACK TO Update_Person_Pvt;
298: END IF;
299:
300: x_return_status := FND_API.G_RET_STS_ERROR;
301:
302: fnd_msg_pub.count_and_get(p_count => x_msg_count,
303: p_data => x_msg_data);
304:

Line 307: IF p_commit = FND_API.G_TRUE THEN

303: p_data => x_msg_data);
304:
305:
306: WHEN OTHERS THEN
307: IF p_commit = FND_API.G_TRUE THEN
308: ROLLBACK TO Update_Person_Pvt;
309: END IF;
310:
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

307: IF p_commit = FND_API.G_TRUE THEN
308: ROLLBACK TO Update_Person_Pvt;
309: END IF;
310:
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312:
313: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SETUP_PERSONS_PVT',
314: p_procedure_name => 'UPDATE_PERSON',
315: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 341: raise fnd_api.g_exc_error;

337: exception
338: when no_data_found then
339: FND_MESSAGE.SET_NAME('IGW','IGW_SS_COUNTRY_INVALID');
340: FND_MSG_PUB.Add;
341: raise fnd_api.g_exc_error;
342: when too_many_rows then
343: FND_MESSAGE.SET_NAME('IGW','IGW_SS_COUNTRY_INVALID');
344: FND_MSG_PUB.Add;
345: raise fnd_api.g_exc_error;

Line 345: raise fnd_api.g_exc_error;

341: raise fnd_api.g_exc_error;
342: when too_many_rows then
343: FND_MESSAGE.SET_NAME('IGW','IGW_SS_COUNTRY_INVALID');
344: FND_MSG_PUB.Add;
345: raise fnd_api.g_exc_error;
346: when others then
347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SETUP_PERSONS_PVT',
348: p_procedure_name => 'GET_COUNTRY_CODE',
349: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 350: raise fnd_api.g_exc_unexpected_error;

346: when others then
347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SETUP_PERSONS_PVT',
348: p_procedure_name => 'GET_COUNTRY_CODE',
349: p_error_text => SUBSTRB(SQLERRM,1,240));
350: raise fnd_api.g_exc_unexpected_error;
351:
352: END GET_COUNTRY_CODE;
353:
354:

Line 361: RAISE FND_API.G_EXC_ERROR;

357: l_msg_count NUMBER;
358: BEGIN
359: l_msg_count := fnd_msg_pub.count_msg;
360: IF (l_msg_count > 0) THEN
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363:
364: END CHECK_ERRORS;
365: