eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_CF_API dependencies on FND_API

Line 237: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS) THEN

233: ,handle_deleted_flag
234: ,new_name
235: );
236:
237: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS) THEN
238: IF (l_orig_item_id_tbl.count > 0) THEN
239: RAISE API_CALL_EXC;
240: END IF;
241: return_value := 1;

Line 367: ' IF (p_return_status <> fnd_api.g_ret_sts_success) THEN ' ||

363: ' x_install_config_rec => p_install_config_rec, ' ||
364: ' x_return_status => p_return_status, ' ||
365: ' x_return_message => p_return_message ' ||
366: ' ); ' ||
367: ' IF (p_return_status <> fnd_api.g_ret_sts_success) THEN ' ||
368: ' l_ib_errored := 1; ' ||
369: ' ELSE ' ||
370: ' IF (p_install_config_rec.config_inst_rev_num IS NULL) THEN ' ||
371: ' api_result := 0; ' ||

Line 773: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

769: l_config_rev_nbr NUMBER;
770: l_valid_config VARCHAR2(10);
771: l_complete_config VARCHAR2(10);
772: l_header_id NUMBER;
773: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
774:
775: BEGIN
776: l_valid_config_start_pos := INSTR(UPPER(p_xml),l_valid_config_start_tag,1, 1)
777: + length(l_valid_config_start_tag);

Line 808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

804: x_valid_config := nvl(l_valid_config, 'FALSE');
805:
806: EXCEPTION
807: WHEN OTHERS THEN
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: x_error_message := SQLERRM;
810: END Parse_output_xml;
811: -------------------------------------------------------------------
812: -------procedure that checks if the passed in init message

Line 990: x_return_status := FND_API.G_RET_STS_SUCCESS;

986: and config_rev_nbr IN (p_old_rev, p_new_rev)
987: ORDER BY config_item_id,config_hdr_id,config_rev_nbr;
988:
989: BEGIN
990: x_return_status := FND_API.G_RET_STS_SUCCESS;
991:
992: FOR I IN 1..1
993: LOOP
994:

Line 1039: IF (v_parse_status <> FND_API.G_RET_STS_SUCCESS) THEN

1035: v_parse_status ,
1036: v_parse_message) ;
1037:
1038: ----if error in parsing xml raise an exception
1039: IF (v_parse_status <> FND_API.G_RET_STS_SUCCESS) THEN
1040: RAISE PARSE_XML_ERROR;
1041: END IF;
1042:
1043: IF (UPPER(v_valid_config) NOT IN ('TRUE', 'Y')) THEN

Line 1170: x_return_status := FND_API.G_RET_STS_SUCCESS;

1166: END LOOP;
1167: COMMIT;
1168: EXCEPTION
1169: WHEN NO_INPUT_HDR_EXCEP THEN
1170: x_return_status := FND_API.G_RET_STS_SUCCESS;
1171: WHEN PARSE_XML_ERROR THEN
1172: ROLLBACK;
1173: -- l_report_status := CZ_UTILS.REPORT (v_parse_message,1,'ITEM DELTA',1);
1174: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, v_parse_message,

Line 1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1172: ROLLBACK;
1173: -- l_report_status := CZ_UTILS.REPORT (v_parse_message,1,'ITEM DELTA',1);
1174: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, v_parse_message,
1175: fnd_log.LEVEL_ERROR);
1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: WHEN OTHERS THEN
1178: ROLLBACK;
1179: l_config_err_msg := SQLERRM;
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: WHEN OTHERS THEN
1178: ROLLBACK;
1179: l_config_err_msg := SQLERRM;
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1181: -- l_report_status := CZ_UTILS.REPORT (l_config_err_msg,1,'ITEM DELTA',1);
1182: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, l_config_err_msg,
1183: fnd_log.LEVEL_UNEXPECTED);
1184: END check_deltas;

Line 1816: IF (NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN

1812:
1813: BEGIN
1814: l_nDebug := 1;
1815:
1816: IF (NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1818: END IF;
1819:
1820: l_validation_type := p_validation_type;

Line 1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1813: BEGIN
1814: l_nDebug := 1;
1815:
1816: IF (NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1818: END IF;
1819:
1820: l_validation_type := p_validation_type;
1821: IF l_validation_type IS NULL THEN

Line 1829: RAISE FND_API.G_EXC_ERROR;

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:
1832: IF p_init_msg IS NULL OR length(p_init_msg) = 0 THEN
1833: fnd_message.set_name('CZ', 'CZ_BV_NULL_INITMSG');

Line 1835: RAISE FND_API.G_EXC_ERROR;

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:
1838: l_url := p_url;
1839: IF l_url IS NULL THEN

Line 1906: IF l_rec1_seq = FND_API.G_MISS_NUM THEN

1902:
1903: l_nDebug := 4;
1904: IF l_has_item THEN
1905: l_rec1_seq := p_config_item_tbl(p_config_item_tbl.FIRST).sequence_nbr;
1906: IF l_rec1_seq = FND_API.G_MISS_NUM THEN
1907: l_rec1_seq := NULL;
1908: END IF;
1909:
1910: FOR i IN p_config_item_tbl.FIRST..p_config_item_tbl.LAST

Line 1924: p_config_item_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN

1920: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1921: END IF;
1922:
1923: IF p_config_item_tbl(i).config_item_id IS NULL OR
1924: p_config_item_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN
1925: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'CONFIG_ITEM_ID', 'TYPE', 'ITEM',
1926: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1927: RAISE FND_API.G_EXC_ERROR;
1928: END IF;

Line 1927: RAISE FND_API.G_EXC_ERROR;

1923: IF p_config_item_tbl(i).config_item_id IS NULL OR
1924: p_config_item_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN
1925: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'CONFIG_ITEM_ID', 'TYPE', 'ITEM',
1926: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1927: RAISE FND_API.G_EXC_ERROR;
1928: END IF;
1929:
1930: IF p_config_item_tbl(i).operation IS NULL OR
1931: p_config_item_tbl(i).operation = FND_API.G_MISS_NUM THEN

Line 1931: p_config_item_tbl(i).operation = FND_API.G_MISS_NUM THEN

1927: RAISE FND_API.G_EXC_ERROR;
1928: END IF;
1929:
1930: IF p_config_item_tbl(i).operation IS NULL OR
1931: p_config_item_tbl(i).operation = FND_API.G_MISS_NUM THEN
1932: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'OPERATION', 'TYPE', 'ITEM',
1933: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1934: RAISE FND_API.G_EXC_ERROR;
1935: ELSIF p_config_item_tbl(i).operation NOT IN (BV_OPERATION_UPDATE,BV_OPERATION_DELETE) THEN

Line 1934: RAISE FND_API.G_EXC_ERROR;

1930: IF p_config_item_tbl(i).operation IS NULL OR
1931: p_config_item_tbl(i).operation = FND_API.G_MISS_NUM THEN
1932: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'OPERATION', 'TYPE', 'ITEM',
1933: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1934: RAISE FND_API.G_EXC_ERROR;
1935: ELSIF p_config_item_tbl(i).operation NOT IN (BV_OPERATION_UPDATE,BV_OPERATION_DELETE) THEN
1936: IF p_config_item_tbl(i).operation = BV_OPERATION_INSERT THEN
1937: l_operation_code := 'INSERT';
1938: ELSIF p_config_item_tbl(i).operation = BV_OPERATION_REVERT THEN

Line 1948: RAISE FND_API.G_EXC_ERROR;

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
1951: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'INSTANCE_NAME', 'TYPE', 'ITEM',
1952: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);

Line 1950: p_config_item_tbl(i).instance_name = FND_API.G_MISS_CHAR THEN

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
1951: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'INSTANCE_NAME', 'TYPE', 'ITEM',
1952: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1953: RAISE FND_API.G_EXC_ERROR;
1954: END IF;

Line 1953: 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
1951: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'INSTANCE_NAME', 'TYPE', 'ITEM',
1952: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1953: RAISE FND_API.G_EXC_ERROR;
1954: END IF;
1955:
1956: IF l_rec1_seq IS NULL AND p_config_item_tbl(i).sequence_nbr IS NOT NULL OR
1957: l_rec1_seq IS NOT NULL AND (p_config_item_tbl(i).sequence_nbr IS NULL OR

Line 1958: p_config_item_tbl(i).sequence_nbr=FND_API.G_MISS_NUM) THEN

1954: END IF;
1955:
1956: IF l_rec1_seq IS NULL AND p_config_item_tbl(i).sequence_nbr IS NOT NULL OR
1957: l_rec1_seq IS NOT NULL AND (p_config_item_tbl(i).sequence_nbr IS NULL OR
1958: p_config_item_tbl(i).sequence_nbr=FND_API.G_MISS_NUM) THEN
1959: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'SEQUENCE_NBR', 'TYPE', 'ITEM',
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

Line 1961: RAISE FND_API.G_EXC_ERROR;

1957: l_rec1_seq IS NOT NULL AND (p_config_item_tbl(i).sequence_nbr IS NULL OR
1958: p_config_item_tbl(i).sequence_nbr=FND_API.G_MISS_NUM) THEN
1959: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'SEQUENCE_NBR', 'TYPE', 'ITEM',
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);

Line 1967: RAISE FND_API.G_EXC_ERROR;

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;
1970: END IF;
1971: END IF;

Line 1987: RAISE FND_API.G_EXC_ERROR;

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;
1990: END IF;
1991:

Line 1998: IF l_quantity_tbl(l_idx) = FND_API.G_MISS_NUM THEN

1994: l_ecc_tbl(l_idx) := l_ext_comp_code;
1995: l_seq_nbr_tbl(l_idx) := NVL(p_config_item_tbl(i).sequence_nbr, l_item_depth);
1996: l_operation_tbl(l_idx) := p_config_item_tbl(i).operation;
1997: l_quantity_tbl(l_idx) := p_config_item_tbl(i).quantity;
1998: IF l_quantity_tbl(l_idx) = FND_API.G_MISS_NUM THEN
1999: l_quantity_tbl(l_idx) := l_miss_num;
2000: END IF;
2001: l_instance_name_tbl(l_idx) := p_config_item_tbl(i).instance_name;
2002: l_loc_id_tbl(l_idx) := p_config_item_tbl(i).location_id;

Line 2003: IF l_loc_id_tbl(l_idx) = FND_API.G_MISS_NUM THEN

1999: l_quantity_tbl(l_idx) := l_miss_num;
2000: END IF;
2001: l_instance_name_tbl(l_idx) := p_config_item_tbl(i).instance_name;
2002: l_loc_id_tbl(l_idx) := p_config_item_tbl(i).location_id;
2003: IF l_loc_id_tbl(l_idx) = FND_API.G_MISS_NUM THEN
2004: l_loc_id_tbl(l_idx) := l_miss_num;
2005: END IF;
2006: l_loc_type_code_tbl(l_idx) := p_config_item_tbl(i).location_type_code;
2007: l_rec_seq_tbl(l_idx) := i;

Line 2074: IF l_rec1_seq = FND_API.G_MISS_NUM THEN

2070: -- processing extended attributes
2071: IF l_has_attr THEN
2072: IF l_rec1_seq IS NULL AND NOT l_has_item THEN
2073: l_rec1_seq := p_config_ext_attr_tbl(p_config_ext_attr_tbl.FIRST).sequence_nbr;
2074: IF l_rec1_seq = FND_API.G_MISS_NUM THEN
2075: l_rec1_seq := NULL;
2076: END IF;
2077: END IF;
2078:

Line 2094: p_config_ext_attr_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN

2090: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
2091: END IF;
2092:
2093: IF p_config_ext_attr_tbl(i).config_item_id IS NULL OR
2094: p_config_ext_attr_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN
2095: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'CONFIG_ITEM_ID', 'TYPE', 'ATTRIBUTE',
2096: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2097: RAISE FND_API.G_EXC_ERROR;
2098: END IF;

Line 2097: RAISE FND_API.G_EXC_ERROR;

2093: IF p_config_ext_attr_tbl(i).config_item_id IS NULL OR
2094: p_config_ext_attr_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN
2095: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'CONFIG_ITEM_ID', 'TYPE', 'ATTRIBUTE',
2096: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2097: RAISE FND_API.G_EXC_ERROR;
2098: END IF;
2099:
2100: IF l_rec1_seq IS NULL AND p_config_ext_attr_tbl(i).sequence_nbr IS NOT NULL OR
2101: l_rec1_seq IS NOT NULL AND (p_config_ext_attr_tbl(i).sequence_nbr IS NULL OR

Line 2102: p_config_ext_attr_tbl(i).sequence_nbr=FND_API.G_MISS_NUM) THEN

2098: END IF;
2099:
2100: IF l_rec1_seq IS NULL AND p_config_ext_attr_tbl(i).sequence_nbr IS NOT NULL OR
2101: l_rec1_seq IS NOT NULL AND (p_config_ext_attr_tbl(i).sequence_nbr IS NULL OR
2102: p_config_ext_attr_tbl(i).sequence_nbr=FND_API.G_MISS_NUM) THEN
2103: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'SEQUENCE_NBR', 'TYPE', 'ATTRIBUTE',
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

Line 2105: RAISE FND_API.G_EXC_ERROR;

2101: l_rec1_seq IS NOT NULL AND (p_config_ext_attr_tbl(i).sequence_nbr IS NULL OR
2102: p_config_ext_attr_tbl(i).sequence_nbr=FND_API.G_MISS_NUM) THEN
2103: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'SEQUENCE_NBR', 'TYPE', 'ATTRIBUTE',
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);

Line 2111: RAISE FND_API.G_EXC_ERROR;

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;
2114: END IF;
2115: END IF;

Line 2118: p_config_ext_attr_tbl(i).attribute_name = FND_API.G_MISS_CHAR THEN

2114: END IF;
2115: END IF;
2116:
2117: IF p_config_ext_attr_tbl(i).attribute_name IS NULL OR
2118: p_config_ext_attr_tbl(i).attribute_name = FND_API.G_MISS_CHAR THEN
2119: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'ATTRIBUTE_NAME', 'TYPE', 'ATTRIBUTE',
2120: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2121: RAISE FND_API.G_EXC_ERROR;
2122: END IF;

Line 2121: RAISE FND_API.G_EXC_ERROR;

2117: IF p_config_ext_attr_tbl(i).attribute_name IS NULL OR
2118: p_config_ext_attr_tbl(i).attribute_name = FND_API.G_MISS_CHAR THEN
2119: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'ATTRIBUTE_NAME', 'TYPE', 'ATTRIBUTE',
2120: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2121: RAISE FND_API.G_EXC_ERROR;
2122: END IF;
2123: IF p_config_ext_attr_tbl(i).attribute_value IS NULL THEN
2124: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'ATTRIBUTE_VALUE', 'TYPE', 'ATTRIBUTE',
2125: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);

Line 2126: RAISE FND_API.G_EXC_ERROR;

2122: END IF;
2123: IF p_config_ext_attr_tbl(i).attribute_value IS NULL THEN
2124: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'ATTRIBUTE_VALUE', 'TYPE', 'ATTRIBUTE',
2125: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
2126: RAISE FND_API.G_EXC_ERROR;
2127: END IF;
2128:
2129: IF NOT l_upd_item_map.exists(p_config_ext_attr_tbl(i).config_item_id) THEN
2130: get_ext_comp_code(l_config_hdr_id, l_config_rev_nbr,

Line 2143: RAISE FND_API.G_EXC_ERROR;

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:
2146: -- Create a dummy item with no-op for now, this part of code will be removed
2147: -- or modified after changing to not generate ecc

Line 2252: RAISE FND_API.G_EXC_ERROR;

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');
2255: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2256: fnd_msg_pub.add;

Line 2257: RAISE FND_API.G_EXC_UNEXPECTED_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');
2260: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2261: fnd_msg_pub.add;

Line 2262: 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
2265: FOR i IN (SELECT message FROM cz_config_messages
2266: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1

Line 2270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
2270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2271: END IF;
2272:
2273: l_nDebug := 11;
2274: IF l_validation_status = CONFIG_PROCESSED AND l_validation_type = CZ_API_PUB.VALIDATE_ORDER

Line 2279: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2275: AND NOT (l_has_item OR l_has_attr) THEN
2276: -- Added 2 new params as per the Quoting ER#9348864 as said earlier. But for
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

Line 2286: RAISE FND_API.G_EXC_ERROR;

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;
2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288: END IF;
2289:
2290: l_nDebug := 12;

Line 2293: x_return_status := FND_API.G_RET_STS_SUCCESS;

2289:
2290: l_nDebug := 12;
2291: delete_bv_records(l_pseudo_hdr_id, TRUE, TRUE);
2292:
2293: x_return_status := FND_API.G_RET_STS_SUCCESS;
2294:
2295: EXCEPTION
2296: WHEN FND_API.G_EXC_ERROR THEN
2297: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2296: WHEN FND_API.G_EXC_ERROR THEN

2292:
2293: x_return_status := FND_API.G_RET_STS_SUCCESS;
2294:
2295: EXCEPTION
2296: WHEN FND_API.G_EXC_ERROR THEN
2297: x_return_status := FND_API.G_RET_STS_ERROR;
2298: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2299: p_data => x_msg_data);
2300: ROLLBACK;

Line 2297: x_return_status := FND_API.G_RET_STS_ERROR;

2293: x_return_status := FND_API.G_RET_STS_SUCCESS;
2294:
2295: EXCEPTION
2296: WHEN FND_API.G_EXC_ERROR THEN
2297: x_return_status := FND_API.G_RET_STS_ERROR;
2298: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2299: p_data => x_msg_data);
2300: ROLLBACK;
2301:

Line 2302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2298: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2299: p_data => x_msg_data);
2300: ROLLBACK;
2301:
2302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2304: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2305: p_data => x_msg_data);
2306: delete_bv_records(l_pseudo_hdr_id, FALSE, TRUE);

Line 2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2299: p_data => x_msg_data);
2300: ROLLBACK;
2301:
2302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2304: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2305: p_data => x_msg_data);
2306: delete_bv_records(l_pseudo_hdr_id, FALSE, TRUE);
2307:

Line 2309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2305: p_data => x_msg_data);
2306: delete_bv_records(l_pseudo_hdr_id, FALSE, TRUE);
2307:
2308: WHEN OTHERS THEN
2309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2310: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
2311: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
2312: END IF;
2313:

Line 2576: IF (l_delta_status <> FND_API.G_RET_STS_SUCCESS) THEN

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);
2576: IF (l_delta_status <> FND_API.G_RET_STS_SUCCESS) THEN
2577: RAISE DELTA_CHECK_FAILURE;
2578: END IF;
2579: END IF;
2580:

Line 3220: -- Required because Istore passes FND_API.G_MISS_DATE

3216: ORDER BY start_date DESC;
3217:
3218: BEGIN
3219:
3220: -- Required because Istore passes FND_API.G_MISS_DATE
3221: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN
3222: v_config_lookup_date := SYSDATE;
3223: END IF;
3224:

Line 3221: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN

3217:
3218: BEGIN
3219:
3220: -- Required because Istore passes FND_API.G_MISS_DATE
3221: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN
3222: v_config_lookup_date := SYSDATE;
3223: END IF;
3224:
3225: IF v_language IS NULL THEN

Line 3501: -- Required because Istore passes FND_API.G_MISS_DATE

3497: ORDER BY start_date DESC;
3498:
3499: BEGIN
3500:
3501: -- Required because Istore passes FND_API.G_MISS_DATE
3502: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN
3503: v_config_lookup_date := SYSDATE;
3504: END IF;
3505:

Line 3502: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN

3498:
3499: BEGIN
3500:
3501: -- Required because Istore passes FND_API.G_MISS_DATE
3502: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN
3503: v_config_lookup_date := SYSDATE;
3504: END IF;
3505:
3506: IF v_language IS NULL THEN