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_LINEAR_LOCATIONS_PUB dependencies on EAM_LINEAR_LOCATIONS_PUB

Line 1: PACKAGE BODY eam_linear_locations_pub AS

1: PACKAGE BODY eam_linear_locations_pub AS
2: /* $Header: EAMPELLB.pls 120.4 2006/02/24 15:18:31 sraval noship $*/
3: -- Start of comments
4: -- API name : eam_linear_locations_pub
5: -- Type : Public.

Line 4: -- API name : eam_linear_locations_pub

1: PACKAGE BODY eam_linear_locations_pub AS
2: /* $Header: EAMPELLB.pls 120.4 2006/02/24 15:18:31 sraval noship $*/
3: -- Start of comments
4: -- API name : eam_linear_locations_pub
5: -- Type : Public.
6: -- Function :
7: -- Pre-reqs : None.
8: -- Parameters :

Line 38: g_pkg_name CONSTANT VARCHAR2(30):= 'eam_linear_locations_pub';

34: -- Notes : Note text
35: --
36: -- End of comments
37:
38: g_pkg_name CONSTANT VARCHAR2(30):= 'eam_linear_locations_pub';
39:
40: function return_user_id(p_user_name in varchar2) return number
41: is
42: l_user_id number;

Line 121: SAVEPOINT eam_linear_locations_pub;

117: l_count NUMBER := 0;
118:
119: BEGIN
120: -- Standard Start of API savepoint
121: SAVEPOINT eam_linear_locations_pub;
122:
123: -- Standard call to check for call compatibility.
124: IF NOT fnd_api.compatible_api_call(
125: l_api_version

Line 202: ROLLBACK TO eam_linear_locations_pub;

198: fnd_msg_pub.count_and_get(p_count => x_msg_count
199: ,p_data => x_msg_data);
200: EXCEPTION
201: WHEN fnd_api.g_exc_error THEN
202: ROLLBACK TO eam_linear_locations_pub;
203: x_return_status := fnd_api.g_ret_sts_error;
204: fnd_msg_pub.count_and_get(p_count => x_msg_count
205: ,p_data => x_msg_data);
206: WHEN fnd_api.g_exc_unexpected_error THEN

Line 207: ROLLBACK TO eam_linear_locations_pub;

203: x_return_status := fnd_api.g_ret_sts_error;
204: fnd_msg_pub.count_and_get(p_count => x_msg_count
205: ,p_data => x_msg_data);
206: WHEN fnd_api.g_exc_unexpected_error THEN
207: ROLLBACK TO eam_linear_locations_pub;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: fnd_msg_pub.count_and_get(p_count => x_msg_count
210: ,p_data => x_msg_data);
211: WHEN OTHERS THEN

Line 212: ROLLBACK TO eam_linear_locations_pub;

208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: fnd_msg_pub.count_and_get(p_count => x_msg_count
210: ,p_data => x_msg_data);
211: WHEN OTHERS THEN
212: ROLLBACK TO eam_linear_locations_pub;
213: x_return_status := fnd_api.g_ret_sts_unexp_error;
214: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
215: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
216: END IF;

Line 245: SAVEPOINT eam_linear_locations_pub;

241: l_count NUMBER := 0;
242:
243: BEGIN
244: -- Standard Start of API savepoint
245: SAVEPOINT eam_linear_locations_pub;
246:
247: -- Standard call to check for call compatibility.
248: IF NOT fnd_api.compatible_api_call(
249: l_api_version

Line 330: ROLLBACK TO eam_linear_locations_pub;

326: fnd_msg_pub.count_and_get(p_count => x_msg_count
327: ,p_data => x_msg_data);
328: EXCEPTION
329: WHEN fnd_api.g_exc_error THEN
330: ROLLBACK TO eam_linear_locations_pub;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_count => x_msg_count
333: ,p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN

Line 335: ROLLBACK TO eam_linear_locations_pub;

331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_count => x_msg_count
333: ,p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error THEN
335: ROLLBACK TO eam_linear_locations_pub;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get(p_count => x_msg_count
338: ,p_data => x_msg_data);
339: WHEN OTHERS THEN

Line 340: ROLLBACK TO eam_linear_locations_pub;

336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337: fnd_msg_pub.count_and_get(p_count => x_msg_count
338: ,p_data => x_msg_data);
339: WHEN OTHERS THEN
340: ROLLBACK TO eam_linear_locations_pub;
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
343: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
344: END IF;

Line 371: SAVEPOINT eam_linear_locations_pub;

367: l_count NUMBER := 0;
368:
369: BEGIN
370: -- Standard Start of API savepoint
371: SAVEPOINT eam_linear_locations_pub;
372:
373: -- Standard call to check for call compatibility.
374: IF NOT fnd_api.compatible_api_call(
375: l_api_version

Line 423: ROLLBACK TO eam_linear_locations_pub;

419: fnd_msg_pub.count_and_get(p_count => x_msg_count
420: ,p_data => x_msg_data);
421: EXCEPTION
422: WHEN fnd_api.g_exc_error THEN
423: ROLLBACK TO eam_linear_locations_pub;
424: x_return_status := fnd_api.g_ret_sts_error;
425: fnd_msg_pub.count_and_get(p_count => x_msg_count
426: ,p_data => x_msg_data);
427: WHEN fnd_api.g_exc_unexpected_error THEN

Line 428: ROLLBACK TO eam_linear_locations_pub;

424: x_return_status := fnd_api.g_ret_sts_error;
425: fnd_msg_pub.count_and_get(p_count => x_msg_count
426: ,p_data => x_msg_data);
427: WHEN fnd_api.g_exc_unexpected_error THEN
428: ROLLBACK TO eam_linear_locations_pub;
429: x_return_status := fnd_api.g_ret_sts_unexp_error;
430: fnd_msg_pub.count_and_get(p_count => x_msg_count
431: ,p_data => x_msg_data);
432: WHEN OTHERS THEN

Line 433: ROLLBACK TO eam_linear_locations_pub;

429: x_return_status := fnd_api.g_ret_sts_unexp_error;
430: fnd_msg_pub.count_and_get(p_count => x_msg_count
431: ,p_data => x_msg_data);
432: WHEN OTHERS THEN
433: ROLLBACK TO eam_linear_locations_pub;
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
436: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
437: END IF;

Line 479: SAVEPOINT eam_linear_locations_pub;

475: l_resp_appl_id number := 426;
476:
477: BEGIN
478: -- Standard Start of API savepoint
479: SAVEPOINT eam_linear_locations_pub;
480:
481:
482: -- validate and set the user context
483: l_user_id := return_user_id(p_user_name);

Line 516: eam_linear_locations_pub.get_eam_linear_id(

512: x_return_status := fnd_api.g_ret_sts_success;
513:
514: -- API body
515: --first check if asset already exists in EAM
516: eam_linear_locations_pub.get_eam_linear_id(
517: p_api_version => p_api_version
518: ,p_init_msg_list => p_init_msg_list
519: ,p_validation_level => p_validation_level
520: ,p_external_linear_id => p_external_linear_id

Line 531: eam_linear_locations_pub.insert_row(

527: );
528:
529: -- if asset does not exist in ELL, then insert row and get EAM linear id
530: if (l_x_eam_linear_id = -1) then
531: eam_linear_locations_pub.insert_row(
532: p_api_version => p_api_version
533: ,p_init_msg_list => p_init_msg_list
534: ,p_commit => p_commit
535: ,p_validation_level => p_validation_level

Line 584: ROLLBACK TO eam_linear_locations_pub;

580: fnd_msg_pub.count_and_get(p_count => x_msg_count
581: ,p_data => x_msg_data);
582: EXCEPTION
583: WHEN fnd_api.g_exc_error THEN
584: ROLLBACK TO eam_linear_locations_pub;
585: x_return_status := fnd_api.g_ret_sts_error;
586: fnd_msg_pub.count_and_get(p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN fnd_api.g_exc_unexpected_error THEN

Line 589: ROLLBACK TO eam_linear_locations_pub;

585: x_return_status := fnd_api.g_ret_sts_error;
586: fnd_msg_pub.count_and_get(p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN fnd_api.g_exc_unexpected_error THEN
589: ROLLBACK TO eam_linear_locations_pub;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: fnd_msg_pub.count_and_get(p_count => x_msg_count
592: ,p_data => x_msg_data);
593: WHEN OTHERS THEN

Line 594: ROLLBACK TO eam_linear_locations_pub;

590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: fnd_msg_pub.count_and_get(p_count => x_msg_count
592: ,p_data => x_msg_data);
593: WHEN OTHERS THEN
594: ROLLBACK TO eam_linear_locations_pub;
595: x_return_status := fnd_api.g_ret_sts_unexp_error;
596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
597: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
598: END IF;

Line 640: SAVEPOINT eam_linear_locations_pub;

636: l_resp_appl_id number := 426;
637:
638: BEGIN
639: -- Standard Start of API savepoint
640: SAVEPOINT eam_linear_locations_pub;
641:
642:
643: -- validate and set the user context
644: l_user_id := return_user_id(p_user_name);

Line 677: eam_linear_locations_pub.get_eam_linear_id(

673: x_return_status := fnd_api.g_ret_sts_success;
674:
675: -- API body
676:
677: eam_linear_locations_pub.get_eam_linear_id(
678: p_api_version => p_api_version
679: ,p_init_msg_list => p_init_msg_list
680: ,p_validation_level => p_validation_level
681: ,p_external_linear_id => p_external_linear_id

Line 692: eam_linear_locations_pub.insert_row(

688: );
689:
690: -- if asset does not exist in ELL, then insert row and get EAM linear id
691: if (l_x_eam_linear_id = -1) then
692: eam_linear_locations_pub.insert_row(
693: p_api_version => p_api_version
694: ,p_init_msg_list => p_init_msg_list
695: ,p_commit => p_commit
696: ,p_validation_level => p_validation_level

Line 735: ROLLBACK TO eam_linear_locations_pub;

731: fnd_msg_pub.count_and_get(p_count => x_msg_count
732: ,p_data => x_msg_data);
733: EXCEPTION
734: WHEN fnd_api.g_exc_error THEN
735: ROLLBACK TO eam_linear_locations_pub;
736: x_return_status := fnd_api.g_ret_sts_error;
737: fnd_msg_pub.count_and_get(p_count => x_msg_count
738: ,p_data => x_msg_data);
739: WHEN fnd_api.g_exc_unexpected_error THEN

Line 740: ROLLBACK TO eam_linear_locations_pub;

736: x_return_status := fnd_api.g_ret_sts_error;
737: fnd_msg_pub.count_and_get(p_count => x_msg_count
738: ,p_data => x_msg_data);
739: WHEN fnd_api.g_exc_unexpected_error THEN
740: ROLLBACK TO eam_linear_locations_pub;
741: x_return_status := fnd_api.g_ret_sts_unexp_error;
742: fnd_msg_pub.count_and_get(p_count => x_msg_count
743: ,p_data => x_msg_data);
744: WHEN OTHERS THEN

Line 745: ROLLBACK TO eam_linear_locations_pub;

741: x_return_status := fnd_api.g_ret_sts_unexp_error;
742: fnd_msg_pub.count_and_get(p_count => x_msg_count
743: ,p_data => x_msg_data);
744: WHEN OTHERS THEN
745: ROLLBACK TO eam_linear_locations_pub;
746: x_return_status := fnd_api.g_ret_sts_unexp_error;
747: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
748: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
749: END IF;

Line 819: l_full_name CONSTANT VARCHAR2(60) := 'eam_linear_locations_pub' || '.' || l_api_name;

815: IS
816:
817: l_api_name CONSTANT VARCHAR2(30) := 'create_eam_wo';
818: l_api_version CONSTANT NUMBER := 1.0;
819: l_full_name CONSTANT VARCHAR2(60) := 'eam_linear_locations_pub' || '.' || l_api_name;
820: l_count NUMBER := 0;
821: l_message VARCHAR2(2000);
822: l_x_return_status varchar2(30);
823: l_x_msg_count number;

Line 950: eam_linear_locations_pub.get_eam_linear_id(

946: l_debug_filename := p_debug_filename;
947: l_debug_file_mode := p_debug_file_mode;
948:
949:
950: eam_linear_locations_pub.get_eam_linear_id(
951: p_api_version => p_api_version
952: ,p_init_msg_list => p_init_msg_list
953: ,p_validation_level => p_validation_level
954: ,p_external_linear_id => p_external_linear_id

Line 965: eam_linear_locations_pub.insert_row(

961: );
962:
963: -- if asset does not exist in ELL, then insert row and get EAM linear id
964: if (l_x_eam_linear_id = -1) then
965: eam_linear_locations_pub.insert_row(
966: p_api_version => p_api_version
967: ,p_init_msg_list => p_init_msg_list
968: ,p_commit => p_commit
969: ,p_validation_level => p_validation_level

Line 1121: ,x_bom_departments_table out nocopy eam_linear_locations_pub.bom_departments_table

1117:
1118: procedure return_bom_departments
1119: ( p_organization_id in number
1120: ,p_user_name in VARCHAR2
1121: ,x_bom_departments_table out nocopy eam_linear_locations_pub.bom_departments_table
1122: ) is
1123: l_user_id number;
1124: l_resp_id number;
1125: l_resp_appl_id number;

Line 1163: ,x_organizations_table OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.Org_Access_Table

1159:
1160: Procedure return_organizations
1161: (
1162: p_user_name VARCHAR2
1163: ,x_organizations_table OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.Org_Access_Table
1164: )
1165: is
1166: l_user_id number;
1167: l_organizations_index binary_integer;

Line 1205: , x_work_request_table OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.Work_Request_Table

1201: Procedure return_work_request_details
1202: (
1203: p_user_name VARCHAR2
1204: , p_work_request_id number
1205: , x_work_request_table OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.Work_Request_Table
1206: )
1207:
1208: is
1209: l_user_id number;

Line 1290: , x_work_order_rec OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.Work_Order_Record

1286: Procedure return_work_order_details
1287: (
1288: p_user_name VARCHAR2
1289: , p_wip_entity_id number
1290: , x_work_order_rec OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.Work_Order_Record
1291: )
1292:
1293: IS
1294:

Line 1479: END eam_linear_locations_pub;

1475:
1476:
1477:
1478:
1479: END eam_linear_locations_pub;