eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_RO_CONTRACT_VAL dependencies on HR_UTILITY

Line 64: hr_utility.set_location('Entering : '||l_proc,5);

60:
61: BEGIN
62: l_proc:= g_package||'CHECK_RO_CONTRACT';
63:
64: hr_utility.set_location('Entering : '||l_proc,5);
65:
66: open csr_get_securityid;
67: fetch csr_get_securityid into l_security_id;
68: close csr_get_securityid;

Line 75: hr_utility.set_message(800,'PO_CONTRACT_TYPE_INVALID');

71: if p_type is not null then
72: open csr_get_type(l_security_id);
73: fetch csr_get_type into l_exists;
74: if csr_get_type%NOTFOUND then
75: hr_utility.set_message(800,'PO_CONTRACT_TYPE_INVALID');
76: hr_utility.raise_error;
77: end if;
78: close csr_get_type;
79: end if;

Line 76: hr_utility.raise_error;

72: open csr_get_type(l_security_id);
73: fetch csr_get_type into l_exists;
74: if csr_get_type%NOTFOUND then
75: hr_utility.set_message(800,'PO_CONTRACT_TYPE_INVALID');
76: hr_utility.raise_error;
77: end if;
78: close csr_get_type;
79: end if;
80:

Line 85: hr_utility.set_message(800,'OKC_REP_IMP_INV_STATUS');

81: if p_status is not null then
82: open csr_get_status(l_security_id);
83: fetch csr_get_status into l_exists;
84: if csr_get_status%NOTFOUND then
85: hr_utility.set_message(800,'OKC_REP_IMP_INV_STATUS');
86: hr_utility.raise_error;
87: end if;
88: close csr_get_status;
89: end if;

Line 86: hr_utility.raise_error;

82: open csr_get_status(l_security_id);
83: fetch csr_get_status into l_exists;
84: if csr_get_status%NOTFOUND then
85: hr_utility.set_message(800,'OKC_REP_IMP_INV_STATUS');
86: hr_utility.raise_error;
87: end if;
88: close csr_get_status;
89: end if;
90:

Line 93: hr_utility.set_location('Entering : '||l_proc,10);

89: end if;
90:
91:
92: if p_ctr_information1 is not null and p_status is null then
93: hr_utility.set_location('Entering : '||l_proc,10);
94: hr_utility.set_message(800,'HR_520027_CON_STA_REQ');
95: hr_utility.raise_error;
96: end if;
97:

Line 94: hr_utility.set_message(800,'HR_520027_CON_STA_REQ');

90:
91:
92: if p_ctr_information1 is not null and p_status is null then
93: hr_utility.set_location('Entering : '||l_proc,10);
94: hr_utility.set_message(800,'HR_520027_CON_STA_REQ');
95: hr_utility.raise_error;
96: end if;
97:
98: if p_status = 'A-SUSPENDED' then

Line 95: hr_utility.raise_error;

91:
92: if p_ctr_information1 is not null and p_status is null then
93: hr_utility.set_location('Entering : '||l_proc,10);
94: hr_utility.set_message(800,'HR_520027_CON_STA_REQ');
95: hr_utility.raise_error;
96: end if;
97:
98: if p_status = 'A-SUSPENDED' then
99:

Line 100: hr_utility.set_location(l_proc,15);

96: end if;
97:
98: if p_status = 'A-SUSPENDED' then
99:
100: hr_utility.set_location(l_proc,15);
101:
102: open csr_contract_legal_susp_reason;
103: fetch csr_contract_legal_susp_reason into l_exists;
104: if csr_contract_legal_susp_reason%NOTFOUND then

Line 105: hr_utility.set_message(800,'HR_520028_CON_INVAL_RES');

101:
102: open csr_contract_legal_susp_reason;
103: fetch csr_contract_legal_susp_reason into l_exists;
104: if csr_contract_legal_susp_reason%NOTFOUND then
105: hr_utility.set_message(800,'HR_520028_CON_INVAL_RES');
106: hr_utility.raise_error;
107: end if;
108: close csr_contract_legal_susp_reason;
109:

Line 106: hr_utility.raise_error;

102: open csr_contract_legal_susp_reason;
103: fetch csr_contract_legal_susp_reason into l_exists;
104: if csr_contract_legal_susp_reason%NOTFOUND then
105: hr_utility.set_message(800,'HR_520028_CON_INVAL_RES');
106: hr_utility.raise_error;
107: end if;
108: close csr_contract_legal_susp_reason;
109:
110: hr_utility.set_location(l_proc,20);

Line 110: hr_utility.set_location(l_proc,20);

106: hr_utility.raise_error;
107: end if;
108: close csr_contract_legal_susp_reason;
109:
110: hr_utility.set_location(l_proc,20);
111:
112: elsif p_status = 'RO-TERM' then
113:
114: hr_utility.set_location(l_proc,25);

Line 114: hr_utility.set_location(l_proc,25);

110: hr_utility.set_location(l_proc,20);
111:
112: elsif p_status = 'RO-TERM' then
113:
114: hr_utility.set_location(l_proc,25);
115:
116: open csr_contract_legal_term_reason;
117: fetch csr_contract_legal_term_reason into l_exists;
118: if csr_contract_legal_term_reason%NOTFOUND then

Line 119: hr_utility.set_message(800,'HR_520028_CON_INVAL_RES');

115:
116: open csr_contract_legal_term_reason;
117: fetch csr_contract_legal_term_reason into l_exists;
118: if csr_contract_legal_term_reason%NOTFOUND then
119: hr_utility.set_message(800,'HR_520028_CON_INVAL_RES');
120: hr_utility.raise_error;
121: end if;
122: close csr_contract_legal_term_reason;
123:

Line 120: hr_utility.raise_error;

116: open csr_contract_legal_term_reason;
117: fetch csr_contract_legal_term_reason into l_exists;
118: if csr_contract_legal_term_reason%NOTFOUND then
119: hr_utility.set_message(800,'HR_520028_CON_INVAL_RES');
120: hr_utility.raise_error;
121: end if;
122: close csr_contract_legal_term_reason;
123:
124: hr_utility.set_location(l_proc,30);

Line 124: hr_utility.set_location(l_proc,30);

120: hr_utility.raise_error;
121: end if;
122: close csr_contract_legal_term_reason;
123:
124: hr_utility.set_location(l_proc,30);
125:
126: elsif p_status = 'RO-REACT' then
127:
128: hr_utility.set_location(l_proc,35);

Line 128: hr_utility.set_location(l_proc,35);

124: hr_utility.set_location(l_proc,30);
125:
126: elsif p_status = 'RO-REACT' then
127:
128: hr_utility.set_location(l_proc,35);
129:
130: open csr_contract_react_reason;
131: fetch csr_contract_react_reason into l_exists;
132: if csr_contract_react_reason%NOTFOUND then

Line 133: hr_utility.set_message(800,'HR_520028_CON_INVAL_RES');

129:
130: open csr_contract_react_reason;
131: fetch csr_contract_react_reason into l_exists;
132: if csr_contract_react_reason%NOTFOUND then
133: hr_utility.set_message(800,'HR_520028_CON_INVAL_RES');
134: hr_utility.raise_error;
135: end if;
136: close csr_contract_react_reason;
137:

Line 134: hr_utility.raise_error;

130: open csr_contract_react_reason;
131: fetch csr_contract_react_reason into l_exists;
132: if csr_contract_react_reason%NOTFOUND then
133: hr_utility.set_message(800,'HR_520028_CON_INVAL_RES');
134: hr_utility.raise_error;
135: end if;
136: close csr_contract_react_reason;
137:
138: hr_utility.set_location(l_proc,40);

Line 138: hr_utility.set_location(l_proc,40);

134: hr_utility.raise_error;
135: end if;
136: close csr_contract_react_reason;
137:
138: hr_utility.set_location(l_proc,40);
139:
140: end if;
141:
142:

Line 143: hr_utility.set_location('Leaving : '||l_proc,50);

139:
140: end if;
141:
142:
143: hr_utility.set_location('Leaving : '||l_proc,50);
144:
145: END CHECK_RO_CONTRACT;
146:
147:

Line 170: hr_utility.set_location('Entering : '||l_proc,5);

166:
167: BEGIN
168: l_proc:= g_package||'CREATE_RO_CONTRACT';
169:
170: hr_utility.set_location('Entering : '||l_proc,5);
171:
172: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
173: hr_utility.set_location('Leaving : '||l_proc,10);
174: return;

Line 172: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

168: l_proc:= g_package||'CREATE_RO_CONTRACT';
169:
170: hr_utility.set_location('Entering : '||l_proc,5);
171:
172: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
173: hr_utility.set_location('Leaving : '||l_proc,10);
174: return;
175: END IF;
176:

Line 173: hr_utility.set_location('Leaving : '||l_proc,10);

169:
170: hr_utility.set_location('Entering : '||l_proc,5);
171:
172: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
173: hr_utility.set_location('Leaving : '||l_proc,10);
174: return;
175: END IF;
176:
177: -- No longer required as multiple contracts

Line 187: hr_utility.set_message(800,'HR_520026_CON_EXISTS');

183:
184: open csr_contract_exists;
185: fetch csr_contract_exists into l_exists;
186: if csr_contract_exists%FOUND then
187: hr_utility.set_message(800,'HR_520026_CON_EXISTS');
188: hr_utility.raise_error;
189: end if;
190: close csr_contract_exists;
191:

Line 188: hr_utility.raise_error;

184: open csr_contract_exists;
185: fetch csr_contract_exists into l_exists;
186: if csr_contract_exists%FOUND then
187: hr_utility.set_message(800,'HR_520026_CON_EXISTS');
188: hr_utility.raise_error;
189: end if;
190: close csr_contract_exists;
191:
192: */

Line 194: hr_utility.set_location(l_proc,15);

190: close csr_contract_exists;
191:
192: */
193:
194: hr_utility.set_location(l_proc,15);
195:
196: CHECK_RO_CONTRACT(p_person_id => p_person_id
197: ,p_type => p_type
198: ,p_status => p_status

Line 203: hr_utility.set_location('Leaving : '||l_proc,20);

199: ,p_ctr_information1 => p_ctr_information1
200: );
201:
202:
203: hr_utility.set_location('Leaving : '||l_proc,20);
204:
205: END CREATE_RO_CONTRACT;
206:
207: PROCEDURE UPDATE_RO_CONTRACT(p_person_id NUMBER

Line 219: hr_utility.set_location('Entering : '||l_proc,5);

215: l_proc varchar2(60);
216:
217: BEGIN
218: l_proc:= g_package||'UPDATE_RO_CONTRACT';
219: hr_utility.set_location('Entering : '||l_proc,5);
220: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
221: hr_utility.set_location('Leaving : '||l_proc,10);
222: return;
223: END IF;

Line 220: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

216:
217: BEGIN
218: l_proc:= g_package||'UPDATE_RO_CONTRACT';
219: hr_utility.set_location('Entering : '||l_proc,5);
220: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
221: hr_utility.set_location('Leaving : '||l_proc,10);
222: return;
223: END IF;
224:

Line 221: hr_utility.set_location('Leaving : '||l_proc,10);

217: BEGIN
218: l_proc:= g_package||'UPDATE_RO_CONTRACT';
219: hr_utility.set_location('Entering : '||l_proc,5);
220: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
221: hr_utility.set_location('Leaving : '||l_proc,10);
222: return;
223: END IF;
224:
225: CHECK_RO_CONTRACT(p_person_id => p_person_id

Line 231: hr_utility.set_location('Leaving : '||l_proc,20);

227: ,p_status => p_status
228: ,p_ctr_information1 => p_ctr_information1
229: );
230:
231: hr_utility.set_location('Leaving : '||l_proc,20);
232:
233: END UPDATE_RO_CONTRACT;
234:
235: END HR_RO_CONTRACT_VAL;