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 226: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS) THEN

222: ,handle_deleted_flag
223: ,new_name
224: );
225:
226: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS) THEN
227: IF (l_orig_item_id_tbl.count > 0) THEN
228: RAISE API_CALL_EXC;
229: END IF;
230: return_value := 1;

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

350: ' x_install_config_rec => p_install_config_rec, ' ||
351: ' x_return_status => p_return_status, ' ||
352: ' x_return_message => p_return_message ' ||
353: ' ); ' ||
354: ' IF (p_return_status <> fnd_api.g_ret_sts_success) THEN ' ||
355: ' l_ib_errored := 1; ' ||
356: ' ELSE ' ||
357: ' IF (p_install_config_rec.config_inst_rev_num IS NULL) THEN ' ||
358: ' api_result := 0; ' ||

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

739: l_config_rev_nbr NUMBER;
740: l_valid_config VARCHAR2(10);
741: l_complete_config VARCHAR2(10);
742: l_header_id NUMBER;
743: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
744:
745: BEGIN
746: l_valid_config_start_pos := INSTR(UPPER(p_xml),l_valid_config_start_tag,1, 1)
747: + length(l_valid_config_start_tag);

Line 778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

774: x_valid_config := nvl(l_valid_config, 'FALSE');
775:
776: EXCEPTION
777: WHEN OTHERS THEN
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: x_error_message := SQLERRM;
780: END Parse_output_xml;
781: -------------------------------------------------------------------
782: -------procedure that checks if the passed in init message

Line 951: x_return_status := FND_API.G_RET_STS_SUCCESS;

947: and config_rev_nbr IN (p_old_rev, p_new_rev)
948: ORDER BY config_item_id,config_hdr_id,config_rev_nbr;
949:
950: BEGIN
951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953: FOR I IN 1..1
954: LOOP
955:

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

994: v_parse_status ,
995: v_parse_message) ;
996:
997: ----if error in parsing xml raise an exception
998: IF (v_parse_status <> FND_API.G_RET_STS_SUCCESS) THEN
999: RAISE PARSE_XML_ERROR;
1000: END IF;
1001:
1002: IF (UPPER(v_valid_config) NOT IN ('TRUE', 'Y')) THEN

Line 1116: x_return_status := FND_API.G_RET_STS_SUCCESS;

1112: END LOOP;
1113: COMMIT;
1114: EXCEPTION
1115: WHEN NO_INPUT_HDR_EXCEP THEN
1116: x_return_status := FND_API.G_RET_STS_SUCCESS;
1117: WHEN PARSE_XML_ERROR THEN
1118: ROLLBACK;
1119: -- l_report_status := CZ_UTILS.REPORT (v_parse_message,1,'ITEM DELTA',1);
1120: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, v_parse_message,

Line 1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1118: ROLLBACK;
1119: -- l_report_status := CZ_UTILS.REPORT (v_parse_message,1,'ITEM DELTA',1);
1120: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, v_parse_message,
1121: fnd_log.LEVEL_ERROR);
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123: WHEN OTHERS THEN
1124: ROLLBACK;
1125: l_config_err_msg := SQLERRM;
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123: WHEN OTHERS THEN
1124: ROLLBACK;
1125: l_config_err_msg := SQLERRM;
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1127: -- l_report_status := CZ_UTILS.REPORT (l_config_err_msg,1,'ITEM DELTA',1);
1128: cz_utils.log_report('CZ_CF_API', 'check_deltas', null, l_config_err_msg,
1129: fnd_log.LEVEL_UNEXPECTED);
1130: END check_deltas;

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

1459:
1460: BEGIN
1461: l_nDebug := 1;
1462:
1463: IF (NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465: END IF;
1466:
1467: l_validation_type := p_validation_type;

Line 1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1460: BEGIN
1461: l_nDebug := 1;
1462:
1463: IF (NOT FND_API.compatible_api_call(l_api_version,p_api_version,l_api_name,G_PKG_NAME)) THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465: END IF;
1466:
1467: l_validation_type := p_validation_type;
1468: IF l_validation_type IS NULL THEN

Line 1476: RAISE FND_API.G_EXC_ERROR;

1472: CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN) THEN
1473: fnd_message.set_name('CZ', 'CZ_BV_INVALID_TYPE');
1474: fnd_message.set_token('TYPE', l_validation_type);
1475: fnd_msg_pub.add;
1476: RAISE FND_API.G_EXC_ERROR;
1477: END IF;
1478:
1479: IF p_init_msg IS NULL OR length(p_init_msg) = 0 THEN
1480: fnd_message.set_name('CZ', 'CZ_BV_NULL_INITMSG');

Line 1482: RAISE FND_API.G_EXC_ERROR;

1478:
1479: IF p_init_msg IS NULL OR length(p_init_msg) = 0 THEN
1480: fnd_message.set_name('CZ', 'CZ_BV_NULL_INITMSG');
1481: fnd_msg_pub.add;
1482: RAISE FND_API.G_EXC_ERROR;
1483: END IF;
1484:
1485: l_url := p_url;
1486: IF l_url IS NULL THEN

Line 1553: IF l_rec1_seq = FND_API.G_MISS_NUM THEN

1549:
1550: l_nDebug := 4;
1551: IF l_has_item THEN
1552: l_rec1_seq := p_config_item_tbl(p_config_item_tbl.FIRST).sequence_nbr;
1553: IF l_rec1_seq = FND_API.G_MISS_NUM THEN
1554: l_rec1_seq := NULL;
1555: END IF;
1556:
1557: FOR i IN p_config_item_tbl.FIRST..p_config_item_tbl.LAST

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

1567: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1568: END IF;
1569:
1570: IF p_config_item_tbl(i).config_item_id IS NULL OR
1571: p_config_item_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN
1572: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'CONFIG_ITEM_ID', 'TYPE', 'ITEM',
1573: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF;

Line 1574: RAISE FND_API.G_EXC_ERROR;

1570: IF p_config_item_tbl(i).config_item_id IS NULL OR
1571: p_config_item_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN
1572: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'CONFIG_ITEM_ID', 'TYPE', 'ITEM',
1573: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF;
1576:
1577: IF p_config_item_tbl(i).operation IS NULL OR
1578: p_config_item_tbl(i).operation = FND_API.G_MISS_NUM THEN

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

1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF;
1576:
1577: IF p_config_item_tbl(i).operation IS NULL OR
1578: p_config_item_tbl(i).operation = FND_API.G_MISS_NUM THEN
1579: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'OPERATION', 'TYPE', 'ITEM',
1580: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1581: RAISE FND_API.G_EXC_ERROR;
1582: ELSIF p_config_item_tbl(i).operation NOT IN (BV_OPERATION_UPDATE,BV_OPERATION_DELETE) THEN

Line 1581: RAISE FND_API.G_EXC_ERROR;

1577: IF p_config_item_tbl(i).operation IS NULL OR
1578: p_config_item_tbl(i).operation = FND_API.G_MISS_NUM THEN
1579: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'OPERATION', 'TYPE', 'ITEM',
1580: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1581: RAISE FND_API.G_EXC_ERROR;
1582: ELSIF p_config_item_tbl(i).operation NOT IN (BV_OPERATION_UPDATE,BV_OPERATION_DELETE) THEN
1583: IF p_config_item_tbl(i).operation = BV_OPERATION_INSERT THEN
1584: l_operation_code := 'INSERT';
1585: ELSIF p_config_item_tbl(i).operation = BV_OPERATION_REVERT THEN

Line 1595: RAISE FND_API.G_EXC_ERROR;

1591: fnd_message.set_token('CODE', l_operation_code);
1592: fnd_message.set_token('IDX', i);
1593: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1594: fnd_msg_pub.add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: ELSIF p_config_item_tbl(i).operation = BV_OPERATION_UPDATE AND
1597: p_config_item_tbl(i).instance_name = FND_API.G_MISS_CHAR THEN
1598: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'INSTANCE_NAME', 'TYPE', 'ITEM',
1599: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);

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

1593: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1594: fnd_msg_pub.add;
1595: RAISE FND_API.G_EXC_ERROR;
1596: ELSIF p_config_item_tbl(i).operation = BV_OPERATION_UPDATE AND
1597: p_config_item_tbl(i).instance_name = FND_API.G_MISS_CHAR THEN
1598: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'INSTANCE_NAME', 'TYPE', 'ITEM',
1599: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;

Line 1600: RAISE FND_API.G_EXC_ERROR;

1596: ELSIF p_config_item_tbl(i).operation = BV_OPERATION_UPDATE AND
1597: p_config_item_tbl(i).instance_name = FND_API.G_MISS_CHAR THEN
1598: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'INSTANCE_NAME', 'TYPE', 'ITEM',
1599: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;
1602:
1603: IF l_rec1_seq IS NULL AND p_config_item_tbl(i).sequence_nbr IS NOT NULL OR
1604: l_rec1_seq IS NOT NULL AND (p_config_item_tbl(i).sequence_nbr IS NULL OR

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

1601: END IF;
1602:
1603: IF l_rec1_seq IS NULL AND p_config_item_tbl(i).sequence_nbr IS NOT NULL OR
1604: l_rec1_seq IS NOT NULL AND (p_config_item_tbl(i).sequence_nbr IS NULL OR
1605: p_config_item_tbl(i).sequence_nbr=FND_API.G_MISS_NUM) THEN
1606: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'SEQUENCE_NBR', 'TYPE', 'ITEM',
1607: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1608: RAISE FND_API.G_EXC_ERROR;
1609: ELSIF p_config_item_tbl(i).sequence_nbr IS NOT NULL THEN

Line 1608: RAISE FND_API.G_EXC_ERROR;

1604: l_rec1_seq IS NOT NULL AND (p_config_item_tbl(i).sequence_nbr IS NULL OR
1605: p_config_item_tbl(i).sequence_nbr=FND_API.G_MISS_NUM) THEN
1606: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'SEQUENCE_NBR', 'TYPE', 'ITEM',
1607: 'IDX', i, 'SEQ', p_config_item_tbl(i).sequence_nbr);
1608: RAISE FND_API.G_EXC_ERROR;
1609: ELSIF p_config_item_tbl(i).sequence_nbr IS NOT NULL THEN
1610: IF l_item_seq_map.exists(p_config_item_tbl(i).sequence_nbr) THEN
1611: fnd_message.set_name('CZ', 'CZ_BV_DUP_SEQ');
1612: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);

Line 1614: RAISE FND_API.G_EXC_ERROR;

1610: IF l_item_seq_map.exists(p_config_item_tbl(i).sequence_nbr) THEN
1611: fnd_message.set_name('CZ', 'CZ_BV_DUP_SEQ');
1612: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1613: fnd_msg_pub.add;
1614: RAISE FND_API.G_EXC_ERROR;
1615: ELSE
1616: l_item_seq_map(p_config_item_tbl(i).sequence_nbr) := i;
1617: END IF;
1618: END IF;

Line 1634: RAISE FND_API.G_EXC_ERROR;

1630: fnd_message.set_token('TYPE', 'ITEM');
1631: fnd_message.set_token('IND', i);
1632: fnd_message.set_token('SEQ', p_config_item_tbl(i).sequence_nbr);
1633: fnd_msg_pub.add;
1634: RAISE FND_API.G_EXC_ERROR;
1635: ELSIF p_config_item_tbl(i).operation = BV_OPERATION_UPDATE THEN
1636: l_upd_item_map(p_config_item_tbl(i).config_item_id) := p_config_item_tbl(i).config_item_id;
1637: END IF;
1638:

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

1641: l_ecc_tbl(l_idx) := l_ext_comp_code;
1642: l_seq_nbr_tbl(l_idx) := NVL(p_config_item_tbl(i).sequence_nbr, l_item_depth);
1643: l_operation_tbl(l_idx) := p_config_item_tbl(i).operation;
1644: l_quantity_tbl(l_idx) := p_config_item_tbl(i).quantity;
1645: IF l_quantity_tbl(l_idx) = FND_API.G_MISS_NUM THEN
1646: l_quantity_tbl(l_idx) := l_miss_num;
1647: END IF;
1648: l_instance_name_tbl(l_idx) := p_config_item_tbl(i).instance_name;
1649: l_loc_id_tbl(l_idx) := p_config_item_tbl(i).location_id;

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

1646: l_quantity_tbl(l_idx) := l_miss_num;
1647: END IF;
1648: l_instance_name_tbl(l_idx) := p_config_item_tbl(i).instance_name;
1649: l_loc_id_tbl(l_idx) := p_config_item_tbl(i).location_id;
1650: IF l_loc_id_tbl(l_idx) = FND_API.G_MISS_NUM THEN
1651: l_loc_id_tbl(l_idx) := l_miss_num;
1652: END IF;
1653: l_loc_type_code_tbl(l_idx) := p_config_item_tbl(i).location_type_code;
1654: l_rec_seq_tbl(l_idx) := i;

Line 1721: IF l_rec1_seq = FND_API.G_MISS_NUM THEN

1717: -- processing extended attributes
1718: IF l_has_attr THEN
1719: IF l_rec1_seq IS NULL AND NOT l_has_item THEN
1720: l_rec1_seq := p_config_ext_attr_tbl(p_config_ext_attr_tbl.FIRST).sequence_nbr;
1721: IF l_rec1_seq = FND_API.G_MISS_NUM THEN
1722: l_rec1_seq := NULL;
1723: END IF;
1724: END IF;
1725:

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

1737: CZ_UTILS.log_report(G_PKG_NAME, l_api_name, l_nDebug, l_msg, FND_LOG.LEVEL_STATEMENT);
1738: END IF;
1739:
1740: IF p_config_ext_attr_tbl(i).config_item_id IS NULL OR
1741: p_config_ext_attr_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN
1742: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'CONFIG_ITEM_ID', 'TYPE', 'ATTRIBUTE',
1743: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
1744: RAISE FND_API.G_EXC_ERROR;
1745: END IF;

Line 1744: RAISE FND_API.G_EXC_ERROR;

1740: IF p_config_ext_attr_tbl(i).config_item_id IS NULL OR
1741: p_config_ext_attr_tbl(i).config_item_id = FND_API.G_MISS_NUM THEN
1742: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'CONFIG_ITEM_ID', 'TYPE', 'ATTRIBUTE',
1743: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
1744: RAISE FND_API.G_EXC_ERROR;
1745: END IF;
1746:
1747: IF l_rec1_seq IS NULL AND p_config_ext_attr_tbl(i).sequence_nbr IS NOT NULL OR
1748: l_rec1_seq IS NOT NULL AND (p_config_ext_attr_tbl(i).sequence_nbr IS NULL OR

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

1745: END IF;
1746:
1747: IF l_rec1_seq IS NULL AND p_config_ext_attr_tbl(i).sequence_nbr IS NOT NULL OR
1748: l_rec1_seq IS NOT NULL AND (p_config_ext_attr_tbl(i).sequence_nbr IS NULL OR
1749: p_config_ext_attr_tbl(i).sequence_nbr=FND_API.G_MISS_NUM) THEN
1750: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'SEQUENCE_NBR', 'TYPE', 'ATTRIBUTE',
1751: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
1752: RAISE FND_API.G_EXC_ERROR;
1753: ELSIF p_config_ext_attr_tbl(i).sequence_nbr IS NOT NULL THEN

Line 1752: RAISE FND_API.G_EXC_ERROR;

1748: l_rec1_seq IS NOT NULL AND (p_config_ext_attr_tbl(i).sequence_nbr IS NULL OR
1749: p_config_ext_attr_tbl(i).sequence_nbr=FND_API.G_MISS_NUM) THEN
1750: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'SEQUENCE_NBR', 'TYPE', 'ATTRIBUTE',
1751: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
1752: RAISE FND_API.G_EXC_ERROR;
1753: ELSIF p_config_ext_attr_tbl(i).sequence_nbr IS NOT NULL THEN
1754: IF l_item_seq_map.exists(p_config_ext_attr_tbl(i).sequence_nbr) THEN
1755: fnd_message.set_name('CZ', 'CZ_BV_DUP_SEQ');
1756: fnd_message.set_token('SEQ', p_config_ext_attr_tbl(i).sequence_nbr);

Line 1758: RAISE FND_API.G_EXC_ERROR;

1754: IF l_item_seq_map.exists(p_config_ext_attr_tbl(i).sequence_nbr) THEN
1755: fnd_message.set_name('CZ', 'CZ_BV_DUP_SEQ');
1756: fnd_message.set_token('SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
1757: fnd_msg_pub.add;
1758: RAISE FND_API.G_EXC_ERROR;
1759: ELSE
1760: l_item_seq_map(p_config_ext_attr_tbl(i).sequence_nbr) := i;
1761: END IF;
1762: END IF;

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

1761: END IF;
1762: END IF;
1763:
1764: IF p_config_ext_attr_tbl(i).attribute_name IS NULL OR
1765: p_config_ext_attr_tbl(i).attribute_name = FND_API.G_MISS_CHAR THEN
1766: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'ATTRIBUTE_NAME', 'TYPE', 'ATTRIBUTE',
1767: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;

Line 1768: RAISE FND_API.G_EXC_ERROR;

1764: IF p_config_ext_attr_tbl(i).attribute_name IS NULL OR
1765: p_config_ext_attr_tbl(i).attribute_name = FND_API.G_MISS_CHAR THEN
1766: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'ATTRIBUTE_NAME', 'TYPE', 'ATTRIBUTE',
1767: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770: IF p_config_ext_attr_tbl(i).attribute_value IS NULL THEN
1771: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'ATTRIBUTE_VALUE', 'TYPE', 'ATTRIBUTE',
1772: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);

Line 1773: RAISE FND_API.G_EXC_ERROR;

1769: END IF;
1770: IF p_config_ext_attr_tbl(i).attribute_value IS NULL THEN
1771: set_message('CZ_BV_NULL_VAL', 'COLUMN', 'ATTRIBUTE_VALUE', 'TYPE', 'ATTRIBUTE',
1772: 'IDX', i, 'SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
1773: RAISE FND_API.G_EXC_ERROR;
1774: END IF;
1775:
1776: IF NOT l_upd_item_map.exists(p_config_ext_attr_tbl(i).config_item_id) THEN
1777: get_ext_comp_code(l_config_hdr_id, l_config_rev_nbr,

Line 1790: RAISE FND_API.G_EXC_ERROR;

1786: fnd_message.set_token('TYPE', 'ATTRIBUTE');
1787: fnd_message.set_token('IND', i);
1788: fnd_message.set_token('SEQ', p_config_ext_attr_tbl(i).sequence_nbr);
1789: fnd_msg_pub.add;
1790: RAISE FND_API.G_EXC_ERROR;
1791: END IF;
1792:
1793: -- Create a dummy item with no-op for now, this part of code will be removed
1794: -- or modified after changing to not generate ecc

Line 1899: RAISE FND_API.G_EXC_ERROR;

1895: IF l_validation_status = INIT_TOO_LONG THEN
1896: fnd_message.set_name('CZ', 'CZ_BV_ERR_INIT_MSG');
1897: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
1898: fnd_msg_pub.add;
1899: RAISE FND_API.G_EXC_ERROR;
1900: ELSIF l_validation_status = UTL_HTTP_INIT_FAILED THEN
1901: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_INIT');
1902: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
1903: fnd_msg_pub.add;

Line 1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1900: ELSIF l_validation_status = UTL_HTTP_INIT_FAILED THEN
1901: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_INIT');
1902: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
1903: fnd_msg_pub.add;
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: ELSIF l_validation_status = UTL_HTTP_REQUEST_FAILED THEN
1906: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_REQ');
1907: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
1908: fnd_msg_pub.add;

Line 1909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1905: ELSIF l_validation_status = UTL_HTTP_REQUEST_FAILED THEN
1906: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_REQ');
1907: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
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

Line 1917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1918: END IF;
1919:
1920: l_nDebug := 11;
1921: IF l_validation_status = CONFIG_PROCESSED AND l_validation_type = CZ_API_PUB.VALIDATE_ORDER

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

1920: l_nDebug := 11;
1921: IF l_validation_status = CONFIG_PROCESSED AND l_validation_type = CZ_API_PUB.VALIDATE_ORDER
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

Line 1931: RAISE FND_API.G_EXC_ERROR;

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;
1931: RAISE FND_API.G_EXC_ERROR;
1932: END IF;
1933: END IF;
1934:
1935: l_nDebug := 12;

Line 1938: x_return_status := FND_API.G_RET_STS_SUCCESS;

1934:
1935: l_nDebug := 12;
1936: delete_bv_records(l_pseudo_hdr_id, TRUE, TRUE);
1937:
1938: x_return_status := FND_API.G_RET_STS_SUCCESS;
1939:
1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN
1942: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1941: WHEN FND_API.G_EXC_ERROR THEN

1937:
1938: x_return_status := FND_API.G_RET_STS_SUCCESS;
1939:
1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN
1942: x_return_status := FND_API.G_RET_STS_ERROR;
1943: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1944: p_data => x_msg_data);
1945: ROLLBACK;

Line 1942: x_return_status := FND_API.G_RET_STS_ERROR;

1938: x_return_status := FND_API.G_RET_STS_SUCCESS;
1939:
1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN
1942: x_return_status := FND_API.G_RET_STS_ERROR;
1943: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1944: p_data => x_msg_data);
1945: ROLLBACK;
1946:

Line 1947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1943: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1944: p_data => x_msg_data);
1945: ROLLBACK;
1946:
1947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1949: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1950: p_data => x_msg_data);
1951: delete_bv_records(l_pseudo_hdr_id, FALSE, TRUE);

Line 1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1944: p_data => x_msg_data);
1945: ROLLBACK;
1946:
1947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1949: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1950: p_data => x_msg_data);
1951: delete_bv_records(l_pseudo_hdr_id, FALSE, TRUE);
1952:

Line 1954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1950: p_data => x_msg_data);
1951: delete_bv_records(l_pseudo_hdr_id, FALSE, TRUE);
1952:
1953: WHEN OTHERS THEN
1954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1955: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1956: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
1957: END IF;
1958:

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

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
2177: RAISE DELTA_CHECK_FAILURE;
2178: END IF;
2179: END IF;
2180:

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

2816: ORDER BY start_date DESC;
2817:
2818: BEGIN
2819:
2820: -- Required because Istore passes FND_API.G_MISS_DATE
2821: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN
2822: v_config_lookup_date := SYSDATE;
2823: END IF;
2824:

Line 2821: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN

2817:
2818: BEGIN
2819:
2820: -- Required because Istore passes FND_API.G_MISS_DATE
2821: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN
2822: v_config_lookup_date := SYSDATE;
2823: END IF;
2824:
2825: IF v_language IS NULL THEN

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

3097: ORDER BY start_date DESC;
3098:
3099: BEGIN
3100:
3101: -- Required because Istore passes FND_API.G_MISS_DATE
3102: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN
3103: v_config_lookup_date := SYSDATE;
3104: END IF;
3105:

Line 3102: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN

3098:
3099: BEGIN
3100:
3101: -- Required because Istore passes FND_API.G_MISS_DATE
3102: IF v_config_lookup_date = FND_API.G_MISS_DATE THEN
3103: v_config_lookup_date := SYSDATE;
3104: END IF;
3105:
3106: IF v_language IS NULL THEN