APPS.IRC_IDO_BUS dependencies on HZ_PARTIES

Line 84: -- This process validates the party_id exists in HZ_PARTIES, on insert.

80: --
81: -- {Start Of Comments}
82: --
83: -- Description:
84: -- This process validates the party_id exists in HZ_PARTIES, on insert.
85: --
86: -- Pre Conditions:
87: -- None.
88: --

Line 97: -- 1: p_party_id does not exist in HZ_PARTIES

93: -- Processing continues.
94: --
95: -- Post Failure:
96: -- An application error will be raised for the following faliure conditions:
97: -- 1: p_party_id does not exist in HZ_PARTIES
98: --
99: -- Access Status:
100: -- Internal Table Handler Use Only.
101: Procedure chk_party_id(p_party_id in number) is

Line 105: l_party_id hz_parties.party_id%type ;

101: Procedure chk_party_id(p_party_id in number) is
102: --
103: l_proc varchar2(72) := g_package||'chk_party_id';
104: --
105: l_party_id hz_parties.party_id%type ;
106: cursor csr_valid_party is
107: select hp.party_id
108: from hz_parties hp
109: where hp.party_id = p_party_id;

Line 108: from hz_parties hp

104: --
105: l_party_id hz_parties.party_id%type ;
106: cursor csr_valid_party is
107: select hp.party_id
108: from hz_parties hp
109: where hp.party_id = p_party_id;
110: begin
111: hr_utility.set_location('Entering: '|| l_proc, 1);
112: --

Line 113: -- Check the party_id being passed exists on HZ_PARTIES table.

109: where hp.party_id = p_party_id;
110: begin
111: hr_utility.set_location('Entering: '|| l_proc, 1);
112: --
113: -- Check the party_id being passed exists on HZ_PARTIES table.
114: --
115: open csr_valid_party;
116: fetch csr_valid_party into l_party_id;
117: if csr_valid_party%notfound then