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

Line 32: hr_utility.set_location

28: p_business_group_id IN OUT NOCOPY NUMBER,
29: p_legislative_parameters OUT NOCOPY VARCHAR2
30: ) IS
31: BEGIN
32: hr_utility.set_location
33: ('pay_ca_t4a_mag.get_report_parameters', 10);
34:
35: SELECT ppa.start_date,
36: ppa.effective_date,

Line 47: hr_utility.set_location

43: p_report_type,
44: p_legislative_parameters
45: FROM pay_payroll_actions ppa
46: WHERE payroll_action_id = p_pactid;
47: hr_utility.set_location
48: ('pay_ca_t4a_mag.get_report_parameters', 20);
49:
50: END get_report_parameters;
51:

Line 104: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 10);

100: l_tax_year VARCHAR2(10);
101:
102: BEGIN
103:
104: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 10);
105:
106: get_report_parameters(
107: p_pactid,
108: p_year_start,

Line 120: hr_utility.trace('l_tax_year ='||l_tax_year);

116: l_person_id_ue_id := get_user_entity_id('CAEOY_PERSON_ID');
117: l_tax_year := pay_ca_t4a_mag.get_parameter('REPORTING_YEAR',
118: l_legislative_parameters);
119:
120: hr_utility.trace('l_tax_year ='||l_tax_year);
121: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 20);
122:
123: /* Removed the join from 'Where clause' that checks
124: whether GRE has the 'Fed Magnetic Reporting' information or not */

Line 121: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 20);

117: l_tax_year := pay_ca_t4a_mag.get_parameter('REPORTING_YEAR',
118: l_legislative_parameters);
119:
120: hr_utility.trace('l_tax_year ='||l_tax_year);
121: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 20);
122:
123: /* Removed the join from 'Where clause' that checks
124: whether GRE has the 'Fed Magnetic Reporting' information or not */
125:

Line 150: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 30);

146: ' and fai1.context1 = paa.assignment_action_id
147: and fai1.user_entity_id = '||l_person_id_ue_id||
148: ' order by to_number(fai1.value)';
149:
150: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 30);
151:
152: END range_cursor;
153:
154: --

Line 243: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',10);

239: BEGIN
240:
241: -- Get the report parameters. These define the report being run.
242:
243: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',10);
244:
245: get_report_parameters(
246: p_pactid,
247: l_year_start,

Line 253: --hr_utility.trace_on(null,'T4MAG');

249: l_report_type,
250: l_business_group_id,
251: l_legislative_parameters
252: );
253: --hr_utility.trace_on(null,'T4MAG');
254: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',
255: l_legislative_parameters);
256: hr_utility.trace('l_trans_gre ='||l_trans_gre);
257: l_validate_gre := pay_ca_t4a_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));

Line 256: hr_utility.trace('l_trans_gre ='||l_trans_gre);

252: );
253: --hr_utility.trace_on(null,'T4MAG');
254: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',
255: l_legislative_parameters);
256: hr_utility.trace('l_trans_gre ='||l_trans_gre);
257: l_validate_gre := pay_ca_t4a_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
258:
259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);
260:

Line 259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);

255: l_legislative_parameters);
256: hr_utility.trace('l_trans_gre ='||l_trans_gre);
257: l_validate_gre := pay_ca_t4a_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
258:
259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);
260:
261: if l_validate_gre = '1' then
262: hr_utility.raise_error;
263: end if;

Line 262: hr_utility.raise_error;

258:
259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);
260:
261: if l_validate_gre = '1' then
262: hr_utility.raise_error;
263: end if;
264:
265: IF l_report_type = 'MAG_T4A' THEN
266: OPEN c_all_asg;

Line 273: hr_utility.set_location('pay_ca_t4a_mag.create_assignement_act', 30);

269: l_assignment_id,
270: l_tax_unit_id,
271: l_effective_end_date,
272: l_assignment_action_id;
273: hr_utility.set_location('pay_ca_t4a_mag.create_assignement_act', 30);
274: EXIT WHEN c_all_asg%NOTFOUND;
275:
276:
277: --Create the assignment action for the record

Line 279: hr_utility.trace('Assignment Fetched - ');

275:
276:
277: --Create the assignment action for the record
278:
279: hr_utility.trace('Assignment Fetched - ');
280: hr_utility.trace('Assignment Id : '||
281: to_char(l_assignment_id));
282: hr_utility.trace('Person Id : '|| to_char(l_person_id));
283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));

Line 280: hr_utility.trace('Assignment Id : '||

276:
277: --Create the assignment action for the record
278:
279: hr_utility.trace('Assignment Fetched - ');
280: hr_utility.trace('Assignment Id : '||
281: to_char(l_assignment_id));
282: hr_utility.trace('Person Id : '|| to_char(l_person_id));
283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
284: hr_utility.trace('Effective End Date : '||

Line 282: hr_utility.trace('Person Id : '|| to_char(l_person_id));

278:
279: hr_utility.trace('Assignment Fetched - ');
280: hr_utility.trace('Assignment Id : '||
281: to_char(l_assignment_id));
282: hr_utility.trace('Person Id : '|| to_char(l_person_id));
283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
284: hr_utility.trace('Effective End Date : '||
285: to_char(l_effective_end_date));
286:

Line 283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));

279: hr_utility.trace('Assignment Fetched - ');
280: hr_utility.trace('Assignment Id : '||
281: to_char(l_assignment_id));
282: hr_utility.trace('Person Id : '|| to_char(l_person_id));
283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
284: hr_utility.trace('Effective End Date : '||
285: to_char(l_effective_end_date));
286:
287: hr_utility.set_location(

Line 284: hr_utility.trace('Effective End Date : '||

280: hr_utility.trace('Assignment Id : '||
281: to_char(l_assignment_id));
282: hr_utility.trace('Person Id : '|| to_char(l_person_id));
283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
284: hr_utility.trace('Effective End Date : '||
285: to_char(l_effective_end_date));
286:
287: hr_utility.set_location(
288: 'pay_ca_t4a_mag.create_assignement_act', 40);

Line 287: hr_utility.set_location(

283: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
284: hr_utility.trace('Effective End Date : '||
285: to_char(l_effective_end_date));
286:
287: hr_utility.set_location(
288: 'pay_ca_t4a_mag.create_assignement_act', 40);
289:
290: SELECT pay_assignment_actions_s.nextval
291: INTO lockingactid

Line 293: hr_utility.set_location(

289:
290: SELECT pay_assignment_actions_s.nextval
291: INTO lockingactid
292: FROM dual;
293: hr_utility.set_location(
294: 'pay_ca_t4a_mag.create_assignement_act', 50);
295:
296: hr_nonrun_asact.insact(lockingactid, l_assignment_id,
297: p_pactid,p_chunk, l_tax_unit_id);

Line 299: hr_utility.set_location(

295:
296: hr_nonrun_asact.insact(lockingactid, l_assignment_id,
297: p_pactid,p_chunk, l_tax_unit_id);
298:
299: hr_utility.set_location(
300: 'pay_ca_t4a_mag.create_assignement_act', 60);
301:
302: hr_nonrun_asact.insint(lockingactid,
303: l_assignment_action_id);

Line 305: hr_utility.set_location(

301:
302: hr_nonrun_asact.insint(lockingactid,
303: l_assignment_action_id);
304:
305: hr_utility.set_location(
306: 'pay_ca_t4a_mag.create_assignement_act', 70);
307:
308: hr_utility.trace('Interlock Created - ');
309: hr_utility.trace('Locking Action : '||

Line 308: hr_utility.trace('Interlock Created - ');

304:
305: hr_utility.set_location(
306: 'pay_ca_t4a_mag.create_assignement_act', 70);
307:
308: hr_utility.trace('Interlock Created - ');
309: hr_utility.trace('Locking Action : '||
310: to_char(lockingactid));
311: hr_utility.trace('Locked Action : '||
312: to_char(l_assignment_action_id));

Line 309: hr_utility.trace('Locking Action : '||

305: hr_utility.set_location(
306: 'pay_ca_t4a_mag.create_assignement_act', 70);
307:
308: hr_utility.trace('Interlock Created - ');
309: hr_utility.trace('Locking Action : '||
310: to_char(lockingactid));
311: hr_utility.trace('Locked Action : '||
312: to_char(l_assignment_action_id));
313:

Line 311: hr_utility.trace('Locked Action : '||

307:
308: hr_utility.trace('Interlock Created - ');
309: hr_utility.trace('Locking Action : '||
310: to_char(lockingactid));
311: hr_utility.trace('Locked Action : '||
312: to_char(l_assignment_action_id));
313:
314: END LOOP;
315: Close c_all_asg;

Line 429: hr_utility.trace('fetch footnote '|| lv_footnote_amount);

425: lv_footnote_amount := '0';
426: open c_get_footnote_amount(p_assignment_action_id,p_footnote_code);
427: fetch c_get_footnote_amount into lv_footnote_amount;
428:
429: hr_utility.trace('fetch footnote '|| lv_footnote_amount);
430:
431: close c_get_footnote_amount;
432:
433: return lv_footnote_amount;

Line 436: hr_utility.trace('fetch no footnote ');

432:
433: return lv_footnote_amount;
434: exception
435: when no_data_found then
436: hr_utility.trace('fetch no footnote ');
437: lv_footnote_amount := '0';
438: return lv_footnote_amount;
439: end get_t4a_footnote_amounts;
440:

Line 508: --hr_utility.trace_on(null,'T4MAG');

504: BEGIN
505:
506: /* Fetching the Payroll Action Id for Trasnmitter GRE */
507:
508: --hr_utility.trace_on(null,'T4MAG');
509: hr_utility.trace('Inside the Validation Code');
510: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
511: open c_trans_payid(p_trans,p_year);
512: fetch c_trans_payid into l_trans_payid,l_bg_id;

Line 509: hr_utility.trace('Inside the Validation Code');

505:
506: /* Fetching the Payroll Action Id for Trasnmitter GRE */
507:
508: --hr_utility.trace_on(null,'T4MAG');
509: hr_utility.trace('Inside the Validation Code');
510: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
511: open c_trans_payid(p_trans,p_year);
512: fetch c_trans_payid into l_trans_payid,l_bg_id;
513: IF c_trans_payid%notfound THEN

Line 510: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);

506: /* Fetching the Payroll Action Id for Trasnmitter GRE */
507:
508: --hr_utility.trace_on(null,'T4MAG');
509: hr_utility.trace('Inside the Validation Code');
510: hr_utility.trace('The Transmitter GRE id passed is '||p_trans);
511: open c_trans_payid(p_trans,p_year);
512: fetch c_trans_payid into l_trans_payid,l_bg_id;
513: IF c_trans_payid%notfound THEN
514: close c_trans_payid;

Line 515: hr_utility.trace('The Transmitter GRE id not found '||p_trans);

511: open c_trans_payid(p_trans,p_year);
512: fetch c_trans_payid into l_trans_payid,l_bg_id;
513: IF c_trans_payid%notfound THEN
514: close c_trans_payid;
515: hr_utility.trace('The Transmitter GRE id not found '||p_trans);
516: hr_utility.raise_error;
517: return '1';
518: else
519: close c_trans_payid;

Line 516: hr_utility.raise_error;

512: fetch c_trans_payid into l_trans_payid,l_bg_id;
513: IF c_trans_payid%notfound THEN
514: close c_trans_payid;
515: hr_utility.trace('The Transmitter GRE id not found '||p_trans);
516: hr_utility.raise_error;
517: return '1';
518: else
519: close c_trans_payid;
520: END IF;

Line 522: hr_utility.trace('Fetched the Payroll Id for transmitter GRE'|| l_trans_payid);

518: else
519: close c_trans_payid;
520: END IF;
521:
522: hr_utility.trace('Fetched the Payroll Id for transmitter GRE'|| l_trans_payid);
523: hr_utility.trace('The Reporting Year is '||p_year);
524:
525: /*Fetching the Trasnmitter Level Data */
526:

Line 523: hr_utility.trace('The Reporting Year is '||p_year);

519: close c_trans_payid;
520: END IF;
521:
522: hr_utility.trace('Fetched the Payroll Id for transmitter GRE'|| l_trans_payid);
523: hr_utility.trace('The Reporting Year is '||p_year);
524:
525: /*Fetching the Trasnmitter Level Data */
526:
527: l_trans_no := get_arch_val(l_trans_payid, 'CAEOY_TRANSMITTER_NUMBER');

Line 544: hr_utility.trace('Transmitter Number'||l_trans_no);

540: OPEN c_gre_name(to_number(p_trans));
541: FETCH c_gre_name INTO l_trans_name;
542: CLOSE c_gre_name;
543:
544: hr_utility.trace('Transmitter Number'||l_trans_no);
545: hr_utility.trace('Tech Name'||l_tech_name);
546: hr_utility.trace('Tech Email '||l_tech_email);
547: hr_utility.trace('Tech Phno'||l_tech_phno);
548: hr_utility.trace('Tech area'||l_tech_area);

Line 545: hr_utility.trace('Tech Name'||l_tech_name);

541: FETCH c_gre_name INTO l_trans_name;
542: CLOSE c_gre_name;
543:
544: hr_utility.trace('Transmitter Number'||l_trans_no);
545: hr_utility.trace('Tech Name'||l_tech_name);
546: hr_utility.trace('Tech Email '||l_tech_email);
547: hr_utility.trace('Tech Phno'||l_tech_phno);
548: hr_utility.trace('Tech area'||l_tech_area);
549: hr_utility.trace('Tech Lang'||l_lang);

Line 546: hr_utility.trace('Tech Email '||l_tech_email);

542: CLOSE c_gre_name;
543:
544: hr_utility.trace('Transmitter Number'||l_trans_no);
545: hr_utility.trace('Tech Name'||l_tech_name);
546: hr_utility.trace('Tech Email '||l_tech_email);
547: hr_utility.trace('Tech Phno'||l_tech_phno);
548: hr_utility.trace('Tech area'||l_tech_area);
549: hr_utility.trace('Tech Lang'||l_lang);
550:

Line 547: hr_utility.trace('Tech Phno'||l_tech_phno);

543:
544: hr_utility.trace('Transmitter Number'||l_trans_no);
545: hr_utility.trace('Tech Name'||l_tech_name);
546: hr_utility.trace('Tech Email '||l_tech_email);
547: hr_utility.trace('Tech Phno'||l_tech_phno);
548: hr_utility.trace('Tech area'||l_tech_area);
549: hr_utility.trace('Tech Lang'||l_lang);
550:
551: /* Checking for the validity of the above values fetched */

Line 548: hr_utility.trace('Tech area'||l_tech_area);

544: hr_utility.trace('Transmitter Number'||l_trans_no);
545: hr_utility.trace('Tech Name'||l_tech_name);
546: hr_utility.trace('Tech Email '||l_tech_email);
547: hr_utility.trace('Tech Phno'||l_tech_phno);
548: hr_utility.trace('Tech area'||l_tech_area);
549: hr_utility.trace('Tech Lang'||l_lang);
550:
551: /* Checking for the validity of the above values fetched */
552: IF l_trans_no IS NULL

Line 549: hr_utility.trace('Tech Lang'||l_lang);

545: hr_utility.trace('Tech Name'||l_tech_name);
546: hr_utility.trace('Tech Email '||l_tech_email);
547: hr_utility.trace('Tech Phno'||l_tech_phno);
548: hr_utility.trace('Tech area'||l_tech_area);
549: hr_utility.trace('Tech Lang'||l_lang);
550:
551: /* Checking for the validity of the above values fetched */
552: IF l_trans_no IS NULL
553: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN

Line 554: hr_utility.trace('Incorrect Transmitter No format');

550:
551: /* Checking for the validity of the above values fetched */
552: IF l_trans_no IS NULL
553: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
554: hr_utility.trace('Incorrect Transmitter No format');
555: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
556: hr_utility.set_message_token('GRE_NAME',l_trans_name);
557: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
558: pay_core_utils.push_token('GRE_NAME',l_trans_name);

Line 555: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');

551: /* Checking for the validity of the above values fetched */
552: IF l_trans_no IS NULL
553: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
554: hr_utility.trace('Incorrect Transmitter No format');
555: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
556: hr_utility.set_message_token('GRE_NAME',l_trans_name);
557: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
558: pay_core_utils.push_token('GRE_NAME',l_trans_name);
559: hr_utility.raise_error;

Line 556: hr_utility.set_message_token('GRE_NAME',l_trans_name);

552: IF l_trans_no IS NULL
553: OR TRANSLATE(l_trans_no,'M0123456789','M9999999999') <> 'MM999999' THEN
554: hr_utility.trace('Incorrect Transmitter No format');
555: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
556: hr_utility.set_message_token('GRE_NAME',l_trans_name);
557: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
558: pay_core_utils.push_token('GRE_NAME',l_trans_name);
559: hr_utility.raise_error;
560: return '1';

Line 559: hr_utility.raise_error;

555: hr_utility.set_message(801,'PAY_74155_INCORRECT_TRANSMT_NO');
556: hr_utility.set_message_token('GRE_NAME',l_trans_name);
557: pay_core_utils.push_message(801,'PAY_74155_INCORRECT_TRANSMT_NO','P');
558: pay_core_utils.push_token('GRE_NAME',l_trans_name);
559: hr_utility.raise_error;
560: return '1';
561: END IF;
562:
563: if l_tech_name is null or

Line 568: hr_utility.trace('Technical contact details missing');

564: l_tech_area is null or
565: l_tech_phno is null or
566: l_tech_email is null or
567: l_lang is null then
568: hr_utility.trace('Technical contact details missing');
569: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
570: hr_utility.set_message_token('GRE_NAME',l_trans_name);
571: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
572: pay_core_utils.push_token('GRE_NAME',l_trans_name);

Line 569: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');

565: l_tech_phno is null or
566: l_tech_email is null or
567: l_lang is null then
568: hr_utility.trace('Technical contact details missing');
569: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
570: hr_utility.set_message_token('GRE_NAME',l_trans_name);
571: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
572: pay_core_utils.push_token('GRE_NAME',l_trans_name);
573: hr_utility.raise_error;

Line 570: hr_utility.set_message_token('GRE_NAME',l_trans_name);

566: l_tech_email is null or
567: l_lang is null then
568: hr_utility.trace('Technical contact details missing');
569: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
570: hr_utility.set_message_token('GRE_NAME',l_trans_name);
571: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
572: pay_core_utils.push_token('GRE_NAME',l_trans_name);
573: hr_utility.raise_error;
574: return '1';

Line 573: hr_utility.raise_error;

569: hr_utility.set_message(801,'PAY_74158_INCORRECT_TCHN_INFO');
570: hr_utility.set_message_token('GRE_NAME',l_trans_name);
571: pay_core_utils.push_message(801,'PAY_74158_INCORRECT_TCHN_INFO','P');
572: pay_core_utils.push_token('GRE_NAME',l_trans_name);
573: hr_utility.raise_error;
574: return '1';
575: end if;
576: if l_acc_name is null or
577: l_acc_phno is null or

Line 583: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);

579: l_acc_info_flag := 'N';
580: else
581: l_acc_info_flag := 'Y';
582: end if;
583: hr_utility.trace('The value of the Flag is '||l_acc_info_flag);
584:
585: /* If Transmitter Level Accounting Information is Missing checking for the GRE level information */
586:
587: open c_all_gres(p_trans,p_year,l_bg_id);

Line 590: hr_utility.trace('The Gre id fetched is '||l_gre);

586:
587: open c_all_gres(p_trans,p_year,l_bg_id);
588: loop
589: fetch c_all_gres into l_gre_payid, l_gre, l_gre_name;
590: hr_utility.trace('The Gre id fetched is '||l_gre);
591: if c_all_gres%notfound then
592: close c_all_gres;
593: exit;
594: end if;

Line 596: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);

592: close c_all_gres;
593: exit;
594: end if;
595:
596: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
597:
598:
599: if l_gre <> to_number(p_trans) then
600: hr_utility.trace('Inside the loop'||l_gre_payid);

Line 600: hr_utility.trace('Inside the loop'||l_gre_payid);

596: hr_utility.trace('Before fetching the GREs for this Transmitter '||l_gre||'-'||p_year);
597:
598:
599: if l_gre <> to_number(p_trans) then
600: hr_utility.trace('Inside the loop'||l_gre_payid);
601:
602: hr_utility.trace('Checking GRE level data');
603: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
604: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');

Line 602: hr_utility.trace('Checking GRE level data');

598:
599: if l_gre <> to_number(p_trans) then
600: hr_utility.trace('Inside the loop'||l_gre_payid);
601:
602: hr_utility.trace('Checking GRE level data');
603: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
604: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
605: --l_tax_unit_id := get_arch_val(l_gre_payid, 'CAEOY_TAX_UNIT_ID');
606: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');

Line 603: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);

599: if l_gre <> to_number(p_trans) then
600: hr_utility.trace('Inside the loop'||l_gre_payid);
601:
602: hr_utility.trace('Checking GRE level data');
603: hr_utility.trace('The Payroll Action Id for Gre is '|| l_gre_payid);
604: l_bus_no := get_arch_val(l_gre_payid,'CAEOY_EMPLOYER_IDENTIFICATION_NUMBER');
605: --l_tax_unit_id := get_arch_val(l_gre_payid, 'CAEOY_TAX_UNIT_ID');
606: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
607: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');

Line 610: hr_utility.trace('Tax unit Id'||l_tax_unit_id);

606: l_acc_name := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_NAME');
607: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
608: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
609:
610: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
611: hr_utility.trace('Acc Name '||l_acc_name);
612: hr_utility.trace('Acc Area '||l_acc_area);
613: hr_utility.trace('Acc Phone '||l_acc_phno);
614: hr_utility.trace('gre namee '||l_gre_name);

Line 611: hr_utility.trace('Acc Name '||l_acc_name);

607: l_acc_area := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_AREA_CODE');
608: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
609:
610: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
611: hr_utility.trace('Acc Name '||l_acc_name);
612: hr_utility.trace('Acc Area '||l_acc_area);
613: hr_utility.trace('Acc Phone '||l_acc_phno);
614: hr_utility.trace('gre namee '||l_gre_name);
615:

Line 612: hr_utility.trace('Acc Area '||l_acc_area);

608: l_acc_phno := get_arch_val(l_gre_payid, 'CAEOY_ACCOUNTING_CONTACT_PHONE');
609:
610: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
611: hr_utility.trace('Acc Name '||l_acc_name);
612: hr_utility.trace('Acc Area '||l_acc_area);
613: hr_utility.trace('Acc Phone '||l_acc_phno);
614: hr_utility.trace('gre namee '||l_gre_name);
615:
616:

Line 613: hr_utility.trace('Acc Phone '||l_acc_phno);

609:
610: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
611: hr_utility.trace('Acc Name '||l_acc_name);
612: hr_utility.trace('Acc Area '||l_acc_area);
613: hr_utility.trace('Acc Phone '||l_acc_phno);
614: hr_utility.trace('gre namee '||l_gre_name);
615:
616:
617: if l_bus_no is null

Line 614: hr_utility.trace('gre namee '||l_gre_name);

610: hr_utility.trace('Tax unit Id'||l_tax_unit_id);
611: hr_utility.trace('Acc Name '||l_acc_name);
612: hr_utility.trace('Acc Area '||l_acc_area);
613: hr_utility.trace('Acc Phone '||l_acc_phno);
614: hr_utility.trace('gre namee '||l_gre_name);
615:
616:
617: if l_bus_no is null
618: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then

Line 619: hr_utility.trace('No Business Number Entereed ');

615:
616:
617: if l_bus_no is null
618: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
619: hr_utility.trace('No Business Number Entereed ');
620: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
621: hr_utility.set_message_token('GRE_NAME',l_gre_name);
622: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
623: pay_core_utils.push_token('GRE_NAME',l_gre_name);

Line 620: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');

616:
617: if l_bus_no is null
618: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
619: hr_utility.trace('No Business Number Entereed ');
620: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
621: hr_utility.set_message_token('GRE_NAME',l_gre_name);
622: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
623: pay_core_utils.push_token('GRE_NAME',l_gre_name);
624: hr_utility.raise_error;

Line 621: hr_utility.set_message_token('GRE_NAME',l_gre_name);

617: if l_bus_no is null
618: or TRANSLATE(l_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
619: hr_utility.trace('No Business Number Entereed ');
620: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
621: hr_utility.set_message_token('GRE_NAME',l_gre_name);
622: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
623: pay_core_utils.push_token('GRE_NAME',l_gre_name);
624: hr_utility.raise_error;
625: return '1';

Line 624: hr_utility.raise_error;

620: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
621: hr_utility.set_message_token('GRE_NAME',l_gre_name);
622: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
623: pay_core_utils.push_token('GRE_NAME',l_gre_name);
624: hr_utility.raise_error;
625: return '1';
626: end if;
627:
628: if (l_acc_name is null or

Line 632: hr_utility.trace('No Accounting Contact info present');

628: if (l_acc_name is null or
629: l_acc_area is null or
630: l_acc_phno is null ) and
631: l_acc_info_flag = 'N' then
632: hr_utility.trace('No Accounting Contact info present');
633: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
634: hr_utility.set_message_token('GRE_NAME',l_gre_name);
635: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
636: pay_core_utils.push_token('GRE_NAME',l_gre_name);

Line 633: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');

629: l_acc_area is null or
630: l_acc_phno is null ) and
631: l_acc_info_flag = 'N' then
632: hr_utility.trace('No Accounting Contact info present');
633: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
634: hr_utility.set_message_token('GRE_NAME',l_gre_name);
635: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
636: pay_core_utils.push_token('GRE_NAME',l_gre_name);
637: hr_utility.raise_error;

Line 634: hr_utility.set_message_token('GRE_NAME',l_gre_name);

630: l_acc_phno is null ) and
631: l_acc_info_flag = 'N' then
632: hr_utility.trace('No Accounting Contact info present');
633: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
634: hr_utility.set_message_token('GRE_NAME',l_gre_name);
635: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
636: pay_core_utils.push_token('GRE_NAME',l_gre_name);
637: hr_utility.raise_error;
638: return '1';

Line 637: hr_utility.raise_error;

633: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
634: hr_utility.set_message_token('GRE_NAME',l_gre_name);
635: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
636: pay_core_utils.push_token('GRE_NAME',l_gre_name);
637: hr_utility.raise_error;
638: return '1';
639: end if;
640:
641: elsif l_gre = to_number(p_trans) then

Line 645: hr_utility.trace('No Business Number Entereed ');

641: elsif l_gre = to_number(p_trans) then
642:
643: if l_trans_bus_no is null
644: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
645: hr_utility.trace('No Business Number Entereed ');
646: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
647: hr_utility.set_message_token('GRE_NAME',l_trans_name);
648: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
649: pay_core_utils.push_token('GRE_NAME',l_trans_name);

Line 646: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');

642:
643: if l_trans_bus_no is null
644: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
645: hr_utility.trace('No Business Number Entereed ');
646: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
647: hr_utility.set_message_token('GRE_NAME',l_trans_name);
648: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
649: pay_core_utils.push_token('GRE_NAME',l_trans_name);
650: hr_utility.raise_error;

Line 647: hr_utility.set_message_token('GRE_NAME',l_trans_name);

643: if l_trans_bus_no is null
644: or TRANSLATE(l_trans_bus_no,'0123456789RP','9999999999RP') <> '999999999RP9999' then
645: hr_utility.trace('No Business Number Entereed ');
646: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
647: hr_utility.set_message_token('GRE_NAME',l_trans_name);
648: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
649: pay_core_utils.push_token('GRE_NAME',l_trans_name);
650: hr_utility.raise_error;
651: return '1';

Line 650: hr_utility.raise_error;

646: hr_utility.set_message(801,'PAY_74154_INCORRECT_BN');
647: hr_utility.set_message_token('GRE_NAME',l_trans_name);
648: pay_core_utils.push_message(801,'PAY_74154_INCORRECT_BN','P');
649: pay_core_utils.push_token('GRE_NAME',l_trans_name);
650: hr_utility.raise_error;
651: return '1';
652: end if;
653: if l_acc_info_flag = 'N' then
654: hr_utility.trace('No Accounting Contact info present');

Line 654: hr_utility.trace('No Accounting Contact info present');

650: hr_utility.raise_error;
651: return '1';
652: end if;
653: if l_acc_info_flag = 'N' then
654: hr_utility.trace('No Accounting Contact info present');
655: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
656: hr_utility.set_message_token('GRE_NAME',l_trans_name);
657: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
658: pay_core_utils.push_token('GRE_NAME',l_trans_name);

Line 655: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');

651: return '1';
652: end if;
653: if l_acc_info_flag = 'N' then
654: hr_utility.trace('No Accounting Contact info present');
655: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
656: hr_utility.set_message_token('GRE_NAME',l_trans_name);
657: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
658: pay_core_utils.push_token('GRE_NAME',l_trans_name);
659: hr_utility.raise_error;

Line 656: hr_utility.set_message_token('GRE_NAME',l_trans_name);

652: end if;
653: if l_acc_info_flag = 'N' then
654: hr_utility.trace('No Accounting Contact info present');
655: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
656: hr_utility.set_message_token('GRE_NAME',l_trans_name);
657: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
658: pay_core_utils.push_token('GRE_NAME',l_trans_name);
659: hr_utility.raise_error;
660: return '1';

Line 659: hr_utility.raise_error;

655: hr_utility.set_message(801,'PAY_74157_INCORRECT_ACNT_INFO');
656: hr_utility.set_message_token('GRE_NAME',l_trans_name);
657: pay_core_utils.push_message(801,'PAY_74157_INCORRECT_ACNT_INFO','P');
658: pay_core_utils.push_token('GRE_NAME',l_trans_name);
659: hr_utility.raise_error;
660: return '1';
661: end if;
662: end if;
663: end loop;

Line 1033: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);

1029: l_transfer_oth1_rep1 := rpad(lpad('.00,',10), 10*12, lpad('.00,',10));
1030: l_transfer_oth3_rep2 := rpad(lpad('.00,',10), 10*12, lpad('.00,',10));
1031: l_transfer_oth4_rep3 := rpad(lpad('.00,',10), 4*12, lpad('.00,',10));
1032:
1033: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
1034: hr_utility.trace('p_fail = '||p_fail);
1035: hr_utility.trace('t_dbi.COUNT = '||t_dbi.COUNT);
1036:
1037: for i in 1..t_dbi.COUNT

Line 1034: hr_utility.trace('p_fail = '||p_fail);

1030: l_transfer_oth3_rep2 := rpad(lpad('.00,',10), 10*12, lpad('.00,',10));
1031: l_transfer_oth4_rep3 := rpad(lpad('.00,',10), 4*12, lpad('.00,',10));
1032:
1033: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
1034: hr_utility.trace('p_fail = '||p_fail);
1035: hr_utility.trace('t_dbi.COUNT = '||t_dbi.COUNT);
1036:
1037: for i in 1..t_dbi.COUNT
1038: loop

Line 1035: hr_utility.trace('t_dbi.COUNT = '||t_dbi.COUNT);

1031: l_transfer_oth4_rep3 := rpad(lpad('.00,',10), 4*12, lpad('.00,',10));
1032:
1033: hr_utility.trace('p_assignment_action_id = '||p_assignment_action_id);
1034: hr_utility.trace('p_fail = '||p_fail);
1035: hr_utility.trace('t_dbi.COUNT = '||t_dbi.COUNT);
1036:
1037: for i in 1..t_dbi.COUNT
1038: loop
1039: l_amt := fnd_number.canonical_to_number(get_dbitem_value(p_assignment_action_id,t_dbi(i)));

Line 1047: hr_utility.trace('sqlerrm at multiply = '||sqlerrm);

1043: l_tot_oth_info_amt := l_tot_oth_info_amt + (l_amt * t_flag(i));
1044: end if;
1045: exception
1046: when others then
1047: hr_utility.trace('sqlerrm at multiply = '||sqlerrm);
1048: end;
1049:
1050: if (p_fail <> 'Y') and (l_amt >0)
1051: and t_dbi(i) <> 'CAEOY_T4A_EMPLOYEE_REGISTRATION_NO'

Line 1224: hr_utility.trace('1 p_transfer_oth1_rep1 = '||p_transfer_oth1_rep1);

1220:
1221: p_transfer_oth4_rep3 := substr(l_transfer_oth4_rep3,1,240);
1222: p_transfer_oth4_rep3_dummy := substr(l_transfer_oth4_rep3,241,480);
1223:
1224: hr_utility.trace('1 p_transfer_oth1_rep1 = '||p_transfer_oth1_rep1);
1225: hr_utility.trace('1 p_transfer_oth1_rep2 = '||p_transfer_oth1_rep2);
1226: hr_utility.trace('1 p_transfer_oth1_rep3 = '||p_transfer_oth1_rep3);
1227: hr_utility.trace('1 p_transfer_oth2_rep2 = '||p_transfer_oth2_rep2);
1228: hr_utility.trace('1 p_transfer_oth2_rep3 = '||p_transfer_oth2_rep3);

Line 1225: hr_utility.trace('1 p_transfer_oth1_rep2 = '||p_transfer_oth1_rep2);

1221: p_transfer_oth4_rep3 := substr(l_transfer_oth4_rep3,1,240);
1222: p_transfer_oth4_rep3_dummy := substr(l_transfer_oth4_rep3,241,480);
1223:
1224: hr_utility.trace('1 p_transfer_oth1_rep1 = '||p_transfer_oth1_rep1);
1225: hr_utility.trace('1 p_transfer_oth1_rep2 = '||p_transfer_oth1_rep2);
1226: hr_utility.trace('1 p_transfer_oth1_rep3 = '||p_transfer_oth1_rep3);
1227: hr_utility.trace('1 p_transfer_oth2_rep2 = '||p_transfer_oth2_rep2);
1228: hr_utility.trace('1 p_transfer_oth2_rep3 = '||p_transfer_oth2_rep3);
1229: hr_utility.trace('1 p_transfer_oth3_rep2 = '||p_transfer_oth3_rep2);

Line 1226: hr_utility.trace('1 p_transfer_oth1_rep3 = '||p_transfer_oth1_rep3);

1222: p_transfer_oth4_rep3_dummy := substr(l_transfer_oth4_rep3,241,480);
1223:
1224: hr_utility.trace('1 p_transfer_oth1_rep1 = '||p_transfer_oth1_rep1);
1225: hr_utility.trace('1 p_transfer_oth1_rep2 = '||p_transfer_oth1_rep2);
1226: hr_utility.trace('1 p_transfer_oth1_rep3 = '||p_transfer_oth1_rep3);
1227: hr_utility.trace('1 p_transfer_oth2_rep2 = '||p_transfer_oth2_rep2);
1228: hr_utility.trace('1 p_transfer_oth2_rep3 = '||p_transfer_oth2_rep3);
1229: hr_utility.trace('1 p_transfer_oth3_rep2 = '||p_transfer_oth3_rep2);
1230: hr_utility.trace('1 p_transfer_oth3_rep3 = '||p_transfer_oth3_rep3);

Line 1227: hr_utility.trace('1 p_transfer_oth2_rep2 = '||p_transfer_oth2_rep2);

1223:
1224: hr_utility.trace('1 p_transfer_oth1_rep1 = '||p_transfer_oth1_rep1);
1225: hr_utility.trace('1 p_transfer_oth1_rep2 = '||p_transfer_oth1_rep2);
1226: hr_utility.trace('1 p_transfer_oth1_rep3 = '||p_transfer_oth1_rep3);
1227: hr_utility.trace('1 p_transfer_oth2_rep2 = '||p_transfer_oth2_rep2);
1228: hr_utility.trace('1 p_transfer_oth2_rep3 = '||p_transfer_oth2_rep3);
1229: hr_utility.trace('1 p_transfer_oth3_rep2 = '||p_transfer_oth3_rep2);
1230: hr_utility.trace('1 p_transfer_oth3_rep3 = '||p_transfer_oth3_rep3);
1231: hr_utility.trace('1 p_transfer_oth1_rep1_dummy = '||p_transfer_oth1_rep1_dummy);

Line 1228: hr_utility.trace('1 p_transfer_oth2_rep3 = '||p_transfer_oth2_rep3);

1224: hr_utility.trace('1 p_transfer_oth1_rep1 = '||p_transfer_oth1_rep1);
1225: hr_utility.trace('1 p_transfer_oth1_rep2 = '||p_transfer_oth1_rep2);
1226: hr_utility.trace('1 p_transfer_oth1_rep3 = '||p_transfer_oth1_rep3);
1227: hr_utility.trace('1 p_transfer_oth2_rep2 = '||p_transfer_oth2_rep2);
1228: hr_utility.trace('1 p_transfer_oth2_rep3 = '||p_transfer_oth2_rep3);
1229: hr_utility.trace('1 p_transfer_oth3_rep2 = '||p_transfer_oth3_rep2);
1230: hr_utility.trace('1 p_transfer_oth3_rep3 = '||p_transfer_oth3_rep3);
1231: hr_utility.trace('1 p_transfer_oth1_rep1_dummy = '||p_transfer_oth1_rep1_dummy);
1232: hr_utility.trace('1 p_transfer_oth1_rep2_dummy = '||p_transfer_oth1_rep2_dummy);

Line 1229: hr_utility.trace('1 p_transfer_oth3_rep2 = '||p_transfer_oth3_rep2);

1225: hr_utility.trace('1 p_transfer_oth1_rep2 = '||p_transfer_oth1_rep2);
1226: hr_utility.trace('1 p_transfer_oth1_rep3 = '||p_transfer_oth1_rep3);
1227: hr_utility.trace('1 p_transfer_oth2_rep2 = '||p_transfer_oth2_rep2);
1228: hr_utility.trace('1 p_transfer_oth2_rep3 = '||p_transfer_oth2_rep3);
1229: hr_utility.trace('1 p_transfer_oth3_rep2 = '||p_transfer_oth3_rep2);
1230: hr_utility.trace('1 p_transfer_oth3_rep3 = '||p_transfer_oth3_rep3);
1231: hr_utility.trace('1 p_transfer_oth1_rep1_dummy = '||p_transfer_oth1_rep1_dummy);
1232: hr_utility.trace('1 p_transfer_oth1_rep2_dummy = '||p_transfer_oth1_rep2_dummy);
1233: hr_utility.trace('1 p_transfer_oth1_rep3_dummy = '||p_transfer_oth1_rep3_dummy);

Line 1230: hr_utility.trace('1 p_transfer_oth3_rep3 = '||p_transfer_oth3_rep3);

1226: hr_utility.trace('1 p_transfer_oth1_rep3 = '||p_transfer_oth1_rep3);
1227: hr_utility.trace('1 p_transfer_oth2_rep2 = '||p_transfer_oth2_rep2);
1228: hr_utility.trace('1 p_transfer_oth2_rep3 = '||p_transfer_oth2_rep3);
1229: hr_utility.trace('1 p_transfer_oth3_rep2 = '||p_transfer_oth3_rep2);
1230: hr_utility.trace('1 p_transfer_oth3_rep3 = '||p_transfer_oth3_rep3);
1231: hr_utility.trace('1 p_transfer_oth1_rep1_dummy = '||p_transfer_oth1_rep1_dummy);
1232: hr_utility.trace('1 p_transfer_oth1_rep2_dummy = '||p_transfer_oth1_rep2_dummy);
1233: hr_utility.trace('1 p_transfer_oth1_rep3_dummy = '||p_transfer_oth1_rep3_dummy);
1234: hr_utility.trace('1 p_transfer_oth2_rep2_dummy = '||p_transfer_oth2_rep2_dummy);

Line 1231: hr_utility.trace('1 p_transfer_oth1_rep1_dummy = '||p_transfer_oth1_rep1_dummy);

1227: hr_utility.trace('1 p_transfer_oth2_rep2 = '||p_transfer_oth2_rep2);
1228: hr_utility.trace('1 p_transfer_oth2_rep3 = '||p_transfer_oth2_rep3);
1229: hr_utility.trace('1 p_transfer_oth3_rep2 = '||p_transfer_oth3_rep2);
1230: hr_utility.trace('1 p_transfer_oth3_rep3 = '||p_transfer_oth3_rep3);
1231: hr_utility.trace('1 p_transfer_oth1_rep1_dummy = '||p_transfer_oth1_rep1_dummy);
1232: hr_utility.trace('1 p_transfer_oth1_rep2_dummy = '||p_transfer_oth1_rep2_dummy);
1233: hr_utility.trace('1 p_transfer_oth1_rep3_dummy = '||p_transfer_oth1_rep3_dummy);
1234: hr_utility.trace('1 p_transfer_oth2_rep2_dummy = '||p_transfer_oth2_rep2_dummy);
1235: hr_utility.trace('1 p_transfer_oth2_rep3_dummy = '||p_transfer_oth2_rep3_dummy);

Line 1232: hr_utility.trace('1 p_transfer_oth1_rep2_dummy = '||p_transfer_oth1_rep2_dummy);

1228: hr_utility.trace('1 p_transfer_oth2_rep3 = '||p_transfer_oth2_rep3);
1229: hr_utility.trace('1 p_transfer_oth3_rep2 = '||p_transfer_oth3_rep2);
1230: hr_utility.trace('1 p_transfer_oth3_rep3 = '||p_transfer_oth3_rep3);
1231: hr_utility.trace('1 p_transfer_oth1_rep1_dummy = '||p_transfer_oth1_rep1_dummy);
1232: hr_utility.trace('1 p_transfer_oth1_rep2_dummy = '||p_transfer_oth1_rep2_dummy);
1233: hr_utility.trace('1 p_transfer_oth1_rep3_dummy = '||p_transfer_oth1_rep3_dummy);
1234: hr_utility.trace('1 p_transfer_oth2_rep2_dummy = '||p_transfer_oth2_rep2_dummy);
1235: hr_utility.trace('1 p_transfer_oth2_rep3_dummy = '||p_transfer_oth2_rep3_dummy);
1236: hr_utility.trace('1 p_transfer_oth3_rep2_dummy = '||p_transfer_oth3_rep2_dummy);

Line 1233: hr_utility.trace('1 p_transfer_oth1_rep3_dummy = '||p_transfer_oth1_rep3_dummy);

1229: hr_utility.trace('1 p_transfer_oth3_rep2 = '||p_transfer_oth3_rep2);
1230: hr_utility.trace('1 p_transfer_oth3_rep3 = '||p_transfer_oth3_rep3);
1231: hr_utility.trace('1 p_transfer_oth1_rep1_dummy = '||p_transfer_oth1_rep1_dummy);
1232: hr_utility.trace('1 p_transfer_oth1_rep2_dummy = '||p_transfer_oth1_rep2_dummy);
1233: hr_utility.trace('1 p_transfer_oth1_rep3_dummy = '||p_transfer_oth1_rep3_dummy);
1234: hr_utility.trace('1 p_transfer_oth2_rep2_dummy = '||p_transfer_oth2_rep2_dummy);
1235: hr_utility.trace('1 p_transfer_oth2_rep3_dummy = '||p_transfer_oth2_rep3_dummy);
1236: hr_utility.trace('1 p_transfer_oth3_rep2_dummy = '||p_transfer_oth3_rep2_dummy);
1237: hr_utility.trace('1 p_transfer_oth3_rep3_dummy = '||p_transfer_oth3_rep3_dummy);

Line 1234: hr_utility.trace('1 p_transfer_oth2_rep2_dummy = '||p_transfer_oth2_rep2_dummy);

1230: hr_utility.trace('1 p_transfer_oth3_rep3 = '||p_transfer_oth3_rep3);
1231: hr_utility.trace('1 p_transfer_oth1_rep1_dummy = '||p_transfer_oth1_rep1_dummy);
1232: hr_utility.trace('1 p_transfer_oth1_rep2_dummy = '||p_transfer_oth1_rep2_dummy);
1233: hr_utility.trace('1 p_transfer_oth1_rep3_dummy = '||p_transfer_oth1_rep3_dummy);
1234: hr_utility.trace('1 p_transfer_oth2_rep2_dummy = '||p_transfer_oth2_rep2_dummy);
1235: hr_utility.trace('1 p_transfer_oth2_rep3_dummy = '||p_transfer_oth2_rep3_dummy);
1236: hr_utility.trace('1 p_transfer_oth3_rep2_dummy = '||p_transfer_oth3_rep2_dummy);
1237: hr_utility.trace('1 p_transfer_oth3_rep3_dummy = '||p_transfer_oth3_rep3_dummy);
1238:

Line 1235: hr_utility.trace('1 p_transfer_oth2_rep3_dummy = '||p_transfer_oth2_rep3_dummy);

1231: hr_utility.trace('1 p_transfer_oth1_rep1_dummy = '||p_transfer_oth1_rep1_dummy);
1232: hr_utility.trace('1 p_transfer_oth1_rep2_dummy = '||p_transfer_oth1_rep2_dummy);
1233: hr_utility.trace('1 p_transfer_oth1_rep3_dummy = '||p_transfer_oth1_rep3_dummy);
1234: hr_utility.trace('1 p_transfer_oth2_rep2_dummy = '||p_transfer_oth2_rep2_dummy);
1235: hr_utility.trace('1 p_transfer_oth2_rep3_dummy = '||p_transfer_oth2_rep3_dummy);
1236: hr_utility.trace('1 p_transfer_oth3_rep2_dummy = '||p_transfer_oth3_rep2_dummy);
1237: hr_utility.trace('1 p_transfer_oth3_rep3_dummy = '||p_transfer_oth3_rep3_dummy);
1238:
1239: /*

Line 1236: hr_utility.trace('1 p_transfer_oth3_rep2_dummy = '||p_transfer_oth3_rep2_dummy);

1232: hr_utility.trace('1 p_transfer_oth1_rep2_dummy = '||p_transfer_oth1_rep2_dummy);
1233: hr_utility.trace('1 p_transfer_oth1_rep3_dummy = '||p_transfer_oth1_rep3_dummy);
1234: hr_utility.trace('1 p_transfer_oth2_rep2_dummy = '||p_transfer_oth2_rep2_dummy);
1235: hr_utility.trace('1 p_transfer_oth2_rep3_dummy = '||p_transfer_oth2_rep3_dummy);
1236: hr_utility.trace('1 p_transfer_oth3_rep2_dummy = '||p_transfer_oth3_rep2_dummy);
1237: hr_utility.trace('1 p_transfer_oth3_rep3_dummy = '||p_transfer_oth3_rep3_dummy);
1238:
1239: /*
1240: hr_utility.trace('p_cnt = '|| l_cnt);

Line 1237: hr_utility.trace('1 p_transfer_oth3_rep3_dummy = '||p_transfer_oth3_rep3_dummy);

1233: hr_utility.trace('1 p_transfer_oth1_rep3_dummy = '||p_transfer_oth1_rep3_dummy);
1234: hr_utility.trace('1 p_transfer_oth2_rep2_dummy = '||p_transfer_oth2_rep2_dummy);
1235: hr_utility.trace('1 p_transfer_oth2_rep3_dummy = '||p_transfer_oth2_rep3_dummy);
1236: hr_utility.trace('1 p_transfer_oth3_rep2_dummy = '||p_transfer_oth3_rep2_dummy);
1237: hr_utility.trace('1 p_transfer_oth3_rep3_dummy = '||p_transfer_oth3_rep3_dummy);
1238:
1239: /*
1240: hr_utility.trace('p_cnt = '|| l_cnt);
1241: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);

Line 1240: hr_utility.trace('p_cnt = '|| l_cnt);

1236: hr_utility.trace('1 p_transfer_oth3_rep2_dummy = '||p_transfer_oth3_rep2_dummy);
1237: hr_utility.trace('1 p_transfer_oth3_rep3_dummy = '||p_transfer_oth3_rep3_dummy);
1238:
1239: /*
1240: hr_utility.trace('p_cnt = '|| l_cnt);
1241: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
1242: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
1243: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
1244: hr_utility.trace('write_f30 = '|| l_write_f30);

Line 1241: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);

1237: hr_utility.trace('1 p_transfer_oth3_rep3_dummy = '||p_transfer_oth3_rep3_dummy);
1238:
1239: /*
1240: hr_utility.trace('p_cnt = '|| l_cnt);
1241: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
1242: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
1243: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
1244: hr_utility.trace('write_f30 = '|| l_write_f30);
1245: hr_utility.trace('p_write_f31 = '|| l_write_f31);

Line 1242: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);

1238:
1239: /*
1240: hr_utility.trace('p_cnt = '|| l_cnt);
1241: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
1242: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
1243: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
1244: hr_utility.trace('write_f30 = '|| l_write_f30);
1245: hr_utility.trace('p_write_f31 = '|| l_write_f31);
1246: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);

Line 1243: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);

1239: /*
1240: hr_utility.trace('p_cnt = '|| l_cnt);
1241: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
1242: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
1243: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
1244: hr_utility.trace('write_f30 = '|| l_write_f30);
1245: hr_utility.trace('p_write_f31 = '|| l_write_f31);
1246: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
1247: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);

Line 1244: hr_utility.trace('write_f30 = '|| l_write_f30);

1240: hr_utility.trace('p_cnt = '|| l_cnt);
1241: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
1242: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
1243: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
1244: hr_utility.trace('write_f30 = '|| l_write_f30);
1245: hr_utility.trace('p_write_f31 = '|| l_write_f31);
1246: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
1247: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
1248: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);

Line 1245: hr_utility.trace('p_write_f31 = '|| l_write_f31);

1241: hr_utility.trace('p_oth_rep1 = '|| l_oth_rep1);
1242: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
1243: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
1244: hr_utility.trace('write_f30 = '|| l_write_f30);
1245: hr_utility.trace('p_write_f31 = '|| l_write_f31);
1246: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
1247: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
1248: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
1249: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);

Line 1246: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);

1242: hr_utility.trace('p_oth_rep2 = '|| l_oth_rep2);
1243: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
1244: hr_utility.trace('write_f30 = '|| l_write_f30);
1245: hr_utility.trace('p_write_f31 = '|| l_write_f31);
1246: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
1247: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
1248: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
1249: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
1250: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);

Line 1247: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);

1243: hr_utility.trace('p_oth_rep3 = '|| l_oth_rep3);
1244: hr_utility.trace('write_f30 = '|| l_write_f30);
1245: hr_utility.trace('p_write_f31 = '|| l_write_f31);
1246: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
1247: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
1248: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
1249: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
1250: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
1251: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);

Line 1248: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);

1244: hr_utility.trace('write_f30 = '|| l_write_f30);
1245: hr_utility.trace('p_write_f31 = '|| l_write_f31);
1246: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
1247: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
1248: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
1249: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
1250: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
1251: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
1252: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);

Line 1249: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);

1245: hr_utility.trace('p_write_f31 = '|| l_write_f31);
1246: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
1247: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
1248: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
1249: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
1250: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
1251: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
1252: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
1253: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);

Line 1250: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);

1246: hr_utility.trace('p_transfer_other_info1_str1 = '|| l_transfer_other_info1_str1);
1247: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
1248: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
1249: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
1250: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
1251: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
1252: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
1253: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
1254: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);

Line 1251: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);

1247: hr_utility.trace('p_transfer_other_info1_str2 = '|| l_transfer_other_info1_str2);
1248: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
1249: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
1250: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
1251: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
1252: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
1253: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
1254: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
1255: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);

Line 1252: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);

1248: hr_utility.trace('p_transfer_other_info1_str3 = '|| l_transfer_other_info1_str3);
1249: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
1250: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
1251: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
1252: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
1253: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
1254: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
1255: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
1256: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);

Line 1253: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);

1249: hr_utility.trace('p_transfer_other_info2_str1 = '|| l_transfer_other_info2_str1);
1250: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
1251: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
1252: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
1253: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
1254: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
1255: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
1256: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
1257: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);

Line 1254: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);

1250: hr_utility.trace('p_transfer_other_info2_str2 = '|| l_transfer_other_info2_str2);
1251: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
1252: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
1253: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
1254: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
1255: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
1256: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
1257: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
1258: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);

Line 1255: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);

1251: hr_utility.trace('p_transfer_other_info2_str3 = '|| l_transfer_other_info2_str3);
1252: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
1253: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
1254: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
1255: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
1256: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
1257: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
1258: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
1259: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);

Line 1256: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);

1252: hr_utility.trace('p_transfer_other_info3_str1 = '|| l_transfer_other_info3_str1);
1253: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
1254: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
1255: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
1256: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
1257: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
1258: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
1259: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
1260: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);

Line 1257: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);

1253: hr_utility.trace('p_transfer_other_info3_str2 = '|| l_transfer_other_info3_str2);
1254: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
1255: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
1256: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
1257: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
1258: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
1259: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
1260: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
1261: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);

Line 1258: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);

1254: hr_utility.trace('p_transfer_other_info3_str3 = '|| l_transfer_other_info3_str3);
1255: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
1256: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
1257: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
1258: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
1259: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
1260: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
1261: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
1262: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);

Line 1259: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);

1255: hr_utility.trace('p_transfer_other_info4_str1 = '|| l_transfer_other_info4_str1);
1256: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
1257: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
1258: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
1259: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
1260: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
1261: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
1262: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
1263: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);

Line 1260: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);

1256: hr_utility.trace('p_transfer_other_info4_str2 = '|| l_transfer_other_info4_str2);
1257: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
1258: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
1259: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
1260: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
1261: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
1262: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
1263: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
1264: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);

Line 1261: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);

1257: hr_utility.trace('p_transfer_other_info4_str3 = '|| l_transfer_other_info4_str3);
1258: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
1259: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
1260: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
1261: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
1262: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
1263: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
1264: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
1265: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);

Line 1262: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);

1258: hr_utility.trace('p_transfer_oth1_rep1 = '|| l_transfer_oth1_rep1);
1259: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
1260: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
1261: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
1262: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
1263: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
1264: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
1265: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
1266:

Line 1263: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);

1259: hr_utility.trace('p_transfer_oth1_rep2 = '|| l_transfer_oth1_rep2);
1260: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
1261: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
1262: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
1263: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
1264: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
1265: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
1266:
1267: */

Line 1264: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);

1260: hr_utility.trace('p_transfer_oth1_rep3 = '|| l_transfer_oth1_rep3);
1261: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
1262: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
1263: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
1264: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
1265: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
1266:
1267: */
1268:

Line 1265: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);

1261: hr_utility.trace('p_transfer_oth2_rep2 = '|| l_transfer_oth2_rep2);
1262: hr_utility.trace('p_transfer_oth2_rep3 = '|| l_transfer_oth2_rep3);
1263: hr_utility.trace('p_transfer_oth3_rep2 = '|| l_transfer_oth3_rep2);
1264: hr_utility.trace('p_transfer_oth3_rep3 = '|| l_transfer_oth3_rep3);
1265: hr_utility.trace('p_transfer_oth4_rep3 = '|| l_transfer_oth4_rep3);
1266:
1267: */
1268:
1269: return l_write_f30;