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_AU_SUPER_API dependencies on HR_UTILITY

Line 74: hr_utility.set_location(g_package||l_procedure, 1);

70: l_personal_payment_method_id number;
71: l_procedure constant varchar2(60) := 'get_payment_method';
72: --
73: begin
74: hr_utility.set_location(g_package||l_procedure, 1);
75: open csr_get_super_fund
76: (p_assignment_id
77: ,p_super_fund_name
78: ,p_effective_date

Line 85: hr_utility.trace('Invalid super fund: '||p_super_fund_name||' for assignment_id = '||to_char(p_assignment_id));

81: into l_personal_payment_method_id;
82: if csr_get_super_fund%notfound
83: then
84: close csr_get_super_fund;
85: hr_utility.trace('Invalid super fund: '||p_super_fund_name||' for assignment_id = '||to_char(p_assignment_id));
86: hr_utility.set_message(801,'HR_AU_SUPER_FUND_NOT_VALID');
87: hr_utility.raise_error;
88: end if;
89: close csr_get_super_fund;

Line 86: hr_utility.set_message(801,'HR_AU_SUPER_FUND_NOT_VALID');

82: if csr_get_super_fund%notfound
83: then
84: close csr_get_super_fund;
85: hr_utility.trace('Invalid super fund: '||p_super_fund_name||' for assignment_id = '||to_char(p_assignment_id));
86: hr_utility.set_message(801,'HR_AU_SUPER_FUND_NOT_VALID');
87: hr_utility.raise_error;
88: end if;
89: close csr_get_super_fund;
90: return l_personal_payment_method_id;

Line 87: hr_utility.raise_error;

83: then
84: close csr_get_super_fund;
85: hr_utility.trace('Invalid super fund: '||p_super_fund_name||' for assignment_id = '||to_char(p_assignment_id));
86: hr_utility.set_message(801,'HR_AU_SUPER_FUND_NOT_VALID');
87: hr_utility.raise_error;
88: end if;
89: close csr_get_super_fund;
90: return l_personal_payment_method_id;
91: --

Line 92: hr_utility.set_location(g_package||l_procedure, 99);

88: end if;
89: close csr_get_super_fund;
90: return l_personal_payment_method_id;
91: --
92: hr_utility.set_location(g_package||l_procedure, 99);
93: end get_payment_method;
94: --
95: ---------------------------------------------------------------------------------------------
96: -- PRIVATE FUNCTION valid_business_group

Line 113: hr_utility.set_location(g_package||l_procedure, 1);

109: from per_business_groups
110: where business_group_id = p_business_group_id;
111: --
112: begin
113: hr_utility.set_location(g_package||l_procedure, 1);
114: open csr_per_business_groups;
115: fetch csr_per_business_groups
116: into l_legislation_code;
117: if csr_per_business_groups%notfound

Line 120: hr_utility.set_location(g_package||l_procedure, 2);

116: into l_legislation_code;
117: if csr_per_business_groups%notfound
118: then
119: close csr_per_business_groups;
120: hr_utility.set_location(g_package||l_procedure, 2);
121: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
122: return false;
123: end if;
124: close csr_per_business_groups;

Line 121: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));

117: if csr_per_business_groups%notfound
118: then
119: close csr_per_business_groups;
120: hr_utility.set_location(g_package||l_procedure, 2);
121: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
122: return false;
123: end if;
124: close csr_per_business_groups;
125: --

Line 126: hr_utility.set_location(g_package||l_procedure, 10);

122: return false;
123: end if;
124: close csr_per_business_groups;
125: --
126: hr_utility.set_location(g_package||l_procedure, 10);
127: if l_legislation_code = g_legislation_code
128: then
129: return true;
130: else

Line 148: hr_utility.set_location(g_package||l_procedure,1);

144: --
145: l_procedure constant varchar2(60) := 'validate_percent_variables';
146: --
147: begin
148: hr_utility.set_location(g_package||l_procedure,1);
149: --
150: -- Check perentage amounts are between 0 and 100
151: --
152: if (p_sg_percent is not null)

Line 156: hr_utility.trace('p_sg_percent: '||to_char(p_sg_percent));

152: if (p_sg_percent is not null)
153: then
154: if (p_sg_percent not between 0 and 100)
155: then
156: hr_utility.trace('p_sg_percent: '||to_char(p_sg_percent));
157: return false;
158: end if;
159: end if;
160: --

Line 165: hr_utility.trace('p_non_sg_percent: '||to_char(p_non_sg_percent));

161: if (p_non_sg_percent is not null)
162: then
163: if (p_non_sg_percent not between 0 and 100)
164: then
165: hr_utility.trace('p_non_sg_percent: '||to_char(p_non_sg_percent));
166: return false;
167: end if;
168: end if;
169: hr_utility.set_location(g_package||l_procedure,10);

Line 169: hr_utility.set_location(g_package||l_procedure,10);

165: hr_utility.trace('p_non_sg_percent: '||to_char(p_non_sg_percent));
166: return false;
167: end if;
168: end if;
169: hr_utility.set_location(g_package||l_procedure,10);
170: return true;
171: end validate_percent_variables;
172: --
173: ---------------------------------------------------------------------------------------------

Line 208: hr_utility.set_location(g_package||l_procedure, 1);

204: begin
205: --
206: -- get the element type id for the super element
207: --
208: hr_utility.set_location(g_package||l_procedure, 1);
209: --
210: open csr_super_element(p_effective_date);
211: fetch csr_super_element
212: into p_element_type_id;

Line 216: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));

212: into p_element_type_id;
213: if (csr_super_element%notfound)
214: then
215: close csr_super_element;
216: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
217: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
218: hr_utility.raise_error;
219: end if;
220: close csr_super_element;

Line 217: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');

213: if (csr_super_element%notfound)
214: then
215: close csr_super_element;
216: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
217: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
218: hr_utility.raise_error;
219: end if;
220: close csr_super_element;
221: --

Line 218: hr_utility.raise_error;

214: then
215: close csr_super_element;
216: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
217: hr_utility.set_message(801,'HR_AU_NZ_ELE_TYP_NOT_FND');
218: hr_utility.raise_error;
219: end if;
220: close csr_super_element;
221: --
222: -- get the input value id for each tax input

Line 251: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));

247: then
248: p_inp_value_id_table(6) := rec_super_element.input_value_id;
249: --
250: else
251: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));
252: hr_utility.trace('Input name: '||rec_super_element.name);
253: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
254: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
255: hr_utility.raise_error;

Line 252: hr_utility.trace('Input name: '||rec_super_element.name);

248: p_inp_value_id_table(6) := rec_super_element.input_value_id;
249: --
250: else
251: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));
252: hr_utility.trace('Input name: '||rec_super_element.name);
253: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
254: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
255: hr_utility.raise_error;
256: end if;

Line 253: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));

249: --
250: else
251: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));
252: hr_utility.trace('Input name: '||rec_super_element.name);
253: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
254: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
255: hr_utility.raise_error;
256: end if;
257: end loop;

Line 254: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');

250: else
251: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));
252: hr_utility.trace('Input name: '||rec_super_element.name);
253: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
254: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
255: hr_utility.raise_error;
256: end if;
257: end loop;
258: --

Line 255: hr_utility.raise_error;

251: hr_utility.trace('p_element_type_id: '||to_char(p_element_type_id));
252: hr_utility.trace('Input name: '||rec_super_element.name);
253: hr_utility.trace('p_effective_date: '||to_char(p_effective_date,'MM/DD/YYYY'));
254: hr_utility.set_message(801,'HR_NZ_INPUT_VALUE_NOT_FOUND');
255: hr_utility.raise_error;
256: end if;
257: end loop;
258: --
259: hr_utility.set_location(g_package||l_procedure, 10);

Line 259: hr_utility.set_location(g_package||l_procedure, 10);

255: hr_utility.raise_error;
256: end if;
257: end loop;
258: --
259: hr_utility.set_location(g_package||l_procedure, 10);
260: --
261: end get_super_input_ids;
262: --
263: ---------------------------------------------------------------------------------------------

Line 342: hr_utility.set_location(g_package||l_procedure, 1);

338: --
339: begin
340: l_procedure := 'update_super_contribution'; -- Bug: 3648796
341:
342: hr_utility.set_location(g_package||l_procedure, 1);
343:
344: l_session_date := trunc(p_session_date);
345: --
346: -- Ensure business group supplied is Australian

Line 350: hr_utility.set_location(g_package||l_procedure, 2);

346: -- Ensure business group supplied is Australian
347: --
348: if not valid_business_group(p_business_group_id)
349: then
350: hr_utility.set_location(g_package||l_procedure, 2);
351: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');
352: hr_utility.raise_error;
353: end if;
354: --

Line 351: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');

347: --
348: if not valid_business_group(p_business_group_id)
349: then
350: hr_utility.set_location(g_package||l_procedure, 2);
351: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');
352: hr_utility.raise_error;
353: end if;
354: --
355: -- Check perentage amounts are between 0 and 100

Line 352: hr_utility.raise_error;

348: if not valid_business_group(p_business_group_id)
349: then
350: hr_utility.set_location(g_package||l_procedure, 2);
351: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');
352: hr_utility.raise_error;
353: end if;
354: --
355: -- Check perentage amounts are between 0 and 100
356: --

Line 359: hr_utility.set_message(801,'HR_AU_PERCENT_NOT_VALID');

355: -- Check perentage amounts are between 0 and 100
356: --
357: if not validate_percent_variables(p_sg_percent, p_non_sg_percent)
358: then
359: hr_utility.set_message(801,'HR_AU_PERCENT_NOT_VALID');
360: hr_utility.raise_error;
361: end if;
362: --
363: -- Get Element type id and input value ids

Line 360: hr_utility.raise_error;

356: --
357: if not validate_percent_variables(p_sg_percent, p_non_sg_percent)
358: then
359: hr_utility.set_message(801,'HR_AU_PERCENT_NOT_VALID');
360: hr_utility.raise_error;
361: end if;
362: --
363: -- Get Element type id and input value ids
364: --

Line 376: hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');

372: ,p_session_date => l_session_date
373: );
374: if (l_element_link_id is null or l_element_link_id = 0)
375: then
376: hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');
377: hr_utility.raise_error;
378: end if;
379:
380: -----------------------------------------------------------------------------

Line 377: hr_utility.raise_error;

373: );
374: if (l_element_link_id is null or l_element_link_id = 0)
375: then
376: hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');
377: hr_utility.raise_error;
378: end if;
379:
380: -----------------------------------------------------------------------------
381: -- verify the element entry is the super entry that is to be updated

Line 383: hr_utility.set_location(g_package||l_procedure ,7);

379:
380: -----------------------------------------------------------------------------
381: -- verify the element entry is the super entry that is to be updated
382: ------------------------------------------------------------------------------
383: hr_utility.set_location(g_package||l_procedure ,7);
384: --
385: open csr_ele_entry(l_element_link_id, l_inp_value_id_table(1), p_element_entry_id);
386: fetch csr_ele_entry into l_element_entry_id, l_object_version_number;
387: if (csr_ele_entry%notfound)

Line 390: hr_utility.set_message(801,'HR_AU_NZ_ELE_ENT_NOT_FND');

386: fetch csr_ele_entry into l_element_entry_id, l_object_version_number;
387: if (csr_ele_entry%notfound)
388: then
389: close csr_ele_entry;
390: hr_utility.set_message(801,'HR_AU_NZ_ELE_ENT_NOT_FND');
391: hr_utility.raise_error;
392: end if;
393: close csr_ele_entry;
394: --

Line 391: hr_utility.raise_error;

387: if (csr_ele_entry%notfound)
388: then
389: close csr_ele_entry;
390: hr_utility.set_message(801,'HR_AU_NZ_ELE_ENT_NOT_FND');
391: hr_utility.raise_error;
392: end if;
393: close csr_ele_entry;
394: --
395: -- Get the personal_payment_method_id for the super fund

Line 451: hr_utility.set_location(g_package||l_procedure, 30);

447: ,p_update_warning => p_update_warning
448: );
449: p_effective_start_date := l_effective_start_date;
450: p_effective_end_date := l_effective_end_date;
451: hr_utility.set_location(g_package||l_procedure, 30);
452: end update_super_contribution;
453: --
454: ---------------------------------------------------------------------------------------------
455: -- PUBLIC PROCEDURE create_super_contribution

Line 521: hr_utility.set_location(g_package||l_procedure, 1);

517: --
518: begin
519: l_procedure := 'create_super_contribution'; -- Bug: 3648796
520:
521: hr_utility.set_location(g_package||l_procedure, 1);
522:
523: --
524: -- Ensure business group supplied is Australian
525: --

Line 528: hr_utility.set_location(g_package||l_procedure, 2);

524: -- Ensure business group supplied is Australian
525: --
526: if not valid_business_group(p_business_group_id)
527: then
528: hr_utility.set_location(g_package||l_procedure, 2);
529: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');
530: hr_utility.raise_error;
531: end if;
532: --

Line 529: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');

525: --
526: if not valid_business_group(p_business_group_id)
527: then
528: hr_utility.set_location(g_package||l_procedure, 2);
529: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');
530: hr_utility.raise_error;
531: end if;
532: --
533: -- Check perentage amounts are between 0 and 100

Line 530: hr_utility.raise_error;

526: if not valid_business_group(p_business_group_id)
527: then
528: hr_utility.set_location(g_package||l_procedure, 2);
529: hr_utility.set_message(801,'HR_7208_API_BUS_GRP_INVALID');
530: hr_utility.raise_error;
531: end if;
532: --
533: -- Check perentage amounts are between 0 and 100
534: --

Line 537: hr_utility.set_message(801,'HR_AU_PERCENT_NOT_VALID');

533: -- Check perentage amounts are between 0 and 100
534: --
535: if not validate_percent_variables(p_sg_percent, p_non_sg_percent)
536: then
537: hr_utility.set_message(801,'HR_AU_PERCENT_NOT_VALID');
538: hr_utility.raise_error;
539: end if;
540: --
541: -- Get Element type id and input value ids

Line 538: hr_utility.raise_error;

534: --
535: if not validate_percent_variables(p_sg_percent, p_non_sg_percent)
536: then
537: hr_utility.set_message(801,'HR_AU_PERCENT_NOT_VALID');
538: hr_utility.raise_error;
539: end if;
540: --
541: -- Get Element type id and input value ids
542: --

Line 554: hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');

550: ,p_session_date => p_effective_date
551: );
552: if (l_element_link_id is null or l_element_link_id = 0)
553: then
554: hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');
555: hr_utility.raise_error;
556: end if;
557: --
558: --

Line 555: hr_utility.raise_error;

551: );
552: if (l_element_link_id is null or l_element_link_id = 0)
553: then
554: hr_utility.set_message(801,'HR_AU_NZ_ELE_LNK_NOT_FND');
555: hr_utility.raise_error;
556: end if;
557: --
558: --
559: -- Get the personal_payment_method_id for the super fund

Line 624: hr_utility.set_location(g_package||l_procedure, 30);

620: ,p_object_version_number => l_object_version_number
621: ,p_create_warning => l_create_warning
622: );
623: --
624: hr_utility.set_location(g_package||l_procedure, 30);
625: end create_super_contribution;
626:
627: end hr_au_super_api ;