835:
836:
837:
838: l_dup_site_code:='F';
839: l_user_id := fnd_global.user_id;
840: l_login_id := fnd_global.login_id;
841: l_account_uses_insert_flag := 'N'; -- Do not insert bank acct uses
842: l_account_uses_upd_flag := 'N'; -- Do not update bank acct uses
843: l_bank_branch_id := p_bank_branch_id;
836:
837:
838: l_dup_site_code:='F';
839: l_user_id := fnd_global.user_id;
840: l_login_id := fnd_global.login_id;
841: l_account_uses_insert_flag := 'N'; -- Do not insert bank acct uses
842: l_account_uses_upd_flag := 'N'; -- Do not update bank acct uses
843: l_bank_branch_id := p_bank_branch_id;
844:
3037:
3038: BANK_USES_EXCEPTION EXCEPTION;
3039:
3040: BEGIN
3041: l_user_id := fnd_global.user_id;
3042: l_login_id := fnd_global.login_id;
3043:
3044: SELECT party_id,vendor_type_lookup_code
3045: INTO l_party_id,l_vendor_type_lookup_code
3038: BANK_USES_EXCEPTION EXCEPTION;
3039:
3040: BEGIN
3041: l_user_id := fnd_global.user_id;
3042: l_login_id := fnd_global.login_id;
3043:
3044: SELECT party_id,vendor_type_lookup_code
3045: INTO l_party_id,l_vendor_type_lookup_code
3046: FROM ap_suppliers