DBA Data[Home] [Help]

APPS.ARP_PROCESS_CREDIT dependencies on ARP_TRX_UTIL

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

2225:
2226: END IF;
2227:
2228: --Bug2109490
2229: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2230: --
2231: -- call Tax engine, checking if tax needs to be recalculated
2232: --
2233: l_action := arp_etax_services_pkg.Get_tax_Action(p_customer_trx_id);

Line 2252: arp_trx_util.lock_transaction(p_customer_trx_id);

2248: /*---------------------------------------------------------------+
2249: | Lock rows in other tables that reference this customer_trx_id |
2250: | and the credited transaction |
2251: +---------------------------------------------------------------*/
2252: arp_trx_util.lock_transaction(p_customer_trx_id);
2253:
2254: set_header_flags(p_customer_trx_id,
2255: p_trx_rec,
2256: p_gl_date,

Line 2275: arp_trx_util.detect_freight_only_rules_case(p_customer_trx_id);

2271: AND
2272: (p_prev_customer_trx_id IS NOT NULL))
2273: THEN
2274: l_frt_only_rules :=
2275: arp_trx_util.detect_freight_only_rules_case(p_customer_trx_id);
2276:
2277: IF p_trx_rec.complete_flag = 'Y'
2278: THEN
2279: IF ((l_frt_only_rules = TRUE)

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

2380:
2381: --Bug2109490
2382: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2383: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2384: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2385: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2386: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2387:
2388: IF (( p_prev_customer_trx_id IS NOT NULL)

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

2382: arp_util.debug( 'p_prev_customer_trx_id : ' || to_char( p_prev_customer_trx_id ));
2383: arp_util.debug( 'p_rederive_credit_info : ' || p_rederive_credit_info);
2384: arp_util.debug(' l_recalc_tax_flag : '||arp_trx_util.boolean_to_varchar2(l_recalc_tax_flag));
2385: arp_util.debug( 'p_compute_tax : ' || p_compute_tax);
2386: arp_util.debug('l_trx_number_change_flag : '||arp_trx_util.boolean_to_varchar2(l_trx_number_change_flag));
2387:
2388: IF (( p_prev_customer_trx_id IS NOT NULL)
2389: AND
2390: nvl(p_rederive_credit_info, 'N') = 'Y' )

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

2508: END;
2509:
2510: END IF;
2511: /* Bug 3619804 Added the call to the procedure reverse_revrec_effect_cm */
2512: arp_util.debug('Complete_changed_flag : '||arp_trx_util.boolean_to_varchar2(l_complete_changed_flag));
2513: arp_util.debug('Complete Flag : '|| p_trx_rec.complete_flag);
2514: arp_util.debug('Customer_trx_id : '|| p_customer_trx_id );
2515: arp_util.debug('CM invoicing_rule_id : '|| p_cr_txn_invoicing_rule_id );
2516: 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 2701: arp_trx_util.lock_transaction(p_customer_trx_id);

2697: /*---------------------------------------------------------------+
2698: | Lock rows in other tables that reference this customer_trx_id |
2699: | and the credited transaction |
2700: +---------------------------------------------------------------*/
2701: arp_trx_util.lock_transaction(p_customer_trx_id);
2702:
2703: /*--------------------+
2704: | pre-insert logic |
2705: +--------------------*/

Line 3120: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));

3116: arp_util.debug('p_cr_line_amount : '||l_credited_line_amount);
3117: arp_util.debug('p_cr_tax_amount : '||l_credited_tax_amount);
3118: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3119: arp_util.debug('p_line_amt_chng_flag : '||
3120: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3121: arp_util.debug('p_tax_amt_chng_flag : '||
3122: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3123: arp_util.debug('p_frt_amt_chng_flag : '||
3124: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));

Line 3122: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));

3118: arp_util.debug('p_cr_frt_amount : '||l_credited_frt_amount );
3119: arp_util.debug('p_line_amt_chng_flag : '||
3120: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3121: arp_util.debug('p_tax_amt_chng_flag : '||
3122: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3123: arp_util.debug('p_frt_amt_chng_flag : '||
3124: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3125: arp_util.debug('p_tax_mode : '||l_tax_mode);
3126: arp_util.debug('p_frt_mode : '||l_frt_mode);

Line 3124: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));

3120: arp_trx_util.boolean_to_varchar2(l_line_amt_chng_flag));
3121: arp_util.debug('p_tax_amt_chng_flag : '||
3122: arp_trx_util.boolean_to_varchar2(l_tax_amt_chng_flag));
3123: arp_util.debug('p_frt_amt_chng_flag : '||
3124: arp_trx_util.boolean_to_varchar2(l_frt_amt_chng_flag));
3125: arp_util.debug('p_tax_mode : '||l_tax_mode);
3126: arp_util.debug('p_frt_mode : '||l_frt_mode);
3127: arp_util.debug('p_frt_ctlid : '||l_frt_ctlid);
3128: arp_util.debug('p_cm_complete_flag : '||l_cm_complete_flag);

Line 3245: arp_trx_util.lock_transaction(p_customer_trx_id);

3241: /*---------------------------------------------------------------+
3242: | Lock rows in other tables that reference this customer_trx_id |
3243: | and the credited transaction |
3244: +---------------------------------------------------------------*/
3245: arp_trx_util.lock_transaction(p_customer_trx_id);
3246:
3247: /*--------------------+
3248: | pre-update logic |
3249: +--------------------*/