APPS.PER_FR_ORG_DDF_VALIDATION dependencies on HR_ORGANIZATION_INFORMATION

Line 17: from hr_organization_information

13: l_proc varchar2(72) := g_package||'.validate_fr_opm_mapping';
14: L_dummy number;
15: Cursor csr_chk_specific_opm is
16: select 1
17: from hr_organization_information
18: where ORG_INFORMATION_CONTEXT = 'FR_DYN_PAYMETH_MAPPING_INFO'
19: and ORG_INFORMATION1 = p_org_information1
20: and ORGANIZATION_ID <> p_organization_id;
21: --

Line 24: from hr_organization_information

20: and ORGANIZATION_ID <> p_organization_id;
21: --
22: cursor csr_chk_generic_opm is
23: select 1
24: from hr_organization_information
25: where ORG_INFORMATION_CONTEXT = 'FR_DYN_PAYMETH_MAPPING_INFO'
26: and ORG_INFORMATION2 = p_org_information2
27: and ORGANIZATION_ID = p_organization_id
28: and org_information_id <> p_org_information_id;

Line 42: (p_check_column1 => 'HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1')

38: hr_utility.set_location('Entering: '||l_proc,5);
39: if p_org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO' then
40: hr_utility.set_location(l_proc,10);
41: if hr_multi_message.no_exclusive_error
42: (p_check_column1 => 'HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1')
43: then
44: -- No error for ORG_INFORMATION1 already exists so,
45: -- prevent account-specific methods from being attached to more than
46: -- one organization, but allow them to be registered more than once to

Line 55: 'HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1');

51: If csr_chk_specific_opm%FOUND then
52: Close csr_chk_specific_opm;
53: fnd_message.set_name('PER', 'HR_75032_ORI_SPEC_OPM_EXISTS');
54: hr_multi_message.add(p_associated_column1 =>
55: 'HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1');
56: else
57: close csr_chk_specific_opm;
58: end if;
59: end if; -- check existing errors

Line 61: (p_check_column1 => 'HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2')

57: close csr_chk_specific_opm;
58: end if;
59: end if; -- check existing errors
60: if hr_multi_message.no_exclusive_error
61: (p_check_column1 => 'HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2')
62: then
63: -- No error for ORG_INFORMATION2 already exists so,
64: -- prevent account-independent methods from being attached to an
65: -- organization more than once.

Line 73: 'HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2');

69: if csr_chk_generic_opm%FOUND then
70: close csr_chk_generic_opm;
71: fnd_message.set_name('PER', 'HR_75033_ORI_GEN_OPM_EXISTS');
72: hr_multi_message.add(p_associated_column1 =>
73: 'HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2');
74: else
75: close csr_chk_generic_opm;
76: end if;
77: end if; -- check existing errors