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_PARAMETERS_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 204: RAISE FND_API.G_EXC_ERROR;

200: if not EAM_COMMON_UTILITIES_PVT.validate_boolean_flag(p_flag)
201: then
202: fnd_message.set_name('EAM', p_msg);
203: fnd_msg_pub.add;
204: RAISE FND_API.G_EXC_ERROR;
205: end if;
206: end if;
207: end;
208:

Line 222: RAISE fnd_api.g_exc_error;

218: if l_count = 0
219: then
220: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
221: fnd_msg_pub.add;
222: RAISE fnd_api.g_exc_error;
223: end if;
224:
225:
226: end;

Line 250: RAISE fnd_api.g_exc_error;

246: IF (l_installed = FALSE)
247: THEN
248: fnd_message.set_name('EAM', 'EAM_WR_PN_NOT_INSTALLED');
249: fnd_msg_pub.add;
250: RAISE fnd_api.g_exc_error;
251: END IF;
252: end if;
253: END;
254:

Line 268: RAISE fnd_api.g_exc_error;

264: if (l_count = 0 and NOT p_create_flag)
265: then
266: fnd_message.set_name('EAM', 'EAM_PARAM_REC_NOT_FOUND');
267: fnd_msg_pub.add;
268: RAISE fnd_api.g_exc_error;
269: elsif (l_count >0 and p_create_flag)
270: then
271: fnd_message.set_name('EAM', 'EAM_PARAM_REC_EXISTS');
272: fnd_msg_pub.add;

Line 273: RAISE fnd_api.g_exc_error;

269: elsif (l_count >0 and p_create_flag)
270: then
271: fnd_message.set_name('EAM', 'EAM_PARAM_REC_EXISTS');
272: fnd_msg_pub.add;
273: RAISE fnd_api.g_exc_error;
274: end if;
275: END;
276:
277:

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

276:
277:
278: PROCEDURE insert_parameters
279: ( p_api_version IN NUMBER ,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
281: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
283:
284: x_return_status OUT NOCOPY VARCHAR2 ,

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

277:
278: PROCEDURE insert_parameters
279: ( p_api_version IN NUMBER ,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
281: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
283:
284: x_return_status OUT NOCOPY VARCHAR2 ,
285: x_msg_count OUT NOCOPY NUMBER ,

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

278: PROCEDURE insert_parameters
279: ( p_api_version IN NUMBER ,
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
281: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
283:
284: x_return_status OUT NOCOPY VARCHAR2 ,
285: x_msg_count OUT NOCOPY NUMBER ,
286: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 325: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

321: BEGIN
322: -- Standard Start of API savepoint
323: SAVEPOINT INSERT_PARAMETERS;
324: -- Standard call to check for call compatibility.
325: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
326: p_api_version ,
327: l_api_name ,
328: G_PKG_NAME )
329: THEN

Line 330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

326: p_api_version ,
327: l_api_name ,
328: G_PKG_NAME )
329: THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF FND_API.to_Boolean( p_init_msg_list ) THEN
334: FND_MSG_PUB.initialize;

Line 333: IF FND_API.to_Boolean( p_init_msg_list ) THEN

329: THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF FND_API.to_Boolean( p_init_msg_list ) THEN
334: FND_MSG_PUB.initialize;
335: END IF;
336: -- Initialize API return status to success
337: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 337: x_return_status := FND_API.G_RET_STS_SUCCESS;

333: IF FND_API.to_Boolean( p_init_msg_list ) THEN
334: FND_MSG_PUB.initialize;
335: END IF;
336: -- Initialize API return status to success
337: x_return_status := FND_API.G_RET_STS_SUCCESS;
338: -- API body
339:
340: -- verify that all "not null" params are provided
341: if (P_DEF_MAINT_COST_CATEGORY is null

Line 347: RAISE FND_API.G_EXC_ERROR;

343: or P_DEFAULT_EAM_CLASS is null)
344: then
345: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAMS');
346: fnd_msg_pub.add;
347: RAISE FND_API.G_EXC_ERROR;
348: end if;
349:
350: --ver eam enabled
351: validate_org_eam_enabled(p_organization_id);

Line 358: RAISE FND_API.G_EXC_ERROR;

354: if not validate_mfg_lookups('BOM_EAM_COST_CATEGORY', P_DEF_MAINT_COST_CATEGORY)
355: then
356: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_COST_CAT');
357: fnd_msg_pub.add;
358: RAISE FND_API.G_EXC_ERROR;
359: end if;
360:
361: --VALIDATE Billing_BASIS
362: if not validate_mfg_lookups('EAM_BILLING_BASIS', P_BILLING_BASIS)

Line 366: RAISE FND_API.G_EXC_ERROR;

362: if not validate_mfg_lookups('EAM_BILLING_BASIS', P_BILLING_BASIS)
363: then
364: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_BILLING_BASIS');
365: fnd_msg_pub.add;
366: RAISE FND_API.G_EXC_ERROR;
367: end if;
368:
369: -- VALIDATE BILLING_METHOD
370: if not validate_mfg_lookups('EAM_BILLING_METHOD', P_BILLING_METHOD)

Line 374: RAISE FND_API.G_EXC_ERROR;

370: if not validate_mfg_lookups('EAM_BILLING_METHOD', P_BILLING_METHOD)
371: then
372: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_BILLING_METHOD');
373: fnd_msg_pub.add;
374: RAISE FND_API.G_EXC_ERROR;
375: end if;
376:
377: --ver def cost element id
378: if not validate_cost_element_id(P_DEF_EAM_COST_ELEMENT_ID )

Line 382: RAISE FND_API.G_EXC_ERROR;

378: if not validate_cost_element_id(P_DEF_EAM_COST_ELEMENT_ID )
379: then
380: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CST_ELMNT_ID');
381: fnd_msg_pub.add;
382: RAISE FND_API.G_EXC_ERROR;
383: end if;
384: --ver wip acnt class
385: if not validate_acnt_class(P_DEFAULT_EAM_CLASS , P_ORGANIZATION_ID )
386: then

Line 389: RAISE FND_API.G_EXC_ERROR;

385: if not validate_acnt_class(P_DEFAULT_EAM_CLASS , P_ORGANIZATION_ID )
386: then
387: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
388: fnd_msg_pub.add;
389: RAISE FND_API.G_EXC_ERROR;
390: end if;
391: --ver maint offset acnt
392: if not validate_chart_of_accounts(P_MAINTENANCE_OFFSET_ACCOUNT ,P_ORGANIZATION_ID )
393: then

Line 396: RAISE FND_API.G_EXC_ERROR;

392: if not validate_chart_of_accounts(P_MAINTENANCE_OFFSET_ACCOUNT ,P_ORGANIZATION_ID )
393: then
394: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CHART_ACNT');
395: fnd_msg_pub.add;
396: RAISE FND_API.G_EXC_ERROR;
397: end if;
398:
399: -- validate default dept id
400: if (p_default_department_id is not null and not eam_common_utilities_pvt.validate_department_id(p_default_department_id, p_organization_id)) then

Line 403: RAISE FND_API.G_EXC_ERROR;

399: -- validate default dept id
400: if (p_default_department_id is not null and not eam_common_utilities_pvt.validate_department_id(p_default_department_id, p_organization_id)) then
401: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_DEPT_ID');
402: fnd_msg_pub.add;
403: RAISE FND_API.G_EXC_ERROR;
404: end if;
405:
406: --varifyflag values 'Y' or 'N'
407: --WorkRequestAutoApprove

Line 507: IF FND_API.To_Boolean( p_commit ) THEN

503: );
504:
505: -- End of API body.
506: -- Standard check of p_commit.
507: IF FND_API.To_Boolean( p_commit ) THEN
508: COMMIT WORK;
509: END IF;
510: -- Standard call to get message count and if count is 1, get message info.
511: FND_MSG_PUB.get

Line 516: WHEN FND_API.G_EXC_ERROR THEN

512: ( p_msg_index_out => x_msg_count ,
513: p_data => x_msg_data
514: );
515: EXCEPTION
516: WHEN FND_API.G_EXC_ERROR THEN
517: ROLLBACK TO INSERT_PARAMETERS;
518: x_return_status := FND_API.G_RET_STS_ERROR ;
519: FND_MSG_PUB.get
520: ( p_msg_index_out => x_msg_count ,

Line 518: x_return_status := FND_API.G_RET_STS_ERROR ;

514: );
515: EXCEPTION
516: WHEN FND_API.G_EXC_ERROR THEN
517: ROLLBACK TO INSERT_PARAMETERS;
518: x_return_status := FND_API.G_RET_STS_ERROR ;
519: FND_MSG_PUB.get
520: ( p_msg_index_out => x_msg_count ,
521: p_data => x_msg_data
522: );

Line 523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

519: FND_MSG_PUB.get
520: ( p_msg_index_out => x_msg_count ,
521: p_data => x_msg_data
522: );
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
524: ROLLBACK TO INSERT_PARAMETERS;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: FND_MSG_PUB.get
527: ( p_msg_index_out => x_msg_count ,

Line 525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

521: p_data => x_msg_data
522: );
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
524: ROLLBACK TO INSERT_PARAMETERS;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: FND_MSG_PUB.get
527: ( p_msg_index_out => x_msg_count ,
528: p_data => x_msg_data
529: );

Line 532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

528: p_data => x_msg_data
529: );
530: WHEN OTHERS THEN
531: ROLLBACK TO INSERT_PARAMETERS;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: IF FND_MSG_PUB.Check_Msg_Level
534: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
535: THEN
536: FND_MSG_PUB.Add_Exc_Msg

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

546:
547:
548: PROCEDURE update_parameters
549: ( p_api_version IN NUMBER ,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
551: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
552: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
553:
554: x_return_status OUT NOCOPY VARCHAR2 ,

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

547:
548: PROCEDURE update_parameters
549: ( p_api_version IN NUMBER ,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
551: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
552: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
553:
554: x_return_status OUT NOCOPY VARCHAR2 ,
555: x_msg_count OUT NOCOPY NUMBER ,

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

548: PROCEDURE update_parameters
549: ( p_api_version IN NUMBER ,
550: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
551: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
552: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
553:
554: x_return_status OUT NOCOPY VARCHAR2 ,
555: x_msg_count OUT NOCOPY NUMBER ,
556: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 595: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

591: -- Standard Start of API savepoint
592: SAVEPOINT UPDATE_PARAMETERS;
593: -- Standard call to check for call compatibility.
594:
595: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
596: p_api_version ,
597: l_api_name ,
598: G_PKG_NAME )
599: THEN

Line 600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

596: p_api_version ,
597: l_api_name ,
598: G_PKG_NAME )
599: THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: END IF;
602: -- Initialize message list if p_init_msg_list is set to TRUE.
603: IF FND_API.to_Boolean( p_init_msg_list ) THEN
604: FND_MSG_PUB.initialize;

Line 603: IF FND_API.to_Boolean( p_init_msg_list ) THEN

599: THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: END IF;
602: -- Initialize message list if p_init_msg_list is set to TRUE.
603: IF FND_API.to_Boolean( p_init_msg_list ) THEN
604: FND_MSG_PUB.initialize;
605: END IF;
606: -- Initialize API return status to success
607: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 607: x_return_status := FND_API.G_RET_STS_SUCCESS;

603: IF FND_API.to_Boolean( p_init_msg_list ) THEN
604: FND_MSG_PUB.initialize;
605: END IF;
606: -- Initialize API return status to success
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608: -- API body
609:
610: -- verify that all "not null" params are provided
611: if (P_DEF_MAINT_COST_CATEGORY is null

Line 617: RAISE FND_API.G_EXC_ERROR;

613: or P_DEFAULT_EAM_CLASS is null)
614: then
615: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAMS');
616: fnd_msg_pub.add;
617: RAISE FND_API.G_EXC_ERROR;
618: end if;
619:
620: --ver eam enabled
621: validate_org_eam_enabled(p_organization_id);

Line 627: RAISE FND_API.G_EXC_ERROR;

623: if not validate_mfg_lookups('BOM_EAM_COST_CATEGORY', P_DEF_MAINT_COST_CATEGORY)
624: then
625: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_COST_CAT');
626: fnd_msg_pub.add;
627: RAISE FND_API.G_EXC_ERROR;
628: end if;
629:
630: if not validate_cost_element_id(P_DEF_EAM_COST_ELEMENT_ID )
631: then

Line 634: RAISE FND_API.G_EXC_ERROR;

630: if not validate_cost_element_id(P_DEF_EAM_COST_ELEMENT_ID )
631: then
632: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CST_ELMNT_ID');
633: fnd_msg_pub.add;
634: RAISE FND_API.G_EXC_ERROR;
635: end if;
636: if not validate_acnt_class(P_DEFAULT_EAM_CLASS , P_ORGANIZATION_ID )
637: then
638: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');

Line 640: RAISE FND_API.G_EXC_ERROR;

636: if not validate_acnt_class(P_DEFAULT_EAM_CLASS , P_ORGANIZATION_ID )
637: then
638: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
639: fnd_msg_pub.add;
640: RAISE FND_API.G_EXC_ERROR;
641: end if;
642:
643: if not validate_chart_of_accounts(P_MAINTENANCE_OFFSET_ACCOUNT ,P_ORGANIZATION_ID )
644: then

Line 647: RAISE FND_API.G_EXC_ERROR;

643: if not validate_chart_of_accounts(P_MAINTENANCE_OFFSET_ACCOUNT ,P_ORGANIZATION_ID )
644: then
645: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CHART_ACNT');
646: fnd_msg_pub.add;
647: RAISE FND_API.G_EXC_ERROR;
648: end if;
649:
650: -- validate default dept id
651: if (p_default_department_id is not null and not eam_common_utilities_pvt.validate_department_id(p_default_department_id, p_organization_id)) then

Line 654: RAISE FND_API.G_EXC_ERROR;

650: -- validate default dept id
651: if (p_default_department_id is not null and not eam_common_utilities_pvt.validate_department_id(p_default_department_id, p_organization_id)) then
652: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_DEPT_ID');
653: fnd_msg_pub.add;
654: RAISE FND_API.G_EXC_ERROR;
655: end if;
656:
657: --varifyflag values 'Y' or 'N'
658: --WorkRequestAutoApprove

Line 721: IF FND_API.To_Boolean( p_commit ) THEN

717: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
718:
719: -- End of API body.
720: -- Standard check of p_commit.
721: IF FND_API.To_Boolean( p_commit ) THEN
722: COMMIT WORK;
723: END IF;
724: -- Standard call to get message count and if count is 1, get message info.
725: FND_MSG_PUB.get

Line 730: WHEN FND_API.G_EXC_ERROR THEN

726: ( p_msg_index_out => x_msg_count ,
727: p_data => x_msg_data
728: );
729: EXCEPTION
730: WHEN FND_API.G_EXC_ERROR THEN
731: ROLLBACK TO UPDATE_PARAMETERS;
732: x_return_status := FND_API.G_RET_STS_ERROR ;
733: FND_MSG_PUB.get
734: ( p_msg_index_out => x_msg_count ,

Line 732: x_return_status := FND_API.G_RET_STS_ERROR ;

728: );
729: EXCEPTION
730: WHEN FND_API.G_EXC_ERROR THEN
731: ROLLBACK TO UPDATE_PARAMETERS;
732: x_return_status := FND_API.G_RET_STS_ERROR ;
733: FND_MSG_PUB.get
734: ( p_msg_index_out => x_msg_count ,
735: p_data => x_msg_data
736: );

Line 737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

733: FND_MSG_PUB.get
734: ( p_msg_index_out => x_msg_count ,
735: p_data => x_msg_data
736: );
737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
738: ROLLBACK TO UPDATE_PARAMETERS;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: FND_MSG_PUB.get
741: ( p_msg_index_out => x_msg_count ,

Line 739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

735: p_data => x_msg_data
736: );
737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
738: ROLLBACK TO UPDATE_PARAMETERS;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: FND_MSG_PUB.get
741: ( p_msg_index_out => x_msg_count ,
742: p_data => x_msg_data
743: );

Line 746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

742: p_data => x_msg_data
743: );
744: WHEN OTHERS THEN
745: ROLLBACK TO UPDATE_PARAMETERS;
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
747: IF FND_MSG_PUB.Check_Msg_Level
748: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
749: THEN
750: FND_MSG_PUB.Add_Exc_Msg