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

Line 25: Uses : hr_utility

21:
22: Description : This package holds building blocks used in the generation
23: of nacha IAT Tape.
24:
25: Uses : hr_utility
26:
27: Change List
28: -----------
29: Date Name Vers Bug No Description

Line 152: hr_utility.set_location('pay_us_nacha_tape.get_formula_id', 1);

148: FUNCTION get_formula_id (p_formula_name VARCHAR2)
149: RETURN VARCHAR2 IS
150: ff_formula_id VARCHAR2(9);
151: BEGIN
152: hr_utility.set_location('pay_us_nacha_tape.get_formula_id', 1);
153: --
154: SELECT TO_CHAR(FORMULA_ID) INTO ff_formula_id
155: FROM FF_FORMULAS_F
156: WHERE p_effective_date BETWEEN EFFECTIVE_START_DATE AND

Line 160: hr_utility.TRACE('Formula ID : '|| ff_formula_id);

156: WHERE p_effective_date BETWEEN EFFECTIVE_START_DATE AND
157: EFFECTIVE_END_DATE
158: AND FORMULA_NAME = p_formula_name;
159: --
160: hr_utility.TRACE('Formula ID : '|| ff_formula_id);
161: RETURN ff_formula_id;
162: EXCEPTION
163: WHEN no_data_found THEN
164: hr_utility.set_message(801, 'FFX37_FORMULA_NOT_FOUND');

Line 164: hr_utility.set_message(801, 'FFX37_FORMULA_NOT_FOUND');

160: hr_utility.TRACE('Formula ID : '|| ff_formula_id);
161: RETURN ff_formula_id;
162: EXCEPTION
163: WHEN no_data_found THEN
164: hr_utility.set_message(801, 'FFX37_FORMULA_NOT_FOUND');
165: hr_utility.set_message_token('1', p_formula_name);
166: hr_utility.raise_error;
167: END get_formula_id;
168:

Line 165: hr_utility.set_message_token('1', p_formula_name);

161: RETURN ff_formula_id;
162: EXCEPTION
163: WHEN no_data_found THEN
164: hr_utility.set_message(801, 'FFX37_FORMULA_NOT_FOUND');
165: hr_utility.set_message_token('1', p_formula_name);
166: hr_utility.raise_error;
167: END get_formula_id;
168:
169:

Line 166: hr_utility.raise_error;

162: EXCEPTION
163: WHEN no_data_found THEN
164: hr_utility.set_message(801, 'FFX37_FORMULA_NOT_FOUND');
165: hr_utility.set_message_token('1', p_formula_name);
166: hr_utility.raise_error;
167: END get_formula_id;
168:
169:
170: /* ***************************************************************

Line 183: hr_utility.set_location('pay_us_nacha_tape.get_effective_date', 20);

179: FUNCTION get_transfer_param (p_param_name VARCHAR2 )
180: RETURN NUMBER IS
181: param_value NUMBER;
182: BEGIN
183: hr_utility.set_location('pay_us_nacha_tape.get_effective_date', 20);
184: IF pay_mag_tape.internal_prm_names(3) = p_param_name
185: THEN
186: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3));
187: ELSIF pay_mag_tape.internal_prm_names(4) = p_param_name

Line 213: hr_utility.TRACE('Writing File Header');

209: PROCEDURE write_file_header IS
210:
211: BEGIN
212:
213: hr_utility.TRACE('Writing File Header');
214: hr_utility.TRACE('.... Writing File Header Context');
215:
216: pay_mag_tape.internal_cxt_values(1) := '3';
217: pay_mag_tape.internal_cxt_names(2) := 'ORG_PAY_METHOD_ID';

Line 214: hr_utility.TRACE('.... Writing File Header Context');

210:
211: BEGIN
212:
213: hr_utility.TRACE('Writing File Header');
214: hr_utility.TRACE('.... Writing File Header Context');
215:
216: pay_mag_tape.internal_cxt_values(1) := '3';
217: pay_mag_tape.internal_cxt_names(2) := 'ORG_PAY_METHOD_ID';
218: pay_mag_tape.internal_cxt_values(2) := g_org_payment_method_id;

Line 222: hr_utility.TRACE('.... Writing File Header Parameters');

218: pay_mag_tape.internal_cxt_values(2) := g_org_payment_method_id;
219: pay_mag_tape.internal_cxt_names(3) := 'DATE_EARNED';
220: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);
221: --
222: hr_utility.TRACE('.... Writing File Header Parameters');
223: hr_utility.TRACE('g_file_header ' || g_file_header);
224:
225: pay_mag_tape.internal_prm_values(1) := '5';
226: pay_mag_tape.internal_prm_values(2) := g_file_header;

Line 223: hr_utility.TRACE('g_file_header ' || g_file_header);

219: pay_mag_tape.internal_cxt_names(3) := 'DATE_EARNED';
220: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);
221: --
222: hr_utility.TRACE('.... Writing File Header Parameters');
223: hr_utility.TRACE('g_file_header ' || g_file_header);
224:
225: pay_mag_tape.internal_prm_values(1) := '5';
226: pay_mag_tape.internal_prm_values(2) := g_file_header;
227: pay_mag_tape.internal_prm_names(3) := 'FILE_ID_MODIFIER';

Line 234: hr_utility.TRACE('Leaving File Header');

230: pay_mag_tape.internal_prm_values(4) := g_date;
231: pay_mag_tape.internal_prm_names(5) := 'CREATION_TIME';
232: pay_mag_tape.internal_prm_values(5) := g_time;
233:
234: hr_utility.TRACE('Leaving File Header');
235:
236: hr_utility.set_location('run_formula.File_head', 6);
237:
238: END; /* end write_file_header */

Line 236: hr_utility.set_location('run_formula.File_head', 6);

232: pay_mag_tape.internal_prm_values(5) := g_time;
233:
234: hr_utility.TRACE('Leaving File Header');
235:
236: hr_utility.set_location('run_formula.File_head', 6);
237:
238: END; /* end write_file_header */
239:
240: --==================================================

Line 247: hr_utility.TRACE('Writing IAT Batch Header');

243: PROCEDURE write_batch_header
244: IS
245:
246: BEGIN
247: hr_utility.TRACE('Writing IAT Batch Header');
248:
249: g_overflow_batch := 'N';
250: hr_utility.TRACE('....IAT g_overflow_batch is : '|| g_overflow_batch);
251:

Line 250: hr_utility.TRACE('....IAT g_overflow_batch is : '|| g_overflow_batch);

246: BEGIN
247: hr_utility.TRACE('Writing IAT Batch Header');
248:
249: g_overflow_batch := 'N';
250: hr_utility.TRACE('....IAT g_overflow_batch is : '|| g_overflow_batch);
251:
252: --Two different cursors are used based on the oracle db version for performance improvement
253: IF (nvl(hr_general2.get_oracle_db_version, 0) < 10.0) THEN
254: OPEN csr_assignments (g_legal_company_id,

Line 270: hr_utility.TRACE('.... Writing IAT Batch Header Context');

266: g_batch_number := g_batch_number + 1;
267:
268: -- Context for NACHA_BATCH_HEADER
269: -- first context is number of contexts
270: hr_utility.TRACE('.... Writing IAT Batch Header Context');
271:
272: pay_mag_tape.internal_cxt_values(1) := '4';
273: pay_mag_tape.internal_cxt_names(2) := 'TAX_UNIT_ID';
274: pay_mag_tape.internal_cxt_values(2) := TO_CHAR(g_legal_company_id);

Line 283: hr_utility.TRACE('.... Writing Batch Header Parameters');

279:
280: -- Parameters for NACHA_BATCH_HEADER
281: -- first parameter is number of parameters
282: -- second parameter is formula is
283: hr_utility.TRACE('.... Writing Batch Header Parameters');
284:
285: pay_mag_tape.internal_prm_values(1) := '6';
286: pay_mag_tape.internal_prm_values(2) := g_batch_header;
287:

Line 302: hr_utility.TRACE('Leaving Batch Header');

298: pay_mag_tape.internal_prm_values(6) := 'IAT';
299:
300:
301:
302: hr_utility.TRACE('Leaving Batch Header');
303:
304: END; /* write_batch_header */
305:
306: --=========================================

Line 322: hr_utility.TRACE('Writing Entry Detail');

318: PROCEDURE write_entry_detail IS
319:
320: BEGIN
321:
322: hr_utility.TRACE('Writing Entry Detail');
323:
324: hr_utility.TRACE('.... Writing Entry Detail Context');
325: g_count := g_count + 1;
326:

Line 324: hr_utility.TRACE('.... Writing Entry Detail Context');

320: BEGIN
321:
322: hr_utility.TRACE('Writing Entry Detail');
323:
324: hr_utility.TRACE('.... Writing Entry Detail Context');
325: g_count := g_count + 1;
326:
327:
328: hr_utility.TRACE('Entry Detail : g_hash ' || g_hash);

Line 328: hr_utility.TRACE('Entry Detail : g_hash ' || g_hash);

324: hr_utility.TRACE('.... Writing Entry Detail Context');
325: g_count := g_count + 1;
326:
327:
328: hr_utility.TRACE('Entry Detail : g_hash ' || g_hash);
329: --
330:
331: -- Context Setup for NACHA_ENTRY_DETAIL
332: -- First context value is number of contexts

Line 346: hr_utility.TRACE('.... Writing Entry Detail Parameters');

342: -- Parameter Setup for NACHA_ENTRY_DETAIL
343: -- First parameter value is number of parameters
344: -- second parameter value is formula id
345:
346: hr_utility.TRACE('.... Writing Entry Detail Parameters');
347:
348: pay_mag_tape.internal_prm_values(1) := '8';
349: pay_mag_tape.internal_prm_values(2) := g_entry_detail;
350:

Line 365: hr_utility.set_location('run_formula.Assignment', 8);

361: pay_mag_tape.internal_prm_values(7) := '0';*/
362:
363:
364: g_temp_count := 1;
365: hr_utility.set_location('run_formula.Assignment', 8);
366:
367: END IF;
368:
369: -- Parameters 3-5 are transferred from previous formula

Line 382: hr_utility.set_location('run_formula.Assignment', 7);

378:
379: pay_mag_tape.internal_prm_names(8) := 'TEST_FILE';
380: pay_mag_tape.internal_prm_values(8) := p_test_file;
381:
382: hr_utility.set_location('run_formula.Assignment', 7);
383:
384:
385:
386: g_addenda_write := 'Y';

Line 404: hr_utility.TRACE('Entry Detail : TRANSFER_ENTRY_HASH ' || get_transfer_param ('TRANSFER_ENTRY_HASH'));

400: AND p_effective_date BETWEEN b.EFFECTIVE_START_DATE
401: AND b.EFFECTIVE_END_DATE);
402: END IF;
403:
404: hr_utility.TRACE('Entry Detail : TRANSFER_ENTRY_HASH ' || get_transfer_param ('TRANSFER_ENTRY_HASH'));
405:
406: hr_utility.TRACE('Leaving Entry Detail');
407:
408: END; /* write_entry_detail */

Line 406: hr_utility.TRACE('Leaving Entry Detail');

402: END IF;
403:
404: hr_utility.TRACE('Entry Detail : TRANSFER_ENTRY_HASH ' || get_transfer_param ('TRANSFER_ENTRY_HASH'));
405:
406: hr_utility.TRACE('Leaving Entry Detail');
407:
408: END; /* write_entry_detail */
409:
410: /******************************************************************

Line 423: hr_utility.TRACE('Writing Org Entry Detail');

419: PROCEDURE write_org_entry_detail IS
420:
421: BEGIN
422:
423: hr_utility.TRACE('Writing Org Entry Detail');
424:
425: IF g_nacha_balance_flag = 'Y' THEN
426: g_count := g_count + 1;
427: g_addenda_write := 'Y';

Line 440: hr_utility.TRACE('.... Writing Org Entry Detail Context');

436: END IF;
437:
438: -- Context Setup for NACHA_ORG_PAY_ENTRY_DETAIL
439: -- first context is number of context values
440: hr_utility.TRACE('.... Writing Org Entry Detail Context');
441:
442: pay_mag_tape.internal_cxt_values(1) := '3';
443: pay_mag_tape.internal_cxt_names(2) := 'ORG_PAY_METHOD_ID';
444: pay_mag_tape.internal_cxt_values(2) := g_csr_org_pay_meth_id;

Line 451: hr_utility.TRACE('.... Writing Org Entry Detail Parameters');

447:
448: -- Parameter Setup for NACHA_ORG_PAY_ENTRY_DETAIL
449: -- first parameter is number of parameters
450: -- second parameter is formula id
451: hr_utility.TRACE('.... Writing Org Entry Detail Parameters');
452:
453: pay_mag_tape.internal_prm_values(1) := '8';
454: pay_mag_tape.internal_prm_values(2) := g_org_pay_entry_detail;
455:

Line 477: hr_utility.set_location('run_formula.org_pay_entry_detail', 9);

473: CLOSE csr_assignments;
474: ELSE
475: CLOSE csr_assignments_no_rule;
476: END IF;
477: hr_utility.set_location('run_formula.org_pay_entry_detail', 9);
478:
479: hr_utility.TRACE('Leaving Org Entry Detail');
480:
481: END; /* write_org_entry_detail */

Line 479: hr_utility.TRACE('Leaving Org Entry Detail');

475: CLOSE csr_assignments_no_rule;
476: END IF;
477: hr_utility.set_location('run_formula.org_pay_entry_detail', 9);
478:
479: hr_utility.TRACE('Leaving Org Entry Detail');
480:
481: END; /* write_org_entry_detail */
482:
483:

Line 498: hr_utility.TRACE('Writing IAT Addenda');

494: PROCEDURE write_addenda IS
495:
496: BEGIN
497:
498: hr_utility.TRACE('Writing IAT Addenda');
499:
500: g_addenda_num := g_addenda_num - 1;
501:
502: IF g_addenda_num = 0 THEN

Line 506: hr_utility.TRACE('g_addenda_num ' || g_addenda_num);

502: IF g_addenda_num = 0 THEN
503: g_addenda_write := 'N';
504: END IF;
505:
506: hr_utility.TRACE('g_addenda_num ' || g_addenda_num);
507:
508: IF g_addenda_num = 6 THEN
509:
510: hr_utility.TRACE('First Addenda');

Line 510: hr_utility.TRACE('First Addenda');

506: hr_utility.TRACE('g_addenda_num ' || g_addenda_num);
507:
508: IF g_addenda_num = 6 THEN
509:
510: hr_utility.TRACE('First Addenda');
511:
512: pay_mag_tape.internal_cxt_values(1) := '3';
513:
514: pay_mag_tape.internal_cxt_names(2) := 'DATE_EARNED';

Line 550: hr_utility.TRACE('Second Addenda');

546: pay_mag_tape.internal_prm_values(11) := g_org_addenda;
547:
548: ELSIF g_addenda_num = 5 THEN
549:
550: hr_utility.TRACE('Second Addenda');
551:
552: g_addenda := get_formula_id('NACHA_IAT_ADDENDA2');
553: pay_mag_tape.internal_prm_values(1) := '9';
554: pay_mag_tape.internal_prm_values(2) := g_addenda;

Line 573: hr_utility.TRACE('Third Addenda');

569: pay_mag_tape.internal_prm_values(9) := g_street_address;
570:
571: ELSIF g_addenda_num = 4 THEN
572:
573: hr_utility.TRACE('Third Addenda');
574:
575: g_addenda := get_formula_id('NACHA_IAT_ADDENDA3');
576: pay_mag_tape.internal_prm_values(1) := '9';
577: pay_mag_tape.internal_prm_values(2) := g_addenda;

Line 600: hr_utility.TRACE('Fourth Addenda');

596: pay_mag_tape.internal_prm_values(9) := g_country || get_addr_delim(g_postal_code) || g_postal_code || '\';
597:
598: ELSIF g_addenda_num = 3 THEN
599:
600: hr_utility.TRACE('Fourth Addenda');
601:
602: pay_mag_tape.internal_cxt_values(1) := '3';
603:
604: pay_mag_tape.internal_cxt_names(2) := 'DATE_EARNED';

Line 610: hr_utility.TRACE('Fourth Addenda');

606:
607: pay_mag_tape.internal_cxt_names(3) := 'ORG_PAY_METHOD_ID';
608: pay_mag_tape.internal_cxt_values(3) := g_org_payment_method_id;
609:
610: hr_utility.TRACE('Fourth Addenda');
611: g_addenda := get_formula_id('NACHA_IAT_ADDENDA4');
612: pay_mag_tape.internal_prm_values(1) := '7';
613: pay_mag_tape.internal_prm_values(2) := g_addenda;
614:

Line 629: hr_utility.TRACE('Fifth Addenda');

625: pay_mag_tape.internal_prm_values(7) := to_char(g_count);
626:
627: ELSIF g_addenda_num = 2 THEN
628:
629: hr_utility.TRACE('Fifth Addenda');
630:
631: g_addenda := get_formula_id('NACHA_IAT_ADDENDA5');
632:
633: pay_mag_tape.internal_cxt_values(1) := '4';

Line 665: hr_utility.TRACE('Sixth Addenda');

661:
662:
663: ELSIF g_addenda_num = 1 THEN
664:
665: hr_utility.TRACE('Sixth Addenda');
666:
667: pay_mag_tape.internal_cxt_values(1) := '3';
668:
669: pay_mag_tape.internal_cxt_names(2) := 'DATE_EARNED';

Line 701: hr_utility.TRACE('Seventh Addenda');

697: pay_mag_tape.internal_prm_values(10) := g_org_addenda;
698:
699: ELSIF g_addenda_num = 0 THEN
700:
701: hr_utility.TRACE('Seventh Addenda');
702:
703: pay_mag_tape.internal_cxt_values(1) := '3';
704:
705: pay_mag_tape.internal_cxt_names(2) := 'DATE_EARNED';

Line 739: hr_utility.TRACE('No Addenda Records to Write');

735: g_org_addenda := 'N';
736:
737: ELSE
738:
739: hr_utility.TRACE('No Addenda Records to Write');
740:
741: END IF;
742:
743:

Line 748: hr_utility.TRACE('Leaving Addenda');

744: -- we do not change the count till after so we can have the same trace number
745: -- in both entry detail and addenda rec
746: g_addenda_count := g_addenda_count + 1;
747:
748: hr_utility.TRACE('Leaving Addenda');
749:
750: END; /* write_addenda */
751:
752:

Line 766: hr_utility.TRACE('Writing IAT Batch Control');

762:
763: PROCEDURE write_batch_control IS
764:
765: BEGIN
766: hr_utility.TRACE('Writing IAT Batch Control');
767:
768: g_batch_control_write := 'N';
769:
770: g_hash := g_hash + get_transfer_param ('TRANSFER_ENTRY_HASH');

Line 772: hr_utility.TRACE('Batch Control : g_hash ' || g_hash);

768: g_batch_control_write := 'N';
769:
770: g_hash := g_hash + get_transfer_param ('TRANSFER_ENTRY_HASH');
771:
772: hr_utility.TRACE('Batch Control : g_hash ' || g_hash);
773: hr_utility.TRACE('Batch Control : TRANSFER_ENTRY_HASH ' || get_transfer_param ('TRANSFER_ENTRY_HASH'));
774:
775: g_amount := g_amount + get_transfer_param ('TRANSFER_CREDIT_AMOUNT');
776:

Line 773: hr_utility.TRACE('Batch Control : TRANSFER_ENTRY_HASH ' || get_transfer_param ('TRANSFER_ENTRY_HASH'));

769:
770: g_hash := g_hash + get_transfer_param ('TRANSFER_ENTRY_HASH');
771:
772: hr_utility.TRACE('Batch Control : g_hash ' || g_hash);
773: hr_utility.TRACE('Batch Control : TRANSFER_ENTRY_HASH ' || get_transfer_param ('TRANSFER_ENTRY_HASH'));
774:
775: g_amount := g_amount + get_transfer_param ('TRANSFER_CREDIT_AMOUNT');
776:
777: -- Context Setup for NACHA_BATCH_CONTROL

Line 780: hr_utility.TRACE('.... Writing Batch Control Context');

776:
777: -- Context Setup for NACHA_BATCH_CONTROL
778: -- First context value is number of context values
779:
780: hr_utility.TRACE('.... Writing Batch Control Context');
781:
782: pay_mag_tape.internal_cxt_values(1) := '4';
783: pay_mag_tape.internal_cxt_names(2) := 'TAX_UNIT_ID';
784: pay_mag_tape.internal_cxt_values(2) := TO_CHAR(g_legal_company_id);

Line 793: hr_utility.TRACE('.... Writing Batch Control Parameters');

789:
790: -- Parameter Setup for NACHA_BATCH_CONTROL
791: -- First parameter value is number of parameters
792:
793: hr_utility.TRACE('.... Writing Batch Control Parameters');
794:
795: pay_mag_tape.internal_prm_values(1) := '6';
796: pay_mag_tape.internal_prm_values(2) := g_batch_control;
797:

Line 807: hr_utility.set_location('run_formula.Batch_ctrl', 9);

803:
804: pay_mag_tape.internal_prm_names(6) := 'BATCH_NUMBER';
805: pay_mag_tape.internal_prm_values(6) := TO_CHAR(g_batch_number);
806:
807: hr_utility.set_location('run_formula.Batch_ctrl', 9);
808:
809: hr_utility.TRACE('Leaving Batch Control');
810:
811: END; /* write_batch_control */

Line 809: hr_utility.TRACE('Leaving Batch Control');

805: pay_mag_tape.internal_prm_values(6) := TO_CHAR(g_batch_number);
806:
807: hr_utility.set_location('run_formula.Batch_ctrl', 9);
808:
809: hr_utility.TRACE('Leaving Batch Control');
810:
811: END; /* write_batch_control */
812:
813: /******************************************************************

Line 826: hr_utility.TRACE('Writing File Control');

822: PROCEDURE write_file_control IS
823:
824: BEGIN
825:
826: hr_utility.TRACE('Writing File Control');
827:
828: /*
829: hr_utility.TRACE('g_batch_number: ' || g_batch_number);
830: hr_utility.TRACE('g_count: ' || g_count);

Line 829: hr_utility.TRACE('g_batch_number: ' || g_batch_number);

825:
826: hr_utility.TRACE('Writing File Control');
827:
828: /*
829: hr_utility.TRACE('g_batch_number: ' || g_batch_number);
830: hr_utility.TRACE('g_count: ' || g_count);
831: hr_utility.TRACE('g_addenda_count: ' || g_addenda_count);
832:
833: hr_utility.TRACE('File Control : g_hash ' || g_hash);

Line 830: hr_utility.TRACE('g_count: ' || g_count);

826: hr_utility.TRACE('Writing File Control');
827:
828: /*
829: hr_utility.TRACE('g_batch_number: ' || g_batch_number);
830: hr_utility.TRACE('g_count: ' || g_count);
831: hr_utility.TRACE('g_addenda_count: ' || g_addenda_count);
832:
833: hr_utility.TRACE('File Control : g_hash ' || g_hash);
834: */

Line 831: hr_utility.TRACE('g_addenda_count: ' || g_addenda_count);

827:
828: /*
829: hr_utility.TRACE('g_batch_number: ' || g_batch_number);
830: hr_utility.TRACE('g_count: ' || g_count);
831: hr_utility.TRACE('g_addenda_count: ' || g_addenda_count);
832:
833: hr_utility.TRACE('File Control : g_hash ' || g_hash);
834: */
835:

Line 833: hr_utility.TRACE('File Control : g_hash ' || g_hash);

829: hr_utility.TRACE('g_batch_number: ' || g_batch_number);
830: hr_utility.TRACE('g_count: ' || g_count);
831: hr_utility.TRACE('g_addenda_count: ' || g_addenda_count);
832:
833: hr_utility.TRACE('File Control : g_hash ' || g_hash);
834: */
835:
836: v_block_count := CEIL(((2 * g_batch_number ) +
837: g_count + g_addenda_count + 2) / 10);

Line 842: hr_utility.TRACE('.... Writing File Control Context');

838: g_pad_count := (v_block_count * 10) -
839: ((2 * g_batch_number ) +
840: g_count + g_addenda_count + 2);
841:
842: hr_utility.TRACE('.... Writing File Control Context');
843:
844: -- dscully - added contexts for NACHA_BALANCED_NACHA_FILE DBI
845: pay_mag_tape.internal_cxt_values(1) := '3';
846: pay_mag_tape.internal_cxt_names(2) := 'ORG_PAY_METHOD_ID';

Line 851: hr_utility.TRACE('.... Writing File Control Parameters');

847: pay_mag_tape.internal_cxt_values(2) := g_org_payment_method_id;
848: pay_mag_tape.internal_cxt_names(3) := 'DATE_EARNED';
849: pay_mag_tape.internal_cxt_values(3) := fnd_date.date_to_canonical(p_effective_date);
850:
851: hr_utility.TRACE('.... Writing File Control Parameters');
852:
853: pay_mag_tape.internal_prm_values(1) := '8';
854: pay_mag_tape.internal_prm_values(2) := g_file_control;
855:

Line 874: hr_utility.set_location('run_formula.File_Control', 11);

870:
871: pay_mag_tape.internal_prm_names(8) := 'TRANSFER_PAD_COUNT';
872: pay_mag_tape.internal_prm_values(8) := TO_CHAR(g_pad_count);
873: --
874: hr_utility.set_location('run_formula.File_Control', 11);
875: hr_utility.TRACE('Leaving File Control');
876:
877: END; /* write_file_control */
878:

Line 875: hr_utility.TRACE('Leaving File Control');

871: pay_mag_tape.internal_prm_names(8) := 'TRANSFER_PAD_COUNT';
872: pay_mag_tape.internal_prm_values(8) := TO_CHAR(g_pad_count);
873: --
874: hr_utility.set_location('run_formula.File_Control', 11);
875: hr_utility.TRACE('Leaving File Control');
876:
877: END; /* write_file_control */
878:
879: /******************************************************************

Line 891: hr_utility.TRACE('Writing Padding');

887: PROCEDURE write_padding IS
888:
889: BEGIN
890:
891: hr_utility.TRACE('Writing Padding');
892:
893: pay_mag_tape.internal_cxt_values(1) := '1';
894:
895: hr_utility.TRACE('Writing Padding for IAT');

Line 895: hr_utility.TRACE('Writing Padding for IAT');

891: hr_utility.TRACE('Writing Padding');
892:
893: pay_mag_tape.internal_cxt_values(1) := '1';
894:
895: hr_utility.TRACE('Writing Padding for IAT');
896: pay_mag_tape.internal_prm_values(1) := '3';
897: pay_mag_tape.internal_prm_values(2) := g_padding;
898: pay_mag_tape.internal_prm_names(3) := 'TRANSFER_PAD_COUNT';
899: pay_mag_tape.internal_prm_values(3) := TO_CHAR(g_pad_count);

Line 908: hr_utility.TRACE('Leaving IAT Padding');

904: g_pad_count := g_pad_count - 1;
905: END IF;
906:
907:
908: hr_utility.TRACE('Leaving IAT Padding');
909:
910: END; /* write_padding */
911:
912: /*****************************END of Local Functions ****************/

Line 917: hr_utility.TRACE('Entering pay_us_nacha_iat_tape.run_formula');

913:
914:
915: BEGIN
916:
917: hr_utility.TRACE('Entering pay_us_nacha_iat_tape.run_formula');
918: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
919: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
920: pay_mag_tape.internal_prm_values(1) := '2';
921:

Line 924: hr_utility.set_location('pay_us_nacha_iat_tape.run_formula', 1);

920: pay_mag_tape.internal_prm_values(1) := '2';
921:
922: pay_mag_tape.internal_cxt_names(1) := 'NUMBER_OF_CONTEXT';
923: pay_mag_tape.internal_cxt_values(1) := '1';
924: hr_utility.set_location('pay_us_nacha_iat_tape.run_formula', 1);
925:
926:
927: IF NOT csr_nacha_batch%ISOPEN AND g_first_exec = 'Y' THEN
928:

Line 931: hr_utility.set_location('run_formula.Init', 5);

927: IF NOT csr_nacha_batch%ISOPEN AND g_first_exec = 'Y' THEN
928:
929: g_first_exec := 'N';
930:
931: hr_utility.set_location('run_formula.Init', 5);
932: g_payroll_action_id := fnd_number.canonical_to_number(
933: pay_mag_tape.internal_prm_values(3));
934:
935: hr_utility.TRACE('g_payroll_action_id : ' || g_payroll_action_id);

Line 935: hr_utility.TRACE('g_payroll_action_id : ' || g_payroll_action_id);

931: hr_utility.set_location('run_formula.Init', 5);
932: g_payroll_action_id := fnd_number.canonical_to_number(
933: pay_mag_tape.internal_prm_values(3));
934:
935: hr_utility.TRACE('g_payroll_action_id : ' || g_payroll_action_id);
936:
937:
938: g_org_payment_method_id := p_org_payment_method_id;
939:

Line 969: hr_utility.TRACE('g_payroll_id : ' || g_payroll_id);

965: CLOSE csr_org_flex_info;
966:
967: END IF;
968:
969: hr_utility.TRACE('g_payroll_id : ' || g_payroll_id);
970: hr_utility.TRACE('g_organization_id : ' || g_organization_id);
971:
972: IF g_org_payment_method_id IS NOT NULL THEN
973: hr_utility.TRACE('g_org_payment_method_id = ' || g_org_payment_method_id);

Line 970: hr_utility.TRACE('g_organization_id : ' || g_organization_id);

966:
967: END IF;
968:
969: hr_utility.TRACE('g_payroll_id : ' || g_payroll_id);
970: hr_utility.TRACE('g_organization_id : ' || g_organization_id);
971:
972: IF g_org_payment_method_id IS NOT NULL THEN
973: hr_utility.TRACE('g_org_payment_method_id = ' || g_org_payment_method_id);
974: write_file_header;

Line 973: hr_utility.TRACE('g_org_payment_method_id = ' || g_org_payment_method_id);

969: hr_utility.TRACE('g_payroll_id : ' || g_payroll_id);
970: hr_utility.TRACE('g_organization_id : ' || g_organization_id);
971:
972: IF g_org_payment_method_id IS NOT NULL THEN
973: hr_utility.TRACE('g_org_payment_method_id = ' || g_org_payment_method_id);
974: write_file_header;
975: ELSE
976: hr_utility.set_message(801, 'HR_7711_SCL_FLEX_NOT_FOUND');
977: hr_utility.raise_error;

Line 976: hr_utility.set_message(801, 'HR_7711_SCL_FLEX_NOT_FOUND');

972: IF g_org_payment_method_id IS NOT NULL THEN
973: hr_utility.TRACE('g_org_payment_method_id = ' || g_org_payment_method_id);
974: write_file_header;
975: ELSE
976: hr_utility.set_message(801, 'HR_7711_SCL_FLEX_NOT_FOUND');
977: hr_utility.raise_error;
978: END IF;
979:
980: hr_utility.TRACE('p_business_group_id = ' || p_business_group_id);

Line 977: hr_utility.raise_error;

973: hr_utility.TRACE('g_org_payment_method_id = ' || g_org_payment_method_id);
974: write_file_header;
975: ELSE
976: hr_utility.set_message(801, 'HR_7711_SCL_FLEX_NOT_FOUND');
977: hr_utility.raise_error;
978: END IF;
979:
980: hr_utility.TRACE('p_business_group_id = ' || p_business_group_id);
981: hr_utility.TRACE('g_payroll_action_id <' || g_payroll_action_id);

Line 980: hr_utility.TRACE('p_business_group_id = ' || p_business_group_id);

976: hr_utility.set_message(801, 'HR_7711_SCL_FLEX_NOT_FOUND');
977: hr_utility.raise_error;
978: END IF;
979:
980: hr_utility.TRACE('p_business_group_id = ' || p_business_group_id);
981: hr_utility.TRACE('g_payroll_action_id <' || g_payroll_action_id);
982: hr_utility.TRACE('p_effective_date <' || p_effective_date);
983:
984: OPEN csr_nacha_batch(p_business_group_id, g_payroll_action_id, p_effective_date);

Line 981: hr_utility.TRACE('g_payroll_action_id <' || g_payroll_action_id);

977: hr_utility.raise_error;
978: END IF;
979:
980: hr_utility.TRACE('p_business_group_id = ' || p_business_group_id);
981: hr_utility.TRACE('g_payroll_action_id <' || g_payroll_action_id);
982: hr_utility.TRACE('p_effective_date <' || p_effective_date);
983:
984: OPEN csr_nacha_batch(p_business_group_id, g_payroll_action_id, p_effective_date);
985:

Line 982: hr_utility.TRACE('p_effective_date <' || p_effective_date);

978: END IF;
979:
980: hr_utility.TRACE('p_business_group_id = ' || p_business_group_id);
981: hr_utility.TRACE('g_payroll_action_id <' || g_payroll_action_id);
982: hr_utility.TRACE('p_effective_date <' || p_effective_date);
983:
984: OPEN csr_nacha_batch(p_business_group_id, g_payroll_action_id, p_effective_date);
985:
986:

Line 1008: hr_utility.set_message(801, 'PAY_US_PAYMENT_OVERFLOW');

1004:
1005: IF csr_assignments%FOUND THEN
1006:
1007: IF v_amount > 99999999.99 THEN
1008: hr_utility.set_message(801, 'PAY_US_PAYMENT_OVERFLOW');
1009: pay_core_utils.push_message(801, 'PAY_US_PAYMENT_OVERFLOW', 'P');
1010: pay_core_utils.push_token('ASSIGNMENT_NO', g_assignment_id);
1011: raise_application_error( - 20101, 'Error in pay_us_nacha_tape.run_formula');
1012:

Line 1019: hr_utility.TRACE('p_direct_dep_date is not null ' || p_direct_dep_date);

1015: --Bug 9413224. Use c_emp_details_override if Override date is provided
1016: -- Else use c_emp_details
1017: --OPEN c_emp_details(p_effective_date);
1018: if p_direct_dep_date is not null then
1019: hr_utility.TRACE('p_direct_dep_date is not null ' || p_direct_dep_date);
1020:
1021: OPEN c_emp_details_override(to_date(p_direct_dep_date,'YYMMDD'));
1022: FETCH c_emp_details_override INTO g_full_name, g_organization_id, n_person_id, g_emp_num,
1023: g_emp_adress, g_emp_city, g_emp_state, g_emp_county, g_emp_country, g_emp_postal;

Line 1027: hr_utility.TRACE('p_direct_dep_date is null ');

1023: g_emp_adress, g_emp_city, g_emp_state, g_emp_county, g_emp_country, g_emp_postal;
1024: CLOSE c_emp_details_override;
1025:
1026: else
1027: hr_utility.TRACE('p_direct_dep_date is null ');
1028: OPEN c_emp_details(v_prepayment_id);
1029: FETCH c_emp_details INTO g_full_name, g_organization_id, n_person_id, g_emp_num,
1030: g_emp_adress, g_emp_city, g_emp_state, g_emp_county, g_emp_country, g_emp_postal;
1031: CLOSE c_emp_details;

Line 1033: hr_utility.TRACE('g_emp_num : ' || g_emp_num);

1029: FETCH c_emp_details INTO g_full_name, g_organization_id, n_person_id, g_emp_num,
1030: g_emp_adress, g_emp_city, g_emp_state, g_emp_county, g_emp_country, g_emp_postal;
1031: CLOSE c_emp_details;
1032:
1033: hr_utility.TRACE('g_emp_num : ' || g_emp_num);
1034:
1035: end if;
1036:
1037: --No need of this check as any employee for which payroll has been run will atleast have the primary address

Line 1040: hr_utility.set_message(801, 'PAY_US_IAT_NO_ADDRESS');

1036:
1037: --No need of this check as any employee for which payroll has been run will atleast have the primary address
1038: /*IF c_emp_details%NOTFOUND THEN
1039: CLOSE c_emp_details;
1040: hr_utility.set_message(801, 'PAY_US_IAT_NO_ADDRESS');
1041: hr_utility.set_message_token('ASSIGN_NUM', g_assignment_id);
1042: hr_utility.raise_error;
1043: END IF;*/
1044:

Line 1041: hr_utility.set_message_token('ASSIGN_NUM', g_assignment_id);

1037: --No need of this check as any employee for which payroll has been run will atleast have the primary address
1038: /*IF c_emp_details%NOTFOUND THEN
1039: CLOSE c_emp_details;
1040: hr_utility.set_message(801, 'PAY_US_IAT_NO_ADDRESS');
1041: hr_utility.set_message_token('ASSIGN_NUM', g_assignment_id);
1042: hr_utility.raise_error;
1043: END IF;*/
1044:
1045:

Line 1042: hr_utility.raise_error;

1038: /*IF c_emp_details%NOTFOUND THEN
1039: CLOSE c_emp_details;
1040: hr_utility.set_message(801, 'PAY_US_IAT_NO_ADDRESS');
1041: hr_utility.set_message_token('ASSIGN_NUM', g_assignment_id);
1042: hr_utility.raise_error;
1043: END IF;*/
1044:
1045:
1046:

Line 1047: hr_utility.TRACE('full_name : ' || g_full_name);

1043: END IF;*/
1044:
1045:
1046:
1047: hr_utility.TRACE('full_name : ' || g_full_name);
1048:
1049: g_overflow_amount := g_overflow_amount + v_amount;
1050:
1051: IF g_overflow_amount > 99999999.99 THEN

Line 1077: hr_utility.set_message(801, 'PAY_US_PAYMENT_OVERFLOW');

1073:
1074: g_overflow_amount := g_overflow_amount + v_amount;
1075:
1076: IF v_amount > 99999999.99 THEN
1077: hr_utility.set_message(801, 'PAY_US_PAYMENT_OVERFLOW');
1078: pay_core_utils.push_message(801, 'PAY_US_PAYMENT_OVERFLOW', 'P');
1079: pay_core_utils.push_token('ASSIGNMENT_NO', g_assignment_id);
1080: raise_application_error( - 20101, 'Error in pay_us_nacha_tape.run_formula');
1081: END IF;

Line 1088: hr_utility.TRACE('p_direct_dep_date is not null ' || p_direct_dep_date);

1084: --Bug 9413224. Use c_emp_details_override if Override date is provided
1085: -- Else use c_emp_details
1086: -- OPEN c_emp_details(p_effective_date);
1087: if p_direct_dep_date is not null then
1088: hr_utility.TRACE('p_direct_dep_date is not null ' || p_direct_dep_date);
1089:
1090: OPEN c_emp_details_override(to_date(p_direct_dep_date,'YYMMDD'));
1091: FETCH c_emp_details_override INTO g_full_name, g_organization_id, n_person_id, g_emp_num,
1092: g_emp_adress, g_emp_city, g_emp_state, g_emp_county, g_emp_country, g_emp_postal;

Line 1095: hr_utility.TRACE('g_emp_num : ' || g_emp_num);

1091: FETCH c_emp_details_override INTO g_full_name, g_organization_id, n_person_id, g_emp_num,
1092: g_emp_adress, g_emp_city, g_emp_state, g_emp_county, g_emp_country, g_emp_postal;
1093: CLOSE c_emp_details_override;
1094:
1095: hr_utility.TRACE('g_emp_num : ' || g_emp_num);
1096:
1097: else
1098: hr_utility.TRACE('p_direct_dep_date is null ');
1099: OPEN c_emp_details(v_prepayment_id);

Line 1098: hr_utility.TRACE('p_direct_dep_date is null ');

1094:
1095: hr_utility.TRACE('g_emp_num : ' || g_emp_num);
1096:
1097: else
1098: hr_utility.TRACE('p_direct_dep_date is null ');
1099: OPEN c_emp_details(v_prepayment_id);
1100: FETCH c_emp_details INTO g_full_name, g_organization_id, n_person_id, g_emp_num,
1101: g_emp_adress, g_emp_city, g_emp_state, g_emp_county, g_emp_country, g_emp_postal;
1102: CLOSE c_emp_details;

Line 1104: hr_utility.TRACE('g_emp_num : ' || g_emp_num);

1100: FETCH c_emp_details INTO g_full_name, g_organization_id, n_person_id, g_emp_num,
1101: g_emp_adress, g_emp_city, g_emp_state, g_emp_county, g_emp_country, g_emp_postal;
1102: CLOSE c_emp_details;
1103:
1104: hr_utility.TRACE('g_emp_num : ' || g_emp_num);
1105:
1106: end if;
1107:
1108:

Line 1112: hr_utility.set_message(801, 'PAY_US_IAT_NO_ADDRESS');

1108:
1109: --No need of this check as, any employee for which payroll has been run will atleast have the primary address
1110: /*IF c_emp_details%NOTFOUND THEN
1111: CLOSE c_emp_details;
1112: hr_utility.set_message(801, 'PAY_US_IAT_NO_ADDRESS');
1113: hr_utility.set_message_token('ASSIGN_NUM', g_assignment_id);
1114: hr_utility.raise_error;
1115: END IF;*/
1116: IF g_overflow_amount > 99999999.99 THEN

Line 1113: hr_utility.set_message_token('ASSIGN_NUM', g_assignment_id);

1109: --No need of this check as, any employee for which payroll has been run will atleast have the primary address
1110: /*IF c_emp_details%NOTFOUND THEN
1111: CLOSE c_emp_details;
1112: hr_utility.set_message(801, 'PAY_US_IAT_NO_ADDRESS');
1113: hr_utility.set_message_token('ASSIGN_NUM', g_assignment_id);
1114: hr_utility.raise_error;
1115: END IF;*/
1116: IF g_overflow_amount > 99999999.99 THEN
1117: g_overflow_amount := 0;

Line 1114: hr_utility.raise_error;

1110: /*IF c_emp_details%NOTFOUND THEN
1111: CLOSE c_emp_details;
1112: hr_utility.set_message(801, 'PAY_US_IAT_NO_ADDRESS');
1113: hr_utility.set_message_token('ASSIGN_NUM', g_assignment_id);
1114: hr_utility.raise_error;
1115: END IF;*/
1116: IF g_overflow_amount > 99999999.99 THEN
1117: g_overflow_amount := 0;
1118: g_overflow_flag := 'Y';

Line 1134: hr_utility.TRACE('Before Batch cursor');

1130: END IF;
1131: END IF;
1132: ELSE
1133:
1134: hr_utility.TRACE('Before Batch cursor');
1135:
1136: FETCH csr_nacha_batch INTO g_csr_org_pay_meth_id,
1137: g_legal_company_id,
1138: g_nacha_balance_flag;

Line 1140: hr_utility.TRACE('after fetch Batch cursor');

1136: FETCH csr_nacha_batch INTO g_csr_org_pay_meth_id,
1137: g_legal_company_id,
1138: g_nacha_balance_flag;
1139:
1140: hr_utility.TRACE('after fetch Batch cursor');
1141:
1142: IF csr_nacha_batch %FOUND THEN
1143: /* to reset rowid when GRE changes. Bug 1967949 */
1144: hr_utility.TRACE('b4 g_legal_company_id is : ' || g_legal_company_id);

Line 1144: hr_utility.TRACE('b4 g_legal_company_id is : ' || g_legal_company_id);

1140: hr_utility.TRACE('after fetch Batch cursor');
1141:
1142: IF csr_nacha_batch %FOUND THEN
1143: /* to reset rowid when GRE changes. Bug 1967949 */
1144: hr_utility.TRACE('b4 g_legal_company_id is : ' || g_legal_company_id);
1145: hr_utility.TRACE('b4 g_reset_greid is : ' || g_reset_greid);
1146: hr_utility.TRACE('b4 g_rowid is : ' || g_rowid);
1147:
1148: IF g_reset_greid <> g_legal_company_id THEN

Line 1145: hr_utility.TRACE('b4 g_reset_greid is : ' || g_reset_greid);

1141:
1142: IF csr_nacha_batch %FOUND THEN
1143: /* to reset rowid when GRE changes. Bug 1967949 */
1144: hr_utility.TRACE('b4 g_legal_company_id is : ' || g_legal_company_id);
1145: hr_utility.TRACE('b4 g_reset_greid is : ' || g_reset_greid);
1146: hr_utility.TRACE('b4 g_rowid is : ' || g_rowid);
1147:
1148: IF g_reset_greid <> g_legal_company_id THEN
1149: g_rowid := NULL;

Line 1146: hr_utility.TRACE('b4 g_rowid is : ' || g_rowid);

1142: IF csr_nacha_batch %FOUND THEN
1143: /* to reset rowid when GRE changes. Bug 1967949 */
1144: hr_utility.TRACE('b4 g_legal_company_id is : ' || g_legal_company_id);
1145: hr_utility.TRACE('b4 g_reset_greid is : ' || g_reset_greid);
1146: hr_utility.TRACE('b4 g_rowid is : ' || g_rowid);
1147:
1148: IF g_reset_greid <> g_legal_company_id THEN
1149: g_rowid := NULL;
1150: g_reset_greid := g_legal_company_id;

Line 1175: /*hr_utility.TRACE('p_business_group_id : ' || p_business_group_id);

1171: WHERE hou.location_id = hl.location_id
1172: AND hou.organization_id = g_legal_company_id
1173: and p_effective_date between hou.date_from and nvl(hou.date_to,p_effective_date);
1174:
1175: /*hr_utility.TRACE('p_business_group_id : ' || p_business_group_id);
1176: hr_utility.TRACE('g_legal_company_id : ' || g_legal_company_id);
1177: hr_utility.TRACE('g_organization_id : ' || g_organization_id);
1178: hr_utility.TRACE('g_org_name : ' || g_org_name);
1179: hr_utility.TRACE('g_street_address : ' || g_street_address);

Line 1176: hr_utility.TRACE('g_legal_company_id : ' || g_legal_company_id);

1172: AND hou.organization_id = g_legal_company_id
1173: and p_effective_date between hou.date_from and nvl(hou.date_to,p_effective_date);
1174:
1175: /*hr_utility.TRACE('p_business_group_id : ' || p_business_group_id);
1176: hr_utility.TRACE('g_legal_company_id : ' || g_legal_company_id);
1177: hr_utility.TRACE('g_organization_id : ' || g_organization_id);
1178: hr_utility.TRACE('g_org_name : ' || g_org_name);
1179: hr_utility.TRACE('g_street_address : ' || g_street_address);
1180: hr_utility.TRACE('g_city : ' || g_city);

Line 1177: hr_utility.TRACE('g_organization_id : ' || g_organization_id);

1173: and p_effective_date between hou.date_from and nvl(hou.date_to,p_effective_date);
1174:
1175: /*hr_utility.TRACE('p_business_group_id : ' || p_business_group_id);
1176: hr_utility.TRACE('g_legal_company_id : ' || g_legal_company_id);
1177: hr_utility.TRACE('g_organization_id : ' || g_organization_id);
1178: hr_utility.TRACE('g_org_name : ' || g_org_name);
1179: hr_utility.TRACE('g_street_address : ' || g_street_address);
1180: hr_utility.TRACE('g_city : ' || g_city);
1181: hr_utility.TRACE('g_state : ' || g_state);

Line 1178: hr_utility.TRACE('g_org_name : ' || g_org_name);

1174:
1175: /*hr_utility.TRACE('p_business_group_id : ' || p_business_group_id);
1176: hr_utility.TRACE('g_legal_company_id : ' || g_legal_company_id);
1177: hr_utility.TRACE('g_organization_id : ' || g_organization_id);
1178: hr_utility.TRACE('g_org_name : ' || g_org_name);
1179: hr_utility.TRACE('g_street_address : ' || g_street_address);
1180: hr_utility.TRACE('g_city : ' || g_city);
1181: hr_utility.TRACE('g_state : ' || g_state);
1182: hr_utility.TRACE('g_county : ' || g_county);

Line 1179: hr_utility.TRACE('g_street_address : ' || g_street_address);

1175: /*hr_utility.TRACE('p_business_group_id : ' || p_business_group_id);
1176: hr_utility.TRACE('g_legal_company_id : ' || g_legal_company_id);
1177: hr_utility.TRACE('g_organization_id : ' || g_organization_id);
1178: hr_utility.TRACE('g_org_name : ' || g_org_name);
1179: hr_utility.TRACE('g_street_address : ' || g_street_address);
1180: hr_utility.TRACE('g_city : ' || g_city);
1181: hr_utility.TRACE('g_state : ' || g_state);
1182: hr_utility.TRACE('g_county : ' || g_county);
1183: hr_utility.TRACE('g_country : ' || g_country);

Line 1180: hr_utility.TRACE('g_city : ' || g_city);

1176: hr_utility.TRACE('g_legal_company_id : ' || g_legal_company_id);
1177: hr_utility.TRACE('g_organization_id : ' || g_organization_id);
1178: hr_utility.TRACE('g_org_name : ' || g_org_name);
1179: hr_utility.TRACE('g_street_address : ' || g_street_address);
1180: hr_utility.TRACE('g_city : ' || g_city);
1181: hr_utility.TRACE('g_state : ' || g_state);
1182: hr_utility.TRACE('g_county : ' || g_county);
1183: hr_utility.TRACE('g_country : ' || g_country);
1184: hr_utility.TRACE('g_postal_code : ' || g_postal_code);*/

Line 1181: hr_utility.TRACE('g_state : ' || g_state);

1177: hr_utility.TRACE('g_organization_id : ' || g_organization_id);
1178: hr_utility.TRACE('g_org_name : ' || g_org_name);
1179: hr_utility.TRACE('g_street_address : ' || g_street_address);
1180: hr_utility.TRACE('g_city : ' || g_city);
1181: hr_utility.TRACE('g_state : ' || g_state);
1182: hr_utility.TRACE('g_county : ' || g_county);
1183: hr_utility.TRACE('g_country : ' || g_country);
1184: hr_utility.TRACE('g_postal_code : ' || g_postal_code);*/
1185:

Line 1182: hr_utility.TRACE('g_county : ' || g_county);

1178: hr_utility.TRACE('g_org_name : ' || g_org_name);
1179: hr_utility.TRACE('g_street_address : ' || g_street_address);
1180: hr_utility.TRACE('g_city : ' || g_city);
1181: hr_utility.TRACE('g_state : ' || g_state);
1182: hr_utility.TRACE('g_county : ' || g_county);
1183: hr_utility.TRACE('g_country : ' || g_country);
1184: hr_utility.TRACE('g_postal_code : ' || g_postal_code);*/
1185:
1186: write_batch_header;

Line 1183: hr_utility.TRACE('g_country : ' || g_country);

1179: hr_utility.TRACE('g_street_address : ' || g_street_address);
1180: hr_utility.TRACE('g_city : ' || g_city);
1181: hr_utility.TRACE('g_state : ' || g_state);
1182: hr_utility.TRACE('g_county : ' || g_county);
1183: hr_utility.TRACE('g_country : ' || g_country);
1184: hr_utility.TRACE('g_postal_code : ' || g_postal_code);*/
1185:
1186: write_batch_header;
1187:

Line 1184: hr_utility.TRACE('g_postal_code : ' || g_postal_code);*/

1180: hr_utility.TRACE('g_city : ' || g_city);
1181: hr_utility.TRACE('g_state : ' || g_state);
1182: hr_utility.TRACE('g_county : ' || g_county);
1183: hr_utility.TRACE('g_country : ' || g_country);
1184: hr_utility.TRACE('g_postal_code : ' || g_postal_code);*/
1185:
1186: write_batch_header;
1187:
1188: ELSE

Line 1190: hr_utility.TRACE('g_pad_count ' || g_pad_count);

1186: write_batch_header;
1187:
1188: ELSE
1189:
1190: hr_utility.TRACE('g_pad_count ' || g_pad_count);
1191: IF g_pad_count = - 1 THEN
1192: write_file_control;
1193: ELSIF g_pad_count > 0 THEN
1194: write_padding;