DBA Data[Home] [Help]

APPS.PAY_NO_SC_ARCHIVE dependencies on FND_FILE

Line 79: fnd_file.put_line (fnd_file.LOG, 'Entering Get all Parameters' );

75: WHERE payroll_action_id = p_payroll_action_id;
76: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
77: --
78: BEGIN
79: fnd_file.put_line (fnd_file.LOG, 'Entering Get all Parameters' );
80: OPEN csr_parameter_info (p_payroll_action_id);
81: FETCH csr_parameter_info
82: INTO p_legal_employer_id
83: ,p_employee

Line 245: -- fnd_file.put_line (fnd_file.LOG, 'Exiting Assignment Action Code' );

241: END IF;
242: IF g_debug THEN
243: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
244: END IF;
245: -- fnd_file.put_line (fnd_file.LOG, 'Exiting Assignment Action Code' );
246:
247:
248: END ASSIGNMENT_ACTION_CODE;
249: /* INITIALIZATION CODE */

Line 253: -- fnd_file.put_line (fnd_file.LOG, 'Entering Initialization Code' );

249: /* INITIALIZATION CODE */
250: PROCEDURE INITIALIZATION_CODE(p_payroll_action_id IN NUMBER)
251: IS
252: BEGIN
253: -- fnd_file.put_line (fnd_file.LOG, 'Entering Initialization Code' );
254: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
255:
256:
257:

Line 260: -- fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );

256:
257:
258: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
259:
260: -- fnd_file.put_line (fnd_file.LOG, 'Existing Initialization Code' );
261: EXCEPTION WHEN OTHERS THEN
262: g_err_num := SQLCODE;
263: IF g_debug THEN
264: hr_utility.set_location(' Err Procedure INITIALIZATION_CODE',110);

Line 268: fnd_file.put_line (fnd_file.LOG, 'Error in Initialization Code' );

264: hr_utility.set_location(' Err Procedure INITIALIZATION_CODE',110);
265: hr_utility.set_location('ORA_ERR: ' || g_err_num ||
266: 'In INITIALIZATION_CODE',180);
267: END IF;
268: fnd_file.put_line (fnd_file.LOG, 'Error in Initialization Code' );
269: END INITIALIZATION_CODE;
270: /* ARCHIVE CODE */
271: PROCEDURE ARCHIVE_CODE(p_assignment_action_id IN NUMBER
272: ,p_effective_date IN DATE)

Line 327: fnd_file.put_line (fnd_file.LOG, 'entering archive code' );

323:
324: /**** End of Cursor ***/
325:
326: BEGIN
327: fnd_file.put_line (fnd_file.LOG, 'entering archive code' );
328:
329:
330: l_start_date := trunc(p_effective_date,'YY');
331: l_end_date := last_day(add_months(l_start_date,11));

Line 356: fnd_file.put_line (fnd_file.LOG, 'Exiting archive code' );

352: END IF;
353: IF g_debug THEN
354: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',90);
355: END IF;
356: fnd_file.put_line (fnd_file.LOG, 'Exiting archive code' );
357: END ARCHIVE_CODE;
358: END PAY_NO_SC_ARCHIVE;