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 27: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

23: /*========================================================================
24: | Prototype Declarations Procedures
25: *=======================================================================*/
26:
27: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
28:
29:
30: FUNCTION get_iby_account_type(p_account_type IN VARCHAR2) RETURN VARCHAR2;
31:

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

376: -------------------------------------------------------------------------------------
377: IF (PG_DEBUG = 'Y') THEN
378: arp_standard.debug('No Fixed Rate');
379: END IF;
380: p_exchange_rate_type := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
381:
382: IF (PG_DEBUG = 'Y') THEN
383: arp_standard.debug('Profile option default exch rate type: '|| p_exchange_rate_type);
384: END IF;

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

625: ce_bank_acct_uses_ou_v aba,
626: ce_bank_accounts cba,
627: ar_receipt_classes arc
628: WHERE arm.payment_channel_code = 'CREDIT_CARD'
629: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)
630: AND arm.receipt_method_id = arma.receipt_method_id
631: AND arm.receipt_class_id = arc.receipt_class_id
632: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id
633: AND aba.bank_account_id = cba.bank_account_id

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

645: ce_bank_acct_uses_ou_v aba,
646: ce_bank_accounts cba,
647: ar_receipt_classes arc
648: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'
649: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)
650: AND arm.receipt_method_id = arma.receipt_method_id
651: AND arm.receipt_class_id = arc.receipt_class_id
652: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id
653: AND aba.bank_account_id = cba.bank_account_id

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

733: IF (p_payment_instrument <> 'BANK_ACCOUNT') THEN
734: ---------------------------------------------------------------------------------
735: l_debug_info := 'Get payment method information from the OIR_CC_PMT_METHOD profile';
736: ---------------------------------------------------------------------------------
737: IF (fnd_profile.VALUE('OIR_CC_PMT_METHOD') IS NOT NULL AND fnd_profile.VALUE('OIR_CC_PMT_METHOD') <> 'DISABLED') THEN
738:
739: BEGIN
740:
741: OPEN cc_profile_pmt_method_info_cur;

Line 755: 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');

751: CLOSE cc_profile_pmt_method_info_cur;
752:
753: EXCEPTION
754: WHEN OTHERS THEN
755: 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');
756: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
757: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info
758: ||':ERROR =>'|| SQLERRM);
759: end if;

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

765: IF (p_payment_instrument <> 'CREDIT_CARD') THEN
766: ---------------------------------------------------------------------------------
767: l_debug_info := 'Get payment method information from the OIR_BA_PMT_METHOD profile';
768: ---------------------------------------------------------------------------------
769: IF (fnd_profile.VALUE('OIR_BA_PMT_METHOD') IS NOT NULL AND fnd_profile.VALUE('OIR_BA_PMT_METHOD') <> 'DISABLED') THEN
770:
771: BEGIN
772:
773: OPEN ba_profile_pmt_method_info_cur;

Line 787: 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');

783: CLOSE ba_profile_pmt_method_info_cur;
784:
785: EXCEPTION
786: WHEN OTHERS THEN
787: 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');
788: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
789: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info
790: ||':ERROR =>'|| SQLERRM);
791: end if;

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

5230: ce_bank_acct_uses_ou_v aba,
5231: ce_bank_accounts cba,
5232: ar_receipt_classes arc
5233: WHERE arm.payment_channel_code = 'CREDIT_CARD'
5234: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)
5235: AND arm.receipt_method_id = arma.receipt_method_id
5236: AND arm.receipt_class_id = arc.receipt_class_id
5237: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id
5238: AND aba.bank_account_id = cba.bank_account_id

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

5258: IF (PG_DEBUG = 'Y') THEN
5259: arp_standard.debug(l_debug_info);
5260: END IF;
5261:
5262: profile_cc_payment_method := FND_PROFILE.value('OIR_CC_PMT_METHOD');
5263:
5264: IF (profile_cc_payment_method = 'DISABLED') THEN /* Credit Card Payment is Disabled */
5265: RETURN 0;
5266: ELSIF (profile_cc_payment_method IS NOT NULL) THEN /* A Credit Card Payment Method has been mentioned */

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

5267: OPEN cc_profile_pmt_method_info_cur;
5268: FETCH cc_profile_pmt_method_info_cur INTO cc_profile_pmt_method_info;
5269: /* If CC Payment Method set is NULL or DISABLED or an invalid payment method, it returns NO rows */
5270: IF cc_profile_pmt_method_info_cur%FOUND THEN
5271: l_debug_info := 'Payment Method Set in the profile OIR_CC_PMT_METHOD is Valid. Val=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
5272: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5273: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5274: end if;
5275: RETURN 1;

Line 5277: 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');

5273: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5274: end if;
5275: RETURN 1;
5276: ELSE
5277: 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');
5278: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5279: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5280: end if;
5281: RETURN 0;

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

5371: END IF;
5372:
5373: EXCEPTION
5374: WHEN OTHERS THEN
5375: l_debug_info := 'Unknown exception. Value in profile OIR_CC_PMT_METHOD=' || fnd_profile.VALUE('OIR_CC_PMT_METHOD');
5376: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5377: write_debug_and_log('ERROR =>'|| SQLERRM);
5378: write_debug_and_log('-DEBUG_INFO-' || l_debug_info);
5379: RETURN 0;

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

5417: ce_bank_acct_uses_ou_v aba,
5418: ce_bank_accounts cba,
5419: ar_receipt_classes arc
5420: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'
5421: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)
5422: AND arm.receipt_method_id = arma.receipt_method_id
5423: AND arm.receipt_class_id = arc.receipt_class_id
5424: AND arma.remit_bank_acct_use_id = aba.bank_acct_use_id
5425: AND aba.bank_account_id = cba.bank_account_id

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

5443: IF (PG_DEBUG = 'Y') THEN
5444: arp_standard.debug(l_debug_info);
5445: END IF;
5446:
5447: profile_ba_payment_method := FND_PROFILE.value('OIR_BA_PMT_METHOD');
5448:
5449: IF (profile_ba_payment_method = 'DISABLED') THEN /* Bank Account Payment is Disabled */
5450: RETURN 0;
5451: ELSIF (profile_ba_payment_method IS NOT NULL) THEN /* A Bank Account Payment Method has been mentioned */

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

5452: OPEN ba_profile_pmt_method_info_cur;
5453: FETCH ba_profile_pmt_method_info_cur INTO ba_profile_pmt_method_info;
5454: /* If Bank Account Payment Method set is NULL or DISABLED or an invalid payment method, it returns NO rows */
5455: IF ba_profile_pmt_method_info_cur%FOUND THEN
5456: l_debug_info := 'Payment Method Set in the profile OIR_BA_PMT_METHOD is Valid. Val=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
5457: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5458: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5459: end if;
5460: RETURN 1;

Line 5462: 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');

5458: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5459: end if;
5460: RETURN 1;
5461: ELSE
5462: 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');
5463: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5464: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name, l_debug_info);
5465: end if;
5466: RETURN 0;

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

5544: END IF;
5545:
5546: EXCEPTION
5547: WHEN OTHERS THEN
5548: l_debug_info := 'Unknown exception. Value in profile OIR_BA_PMT_METHOD=' || fnd_profile.VALUE('OIR_BA_PMT_METHOD');
5549: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5550: write_debug_and_log('ERROR =>'|| SQLERRM);
5551: write_debug_and_log('-DEBUG_INFO-' || l_debug_info);
5552: RETURN 0;