DBA Data[Home] [Help]

APPS.EAM_MAINT_ATTRIBUTES_PUB dependencies on FND_MESSAGE

Line 143: fnd_message.set_name('EAM', 'EAM_INVALID_INSTANCE_ID');

139: AND cii.last_vld_organization_id = msi.organization_id AND msi.eam_item_type in (1,3)
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

Line 157: fnd_message.set_name('EAM', 'EAM_INVLD_PARENT_INST_ID');

153: AND msi.serial_number_control_code <> 1 AND msi.organization_id = mp.organization_id
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:

Line 388: fnd_message.set_name('EAM', 'EAM_INVALID_INSTANCE_ID');

384: WHERE cii.instance_id = p_instance_id AND cii.inventory_item_id = msi.inventory_item_id
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:

Line 398: fnd_message.set_name('EAM', 'EAM_MAINT_ORG_MISSING');

394: SELECT mp.maint_organization_id INTO x_org_id FROM csi_item_instances cii, mtl_parameters mp
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:

Line 411: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_OWN_DEPT_ID');

407: WHERE department_id = p_owning_department_id AND organization_id = x_org_id
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;

Line 426: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');

422: WHERE class_code = p_accounting_class_code AND class_type = 6
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;

Line 441: fnd_message.set_name('EAM', 'EAM_LOCATION_ID_INVALID');

437: WHERE location_id = p_area_id AND organization_id = x_org_id
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;