DBA Data[Home] [Help]

APPS.EAM_DEPT_APPROVERS_PUB dependencies on FND_MESSAGE

Line 57: fnd_message.set_name('EAM', 'EAM_INVALID_APPLICATION_ID');

53: WHERE APPLICATION_ID = p_application_id;
54:
55: if l_count = 0
56: then
57: fnd_message.set_name('EAM', 'EAM_INVALID_APPLICATION_ID');
58: fnd_msg_pub.add;
59: RAISE fnd_api.g_exc_error;
60: end if;
61:

Line 71: fnd_message.set_name('EAM', 'EAM_DA_INVALID_RESP');

67: l_count number;
68: BEGIN
69: IF p_resp_app_id IS NULL
70: then
71: fnd_message.set_name('EAM', 'EAM_DA_INVALID_RESP');
72: fnd_msg_pub.add;
73: RAISE fnd_api.g_exc_error;
74: end if;
75: SELECT COUNT(*) INTO l_count

Line 82: fnd_message.set_name('EAM', 'EAM_DA_INVALID_RESP');

78: And application_id = p_resp_app_id;
79:
80: if l_count = 0
81: then
82: fnd_message.set_name('EAM', 'EAM_DA_INVALID_RESP');
83: fnd_msg_pub.add;
84: RAISE fnd_api.g_exc_error;
85: end if;
86:

Line 100: fnd_message.set_name('EAM', 'EAM_DA_INVALID_RESP');

96: END IF;
97:
98: IF p_responsibility_id IS NULL
99: THEN
100: fnd_message.set_name('EAM', 'EAM_DA_INVALID_RESP');
101: fnd_msg_pub.add;
102: RAISE fnd_api.g_exc_error;
103: end if;
104:

Line 112: fnd_message.set_name('EAM', 'EAM_DEPT_INV_PRIMARY_APPROVER');

108: AND RESPONSIBILITY_ID = P_RESPONSIBILITY_ID;
109:
110: if l_count = 0
111: then
112: fnd_message.set_name('EAM', 'EAM_DEPT_INV_PRIMARY_APPROVER');
113: fnd_msg_pub.add;
114: RAISE fnd_api.g_exc_error;
115: end if;
116:

Line 170: fnd_message.set_name('EAM', 'EAM_DEPT_REC_NOT_FOUND');

166: ORGANIZATION_ID = P_ORGANIZATION_ID and
167: RESPONSIBILITY_APPLICATION_ID = P_RESP_APP_ID and
168: RESPONSIBILITY_ID = P_RESPONSIBILITY_ID;
169: if l_count = 0 then
170: fnd_message.set_name('EAM', 'EAM_DEPT_REC_NOT_FOUND');
171: fnd_msg_pub.add;
172: RAISE fnd_api.g_exc_error;
173: end if;
174:

Line 181: fnd_message.set_name('EAM', 'EAM_DEPT_REC_EXISTS');

177: FROM BOM_EAM_DEPT_APPROVERS
178: WHERE DEPT_ID = P_DEPT_ID and
179: ORGANIZATION_ID = P_ORGANIZATION_ID;
180: IF l_count > 0 THEN
181: fnd_message.set_name('EAM', 'EAM_DEPT_REC_EXISTS');
182: fnd_msg_pub.add;
183: RAISE fnd_api.g_exc_error;
184: END IF;
185: END IF;

Line 241: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');

237: x_msg_count => l_msg_count ,
238: x_msg_data => l_msg_data);
239: if l_boolean = 0
240: then
241: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
242: fnd_msg_pub.add;
243: RAISE fnd_api.g_exc_error;
244: end if;
245:

Line 249: fnd_message.set_name('EAM', 'EAM_DA_INVALID_DEPT');

245:
246: /*
247: if not EAM_COMMON_UTILITIES_PVT.validate_department_id(p_dept_id, p_organization_id)
248: then
249: fnd_message.set_name('EAM', 'EAM_DA_INVALID_DEPT');
250: fnd_msg_pub.add;
251: RAISE fnd_api.g_exc_error;
252: end if; */
253:

Line 261: fnd_message.set_name('EAM', 'EAM_DA_INVALID_DEPT');

257:
258: -- one department per organization
259: l_bool := validate_department (p_dept_id , p_organization_id);
260: if not l_bool then
261: fnd_message.set_name('EAM', 'EAM_DA_INVALID_DEPT');
262: fnd_msg_pub.add;
263: RAISE fnd_api.g_exc_error;
264: end if;
265:

Line 270: fnd_message.set_name('EAM', 'EAM_INVALID_DEPT_RESP');

266: -- Bug # 3518888 : Commmenting as it is not required.
267: --a dept can be assigned to one responsibility only
268: /*l_bool := validate_dept_assign (p_dept_id , p_responsibility_id);
269: if l_bool then
270: fnd_message.set_name('EAM', 'EAM_INVALID_DEPT_RESP');
271: fnd_msg_pub.add;
272: RAISE fnd_api.g_exc_error;
273: end if;*/
274:

Line 419: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');

415: x_msg_count => l_msg_count ,
416: x_msg_data => l_msg_data);
417: if l_boolean = 0
418: then
419: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
420: fnd_msg_pub.add;
421: RAISE fnd_api.g_exc_error;
422: end if;
423:

Line 427: fnd_message.set_name('EAM', 'EAM_DA_INVALID_DEPT');

423:
424:
425: /*if not EAM_COMMON_UTILITIES_PVT.validate_department_id(p_dept_id, p_organization_id)
426: then
427: fnd_message.set_name('EAM', 'EAM_DA_INVALID_DEPT');
428: fnd_msg_pub.add;
429: RAISE fnd_api.g_exc_error;
430: end if;*/
431:

Line 439: fnd_message.set_name('EAM', 'EAM_DA_INVALID_DEPT');

435:
436: -- one department per organization
437: l_bool := validate_department (p_dept_id , p_organization_id);
438: if not l_bool then
439: fnd_message.set_name('EAM', 'EAM_DA_INVALID_DEPT');
440: fnd_msg_pub.add;
441: RAISE fnd_api.g_exc_error;
442: end if;
443: