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.EAM_DEPT_APPROVERS_PUB dependencies on FND_MSG_PUB

Line 58: fnd_msg_pub.add;

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:
62: END;

Line 72: fnd_msg_pub.add;

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
76: FROM fnd_responsibility

Line 83: fnd_msg_pub.add;

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:
87: END ;

Line 101: fnd_msg_pub.add;

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:
105: -- primary_approver_id HAS TO BE VALID USER WITH VALID RESPONSIBILITY ID

Line 113: fnd_msg_pub.add;

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:
117: END validate_primary_approver_id;

Line 171: fnd_msg_pub.add;

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:
175: ELSIF p_create_flag THEN

Line 182: fnd_msg_pub.add;

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;
186: END;

Line 225: FND_MSG_PUB.initialize;

221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223: -- Initialize message list if p_init_msg_list is set to TRUE.
224: IF FND_API.to_Boolean( p_init_msg_list ) THEN
225: FND_MSG_PUB.initialize;
226: END IF;
227: -- Initialize API return status to success
228: x_return_status := FND_API.G_RET_STS_SUCCESS;
229: -- API body

Line 242: fnd_msg_pub.add;

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:
246: /*

Line 250: fnd_msg_pub.add;

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:
254: validate_application_id(p_resp_app_id);

Line 262: fnd_msg_pub.add;

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:
266: -- Bug # 3518888 : Commmenting as it is not required.

Line 271: fnd_msg_pub.add;

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:
275: validate_primary_approver_id (p_primary_approver_id, p_responsibility_id);

Line 283: l_msg_count := FND_MSG_PUB.count_msg;

279: p_resp_app_id ,
280: P_RESPONSIBILITY_ID, true );
281:
282:
283: l_msg_count := FND_MSG_PUB.count_msg;
284: IF l_msg_count > 0 THEN
285: X_msg_count := l_msg_count;
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;

Line 325: FND_MSG_PUB.get

321: IF FND_API.To_Boolean( p_commit ) THEN
322: COMMIT WORK;
323: END IF;
324: -- Standard call to get message count and if count is 1, get message info.
325: FND_MSG_PUB.get
326: ( p_msg_index_out => x_msg_count ,
327: p_data => x_msg_data
328: );
329: EXCEPTION

Line 333: FND_MSG_PUB.get

329: EXCEPTION
330: WHEN FND_API.G_EXC_ERROR THEN
331: ROLLBACK TO INSERT_DEPT_APPR;
332: x_return_status := FND_API.G_RET_STS_ERROR ;
333: FND_MSG_PUB.get
334: ( p_msg_index_out => x_msg_count ,
335: p_data => x_msg_data
336: );
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 340: FND_MSG_PUB.get

336: );
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: ROLLBACK TO INSERT_DEPT_APPR;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
340: FND_MSG_PUB.get
341: ( p_msg_index_out => x_msg_count ,
342: p_data => x_msg_data
343: );
344: WHEN OTHERS THEN

Line 347: IF FND_MSG_PUB.Check_Msg_Level

343: );
344: WHEN OTHERS THEN
345: ROLLBACK TO INSERT_DEPT_APPR;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: IF FND_MSG_PUB.Check_Msg_Level
348: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
349: THEN
350: FND_MSG_PUB.Add_Exc_Msg
351: ( G_PKG_NAME ,

Line 348: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

344: WHEN OTHERS THEN
345: ROLLBACK TO INSERT_DEPT_APPR;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: IF FND_MSG_PUB.Check_Msg_Level
348: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
349: THEN
350: FND_MSG_PUB.Add_Exc_Msg
351: ( G_PKG_NAME ,
352: l_api_name

Line 350: FND_MSG_PUB.Add_Exc_Msg

346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: IF FND_MSG_PUB.Check_Msg_Level
348: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
349: THEN
350: FND_MSG_PUB.Add_Exc_Msg
351: ( G_PKG_NAME ,
352: l_api_name
353: );
354: END IF;

Line 355: FND_MSG_PUB.get

351: ( G_PKG_NAME ,
352: l_api_name
353: );
354: END IF;
355: FND_MSG_PUB.get
356: ( p_msg_index_out => x_msg_count ,
357: p_data => x_msg_data
358: );
359: END INSERT_DEPT_APPR;

Line 403: FND_MSG_PUB.initialize;

399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401: -- Initialize message list if p_init_msg_list is set to TRUE.
402: IF FND_API.to_Boolean( p_init_msg_list ) THEN
403: FND_MSG_PUB.initialize;
404: END IF;
405: -- Initialize API return status to success
406: x_return_status := FND_API.G_RET_STS_SUCCESS;
407: -- API body

Line 420: fnd_msg_pub.add;

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:
424:

Line 428: fnd_msg_pub.add;

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:
432: validate_application_id(p_resp_app_id);

Line 440: fnd_msg_pub.add;

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:
444: validate_primary_approver_id (p_primary_approver_id, p_responsibility_id);

Line 475: FND_MSG_PUB.get

471: IF FND_API.To_Boolean( p_commit ) THEN
472: COMMIT WORK;
473: END IF;
474: -- Standard call to get message count and if count is 1, get message info.
475: FND_MSG_PUB.get
476: ( p_msg_index_out => x_msg_count ,
477: p_data => x_msg_data
478: );
479: EXCEPTION

Line 483: FND_MSG_PUB.get

479: EXCEPTION
480: WHEN FND_API.G_EXC_ERROR THEN
481: ROLLBACK TO UPDATE_DEPT_APPR;
482: x_return_status := FND_API.G_RET_STS_ERROR ;
483: FND_MSG_PUB.get
484: ( p_msg_index_out => x_msg_count ,
485: p_data => x_msg_data
486: );
487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 490: FND_MSG_PUB.get

486: );
487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
488: ROLLBACK TO UPDATE_DEPT_APPR;
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
490: FND_MSG_PUB.get
491: ( p_msg_index_out => x_msg_count ,
492: p_data => x_msg_data
493: );
494: WHEN OTHERS THEN

Line 497: IF FND_MSG_PUB.Check_Msg_Level

493: );
494: WHEN OTHERS THEN
495: ROLLBACK TO UPDATE_DEPT_APPR;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
497: IF FND_MSG_PUB.Check_Msg_Level
498: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: FND_MSG_PUB.Add_Exc_Msg
501: ( G_PKG_NAME ,

Line 498: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

494: WHEN OTHERS THEN
495: ROLLBACK TO UPDATE_DEPT_APPR;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
497: IF FND_MSG_PUB.Check_Msg_Level
498: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: FND_MSG_PUB.Add_Exc_Msg
501: ( G_PKG_NAME ,
502: l_api_name

Line 500: FND_MSG_PUB.Add_Exc_Msg

496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
497: IF FND_MSG_PUB.Check_Msg_Level
498: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: FND_MSG_PUB.Add_Exc_Msg
501: ( G_PKG_NAME ,
502: l_api_name
503: );
504: END IF;

Line 505: FND_MSG_PUB.get

501: ( G_PKG_NAME ,
502: l_api_name
503: );
504: END IF;
505: FND_MSG_PUB.get
506: ( p_msg_index_out => x_msg_count ,
507: p_data => x_msg_data
508: );
509: END update_dept_appr;