APPS.PAY_US_NACHA_TAPE dependencies on PAY_US_NACHA_TAPE

Line 1: package body pay_us_nacha_tape as

1: package body pay_us_nacha_tape as
2: /* $Header: pytapnac.pkb 120.2.12000000.1 2007/01/18 01:44:48 appldev noship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_nacha_tape

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_nacha_tape
21:
22: Description : This package holds building blocks used in the generation
23: of nacha Tape.
24:

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

331: FUNCTION get_formula_id (p_formula_name varchar2)
332: RETURN varchar2 IS
333: ff_formula_id varchar2(9);
334: BEGIN
335: hr_utility.set_location('pay_us_nacha_tape.get_formula_id',1);
336: --
337: select TO_CHAR(FORMULA_ID) INTO ff_formula_id
338: from FF_FORMULAS_F
339: where g_effective_date between EFFECTIVE_START_DATE and

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

364: FUNCTION get_transfer_param ( p_param_name varchar2 )
365: RETURN Number IS
366: param_value number;
367: BEGIN
368: hr_utility.set_location('pay_us_nacha_tape.get_effective_date',20);
369: IF pay_mag_tape.internal_prm_names(3) = p_param_name
370: THEN
371: param_value := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3));
372: ELSIF pay_mag_tape.internal_prm_names(4) = p_param_name

Line 930: hr_utility.trace('Entering pay_us_nacha_tape.run_formula');

926: /*****************************END of Local Functions ****************/
927:
928:
929: BEGIN
930: hr_utility.trace('Entering pay_us_nacha_tape.run_formula');
931: pay_mag_tape.internal_prm_names(1) := 'NO_OF_PARAMETERS';
932: pay_mag_tape.internal_prm_names(2) := 'NEW_FORMULA_ID';
933: pay_mag_tape.internal_prm_values(1) := '2';
934:

Line 937: hr_utility.set_location('pay_us_nacha_tape.run_formula',1);

933: pay_mag_tape.internal_prm_values(1) := '2';
934:
935: pay_mag_tape.internal_cxt_names(1) := 'NUMBER_OF_CONTEXT';
936: pay_mag_tape.internal_cxt_values(1) := '1';
937: hr_utility.set_location('pay_us_nacha_tape.run_formula',1);
938:
939: hr_utility.set_location ('run_formula loop',1);
940:
941: /****************Level 1.1 The first major if clause ***************/

Line 970: hr_utility.set_message_token('PROCEDURE','pay_us_nacha_tape');

966: and ppa.effective_date between opm.EFFECTIVE_START_DATE
967: and opm.EFFECTIVE_END_DATE;
968: if SQL%NOTFOUND then
969: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
970: hr_utility.set_message_token('PROCEDURE','pay_us_nacha_tape');
971: hr_utility.set_message_token('STEP','1');
972: hr_utility.raise_error;
973: end if;
974:

Line 1066: raise_application_error(-20101, 'Error in pay_us_nacha_tape.run_formula');

1062: IF v_amount > 99999999.99 THEN
1063: hr_utility.set_message(801,'PAY_US_PAYMENT_OVERFLOW');
1064: pay_core_utils.push_message(801,'PAY_US_PAYMENT_OVERFLOW','P');
1065: pay_core_utils.push_token('ASSIGNMENT_NO',g_assignment_id);
1066: raise_application_error(-20101, 'Error in pay_us_nacha_tape.run_formula');
1067:
1068: END IF ;
1069:
1070:

Line 1101: raise_application_error(-20101, 'Error in pay_us_nacha_tape.run_formula');

1097: IF v_amount > 99999999.99 THEN
1098: hr_utility.set_message(801,'PAY_US_PAYMENT_OVERFLOW');
1099: pay_core_utils.push_message(801,'PAY_US_PAYMENT_OVERFLOW','P');
1100: pay_core_utils.push_token('ASSIGNMENT_NO',g_assignment_id);
1101: raise_application_error(-20101, 'Error in pay_us_nacha_tape.run_formula');
1102: END IF;
1103:
1104: hr_utility.trace('G_OVERFLOW_AMOUNT is : '|| g_overflow_amount);
1105: hr_utility.trace('G_ROWID value is : '|| g_rowid);

Line 1179: END pay_us_nacha_tape;

1175: END run_formula;
1176:
1177: --BEGIN
1178: -- hr_utility.trace_on(null, 'NACHA');
1179: END pay_us_nacha_tape;