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
922: FND_MESSAGE.SET_NAME('FND','FND_MO_RPT_PARTIAL_LEDGER');
923: l_message := FND_MESSAGE.get;
924: END IF;
925:
926: l_xml_header := '
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
922: FND_MESSAGE.SET_NAME('FND','FND_MO_RPT_PARTIAL_LEDGER');
923: l_message := FND_MESSAGE.get;
924: END IF;
925:
926: l_xml_header := '
927:
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:
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:
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
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
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');
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');
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;
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');
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');
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
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');
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);
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 ||