22:
23: IF PG_DEBUG in ('Y', 'C') THEN
24: fnd_file.put_line(FND_FILE.LOG,'AR_ECAPP_PKG.UPDATE_STATUS()+');
25: fnd_file.put_line(FND_FILE.LOG, totalRows);
26: arp_standard.debug ('Inserting record into ar_settlement_errors_gt table');
27: END IF;
28:
29: FORALL i in 1 .. totalRows
30: insert into ar_settlement_errors_gt(
41: refcode_tab(i)
42: );
43:
44: IF PG_DEBUG in ('Y', 'C') THEN
45: arp_standard.debug ('Number of rows inserted: ' ||sql%rowcount);
46: arp_standard.debug ('Printing the IN parametr list from IBY');
47: IF txn_id_tab.count > 0 THEN
48: FOR i in 1 .. totalRows LOOP
49: cnt := cnt + 1;
42: );
43:
44: IF PG_DEBUG in ('Y', 'C') THEN
45: arp_standard.debug ('Number of rows inserted: ' ||sql%rowcount);
46: arp_standard.debug ('Printing the IN parametr list from IBY');
47: IF txn_id_tab.count > 0 THEN
48: FOR i in 1 .. totalRows LOOP
49: cnt := cnt + 1;
50: arp_standard.debug ('txn_id_Tab(' || cnt || ')' || txn_id_Tab(i)) ;
46: arp_standard.debug ('Printing the IN parametr list from IBY');
47: IF txn_id_tab.count > 0 THEN
48: FOR i in 1 .. totalRows LOOP
49: cnt := cnt + 1;
50: arp_standard.debug ('txn_id_Tab(' || cnt || ')' || txn_id_Tab(i)) ;
51: arp_standard.debug ('req_type_Tab(' || cnt || ')' || req_type_Tab(i)) ;
52: arp_standard.debug ('Status_Tab(' || cnt || ')' || Status_Tab(i)) ;
53: arp_standard.debug ('updatedt_Tab(' || cnt || ')' || updatedt_Tab(i)) ;
54: arp_standard.debug ('refcode_Tab(' || cnt || ')' || refcode_Tab(i)) ;
47: IF txn_id_tab.count > 0 THEN
48: FOR i in 1 .. totalRows LOOP
49: cnt := cnt + 1;
50: arp_standard.debug ('txn_id_Tab(' || cnt || ')' || txn_id_Tab(i)) ;
51: arp_standard.debug ('req_type_Tab(' || cnt || ')' || req_type_Tab(i)) ;
52: arp_standard.debug ('Status_Tab(' || cnt || ')' || Status_Tab(i)) ;
53: arp_standard.debug ('updatedt_Tab(' || cnt || ')' || updatedt_Tab(i)) ;
54: arp_standard.debug ('refcode_Tab(' || cnt || ')' || refcode_Tab(i)) ;
55: END LOOP;
48: FOR i in 1 .. totalRows LOOP
49: cnt := cnt + 1;
50: arp_standard.debug ('txn_id_Tab(' || cnt || ')' || txn_id_Tab(i)) ;
51: arp_standard.debug ('req_type_Tab(' || cnt || ')' || req_type_Tab(i)) ;
52: arp_standard.debug ('Status_Tab(' || cnt || ')' || Status_Tab(i)) ;
53: arp_standard.debug ('updatedt_Tab(' || cnt || ')' || updatedt_Tab(i)) ;
54: arp_standard.debug ('refcode_Tab(' || cnt || ')' || refcode_Tab(i)) ;
55: END LOOP;
56: END IF;
49: cnt := cnt + 1;
50: arp_standard.debug ('txn_id_Tab(' || cnt || ')' || txn_id_Tab(i)) ;
51: arp_standard.debug ('req_type_Tab(' || cnt || ')' || req_type_Tab(i)) ;
52: arp_standard.debug ('Status_Tab(' || cnt || ')' || Status_Tab(i)) ;
53: arp_standard.debug ('updatedt_Tab(' || cnt || ')' || updatedt_Tab(i)) ;
54: arp_standard.debug ('refcode_Tab(' || cnt || ')' || refcode_Tab(i)) ;
55: END LOOP;
56: END IF;
57: arp_standard.debug ('Calling correct_settlement_error routine');
50: arp_standard.debug ('txn_id_Tab(' || cnt || ')' || txn_id_Tab(i)) ;
51: arp_standard.debug ('req_type_Tab(' || cnt || ')' || req_type_Tab(i)) ;
52: arp_standard.debug ('Status_Tab(' || cnt || ')' || Status_Tab(i)) ;
53: arp_standard.debug ('updatedt_Tab(' || cnt || ')' || updatedt_Tab(i)) ;
54: arp_standard.debug ('refcode_Tab(' || cnt || ')' || refcode_Tab(i)) ;
55: END LOOP;
56: END IF;
57: arp_standard.debug ('Calling correct_settlement_error routine');
58: END IF;
53: arp_standard.debug ('updatedt_Tab(' || cnt || ')' || updatedt_Tab(i)) ;
54: arp_standard.debug ('refcode_Tab(' || cnt || ')' || refcode_Tab(i)) ;
55: END LOOP;
56: END IF;
57: arp_standard.debug ('Calling correct_settlement_error routine');
58: END IF;
59: correct_settlement_error ;
60:
61: /***************************************************************
148:
149: l_called_from := 'SUBMIT_OFFLINE';
150:
151: IF PG_DEBUG in ('Y', 'C') THEN
152: arp_standard.debug('Open Cursor C1');
153: END IF;
154:
155: OPEN C1;
156: FETCH C1 BULK COLLECT INTO
162: l_instrtype;
163: CLOSE C1;
164:
165: IF PG_DEBUG in ('Y', 'C') THEN
166: arp_standard.debug('Close Cursor C1');
167: END IF;
168:
169: fnd_file.put_line(FND_FILE.LOG,'Receipts being processed' || ' ' || 'Operating Unit');
170: fnd_file.put_line(FND_FILE.LOG, '------------------------'|| ' ' || '--------------');
199: THEN
200:
201: IF PG_DEBUG in ('Y', 'C')
202: THEN
203: arp_standard.debug('Setting Org Context for Org_Id: '||l_org_id(i));
204: END IF;
205:
206: /*mo_global.set_policy_context('S', l_org_id(i));*/
207: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id(i),
285: FOR i in l_request_id.first .. l_request_id.last LOOP
286: Begin
287:
288: IF PG_DEBUG in ('Y', 'C') THEN
289: arp_standard.debug('Setting org context before calling CC Auto Correct');
290: arp_standard.debug('Org ID: ' || l_cc_org_id(i));
291: arp_standard.debug('Request ID: ' || l_request_id(i));
292: END IF;
293:
286: Begin
287:
288: IF PG_DEBUG in ('Y', 'C') THEN
289: arp_standard.debug('Setting org context before calling CC Auto Correct');
290: arp_standard.debug('Org ID: ' || l_cc_org_id(i));
291: arp_standard.debug('Request ID: ' || l_request_id(i));
292: END IF;
293:
294: mo_global.set_policy_context('S', l_cc_org_id(i));
287:
288: IF PG_DEBUG in ('Y', 'C') THEN
289: arp_standard.debug('Setting org context before calling CC Auto Correct');
290: arp_standard.debug('Org ID: ' || l_cc_org_id(i));
291: arp_standard.debug('Request ID: ' || l_request_id(i));
292: END IF;
293:
294: mo_global.set_policy_context('S', l_cc_org_id(i));
295: