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 FND_MESSAGE

Line 1575: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_SETTING');

1571:
1572: --check whether analysis settings still there by looking whether the required
1573: --column value return IS NULL or not
1574: IF v_style IS NULL THEN
1575: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_SETTING');
1576: FND_MESSAGE.SET_TOKEN('ANALYSIS_NAME',p_name);
1577: RAISE e_pagg_no_setting_found;
1578: END IF;
1579:

Line 1576: FND_MESSAGE.SET_TOKEN('ANALYSIS_NAME',p_name);

1572: --check whether analysis settings still there by looking whether the required
1573: --column value return IS NULL or not
1574: IF v_style IS NULL THEN
1575: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_SETTING');
1576: FND_MESSAGE.SET_TOKEN('ANALYSIS_NAME',p_name);
1577: RAISE e_pagg_no_setting_found;
1578: END IF;
1579:
1580: --DELETE existing saved data

Line 1645: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');

1641: IF v_ccy_multiplier IS NULL AND v_curr_reporting<>'USD' AND
1642: ((v_ccy_case_flag=0 AND v_ccy_agg_flag=0) OR v_currency_source='R' OR
1643: (v_ccy_case_flag=0 AND v_ccy_agg_flag IN (1,2) AND v_ccy_agg_level>1))
1644: THEN
1645: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');
1646: FND_MESSAGE.SET_TOKEN('CCY',v_curr_reporting);
1647: raise e_pagg_no_fxrate_found;
1648: END IF;
1649: --Update currency_used in qrm_analysis_settings

Line 1646: FND_MESSAGE.SET_TOKEN('CCY',v_curr_reporting);

1642: ((v_ccy_case_flag=0 AND v_ccy_agg_flag=0) OR v_currency_source='R' OR
1643: (v_ccy_case_flag=0 AND v_ccy_agg_flag IN (1,2) AND v_ccy_agg_level>1))
1644: THEN
1645: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');
1646: FND_MESSAGE.SET_TOKEN('CCY',v_curr_reporting);
1647: raise e_pagg_no_fxrate_found;
1648: END IF;
1649: --Update currency_used in qrm_analysis_settings
1650: IF v_ccy_case_flag=0 AND v_ccy_agg_flag=0 THEN --use curr_reporting

Line 2575: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_UNEXPECTED_ERROR');

2571: END IF;
2572: RETURN 'F';
2573: WHEN OTHERS THEN
2574: IF p_caller_flag='OA' THEN
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

Line 2935: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_TIMEBUCKETS');

2931: OPEN v_find_tb;
2932: FETCH v_find_tb INTO v_dummy;
2933: CLOSE v_find_tb;
2934: IF v_dummy=0 THEN
2935: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_TIMEBUCKETS');
2936: FND_MESSAGE.SET_TOKEN('TB_NAME',p_tb_name);
2937: RAISE e_pagg_no_timebuckets_found;
2938: END IF;
2939:

Line 2936: FND_MESSAGE.SET_TOKEN('TB_NAME',p_tb_name);

2932: FETCH v_find_tb INTO v_dummy;
2933: CLOSE v_find_tb;
2934: IF v_dummy=0 THEN
2935: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_TIMEBUCKETS');
2936: FND_MESSAGE.SET_TOKEN('TB_NAME',p_tb_name);
2937: RAISE e_pagg_no_timebuckets_found;
2938: END IF;
2939:
2940: OPEN v_tb_cursor;

Line 3933: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');

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);
3935: RAISE e_pagg_no_fxrate_found;
3936: END IF;
3937: END IF;

Line 3934: FND_MESSAGE.SET_TOKEN('CCY',p_curr_reporting);

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);
3935: RAISE e_pagg_no_fxrate_found;
3936: END IF;
3937: END IF;
3938: END LOOP;

Line 4025: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');

4021: 'M');
4022:
4023: --check whether p_ccy_multiplier is not null when needed
4024: IF p_ccy_multiplier IS NULL THEN
4025: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');
4026: FND_MESSAGE.SET_TOKEN('CCY',p_curr_reporting);
4027: RAISE e_pagg_no_fxrate_found;
4028: END IF;
4029: END IF;

Line 4026: FND_MESSAGE.SET_TOKEN('CCY',p_curr_reporting);

4022:
4023: --check whether p_ccy_multiplier is not null when needed
4024: IF p_ccy_multiplier IS NULL THEN
4025: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');
4026: FND_MESSAGE.SET_TOKEN('CCY',p_curr_reporting);
4027: RAISE e_pagg_no_fxrate_found;
4028: END IF;
4029: END IF;
4030:

Line 4327: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_SETTING');

4323: OPEN get_tb_label;
4324: FETCH get_tb_label INTO v_tb_label;
4325: CLOSE get_tb_label;
4326: IF v_tb_label IS NULL THEN
4327: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_SETTING');
4328: FND_MESSAGE.SET_TOKEN('ANALYSIS_NAME',p_name);
4329: RAISE e_pagg_no_setting_found;
4330: END IF;
4331: OPEN get_row_agg_no;

Line 4328: FND_MESSAGE.SET_TOKEN('ANALYSIS_NAME',p_name);

4324: FETCH get_tb_label INTO v_tb_label;
4325: CLOSE get_tb_label;
4326: IF v_tb_label IS NULL THEN
4327: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_SETTING');
4328: FND_MESSAGE.SET_TOKEN('ANALYSIS_NAME',p_name);
4329: RAISE e_pagg_no_setting_found;
4330: END IF;
4331: OPEN get_row_agg_no;
4332: FETCH get_row_agg_no INTO v_row_agg_no;

Line 4405: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_SETTING');

4401: OPEN get_style;
4402: FETCH get_style INTO v_style;
4403: CLOSE get_style;
4404: IF v_style IS NULL THEN
4405: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_SETTING');
4406: FND_MESSAGE.SET_TOKEN('ANALYSIS_NAME',p_name);
4407: RAISE e_pagg_no_setting_found;
4408: END IF;
4409:

Line 4406: FND_MESSAGE.SET_TOKEN('ANALYSIS_NAME',p_name);

4402: FETCH get_style INTO v_style;
4403: CLOSE get_style;
4404: IF v_style IS NULL THEN
4405: FND_MESSAGE.SET_NAME('QRM','QRM_ANA_NO_SETTING');
4406: FND_MESSAGE.SET_TOKEN('ANALYSIS_NAME',p_name);
4407: RAISE e_pagg_no_setting_found;
4408: END IF;
4409:
4410: --update total

Line 4528: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');

4524: v_bid_rate_base, v_ask_rate_base,
4525: v_ccy;
4526: CLOSE get_fx_spot_rates;
4527: IF v_bid_rate_comm IS NULL THEN
4528: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');
4529: FND_MESSAGE.SET_TOKEN('CCY',p_contra_ccy);
4530: RAISE e_pagg_no_fxrate_found;
4531: ELSE
4532: IF p_side IN ('A','ASK') THEN

Line 4529: FND_MESSAGE.SET_TOKEN('CCY',p_contra_ccy);

4525: v_ccy;
4526: CLOSE get_fx_spot_rates;
4527: IF v_bid_rate_comm IS NULL THEN
4528: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');
4529: FND_MESSAGE.SET_TOKEN('CCY',p_contra_ccy);
4530: RAISE e_pagg_no_fxrate_found;
4531: ELSE
4532: IF p_side IN ('A','ASK') THEN
4533: IF p_base_ccy='USD' THEN --use Commodity Quote Basis

Line 4568: FND_MESSAGE.SET_NAME('QRM','QRM_CALC_NO_DEFAULT_SPOT_ERR');

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);
4570: RAISE e_pagg_no_fxrate_found;
4571: END get_fx_rate;
4572:

Line 4569: FND_MESSAGE.SET_TOKEN('CCY',p_contra_ccy);

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);
4570: RAISE e_pagg_no_fxrate_found;
4571: END get_fx_rate;
4572:
4573: