eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_IREC_PAYMENTS dependencies on FND_PROFILE

Line 32: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

28: /*========================================================================
29: | Prototype Declarations Procedures
30: *=======================================================================*/
31:
32: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
33:
34:
35: FUNCTION get_iby_account_type(p_account_type IN VARCHAR2) RETURN VARCHAR2;
36:

Line 386: p_exchange_rate_type := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');

382: -------------------------------------------------------------------------------------
383: IF (PG_DEBUG = 'Y') THEN
384: arp_standard.debug('No Fixed Rate');
385: END IF;
386: p_exchange_rate_type := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
387:
388: IF (PG_DEBUG = 'Y') THEN
389: arp_standard.debug('Profile option default exch rate type: '|| p_exchange_rate_type);
390: END IF;

Line 637: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)

633: ce_bank_acct_uses_ou_v aba,
634: ce_bank_accounts cba,
635: ar_receipt_classes arc
636: WHERE arm.payment_channel_code = 'CREDIT_CARD'
637: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)
638: AND arm.receipt_method_id = arma.receipt_method_id
639: AND arm.receipt_class_id = arc.receipt_class_id
640: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id
641: AND aba.bank_account_id = cba.bank_account_id

Line 658: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)

654: ce_bank_acct_uses_ou_v aba,
655: ce_bank_accounts cba,
656: ar_receipt_classes arc
657: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'
658: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)
659: AND arm.receipt_method_id = arma.receipt_method_id
660: AND arm.receipt_class_id = arc.receipt_class_id
661: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id
662: AND aba.bank_account_id = cba.bank_account_id

Line 746: IF (fnd_profile.VALUE('OIR_CC_PMT_METHOD') IS NOT NULL AND fnd_profile.VALUE('OIR_CC_PMT_METHOD') <> 'DISABLED') THEN

742: IF (p_payment_instrument <> 'BANK_ACCOUNT') THEN
743: ---------------------------------------------------------------------------------
744: l_debug_info := 'Get payment method information from the OIR_CC_PMT_METHOD profile';
745: ---------------------------------------------------------------------------------
746: IF (fnd_profile.VALUE('OIR_CC_PMT_METHOD') IS NOT NULL AND fnd_profile.VALUE('OIR_CC_PMT_METHOD') <> 'DISABLED') THEN
747:
748: BEGIN
749:
750: OPEN cc_profile_pmt_method_info_cur;

Line 765: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_CC_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');

761: CLOSE cc_profile_pmt_method_info_cur;
762:
763: EXCEPTION
764: WHEN OTHERS THEN
765: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_CC_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
766: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
767: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info
768: ||':ERROR =>'|| SQLERRM);
769: end if;

Line 779: IF (fnd_profile.VALUE('OIR_BA_PMT_METHOD') IS NOT NULL AND fnd_profile.VALUE('OIR_BA_PMT_METHOD') <> 'DISABLED') THEN

775: IF (p_payment_instrument <> 'CREDIT_CARD') THEN
776: ---------------------------------------------------------------------------------
777: l_debug_info := 'Get payment method information from the OIR_BA_PMT_METHOD profile';
778: ---------------------------------------------------------------------------------
779: IF (fnd_profile.VALUE('OIR_BA_PMT_METHOD') IS NOT NULL AND fnd_profile.VALUE('OIR_BA_PMT_METHOD') <> 'DISABLED') THEN
780:
781: BEGIN
782:
783: OPEN ba_profile_pmt_method_info_cur;

Line 798: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_BA_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');

794: CLOSE ba_profile_pmt_method_info_cur;
795:
796: EXCEPTION
797: WHEN OTHERS THEN
798: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_BA_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
799: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
800: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info
801: ||':ERROR =>'|| SQLERRM);
802: end if;

Line 5879: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)

5875: ce_bank_acct_uses_ou_v aba,
5876: ce_bank_accounts cba,
5877: ar_receipt_classes arc
5878: WHERE arm.payment_channel_code = 'CREDIT_CARD'
5879: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)
5880: AND arm.receipt_method_id = arma.receipt_method_id
5881: AND arm.receipt_class_id = arc.receipt_class_id
5882: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id
5883: AND aba.bank_account_id = cba.bank_account_id

Line 5907: profile_cc_payment_method := FND_PROFILE.value('OIR_CC_PMT_METHOD');

5903: IF (PG_DEBUG = 'Y') THEN
5904: arp_standard.debug(l_debug_info);
5905: END IF;
5906:
5907: profile_cc_payment_method := FND_PROFILE.value('OIR_CC_PMT_METHOD');
5908:
5909: IF (profile_cc_payment_method = 'DISABLED') THEN /* Credit Card Payment is Disabled */
5910: RETURN 0;
5911: ELSIF (profile_cc_payment_method IS NOT NULL) THEN /* A Credit Card Payment Method has been mentioned */

Line 5916: l_debug_info := 'Payment Method Set in the profile OIR_CC_PMT_METHOD is Valid. Val=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');

5912: OPEN cc_profile_pmt_method_info_cur;
5913: FETCH cc_profile_pmt_method_info_cur INTO cc_profile_pmt_method_info;
5914: /* If CC Payment Method set is NULL or DISABLED or an invalid payment method, it returns NO rows */
5915: IF cc_profile_pmt_method_info_cur%FOUND THEN
5916: l_debug_info := 'Payment Method Set in the profile OIR_CC_PMT_METHOD is Valid. Val=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
5917: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5918: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5919: end if;
5920: RETURN 1;

Line 5922: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_CC_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');

5918: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5919: end if;
5920: RETURN 1;
5921: ELSE
5922: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_CC_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
5923: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5924: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5925: end if;
5926: RETURN 0;

Line 6022: l_debug_info := 'Unknown exception. Value in profile OIR_CC_PMT_METHOD=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');

6018: END IF;
6019:
6020: EXCEPTION
6021: WHEN OTHERS THEN
6022: l_debug_info := 'Unknown exception. Value in profile OIR_CC_PMT_METHOD=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
6023: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
6024: write_debug_and_log('ERROR =>'|| SQLERRM);
6025: write_debug_and_log('-DEBUG_INFO-' || l_debug_info);
6026: RETURN 0;

Line 6068: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)

6064: ce_bank_acct_uses_ou_v aba,
6065: ce_bank_accounts cba,
6066: ar_receipt_classes arc
6067: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'
6068: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)
6069: AND arm.receipt_method_id = arma.receipt_method_id
6070: AND arm.receipt_class_id = arc.receipt_class_id
6071: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id
6072: AND aba.bank_account_id = cba.bank_account_id

Line 6094: profile_ba_payment_method := FND_PROFILE.value('OIR_BA_PMT_METHOD');

6090: IF (PG_DEBUG = 'Y') THEN
6091: arp_standard.debug(l_debug_info);
6092: END IF;
6093:
6094: profile_ba_payment_method := FND_PROFILE.value('OIR_BA_PMT_METHOD');
6095:
6096: IF (profile_ba_payment_method = 'DISABLED') THEN /* Bank Account Payment is Disabled */
6097: RETURN 0;
6098: ELSIF (profile_ba_payment_method IS NOT NULL) THEN /* A Bank Account Payment Method has been mentioned */

Line 6103: l_debug_info := 'Payment Method Set in the profile OIR_BA_PMT_METHOD is Valid. Val=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');

6099: OPEN ba_profile_pmt_method_info_cur;
6100: FETCH ba_profile_pmt_method_info_cur INTO ba_profile_pmt_method_info;
6101: /* If Bank Account Payment Method set is NULL or DISABLED or an invalid payment method, it returns NO rows */
6102: IF ba_profile_pmt_method_info_cur%FOUND THEN
6103: l_debug_info := 'Payment Method Set in the profile OIR_BA_PMT_METHOD is Valid. Val=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
6104: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
6106: end if;
6107: RETURN 1;

Line 6109: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_BA_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');

6105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
6106: end if;
6107: RETURN 1;
6108: ELSE
6109: l_debug_info := 'Invalid Payment Method is Set in the profile OIR_BA_PMT_METHOD. Value in profile=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
6110: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
6111: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
6112: end if;
6113: RETURN 0;

Line 6195: l_debug_info := 'Unknown exception. Value in profile OIR_BA_PMT_METHOD=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');

6191: END IF;
6192:
6193: EXCEPTION
6194: WHEN OTHERS THEN
6195: l_debug_info := 'Unknown exception. Value in profile OIR_BA_PMT_METHOD=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
6196: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
6197: write_debug_and_log('ERROR =>'|| SQLERRM);
6198: write_debug_and_log('-DEBUG_INFO-' || l_debug_info);
6199: RETURN 0;