DBA Data[Home] [Help]

APPS.ARP_PROCESS_CREDIT dependencies on ARP_TRX_UTIL

Line 2199: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));

2195:
2196: END IF;
2197:
2198: --Bug2109490
2199: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2200: --
2201: -- call Tax engine, checking if tax needs to be recalculated
2202: --
2203: l_action := arp_etax_services_pkg.Get_tax_Action(p_customer_trx_id);

Line 2222: arp_trx_util.lock_transaction(p_customer_trx_id);

2218: /*---------------------------------------------------------------+
2219: | Lock rows in other tables that reference this customer_trx_id |
2220: | and the credited transaction |
2221: +---------------------------------------------------------------*/
2222: arp_trx_util.lock_transaction(p_customer_trx_id);
2223:
2224: set_header_flags(p_customer_trx_id,
2225: p_trx_rec,
2226: p_gl_date,

Line 2245: arp_trx_util.detect_freight_only_rules_case(p_customer_trx_id);

2241: AND
2242: (p_prev_customer_trx_id IS NOT NULL))
2243: THEN
2244: l_frt_only_rules :=
2245: arp_trx_util.detect_freight_only_rules_case(p_customer_trx_id);
2246:
2247: IF p_trx_rec.complete_flag = 'Y'
2248: THEN
2249: IF ((l_frt_only_rules = TRUE)

Line 2354: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));

2350:
2351: --Bug2109490
2352: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2353: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2354: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2355: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2356: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2357:
2358: IF (( p_prev_customer_trx_id IS NOT NULL)

Line 2356: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));

2352: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2353: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2354: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2355: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2356: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2357:
2358: IF (( p_prev_customer_trx_id IS NOT NULL)
2359: AND
2360: nvl(p_rederive_credit_info, 'N') = 'Y' )

Line 2482: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));

2478: END;
2479:
2480: END IF;
2481: /* Bug 3619804 Added the call to the procedure reverse_revrec_effect_cm */
2482: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2483: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2484: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2485: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2486: arp_util.debug('CM Rev Recog Run Flag : ' ||arpt_sql_func_util.get_revenue_recog_run_flag(p_customer_trx_id,p_cr_txn_invoicing_rule_id));

Line 2671: arp_trx_util.lock_transaction(p_customer_trx_id);

2667: /*---------------------------------------------------------------+
2668: | Lock rows in other tables that reference this customer_trx_id |
2669: | and the credited transaction |
2670: +---------------------------------------------------------------*/
2671: arp_trx_util.lock_transaction(p_customer_trx_id);
2672:
2673: /*--------------------+
2674: | pre-insert logic |
2675: +--------------------*/

Line 3080: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));

3076: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);
3077: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3078: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3079: arp_util.debug('p_line_amt_chng_flag : '||
3080: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3081: arp_util.debug('p_tax_amt_chng_flag : '||
3082: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3083: arp_util.debug('p_frt_amt_chng_flag : '||
3084: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));

Line 3082: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));

3078: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3079: arp_util.debug('p_line_amt_chng_flag : '||
3080: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3081: arp_util.debug('p_tax_amt_chng_flag : '||
3082: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3083: arp_util.debug('p_frt_amt_chng_flag : '||
3084: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3085: arp_util.debug('p_tax_mode : '||l_tax_mode);
3086: arp_util.debug('p_frt_mode : '||l_frt_mode);

Line 3084: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));

3080: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3081: arp_util.debug('p_tax_amt_chng_flag : '||
3082: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3083: arp_util.debug('p_frt_amt_chng_flag : '||
3084: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3085: arp_util.debug('p_tax_mode : '||l_tax_mode);
3086: arp_util.debug('p_frt_mode : '||l_frt_mode);
3087: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3088: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);

Line 3205: arp_trx_util.lock_transaction(p_customer_trx_id);

3201: /*---------------------------------------------------------------+
3202: | Lock rows in other tables that reference this customer_trx_id |
3203: | and the credited transaction |
3204: +---------------------------------------------------------------*/
3205: arp_trx_util.lock_transaction(p_customer_trx_id);
3206:
3207: /*--------------------+
3208: | pre-update logic |
3209: +--------------------*/