APPS.ZPB_ACVAL_PVT dependencies on ZPB_ACVAL_PVT

Line 1: PACKAGE BODY ZPB_ACVAL_PVT AS

1: PACKAGE BODY ZPB_ACVAL_PVT AS
2: /* $Header: ZPBACVLB.pls 120.19 2007/12/04 14:32:40 mbhat ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(15) := 'zpb_acval_pvt';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(15) := 'zpb_acval_pvt';

1: PACKAGE BODY ZPB_ACVAL_PVT AS
2: /* $Header: ZPBACVLB.pls 120.19 2007/12/04 14:32:40 mbhat ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(15) := 'zpb_acval_pvt';
6:
7: -------------------------------------------------------------------------------
8:
9: PROCEDURE validate_currentrun_helper (

Line 258: SAVEPOINT zpb_acval_pvt_validate;

254: x_changeCurrentRun := 'Y';
255: i := 4;
256:
257: -- Standard Start of API savepoint
258: SAVEPOINT zpb_acval_pvt_validate;
259:
260: -- API body
261: l_edt_ac_id := p_analysis_cycle_id;
262:

Line 475: ROLLBACK TO zpb_acval_pvt_validate;

471:
472: /*
473: EXCEPTION
474: WHEN FND_API.G_EXC_ERROR THEN
475: ROLLBACK TO zpb_acval_pvt_validate;
476: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
477: x_changeCurrentRun := 'Y';
478: return;
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 480: ROLLBACK TO zpb_acval_pvt_validate;

476: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
477: x_changeCurrentRun := 'Y';
478: return;
479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
480: ROLLBACK TO zpb_acval_pvt_validate;
481: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
482: x_changeCurrentRun := 'Y';
483: return;
484:

Line 486: ROLLBACK TO zpb_acval_pvt_validate;

482: x_changeCurrentRun := 'Y';
483: return;
484:
485: WHEN OTHERS THEN
486: ROLLBACK TO zpb_acval_pvt_validate;
487: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
488: x_changeCurrentRun := 'Y';
489: return;
490: */

Line 2943: SAVEPOINT zpb_acval_pvt_delete_view;

2939: where analysis_cycle_id = p_analysis_cycle_id;
2940:
2941: BEGIN
2942: -- Standard Start of API savepoint
2943: SAVEPOINT zpb_acval_pvt_delete_view;
2944: open published_ac;
2945: fetch published_ac into l_status_code;
2946: close published_ac;
2947:

Line 2959: ROLLBACK TO zpb_acval_pvt_delete_view;

2955: ZPB_LOG.WRITE(G_PKG_NAME || '.' || l_api_name, ' View Deleted with Analysis Cycleid' || p_analysis_cycle_id || '.');
2956:
2957: EXCEPTION
2958: WHEN FND_API.G_EXC_ERROR THEN
2959: ROLLBACK TO zpb_acval_pvt_delete_view;
2960: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2961:
2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2963: ROLLBACK TO zpb_acval_pvt_delete_view;

Line 2963: ROLLBACK TO zpb_acval_pvt_delete_view;

2959: ROLLBACK TO zpb_acval_pvt_delete_view;
2960: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2961:
2962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2963: ROLLBACK TO zpb_acval_pvt_delete_view;
2964: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2965:
2966:
2967: WHEN OTHERS THEN

Line 2968: ROLLBACK TO zpb_acval_pvt_delete_view;

2964: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2965:
2966:
2967: WHEN OTHERS THEN
2968: ROLLBACK TO zpb_acval_pvt_delete_view;
2969: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2970:
2971: end delete_view;
2972: -------------------------------------------------------------------------------

Line 3028: END zpb_acval_pvt;

3024: END IF;
3025:
3026: END has_validation_errors;
3027:
3028: END zpb_acval_pvt;