APPS.CE_BANK_PUB dependencies on FND_PROFILE

Line 4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

1: PACKAGE BODY ce_bank_pub AS
2: /*$Header: ceextbab.pls 120.27.12020000.3 2012/09/21 20:54:21 ckansara ship $ */
3:
4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5: -- l_DEBUG varchar2(1) := 'Y';
6:
7: -- 12557352: Added check_mandatory_param
8: /*=======================================================================+

Line 306: l_gen_party_num := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');

302: l_bank_rec.country := p_country_code;
303: l_bank_rec.institution_type := 'BANK';
304: l_bank_rec.organization_rec := l_org_rec;
305:
306: l_gen_party_num := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
307: if (l_gen_party_num = 'N') then
308: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
309: end if;
310:

Line 308: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');

304: l_bank_rec.organization_rec := l_org_rec;
305:
306: l_gen_party_num := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
307: if (l_gen_party_num = 'N') then
308: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
309: end if;
310:
311: hz_bank_pub.create_bank(fnd_api.g_false, l_bank_rec, x_bank_id, l_party_number,
312: l_profile_id, l_code_assignment_id,

Line 316: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');

312: l_profile_id, l_code_assignment_id,
313: x_return_status, x_msg_count, x_msg_data);
314:
315: if (l_gen_party_num = 'N') then
316: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');
317: end if;
318:
319: -- raise an exception if error creating bank
320: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1153: l_gen_party_num := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');

1149: l_branch_rec.institution_type := 'BANK_BRANCH';
1150: l_branch_rec.organization_rec := l_org_rec;
1151: l_branch_rec.country := l_country;
1152:
1153: l_gen_party_num := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
1154: if (l_gen_party_num = 'N') then
1155: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
1156: end if;
1157:

Line 1155: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');

1151: l_branch_rec.country := l_country;
1152:
1153: l_gen_party_num := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
1154: if (l_gen_party_num = 'N') then
1155: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
1156: end if;
1157:
1158: hz_bank_pub.create_bank_branch(fnd_api.g_false, l_branch_rec, p_bank_id,
1159: x_branch_id, l_party_number,

Line 1167: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');

1163: l_rfc_code_assignment_id,
1164: x_return_status, x_msg_count, x_msg_data);
1165:
1166: if (l_gen_party_num = 'N') then
1167: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');
1168: end if;
1169:
1170: -- raise an exception if the branch creation is unsuccessful
1171: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 2567: l_maskoption:=fnd_profile.value('CE_MASK_INTERNAL_BANK_ACCT_NUM');

2563: l_replaceMaskChar VARCHAR2(100);
2564: l_newMaskedValues VARCHAR2(100);
2565: BEGIN
2566:
2567: l_maskoption:=fnd_profile.value('CE_MASK_INTERNAL_BANK_ACCT_NUM');
2568: if l_maskOption is null then
2569: l_maskOption:= 'LAST FOUR VISIBLE';
2570: end if;
2571: l_acctNumLen:= length(p_bank_account_num);