24: G_msg_rec.error_message(l_index) := SUBSTR(fnd_message.get,1,240);
25: G_msg_rec.message_type(l_index) := p_msg_type; --bug no: 9652756
26:
27: EXCEPTION
28: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
29: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: WHEN OTHERS THEN
32: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
26:
27: EXCEPTION
28: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
29: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: WHEN OTHERS THEN
32: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
33: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
34: END ADD;
29: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: WHEN OTHERS THEN
32: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.ADD');
33: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
34: END ADD;
35:
36: PROCEDURE SAVE_MESSAGE
37: (p_request_id NUMBER)
96: G_MSG_REC.error_message.delete;
97: G_MSG_REC.message_type.delete; --bug no: 9652756
98:
99: EXCEPTION
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSAGE');
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: WHEN OTHERS THEN
104: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSSAGE');
98:
99: EXCEPTION
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSAGE');
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: WHEN OTHERS THEN
104: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSSAGE');
105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106:
101: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSAGE');
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: WHEN OTHERS THEN
104: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_MSG.SAVE_MESSSAGE');
105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106:
107: END SAVE_MESSAGE;
108:
109: END QP_BULK_MSG;