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_API

Line 11: -- Default = FND_API.G_FALSE

7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN : p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 13: -- Default = FND_API.G_FALSE

9: -- IN : p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2

Line 15: -- Default = FND_API.G_VALID_LEVEL_FULL

11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2
18: -- .
19: -- .

Line 59: RAISE fnd_api.g_exc_error;

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

Line 73: RAISE fnd_api.g_exc_error;

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
77: WHERE responsibility_id = p_resp_id

Line 84: RAISE fnd_api.g_exc_error;

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

Line 102: RAISE fnd_api.g_exc_error;

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
106: select count(*) into l_count

Line 114: RAISE fnd_api.g_exc_error;

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

Line 172: RAISE fnd_api.g_exc_error;

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
176: SELECT COUNT(*) INTO l_count

Line 183: RAISE fnd_api.g_exc_error;

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

Line 190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

186: END;
187:
188: PROCEDURE insert_dept_appr
189: ( p_api_version IN NUMBER ,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
193:
194: x_return_status OUT NOCOPY VARCHAR2 ,

Line 191: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

187:
188: PROCEDURE insert_dept_appr
189: ( p_api_version IN NUMBER ,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
193:
194: x_return_status OUT NOCOPY VARCHAR2 ,
195: x_msg_count OUT NOCOPY NUMBER ,

Line 192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

188: PROCEDURE insert_dept_appr
189: ( p_api_version IN NUMBER ,
190: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
191: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
192: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
193:
194: x_return_status OUT NOCOPY VARCHAR2 ,
195: x_msg_count OUT NOCOPY NUMBER ,
196: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 216: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

212: BEGIN
213: -- Standard Start of API savepoint
214: SAVEPOINT INSERT_DEPT_APPR;
215: -- Standard call to check for call compatibility.
216: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
217: p_api_version ,
218: l_api_name ,
219: G_PKG_NAME )
220: THEN

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: p_api_version ,
218: l_api_name ,
219: G_PKG_NAME )
220: THEN
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;

Line 224: IF FND_API.to_Boolean( p_init_msg_list ) THEN

220: THEN
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;

Line 228: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
230:
231: EAM_COMMON_UTILITIES_PVT.verify_org(
232: p_resp_id => NULL,

Line 243: RAISE fnd_api.g_exc_error;

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: /*
247: if not EAM_COMMON_UTILITIES_PVT.validate_department_id(p_dept_id, p_organization_id)

Line 251: RAISE fnd_api.g_exc_error;

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);
255:

Line 263: RAISE fnd_api.g_exc_error;

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.
267: --a dept can be assigned to one responsibility only

Line 272: RAISE fnd_api.g_exc_error;

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);
276:

Line 286: RAISE FND_API.G_EXC_ERROR;

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;
288:
289:
290: INSERT INTO BOM_EAM_DEPT_APPROVERS

Line 321: IF FND_API.To_Boolean( p_commit ) THEN

317: );
318:
319: -- End of API body.
320: -- Standard check of p_commit.
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

Line 330: WHEN FND_API.G_EXC_ERROR THEN

326: ( p_msg_index_out => x_msg_count ,
327: p_data => x_msg_data
328: );
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 ,

Line 332: x_return_status := FND_API.G_RET_STS_ERROR ;

328: );
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: );

Line 337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

335: p_data => x_msg_data
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: );

Line 346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

342: p_data => x_msg_data
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

Line 364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

360:
361:
362: PROCEDURE update_dept_appr
363: ( p_api_version IN NUMBER ,
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
365: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
366: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
367:
368: x_return_status OUT NOCOPY VARCHAR2 ,

Line 365: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

361:
362: PROCEDURE update_dept_appr
363: ( p_api_version IN NUMBER ,
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
365: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
366: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
367:
368: x_return_status OUT NOCOPY VARCHAR2 ,
369: x_msg_count OUT NOCOPY NUMBER ,

Line 366: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

362: PROCEDURE update_dept_appr
363: ( p_api_version IN NUMBER ,
364: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
365: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
366: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
367:
368: x_return_status OUT NOCOPY VARCHAR2 ,
369: x_msg_count OUT NOCOPY NUMBER ,
370: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 394: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

390: BEGIN
391: -- Standard Start of API savepoint
392: SAVEPOINT UPDATE_DEPT_APPR;
393: -- Standard call to check for call compatibility.
394: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
395: p_api_version ,
396: l_api_name ,
397: G_PKG_NAME )
398: THEN

Line 399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

395: p_api_version ,
396: l_api_name ,
397: G_PKG_NAME )
398: THEN
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;

Line 402: IF FND_API.to_Boolean( p_init_msg_list ) THEN

398: THEN
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;

Line 406: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
408:
409: EAM_COMMON_UTILITIES_PVT.verify_org(
410: p_resp_id => NULL,

Line 421: RAISE fnd_api.g_exc_error;

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:
425: /*if not EAM_COMMON_UTILITIES_PVT.validate_department_id(p_dept_id, p_organization_id)

Line 429: RAISE fnd_api.g_exc_error;

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);
433:

Line 441: RAISE fnd_api.g_exc_error;

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);
445:

Line 471: IF FND_API.To_Boolean( p_commit ) THEN

467: RESPONSIBILITY_ID = P_RESPONSIBILITY_ID;
468:
469: -- End of API body.
470: -- Standard check of p_commit.
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

Line 480: WHEN FND_API.G_EXC_ERROR THEN

476: ( p_msg_index_out => x_msg_count ,
477: p_data => x_msg_data
478: );
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 ,

Line 482: x_return_status := FND_API.G_RET_STS_ERROR ;

478: );
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: );

Line 487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

485: p_data => x_msg_data
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: );

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

492: p_data => x_msg_data
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