59:
60: l_Debug_Module := p_debug_module;
61:
62: iby_debug_pub.add(debug_msg => 'p_mbatchid: ' || p_mbatchid,
63: debug_level => FND_LOG.LEVEL_STATEMENT,
64: module => l_Debug_Module);
65:
66: iby_debug_pub.add(debug_msg => 'p_fromDate: ' || p_fromDate,
67: debug_level => FND_LOG.LEVEL_STATEMENT,
63: debug_level => FND_LOG.LEVEL_STATEMENT,
64: module => l_Debug_Module);
65:
66: iby_debug_pub.add(debug_msg => 'p_fromDate: ' || p_fromDate,
67: debug_level => FND_LOG.LEVEL_STATEMENT,
68: module => l_Debug_Module);
69:
70: iby_debug_pub.add(debug_msg => 'p_toDate: ' || p_toDate,
71: debug_level => FND_LOG.LEVEL_STATEMENT,
67: debug_level => FND_LOG.LEVEL_STATEMENT,
68: module => l_Debug_Module);
69:
70: iby_debug_pub.add(debug_msg => 'p_toDate: ' || p_toDate,
71: debug_level => FND_LOG.LEVEL_STATEMENT,
72: module => l_Debug_Module);
73:
74: iby_debug_pub.add(debug_msg => 'p_fromPSON: ' || p_fromPSON,
75: debug_level => FND_LOG.LEVEL_STATEMENT,
71: debug_level => FND_LOG.LEVEL_STATEMENT,
72: module => l_Debug_Module);
73:
74: iby_debug_pub.add(debug_msg => 'p_fromPSON: ' || p_fromPSON,
75: debug_level => FND_LOG.LEVEL_STATEMENT,
76: module => l_Debug_Module);
77:
78: iby_debug_pub.add(debug_msg => 'p_toPSON: ' || p_toPSON,
79: debug_level => FND_LOG.LEVEL_STATEMENT,
75: debug_level => FND_LOG.LEVEL_STATEMENT,
76: module => l_Debug_Module);
77:
78: iby_debug_pub.add(debug_msg => 'p_toPSON: ' || p_toPSON,
79: debug_level => FND_LOG.LEVEL_STATEMENT,
80: module => l_Debug_Module);
81:
82: iby_debug_pub.add(debug_msg => 'p_delivery_method: ' || p_delivery_method,
83: debug_level => FND_LOG.LEVEL_STATEMENT,
79: debug_level => FND_LOG.LEVEL_STATEMENT,
80: module => l_Debug_Module);
81:
82: iby_debug_pub.add(debug_msg => 'p_delivery_method: ' || p_delivery_method,
83: debug_level => FND_LOG.LEVEL_STATEMENT,
84: module => l_Debug_Module);
85:
86: iby_debug_pub.add(debug_msg => 'p_format_code: ' || p_format_code,
87: debug_level => FND_LOG.LEVEL_STATEMENT,
83: debug_level => FND_LOG.LEVEL_STATEMENT,
84: module => l_Debug_Module);
85:
86: iby_debug_pub.add(debug_msg => 'p_format_code: ' || p_format_code,
87: debug_level => FND_LOG.LEVEL_STATEMENT,
88: module => l_Debug_Module);
89:
90: -- back out this changes due to performance reasons
91: -- from date is required program parameter
167:
168: BEGIN
169:
170: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
171: debug_level => FND_LOG.LEVEL_PROCEDURE,
172: module => l_Debug_Module);
173:
174: CEP_STANDARD.init_security;
175:
230:
231: Setup_for_Extract(p_sys_key);
232:
233: iby_debug_pub.add(debug_msg => 'After Setup_for_Extract() ',
234: debug_level => FND_LOG.LEVEL_STATEMENT,
235: module => l_Debug_Module);
236:
237: iby_debug_pub.add(debug_msg => 'Before executing dynamic query.',
238: debug_level => FND_LOG.LEVEL_STATEMENT,
234: debug_level => FND_LOG.LEVEL_STATEMENT,
235: module => l_Debug_Module);
236:
237: iby_debug_pub.add(debug_msg => 'Before executing dynamic query.',
238: debug_level => FND_LOG.LEVEL_STATEMENT,
239: module => l_Debug_Module);
240:
241: iby_debug_pub.add(debug_msg => 'l_extract_query: ' || l_extract_query,
242: debug_level => FND_LOG.LEVEL_STATEMENT,
238: debug_level => FND_LOG.LEVEL_STATEMENT,
239: module => l_Debug_Module);
240:
241: iby_debug_pub.add(debug_msg => 'l_extract_query: ' || l_extract_query,
242: debug_level => FND_LOG.LEVEL_STATEMENT,
243: module => l_Debug_Module);
244:
245: --iby_debug_pub.add(debug_msg => 'variables: '||p_fromDate||':'||l_toDate||':'||
246: -- l_mbatchid||':'||l_fromPSON||':'||l_toPSON||':'||
244:
245: --iby_debug_pub.add(debug_msg => 'variables: '||p_fromDate||':'||l_toDate||':'||
246: -- l_mbatchid||':'||l_fromPSON||':'||l_toPSON||':'||
247: -- l_delivery_method||':'||p_format_code||':'||l_trxn_id,
248: -- debug_level => FND_LOG.LEVEL_STATEMENT,
249: -- module => l_Debug_Module);
250:
251: EXECUTE IMMEDIATE l_extract_query INTO l_xml USING p_fromDate, p_delivery_method, p_format_code;
252:
258:
259: x_extract_doc := XMLType.getClobVal(l_xml);
260:
261: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
262: debug_level => FND_LOG.LEVEL_PROCEDURE,
263: module => l_Debug_Module);
264:
265: -- clears out data from global temporary table
266: COMMIT;
298:
299: iby_utility_pvt.set_view_param(G_VP_EXTRACT_MODE, l_char_extract_mdoe);
300:
301: iby_debug_pub.add(debug_msg => 'The extract mode is: ' || G_Extract_Run_Mode,
302: debug_level => FND_LOG.LEVEL_STATEMENT,
303: module => l_Debug_Module);
304:
305: IF (NOT p_sys_key IS NULL) THEN
306: iby_security_pkg.validate_sys_key(p_sys_key,lx_err_code);
559:
560: BEGIN
561:
562: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
563: debug_level => FND_LOG.LEVEL_PROCEDURE,
564: module => l_Debug_Module);
565:
566: iby_debug_pub.add(debug_msg => 'Extract mode is G_EXTRACT_MODE_SRA. ',
567: debug_level => FND_LOG.LEVEL_STATEMENT,
563: debug_level => FND_LOG.LEVEL_PROCEDURE,
564: module => l_Debug_Module);
565:
566: iby_debug_pub.add(debug_msg => 'Extract mode is G_EXTRACT_MODE_SRA. ',
567: debug_level => FND_LOG.LEVEL_STATEMENT,
568: module => l_Debug_Module);
569:
570: IF G_Extract_Run_Delivery_Method = G_SRA_DELIVERY_METHOD_PRINTED THEN
571:
569:
570: IF G_Extract_Run_Delivery_Method = G_SRA_DELIVERY_METHOD_PRINTED THEN
571:
572: iby_debug_pub.add(debug_msg => 'Delivery method is printed. ',
573: debug_level => FND_LOG.LEVEL_STATEMENT,
574: module => l_Debug_Module);
575:
576: OPEN l_payeeacct_prt_csr (p_mbatch_id);
577: FETCH l_payeeacct_prt_csr INTO l_payeeacct_agg;
577: FETCH l_payeeacct_prt_csr INTO l_payeeacct_agg;
578: CLOSE l_payeeacct_prt_csr;
579:
580: iby_debug_pub.add(debug_msg => 'After fetch from payee account cursor. ',
581: debug_level => FND_LOG.LEVEL_STATEMENT,
582: module => l_Debug_Module);
583:
584: ELSIF G_Extract_Run_Delivery_Method = G_SRA_DELIVERY_METHOD_EMAIL OR
585: G_Extract_Run_Delivery_Method = G_SRA_DELIVERY_METHOD_FAX THEN
584: ELSIF G_Extract_Run_Delivery_Method = G_SRA_DELIVERY_METHOD_EMAIL OR
585: G_Extract_Run_Delivery_Method = G_SRA_DELIVERY_METHOD_FAX THEN
586:
587: iby_debug_pub.add(debug_msg => 'Delivery method is Email/Fax. ',
588: debug_level => FND_LOG.LEVEL_STATEMENT,
589: module => l_Debug_Module);
590:
591: OPEN l_payeeacct_ele_csr (p_mbatch_id);
592: FETCH l_payeeacct_ele_csr INTO l_payeeacct_agg;
592: FETCH l_payeeacct_ele_csr INTO l_payeeacct_agg;
593: CLOSE l_payeeacct_ele_csr;
594:
595: iby_debug_pub.add(debug_msg => 'After fetch from payee account cursor. ',
596: debug_level => FND_LOG.LEVEL_STATEMENT,
597: module => l_Debug_Module);
598: END IF;
599:
600: RETURN l_payeeacct_agg;
599:
600: RETURN l_payeeacct_agg;
601:
602: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
603: debug_level => FND_LOG.LEVEL_PROCEDURE,
604: module => l_Debug_Module);
605:
606: END Get_Ins_PayeeAcctAgg;
607:
872:
873: BEGIN
874:
875: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
876: debug_level => FND_LOG.LEVEL_PROCEDURE,
877: module => l_Debug_Module);
878:
879: l_where_clause := Get_Payer_Notif_Where_cluase
880: (
890:
891: l_update_stmt := l_update_stmt || l_where_clause;
892:
893: iby_debug_pub.add(debug_msg => 'Before executing dynamic update statement.',
894: debug_level => FND_LOG.LEVEL_STATEMENT,
895: module => l_Debug_Module);
896:
897: iby_debug_pub.add(debug_msg => 'l_update_stmt: ' || l_update_stmt,
898: debug_level => FND_LOG.LEVEL_STATEMENT,
894: debug_level => FND_LOG.LEVEL_STATEMENT,
895: module => l_Debug_Module);
896:
897: iby_debug_pub.add(debug_msg => 'l_update_stmt: ' || l_update_stmt,
898: debug_level => FND_LOG.LEVEL_STATEMENT,
899: module => l_Debug_Module);
900:
901: EXECUTE IMMEDIATE l_update_stmt;
902:
900:
901: EXECUTE IMMEDIATE l_update_stmt;
902:
903: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
904: debug_level => FND_LOG.LEVEL_PROCEDURE,
905: module => l_Debug_Module);
906:
907: END Update_Pmt_SRA_Attr_Prt;
908:
979: l_bool_val boolean; -- Bug 6411356
980:
981: BEGIN
982:
983: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module, debug_level => FND_LOG.LEVEL_PROCEDURE,
984: module => l_Debug_Module);
985:
986: iby_debug_pub.add(debug_msg => 'p_bep_type: '||p_bep_type, debug_level => FND_LOG.LEVEL_STATEMENT,
987: module => l_Debug_Module);
982:
983: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module, debug_level => FND_LOG.LEVEL_PROCEDURE,
984: module => l_Debug_Module);
985:
986: iby_debug_pub.add(debug_msg => 'p_bep_type: '||p_bep_type, debug_level => FND_LOG.LEVEL_STATEMENT,
987: module => l_Debug_Module);
988:
989: iby_debug_pub.add(debug_msg => 'p_from_settlement_date: '||p_from_settlement_date, debug_level => FND_LOG.LEVEL_STATEMENT,
990: module => l_Debug_Module);
985:
986: iby_debug_pub.add(debug_msg => 'p_bep_type: '||p_bep_type, debug_level => FND_LOG.LEVEL_STATEMENT,
987: module => l_Debug_Module);
988:
989: iby_debug_pub.add(debug_msg => 'p_from_settlement_date: '||p_from_settlement_date, debug_level => FND_LOG.LEVEL_STATEMENT,
990: module => l_Debug_Module);
991:
992: iby_debug_pub.add(debug_msg => 'p_to_settlement_date: '||p_to_settlement_date, debug_level => FND_LOG.LEVEL_STATEMENT,
993: module => l_Debug_Module);
988:
989: iby_debug_pub.add(debug_msg => 'p_from_settlement_date: '||p_from_settlement_date, debug_level => FND_LOG.LEVEL_STATEMENT,
990: module => l_Debug_Module);
991:
992: iby_debug_pub.add(debug_msg => 'p_to_settlement_date: '||p_to_settlement_date, debug_level => FND_LOG.LEVEL_STATEMENT,
993: module => l_Debug_Module);
994:
995: iby_debug_pub.add(debug_msg => 'p_settlement_batch: '||p_settlement_batch, debug_level => FND_LOG.LEVEL_STATEMENT,
996: module => l_Debug_Module);
991:
992: iby_debug_pub.add(debug_msg => 'p_to_settlement_date: '||p_to_settlement_date, debug_level => FND_LOG.LEVEL_STATEMENT,
993: module => l_Debug_Module);
994:
995: iby_debug_pub.add(debug_msg => 'p_settlement_batch: '||p_settlement_batch, debug_level => FND_LOG.LEVEL_STATEMENT,
996: module => l_Debug_Module);
997:
998: iby_debug_pub.add(debug_msg => 'p_from_PSON: '||p_from_PSON, debug_level => FND_LOG.LEVEL_STATEMENT,
999: module => l_Debug_Module);
994:
995: iby_debug_pub.add(debug_msg => 'p_settlement_batch: '||p_settlement_batch, debug_level => FND_LOG.LEVEL_STATEMENT,
996: module => l_Debug_Module);
997:
998: iby_debug_pub.add(debug_msg => 'p_from_PSON: '||p_from_PSON, debug_level => FND_LOG.LEVEL_STATEMENT,
999: module => l_Debug_Module);
1000:
1001: iby_debug_pub.add(debug_msg => 'p_to_PSON: '||p_to_PSON, debug_level => FND_LOG.LEVEL_STATEMENT,
1002: module => l_Debug_Module);
997:
998: iby_debug_pub.add(debug_msg => 'p_from_PSON: '||p_from_PSON, debug_level => FND_LOG.LEVEL_STATEMENT,
999: module => l_Debug_Module);
1000:
1001: iby_debug_pub.add(debug_msg => 'p_to_PSON: '||p_to_PSON, debug_level => FND_LOG.LEVEL_STATEMENT,
1002: module => l_Debug_Module);
1003:
1004: -- The settlement date is required for the concurrent request, so included
1005: -- logic in API to get the settlement date based on query from concurrent
1015: WHEN others THEN NULL;
1016: END;
1017:
1018: iby_debug_pub.add(debug_msg => 'Reqdate is not passed and type is PROCESSOR. l_reqdate='||l_reqdate,
1019: debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
1020:
1021: END IF;
1022:
1023: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()', debug_level => FND_LOG.LEVEL_STATEMENT,
1019: debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
1020:
1021: END IF;
1022:
1023: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()', debug_level => FND_LOG.LEVEL_STATEMENT,
1024: module => l_Debug_Module);
1025:
1026: --Bug 6411356
1027: --below code added to set the current nls character setting
1060: -- Added explicit commit in pl/sql. Request id is logged, but the request is not created in FND
1061: COMMIT;
1062:
1063: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
1064: debug_level => FND_LOG.LEVEL_STATEMENT,
1065: module => l_Debug_Module);
1066: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
1067: debug_level => FND_LOG.LEVEL_STATEMENT,
1068: module => l_Debug_Module);
1063: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
1064: debug_level => FND_LOG.LEVEL_STATEMENT,
1065: module => l_Debug_Module);
1066: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
1067: debug_level => FND_LOG.LEVEL_STATEMENT,
1068: module => l_Debug_Module);
1069:
1070: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1071: debug_level => FND_LOG.LEVEL_PROCEDURE,
1067: debug_level => FND_LOG.LEVEL_STATEMENT,
1068: module => l_Debug_Module);
1069:
1070: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1071: debug_level => FND_LOG.LEVEL_PROCEDURE,
1072: module => l_Debug_Module);
1073:
1074: RETURN l_request_id;
1075:
1088:
1089:
1090: BEGIN
1091:
1092: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module, debug_level => FND_LOG.LEVEL_PROCEDURE,
1093: module => l_Debug_Module);
1094:
1095: iby_debug_pub.add(debug_msg => 'p_settlement_batch: '||p_settlement_batch, debug_level => FND_LOG.LEVEL_STATEMENT,
1096: module => l_Debug_Module);
1091:
1092: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module, debug_level => FND_LOG.LEVEL_PROCEDURE,
1093: module => l_Debug_Module);
1094:
1095: iby_debug_pub.add(debug_msg => 'p_settlement_batch: '||p_settlement_batch, debug_level => FND_LOG.LEVEL_STATEMENT,
1096: module => l_Debug_Module);
1097:
1098: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()', debug_level => FND_LOG.LEVEL_STATEMENT,
1099: module => l_Debug_Module);
1094:
1095: iby_debug_pub.add(debug_msg => 'p_settlement_batch: '||p_settlement_batch, debug_level => FND_LOG.LEVEL_STATEMENT,
1096: module => l_Debug_Module);
1097:
1098: iby_debug_pub.add(debug_msg => 'Before Calling FND_REQUEST.SUBMIT_REQUEST()', debug_level => FND_LOG.LEVEL_STATEMENT,
1099: module => l_Debug_Module);
1100:
1101:
1102: --Bug 6411356
1132: -- Added explicit commit in pl/sql. Request id is logged, but the request is not created in FND
1133: COMMIT;
1134:
1135: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
1136: debug_level => FND_LOG.LEVEL_STATEMENT,
1137: module => l_Debug_Module);
1138: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
1139: debug_level => FND_LOG.LEVEL_STATEMENT,
1140: module => l_Debug_Module);
1135: iby_debug_pub.add(debug_msg => 'After Calling FND_REQUEST.SUBMIT_REQUEST()',
1136: debug_level => FND_LOG.LEVEL_STATEMENT,
1137: module => l_Debug_Module);
1138: iby_debug_pub.add(debug_msg => 'Request id: ' || l_request_id,
1139: debug_level => FND_LOG.LEVEL_STATEMENT,
1140: module => l_Debug_Module);
1141:
1142: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1143: debug_level => FND_LOG.LEVEL_PROCEDURE,
1139: debug_level => FND_LOG.LEVEL_STATEMENT,
1140: module => l_Debug_Module);
1141:
1142: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
1143: debug_level => FND_LOG.LEVEL_PROCEDURE,
1144: module => l_Debug_Module);
1145:
1146: RETURN l_request_id;
1147: