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.WIP_EAM_WORKREQUEST_PVT dependencies on STANDARD

Line 74: l_standard_log VARCHAR2(2000);

70: l_status_id NUMBER;
71: l_asset_activity_id NUMBER;
72: l_work_request_note_id NUMBER;
73: l_auto_approve_flag VARCHAR2(1);
74: l_standard_log VARCHAR2(2000);
75: l_stmt_num NUMBER;
76: l_request_log VARCHAR2(2000);
77: l_maintenance_object_id NUMBER;
78: l_maintenance_object_type NUMBER;

Line 86: -- Standard Start of API savepoint

82:
83: BEGIN
84: l_asset_activity_id := -1;
85: l_stmt_num := 10;
86: -- Standard Start of API savepoint
87: SAVEPOINT create_work_request_pvt;
88: l_stmt_num := 20;
89: -- Standard call to check for call compatibility.
90: IF NOT fnd_api.compatible_api_call(

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

85: l_stmt_num := 10;
86: -- Standard Start of API savepoint
87: SAVEPOINT create_work_request_pvt;
88: l_stmt_num := 20;
89: -- Standard call to check for call compatibility.
90: IF NOT fnd_api.compatible_api_call(
91: l_api_version
92: ,p_api_version
93: ,l_api_name

Line 315: INTO l_standard_log

311: );
312: l_stmt_num := 90;
313: SELECT '*** '||FND_GLOBAL.USER_NAME||' ('
314: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '
315: INTO l_standard_log
316: FROM DUAL;
317: l_stmt_num := 100;
318: SELECT wip_eam_work_req_notes_s.nextval
319: INTO l_work_request_note_id

Line 342: l_standard_log,

338: sysdate,
339: FND_GLOBAL.user_id,
340: FND_GLOBAL.login_id,
341: l_work_request_id,
342: l_standard_log,
343: 1, -- 1 for request log, 2 for approver log
344: null
345: );
346: l_stmt_num := 120;

Line 405: -- Standard check of p_commit.

401: /* Hook for Eam Asset Log #4141712 End*/
402:
403: -- End of API body.
404: l_stmt_num := 998;
405: -- Standard check of p_commit.
406: IF fnd_api.to_boolean(p_commit) THEN
407: COMMIT WORK;
408: END IF;
409: l_stmt_num := 999;

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

406: IF fnd_api.to_boolean(p_commit) THEN
407: COMMIT WORK;
408: END IF;
409: l_stmt_num := 999;
410: -- Standard call to get message count and if count is 1, get message info.
411: fnd_msg_pub.count_and_get(
412: p_encoded => fnd_api.g_false
413: ,p_count => x_msg_count
414: ,p_data => x_msg_data);

Line 694: l_standard_log VARCHAR2(2000);

690: l_new_attribute12 VARCHAR2(150);
691: l_new_attribute13 VARCHAR2(150);
692: l_new_attribute14 VARCHAR2(150);
693: l_new_attribute15 VARCHAR2(150);
694: l_standard_log VARCHAR2(2000);
695: l_request_log VARCHAR2(2000);
696: l_another_log VARCHAR2(2000);
697: l_old_data VARCHAR2(80);
698: l_new_data VARCHAR2(80);

Line 718: -- Standard Start of API savepoint

714: l_asset_num_reqd VARCHAR2(1);
715:
716: BEGIN
717: l_stmt_num := 10;
718: -- Standard Start of API savepoint
719: SAVEPOINT update_work_request_pvt;
720: l_stmt_num := 20;
721: -- Standard call to check for call compatibility.
722: IF NOT fnd_api.compatible_api_call(

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

717: l_stmt_num := 10;
718: -- Standard Start of API savepoint
719: SAVEPOINT update_work_request_pvt;
720: l_stmt_num := 20;
721: -- Standard call to check for call compatibility.
722: IF NOT fnd_api.compatible_api_call(
723: l_api_version
724: ,p_api_version
725: ,l_api_name

Line 856: INTO l_standard_log

852: END IF;
853:
854: SELECT '*** '||FND_GLOBAL.USER_NAME||' ('
855: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '
856: INTO l_standard_log
857: FROM DUAL;
858: l_another_log := l_standard_log;
859: l_stmt_num := 60;
860:

Line 858: l_another_log := l_standard_log;

854: SELECT '*** '||FND_GLOBAL.USER_NAME||' ('
855: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '
856: INTO l_standard_log
857: FROM DUAL;
858: l_another_log := l_standard_log;
859: l_stmt_num := 60;
860:
861: SELECT wip_eam_work_req_notes_s.nextval
862: INTO l_work_request_note_id

Line 885: l_standard_log,

881: sysdate,
882: FND_GLOBAL.user_id,
883: FND_GLOBAL.login_id,
884: p_request_id,
885: l_standard_log,
886: 1, -- 1 for request log, 2 for approver log
887: null -- Don't know what will be put here for notification_id
888: );
889:

Line 2252: -- Standard check of p_commit.

2248: -- l_request_log := chr(10) || l_another_log;
2249: END IF;
2250: l_stmt_num := 998;
2251: -- End of API body.
2252: -- Standard check of p_commit.
2253: IF fnd_api.to_boolean(p_commit) THEN
2254: COMMIT WORK;
2255: END IF;
2256:

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

2254: COMMIT WORK;
2255: END IF;
2256:
2257: l_stmt_num := 999;
2258: -- Standard call to get message count and if count is 1, get message info.
2259: fnd_msg_pub.count_and_get(
2260: p_encoded => fnd_api.g_false
2261: ,p_count => x_msg_count
2262: ,p_data => x_msg_data);

Line 3201: l_standard_log VARCHAR2(2000);

3197: )is
3198: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Approve_Check';
3199: l_api_version CONSTANT NUMBER := 115.0;
3200: l_auto_approve_flag VARCHAR2(1);
3201: l_standard_log VARCHAR2(2000);
3202: l_stmt_num NUMBER;
3203: BEGIN
3204: l_stmt_num := 10;
3205: -- Standard Start of API savepoint

Line 3205: -- Standard Start of API savepoint

3201: l_standard_log VARCHAR2(2000);
3202: l_stmt_num NUMBER;
3203: BEGIN
3204: l_stmt_num := 10;
3205: -- Standard Start of API savepoint
3206: SAVEPOINT auto_approve_check_pvt;
3207: l_stmt_num := 20;
3208: -- Standard call to check for call compatibility.
3209: IF NOT fnd_api.compatible_api_call(

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

3204: l_stmt_num := 10;
3205: -- Standard Start of API savepoint
3206: SAVEPOINT auto_approve_check_pvt;
3207: l_stmt_num := 20;
3208: -- Standard call to check for call compatibility.
3209: IF NOT fnd_api.compatible_api_call(
3210: l_api_version
3211: ,p_api_version
3212: ,l_api_name

Line 3238: -- Standard check of p_commit.

3234: l_stmt_num := 60;
3235: x_return_check := l_auto_approve_flag ;
3236: -- End API Body
3237: l_stmt_num := 998;
3238: -- Standard check of p_commit.
3239: IF fnd_api.to_boolean(p_commit) THEN
3240: COMMIT WORK;
3241: END IF;
3242: l_stmt_num := 999;

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

3239: IF fnd_api.to_boolean(p_commit) THEN
3240: COMMIT WORK;
3241: END IF;
3242: l_stmt_num := 999;
3243: -- Standard call to get message count and if count is 1, get message info.
3244: fnd_msg_pub.count_and_get(
3245: p_encoded => fnd_api.g_false
3246: ,p_count => x_msg_count
3247: ,p_data => x_msg_data);

Line 3348: -- Standard Start of API savepoint

3344: l_instance_id NUMBER;
3345:
3346: BEGIN
3347: l_stmt_number := 10;
3348: -- Standard Start of API savepoint
3349: SAVEPOINT create_and_approve;
3350: l_stmt_num := 20;
3351: -- Standard call to check for call compatibility.
3352: IF NOT fnd_api.compatible_api_call(

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

3347: l_stmt_number := 10;
3348: -- Standard Start of API savepoint
3349: SAVEPOINT create_and_approve;
3350: l_stmt_num := 20;
3351: -- Standard call to check for call compatibility.
3352: IF NOT fnd_api.compatible_api_call(
3353: l_api_version
3354: ,p_api_version
3355: ,l_api_name

Line 3559: -- Standard check of p_commit.

3555:
3556:
3557: -- End of API body.
3558: l_stmt_num := 998;
3559: -- Standard check of p_commit.
3560: IF fnd_api.to_boolean(p_commit) THEN
3561: COMMIT WORK;
3562: END IF;
3563: l_stmt_num := 999;

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

3560: IF fnd_api.to_boolean(p_commit) THEN
3561: COMMIT WORK;
3562: END IF;
3563: l_stmt_num := 999;
3564: -- Standard call to get message count and if count is 1, get message info.
3565: fnd_msg_pub.count_and_get(
3566: p_encoded => fnd_api.g_false
3567: ,p_count => x_msg_count
3568: ,p_data => x_msg_data);

Line 3629: -- Standard Start of API savepoint

3625: l_stmt_num NUMBER;
3626:
3627: BEGIN
3628: l_stmt_num := 1;
3629: -- Standard Start of API savepoint
3630: SAVEPOINT check_product_install;
3631: -- Standard call to check for call compatibility.
3632: IF NOT fnd_api.compatible_api_call(l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
3633: RAISE fnd_api.g_exc_unexpected_error;

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

3627: BEGIN
3628: l_stmt_num := 1;
3629: -- Standard Start of API savepoint
3630: SAVEPOINT check_product_install;
3631: -- Standard call to check for call compatibility.
3632: IF NOT fnd_api.compatible_api_call(l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
3633: RAISE fnd_api.g_exc_unexpected_error;
3634: END IF;
3635: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3657: -- Standard check of p_commit.

3653: END IF;
3654:
3655: l_stmt_num := 15;
3656: -- End of API body.
3657: -- Standard check of p_commit.
3658: IF fnd_api.to_boolean(p_commit) THEN
3659: COMMIT WORK;
3660: END IF;
3661: -- Standard call to get message count and if count is 1, get message info.

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

3657: -- Standard check of p_commit.
3658: IF fnd_api.to_boolean(p_commit) THEN
3659: COMMIT WORK;
3660: END IF;
3661: -- Standard call to get message count and if count is 1, get message info.
3662: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3663: p_count => x_msg_count,
3664: p_data => x_msg_data);
3665: l_stmt_num := 20;