1801: ,p_token_name4 IN VARCHAR2
1802: ,p_token_value4 IN VARCHAR2
1803: ) IS
1804: BEGIN
1805: fnd_message.set_name('CZ', p_msg_name);
1806: fnd_message.set_token(p_token_name1, p_token_value1);
1807: fnd_message.set_token(p_token_name2, p_token_value2);
1808: fnd_message.set_token(p_token_name3, p_token_value3);
1809: fnd_message.set_token(p_token_name4, p_token_value4);
1802: ,p_token_value4 IN VARCHAR2
1803: ) IS
1804: BEGIN
1805: fnd_message.set_name('CZ', p_msg_name);
1806: fnd_message.set_token(p_token_name1, p_token_value1);
1807: fnd_message.set_token(p_token_name2, p_token_value2);
1808: fnd_message.set_token(p_token_name3, p_token_value3);
1809: fnd_message.set_token(p_token_name4, p_token_value4);
1810: fnd_msg_pub.add;
1803: ) IS
1804: BEGIN
1805: fnd_message.set_name('CZ', p_msg_name);
1806: fnd_message.set_token(p_token_name1, p_token_value1);
1807: fnd_message.set_token(p_token_name2, p_token_value2);
1808: fnd_message.set_token(p_token_name3, p_token_value3);
1809: fnd_message.set_token(p_token_name4, p_token_value4);
1810: fnd_msg_pub.add;
1811: END set_message;
1804: BEGIN
1805: fnd_message.set_name('CZ', p_msg_name);
1806: fnd_message.set_token(p_token_name1, p_token_value1);
1807: fnd_message.set_token(p_token_name2, p_token_value2);
1808: fnd_message.set_token(p_token_name3, p_token_value3);
1809: fnd_message.set_token(p_token_name4, p_token_value4);
1810: fnd_msg_pub.add;
1811: END set_message;
1812:
1805: fnd_message.set_name('CZ', p_msg_name);
1806: fnd_message.set_token(p_token_name1, p_token_value1);
1807: fnd_message.set_token(p_token_name2, p_token_value2);
1808: fnd_message.set_token(p_token_name3, p_token_value3);
1809: fnd_message.set_token(p_token_name4, p_token_value4);
1810: fnd_msg_pub.add;
1811: END set_message;
1812:
1813: BEGIN
1822: l_validation_type := CZ_API_PUB.VALIDATE_ORDER;
1823: ELSIF l_validation_type NOT IN
1824: (CZ_API_PUB.VALIDATE_ORDER, CZ_API_PUB.VALIDATE_FULFILLMENT,
1825: CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN) THEN
1826: fnd_message.set_name('CZ', 'CZ_BV_INVALID_TYPE');
1827: fnd_message.set_token('TYPE', l_validation_type);
1828: fnd_msg_pub.add;
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;
1823: ELSIF l_validation_type NOT IN
1824: (CZ_API_PUB.VALIDATE_ORDER, CZ_API_PUB.VALIDATE_FULFILLMENT,
1825: CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN) THEN
1826: fnd_message.set_name('CZ', 'CZ_BV_INVALID_TYPE');
1827: fnd_message.set_token('TYPE', l_validation_type);
1828: fnd_msg_pub.add;
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;
1831:
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;
1831:
1832: IF p_init_msg IS NULL OR length(p_init_msg) = 0 THEN
1833: fnd_message.set_name('CZ', 'CZ_BV_NULL_INITMSG');
1834: fnd_msg_pub.add;
1835: RAISE FND_API.G_EXC_ERROR;
1836: END IF;
1837:
1939: l_operation_code := 'REVERT';
1940: ELSE
1941: l_operation_code := to_char(p_config_item_tbl(i).operation);
1942: END IF;
1943: fnd_message.set_name('CZ', 'CZ_BV_INVALID_OP');
1944: fnd_message.set_token('CODE', l_operation_code);
1945: fnd_message.set_token('IDX', i);
1946: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1947: fnd_msg_pub.add;
1940: ELSE
1941: l_operation_code := to_char(p_config_item_tbl(i).operation);
1942: END IF;
1943: fnd_message.set_name('CZ', 'CZ_BV_INVALID_OP');
1944: fnd_message.set_token('CODE', l_operation_code);
1945: fnd_message.set_token('IDX', i);
1946: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1947: fnd_msg_pub.add;
1948: RAISE FND_API.G_EXC_ERROR;
1941: l_operation_code := to_char(p_config_item_tbl(i).operation);
1942: END IF;
1943: fnd_message.set_name('CZ', 'CZ_BV_INVALID_OP');
1944: fnd_message.set_token('CODE', l_operation_code);
1945: fnd_message.set_token('IDX', i);
1946: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1947: fnd_msg_pub.add;
1948: RAISE FND_API.G_EXC_ERROR;
1949: ELSIF p_config_item_tbl(i).operation = BV_OPERATION_UPDATE AND
1942: END IF;
1943: fnd_message.set_name('CZ', 'CZ_BV_INVALID_OP');
1944: fnd_message.set_token('CODE', l_operation_code);
1945: fnd_message.set_token('IDX', i);
1946: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1947: fnd_msg_pub.add;
1948: RAISE FND_API.G_EXC_ERROR;
1949: ELSIF p_config_item_tbl(i).operation = BV_OPERATION_UPDATE AND
1950: p_config_item_tbl(i).instance_name = FND_API.G_MISS_CHAR THEN
1960: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1961: RAISE FND_API.G_EXC_ERROR;
1962: ELSIF p_config_item_tbl(i).sequence_nbr IS NOT NULL THEN
1963: IF l_item_seq_map.exists(p_config_item_tbl(i).sequence_nbr) THEN
1964: fnd_message.set_name('CZ', 'CZ_BV_DUP_SEQ');
1965: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1966: fnd_msg_pub.add;
1967: RAISE FND_API.G_EXC_ERROR;
1968: ELSE
1961: RAISE FND_API.G_EXC_ERROR;
1962: ELSIF p_config_item_tbl(i).sequence_nbr IS NOT NULL THEN
1963: IF l_item_seq_map.exists(p_config_item_tbl(i).sequence_nbr) THEN
1964: fnd_message.set_name('CZ', 'CZ_BV_DUP_SEQ');
1965: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1966: fnd_msg_pub.add;
1967: RAISE FND_API.G_EXC_ERROR;
1968: ELSE
1969: l_item_seq_map(p_config_item_tbl(i).sequence_nbr) := i;
1975: p_config_item_tbl(i).config_item_id,
1976: l_ext_comp_code, l_item_depth);
1977:
1978: IF l_ext_comp_code IS NULL OR length(l_ext_comp_code) = 0 THEN
1979: fnd_message.set_name('CZ', 'CZ_BV_INVALID_ITEM');
1980: fnd_message.set_token('HDR', l_config_hdr_id);
1981: fnd_message.set_token('REV', l_config_rev_nbr);
1982: fnd_message.set_token('ID', p_config_item_tbl(i).config_item_id);
1983: fnd_message.set_token('TYPE', 'ITEM');
1976: l_ext_comp_code, l_item_depth);
1977:
1978: IF l_ext_comp_code IS NULL OR length(l_ext_comp_code) = 0 THEN
1979: fnd_message.set_name('CZ', 'CZ_BV_INVALID_ITEM');
1980: fnd_message.set_token('HDR', l_config_hdr_id);
1981: fnd_message.set_token('REV', l_config_rev_nbr);
1982: fnd_message.set_token('ID', p_config_item_tbl(i).config_item_id);
1983: fnd_message.set_token('TYPE', 'ITEM');
1984: fnd_message.set_token('IND', i);
1977:
1978: IF l_ext_comp_code IS NULL OR length(l_ext_comp_code) = 0 THEN
1979: fnd_message.set_name('CZ', 'CZ_BV_INVALID_ITEM');
1980: fnd_message.set_token('HDR', l_config_hdr_id);
1981: fnd_message.set_token('REV', l_config_rev_nbr);
1982: fnd_message.set_token('ID', p_config_item_tbl(i).config_item_id);
1983: fnd_message.set_token('TYPE', 'ITEM');
1984: fnd_message.set_token('IND', i);
1985: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1978: IF l_ext_comp_code IS NULL OR length(l_ext_comp_code) = 0 THEN
1979: fnd_message.set_name('CZ', 'CZ_BV_INVALID_ITEM');
1980: fnd_message.set_token('HDR', l_config_hdr_id);
1981: fnd_message.set_token('REV', l_config_rev_nbr);
1982: fnd_message.set_token('ID', p_config_item_tbl(i).config_item_id);
1983: fnd_message.set_token('TYPE', 'ITEM');
1984: fnd_message.set_token('IND', i);
1985: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1986: fnd_msg_pub.add;
1979: fnd_message.set_name('CZ', 'CZ_BV_INVALID_ITEM');
1980: fnd_message.set_token('HDR', l_config_hdr_id);
1981: fnd_message.set_token('REV', l_config_rev_nbr);
1982: fnd_message.set_token('ID', p_config_item_tbl(i).config_item_id);
1983: fnd_message.set_token('TYPE', 'ITEM');
1984: fnd_message.set_token('IND', i);
1985: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1986: fnd_msg_pub.add;
1987: RAISE FND_API.G_EXC_ERROR;
1980: fnd_message.set_token('HDR', l_config_hdr_id);
1981: fnd_message.set_token('REV', l_config_rev_nbr);
1982: fnd_message.set_token('ID', p_config_item_tbl(i).config_item_id);
1983: fnd_message.set_token('TYPE', 'ITEM');
1984: fnd_message.set_token('IND', i);
1985: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1986: fnd_msg_pub.add;
1987: RAISE FND_API.G_EXC_ERROR;
1988: ELSIF p_config_item_tbl(i).operation = BV_OPERATION_UPDATE THEN
1981: fnd_message.set_token('REV', l_config_rev_nbr);
1982: fnd_message.set_token('ID', p_config_item_tbl(i).config_item_id);
1983: fnd_message.set_token('TYPE', 'ITEM');
1984: fnd_message.set_token('IND', i);
1985: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1986: fnd_msg_pub.add;
1987: RAISE FND_API.G_EXC_ERROR;
1988: ELSIF p_config_item_tbl(i).operation = BV_OPERATION_UPDATE THEN
1989: l_upd_item_map(p_config_item_tbl(i).config_item_id) := p_config_item_tbl(i).config_item_id;
2104: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2105: RAISE FND_API.G_EXC_ERROR;
2106: ELSIF p_config_ext_attr_tbl(i).sequence_nbr IS NOT NULL THEN
2107: IF l_item_seq_map.exists(p_config_ext_attr_tbl(i).sequence_nbr) THEN
2108: fnd_message.set_name('CZ', 'CZ_BV_DUP_SEQ');
2109: fnd_message.set_token('SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2110: fnd_msg_pub.add;
2111: RAISE FND_API.G_EXC_ERROR;
2112: ELSE
2105: RAISE FND_API.G_EXC_ERROR;
2106: ELSIF p_config_ext_attr_tbl(i).sequence_nbr IS NOT NULL THEN
2107: IF l_item_seq_map.exists(p_config_ext_attr_tbl(i).sequence_nbr) THEN
2108: fnd_message.set_name('CZ', 'CZ_BV_DUP_SEQ');
2109: fnd_message.set_token('SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2110: fnd_msg_pub.add;
2111: RAISE FND_API.G_EXC_ERROR;
2112: ELSE
2113: l_item_seq_map(p_config_ext_attr_tbl(i).sequence_nbr) := i;
2131: p_config_ext_attr_tbl(i).config_item_id,
2132: l_ext_comp_code, l_item_depth);
2133:
2134: IF l_ext_comp_code IS NULL OR length(l_ext_comp_code) = 0 THEN
2135: fnd_message.set_name('CZ', 'CZ_BV_INVALID_ITEM');
2136: fnd_message.set_token('HDR', l_config_hdr_id);
2137: fnd_message.set_token('REV', l_config_rev_nbr);
2138: fnd_message.set_token('ID', p_config_ext_attr_tbl(i).config_item_id);
2139: fnd_message.set_token('TYPE', 'ATTRIBUTE');
2132: l_ext_comp_code, l_item_depth);
2133:
2134: IF l_ext_comp_code IS NULL OR length(l_ext_comp_code) = 0 THEN
2135: fnd_message.set_name('CZ', 'CZ_BV_INVALID_ITEM');
2136: fnd_message.set_token('HDR', l_config_hdr_id);
2137: fnd_message.set_token('REV', l_config_rev_nbr);
2138: fnd_message.set_token('ID', p_config_ext_attr_tbl(i).config_item_id);
2139: fnd_message.set_token('TYPE', 'ATTRIBUTE');
2140: fnd_message.set_token('IND', i);
2133:
2134: IF l_ext_comp_code IS NULL OR length(l_ext_comp_code) = 0 THEN
2135: fnd_message.set_name('CZ', 'CZ_BV_INVALID_ITEM');
2136: fnd_message.set_token('HDR', l_config_hdr_id);
2137: fnd_message.set_token('REV', l_config_rev_nbr);
2138: fnd_message.set_token('ID', p_config_ext_attr_tbl(i).config_item_id);
2139: fnd_message.set_token('TYPE', 'ATTRIBUTE');
2140: fnd_message.set_token('IND', i);
2141: fnd_message.set_token('SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2134: IF l_ext_comp_code IS NULL OR length(l_ext_comp_code) = 0 THEN
2135: fnd_message.set_name('CZ', 'CZ_BV_INVALID_ITEM');
2136: fnd_message.set_token('HDR', l_config_hdr_id);
2137: fnd_message.set_token('REV', l_config_rev_nbr);
2138: fnd_message.set_token('ID', p_config_ext_attr_tbl(i).config_item_id);
2139: fnd_message.set_token('TYPE', 'ATTRIBUTE');
2140: fnd_message.set_token('IND', i);
2141: fnd_message.set_token('SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2142: fnd_msg_pub.add;
2135: fnd_message.set_name('CZ', 'CZ_BV_INVALID_ITEM');
2136: fnd_message.set_token('HDR', l_config_hdr_id);
2137: fnd_message.set_token('REV', l_config_rev_nbr);
2138: fnd_message.set_token('ID', p_config_ext_attr_tbl(i).config_item_id);
2139: fnd_message.set_token('TYPE', 'ATTRIBUTE');
2140: fnd_message.set_token('IND', i);
2141: fnd_message.set_token('SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2142: fnd_msg_pub.add;
2143: RAISE FND_API.G_EXC_ERROR;
2136: fnd_message.set_token('HDR', l_config_hdr_id);
2137: fnd_message.set_token('REV', l_config_rev_nbr);
2138: fnd_message.set_token('ID', p_config_ext_attr_tbl(i).config_item_id);
2139: fnd_message.set_token('TYPE', 'ATTRIBUTE');
2140: fnd_message.set_token('IND', i);
2141: fnd_message.set_token('SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2142: fnd_msg_pub.add;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2137: fnd_message.set_token('REV', l_config_rev_nbr);
2138: fnd_message.set_token('ID', p_config_ext_attr_tbl(i).config_item_id);
2139: fnd_message.set_token('TYPE', 'ATTRIBUTE');
2140: fnd_message.set_token('IND', i);
2141: fnd_message.set_token('SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2142: fnd_msg_pub.add;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2145:
2245: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, 'validation status: ' ||
2246: l_validation_status||v_detailed_error_message, FND_LOG.LEVEL_PROCEDURE);
2247:
2248: IF l_validation_status = INIT_TOO_LONG THEN
2249: fnd_message.set_name('CZ', 'CZ_BV_ERR_INIT_MSG');
2250: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2251: fnd_msg_pub.add;
2252: RAISE FND_API.G_EXC_ERROR;
2253: ELSIF l_validation_status = UTL_HTTP_INIT_FAILED THEN
2246: l_validation_status||v_detailed_error_message, FND_LOG.LEVEL_PROCEDURE);
2247:
2248: IF l_validation_status = INIT_TOO_LONG THEN
2249: fnd_message.set_name('CZ', 'CZ_BV_ERR_INIT_MSG');
2250: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2251: fnd_msg_pub.add;
2252: RAISE FND_API.G_EXC_ERROR;
2253: ELSIF l_validation_status = UTL_HTTP_INIT_FAILED THEN
2254: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_INIT');
2250: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2251: fnd_msg_pub.add;
2252: RAISE FND_API.G_EXC_ERROR;
2253: ELSIF l_validation_status = UTL_HTTP_INIT_FAILED THEN
2254: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_INIT');
2255: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2256: fnd_msg_pub.add;
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: ELSIF l_validation_status = UTL_HTTP_REQUEST_FAILED THEN
2251: fnd_msg_pub.add;
2252: RAISE FND_API.G_EXC_ERROR;
2253: ELSIF l_validation_status = UTL_HTTP_INIT_FAILED THEN
2254: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_INIT');
2255: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2256: fnd_msg_pub.add;
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: ELSIF l_validation_status = UTL_HTTP_REQUEST_FAILED THEN
2259: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_REQ');
2255: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2256: fnd_msg_pub.add;
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: ELSIF l_validation_status = UTL_HTTP_REQUEST_FAILED THEN
2259: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_REQ');
2260: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2261: fnd_msg_pub.add;
2262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2263: ELSIF l_validation_status = CONFIG_PROCESSED_NO_TERMINATE OR
2256: fnd_msg_pub.add;
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: ELSIF l_validation_status = UTL_HTTP_REQUEST_FAILED THEN
2259: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_REQ');
2260: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
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