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.AR_AGING_BUCKETS_PKG dependencies on STANDARD

Line 158: arp_standard.debug( dbms_lob.substr( p_clob, 255, l_offset ) );

154: BEGIN
155: BEGIN
156: LOOP
157: EXIT WHEN l_offset > dbms_lob.getlength(p_clob);
158: arp_standard.debug( dbms_lob.substr( p_clob, 255, l_offset ) );
159: l_offset := l_offset + 255;
160: END LOOP;
161:
162: EXCEPTION

Line 165: arp_standard.debug( ' Exception '||SQLERRM);

161:
162: EXCEPTION
163: WHEN OTHERS THEN
164: IF PG_DEBUG in ('Y', 'C') THEN
165: arp_standard.debug( ' Exception '||SQLERRM);
166: arp_standard.debug( ' Exception print_clob()');
167: END IF;
168: END;
169: END print_clob;

Line 166: arp_standard.debug( ' Exception print_clob()');

162: EXCEPTION
163: WHEN OTHERS THEN
164: IF PG_DEBUG in ('Y', 'C') THEN
165: arp_standard.debug( ' Exception '||SQLERRM);
166: arp_standard.debug( ' Exception print_clob()');
167: END IF;
168: END;
169: END print_clob;
170:

Line 211: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_heading()+');

207: ';
208:
209: BEGIN
210: IF PG_DEBUG in ('Y', 'C') THEN
211: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_heading()+');
212: END IF;
213:
214: FOR buc_rec IN buc_info_cur LOOP
215: IF buc_rec.report_heading2 IS NULL THEN

Line 228: arp_standard.debug( 'report_heading1: '||buc_rec.report_heading1);

224: ''||format_string(buc_rec.report_heading2)||'';
225: END IF;
226:
227: IF PG_DEBUG in ('Y', 'C') THEN
228: arp_standard.debug( 'report_heading1: '||buc_rec.report_heading1);
229: arp_standard.debug( 'report_heading2: '||buc_rec.report_heading2);
230: END IF;
231:
232: i := i + 1;

Line 229: arp_standard.debug( 'report_heading2: '||buc_rec.report_heading2);

225: END IF;
226:
227: IF PG_DEBUG in ('Y', 'C') THEN
228: arp_standard.debug( 'report_heading1: '||buc_rec.report_heading1);
229: arp_standard.debug( 'report_heading2: '||buc_rec.report_heading2);
230: END IF;
231:
232: i := i + 1;
233:

Line 237: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_heading()-');

233:
234: END LOOP;
235:
236: IF PG_DEBUG in ('Y', 'C') THEN
237: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_heading()-');
238: END IF;
239:
240: RETURN l_report_heading;
241:

Line 245: arp_standard.debug( ' Exception '||SQLERRM);

241:
242: EXCEPTION
243: WHEN OTHERS THEN
244: IF PG_DEBUG in ('Y', 'C') THEN
245: arp_standard.debug( ' Exception '||SQLERRM);
246: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.get_report_heading()');
247: END IF;
248: RAISE;
249: END get_report_heading;

Line 246: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.get_report_heading()');

242: EXCEPTION
243: WHEN OTHERS THEN
244: IF PG_DEBUG in ('Y', 'C') THEN
245: arp_standard.debug( ' Exception '||SQLERRM);
246: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.get_report_heading()');
247: END IF;
248: RAISE;
249: END get_report_heading;
250:

Line 278: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_parent_request_id()+');

274: l_request_id NUMBER;
275:
276: BEGIN
277: IF PG_DEBUG in ('Y', 'C') THEN
278: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_parent_request_id()+');
279: arp_standard.debug( 'p_request_id :'||p_request_id);
280: END IF;
281:
282: SELECT parent_request_id

Line 279: arp_standard.debug( 'p_request_id :'||p_request_id);

275:
276: BEGIN
277: IF PG_DEBUG in ('Y', 'C') THEN
278: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_parent_request_id()+');
279: arp_standard.debug( 'p_request_id :'||p_request_id);
280: END IF;
281:
282: SELECT parent_request_id
283: INTO l_request_id

Line 288: arp_standard.debug( 'Return value :'||l_request_id);

284: FROM fnd_concurrent_requests child
285: WHERE child.request_id = p_request_id;
286:
287: IF PG_DEBUG in ('Y', 'C') THEN
288: arp_standard.debug( 'Return value :'||l_request_id);
289: END IF;
290:
291: RETURN l_request_id;
292:

Line 296: arp_standard.debug( ' Exception '||SQLERRM);

292:
293: EXCEPTION
294: WHEN OTHERS THEN
295: IF PG_DEBUG in ('Y', 'C') THEN
296: arp_standard.debug( ' Exception '||SQLERRM);
297: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.get_parent_request_id()');
298: END IF;
299: RAISE;
300: END get_parent_request_id;

Line 297: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.get_parent_request_id()');

293: EXCEPTION
294: WHEN OTHERS THEN
295: IF PG_DEBUG in ('Y', 'C') THEN
296: arp_standard.debug( ' Exception '||SQLERRM);
297: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.get_parent_request_id()');
298: END IF;
299: RAISE;
300: END get_parent_request_id;
301:

Line 330: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()+');

326: p_info_type VARCHAR2) RETURN VARCHAR2 IS
327:
328: BEGIN
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()+');
331: arp_standard.debug( 'p_site_use_id :'||p_site_use_id);
332: arp_standard.debug( 'p_info_type :'||p_info_type);
333: arp_standard.debug( 'pg_temp_site_use_id :'||pg_temp_site_use_id);
334: END IF;

Line 331: arp_standard.debug( 'p_site_use_id :'||p_site_use_id);

327:
328: BEGIN
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()+');
331: arp_standard.debug( 'p_site_use_id :'||p_site_use_id);
332: arp_standard.debug( 'p_info_type :'||p_info_type);
333: arp_standard.debug( 'pg_temp_site_use_id :'||pg_temp_site_use_id);
334: END IF;
335:

Line 332: arp_standard.debug( 'p_info_type :'||p_info_type);

328: BEGIN
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()+');
331: arp_standard.debug( 'p_site_use_id :'||p_site_use_id);
332: arp_standard.debug( 'p_info_type :'||p_info_type);
333: arp_standard.debug( 'pg_temp_site_use_id :'||pg_temp_site_use_id);
334: END IF;
335:
336: IF p_site_use_id IS NULL THEN

Line 333: arp_standard.debug( 'pg_temp_site_use_id :'||pg_temp_site_use_id);

329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()+');
331: arp_standard.debug( 'p_site_use_id :'||p_site_use_id);
332: arp_standard.debug( 'p_info_type :'||p_info_type);
333: arp_standard.debug( 'pg_temp_site_use_id :'||pg_temp_site_use_id);
334: END IF;
335:
336: IF p_site_use_id IS NULL THEN
337: RETURN NULL;

Line 402: arp_standard.debug( 'Exception message '||SQLERRM);

398:
399: EXCEPTION
400: WHEN NO_DATA_FOUND THEN
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_standard.debug( 'Exception message '||SQLERRM);
403: END IF;
404: END;
405: END IF;
406:

Line 408: arp_standard.debug( 'pg_temp_contact_name '||pg_temp_contact_name);

404: END;
405: END IF;
406:
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_standard.debug( 'pg_temp_contact_name '||pg_temp_contact_name);
409: arp_standard.debug( 'pg_temp_contact_phone '||pg_temp_contact_phone);
410: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()-');
411: END IF;
412:

Line 409: arp_standard.debug( 'pg_temp_contact_phone '||pg_temp_contact_phone);

405: END IF;
406:
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_standard.debug( 'pg_temp_contact_name '||pg_temp_contact_name);
409: arp_standard.debug( 'pg_temp_contact_phone '||pg_temp_contact_phone);
410: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()-');
411: END IF;
412:
413: IF p_info_type = 'NAME' THEN

Line 410: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()-');

406:
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_standard.debug( 'pg_temp_contact_name '||pg_temp_contact_name);
409: arp_standard.debug( 'pg_temp_contact_phone '||pg_temp_contact_phone);
410: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_contact_information()-');
411: END IF;
412:
413: IF p_info_type = 'NAME' THEN
414: RETURN pg_temp_contact_name;

Line 422: arp_standard.debug( 'Exception message '||SQLERRM);

418:
419: EXCEPTION
420: WHEN OTHERS THEN
421: IF PG_DEBUG in ('Y', 'C') THEN
422: arp_standard.debug( 'Exception message '||SQLERRM);
423: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.get_contact_information()');
424: END IF;
425: RETURN NULL;
426: END get_contact_information;

Line 423: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.get_contact_information()');

419: EXCEPTION
420: WHEN OTHERS THEN
421: IF PG_DEBUG in ('Y', 'C') THEN
422: arp_standard.debug( 'Exception message '||SQLERRM);
423: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.get_contact_information()');
424: END IF;
425: RETURN NULL;
426: END get_contact_information;
427:

Line 917: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_header_xml()+');

913: l_xml_header VARCHAR2(32000);
914:
915: BEGIN
916: IF PG_DEBUG in ('Y', 'C') THEN
917: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_header_xml()+');
918: END IF;
919:
920: IF to_number(pg_reporting_level) = 1000 AND
921: mo_utils.check_ledger_in_sp(TO_NUMBER(pg_reporting_entity_id)) = 'N' THEN

Line 958: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_header_xml()-');

954: '||pg_functional_currency||'
955: '||pg_risk_meaning||''||AR_AGING_BUCKETS_PKG.get_report_heading();
956:
957: IF PG_DEBUG in ('Y', 'C') THEN
958: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_header_xml()-');
959: END IF;
960:
961: RETURN l_xml_header;
962:

Line 965: arp_standard.debug( 'Exception message '||SQLERRM);

961: RETURN l_xml_header;
962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: arp_standard.debug( 'Exception message '||SQLERRM);
966: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.get_report_header_xml()');
967: RETURN NULL;
968: END get_report_header_xml;
969:

Line 966: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.get_report_header_xml()');

962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: arp_standard.debug( 'Exception message '||SQLERRM);
966: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.get_report_header_xml()');
967: RETURN NULL;
968: END get_report_header_xml;
969:
970:

Line 998: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.populate_setup_information()+');

994: l_sys_query VARCHAR2(20000);
995:
996: BEGIN
997: IF PG_DEBUG in ('Y', 'C') THEN
998: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.populate_setup_information()+');
999: END IF;
1000:
1001: l_sys_query := '
1002: SELECT param.org_id,

Line 1018: arp_standard.debug( ' l_sys_query :'||l_sys_query);

1014: AND rownum = 1
1015: '||pg_org_where_sys_param;
1016:
1017: IF PG_DEBUG in ('Y', 'C') THEN
1018: arp_standard.debug( ' l_sys_query :'||l_sys_query);
1019: END IF;
1020:
1021: EXECUTE IMMEDIATE l_sys_query
1022: INTO pg_param_org_id,

Line 1032: arp_standard.debug( ' Rows returned '||SQL%ROWCOUNT);

1028: pg_set_of_books_id
1029: USING pg_in_currency;
1030:
1031: IF PG_DEBUG in ('Y', 'C') THEN
1032: arp_standard.debug( ' Rows returned '||SQL%ROWCOUNT);
1033: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.populate_setup_information()+');
1034: END IF;
1035:
1036: EXCEPTION

Line 1033: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.populate_setup_information()+');

1029: USING pg_in_currency;
1030:
1031: IF PG_DEBUG in ('Y', 'C') THEN
1032: arp_standard.debug( ' Rows returned '||SQL%ROWCOUNT);
1033: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.populate_setup_information()+');
1034: END IF;
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN

Line 1039: arp_standard.debug( ' Exception '||SQLERRM);

1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: IF PG_DEBUG in ('Y', 'C') THEN
1039: arp_standard.debug( ' Exception '||SQLERRM);
1040: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.populate_setup_information()');
1041: END IF;
1042: RAISE;
1043: END populate_setup_information;

Line 1040: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.populate_setup_information()');

1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: IF PG_DEBUG in ('Y', 'C') THEN
1039: arp_standard.debug( ' Exception '||SQLERRM);
1040: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.populate_setup_information()');
1041: END IF;
1042: RAISE;
1043: END populate_setup_information;
1044:

Line 1074: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()+');

1070: PROCEDURE initialize_package_globals IS
1071: BEGIN
1072:
1073: IF PG_DEBUG in ('Y', 'C') THEN
1074: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()+');
1075: END IF;
1076:
1077: XLA_MO_REPORTING_API.Initialize(pg_reporting_level, pg_reporting_entity_id, 'AUTO');
1078:

Line 1083: arp_standard.debug( ' pg_reporting_entity_name '||pg_reporting_entity_name );

1079: pg_reporting_entity_name := substrb(XLA_MO_REPORTING_API.get_reporting_entity_name,1,80);
1080: pg_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
1081:
1082: IF PG_DEBUG in ('Y', 'C') THEN
1083: arp_standard.debug( ' pg_reporting_entity_name '||pg_reporting_entity_name );
1084: arp_standard.debug( ' pg_reporting_level_name '||pg_reporting_level_name );
1085: END IF;
1086:
1087: pg_org_where_ps := XLA_MO_REPORTING_API.Get_Predicate('ps', 'push_subq');

Line 1084: arp_standard.debug( ' pg_reporting_level_name '||pg_reporting_level_name );

1080: pg_reporting_level_name := substrb(XLA_MO_REPORTING_API.get_reporting_level_name,1,30);
1081:
1082: IF PG_DEBUG in ('Y', 'C') THEN
1083: arp_standard.debug( ' pg_reporting_entity_name '||pg_reporting_entity_name );
1084: arp_standard.debug( ' pg_reporting_level_name '||pg_reporting_level_name );
1085: END IF;
1086:
1087: pg_org_where_ps := XLA_MO_REPORTING_API.Get_Predicate('ps', 'push_subq');
1088: pg_org_where_gld := XLA_MO_REPORTING_API.Get_Predicate('gld', 'push_subq');

Line 1125: arp_standard.debug( ' Populating balancing segment strings.. ');

1121: pg_org_where_sys_param := replace(pg_org_where_sys_param,
1122: ':p_reporting_entity_id','AR_AGING_BUCKETS_PKG.get_reporting_entity_id()');
1123:
1124: IF PG_DEBUG in ('Y', 'C') THEN
1125: arp_standard.debug( ' Populating balancing segment strings.. ');
1126: END IF;
1127:
1128: IF pg_in_bal_segment_low IS NULL AND pg_in_bal_segment_high IS NULL THEN
1129: pg_bal_seg_where := NULL;

Line 1182: arp_standard.debug( ' pg_accounting_flexfield '||pg_accounting_flexfield);

1178:
1179: pg_cons_profile_value := AR_SETUP.value('AR_SHOW_BILLING_NUMBER',null);
1180:
1181: IF PG_DEBUG in ('Y', 'C') THEN
1182: arp_standard.debug( ' pg_accounting_flexfield '||pg_accounting_flexfield);
1183: arp_standard.debug( ' pg_bal_seg_where '||pg_bal_seg_where);
1184: arp_standard.debug( ' pg_acct_flex_bal_seg '||pg_acct_flex_bal_seg);
1185: arp_standard.debug( ' pg_cons_profile_value '||pg_cons_profile_value);
1186: END IF;

Line 1183: arp_standard.debug( ' pg_bal_seg_where '||pg_bal_seg_where);

1179: pg_cons_profile_value := AR_SETUP.value('AR_SHOW_BILLING_NUMBER',null);
1180:
1181: IF PG_DEBUG in ('Y', 'C') THEN
1182: arp_standard.debug( ' pg_accounting_flexfield '||pg_accounting_flexfield);
1183: arp_standard.debug( ' pg_bal_seg_where '||pg_bal_seg_where);
1184: arp_standard.debug( ' pg_acct_flex_bal_seg '||pg_acct_flex_bal_seg);
1185: arp_standard.debug( ' pg_cons_profile_value '||pg_cons_profile_value);
1186: END IF;
1187:

Line 1184: arp_standard.debug( ' pg_acct_flex_bal_seg '||pg_acct_flex_bal_seg);

1180:
1181: IF PG_DEBUG in ('Y', 'C') THEN
1182: arp_standard.debug( ' pg_accounting_flexfield '||pg_accounting_flexfield);
1183: arp_standard.debug( ' pg_bal_seg_where '||pg_bal_seg_where);
1184: arp_standard.debug( ' pg_acct_flex_bal_seg '||pg_acct_flex_bal_seg);
1185: arp_standard.debug( ' pg_cons_profile_value '||pg_cons_profile_value);
1186: END IF;
1187:
1188: pg_report_name := ARP_STANDARD.fnd_message(pg_rep_type||'_REPORT_NAME');

Line 1185: arp_standard.debug( ' pg_cons_profile_value '||pg_cons_profile_value);

1181: IF PG_DEBUG in ('Y', 'C') THEN
1182: arp_standard.debug( ' pg_accounting_flexfield '||pg_accounting_flexfield);
1183: arp_standard.debug( ' pg_bal_seg_where '||pg_bal_seg_where);
1184: arp_standard.debug( ' pg_acct_flex_bal_seg '||pg_acct_flex_bal_seg);
1185: arp_standard.debug( ' pg_cons_profile_value '||pg_cons_profile_value);
1186: END IF;
1187:
1188: pg_report_name := ARP_STANDARD.fnd_message(pg_rep_type||'_REPORT_NAME');
1189: pg_segment_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_SEG_LABEL');

Line 1188: pg_report_name := ARP_STANDARD.fnd_message(pg_rep_type||'_REPORT_NAME');

1184: arp_standard.debug( ' pg_acct_flex_bal_seg '||pg_acct_flex_bal_seg);
1185: arp_standard.debug( ' pg_cons_profile_value '||pg_cons_profile_value);
1186: END IF;
1187:
1188: pg_report_name := ARP_STANDARD.fnd_message(pg_rep_type||'_REPORT_NAME');
1189: pg_segment_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_SEG_LABEL');
1190: pg_bal_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_BAL_LABEL');
1191: pg_label_1 := ARP_STANDARD.fnd_message(pg_rep_type||'_LABEL_1');
1192:

Line 1189: pg_segment_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_SEG_LABEL');

1185: arp_standard.debug( ' pg_cons_profile_value '||pg_cons_profile_value);
1186: END IF;
1187:
1188: pg_report_name := ARP_STANDARD.fnd_message(pg_rep_type||'_REPORT_NAME');
1189: pg_segment_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_SEG_LABEL');
1190: pg_bal_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_BAL_LABEL');
1191: pg_label_1 := ARP_STANDARD.fnd_message(pg_rep_type||'_LABEL_1');
1192:
1193:

Line 1190: pg_bal_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_BAL_LABEL');

1186: END IF;
1187:
1188: pg_report_name := ARP_STANDARD.fnd_message(pg_rep_type||'_REPORT_NAME');
1189: pg_segment_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_SEG_LABEL');
1190: pg_bal_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_BAL_LABEL');
1191: pg_label_1 := ARP_STANDARD.fnd_message(pg_rep_type||'_LABEL_1');
1192:
1193:
1194: IF pg_rep_type = 'ARXAGS' THEN

Line 1191: pg_label_1 := ARP_STANDARD.fnd_message(pg_rep_type||'_LABEL_1');

1187:
1188: pg_report_name := ARP_STANDARD.fnd_message(pg_rep_type||'_REPORT_NAME');
1189: pg_segment_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_SEG_LABEL');
1190: pg_bal_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_BAL_LABEL');
1191: pg_label_1 := ARP_STANDARD.fnd_message(pg_rep_type||'_LABEL_1');
1192:
1193:
1194: IF pg_rep_type = 'ARXAGS' THEN
1195: IF UPPER(RTRIM(RPAD(pg_in_summary_option_low,1))) = 'I' THEN

Line 1196: pg_bal_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_BAL_LABEL_INV');

1192:
1193:
1194: IF pg_rep_type = 'ARXAGS' THEN
1195: IF UPPER(RTRIM(RPAD(pg_in_summary_option_low,1))) = 'I' THEN
1196: pg_bal_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_BAL_LABEL_INV');
1197: END IF;
1198:
1199: IF UPPER(SUBSTR(pg_in_sortoption,1,1)) = 'C' THEN
1200: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type ||'_SORT_ONC');

Line 1200: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type ||'_SORT_ONC');

1196: pg_bal_label := ARP_STANDARD.fnd_message(pg_rep_type ||'_BAL_LABEL_INV');
1197: END IF;
1198:
1199: IF UPPER(SUBSTR(pg_in_sortoption,1,1)) = 'C' THEN
1200: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type ||'_SORT_ONC');
1201: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_C');
1202: ELSE
1203: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type || '_SORT_ONT');
1204: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_T');

Line 1201: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_C');

1197: END IF;
1198:
1199: IF UPPER(SUBSTR(pg_in_sortoption,1,1)) = 'C' THEN
1200: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type ||'_SORT_ONC');
1201: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_C');
1202: ELSE
1203: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type || '_SORT_ONT');
1204: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_T');
1205: END IF;

Line 1203: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type || '_SORT_ONT');

1199: IF UPPER(SUBSTR(pg_in_sortoption,1,1)) = 'C' THEN
1200: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type ||'_SORT_ONC');
1201: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_C');
1202: ELSE
1203: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type || '_SORT_ONT');
1204: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_T');
1205: END IF;
1206: ELSE
1207: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type||'_SORT_ON');

Line 1204: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_T');

1200: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type ||'_SORT_ONC');
1201: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_C');
1202: ELSE
1203: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type || '_SORT_ONT');
1204: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_T');
1205: END IF;
1206: ELSE
1207: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type||'_SORT_ON');
1208: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL');

Line 1207: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type||'_SORT_ON');

1203: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type || '_SORT_ONT');
1204: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_T');
1205: END IF;
1206: ELSE
1207: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type||'_SORT_ON');
1208: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL');
1209: END IF;
1210:
1211: IF pg_rep_type IN ('ARXAGL','ARXAGR') THEN

Line 1208: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL');

1204: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL_T');
1205: END IF;
1206: ELSE
1207: pg_sort_on := ARP_STANDARD.fnd_message(pg_rep_type||'_SORT_ON');
1208: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL');
1209: END IF;
1210:
1211: IF pg_rep_type IN ('ARXAGL','ARXAGR') THEN
1212: pg_label := ARP_STANDARD.fnd_message(pg_rep_type||'_LABEL');

Line 1212: pg_label := ARP_STANDARD.fnd_message(pg_rep_type||'_LABEL');

1208: pg_grand_total := ARP_STANDARD.fnd_message(pg_rep_type ||'_GRAND_TOTAL');
1209: END IF;
1210:
1211: IF pg_rep_type IN ('ARXAGL','ARXAGR') THEN
1212: pg_label := ARP_STANDARD.fnd_message(pg_rep_type||'_LABEL');
1213: END IF;
1214:
1215: IF PG_DEBUG in ('Y', 'C') THEN
1216: arp_standard.debug( ' pg_report_name '||pg_report_name);

Line 1216: arp_standard.debug( ' pg_report_name '||pg_report_name);

1212: pg_label := ARP_STANDARD.fnd_message(pg_rep_type||'_LABEL');
1213: END IF;
1214:
1215: IF PG_DEBUG in ('Y', 'C') THEN
1216: arp_standard.debug( ' pg_report_name '||pg_report_name);
1217: arp_standard.debug( ' pg_segment_label '||pg_segment_label);
1218: arp_standard.debug( ' pg_bal_label '||pg_bal_label);
1219: arp_standard.debug( ' pg_label_1 '||pg_label_1);
1220: arp_standard.debug( ' pg_sort_on '||pg_sort_on);

Line 1217: arp_standard.debug( ' pg_segment_label '||pg_segment_label);

1213: END IF;
1214:
1215: IF PG_DEBUG in ('Y', 'C') THEN
1216: arp_standard.debug( ' pg_report_name '||pg_report_name);
1217: arp_standard.debug( ' pg_segment_label '||pg_segment_label);
1218: arp_standard.debug( ' pg_bal_label '||pg_bal_label);
1219: arp_standard.debug( ' pg_label_1 '||pg_label_1);
1220: arp_standard.debug( ' pg_sort_on '||pg_sort_on);
1221: arp_standard.debug( ' pg_grand_total '||pg_grand_total);

Line 1218: arp_standard.debug( ' pg_bal_label '||pg_bal_label);

1214:
1215: IF PG_DEBUG in ('Y', 'C') THEN
1216: arp_standard.debug( ' pg_report_name '||pg_report_name);
1217: arp_standard.debug( ' pg_segment_label '||pg_segment_label);
1218: arp_standard.debug( ' pg_bal_label '||pg_bal_label);
1219: arp_standard.debug( ' pg_label_1 '||pg_label_1);
1220: arp_standard.debug( ' pg_sort_on '||pg_sort_on);
1221: arp_standard.debug( ' pg_grand_total '||pg_grand_total);
1222: arp_standard.debug( ' pg_label '||pg_label);

Line 1219: arp_standard.debug( ' pg_label_1 '||pg_label_1);

1215: IF PG_DEBUG in ('Y', 'C') THEN
1216: arp_standard.debug( ' pg_report_name '||pg_report_name);
1217: arp_standard.debug( ' pg_segment_label '||pg_segment_label);
1218: arp_standard.debug( ' pg_bal_label '||pg_bal_label);
1219: arp_standard.debug( ' pg_label_1 '||pg_label_1);
1220: arp_standard.debug( ' pg_sort_on '||pg_sort_on);
1221: arp_standard.debug( ' pg_grand_total '||pg_grand_total);
1222: arp_standard.debug( ' pg_label '||pg_label);
1223: END IF;

Line 1220: arp_standard.debug( ' pg_sort_on '||pg_sort_on);

1216: arp_standard.debug( ' pg_report_name '||pg_report_name);
1217: arp_standard.debug( ' pg_segment_label '||pg_segment_label);
1218: arp_standard.debug( ' pg_bal_label '||pg_bal_label);
1219: arp_standard.debug( ' pg_label_1 '||pg_label_1);
1220: arp_standard.debug( ' pg_sort_on '||pg_sort_on);
1221: arp_standard.debug( ' pg_grand_total '||pg_grand_total);
1222: arp_standard.debug( ' pg_label '||pg_label);
1223: END IF;
1224:

Line 1221: arp_standard.debug( ' pg_grand_total '||pg_grand_total);

1217: arp_standard.debug( ' pg_segment_label '||pg_segment_label);
1218: arp_standard.debug( ' pg_bal_label '||pg_bal_label);
1219: arp_standard.debug( ' pg_label_1 '||pg_label_1);
1220: arp_standard.debug( ' pg_sort_on '||pg_sort_on);
1221: arp_standard.debug( ' pg_grand_total '||pg_grand_total);
1222: arp_standard.debug( ' pg_label '||pg_label);
1223: END IF;
1224:
1225: populate_setup_information;

Line 1222: arp_standard.debug( ' pg_label '||pg_label);

1218: arp_standard.debug( ' pg_bal_label '||pg_bal_label);
1219: arp_standard.debug( ' pg_label_1 '||pg_label_1);
1220: arp_standard.debug( ' pg_sort_on '||pg_sort_on);
1221: arp_standard.debug( ' pg_grand_total '||pg_grand_total);
1222: arp_standard.debug( ' pg_label '||pg_label);
1223: END IF;
1224:
1225: populate_setup_information;
1226:

Line 1237: arp_standard.debug( ' pg_short_unid_phrase :'||pg_short_unid_phrase);

1233: pg_risk_meaning := rtrim(rpad(ARPT_SQL_FUNC_UTIL.get_lookup_meaning
1234: ('MISC_PHRASES','RISK'),20));
1235:
1236: IF PG_DEBUG in ('Y', 'C') THEN
1237: arp_standard.debug( ' pg_short_unid_phrase :'||pg_short_unid_phrase);
1238: arp_standard.debug( ' pg_payment_meaning :'||pg_payment_meaning);
1239: arp_standard.debug( ' pg_risk_meaning :'||pg_risk_meaning);
1240: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()-');
1241: END IF;

Line 1238: arp_standard.debug( ' pg_payment_meaning :'||pg_payment_meaning);

1234: ('MISC_PHRASES','RISK'),20));
1235:
1236: IF PG_DEBUG in ('Y', 'C') THEN
1237: arp_standard.debug( ' pg_short_unid_phrase :'||pg_short_unid_phrase);
1238: arp_standard.debug( ' pg_payment_meaning :'||pg_payment_meaning);
1239: arp_standard.debug( ' pg_risk_meaning :'||pg_risk_meaning);
1240: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()-');
1241: END IF;
1242:

Line 1239: arp_standard.debug( ' pg_risk_meaning :'||pg_risk_meaning);

1235:
1236: IF PG_DEBUG in ('Y', 'C') THEN
1237: arp_standard.debug( ' pg_short_unid_phrase :'||pg_short_unid_phrase);
1238: arp_standard.debug( ' pg_payment_meaning :'||pg_payment_meaning);
1239: arp_standard.debug( ' pg_risk_meaning :'||pg_risk_meaning);
1240: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()-');
1241: END IF;
1242:
1243: EXCEPTION

Line 1240: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()-');

1236: IF PG_DEBUG in ('Y', 'C') THEN
1237: arp_standard.debug( ' pg_short_unid_phrase :'||pg_short_unid_phrase);
1238: arp_standard.debug( ' pg_payment_meaning :'||pg_payment_meaning);
1239: arp_standard.debug( ' pg_risk_meaning :'||pg_risk_meaning);
1240: arp_standard.debug( ' AR_AGING_BUCKETS_PKG.initialize_package_globals()-');
1241: END IF;
1242:
1243: EXCEPTION
1244: WHEN OTHERS THEN

Line 1245: arp_standard.debug( ' Exception '||SQLERRM);

1241: END IF;
1242:
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: arp_standard.debug( ' Exception '||SQLERRM);
1246: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.initialize_package_globals()');
1247: RAISE;
1248: END initialize_package_globals;
1249:

Line 1246: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.initialize_package_globals()');

1242:
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: arp_standard.debug( ' Exception '||SQLERRM);
1246: arp_standard.debug( ' Exception AR_AGING_BUCKETS_PKG.initialize_package_globals()');
1247: RAISE;
1248: END initialize_package_globals;
1249:
1250:

Line 1274: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.cleanup_staging_tables()+');

1270: *==========================================================================*/
1271: PROCEDURE cleanup_staging_tables IS
1272: BEGIN
1273: IF PG_DEBUG in ('Y', 'C') THEN
1274: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.cleanup_staging_tables()+');
1275: arp_standard.debug( 'pg_retain_staging_flag :'||pg_retain_staging_flag );
1276: END IF;
1277:
1278: DELETE

Line 1275: arp_standard.debug( 'pg_retain_staging_flag :'||pg_retain_staging_flag );

1271: PROCEDURE cleanup_staging_tables IS
1272: BEGIN
1273: IF PG_DEBUG in ('Y', 'C') THEN
1274: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.cleanup_staging_tables()+');
1275: arp_standard.debug( 'pg_retain_staging_flag :'||pg_retain_staging_flag );
1276: END IF;
1277:
1278: DELETE
1279: FROM ar_aging_payment_schedules

Line 1291: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.cleanup_staging_tables()-');

1287: FROM ar_aging_mfar_extract
1288: WHERE parent_request_id = pg_request_id;
1289:
1290: IF PG_DEBUG in ('Y', 'C') THEN
1291: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.cleanup_staging_tables()-');
1292: END IF;
1293: END cleanup_staging_tables;
1294:
1295:

Line 1339: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()+');

1335: l_stmt_cursor INTEGER;
1336: l_rows_processed NUMBER;
1337: BEGIN
1338: IF PG_DEBUG in ('Y', 'C') THEN
1339: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()+');
1340: END IF;
1341:
1342: IF PG_DEBUG in ('Y', 'C') THEN
1343: arp_standard.debug( 'Deleting existing data for parent_request_id:'||pg_request_id);

Line 1343: arp_standard.debug( 'Deleting existing data for parent_request_id:'||pg_request_id);

1339: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()+');
1340: END IF;
1341:
1342: IF PG_DEBUG in ('Y', 'C') THEN
1343: arp_standard.debug( 'Deleting existing data for parent_request_id:'||pg_request_id);
1344: END IF;
1345:
1346: --clean up the interim tables if there exists any data refering to current request
1347: cleanup_staging_tables;

Line 1492: arp_standard.debug( l_final_stmt );

1488: l_final_stmt := l_insert_stmt ||
1489: l_select_caluse ||
1490: l_from_clause ;
1491:
1492: arp_standard.debug( l_final_stmt );
1493:
1494: l_stmt_cursor := dbms_sql.open_cursor;
1495: dbms_sql.parse (l_stmt_cursor,l_final_stmt,dbms_sql.v7);
1496:

Line 1527: arp_standard.debug( 'rows inserted into staging table:'||l_rows_processed);

1523: COMMIT;
1524: END IF;
1525:
1526: IF PG_DEBUG in ('Y', 'C') THEN
1527: arp_standard.debug( 'rows inserted into staging table:'||l_rows_processed);
1528: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()-');
1529: END IF;
1530:
1531: EXCEPTION

Line 1528: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()-');

1524: END IF;
1525:
1526: IF PG_DEBUG in ('Y', 'C') THEN
1527: arp_standard.debug( 'rows inserted into staging table:'||l_rows_processed);
1528: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()-');
1529: END IF;
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN

Line 1533: arp_standard.debug( 'Exception : '||SQLERRM );

1529: END IF;
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: arp_standard.debug( 'Exception : '||SQLERRM );
1534: arp_standard.debug( 'In AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()-');
1535: RAISE;
1536: END alloc_aging_payment_schedules;
1537:

Line 1534: arp_standard.debug( 'In AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()-');

1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: arp_standard.debug( 'Exception : '||SQLERRM );
1534: arp_standard.debug( 'In AR_AGING_BUCKETS_PKG.alloc_aging_payment_schedules()-');
1535: RAISE;
1536: END alloc_aging_payment_schedules;
1537:
1538:

Line 1580: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()+');

1576: /*Only verified the flow related to aging by account report,need verify and replace the
1577: lexical parameters and test the complete flow when we decide to migrate all these
1578: reports(reports like ARXAGR ,ARXAGL and ARXAGS)*/
1579: IF PG_DEBUG in ('Y', 'C') THEN
1580: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()+');
1581: arp_standard.debug( 'p_qry_category '||p_qry_category);
1582: END IF;
1583:
1584: --report specific subquery

Line 1581: arp_standard.debug( 'p_qry_category '||p_qry_category);

1577: lexical parameters and test the complete flow when we decide to migrate all these
1578: reports(reports like ARXAGR ,ARXAGL and ARXAGS)*/
1579: IF PG_DEBUG in ('Y', 'C') THEN
1580: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()+');
1581: arp_standard.debug( 'p_qry_category '||p_qry_category);
1582: END IF;
1583:
1584: --report specific subquery
1585: IF pg_rep_type = 'ARXAGR' THEN

Line 1778: arp_standard.debug( 'p_rep_specific_cols '||p_rep_specific_cols );

1774: END IF;
1775:
1776:
1777: IF PG_DEBUG in ('Y', 'C') THEN
1778: arp_standard.debug( 'p_rep_specific_cols '||p_rep_specific_cols );
1779: arp_standard.debug( 'p_rep_from_info '||p_rep_from_info );
1780: arp_standard.debug( 'p_rep_where_cls '||p_rep_where_cls );
1781: arp_standard.debug( 'p_rep_spec_sub_query '||p_rep_spec_sub_query );
1782: arp_standard.debug( 'p_rep_spec_grp_cols '||p_rep_spec_grp_cols );

Line 1779: arp_standard.debug( 'p_rep_from_info '||p_rep_from_info );

1775:
1776:
1777: IF PG_DEBUG in ('Y', 'C') THEN
1778: arp_standard.debug( 'p_rep_specific_cols '||p_rep_specific_cols );
1779: arp_standard.debug( 'p_rep_from_info '||p_rep_from_info );
1780: arp_standard.debug( 'p_rep_where_cls '||p_rep_where_cls );
1781: arp_standard.debug( 'p_rep_spec_sub_query '||p_rep_spec_sub_query );
1782: arp_standard.debug( 'p_rep_spec_grp_cols '||p_rep_spec_grp_cols );
1783: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()-');

Line 1780: arp_standard.debug( 'p_rep_where_cls '||p_rep_where_cls );

1776:
1777: IF PG_DEBUG in ('Y', 'C') THEN
1778: arp_standard.debug( 'p_rep_specific_cols '||p_rep_specific_cols );
1779: arp_standard.debug( 'p_rep_from_info '||p_rep_from_info );
1780: arp_standard.debug( 'p_rep_where_cls '||p_rep_where_cls );
1781: arp_standard.debug( 'p_rep_spec_sub_query '||p_rep_spec_sub_query );
1782: arp_standard.debug( 'p_rep_spec_grp_cols '||p_rep_spec_grp_cols );
1783: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()-');
1784: END IF;

Line 1781: arp_standard.debug( 'p_rep_spec_sub_query '||p_rep_spec_sub_query );

1777: IF PG_DEBUG in ('Y', 'C') THEN
1778: arp_standard.debug( 'p_rep_specific_cols '||p_rep_specific_cols );
1779: arp_standard.debug( 'p_rep_from_info '||p_rep_from_info );
1780: arp_standard.debug( 'p_rep_where_cls '||p_rep_where_cls );
1781: arp_standard.debug( 'p_rep_spec_sub_query '||p_rep_spec_sub_query );
1782: arp_standard.debug( 'p_rep_spec_grp_cols '||p_rep_spec_grp_cols );
1783: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()-');
1784: END IF;
1785:

Line 1782: arp_standard.debug( 'p_rep_spec_grp_cols '||p_rep_spec_grp_cols );

1778: arp_standard.debug( 'p_rep_specific_cols '||p_rep_specific_cols );
1779: arp_standard.debug( 'p_rep_from_info '||p_rep_from_info );
1780: arp_standard.debug( 'p_rep_where_cls '||p_rep_where_cls );
1781: arp_standard.debug( 'p_rep_spec_sub_query '||p_rep_spec_sub_query );
1782: arp_standard.debug( 'p_rep_spec_grp_cols '||p_rep_spec_grp_cols );
1783: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()-');
1784: END IF;
1785:
1786: EXCEPTION

Line 1783: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()-');

1779: arp_standard.debug( 'p_rep_from_info '||p_rep_from_info );
1780: arp_standard.debug( 'p_rep_where_cls '||p_rep_where_cls );
1781: arp_standard.debug( 'p_rep_spec_sub_query '||p_rep_spec_sub_query );
1782: arp_standard.debug( 'p_rep_spec_grp_cols '||p_rep_spec_grp_cols );
1783: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.get_report_specific_info()-');
1784: END IF;
1785:
1786: EXCEPTION
1787: WHEN OTHERS THEN

Line 1788: arp_standard.debug( 'Exception '||SQLERRM);

1784: END IF;
1785:
1786: EXCEPTION
1787: WHEN OTHERS THEN
1788: arp_standard.debug( 'Exception '||SQLERRM);
1789: arp_standard.debug( 'Exception :AR_AGING_BUCKETS_PKG.get_report_specific_info()-');
1790: RAISE;
1791: END get_report_specific_info;
1792:

Line 1789: arp_standard.debug( 'Exception :AR_AGING_BUCKETS_PKG.get_report_specific_info()-');

1785:
1786: EXCEPTION
1787: WHEN OTHERS THEN
1788: arp_standard.debug( 'Exception '||SQLERRM);
1789: arp_standard.debug( 'Exception :AR_AGING_BUCKETS_PKG.get_report_specific_info()-');
1790: RAISE;
1791: END get_report_specific_info;
1792:
1793:

Line 1848: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.bind_bucket_parameters()+');

1844:
1845:
1846: BEGIN
1847: IF PG_DEBUG in ('Y', 'C') THEN
1848: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.bind_bucket_parameters()+');
1849: arp_standard.debug( 'p_cursor :'||p_cursor);
1850: END IF;
1851:
1852: FOR buc_rec IN buc_info_cur LOOP

Line 1849: arp_standard.debug( 'p_cursor :'||p_cursor);

1845:
1846: BEGIN
1847: IF PG_DEBUG in ('Y', 'C') THEN
1848: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.bind_bucket_parameters()+');
1849: arp_standard.debug( 'p_cursor :'||p_cursor);
1850: END IF;
1851:
1852: FOR buc_rec IN buc_info_cur LOOP
1853: IF PG_DEBUG in ('Y', 'C') THEN

Line 1854: arp_standard.debug( ':bucket_days_from_'||buc_rec.sequence_number||' value '||buc_rec.days_start);

1850: END IF;
1851:
1852: FOR buc_rec IN buc_info_cur LOOP
1853: IF PG_DEBUG in ('Y', 'C') THEN
1854: arp_standard.debug( ':bucket_days_from_'||buc_rec.sequence_number||' value '||buc_rec.days_start);
1855: arp_standard.debug( ':bucket_days_to_'||buc_rec.sequence_number||' value '||buc_rec.days_to);
1856: arp_standard.debug( ':bucket_line_type_'||buc_rec.sequence_number||' value '||buc_rec.type);
1857: arp_standard.debug( ':bucket_category_'||buc_rec.sequence_number||' value '||buc_rec.bucket_category);
1858: END IF;

Line 1855: arp_standard.debug( ':bucket_days_to_'||buc_rec.sequence_number||' value '||buc_rec.days_to);

1851:
1852: FOR buc_rec IN buc_info_cur LOOP
1853: IF PG_DEBUG in ('Y', 'C') THEN
1854: arp_standard.debug( ':bucket_days_from_'||buc_rec.sequence_number||' value '||buc_rec.days_start);
1855: arp_standard.debug( ':bucket_days_to_'||buc_rec.sequence_number||' value '||buc_rec.days_to);
1856: arp_standard.debug( ':bucket_line_type_'||buc_rec.sequence_number||' value '||buc_rec.type);
1857: arp_standard.debug( ':bucket_category_'||buc_rec.sequence_number||' value '||buc_rec.bucket_category);
1858: END IF;
1859:

Line 1856: arp_standard.debug( ':bucket_line_type_'||buc_rec.sequence_number||' value '||buc_rec.type);

1852: FOR buc_rec IN buc_info_cur LOOP
1853: IF PG_DEBUG in ('Y', 'C') THEN
1854: arp_standard.debug( ':bucket_days_from_'||buc_rec.sequence_number||' value '||buc_rec.days_start);
1855: arp_standard.debug( ':bucket_days_to_'||buc_rec.sequence_number||' value '||buc_rec.days_to);
1856: arp_standard.debug( ':bucket_line_type_'||buc_rec.sequence_number||' value '||buc_rec.type);
1857: arp_standard.debug( ':bucket_category_'||buc_rec.sequence_number||' value '||buc_rec.bucket_category);
1858: END IF;
1859:
1860: dbms_sql.bind_variable(p_cursor, ':bucket_days_from_'||buc_rec.sequence_number,

Line 1857: arp_standard.debug( ':bucket_category_'||buc_rec.sequence_number||' value '||buc_rec.bucket_category);

1853: IF PG_DEBUG in ('Y', 'C') THEN
1854: arp_standard.debug( ':bucket_days_from_'||buc_rec.sequence_number||' value '||buc_rec.days_start);
1855: arp_standard.debug( ':bucket_days_to_'||buc_rec.sequence_number||' value '||buc_rec.days_to);
1856: arp_standard.debug( ':bucket_line_type_'||buc_rec.sequence_number||' value '||buc_rec.type);
1857: arp_standard.debug( ':bucket_category_'||buc_rec.sequence_number||' value '||buc_rec.bucket_category);
1858: END IF;
1859:
1860: dbms_sql.bind_variable(p_cursor, ':bucket_days_from_'||buc_rec.sequence_number,
1861: buc_rec.days_start);

Line 1872: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.bind_bucket_parameters()-');

1868: END LOOP;
1869:
1870:
1871: IF PG_DEBUG in ('Y', 'C') THEN
1872: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.bind_bucket_parameters()-');
1873: END IF;
1874:
1875: EXCEPTION
1876: WHEN OTHERS THEN

Line 1877: arp_standard.debug( 'Exception '||SQLERRM);

1873: END IF;
1874:
1875: EXCEPTION
1876: WHEN OTHERS THEN
1877: arp_standard.debug( 'Exception '||SQLERRM);
1878: arp_standard.debug( 'EXception AR_AGING_BUCKETS_PKG.bind_bucket_parameters()');
1879: RAISE;
1880: END bind_bucket_parameters;
1881:

Line 1878: arp_standard.debug( 'EXception AR_AGING_BUCKETS_PKG.bind_bucket_parameters()');

1874:
1875: EXCEPTION
1876: WHEN OTHERS THEN
1877: arp_standard.debug( 'Exception '||SQLERRM);
1878: arp_standard.debug( 'EXception AR_AGING_BUCKETS_PKG.bind_bucket_parameters()');
1879: RAISE;
1880: END bind_bucket_parameters;
1881:
1882:

Line 1913: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()+');

1909: l_insert_stmt VARCHAR2(32000);
1910:
1911: BEGIN
1912: IF PG_DEBUG in ('Y', 'C') THEN
1913: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()+');
1914: arp_standard.debug( 'p_qry_category :'||p_qry_category);
1915: END IF;
1916:
1917: l_insert_stmt := '

Line 1914: arp_standard.debug( 'p_qry_category :'||p_qry_category);

1910:
1911: BEGIN
1912: IF PG_DEBUG in ('Y', 'C') THEN
1913: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()+');
1914: arp_standard.debug( 'p_qry_category :'||p_qry_category);
1915: END IF;
1916:
1917: l_insert_stmt := '
1918: insert into ar_aging_extract

Line 2000: arp_standard.debug( 'as_of_date '||pg_in_as_of_date_low);

1996:
1997: l_cursor := dbms_sql.open_cursor;
1998:
1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_standard.debug( 'as_of_date '||pg_in_as_of_date_low);
2001: arp_standard.debug( 'pg_rep_type '||pg_rep_type);
2002: arp_standard.debug( 'pg_in_format_option_low '||pg_in_format_option_low);
2003: arp_standard.debug( 'pg_convert_flag '||pg_convert_flag);
2004: arp_standard.debug( 'pg_functional_currency '||pg_functional_currency);

Line 2001: arp_standard.debug( 'pg_rep_type '||pg_rep_type);

1997: l_cursor := dbms_sql.open_cursor;
1998:
1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_standard.debug( 'as_of_date '||pg_in_as_of_date_low);
2001: arp_standard.debug( 'pg_rep_type '||pg_rep_type);
2002: arp_standard.debug( 'pg_in_format_option_low '||pg_in_format_option_low);
2003: arp_standard.debug( 'pg_convert_flag '||pg_convert_flag);
2004: arp_standard.debug( 'pg_functional_currency '||pg_functional_currency);
2005: arp_standard.debug( 'worker_id '||pg_worker_id);

Line 2002: arp_standard.debug( 'pg_in_format_option_low '||pg_in_format_option_low);

1998:
1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_standard.debug( 'as_of_date '||pg_in_as_of_date_low);
2001: arp_standard.debug( 'pg_rep_type '||pg_rep_type);
2002: arp_standard.debug( 'pg_in_format_option_low '||pg_in_format_option_low);
2003: arp_standard.debug( 'pg_convert_flag '||pg_convert_flag);
2004: arp_standard.debug( 'pg_functional_currency '||pg_functional_currency);
2005: arp_standard.debug( 'worker_id '||pg_worker_id);
2006: arp_standard.debug( 'pg_parent_request_id '||pg_parent_request_id);

Line 2003: arp_standard.debug( 'pg_convert_flag '||pg_convert_flag);

1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_standard.debug( 'as_of_date '||pg_in_as_of_date_low);
2001: arp_standard.debug( 'pg_rep_type '||pg_rep_type);
2002: arp_standard.debug( 'pg_in_format_option_low '||pg_in_format_option_low);
2003: arp_standard.debug( 'pg_convert_flag '||pg_convert_flag);
2004: arp_standard.debug( 'pg_functional_currency '||pg_functional_currency);
2005: arp_standard.debug( 'worker_id '||pg_worker_id);
2006: arp_standard.debug( 'pg_parent_request_id '||pg_parent_request_id);
2007: END IF;

Line 2004: arp_standard.debug( 'pg_functional_currency '||pg_functional_currency);

2000: arp_standard.debug( 'as_of_date '||pg_in_as_of_date_low);
2001: arp_standard.debug( 'pg_rep_type '||pg_rep_type);
2002: arp_standard.debug( 'pg_in_format_option_low '||pg_in_format_option_low);
2003: arp_standard.debug( 'pg_convert_flag '||pg_convert_flag);
2004: arp_standard.debug( 'pg_functional_currency '||pg_functional_currency);
2005: arp_standard.debug( 'worker_id '||pg_worker_id);
2006: arp_standard.debug( 'pg_parent_request_id '||pg_parent_request_id);
2007: END IF;
2008:

Line 2005: arp_standard.debug( 'worker_id '||pg_worker_id);

2001: arp_standard.debug( 'pg_rep_type '||pg_rep_type);
2002: arp_standard.debug( 'pg_in_format_option_low '||pg_in_format_option_low);
2003: arp_standard.debug( 'pg_convert_flag '||pg_convert_flag);
2004: arp_standard.debug( 'pg_functional_currency '||pg_functional_currency);
2005: arp_standard.debug( 'worker_id '||pg_worker_id);
2006: arp_standard.debug( 'pg_parent_request_id '||pg_parent_request_id);
2007: END IF;
2008:
2009:

Line 2006: arp_standard.debug( 'pg_parent_request_id '||pg_parent_request_id);

2002: arp_standard.debug( 'pg_in_format_option_low '||pg_in_format_option_low);
2003: arp_standard.debug( 'pg_convert_flag '||pg_convert_flag);
2004: arp_standard.debug( 'pg_functional_currency '||pg_functional_currency);
2005: arp_standard.debug( 'worker_id '||pg_worker_id);
2006: arp_standard.debug( 'pg_parent_request_id '||pg_parent_request_id);
2007: END IF;
2008:
2009:
2010: dbms_sql.parse(l_cursor,l_insert_stmt||p_in_report_query||')',DBMS_SQL.NATIVE);

Line 2030: arp_standard.debug( 'Rows Processed '||l_rows_processed);

2026:
2027: l_rows_processed := dbms_sql.execute(l_cursor);
2028:
2029: IF PG_DEBUG in ('Y', 'C') THEN
2030: arp_standard.debug( 'Rows Processed '||l_rows_processed);
2031: END IF;
2032:
2033: IF PG_DEBUG in ('Y', 'C') THEN
2034: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()-');

Line 2034: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()-');

2030: arp_standard.debug( 'Rows Processed '||l_rows_processed);
2031: END IF;
2032:
2033: IF PG_DEBUG in ('Y', 'C') THEN
2034: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()-');
2035: END IF;
2036:
2037: EXCEPTION
2038: WHEN OTHERS THEN

Line 2039: arp_standard.debug( 'Exception '||SQLERRM);

2035: END IF;
2036:
2037: EXCEPTION
2038: WHEN OTHERS THEN
2039: arp_standard.debug( 'Exception '||SQLERRM);
2040: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()-');
2041: RAISE;
2042: END extract_aging_information;
2043:

Line 2040: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()-');

2036:
2037: EXCEPTION
2038: WHEN OTHERS THEN
2039: arp_standard.debug( 'Exception '||SQLERRM);
2040: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.extract_aging_information()-');
2041: RAISE;
2042: END extract_aging_information;
2043:
2044:

Line 2083: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.build_select_stmt()+');

2079: l_accting_source VARCHAR2(30);
2080:
2081: BEGIN
2082: IF PG_DEBUG in ('Y', 'C') THEN
2083: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.build_select_stmt()+');
2084: END IF;
2085:
2086: get_report_specific_info( p_qry_category => AR_AGING_CTGRY_INVOICE,
2087: p_rep_specific_cols => l_rep_specific_cols,

Line 2701: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.build_select_stmt()-');

2697: and dist2.amount_dr is not null
2698: and th2.customer_trx_id = ps.customer_trx_id)';
2699:
2700: IF PG_DEBUG in ('Y', 'C') THEN
2701: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.build_select_stmt()-');
2702: END IF;
2703:
2704: EXCEPTION
2705: WHEN OTHERS THEN

Line 2707: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.build_select_stmt()');

2703:
2704: EXCEPTION
2705: WHEN OTHERS THEN
2706: IF PG_DEBUG in ('Y', 'C') THEN
2707: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.build_select_stmt()');
2708: arp_standard.debug( 'Exception message '||SQLERRM);
2709: END IF;
2710: RAISE;
2711: END build_select_stmt;

Line 2708: arp_standard.debug( 'Exception message '||SQLERRM);

2704: EXCEPTION
2705: WHEN OTHERS THEN
2706: IF PG_DEBUG in ('Y', 'C') THEN
2707: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.build_select_stmt()');
2708: arp_standard.debug( 'Exception message '||SQLERRM);
2709: END IF;
2710: RAISE;
2711: END build_select_stmt;
2712:

Line 2861: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()+');

2857: l_pror_identifier NUMBER(15);
2858:
2859: BEGIN
2860: IF PG_DEBUG in ('Y', 'C') THEN
2861: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()+');
2862: arp_standard.debug( 'p_category '||p_category);
2863: END IF;
2864:
2865: OPEN aging_ps_cur;

Line 2862: arp_standard.debug( 'p_category '||p_category);

2858:
2859: BEGIN
2860: IF PG_DEBUG in ('Y', 'C') THEN
2861: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()+');
2862: arp_standard.debug( 'p_category '||p_category);
2863: END IF;
2864:
2865: OPEN aging_ps_cur;
2866:

Line 2871: arp_standard.debug( 'current fetch count '|| l_aging_mfar_tab.count);

2867: LOOP
2868: FETCH aging_ps_cur BULK COLLECT INTO l_aging_mfar_tab LIMIT MAX_ARRAY_SIZE;
2869:
2870: IF PG_DEBUG in ('Y', 'C') THEN
2871: arp_standard.debug( 'current fetch count '|| l_aging_mfar_tab.count);
2872: END IF;
2873:
2874: EXIT WHEN l_aging_mfar_tab.count = 0;
2875:

Line 2898: arp_standard.debug('l_alloc_amt '|| l_alloc_amt);

2894: l_run_alloc_tot := l_run_alloc_tot + l_alloc_amt;
2895: END IF;
2896:
2897: IF PG_DEBUG in ('Y', 'C') THEN
2898: arp_standard.debug('l_alloc_amt '|| l_alloc_amt);
2899: arp_standard.debug('l_run_alloc_tot '|| l_run_alloc_tot);
2900: arp_standard.debug('l_run_rec_tot '|| l_run_rec_tot);
2901: arp_standard.debug('l_pror_identifier '|| l_pror_identifier);
2902: arp_standard.debug('payment_schedule_id '|| l_aging_mfar_tab(i).payment_schedule_id);

Line 2899: arp_standard.debug('l_run_alloc_tot '|| l_run_alloc_tot);

2895: END IF;
2896:
2897: IF PG_DEBUG in ('Y', 'C') THEN
2898: arp_standard.debug('l_alloc_amt '|| l_alloc_amt);
2899: arp_standard.debug('l_run_alloc_tot '|| l_run_alloc_tot);
2900: arp_standard.debug('l_run_rec_tot '|| l_run_rec_tot);
2901: arp_standard.debug('l_pror_identifier '|| l_pror_identifier);
2902: arp_standard.debug('payment_schedule_id '|| l_aging_mfar_tab(i).payment_schedule_id);
2903: END IF;

Line 2900: arp_standard.debug('l_run_rec_tot '|| l_run_rec_tot);

2896:
2897: IF PG_DEBUG in ('Y', 'C') THEN
2898: arp_standard.debug('l_alloc_amt '|| l_alloc_amt);
2899: arp_standard.debug('l_run_alloc_tot '|| l_run_alloc_tot);
2900: arp_standard.debug('l_run_rec_tot '|| l_run_rec_tot);
2901: arp_standard.debug('l_pror_identifier '|| l_pror_identifier);
2902: arp_standard.debug('payment_schedule_id '|| l_aging_mfar_tab(i).payment_schedule_id);
2903: END IF;
2904:

Line 2901: arp_standard.debug('l_pror_identifier '|| l_pror_identifier);

2897: IF PG_DEBUG in ('Y', 'C') THEN
2898: arp_standard.debug('l_alloc_amt '|| l_alloc_amt);
2899: arp_standard.debug('l_run_alloc_tot '|| l_run_alloc_tot);
2900: arp_standard.debug('l_run_rec_tot '|| l_run_rec_tot);
2901: arp_standard.debug('l_pror_identifier '|| l_pror_identifier);
2902: arp_standard.debug('payment_schedule_id '|| l_aging_mfar_tab(i).payment_schedule_id);
2903: END IF;
2904:
2905: END LOOP;

Line 2902: arp_standard.debug('payment_schedule_id '|| l_aging_mfar_tab(i).payment_schedule_id);

2898: arp_standard.debug('l_alloc_amt '|| l_alloc_amt);
2899: arp_standard.debug('l_run_alloc_tot '|| l_run_alloc_tot);
2900: arp_standard.debug('l_run_rec_tot '|| l_run_rec_tot);
2901: arp_standard.debug('l_pror_identifier '|| l_pror_identifier);
2902: arp_standard.debug('payment_schedule_id '|| l_aging_mfar_tab(i).payment_schedule_id);
2903: END IF;
2904:
2905: END LOOP;
2906:

Line 2915: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()-');

2911: EXIT WHEN aging_ps_cur%NOTFOUND;
2912: END LOOP;
2913:
2914: IF PG_DEBUG in ('Y', 'C') THEN
2915: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()-');
2916: END IF;
2917:
2918: EXCEPTION
2919: WHEN OTHERS THEN

Line 2921: arp_standard.debug( 'Exception message '||SQLERRM);

2917:
2918: EXCEPTION
2919: WHEN OTHERS THEN
2920: IF PG_DEBUG in ('Y', 'C') THEN
2921: arp_standard.debug( 'Exception message '||SQLERRM);
2922: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()');
2923: END IF;
2924: RAISE;
2925: END prorate_aging_balances_mfar;

Line 2922: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()');

2918: EXCEPTION
2919: WHEN OTHERS THEN
2920: IF PG_DEBUG in ('Y', 'C') THEN
2921: arp_standard.debug( 'Exception message '||SQLERRM);
2922: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.prorate_aging_balances_mfar()');
2923: END IF;
2924: RAISE;
2925: END prorate_aging_balances_mfar;
2926:

Line 2972: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.generate_xml()+');

2968: l_alter_str VARCHAR2(100);
2969:
2970: BEGIN
2971: IF PG_DEBUG in ('Y', 'C') THEN
2972: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.generate_xml()+');
2973: print_clob(p_extract_query);
2974: END IF;
2975:
2976: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);

Line 2980: arp_standard.debug( 'l_version :'||l_version);

2976: DBMS_UTILITY.DB_VERSION(l_version, l_compatibility);
2977: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
2978:
2979: IF PG_DEBUG in ('Y', 'C') THEN
2980: arp_standard.debug( 'l_version :'||l_version);
2981: arp_standard.debug( 'l_compatibility :'||l_compatibility);
2982: arp_standard.debug( 'l_majorVersion :'||l_majorVersion);
2983: END IF;
2984:

Line 2981: arp_standard.debug( 'l_compatibility :'||l_compatibility);

2977: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
2978:
2979: IF PG_DEBUG in ('Y', 'C') THEN
2980: arp_standard.debug( 'l_version :'||l_version);
2981: arp_standard.debug( 'l_compatibility :'||l_compatibility);
2982: arp_standard.debug( 'l_majorVersion :'||l_majorVersion);
2983: END IF;
2984:
2985: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN

Line 2982: arp_standard.debug( 'l_majorVersion :'||l_majorVersion);

2978:
2979: IF PG_DEBUG in ('Y', 'C') THEN
2980: arp_standard.debug( 'l_version :'||l_version);
2981: arp_standard.debug( 'l_compatibility :'||l_compatibility);
2982: arp_standard.debug( 'l_majorVersion :'||l_majorVersion);
2983: END IF;
2984:
2985: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
2986:

Line 2992: arp_standard.debug( 'Query context set.call to getXML...');

2988: queryCtx := DBMS_XMLQuery.newContext( p_extract_query );
2989: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
2990:
2991: IF PG_DEBUG in ('Y', 'C') THEN
2992: arp_standard.debug( 'Query context set.call to getXML...');
2993: END IF;
2994:
2995: l_result := DBMS_XMLQuery.getXML(queryCtx);
2996: DBMS_XMLQuery.closeContext(queryCtx);

Line 3003: arp_standard.debug( 'l_errNo '||l_errNo);

2999:
3000: EXCEPTION WHEN OTHERS THEN
3001: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
3002: IF PG_DEBUG in ('Y', 'C') THEN
3003: arp_standard.debug( 'l_errNo '||l_errNo);
3004: END IF;
3005:
3006: IF l_errNo = 1403 THEN
3007: l_rows_processed := 0;

Line 3051: arp_standard.debug( 'Query context set.call to getXML...');

3047: END IF;
3048:
3049: qryCtx := DBMS_XMLGEN.newContext(p_extract_query);
3050: IF PG_DEBUG in ('Y', 'C') THEN
3051: arp_standard.debug( 'Query context set.call to getXML...');
3052: END IF;
3053:
3054: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
3055: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

Line 3066: arp_standard.debug( 'l_rows_processed '||l_rows_processed);

3062: EXECUTE IMMEDIATE l_alter_str;
3063: END IF;
3064:
3065: IF PG_DEBUG in ('Y', 'C') THEN
3066: arp_standard.debug( 'l_rows_processed '||l_rows_processed);
3067: END IF;
3068:
3069: IF l_rows_processed <> 0 THEN
3070: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

Line 3095: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.generate_xml()-');

3091:
3092: ar_cumulative_balance_report.process_clob(tempResult);
3093:
3094: IF PG_DEBUG in ('Y', 'C') THEN
3095: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.generate_xml()-');
3096: END IF;
3097:
3098: EXCEPTION
3099: WHEN OTHERS THEN

Line 3107: arp_standard.debug( 'Exception message '||SQLERRM);

3103: EXECUTE IMMEDIATE l_alter_str;
3104: END IF;
3105:
3106: IF PG_DEBUG in ('Y', 'C') THEN
3107: arp_standard.debug( 'Exception message '||SQLERRM);
3108: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.generate_xml()');
3109: END IF;
3110: RAISE;
3111: END generate_xml;

Line 3108: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.generate_xml()');

3104: END IF;
3105:
3106: IF PG_DEBUG in ('Y', 'C') THEN
3107: arp_standard.debug( 'Exception message '||SQLERRM);
3108: arp_standard.debug( 'Exception AR_AGING_BUCKETS_PKG.generate_xml()');
3109: END IF;
3110: RAISE;
3111: END generate_xml;
3112:

Line 3166: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_rep_extract()+');

3162: p_retain_staging_flag IN VARCHAR2 DEFAULT NULL) IS
3163: BEGIN
3164:
3165: IF PG_DEBUG in ('Y', 'C') THEN
3166: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_rep_extract()+');
3167: arp_standard.debug( 'invoking procedure aging_seven_buckets..');
3168: END IF;
3169:
3170: aging_seven_buckets( p_rep_type => p_rep_type,

Line 3167: arp_standard.debug( 'invoking procedure aging_seven_buckets..');

3163: BEGIN
3164:
3165: IF PG_DEBUG in ('Y', 'C') THEN
3166: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_rep_extract()+');
3167: arp_standard.debug( 'invoking procedure aging_seven_buckets..');
3168: END IF;
3169:
3170: aging_seven_buckets( p_rep_type => p_rep_type,
3171: p_reporting_level => p_reporting_level,

Line 3198: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_rep_extract()-');

3194: p_retain_staging_flag => p_retain_staging_flag,
3195: p_master_req_flag => 'N');
3196:
3197: IF PG_DEBUG in ('Y', 'C') THEN
3198: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_rep_extract()-');
3199: END IF;
3200: END aging_rep_extract;
3201:
3202:

Line 3263: arp_standard.debug( 'submit_subrequest()+');

3259:
3260: PROCEDURE submit_subrequest ( p_worker_number IN NUMBER ) IS
3261: l_request_id NUMBER;
3262: BEGIN
3263: arp_standard.debug( 'submit_subrequest()+');
3264:
3265: l_request_id := FND_REQUEST.submit_request( 'AR', 'ARXAGEXT',
3266: '',
3267: SYSDATE,

Line 3296: arp_standard.debug( 'can not start for worker_id: ' ||p_worker_number );

3292: to_char(pg_worker_count));
3293:
3294:
3295: IF (l_request_id = 0) THEN
3296: arp_standard.debug( 'can not start for worker_id: ' ||p_worker_number );
3297: arp_standard.debug( 'Error Message ' ||fnd_Message.get );
3298: return;
3299: ELSE
3300: commit;

Line 3297: arp_standard.debug( 'Error Message ' ||fnd_Message.get );

3293:
3294:
3295: IF (l_request_id = 0) THEN
3296: arp_standard.debug( 'can not start for worker_id: ' ||p_worker_number );
3297: arp_standard.debug( 'Error Message ' ||fnd_Message.get );
3298: return;
3299: ELSE
3300: commit;
3301: arp_standard.debug( 'child request id: ' ||l_request_id ||

Line 3301: arp_standard.debug( 'child request id: ' ||l_request_id ||

3297: arp_standard.debug( 'Error Message ' ||fnd_Message.get );
3298: return;
3299: ELSE
3300: commit;
3301: arp_standard.debug( 'child request id: ' ||l_request_id ||
3302: ' started for worker_id: ' ||p_worker_number );
3303: END IF;
3304:
3305: pg_req_status_tab(p_worker_number).request_id := l_request_id;

Line 3306: arp_standard.debug( 'submit_subrequest()-');

3302: ' started for worker_id: ' ||p_worker_number );
3303: END IF;
3304:
3305: pg_req_status_tab(p_worker_number).request_id := l_request_id;
3306: arp_standard.debug( 'submit_subrequest()-');
3307:
3308: END submit_subrequest;
3309:
3310: BEGIN

Line 3312: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_seven_buckets()+');

3308: END submit_subrequest;
3309:
3310: BEGIN
3311: IF PG_DEBUG in ('Y', 'C') THEN
3312: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_seven_buckets()+');
3313: arp_standard.debug( 'p_rep_type '|| p_rep_type);
3314: arp_standard.debug( 'p_reporting_level '|| p_reporting_level);
3315: arp_standard.debug( 'p_reporting_entity_id '|| p_reporting_entity_id);
3316: arp_standard.debug( 'p_coaid '|| p_coaid);

Line 3313: arp_standard.debug( 'p_rep_type '|| p_rep_type);

3309:
3310: BEGIN
3311: IF PG_DEBUG in ('Y', 'C') THEN
3312: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_seven_buckets()+');
3313: arp_standard.debug( 'p_rep_type '|| p_rep_type);
3314: arp_standard.debug( 'p_reporting_level '|| p_reporting_level);
3315: arp_standard.debug( 'p_reporting_entity_id '|| p_reporting_entity_id);
3316: arp_standard.debug( 'p_coaid '|| p_coaid);
3317: arp_standard.debug( 'p_in_bal_segment_low '|| p_in_bal_segment_low);

Line 3314: arp_standard.debug( 'p_reporting_level '|| p_reporting_level);

3310: BEGIN
3311: IF PG_DEBUG in ('Y', 'C') THEN
3312: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_seven_buckets()+');
3313: arp_standard.debug( 'p_rep_type '|| p_rep_type);
3314: arp_standard.debug( 'p_reporting_level '|| p_reporting_level);
3315: arp_standard.debug( 'p_reporting_entity_id '|| p_reporting_entity_id);
3316: arp_standard.debug( 'p_coaid '|| p_coaid);
3317: arp_standard.debug( 'p_in_bal_segment_low '|| p_in_bal_segment_low);
3318: arp_standard.debug( 'p_in_bal_segment_high '|| p_in_bal_segment_high);

Line 3315: arp_standard.debug( 'p_reporting_entity_id '|| p_reporting_entity_id);

3311: IF PG_DEBUG in ('Y', 'C') THEN
3312: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_seven_buckets()+');
3313: arp_standard.debug( 'p_rep_type '|| p_rep_type);
3314: arp_standard.debug( 'p_reporting_level '|| p_reporting_level);
3315: arp_standard.debug( 'p_reporting_entity_id '|| p_reporting_entity_id);
3316: arp_standard.debug( 'p_coaid '|| p_coaid);
3317: arp_standard.debug( 'p_in_bal_segment_low '|| p_in_bal_segment_low);
3318: arp_standard.debug( 'p_in_bal_segment_high '|| p_in_bal_segment_high);
3319: arp_standard.debug( 'p_in_as_of_date_low '|| p_in_as_of_date_low);

Line 3316: arp_standard.debug( 'p_coaid '|| p_coaid);

3312: arp_standard.debug( 'AR_AGING_BUCKETS_PKG.aging_seven_buckets()+');
3313: arp_standard.debug( 'p_rep_type '|| p_rep_type);
3314: arp_standard.debug( 'p_reporting_level '|| p_reporting_level);
3315: arp_standard.debug( 'p_reporting_entity_id '|| p_reporting_entity_id);
3316: arp_standard.debug( 'p_coaid '|| p_coaid);
3317: arp_standard.debug( 'p_in_bal_segment_low '|| p_in_bal_segment_low);
3318: arp_standard.debug( 'p_in_bal_segment_high '|| p_in_bal_segment_high);
3319: arp_standard.debug( 'p_in_as_of_date_low '|| p_in_as_of_date_low);
3320: arp_standard.debug( 'p_in_summary_option_low '|| p_in_summary_option_low);

Line 3317: arp_standard.debug( 'p_in_bal_segment_low '|| p_in_bal_segment_low);

3313: arp_standard.debug( 'p_rep_type '|| p_rep_type);
3314: arp_standard.debug( 'p_reporting_level '|| p_reporting_level);
3315: arp_standard.debug( 'p_reporting_entity_id '|| p_reporting_entity_id);
3316: arp_standard.debug( 'p_coaid '|| p_coaid);
3317: arp_standard.debug( 'p_in_bal_segment_low '|| p_in_bal_segment_low);
3318: arp_standard.debug( 'p_in_bal_segment_high '|| p_in_bal_segment_high);
3319: arp_standard.debug( 'p_in_as_of_date_low '|| p_in_as_of_date_low);
3320: arp_standard.debug( 'p_in_summary_option_low '|| p_in_summary_option_low);
3321: arp_standard.debug( 'p_in_format_option_low '|| p_in_format_option_low);

Line 3318: arp_standard.debug( 'p_in_bal_segment_high '|| p_in_bal_segment_high);

3314: arp_standard.debug( 'p_reporting_level '|| p_reporting_level);
3315: arp_standard.debug( 'p_reporting_entity_id '|| p_reporting_entity_id);
3316: arp_standard.debug( 'p_coaid '|| p_coaid);
3317: arp_standard.debug( 'p_in_bal_segment_low '|| p_in_bal_segment_low);
3318: arp_standard.debug( 'p_in_bal_segment_high '|| p_in_bal_segment_high);
3319: arp_standard.debug( 'p_in_as_of_date_low '|| p_in_as_of_date_low);
3320: arp_standard.debug( 'p_in_summary_option_low '|| p_in_summary_option_low);
3321: arp_standard.debug( 'p_in_format_option_low '|| p_in_format_option_low);
3322: arp_standard.debug( 'p_in_bucket_type_low '|| p_in_bucket_type_low);

Line 3319: arp_standard.debug( 'p_in_as_of_date_low '|| p_in_as_of_date_low);

3315: arp_standard.debug( 'p_reporting_entity_id '|| p_reporting_entity_id);
3316: arp_standard.debug( 'p_coaid '|| p_coaid);
3317: arp_standard.debug( 'p_in_bal_segment_low '|| p_in_bal_segment_low);
3318: arp_standard.debug( 'p_in_bal_segment_high '|| p_in_bal_segment_high);
3319: arp_standard.debug( 'p_in_as_of_date_low '|| p_in_as_of_date_low);
3320: arp_standard.debug( 'p_in_summary_option_low '|| p_in_summary_option_low);
3321: arp_standard.debug( 'p_in_format_option_low '|| p_in_format_option_low);
3322: arp_standard.debug( 'p_in_bucket_type_low '|| p_in_bucket_type_low);
3323: arp_standard.debug( 'p_credit_option '|| p_credit_option);

Line 3320: arp_standard.debug( 'p_in_summary_option_low '|| p_in_summary_option_low);

3316: arp_standard.debug( 'p_coaid '|| p_coaid);
3317: arp_standard.debug( 'p_in_bal_segment_low '|| p_in_bal_segment_low);
3318: arp_standard.debug( 'p_in_bal_segment_high '|| p_in_bal_segment_high);
3319: arp_standard.debug( 'p_in_as_of_date_low '|| p_in_as_of_date_low);
3320: arp_standard.debug( 'p_in_summary_option_low '|| p_in_summary_option_low);
3321: arp_standard.debug( 'p_in_format_option_low '|| p_in_format_option_low);
3322: arp_standard.debug( 'p_in_bucket_type_low '|| p_in_bucket_type_low);
3323: arp_standard.debug( 'p_credit_option '|| p_credit_option);
3324: arp_standard.debug( 'p_risk_option '|| p_risk_option);

Line 3321: arp_standard.debug( 'p_in_format_option_low '|| p_in_format_option_low);

3317: arp_standard.debug( 'p_in_bal_segment_low '|| p_in_bal_segment_low);
3318: arp_standard.debug( 'p_in_bal_segment_high '|| p_in_bal_segment_high);
3319: arp_standard.debug( 'p_in_as_of_date_low '|| p_in_as_of_date_low);
3320: arp_standard.debug( 'p_in_summary_option_low '|| p_in_summary_option_low);
3321: arp_standard.debug( 'p_in_format_option_low '|| p_in_format_option_low);
3322: arp_standard.debug( 'p_in_bucket_type_low '|| p_in_bucket_type_low);
3323: arp_standard.debug( 'p_credit_option '|| p_credit_option);
3324: arp_standard.debug( 'p_risk_option '|| p_risk_option);
3325: arp_standard.debug( 'p_in_currency '|| p_in_currency);

Line 3322: arp_standard.debug( 'p_in_bucket_type_low '|| p_in_bucket_type_low);

3318: arp_standard.debug( 'p_in_bal_segment_high '|| p_in_bal_segment_high);
3319: arp_standard.debug( 'p_in_as_of_date_low '|| p_in_as_of_date_low);
3320: arp_standard.debug( 'p_in_summary_option_low '|| p_in_summary_option_low);
3321: arp_standard.debug( 'p_in_format_option_low '|| p_in_format_option_low);
3322: arp_standard.debug( 'p_in_bucket_type_low '|| p_in_bucket_type_low);
3323: arp_standard.debug( 'p_credit_option '|| p_credit_option);
3324: arp_standard.debug( 'p_risk_option '|| p_risk_option);
3325: arp_standard.debug( 'p_in_currency '|| p_in_currency);
3326: arp_standard.debug( 'p_in_customer_name_low '|| p_in_customer_name_low);

Line 3323: arp_standard.debug( 'p_credit_option '|| p_credit_option);

3319: arp_standard.debug( 'p_in_as_of_date_low '|| p_in_as_of_date_low);
3320: arp_standard.debug( 'p_in_summary_option_low '|| p_in_summary_option_low);
3321: arp_standard.debug( 'p_in_format_option_low '|| p_in_format_option_low);
3322: arp_standard.debug( 'p_in_bucket_type_low '|| p_in_bucket_type_low);
3323: arp_standard.debug( 'p_credit_option '|| p_credit_option);
3324: arp_standard.debug( 'p_risk_option '|| p_risk_option);
3325: arp_standard.debug( 'p_in_currency '|| p_in_currency);
3326: arp_standard.debug( 'p_in_customer_name_low '|| p_in_customer_name_low);
3327: arp_standard.debug( 'p_in_customer_name_high '|| p_in_customer_name_high);

Line 3324: arp_standard.debug( 'p_risk_option '|| p_risk_option);

3320: arp_standard.debug( 'p_in_summary_option_low '|| p_in_summary_option_low);
3321: arp_standard.debug( 'p_in_format_option_low '|| p_in_format_option_low);
3322: arp_standard.debug( 'p_in_bucket_type_low '|| p_in_bucket_type_low);
3323: arp_standard.debug( 'p_credit_option '|| p_credit_option);
3324: arp_standard.debug( 'p_risk_option '|| p_risk_option);
3325: arp_standard.debug( 'p_in_currency '|| p_in_currency);
3326: arp_standard.debug( 'p_in_customer_name_low '|| p_in_customer_name_low);
3327: arp_standard.debug( 'p_in_customer_name_high '|| p_in_customer_name_high);
3328: arp_standard.debug( 'p_in_customer_num_low '|| p_in_customer_num_low);

Line 3325: arp_standard.debug( 'p_in_currency '|| p_in_currency);

3321: arp_standard.debug( 'p_in_format_option_low '|| p_in_format_option_low);
3322: arp_standard.debug( 'p_in_bucket_type_low '|| p_in_bucket_type_low);
3323: arp_standard.debug( 'p_credit_option '|| p_credit_option);
3324: arp_standard.debug( 'p_risk_option '|| p_risk_option);
3325: arp_standard.debug( 'p_in_currency '|| p_in_currency);
3326: arp_standard.debug( 'p_in_customer_name_low '|| p_in_customer_name_low);
3327: arp_standard.debug( 'p_in_customer_name_high '|| p_in_customer_name_high);
3328: arp_standard.debug( 'p_in_customer_num_low '|| p_in_customer_num_low);
3329: arp_standard.debug( 'p_in_customer_num_high '|| p_in_customer_num_high);

Line 3326: arp_standard.debug( 'p_in_customer_name_low '|| p_in_customer_name_low);

3322: arp_standard.debug( 'p_in_bucket_type_low '|| p_in_bucket_type_low);
3323: arp_standard.debug( 'p_credit_option '|| p_credit_option);
3324: arp_standard.debug( 'p_risk_option '|| p_risk_option);
3325: arp_standard.debug( 'p_in_currency '|| p_in_currency);
3326: arp_standard.debug( 'p_in_customer_name_low '|| p_in_customer_name_low);
3327: arp_standard.debug( 'p_in_customer_name_high '|| p_in_customer_name_high);
3328: arp_standard.debug( 'p_in_customer_num_low '|| p_in_customer_num_low);
3329: arp_standard.debug( 'p_in_customer_num_high '|| p_in_customer_num_high);
3330: arp_standard.debug( 'p_in_amt_due_low '|| p_in_amt_due_low);

Line 3327: arp_standard.debug( 'p_in_customer_name_high '|| p_in_customer_name_high);

3323: arp_standard.debug( 'p_credit_option '|| p_credit_option);
3324: arp_standard.debug( 'p_risk_option '|| p_risk_option);
3325: arp_standard.debug( 'p_in_currency '|| p_in_currency);
3326: arp_standard.debug( 'p_in_customer_name_low '|| p_in_customer_name_low);
3327: arp_standard.debug( 'p_in_customer_name_high '|| p_in_customer_name_high);
3328: arp_standard.debug( 'p_in_customer_num_low '|| p_in_customer_num_low);
3329: arp_standard.debug( 'p_in_customer_num_high '|| p_in_customer_num_high);
3330: arp_standard.debug( 'p_in_amt_due_low '|| p_in_amt_due_low);
3331: arp_standard.debug( 'p_in_amt_due_high '|| p_in_amt_due_high);

Line 3328: arp_standard.debug( 'p_in_customer_num_low '|| p_in_customer_num_low);

3324: arp_standard.debug( 'p_risk_option '|| p_risk_option);
3325: arp_standard.debug( 'p_in_currency '|| p_in_currency);
3326: arp_standard.debug( 'p_in_customer_name_low '|| p_in_customer_name_low);
3327: arp_standard.debug( 'p_in_customer_name_high '|| p_in_customer_name_high);
3328: arp_standard.debug( 'p_in_customer_num_low '|| p_in_customer_num_low);
3329: arp_standard.debug( 'p_in_customer_num_high '|| p_in_customer_num_high);
3330: arp_standard.debug( 'p_in_amt_due_low '|| p_in_amt_due_low);
3331: arp_standard.debug( 'p_in_amt_due_high '|| p_in_amt_due_high);
3332: arp_standard.debug( 'p_in_invoice_type_low '|| p_in_invoice_type_low);

Line 3329: arp_standard.debug( 'p_in_customer_num_high '|| p_in_customer_num_high);

3325: arp_standard.debug( 'p_in_currency '|| p_in_currency);
3326: arp_standard.debug( 'p_in_customer_name_low '|| p_in_customer_name_low);
3327: arp_standard.debug( 'p_in_customer_name_high '|| p_in_customer_name_high);
3328: arp_standard.debug( 'p_in_customer_num_low '|| p_in_customer_num_low);
3329: arp_standard.debug( 'p_in_customer_num_high '|| p_in_customer_num_high);
3330: arp_standard.debug( 'p_in_amt_due_low '|| p_in_amt_due_low);
3331: arp_standard.debug( 'p_in_amt_due_high '|| p_in_amt_due_high);
3332: arp_standard.debug( 'p_in_invoice_type_low '|| p_in_invoice_type_low);
3333: arp_standard.debug( 'p_in_invoice_type_high '|| p_in_invoice_type_high);

Line 3330: arp_standard.debug( 'p_in_amt_due_low '|| p_in_amt_due_low);

3326: arp_standard.debug( 'p_in_customer_name_low '|| p_in_customer_name_low);
3327: arp_standard.debug( 'p_in_customer_name_high '|| p_in_customer_name_high);
3328: arp_standard.debug( 'p_in_customer_num_low '|| p_in_customer_num_low);
3329: arp_standard.debug( 'p_in_customer_num_high '|| p_in_customer_num_high);
3330: arp_standard.debug( 'p_in_amt_due_low '|| p_in_amt_due_low);
3331: arp_standard.debug( 'p_in_amt_due_high '|| p_in_amt_due_high);
3332: arp_standard.debug( 'p_in_invoice_type_low '|| p_in_invoice_type_low);
3333: arp_standard.debug( 'p_in_invoice_type_high '|| p_in_invoice_type_high);
3334: arp_standard.debug( 'p_worker_id '|| p_in_worker_id);

Line 3331: arp_standard.debug( 'p_in_amt_due_high '|| p_in_amt_due_high);

3327: arp_standard.debug( 'p_in_customer_name_high '|| p_in_customer_name_high);
3328: arp_standard.debug( 'p_in_customer_num_low '|| p_in_customer_num_low);
3329: arp_standard.debug( 'p_in_customer_num_high '|| p_in_customer_num_high);
3330: arp_standard.debug( 'p_in_amt_due_low '|| p_in_amt_due_low);
3331: arp_standard.debug( 'p_in_amt_due_high '|| p_in_amt_due_high);
3332: arp_standard.debug( 'p_in_invoice_type_low '|| p_in_invoice_type_low);
3333: arp_standard.debug( 'p_in_invoice_type_high '|| p_in_invoice_type_high);
3334: arp_standard.debug( 'p_worker_id '|| p_in_worker_id);
3335: arp_standard.debug( 'p_worker_count '|| p_in_worker_count);

Line 3332: arp_standard.debug( 'p_in_invoice_type_low '|| p_in_invoice_type_low);

3328: arp_standard.debug( 'p_in_customer_num_low '|| p_in_customer_num_low);
3329: arp_standard.debug( 'p_in_customer_num_high '|| p_in_customer_num_high);
3330: arp_standard.debug( 'p_in_amt_due_low '|| p_in_amt_due_low);
3331: arp_standard.debug( 'p_in_amt_due_high '|| p_in_amt_due_high);
3332: arp_standard.debug( 'p_in_invoice_type_low '|| p_in_invoice_type_low);
3333: arp_standard.debug( 'p_in_invoice_type_high '|| p_in_invoice_type_high);
3334: arp_standard.debug( 'p_worker_id '|| p_in_worker_id);
3335: arp_standard.debug( 'p_worker_count '|| p_in_worker_count);
3336: arp_standard.debug( 'p_retain_staging_flag '|| p_retain_staging_flag);

Line 3333: arp_standard.debug( 'p_in_invoice_type_high '|| p_in_invoice_type_high);

3329: arp_standard.debug( 'p_in_customer_num_high '|| p_in_customer_num_high);
3330: arp_standard.debug( 'p_in_amt_due_low '|| p_in_amt_due_low);
3331: arp_standard.debug( 'p_in_amt_due_high '|| p_in_amt_due_high);
3332: arp_standard.debug( 'p_in_invoice_type_low '|| p_in_invoice_type_low);
3333: arp_standard.debug( 'p_in_invoice_type_high '|| p_in_invoice_type_high);
3334: arp_standard.debug( 'p_worker_id '|| p_in_worker_id);
3335: arp_standard.debug( 'p_worker_count '|| p_in_worker_count);
3336: arp_standard.debug( 'p_retain_staging_flag '|| p_retain_staging_flag);
3337: arp_standard.debug( 'p_accounting_method '|| p_accounting_method);

Line 3334: arp_standard.debug( 'p_worker_id '|| p_in_worker_id);

3330: arp_standard.debug( 'p_in_amt_due_low '|| p_in_amt_due_low);
3331: arp_standard.debug( 'p_in_amt_due_high '|| p_in_amt_due_high);
3332: arp_standard.debug( 'p_in_invoice_type_low '|| p_in_invoice_type_low);
3333: arp_standard.debug( 'p_in_invoice_type_high '|| p_in_invoice_type_high);
3334: arp_standard.debug( 'p_worker_id '|| p_in_worker_id);
3335: arp_standard.debug( 'p_worker_count '|| p_in_worker_count);
3336: arp_standard.debug( 'p_retain_staging_flag '|| p_retain_staging_flag);
3337: arp_standard.debug( 'p_accounting_method '|| p_accounting_method);
3338: END IF;

Line 3335: arp_standard.debug( 'p_worker_count '|| p_in_worker_count);

3331: arp_standard.debug( 'p_in_amt_due_high '|| p_in_amt_due_high);
3332: arp_standard.debug( 'p_in_invoice_type_low '|| p_in_invoice_type_low);
3333: arp_standard.debug( 'p_in_invoice_type_high '|| p_in_invoice_type_high);
3334: arp_standard.debug( 'p_worker_id '|| p_in_worker_id);
3335: arp_standard.debug( 'p_worker_count '|| p_in_worker_count);
3336: arp_standard.debug( 'p_retain_staging_flag '|| p_retain_staging_flag);
3337: arp_standard.debug( 'p_accounting_method '|| p_accounting_method);
3338: END IF;
3339:

Line 3336: arp_standard.debug( 'p_retain_staging_flag '|| p_retain_staging_flag);

3332: arp_standard.debug( 'p_in_invoice_type_low '|| p_in_invoice_type_low);
3333: arp_standard.debug( 'p_in_invoice_type_high '|| p_in_invoice_type_high);
3334: arp_standard.debug( 'p_worker_id '|| p_in_worker_id);
3335: arp_standard.debug( 'p_worker_count '|| p_in_worker_count);
3336: arp_standard.debug( 'p_retain_staging_flag '|| p_retain_staging_flag);
3337: arp_standard.debug( 'p_accounting_method '|| p_accounting_method);
3338: END IF;
3339:
3340: --set the parameter value to package global variables

Line 3337: arp_standard.debug( 'p_accounting_method '|| p_accounting_method);

3333: arp_standard.debug( 'p_in_invoice_type_high '|| p_in_invoice_type_high);
3334: arp_standard.debug( 'p_worker_id '|| p_in_worker_id);
3335: arp_standard.debug( 'p_worker_count '|| p_in_worker_count);
3336: arp_standard.debug( 'p_retain_staging_flag '|| p_retain_staging_flag);
3337: arp_standard.debug( 'p_accounting_method '|| p_accounting_method);
3338: END IF;
3339:
3340: --set the parameter value to package global variables
3341: pg_rep_type := p_rep_type;

Line 3368: arp_standard.debug( 'pg_reporting_level '|| pg_reporting_level);

3364: pg_in_amt_due_low := p_in_amt_due_low;
3365: pg_in_amt_due_high := p_in_amt_due_high;
3366:
3367: IF PG_DEBUG in ('Y', 'C') THEN
3368: arp_standard.debug( 'pg_reporting_level '|| pg_reporting_level);
3369: arp_standard.debug( 'pg_reporting_entity_id '|| pg_reporting_entity_id);
3370: arp_standard.debug( 'pg_coaid '|| pg_coaid);
3371: arp_standard.debug( 'pg_in_as_of_date_low '|| pg_in_as_of_date_low);
3372: arp_standard.debug( 'pg_worker_id '|| pg_worker_id);

Line 3369: arp_standard.debug( 'pg_reporting_entity_id '|| pg_reporting_entity_id);

3365: pg_in_amt_due_high := p_in_amt_due_high;
3366:
3367: IF PG_DEBUG in ('Y', 'C') THEN
3368: arp_standard.debug( 'pg_reporting_level '|| pg_reporting_level);
3369: arp_standard.debug( 'pg_reporting_entity_id '|| pg_reporting_entity_id);
3370: arp_standard.debug( 'pg_coaid '|| pg_coaid);
3371: arp_standard.debug( 'pg_in_as_of_date_low '|| pg_in_as_of_date_low);
3372: arp_standard.debug( 'pg_worker_id '|| pg_worker_id);
3373: arp_standard.debug( 'pg_worker_count '|| pg_worker_count);

Line 3370: arp_standard.debug( 'pg_coaid '|| pg_coaid);

3366:
3367: IF PG_DEBUG in ('Y', 'C') THEN
3368: arp_standard.debug( 'pg_reporting_level '|| pg_reporting_level);
3369: arp_standard.debug( 'pg_reporting_entity_id '|| pg_reporting_entity_id);
3370: arp_standard.debug( 'pg_coaid '|| pg_coaid);
3371: arp_standard.debug( 'pg_in_as_of_date_low '|| pg_in_as_of_date_low);
3372: arp_standard.debug( 'pg_worker_id '|| pg_worker_id);
3373: arp_standard.debug( 'pg_worker_count '|| pg_worker_count);
3374: arp_standard.debug( 'pg_retain_staging_flag '|| pg_retain_staging_flag);

Line 3371: arp_standard.debug( 'pg_in_as_of_date_low '|| pg_in_as_of_date_low);

3367: IF PG_DEBUG in ('Y', 'C') THEN
3368: arp_standard.debug( 'pg_reporting_level '|| pg_reporting_level);
3369: arp_standard.debug( 'pg_reporting_entity_id '|| pg_reporting_entity_id);
3370: arp_standard.debug( 'pg_coaid '|| pg_coaid);
3371: arp_standard.debug( 'pg_in_as_of_date_low '|| pg_in_as_of_date_low);
3372: arp_standard.debug( 'pg_worker_id '|| pg_worker_id);
3373: arp_standard.debug( 'pg_worker_count '|| pg_worker_count);
3374: arp_standard.debug( 'pg_retain_staging_flag '|| pg_retain_staging_flag);
3375: END IF;

Line 3372: arp_standard.debug( 'pg_worker_id '|| pg_worker_id);

3368: arp_standard.debug( 'pg_reporting_level '|| pg_reporting_level);
3369: arp_standard.debug( 'pg_reporting_entity_id '|| pg_reporting_entity_id);
3370: arp_standard.debug( 'pg_coaid '|| pg_coaid);
3371: arp_standard.debug( 'pg_in_as_of_date_low '|| pg_in_as_of_date_low);
3372: arp_standard.debug( 'pg_worker_id '|| pg_worker_id);
3373: arp_standard.debug( 'pg_worker_count '|| pg_worker_count);
3374: arp_standard.debug( 'pg_retain_staging_flag '|| pg_retain_staging_flag);
3375: END IF;
3376:

Line 3373: arp_standard.debug( 'pg_worker_count '|| pg_worker_count);

3369: arp_standard.debug( 'pg_reporting_entity_id '|| pg_reporting_entity_id);
3370: arp_standard.debug( 'pg_coaid '|| pg_coaid);
3371: arp_standard.debug( 'pg_in_as_of_date_low '|| pg_in_as_of_date_low);
3372: arp_standard.debug( 'pg_worker_id '|| pg_worker_id);
3373: arp_standard.debug( 'pg_worker_count '|| pg_worker_count);
3374: arp_standard.debug( 'pg_retain_staging_flag '|| pg_retain_staging_flag);
3375: END IF;
3376:
3377: pg_request_id := arp_standard.profile.request_id;

Line 3374: arp_standard.debug( 'pg_retain_staging_flag '|| pg_retain_staging_flag);

3370: arp_standard.debug( 'pg_coaid '|| pg_coaid);
3371: arp_standard.debug( 'pg_in_as_of_date_low '|| pg_in_as_of_date_low);
3372: arp_standard.debug( 'pg_worker_id '|| pg_worker_id);
3373: arp_standard.debug( 'pg_worker_count '|| pg_worker_count);
3374: arp_standard.debug( 'pg_retain_staging_flag '|| pg_retain_staging_flag);
3375: END IF;
3376:
3377: pg_request_id := arp_standard.profile.request_id;
3378:

Line 3377: pg_request_id := arp_standard.profile.request_id;

3373: arp_standard.debug( 'pg_worker_count '|| pg_worker_count);
3374: arp_standard.debug( 'pg_retain_staging_flag '|| pg_retain_staging_flag);
3375: END IF;
3376:
3377: pg_request_id := arp_standard.profile.request_id;
3378:
3379: initialize_package_globals;
3380:
3381: IF nvl(p_master_req_flag,'Y') = 'Y' THEN

Line 3397: arp_standard.debug( 'Submitting worker '|| l_worker_number );

3393: IF nvl(p_master_req_flag,'Y') = 'Y' AND pg_worker_count > 1 THEN
3394: --Invoke the child programs
3395: FOR l_worker_number IN 1..pg_worker_count LOOP
3396: IF PG_DEBUG in ('Y', 'C') THEN
3397: arp_standard.debug( 'Submitting worker '|| l_worker_number );
3398: END IF;
3399: submit_subrequest ( l_worker_number );
3400: END LOOP;
3401:

Line 3405: arp_standard.debug( 'Waiting for the completion of worker '||pg_req_status_tab(i).request_id);

3401:
3402: -- Wait for the completion of the submitted requests
3403: FOR i in 1..pg_worker_count LOOP
3404: IF PG_DEBUG in ('Y', 'C') THEN
3405: arp_standard.debug( 'Waiting for the completion of worker '||pg_req_status_tab(i).request_id);
3406: END IF;
3407:
3408: l_complete := FND_CONCURRENT.WAIT_FOR_REQUEST(
3409: request_id => pg_req_status_tab(i).request_id,

Line 3430: arp_standard.debug( 'Child processing..');

3426: END IF;
3427: END LOOP;
3428: ELSE
3429: IF PG_DEBUG in ('Y', 'C') THEN
3430: arp_standard.debug( 'Child processing..');
3431: END IF;
3432:
3433: build_select_stmt( p_out_invoice_query => l_out_invoice_query,
3434: p_out_receipt_query => l_out_unapp_query,

Line 3438: arp_standard.debug( l_out_unapp_query );

3434: p_out_receipt_query => l_out_unapp_query,
3435: p_out_riskinfo_query => l_out_riskinfo_query,
3436: p_out_br_query => l_out_br_query);
3437:
3438: arp_standard.debug( l_out_unapp_query );
3439:
3440: extract_aging_information( AR_AGING_CTGRY_INVOICE,
3441: l_out_invoice_query );
3442: