APPS.IGW_SETUP_PERSONS_PVT dependencies on FND_MSG_PUB

Line 49: Fnd_Msg_Pub.Initialize;

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
53: if (p_country_name is null) then

Line 157: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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:
160:
161: WHEN OTHERS THEN

Line 168: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SETUP_PERSONS_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));
171:
172: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 172: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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));
171:
172: fnd_msg_pub.count_and_get(p_count => x_msg_count,
173: p_data => x_msg_data);
174:
175:
176: END CREATE_PERSON;

Line 227: Fnd_Msg_Pub.Initialize;

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
231: if (p_country_name is null) then

Line 302: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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:
305:
306: WHEN OTHERS THEN

Line 313: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SETUP_PERSONS_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));
316:
317: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 317: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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));
316:
317: fnd_msg_pub.count_and_get(p_count => x_msg_count,
318: p_data => x_msg_data);
319:
320:
321: END UPDATE_PERSON;

Line 340: FND_MSG_PUB.Add;

336:
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;

Line 344: FND_MSG_PUB.Add;

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;
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',

Line 347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_SETUP_PERSONS_PVT',

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));
350: raise fnd_api.g_exc_unexpected_error;
351:

Line 359: l_msg_count := fnd_msg_pub.count_msg;

355: ----------------------------------------------------------------------------------------------
356: PROCEDURE CHECK_ERRORS is
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: