DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_PROCESS dependencies on FND_FILE

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

5153: p_resource_id => c_resource.resource_id
5154: );
5155:
5156: IF NVL (l_timecard_status, 'xx') = 'SUBMITTED' OR NVL (l_timecard_status, 'xx') = 'APPROVED' THEN
5157: fnd_file.new_line (fnd_file.LOG, 1);
5158: fnd_message.set_name ('HXC', 'HXC_NOCHANGE_TIMECARD');
5159:
5160: IF sub_log_msg IS NULL THEN
5161: sub_log_msg := SUBSTR (fnd_message.get (), 1, 2000);

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

5158: fnd_message.set_name ('HXC', 'HXC_NOCHANGE_TIMECARD');
5159:
5160: IF sub_log_msg IS NULL THEN
5161: sub_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
5162: fnd_file.put_line (fnd_file.LOG, sub_log_msg);
5163: rej_log_msg := NULL;
5164: fnd_file.new_line (fnd_file.LOG, 1);
5165: END IF;
5166:

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

5160: IF sub_log_msg IS NULL THEN
5161: sub_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
5162: fnd_file.put_line (fnd_file.LOG, sub_log_msg);
5163: rej_log_msg := NULL;
5164: fnd_file.new_line (fnd_file.LOG, 1);
5165: END IF;
5166:
5167: OPEN crs_employee_info (
5168: c_resource.resource_id,

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

5172: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
5173: /*ADVICE(4482): FETCH into a list of variables instead of a record [204] */
5174:
5175: CLOSE crs_employee_info;
5176: fnd_file.put_line (fnd_file.LOG, RTRIM (l_empnumber) || ' - ' || RTRIM (l_empname));
5177: hxc_lock_api.release_lock (
5178: p_row_lock_id => l_lock_row_id,
5179: p_process_locker_type => l_process_lock_type,
5180: p_transaction_lock_id => l_lock_trx_id,

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

5222: -- first insert message in log file if rejected TC is submitted without any change
5223: -- before subm,itting the TC.
5224:
5225: IF NVL (l_timecard_status, 'xx') = 'REJECTED' THEN
5226: fnd_file.new_line (fnd_file.LOG, 1);
5227: fnd_message.set_name ('HXC', 'HXC_TK_SUBMIT_UNCHANGED_TC');
5228:
5229: IF rej_log_msg IS NULL THEN
5230: rej_log_msg := SUBSTR (fnd_message.get (), 1, 2000);

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

5227: fnd_message.set_name ('HXC', 'HXC_TK_SUBMIT_UNCHANGED_TC');
5228:
5229: IF rej_log_msg IS NULL THEN
5230: rej_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
5231: fnd_file.put_line (fnd_file.LOG, rej_log_msg);
5232: sub_log_msg := NULL;
5233: fnd_file.new_line (fnd_file.LOG, 1);
5234: END IF;
5235:

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

5229: IF rej_log_msg IS NULL THEN
5230: rej_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
5231: fnd_file.put_line (fnd_file.LOG, rej_log_msg);
5232: sub_log_msg := NULL;
5233: fnd_file.new_line (fnd_file.LOG, 1);
5234: END IF;
5235:
5236: OPEN crs_employee_info (
5237: c_resource.resource_id,

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

5241: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
5242: /*ADVICE(4551): FETCH into a list of variables instead of a record [204] */
5243:
5244: CLOSE crs_employee_info;
5245: fnd_file.put_line (fnd_file.LOG, RTRIM (l_empnumber) || ' - ' || RTRIM (l_empname));
5246: END IF;
5247:
5248: l_notify_to :=
5249: hxc_preference_evaluation.resource_preferences (p_timekeeper_id, 'TK_TCARD_CLA', 3, SYSDATE);

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

5286: FETCH crs_employee_info INTO l_empnumber, l_empname, l_enddate;
5287: /*ADVICE(4595): FETCH into a list of variables instead of a record [204] */
5288:
5289: CLOSE crs_employee_info;
5290: fnd_file.new_line (fnd_file.LOG, 1);
5291: fnd_message.set_name ('HXC', 'HXC_TIMECARD_LOCKED');
5292: fnd_message.set_token ('FULL_NAME', l_empname);
5293: lock_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
5294: fnd_file.put_line (fnd_file.LOG, lock_log_msg);

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

5290: fnd_file.new_line (fnd_file.LOG, 1);
5291: fnd_message.set_name ('HXC', 'HXC_TIMECARD_LOCKED');
5292: fnd_message.set_token ('FULL_NAME', l_empname);
5293: lock_log_msg := SUBSTR (fnd_message.get (), 1, 2000);
5294: fnd_file.put_line (fnd_file.LOG, lock_log_msg);
5295: lock_log_msg := NULL;
5296: END IF;
5297: END IF;
5298: END IF;