DBA Data[Home] [Help]

APPS.PAY_FR_RULES dependencies on HR_UTILITY

Line 24: 12-JAN-2004 aparkes 115.10 Use hr_utility.raise_error in above proc

20: 08-JAN-2004 aparkes 115.9 Added get_source_text2_context (for bug
21: 3360253), get_source_number_context and
22: raise_null_context_input following bug
23: 3305989.
24: 12-JAN-2004 aparkes 115.10 Use hr_utility.raise_error in above proc
25: 115.11 Corrected trace in get_source_number_context
26: */
27: --
28: --

Line 76: hr_utility.trace('error PAY_75084_NULL_CONTEXT_INPUT raised. Direct Ele:'

72: close csr_get_element_info;
73: open csr_get_input_name;
74: fetch csr_get_input_name into l_input_name;
75: close csr_get_input_name;
76: hr_utility.trace('error PAY_75084_NULL_CONTEXT_INPUT raised. Direct Ele:'
77: ||l_element_name||' Input:'||l_input_name);
78: hr_utility.set_message(801,'PAY_75084_NULL_CONTEXT_INPUT');
79: hr_utility.set_message_token('INPUT_NAME',l_input_name);
80: hr_utility.set_message_token('ELEMENT',l_element_name);

Line 78: hr_utility.set_message(801,'PAY_75084_NULL_CONTEXT_INPUT');

74: fetch csr_get_input_name into l_input_name;
75: close csr_get_input_name;
76: hr_utility.trace('error PAY_75084_NULL_CONTEXT_INPUT raised. Direct Ele:'
77: ||l_element_name||' Input:'||l_input_name);
78: hr_utility.set_message(801,'PAY_75084_NULL_CONTEXT_INPUT');
79: hr_utility.set_message_token('INPUT_NAME',l_input_name);
80: hr_utility.set_message_token('ELEMENT',l_element_name);
81: hr_utility.raise_error;
82: end raise_null_context_input;

Line 79: hr_utility.set_message_token('INPUT_NAME',l_input_name);

75: close csr_get_input_name;
76: hr_utility.trace('error PAY_75084_NULL_CONTEXT_INPUT raised. Direct Ele:'
77: ||l_element_name||' Input:'||l_input_name);
78: hr_utility.set_message(801,'PAY_75084_NULL_CONTEXT_INPUT');
79: hr_utility.set_message_token('INPUT_NAME',l_input_name);
80: hr_utility.set_message_token('ELEMENT',l_element_name);
81: hr_utility.raise_error;
82: end raise_null_context_input;
83:

Line 80: hr_utility.set_message_token('ELEMENT',l_element_name);

76: hr_utility.trace('error PAY_75084_NULL_CONTEXT_INPUT raised. Direct Ele:'
77: ||l_element_name||' Input:'||l_input_name);
78: hr_utility.set_message(801,'PAY_75084_NULL_CONTEXT_INPUT');
79: hr_utility.set_message_token('INPUT_NAME',l_input_name);
80: hr_utility.set_message_token('ELEMENT',l_element_name);
81: hr_utility.raise_error;
82: end raise_null_context_input;
83:
84: procedure get_source_text_context(p_asg_act_id number,

Line 81: hr_utility.raise_error;

77: ||l_element_name||' Input:'||l_input_name);
78: hr_utility.set_message(801,'PAY_75084_NULL_CONTEXT_INPUT');
79: hr_utility.set_message_token('INPUT_NAME',l_input_name);
80: hr_utility.set_message_token('ELEMENT',l_element_name);
81: hr_utility.raise_error;
82: end raise_null_context_input;
83:
84: procedure get_source_text_context(p_asg_act_id number,
85: p_ee_id number,

Line 126: hr_utility.set_location('PAY_FR_RULES.get_source_text_context',1);

122: and pa.date_earned between
123: eev.effective_start_date and eev.effective_end_date;
124:
125: begin
126: hr_utility.set_location('PAY_FR_RULES.get_source_text_context',1);
127:
128: if pay_fr_general.g_process_type is not null
129: then p_source_text := pay_fr_general.g_process_type;
130: hr_utility.set_location('PAY_FR_RULES.get_source_text_context',2);

Line 130: hr_utility.set_location('PAY_FR_RULES.get_source_text_context',2);

126: hr_utility.set_location('PAY_FR_RULES.get_source_text_context',1);
127:
128: if pay_fr_general.g_process_type is not null
129: then p_source_text := pay_fr_general.g_process_type;
130: hr_utility.set_location('PAY_FR_RULES.get_source_text_context',2);
131:
132: else
133: hr_utility.set_location('PAY_FR_RULES.get_source_text_context',3);
134: open csr_process_type_entry_value;

Line 133: hr_utility.set_location('PAY_FR_RULES.get_source_text_context',3);

129: then p_source_text := pay_fr_general.g_process_type;
130: hr_utility.set_location('PAY_FR_RULES.get_source_text_context',2);
131:
132: else
133: hr_utility.set_location('PAY_FR_RULES.get_source_text_context',3);
134: open csr_process_type_entry_value;
135: fetch csr_process_type_entry_value into p_source_text;
136: close csr_process_type_entry_value;
137:

Line 139: hr_utility.set_location('PAY_FR_RULES.get_source_text_context='||

135: fetch csr_process_type_entry_value into p_source_text;
136: close csr_process_type_entry_value;
137:
138: end if;
139: hr_utility.set_location('PAY_FR_RULES.get_source_text_context='||
140: p_source_text,4);
141:
142: end get_source_text_context;
143:

Line 150: hr_utility.set_location('Entered get_source_text2_context. p_asg_act_id('

146: p_source_text2 in out nocopy varchar2) is
147: begin
148: -- contribution_code should never be null so error if this
149: -- defaulting procedure if invoked
150: hr_utility.set_location('Entered get_source_text2_context. p_asg_act_id('
151: ||to_char(p_asg_act_id)||') p_ee_id('
152: ||to_char(p_ee_id)||')',5);
153: raise_null_context_input(p_ee_id,'SOURCE_TEXT2');
154: hr_utility.set_location('Leaving get_source_text2_context.',10);

Line 154: hr_utility.set_location('Leaving get_source_text2_context.',10);

150: hr_utility.set_location('Entered get_source_text2_context. p_asg_act_id('
151: ||to_char(p_asg_act_id)||') p_ee_id('
152: ||to_char(p_ee_id)||')',5);
153: raise_null_context_input(p_ee_id,'SOURCE_TEXT2');
154: hr_utility.set_location('Leaving get_source_text2_context.',10);
155: end get_source_text2_context;
156:
157: procedure get_source_context(p_asg_act_id number,
158: p_ee_id number,

Line 164: hr_utility.set_location('Entered get_source_context. p_asg_act_id('||

160: begin
161: -- contribution_usage_id should never be null so error if this
162: -- defaulting procedure is invoked
163:
164: hr_utility.set_location('Entered get_source_context. p_asg_act_id('||
165: to_char(p_asg_act_id)||') p_ee_id('||
166: to_char(p_ee_id)||')',5);
167: p_source_id := '-99';
168: raise_null_context_input(p_ee_id,'SOURCE_ID');

Line 169: hr_utility.set_location('Leaving get_source_context.',10);

165: to_char(p_asg_act_id)||') p_ee_id('||
166: to_char(p_ee_id)||')',5);
167: p_source_id := '-99';
168: raise_null_context_input(p_ee_id,'SOURCE_ID');
169: hr_utility.set_location('Leaving get_source_context.',10);
170:
171: end get_source_context;
172:
173: procedure get_source_number_context(p_asg_act_id number,

Line 180: hr_utility.set_location('Entered get_source_number_context. p_asg_act_id('

176: is
177: begin
178: -- Rate should never be null so error if this
179: -- defaulting procedure if invoked
180: hr_utility.set_location('Entered get_source_number_context. p_asg_act_id('
181: ||to_char(p_asg_act_id)||') p_ee_id('
182: ||to_char(p_ee_id)||')',5);
183: raise_null_context_input(p_ee_id,'SOURCE_NUMBER');
184: hr_utility.set_location('Leaving get_source_number_context.',10);

Line 184: hr_utility.set_location('Leaving get_source_number_context.',10);

180: hr_utility.set_location('Entered get_source_number_context. p_asg_act_id('
181: ||to_char(p_asg_act_id)||') p_ee_id('
182: ||to_char(p_ee_id)||')',5);
183: raise_null_context_input(p_ee_id,'SOURCE_NUMBER');
184: hr_utility.set_location('Leaving get_source_number_context.',10);
185: end get_source_number_context;
186:
187: PROCEDURE get_dynamic_org_meth
188: (p_assignment_action_id in number

Line 337: hr_utility.set_message(801, 'PAY_75034_NO_SPEC_OPM');

333: p_org_method_id :=
334: g_org_meth_map_tbl(l_map_tbl_ind).new_org_paymeth_id;
335: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75034_NO_SPEC_OPM'
336: THEN
337: hr_utility.set_message(801, 'PAY_75034_NO_SPEC_OPM');
338: hr_utility.set_message_token('OPM_NAME',g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
339: hr_utility.set_message_token('ESTAB_NAME',g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
340: hr_utility.raise_error;
341: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75035_OPM_NOT_EFFECTIVE'

Line 338: hr_utility.set_message_token('OPM_NAME',g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);

334: g_org_meth_map_tbl(l_map_tbl_ind).new_org_paymeth_id;
335: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75034_NO_SPEC_OPM'
336: THEN
337: hr_utility.set_message(801, 'PAY_75034_NO_SPEC_OPM');
338: hr_utility.set_message_token('OPM_NAME',g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
339: hr_utility.set_message_token('ESTAB_NAME',g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
340: hr_utility.raise_error;
341: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75035_OPM_NOT_EFFECTIVE'
342: THEN

Line 339: hr_utility.set_message_token('ESTAB_NAME',g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);

335: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75034_NO_SPEC_OPM'
336: THEN
337: hr_utility.set_message(801, 'PAY_75034_NO_SPEC_OPM');
338: hr_utility.set_message_token('OPM_NAME',g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
339: hr_utility.set_message_token('ESTAB_NAME',g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
340: hr_utility.raise_error;
341: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75035_OPM_NOT_EFFECTIVE'
342: THEN
343: hr_utility.set_message(801,'PAY_75035_OPM_NOT_EFFECTIVE');

Line 340: hr_utility.raise_error;

336: THEN
337: hr_utility.set_message(801, 'PAY_75034_NO_SPEC_OPM');
338: hr_utility.set_message_token('OPM_NAME',g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
339: hr_utility.set_message_token('ESTAB_NAME',g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
340: hr_utility.raise_error;
341: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75035_OPM_NOT_EFFECTIVE'
342: THEN
343: hr_utility.set_message(801,'PAY_75035_OPM_NOT_EFFECTIVE');
344: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);

Line 343: hr_utility.set_message(801,'PAY_75035_OPM_NOT_EFFECTIVE');

339: hr_utility.set_message_token('ESTAB_NAME',g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
340: hr_utility.raise_error;
341: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75035_OPM_NOT_EFFECTIVE'
342: THEN
343: hr_utility.set_message(801,'PAY_75035_OPM_NOT_EFFECTIVE');
344: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
345: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);
346: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
347: hr_utility.raise_error;

Line 344: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);

340: hr_utility.raise_error;
341: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75035_OPM_NOT_EFFECTIVE'
342: THEN
343: hr_utility.set_message(801,'PAY_75035_OPM_NOT_EFFECTIVE');
344: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
345: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);
346: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
347: hr_utility.raise_error;
348: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75036_TOO_MANY_GEN_OPMS'

Line 345: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);

341: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75035_OPM_NOT_EFFECTIVE'
342: THEN
343: hr_utility.set_message(801,'PAY_75035_OPM_NOT_EFFECTIVE');
344: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
345: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);
346: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
347: hr_utility.raise_error;
348: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75036_TOO_MANY_GEN_OPMS'
349: THEN

Line 346: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);

342: THEN
343: hr_utility.set_message(801,'PAY_75035_OPM_NOT_EFFECTIVE');
344: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
345: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);
346: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
347: hr_utility.raise_error;
348: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75036_TOO_MANY_GEN_OPMS'
349: THEN
350: hr_utility.set_message(801, 'PAY_75036_TOO_MANY_GEN_OPMS');

Line 347: hr_utility.raise_error;

343: hr_utility.set_message(801,'PAY_75035_OPM_NOT_EFFECTIVE');
344: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
345: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);
346: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
347: hr_utility.raise_error;
348: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75036_TOO_MANY_GEN_OPMS'
349: THEN
350: hr_utility.set_message(801, 'PAY_75036_TOO_MANY_GEN_OPMS');
351: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);

Line 350: hr_utility.set_message(801, 'PAY_75036_TOO_MANY_GEN_OPMS');

346: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
347: hr_utility.raise_error;
348: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75036_TOO_MANY_GEN_OPMS'
349: THEN
350: hr_utility.set_message(801, 'PAY_75036_TOO_MANY_GEN_OPMS');
351: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
352: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);
353: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
354: hr_utility.raise_error;

Line 351: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);

347: hr_utility.raise_error;
348: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75036_TOO_MANY_GEN_OPMS'
349: THEN
350: hr_utility.set_message(801, 'PAY_75036_TOO_MANY_GEN_OPMS');
351: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
352: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);
353: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
354: hr_utility.raise_error;
355: END IF;

Line 352: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);

348: ELSIF g_org_meth_map_tbl(l_map_tbl_ind).err_name = 'PAY_75036_TOO_MANY_GEN_OPMS'
349: THEN
350: hr_utility.set_message(801, 'PAY_75036_TOO_MANY_GEN_OPMS');
351: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
352: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);
353: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
354: hr_utility.raise_error;
355: END IF;
356: END get_dynamic_org_meth;

Line 353: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);

349: THEN
350: hr_utility.set_message(801, 'PAY_75036_TOO_MANY_GEN_OPMS');
351: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
352: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);
353: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
354: hr_utility.raise_error;
355: END IF;
356: END get_dynamic_org_meth;
357:

Line 354: hr_utility.raise_error;

350: hr_utility.set_message(801, 'PAY_75036_TOO_MANY_GEN_OPMS');
351: hr_utility.set_message_token('OPM_NAME', g_org_meth_map_tbl(l_map_tbl_ind).opm_name_token);
352: hr_utility.set_message_token('ORG_CLASS', g_org_meth_map_tbl(l_map_tbl_ind).org_type_token);
353: hr_utility.set_message_token('ORG_NAME', g_org_meth_map_tbl(l_map_tbl_ind).org_name_token);
354: hr_utility.raise_error;
355: END IF;
356: END get_dynamic_org_meth;
357:
358: procedure get_multi_tax_unit_pay_flag(p_bus_grp in number,