APPS.CZ_CF_API dependencies on CZ_CONFIG_MESSAGES

Line 151: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;

147:
148: BEGIN
149: IF ((last_msg_seq_allocated IS NULL) OR
150: (next_msg_seq_to_use = last_msg_seq_allocated + id_increment)) THEN
151: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;
152: next_msg_seq_to_use := last_msg_seq_allocated;
153: END IF;
154:
155: l_msg_seq := next_msg_seq_to_use;

Line 398: DELETE FROM CZ_CONFIG_MESSAGES

394: DELETE FROM CZ_CONFIG_INPUTS
395: WHERE CONFIG_HDR_ID=in_config_hdr_id
396: AND CONFIG_REV_NBR=in_config_rev_nbr;
397:
398: DELETE FROM CZ_CONFIG_MESSAGES
399: WHERE CONFIG_HDR_ID=in_config_hdr_id
400: AND CONFIG_REV_NBR=in_config_rev_nbr;
401:
402: l_ndebug := 5;

Line 832: ------cz_config_messages

828: END;
829:
830: --------------------------------------------------
831: ------procedure that logs a delta message to
832: ------cz_config_messages
833: PROCEDURE log_delta_message (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
834: p_organization_id IN mtl_system_items.organization_id%TYPE ,
835: p_component_code IN cz_config_details_v.component_code%TYPE,
836: p_current_quantity IN NUMBER,

Line 873: insert into cz_config_messages (config_hdr_id,config_rev_nbr,constraint_type,

869: 'COMPONENTCODE',p_component_code,
870: 'DESCRIPTION',l_description );
871: END IF;
872:
873: insert into cz_config_messages (config_hdr_id,config_rev_nbr,constraint_type,
874: message,message_seq,deleted_flag)
875: values (p_config_hdr,p_config_rev,'ITEM DELTA',l_delta_message,l_msg_seq, '0');
876: END;
877:

Line 883: ------ The changes are logged to cz_config_messages

879: ----- changes for batch validation failure processing
880: ----- this block would set the validation status to fail if
881: ----- the config_input_list is empty and validation_status is CONFIG_PROCESSED
882: ------ and if there are configured item changes
883: ------ The changes are logged to cz_config_messages
884: ------@p_config_input_list input list passed to validate proc
885: ------@p_validation_status --- validation status after BV
886: ------@p_init_message --- init message passed by calling application
887: ------@x_config_messages OUTPUT config_messages

Line 1912: FOR i IN (SELECT message FROM cz_config_messages

1908: fnd_msg_pub.add;
1909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1910: ELSIF l_validation_status = CONFIG_PROCESSED_NO_TERMINATE OR
1911: l_validation_status = CONFIG_EXCEPTION THEN
1912: FOR i IN (SELECT message FROM cz_config_messages
1913: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
1914: ORDER BY message_seq) LOOP
1915: fnd_msg_pub.Add_Exc_Msg(p_error_text => i.message);
1916: END LOOP;

Line 1926: FOR i IN (SELECT message FROM cz_config_messages

1922: AND NOT (l_has_item OR l_has_attr) THEN
1923: check_deltas(p_init_msg, x_config_xml_msg, x_return_status);
1924: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1925: fnd_msg_pub.Add_Exc_Msg(p_error_text => 'Error from check_delta:');
1926: FOR i IN (SELECT message FROM cz_config_messages
1927: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
1928: ORDER BY message_seq) LOOP
1929: fnd_msg_pub.Add_Exc_Msg(p_error_text => i.message);
1930: END LOOP;

Line 2172: -- and if there are configured item changes. The changes are logged to cz_config_messages

2168:
2169: l_nDebug := 6;
2170: -- this block would set the config status status in the terminate message to FALSE
2171: -- if the config_input_list is empty and validation_status is CONFIG_PROCESSED
2172: -- and if there are configured item changes. The changes are logged to cz_config_messages
2173: IF validation_status = CONFIG_PROCESSED AND p_validation_type = CZ_API_PUB.VALIDATE_ORDER AND
2174: config_input_list.COUNT = 0 THEN
2175: check_deltas(init_message,config_messages,l_delta_status);
2176: IF (l_delta_status <> FND_API.G_RET_STS_SUCCESS) THEN