APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on HR_UTILITY

Line 149: hr_utility.set_location('pay_mag_utils.create_assignment_action',1);

145: l_serial_no varchar2(30);
146:
147: begin
148:
149: hr_utility.set_location('pay_mag_utils.create_assignment_action',1);
150:
151: /* Create assignment action to identify a specific person's inclusion in the
152: magnetic tape report identified by the parent payroll action. The
153: assignment action has to be sequenced within the other assignment actions

Line 181: hr_utility.set_location('pay_mag_utils.create_assignment_action',2);

177:
178:
179: /* Get the assignment_action_id of the newly created assignment action. */
180:
181: hr_utility.set_location('pay_mag_utils.create_assignment_action',2);
182:
183: open csr_assignment_action;
184: fetch csr_assignment_action INTO l_assignment_action_id;
185: close csr_assignment_action;

Line 192: hr_utility.set_location('pay_mag_utils.create_assignment_action',3);

188: set aa.tax_unit_id = p_tax_unit_id,
189: aa.serial_number = l_serial_no
190: where aa.assignment_action_id = l_assignment_action_id;
191:
192: hr_utility.set_location('pay_mag_utils.create_assignment_action',3);
193:
194: /* Return id of new row. */
195:
196: return (l_assignment_action_id);

Line 415: hr_utility.trace('COMMITTED');

411:
412: if cnt = l_chunk_size then
413: cnt := 0;
414: commit;
415: hr_utility.trace('COMMITTED');
416: end if;
417:
418: cnt := cnt + 1;
419: hr_utility.trace('CNT:::: '||cnt||'CHUNK SIZE::: '||l_chunk_size);

Line 419: hr_utility.trace('CNT:::: '||cnt||'CHUNK SIZE::: '||l_chunk_size);

415: hr_utility.trace('COMMITTED');
416: end if;
417:
418: cnt := cnt + 1;
419: hr_utility.trace('CNT:::: '||cnt||'CHUNK SIZE::: '||l_chunk_size);
420:
421: /* Fetch a row from the cursor. */
422:
423: fetch c_people into l_person_id,

Line 635: raise hr_utility.hr_error;

631:
632: if l_request_id = 0 then
633:
634: g_message_text := 'Failed to submit concurrent request';
635: raise hr_utility.hr_error;
636: end if;
637:
638: /* Request has been accepted so update payroll action with the
639: request details. */

Line 814: when hr_utility.hr_error then

810: /* Traps all exceptions raised within the procedure, extracts the message
811: text associated with the exception and sets this up for SRS to read. */
812:
813: exception
814: when hr_utility.hr_error then
815:
816: /* If a payroll action exists then error it. */
817: if p_payroll_action_id is not null then
818: Pay_Mag_Utils.Error_Payroll_Action(p_payroll_action_id);

Line 826: errbuf := hr_utility.get_message;

822: if g_message_text is not null
823: then
824: errbuf := g_message_text;
825: else
826: errbuf := hr_utility.get_message;
827: end if;
828: retcode := 2;
829:
830: when others then

Line 916: hr_utility.raise_error;

912: /* Set up error message and error return code. */
913: errbuf := l_err_text;
914: retcode := l_err_code;
915: g_message_text := l_err_text;
916: hr_utility.raise_error;
917: end if;
918:
919: /* Now its time to check for the context of Worksite Filing */
920:

Line 933: hr_utility.raise_error;

929: /* Set up error message and error return code. */
930: errbuf := l_err_text;
931: retcode := l_err_code;
932: g_message_text := l_err_text;
933: hr_utility.raise_error;
934: end if;
935:
936: /* Derive the start and end dates of the period being reported on. */
937:

Line 1006: hr_utility.raise_error;

1002: on. Set up message explaining why report was not produced. */
1003:
1004: g_message_text := 'There are no employees that match ' ||
1005: 'the criteria for the report';
1006: hr_utility.raise_error;
1007:
1008: end if;
1009:
1010: /* Process completed successfully. Update the status of the payroll and

Line 1023: when hr_utility.hr_error then

1019: /* Trap all exceptions raised within the procedure, extract the message
1020: text associated with the exception and set this up for SRS to read. */
1021:
1022: exception
1023: when hr_utility.hr_error then
1024: /* If a payroll action exists then error it. */
1025: if l_payroll_action_id is not null then
1026: Pay_Mag_Utils.Error_Payroll_Action(l_payroll_action_id);
1027: end if;

Line 1034: errbuf := hr_utility.get_message;

1030: if g_message_text is not null
1031: then
1032: errbuf := g_message_text;
1033: else
1034: errbuf := hr_utility.get_message;
1035: end if;
1036: retcode := 2;
1037:
1038: when others then