DBA Data[Home] [Help]

APPS.QRM_PA_AGGREGATION_P dependencies on FND_MSG_PUB

Line 1558: --initialize fnd_msg_pub if it has not been intialized

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
1560: fnd_msg_pub.Initialize;
1561: END IF;
1562:

Line 1559: IF p_caller_flag='OA' AND fnd_msg_pub.count_msg>0 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
1560: fnd_msg_pub.Initialize;
1561: END IF;
1562:
1563: --query analysis data

Line 1560: fnd_msg_pub.Initialize;

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
1560: fnd_msg_pub.Initialize;
1561: END IF;
1562:
1563: --query analysis data
1564: OPEN analysis_data;

Line 2544: fnd_msg_pub.add;

2540: WHEN e_pagg_no_fxrate_found THEN
2541: IF p_caller_flag='CONC' THEN
2542: RAISE e_pagg_no_fxrate_found;
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');

Line 2555: fnd_msg_pub.add;

2551: WHEN e_pagg_no_timebuckets_found THEN
2552: IF p_caller_flag='CONC' THEN
2553: RAISE e_pagg_no_timebuckets_found;
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');

Line 2566: fnd_msg_pub.add;

2562: WHEN e_pagg_no_setting_found THEN
2563: IF p_caller_flag='CONC' THEN
2564: RAISE e_pagg_no_setting_found;
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');

Line 2576: fnd_msg_pub.add;

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
2580: --xtr_risk_debug_pkg.dpop('transform_and_save: ' || 'QRM_PA_AGGREGATION_P.T_AND_S');

Line 3891: --initialize fnd_msg_pub if it has not been intialized

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
3893: fnd_msg_pub.Initialize;
3894: END IF;
3895:

Line 3892: IF fnd_msg_pub.count_msg>0 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
3893: fnd_msg_pub.Initialize;
3894: END IF;
3895:
3896: --FHU will convert the relative date and saved them into the fix date col

Line 3893: fnd_msg_pub.Initialize;

3889: END IF;
3890:
3891: --initialize fnd_msg_pub if it has not been intialized
3892: IF fnd_msg_pub.count_msg>0 THEN
3893: fnd_msg_pub.Initialize;
3894: END IF;
3895:
3896: --FHU will convert the relative date and saved them into the fix date col
3897:

Line 4047: fnd_msg_pub.add;

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

Line 4395: --initialize fnd_msg_pub if it has not been intialized

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;
4398: END IF;
4399: --check whether analysis settings still there by looking whether the required

Line 4396: IF fnd_msg_pub.count_msg>0 THEN

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;
4398: END IF;
4399: --check whether analysis settings still there by looking whether the required
4400: --column value return IS NULL or not

Line 4397: fnd_msg_pub.Initialize;

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;
4398: END IF;
4399: --check whether analysis settings still there by looking whether the required
4400: --column value return IS NULL or not
4401: OPEN get_style;

Line 4446: fnd_msg_pub.add;

4442: END IF;
4443: RETURN 'T';
4444: EXCEPTION
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',