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

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

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

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

Line 327: INTO l_standard_log

323: END;
324:
325: SELECT '*** '||l_user_name||' ('
326: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '
327: INTO l_standard_log
328: FROM DUAL;
329: l_stmt_num := 100;
330: SELECT wip_eam_work_req_notes_s.nextval
331: INTO l_work_request_note_id

Line 354: l_standard_log,

350: sysdate,
351: NVL(p_user_id,FND_GLOBAL.user_id),
352: NVL(p_user_id,FND_GLOBAL.login_id),
353: l_work_request_id,
354: l_standard_log,
355: 1, -- 1 for request log, 2 for approver log
356: null
357: );
358: l_stmt_num := 120;

Line 417: -- Standard check of p_commit.

413: /* Hook for Eam Asset Log #4141712 End*/
414:
415: -- End of API body.
416: l_stmt_num := 998;
417: -- Standard check of p_commit.
418: IF fnd_api.to_boolean(p_commit) THEN
419: COMMIT WORK;
420: END IF;
421: l_stmt_num := 999;

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

418: IF fnd_api.to_boolean(p_commit) THEN
419: COMMIT WORK;
420: END IF;
421: l_stmt_num := 999;
422: -- Standard call to get message count and if count is 1, get message info.
423: fnd_msg_pub.count_and_get(
424: p_encoded => fnd_api.g_false
425: ,p_count => x_msg_count
426: ,p_data => x_msg_data);

Line 707: l_standard_log VARCHAR2(2000);

703: l_new_attribute12 VARCHAR2(150);
704: l_new_attribute13 VARCHAR2(150);
705: l_new_attribute14 VARCHAR2(150);
706: l_new_attribute15 VARCHAR2(150);
707: l_standard_log VARCHAR2(2000);
708: l_request_log VARCHAR2(2000);
709: l_another_log VARCHAR2(2000);
710: l_old_data VARCHAR2(80);
711: l_new_data VARCHAR2(80);

Line 736: -- Standard Start of API savepoint

732:
733:
734:
735: l_stmt_num := 10;
736: -- Standard Start of API savepoint
737: SAVEPOINT update_work_request_pvt;
738: l_stmt_num := 20;
739: -- Standard call to check for call compatibility.
740: IF NOT fnd_api.compatible_api_call(

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

735: l_stmt_num := 10;
736: -- Standard Start of API savepoint
737: SAVEPOINT update_work_request_pvt;
738: l_stmt_num := 20;
739: -- Standard call to check for call compatibility.
740: IF NOT fnd_api.compatible_api_call(
741: l_api_version
742: ,p_api_version
743: ,l_api_name

Line 884: INTO l_standard_log

880: END;
881:
882: SELECT '*** '||l_user_name||' ('
883: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '
884: INTO l_standard_log
885: FROM DUAL;
886: l_another_log := l_standard_log;
887: l_stmt_num := 60;
888:

Line 886: l_another_log := l_standard_log;

882: SELECT '*** '||l_user_name||' ('
883: ||to_char(SYSDATE,'YYYY-MM-DD HH24:MI:SS')||') *** '
884: INTO l_standard_log
885: FROM DUAL;
886: l_another_log := l_standard_log;
887: l_stmt_num := 60;
888:
889: SELECT wip_eam_work_req_notes_s.nextval
890: INTO l_work_request_note_id

Line 913: l_standard_log,

909: sysdate,
910: NVL(p_user_id,FND_GLOBAL.user_id),
911: NVL(p_user_id,FND_GLOBAL.login_id),
912: p_request_id,
913: l_standard_log,
914: 1, -- 1 for request log, 2 for approver log
915: null -- Don't know what will be put here for notification_id
916: );
917:

Line 2292: -- Standard check of p_commit.

2288:
2289: END IF;
2290:
2291: -- End of API body.
2292: -- Standard check of p_commit.
2293: IF fnd_api.to_boolean(p_commit) THEN
2294: COMMIT WORK;
2295: END IF;
2296:

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

2294: COMMIT WORK;
2295: END IF;
2296:
2297: l_stmt_num := 999;
2298: -- Standard call to get message count and if count is 1, get message info.
2299: fnd_msg_pub.count_and_get(
2300: p_encoded => fnd_api.g_false
2301: ,p_count => x_msg_count
2302: ,p_data => x_msg_data);

Line 3263: l_standard_log VARCHAR2(2000);

3259: )is
3260: l_api_name CONSTANT VARCHAR2(30) := 'Auto_Approve_Check';
3261: l_api_version CONSTANT NUMBER := 115.0;
3262: l_auto_approve_flag VARCHAR2(1);
3263: l_standard_log VARCHAR2(2000);
3264: l_stmt_num NUMBER;
3265: BEGIN
3266: l_stmt_num := 10;
3267: -- Standard Start of API savepoint

Line 3267: -- Standard Start of API savepoint

3263: l_standard_log VARCHAR2(2000);
3264: l_stmt_num NUMBER;
3265: BEGIN
3266: l_stmt_num := 10;
3267: -- Standard Start of API savepoint
3268: SAVEPOINT auto_approve_check_pvt;
3269: l_stmt_num := 20;
3270: -- Standard call to check for call compatibility.
3271: IF NOT fnd_api.compatible_api_call(

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

3266: l_stmt_num := 10;
3267: -- Standard Start of API savepoint
3268: SAVEPOINT auto_approve_check_pvt;
3269: l_stmt_num := 20;
3270: -- Standard call to check for call compatibility.
3271: IF NOT fnd_api.compatible_api_call(
3272: l_api_version
3273: ,p_api_version
3274: ,l_api_name

Line 3300: -- Standard check of p_commit.

3296: l_stmt_num := 60;
3297: x_return_check := l_auto_approve_flag ;
3298: -- End API Body
3299: l_stmt_num := 998;
3300: -- Standard check of p_commit.
3301: IF fnd_api.to_boolean(p_commit) THEN
3302: COMMIT WORK;
3303: END IF;
3304: l_stmt_num := 999;

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

3301: IF fnd_api.to_boolean(p_commit) THEN
3302: COMMIT WORK;
3303: END IF;
3304: l_stmt_num := 999;
3305: -- Standard call to get message count and if count is 1, get message info.
3306: fnd_msg_pub.count_and_get(
3307: p_encoded => fnd_api.g_false
3308: ,p_count => x_msg_count
3309: ,p_data => x_msg_data);

Line 3410: -- Standard Start of API savepoint

3406: l_instance_id NUMBER;
3407:
3408: BEGIN
3409: l_stmt_number := 10;
3410: -- Standard Start of API savepoint
3411: SAVEPOINT create_and_approve;
3412: l_stmt_num := 20;
3413: -- Standard call to check for call compatibility.
3414: IF NOT fnd_api.compatible_api_call(

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

3409: l_stmt_number := 10;
3410: -- Standard Start of API savepoint
3411: SAVEPOINT create_and_approve;
3412: l_stmt_num := 20;
3413: -- Standard call to check for call compatibility.
3414: IF NOT fnd_api.compatible_api_call(
3415: l_api_version
3416: ,p_api_version
3417: ,l_api_name

Line 3622: -- Standard check of p_commit.

3618:
3619:
3620: -- End of API body.
3621: l_stmt_num := 998;
3622: -- Standard check of p_commit.
3623: IF fnd_api.to_boolean(p_commit) THEN
3624: COMMIT WORK;
3625: END IF;
3626: l_stmt_num := 999;

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

3623: IF fnd_api.to_boolean(p_commit) THEN
3624: COMMIT WORK;
3625: END IF;
3626: l_stmt_num := 999;
3627: -- Standard call to get message count and if count is 1, get message info.
3628: fnd_msg_pub.count_and_get(
3629: p_encoded => fnd_api.g_false
3630: ,p_count => x_msg_count
3631: ,p_data => x_msg_data);

Line 3692: -- Standard Start of API savepoint

3688: l_stmt_num NUMBER;
3689:
3690: BEGIN
3691: l_stmt_num := 1;
3692: -- Standard Start of API savepoint
3693: SAVEPOINT check_product_install;
3694: -- Standard call to check for call compatibility.
3695: IF NOT fnd_api.compatible_api_call(l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
3696: RAISE fnd_api.g_exc_unexpected_error;

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

3690: BEGIN
3691: l_stmt_num := 1;
3692: -- Standard Start of API savepoint
3693: SAVEPOINT check_product_install;
3694: -- Standard call to check for call compatibility.
3695: IF NOT fnd_api.compatible_api_call(l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
3696: RAISE fnd_api.g_exc_unexpected_error;
3697: END IF;
3698: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3720: -- Standard check of p_commit.

3716: END IF;
3717:
3718: l_stmt_num := 15;
3719: -- End of API body.
3720: -- Standard check of p_commit.
3721: IF fnd_api.to_boolean(p_commit) THEN
3722: COMMIT WORK;
3723: END IF;
3724: -- Standard call to get message count and if count is 1, get message info.

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

3720: -- Standard check of p_commit.
3721: IF fnd_api.to_boolean(p_commit) THEN
3722: COMMIT WORK;
3723: END IF;
3724: -- Standard call to get message count and if count is 1, get message info.
3725: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3726: p_count => x_msg_count,
3727: p_data => x_msg_data);
3728: l_stmt_num := 20;