75: IF p_dml_flag = 'C' THEN
76: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
78: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
79: ': before calling ahl_uc_unitconfig_pvt.create_uc_header');
80: END IF;
81: ahl_uc_unitconfig_pvt.create_uc_header(
82: p_api_version => 1.0,
83: p_init_msg_list => FND_API.G_FALSE,
77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
78: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
79: ': before calling ahl_uc_unitconfig_pvt.create_uc_header');
80: END IF;
81: ahl_uc_unitconfig_pvt.create_uc_header(
82: p_api_version => 1.0,
83: p_init_msg_list => FND_API.G_FALSE,
84: p_commit => FND_API.G_FALSE,
85: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
91: ELSIF p_dml_flag = 'U' THEN
92: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
94: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
95: ': before calling ahl_uc_unitconfig_pvt.update_uc_header');
96: END IF;
97: ahl_uc_unitconfig_pvt.update_uc_header(
98: p_api_version => 1.0,
99: p_init_msg_list => FND_API.G_FALSE,
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
94: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
95: ': before calling ahl_uc_unitconfig_pvt.update_uc_header');
96: END IF;
97: ahl_uc_unitconfig_pvt.update_uc_header(
98: p_api_version => 1.0,
99: p_init_msg_list => FND_API.G_FALSE,
100: p_commit => FND_API.G_FALSE,
101: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
108: ELSIF p_dml_flag = 'D' THEN
109: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
110: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
111: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name,
112: ': before calling ahl_uc_unitconfig_pvt.delete_uc_header');
113: END IF;
114:
115: --Get the object_version_number of the uc_header and csi instance record
116: OPEN get_ovns(p_x_uc_header_rec.uc_header_id);
123: CLOSE get_ovns;
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126: CLOSE get_ovns;
127: ahl_uc_unitconfig_pvt.delete_uc_header(
128: p_api_version => 1.0,
129: p_init_msg_list => FND_API.G_FALSE,
130: p_commit => FND_API.G_FALSE,
131: p_validation_level => FND_API.G_VALID_LEVEL_FULL,