APPS.PA_REV_CA dependencies on PA_BILLING_EXTN_PARAMS_V

Line 1127: PA_MCB_INVOICE_PKG.log_message('Before pa_billing_extn_params_v select pa_rev_ca.calc_ca_amt :');

1123: FROM pa_billing_extensions
1124: WHERE billing_extension_id = X_billing_extension_id;
1125:
1126: IF g1_debug_mode = 'Y' THEN
1127: PA_MCB_INVOICE_PKG.log_message('Before pa_billing_extn_params_v select pa_rev_ca.calc_ca_amt :');
1128: END IF;
1129: /* Added for bug 2649456.Not handling exception intentionaly because if it is coming,
1130: it will be data issue */
1131: BEGIN

Line 1134: FROM pa_billing_extn_params_v;

1130: it will be data issue */
1131: BEGIN
1132: SELECT default_cost_plan_type_id,default_rev_plan_type_id
1133: INTO l_cost_plan_type_id,l_rev_plan_type_id
1134: FROM pa_billing_extn_params_v;
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: IF g1_debug_mode = 'Y' THEN
1138: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_rev_ca.calc_ca_amt :'||SQLERRM);

Line 1138: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_rev_ca.calc_ca_amt :'||SQLERRM);

1134: FROM pa_billing_extn_params_v;
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: IF g1_debug_mode = 'Y' THEN
1138: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_rev_ca.calc_ca_amt :'||SQLERRM);
1139: END IF;
1140: RAISE;
1141: END;
1142: /* till here */