APPS.CZ_CF_API dependencies on CZ_CONFIG_MESSAGES

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

158:
159: BEGIN
160: IF ((last_msg_seq_allocated IS NULL) OR
161: (next_msg_seq_to_use = last_msg_seq_allocated + id_increment)) THEN
162: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;
163: next_msg_seq_to_use := last_msg_seq_allocated;
164: END IF;
165:
166: l_msg_seq := next_msg_seq_to_use;

Line 411: DELETE FROM CZ_CONFIG_MESSAGES

407: DELETE FROM CZ_CONFIG_INPUTS
408: WHERE CONFIG_HDR_ID=in_config_hdr_id
409: AND CONFIG_REV_NBR=in_config_rev_nbr;
410:
411: DELETE FROM CZ_CONFIG_MESSAGES
412: WHERE CONFIG_HDR_ID=in_config_hdr_id
413: AND CONFIG_REV_NBR=in_config_rev_nbr;
414:
415: --Bug10147623: Delete data from custom config table.

Line 862: ------cz_config_messages

858: END;
859:
860: --------------------------------------------------
861: ------procedure that logs a delta message to
862: ------cz_config_messages
863: PROCEDURE log_delta_message (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
864: p_organization_id IN mtl_system_items.organization_id%TYPE ,
865: p_component_code IN cz_config_details_v.component_code%TYPE,
866: p_current_quantity IN NUMBER,

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

899: 'COMPONENTCODE',p_component_code,
900: 'DESCRIPTION',l_description );
901: END IF;
902:
903: insert into cz_config_messages (config_hdr_id,config_rev_nbr,constraint_type,
904: message,message_seq,deleted_flag)
905: values (p_config_hdr,p_config_rev,'ITEM DELTA',l_delta_message,l_msg_seq, '0');
906: END;
907:

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

909: ----- changes for batch validation failure processing
910: ----- this block would set the validation status to fail if
911: ----- the config_input_list is empty and validation_status is CONFIG_PROCESSED
912: ------ and if there are configured item changes
913: ------ The changes are logged to cz_config_messages
914: ------@p_config_input_list input list passed to validate proc
915: ------@p_validation_status --- validation status after BV
916: ------@p_init_message --- init message passed by calling application
917: ------@x_config_messages OUTPUT config_messages

Line 2265: FOR i IN (SELECT message FROM cz_config_messages

2261: fnd_msg_pub.add;
2262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2263: ELSIF l_validation_status = CONFIG_PROCESSED_NO_TERMINATE OR
2264: l_validation_status = CONFIG_EXCEPTION THEN
2265: FOR i IN (SELECT message FROM cz_config_messages
2266: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
2267: ORDER BY message_seq) LOOP
2268: fnd_msg_pub.Add_Exc_Msg(p_error_text => i.message);
2269: END LOOP;

Line 2281: FOR i IN (SELECT message FROM cz_config_messages

2277: -- this call they are not required though for this VALIDATE API.
2278: check_deltas(p_init_msg,'N',x_config_xml_msg,x_return_status,v_return_config_changed);
2279: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2280: fnd_msg_pub.Add_Exc_Msg(p_error_text => 'Error from check_delta:');
2281: FOR i IN (SELECT message FROM cz_config_messages
2282: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
2283: ORDER BY message_seq) LOOP
2284: fnd_msg_pub.Add_Exc_Msg(p_error_text => i.message);
2285: END LOOP;

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

2567:
2568: l_nDebug := 6;
2569: -- this block would set the config status status in the terminate message to FALSE
2570: -- if the config_input_list is empty and validation_status is CONFIG_PROCESSED
2571: -- and if there are configured item changes. The changes are logged to cz_config_messages
2572: IF validation_status = CONFIG_PROCESSED AND p_validation_type = CZ_API_PUB.VALIDATE_ORDER AND
2573: config_input_list.COUNT = 0 THEN
2574: -- Added 2 new params as per the Quoting ER#9348864 as said earlier
2575: check_deltas(init_message,p_check_config_flag,config_messages,l_delta_status,x_return_config_changed);