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_COMMON_UTILITIES_PVT dependencies on STANDARD

Line 69: -- Standard Start of API savepoint

65: FROM mtl_parameters MP
66: WHERE mp.organization_id = p_org_id ;
67:
68: BEGIN
69: -- Standard Start of API savepoint
70: l_stmt_num := 10;
71: SAVEPOINT get_org_code_pvt;
72:
73: l_stmt_num := 20;

Line 74: -- Standard call to check for call compatibility.

70: l_stmt_num := 10;
71: SAVEPOINT get_org_code_pvt;
72:
73: l_stmt_num := 20;
74: -- Standard call to check for call compatibility.
75: IF NOT fnd_api.compatible_api_call(
76: l_api_version
77: ,p_api_version
78: ,l_api_name

Line 125: -- Standard check of p_commit.

121: x_organization_code := l_organization_code;
122:
123: l_stmt_num := 998;
124: -- End of API body.
125: -- Standard check of p_commit.
126: IF fnd_api.to_boolean(p_commit) THEN
127: COMMIT WORK;
128: END IF;
129:

Line 131: -- Standard call to get message count and if count is 1, get message info.

127: COMMIT WORK;
128: END IF;
129:
130: l_stmt_num := 999;
131: -- Standard call to get message count and if count is 1, get message info.
132: fnd_msg_pub.count_and_get(
133: p_count => x_msg_count
134: ,p_data => x_msg_data);
135: EXCEPTION

Line 183: -- Standard Start of API savepoint

179: l_concatenated_segments VARCHAR2(800);
180: l_inventory_item_id NUMBER;
181: l_stmt_num NUMBER;
182: BEGIN
183: -- Standard Start of API savepoint
184: l_stmt_num := 10;
185: SAVEPOINT get_item_id_pvt;
186:
187: l_stmt_num := 20;

Line 188: -- Standard call to check for call compatibility.

184: l_stmt_num := 10;
185: SAVEPOINT get_item_id_pvt;
186:
187: l_stmt_num := 20;
188: -- Standard call to check for call compatibility.
189: IF NOT fnd_api.compatible_api_call(
190: l_api_version
191: ,p_api_version
192: ,l_api_name

Line 239: -- Standard check of p_commit.

235: x_inventory_item_id := l_inventory_item_id;
236:
237: l_stmt_num := 998;
238: -- End of API body.
239: -- Standard check of p_commit.
240: IF fnd_api.to_boolean(p_commit) THEN
241: COMMIT WORK;
242: END IF;
243:

Line 245: -- Standard call to get message count and if count is 1, get message info.

241: COMMIT WORK;
242: END IF;
243:
244: l_stmt_num := 999;
245: -- Standard call to get message count and if count is 1, get message info.
246: fnd_msg_pub.count_and_get(
247: p_count => x_msg_count
248: ,p_data => x_msg_data);
249: EXCEPTION

Line 303: -- Standard Start of API savepoint

299: l_stmt_num NUMBER;
300: l_period_set_name VARCHAR2(30);
301:
302: BEGIN
303: -- Standard Start of API savepoint
304: l_stmt_num := 10;
305: SAVEPOINT get_current_period_pvt;
306:
307: l_stmt_num := 20;

Line 308: -- Standard call to check for call compatibility.

304: l_stmt_num := 10;
305: SAVEPOINT get_current_period_pvt;
306:
307: l_stmt_num := 20;
308: -- Standard call to check for call compatibility.
309: IF NOT fnd_api.compatible_api_call(
310: l_api_version
311: ,p_api_version
312: ,l_api_name

Line 359: -- Standard check of p_commit.

355: x_period_name := l_period_name;
356:
357: l_stmt_num := 998;
358: -- End of API body.
359: -- Standard check of p_commit.
360: IF fnd_api.to_boolean(p_commit) THEN
361: COMMIT WORK;
362: END IF;
363:

Line 365: -- Standard call to get message count and if count is 1, get message info.

361: COMMIT WORK;
362: END IF;
363:
364: l_stmt_num := 999;
365: -- Standard call to get message count and if count is 1, get message info.
366: fnd_msg_pub.count_and_get(
367: p_count => x_msg_count
368: ,p_data => x_msg_data);
369: EXCEPTION

Line 420: -- Standard Start of API savepoint

416: l_organization_id NUMBER;
417: l_currency VARCHAR2(30);
418: l_stmt_num NUMBER;
419: BEGIN
420: -- Standard Start of API savepoint
421: l_stmt_num := 10;
422: SAVEPOINT get_currency_pvt;
423:
424: l_stmt_num := 20;

Line 425: -- Standard call to check for call compatibility.

421: l_stmt_num := 10;
422: SAVEPOINT get_currency_pvt;
423:
424: l_stmt_num := 20;
425: -- Standard call to check for call compatibility.
426: IF NOT fnd_api.compatible_api_call(
427: l_api_version
428: ,p_api_version
429: ,l_api_name

Line 468: -- Standard check of p_commit.

464: x_currency := l_currency;
465:
466: l_stmt_num := 998;
467: -- End of API body.
468: -- Standard check of p_commit.
469: IF fnd_api.to_boolean(p_commit) THEN
470: COMMIT WORK;
471: END IF;
472:

Line 474: -- Standard call to get message count and if count is 1, get message info.

470: COMMIT WORK;
471: END IF;
472:
473: l_stmt_num := 999;
474: -- Standard call to get message count and if count is 1, get message info.
475: fnd_msg_pub.count_and_get(
476: p_count => x_msg_count
477: ,p_data => x_msg_data);
478: EXCEPTION

Line 538: -- Standard Start of API savepoint

534: l_success VARCHAR2(1);
535: l_base_item_id NUMBER;
536:
537: BEGIN
538: -- Standard Start of API savepoint
539: l_stmt_num := 10;
540: SAVEPOINT get_next_asset_number_pvt;
541:
542: l_stmt_num := 20;

Line 543: -- Standard call to check for call compatibility.

539: l_stmt_num := 10;
540: SAVEPOINT get_next_asset_number_pvt;
541:
542: l_stmt_num := 20;
543: -- Standard call to check for call compatibility.
544: IF NOT fnd_api.compatible_api_call(
545: l_api_version
546: ,p_api_version
547: ,l_api_name

Line 874: -- Standard check of p_commit.

870:
871:
872: l_stmt_num := 998;
873: -- End of API body.
874: -- Standard check of p_commit.
875: IF fnd_api.to_boolean(p_commit) THEN
876: COMMIT WORK;
877: END IF;
878:

Line 880: -- Standard call to get message count and if count is 1, get message info.

876: COMMIT WORK;
877: END IF;
878:
879: l_stmt_num := 999;
880: -- Standard call to get message count and if count is 1, get message info.
881: fnd_msg_pub.count_and_get(
882: p_encoded => fnd_api.g_false
883: ,p_count => x_msg_count
884: ,p_data => x_msg_data);

Line 1587: -- Standard Start of API savepoint

1583: l_current_date VARCHAR2(100);
1584: l_current_time VARCHAR2(100);
1585: l_maint_supervisor_mode NUMBER;
1586: BEGIN
1587: -- Standard Start of API savepoint
1588: l_stmt_num := 10;
1589: SAVEPOINT get_work_order_count_pvt;
1590:
1591: l_stmt_num := 20;

Line 1592: -- Standard call to check for call compatibility.

1588: l_stmt_num := 10;
1589: SAVEPOINT get_work_order_count_pvt;
1590:
1591: l_stmt_num := 20;
1592: -- Standard call to check for call compatibility.
1593: IF NOT fnd_api.compatible_api_call(
1594: l_api_version
1595: ,p_api_version
1596: ,l_api_name

Line 2032: -- Standard check of p_commit.

2028: x_current_time := l_current_time;
2029:
2030: l_stmt_num := 998;
2031: -- End of API body.
2032: -- Standard check of p_commit.
2033: IF fnd_api.to_boolean(p_commit) THEN
2034: COMMIT WORK;
2035: END IF;
2036:

Line 2038: -- Standard call to get message count and if count is 1, get message info.

2034: COMMIT WORK;
2035: END IF;
2036:
2037: l_stmt_num := 999;
2038: -- Standard call to get message count and if count is 1, get message info.
2039: fnd_msg_pub.count_and_get(
2040: p_encoded => fnd_api.g_false
2041: ,p_count => x_msg_count
2042: ,p_data => x_msg_data);

Line 2155: -- Standard Start of API savepoint

2151: l_output_dir VARCHAR2(512);
2152:
2153: BEGIN
2154:
2155: -- Standard Start of API savepoint
2156: l_stmt_num := 10;
2157: SAVEPOINT insert_into_wori_pvt;
2158:
2159: l_stmt_num := 20;

Line 2160: -- Standard call to check for call compatibility.

2156: l_stmt_num := 10;
2157: SAVEPOINT insert_into_wori_pvt;
2158:
2159: l_stmt_num := 20;
2160: -- Standard call to check for call compatibility.
2161: IF NOT fnd_api.compatible_api_call(
2162: l_api_version
2163: ,p_api_version
2164: ,l_api_name

Line 2270: -- Standard check of p_commit.

2266:
2267:
2268:
2269: -- End of API body.
2270: -- Standard check of p_commit.
2271: IF fnd_api.to_boolean(p_commit) THEN
2272: COMMIT WORK;
2273: END IF;
2274:

Line 2276: -- Standard call to get message count and if count is 1, get message info.

2272: COMMIT WORK;
2273: END IF;
2274:
2275: l_stmt_num := 999;
2276: -- Standard call to get message count and if count is 1, get message info.
2277: fnd_msg_pub.count_and_get(
2278: p_encoded => fnd_api.g_false
2279: ,p_count => x_msg_count
2280: ,p_data => x_msg_data);

Line 2401: -- Standard Start of API savepoint

2397: l_instance_id NUMBER;
2398: l_gen_object_id NUMBER;
2399: BEGIN
2400:
2401: -- Standard Start of API savepoint
2402: l_stmt_num := 10;
2403: SAVEPOINT asset_util_pvt;
2404:
2405: l_stmt_num := 20;

Line 2406: -- Standard call to check for call compatibility.

2402: l_stmt_num := 10;
2403: SAVEPOINT asset_util_pvt;
2404:
2405: l_stmt_num := 20;
2406: -- Standard call to check for call compatibility.
2407: IF NOT fnd_api.compatible_api_call(
2408: l_api_version
2409: ,p_api_version
2410: ,l_api_name

Line 2839: -- Standard Start of API savepoint

2835: l_organization_id number;
2836: l_description mtl_serial_numbers.descriptive_text%TYPE;
2837: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
2838: begin
2839: -- Standard Start of API savepoint
2840: SAVEPOINT create_asset;
2841:
2842: -- Standard call to check for call compatibility.
2843: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 2842: -- Standard call to check for call compatibility.

2838: begin
2839: -- Standard Start of API savepoint
2840: SAVEPOINT create_asset;
2841:
2842: -- Standard call to check for call compatibility.
2843: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2844: RAISE fnd_api.g_exc_unexpected_error;
2845: END IF;
2846:

Line 2955: -- Standard check of p_commit.

2951:
2952: x_eam_wo_rec := l_eam_wo_rec;
2953:
2954: -- End of API body.
2955: -- Standard check of p_commit.
2956: IF fnd_api.to_boolean(p_commit) THEN
2957: COMMIT WORK;
2958: END IF;
2959:

Line 2960: -- Standard call to get message count and if count is 1, get message info.

2956: IF fnd_api.to_boolean(p_commit) THEN
2957: COMMIT WORK;
2958: END IF;
2959:
2960: -- Standard call to get message count and if count is 1, get message info.
2961: fnd_msg_pub.count_and_get(
2962: p_count => x_msg_count
2963: ,p_data => x_msg_data);
2964:

Line 3191: -- Standard Start of API savepoint

3187: l_msg_data varchar2(20000);
3188:
3189:
3190: begin
3191: -- Standard Start of API savepoint
3192: SAVEPOINT write_woru;
3193:
3194: -- Initialize API return status to success
3195: l_stmt_num := 10;

Line 3344: -- Standard Start of API savepoint

3340: and woru.resource_seq_num = p_resource_seq_num
3341: and woru.organization_id = p_organization_id;
3342:
3343: begin
3344: -- Standard Start of API savepoint
3345: SAVEPOINT adjust_woru;
3346:
3347: -- Standard call to check for call compatibility.
3348: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 3347: -- Standard call to check for call compatibility.

3343: begin
3344: -- Standard Start of API savepoint
3345: SAVEPOINT adjust_woru;
3346:
3347: -- Standard call to check for call compatibility.
3348: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3349: RAISE fnd_api.g_exc_unexpected_error;
3350: END IF;
3351:

Line 3552: -- Standard check of p_commit.

3548: end if;
3549:
3550:
3551: -- End of API body.
3552: -- Standard check of p_commit.
3553: IF fnd_api.to_boolean(p_commit) THEN
3554: COMMIT WORK;
3555: END IF;
3556:

Line 3557: -- Standard call to get message count and if count is 1, get message info.

3553: IF fnd_api.to_boolean(p_commit) THEN
3554: COMMIT WORK;
3555: END IF;
3556:
3557: -- Standard call to get message count and if count is 1, get message info.
3558: fnd_msg_pub.count_and_get(
3559: p_count => x_msg_count
3560: ,p_data => x_msg_data);
3561: