DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_PROCESS dependencies on FND_FILE

Line 6509: fnd_file.new_line (fnd_file.LOG, 1);

6505: p_resource_id => c_resource.resource_id
6506: );
6507:
6508: IF NVL (l_timecard_status, 'xx') = 'SUBMITTED' OR NVL (l_timecard_status, 'xx') = 'APPROVED' THEN
6509: fnd_file.new_line (fnd_file.LOG, 1);
6510: fnd_message.set_name ('HXC', 'HXC_NOCHANGE_TIMECARD');
6511:
6512: IF sub_log_msg IS NULL THEN
6513: sub_log_msg := SUBSTR (fnd_message.get (), 1, 2000);

Line 6514: fnd_file.put_line (fnd_file.LOG, sub_log_msg);

6510: fnd_message.set_name ('HXC', 'HXC_NOCHANGE_TIMECARD');
6511:
6512: IF sub_log_msg IS NULL THEN
6513: sub_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
6514: fnd_file.put_line (fnd_file.LOG, sub_log_msg);
6515: rej_log_msg := NULL;
6516: fnd_file.new_line (fnd_file.LOG, 1);
6517: END IF;
6518:

Line 6516: fnd_file.new_line (fnd_file.LOG, 1);

6512: IF sub_log_msg IS NULL THEN
6513: sub_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
6514: fnd_file.put_line (fnd_file.LOG, sub_log_msg);
6515: rej_log_msg := NULL;
6516: fnd_file.new_line (fnd_file.LOG, 1);
6517: END IF;
6518:
6519: OPEN crs_employee_info (
6520: c_resource.resource_id,

Line 6528: fnd_file.put_line (fnd_file.LOG, RTRIM (l_empnumber) || ' - ' || RTRIM (l_empname));

6524: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
6525: /*ADVICE(4482): FETCH into a list of variables instead of a record [204] */
6526:
6527: CLOSE crs_employee_info;
6528: fnd_file.put_line (fnd_file.LOG, RTRIM (l_empnumber) || ' - ' || RTRIM (l_empname));
6529: hxc_lock_api.release_lock (
6530: p_row_lock_id => l_lock_row_id,
6531: p_process_locker_type => l_process_lock_type,
6532: p_transaction_lock_id => l_lock_trx_id,

Line 6578: fnd_file.new_line (fnd_file.LOG, 1);

6574: -- first insert message in log file if rejected TC is submitted without any change
6575: -- before subm,itting the TC.
6576:
6577: IF NVL (l_timecard_status, 'xx') = 'REJECTED' THEN
6578: fnd_file.new_line (fnd_file.LOG, 1);
6579: fnd_message.set_name ('HXC', 'HXC_TK_SUBMIT_UNCHANGED_TC');
6580:
6581: IF rej_log_msg IS NULL THEN
6582: rej_log_msg := SUBSTR (fnd_message.get (), 1, 2000);

Line 6583: fnd_file.put_line (fnd_file.LOG, rej_log_msg);

6579: fnd_message.set_name ('HXC', 'HXC_TK_SUBMIT_UNCHANGED_TC');
6580:
6581: IF rej_log_msg IS NULL THEN
6582: rej_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
6583: fnd_file.put_line (fnd_file.LOG, rej_log_msg);
6584: sub_log_msg := NULL;
6585: fnd_file.new_line (fnd_file.LOG, 1);
6586: END IF;
6587:

Line 6585: fnd_file.new_line (fnd_file.LOG, 1);

6581: IF rej_log_msg IS NULL THEN
6582: rej_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
6583: fnd_file.put_line (fnd_file.LOG, rej_log_msg);
6584: sub_log_msg := NULL;
6585: fnd_file.new_line (fnd_file.LOG, 1);
6586: END IF;
6587:
6588: OPEN crs_employee_info (
6589: c_resource.resource_id,

Line 6597: fnd_file.put_line (fnd_file.LOG, RTRIM (l_empnumber) || ' - ' || RTRIM (l_empname));

6593: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
6594: /*ADVICE(4551): FETCH into a list of variables instead of a record [204] */
6595:
6596: CLOSE crs_employee_info;
6597: fnd_file.put_line (fnd_file.LOG, RTRIM (l_empnumber) || ' - ' || RTRIM (l_empname));
6598: END IF;
6599:
6600: l_notify_to :=
6601: hxc_preference_evaluation.resource_preferences (p_timekeeper_id, 'TK_TCARD_CLA', 3, SYSDATE);

Line 6642: fnd_file.new_line (fnd_file.LOG, 1);

6638: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
6639: /*ADVICE(4595): FETCH into a list of variables instead of a record [204] */
6640:
6641: CLOSE crs_employee_info;
6642: fnd_file.new_line (fnd_file.LOG, 1);
6643: fnd_message.set_name ('HXC', 'HXC_TIMECARD_LOCKED');
6644: fnd_message.set_token ('FULL_NAME', l_empname);
6645: lock_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
6646: fnd_file.put_line (fnd_file.LOG, lock_log_msg);

Line 6646: fnd_file.put_line (fnd_file.LOG, lock_log_msg);

6642: fnd_file.new_line (fnd_file.LOG, 1);
6643: fnd_message.set_name ('HXC', 'HXC_TIMECARD_LOCKED');
6644: fnd_message.set_token ('FULL_NAME', l_empname);
6645: lock_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
6646: fnd_file.put_line (fnd_file.LOG, lock_log_msg);
6647: lock_log_msg := NULL;
6648: END IF;
6649: END IF;
6650: END IF;