60:
61:
62: EXCEPTION
63: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
64: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
65: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
66: (
67: l_api_name,
68: G_PKG_NAME,
71: x_msg_data,
72: '_PVT'
73: );
74: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
75: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
76: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
77: (
78: l_api_name,
79: G_PKG_NAME,
82: x_msg_data,
83: '_PVT'
84: );
85: WHEN OTHERS THEN
86: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (Others) => '||SQLERRM);
87: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
88: (
89: l_api_name,
90: G_PKG_NAME,
148:
149: fnd_msg_pub.delete_msg();
150:
151: l_mesg_len := length(l_mesg);
152: fnd_file.put_line(fnd_file.log, 'Error: ');
153: fnd_file.put_line(fnd_file.output, 'Error: ');
154:
155: FOR i IN 1..ceil(l_mesg_len/255) LOOP
156: fnd_file.put_line(fnd_file.log, l_mesg);
149: fnd_msg_pub.delete_msg();
150:
151: l_mesg_len := length(l_mesg);
152: fnd_file.put_line(fnd_file.log, 'Error: ');
153: fnd_file.put_line(fnd_file.output, 'Error: ');
154:
155: FOR i IN 1..ceil(l_mesg_len/255) LOOP
156: fnd_file.put_line(fnd_file.log, l_mesg);
157: fnd_file.put_line(fnd_file.output, l_mesg);
152: fnd_file.put_line(fnd_file.log, 'Error: ');
153: fnd_file.put_line(fnd_file.output, 'Error: ');
154:
155: FOR i IN 1..ceil(l_mesg_len/255) LOOP
156: fnd_file.put_line(fnd_file.log, l_mesg);
157: fnd_file.put_line(fnd_file.output, l_mesg);
158: END LOOP;
159:
160: fnd_file.new_line(fnd_file.log,2);
153: fnd_file.put_line(fnd_file.output, 'Error: ');
154:
155: FOR i IN 1..ceil(l_mesg_len/255) LOOP
156: fnd_file.put_line(fnd_file.log, l_mesg);
157: fnd_file.put_line(fnd_file.output, l_mesg);
158: END LOOP;
159:
160: fnd_file.new_line(fnd_file.log,2);
161: fnd_file.new_line(fnd_file.output,2);
156: fnd_file.put_line(fnd_file.log, l_mesg);
157: fnd_file.put_line(fnd_file.output, l_mesg);
158: END LOOP;
159:
160: fnd_file.new_line(fnd_file.log,2);
161: fnd_file.new_line(fnd_file.output,2);
162: END IF;
163:
164: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
157: fnd_file.put_line(fnd_file.output, l_mesg);
158: END LOOP;
159:
160: fnd_file.new_line(fnd_file.log,2);
161: fnd_file.new_line(fnd_file.output,2);
162: END IF;
163:
164: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
165: fnd_file.put_line(fnd_file.log, 'Late Interest Calculation Failed');
161: fnd_file.new_line(fnd_file.output,2);
162: END IF;
163:
164: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
165: fnd_file.put_line(fnd_file.log, 'Late Interest Calculation Failed');
166: fnd_file.put_line(fnd_file.output, 'Late Interest Calculation Failed');
167: END IF;
168:
169:
162: END IF;
163:
164: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
165: fnd_file.put_line(fnd_file.log, 'Late Interest Calculation Failed');
166: fnd_file.put_line(fnd_file.output, 'Late Interest Calculation Failed');
167: END IF;
168:
169:
170: fnd_file.put_line(fnd_file.log,'msg data '||l_msg_data);
166: fnd_file.put_line(fnd_file.output, 'Late Interest Calculation Failed');
167: END IF;
168:
169:
170: fnd_file.put_line(fnd_file.log,'msg data '||l_msg_data);
171: fnd_file.put_line(fnd_file.log,'return status '||l_return_status);
172: fnd_file.put_line(fnd_file.output,'msg data '||l_msg_data);
173: fnd_file.put_line(fnd_file.output,'return status '||l_return_status);
174:
167: END IF;
168:
169:
170: fnd_file.put_line(fnd_file.log,'msg data '||l_msg_data);
171: fnd_file.put_line(fnd_file.log,'return status '||l_return_status);
172: fnd_file.put_line(fnd_file.output,'msg data '||l_msg_data);
173: fnd_file.put_line(fnd_file.output,'return status '||l_return_status);
174:
175: EXCEPTION
168:
169:
170: fnd_file.put_line(fnd_file.log,'msg data '||l_msg_data);
171: fnd_file.put_line(fnd_file.log,'return status '||l_return_status);
172: fnd_file.put_line(fnd_file.output,'msg data '||l_msg_data);
173: fnd_file.put_line(fnd_file.output,'return status '||l_return_status);
174:
175: EXCEPTION
176: WHEN OTHERS THEN
169:
170: fnd_file.put_line(fnd_file.log,'msg data '||l_msg_data);
171: fnd_file.put_line(fnd_file.log,'return status '||l_return_status);
172: fnd_file.put_line(fnd_file.output,'msg data '||l_msg_data);
173: fnd_file.put_line(fnd_file.output,'return status '||l_return_status);
174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (Others) => '||SQLERRM);
173: fnd_file.put_line(fnd_file.output,'return status '||l_return_status);
174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (Others) => '||SQLERRM);
178: l_return_status :=Okl_Api.HANDLE_EXCEPTIONS
179: (
180: l_api_name,
181: G_PKG_NAME,