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.PAY_SEED_UTL dependencies on HR_UTILITY

Line 3: -- PLOG logging message cover for hr_utility --

1: package body pay_seed_utl AS
2: /* $Header: pyseedutl.pkb 120.1.12020000.2 2012/11/16 10:28:24 asnell ship $ */
3: -- PLOG logging message cover for hr_utility --
4: procedure PLOG ( p_message IN varchar2 ) is
5: -- output a message to the process log file
6: begin
7: IF hr_utility.debug_enabled then

Line 7: IF hr_utility.debug_enabled then

3: -- PLOG logging message cover for hr_utility --
4: procedure PLOG ( p_message IN varchar2 ) is
5: -- output a message to the process log file
6: begin
7: IF hr_utility.debug_enabled then
8: hr_utility.trace('pyseedutl '||p_message);
9: END IF;
10: end plog;
11:

Line 8: hr_utility.trace('pyseedutl '||p_message);

4: procedure PLOG ( p_message IN varchar2 ) is
5: -- output a message to the process log file
6: begin
7: IF hr_utility.debug_enabled then
8: hr_utility.trace('pyseedutl '||p_message);
9: END IF;
10: end plog;
11:
12:

Line 98: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

94: FETCH c_element_name_id INTO l_creator_id;
95: IF c_element_name_id%NOTFOUND THEN --{
96: CLOSE c_element_name_id;
97: plog(' ERROR ELEMENT_NAME:'||p_creator_name1||' not found ');
98: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
99: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
100: hr_utility.set_message_token('STEP','FindElementName');
101: hr_utility.raise_error;
102: END IF; --}

Line 99: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');

95: IF c_element_name_id%NOTFOUND THEN --{
96: CLOSE c_element_name_id;
97: plog(' ERROR ELEMENT_NAME:'||p_creator_name1||' not found ');
98: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
99: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
100: hr_utility.set_message_token('STEP','FindElementName');
101: hr_utility.raise_error;
102: END IF; --}
103: CLOSE c_element_name_id;

Line 100: hr_utility.set_message_token('STEP','FindElementName');

96: CLOSE c_element_name_id;
97: plog(' ERROR ELEMENT_NAME:'||p_creator_name1||' not found ');
98: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
99: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
100: hr_utility.set_message_token('STEP','FindElementName');
101: hr_utility.raise_error;
102: END IF; --}
103: CLOSE c_element_name_id;
104: END IF; --}

Line 101: hr_utility.raise_error;

97: plog(' ERROR ELEMENT_NAME:'||p_creator_name1||' not found ');
98: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
99: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
100: hr_utility.set_message_token('STEP','FindElementName');
101: hr_utility.raise_error;
102: END IF; --}
103: CLOSE c_element_name_id;
104: END IF; --}
105:

Line 112: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

108: FETCH c_input_name_id INTO l_creator_id;
109: IF c_input_name_id%NOTFOUND THEN --{
110: CLOSE c_input_name_id;
111: plog(' ERROR Element Input:'||p_creator_name1||'.'||p_creator_name2||' not found ');
112: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
113: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
114: hr_utility.set_message_token('STEP','FindElementInput');
115: hr_utility.raise_error;
116: END IF; --}

Line 113: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');

109: IF c_input_name_id%NOTFOUND THEN --{
110: CLOSE c_input_name_id;
111: plog(' ERROR Element Input:'||p_creator_name1||'.'||p_creator_name2||' not found ');
112: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
113: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
114: hr_utility.set_message_token('STEP','FindElementInput');
115: hr_utility.raise_error;
116: END IF; --}
117: CLOSE c_input_name_id;

Line 114: hr_utility.set_message_token('STEP','FindElementInput');

110: CLOSE c_input_name_id;
111: plog(' ERROR Element Input:'||p_creator_name1||'.'||p_creator_name2||' not found ');
112: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
113: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
114: hr_utility.set_message_token('STEP','FindElementInput');
115: hr_utility.raise_error;
116: END IF; --}
117: CLOSE c_input_name_id;
118: END IF; --}

Line 115: hr_utility.raise_error;

111: plog(' ERROR Element Input:'||p_creator_name1||'.'||p_creator_name2||' not found ');
112: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
113: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
114: hr_utility.set_message_token('STEP','FindElementInput');
115: hr_utility.raise_error;
116: END IF; --}
117: CLOSE c_input_name_id;
118: END IF; --}
119:

Line 126: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

122: FETCH c_defined_balance_id INTO l_creator_id;
123: IF c_defined_balance_id%NOTFOUND THEN --{
124: CLOSE c_defined_balance_id;
125: plog(' ERROR Balance Dimension :'||p_creator_name1||'.'||p_creator_name2||' not found ');
126: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
128: hr_utility.set_message_token('STEP','FindDefinedBalance');
129: hr_utility.raise_error;
130: END IF; --}

Line 127: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');

123: IF c_defined_balance_id%NOTFOUND THEN --{
124: CLOSE c_defined_balance_id;
125: plog(' ERROR Balance Dimension :'||p_creator_name1||'.'||p_creator_name2||' not found ');
126: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
128: hr_utility.set_message_token('STEP','FindDefinedBalance');
129: hr_utility.raise_error;
130: END IF; --}
131: CLOSE c_defined_balance_id;

Line 128: hr_utility.set_message_token('STEP','FindDefinedBalance');

124: CLOSE c_defined_balance_id;
125: plog(' ERROR Balance Dimension :'||p_creator_name1||'.'||p_creator_name2||' not found ');
126: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
128: hr_utility.set_message_token('STEP','FindDefinedBalance');
129: hr_utility.raise_error;
130: END IF; --}
131: CLOSE c_defined_balance_id;
132: END IF; --}

Line 129: hr_utility.raise_error;

125: plog(' ERROR Balance Dimension :'||p_creator_name1||'.'||p_creator_name2||' not found ');
126: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
127: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
128: hr_utility.set_message_token('STEP','FindDefinedBalance');
129: hr_utility.raise_error;
130: END IF; --}
131: CLOSE c_defined_balance_id;
132: END IF; --}
133:

Line 140: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

136: FETCH c_defined_balance_id INTO l_creator_id;
137: IF c_defined_balance_id%NOTFOUND THEN --{
138: CLOSE c_defined_balance_id;
139: plog(' ERROR Balance Dimension :'||p_creator_name1||'.'||p_creator_name2||' not found ');
140: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
141: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
142: hr_utility.set_message_token('STEP','FindBalanceDimension');
143: hr_utility.raise_error;
144: END IF; --}

Line 141: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');

137: IF c_defined_balance_id%NOTFOUND THEN --{
138: CLOSE c_defined_balance_id;
139: plog(' ERROR Balance Dimension :'||p_creator_name1||'.'||p_creator_name2||' not found ');
140: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
141: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
142: hr_utility.set_message_token('STEP','FindBalanceDimension');
143: hr_utility.raise_error;
144: END IF; --}
145: CLOSE c_defined_balance_id;

Line 142: hr_utility.set_message_token('STEP','FindBalanceDimension');

138: CLOSE c_defined_balance_id;
139: plog(' ERROR Balance Dimension :'||p_creator_name1||'.'||p_creator_name2||' not found ');
140: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
141: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
142: hr_utility.set_message_token('STEP','FindBalanceDimension');
143: hr_utility.raise_error;
144: END IF; --}
145: CLOSE c_defined_balance_id;
146: END IF; --}

Line 143: hr_utility.raise_error;

139: plog(' ERROR Balance Dimension :'||p_creator_name1||'.'||p_creator_name2||' not found ');
140: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
141: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
142: hr_utility.set_message_token('STEP','FindBalanceDimension');
143: hr_utility.raise_error;
144: END IF; --}
145: CLOSE c_defined_balance_id;
146: END IF; --}
147:

Line 154: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

150: FETCH c_absence_type_id INTO l_creator_id;
151: IF c_absence_type_id%NOTFOUND THEN --{
152: CLOSE c_absence_type_id;
153: plog(' ERROR Absence Type:'||p_creator_name1||' not found ');
154: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
155: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
156: hr_utility.set_message_token('STEP','FindAbsenceType');
157: hr_utility.raise_error;
158: END IF; --}

Line 155: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');

151: IF c_absence_type_id%NOTFOUND THEN --{
152: CLOSE c_absence_type_id;
153: plog(' ERROR Absence Type:'||p_creator_name1||' not found ');
154: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
155: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
156: hr_utility.set_message_token('STEP','FindAbsenceType');
157: hr_utility.raise_error;
158: END IF; --}
159: CLOSE c_absence_type_id;

Line 156: hr_utility.set_message_token('STEP','FindAbsenceType');

152: CLOSE c_absence_type_id;
153: plog(' ERROR Absence Type:'||p_creator_name1||' not found ');
154: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
155: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
156: hr_utility.set_message_token('STEP','FindAbsenceType');
157: hr_utility.raise_error;
158: END IF; --}
159: CLOSE c_absence_type_id;
160: END IF; --}

Line 157: hr_utility.raise_error;

153: plog(' ERROR Absence Type:'||p_creator_name1||' not found ');
154: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
155: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
156: hr_utility.set_message_token('STEP','FindAbsenceType');
157: hr_utility.raise_error;
158: END IF; --}
159: CLOSE c_absence_type_id;
160: END IF; --}
161:

Line 168: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

164: FETCH c_grade_name_id INTO l_creator_id;
165: IF c_grade_name_id%NOTFOUND THEN --{
166: CLOSE c_grade_name_id;
167: plog(' ERROR Grade:'||p_creator_name1||' not found ');
168: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
170: hr_utility.set_message_token('STEP','FindGrade ');
171: hr_utility.raise_error;
172: END IF; --}

Line 169: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');

165: IF c_grade_name_id%NOTFOUND THEN --{
166: CLOSE c_grade_name_id;
167: plog(' ERROR Grade:'||p_creator_name1||' not found ');
168: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
170: hr_utility.set_message_token('STEP','FindGrade ');
171: hr_utility.raise_error;
172: END IF; --}
173: CLOSE c_grade_name_id;

Line 170: hr_utility.set_message_token('STEP','FindGrade ');

166: CLOSE c_grade_name_id;
167: plog(' ERROR Grade:'||p_creator_name1||' not found ');
168: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
170: hr_utility.set_message_token('STEP','FindGrade ');
171: hr_utility.raise_error;
172: END IF; --}
173: CLOSE c_grade_name_id;
174: END IF; --}

Line 171: hr_utility.raise_error;

167: plog(' ERROR Grade:'||p_creator_name1||' not found ');
168: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
169: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
170: hr_utility.set_message_token('STEP','FindGrade ');
171: hr_utility.raise_error;
172: END IF; --}
173: CLOSE c_grade_name_id;
174: END IF; --}
175:

Line 182: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

178: FETCH c_global_name_id INTO l_creator_id;
179: IF c_global_name_id%NOTFOUND THEN --{
180: CLOSE c_global_name_id;
181: plog(' ERROR Global Name:'||p_creator_name1||' not found ');
182: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
184: hr_utility.set_message_token('STEP','FindFFGlobal');
185: hr_utility.raise_error;
186: END IF; --}

Line 183: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');

179: IF c_global_name_id%NOTFOUND THEN --{
180: CLOSE c_global_name_id;
181: plog(' ERROR Global Name:'||p_creator_name1||' not found ');
182: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
184: hr_utility.set_message_token('STEP','FindFFGlobal');
185: hr_utility.raise_error;
186: END IF; --}
187: CLOSE c_global_name_id;

Line 184: hr_utility.set_message_token('STEP','FindFFGlobal');

180: CLOSE c_global_name_id;
181: plog(' ERROR Global Name:'||p_creator_name1||' not found ');
182: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
184: hr_utility.set_message_token('STEP','FindFFGlobal');
185: hr_utility.raise_error;
186: END IF; --}
187: CLOSE c_global_name_id;
188: END IF; --}

Line 185: hr_utility.raise_error;

181: plog(' ERROR Global Name:'||p_creator_name1||' not found ');
182: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','USER_ENTITY_CREATOR_ID');
184: hr_utility.set_message_token('STEP','FindFFGlobal');
185: hr_utility.raise_error;
186: END IF; --}
187: CLOSE c_global_name_id;
188: END IF; --}
189:

Line 330: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

326: FETCH c_element_name_id INTO l_parameter_value;
327: IF c_element_name_id%NOTFOUND THEN --{
328: CLOSE c_element_name_id;
329: plog(' ERROR ELEMENT_NAME:'||p_value_name1||' not found ');
330: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
331: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
332: hr_utility.set_message_token('STEP','FindElementName');
333: hr_utility.raise_error;
334: END IF; --}

Line 331: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');

327: IF c_element_name_id%NOTFOUND THEN --{
328: CLOSE c_element_name_id;
329: plog(' ERROR ELEMENT_NAME:'||p_value_name1||' not found ');
330: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
331: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
332: hr_utility.set_message_token('STEP','FindElementName');
333: hr_utility.raise_error;
334: END IF; --}
335: CLOSE c_element_name_id;

Line 332: hr_utility.set_message_token('STEP','FindElementName');

328: CLOSE c_element_name_id;
329: plog(' ERROR ELEMENT_NAME:'||p_value_name1||' not found ');
330: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
331: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
332: hr_utility.set_message_token('STEP','FindElementName');
333: hr_utility.raise_error;
334: END IF; --}
335: CLOSE c_element_name_id;
336: END IF; --}

Line 333: hr_utility.raise_error;

329: plog(' ERROR ELEMENT_NAME:'||p_value_name1||' not found ');
330: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
331: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
332: hr_utility.set_message_token('STEP','FindElementName');
333: hr_utility.raise_error;
334: END IF; --}
335: CLOSE c_element_name_id;
336: END IF; --}
337:

Line 344: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

340: FETCH c_input_name_id INTO l_parameter_value;
341: IF c_input_name_id%NOTFOUND THEN --{
342: CLOSE c_input_name_id;
343: plog(' ERROR Element Input:'||p_value_name1||'.'||p_value_name2||' not found ');
344: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
345: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
346: hr_utility.set_message_token('STEP','FindElementInput');
347: hr_utility.raise_error;
348: END IF; --}

Line 345: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');

341: IF c_input_name_id%NOTFOUND THEN --{
342: CLOSE c_input_name_id;
343: plog(' ERROR Element Input:'||p_value_name1||'.'||p_value_name2||' not found ');
344: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
345: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
346: hr_utility.set_message_token('STEP','FindElementInput');
347: hr_utility.raise_error;
348: END IF; --}
349: CLOSE c_input_name_id;

Line 346: hr_utility.set_message_token('STEP','FindElementInput');

342: CLOSE c_input_name_id;
343: plog(' ERROR Element Input:'||p_value_name1||'.'||p_value_name2||' not found ');
344: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
345: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
346: hr_utility.set_message_token('STEP','FindElementInput');
347: hr_utility.raise_error;
348: END IF; --}
349: CLOSE c_input_name_id;
350: END IF; --}

Line 347: hr_utility.raise_error;

343: plog(' ERROR Element Input:'||p_value_name1||'.'||p_value_name2||' not found ');
344: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
345: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
346: hr_utility.set_message_token('STEP','FindElementInput');
347: hr_utility.raise_error;
348: END IF; --}
349: CLOSE c_input_name_id;
350: END IF; --}
351:

Line 358: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

354: FETCH c_defined_balance_id INTO l_parameter_value;
355: IF c_defined_balance_id%NOTFOUND THEN --{
356: CLOSE c_defined_balance_id;
357: plog(' ERROR Balance Dimension :'||p_value_name1||'.'||p_value_name2||' not found ');
358: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
359: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
360: hr_utility.set_message_token('STEP','FindDefinedBalance');
361: hr_utility.raise_error;
362: END IF; --}

Line 359: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');

355: IF c_defined_balance_id%NOTFOUND THEN --{
356: CLOSE c_defined_balance_id;
357: plog(' ERROR Balance Dimension :'||p_value_name1||'.'||p_value_name2||' not found ');
358: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
359: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
360: hr_utility.set_message_token('STEP','FindDefinedBalance');
361: hr_utility.raise_error;
362: END IF; --}
363: CLOSE c_defined_balance_id;

Line 360: hr_utility.set_message_token('STEP','FindDefinedBalance');

356: CLOSE c_defined_balance_id;
357: plog(' ERROR Balance Dimension :'||p_value_name1||'.'||p_value_name2||' not found ');
358: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
359: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
360: hr_utility.set_message_token('STEP','FindDefinedBalance');
361: hr_utility.raise_error;
362: END IF; --}
363: CLOSE c_defined_balance_id;
364: END IF; --}

Line 361: hr_utility.raise_error;

357: plog(' ERROR Balance Dimension :'||p_value_name1||'.'||p_value_name2||' not found ');
358: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
359: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
360: hr_utility.set_message_token('STEP','FindDefinedBalance');
361: hr_utility.raise_error;
362: END IF; --}
363: CLOSE c_defined_balance_id;
364: END IF; --}
365:

Line 372: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

368: FETCH c_absence_type_id INTO l_parameter_value;
369: IF c_absence_type_id%NOTFOUND THEN --{
370: CLOSE c_absence_type_id;
371: plog(' ERROR Absence Type:'||p_value_name1||' not found ');
372: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
374: hr_utility.set_message_token('STEP','FindAbsenceType');
375: hr_utility.raise_error;
376: END IF; --}

Line 373: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');

369: IF c_absence_type_id%NOTFOUND THEN --{
370: CLOSE c_absence_type_id;
371: plog(' ERROR Absence Type:'||p_value_name1||' not found ');
372: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
374: hr_utility.set_message_token('STEP','FindAbsenceType');
375: hr_utility.raise_error;
376: END IF; --}
377: CLOSE c_absence_type_id;

Line 374: hr_utility.set_message_token('STEP','FindAbsenceType');

370: CLOSE c_absence_type_id;
371: plog(' ERROR Absence Type:'||p_value_name1||' not found ');
372: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
374: hr_utility.set_message_token('STEP','FindAbsenceType');
375: hr_utility.raise_error;
376: END IF; --}
377: CLOSE c_absence_type_id;
378: END IF; --}

Line 375: hr_utility.raise_error;

371: plog(' ERROR Absence Type:'||p_value_name1||' not found ');
372: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
374: hr_utility.set_message_token('STEP','FindAbsenceType');
375: hr_utility.raise_error;
376: END IF; --}
377: CLOSE c_absence_type_id;
378: END IF; --}
379:

Line 386: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

382: FETCH c_grade_name_id INTO l_parameter_value;
383: IF c_grade_name_id%NOTFOUND THEN --{
384: CLOSE c_grade_name_id;
385: plog(' ERROR Grade:'||p_value_name1||' not found ');
386: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
387: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
388: hr_utility.set_message_token('STEP','FindGrade ');
389: hr_utility.raise_error;
390: END IF; --}

Line 387: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');

383: IF c_grade_name_id%NOTFOUND THEN --{
384: CLOSE c_grade_name_id;
385: plog(' ERROR Grade:'||p_value_name1||' not found ');
386: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
387: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
388: hr_utility.set_message_token('STEP','FindGrade ');
389: hr_utility.raise_error;
390: END IF; --}
391: CLOSE c_grade_name_id;

Line 388: hr_utility.set_message_token('STEP','FindGrade ');

384: CLOSE c_grade_name_id;
385: plog(' ERROR Grade:'||p_value_name1||' not found ');
386: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
387: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
388: hr_utility.set_message_token('STEP','FindGrade ');
389: hr_utility.raise_error;
390: END IF; --}
391: CLOSE c_grade_name_id;
392: END IF; --}

Line 389: hr_utility.raise_error;

385: plog(' ERROR Grade:'||p_value_name1||' not found ');
386: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
387: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
388: hr_utility.set_message_token('STEP','FindGrade ');
389: hr_utility.raise_error;
390: END IF; --}
391: CLOSE c_grade_name_id;
392: END IF; --}
393:

Line 400: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

396: FETCH c_dimension_name_id INTO l_parameter_value;
397: IF c_dimension_name_id%NOTFOUND THEN --{
398: CLOSE c_dimension_name_id;
399: plog(' ERROR dimension:'||p_value_name1||' not found ');
400: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
401: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
402: hr_utility.set_message_token('STEP','FindDimension ');
403: hr_utility.raise_error;
404: END IF; --}

Line 401: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');

397: IF c_dimension_name_id%NOTFOUND THEN --{
398: CLOSE c_dimension_name_id;
399: plog(' ERROR dimension:'||p_value_name1||' not found ');
400: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
401: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
402: hr_utility.set_message_token('STEP','FindDimension ');
403: hr_utility.raise_error;
404: END IF; --}
405: CLOSE c_dimension_name_id;

Line 402: hr_utility.set_message_token('STEP','FindDimension ');

398: CLOSE c_dimension_name_id;
399: plog(' ERROR dimension:'||p_value_name1||' not found ');
400: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
401: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
402: hr_utility.set_message_token('STEP','FindDimension ');
403: hr_utility.raise_error;
404: END IF; --}
405: CLOSE c_dimension_name_id;
406: END IF; --}

Line 403: hr_utility.raise_error;

399: plog(' ERROR dimension:'||p_value_name1||' not found ');
400: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
401: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
402: hr_utility.set_message_token('STEP','FindDimension ');
403: hr_utility.raise_error;
404: END IF; --}
405: CLOSE c_dimension_name_id;
406: END IF; --}
407:

Line 414: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

410: FETCH c_balance_name_id INTO l_parameter_value;
411: IF c_balance_name_id%NOTFOUND THEN --{
412: CLOSE c_balance_name_id;
413: plog(' ERROR balance:'||p_value_name1||' not found ');
414: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
415: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
416: hr_utility.set_message_token('STEP','FindBalance ');
417: hr_utility.raise_error;
418: END IF; --}

Line 415: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');

411: IF c_balance_name_id%NOTFOUND THEN --{
412: CLOSE c_balance_name_id;
413: plog(' ERROR balance:'||p_value_name1||' not found ');
414: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
415: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
416: hr_utility.set_message_token('STEP','FindBalance ');
417: hr_utility.raise_error;
418: END IF; --}
419: CLOSE c_balance_name_id;

Line 416: hr_utility.set_message_token('STEP','FindBalance ');

412: CLOSE c_balance_name_id;
413: plog(' ERROR balance:'||p_value_name1||' not found ');
414: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
415: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
416: hr_utility.set_message_token('STEP','FindBalance ');
417: hr_utility.raise_error;
418: END IF; --}
419: CLOSE c_balance_name_id;
420: END IF; --}

Line 417: hr_utility.raise_error;

413: plog(' ERROR balance:'||p_value_name1||' not found ');
414: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
415: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
416: hr_utility.set_message_token('STEP','FindBalance ');
417: hr_utility.raise_error;
418: END IF; --}
419: CLOSE c_balance_name_id;
420: END IF; --}
421:

Line 428: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

424: FETCH c_payment_name_id INTO l_parameter_value;
425: IF c_payment_name_id%NOTFOUND THEN --{
426: CLOSE c_payment_name_id;
427: plog(' ERROR payment type:'||p_value_name1||' not found ');
428: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
429: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
430: hr_utility.set_message_token('STEP','FindPaymentType ');
431: hr_utility.raise_error;
432: END IF; --}

Line 429: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');

425: IF c_payment_name_id%NOTFOUND THEN --{
426: CLOSE c_payment_name_id;
427: plog(' ERROR payment type:'||p_value_name1||' not found ');
428: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
429: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
430: hr_utility.set_message_token('STEP','FindPaymentType ');
431: hr_utility.raise_error;
432: END IF; --}
433: CLOSE c_payment_name_id;

Line 430: hr_utility.set_message_token('STEP','FindPaymentType ');

426: CLOSE c_payment_name_id;
427: plog(' ERROR payment type:'||p_value_name1||' not found ');
428: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
429: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
430: hr_utility.set_message_token('STEP','FindPaymentType ');
431: hr_utility.raise_error;
432: END IF; --}
433: CLOSE c_payment_name_id;
434: END IF; --}

Line 431: hr_utility.raise_error;

427: plog(' ERROR payment type:'||p_value_name1||' not found ');
428: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
429: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
430: hr_utility.set_message_token('STEP','FindPaymentType ');
431: hr_utility.raise_error;
432: END IF; --}
433: CLOSE c_payment_name_id;
434: END IF; --}
435:

Line 442: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

438: FETCH c_user_entity_name_id INTO l_parameter_value;
439: IF c_user_entity_name_id%NOTFOUND THEN --{
440: CLOSE c_user_entity_name_id;
441: plog(' ERROR user_entity:'||p_value_name1||' not found ');
442: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
443: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
444: hr_utility.set_message_token('STEP','FindUserEntity ');
445: hr_utility.raise_error;
446: END IF; --}

Line 443: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');

439: IF c_user_entity_name_id%NOTFOUND THEN --{
440: CLOSE c_user_entity_name_id;
441: plog(' ERROR user_entity:'||p_value_name1||' not found ');
442: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
443: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
444: hr_utility.set_message_token('STEP','FindUserEntity ');
445: hr_utility.raise_error;
446: END IF; --}
447: CLOSE c_user_entity_name_id;

Line 444: hr_utility.set_message_token('STEP','FindUserEntity ');

440: CLOSE c_user_entity_name_id;
441: plog(' ERROR user_entity:'||p_value_name1||' not found ');
442: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
443: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
444: hr_utility.set_message_token('STEP','FindUserEntity ');
445: hr_utility.raise_error;
446: END IF; --}
447: CLOSE c_user_entity_name_id;
448: END IF; --}

Line 445: hr_utility.raise_error;

441: plog(' ERROR user_entity:'||p_value_name1||' not found ');
442: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
443: hr_utility.set_message_token('PROCEDURE','PARAMETER_VALUE');
444: hr_utility.set_message_token('STEP','FindUserEntity ');
445: hr_utility.raise_error;
446: END IF; --}
447: CLOSE c_user_entity_name_id;
448: END IF; --}
449:

Line 475: hr_utility.trace('PAY_SEED_UTILS.ID_TO_NAME. p_balance_type_id:'||p_balance_type_id||' not found');

471: OPEN csr_balance_name(p_balance_type_id);
472: FETCH csr_balance_name INTO l_return;
473: IF csr_balance_name%NOTFOUND THEN
474: l_return := NULL;
475: hr_utility.trace('PAY_SEED_UTILS.ID_TO_NAME. p_balance_type_id:'||p_balance_type_id||' not found');
476: END IF;
477: close csr_balance_name;
478: return l_return;
479: end lookup_balance_name;

Line 497: hr_utility.trace('PAY_SEED_UTILS.NAME_TO_ID. p_balance_name:'||p_balance_name||' not found');

493: OPEN csr_balance_id(p_balance_name, p_legislation_code);
494: FETCH csr_balance_id INTO l_return;
495: IF csr_balance_id%NOTFOUND THEN
496: l_return := 'BalNotFound';
497: hr_utility.trace('PAY_SEED_UTILS.NAME_TO_ID. p_balance_name:'||p_balance_name||' not found');
498: IF nvl(p_ignore_missing_balance,'N') <> 'Y' then
499: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
500: hr_utility.set_message_token('PROCEDURE','BALANCE_NAME');
501: hr_utility.set_message_token('STEP','Find balance:'||p_balance_name);

Line 499: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

495: IF csr_balance_id%NOTFOUND THEN
496: l_return := 'BalNotFound';
497: hr_utility.trace('PAY_SEED_UTILS.NAME_TO_ID. p_balance_name:'||p_balance_name||' not found');
498: IF nvl(p_ignore_missing_balance,'N') <> 'Y' then
499: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
500: hr_utility.set_message_token('PROCEDURE','BALANCE_NAME');
501: hr_utility.set_message_token('STEP','Find balance:'||p_balance_name);
502: hr_utility.raise_error;
503: END IF;

Line 500: hr_utility.set_message_token('PROCEDURE','BALANCE_NAME');

496: l_return := 'BalNotFound';
497: hr_utility.trace('PAY_SEED_UTILS.NAME_TO_ID. p_balance_name:'||p_balance_name||' not found');
498: IF nvl(p_ignore_missing_balance,'N') <> 'Y' then
499: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
500: hr_utility.set_message_token('PROCEDURE','BALANCE_NAME');
501: hr_utility.set_message_token('STEP','Find balance:'||p_balance_name);
502: hr_utility.raise_error;
503: END IF;
504: END IF;

Line 501: hr_utility.set_message_token('STEP','Find balance:'||p_balance_name);

497: hr_utility.trace('PAY_SEED_UTILS.NAME_TO_ID. p_balance_name:'||p_balance_name||' not found');
498: IF nvl(p_ignore_missing_balance,'N') <> 'Y' then
499: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
500: hr_utility.set_message_token('PROCEDURE','BALANCE_NAME');
501: hr_utility.set_message_token('STEP','Find balance:'||p_balance_name);
502: hr_utility.raise_error;
503: END IF;
504: END IF;
505: close csr_balance_id;

Line 502: hr_utility.raise_error;

498: IF nvl(p_ignore_missing_balance,'N') <> 'Y' then
499: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
500: hr_utility.set_message_token('PROCEDURE','BALANCE_NAME');
501: hr_utility.set_message_token('STEP','Find balance:'||p_balance_name);
502: hr_utility.raise_error;
503: END IF;
504: END IF;
505: close csr_balance_id;
506: return l_return;