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 1588: -- Standard Start of API savepoint

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

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

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

Line 2033: -- Standard check of p_commit.

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

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

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

Line 2156: -- Standard Start of API savepoint

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

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

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

Line 2271: -- Standard check of p_commit.

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

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

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

Line 2402: -- Standard Start of API savepoint

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

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

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

Line 2958: -- Standard Start of API savepoint

2954: l_organization_id number;
2955: l_description mtl_serial_numbers.descriptive_text%TYPE;
2956: l_eam_wo_rec EAM_PROCESS_WO_PUB.eam_wo_rec_type;
2957: begin
2958: -- Standard Start of API savepoint
2959: SAVEPOINT create_asset;
2960:
2961: -- Standard call to check for call compatibility.
2962: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

2957: begin
2958: -- Standard Start of API savepoint
2959: SAVEPOINT create_asset;
2960:
2961: -- Standard call to check for call compatibility.
2962: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2963: RAISE fnd_api.g_exc_unexpected_error;
2964: END IF;
2965:

Line 3074: -- Standard check of p_commit.

3070:
3071: x_eam_wo_rec := l_eam_wo_rec;
3072:
3073: -- End of API body.
3074: -- Standard check of p_commit.
3075: IF fnd_api.to_boolean(p_commit) THEN
3076: COMMIT WORK;
3077: END IF;
3078:

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

3075: IF fnd_api.to_boolean(p_commit) THEN
3076: COMMIT WORK;
3077: END IF;
3078:
3079: -- Standard call to get message count and if count is 1, get message info.
3080: fnd_msg_pub.count_and_get(
3081: p_count => x_msg_count
3082: ,p_data => x_msg_data);
3083:

Line 3335: -- Standard Start of API savepoint

3331: l_msg_data varchar2(20000);
3332:
3333:
3334: begin
3335: -- Standard Start of API savepoint
3336: SAVEPOINT write_woru;
3337:
3338: -- Initialize API return status to success
3339: l_stmt_num := 10;

Line 3488: -- Standard Start of API savepoint

3484: and woru.resource_seq_num = p_resource_seq_num
3485: and woru.organization_id = p_organization_id;
3486:
3487: begin
3488: -- Standard Start of API savepoint
3489: SAVEPOINT adjust_woru;
3490:
3491: -- Standard call to check for call compatibility.
3492: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

3487: begin
3488: -- Standard Start of API savepoint
3489: SAVEPOINT adjust_woru;
3490:
3491: -- Standard call to check for call compatibility.
3492: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3493: RAISE fnd_api.g_exc_unexpected_error;
3494: END IF;
3495:

Line 3696: -- Standard check of p_commit.

3692: end if;
3693:
3694:
3695: -- End of API body.
3696: -- Standard check of p_commit.
3697: IF fnd_api.to_boolean(p_commit) THEN
3698: COMMIT WORK;
3699: END IF;
3700:

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

3697: IF fnd_api.to_boolean(p_commit) THEN
3698: COMMIT WORK;
3699: END IF;
3700:
3701: -- Standard call to get message count and if count is 1, get message info.
3702: fnd_msg_pub.count_and_get(
3703: p_count => x_msg_count
3704: ,p_data => x_msg_data);
3705: