APPS.OE_VERIFY_PAYMENT_PUB dependencies on FND_PROFILE

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

1257:
1258:
1259: -- lkxu 10/22/02: commented out the check for profile option,
1260: -- as this profile option is not being used any more.
1261: -- IF NVL(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER')
1262: -- = 'ORDER' THEN
1263: BEGIN
1264: IF l_debug_level > 0 THEN
1265: oe_debug_pub.add( 'OEXPVPMB:INTO MULTI CREDIT CHECKING FLOW ' , 1 ) ;

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

1331: --
1332:
1333: -- lkxu, call different code according to the profile option.
1334: -- No need to check this profile option as it is not being used any more.
1335: -- IF Nvl(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER') = 'ORDER' THEN
1336: -- calling order level credit checking.
1337:
1338: OE_Credit_PUB.Check_Available_Credit
1339: ( p_header_id => l_header_rec.header_id

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

1587:
1588:
1589: -- lkxu 10/22/02: commented out the check for profile option,
1590: -- as this profile option is not being used any more.
1591: -- IF NVL(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER')
1592: -- = 'ORDER' THEN
1593: BEGIN
1594: IF l_debug_level > 0 THEN
1595: oe_debug_pub.add( 'OEXPVPMB:INTO MULTI CREDIT CHECKING FLOW ' , 1 ) ;

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

1660: --
1661:
1662: -- lkxu, call different code according to the profile option.
1663: -- No need to check this profile option as it is not being used any more.
1664: -- IF Nvl(Fnd_Profile.Value('OE_CREDIT_CHECKING_LEVEL'),'ORDER') = 'ORDER' THEN
1665: -- calling order level credit checking.
1666:
1667: OE_Credit_PUB.Check_Available_Credit
1668: ( p_header_id => l_header_rec.header_id

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

3453: --
3454:
3455: /**
3456: l_cust_trx_date := nvl(p_header_rec.ordered_date, sysdate)
3457: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);
3458: begin
3459: arp_bank_pkg.process_cust_bank_account
3460: ( p_trx_date => l_cust_trx_date
3461: , p_currency_code => p_header_rec.transactional_curr_code

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

3839: oe_debug_pub.add( 'OEXPVPMB: RISK RESPONSE INCLUDED : '||L_RISKRESP_INCLUDED ) ;
3840: END IF;
3841:
3842: IF l_riskresp_included = 'YES' THEN
3843: l_risk_threshold := TO_NUMBER(NVL(fnd_profile.value('ONT_RISK_FAC_THRESHOLD'), '0')) ;
3844:
3845: IF l_debug_level > 0 THEN
3846: oe_debug_pub.add( 'OEXPVPMB: RISK SCORE : '||L_RISK_SCORE ) ;
3847: END IF;

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

3968: IF l_debug_level > 0 THEN
3969: oe_debug_pub.add( 'OEXPVPMB: FETCHING VALUE FOR OM: ESTIMATED AUTHORIZATION VALIDITY PERIOD' ) ;
3970: END IF;
3971: --
3972: l_est_valid_days := to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0') ) ;
3973:
3974: IF l_debug_level > 0 THEN
3975: oe_debug_pub.add( 'OEXPVPMB: OM: ESTIMATED AUTHORIZATION VALIDITY PERIOD : '|| L_EST_VALID_DAYS ) ;
3976: END IF;

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

4237: IF l_debug_level > 0 THEN
4238: oe_debug_pub.add( 'OEXPVPMB: FETCHING PAYMENT METHOD ID FROM PROFILE OPTION' ) ;
4239: END IF;
4240: --
4241: l_pay_method_id := to_number(nvl(fnd_profile.value('ONT_RECEIPT_METHOD_ID'), '0')) ;
4242: --
4243: IF l_debug_level > 0 THEN
4244: oe_debug_pub.add( 'OEXPVPMB: PROFILE PAYMENT METHOD ID IS : '||L_PAY_METHOD_ID ) ;
4245: END IF;

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

4252:
4253: -- comment out the code for R12 cc encryption project
4254: -- Fixed for the FP bug 3881076
4255: -- l_as_of_date := nvl(p_header_rec.ordered_date, sysdate)
4256: -- - nvl(to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);
4257:
4258: l_cust_pay_method_id := arp_bank_pkg.process_cust_pay_method
4259: ( p_pay_method_id => l_pay_method_id
4260: , p_customer_id => p_header_rec.sold_to_org_id

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

4882:
4883: -- Fetch the value for profile "OM: Estimated Authorization Validity Period"
4884: -- This is required to estimate the validity of Authorization which might
4885: -- have been taken through iPayment, but was not updated on the order header.
4886: l_est_valid_days := to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0') ) ;
4887:
4888: IF l_debug_level > 0 THEN
4889: oe_debug_pub.add( 'OEXPVPMB: FETCH_LAST_AUTH , ESTIMATED AUTH VALIDITY PERIOD : '|| L_EST_VALID_DAYS ) ;
4890: END IF;

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

5931: */
5932:
5933: --R12 CC Encryption
5934: /*l_cust_trx_date := l_ordered_date
5935: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);*/
5936: -- IF p_line_id is null then
5937: IF l_payments_tbl(I).line_id IS NULL THEN
5938: IF l_debug_level > 0 THEN
5939: oe_debug_pub.add('Before getting trxn id'||l_payments_tbl(I).line_id||' and '||p_header_rec.header_id);

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

6660: oe_debug_pub.add( 'OEXPVPMB: RISK RESPONSE INCLUDED : '||L_RISKRESP_INCLUDED ) ;
6661: END IF;
6662:
6663: IF l_riskresp_included = 'YES' THEN
6664: l_risk_threshold := TO_NUMBER(NVL(fnd_profile.value('ONT_RISK_FAC_THRESHOLD'), '0')) ;
6665:
6666: IF l_debug_level > 0 THEN
6667: oe_debug_pub.add( 'OEXPVPMB: RISK SCORE : '||L_RISK_SCORE ) ;
6668: END IF;