DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on IBY_EXT_BANKACCT_PUB

Line 931: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;

927: where INSTRUMENT_ID = p_bank_account_id AND PARTY_ID = l_party_id
928: AND((l_customer_site_id IS NOT NULL AND ACCT_SITE_USE_ID = l_customer_site_id ) OR (l_customer_site_id IS NULL AND ACCT_SITE_USE_ID IS NULL));
929:
930: l_create_credit_card IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
931: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
932: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
933: l_procedure_name VARCHAR2(30);
934: l_party_id NUMBER;
935: l_payerContext_Rec_type IBY_FNDCPT_COMMON_PUB.PayerContext_Rec_type;

Line 2927: l_ext_bank_act_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;

2923: p_bank_account_id OUT NOCOPY NUMBER) IS
2924:
2925:
2926: l_create_credit_card IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;
2927: l_ext_bank_act_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
2928: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2929: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2930: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
2931: l_payerContext_Rec_type IBY_FNDCPT_COMMON_PUB.PayerContext_Rec_type;

Line 2982: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;

2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
2979: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
2980: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2981: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2982: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;
2983: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
2984: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
2985: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
2986: l_address_country ce_bank_branches_v.country% TYPE default 'US';

Line 2983: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;

2979: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
2980: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2981: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2982: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;
2983: l_ext_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
2984: l_bank_party_id ce_bank_branches_v.bank_party_id%TYPE;
2985: l_branch_party_id ce_bank_branches_v.branch_party_id%TYPE;
2986: l_address_country ce_bank_branches_v.country% TYPE default 'US';
2987: l_bank_name ar_bank_directory.bank_name%type;

Line 3087: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');

3083: l_ext_branch_rec.bch_object_version_number :='1';
3084: l_ext_branch_rec.typ_object_version_number :='1';
3085:
3086: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3087: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');
3088: end if;
3089:
3090: iby_ext_bankacct_pub.create_ext_bank_branch(
3091: -- IN parameters

Line 3090: iby_ext_bankacct_pub.create_ext_bank_branch(

3086: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3087: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');
3088: end if;
3089:
3090: iby_ext_bankacct_pub.create_ext_bank_branch(
3091: -- IN parameters
3092: p_api_version => l_api_version,
3093: p_init_msg_list => l_init_msg_list,
3094: p_ext_bank_branch_rec => l_ext_branch_rec,

Line 3103: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');

3099: x_msg_data => x_msg_data,
3100: x_response => l_branch_response);
3101:
3102: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3103: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3104: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3106: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3107: end if;

Line 3128: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank .....');

3124: l_ext_bank_rec.country_code := 'US'; --Create banks are used from Federal Sites.. which has details about US banks only.
3125: l_ext_bank_rec.object_version_number := '1';
3126:
3127: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3128: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank .....');
3129: end if;
3130:
3131: iby_ext_bankacct_pub.create_ext_bank(
3132: -- IN parameters

Line 3131: iby_ext_bankacct_pub.create_ext_bank(

3127: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3128: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank .....');
3129: end if;
3130:
3131: iby_ext_bankacct_pub.create_ext_bank(
3132: -- IN parameters
3133: p_api_version => l_api_version,
3134: p_init_msg_list => l_init_msg_list,
3135: p_ext_bank_rec => l_ext_bank_rec,

Line 3144: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'end iby_ext_bankacct_pub.create_ext_bank');

3140: x_msg_data => x_msg_data,
3141: x_response => l_bank_response );
3142:
3143: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3144: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'end iby_ext_bankacct_pub.create_ext_bank');
3145: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank party Id ::' || l_bank_party_id);
3146: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_return_status ::' || x_return_status);
3147: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_msg_data ::' || x_msg_data);
3148: end if;

Line 3163: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');

3159: l_ext_branch_rec.bch_object_version_number :='1';
3160: l_ext_branch_rec.typ_object_version_number :='1';
3161:
3162: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3163: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');
3164: end if;
3165:
3166: iby_ext_bankacct_pub.create_ext_bank_branch(
3167: -- IN parameters

Line 3166: iby_ext_bankacct_pub.create_ext_bank_branch(

3162: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3163: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling iby_ext_bankacct_pub.create_ext_bank_branch .....');
3164: end if;
3165:
3166: iby_ext_bankacct_pub.create_ext_bank_branch(
3167: -- IN parameters
3168: p_api_version => l_api_version,
3169: p_init_msg_list => l_init_msg_list,
3170: p_ext_bank_branch_rec => l_ext_branch_rec,

Line 3179: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');

3175: x_msg_data => x_msg_data,
3176: x_response => l_branch_response);
3177:
3178: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3179: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'End iby_ext_bankacct_pub.create_ext_bank_branch');
3180: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch party id :: '||l_branch_party_id);
3181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3182: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3183: end if;

Line 3225: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct ..');

3221: l_ext_bank_act_rec.acct_type := p_account_type;
3222: l_ext_bank_act_rec.iban := p_iban;
3223:
3224: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3225: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct ..');
3226: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.bank_id :: '||l_ext_bank_act_rec.bank_id);
3227: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.branch_id ::' || l_ext_bank_act_rec.branch_id);
3228: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.country_code ::' || l_ext_bank_act_rec.country_code);
3229: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_owner_party_id :: '||l_ext_bank_act_rec.acct_owner_party_id);

Line 3237: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct(

3233: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.iban ::' || l_ext_bank_act_rec.iban );
3234: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_ext_bank_act_rec.acct_type ::' || l_ext_bank_act_rec.acct_type);
3235: end if;
3236:
3237: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct(
3238: p_api_version => 1.0,
3239: p_init_msg_list => FND_API.G_FALSE,
3240: p_ext_bank_acct_rec => l_ext_bank_act_rec,
3241: x_acct_id => l_bank_account_id,

Line 3311: IBY_EXT_BANKACCT_PUB.add_joint_account_owner(

3307: AND EXT_BANK_ACCOUNT_ID = l_bank_account_id;
3308:
3309: if(l_count <= 0) then
3310: write_debug_and_log('Adding joint account owner >> l_bank_account_id '||l_bank_account_id||' p_payer_party_id :'||p_payer_party_id);
3311: IBY_EXT_BANKACCT_PUB.add_joint_account_owner(
3312: p_api_version => 1.0,
3313: p_init_msg_list => FND_API.G_FALSE,
3314: p_bank_account_id => l_bank_account_id,
3315: p_acct_owner_party_id => p_payer_party_id,