DBA Data[Home] [Help]

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.12.12010000.2 2008/10/02 16:31:52 csutaria ship $ */
3:
4: --l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5: l_DEBUG varchar2(1) := 'Y';
6:
7:
8: /*=======================================================================+

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

276: l_bank_rec.country := p_country_code;
277: l_bank_rec.institution_type := 'BANK';
278: l_bank_rec.organization_rec := l_org_rec;
279:
280: l_gen_party_num := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
281: if (l_gen_party_num = 'N') then
282: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
283: end if;
284:

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

278: l_bank_rec.organization_rec := l_org_rec;
279:
280: l_gen_party_num := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
281: if (l_gen_party_num = 'N') then
282: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
283: end if;
284:
285: hz_bank_pub.create_bank(fnd_api.g_false, l_bank_rec, x_bank_id, l_party_number,
286: l_profile_id, l_code_assignment_id,

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

286: l_profile_id, l_code_assignment_id,
287: x_return_status, x_msg_count, x_msg_data);
288:
289: if (l_gen_party_num = 'N') then
290: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');
291: end if;
292:
293: -- raise an exception if error creating bank
294: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

1096: l_branch_rec.institution_type := 'BANK_BRANCH';
1097: l_branch_rec.organization_rec := l_org_rec;
1098: l_branch_rec.country := l_country;
1099:
1100: l_gen_party_num := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
1101: if (l_gen_party_num = 'N') then
1102: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
1103: end if;
1104:

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

1098: l_branch_rec.country := l_country;
1099:
1100: l_gen_party_num := fnd_profile.value('HZ_GENERATE_PARTY_NUMBER');
1101: if (l_gen_party_num = 'N') then
1102: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'Y');
1103: end if;
1104:
1105: hz_bank_pub.create_bank_branch(fnd_api.g_false, l_branch_rec, p_bank_id,
1106: x_branch_id, l_party_number,

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

1110: l_rfc_code_assignment_id,
1111: x_return_status, x_msg_count, x_msg_data);
1112:
1113: if (l_gen_party_num = 'N') then
1114: fnd_profile.put('HZ_GENERATE_PARTY_NUMBER', 'N');
1115: end if;
1116:
1117: -- raise an exception if the branch creation is unsuccessful
1118: IF x_return_status <> fnd_api.g_ret_sts_success THEN