[Home] [Help]
604: l_msg_count NUMBER := 0 ;
605: l_msg_data VARCHAR2(2000):= NULL ;
606: l_result_out VARCHAR2(30) := NULL ;
607: l_return_status VARCHAR2(30) := NULL ;
608: l_fnd_profile_value VARCHAR2(1);
609: l_format_mask VARCHAR2(500);
610: l_trx_date DATE;
611: l_trxn_extension_id NUMBER; --R12 CC Encryption
612:
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add( 'OEXVPPYB: VALUE FOR L_PPP_HOLD_EXISTS IS: '||L_PPP_HOLD_EXISTS , 1 ) ;
688: END IF;
689:
690: l_fnd_profile_value := fnd_profile.value('ONT_PROCESS_PAYMENT_IMMEDIATELY');
691:
692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add( 'OEXVPPYB: VALUE FOR PREPAYMENT PROFILE OPTION IS : '||L_FND_PROFILE_VALUE , 1 ) ;
694: END IF;
689:
690: l_fnd_profile_value := fnd_profile.value('ONT_PROCESS_PAYMENT_IMMEDIATELY');
691:
692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add( 'OEXVPPYB: VALUE FOR PREPAYMENT PROFILE OPTION IS : '||L_FND_PROFILE_VALUE , 1 ) ;
694: END IF;
695:
696: IF l_ppp_hold_exists = 'N' THEN
697: IF l_fnd_profile_value= 'Y' THEN
693: oe_debug_pub.add( 'OEXVPPYB: VALUE FOR PREPAYMENT PROFILE OPTION IS : '||L_FND_PROFILE_VALUE , 1 ) ;
694: END IF;
695:
696: IF l_ppp_hold_exists = 'N' THEN
697: IF l_fnd_profile_value= 'Y' THEN
698: l_process_payment := 'Y';
699: ELSE
700: l_apply_ppp_hold := 'Y';
701: END IF;
757: -- bug 3486808
758: --R12 CC Encryption
759: --Verify
760: /*l_trx_date := nvl(p_header_rec.ordered_date, sysdate)
761: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);
762:
763: arp_bank_pkg.process_cust_bank_account
764: ( p_trx_date => l_trx_date
765: , p_currency_code => p_header_rec.transactional_curr_code
3181:
3182: select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;
3183:
3184: -- MOAC changes
3185: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;
3186: SELECT org_id
3187: INTO l_organization_id
3188: FROM oe_order_headers_all
3189: WHERE header_id = p_header_id;