64:
65: fnd_msg_pub.delete_msg();
66:
67: l_mesg_len := length(l_mesg);
68: fnd_file.put_line(fnd_file.log, 'Error: ');
69: fnd_file.put_line(fnd_file.output, 'Error: ');
70:
71: FOR i IN 1..ceil(l_mesg_len/255) LOOP
72: fnd_file.put_line(fnd_file.log, l_mesg);
65: fnd_msg_pub.delete_msg();
66:
67: l_mesg_len := length(l_mesg);
68: fnd_file.put_line(fnd_file.log, 'Error: ');
69: fnd_file.put_line(fnd_file.output, 'Error: ');
70:
71: FOR i IN 1..ceil(l_mesg_len/255) LOOP
72: fnd_file.put_line(fnd_file.log, l_mesg);
73: fnd_file.put_line(fnd_file.output, l_mesg);
68: fnd_file.put_line(fnd_file.log, 'Error: ');
69: fnd_file.put_line(fnd_file.output, 'Error: ');
70:
71: FOR i IN 1..ceil(l_mesg_len/255) LOOP
72: fnd_file.put_line(fnd_file.log, l_mesg);
73: fnd_file.put_line(fnd_file.output, l_mesg);
74: END LOOP;
75:
76: fnd_file.new_line(fnd_file.log,2);
69: fnd_file.put_line(fnd_file.output, 'Error: ');
70:
71: FOR i IN 1..ceil(l_mesg_len/255) LOOP
72: fnd_file.put_line(fnd_file.log, l_mesg);
73: fnd_file.put_line(fnd_file.output, l_mesg);
74: END LOOP;
75:
76: fnd_file.new_line(fnd_file.log,2);
77: fnd_file.new_line(fnd_file.output,2);
72: fnd_file.put_line(fnd_file.log, l_mesg);
73: fnd_file.put_line(fnd_file.output, l_mesg);
74: END LOOP;
75:
76: fnd_file.new_line(fnd_file.log,2);
77: fnd_file.new_line(fnd_file.output,2);
78: END IF;
79:
80: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
73: fnd_file.put_line(fnd_file.output, l_mesg);
74: END LOOP;
75:
76: fnd_file.new_line(fnd_file.log,2);
77: fnd_file.new_line(fnd_file.output,2);
78: END IF;
79:
80: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
81: fnd_file.put_line(fnd_file.log, 'FA ADJUSTMENTS Failed, None of the transactions got processed');
77: fnd_file.new_line(fnd_file.output,2);
78: END IF;
79:
80: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
81: fnd_file.put_line(fnd_file.log, 'FA ADJUSTMENTS Failed, None of the transactions got processed');
82: fnd_file.put_line(fnd_file.output, 'FA ADJUSTMENTS Failed, None of the transactions got processed');
83: END IF;
84:
85: IF l_return_status = OKC_API.G_RET_STS_SUCCESS AND
78: END IF;
79:
80: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
81: fnd_file.put_line(fnd_file.log, 'FA ADJUSTMENTS Failed, None of the transactions got processed');
82: fnd_file.put_line(fnd_file.output, 'FA ADJUSTMENTS Failed, None of the transactions got processed');
83: END IF;
84:
85: IF l_return_status = OKC_API.G_RET_STS_SUCCESS AND
86: l_transaction_status <> OKC_API.G_RET_STS_SUCCESS THEN
83: END IF;
84:
85: IF l_return_status = OKC_API.G_RET_STS_SUCCESS AND
86: l_transaction_status <> OKC_API.G_RET_STS_SUCCESS THEN
87: fnd_file.put_line(fnd_file.log, 'One or more transactions failed');
88: fnd_file.put_line(fnd_file.output, 'One or more transactions failed');
89: END IF;
90:
91: IF l_return_status = OKC_API.G_RET_STS_SUCCESS AND
84:
85: IF l_return_status = OKC_API.G_RET_STS_SUCCESS AND
86: l_transaction_status <> OKC_API.G_RET_STS_SUCCESS THEN
87: fnd_file.put_line(fnd_file.log, 'One or more transactions failed');
88: fnd_file.put_line(fnd_file.output, 'One or more transactions failed');
89: END IF;
90:
91: IF l_return_status = OKC_API.G_RET_STS_SUCCESS AND
92: l_transaction_status = OKC_API.G_RET_STS_SUCCESS THEN
89: END IF;
90:
91: IF l_return_status = OKC_API.G_RET_STS_SUCCESS AND
92: l_transaction_status = OKC_API.G_RET_STS_SUCCESS THEN
93: fnd_file.put_line(fnd_file.log, 'All the transactions got processed successfully');
94: fnd_file.put_line(fnd_file.output, 'All the transactions got processed successfully');
95: END IF;
96:
97:
90:
91: IF l_return_status = OKC_API.G_RET_STS_SUCCESS AND
92: l_transaction_status = OKC_API.G_RET_STS_SUCCESS THEN
93: fnd_file.put_line(fnd_file.log, 'All the transactions got processed successfully');
94: fnd_file.put_line(fnd_file.output, 'All the transactions got processed successfully');
95: END IF;
96:
97:
98: fnd_file.put_line(fnd_file.log,'KHR ID '||TO_CHAR(P_CONTRACT_ID));
94: fnd_file.put_line(fnd_file.output, 'All the transactions got processed successfully');
95: END IF;
96:
97:
98: fnd_file.put_line(fnd_file.log,'KHR ID '||TO_CHAR(P_CONTRACT_ID));
99: fnd_file.put_line(fnd_file.log,'KLE_ID '||P_KLE_ID);
100: fnd_file.put_line(fnd_file.log,'msg data '||l_msg_data);
101: fnd_file.put_line(fnd_file.log,'return status '||l_return_status);
102: fnd_file.put_line(fnd_file.log,'transaction status '||l_transaction_status);
95: END IF;
96:
97:
98: fnd_file.put_line(fnd_file.log,'KHR ID '||TO_CHAR(P_CONTRACT_ID));
99: fnd_file.put_line(fnd_file.log,'KLE_ID '||P_KLE_ID);
100: fnd_file.put_line(fnd_file.log,'msg data '||l_msg_data);
101: fnd_file.put_line(fnd_file.log,'return status '||l_return_status);
102: fnd_file.put_line(fnd_file.log,'transaction status '||l_transaction_status);
103:
96:
97:
98: fnd_file.put_line(fnd_file.log,'KHR ID '||TO_CHAR(P_CONTRACT_ID));
99: fnd_file.put_line(fnd_file.log,'KLE_ID '||P_KLE_ID);
100: fnd_file.put_line(fnd_file.log,'msg data '||l_msg_data);
101: fnd_file.put_line(fnd_file.log,'return status '||l_return_status);
102: fnd_file.put_line(fnd_file.log,'transaction status '||l_transaction_status);
103:
104: END;
97:
98: fnd_file.put_line(fnd_file.log,'KHR ID '||TO_CHAR(P_CONTRACT_ID));
99: fnd_file.put_line(fnd_file.log,'KLE_ID '||P_KLE_ID);
100: fnd_file.put_line(fnd_file.log,'msg data '||l_msg_data);
101: fnd_file.put_line(fnd_file.log,'return status '||l_return_status);
102: fnd_file.put_line(fnd_file.log,'transaction status '||l_transaction_status);
103:
104: END;
105:
98: fnd_file.put_line(fnd_file.log,'KHR ID '||TO_CHAR(P_CONTRACT_ID));
99: fnd_file.put_line(fnd_file.log,'KLE_ID '||P_KLE_ID);
100: fnd_file.put_line(fnd_file.log,'msg data '||l_msg_data);
101: fnd_file.put_line(fnd_file.log,'return status '||l_return_status);
102: fnd_file.put_line(fnd_file.log,'transaction status '||l_transaction_status);
103:
104: END;
105:
106: END;