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

Line 44: Name : HR_UTILITY_TRACE

40: g_debug boolean;
41: g_document_type varchar2(50);
42:
43: /****************************************************************************
44: Name : HR_UTILITY_TRACE
45: Description : This procedure prints debug messages.
46: *****************************************************************************/
47:
48: PROCEDURE HR_UTILITY_TRACE

Line 48: PROCEDURE HR_UTILITY_TRACE

44: Name : HR_UTILITY_TRACE
45: Description : This procedure prints debug messages.
46: *****************************************************************************/
47:
48: PROCEDURE HR_UTILITY_TRACE
49: (
50: P_TRC_DATA varchar2
51: ) AS
52: BEGIN

Line 54: hr_utility.trace(p_trc_data);

50: P_TRC_DATA varchar2
51: ) AS
52: BEGIN
53: IF g_debug THEN
54: hr_utility.trace(p_trc_data);
55: END IF;
56: END HR_UTILITY_TRACE;
57:
58: /*

Line 56: END HR_UTILITY_TRACE;

52: BEGIN
53: IF g_debug THEN
54: hr_utility.trace(p_trc_data);
55: END IF;
56: END HR_UTILITY_TRACE;
57:
58: /*
59: -------------------------------------------------------------------------------------------------------
60: -- Name : bal_db_item

Line 85: hr_utility.set_location

81: AND UE.legislation_code = 'US';
82:
83: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
84: BEGIN
85: hr_utility.set_location
86: ('pay_us_mmref_local_xml.bal_db_item - opening cursor', 10);
87: -- Open the cursor
88: OPEN csr_defined_balance;
89: -- Fetch the value

Line 94: hr_utility.set_location

90: FETCH csr_defined_balance
91: INTO l_defined_balance_id;
92: IF csr_defined_balance%NOTFOUND THEN
93: CLOSE csr_defined_balance;
94: hr_utility.set_location
95: ('pay_us_mmref_local_xml.bal_db_item - no rows found from cursor', 20);
96: hr_utility.raise_error;
97: ELSE
98: hr_utility.set_location

Line 96: hr_utility.raise_error;

92: IF csr_defined_balance%NOTFOUND THEN
93: CLOSE csr_defined_balance;
94: hr_utility.set_location
95: ('pay_us_mmref_local_xml.bal_db_item - no rows found from cursor', 20);
96: hr_utility.raise_error;
97: ELSE
98: hr_utility.set_location
99: ('pay_us_mmref_local_xml.bal_db_item - fetched from cursor', 30);
100: CLOSE csr_defined_balance;

Line 98: hr_utility.set_location

94: hr_utility.set_location
95: ('pay_us_mmref_local_xml.bal_db_item - no rows found from cursor', 20);
96: hr_utility.raise_error;
97: ELSE
98: hr_utility.set_location
99: ('pay_us_mmref_local_xml.bal_db_item - fetched from cursor', 30);
100: CLOSE csr_defined_balance;
101: END IF;
102: -- Return the value to the call

Line 137: hr_utility.set_location

133: p_locality_code IN OUT NOCOPY VARCHAR2
134: ) IS
135: l_state_code varchar2(200);
136: BEGIN
137: hr_utility.set_location
138: ('pay_us_mmref_local_xml.get_report_parameters', 10);
139: hr_utility.trace('Payroll_Action_Id '|| to_char(p_pactid));
140: SELECT ppa.start_date,
141: ppa.effective_date,

Line 139: hr_utility.trace('Payroll_Action_Id '|| to_char(p_pactid));

135: l_state_code varchar2(200);
136: BEGIN
137: hr_utility.set_location
138: ('pay_us_mmref_local_xml.get_report_parameters', 10);
139: hr_utility.trace('Payroll_Action_Id '|| to_char(p_pactid));
140: SELECT ppa.start_date,
141: ppa.effective_date,
142: ppa.business_group_id,
143: pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(ppa.payroll_action_id,

Line 168: hr_utility.set_location('pay_us_mmref_local_xml.get_report_parameters', 15);

164: if p_locality_code = 'NULL' then
165: p_locality_code := l_state_code||'000-0000';
166: end if;
167: */
168: hr_utility.set_location('pay_us_mmref_local_xml.get_report_parameters', 15);
169: hr_utility.trace('Parameter Values ');
170: hr_utility.trace('Year Start '|| to_char(p_year_start,'dd-mon-yyyy'));
171: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));
172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));

Line 169: hr_utility.trace('Parameter Values ');

165: p_locality_code := l_state_code||'000-0000';
166: end if;
167: */
168: hr_utility.set_location('pay_us_mmref_local_xml.get_report_parameters', 15);
169: hr_utility.trace('Parameter Values ');
170: hr_utility.trace('Year Start '|| to_char(p_year_start,'dd-mon-yyyy'));
171: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));
172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));
173: hr_utility.trace('p_state_abbrev '|| p_state_abbrev);

Line 170: hr_utility.trace('Year Start '|| to_char(p_year_start,'dd-mon-yyyy'));

166: end if;
167: */
168: hr_utility.set_location('pay_us_mmref_local_xml.get_report_parameters', 15);
169: hr_utility.trace('Parameter Values ');
170: hr_utility.trace('Year Start '|| to_char(p_year_start,'dd-mon-yyyy'));
171: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));
172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));
173: hr_utility.trace('p_state_abbrev '|| p_state_abbrev);
174: hr_utility.trace('p_state_code '|| p_state_code);

Line 171: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));

167: */
168: hr_utility.set_location('pay_us_mmref_local_xml.get_report_parameters', 15);
169: hr_utility.trace('Parameter Values ');
170: hr_utility.trace('Year Start '|| to_char(p_year_start,'dd-mon-yyyy'));
171: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));
172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));
173: hr_utility.trace('p_state_abbrev '|| p_state_abbrev);
174: hr_utility.trace('p_state_code '|| p_state_code);
175: hr_utility.trace('p_report_type '|| p_report_type);

Line 172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));

168: hr_utility.set_location('pay_us_mmref_local_xml.get_report_parameters', 15);
169: hr_utility.trace('Parameter Values ');
170: hr_utility.trace('Year Start '|| to_char(p_year_start,'dd-mon-yyyy'));
171: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));
172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));
173: hr_utility.trace('p_state_abbrev '|| p_state_abbrev);
174: hr_utility.trace('p_state_code '|| p_state_code);
175: hr_utility.trace('p_report_type '|| p_report_type);
176: hr_utility.trace('p_locality_code '|| p_locality_code);

Line 173: hr_utility.trace('p_state_abbrev '|| p_state_abbrev);

169: hr_utility.trace('Parameter Values ');
170: hr_utility.trace('Year Start '|| to_char(p_year_start,'dd-mon-yyyy'));
171: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));
172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));
173: hr_utility.trace('p_state_abbrev '|| p_state_abbrev);
174: hr_utility.trace('p_state_code '|| p_state_code);
175: hr_utility.trace('p_report_type '|| p_report_type);
176: hr_utility.trace('p_locality_code '|| p_locality_code);
177: hr_utility.set_location

Line 174: hr_utility.trace('p_state_code '|| p_state_code);

170: hr_utility.trace('Year Start '|| to_char(p_year_start,'dd-mon-yyyy'));
171: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));
172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));
173: hr_utility.trace('p_state_abbrev '|| p_state_abbrev);
174: hr_utility.trace('p_state_code '|| p_state_code);
175: hr_utility.trace('p_report_type '|| p_report_type);
176: hr_utility.trace('p_locality_code '|| p_locality_code);
177: hr_utility.set_location
178: ('pay_us_mmref_local_xml.get_report_parameters', 40);

Line 175: hr_utility.trace('p_report_type '|| p_report_type);

171: hr_utility.trace('Year End '|| to_char(p_year_end,'dd-mon-yyyy'));
172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));
173: hr_utility.trace('p_state_abbrev '|| p_state_abbrev);
174: hr_utility.trace('p_state_code '|| p_state_code);
175: hr_utility.trace('p_report_type '|| p_report_type);
176: hr_utility.trace('p_locality_code '|| p_locality_code);
177: hr_utility.set_location
178: ('pay_us_mmref_local_xml.get_report_parameters', 40);
179: EXCEPTION

Line 176: hr_utility.trace('p_locality_code '|| p_locality_code);

172: hr_utility.trace('Business Group Id '|| to_char(p_business_group_id));
173: hr_utility.trace('p_state_abbrev '|| p_state_abbrev);
174: hr_utility.trace('p_state_code '|| p_state_code);
175: hr_utility.trace('p_report_type '|| p_report_type);
176: hr_utility.trace('p_locality_code '|| p_locality_code);
177: hr_utility.set_location
178: ('pay_us_mmref_local_xml.get_report_parameters', 40);
179: EXCEPTION
180: WHEN OTHERS THEN

Line 177: hr_utility.set_location

173: hr_utility.trace('p_state_abbrev '|| p_state_abbrev);
174: hr_utility.trace('p_state_code '|| p_state_code);
175: hr_utility.trace('p_report_type '|| p_report_type);
176: hr_utility.trace('p_locality_code '|| p_locality_code);
177: hr_utility.set_location
178: ('pay_us_mmref_local_xml.get_report_parameters', 40);
179: EXCEPTION
180: WHEN OTHERS THEN
181: hr_utility.trace('get_report_parameters procedure Raised Exception ');

Line 181: hr_utility.trace('get_report_parameters procedure Raised Exception ');

177: hr_utility.set_location
178: ('pay_us_mmref_local_xml.get_report_parameters', 40);
179: EXCEPTION
180: WHEN OTHERS THEN
181: hr_utility.trace('get_report_parameters procedure Raised Exception ');
182: hr_utility.trace('ERROR '||substr(SQLERRM,1,40));
183: hr_utility.trace(substr(SQLERRM,41,90));
184: END get_report_parameters;
185:

Line 182: hr_utility.trace('ERROR '||substr(SQLERRM,1,40));

178: ('pay_us_mmref_local_xml.get_report_parameters', 40);
179: EXCEPTION
180: WHEN OTHERS THEN
181: hr_utility.trace('get_report_parameters procedure Raised Exception ');
182: hr_utility.trace('ERROR '||substr(SQLERRM,1,40));
183: hr_utility.trace(substr(SQLERRM,41,90));
184: END get_report_parameters;
185:
186: -------------------------------------------------------------------------

Line 183: hr_utility.trace(substr(SQLERRM,41,90));

179: EXCEPTION
180: WHEN OTHERS THEN
181: hr_utility.trace('get_report_parameters procedure Raised Exception ');
182: hr_utility.trace('ERROR '||substr(SQLERRM,1,40));
183: hr_utility.trace(substr(SQLERRM,41,90));
184: END get_report_parameters;
185:
186: -------------------------------------------------------------------------
187: -- Name : get_balance_value

Line 211: hr_utility.set_location

207: p_effective_date DATE
208: ) RETURN NUMBER IS
209: l_jurisdiction_code VARCHAR2(20);
210: BEGIN
211: hr_utility.set_location
212: ('pay_us_mmref_local_xml.get_balance_value', 10);
213: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
214: IF p_state_abbrev <> 'FED' THEN
215: SELECT jurisdiction_code

Line 219: hr_utility.set_location

215: SELECT jurisdiction_code
216: INTO l_jurisdiction_code
217: FROM pay_state_rules
218: WHERE state_code = p_state_abbrev;
219: hr_utility.set_location
220: ('pay_us_mmref_local_xml.get_balance_value', 15);
221: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
222: END IF;
223: hr_utility.trace(p_balance_name);

Line 223: hr_utility.trace(p_balance_name);

219: hr_utility.set_location
220: ('pay_us_mmref_local_xml.get_balance_value', 15);
221: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
222: END IF;
223: hr_utility.trace(p_balance_name);
224: hr_utility.trace('Context');
225: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
226: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
227: hr_utility.set_location

Line 224: hr_utility.trace('Context');

220: ('pay_us_mmref_local_xml.get_balance_value', 15);
221: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
222: END IF;
223: hr_utility.trace(p_balance_name);
224: hr_utility.trace('Context');
225: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
226: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
227: hr_utility.set_location
228: ('pay_us_mmref_local_xml.get_balance_value', 20);

Line 225: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);

221: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
222: END IF;
223: hr_utility.trace(p_balance_name);
224: hr_utility.trace('Context');
225: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
226: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
227: hr_utility.set_location
228: ('pay_us_mmref_local_xml.get_balance_value', 20);
229: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),

Line 226: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);

222: END IF;
223: hr_utility.trace(p_balance_name);
224: hr_utility.trace('Context');
225: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
226: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
227: hr_utility.set_location
228: ('pay_us_mmref_local_xml.get_balance_value', 20);
229: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
230: p_assignment_id,

Line 227: hr_utility.set_location

223: hr_utility.trace(p_balance_name);
224: hr_utility.trace('Context');
225: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
226: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
227: hr_utility.set_location
228: ('pay_us_mmref_local_xml.get_balance_value', 20);
229: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
230: p_assignment_id,
231: p_effective_date);

Line 257: -- hr_utility.trace_on(null,'LOCALXML');

253: p_state_code VARCHAR2(200);
254: p_report_type VARCHAR2(200);
255: p_locality_code VARCHAR2(200);
256: BEGIN
257: -- hr_utility.trace_on(null,'LOCALXML');
258: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 10);
259:
260: get_report_parameters( p_pactid,
261: p_year_start,

Line 258: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 10);

254: p_report_type VARCHAR2(200);
255: p_locality_code VARCHAR2(200);
256: BEGIN
257: -- hr_utility.trace_on(null,'LOCALXML');
258: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 10);
259:
260: get_report_parameters( p_pactid,
261: p_year_start,
262: p_year_end,

Line 269: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 20);

265: p_report_type,
266: p_business_group_id,
267: p_locality_code
268: );
269: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 20);
270:
271:
272: IF p_report_type = 'W2_MAG_XML' THEN
273: p_sqlstr := '

Line 319: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 40);

315: WHERE hoi.organization_id = paa.tax_unit_id
316: AND hoi.org_information_context = ''1099R Magnetic Report Rules''
317: )
318: ORDER BY to_number(paa.serial_number)';
319: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 40);
320: END IF;
321: hr_utility.trace( substr(p_sqlstr,1, 50));
322: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 50);
323: END range_cursor;

Line 321: hr_utility.trace( substr(p_sqlstr,1, 50));

317: )
318: ORDER BY to_number(paa.serial_number)';
319: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 40);
320: END IF;
321: hr_utility.trace( substr(p_sqlstr,1, 50));
322: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 50);
323: END range_cursor;
324: --
325:

Line 322: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 50);

318: ORDER BY to_number(paa.serial_number)';
319: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 40);
320: END IF;
321: hr_utility.trace( substr(p_sqlstr,1, 50));
322: hr_utility.set_location( 'pay_us_mmref_local_xml.range_cursor', 50);
323: END range_cursor;
324: --
325:
326: /****************************************************************************

Line 507: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 10);

503: l_gre_id := -1;
504: l_error_flag := 'N';
505:
506: -- Get the report parameters. These define the report being run.
507: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 10);
508: get_report_parameters( p_pactid,
509: l_year_start,
510: l_year_end,
511: l_state_abbrev,

Line 524: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 20);

520:
521: --Currently all reports group by GRE
522: l_group_by_gre := TRUE;
523: --Open the appropriate cursor
524: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 20);
525: hr_utility.trace('LOCALITY_CODE : '|| l_locality_code);
526: IF l_report_type = 'W2_MAG_XML' THEN
527: OPEN c_local(l_state_code,
528: l_locality_code);

Line 525: hr_utility.trace('LOCALITY_CODE : '|| l_locality_code);

521: --Currently all reports group by GRE
522: l_group_by_gre := TRUE;
523: --Open the appropriate cursor
524: hr_utility.set_location( 'pay_us_mmref_local_xml.create_assignement_act', 20);
525: hr_utility.trace('LOCALITY_CODE : '|| l_locality_code);
526: IF l_report_type = 'W2_MAG_XML' THEN
527: OPEN c_local(l_state_code,
528: l_locality_code);
529: END IF;

Line 537: hr_utility.set_location(

533: l_tax_unit_id,
534: l_effective_end_date,
535: l_assignment_action_id,
536: l_w2_box17;
537: hr_utility.set_location(
538: 'pay_us_mmref_local_xml.create_assignement_act', 40);
539: EXIT WHEN c_local%NOTFOUND;
540: --Based on the groupin criteria, check if the record is the same
541: --as the previous record.

Line 555: hr_utility.set_location(

551: )
552: ) THEN
553: --{
554: --Do Nothing
555: hr_utility.set_location(
556: 'pay_us_mmref_local_xml.create_assignement_act', 50);
557: NULL;
558: --}
559: ELSE

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

558: --}
559: ELSE
560: --{
561: --Create the assignment action for the record
562: hr_utility.trace('Assignment Fetched - ');
563: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
564: hr_utility.trace('Person Id : '|| to_char(l_person_id));
565: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
566: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));

Line 563: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));

559: ELSE
560: --{
561: --Create the assignment action for the record
562: hr_utility.trace('Assignment Fetched - ');
563: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
564: hr_utility.trace('Person Id : '|| to_char(l_person_id));
565: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
566: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
567: IF (l_report_type = 'W2_MAG_XML') then

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

560: --{
561: --Create the assignment action for the record
562: hr_utility.trace('Assignment Fetched - ');
563: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
564: hr_utility.trace('Person Id : '|| to_char(l_person_id));
565: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
566: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
567: IF (l_report_type = 'W2_MAG_XML') then
568: SELECT pay_assignment_actions_s.nextval

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

561: --Create the assignment action for the record
562: hr_utility.trace('Assignment Fetched - ');
563: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
564: hr_utility.trace('Person Id : '|| to_char(l_person_id));
565: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
566: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
567: IF (l_report_type = 'W2_MAG_XML') then
568: SELECT pay_assignment_actions_s.nextval
569: INTO lockingactid

Line 566: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));

562: hr_utility.trace('Assignment Fetched - ');
563: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
564: hr_utility.trace('Person Id : '|| to_char(l_person_id));
565: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
566: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date));
567: IF (l_report_type = 'W2_MAG_XML') then
568: SELECT pay_assignment_actions_s.nextval
569: INTO lockingactid
570: FROM dual;

Line 571: hr_utility.set_location(

567: IF (l_report_type = 'W2_MAG_XML') then
568: SELECT pay_assignment_actions_s.nextval
569: INTO lockingactid
570: FROM dual;
571: hr_utility.set_location(
572: 'pay_us_mmref_local_xml.create_assignement_act', 60);
573: hr_nonrun_asact.insact( lockingactid,
574: l_assignment_id,
575: p_pactid,

Line 578: hr_utility.set_location(

574: l_assignment_id,
575: p_pactid,
576: p_chunk,
577: l_tax_unit_id);
578: hr_utility.set_location(
579: 'pay_us_mmref_local_xml.create_assignement_act', 70);
580: hr_nonrun_asact.insint(lockingactid,
581: l_assignment_action_id);
582: hr_utility.set_location(

Line 582: hr_utility.set_location(

578: hr_utility.set_location(
579: 'pay_us_mmref_local_xml.create_assignement_act', 70);
580: hr_nonrun_asact.insint(lockingactid,
581: l_assignment_action_id);
582: hr_utility.set_location(
583: 'pay_us_mmref_local_xml.create_assignement_act', 80);
584: hr_utility.trace('Interlock Created - ');
585: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
586: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));

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

580: hr_nonrun_asact.insint(lockingactid,
581: l_assignment_action_id);
582: hr_utility.set_location(
583: 'pay_us_mmref_local_xml.create_assignement_act', 80);
584: hr_utility.trace('Interlock Created - ');
585: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
586: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
587: --Store the current person/GRE for comparision during the
588: --next iteration.

Line 585: hr_utility.trace('Locking Action : '|| to_char(lockingactid));

581: l_assignment_action_id);
582: hr_utility.set_location(
583: 'pay_us_mmref_local_xml.create_assignement_act', 80);
584: hr_utility.trace('Interlock Created - ');
585: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
586: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
587: --Store the current person/GRE for comparision during the
588: --next iteration.
589: l_prev_person_id := l_person_id;

Line 586: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));

582: hr_utility.set_location(
583: 'pay_us_mmref_local_xml.create_assignement_act', 80);
584: hr_utility.trace('Interlock Created - ');
585: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
586: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
587: --Store the current person/GRE for comparision during the
588: --next iteration.
589: l_prev_person_id := l_person_id;
590: l_prev_tax_unit_id := l_tax_unit_id;

Line 599: hr_utility.trace('Error Flag was set to Y');

595: CLOSE c_local;
596: END IF;
597:
598: IF l_error_flag = 'Y' THEN
599: hr_utility.trace('Error Flag was set to Y');
600: hr_utility.raise_error;
601: END IF;
602:
603: END create_assignment_act;

Line 600: hr_utility.raise_error;

596: END IF;
597:
598: IF l_error_flag = 'Y' THEN
599: hr_utility.trace('Error Flag was set to Y');
600: hr_utility.raise_error;
601: END IF;
602:
603: END create_assignment_act;
604: --

Line 641: HR_UTILITY_TRACE('end_of_file l_final_xml_string = '

637: ,p_state_abbreviation
638: ,p_locality_code
639: ,status
640: ,p_final_xml_string);
641: HR_UTILITY_TRACE('end_of_file l_final_xml_string = '
642: || p_final_xml_string);
643: WRITE_TO_MAGTAPE_LOB(p_final_xml_string);
644: --}
645: END transmitter_record_start;

Line 654: HR_UTILITY_TRACE('end_of_file l_final_xml_string = '

650: l_is_temp_final_xml VARCHAR2(2);
651:
652: BEGIN
653: l_final_xml_string := '';
654: HR_UTILITY_TRACE('end_of_file l_final_xml_string = '
655: || l_final_xml_string);
656: WRITE_TO_MAGTAPE_LOB(l_final_xml_string);
657: -- pay_core_files.write_to_magtape_lob(l_final_xml_string);
658: END;

Line 698: HR_UTILITY_TRACE('end_of_file l_final_xml_string = '

694: ,p_state_abbreviation
695: ,p_locality_code
696: ,status
697: ,p_final_xml_string);
698: HR_UTILITY_TRACE('end_of_file l_final_xml_string = '
699: || p_final_xml_string);
700: WRITE_TO_MAGTAPE_LOB(p_final_xml_string);
701: --}
702: END local_w2_xml_employer_start;

Line 711: HR_UTILITY_TRACE('end_of_file l_final_xml_string = '

707: l_is_temp_final_xml VARCHAR2(2);
708:
709: BEGIN
710: l_final_xml_string := '';
711: HR_UTILITY_TRACE('end_of_file l_final_xml_string = '
712: || l_final_xml_string);
713: WRITE_TO_MAGTAPE_LOB(l_final_xml_string);
714: -- pay_core_files.write_to_magtape_lob(l_final_xml_string);
715: END local_w2_xml_employer_end;

Line 777: HR_UTILITY_TRACE('Constructing XML for Employee ->');

773: l_main_payroll_action_id NUMBER;
774: BEGIN
775: --{
776: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
777: HR_UTILITY_TRACE('Constructing XML for Employee ->');
778: HR_UTILITY_TRACE('EE ASGN ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')));
779: OPEN c_get_params;
780: FETCH c_get_params INTO p_ye_assignment_action_id,
781: p_tax_unit_id,

Line 778: HR_UTILITY_TRACE('EE ASGN ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')));

774: BEGIN
775: --{
776: -- Fetch All parameters value set by Transmitter Cursor and Conc. Program
777: HR_UTILITY_TRACE('Constructing XML for Employee ->');
778: HR_UTILITY_TRACE('EE ASGN ID :'||to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')));
779: OPEN c_get_params;
780: FETCH c_get_params INTO p_ye_assignment_action_id,
781: p_tax_unit_id,
782: p_payroll_action_id,

Line 804: HR_UTILITY_TRACE('Prameter Used for Employee level XML');

800: p_reporting_year := pay_magtape_generic.get_parameter_value('TRANSFER_REPORTING_YEAR');
801: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
802: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
803: */
804: HR_UTILITY_TRACE('Prameter Used for Employee level XML');
805: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));
806: HR_UTILITY_TRACE('p_payroll_action_id YE :'||to_char(p_payroll_action_id));
807: HR_UTILITY_TRACE('p_payroll_action_id :'||to_char(l_main_payroll_action_id));
808: HR_UTILITY_TRACE('p_ye_assignment_action_id :'||to_char(p_ye_assignment_action_id));

Line 805: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));

801: p_locality_code := pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE');
802: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
803: */
804: HR_UTILITY_TRACE('Prameter Used for Employee level XML');
805: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));
806: HR_UTILITY_TRACE('p_payroll_action_id YE :'||to_char(p_payroll_action_id));
807: HR_UTILITY_TRACE('p_payroll_action_id :'||to_char(l_main_payroll_action_id));
808: HR_UTILITY_TRACE('p_ye_assignment_action_id :'||to_char(p_ye_assignment_action_id));
809: HR_UTILITY_TRACE('p_assignment_action_id :'||to_char(p_assignment_action_id));

Line 806: HR_UTILITY_TRACE('p_payroll_action_id YE :'||to_char(p_payroll_action_id));

802: p_jurisdiction_code := pay_magtape_generic.get_parameter_value('EE_LOCALITY_JD_CODE');
803: */
804: HR_UTILITY_TRACE('Prameter Used for Employee level XML');
805: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));
806: HR_UTILITY_TRACE('p_payroll_action_id YE :'||to_char(p_payroll_action_id));
807: HR_UTILITY_TRACE('p_payroll_action_id :'||to_char(l_main_payroll_action_id));
808: HR_UTILITY_TRACE('p_ye_assignment_action_id :'||to_char(p_ye_assignment_action_id));
809: HR_UTILITY_TRACE('p_assignment_action_id :'||to_char(p_assignment_action_id));
810: HR_UTILITY_TRACE('p_assignment_id :'||to_char(p_assignment_id));

Line 807: HR_UTILITY_TRACE('p_payroll_action_id :'||to_char(l_main_payroll_action_id));

803: */
804: HR_UTILITY_TRACE('Prameter Used for Employee level XML');
805: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));
806: HR_UTILITY_TRACE('p_payroll_action_id YE :'||to_char(p_payroll_action_id));
807: HR_UTILITY_TRACE('p_payroll_action_id :'||to_char(l_main_payroll_action_id));
808: HR_UTILITY_TRACE('p_ye_assignment_action_id :'||to_char(p_ye_assignment_action_id));
809: HR_UTILITY_TRACE('p_assignment_action_id :'||to_char(p_assignment_action_id));
810: HR_UTILITY_TRACE('p_assignment_id :'||to_char(p_assignment_id));
811: HR_UTILITY_TRACE('p_date_earned :'||to_char(p_date_earned,'DD-MON-YYYY'));

Line 808: HR_UTILITY_TRACE('p_ye_assignment_action_id :'||to_char(p_ye_assignment_action_id));

804: HR_UTILITY_TRACE('Prameter Used for Employee level XML');
805: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));
806: HR_UTILITY_TRACE('p_payroll_action_id YE :'||to_char(p_payroll_action_id));
807: HR_UTILITY_TRACE('p_payroll_action_id :'||to_char(l_main_payroll_action_id));
808: HR_UTILITY_TRACE('p_ye_assignment_action_id :'||to_char(p_ye_assignment_action_id));
809: HR_UTILITY_TRACE('p_assignment_action_id :'||to_char(p_assignment_action_id));
810: HR_UTILITY_TRACE('p_assignment_id :'||to_char(p_assignment_id));
811: HR_UTILITY_TRACE('p_date_earned :'||to_char(p_date_earned,'DD-MON-YYYY'));
812: HR_UTILITY_TRACE('p_reporting_year :'||p_reporting_year);

Line 809: HR_UTILITY_TRACE('p_assignment_action_id :'||to_char(p_assignment_action_id));

805: HR_UTILITY_TRACE('p_tax_unit_id YE :'||to_char(p_tax_unit_id));
806: HR_UTILITY_TRACE('p_payroll_action_id YE :'||to_char(p_payroll_action_id));
807: HR_UTILITY_TRACE('p_payroll_action_id :'||to_char(l_main_payroll_action_id));
808: HR_UTILITY_TRACE('p_ye_assignment_action_id :'||to_char(p_ye_assignment_action_id));
809: HR_UTILITY_TRACE('p_assignment_action_id :'||to_char(p_assignment_action_id));
810: HR_UTILITY_TRACE('p_assignment_id :'||to_char(p_assignment_id));
811: HR_UTILITY_TRACE('p_date_earned :'||to_char(p_date_earned,'DD-MON-YYYY'));
812: HR_UTILITY_TRACE('p_reporting_year :'||p_reporting_year);
813: HR_UTILITY_TRACE('p_locality_code :'||p_locality_code);

Line 810: HR_UTILITY_TRACE('p_assignment_id :'||to_char(p_assignment_id));

806: HR_UTILITY_TRACE('p_payroll_action_id YE :'||to_char(p_payroll_action_id));
807: HR_UTILITY_TRACE('p_payroll_action_id :'||to_char(l_main_payroll_action_id));
808: HR_UTILITY_TRACE('p_ye_assignment_action_id :'||to_char(p_ye_assignment_action_id));
809: HR_UTILITY_TRACE('p_assignment_action_id :'||to_char(p_assignment_action_id));
810: HR_UTILITY_TRACE('p_assignment_id :'||to_char(p_assignment_id));
811: HR_UTILITY_TRACE('p_date_earned :'||to_char(p_date_earned,'DD-MON-YYYY'));
812: HR_UTILITY_TRACE('p_reporting_year :'||p_reporting_year);
813: HR_UTILITY_TRACE('p_locality_code :'||p_locality_code);
814: -- HR_UTILITY_TRACE('p_jurisdiction_code :'||p_jurisdiction_code);

Line 811: HR_UTILITY_TRACE('p_date_earned :'||to_char(p_date_earned,'DD-MON-YYYY'));

807: HR_UTILITY_TRACE('p_payroll_action_id :'||to_char(l_main_payroll_action_id));
808: HR_UTILITY_TRACE('p_ye_assignment_action_id :'||to_char(p_ye_assignment_action_id));
809: HR_UTILITY_TRACE('p_assignment_action_id :'||to_char(p_assignment_action_id));
810: HR_UTILITY_TRACE('p_assignment_id :'||to_char(p_assignment_id));
811: HR_UTILITY_TRACE('p_date_earned :'||to_char(p_date_earned,'DD-MON-YYYY'));
812: HR_UTILITY_TRACE('p_reporting_year :'||p_reporting_year);
813: HR_UTILITY_TRACE('p_locality_code :'||p_locality_code);
814: -- HR_UTILITY_TRACE('p_jurisdiction_code :'||p_jurisdiction_code);
815:

Line 812: HR_UTILITY_TRACE('p_reporting_year :'||p_reporting_year);

808: HR_UTILITY_TRACE('p_ye_assignment_action_id :'||to_char(p_ye_assignment_action_id));
809: HR_UTILITY_TRACE('p_assignment_action_id :'||to_char(p_assignment_action_id));
810: HR_UTILITY_TRACE('p_assignment_id :'||to_char(p_assignment_id));
811: HR_UTILITY_TRACE('p_date_earned :'||to_char(p_date_earned,'DD-MON-YYYY'));
812: HR_UTILITY_TRACE('p_reporting_year :'||p_reporting_year);
813: HR_UTILITY_TRACE('p_locality_code :'||p_locality_code);
814: -- HR_UTILITY_TRACE('p_jurisdiction_code :'||p_jurisdiction_code);
815:
816: get_report_parameters( l_main_payroll_action_id,

Line 813: HR_UTILITY_TRACE('p_locality_code :'||p_locality_code);

809: HR_UTILITY_TRACE('p_assignment_action_id :'||to_char(p_assignment_action_id));
810: HR_UTILITY_TRACE('p_assignment_id :'||to_char(p_assignment_id));
811: HR_UTILITY_TRACE('p_date_earned :'||to_char(p_date_earned,'DD-MON-YYYY'));
812: HR_UTILITY_TRACE('p_reporting_year :'||p_reporting_year);
813: HR_UTILITY_TRACE('p_locality_code :'||p_locality_code);
814: -- HR_UTILITY_TRACE('p_jurisdiction_code :'||p_jurisdiction_code);
815:
816: get_report_parameters( l_main_payroll_action_id,
817: l_year_start,

Line 814: -- HR_UTILITY_TRACE('p_jurisdiction_code :'||p_jurisdiction_code);

810: HR_UTILITY_TRACE('p_assignment_id :'||to_char(p_assignment_id));
811: HR_UTILITY_TRACE('p_date_earned :'||to_char(p_date_earned,'DD-MON-YYYY'));
812: HR_UTILITY_TRACE('p_reporting_year :'||p_reporting_year);
813: HR_UTILITY_TRACE('p_locality_code :'||p_locality_code);
814: -- HR_UTILITY_TRACE('p_jurisdiction_code :'||p_jurisdiction_code);
815:
816: get_report_parameters( l_main_payroll_action_id,
817: l_year_start,
818: l_year_end,

Line 826: HR_UTILITY_TRACE('Year Start :'||to_char(l_year_start,'dd-mon-yyyy'));

822: l_business_group_id,
823: l_locality_code
824: );
825:
826: HR_UTILITY_TRACE('Year Start :'||to_char(l_year_start,'dd-mon-yyyy'));
827: HR_UTILITY_TRACE('Year End :'||to_char(l_year_end,'dd-mon-yyyy'));
828: HR_UTILITY_TRACE('State Abbreviation :'||l_state_abbrev);
829: HR_UTILITY_TRACE('State Code :'||l_state_code);
830: HR_UTILITY_TRACE('Report Type :'||l_report_type);

Line 827: HR_UTILITY_TRACE('Year End :'||to_char(l_year_end,'dd-mon-yyyy'));

823: l_locality_code
824: );
825:
826: HR_UTILITY_TRACE('Year Start :'||to_char(l_year_start,'dd-mon-yyyy'));
827: HR_UTILITY_TRACE('Year End :'||to_char(l_year_end,'dd-mon-yyyy'));
828: HR_UTILITY_TRACE('State Abbreviation :'||l_state_abbrev);
829: HR_UTILITY_TRACE('State Code :'||l_state_code);
830: HR_UTILITY_TRACE('Report Type :'||l_report_type);
831: HR_UTILITY_TRACE('Locality Code :'||l_locality_code);

Line 828: HR_UTILITY_TRACE('State Abbreviation :'||l_state_abbrev);

824: );
825:
826: HR_UTILITY_TRACE('Year Start :'||to_char(l_year_start,'dd-mon-yyyy'));
827: HR_UTILITY_TRACE('Year End :'||to_char(l_year_end,'dd-mon-yyyy'));
828: HR_UTILITY_TRACE('State Abbreviation :'||l_state_abbrev);
829: HR_UTILITY_TRACE('State Code :'||l_state_code);
830: HR_UTILITY_TRACE('Report Type :'||l_report_type);
831: HR_UTILITY_TRACE('Locality Code :'||l_locality_code);
832:

Line 829: HR_UTILITY_TRACE('State Code :'||l_state_code);

825:
826: HR_UTILITY_TRACE('Year Start :'||to_char(l_year_start,'dd-mon-yyyy'));
827: HR_UTILITY_TRACE('Year End :'||to_char(l_year_end,'dd-mon-yyyy'));
828: HR_UTILITY_TRACE('State Abbreviation :'||l_state_abbrev);
829: HR_UTILITY_TRACE('State Code :'||l_state_code);
830: HR_UTILITY_TRACE('Report Type :'||l_report_type);
831: HR_UTILITY_TRACE('Locality Code :'||l_locality_code);
832:
833: --

Line 830: HR_UTILITY_TRACE('Report Type :'||l_report_type);

826: HR_UTILITY_TRACE('Year Start :'||to_char(l_year_start,'dd-mon-yyyy'));
827: HR_UTILITY_TRACE('Year End :'||to_char(l_year_end,'dd-mon-yyyy'));
828: HR_UTILITY_TRACE('State Abbreviation :'||l_state_abbrev);
829: HR_UTILITY_TRACE('State Code :'||l_state_code);
830: HR_UTILITY_TRACE('Report Type :'||l_report_type);
831: HR_UTILITY_TRACE('Locality Code :'||l_locality_code);
832:
833: --
834: -- Following Procedure Call will form the RE Record Structure in XML format

Line 831: HR_UTILITY_TRACE('Locality Code :'||l_locality_code);

827: HR_UTILITY_TRACE('Year End :'||to_char(l_year_end,'dd-mon-yyyy'));
828: HR_UTILITY_TRACE('State Abbreviation :'||l_state_abbrev);
829: HR_UTILITY_TRACE('State Code :'||l_state_code);
830: HR_UTILITY_TRACE('Report Type :'||l_report_type);
831: HR_UTILITY_TRACE('Locality Code :'||l_locality_code);
832:
833: --
834: -- Following Procedure Call will form the RE Record Structure in XML format
835: --

Line 851: --HR_UTILITY_TRACE('end_of_file p_final_xml_string = '

847: ,status
848: ,p_final_xml_string
849: );
850:
851: --HR_UTILITY_TRACE('end_of_file p_final_xml_string = '
852: -- || p_final_xml_string);
853: WRITE_TO_MAGTAPE_LOB(p_final_xml_string);
854: --}
855: EXCEPTION

Line 857: HR_UTILITY_TRACE('Error Encountered in local_w2_xml_employee_build');

853: WRITE_TO_MAGTAPE_LOB(p_final_xml_string);
854: --}
855: EXCEPTION
856: WHEN OTHERS THEN
857: HR_UTILITY_TRACE('Error Encountered in local_w2_xml_employee_build');
858: HR_UTILITY_TRACE(sqlerrm);
859: END local_w2_xml_employee_build;
860:
861: /****************************************************************************

Line 858: HR_UTILITY_TRACE(sqlerrm);

854: --}
855: EXCEPTION
856: WHEN OTHERS THEN
857: HR_UTILITY_TRACE('Error Encountered in local_w2_xml_employee_build');
858: HR_UTILITY_TRACE(sqlerrm);
859: END local_w2_xml_employee_build;
860:
861: /****************************************************************************
862: Name : PRINT_BLOB

Line 987: -- hr_utility.trace_on(null, 'USLOCALW2');

983:
984:
985: END local_non_pa_emp_data;
986: BEGIN
987: -- hr_utility.trace_on(null, 'USLOCALW2');
988: g_proc_name := 'PAY_US_MMREF_LOCAL_XML.';
989: g_debug := hr_utility.debug_enabled;
990: g_document_type := 'LOCAL_W2_XML';
991:

Line 989: g_debug := hr_utility.debug_enabled;

985: END local_non_pa_emp_data;
986: BEGIN
987: -- hr_utility.trace_on(null, 'USLOCALW2');
988: g_proc_name := 'PAY_US_MMREF_LOCAL_XML.';
989: g_debug := hr_utility.debug_enabled;
990: g_document_type := 'LOCAL_W2_XML';
991:
992: END pay_us_mmref_local_xml;