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.QRM_PA_AGGREGATION_P dependencies on XTR_RISK_DEBUG_PKG

Line 143: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.GET_UNDERLYING_CCY');

139: WHERE attribute_name=v_meas_temp;
140:
141: BEGIN
142: IF (g_proc_level>=g_debug_level) THEN
143: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.GET_UNDERLYING_CCY');
144: END IF;
145: ------------------CURRENCY LOGIC-----------------------
146: --for sensitivity can only be averaged/summed if the underlying
147: --sensitivity_ccy is uniform

Line 444: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.GET_UNDERLYING_CCY');

440: 'M');
441: END IF;
442: ------------------END OF CURRENCY LOGIC----------------
443: IF (g_proc_level>=g_debug_level) THEN
444: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.GET_UNDERLYING_CCY');
445: END IF;
446: END get_underlying_currency;
447:
448:

Line 490: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.GET_ACT_COL_NAME');

486: v_count NUMBER;
487:
488: BEGIN
489: IF (g_proc_level>=g_debug_level) THEN
490: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.GET_ACT_COL_NAME');
491: END IF;
492:
493: p_actual_agg.EXTEND(p_agg.COUNT);
494: ----------This is for the Total ccy conversion purpose

Line 504: xtr_risk_debug_pkg.dlog('get_actual_column_name: ' || 'p_nom_fl_usd.COUNT',p_nom_fl_usd.COUNT);

500: p_origin_usd.EXTEND(p_agg.COUNT);
501: p_num_denom_origin_usd.EXTEND(p_agg.COUNT);
502: END IF;
503: IF (g_proc_level>=g_debug_level) THEN
504: xtr_risk_debug_pkg.dlog('get_actual_column_name: ' || 'p_nom_fl_usd.COUNT',p_nom_fl_usd.COUNT);
505: END IF;
506: ----------End This is for the Total ccy conversion purpose
507: --update col. name based on the currency conversion
508: FOR i IN 1..p_agg.COUNT LOOP

Line 580: xtr_risk_debug_pkg.dlog('get_actual_column_name: ' || 'p_actual_agg(i)',i||':'||p_actual_agg(i));

576:
577: -----------Testing
578: FOR i IN 1..p_actual_agg.COUNT LOOP
579: IF (g_proc_level>=g_debug_level) THEN
580: xtr_risk_debug_pkg.dlog('get_actual_column_name: ' || 'p_actual_agg(i)',i||':'||p_actual_agg(i));
581: END IF;
582: IF p_need_usd_arr THEN
583: IF (g_proc_level>=g_debug_level) THEN
584: xtr_risk_debug_pkg.dlog('get_actual_column_name: ' || 'p_nom_fl_usd(i)',i||':'||p_nom_fl_usd(i));

Line 584: xtr_risk_debug_pkg.dlog('get_actual_column_name: ' || 'p_nom_fl_usd(i)',i||':'||p_nom_fl_usd(i));

580: xtr_risk_debug_pkg.dlog('get_actual_column_name: ' || 'p_actual_agg(i)',i||':'||p_actual_agg(i));
581: END IF;
582: IF p_need_usd_arr THEN
583: IF (g_proc_level>=g_debug_level) THEN
584: xtr_risk_debug_pkg.dlog('get_actual_column_name: ' || 'p_nom_fl_usd(i)',i||':'||p_nom_fl_usd(i));
585: END IF;
586: END IF;
587: END LOOP;
588: -----------End Testing

Line 590: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.GET_ACT_COL_NAME');

586: END IF;
587: END LOOP;
588: -----------End Testing
589: IF (g_proc_level>=g_debug_level) THEN
590: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.GET_ACT_COL_NAME');
591: END IF;
592: END get_actual_column_name;
593:
594:

Line 625: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.GET_COL_CCY_MULTP');

621: pinfo.set_of_books_id = sob.set_of_books_id;
622:
623: BEGIN
624: IF (g_proc_level>=g_debug_level) THEN
625: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.GET_COL_CCY_MULTP');
626: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'p_currency_source',p_default_ccy);
627: END IF;
628:
629: p_col_ccy_multp.EXTEND(p_max_col_no);

Line 626: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'p_currency_source',p_default_ccy);

622:
623: BEGIN
624: IF (g_proc_level>=g_debug_level) THEN
625: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.GET_COL_CCY_MULTP');
626: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'p_currency_source',p_default_ccy);
627: END IF;
628:
629: p_col_ccy_multp.EXTEND(p_max_col_no);
630:

Line 673: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'i:p_a1',i||':'||p_a1(i));

669: END IF;
670: END IF;
671: END IF;
672: IF (g_proc_level>=g_debug_level) THEN
673: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'i:p_a1',i||':'||p_a1(i));
674: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'v_fx_rate',v_fx_rate);
675: xtr_risk_debug_pkg.dlog('i:p_col_ccy_multp',i||':'||p_col_ccy_multp(i-p_row_agg_no));
676: END IF;
677: END LOOP;

Line 674: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'v_fx_rate',v_fx_rate);

670: END IF;
671: END IF;
672: IF (g_proc_level>=g_debug_level) THEN
673: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'i:p_a1',i||':'||p_a1(i));
674: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'v_fx_rate',v_fx_rate);
675: xtr_risk_debug_pkg.dlog('i:p_col_ccy_multp',i||':'||p_col_ccy_multp(i-p_row_agg_no));
676: END IF;
677: END LOOP;
678:

Line 675: xtr_risk_debug_pkg.dlog('i:p_col_ccy_multp',i||':'||p_col_ccy_multp(i-p_row_agg_no));

671: END IF;
672: IF (g_proc_level>=g_debug_level) THEN
673: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'i:p_a1',i||':'||p_a1(i));
674: xtr_risk_debug_pkg.dlog('get_col_ccy_multp: ' || 'v_fx_rate',v_fx_rate);
675: xtr_risk_debug_pkg.dlog('i:p_col_ccy_multp',i||':'||p_col_ccy_multp(i-p_row_agg_no));
676: END IF;
677: END LOOP;
678:
679: IF (g_proc_level>=g_debug_level) THEN

Line 680: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.GET_COL_CCY_MULTP');

676: END IF;
677: END LOOP;
678:
679: IF (g_proc_level>=g_debug_level) THEN
680: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.GET_COL_CCY_MULTP');
681: END IF;
682: END get_col_ccy_multp;
683:
684:

Line 767: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.INSERT_ROW');

763:
764: BEGIN
765:
766: IF (g_proc_level>=g_debug_level) THEN
767: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.INSERT_ROW');
768: END IF;
769:
770: ---------Should be removed if multiple level columns is implemented
771: --If multiple col level is implemented, replace this with

Line 818: xtr_risk_debug_pkg.dlog('insert_row: ' || '',p_row||':'||v_test);

814: --WDK: v_test is only 4096 characters big. if bigger than that then do not want
815: --to error out, so dump contents and continue
816: IF (length(v_test)>4000) THEN
817: IF (g_proc_level>=g_debug_level) THEN
818: xtr_risk_debug_pkg.dlog('insert_row: ' || '',p_row||':'||v_test);
819: END IF;
820: v_test:='';
821: END IF;
822: IF j <= p_row_agg_no THEN

Line 829: xtr_risk_debug_pkg.dlog('insert_row: ' || '',p_row||':'||v_test);

825: v_test := v_test||':'||sm(j-p_row_agg_no);
826: END IF;
827: END LOOP;
828: IF (g_proc_level>=g_debug_level) THEN
829: xtr_risk_debug_pkg.dlog('insert_row: ' || '',p_row||':'||v_test);
830: END IF;
831: ------------------End Testing purpose
832:
833: --format the tot, ccy to be append-ready (for now formatting is done in SQL)

Line 914: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_SAVED_ANALYSES_ROW',

910: FND_GLOBAL.login_id);
911: END IF;
912:
913: IF (g_event_level>=g_debug_level) THEN --bug 3236479
914: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_SAVED_ANALYSES_ROW',
915: 'QRM_PA_AGGREGATION_P.INSERT_ROW',g_event_level);
916: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.INSERT_ROW');
917: END IF;
918:

Line 916: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.INSERT_ROW');

912:
913: IF (g_event_level>=g_debug_level) THEN --bug 3236479
914: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_SAVED_ANALYSES_ROW',
915: 'QRM_PA_AGGREGATION_P.INSERT_ROW',g_event_level);
916: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.INSERT_ROW');
917: END IF;
918:
919: RETURN TRUE;
920: EXCEPTION

Line 923: xtr_risk_debug_pkg.dlog('EXCEPTION','UNEXPECTED',

919: RETURN TRUE;
920: EXCEPTION
921: WHEN OTHERS THEN
922: IF (g_ERROR_level>=g_debug_level) THEN
923: xtr_risk_debug_pkg.dlog('EXCEPTION','UNEXPECTED',
924: 'QRM_PA_AGGREGATION_P.INSERT_ROW',G_ERROR_LEVEL);
925: END IF;
926: RETURN FALSE;
927: END insert_row;

Line 984: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.CREATE_CURSOR');

980: v_where_col VARCHAR2(255);
981:
982: BEGIN
983: IF (g_proc_level>=g_debug_level) THEN
984: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.CREATE_CURSOR');
985: END IF;
986:
987: --call get_actual_column_name proc
988: IF p_style<>'T' THEN

Line 1008: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'p_ccy_multiplier',p_ccy_multiplier);

1004: IF p_table_col_curr(i) IS NULL THEN
1005: --NULL means value is converted to reporting currency
1006: p_table_col_curr(i) := p_curr_reporting;
1007: IF (g_proc_level>=g_debug_level) THEN
1008: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'p_ccy_multiplier',p_ccy_multiplier);
1009: END IF;
1010: --ccy multiplier only applicable to amount type
1011: IF p_ccy_multiplier IS NOT NULL AND p_amount(i)='Y' THEN
1012: v_act_agg(i) := v_act_agg(i)||'*TO_NUMBER('''||p_ccy_multiplier||''')';

Line 1021: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'v_act_agg(i)',i||':'||v_act_agg(i));

1017: END IF;
1018: -----------Testing
1019: FOR i IN 1..v_act_agg.COUNT LOOP
1020: IF (g_proc_level>=g_debug_level) THEN
1021: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'v_act_agg(i)',i||':'||v_act_agg(i));
1022: END IF;
1023: END LOOP;
1024: -----------End Testing
1025:

Line 1041: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'j:v_act_agg(j)',j||':'||v_act_agg(j));

1037: FOR j IN 1..v_act_agg.COUNT LOOP
1038: --for cross-tab and aggregated-table
1039: --IF (p_style='C') OR (p_style='A') THEN
1040: IF (g_proc_level>=g_debug_level) THEN
1041: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'j:v_act_agg(j)',j||':'||v_act_agg(j));
1042: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'j:p_type(j)',j||':'||p_type(j));
1043: END IF;
1044: IF p_type(j)='R' THEN
1045: --check whether att. is from table or view

Line 1042: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'j:p_type(j)',j||':'||p_type(j));

1038: --for cross-tab and aggregated-table
1039: --IF (p_style='C') OR (p_style='A') THEN
1040: IF (g_proc_level>=g_debug_level) THEN
1041: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'j:v_act_agg(j)',j||':'||v_act_agg(j));
1042: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'j:p_type(j)',j||':'||p_type(j));
1043: END IF;
1044: IF p_type(j)='R' THEN
1045: --check whether att. is from table or view
1046: IF p_origin(j)='T' THEN

Line 1069: --xtr_risk_debug_pkg.dlog('p_row_agg_no',p_row_agg_no);

1065: IF p_style='A' THEN
1066: v_aggregate_level := j;
1067: END IF;
1068: END IF;
1069: --xtr_risk_debug_pkg.dlog('p_row_agg_no',p_row_agg_no);
1070: --if style = X and the next one is Measure then v_aggregate_level=j
1071: IF p_style='X' AND p_type(j+1)='M' THEN
1072: p_sql := p_sql||',c.seq_no';
1073: v_aggregate_level := j;

Line 1098: --xtr_risk_debug_pkg.dlog('C->B: v_act_agg(j)',v_act_agg(j));

1094: END IF;
1095: --exclude the null value
1096: v_where_col := v_where_col||' AND v.'||v_act_agg(j)||' IS NOT NULL';
1097: ELSE --IF p_origin(j)='B'
1098: --xtr_risk_debug_pkg.dlog('C->B: v_act_agg(j)',v_act_agg(j));
1099: p_sql_col := p_sql_col||'tb.'||v_act_agg(j);
1100: p_tb_calc_used := TRUE;
1101: p_tb_calc_used_col := TRUE;
1102: --exclude the null value

Line 1127: --xtr_risk_debug_pkg.dlog('M->T: j:v_act_agg,p_origin,p_tot_avg=',j||':'||v_act_agg(j)||','||p_origin(j)||','||p_tot_avg(j));

1123: p_measure_no := p_measure_no+2;
1124: END IF;
1125:
1126: --p_type(j)='M' AND
1127: --xtr_risk_debug_pkg.dlog('M->T: j:v_act_agg,p_origin,p_tot_avg=',j||':'||v_act_agg(j)||','||p_origin(j)||','||p_tot_avg(j));
1128: ELSIF v_act_agg(j) IS NOT NULL AND p_tot_avg(j)='T' THEN
1129: IF p_origin(j)='T' THEN
1130: p_sql := p_sql||'SUM(dc.'||v_act_agg(j)||'),NULL';
1131: ELSIF p_origin(j)='V' THEN

Line 1143: --xtr_risk_debug_pkg.dlog('M->T: v_col_name=',v_col_name);

1139: IF p_need_usd_arr THEN
1140: --first find the origin bec. col+'_usd' may be different from
1141: --the original
1142: v_col_name := v_act_agg(j)||'_USD';
1143: --xtr_risk_debug_pkg.dlog('M->T: v_col_name=',v_col_name);
1144: --xtr_risk_debug_pkg.dlog('M->T: v_origin=',v_origin);
1145: --xtr_risk_debug_pkg.dlog('M->T: v_origin_usd(j)=',v_origin_usd(j));
1146: --xtr_risk_debug_pkg.dlog('M->T: v_agg_usd(j)=',v_agg_usd(j));
1147: IF v_origin_usd(j)='T' THEN

Line 1144: --xtr_risk_debug_pkg.dlog('M->T: v_origin=',v_origin);

1140: --first find the origin bec. col+'_usd' may be different from
1141: --the original
1142: v_col_name := v_act_agg(j)||'_USD';
1143: --xtr_risk_debug_pkg.dlog('M->T: v_col_name=',v_col_name);
1144: --xtr_risk_debug_pkg.dlog('M->T: v_origin=',v_origin);
1145: --xtr_risk_debug_pkg.dlog('M->T: v_origin_usd(j)=',v_origin_usd(j));
1146: --xtr_risk_debug_pkg.dlog('M->T: v_agg_usd(j)=',v_agg_usd(j));
1147: IF v_origin_usd(j)='T' THEN
1148: p_sql := p_sql||',SUM(dc.'||v_agg_usd(j)||'),NULL';

Line 1145: --xtr_risk_debug_pkg.dlog('M->T: v_origin_usd(j)=',v_origin_usd(j));

1141: --the original
1142: v_col_name := v_act_agg(j)||'_USD';
1143: --xtr_risk_debug_pkg.dlog('M->T: v_col_name=',v_col_name);
1144: --xtr_risk_debug_pkg.dlog('M->T: v_origin=',v_origin);
1145: --xtr_risk_debug_pkg.dlog('M->T: v_origin_usd(j)=',v_origin_usd(j));
1146: --xtr_risk_debug_pkg.dlog('M->T: v_agg_usd(j)=',v_agg_usd(j));
1147: IF v_origin_usd(j)='T' THEN
1148: p_sql := p_sql||',SUM(dc.'||v_agg_usd(j)||'),NULL';
1149: ELSIF v_origin_usd(j)='V' THEN

Line 1146: --xtr_risk_debug_pkg.dlog('M->T: v_agg_usd(j)=',v_agg_usd(j));

1142: v_col_name := v_act_agg(j)||'_USD';
1143: --xtr_risk_debug_pkg.dlog('M->T: v_col_name=',v_col_name);
1144: --xtr_risk_debug_pkg.dlog('M->T: v_origin=',v_origin);
1145: --xtr_risk_debug_pkg.dlog('M->T: v_origin_usd(j)=',v_origin_usd(j));
1146: --xtr_risk_debug_pkg.dlog('M->T: v_agg_usd(j)=',v_agg_usd(j));
1147: IF v_origin_usd(j)='T' THEN
1148: p_sql := p_sql||',SUM(dc.'||v_agg_usd(j)||'),NULL';
1149: ELSIF v_origin_usd(j)='V' THEN
1150: p_sql := p_sql||',SUM(v.'||v_agg_usd(j)||'),NULL';

Line 1157: --xtr_risk_debug_pkg.dlog('p_measure_no',p_measure_no);

1153: p_tb_calc_used := TRUE;
1154: END IF;
1155: p_measure_no := p_measure_no+2;
1156: END IF;
1157: --xtr_risk_debug_pkg.dlog('p_measure_no',p_measure_no);
1158: --p_type(j)='M' AND
1159: ELSIF v_act_agg(j) IS NOT NULL AND p_tot_avg(j)='A' THEN
1160: --xtr_risk_debug_pkg.dlog('M->A: v_act_agg',v_act_agg(j));
1161: IF p_nom(j) IS NULL THEN

Line 1160: --xtr_risk_debug_pkg.dlog('M->A: v_act_agg',v_act_agg(j));

1156: END IF;
1157: --xtr_risk_debug_pkg.dlog('p_measure_no',p_measure_no);
1158: --p_type(j)='M' AND
1159: ELSIF v_act_agg(j) IS NOT NULL AND p_tot_avg(j)='A' THEN
1160: --xtr_risk_debug_pkg.dlog('M->A: v_act_agg',v_act_agg(j));
1161: IF p_nom(j) IS NULL THEN
1162: p_nom(j) := 'NULL';
1163: END IF;
1164: IF p_denom(j) IS NULL THEN

Line 1173: --xtr_risk_debug_pkg.dlog('j,v_nom_fl_usd.COUNT',j||','||v_nom_fl_usd.COUNT);

1169: p_tb_calc_used := TRUE;
1170: END IF;
1171: p_measure_no := p_measure_no+2;
1172: --if style = X then v_aggregate_level=j-1
1173: --xtr_risk_debug_pkg.dlog('j,v_nom_fl_usd.COUNT',j||','||v_nom_fl_usd.COUNT);
1174: IF p_need_usd_arr THEN
1175: --xtr_risk_debug_pkg.dlog('M->T: v_nom_fl_usd(j)=',v_nom_fl_usd(j));
1176: IF v_nom_fl_usd(j) IS NULL THEN
1177: v_nom_fl_usd(j) := 'NULL';

Line 1175: --xtr_risk_debug_pkg.dlog('M->T: v_nom_fl_usd(j)=',v_nom_fl_usd(j));

1171: p_measure_no := p_measure_no+2;
1172: --if style = X then v_aggregate_level=j-1
1173: --xtr_risk_debug_pkg.dlog('j,v_nom_fl_usd.COUNT',j||','||v_nom_fl_usd.COUNT);
1174: IF p_need_usd_arr THEN
1175: --xtr_risk_debug_pkg.dlog('M->T: v_nom_fl_usd(j)=',v_nom_fl_usd(j));
1176: IF v_nom_fl_usd(j) IS NULL THEN
1177: v_nom_fl_usd(j) := 'NULL';
1178: END IF;
1179: --xtr_risk_debug_pkg.dlog('M->T: v_denom_fl_usd(j)=',v_denom_fl_usd(j));

Line 1179: --xtr_risk_debug_pkg.dlog('M->T: v_denom_fl_usd(j)=',v_denom_fl_usd(j));

1175: --xtr_risk_debug_pkg.dlog('M->T: v_nom_fl_usd(j)=',v_nom_fl_usd(j));
1176: IF v_nom_fl_usd(j) IS NULL THEN
1177: v_nom_fl_usd(j) := 'NULL';
1178: END IF;
1179: --xtr_risk_debug_pkg.dlog('M->T: v_denom_fl_usd(j)=',v_denom_fl_usd(j));
1180: IF v_denom_fl_usd(j) IS NULL THEN
1181: v_denom_fl_usd(j) := 'NULL';
1182: END IF;
1183: p_sql := p_sql||','||v_nom_fl_usd(j)||','||v_denom_fl_usd(j);

Line 1346: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'v_aggregate_level',v_aggregate_level);

1342: IF p_style<>'T' THEN
1343: --add GROUP BY clause
1344: p_sql := p_sql||' GROUP BY ';
1345: IF (g_proc_level>=g_debug_level) THEN
1346: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'v_aggregate_level',v_aggregate_level);
1347: END IF;
1348: FOR j IN 1..v_aggregate_level LOOP
1349: --xtr_risk_debug_pkg.dlog('v_act_agg(j)',j||':'||v_act_agg(j));
1350: --check whether att. is from table or view

Line 1349: --xtr_risk_debug_pkg.dlog('v_act_agg(j)',j||':'||v_act_agg(j));

1345: IF (g_proc_level>=g_debug_level) THEN
1346: xtr_risk_debug_pkg.dlog('create_cursor: ' || 'v_aggregate_level',v_aggregate_level);
1347: END IF;
1348: FOR j IN 1..v_aggregate_level LOOP
1349: --xtr_risk_debug_pkg.dlog('v_act_agg(j)',j||':'||v_act_agg(j));
1350: --check whether att. is from table or view
1351: IF p_type(j)<>'C' THEN
1352: IF p_origin(j)='T' THEN
1353: p_sql := p_sql||'dc.'||v_act_agg(j);

Line 1387: xtr_risk_debug_pkg.dpop(null,'QRM_PORTFOLIO_ANALYSIS.CREATE_CURSOR');

1383: END LOOP;
1384: END IF; --p_style<>'T'
1385:
1386: IF (g_proc_level>=g_debug_level) THEN
1387: xtr_risk_debug_pkg.dpop(null,'QRM_PORTFOLIO_ANALYSIS.CREATE_CURSOR');
1388: END IF;
1389: END create_cursor;
1390:
1391:

Line 1555: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE');

1551: -------End Testing parameters
1552:
1553: BEGIN
1554: IF (g_proc_level>=g_debug_level) THEN
1555: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE');
1556: END IF;
1557:
1558: --initialize fnd_msg_pub if it has not been intialized
1559: IF p_caller_flag='OA' AND fnd_msg_pub.count_msg>0 THEN

Line 1586: --xtr_risk_debug_pkg.dlog('v_analysis_type',v_analysis_type);

1582: IF NOT (v_style='X' AND p_caller_flag='OA') THEN
1583: DELETE qrm_saved_analyses_col WHERE analysis_name=p_name;
1584: END IF;
1585: COMMIT;
1586: --xtr_risk_debug_pkg.dlog('v_analysis_type',v_analysis_type);
1587: --xtr_risk_debug_pkg.dlog('v_style',v_style);
1588: --xtr_risk_debug_pkg.dlog('v_tb_label',v_tb_label);
1589: --xtr_risk_debug_pkg.dlog('v_tb_name',v_tb_name);
1590: --xtr_risk_debug_pkg.dlog('v_date_type',v_date_type);

Line 1587: --xtr_risk_debug_pkg.dlog('v_style',v_style);

1583: DELETE qrm_saved_analyses_col WHERE analysis_name=p_name;
1584: END IF;
1585: COMMIT;
1586: --xtr_risk_debug_pkg.dlog('v_analysis_type',v_analysis_type);
1587: --xtr_risk_debug_pkg.dlog('v_style',v_style);
1588: --xtr_risk_debug_pkg.dlog('v_tb_label',v_tb_label);
1589: --xtr_risk_debug_pkg.dlog('v_tb_name',v_tb_name);
1590: --xtr_risk_debug_pkg.dlog('v_date_type',v_date_type);
1591: --xtr_risk_debug_pkg.dlog('v_as_of_date',v_as_of_date);

Line 1588: --xtr_risk_debug_pkg.dlog('v_tb_label',v_tb_label);

1584: END IF;
1585: COMMIT;
1586: --xtr_risk_debug_pkg.dlog('v_analysis_type',v_analysis_type);
1587: --xtr_risk_debug_pkg.dlog('v_style',v_style);
1588: --xtr_risk_debug_pkg.dlog('v_tb_label',v_tb_label);
1589: --xtr_risk_debug_pkg.dlog('v_tb_name',v_tb_name);
1590: --xtr_risk_debug_pkg.dlog('v_date_type',v_date_type);
1591: --xtr_risk_debug_pkg.dlog('v_as_of_date',v_as_of_date);
1592: --xtr_risk_debug_pkg.dlog('v_start_date_ref',v_start_date_ref);

Line 1589: --xtr_risk_debug_pkg.dlog('v_tb_name',v_tb_name);

1585: COMMIT;
1586: --xtr_risk_debug_pkg.dlog('v_analysis_type',v_analysis_type);
1587: --xtr_risk_debug_pkg.dlog('v_style',v_style);
1588: --xtr_risk_debug_pkg.dlog('v_tb_label',v_tb_label);
1589: --xtr_risk_debug_pkg.dlog('v_tb_name',v_tb_name);
1590: --xtr_risk_debug_pkg.dlog('v_date_type',v_date_type);
1591: --xtr_risk_debug_pkg.dlog('v_as_of_date',v_as_of_date);
1592: --xtr_risk_debug_pkg.dlog('v_start_date_ref',v_start_date_ref);
1593: --xtr_risk_debug_pkg.dlog('v_start_date_offset',v_start_date_offset);

Line 1590: --xtr_risk_debug_pkg.dlog('v_date_type',v_date_type);

1586: --xtr_risk_debug_pkg.dlog('v_analysis_type',v_analysis_type);
1587: --xtr_risk_debug_pkg.dlog('v_style',v_style);
1588: --xtr_risk_debug_pkg.dlog('v_tb_label',v_tb_label);
1589: --xtr_risk_debug_pkg.dlog('v_tb_name',v_tb_name);
1590: --xtr_risk_debug_pkg.dlog('v_date_type',v_date_type);
1591: --xtr_risk_debug_pkg.dlog('v_as_of_date',v_as_of_date);
1592: --xtr_risk_debug_pkg.dlog('v_start_date_ref',v_start_date_ref);
1593: --xtr_risk_debug_pkg.dlog('v_start_date_offset',v_start_date_offset);
1594: --xtr_risk_debug_pkg.dlog('v_start_offset_type',v_start_offset_type);

Line 1591: --xtr_risk_debug_pkg.dlog('v_as_of_date',v_as_of_date);

1587: --xtr_risk_debug_pkg.dlog('v_style',v_style);
1588: --xtr_risk_debug_pkg.dlog('v_tb_label',v_tb_label);
1589: --xtr_risk_debug_pkg.dlog('v_tb_name',v_tb_name);
1590: --xtr_risk_debug_pkg.dlog('v_date_type',v_date_type);
1591: --xtr_risk_debug_pkg.dlog('v_as_of_date',v_as_of_date);
1592: --xtr_risk_debug_pkg.dlog('v_start_date_ref',v_start_date_ref);
1593: --xtr_risk_debug_pkg.dlog('v_start_date_offset',v_start_date_offset);
1594: --xtr_risk_debug_pkg.dlog('v_start_offset_type',v_start_offset_type);
1595: --xtr_risk_debug_pkg.dlog('v_business_week',v_business_week);

Line 1592: --xtr_risk_debug_pkg.dlog('v_start_date_ref',v_start_date_ref);

1588: --xtr_risk_debug_pkg.dlog('v_tb_label',v_tb_label);
1589: --xtr_risk_debug_pkg.dlog('v_tb_name',v_tb_name);
1590: --xtr_risk_debug_pkg.dlog('v_date_type',v_date_type);
1591: --xtr_risk_debug_pkg.dlog('v_as_of_date',v_as_of_date);
1592: --xtr_risk_debug_pkg.dlog('v_start_date_ref',v_start_date_ref);
1593: --xtr_risk_debug_pkg.dlog('v_start_date_offset',v_start_date_offset);
1594: --xtr_risk_debug_pkg.dlog('v_start_offset_type',v_start_offset_type);
1595: --xtr_risk_debug_pkg.dlog('v_business_week',v_business_week);
1596: --xtr_risk_debug_pkg.dlog('v_calendar_id',v_calendar_id);

Line 1593: --xtr_risk_debug_pkg.dlog('v_start_date_offset',v_start_date_offset);

1589: --xtr_risk_debug_pkg.dlog('v_tb_name',v_tb_name);
1590: --xtr_risk_debug_pkg.dlog('v_date_type',v_date_type);
1591: --xtr_risk_debug_pkg.dlog('v_as_of_date',v_as_of_date);
1592: --xtr_risk_debug_pkg.dlog('v_start_date_ref',v_start_date_ref);
1593: --xtr_risk_debug_pkg.dlog('v_start_date_offset',v_start_date_offset);
1594: --xtr_risk_debug_pkg.dlog('v_start_offset_type',v_start_offset_type);
1595: --xtr_risk_debug_pkg.dlog('v_business_week',v_business_week);
1596: --xtr_risk_debug_pkg.dlog('v_calendar_id',v_calendar_id);
1597: --query attributes data to from SQL statement

Line 1594: --xtr_risk_debug_pkg.dlog('v_start_offset_type',v_start_offset_type);

1590: --xtr_risk_debug_pkg.dlog('v_date_type',v_date_type);
1591: --xtr_risk_debug_pkg.dlog('v_as_of_date',v_as_of_date);
1592: --xtr_risk_debug_pkg.dlog('v_start_date_ref',v_start_date_ref);
1593: --xtr_risk_debug_pkg.dlog('v_start_date_offset',v_start_date_offset);
1594: --xtr_risk_debug_pkg.dlog('v_start_offset_type',v_start_offset_type);
1595: --xtr_risk_debug_pkg.dlog('v_business_week',v_business_week);
1596: --xtr_risk_debug_pkg.dlog('v_calendar_id',v_calendar_id);
1597: --query attributes data to from SQL statement
1598: OPEN attribute_data;

Line 1595: --xtr_risk_debug_pkg.dlog('v_business_week',v_business_week);

1591: --xtr_risk_debug_pkg.dlog('v_as_of_date',v_as_of_date);
1592: --xtr_risk_debug_pkg.dlog('v_start_date_ref',v_start_date_ref);
1593: --xtr_risk_debug_pkg.dlog('v_start_date_offset',v_start_date_offset);
1594: --xtr_risk_debug_pkg.dlog('v_start_offset_type',v_start_offset_type);
1595: --xtr_risk_debug_pkg.dlog('v_business_week',v_business_week);
1596: --xtr_risk_debug_pkg.dlog('v_calendar_id',v_calendar_id);
1597: --query attributes data to from SQL statement
1598: OPEN attribute_data;
1599: FETCH attribute_data BULK COLLECT INTO v_dummy1,v_col_order,v_agg,v_att_type,

Line 1596: --xtr_risk_debug_pkg.dlog('v_calendar_id',v_calendar_id);

1592: --xtr_risk_debug_pkg.dlog('v_start_date_ref',v_start_date_ref);
1593: --xtr_risk_debug_pkg.dlog('v_start_date_offset',v_start_date_offset);
1594: --xtr_risk_debug_pkg.dlog('v_start_offset_type',v_start_offset_type);
1595: --xtr_risk_debug_pkg.dlog('v_business_week',v_business_week);
1596: --xtr_risk_debug_pkg.dlog('v_calendar_id',v_calendar_id);
1597: --query attributes data to from SQL statement
1598: OPEN attribute_data;
1599: FETCH attribute_data BULK COLLECT INTO v_dummy1,v_col_order,v_agg,v_att_type,
1600: v_tot_avg,v_percent,v_nom_fl,v_denom_fl,v_origin,v_amount,

Line 1603: --xtr_risk_debug_pkg.dlog('v_agg.COUNT',v_agg.COUNT);

1599: FETCH attribute_data BULK COLLECT INTO v_dummy1,v_col_order,v_agg,v_att_type,
1600: v_tot_avg,v_percent,v_nom_fl,v_denom_fl,v_origin,v_amount,
1601: v_ccy_aggregate,v_sensitivity,v_num_denom_origin;
1602: CLOSE attribute_data;
1603: --xtr_risk_debug_pkg.dlog('v_agg.COUNT',v_agg.COUNT);
1604: --use some logic to determine what the report underlying currency is
1605: --First, find if there is any AMOUNT type
1606: --bec. amount typemeas. are the only one that can be converted to diff ccy
1607: FOR i IN 1..v_amount.LAST LOOP

Line 1618: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_suffix',v_ccy_suffix);

1614: v_ccy_case_flag,v_agg(i),v_ccy_agg_level,
1615: v_table_col_curr,v_agg_col_curr,
1616: NULL);
1617: IF (g_proc_level>=g_debug_level) THEN
1618: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_suffix',v_ccy_suffix);
1619: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_multiplier',v_ccy_multiplier);
1620: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_case_flag',v_ccy_case_flag);
1621: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_flag',v_ccy_agg_flag);
1622: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_level',v_ccy_agg_level);

Line 1619: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_multiplier',v_ccy_multiplier);

1615: v_table_col_curr,v_agg_col_curr,
1616: NULL);
1617: IF (g_proc_level>=g_debug_level) THEN
1618: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_suffix',v_ccy_suffix);
1619: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_multiplier',v_ccy_multiplier);
1620: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_case_flag',v_ccy_case_flag);
1621: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_flag',v_ccy_agg_flag);
1622: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_level',v_ccy_agg_level);
1623: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'After get_underlying_ccy: v_underlying_ccy',v_underlying_ccy);

Line 1620: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_case_flag',v_ccy_case_flag);

1616: NULL);
1617: IF (g_proc_level>=g_debug_level) THEN
1618: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_suffix',v_ccy_suffix);
1619: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_multiplier',v_ccy_multiplier);
1620: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_case_flag',v_ccy_case_flag);
1621: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_flag',v_ccy_agg_flag);
1622: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_level',v_ccy_agg_level);
1623: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'After get_underlying_ccy: v_underlying_ccy',v_underlying_ccy);
1624: END IF;

Line 1621: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_flag',v_ccy_agg_flag);

1617: IF (g_proc_level>=g_debug_level) THEN
1618: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_suffix',v_ccy_suffix);
1619: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_multiplier',v_ccy_multiplier);
1620: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_case_flag',v_ccy_case_flag);
1621: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_flag',v_ccy_agg_flag);
1622: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_level',v_ccy_agg_level);
1623: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'After get_underlying_ccy: v_underlying_ccy',v_underlying_ccy);
1624: END IF;
1625: --see whether need USD array container if Total CCY is diff.

Line 1622: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_level',v_ccy_agg_level);

1618: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_suffix',v_ccy_suffix);
1619: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_multiplier',v_ccy_multiplier);
1620: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_case_flag',v_ccy_case_flag);
1621: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_flag',v_ccy_agg_flag);
1622: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_level',v_ccy_agg_level);
1623: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'After get_underlying_ccy: v_underlying_ccy',v_underlying_ccy);
1624: END IF;
1625: --see whether need USD array container if Total CCY is diff.
1626: --from CCY used

Line 1623: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'After get_underlying_ccy: v_underlying_ccy',v_underlying_ccy);

1619: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_multiplier',v_ccy_multiplier);
1620: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_case_flag',v_ccy_case_flag);
1621: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_flag',v_ccy_agg_flag);
1622: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_ccy_agg_level',v_ccy_agg_level);
1623: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'After get_underlying_ccy: v_underlying_ccy',v_underlying_ccy);
1624: END IF;
1625: --see whether need USD array container if Total CCY is diff.
1626: --from CCY used
1627: IF (v_ccy_case_flag=0 AND v_ccy_agg_flag>0) THEN

Line 1633: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_need_usd_arr',v_need_usd_arr);

1629: ELSE
1630: v_need_usd_arr := FALSE;
1631: END IF;
1632: IF (g_proc_level>=g_debug_level) THEN
1633: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_need_usd_arr',v_need_usd_arr);
1634: END IF;
1635: EXIT;
1636: END IF;
1637: END LOOP;

Line 1663: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_ANALYSIS_SETTINGS.CURRENCY_USED',

1659: WHERE analysis_name=p_name AND history_flag='S';
1660: END IF;
1661:
1662: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1663: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_ANALYSIS_SETTINGS.CURRENCY_USED',
1664: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);
1665: END IF;
1666:
1667: --Fix end date to be used later, alrady calculated and saved by FHU engine

Line 1679: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'LENGTH(v_sql)',LENGTH(v_sql));

1675: v_ccy_multiplier,v_amount,v_table_col_curr,v_num_denom_origin,
1676: v_curr_reporting,v_sensitivity);
1677:
1678: IF (g_proc_level>=g_debug_level) THEN
1679: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'LENGTH(v_sql)',LENGTH(v_sql));
1680: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_sql',v_sql);
1681: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_sql_col',v_sql_col);
1682: END IF;
1683:

Line 1680: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_sql',v_sql);

1676: v_curr_reporting,v_sensitivity);
1677:
1678: IF (g_proc_level>=g_debug_level) THEN
1679: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'LENGTH(v_sql)',LENGTH(v_sql));
1680: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_sql',v_sql);
1681: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_sql_col',v_sql_col);
1682: END IF;
1683:
1684: IF v_style='X' AND p_caller_flag='OA' THEN

Line 1681: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_sql_col',v_sql_col);

1677:
1678: IF (g_proc_level>=g_debug_level) THEN
1679: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'LENGTH(v_sql)',LENGTH(v_sql));
1680: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_sql',v_sql);
1681: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_sql_col',v_sql_col);
1682: END IF;
1683:
1684: IF v_style='X' AND p_caller_flag='OA' THEN
1685: OPEN count_max_col_no;

Line 1728: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_max_col_no',v_max_col_no);

1724: END IF;
1725:
1726: v_max_col_no := v_col.COUNT;
1727: IF (g_proc_level>=g_debug_level) THEN
1728: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_max_col_no',v_max_col_no);
1729: END IF;
1730: --construct v_seq_no, v_col_name_map, v_hidden, v_type
1731: v_col_seq_no.EXTEND(v_max_col_no);
1732: v_col_seq_no_key.EXTEND(v_max_col_no);

Line 1826: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'i:seq_no:seq_no_key:a1',i||':'||v_col_seq_no(i)||':'||v_col_seq_no_key(i)||':'||v_a1(i));

1822:
1823: -------------Testing purposes
1824: FOR i IN 1..v_row_agg_no+v_max_col_no LOOP
1825: IF (g_proc_level>=g_debug_level) THEN
1826: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'i:seq_no:seq_no_key:a1',i||':'||v_col_seq_no(i)||':'||v_col_seq_no_key(i)||':'||v_a1(i));
1827: END IF;
1828: -- xtr_risk_debug_pkg.dlog('i:type:hidden:col_name_map:percent_col_name_map',i||':'||v_col_type(i)||':'||v_col_hidden(i)||':'||v_col_name_map(i)||':'||v_percent_col_name_map(i)||':');
1829: IF v_style='X' THEN
1830: IF (g_proc_level>=g_debug_level) THEN

Line 1828: -- xtr_risk_debug_pkg.dlog('i:type:hidden:col_name_map:percent_col_name_map',i||':'||v_col_type(i)||':'||v_col_hidden(i)||':'||v_col_name_map(i)||':'||v_percent_col_name_map(i)||':');

1824: FOR i IN 1..v_row_agg_no+v_max_col_no LOOP
1825: IF (g_proc_level>=g_debug_level) THEN
1826: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'i:seq_no:seq_no_key:a1',i||':'||v_col_seq_no(i)||':'||v_col_seq_no_key(i)||':'||v_a1(i));
1827: END IF;
1828: -- xtr_risk_debug_pkg.dlog('i:type:hidden:col_name_map:percent_col_name_map',i||':'||v_col_type(i)||':'||v_col_hidden(i)||':'||v_col_name_map(i)||':'||v_percent_col_name_map(i)||':');
1829: IF v_style='X' THEN
1830: IF (g_proc_level>=g_debug_level) THEN
1831: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'i:start:end',i||':'||v_start_date(i)||':'||v_end_date(i));
1832: END IF;

Line 1831: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'i:start:end',i||':'||v_start_date(i)||':'||v_end_date(i));

1827: END IF;
1828: -- xtr_risk_debug_pkg.dlog('i:type:hidden:col_name_map:percent_col_name_map',i||':'||v_col_type(i)||':'||v_col_hidden(i)||':'||v_col_name_map(i)||':'||v_percent_col_name_map(i)||':');
1829: IF v_style='X' THEN
1830: IF (g_proc_level>=g_debug_level) THEN
1831: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'i:start:end',i||':'||v_start_date(i)||':'||v_end_date(i));
1832: END IF;
1833: END IF;
1834: END LOOP;
1835: -------------End Testing purposes

Line 1866: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_SAVED_ANALYSES_COL',

1862: END IF;
1863: COMMIT;
1864:
1865: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1866: XTR_RISK_DEBUG_PKG.dlog('DML','Inserted into QRM_SAVED_ANALYSES_COL',
1867: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);
1868: END IF;
1869:
1870: ----Start Bug 2566711

Line 1901: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.TOT_CURRENCY',

1897: ----End Bug 2566711
1898: COMMIT;
1899:
1900: IF (g_event_level>=g_debug_level) THEN --bug 3236479
1901: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.TOT_CURRENCY',
1902: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);
1903: END IF;
1904:
1905: END IF;--for p_caller_flag='OA' and v_style='X'

Line 1935: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_tb_calc_used',v_tb_calc_used);

1931: dbms_sql.bind_variable(v_cursor,'analysis_name',p_name);
1932: --remember to add end_date as binding variable
1933: --for special cases
1934: IF (g_proc_level>=g_debug_level) THEN
1935: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_tb_calc_used',v_tb_calc_used);
1936: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_end_date_fix',v_end_date_fix);
1937: END IF;
1938: IF v_style='X' THEN
1939: IF v_analysis_type<>'P' THEN

Line 1936: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_end_date_fix',v_end_date_fix);

1932: --remember to add end_date as binding variable
1933: --for special cases
1934: IF (g_proc_level>=g_debug_level) THEN
1935: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_tb_calc_used',v_tb_calc_used);
1936: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_end_date_fix',v_end_date_fix);
1937: END IF;
1938: IF v_style='X' THEN
1939: IF v_analysis_type<>'P' THEN
1940: dbms_sql.bind_variable(v_cursor,'ref_date',TRUNC(p_ref_date));

Line 1959: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_measure_no',v_measure_no);

1955: FOR i IN 1..v_row_agg_no LOOP
1956: dbms_sql.define_column(v_cursor,i,v_header(i),20);
1957: END LOOP;
1958: IF (g_proc_level>=g_debug_level) THEN
1959: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_measure_no',v_measure_no);
1960: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_all_meas_no',v_all_meas_no||':'||v_measure.COUNT);
1961: END IF;
1962: FOR i IN 1..v_all_meas_no LOOP
1963: dbms_sql.define_column(v_cursor,i+v_row_agg_no,v_measure(i));

Line 1960: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_all_meas_no',v_all_meas_no||':'||v_measure.COUNT);

1956: dbms_sql.define_column(v_cursor,i,v_header(i),20);
1957: END LOOP;
1958: IF (g_proc_level>=g_debug_level) THEN
1959: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_measure_no',v_measure_no);
1960: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_all_meas_no',v_all_meas_no||':'||v_measure.COUNT);
1961: END IF;
1962: FOR i IN 1..v_all_meas_no LOOP
1963: dbms_sql.define_column(v_cursor,i+v_row_agg_no,v_measure(i));
1964: END LOOP;

Line 1968: --xtr_risk_debug_pkg.dlog('v_cursor = ',v_cursor);

1964: END LOOP;
1965:
1966: --execute
1967: v_rows_processed := dbms_sql.execute(v_cursor);
1968: --xtr_risk_debug_pkg.dlog('v_cursor = ',v_cursor);
1969: --xtr_risk_debug_pkg.dlog('v_rows_processed = ',v_rows_processed);
1970:
1971: --calculate multiplier to be used in the total array for style=A
1972: IF v_need_usd_arr THEN -- need to consider USD array then

Line 1969: --xtr_risk_debug_pkg.dlog('v_rows_processed = ',v_rows_processed);

1965:
1966: --execute
1967: v_rows_processed := dbms_sql.execute(v_cursor);
1968: --xtr_risk_debug_pkg.dlog('v_cursor = ',v_cursor);
1969: --xtr_risk_debug_pkg.dlog('v_rows_processed = ',v_rows_processed);
1970:
1971: --calculate multiplier to be used in the total array for style=A
1972: IF v_need_usd_arr THEN -- need to consider USD array then
1973: m := 4;

Line 1999: --xtr_risk_debug_pkg.dlog('v_header(i)',i||':'||v_header(i));

1995: IF dbms_sql.fetch_rows(v_cursor)>0 THEN
1996: --fetch header/VARCHAR type
1997: FOR i IN 1..v_row_agg_no LOOP
1998: dbms_sql.column_value(v_cursor,i,v_header(i));
1999: --xtr_risk_debug_pkg.dlog('v_header(i)',i||':'||v_header(i));
2000: END LOOP;
2001:
2002: --first reset the indicator
2003: v_skip_row := FALSE;

Line 2477: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_successT',v_success);

2473:
2474: --update total
2475: v_success := update_total(p_name,p_ref_date);
2476: IF (g_proc_level>=g_debug_level) THEN
2477: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_successT',v_success);
2478: END IF;
2479: IF NOT v_success THEN
2480: RAISE e_pagg_update_total_fail;
2481: END IF;

Line 2488: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_successCurr',v_success);

2484: v_ccy_agg_flag,v_ccy_agg_level,v_row_agg_no,v_max_col_no,
2485: v_underlying_ccy,v_currency_source,v_curr_reporting,v_agg_col_curr);
2486:
2487: IF (g_proc_level>=g_debug_level) THEN
2488: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_successCurr',v_success);
2489: END IF;
2490: IF NOT v_success THEN
2491: RAISE e_pagg_update_agg_curr_fail;
2492: END IF;

Line 2497: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_success%',v_success);

2493: --update percent
2494: v_success := update_percent (p_name,v_style,v_row_agg_no,v_max_col_no,
2495: p_ref_date,v_md_set_code);
2496: IF (g_proc_level>=g_debug_level) THEN
2497: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_success%',v_success);
2498: END IF;
2499: IF NOT v_success THEN
2500: RAISE e_pagg_update_percent_fail;
2501: END IF;

Line 2505: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_successL',v_success);

2501: END IF;
2502: IF v_style='C' THEN
2503: v_success := update_label(p_name,v_agg,v_col_order,v_att_type,p_ref_date);
2504: IF (g_proc_level>=g_debug_level) THEN
2505: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_successL',v_success);
2506: END IF;
2507: IF NOT v_success THEN
2508: RAISE e_pagg_update_label_fail;
2509: END IF;

Line 2515: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_successTBLabel',v_success);

2511: --update timebuckets label
2512: IF v_style='X' AND p_caller_flag='OA' THEN
2513: v_success := update_timebuckets_label(p_name);
2514: IF (g_proc_level>=g_debug_level) THEN
2515: xtr_risk_debug_pkg.dlog('transform_and_save: ' || 'v_successTBLabel',v_success);
2516: END IF;
2517: IF NOT v_success THEN
2518: RAISE e_pagg_update_tb_label_fail;
2519: END IF;

Line 2527: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_ANALYSIS_SETTINGS.DIRTY=N',

2523: IF p_caller_flag='OA' THEN
2524: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;
2525:
2526: IF (g_event_level>=g_debug_level) THEN --bug 3236479
2527: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_ANALYSIS_SETTINGS.DIRTY=N',
2528: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);
2529: END IF;
2530:
2531: END IF;

Line 2535: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE');

2531: END IF;
2532:
2533: COMMIT;
2534: IF (g_proc_level>=g_debug_level) THEN
2535: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE');
2536: END IF;
2537: RETURN 'T';
2538:
2539: EXCEPTION

Line 2547: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_fxrate_found','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479

2543: ELSE
2544: fnd_msg_pub.add;
2545: END IF;
2546: IF (g_error_level>=g_debug_level) THEN
2547: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_fxrate_found','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479
2548: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');
2549: END IF;
2550: RETURN 'F';
2551: WHEN e_pagg_no_timebuckets_found THEN

Line 2548: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');

2544: fnd_msg_pub.add;
2545: END IF;
2546: IF (g_error_level>=g_debug_level) THEN
2547: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_fxrate_found','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479
2548: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');
2549: END IF;
2550: RETURN 'F';
2551: WHEN e_pagg_no_timebuckets_found THEN
2552: IF p_caller_flag='CONC' THEN

Line 2558: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_timebuckets_found','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479

2554: ELSE
2555: fnd_msg_pub.add;
2556: END IF;
2557: IF (g_error_level>=g_debug_level) THEN
2558: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_timebuckets_found','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479
2559: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');
2560: END IF;
2561: RETURN 'F';
2562: WHEN e_pagg_no_setting_found THEN

Line 2559: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');

2555: fnd_msg_pub.add;
2556: END IF;
2557: IF (g_error_level>=g_debug_level) THEN
2558: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_timebuckets_found','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479
2559: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');
2560: END IF;
2561: RETURN 'F';
2562: WHEN e_pagg_no_setting_found THEN
2563: IF p_caller_flag='CONC' THEN

Line 2569: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_setting_found','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479

2565: ELSE
2566: fnd_msg_pub.add;
2567: END IF;
2568: IF (g_error_level>=g_debug_level) THEN
2569: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_setting_found','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479
2570: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');
2571: END IF;
2572: RETURN 'F';
2573: WHEN OTHERS THEN

Line 2570: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');

2566: fnd_msg_pub.add;
2567: END IF;
2568: IF (g_error_level>=g_debug_level) THEN
2569: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_setting_found','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479
2570: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');
2571: END IF;
2572: RETURN 'F';
2573: WHEN OTHERS THEN
2574: IF p_caller_flag='OA' THEN

Line 2579: xtr_risk_debug_pkg.dlog('EXCEPTION','others','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479

2575: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_UNEXPECTED_ERROR');
2576: fnd_msg_pub.add;
2577: END IF;
2578: IF (g_error_level>=g_debug_level) THEN
2579: xtr_risk_debug_pkg.dlog('EXCEPTION','others','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479
2580: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');
2581: END IF;
2582: RETURN 'F';
2583: END transform_and_save;

Line 2580: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');

2576: fnd_msg_pub.add;
2577: END IF;
2578: IF (g_error_level>=g_debug_level) THEN
2579: xtr_risk_debug_pkg.dlog('EXCEPTION','others','QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_error_level);--bug 3236479
2580: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');
2581: END IF;
2582: RETURN 'F';
2583: END transform_and_save;
2584:

Line 2611: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.FIND_GL_BUSINESS_DAY');

2607: v_found BOOLEAN := FALSE;
2608: BEGIN
2609:
2610: IF (g_proc_level>=g_debug_level) THEN --bug 3236479
2611: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.FIND_GL_BUSINESS_DAY');
2612: END IF;
2613:
2614: IF p_calendar_id IS NULL THEN
2615: v_date_out := p_date_in;

Line 2638: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.FIND_GL_BUSINESS_DAY');

2634: END IF;
2635: END IF;
2636:
2637: IF (g_proc_level>=g_debug_level) THEN --bug 3236479
2638: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.FIND_GL_BUSINESS_DAY');
2639: END IF;
2640:
2641: RETURN v_date_out;
2642: EXCEPTION

Line 2646: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.FIND_GL_BUSINESS_DAY',g_error_level);

2642: EXCEPTION
2643: WHEN OTHERS THEN
2644:
2645: IF (g_error_level>=g_debug_level) THEN --bug 3236479
2646: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.FIND_GL_BUSINESS_DAY',g_error_level);
2647: END IF;
2648:
2649: RETURN p_date_in;
2650: END find_gl_business_days;

Line 2710: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.get_beg_end_of_week');

2706: v_offset NUMBER;
2707: --
2708: BEGIN
2709: IF (g_proc_level>=g_debug_level) THEN
2710: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.get_beg_end_of_week');
2711: END IF;
2712:
2713: OPEN days_of_week_cursor;
2714: FETCH days_of_week_cursor INTO v_fri,v_sat,v_sun,v_mon,v_tue,v_wed,v_thu;

Line 2755: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_last_nonbus_day',v_last_nonbus_day);

2751: END LOOP;
2752: END IF;
2753:
2754: IF (g_proc_level>=g_debug_level) THEN
2755: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_last_nonbus_day',v_last_nonbus_day);
2756: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_nonbus_count',v_nonbus_count);
2757: END IF;
2758:
2759: IF v_nonbus_count <= 0 OR v_nonbus_count >= 7 THEN

Line 2756: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_nonbus_count',v_nonbus_count);

2752: END IF;
2753:
2754: IF (g_proc_level>=g_debug_level) THEN
2755: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_last_nonbus_day',v_last_nonbus_day);
2756: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_nonbus_count',v_nonbus_count);
2757: END IF;
2758:
2759: IF v_nonbus_count <= 0 OR v_nonbus_count >= 7 THEN
2760: p_beg_date := trunc(p_ref_date,'D');

Line 2786: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_ref_day',v_ref_day);

2782: p_beg_date := trunc(p_ref_date) - v_days_before;
2783: p_end_date := trunc(p_ref_date) + (7 - (v_days_before + v_nonbus_count) - 1);
2784:
2785: IF (g_proc_level>=g_debug_level) THEN
2786: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_ref_day',v_ref_day);
2787: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_days_before',v_days_before);
2788: END IF;
2789: END IF;
2790:

Line 2787: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_days_before',v_days_before);

2783: p_end_date := trunc(p_ref_date) + (7 - (v_days_before + v_nonbus_count) - 1);
2784:
2785: IF (g_proc_level>=g_debug_level) THEN
2786: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_ref_day',v_ref_day);
2787: xtr_risk_debug_pkg.dlog('get_beg_end_of_week: ' || 'v_days_before',v_days_before);
2788: END IF;
2789: END IF;
2790:
2791: IF (g_proc_level>=g_debug_level) THEN

Line 2792: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGRREGATION_P.get_beg_end_of_week');

2788: END IF;
2789: END IF;
2790:
2791: IF (g_proc_level>=g_debug_level) THEN
2792: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGRREGATION_P.get_beg_end_of_week');
2793: END IF;
2794: END get_beg_end_of_week;
2795:
2796:

Line 2816: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGRREGATION_P.CALCULATE_RELATIVE_DATE');

2812: v_dummy DATE;
2813: BEGIN
2814:
2815: IF (g_proc_level>=g_debug_level) THEN --bug 3236479
2816: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGRREGATION_P.CALCULATE_RELATIVE_DATE');
2817: END IF;
2818:
2819: --see whether the as of date is fixed or relative
2820: IF p_date_type='F' THEN

Line 2823: xtr_risk_debug_pkg.dlog('calculate_relative_date: ' || 'v_date',v_date);

2819: --see whether the as of date is fixed or relative
2820: IF p_date_type='F' THEN
2821: v_date := TRUNC(p_as_of_date);
2822: IF (g_proc_level>=g_debug_level) THEN
2823: xtr_risk_debug_pkg.dlog('calculate_relative_date: ' || 'v_date',v_date);
2824: END IF;
2825: ELSE
2826: --reference
2827: IF p_start_date_ref='BW' THEN --Beginning of Week

Line 2862: xtr_risk_debug_pkg.dlog('calculate_relative_date: ' || 'v_date',v_date);

2858: END IF;
2859: END IF;
2860: END IF;
2861: IF (g_proc_level>=g_debug_level) THEN
2862: xtr_risk_debug_pkg.dlog('calculate_relative_date: ' || 'v_date',v_date);
2863: xtr_risk_debug_pkg.dlog('calculate_relative_date: ' || 'p_calendar_id',p_calendar_id);
2864: END IF;
2865: --Only check holiday if p_business_week='C' otherwise
2866: --assume 7-days-week

Line 2863: xtr_risk_debug_pkg.dlog('calculate_relative_date: ' || 'p_calendar_id',p_calendar_id);

2859: END IF;
2860: END IF;
2861: IF (g_proc_level>=g_debug_level) THEN
2862: xtr_risk_debug_pkg.dlog('calculate_relative_date: ' || 'v_date',v_date);
2863: xtr_risk_debug_pkg.dlog('calculate_relative_date: ' || 'p_calendar_id',p_calendar_id);
2864: END IF;
2865: --Only check holiday if p_business_week='C' otherwise
2866: --assume 7-days-week
2867: IF p_business_week='C' THEN

Line 2873: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGRREGATION_P.CALCULATE_RELATIVE_DATE');

2869: v_date, p_calendar_id);
2870: END IF;
2871:
2872: IF (g_proc_level>=g_debug_level) THEN --bug 3236479
2873: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGRREGATION_P.CALCULATE_RELATIVE_DATE');
2874: END IF;
2875:
2876: RETURN v_date;
2877: END calculate_relative_date;

Line 2927: xtr_risk_debug_pkg.dpush(null,'QRM_PA_P.UPDATE_TIMEBUCKETS'); --bug3236479

2923: i NUMBER(5);
2924: j NUMBER(5);
2925: BEGIN
2926: IF (g_proc_level>=g_debug_level) THEN
2927: xtr_risk_debug_pkg.dpush(null,'QRM_PA_P.UPDATE_TIMEBUCKETS'); --bug3236479
2928: END IF;
2929:
2930: --check whether time buckets exist
2931: OPEN v_find_tb;

Line 2983: xtr_risk_debug_pkg.dlog('p_start_date(i)',i||':'||p_start_date(i));

2979: --need the -1 since timebucket start and end date cannot overlap.
2980: v_prev_end_date := p_start_date(i);
2981: END IF;
2982: IF (g_proc_level>=g_debug_level) THEN
2983: xtr_risk_debug_pkg.dlog('p_start_date(i)',i||':'||p_start_date(i));
2984: END IF;
2985: xtr_risk_debug_pkg.dlog('v_int_type(i),v_int_length(i)',i||':'||v_int_type(i-p_row_agg_no)||','||v_int_length(i-p_row_agg_no));
2986: IF (g_proc_level>=g_debug_level) THEN
2987: xtr_risk_debug_pkg.dlog('v_prev_end_date',v_prev_end_date);

Line 2985: xtr_risk_debug_pkg.dlog('v_int_type(i),v_int_length(i)',i||':'||v_int_type(i-p_row_agg_no)||','||v_int_length(i-p_row_agg_no));

2981: END IF;
2982: IF (g_proc_level>=g_debug_level) THEN
2983: xtr_risk_debug_pkg.dlog('p_start_date(i)',i||':'||p_start_date(i));
2984: END IF;
2985: xtr_risk_debug_pkg.dlog('v_int_type(i),v_int_length(i)',i||':'||v_int_type(i-p_row_agg_no)||','||v_int_length(i-p_row_agg_no));
2986: IF (g_proc_level>=g_debug_level) THEN
2987: xtr_risk_debug_pkg.dlog('v_prev_end_date',v_prev_end_date);
2988: END IF;
2989: --find temp end date

Line 2987: xtr_risk_debug_pkg.dlog('v_prev_end_date',v_prev_end_date);

2983: xtr_risk_debug_pkg.dlog('p_start_date(i)',i||':'||p_start_date(i));
2984: END IF;
2985: xtr_risk_debug_pkg.dlog('v_int_type(i),v_int_length(i)',i||':'||v_int_type(i-p_row_agg_no)||','||v_int_length(i-p_row_agg_no));
2986: IF (g_proc_level>=g_debug_level) THEN
2987: xtr_risk_debug_pkg.dlog('v_prev_end_date',v_prev_end_date);
2988: END IF;
2989: --find temp end date
2990: IF v_int_type(i-p_row_agg_no)='D' THEN
2991: v_date := v_prev_end_date+v_int_length(i-p_row_agg_no);

Line 3008: --xtr_risk_debug_pkg.dlog('p_end_date(i)',i||':'||p_end_date(i));

3004: p_end_date(i) := find_gl_business_days('B',v_date-1,p_calendar_id);
3005: ELSE
3006: p_end_date(i) := v_date-1;
3007: END IF;
3008: --xtr_risk_debug_pkg.dlog('p_end_date(i)',i||':'||p_end_date(i));
3009: p_col_seq_no(i) := i;
3010: p_col_seq_no_key(i) := TO_CHAR(i);
3011: p_col_name_map(i) := 'M'||TO_CHAR(i-p_row_agg_no);
3012: p_percent_col_name_map(i) := 'P'||TO_CHAR(i-p_row_agg_no);

Line 3025: xtr_risk_debug_pkg.dpop(null,'QRM_PA_P.UPDATE_TIMEBUCKETS');--bug 3236479

3021: p_col_hidden(i) := 'N';
3022: END LOOP;
3023:
3024: IF (g_proc_level>=g_debug_level) THEN
3025: xtr_risk_debug_pkg.dpop(null,'QRM_PA_P.UPDATE_TIMEBUCKETS');--bug 3236479
3026: END IF;
3027: END update_timebuckets;
3028:
3029:

Line 3076: xtr_risk_debug_pkg.dpush(null,'QRM_PA_P.CALC_TB_START_END_DATE');--bug 3236479

3072: v_max_col_no NUMBER;
3073:
3074: BEGIN
3075: IF (g_proc_level>=g_debug_level) THEN
3076: xtr_risk_debug_pkg.dpush(null,'QRM_PA_P.CALC_TB_START_END_DATE');--bug 3236479
3077: END IF;
3078: --need to swap because the END_DATE is the start date for the
3079: --timebuckets
3080: update_timebuckets(p_name, p_ref_date, p_tb_name, p_tb_label, p_end_date,

Line 3095: xtr_risk_debug_pkg.dpop(null,'QRM_PA_P.CALC_TB_START_END_DATE');--bug 3236479

3091: p_start_offset_type := p_end_offset_type;
3092: p_end_date := v_end_date(v_end_date.LAST);
3093:
3094: IF (g_proc_level>=g_debug_level) THEN
3095: xtr_risk_debug_pkg.dpop(null,'QRM_PA_P.CALC_TB_START_END_DATE');--bug 3236479
3096: END IF;
3097: END calc_tb_start_end_dates;
3098:
3099:

Line 3108: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_TOTAL');--bug 3236479

3104: ***************************************************************/
3105: FUNCTION update_total(p_name VARCHAR2, p_ref_date DATE) RETURN BOOLEAN IS
3106: BEGIN
3107: IF (g_proc_level>=g_debug_level) THEN
3108: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_TOTAL');--bug 3236479
3109: END IF;
3110: --update qrm_saved_analyses_row first
3111: --set all the total rows to be hidden
3112: UPDATE qrm_saved_analyses_row

Line 3117: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_ROW.HIDDEN=Y',

3113: SET hidden='Y', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3114: WHERE type>0 AND analysis_name=p_name;
3115:
3116: IF (g_event_level>=g_debug_level) THEN --bug 3236479
3117: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_ROW.HIDDEN=Y',
3118: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);
3119: END IF;
3120:
3121: --set selected total rows to be displayed

Line 3132: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_ROW.HIDDEN=N for those that need to be displayed',

3128: AND type='R'
3129: AND history_flag='S');
3130:
3131: IF (g_event_level>=g_debug_level) THEN --bug 3236479
3132: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_ROW.HIDDEN=N for those that need to be displayed',
3133: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);
3134: END IF;
3135:
3136: --update qrm_saved_analyses_col

Line 3143: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.HIDDEN=Y',

3139: SET hidden='Y', last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3140: WHERE type>0 AND analysis_name=p_name;
3141:
3142: IF (g_event_level>=g_debug_level) THEN --bug 3236479
3143: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.HIDDEN=Y',
3144: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);
3145: END IF;
3146:
3147: --set selected total rows to be displayed

Line 3158: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.HIDDEN=N for those that need to be displayed',

3154: AND type='C'
3155: AND history_flag='S');
3156:
3157: IF (g_event_level>=g_debug_level) THEN --bug 3236479
3158: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.HIDDEN=N for those that need to be displayed',
3159: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);
3160: END IF;
3161:
3162: COMMIT;

Line 3164: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_TOTAL');--bug 3236479

3160: END IF;
3161:
3162: COMMIT;
3163: IF (g_proc_level>=g_debug_level) THEN
3164: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_TOTAL');--bug 3236479
3165: END IF;
3166: RETURN TRUE;
3167: EXCEPTION
3168: WHEN OTHERS THEN

Line 3170: --xtr_risk_debug_pkg.dpop('QRM_PA_AGGREGATION_P.UPDATE_TOTAL');

3166: RETURN TRUE;
3167: EXCEPTION
3168: WHEN OTHERS THEN
3169: IF (g_error_level>=g_debug_level) THEN
3170: --xtr_risk_debug_pkg.dpop('QRM_PA_AGGREGATION_P.UPDATE_TOTAL');
3171: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_error_level);--bug 3236479
3172: END IF;
3173: RETURN FALSE;
3174: END update_total;

Line 3171: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_error_level);--bug 3236479

3167: EXCEPTION
3168: WHEN OTHERS THEN
3169: IF (g_error_level>=g_debug_level) THEN
3170: --xtr_risk_debug_pkg.dpop('QRM_PA_AGGREGATION_P.UPDATE_TOTAL');
3171: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_error_level);--bug 3236479
3172: END IF;
3173: RETURN FALSE;
3174: END update_total;
3175:

Line 3190: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');--bug 3236479

3186: RETURN BOOLEAN IS
3187: BEGIN
3188:
3189: IF (g_proc_level>=g_debug_level) THEN
3190: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');--bug 3236479
3191: END IF;
3192:
3193: UPDATE qrm_saved_analyses_row
3194: SET p1=p_meas(1),p2=p_meas(2),p3=p_meas(3),

Line 3262: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');--bug 3236479

3258: WHERE analysis_name=p_name
3259: AND seq_no=p_row;
3260:
3261: IF (g_proc_level>=g_debug_level) THEN
3262: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');--bug 3236479
3263: END IF;
3264:
3265: RETURN TRUE;
3266: EXCEPTION

Line 3269: --xtr_risk_debug_pkg.dpop('QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');

3265: RETURN TRUE;
3266: EXCEPTION
3267: WHEN OTHERS THEN
3268: IF (g_proc_level>=g_debug_level) THEN
3269: --xtr_risk_debug_pkg.dpop('QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');
3270: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');--bug 3236479
3271: END IF;
3272: RETURN FALSE;
3273: END update_percent_cols;

Line 3270: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');--bug 3236479

3266: EXCEPTION
3267: WHEN OTHERS THEN
3268: IF (g_proc_level>=g_debug_level) THEN
3269: --xtr_risk_debug_pkg.dpop('QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');
3270: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.UPDATE_PERCENT_COLS');--bug 3236479
3271: END IF;
3272: RETURN FALSE;
3273: END update_percent_cols;
3274:

Line 3324: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.TRANSLATE_TO_USD');

3320:
3321: BEGIN
3322:
3323: IF (g_proc_level>=g_debug_level) THEN
3324: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.TRANSLATE_TO_USD');
3325: END IF;
3326:
3327: OPEN get_all_measures;
3328: v_meas.EXTEND(100);

Line 3330: --xtr_risk_debug_pkg.dlog('p_name',p_name);

3326:
3327: OPEN get_all_measures;
3328: v_meas.EXTEND(100);
3329: v_ccy.EXTEND(100);
3330: --xtr_risk_debug_pkg.dlog('p_name',p_name);
3331: LOOP
3332: FETCH get_all_measures INTO
3333: v_row,v_level,v_meas(1),v_meas(2),v_meas(3),v_meas(4),v_meas(5),
3334: v_meas(6),v_meas(7),v_meas(8),v_meas(9),v_meas(10),v_meas(11),

Line 3418: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.TRANSLATE_TO_USD'); --bug 3236479

3414: END LOOP;
3415: CLOSE get_all_measures;
3416:
3417: IF (g_proc_level>=g_debug_level) THEN
3418: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.TRANSLATE_TO_USD'); --bug 3236479
3419: END IF;
3420:
3421: RETURN TRUE;
3422:

Line 3426: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.TRANSLATE_TO_USD',g_error_level);--bug 3236479

3422:
3423: EXCEPTION
3424: WHEN OTHERS THEN
3425: IF (g_error_level>=g_debug_level) THEN
3426: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.TRANSLATE_TO_USD',g_error_level);--bug 3236479
3427: END IF;
3428: RETURN FALSE;
3429: END translate_to_usd;
3430:

Line 3461: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT'); --bug 3236479

3457:
3458: BEGIN
3459:
3460: IF (g_proc_level>=g_debug_level) THEN
3461: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT'); --bug 3236479
3462: END IF;
3463:
3464: OPEN count_column;
3465: FETCH count_column INTO v_max_col_no;

Line 3477: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT'); --bug 3236479

3473: v_success:=update_percent(p_name,v_style,v_row_agg_no,v_max_col_no,
3474: p_ref_date,v_md_set_code);
3475:
3476: IF (g_proc_level>=g_debug_level) THEN
3477: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT'); --bug 3236479
3478: END IF;
3479:
3480: RETURN v_success;
3481: END update_percent;

Line 3527: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT');

3523: WHERE analysis_name=p_name AND type=v_level ORDER BY seq_no;
3524: BEGIN
3525:
3526: IF (g_proc_level>=g_debug_level) THEN
3527: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT');
3528: END IF;
3529:
3530: OPEN percent_info;
3531: FETCH percent_info INTO v_type,v_level;

Line 3534: xtr_risk_debug_pkg.dlog('v_type:v_level',v_type||':'||v_level);

3530: OPEN percent_info;
3531: FETCH percent_info INTO v_type,v_level;
3532: CLOSE percent_info;
3533: IF (g_proc_level>=g_debug_level) THEN
3534: xtr_risk_debug_pkg.dlog('v_type:v_level',v_type||':'||v_level);
3535: END IF;
3536:
3537: v_success := translate_to_usd (p_name,
3538: p_ref_date,

Line 3650: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_ROW.P1..P100 Row Level Agg',

3646: AND seq_no<=v_row
3647: AND (type=-1 OR type>=v_level);
3648:
3649: IF (g_event_level>=g_debug_level) THEN --bug 3236479
3650: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_ROW.P1..P100 Row Level Agg',
3651: 'QRM_PA_AGGREGATION_P.UPDATE_PERCENT',g_event_level);
3652: END IF;
3653:
3654: v_previous_count := v_row+1;

Line 3669: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.COL_PERCENT_LEVEL to null then '||v_level,

3665: SET col_percent_level=v_level, last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3666: WHERE analysis_name=p_name AND type=-1;
3667:
3668: IF (g_event_level>=g_debug_level) THEN --bug 3236479
3669: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.COL_PERCENT_LEVEL to null then '||v_level,
3670: 'QRM_PA_AGGREGATION_P.UPDATE_PERCENT',g_event_level);
3671: END IF;
3672:
3673: --percentage is based on the col aggregates

Line 3678: xtr_risk_debug_pkg.dlog('Before FETCH v_tot');

3674: ELSIF v_type='C' THEN
3675: --get all the specified total column index
3676: v_tot := NULL;
3677: IF (g_proc_level>=g_debug_level) THEN
3678: xtr_risk_debug_pkg.dlog('Before FETCH v_tot');
3679: END IF;
3680: OPEN get_col_tot_seq_no;
3681: FETCH get_col_tot_seq_no BULK COLLECT INTO v_tot;
3682: CLOSE get_col_tot_seq_no;

Line 3684: xtr_risk_debug_pkg.dlog('After FETCH v_tot');

3680: OPEN get_col_tot_seq_no;
3681: FETCH get_col_tot_seq_no BULK COLLECT INTO v_tot;
3682: CLOSE get_col_tot_seq_no;
3683: IF (g_proc_level>=g_debug_level) THEN
3684: xtr_risk_debug_pkg.dlog('After FETCH v_tot');
3685: END IF;
3686: v_previous_count := p_row_agg_no;
3687: IF (g_proc_level>=g_debug_level) THEN
3688: xtr_risk_debug_pkg.dlog('v_tot.COUNT',v_tot.COUNT);

Line 3688: xtr_risk_debug_pkg.dlog('v_tot.COUNT',v_tot.COUNT);

3684: xtr_risk_debug_pkg.dlog('After FETCH v_tot');
3685: END IF;
3686: v_previous_count := p_row_agg_no;
3687: IF (g_proc_level>=g_debug_level) THEN
3688: xtr_risk_debug_pkg.dlog('v_tot.COUNT',v_tot.COUNT);
3689: xtr_risk_debug_pkg.dlog('v_tot.LAST',v_tot.LAST);
3690: xtr_risk_debug_pkg.dlog('v_previous_count',v_previous_count);
3691: END IF;
3692: FOR i IN 1..v_tot.COUNT LOOP

Line 3689: xtr_risk_debug_pkg.dlog('v_tot.LAST',v_tot.LAST);

3685: END IF;
3686: v_previous_count := p_row_agg_no;
3687: IF (g_proc_level>=g_debug_level) THEN
3688: xtr_risk_debug_pkg.dlog('v_tot.COUNT',v_tot.COUNT);
3689: xtr_risk_debug_pkg.dlog('v_tot.LAST',v_tot.LAST);
3690: xtr_risk_debug_pkg.dlog('v_previous_count',v_previous_count);
3691: END IF;
3692: FOR i IN 1..v_tot.COUNT LOOP
3693: --

Line 3690: xtr_risk_debug_pkg.dlog('v_previous_count',v_previous_count);

3686: v_previous_count := p_row_agg_no;
3687: IF (g_proc_level>=g_debug_level) THEN
3688: xtr_risk_debug_pkg.dlog('v_tot.COUNT',v_tot.COUNT);
3689: xtr_risk_debug_pkg.dlog('v_tot.LAST',v_tot.LAST);
3690: xtr_risk_debug_pkg.dlog('v_previous_count',v_previous_count);
3691: END IF;
3692: FOR i IN 1..v_tot.COUNT LOOP
3693: --
3694: --Have to do dynamic sql bec. we have to divide per block of col

Line 3698: xtr_risk_debug_pkg.dlog('v_tot(i)',i||':'||v_tot(i));

3694: --Have to do dynamic sql bec. we have to divide per block of col
3695: --Trying to get all column between the total index
3696: --
3697: IF (g_proc_level>=g_debug_level) THEN
3698: xtr_risk_debug_pkg.dlog('v_tot(i)',i||':'||v_tot(i));
3699: END IF;
3700: v_tot_segment := v_tot(i)-v_previous_count;
3701: FOR j IN 1..v_tot_segment LOOP
3702: --IF j

Line 3719: xtr_risk_debug_pkg.dlog('v_sql',v_sql);

3715: END LOOP;
3716: v_sql:='UPDATE qrm_saved_analyses_row SET '||v_sql||' , last_updated_by=FND_GLOBAL.user_id, last_update_date=:p_ref_date, last_update_login=FND_GLOBAL.login_id WHERE analysis_name=:p_name';
3717:
3718: IF (g_proc_level>=g_debug_level) THEN
3719: xtr_risk_debug_pkg.dlog('v_sql',v_sql);
3720: END IF;
3721: EXECUTE IMMEDIATE v_sql USING p_ref_date,p_name;
3722: v_previous_count := v_tot(i)+1;
3723: END LOOP;

Line 3725: xtr_risk_debug_pkg.dlog('After EXECUTE IMMEDIATE');

3721: EXECUTE IMMEDIATE v_sql USING p_ref_date,p_name;
3722: v_previous_count := v_tot(i)+1;
3723: END LOOP;
3724: IF (g_proc_level>=g_debug_level) THEN
3725: xtr_risk_debug_pkg.dlog('After EXECUTE IMMEDIATE');
3726: END IF;
3727: --update the column info, first null all the COL_PERCENT_LEVEL
3728: UPDATE qrm_saved_analyses_col
3729: SET col_percent_level=NULL, last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id

Line 3737: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.COL_PERCENT_LEVEL to null then '||v_level,

3733: SET col_percent_level=-v_level, last_updated_by=FND_GLOBAL.user_id, last_update_date=p_ref_date, last_update_login=FND_GLOBAL.login_id
3734: WHERE analysis_name=p_name AND (type=-1 OR type>=v_level);
3735:
3736: IF (g_event_level>=g_debug_level) THEN --bug 3236479
3737: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.COL_PERCENT_LEVEL to null then '||v_level,
3738: 'QRM_PA_AGGREGATION_P.UPDATE_PERCENT',g_event_level);
3739: END IF;
3740:
3741: ELSE

Line 3744: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT');--bug 3236479

3740:
3741: ELSE
3742: --no percentage calculation is necessary
3743: IF (g_proc_level>=g_debug_level) THEN
3744: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT');--bug 3236479
3745: END IF;
3746: RETURN TRUE;
3747: END IF;
3748:

Line 3751: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT');-- bug 3236479

3747: END IF;
3748:
3749: COMMIT;
3750: IF (g_proc_level>=g_debug_level) THEN
3751: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_PERCENT');-- bug 3236479
3752: END IF;
3753: RETURN TRUE;
3754: EXCEPTION
3755: WHEN OTHERS THEN

Line 3758: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS',

3754: EXCEPTION
3755: WHEN OTHERS THEN
3756:
3757: IF (g_error_level>=g_debug_level) THEN
3758: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS',
3759: 'QRM_PA_AGGREGATION_P.UPDATE_PERCENT',g_error_level);--bug 3236479
3760: END IF;
3761:
3762: RETURN FALSE;

Line 3788: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_LABEL');

3784: RETURN BOOLEAN IS
3785: v_col_name VARCHAR2(50);
3786: BEGIN
3787: IF (g_proc_level>=g_debug_level) THEN
3788: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_LABEL');
3789: END IF;
3790:
3791: --loop through all the aggregate to see whether DEAL_TYPE is there.
3792: FOR i IN 1..p_agg.COUNT LOOP

Line 3801: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.A1 to user_deal_type',

3797: WHERE analysis_name=p_name AND type=-1;
3798: COMMIT;
3799:
3800: IF (g_event_level>=g_debug_level) THEN --bug 3236479
3801: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SET_ANALYSES_COL.A1 to user_deal_type',
3802: 'QRM_PA_AGGREGATION_P.UPDATE_LABEL',g_event_level);
3803: END IF;
3804:
3805: EXIT;

Line 3810: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_LABEL');

3806: END IF;
3807: END LOOP;
3808:
3809: IF (g_proc_level>=g_debug_level) THEN
3810: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_LABEL');
3811: END IF;
3812: RETURN TRUE;
3813: EXCEPTION
3814: WHEN OTHERS THEN

Line 3816: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.UPDATE_LABEL',g_error_level);-- bug 3236479

3812: RETURN TRUE;
3813: EXCEPTION
3814: WHEN OTHERS THEN
3815: IF (g_error_level>=g_debug_level) THEN
3816: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.UPDATE_LABEL',g_error_level);-- bug 3236479
3817: END IF;
3818: RETURN FALSE;
3819: END update_label;
3820:

Line 3888: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL');--bug 3236479

3884: WHERE attribute_name=v_temp;
3885:
3886: BEGIN
3887: IF (g_proc_level>=g_debug_level) THEN
3888: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL');--bug 3236479
3889: END IF;
3890:
3891: --initialize fnd_msg_pub if it has not been intialized
3892: IF fnd_msg_pub.count_msg>0 THEN

Line 3902: xtr_risk_debug_pkg.dlog('p_att_name.COUNT,p_att_name.LAST',p_att_name.COUNT||','||p_att_name.LAST);

3898: --see whether we need to do total or just to get multiplier
3899: IF p_calc_total_ind='Y' THEN
3900: --first extend v_table_col_curr
3901: IF (g_proc_level>=g_debug_level) THEN
3902: xtr_risk_debug_pkg.dlog('p_att_name.COUNT,p_att_name.LAST',p_att_name.COUNT||','||p_att_name.LAST);
3903: END IF;
3904: p_table_col_curr := SYSTEM.QRM_VARCHAR_table();
3905: p_table_col_curr.EXTEND(p_att_name.COUNT);
3906: v_origin.EXTEND(p_att_name.COUNT);

Line 3914: --xtr_risk_debug_pkg.dlog('p_table_col_curr.COUNT',p_table_col_curr.COUNT);

3910: v_num_denom_origin.EXTEND(p_att_name.COUNT);
3911: p_total := xtr_md_num_table();
3912: p_total.EXTEND(p_att_name.COUNT);
3913:
3914: --xtr_risk_debug_pkg.dlog('p_table_col_curr.COUNT',p_table_col_curr.COUNT);
3915: --get the underlying currency for each column and modify the the
3916: --attribute name with '_USD' and '_SOB'
3917: get_underlying_currency(p_name,p_last_run_date,'T',p_md_set_code,
3918: p_currency_source,p_curr_reporting,p_amount,

Line 3924: --xtr_risk_debug_pkg.dlog('p_table_col_curr.COUNT',p_table_col_curr.COUNT);

3920: v_ccy_suffix,p_ccy_multiplier,v_ccy_agg_flag,
3921: v_underlying_ccy,v_ccy_case_flag,NULL,
3922: v_ccy_agg_level,p_table_col_curr,v_agg_col_curr,
3923: p_sensitivity);
3924: --xtr_risk_debug_pkg.dlog('p_table_col_curr.COUNT',p_table_col_curr.COUNT);
3925: IF (g_proc_level>=g_debug_level) THEN
3926: xtr_risk_debug_pkg.dlog('p_ccy_multiplier',p_ccy_multiplier);
3927: END IF;
3928: --make sure p_ccy_multiplier is not null when necessary otherwise throws error

Line 3926: xtr_risk_debug_pkg.dlog('p_ccy_multiplier',p_ccy_multiplier);

3922: v_ccy_agg_level,p_table_col_curr,v_agg_col_curr,
3923: p_sensitivity);
3924: --xtr_risk_debug_pkg.dlog('p_table_col_curr.COUNT',p_table_col_curr.COUNT);
3925: IF (g_proc_level>=g_debug_level) THEN
3926: xtr_risk_debug_pkg.dlog('p_ccy_multiplier',p_ccy_multiplier);
3927: END IF;
3928: --make sure p_ccy_multiplier is not null when necessary otherwise throws error
3929: FOR i IN 1..p_table_col_curr.COUNT LOOP
3930: --xtr_risk_debug_pkg.dlog('p_table_col_curr(i)',i||':'||p_table_col_curr(i));

Line 3930: --xtr_risk_debug_pkg.dlog('p_table_col_curr(i)',i||':'||p_table_col_curr(i));

3926: xtr_risk_debug_pkg.dlog('p_ccy_multiplier',p_ccy_multiplier);
3927: END IF;
3928: --make sure p_ccy_multiplier is not null when necessary otherwise throws error
3929: FOR i IN 1..p_table_col_curr.COUNT LOOP
3930: --xtr_risk_debug_pkg.dlog('p_table_col_curr(i)',i||':'||p_table_col_curr(i));
3931: IF p_table_col_curr(i) IS NULL THEN
3932: IF p_curr_reporting<>'USD' AND p_ccy_multiplier IS NULL THEN
3933: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');
3934: FND_MESSAGE.SET_TOKEN('CCY',p_curr_reporting);

Line 3944: --xtr_risk_debug_pkg.dlog('v_temp',v_temp);

3940: --get the property of the new name attributes
3941: FOR i IN 1..p_att_name.COUNT LOOP
3942: IF p_att_name(i) IS NOT NULL THEN
3943: v_temp := p_att_name(i);
3944: --xtr_risk_debug_pkg.dlog('v_temp',v_temp);
3945: OPEN get_lookup_prop;
3946: FETCH get_lookup_prop INTO v_origin(i),v_att_type(i),v_nom(i),
3947: v_denom(i),v_num_denom_origin(i);
3948: IF (g_proc_level>=g_debug_level) THEN

Line 3949: xtr_risk_debug_pkg.dlog('v_origin,v_att_type,v_nom,v_denom',i||':'||v_origin(i)||','||v_att_type(i)||','||v_nom(i)||','||v_denom(i));

3945: OPEN get_lookup_prop;
3946: FETCH get_lookup_prop INTO v_origin(i),v_att_type(i),v_nom(i),
3947: v_denom(i),v_num_denom_origin(i);
3948: IF (g_proc_level>=g_debug_level) THEN
3949: xtr_risk_debug_pkg.dlog('v_origin,v_att_type,v_nom,v_denom',i||':'||v_origin(i)||','||v_att_type(i)||','||v_nom(i)||','||v_denom(i));
3950: END IF;
3951: CLOSE get_lookup_prop;
3952: END IF;
3953: END LOOP;

Line 3965: xtr_risk_debug_pkg.dlog('v_sql',v_sql);

3961: p_amount,p_table_col_curr,v_num_denom_origin,
3962: p_curr_reporting,p_sensitivity);
3963:
3964: IF (g_proc_level>=g_debug_level) THEN
3965: xtr_risk_debug_pkg.dlog('v_sql',v_sql);
3966: END IF;
3967: --open dynamic cursor
3968: v_cursor := dbms_sql.open_cursor;
3969: --Parse the results

Line 3981: --xtr_risk_debug_pkg.dlog('v_measure_no',v_measure_no);

3977: ELSE
3978: dbms_sql.bind_variable(v_cursor,'ref_date',TRUNC(p_last_run_date));
3979: END IF;
3980: END IF;
3981: --xtr_risk_debug_pkg.dlog('v_measure_no',v_measure_no);
3982: --the number of columns is twice as many in the SQL bec. of nom and denom
3983: v_total_temp.EXTEND(p_att_name.COUNT*2);
3984: FOR i IN 1..v_total_temp.COUNT LOOP
3985: dbms_sql.define_column(v_cursor,i,v_total_temp(i));

Line 4009: xtr_risk_debug_pkg.dlog('p_total(i)',i||':'||p_att_name(i)||','||p_total(i)||','||p_table_col_curr(i));

4005: p_total(i) := v_total_temp(i*2-1)/v_total_temp(i*2);
4006: END IF;
4007: END IF;
4008: IF (g_proc_level>=g_debug_level) THEN
4009: xtr_risk_debug_pkg.dlog('p_total(i)',i||':'||p_att_name(i)||','||p_total(i)||','||p_table_col_curr(i));
4010: END IF;
4011: END LOOP;
4012: --close dynamic cursor
4013: dbms_sql.close_cursor(v_cursor);

Line 4037: xtr_risk_debug_pkg.dlog('DML','UPDATE QRM_ANALYSIS_SETTINGS.DIRTY=N',

4033: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;
4034: END IF;
4035:
4036: IF (g_event_level>=g_debug_level) THEN
4037: xtr_risk_debug_pkg.dlog('DML','UPDATE QRM_ANALYSIS_SETTINGS.DIRTY=N',
4038: 'QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL',g_event_level);--bug 3236479
4039: END IF;
4040:
4041: IF (g_proc_level>=g_debug_level) THEN

Line 4042: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL');--bug 3236479

4038: 'QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL',g_event_level);--bug 3236479
4039: END IF;
4040:
4041: IF (g_proc_level>=g_debug_level) THEN
4042: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL');--bug 3236479
4043: END IF;
4044:
4045: EXCEPTION
4046: WHEN e_pagg_no_fxrate_found THEN

Line 4049: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_fxrate_found','QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL',g_error_level);--bug 3236479

4045: EXCEPTION
4046: WHEN e_pagg_no_fxrate_found THEN
4047: fnd_msg_pub.add;
4048: IF (g_error_level>=g_debug_level) THEN
4049: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_fxrate_found','QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL',g_error_level);--bug 3236479
4050: END IF;
4051: WHEN OTHERS THEN
4052: IF (g_error_level>=g_debug_level) THEN
4053: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL',g_error_level);--bug 3236479

Line 4053: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL',g_error_level);--bug 3236479

4049: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_fxrate_found','QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL',g_error_level);--bug 3236479
4050: END IF;
4051: WHEN OTHERS THEN
4052: IF (g_error_level>=g_debug_level) THEN
4053: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL',g_error_level);--bug 3236479
4054: END IF;
4055: END calc_table_total_and_fxrate;
4056:
4057:

Line 4073: xtr_risk_debug_pkg.dpush('QRM_PA_AGGREGATION_P.UPDATE_CURR_COL');

4069: v_curr IN OUT NOCOPY SYSTEM.QRM_VARCHAR_TABLE)
4070: RETURN BOOLEAN IS
4071: BEGIN
4072: IF (g_proc_level>=g_debug_level) THEN
4073: xtr_risk_debug_pkg.dpush('QRM_PA_AGGREGATION_P.UPDATE_CURR_COL');
4074: END IF;
4075: IF p_indicator=1 THEN
4076: UPDATE qrm_saved_analyses_row
4077: SET curr1=v_curr(1),curr2=v_curr(2),curr3=v_curr(3),

Line 4119: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1..100 with p_indicator=1',

4115: last_update_login=FND_GLOBAL.login_id
4116: WHERE analysis_name=p_name;
4117:
4118: IF (g_event_level>=g_debug_level) THEN --bug 3236479
4119: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1..100 with p_indicator=1',
4120: 'QRM_PA_AGGREGATION_P.UPDATE_CURRENCY_COLUMNS',g_event_level);
4121: END IF;
4122:
4123: ELSE --p_indicator=2 where curr1 has the CCY for the row

Line 4167: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1..100 with p_indicator='||p_indicator,

4163: last_update_login=FND_GLOBAL.login_id
4164: WHERE analysis_name=p_name;
4165:
4166: IF (g_event_level>=g_debug_level) THEN --bug 3236479
4167: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1..100 with p_indicator='||p_indicator,
4168: 'QRM_PA_AGGREGATION_P.UPDATE_CURRENCY_COLUMNS',g_event_level);
4169: END IF;
4170:
4171: END IF;

Line 4173: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_CURR_COL');

4169: END IF;
4170:
4171: END IF;
4172: IF (g_proc_level>=g_debug_level) THEN
4173: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_CURR_COL');
4174: END IF;
4175: RETURN TRUE;
4176: EXCEPTION
4177: WHEN OTHERS THEN

Line 4179: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.UPDATE_CURR_COL',g_error_level);--bug 3236479

4175: RETURN TRUE;
4176: EXCEPTION
4177: WHEN OTHERS THEN
4178: IF (g_error_level>=g_debug_level) THEN
4179: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS','QRM_PA_AGGREGATION_P.UPDATE_CURR_COL',g_error_level);--bug 3236479
4180: END IF;
4181: RETURN FALSE;
4182: END update_currency_columns;
4183:

Line 4219: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_AGG_CURR');--bug 3236479

4215: ORDER BY 1;
4216:
4217: BEGIN
4218: IF (g_proc_level>=g_debug_level) THEN
4219: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_AGG_CURR');--bug 3236479
4220: END IF;
4221:
4222: IF p_ccy_case_flag=1 THEN
4223: v_curr := SYSTEM.QRM_VARCHAR_table();

Line 4242: xtr_risk_debug_pkg.dlog('v_sql',v_sql);

4238: ELSIF p_ccy_case_flag=0 THEN
4239: IF p_ccy_agg_flag=1 THEN
4240: v_sql := 'UPDATE qrm_saved_analyses_row SET curr1=DECODE(type,-1,a'||p_ccy_agg_level||',tot_currency) WHERE analysis_name=:analysis_name';
4241: IF (g_proc_level>=g_debug_level) THEN
4242: xtr_risk_debug_pkg.dlog('v_sql',v_sql);
4243: END IF;
4244: EXECUTE IMMEDIATE v_sql USING p_name;
4245:
4246: IF (g_event_level>=g_debug_level) THEN --bug 3236479

Line 4247: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1',

4243: END IF;
4244: EXECUTE IMMEDIATE v_sql USING p_name;
4245:
4246: IF (g_event_level>=g_debug_level) THEN --bug 3236479
4247: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_ROW.CURR1',
4248: 'QRM_PA_AGGREGATION_P.UPDATE_AGGREGATE_CURR',g_event_level);
4249: END IF;
4250:
4251: v_success := update_currency_columns(2,p_name,p_ref_date,v_curr);

Line 4280: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.CURR_COL_NAME',

4276: WHERE analysis_name=p_name AND seq_no=i;
4277: END LOOP;
4278:
4279: IF (g_event_level>=g_debug_level) THEN --bug 3236479
4280: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.CURR_COL_NAME',
4281: 'QRM_PA_AGGREGATION_P.UPDATE_AGGREGATE_CURR',g_event_level);
4282: END IF;
4283:
4284: IF (g_proc_level>=g_debug_level) THEN

Line 4285: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_AGG_CURR');-- bug 3236479

4281: 'QRM_PA_AGGREGATION_P.UPDATE_AGGREGATE_CURR',g_event_level);
4282: END IF;
4283:
4284: IF (g_proc_level>=g_debug_level) THEN
4285: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_AGG_CURR');-- bug 3236479
4286: END IF;
4287: RETURN TRUE;
4288:
4289: EXCEPTION

Line 4292: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS',

4288:
4289: EXCEPTION
4290: WHEN OTHERS THEN
4291: IF (g_error_level>=g_debug_level) THEN
4292: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS',
4293: 'QRM_PA_AGGREGATION_P.UPDATE_AGG_CURR',g_error_level);--bug 3236479
4294: END IF;
4295: RETURN FALSE;
4296: END update_aggregate_curr;

Line 4320: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_TB_LABEL');

4316: SELECT COUNT(*) FROM qrm_saved_analyses_col
4317: WHERE analysis_name=p_name AND type=-2;
4318: BEGIN
4319: IF (g_proc_level>=g_debug_level) THEN
4320: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_TB_LABEL');
4321: END IF;
4322:
4323: OPEN get_tb_label;
4324: FETCH get_tb_label INTO v_tb_label;

Line 4349: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.A1 with v_tb_label='||v_tb_label,

4345: END IF;
4346: COMMIT;
4347:
4348: IF (g_event_level>=g_debug_level) THEN --bug 3236479
4349: XTR_RISK_DEBUG_PKG.dlog('DML','Updated QRM_SAVED_ANALYSES_COL.A1 with v_tb_label='||v_tb_label,
4350: 'QRM_PA_AGGREGATION_P.UPDATE_TIMEBUCKETS_LABELS',g_event_level);
4351: END IF;
4352:
4353: IF (g_proc_level>=g_debug_level) THEN

Line 4354: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_TB_LABEL');

4350: 'QRM_PA_AGGREGATION_P.UPDATE_TIMEBUCKETS_LABELS',g_event_level);
4351: END IF;
4352:
4353: IF (g_proc_level>=g_debug_level) THEN
4354: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_TB_LABEL');
4355: END IF;
4356: RETURN TRUE;
4357:
4358: EXCEPTION

Line 4363: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_setting_found',

4359: WHEN e_pagg_no_setting_found THEN
4360: RAISE e_pagg_no_setting_found;
4361:
4362: IF (g_error_level>=g_debug_level) THEN
4363: xtr_risk_debug_pkg.dlog('EXCEPTION','e_pagg_no_setting_found',
4364: 'QRM_PA_AGGREGATION_P.UPDATE_TB_LABEL',g_error_level);--bug 3236479
4365: END IF;
4366:
4367: WHEN OTHERS THEN

Line 4370: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS',

4366:
4367: WHEN OTHERS THEN
4368:
4369: IF (g_error_level>=g_debug_level) THEN
4370: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS',
4371: 'QRM_PA_AGGREGATION_P.UPDATE_TB_LABEL',g_error_level);--bug 3236479
4372: END IF;
4373:
4374: RETURN FALSE;

Line 4393: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_SEMIDIRTY');

4389: SELECT style FROM qrm_analysis_settings
4390: WHERE analysis_name=p_name AND history_flag='S';
4391: BEGIN
4392: IF (g_proc_level>=g_debug_level) THEN
4393: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.UPDATE_SEMIDIRTY');
4394: END IF;
4395: --initialize fnd_msg_pub if it has not been intialized
4396: IF fnd_msg_pub.count_msg>0 THEN
4397: fnd_msg_pub.Initialize;

Line 4413: xtr_risk_debug_pkg.dlog('update_semidirty: ' || 'v_successT',v_success);

4409:
4410: --update total
4411: v_success := update_total(p_name,p_ref_date);
4412: IF (g_proc_level>=g_debug_level) THEN
4413: xtr_risk_debug_pkg.dlog('update_semidirty: ' || 'v_successT',v_success);
4414: END IF;
4415: IF NOT v_success THEN
4416: RAISE e_pagg_update_total_fail;
4417: END IF;

Line 4421: xtr_risk_debug_pkg.dlog('update_semidirty: ' || 'v_success%',v_success);

4417: END IF;
4418: --update percent
4419: v_success := update_percent (p_name,p_ref_date);
4420: IF (g_proc_level>=g_debug_level) THEN
4421: xtr_risk_debug_pkg.dlog('update_semidirty: ' || 'v_success%',v_success);
4422: END IF;
4423: IF NOT v_success THEN
4424: RAISE e_pagg_update_percent_fail;
4425: END IF;

Line 4430: xtr_risk_debug_pkg.dlog('update_semidirty: ' || 'v_successTBLabel',v_success);

4426: --update timebuckets label
4427: IF v_style='X' THEN
4428: v_success := update_timebuckets_label(p_name);
4429: IF (g_proc_level>=g_debug_level) THEN
4430: xtr_risk_debug_pkg.dlog('update_semidirty: ' || 'v_successTBLabel',v_success);
4431: END IF;
4432: IF NOT v_success THEN
4433: RAISE e_pagg_update_tb_label_fail;
4434: END IF;

Line 4441: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_SEMIDIRTY');

4437: --update dirty flag
4438: UPDATE qrm_analysis_settings SET dirty='N' WHERE analysis_name=p_name;
4439: COMMIT;
4440: IF (g_proc_level>=g_debug_level) THEN
4441: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_SEMIDIRTY');
4442: END IF;
4443: RETURN 'T';
4444: EXCEPTION
4445: WHEN e_pagg_no_setting_found THEN

Line 4449: XTR_RISK_DEBUG_PKG.dlog('EXCEPTION','QRM_PA_AGGREGATION_P.E_PAGG_NO_SETTING_FOUND',

4445: WHEN e_pagg_no_setting_found THEN
4446: fnd_msg_pub.add;
4447: --bug 3236479
4448: IF (g_proc_level>=g_ERROR_level) THEN
4449: XTR_RISK_DEBUG_PKG.dlog('EXCEPTION','QRM_PA_AGGREGATION_P.E_PAGG_NO_SETTING_FOUND',
4450: 'QRM_PA_AGGREGATION_P.UPDATE_SEMIDIRTY',
4451: g_error_level);
4452: END IF;
4453: RETURN 'F';

Line 4457: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS',

4453: RETURN 'F';
4454: WHEN OTHERS THEN
4455:
4456: IF (g_error_level>=g_debug_level) THEN
4457: xtr_risk_debug_pkg.dlog('EXCEPTION','OTHERS',
4458: 'QRM_PA_AGGREGATION_P.UPDATE_SEMIDIRTY',g_error_level);--bug 3236479
4459: END IF;
4460:
4461: RETURN 'F';

Line 4504: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.GET_FX_RATE');

4500: GROUP BY currency);
4501:
4502: BEGIN
4503: IF (g_proc_level>=g_debug_level) THEN
4504: xtr_risk_debug_pkg.dpush(null,'QRM_PA_AGGREGATION_P.GET_FX_RATE');
4505: END IF;
4506:
4507: IF p_base_ccy=p_contra_ccy THEN
4508: v_ccy_multiplier := 1;

Line 4556: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.GET_FX_RATE');

4552: END IF;
4553:
4554: END IF;
4555: IF (g_proc_level>=g_debug_level) THEN
4556: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.GET_FX_RATE');
4557: END IF;
4558: RETURN v_ccy_multiplier;
4559:
4560: EXCEPTION

Line 4564: xtr_risk_debug_pkg.dlog('EXCEPTION','xtr_market_data.e_mdcs_no_data_found',

4560: EXCEPTION
4561: WHEN xtr_market_data_p.e_mdcs_no_data_found THEN
4562:
4563: IF (G_ERROR_level>=g_debug_level) THEN
4564: xtr_risk_debug_pkg.dlog('EXCEPTION','xtr_market_data.e_mdcs_no_data_found',
4565: 'QRM_PA_AGGREGATION_P.GET_FX_RATE',g_eRROR_level);--bug 3236479
4566: END IF;
4567:
4568: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');