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.OZF_AUTO_WRITEOFF_PVT dependencies on FND_FILE

Line 131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));

127: IF (l_org_id.COUNT > 0) THEN
128: FOR m IN l_org_id.FIRST..l_org_id.LAST LOOP
129: MO_GLOBAL.set_policy_context('S',l_org_id(m));
130: -- Write OU info to OUT file
131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
133: -- Write OU info to LOG file
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
135: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');

Line 132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');

128: FOR m IN l_org_id.FIRST..l_org_id.LAST LOOP
129: MO_GLOBAL.set_policy_context('S',l_org_id(m));
130: -- Write OU info to OUT file
131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
133: -- Write OU info to LOG file
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
135: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');
136:

Line 134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));

130: -- Write OU info to OUT file
131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
133: -- Write OU info to LOG file
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
135: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');
136:
137: -- Get meaning for the names
138: IF p_claim_class is not null then

Line 135: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');

131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-----------------------------------------------------');
133: -- Write OU info to LOG file
134: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || MO_GLOBAL.get_ou_name(l_org_id(m)));
135: FND_FILE.PUT_LINE(FND_FILE.LOG, '-----------------------------------------------------');
136:
137: -- Get meaning for the names
138: IF p_claim_class is not null then
139: open get_claim_class_csr (p_claim_class);

Line 163: FND_FILE.PUT_LINE(FND_FILE.LOG, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');

159: close get_account_name_csr;
160: end if;
161:
162: -- Write Batch Initialization summary info to LOG file
163: FND_FILE.PUT_LINE(FND_FILE.LOG, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
165: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter2-Customer : '||l_party_name);

Line 164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

160: end if;
161:
162: -- Write Batch Initialization summary info to LOG file
163: FND_FILE.PUT_LINE(FND_FILE.LOG, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
165: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter2-Customer : '||l_party_name);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter3-Claim Type : '||l_claim_type_name);

Line 165: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');

161:
162: -- Write Batch Initialization summary info to LOG file
163: FND_FILE.PUT_LINE(FND_FILE.LOG, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
165: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter2-Customer : '||l_party_name);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter3-Claim Type : '||l_claim_type_name);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter4-Reason Code: '||l_reason_code_name);

Line 166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter1-Claim Class: '||l_claim_class_mean);

162: -- Write Batch Initialization summary info to LOG file
163: FND_FILE.PUT_LINE(FND_FILE.LOG, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
165: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter2-Customer : '||l_party_name);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter3-Claim Type : '||l_claim_type_name);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter4-Reason Code: '||l_reason_code_name);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');

Line 167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter2-Customer : '||l_party_name);

163: FND_FILE.PUT_LINE(FND_FILE.LOG, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
165: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter2-Customer : '||l_party_name);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter3-Claim Type : '||l_claim_type_name);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter4-Reason Code: '||l_reason_code_name);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
171:

Line 168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter3-Claim Type : '||l_claim_type_name);

164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Starts on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
165: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter2-Customer : '||l_party_name);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter3-Claim Type : '||l_claim_type_name);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter4-Reason Code: '||l_reason_code_name);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
171:
172: -- Write Batch Initialization summary info to OUT file

Line 169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter4-Reason Code: '||l_reason_code_name);

165: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter2-Customer : '||l_party_name);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter3-Claim Type : '||l_claim_type_name);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter4-Reason Code: '||l_reason_code_name);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
171:
172: -- Write Batch Initialization summary info to OUT file
173: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');

Line 170: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');

166: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
167: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter2-Customer : '||l_party_name);
168: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter3-Claim Type : '||l_claim_type_name);
169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter4-Reason Code: '||l_reason_code_name);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
171:
172: -- Write Batch Initialization summary info to OUT file
173: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Started on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 173: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');

169: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Parameter4-Reason Code: '||l_reason_code_name);
170: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
171:
172: -- Write Batch Initialization summary info to OUT file
173: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Started on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter2-Customer : '||l_party_name);

Line 174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Started on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

170: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
171:
172: -- Write Batch Initialization summary info to OUT file
173: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Started on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter2-Customer : '||l_party_name);
178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter3-Claim Type : '||l_claim_type_name);

Line 175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');

171:
172: -- Write Batch Initialization summary info to OUT file
173: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Started on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter2-Customer : '||l_party_name);
178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter3-Claim Type : '||l_claim_type_name);
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter4-Reason Code: '||l_reason_code_name);

Line 176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter1-Claim Class: '||l_claim_class_mean);

172: -- Write Batch Initialization summary info to OUT file
173: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Started on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter2-Customer : '||l_party_name);
178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter3-Claim Type : '||l_claim_type_name);
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter4-Reason Code: '||l_reason_code_name);
180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');

Line 177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter2-Customer : '||l_party_name);

173: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+------------------- AUTO-WRITEOFF PROCESS START SUMMARY -------------------+');
174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Started on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter2-Customer : '||l_party_name);
178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter3-Claim Type : '||l_claim_type_name);
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter4-Reason Code: '||l_reason_code_name);
180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
181:

Line 178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter3-Claim Type : '||l_claim_type_name);

174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Started on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter2-Customer : '||l_party_name);
178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter3-Claim Type : '||l_claim_type_name);
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter4-Reason Code: '||l_reason_code_name);
180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
181:
182: --bug#4940880 Update Payment Method

Line 179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter4-Reason Code: '||l_reason_code_name);

175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter2-Customer : '||l_party_name);
178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter3-Claim Type : '||l_claim_type_name);
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter4-Reason Code: '||l_reason_code_name);
180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
181:
182: --bug#4940880 Update Payment Method
183: UPDATE ozf_claims

Line 180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');

176: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter1-Claim Class: '||l_claim_class_mean);
177: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter2-Customer : '||l_party_name);
178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter3-Claim Type : '||l_claim_type_name);
179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter4-Reason Code: '||l_reason_code_name);
180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
181:
182: --bug#4940880 Update Payment Method
183: UPDATE ozf_claims
184: SET payment_method = 'WRITE_OFF'

Line 218: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'STATUS CODE: '||l_claim_rec.status_code);

214:
215: --Assign claim status to 'CLOSED'
216: l_claim_rec.status_code := 'CLOSED';
217: l_claim_rec.user_status_id := null;
218: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'STATUS CODE: '||l_claim_rec.status_code);
219:
220: --Assign Payment Method to 'WRITE OFF'
221: l_claim_rec.payment_method := 'WRITE_OFF';
222:

Line 243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);

239: IF l_return_status = FND_API.g_ret_sts_error THEN
240: v_tot_writeoff_not_processed := v_tot_writeoff_not_processed + 1;
241: ROLLBACK TO Populate_Auto_Writeoff_Data;
242: --RAISE FND_API.g_exc_error;
243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
245: OZF_UTILITY_PVT.write_conc_log;
246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
247: v_tot_writeoff_not_processed := v_tot_writeoff_not_processed + 1;

Line 244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);

240: v_tot_writeoff_not_processed := v_tot_writeoff_not_processed + 1;
241: ROLLBACK TO Populate_Auto_Writeoff_Data;
242: --RAISE FND_API.g_exc_error;
243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
245: OZF_UTILITY_PVT.write_conc_log;
246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
247: v_tot_writeoff_not_processed := v_tot_writeoff_not_processed + 1;
248: ROLLBACK TO Populate_Auto_Writeoff_Data;

Line 250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);

246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
247: v_tot_writeoff_not_processed := v_tot_writeoff_not_processed + 1;
248: ROLLBACK TO Populate_Auto_Writeoff_Data;
249: --RAISE FND_API.g_exc_unexpected_error;
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
252: OZF_UTILITY_PVT.write_conc_log;
253: ELSE
254: v_tot_writeoff_processed := v_tot_writeoff_processed + 1;

Line 251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);

247: v_tot_writeoff_not_processed := v_tot_writeoff_not_processed + 1;
248: ROLLBACK TO Populate_Auto_Writeoff_Data;
249: --RAISE FND_API.g_exc_unexpected_error;
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
252: OZF_UTILITY_PVT.write_conc_log;
253: ELSE
254: v_tot_writeoff_processed := v_tot_writeoff_processed + 1;
255: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off is Successful for claim Number: '||l_claim_rec.claim_number);

Line 255: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off is Successful for claim Number: '||l_claim_rec.claim_number);

251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off Failed for claim Number: '||l_claim_rec.claim_number);
252: OZF_UTILITY_PVT.write_conc_log;
253: ELSE
254: v_tot_writeoff_processed := v_tot_writeoff_processed + 1;
255: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off is Successful for claim Number: '||l_claim_rec.claim_number);
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off is Successful for claim Number: '||l_claim_rec.claim_number);
257: END IF;
258: -- ************************************************************************************
259: EXCEPTION

Line 256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off is Successful for claim Number: '||l_claim_rec.claim_number);

252: OZF_UTILITY_PVT.write_conc_log;
253: ELSE
254: v_tot_writeoff_processed := v_tot_writeoff_processed + 1;
255: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Auto Write off is Successful for claim Number: '||l_claim_rec.claim_number);
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Auto Write off is Successful for claim Number: '||l_claim_rec.claim_number);
257: END IF;
258: -- ************************************************************************************
259: EXCEPTION
260: WHEN OTHERS THEN

Line 266: FND_FILE.PUT_LINE(FND_FILE.LOG, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');

262: END;
263: END LOOP;
264:
265: -- Write Batch summary info to LOG file
266: FND_FILE.PUT_LINE(FND_FILE.LOG, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Ends on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
268: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);

Line 267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Ends on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

263: END LOOP;
264:
265: -- Write Batch summary info to LOG file
266: FND_FILE.PUT_LINE(FND_FILE.LOG, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Ends on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
268: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);

Line 268: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');

264:
265: -- Write Batch summary info to LOG file
266: FND_FILE.PUT_LINE(FND_FILE.LOG, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Ends on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
268: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
272: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');

Line 269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);

265: -- Write Batch summary info to LOG file
266: FND_FILE.PUT_LINE(FND_FILE.LOG, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Ends on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
268: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
272: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
273:

Line 270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);

266: FND_FILE.PUT_LINE(FND_FILE.LOG, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Ends on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
268: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
272: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
273:
274: -- Write Batch summary info to OUT file

Line 271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);

267: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Job Ends on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
268: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
272: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
273:
274: -- Write Batch summary info to OUT file
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');

Line 272: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');

268: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
269: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
272: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
273:
274: -- Write Batch summary info to OUT file
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');

271: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
272: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
273:
274: -- Write Batch summary info to OUT file
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);

Line 276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

272: FND_FILE.PUT_LINE(FND_FILE.LOG, '+---------------------------------------------------------------------------+');
273:
274: -- Write Batch summary info to OUT file
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);

Line 277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');

273:
274: -- Write Batch summary info to OUT file
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');

Line 278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);

274: -- Write Batch summary info to OUT file
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
282:

Line 279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);

275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+-------------------- AUTO-WRITEOFF PROCESS END SUMMARY --------------------+');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
282:
283: END LOOP;

Line 280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);

276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Ended on: '||to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
282:
283: END LOOP;
284: END IF;

Line 281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');

277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Selected for Write offs........: '||v_total_writeoff_count);
279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims Processed for Write offs.......: '||v_tot_writeoff_processed);
280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Total Number of Claims NOT Processed for Write offs...: '||v_tot_writeoff_not_processed);
281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
282:
283: END LOOP;
284: END IF;
285: