1: PACKAGE BODY DPP_ERROR_PVT AS
2: /* $Header: dppverrb.pls 120.4.12010000.2 2010/04/21 13:36:28 kansari ship $ */
3:
4: -- Package name : DPP_ERROR_PVT
5: -- Purpose :
1: PACKAGE BODY DPP_ERROR_PVT AS
2: /* $Header: dppverrb.pls 120.4.12010000.2 2010/04/21 13:36:28 kansari ship $ */
3:
4: -- Package name : DPP_ERROR_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments
6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_ERROR_PVT';
11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
12: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dpperrb.pls';
13:
14: ---------------------------------------------------------------------
44: l_return_status varchar2(30);
45: l_msg_count number;
46: l_msg_data varchar2(4000);
47:
48: l_exe_update_rec DPP_ERROR_PVT.dpp_error_rec_type := p_exe_update_rec;
49: l_lines_tbl DPP_ERROR_PVT.dpp_lines_tbl_type := p_lines_tbl;
50: l_update_count NUMBER;
51: v_Output_XML CLOB;
52:
45: l_msg_count number;
46: l_msg_data varchar2(4000);
47:
48: l_exe_update_rec DPP_ERROR_PVT.dpp_error_rec_type := p_exe_update_rec;
49: l_lines_tbl DPP_ERROR_PVT.dpp_lines_tbl_type := p_lines_tbl;
50: l_update_count NUMBER;
51: v_Output_XML CLOB;
52:
53: l_x_exe_update_rec DPP_ExecutionDetails_PVT.DPP_EXE_UPDATE_REC_TYPE;
51: v_Output_XML CLOB;
52:
53: l_x_exe_update_rec DPP_ExecutionDetails_PVT.DPP_EXE_UPDATE_REC_TYPE;
54: l_status_Update_tbl DPP_ExecutionDetails_PVT.dpp_status_Update_tbl_type;
55: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_ERROR_PVT.UPDATE_ERROR';
56:
57: BEGIN
58:
59: -- Standard begin of API savepoint
175:
176: WHEN OTHERS THEN
177: ROLLBACK TO Update_Error_PVT;
178: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
179: fnd_message.set_token('ROUTINE', 'DPP_ERROR_PVT.Update_Error');
180: fnd_message.set_token('ERRNO', sqlcode);
181: fnd_message.set_token('REASON', sqlerrm);
182: FND_MSG_PUB.add;
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196:
197:
198: END Update_Error;
199:
200: END DPP_ERROR_PVT;