DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on HR_UTILITY

Line 26: -- Name : HR_UTILITY_TRACE

22: --
23: -- Internal procedures
24: --
25: ------------------------------------------------------------------------------
26: -- Name : HR_UTILITY_TRACE
27: -- Description : This procedure prints debug messages.
28: ------------------------------------------------------------------------------
29: PROCEDURE HR_UTILITY_TRACE(P_TRC_DATA varchar2)
30: AS

Line 29: PROCEDURE HR_UTILITY_TRACE(P_TRC_DATA varchar2)

25: ------------------------------------------------------------------------------
26: -- Name : HR_UTILITY_TRACE
27: -- Description : This procedure prints debug messages.
28: ------------------------------------------------------------------------------
29: PROCEDURE HR_UTILITY_TRACE(P_TRC_DATA varchar2)
30: AS
31: BEGIN
32: IF g_debug THEN
33: hr_utility.trace(p_trc_data);

Line 33: hr_utility.trace(p_trc_data);

29: PROCEDURE HR_UTILITY_TRACE(P_TRC_DATA varchar2)
30: AS
31: BEGIN
32: IF g_debug THEN
33: hr_utility.trace(p_trc_data);
34: END IF;
35: END HR_UTILITY_TRACE;
36: ------------------------------------------------------------------------------
37: -- Name : PRINT_CLOB

Line 35: END HR_UTILITY_TRACE;

31: BEGIN
32: IF g_debug THEN
33: hr_utility.trace(p_trc_data);
34: END IF;
35: END HR_UTILITY_TRACE;
36: ------------------------------------------------------------------------------
37: -- Name : PRINT_CLOB
38: -- Description : This procedure prints contents of a CLOB object passed as
39: -- parameter.

Line 55: hr_utility_trace(l_buf);

51: l_chars,
52: l_offset,
53: l_buf);
54: --
55: hr_utility_trace(l_buf);
56: l_offset := l_offset + 255;
57: l_chars:= 255;
58: END LOOP;
59: --

Line 62: hr_utility_trace ('CLOB contents end.');

58: END LOOP;
59: --
60: EXCEPTION
61: WHEN NO_DATA_FOUND THEN
62: hr_utility_trace ('CLOB contents end.');
63: --
64: END PRINT_CLOB;
65:
66: FUNCTION convert_uppercase(p_input_string varchar2)

Line 267: hr_utility_trace('Entering '||l_proc_name);

263: l_business_group_id number;
264: l_effective_date date;
265: --
266: BEGIN
267: hr_utility_trace('Entering '||l_proc_name);
268: --
269: l_payroll_action_id := pay_magtape_generic.get_parameter_value
270: ('TRANSFER_PAYROLL_ACTION_ID');
271: if (l_payroll_action_id is null) then

Line 279: hr_utility_trace ('l_payroll_action_id '||l_payroll_action_id);

275: end if;
276: l_business_group_id := pay_magtape_generic.get_parameter_value
277: ('BG_ID');
278: --
279: hr_utility_trace ('l_payroll_action_id '||l_payroll_action_id);
280: hr_utility_trace ('l_business_group_id '||l_business_group_id);
281: --
282: load_xml('CS','PAYMENT_HEADER_FOOTER','');
283: --

Line 280: hr_utility_trace ('l_business_group_id '||l_business_group_id);

276: l_business_group_id := pay_magtape_generic.get_parameter_value
277: ('BG_ID');
278: --
279: hr_utility_trace ('l_payroll_action_id '||l_payroll_action_id);
280: hr_utility_trace ('l_business_group_id '||l_business_group_id);
281: --
282: load_xml('CS','PAYMENT_HEADER_FOOTER','');
283: --
284: file_creation_no(l_payroll_action_id);

Line 285: hr_utility_trace ('CLOB contents after appending header information');

281: --
282: load_xml('CS','PAYMENT_HEADER_FOOTER','');
283: --
284: file_creation_no(l_payroll_action_id);
285: hr_utility_trace ('CLOB contents after appending header information');
286: --print_clob (pay_mag_tape.g_clob_value);
287:
288: hr_utility_trace('Leaving '||l_proc_name);
289: END gen_header_xml;

Line 288: hr_utility_trace('Leaving '||l_proc_name);

284: file_creation_no(l_payroll_action_id);
285: hr_utility_trace ('CLOB contents after appending header information');
286: --print_clob (pay_mag_tape.g_clob_value);
287:
288: hr_utility_trace('Leaving '||l_proc_name);
289: END gen_header_xml;
290:
291: PROCEDURE gen_bank_header_xml
292: AS

Line 316: hr_utility_trace('Entering '||l_proc_name);

312: l_intl_bank_code varchar(2000);
313: l_ext_act_id number;
314: --
315: BEGIN
316: hr_utility_trace('Entering '||l_proc_name);
317:
318: l_ext_act_id := pay_magtape_generic.get_parameter_value('EXT_ACT_ID');
319:
320: OPEN get_bank_details(l_ext_act_id);

Line 335: hr_utility_trace('Leaving '||l_proc_name);

331: load_xml('D','TRANSIT_CODE' , l_transit_code);
332: load_xml('D','SWIFT_CODE' , l_swift_code);
333: load_xml('D','INTL_BANK_CODE' , l_intl_bank_code);
334:
335: hr_utility_trace('Leaving '||l_proc_name);
336:
337: end gen_bank_header_xml;
338:
339: PROCEDURE gen_bank_footer_xml

Line 343: hr_utility_trace('Entering '||l_proc_name);

339: PROCEDURE gen_bank_footer_xml
340: AS
341: l_proc_name varchar2(50) := 'pay_payment_xml_pkg.gen_bank_footer_xml';
342: BEGIN
343: hr_utility_trace('Entering '||l_proc_name);
344:
345: load_xml('CE','GRP_PAYMENT_SOURCE_BANK','');
346:
347: hr_utility_trace('Leaving '||l_proc_name);

Line 347: hr_utility_trace('Leaving '||l_proc_name);

343: hr_utility_trace('Entering '||l_proc_name);
344:
345: load_xml('CE','GRP_PAYMENT_SOURCE_BANK','');
346:
347: hr_utility_trace('Leaving '||l_proc_name);
348: end gen_bank_footer_xml;
349:
350: ------------------------------------------------------------------------------
351: -- Name : gen_footer_xml

Line 359: hr_utility_trace('Entering '||l_proc_name);

355: PROCEDURE gen_footer_xml
356: AS
357: l_proc_name varchar2(50) := 'pay_payment_xml_pkg.gen_footer_xml';
358: BEGIN
359: hr_utility_trace('Entering '||l_proc_name);
360:
361: load_xml('CE','PAYMENT_HEADER_FOOTER','');
362:
363: hr_utility_trace ('CLOB contents after appending footer information');

Line 363: hr_utility_trace ('CLOB contents after appending footer information');

359: hr_utility_trace('Entering '||l_proc_name);
360:
361: load_xml('CE','PAYMENT_HEADER_FOOTER','');
362:
363: hr_utility_trace ('CLOB contents after appending footer information');
364: --print_clob (pay_mag_tape.g_clob_value);
365:
366: hr_utility_trace('Leaving '||l_proc_name);
367: END gen_footer_xml;

Line 366: hr_utility_trace('Leaving '||l_proc_name);

362:
363: hr_utility_trace ('CLOB contents after appending footer information');
364: --print_clob (pay_mag_tape.g_clob_value);
365:
366: hr_utility_trace('Leaving '||l_proc_name);
367: END gen_footer_xml;
368: ------------------------------------------------------------------------------
369: -- Name : gen_payment_details_xml
370: -- Description : This procedure generates the xml payment details. There will

Line 701: hr_utility_trace('Entering '||l_proc_name);

697: currency_precision number;
698: CURR_NO_OF_DECIMALS number;
699: --
700: BEGIN
701: hr_utility_trace('Entering '||l_proc_name);
702: l_chars := 2000;
703: l_offset := 1;
704: --
705: l_tran_action_id := pay_magtape_generic.get_parameter_value

Line 723: hr_utility.trace('l_org_meth: '||to_char(l_org_meth));

719: l_prepay_asg_act := pay_magtape_generic.get_parameter_value
720: ('PRE_PAY_ASG_ACT');
721: l_org_meth := pay_magtape_generic.get_parameter_value
722: ('ORG_PAY_METHOD');
723: hr_utility.trace('l_org_meth: '||to_char(l_org_meth));
724: l_det_org_pay_method := pay_magtape_generic.get_parameter_value
725: ('DET_ORG_PAY_METH');
726: l_payee_meth := pay_magtape_generic.get_parameter_value
727: ('PAYEE_PAY_METH_ID');

Line 747: hr_utility_trace ('Legislation Code '||

743: g_leg_code := l_leg_code;
744: CLOSE c_get_leg_code;
745: END IF;
746: --
747: hr_utility_trace ('Legislation Code '||
748: g_leg_code);
749: --
750: OPEN get_org_bank_details(l_det_org_pay_method,l_effective_date);
751: FETCH get_org_bank_details INTO

Line 1133: hr_utility_trace ('CLOB contents for assignment action '||

1129: pay_mag_tape.call_leg_xml_proc;
1130: load_xml('CE','PAYMENT_DETAILS','');
1131: --
1132: --
1133: hr_utility_trace ('CLOB contents for assignment action '||
1134: l_assignment_action_id);
1135: --
1136: --print_clob (pay_mag_tape.g_clob_value);
1137: --

Line 1138: hr_utility_trace('Leaving '||l_proc_name);

1134: l_assignment_action_id);
1135: --
1136: --print_clob (pay_mag_tape.g_clob_value);
1137: --
1138: hr_utility_trace('Leaving '||l_proc_name);
1139: END gen_payment_details_xml;
1140: ------------------------------------------------------------------------------
1141: END PAY_PAYMENT_XML_PKG;