22: --Bug#5512040 RAVI (Constrict message to 240 char)
23: G_msg_rec.error_message(l_index) := SUBSTR(fnd_message.get,1,240);
24:
25: EXCEPTION
26: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
27: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
29: WHEN OTHERS THEN
30: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
24:
25: EXCEPTION
26: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
27: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
29: WHEN OTHERS THEN
30: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END ADD;
27: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
28: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
29: WHEN OTHERS THEN
30: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END ADD;
33:
34: PROCEDURE SAVE_MESSAGE
35: (p_request_id NUMBER)
91: G_MSG_REC.orig_sys_pricing_attr_ref.delete;
92: G_MSG_REC.error_message.delete;
93:
94: EXCEPTION
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSAGE');
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: WHEN OTHERS THEN
99: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSSAGE');
93:
94: EXCEPTION
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSAGE');
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: WHEN OTHERS THEN
99: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSSAGE');
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101:
96: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSAGE');
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: WHEN OTHERS THEN
99: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSSAGE');
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101:
102: END SAVE_MESSAGE;
103:
104: END QP_BULK_MSG;