DBA Data[Home] [Help]

APPS.CZ_CF_API dependencies on CZ_API_PUB

Line 209: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;

205: l_copy_mode VARCHAR2(1);
206: l_ret_status VARCHAR2(1);
207: l_msg_count INTEGER;
208:
209: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
210: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
211: API_CALL_EXC EXCEPTION;
212:
213: BEGIN

Line 210: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;

206: l_ret_status VARCHAR2(1);
207: l_msg_count INTEGER;
208:
209: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
210: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
211: API_CALL_EXC EXCEPTION;
212:
213: BEGIN
214: IF ((new_config_flag IS NOT NULL) AND

Line 216: l_copy_mode := CZ_API_PUB.G_NEW_REVISION_COPY_MODE;

212:
213: BEGIN
214: IF ((new_config_flag IS NOT NULL) AND
215: (new_config_flag='0')) THEN
216: l_copy_mode := CZ_API_PUB.G_NEW_REVISION_COPY_MODE;
217: ELSE
218: l_copy_mode := CZ_API_PUB.G_NEW_HEADER_COPY_MODE;
219: END IF;
220:

Line 218: l_copy_mode := CZ_API_PUB.G_NEW_HEADER_COPY_MODE;

214: IF ((new_config_flag IS NOT NULL) AND
215: (new_config_flag='0')) THEN
216: l_copy_mode := CZ_API_PUB.G_NEW_REVISION_COPY_MODE;
217: ELSE
218: l_copy_mode := CZ_API_PUB.G_NEW_HEADER_COPY_MODE;
219: END IF;
220:
221: cz_config_api_pub.copy_configuration
222: (l_api_version

Line 1632: IF p_validation_type IS NULL OR p_validation_type = CZ_API_PUB.VALIDATE_ORDER THEN

1628: l_url := p_url;
1629: END;
1630:
1631: -- append validation type to batch validate tag
1632: IF p_validation_type IS NULL OR p_validation_type = CZ_API_PUB.VALIDATE_ORDER THEN
1633: l_batch_validate_open := batchurlencode('');
1634:
1635: ELSIF (p_validation_type = CZ_API_PUB.VALIDATE_FULFILLMENT) THEN
1636: l_batch_validate_open := batchurlencode('');

Line 1635: ELSIF (p_validation_type = CZ_API_PUB.VALIDATE_FULFILLMENT) THEN

1631: -- append validation type to batch validate tag
1632: IF p_validation_type IS NULL OR p_validation_type = CZ_API_PUB.VALIDATE_ORDER THEN
1633: l_batch_validate_open := batchurlencode('');
1634:
1635: ELSIF (p_validation_type = CZ_API_PUB.VALIDATE_FULFILLMENT) THEN
1636: l_batch_validate_open := batchurlencode('');
1637: ELSIF (p_validation_type = CZ_API_PUB.INTERACTIVE) THEN
1638: l_batch_validate_open := batchurlencode('');
1639: ELSE

Line 1637: ELSIF (p_validation_type = CZ_API_PUB.INTERACTIVE) THEN

1633: l_batch_validate_open := batchurlencode('');
1634:
1635: ELSIF (p_validation_type = CZ_API_PUB.VALIDATE_FULFILLMENT) THEN
1636: l_batch_validate_open := batchurlencode('');
1637: ELSIF (p_validation_type = CZ_API_PUB.INTERACTIVE) THEN
1638: l_batch_validate_open := batchurlencode('');
1639: ELSE
1640: l_batch_validate_open := batchurlencode('');
1641: END IF;

Line 1822: l_validation_type := CZ_API_PUB.VALIDATE_ORDER;

1818: END IF;
1819:
1820: l_validation_type := p_validation_type;
1821: IF l_validation_type IS NULL THEN
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');

Line 1824: (CZ_API_PUB.VALIDATE_ORDER, CZ_API_PUB.VALIDATE_FULFILLMENT,

1820: l_validation_type := p_validation_type;
1821: IF l_validation_type IS NULL THEN
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;

Line 1825: CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN) THEN

1821: IF l_validation_type IS NULL THEN
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;

Line 2274: IF l_validation_status = CONFIG_PROCESSED AND l_validation_type = CZ_API_PUB.VALIDATE_ORDER

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
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);

Line 2331: p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER)

2327: init_message IN VARCHAR2,
2328: config_messages IN OUT NOCOPY CFG_OUTPUT_PIECES,
2329: validation_status IN OUT NOCOPY NUMBER,
2330: URL IN VARCHAR2 DEFAULT FND_PROFILE.Value('CZ_UIMGR_URL'),
2331: p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER)
2332:
2333: IS
2334: p_check_config_flag VARCHAR2(2) := 'N';
2335: x_return_config_changed VARCHAR2(2) := NULL;

Line 2368: p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER,

2364: init_message IN VARCHAR2,
2365: config_messages IN OUT NOCOPY CFG_OUTPUT_PIECES,
2366: validation_status IN OUT NOCOPY NUMBER,
2367: URL IN VARCHAR2 DEFAULT FND_PROFILE.Value('CZ_UIMGR_URL'),
2368: p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER,
2369: p_check_config_flag IN VARCHAR2 DEFAULT 'N',
2370: x_return_config_changed OUT NOCOPY VARCHAR2)
2371:
2372: IS

Line 2572: IF validation_status = CONFIG_PROCESSED AND p_validation_type = CZ_API_PUB.VALIDATE_ORDER AND

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);
2576: IF (l_delta_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3799: AND UPPER(publication_mode) IN ( cz_api_pub.G_PRODUCTION_PUB_MODE , 'T')

3795: AND pub.inventory_item_id = p_inventory_item_id
3796: AND bom_explosion_org_id = p_organization_id
3797: AND fnd_application_id = p_application_id
3798: AND usage_id = p_usage_id AND language = p_language
3799: AND UPPER(publication_mode) IN ( cz_api_pub.G_PRODUCTION_PUB_MODE , 'T')
3800: AND source_target_flag = TARGET_PUBLICATION
3801: AND ui_style = UI_STYLE_DHTML
3802: AND ( (p_pub_start_date >= start_date AND p_pub_start_date < disable_date) OR
3803: (P_pub_end_date > start_date AND p_pub_end_date <= disable_date) OR