DBA Data[Home] [Help]

APPS.EAM_MAINT_ATTRIBUTES_PUB dependencies on FND_MSG_PUB

Line 86: fnd_msg_pub.initialize;

82: END IF;
83:
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF fnd_api.to_boolean(p_init_msg_list) THEN
86: fnd_msg_pub.initialize;
87: END IF;
88:
89: -- Initialize API return status to success
90: x_return_status := fnd_api.g_ret_sts_success;

Line 144: fnd_msg_pub.add;

140: AND msi.serial_number_control_code <> 1;
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: fnd_message.set_name('EAM', 'EAM_INVALID_INSTANCE_ID');
144: fnd_msg_pub.add;
145: RAISE fnd_api.g_exc_error;
146: END;
147: BEGIN
148: SELECT cii.serial_number, cii.inventory_item_id, cii.last_vld_organization_id

Line 158: fnd_msg_pub.add;

154: AND mp.maint_organization_id = l_org_id;
155: EXCEPTION
156: WHEN NO_DATA_FOUND THEN
157: fnd_message.set_name('EAM', 'EAM_INVLD_PARENT_INST_ID');
158: fnd_msg_pub.add;
159: RAISE fnd_api.g_exc_error;
160: END;
161:
162: wip_eam_genealogy_pvt.create_eam_genealogy

Line 191: fnd_msg_pub.count_and_get(p_count => x_msg_count

187: COMMIT WORK;
188: END IF;
189:
190: -- Standard call to get message count and if count is 1, get message info.
191: fnd_msg_pub.count_and_get(p_count => x_msg_count
192: ,p_data => x_msg_data);
193: EXCEPTION
194: WHEN fnd_api.g_exc_error THEN
195: ROLLBACK TO eam_maint_attributes_pub;

Line 197: fnd_msg_pub.count_and_get(p_count => x_msg_count

193: EXCEPTION
194: WHEN fnd_api.g_exc_error THEN
195: ROLLBACK TO eam_maint_attributes_pub;
196: x_return_status := fnd_api.g_ret_sts_error;
197: fnd_msg_pub.count_and_get(p_count => x_msg_count
198: ,p_data => x_msg_data);
199: WHEN fnd_api.g_exc_unexpected_error THEN
200: ROLLBACK TO eam_maint_attributes_pub;
201: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 202: fnd_msg_pub.count_and_get(p_count => x_msg_count

198: ,p_data => x_msg_data);
199: WHEN fnd_api.g_exc_unexpected_error THEN
200: ROLLBACK TO eam_maint_attributes_pub;
201: x_return_status := fnd_api.g_ret_sts_unexp_error;
202: fnd_msg_pub.count_and_get(p_count => x_msg_count
203: ,p_data => x_msg_data);
204: WHEN OTHERS THEN
205: ROLLBACK TO eam_maint_attributes_pub;
206: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 207: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

203: ,p_data => x_msg_data);
204: WHEN OTHERS THEN
205: ROLLBACK TO eam_maint_attributes_pub;
206: x_return_status := fnd_api.g_ret_sts_unexp_error;
207: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
208: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
209: END IF;
210: fnd_msg_pub.count_and_get(p_count => x_msg_count
211: ,p_data => x_msg_data);

Line 208: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

204: WHEN OTHERS THEN
205: ROLLBACK TO eam_maint_attributes_pub;
206: x_return_status := fnd_api.g_ret_sts_unexp_error;
207: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
208: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
209: END IF;
210: fnd_msg_pub.count_and_get(p_count => x_msg_count
211: ,p_data => x_msg_data);
212: END create_maint_attributes;

Line 210: fnd_msg_pub.count_and_get(p_count => x_msg_count

206: x_return_status := fnd_api.g_ret_sts_unexp_error;
207: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
208: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
209: END IF;
210: fnd_msg_pub.count_and_get(p_count => x_msg_count
211: ,p_data => x_msg_data);
212: END create_maint_attributes;
213:
214:

Line 258: fnd_msg_pub.initialize;

254: END IF;
255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: IF fnd_api.to_boolean(p_init_msg_list) THEN
258: fnd_msg_pub.initialize;
259: END IF;
260:
261: -- Initialize API return status to success
262: x_return_status := fnd_api.g_ret_sts_success;

Line 312: fnd_msg_pub.count_and_get(p_count => x_msg_count

308: COMMIT WORK;
309: END IF;
310:
311: -- Standard call to get message count and if count is 1, get message info.
312: fnd_msg_pub.count_and_get(p_count => x_msg_count
313: ,p_data => x_msg_data);
314: EXCEPTION
315: WHEN fnd_api.g_exc_error THEN
316: ROLLBACK TO eam_maint_attributes_pub;

Line 318: fnd_msg_pub.count_and_get(p_count => x_msg_count

314: EXCEPTION
315: WHEN fnd_api.g_exc_error THEN
316: ROLLBACK TO eam_maint_attributes_pub;
317: x_return_status := fnd_api.g_ret_sts_error;
318: fnd_msg_pub.count_and_get(p_count => x_msg_count
319: ,p_data => x_msg_data);
320: WHEN fnd_api.g_exc_unexpected_error THEN
321: ROLLBACK TO eam_maint_attributes_pub;
322: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 323: fnd_msg_pub.count_and_get(p_count => x_msg_count

319: ,p_data => x_msg_data);
320: WHEN fnd_api.g_exc_unexpected_error THEN
321: ROLLBACK TO eam_maint_attributes_pub;
322: x_return_status := fnd_api.g_ret_sts_unexp_error;
323: fnd_msg_pub.count_and_get(p_count => x_msg_count
324: ,p_data => x_msg_data);
325: WHEN OTHERS THEN
326: ROLLBACK TO eam_maint_attributes_pub;
327: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

324: ,p_data => x_msg_data);
325: WHEN OTHERS THEN
326: ROLLBACK TO eam_maint_attributes_pub;
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
329: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
330: END IF;
331: fnd_msg_pub.count_and_get(p_count => x_msg_count
332: ,p_data => x_msg_data);

Line 329: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

325: WHEN OTHERS THEN
326: ROLLBACK TO eam_maint_attributes_pub;
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
329: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
330: END IF;
331: fnd_msg_pub.count_and_get(p_count => x_msg_count
332: ,p_data => x_msg_data);
333: END update_maint_attributes;

Line 331: fnd_msg_pub.count_and_get(p_count => x_msg_count

327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
329: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
330: END IF;
331: fnd_msg_pub.count_and_get(p_count => x_msg_count
332: ,p_data => x_msg_data);
333: END update_maint_attributes;
334:
335:

Line 374: fnd_msg_pub.initialize;

370: END IF;
371:
372: -- Initialize message list if p_init_msg_list is set to TRUE.
373: IF fnd_api.to_boolean(p_init_msg_list) THEN
374: fnd_msg_pub.initialize;
375: END IF;
376:
377: -- Initialize API return status to success
378: x_return_status := fnd_api.g_ret_sts_success;

Line 389: fnd_msg_pub.add;

385: AND cii.last_vld_organization_id = msi.organization_id AND msi.eam_item_type in (1,3)
386: AND msi.serial_number_control_code <> 1;
387: IF l_count = 0 THEN
388: fnd_message.set_name('EAM', 'EAM_INVALID_INSTANCE_ID');
389: fnd_msg_pub.add;
390: RAISE fnd_api.g_exc_error;
391: END IF;
392:
393: -- Select the maintenance organization id

Line 399: fnd_msg_pub.add;

395: WHERE cii.instance_id = p_instance_id AND cii.last_vld_organization_id = mp.organization_id;
396:
397: IF x_org_id is NULL THEN
398: fnd_message.set_name('EAM', 'EAM_MAINT_ORG_MISSING');
399: fnd_msg_pub.add;
400: RAISE fnd_api.g_exc_error;
401: END IF;
402:
403: -- Validate dept id

Line 412: fnd_msg_pub.add;

408: AND nvl(disable_date, sysdate+1) >= sysdate;
409:
410: IF l_count = 0 THEN
411: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_OWN_DEPT_ID');
412: fnd_msg_pub.add;
413: RAISE fnd_api.g_exc_error;
414: END IF;
415: END IF;
416: END IF;

Line 427: fnd_msg_pub.add;

423: AND organization_id = x_org_id;
424:
425: IF l_count = 0 THEN
426: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
427: fnd_msg_pub.add;
428: RAISE fnd_api.g_exc_error;
429: END IF;
430: END IF;
431: END IF;

Line 442: fnd_msg_pub.add;

438: AND sysdate BETWEEN nvl(start_date, sysdate-1) AND nvl(end_date, sysdate+1);
439:
440: IF l_count = 0 THEN
441: fnd_message.set_name('EAM', 'EAM_LOCATION_ID_INVALID');
442: fnd_msg_pub.add;
443: RAISE fnd_api.g_exc_error;
444: END IF;
445: END IF;
446: END IF;

Line 456: fnd_msg_pub.count_and_get(p_count => x_msg_count

452: COMMIT WORK;
453: END IF;
454:
455: -- Standard call to get message count and if count is 1, get message info.
456: fnd_msg_pub.count_and_get(p_count => x_msg_count
457: ,p_data => x_msg_data);
458: EXCEPTION
459: WHEN fnd_api.g_exc_error THEN
460: ROLLBACK TO eam_maint_attributes_pub;

Line 462: fnd_msg_pub.count_and_get(p_count => x_msg_count

458: EXCEPTION
459: WHEN fnd_api.g_exc_error THEN
460: ROLLBACK TO eam_maint_attributes_pub;
461: x_return_status := fnd_api.g_ret_sts_error;
462: fnd_msg_pub.count_and_get(p_count => x_msg_count
463: ,p_data => x_msg_data);
464: WHEN fnd_api.g_exc_unexpected_error THEN
465: ROLLBACK TO eam_maint_attributes_pub;
466: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 467: fnd_msg_pub.count_and_get(p_count => x_msg_count

463: ,p_data => x_msg_data);
464: WHEN fnd_api.g_exc_unexpected_error THEN
465: ROLLBACK TO eam_maint_attributes_pub;
466: x_return_status := fnd_api.g_ret_sts_unexp_error;
467: fnd_msg_pub.count_and_get(p_count => x_msg_count
468: ,p_data => x_msg_data);
469: WHEN OTHERS THEN
470: ROLLBACK TO eam_maint_attributes_pub;
471: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 472: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

468: ,p_data => x_msg_data);
469: WHEN OTHERS THEN
470: ROLLBACK TO eam_maint_attributes_pub;
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
473: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
474: END IF;
475: fnd_msg_pub.count_and_get(p_count => x_msg_count
476: ,p_data => x_msg_data);

Line 473: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

469: WHEN OTHERS THEN
470: ROLLBACK TO eam_maint_attributes_pub;
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
473: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
474: END IF;
475: fnd_msg_pub.count_and_get(p_count => x_msg_count
476: ,p_data => x_msg_data);
477: END validate_maint_defaults;

Line 475: fnd_msg_pub.count_and_get(p_count => x_msg_count

471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
473: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
474: END IF;
475: fnd_msg_pub.count_and_get(p_count => x_msg_count
476: ,p_data => x_msg_data);
477: END validate_maint_defaults;
478:
479: END eam_maint_attributes_pub ;