DBA Data[Home] [Help]

APPS.CZ_RUNTIME dependencies on FND_API

Line 625: x_complete_flag := FND_API.G_TRUE;

621: IF (l_config_status IS NULL) THEN
622: l_column_name := 'config_status';
623: RAISE null_db_value_exc;
624: ELSIF (l_config_status = CONFIG_STATUS_COMPLETE) THEN
625: x_complete_flag := FND_API.G_TRUE;
626: ELSE
627: x_complete_flag := FND_API.G_FALSE;
628: END IF;
629:

Line 627: x_complete_flag := FND_API.G_FALSE;

623: RAISE null_db_value_exc;
624: ELSIF (l_config_status = CONFIG_STATUS_COMPLETE) THEN
625: x_complete_flag := FND_API.G_TRUE;
626: ELSE
627: x_complete_flag := FND_API.G_FALSE;
628: END IF;
629:
630: IF (x_config_date_created IS NULL) THEN
631: l_column_name := 'config_date_created';

Line 646: x_valid_flag := FND_API.G_FALSE;

642: FROM cz_config_messages
643: WHERE config_hdr_id = p_config_hdr_id AND config_rev_nbr = p_config_rev_nbr
644: AND deleted_flag = '0' AND ROWNUM < 2;
645:
646: x_valid_flag := FND_API.G_FALSE;
647:
648: EXCEPTION
649: WHEN NO_DATA_FOUND THEN
650: x_valid_flag := FND_API.G_TRUE;

Line 650: x_valid_flag := FND_API.G_TRUE;

646: x_valid_flag := FND_API.G_FALSE;
647:
648: EXCEPTION
649: WHEN NO_DATA_FOUND THEN
650: x_valid_flag := FND_API.G_TRUE;
651: END;
652:
653: BEGIN
654: SELECT node_identifier INTO l_node_identifier

Line 688: x_return_status := FND_API.G_RET_STS_SUCCESS;

684: l_column_name := 'item_val';
685: RAISE null_db_value_exc;
686: END IF;
687:
688: x_return_status := FND_API.G_RET_STS_SUCCESS;
689:
690: EXCEPTION
691: WHEN no_data_found THEN
692: x_return_status := FND_API.G_RET_STS_ERROR;

Line 692: x_return_status := FND_API.G_RET_STS_ERROR;

688: x_return_status := FND_API.G_RET_STS_SUCCESS;
689:
690: EXCEPTION
691: WHEN no_data_found THEN
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: x_msg_data := 'No such config header found in database with header id ' || to_char(p_config_hdr_id)
694: || ', revision ' || to_char(p_config_rev_nbr);
695:
696: WHEN null_db_value_exc THEN

Line 697: x_return_status := FND_API.G_RET_STS_ERROR;

693: x_msg_data := 'No such config header found in database with header id ' || to_char(p_config_hdr_id)
694: || ', revision ' || to_char(p_config_rev_nbr);
695:
696: WHEN null_db_value_exc THEN
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: x_msg_data := 'Data Error: ' || l_column_name || ' is NULL for record - config_hdr_id ' ||
699: to_char(p_config_hdr_id) || ', config_rev_nbr ' || to_char(p_config_rev_nbr);
700: IF (l_config_item_id IS NOT NULL) THEN
701: x_msg_data := x_msg_data || ', config_item_id ' || to_char(l_config_item_id);

Line 705: x_return_status := FND_API.G_RET_STS_ERROR;

701: x_msg_data := x_msg_data || ', config_item_id ' || to_char(l_config_item_id);
702: END IF;
703:
704: WHEN no_bom_item_found_exc THEN
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: x_msg_data := 'No config item found having an inventory_item_id for the input config' ||
707: ': config_hdr_id ' || to_char(p_config_hdr_id) ||
708: ', config_rev_nbr ' || to_char(p_config_rev_nbr);
709:

Line 711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

707: ': config_hdr_id ' || to_char(p_config_hdr_id) ||
708: ', config_rev_nbr ' || to_char(p_config_rev_nbr);
709:
710: WHEN OTHERS THEN
711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: x_msg_data := SQLERRM;
713:
714: END get_config_info;
715: