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_NETWORK_API_PUB dependencies on FND_API

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: APPLID_NOT_FOUND EXCEPTION;
135:
136: BEGIN
137:
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: IF (p_appl_param_rec.config_creation_date = FND_API.G_MISS_DATE) THEN
141: p_appl_param_rec.config_creation_date := NULL;
142: END IF;

Line 140: IF (p_appl_param_rec.config_creation_date = FND_API.G_MISS_DATE) THEN

136: BEGIN
137:
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: IF (p_appl_param_rec.config_creation_date = FND_API.G_MISS_DATE) THEN
141: p_appl_param_rec.config_creation_date := NULL;
142: END IF;
143:
144: IF (p_appl_param_rec.config_model_lookup_date = FND_API.G_MISS_DATE) THEN

Line 144: IF (p_appl_param_rec.config_model_lookup_date = FND_API.G_MISS_DATE) THEN

140: IF (p_appl_param_rec.config_creation_date = FND_API.G_MISS_DATE) THEN
141: p_appl_param_rec.config_creation_date := NULL;
142: END IF;
143:
144: IF (p_appl_param_rec.config_model_lookup_date = FND_API.G_MISS_DATE) THEN
145: p_appl_param_rec.config_model_lookup_date := NULL;
146: END IF;
147:
148: IF (p_appl_param_rec.config_effective_date = FND_API.G_MISS_DATE) THEN

Line 148: IF (p_appl_param_rec.config_effective_date = FND_API.G_MISS_DATE) THEN

144: IF (p_appl_param_rec.config_model_lookup_date = FND_API.G_MISS_DATE) THEN
145: p_appl_param_rec.config_model_lookup_date := NULL;
146: END IF;
147:
148: IF (p_appl_param_rec.config_effective_date = FND_API.G_MISS_DATE) THEN
149: p_appl_param_rec.config_effective_date := NULL;
150: END IF;
151:
152: IF (p_appl_param_rec.usage_name = FND_API.G_MISS_CHAR) THEN

Line 152: IF (p_appl_param_rec.usage_name = FND_API.G_MISS_CHAR) THEN

148: IF (p_appl_param_rec.config_effective_date = FND_API.G_MISS_DATE) THEN
149: p_appl_param_rec.config_effective_date := NULL;
150: END IF;
151:
152: IF (p_appl_param_rec.usage_name = FND_API.G_MISS_CHAR) THEN
153: p_appl_param_rec.usage_name := NULL;
154: END IF;
155:
156: IF (p_appl_param_rec.publication_mode = FND_API.G_MISS_CHAR) THEN

Line 156: IF (p_appl_param_rec.publication_mode = FND_API.G_MISS_CHAR) THEN

152: IF (p_appl_param_rec.usage_name = FND_API.G_MISS_CHAR) THEN
153: p_appl_param_rec.usage_name := NULL;
154: END IF;
155:
156: IF (p_appl_param_rec.publication_mode = FND_API.G_MISS_CHAR) THEN
157: p_appl_param_rec.publication_mode := NULL;
158: END IF;
159:
160: IF (p_appl_param_rec.language = FND_API.G_MISS_CHAR) THEN

Line 160: IF (p_appl_param_rec.language = FND_API.G_MISS_CHAR) THEN

156: IF (p_appl_param_rec.publication_mode = FND_API.G_MISS_CHAR) THEN
157: p_appl_param_rec.publication_mode := NULL;
158: END IF;
159:
160: IF (p_appl_param_rec.language = FND_API.G_MISS_CHAR) THEN
161: p_appl_param_rec.language := NULL;
162: END IF;
163:
164: IF ( (p_appl_param_rec.calling_application_id = FND_API.G_MISS_NUM) OR (p_appl_param_rec.calling_application_id IS NULL) ) THEN

Line 164: IF ( (p_appl_param_rec.calling_application_id = FND_API.G_MISS_NUM) OR (p_appl_param_rec.calling_application_id IS NULL) ) THEN

160: IF (p_appl_param_rec.language = FND_API.G_MISS_CHAR) THEN
161: p_appl_param_rec.language := NULL;
162: END IF;
163:
164: IF ( (p_appl_param_rec.calling_application_id = FND_API.G_MISS_NUM) OR (p_appl_param_rec.calling_application_id IS NULL) ) THEN
165: RAISE APPLID_NOT_FOUND;
166: END IF;
167: EXCEPTION
168: WHEN APPLID_NOT_FOUND THEN

Line 169: x_return_status := FND_API.G_RET_STS_ERROR;

165: RAISE APPLID_NOT_FOUND;
166: END IF;
167: EXCEPTION
168: WHEN APPLID_NOT_FOUND THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: set_fnd_message('CZ_NET_APPL_ID_ISNULL',null,null,null,null);
171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: END default_pb_parameters;

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: WHEN APPLID_NOT_FOUND THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: set_fnd_message('CZ_NET_APPL_ID_ISNULL',null,null,null,null);
171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: END default_pb_parameters;
174: -----------------------------------------------------------------------
175: ----procedure that sets the the return status to error
176: ----and populates the error message stack

Line 184: p_err_code := FND_API.G_RET_STS_ERROR;

180: p_err_msg IN VARCHAR2)
181: IS
182:
183: BEGIN
184: p_err_code := FND_API.G_RET_STS_ERROR;
185: fnd_msg_pub.count_and_get(p_count => p_msg_count,p_data => p_msg_data);
186: populate_debug_message(p_err_msg,NULL,NULL);
187: CZ_DEBUG_PUB.insert_into_logs(v_msg_tbl);
188: END set_error_message;

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

535:
536: -- message related
537: l_xml_hdr VARCHAR2(32767):= '';
538: l_dummy VARCHAR2(500) := NULL;
539: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
540:
541: BEGIN
542: ---- now set the values from model_rec and org_id
543: l_context_org_id := to_char(p_organization_id);

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

686: l_valid_config VARCHAR2(10);
687: l_complete_config VARCHAR2(10);
688: l_header_id NUMBER;
689: l_line_id NUMBER ;
690: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
691: l_return_status_del VARCHAR2(1);
692: l_msg VARCHAR2(2000);
693: l_msg_data VARCHAR2(2000);
694: l_msg_count NUMBER;

Line 716: RAISE FND_API.G_EXC_ERROR;

712:
713: -----no need to check if valid_config or complete_config
714: ----fix for bug# 2937753
715: IF ( (l_exit is NULL) OR (UPPER(l_exit) = 'ERROR') ) THEN
716: RAISE FND_API.G_EXC_ERROR;
717: ELSE
718: -- if everything ok, set return values
719: x_return_status := l_return_status;
720: x_config_header_id := l_config_header_id;

Line 724: WHEN FND_API.G_EXC_ERROR THEN

720: x_config_header_id := l_config_header_id;
721: x_config_rev_nbr := l_config_rev_nbr;
722: END IF;
723: EXCEPTION
724: WHEN FND_API.G_EXC_ERROR THEN
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: WHEN OTHERS THEN
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: END Parse_output_xml;

Line 725: x_return_status := FND_API.G_RET_STS_ERROR;

721: x_config_rev_nbr := l_config_rev_nbr;
722: END IF;
723: EXCEPTION
724: WHEN FND_API.G_EXC_ERROR THEN
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: WHEN OTHERS THEN
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: END Parse_output_xml;
729:

Line 727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

723: EXCEPTION
724: WHEN FND_API.G_EXC_ERROR THEN
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: WHEN OTHERS THEN
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: END Parse_output_xml;
729:
730: --------------------------------------------------------------------------
731: ----procedure that logs trace for network API

Line 1036: x_return_status := FND_API.G_RET_STS_SUCCESS;

1032: l_orig_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1033: l_new_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1034:
1035: ----initialize return status to success
1036: x_return_status := FND_API.G_RET_STS_SUCCESS;
1037: fnd_msg_pub.initialize;
1038:
1039: ---check api version
1040: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 1040: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1036: x_return_status := FND_API.G_RET_STS_SUCCESS;
1037: fnd_msg_pub.initialize;
1038:
1039: ---check api version
1040: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1041: RAISE G_INCOMPATIBLE_API;
1042: END IF;
1043:
1044: ----verify that input array contains records

Line 1050: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN

1046: RAISE NO_INPUT_RECORDS;
1047: END IF;
1048:
1049: ---verify that the input parameters are not null
1050: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN
1051: RAISE INPUT_TREE_MODE_NULL;
1052: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
1053: new_config_flag := '0';
1054: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN

Line 1128: IF (l_copy_config_status <> FND_API.G_RET_STS_SUCCESS) THEN

1124: NULL,
1125: NULL,
1126: '1');
1127:
1128: IF (l_copy_config_status <> FND_API.G_RET_STS_SUCCESS) THEN
1129: RAISE COPY_CONFIG_FAILURE_EXCEP;
1130: ELSE
1131: reset_config_delta (v_config_hdr_id, v_config_rev_nbr);
1132: reset_config_flags (v_config_hdr_id, v_config_rev_nbr);

Line 1238: IF (l_copy_config_status <> FND_API.G_RET_STS_SUCCESS) THEN

1234: l_copy_config_msg,
1235: NULL,
1236: NULL);
1237:
1238: IF (l_copy_config_status <> FND_API.G_RET_STS_SUCCESS) THEN
1239: RAISE COPY_CONFIG_FAILURE_EXCEP;
1240: ELSE
1241: -- Sungard ER Bug7673721
1242: -- This causes problems because the container model is filtered out of config_details_v

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

1322: v_output_cfg_rev_nbr,
1323: v_parse_status);
1324:
1325: ----if error in parsing xml raise an exception
1326: IF (v_parse_status <> FND_API.G_RET_STS_SUCCESS) THEN
1327: RAISE PARSE_XML_ERROR;
1328: END IF;
1329:
1330: ---add the config hdr and rev to OUT NOCOPY put tbl

Line 1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1471: delete_configuration(x_config_model_tbl);
1472: x_config_model_tbl.DELETE;
1473: COMMIT;
1474: WHEN OTHERS THEN
1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1477: FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name);
1478: END IF;
1479: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 1614: x_return_status := FND_API.G_RET_STS_SUCCESS;

1610: NO_VALIDATION_CONTEXT EXCEPTION;
1611:
1612: BEGIN
1613: ----initialize return status to success
1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615: fnd_msg_pub.initialize;
1616:
1617: ---check api version
1618: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

Line 1618: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615: fnd_msg_pub.initialize;
1616:
1617: ---check api version
1618: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
1619: RAISE G_INCOMPATIBLE_API;
1620: END IF;
1621:
1622: ---check if instance records are passed

Line 1628: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN

1624: RAISE NO_INPUT_RECORDS;
1625: END IF;
1626:
1627: ---verify that the input parameters are not null
1628: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN
1629: RAISE INPUT_TREE_MODE_NULL;
1630: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
1631: new_config_flag := '0';
1632: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN

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

1749: v_output_cfg_rev_nbr,
1750: v_parse_status);
1751:
1752: ----if error in parsing xml raise an exception
1753: IF (v_parse_status <> FND_API.G_RET_STS_SUCCESS) THEN
1754: RAISE PARSE_XML_ERROR;
1755: END IF;
1756:
1757: ---add the config hdr and rev to OUT NOCOPY put tbl

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

1776: x_msg_count,
1777: x_msg_data
1778: );
1779:
1780: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1781: RAISE GEN_CONFIG_TREE_ERR;
1782: END IF;
1783:
1784: IF (l_config_model_tbl.COUNT > 1) THEN

Line 1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1871: set_fnd_message('CZ_NET_API_TREE_GEN_ERR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1872: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1873: COMMIT;
1874: WHEN OTHERS THEN
1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1877: FND_MSG_PUB.add_exc_msg(G_PKG_NAME,l_api_name);
1878: END IF;
1879: FND_MSG_PUB.count_and_get(NULL,x_msg_count,x_msg_data);

Line 2000: x_return_status := FND_API.G_RET_STS_SUCCESS;

1996: l_msg_data VARCHAR2(2000);
1997: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
1998:
1999: BEGIN
2000: x_return_status := FND_API.G_RET_STS_SUCCESS;
2001: fnd_msg_pub.initialize;
2002: x_model_tbl := cz_api_pub.NUMBER_TBL_TYPE();
2003: -- standard call to check for call compatibility
2004: IF (NOT FND_API.compatible_api_call(l_api_version

Line 2004: IF (NOT FND_API.compatible_api_call(l_api_version

2000: x_return_status := FND_API.G_RET_STS_SUCCESS;
2001: fnd_msg_pub.initialize;
2002: x_model_tbl := cz_api_pub.NUMBER_TBL_TYPE();
2003: -- standard call to check for call compatibility
2004: IF (NOT FND_API.compatible_api_call(l_api_version
2005: ,p_api_version
2006: ,l_api_name
2007: ,G_PKG_NAME
2008: )) THEN

Line 2009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2005: ,p_api_version
2006: ,l_api_name
2007: ,G_PKG_NAME
2008: )) THEN
2009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2010: END IF;
2011:
2012: ----default pb applicability parameters to NULL if no values are passed in
2013: l_appl_param_rec.config_creation_date := p_appl_param_rec.config_creation_date;

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

2018: l_appl_param_rec.publication_mode := p_appl_param_rec.publication_mode;
2019: l_appl_param_rec.language := p_appl_param_rec.language;
2020:
2021: default_pb_parameters(l_appl_param_rec,x_return_status);
2022: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:
2026: -- defaulting date values if not passed in

Line 2023: RAISE FND_API.G_EXC_ERROR;

2019: l_appl_param_rec.language := p_appl_param_rec.language;
2020:
2021: default_pb_parameters(l_appl_param_rec,x_return_status);
2022: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:
2026: -- defaulting date values if not passed in
2027: cz_cf_api.default_new_cfg_dates(l_appl_param_rec.config_creation_date

Line 2049: RAISE FND_API.G_EXC_ERROR;

2045: fnd_message.set_name('CZ', 'CZ_NO_PUB_MODEL');
2046: fnd_message.set_token('inventory_item_id', p_inventory_item_id);
2047: fnd_message.set_token('organization', p_organization_id);
2048: fnd_msg_pub.add;
2049: RAISE FND_API.G_EXC_ERROR;
2050: END IF;
2051:
2052: -- must be a network container model
2053: IF (NOT is_container_pvt(l_model_id)) THEN

Line 2058: RAISE FND_API.G_EXC_ERROR;

2054: fnd_message.set_name('CZ', 'CZ_NOT_CONTAINER_MODEL');
2055: fnd_message.set_token('model', l_model_id);
2056: fnd_msg_pub.add;
2057:
2058: RAISE FND_API.G_EXC_ERROR;
2059: END IF;
2060:
2061: get_contained_models_pvt(l_model_id, l_inventory_item_id_tbl);
2062: x_model_tbl := l_inventory_item_id_tbl;

Line 2068: WHEN FND_API.G_EXC_ERROR THEN

2064: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2065: p_data => x_msg_data);
2066:
2067: EXCEPTION
2068: WHEN FND_API.G_EXC_ERROR THEN
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2071: p_data => x_msg_data);
2072:

Line 2069: x_return_status := FND_API.G_RET_STS_ERROR;

2065: p_data => x_msg_data);
2066:
2067: EXCEPTION
2068: WHEN FND_API.G_EXC_ERROR THEN
2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2071: p_data => x_msg_data);
2072:
2073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2069: x_return_status := FND_API.G_RET_STS_ERROR;
2070: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2071: p_data => x_msg_data);
2072:
2073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2075: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2076: p_data => x_msg_data);
2077:

Line 2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2070: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2071: p_data => x_msg_data);
2072:
2073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2075: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2076: p_data => x_msg_data);
2077:
2078: WHEN OTHERS THEN

Line 2079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2075: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2076: p_data => x_msg_data);
2077:
2078: WHEN OTHERS THEN
2079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2080: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
2081: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
2082: END IF;
2083: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2110: IF (NOT FND_API.compatible_api_call(l_api_version

2106: BEGIN
2107: fnd_msg_pub.initialize;
2108:
2109: -- standard call to check for call compatibility
2110: IF (NOT FND_API.compatible_api_call(l_api_version
2111: ,p_api_version
2112: ,l_api_name
2113: ,G_PKG_NAME
2114: )) THEN

Line 2115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2111: ,p_api_version
2112: ,l_api_name
2113: ,G_PKG_NAME
2114: )) THEN
2115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2116: END IF;
2117:
2118: SELECT DECODE(config_model_type, NETWORK_CONTAINER_MODEL, FND_API.G_TRUE, FND_API.G_FALSE)
2119: INTO x_return_value

Line 2118: SELECT DECODE(config_model_type, NETWORK_CONTAINER_MODEL, FND_API.G_TRUE, FND_API.G_FALSE)

2114: )) THEN
2115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2116: END IF;
2117:
2118: SELECT DECODE(config_model_type, NETWORK_CONTAINER_MODEL, FND_API.G_TRUE, FND_API.G_FALSE)
2119: INTO x_return_value
2120: FROM mtl_system_items_b
2121: WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id;
2122:

Line 2123: x_return_status := FND_API.G_RET_STS_SUCCESS;

2119: INTO x_return_value
2120: FROM mtl_system_items_b
2121: WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_organization_id;
2122:
2123: x_return_status := FND_API.G_RET_STS_SUCCESS;
2124:
2125: EXCEPTION
2126: WHEN NO_DATA_FOUND THEN
2127: x_return_value := NULL;

Line 2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2124:
2125: EXCEPTION
2126: WHEN NO_DATA_FOUND THEN
2127: x_return_value := NULL;
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: x_msg_count := 1;
2130: x_msg_data := 'The input inventory item ' || p_inventory_item_id || ' with organization ' ||
2131: p_organization_id || ' does not exist';
2132:

Line 2133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2129: x_msg_count := 1;
2130: x_msg_data := 'The input inventory item ' || p_inventory_item_id || ' with organization ' ||
2131: p_organization_id || ' does not exist';
2132:
2133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2134: x_return_value := NULL;
2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2136: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2137: p_data => x_msg_data);

Line 2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2131: p_organization_id || ' does not exist';
2132:
2133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2134: x_return_value := NULL;
2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2136: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2137: p_data => x_msg_data);
2138: END is_container;
2139:

Line 2161: IF (NOT FND_API.compatible_api_call(l_api_version

2157:
2158: l_component_instance_type cz_config_items.component_instance_type%TYPE;
2159:
2160: BEGIN
2161: IF (NOT FND_API.compatible_api_call(l_api_version
2162: ,p_api_version
2163: ,l_api_name
2164: ,G_PKG_NAME
2165: )) THEN

Line 2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2162: ,p_api_version
2163: ,l_api_name
2164: ,G_PKG_NAME
2165: )) THEN
2166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2167: END IF;
2168:
2169: BEGIN
2170: SELECT component_instance_type INTO l_component_instance_type

Line 2184: RAISE FND_API.G_EXC_ERROR;

2180: fnd_message.set_token('hdr_id','p_config_hdr_id');
2181: fnd_message.set_token('revision','p_config_hdr_id');
2182: fnd_message.set_token('item', p_config_item_id);
2183: fnd_msg_pub.add;
2184: RAISE FND_API.G_EXC_ERROR;
2185: END;
2186:
2187: IF (l_component_instance_type = INSTANCE_ROOT) THEN
2188: x_return_value := FND_API.G_TRUE;

Line 2188: x_return_value := FND_API.G_TRUE;

2184: RAISE FND_API.G_EXC_ERROR;
2185: END;
2186:
2187: IF (l_component_instance_type = INSTANCE_ROOT) THEN
2188: x_return_value := FND_API.G_TRUE;
2189: ELSE
2190: x_return_value := FND_API.G_FALSE;
2191: END IF;
2192:

Line 2190: x_return_value := FND_API.G_FALSE;

2186:
2187: IF (l_component_instance_type = INSTANCE_ROOT) THEN
2188: x_return_value := FND_API.G_TRUE;
2189: ELSE
2190: x_return_value := FND_API.G_FALSE;
2191: END IF;
2192:
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2193: x_return_status := FND_API.G_RET_STS_SUCCESS;

2189: ELSE
2190: x_return_value := FND_API.G_FALSE;
2191: END IF;
2192:
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2195: p_data => x_msg_data);
2196:
2197: EXCEPTION

Line 2198: WHEN FND_API.G_EXC_ERROR THEN

2194: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2195: p_data => x_msg_data);
2196:
2197: EXCEPTION
2198: WHEN FND_API.G_EXC_ERROR THEN
2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2201: p_data => x_msg_data);
2202:

Line 2199: x_return_status := FND_API.G_RET_STS_ERROR;

2195: p_data => x_msg_data);
2196:
2197: EXCEPTION
2198: WHEN FND_API.G_EXC_ERROR THEN
2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2201: p_data => x_msg_data);
2202:
2203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2201: p_data => x_msg_data);
2202:
2203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2205: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2206: p_data => x_msg_data);
2207:

Line 2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2200: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2201: p_data => x_msg_data);
2202:
2203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2205: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2206: p_data => x_msg_data);
2207:
2208: WHEN OTHERS THEN

Line 2209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2205: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2206: p_data => x_msg_data);
2207:
2208: WHEN OTHERS THEN
2209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2210: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
2211: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
2212: END IF;
2213:

Line 2241: IF (NOT FND_API.compatible_api_call(l_api_version

2237: l_model_instantiation_type cz_config_hdrs.model_instantiation_type%TYPE;
2238: l_component_instance_type cz_config_hdrs.component_instance_type%TYPE;
2239:
2240: BEGIN
2241: IF (NOT FND_API.compatible_api_call(l_api_version
2242: ,p_api_version
2243: ,l_api_name
2244: ,G_PKG_NAME
2245: )) THEN

Line 2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2242: ,p_api_version
2243: ,l_api_name
2244: ,G_PKG_NAME
2245: )) THEN
2246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2247: END IF;
2248:
2249: get_header_types(p_config_hdr_id
2250: ,p_config_rev_nbr

Line 2259: RAISE FND_API.G_EXC_ERROR;

2255: fnd_message.set_name('CZ','CZ_NO_CFG');
2256: fnd_message.set_token('hdr_id','p_config_hdr_id');
2257: fnd_message.set_token('revision','p_config_hdr_id');
2258: fnd_msg_pub.add;
2259: RAISE FND_API.G_EXC_ERROR;
2260: END IF;
2261:
2262: IF (l_model_instantiation_type <> NETWORK) THEN
2263: x_return_value := FND_API.G_TRUE;

Line 2263: x_return_value := FND_API.G_TRUE;

2259: RAISE FND_API.G_EXC_ERROR;
2260: END IF;
2261:
2262: IF (l_model_instantiation_type <> NETWORK) THEN
2263: x_return_value := FND_API.G_TRUE;
2264: ELSE
2265: x_return_value := FND_API.G_FALSE;
2266: END IF;
2267:

Line 2265: x_return_value := FND_API.G_FALSE;

2261:
2262: IF (l_model_instantiation_type <> NETWORK) THEN
2263: x_return_value := FND_API.G_TRUE;
2264: ELSE
2265: x_return_value := FND_API.G_FALSE;
2266: END IF;
2267:
2268: x_return_status := FND_API.G_RET_STS_SUCCESS;
2269: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 2268: x_return_status := FND_API.G_RET_STS_SUCCESS;

2264: ELSE
2265: x_return_value := FND_API.G_FALSE;
2266: END IF;
2267:
2268: x_return_status := FND_API.G_RET_STS_SUCCESS;
2269: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2270: p_data => x_msg_data);
2271:
2272: EXCEPTION

Line 2273: WHEN FND_API.G_EXC_ERROR THEN

2269: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2270: p_data => x_msg_data);
2271:
2272: EXCEPTION
2273: WHEN FND_API.G_EXC_ERROR THEN
2274: x_return_status := FND_API.G_RET_STS_ERROR;
2275: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2276: p_data => x_msg_data);
2277:

Line 2274: x_return_status := FND_API.G_RET_STS_ERROR;

2270: p_data => x_msg_data);
2271:
2272: EXCEPTION
2273: WHEN FND_API.G_EXC_ERROR THEN
2274: x_return_status := FND_API.G_RET_STS_ERROR;
2275: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2276: p_data => x_msg_data);
2277:
2278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2274: x_return_status := FND_API.G_RET_STS_ERROR;
2275: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2276: p_data => x_msg_data);
2277:
2278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2280: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2281: p_data => x_msg_data);
2282:

Line 2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2275: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2276: p_data => x_msg_data);
2277:
2278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2280: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2281: p_data => x_msg_data);
2282:
2283: WHEN OTHERS THEN

Line 2284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2280: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2281: p_data => x_msg_data);
2282:
2283: WHEN OTHERS THEN
2284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2285: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
2286: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
2287: END IF;
2288:

Line 2404: IF (NOT FND_API.compatible_api_call(l_api_version

2400: REMOVE_IB_ERR EXCEPTION;
2401:
2402: BEGIN
2403: fnd_msg_pub.initialize;
2404: IF (NOT FND_API.compatible_api_call(l_api_version
2405: ,p_api_version
2406: ,l_api_name
2407: ,G_PKG_NAME
2408: )) THEN

Line 2409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2405: ,p_api_version
2406: ,l_api_name
2407: ,G_PKG_NAME
2408: )) THEN
2409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2410: END IF;
2411:
2412: -----get root instance for the config_item_id
2413: get_root_instance(p_config_hdr_id,

Line 2460: x_return_status := FND_API.G_RET_STS_SUCCESS;

2456: AND config_rev_nbr = p_config_rev_nbr
2457: AND deleted_flag = NO_FLAG);
2458:
2459: IF (SQL%ROWCOUNT > 0) THEN
2460: x_return_status := FND_API.G_RET_STS_SUCCESS;
2461: ELSE
2462: x_return_status := FND_API.G_RET_STS_ERROR;
2463: set_fnd_message('CZ_IB_API_NO_DEACTIVATE','ConfigHdrId',p_config_hdr_id, 'ConfigRevNbr', p_config_rev_nbr);
2464: END IF;

Line 2462: x_return_status := FND_API.G_RET_STS_ERROR;

2458:
2459: IF (SQL%ROWCOUNT > 0) THEN
2460: x_return_status := FND_API.G_RET_STS_SUCCESS;
2461: ELSE
2462: x_return_status := FND_API.G_RET_STS_ERROR;
2463: set_fnd_message('CZ_IB_API_NO_DEACTIVATE','ConfigHdrId',p_config_hdr_id, 'ConfigRevNbr', p_config_rev_nbr);
2464: END IF;
2465: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
2466:

Line 2469: x_return_status := FND_API.G_RET_STS_ERROR;

2465: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
2466:
2467: EXCEPTION
2468: WHEN REMOVE_IB_ERR THEN
2469: x_return_status := FND_API.G_RET_STS_ERROR;
2470: set_fnd_message('CZ_IB_DEACT_REMOVE_IB_ERR',
2471: 'ConfigHdrId', p_config_hdr_id,
2472: 'ConfigRevNbr', p_config_rev_nbr,
2473: 'ConfigItemId', l_config_item_id,

Line 2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2472: 'ConfigRevNbr', p_config_rev_nbr,
2473: 'ConfigItemId', l_config_item_id,
2474: 'RunId', l_run_id);
2475: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2478: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2479: p_data => x_msg_data);
2480: WHEN OTHERS THEN

Line 2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2473: 'ConfigItemId', l_config_item_id,
2474: 'RunId', l_run_id);
2475: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2478: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2479: p_data => x_msg_data);
2480: WHEN OTHERS THEN
2481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2478: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2479: p_data => x_msg_data);
2480: WHEN OTHERS THEN
2481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2482: IF fnd_msg_pub.check_msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
2483: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
2484: END IF;
2485: