56: );
57:
58:
59: -- Add couple of blank lines
60: fnd_file.new_line(fnd_file.log,2);
61: fnd_file.new_line(fnd_file.output,2);
62:
63:
64:
57:
58:
59: -- Add couple of blank lines
60: fnd_file.new_line(fnd_file.log,2);
61: fnd_file.new_line(fnd_file.output,2);
62:
63:
64:
65:
62:
63:
64:
65:
66: fnd_file.new_line(fnd_file.log,2);
67: fnd_file.new_line(fnd_file.output,2);
68:
69: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
70: fnd_file.put_line(fnd_file.log, 'MASS REBOOK Process Failed, None of the transactions got processed');
63:
64:
65:
66: fnd_file.new_line(fnd_file.log,2);
67: fnd_file.new_line(fnd_file.output,2);
68:
69: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
70: fnd_file.put_line(fnd_file.log, 'MASS REBOOK Process Failed, None of the transactions got processed');
71: fnd_file.put_line(fnd_file.output, 'MASS REBOOK Process Failed, None of the transactions got processed');
66: fnd_file.new_line(fnd_file.log,2);
67: fnd_file.new_line(fnd_file.output,2);
68:
69: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
70: fnd_file.put_line(fnd_file.log, 'MASS REBOOK Process Failed, None of the transactions got processed');
71: fnd_file.put_line(fnd_file.output, 'MASS REBOOK Process Failed, None of the transactions got processed');
72: END IF;
73:
74: IF l_total_count = 0 THEN
67: fnd_file.new_line(fnd_file.output,2);
68:
69: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
70: fnd_file.put_line(fnd_file.log, 'MASS REBOOK Process Failed, None of the transactions got processed');
71: fnd_file.put_line(fnd_file.output, 'MASS REBOOK Process Failed, None of the transactions got processed');
72: END IF;
73:
74: IF l_total_count = 0 THEN
75: fnd_file.put_line(fnd_file.log, 'There were no Residual Value Writedown transactions to process.');
71: fnd_file.put_line(fnd_file.output, 'MASS REBOOK Process Failed, None of the transactions got processed');
72: END IF;
73:
74: IF l_total_count = 0 THEN
75: fnd_file.put_line(fnd_file.log, 'There were no Residual Value Writedown transactions to process.');
76: fnd_file.put_line(fnd_file.output,'There were no Residual Value Writedown transactions to process.');
77: ELSE
78:
79: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
72: END IF;
73:
74: IF l_total_count = 0 THEN
75: fnd_file.put_line(fnd_file.log, 'There were no Residual Value Writedown transactions to process.');
76: fnd_file.put_line(fnd_file.output,'There were no Residual Value Writedown transactions to process.');
77: ELSE
78:
79: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
80: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
75: fnd_file.put_line(fnd_file.log, 'There were no Residual Value Writedown transactions to process.');
76: fnd_file.put_line(fnd_file.output,'There were no Residual Value Writedown transactions to process.');
77: ELSE
78:
79: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
80: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
81: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
82:
83: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
76: fnd_file.put_line(fnd_file.output,'There were no Residual Value Writedown transactions to process.');
77: ELSE
78:
79: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
80: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
81: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
82:
83: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
84: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
77: ELSE
78:
79: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
80: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
81: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
82:
83: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
84: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
85: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
79: fnd_file.put_line(fnd_file.log, 'Total Transactions : '||l_total_count);
80: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
81: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
82:
83: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
84: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
85: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
86:
87: END IF;
80: fnd_file.put_line(fnd_file.log, 'Transactions Processed Successfully : '||l_processed_count);
81: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
82:
83: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
84: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
85: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
86:
87: END IF;
88:
81: fnd_file.put_line(fnd_file.log, 'Transactions Failed : '||l_error_count);
82:
83: fnd_file.put_line(fnd_file.output, 'Total Transactions : '||l_total_count);
84: fnd_file.put_line(fnd_file.output, 'Transactions Processed Successfully : '||l_processed_count);
85: fnd_file.put_line(fnd_file.output, 'Transactions Failed : '||l_error_count);
86:
87: END IF;
88:
89:
410: p_msg_index_out => lx_error_rec.msg_count);
411:
412: IF (lx_error_rec.msg_count IS NOT NULL) THEN
413:
414: fnd_file.put_line(fnd_file.log, lx_error_rec.msg_data);
415: fnd_file.put_line(fnd_file.output, lx_error_rec.msg_data);
416:
417: END IF;
418:
411:
412: IF (lx_error_rec.msg_count IS NOT NULL) THEN
413:
414: fnd_file.put_line(fnd_file.log, lx_error_rec.msg_data);
415: fnd_file.put_line(fnd_file.output, lx_error_rec.msg_data);
416:
417: END IF;
418:
419: EXIT WHEN ((lx_error_rec.msg_count = FND_MSG_PUB.COUNT_MSG) OR (lx_error_rec.msg_count IS NULL));