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 326: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 334: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 338: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 348: RAISE FND_API.G_EXC_ERROR;

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

Line 359: RAISE FND_API.G_EXC_ERROR;

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

Line 367: RAISE FND_API.G_EXC_ERROR;

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

Line 375: RAISE FND_API.G_EXC_ERROR;

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

Line 383: RAISE FND_API.G_EXC_ERROR;

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

Line 390: RAISE FND_API.G_EXC_ERROR;

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

Line 397: RAISE FND_API.G_EXC_ERROR;

393: if not validate_chart_of_accounts(P_MAINTENANCE_OFFSET_ACCOUNT ,P_ORGANIZATION_ID )
394: then
395: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CHART_ACNT');
396: fnd_msg_pub.add;
397: RAISE FND_API.G_EXC_ERROR;
398: end if;
399:
400: -- validate default dept id
401: 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 404: RAISE FND_API.G_EXC_ERROR;

400: -- validate default dept id
401: 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
402: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_DEPT_ID');
403: fnd_msg_pub.add;
404: RAISE FND_API.G_EXC_ERROR;
405: end if;
406:
407: --varifyflag values 'Y' or 'N'
408: --WorkRequestAutoApprove

Line 510: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 519: WHEN FND_API.G_EXC_ERROR THEN

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

Line 521: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

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

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

Line 599: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 607: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 611: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 621: RAISE FND_API.G_EXC_ERROR;

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

Line 631: RAISE FND_API.G_EXC_ERROR;

627: if not validate_mfg_lookups('BOM_EAM_COST_CATEGORY', P_DEF_MAINT_COST_CATEGORY)
628: then
629: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_COST_CAT');
630: fnd_msg_pub.add;
631: RAISE FND_API.G_EXC_ERROR;
632: end if;
633:
634: if not validate_cost_element_id(P_DEF_EAM_COST_ELEMENT_ID )
635: then

Line 638: RAISE FND_API.G_EXC_ERROR;

634: if not validate_cost_element_id(P_DEF_EAM_COST_ELEMENT_ID )
635: then
636: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CST_ELMNT_ID');
637: fnd_msg_pub.add;
638: RAISE FND_API.G_EXC_ERROR;
639: end if;
640: if not validate_acnt_class(P_DEFAULT_EAM_CLASS , P_ORGANIZATION_ID )
641: then
642: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');

Line 644: RAISE FND_API.G_EXC_ERROR;

640: if not validate_acnt_class(P_DEFAULT_EAM_CLASS , P_ORGANIZATION_ID )
641: then
642: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CLASS_CODE');
643: fnd_msg_pub.add;
644: RAISE FND_API.G_EXC_ERROR;
645: end if;
646:
647: if not validate_chart_of_accounts(P_MAINTENANCE_OFFSET_ACCOUNT ,P_ORGANIZATION_ID )
648: then

Line 651: RAISE FND_API.G_EXC_ERROR;

647: if not validate_chart_of_accounts(P_MAINTENANCE_OFFSET_ACCOUNT ,P_ORGANIZATION_ID )
648: then
649: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_CHART_ACNT');
650: fnd_msg_pub.add;
651: RAISE FND_API.G_EXC_ERROR;
652: end if;
653:
654: -- validate default dept id
655: 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 658: RAISE FND_API.G_EXC_ERROR;

654: -- validate default dept id
655: 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
656: fnd_message.set_name('EAM', 'EAM_PAR_INVALID_DEPT_ID');
657: fnd_msg_pub.add;
658: RAISE FND_API.G_EXC_ERROR;
659: end if;
660:
661: --varifyflag values 'Y' or 'N'
662: --WorkRequestAutoApprove

Line 726: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 735: WHEN FND_API.G_EXC_ERROR THEN

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

Line 737: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

740: p_data => x_msg_data
741: );
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO UPDATE_PARAMETERS;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
745: FND_MSG_PUB.get
746: ( p_msg_index_out => x_msg_count ,
747: p_data => x_msg_data
748: );

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

747: p_data => x_msg_data
748: );
749: WHEN OTHERS THEN
750: ROLLBACK TO UPDATE_PARAMETERS;
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752: IF FND_MSG_PUB.Check_Msg_Level
753: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
754: THEN
755: FND_MSG_PUB.Add_Exc_Msg