APPS.OE_VERIFY_PAYMENT_PUB dependencies on FND_PROFILE

Line 1189: -- IF NVL(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER')

1185:
1186:
1187: -- lkxu 10/22/02: commented out the check for profile option,
1188: -- as this profile option is not being used any more.
1189: -- IF NVL(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER')
1190: -- = 'ORDER' THEN
1191: BEGIN
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add( 'OEXPVPMB:INTO MULTI CREDIT CHECKING FLOW ' , 1 ) ;

Line 1263: -- IF Nvl(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER') = 'ORDER' THEN

1259: --
1260:
1261: -- lkxu, call different code according to the profile option.
1262: -- No need to check this profile option as it is not being used any more.
1263: -- IF Nvl(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER') = 'ORDER' THEN
1264: -- calling order level credit checking.
1265:
1266: OE_Credit_PUB.Check_Available_Credit
1267: ( p_header_id => l_header_rec.header_id

Line 1519: -- IF NVL(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER')

1515:
1516:
1517: -- lkxu 10/22/02: commented out the check for profile option,
1518: -- as this profile option is not being used any more.
1519: -- IF NVL(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER')
1520: -- = 'ORDER' THEN
1521: BEGIN
1522: IF l_debug_level > 0 THEN
1523: oe_debug_pub.add( 'OEXPVPMB:INTO MULTI CREDIT CHECKING FLOW ' , 1 ) ;

Line 1592: -- IF Nvl(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER') = 'ORDER' THEN

1588: --
1589:
1590: -- lkxu, call different code according to the profile option.
1591: -- No need to check this profile option as it is not being used any more.
1592: -- IF Nvl(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER') = 'ORDER' THEN
1593: -- calling order level credit checking.
1594:
1595: OE_Credit_PUB.Check_Available_Credit
1596: ( p_header_id => l_header_rec.header_id

Line 3384: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);

3380: --
3381:
3382: /**
3383: l_cust_trx_date := nvl(p_header_rec.ordered_date, sysdate)
3384: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);
3385: begin
3386: arp_bank_pkg.process_cust_bank_account
3387: ( p_trx_date => l_cust_trx_date
3388: , p_currency_code => p_header_rec.transactional_curr_code

Line 3770: l_risk_threshold := TO_NUMBER(NVL(fnd_profile.value('ONT_RISK_FAC_THRESHOLD'), '0')) ;

3766: oe_debug_pub.add( 'OEXPVPMB: RISK RESPONSE INCLUDED : '||L_RISKRESP_INCLUDED ) ;
3767: END IF;
3768:
3769: IF l_riskresp_included = 'YES' THEN
3770: l_risk_threshold := TO_NUMBER(NVL(fnd_profile.value('ONT_RISK_FAC_THRESHOLD'), '0')) ;
3771:
3772: IF l_debug_level > 0 THEN
3773: oe_debug_pub.add( 'OEXPVPMB: RISK SCORE : '||L_RISK_SCORE ) ;
3774: END IF;

Line 3899: l_est_valid_days := to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0') ) ;

3895: IF l_debug_level > 0 THEN
3896: oe_debug_pub.add( 'OEXPVPMB: FETCHING VALUE FOR OM: ESTIMATED AUTHORIZATION VALIDITY PERIOD' ) ;
3897: END IF;
3898: --
3899: l_est_valid_days := to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0') ) ;
3900:
3901: IF l_debug_level > 0 THEN
3902: oe_debug_pub.add( 'OEXPVPMB: OM: ESTIMATED AUTHORIZATION VALIDITY PERIOD : '|| L_EST_VALID_DAYS ) ;
3903: END IF;

Line 4168: l_pay_method_id := to_number(nvl(fnd_profile.value('ONT_RECEIPT_METHOD_ID'), '0')) ;

4164: IF l_debug_level > 0 THEN
4165: oe_debug_pub.add( 'OEXPVPMB: FETCHING PAYMENT METHOD ID FROM PROFILE OPTION' ) ;
4166: END IF;
4167: --
4168: l_pay_method_id := to_number(nvl(fnd_profile.value('ONT_RECEIPT_METHOD_ID'), '0')) ;
4169: --
4170: IF l_debug_level > 0 THEN
4171: oe_debug_pub.add( 'OEXPVPMB: PROFILE PAYMENT METHOD ID IS : '||L_PAY_METHOD_ID ) ;
4172: END IF;

Line 4183: -- - nvl(to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);

4179:
4180: -- comment out the code for R12 cc encryption project
4181: -- Fixed for the FP bug 3881076
4182: -- l_as_of_date := nvl(p_header_rec.ordered_date, sysdate)
4183: -- - nvl(to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);
4184:
4185: l_cust_pay_method_id := arp_bank_pkg.process_cust_pay_method
4186: ( p_pay_method_id => l_pay_method_id
4187: , p_customer_id => p_header_rec.sold_to_org_id

Line 4813: l_est_valid_days := to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0') ) ;

4809:
4810: -- Fetch the value for profile "OM: Estimated Authorization Validity Period"
4811: -- This is required to estimate the validity of Authorization which might
4812: -- have been taken through iPayment, but was not updated on the order header.
4813: l_est_valid_days := to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0') ) ;
4814:
4815: IF l_debug_level > 0 THEN
4816: oe_debug_pub.add( 'OEXPVPMB: FETCH_LAST_AUTH , ESTIMATED AUTH VALIDITY PERIOD : '|| L_EST_VALID_DAYS ) ;
4817: END IF;

Line 5771: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/

5767: */
5768:
5769: --R12 CC Encryption
5770: /*l_cust_trx_date := l_ordered_date
5771: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/
5772: -- IF p_line_id is null then
5773: IF l_payments_tbl(I).line_id IS NULL THEN
5774: IF l_debug_level > 0 THEN
5775: oe_debug_pub.add('Before getting trxn id'||l_payments_tbl(I).line_id||' and '||p_header_rec.header_id);

Line 6363: l_risk_threshold := TO_NUMBER(NVL(fnd_profile.value('ONT_RISK_FAC_THRESHOLD'), '0')) ;

6359: oe_debug_pub.add( 'OEXPVPMB: RISK RESPONSE INCLUDED : '||L_RISKRESP_INCLUDED ) ;
6360: END IF;
6361:
6362: IF l_riskresp_included = 'YES' THEN
6363: l_risk_threshold := TO_NUMBER(NVL(fnd_profile.value('ONT_RISK_FAC_THRESHOLD'), '0')) ;
6364:
6365: IF l_debug_level > 0 THEN
6366: oe_debug_pub.add( 'OEXPVPMB: RISK SCORE : '||L_RISK_SCORE ) ;
6367: END IF;