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 QRM_PA_AGGREGATION_P

Line 1: PACKAGE BODY QRM_PA_AGGREGATION_P AS

1: PACKAGE BODY QRM_PA_AGGREGATION_P AS
2: /* $Header: qrmpaggb.pls 120.13 2005/09/20 11:49:16 csutaria ship $ */
3:
4:
5: /***************************************************************

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 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 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 915: 'QRM_PA_AGGREGATION_P.INSERT_ROW',g_event_level);

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:
919: RETURN TRUE;

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 924: 'QRM_PA_AGGREGATION_P.INSERT_ROW',G_ERROR_LEVEL);

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;
928:

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 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 1664: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);

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
1668:

Line 1867: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);

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
1871: --update the tot_currency and tot_currency_label columns

Line 1902: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);

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'
1906:

Line 2528: 'QRM_PA_AGGREGATION_P.TRANSFORM_AND_SAVE',g_event_level);

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;
2532:

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 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 3118: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);

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
3122: UPDATE qrm_saved_analyses_row

Line 3133: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);

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
3137: --set all the total rows to be hidden

Line 3144: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);

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
3148: UPDATE qrm_saved_analyses_col

Line 3159: 'QRM_PA_AGGREGATION_P.UPDATE_TOTAL',g_event_level);

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;
3163: IF (g_proc_level>=g_debug_level) THEN

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 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 3651: 'QRM_PA_AGGREGATION_P.UPDATE_PERCENT',g_event_level);

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;
3655: EXIT WHEN col_100%NOTFOUND;

Line 3670: 'QRM_PA_AGGREGATION_P.UPDATE_PERCENT',g_event_level);

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
3674: ELSIF v_type='C' THEN

Line 3738: 'QRM_PA_AGGREGATION_P.UPDATE_PERCENT',g_event_level);

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
3742: --no percentage calculation is necessary

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 3759: 'QRM_PA_AGGREGATION_P.UPDATE_PERCENT',g_error_level);--bug 3236479

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;
3763: END update_percent;

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 3802: 'QRM_PA_AGGREGATION_P.UPDATE_LABEL',g_event_level);

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;
3806: END IF;

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 4038: 'QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL',g_event_level);--bug 3236479

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
4042: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.CALC_TABLE_TOTAL');--bug 3236479

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 4120: 'QRM_PA_AGGREGATION_P.UPDATE_CURRENCY_COLUMNS',g_event_level);

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
4124: UPDATE qrm_saved_analyses_row

Line 4168: 'QRM_PA_AGGREGATION_P.UPDATE_CURRENCY_COLUMNS',g_event_level);

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;
4172: IF (g_proc_level>=g_debug_level) THEN

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 4248: 'QRM_PA_AGGREGATION_P.UPDATE_AGGREGATE_CURR',g_event_level);

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);
4252: ELSIF p_ccy_agg_flag=2 THEN

Line 4281: 'QRM_PA_AGGREGATION_P.UPDATE_AGGREGATE_CURR',g_event_level);

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
4285: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_AGG_CURR');-- bug 3236479

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 4293: 'QRM_PA_AGGREGATION_P.UPDATE_AGG_CURR',g_error_level);--bug 3236479

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;
4297:

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 4350: 'QRM_PA_AGGREGATION_P.UPDATE_TIMEBUCKETS_LABELS',g_event_level);

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
4354: xtr_risk_debug_pkg.dpop(null,'QRM_PA_AGGREGATION_P.UPDATE_TB_LABEL');

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 4364: 'QRM_PA_AGGREGATION_P.UPDATE_TB_LABEL',g_error_level);--bug 3236479

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
4368:

Line 4371: 'QRM_PA_AGGREGATION_P.UPDATE_TB_LABEL',g_error_level);--bug 3236479

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;
4375: END update_timebuckets_label;

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 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 4450: 'QRM_PA_AGGREGATION_P.UPDATE_SEMIDIRTY',

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';
4454: WHEN OTHERS THEN

Line 4458: 'QRM_PA_AGGREGATION_P.UPDATE_SEMIDIRTY',g_error_level);--bug 3236479

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';
4462: END update_semidirty;

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 4565: 'QRM_PA_AGGREGATION_P.GET_FX_RATE',g_eRROR_level);--bug 3236479

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');
4569: FND_MESSAGE.SET_TOKEN('CCY',p_contra_ccy);

Line 4576: END QRM_PA_AGGREGATION_P;

4572:
4573:
4574:
4575:
4576: END QRM_PA_AGGREGATION_P;