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.PV_AME_API_W dependencies on FND_LOG

Line 112: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

108: END IF;
109:
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: -- ********* End Standard Initializations *********
112: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
113: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE
114: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
115: ,FALSE
116: );

Line 113: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE

109:
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111: -- ********* End Standard Initializations *********
112: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
113: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE
114: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
115: ,FALSE
116: );
117: END IF;

Line 142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

138: END IF;
139: CLOSE lc_referral_info;
140:
141:
142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
144: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
145: ,'After Getting partner Info..partner id:'|| l_partner_id ||
146: ' benefit type:' || l_benefit_type_code

Line 143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

139: CLOSE lc_referral_info;
140:
141:
142: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
144: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
145: ,'After Getting partner Info..partner id:'|| l_partner_id ||
146: ' benefit type:' || l_benefit_type_code
147: );

Line 157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

153: OPEN lc_get_approver_name(pc_user_id => FND_GLOBAL.USER_ID);
154: FETCH lc_get_approver_name INTO l_approver_name;
155: CLOSE lc_get_approver_name;
156:
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
159: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
160: ,'Approver name is: ' || l_approver_name);
161:

Line 158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

154: FETCH lc_get_approver_name INTO l_approver_name;
155: CLOSE lc_get_approver_name;
156:
157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
159: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
160: ,'Approver name is: ' || l_approver_name);
161:
162: END IF;

Line 202: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

198: SET approval_status_code = 'PRIOR_APPROVER'
199: WHERE arc_appr_for_entity_code = p_approval_entity
200: AND appr_for_entity_id = p_referral_id;
201:
202: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
204: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
205: ,'B4 GET_APPROVERS....'
206: );

Line 203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

199: WHERE arc_appr_for_entity_code = p_approval_entity
200: AND appr_for_entity_id = p_referral_id;
201:
202: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
204: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
205: ,'B4 GET_APPROVERS....'
206: );
207: END IF;

Line 220: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

216: ,x_default_approver => l_default_approver
217: ,x_user_id_exists => l_valid_users_flag
218: );
219:
220: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
221:
222: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
223: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
224: ,'After GET_APPROVERS:l_approval_completed ' || l_approval_completed ||

Line 222: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

218: );
219:
220: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
221:
222: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
223: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
224: ,'After GET_APPROVERS:l_approval_completed ' || l_approval_completed ||
225: ' l_default_approver ' || l_default_approver
226: );

Line 297: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

293: ,FND_GLOBAL.LOGIN_ID
294: );
295: EXCEPTION
296: WHEN others THEN
297: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
299: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
300: ,'Bad row index = ' || (1 +sql%rowcount) ||' ' || sqlerrm
301: );

Line 298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

294: );
295: EXCEPTION
296: WHEN others THEN
297: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
299: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
300: ,'Bad row index = ' || (1 +sql%rowcount) ||' ' || sqlerrm
301: );
302: END IF;

Line 305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

301: );
302: END IF;
303: END;
304:
305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
306: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
307: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
308: ,'Sucessfully inserted users into pv_ge_temp_approvers...'
309: );

Line 306: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

302: END IF;
303: END;
304:
305: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
306: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
307: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
308: ,'Sucessfully inserted users into pv_ge_temp_approvers...'
309: );
310: END IF;

Line 348: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

344: ELSIF p_approval_entity = 'PVDQMAPR' then
345: l_message_name := 'PV_LG_DQM_REQR_DEDUP_BY_USER';
346: END IF;
347:
348: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
349: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE
350: ,'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.start'
351: ,'Approvers notification Message:'||l_message_name);
352: end if;

Line 349: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE

345: l_message_name := 'PV_LG_DQM_REQR_DEDUP_BY_USER';
346: END IF;
347:
348: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
349: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE
350: ,'pv.plsql.PV_BENFT_STATUS_CHANGE.STATUS_CHANGE_LOGGING.start'
351: ,'Approvers notification Message:'||l_message_name);
352: end if;
353:

Line 569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

565: IF FND_API.to_Boolean( p_init_msg_list ) THEN
566: fnd_msg_pub.initialize;
567: END IF;
568:
569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE
571: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
572: ,FALSE
573: );

Line 570: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE

566: fnd_msg_pub.initialize;
567: END IF;
568:
569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE
571: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
572: ,FALSE
573: );
574: END IF;

Line 618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

614: ELSIF p_approval_entity = 'PVDEALRN' then
615: l_message_code := 'PV_LG_DEAL_FORWARDED_BY_USER';
616: end if;
617:
618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
619: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE
620: ,'Forward case :b4 updateStatus call Forwardee ID :' || l_forwardee.orig_system_id||
621: ' l_forwardee.name '||l_forwardee.name,FALSE);
622: END IF;

Line 619: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE

615: l_message_code := 'PV_LG_DEAL_FORWARDED_BY_USER';
616: end if;
617:
618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
619: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE
620: ,'Forward case :b4 updateStatus call Forwardee ID :' || l_forwardee.orig_system_id||
621: ' l_forwardee.name '||l_forwardee.name,FALSE);
622: END IF;
623:

Line 702: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

698: close lc_is_default_approver;
699:
700: IF l_approver_current_status is null then
701:
702: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
704: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
705: ,'This user ' || p_approver_user_id || ' is not an approver for entity id: ' || p_referral_id
706: );

Line 703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

699:
700: IF l_approver_current_status is null then
701:
702: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
704: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
705: ,'This user ' || p_approver_user_id || ' is not an approver for entity id: ' || p_referral_id
706: );
707: END IF;

Line 740: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

736:
737: l_log_params_tbl(1).param_name := 'APPROVER';
738: l_log_params_tbl(1).param_value := l_approver_name;
739:
740: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
741: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
742: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
743: ,'Logging approver response message: ' || l_message_code
744: );

Line 741: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

737: l_log_params_tbl(1).param_name := 'APPROVER';
738: l_log_params_tbl(1).param_value := l_approver_name;
739:
740: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
741: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
742: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
743: ,'Logging approver response message: ' || l_message_code
744: );
745: END IF;

Line 768: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

764: end if;
765:
766: end if;
767:
768: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
770: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
771: ,'p_response ' || p_response);
772: END IF;

Line 769: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

765:
766: end if;
767:
768: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
770: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
771: ,'p_response ' || p_response);
772: END IF;
773:

Line 779: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

775: -- an error will be thrown. In the other case i.e approve / reject
776: -- the AME update call is circumvented
777: IF (NOT l_approverInList AND (p_response = AME_UTIL.forwardStatus)) THEN
778:
779: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
781: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
782: ,' The approver is NOT in the list. p_response ' || p_response);
783: END IF;

Line 780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

776: -- the AME update call is circumvented
777: IF (NOT l_approverInList AND (p_response = AME_UTIL.forwardStatus)) THEN
778:
779: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
781: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
782: ,' The approver is NOT in the list. p_response ' || p_response);
783: END IF;
784:

Line 794: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

790:
791:
792: IF (l_approverInList) THEN
793:
794: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
796: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
797: ,'Current User is in AME system. Sending update reponse to AME...');
798: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

Line 795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

791:
792: IF (l_approverInList) THEN
793:
794: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
796: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
797: ,'Current User is in AME system. Sending update reponse to AME...');
798: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
799: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name

Line 798: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

794: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
796: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
797: ,'Current User is in AME system. Sending update reponse to AME...');
798: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
799: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
800: ,'User name l_user_name '|| l_user_name ||
801: ' FND_GLOBAL.USER_NAME '|| FND_GLOBAL.USER_NAME
802: );

Line 852: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

848: , forwardeeIn => l_forwardee
849: , updateItemIn => null
850: );
851:
852: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
853: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
854: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
855: ,'After AME_API.updateApprovalStatus2 call...'
856: );

Line 853: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

849: , updateItemIn => null
850: );
851:
852: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
853: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
854: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
855: ,'After AME_API.updateApprovalStatus2 call...'
856: );
857: END IF;

Line 863: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

859: END IF;
860:
861: ELSE
862:
863: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
865: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
866: ,'Current User is no more in the AME System as an approver. AME was not updated...'
867: );

Line 864: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

860:
861: ELSE
862:
863: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
865: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
866: ,'Current User is no more in the AME System as an approver. AME was not updated...'
867: );
868: END IF;

Line 883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

879: AND approver_id = p_approver_user_id
880: AND approval_status_code IN ('PENDING_APPROVAL','PENDING_DEFAULT')
881: AND rownum = 1;
882:
883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
885: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
886: ,'Set the approval status for '|| p_approval_entity || ', ' || p_referral_id ||
887: 'User id: ' || p_approver_user_id || ' to '||l_approval_status

Line 884: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

880: AND approval_status_code IN ('PENDING_APPROVAL','PENDING_DEFAULT')
881: AND rownum = 1;
882:
883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
885: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
886: ,'Set the approval status for '|| p_approval_entity || ', ' || p_referral_id ||
887: 'User id: ' || p_approver_user_id || ' to '||l_approval_status
888: );

Line 920: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

916: -- Approval. If it is PENDING_DEFAULT then that level is
917: -- considered the last level of approval
918: IF l_approver_current_status = 'PENDING_APPROVAL' THEN
919:
920: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
921: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
922: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
923: ,'B4 getNextApprover....'
924: );

Line 921: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

917: -- considered the last level of approval
918: IF l_approver_current_status = 'PENDING_APPROVAL' THEN
919:
920: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
921: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
922: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
923: ,'B4 getNextApprover....'
924: );
925: END IF;

Line 944: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

940: END IF;
941: RAISE;
942: END;
943:
944: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
945: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
946: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
947: ,'After getNextApprover....l_approval_list '||l_approval_list.COUNT ||
948: 'After getNextApprover....x_approval_done '||x_approval_done||

Line 945: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

941: RAISE;
942: END;
943:
944: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
945: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
946: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
947: ,'After getNextApprover....l_approval_list '||l_approval_list.COUNT ||
948: 'After getNextApprover....x_approval_done '||x_approval_done||
949: 'After getNextApprover....l_default_approver '||l_default_approver ||

Line 965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

961: IF ((l_approval_list IS NULL OR l_approval_list.COUNT < 1)
962: AND p_response = AME_UTIL.forwardStatus)
963: THEN
964:
965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
966: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
967: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
968: ,'Even After forwarding l_approval_list is '||l_approval_list.COUNT);
969: END IF;

Line 966: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

962: AND p_response = AME_UTIL.forwardStatus)
963: THEN
964:
965: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
966: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
967: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
968: ,'Even After forwarding l_approval_list is '||l_approval_list.COUNT);
969: END IF;
970:

Line 1034: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1030:
1031:
1032: IF l_approval_list IS NOT NULL AND l_approval_list.COUNT > 0
1033: THEN
1034: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1036: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1037: ,'Inserting users into pv_ge_temp_approvers...'
1038: );

Line 1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1031:
1032: IF l_approval_list IS NOT NULL AND l_approval_list.COUNT > 0
1033: THEN
1034: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1036: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1037: ,'Inserting users into pv_ge_temp_approvers...'
1038: );
1039: END IF;

Line 1077: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1073: );
1074:
1075: EXCEPTION
1076: WHEN others THEN
1077: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1079: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1080: ,'Bad row index = ' || (1 +sql%rowcount) ||' ' || sqlerrm
1081: );

Line 1078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1074:
1075: EXCEPTION
1076: WHEN others THEN
1077: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1078: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1079: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1080: ,'Bad row index = ' || (1 +sql%rowcount) ||' ' || sqlerrm
1081: );
1082: END IF;

Line 1102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1098: END LOOP;
1099:
1100: l_log_params_tbl(1).param_name := 'APPROVER';
1101:
1102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1104: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1105: ,'Logging who the next approver is: ' || l_approver_name
1106: );

Line 1103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1099:
1100: l_log_params_tbl(1).param_name := 'APPROVER';
1101:
1102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1104: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1105: ,'Logging who the next approver is: ' || l_approver_name
1106: );
1107: END IF;

Line 1295: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1291:
1292: BEGIN
1293: -- get all the approver list and loop till you find the matching
1294: -- and set the flag to true if you find any.
1295: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1297: ,'pv.plsql.' || g_pkg_name || '.VALIDATE_APPROVAL'
1298: ,'before getPendingApprovers ' || p_transaction_id ||
1299: ' '|| p_transaction_type || ' p_user_id ' || p_user_id ||

Line 1296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1292: BEGIN
1293: -- get all the approver list and loop till you find the matching
1294: -- and set the flag to true if you find any.
1295: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1297: ,'pv.plsql.' || g_pkg_name || '.VALIDATE_APPROVAL'
1298: ,'before getPendingApprovers ' || p_transaction_id ||
1299: ' '|| p_transaction_type || ' p_user_id ' || p_user_id ||
1300: ' p_person_id '|| p_person_id||' p_mode '|| p_mode ||

Line 1317: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1313:
1314: FOR i IN 1..x_nextApproversOut.count LOOP
1315: currApprRec := x_nextApproversOut(i);
1316:
1317: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1318: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1319: ,'pv.plsql.' || g_pkg_name || '.VALIDATE_APPROVAL'
1320: ,'currApprRec.orig_system_id ' || currApprRec.orig_system_id
1321: );

Line 1318: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1314: FOR i IN 1..x_nextApproversOut.count LOOP
1315: currApprRec := x_nextApproversOut(i);
1316:
1317: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1318: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1319: ,'pv.plsql.' || g_pkg_name || '.VALIDATE_APPROVAL'
1320: ,'currApprRec.orig_system_id ' || currApprRec.orig_system_id
1321: );
1322: END IF;

Line 1336: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1332:
1333: FOR i IN 1..x_nextApproversOut.count LOOP
1334: currApprRec := x_nextApproversOut(i);
1335:
1336: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1338: ,'pv.plsql.' || g_pkg_name || '.VALIDATE_APPROVAL'
1339: ,'currApprRec.orig_system_id ' || currApprRec.orig_system_id||
1340: 'currApprRec.orig_system_id ' || currApprRec.approver_order_number

Line 1337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1333: FOR i IN 1..x_nextApproversOut.count LOOP
1334: currApprRec := x_nextApproversOut(i);
1335:
1336: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1338: ,'pv.plsql.' || g_pkg_name || '.VALIDATE_APPROVAL'
1339: ,'currApprRec.orig_system_id ' || currApprRec.orig_system_id||
1340: 'currApprRec.orig_system_id ' || currApprRec.approver_order_number
1341: );

Line 1361: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1357: OPEN c_user(currApprRec.orig_system_id);
1358: FETCH c_user INTO l_usr_resp_pending;
1359: CLOSE c_user;
1360:
1361: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1363: ,'pv.plsql.' || g_pkg_name || '.VALIDATE_APPROVAL'
1364: ,'RESPONSES PENDING ? l_usr_resp_pending ' || l_usr_resp_pending
1365: );

Line 1362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1358: FETCH c_user INTO l_usr_resp_pending;
1359: CLOSE c_user;
1360:
1361: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1363: ,'pv.plsql.' || g_pkg_name || '.VALIDATE_APPROVAL'
1364: ,'RESPONSES PENDING ? l_usr_resp_pending ' || l_usr_resp_pending
1365: );
1366: END IF;

Line 1380: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1376: RETURN l_is_valid;
1377:
1378: EXCEPTION
1379: WHEN OTHERS THEN
1380: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1382: ,'pv.plsql.' || g_pkg_name || '.VALIDATE_APPROVAL'
1383: ,'Error in getPendingApprovers '||SQLCODE ||
1384: ': ' || SQLERRM);

Line 1381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1377:
1378: EXCEPTION
1379: WHEN OTHERS THEN
1380: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1382: ,'pv.plsql.' || g_pkg_name || '.VALIDATE_APPROVAL'
1383: ,'Error in getPendingApprovers '||SQLCODE ||
1384: ': ' || SQLERRM);
1385: END IF;

Line 1423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1419: l_orig_system VARCHAR2(20);
1420: l_exception_flag VARCHAR2(1) := 'N';
1421:
1422: BEGIN
1423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1424: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE
1425: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1426: ,FALSE
1427: );

Line 1424: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE

1420: l_exception_flag VARCHAR2(1) := 'N';
1421:
1422: BEGIN
1423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1424: FND_LOG.MESSAGE(FND_LOG.LEVEL_PROCEDURE
1425: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1426: ,FALSE
1427: );
1428: END IF;

Line 1430: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1426: ,FALSE
1427: );
1428: END IF;
1429:
1430: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1431: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1432: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1433: ,'inside GET_APPROVERS p_approval_entity '||p_approval_entity ||
1434: ' p_referral_id ' || p_referral_id

Line 1431: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1427: );
1428: END IF;
1429:
1430: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1431: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1432: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1433: ,'inside GET_APPROVERS p_approval_entity '||p_approval_entity ||
1434: ' p_referral_id ' || p_referral_id
1435: );

Line 1442: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1438: -- This BEGIN ... END is to trap any errors that is thrown from AME. In that
1439: -- case the list of approvers will be empty and approval would not be
1440: -- marked as complete. In those cases the default approver is to be picked up.
1441: BEGIN
1442: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1443: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1444: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1445: ,'GET_APPROVERS Calling new APIs '
1446: );

Line 1443: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1439: -- case the list of approvers will be empty and approval would not be
1440: -- marked as complete. In those cases the default approver is to be picked up.
1441: BEGIN
1442: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1443: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1444: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1445: ,'GET_APPROVERS Calling new APIs '
1446: );
1447: END IF;

Line 1468: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1464: ,transVariableValuesOut => xtransVariableValuesOut);
1465:
1466: --x_approval_list.EXTEND(x_nextApproversOut.COUNT);
1467:
1468: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1469: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1470: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1471: ,'GET_APPROVERS x_nextApproversOut.COUNT '||x_nextApproversOut.COUNT
1472: );

Line 1469: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1465:
1466: --x_approval_list.EXTEND(x_nextApproversOut.COUNT);
1467:
1468: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1469: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1470: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1471: ,'GET_APPROVERS x_nextApproversOut.COUNT '||x_nextApproversOut.COUNT
1472: );
1473: END IF;

Line 1481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1477:
1478: currApprRec := x_nextApproversOut(i);
1479: l_orig_system := currApprRec.orig_system;
1480:
1481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1483: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1484: ,'GET_APPROVERS l_orig_system '||l_orig_system
1485: );

Line 1482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1478: currApprRec := x_nextApproversOut(i);
1479: l_orig_system := currApprRec.orig_system;
1480:
1481: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1483: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1484: ,'GET_APPROVERS l_orig_system '||l_orig_system
1485: );
1486: END IF;

Line 1532: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1528: EXIT;
1529: END IF;
1530: END IF;
1531:
1532: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1534: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1535: ,'GET_APPROVERS x_approval_completed '||x_approval_completed
1536: );

Line 1533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1529: END IF;
1530: END IF;
1531:
1532: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1534: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1535: ,'GET_APPROVERS x_approval_completed '||x_approval_completed
1536: );
1537: END IF;

Line 1542: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1538:
1539: END LOOP;
1540:
1541: x_approval_completed := x_approvalProcessCompleteYNOut;
1542: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1544: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1545: ,'GET_APPROVERS x_approval_completed '||x_approval_completed
1546: );

Line 1543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1539: END LOOP;
1540:
1541: x_approval_completed := x_approvalProcessCompleteYNOut;
1542: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1544: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1545: ,'GET_APPROVERS x_approval_completed '||x_approval_completed
1546: );
1547: END IF;

Line 1577: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1573: *
1574: * A DEFAULT APPROVER IS NEVER CHOSEN IN CASE OF A SUBSEQUENT LEVEL APPROVAL
1575: **/
1576:
1577: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1579: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1580: ,'p_mode '||p_mode||' x_nextApproversOut.COUNT ' || x_nextApproversOut.COUNT ||
1581: ' l_exception_flag '||l_exception_flag||' x_user_id_exists ' || x_user_id_exists);

Line 1578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1574: * A DEFAULT APPROVER IS NEVER CHOSEN IN CASE OF A SUBSEQUENT LEVEL APPROVAL
1575: **/
1576:
1577: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1579: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1580: ,'p_mode '||p_mode||' x_nextApproversOut.COUNT ' || x_nextApproversOut.COUNT ||
1581: ' l_exception_flag '||l_exception_flag||' x_user_id_exists ' || x_user_id_exists);
1582: END IF;

Line 1605: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1601: ELSIF p_approval_entity = 'PVDQMAPR' THEN
1602: x_approval_list(1) := FND_PROFILE.Value('PV_DEFAULT_DQM_APPROVER');
1603: END IF;
1604:
1605: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1607: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1608: ,'Approver from profile for '||p_approval_entity||' is ' || x_approval_list(1)
1609: );

Line 1606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT

1602: x_approval_list(1) := FND_PROFILE.Value('PV_DEFAULT_DQM_APPROVER');
1603: END IF;
1604:
1605: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1606: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT
1607: ,'pv.plsql.' || g_pkg_name || '.' || l_api_name
1608: ,'Approver from profile for '||p_approval_entity||' is ' || x_approval_list(1)
1609: );
1610: END IF;