APPS.EGO_ITEMS_ATTRS_CHANGES_PKG dependencies on FND_API

Line 441: x_return_status := FND_API.G_RET_STS_ERROR;

437: code_debug(' params p_object_name ' ||p_object_name||' p_change_id '||p_change_id||' p_change_line_id '||p_change_line_id);
438: code_debug(' params p_instance_pk1_value ' ||p_instance_pk1_value||' p_instance_pk2_value '||p_instance_pk2_value||' p_instance_pk3_value '||p_instance_pk3_value);
439: l_api_version := 1.0;
440: l_api_name := 'DELETE_OBJ_PENDING_CHANGES';
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: l_dynamic_sql_b := NULL;
443: l_dynamic_sql_tl := NULL;
444: -- standard check for API validation
445: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 445: IF NOT FND_API.Compatible_API_Call (l_api_version,

441: x_return_status := FND_API.G_RET_STS_ERROR;
442: l_dynamic_sql_b := NULL;
443: l_dynamic_sql_tl := NULL;
444: -- standard check for API validation
445: IF NOT FND_API.Compatible_API_Call (l_api_version,
446: p_api_version,
447: l_api_name,
448: G_PKG_NAME) THEN
449: code_debug(' Invalid Params Passed ');

Line 450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

446: p_api_version,
447: l_api_name,
448: G_PKG_NAME) THEN
449: code_debug(' Invalid Params Passed ');
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
451: END IF;
452:
453: IF ( p_object_name IS NULL
454: OR

Line 560: x_return_status := FND_API.G_RET_STS_SUCCESS;

556: EXECUTE IMMEDIATE l_dynamic_sql_tl;
557: l_dynamic_sql_b := 'DELETE '||l_delete_table_b||l_dynamic_sql;
558: code_debug(' Deleting from the base table ');
559: EXECUTE IMMEDIATE l_dynamic_sql_b;
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561: EXCEPTION
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: code_debug( 'EXCEPTION why this ');
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

558: code_debug(' Deleting from the base table ');
559: EXECUTE IMMEDIATE l_dynamic_sql_b;
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561: EXCEPTION
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: code_debug( 'EXCEPTION why this ');
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
566: ,p_count => x_msg_count

Line 564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561: EXCEPTION
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: code_debug( 'EXCEPTION why this ');
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
566: ,p_count => x_msg_count
567: ,p_data => x_msg_data);
568: WHEN OTHERS THEN

Line 565: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

561: EXCEPTION
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563: code_debug( 'EXCEPTION why this ');
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
566: ,p_count => x_msg_count
567: ,p_data => x_msg_data);
568: WHEN OTHERS THEN
569: code_debug( 'EXCEPTION others ');

Line 570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

566: ,p_count => x_msg_count
567: ,p_data => x_msg_data);
568: WHEN OTHERS THEN
569: code_debug( 'EXCEPTION others ');
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: fnd_message.set_name('EGO', 'EGO_PLSQL_ERR');
572: fnd_message.set_token('PKG_NAME', G_PKG_NAME);
573: fnd_message.set_token('API_NAME', l_api_name);
574: fnd_message.set_token('SQL_ERR_MSG', SQLERRM);