APPS.AMW_COMPLIANCE_ENV_ASSOCS_PVT dependencies on FND_API

Line 220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

216: -- if p_object_type is SETUP_RISK_TYPE, then
217: -- p_pk1 is SETUP_RISK_TYPE_ID .
218: -- ===============================================================
219: PROCEDURE PROCESS_COMPLIANCE_ENV_ASSOCS (
220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
223: p_select_flag IN VARCHAR2,
224: p_compliance_env_id IN NUMBER,

Line 221: p_commit IN VARCHAR2 := FND_API.G_FALSE,

217: -- p_pk1 is SETUP_RISK_TYPE_ID .
218: -- ===============================================================
219: PROCEDURE PROCESS_COMPLIANCE_ENV_ASSOCS (
220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
223: p_select_flag IN VARCHAR2,
224: p_compliance_env_id IN NUMBER,
225: p_object_type IN VARCHAR2,

Line 222: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,

218: -- ===============================================================
219: PROCEDURE PROCESS_COMPLIANCE_ENV_ASSOCS (
220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
221: p_commit IN VARCHAR2 := FND_API.G_FALSE,
222: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
223: p_select_flag IN VARCHAR2,
224: p_compliance_env_id IN NUMBER,
225: p_object_type IN VARCHAR2,
226: p_pk1 IN NUMBER,

Line 247: IF p_commit = FND_API.G_TRUE THEN

243:
244: BEGIN
245:
246: -- create savepoint if p_commit is true
247: IF p_commit = FND_API.G_TRUE THEN
248: SAVEPOINT compliance_env_assocs_save;
249: END IF;
250:
251: -- initialize message list if p_init_msg_list is set to true

Line 252: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

248: SAVEPOINT compliance_env_assocs_save;
249: END IF;
250:
251: -- initialize message list if p_init_msg_list is set to true
252: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
253: fnd_msg_pub.initialize;
254: end if;
255:
256: -- initialize return status to success

Line 257: x_return_status := fnd_api.g_ret_sts_success;

253: fnd_msg_pub.initialize;
254: end if;
255:
256: -- initialize return status to success
257: x_return_status := fnd_api.g_ret_sts_success;
258:
259: delete from amw_compliance_env_assocs
260: where pk1 = p_pk1
261: and object_type = p_object_type

Line 305: WHEN FND_API.G_EXC_ERROR THEN

301: l_object_version_number);
302:
303: end if;
304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: IF p_commit = FND_API.G_TRUE THEN
307: ROLLBACK TO compliance_env_assocs_save;
308: END IF;
309:

Line 306: IF p_commit = FND_API.G_TRUE THEN

302:
303: end if;
304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: IF p_commit = FND_API.G_TRUE THEN
307: ROLLBACK TO compliance_env_assocs_save;
308: END IF;
309:
310: x_return_status := FND_API.G_RET_STS_ERROR;

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

306: IF p_commit = FND_API.G_TRUE THEN
307: ROLLBACK TO compliance_env_assocs_save;
308: END IF;
309:
310: x_return_status := FND_API.G_RET_STS_ERROR;
311:
312: fnd_msg_pub.count_and_get(p_count => x_msg_count,
313: p_data => x_msg_data);
314:

Line 316: IF p_commit = FND_API.G_TRUE THEN

312: fnd_msg_pub.count_and_get(p_count => x_msg_count,
313: p_data => x_msg_data);
314:
315: WHEN OTHERS THEN
316: IF p_commit = FND_API.G_TRUE THEN
317: ROLLBACK TO compliance_env_assocs_save;
318: END IF;
319:
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

316: IF p_commit = FND_API.G_TRUE THEN
317: ROLLBACK TO compliance_env_assocs_save;
318: END IF;
319:
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321:
322: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_COMPLIANCE_ENV_ASSOCS_PVT',
323: p_procedure_name => 'PROCESS_COMPLIANCE_ENV_ASSOCS',
324: p_error_text => SUBSTRB(SQLERRM,1,240));