DBA Data[Home] [Help]

APPS.AR_ECAPP_PKG dependencies on ARP_STANDARD

Line 26: arp_standard.debug ('Inserting record into ar_settlement_errors_gt table');

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(

Line 45: arp_standard.debug ('Number of rows inserted: ' ||sql%rowcount);

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;

Line 46: arp_standard.debug ('Printing the IN parametr list from IBY');

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)) ;

Line 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)) ;

Line 51: arp_standard.debug ('req_type_Tab(' || cnt || ')' || req_type_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;

Line 52: arp_standard.debug ('Status_Tab(' || cnt || ')' || Status_Tab(i)) ;

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;

Line 53: arp_standard.debug ('updatedt_Tab(' || cnt || ')' || updatedt_Tab(i)) ;

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');

Line 54: arp_standard.debug ('refcode_Tab(' || cnt || ')' || refcode_Tab(i)) ;

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;

Line 57: arp_standard.debug ('Calling correct_settlement_error routine');

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: /***************************************************************

Line 152: arp_standard.debug('Open Cursor C1');

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

Line 166: arp_standard.debug('Close Cursor C1');

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, '------------------------'|| ' ' || '--------------');

Line 203: arp_standard.debug('Setting Org Context for Org_Id: '||l_org_id(i));

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),

Line 289: arp_standard.debug('Setting org context before calling CC Auto Correct');

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:

Line 290: arp_standard.debug('Org ID: ' || l_cc_org_id(i));

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));

Line 291: arp_standard.debug('Request ID: ' || l_request_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: