84: CZ_DEBUG_PUB.populate_debug_message(p_msg,p_caller,NVL(p_sqlcode,0),v_msg_tbl);
85: END populate_debug_message;
86: ------------------------------------------------------------------------
87: -----procedure that writes messages to the FND stack
88: PROCEDURE set_fnd_message(inMessageName IN VARCHAR2,
89: inToken1 IN VARCHAR2 DEFAULT NULL, inValue1 IN VARCHAR2 DEFAULT NULL,
90: inToken2 IN VARCHAR2 DEFAULT NULL, inValue2 IN VARCHAR2 DEFAULT NULL,
91: inToken3 IN VARCHAR2 DEFAULT NULL, inValue3 IN VARCHAR2 DEFAULT NULL,
92: inToken4 IN VARCHAR2 DEFAULT NULL, inValue4 IN VARCHAR2 DEFAULT NULL,
95: )
96: IS
97:
98: BEGIN
99: FND_MESSAGE.SET_NAME('CZ', inMessageName);
100: IF (inToken1 IS NOT NULL) THEN
101: FND_MESSAGE.SET_TOKEN(inToken1, inValue1);
102: END IF;
103:
97:
98: BEGIN
99: FND_MESSAGE.SET_NAME('CZ', inMessageName);
100: IF (inToken1 IS NOT NULL) THEN
101: FND_MESSAGE.SET_TOKEN(inToken1, inValue1);
102: END IF;
103:
104: IF (inToken2 IS NOT NULL) THEN
105: FND_MESSAGE.SET_TOKEN(inToken2, inValue2);
101: FND_MESSAGE.SET_TOKEN(inToken1, inValue1);
102: END IF;
103:
104: IF (inToken2 IS NOT NULL) THEN
105: FND_MESSAGE.SET_TOKEN(inToken2, inValue2);
106: END IF;
107:
108: IF (inToken3 IS NOT NULL) THEN
109: FND_MESSAGE.SET_TOKEN(inToken3, inValue3);
105: FND_MESSAGE.SET_TOKEN(inToken2, inValue2);
106: END IF;
107:
108: IF (inToken3 IS NOT NULL) THEN
109: FND_MESSAGE.SET_TOKEN(inToken3, inValue3);
110: END IF;
111:
112: IF (inToken4 IS NOT NULL) THEN
113: FND_MESSAGE.SET_TOKEN(inToken4, inValue4);
109: FND_MESSAGE.SET_TOKEN(inToken3, inValue3);
110: END IF;
111:
112: IF (inToken4 IS NOT NULL) THEN
113: FND_MESSAGE.SET_TOKEN(inToken4, inValue4);
114: END IF;
115:
116: IF (inToken5 IS NOT NULL) THEN
117: FND_MESSAGE.SET_TOKEN(inToken5, inValue5);
113: FND_MESSAGE.SET_TOKEN(inToken4, inValue4);
114: END IF;
115:
116: IF (inToken5 IS NOT NULL) THEN
117: FND_MESSAGE.SET_TOKEN(inToken5, inValue5);
118: END IF;
119:
120: IF (inToken6 IS NOT NULL) THEN
121: FND_MESSAGE.SET_TOKEN(inToken6, inValue6);
117: FND_MESSAGE.SET_TOKEN(inToken5, inValue5);
118: END IF;
119:
120: IF (inToken6 IS NOT NULL) THEN
121: FND_MESSAGE.SET_TOKEN(inToken6, inValue6);
122: END IF;
123:
124: FND_MSG_PUB.ADD;
125: END set_fnd_message;
121: FND_MESSAGE.SET_TOKEN(inToken6, inValue6);
122: END IF;
123:
124: FND_MSG_PUB.ADD;
125: END set_fnd_message;
126:
127: -------------------------------------------------------------------------
128: -------calling applications default publication parameters to G_MISS_DATE, G_MISS_CHAR etc
129: -------In such cases default the parameter to NULL.
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;
174: -----------------------------------------------------------------------
1223: COMMIT;
1224: EXCEPTION
1225: WHEN G_INCOMPATIBLE_API THEN
1226: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_VERSION_ERR', 'CODEVERSION', l_api_version, 'VERSION', p_api_version);
1227: set_fnd_message('CZ_NET_API_VERSION_ERR','CODEVERSION',l_api_version, 'VERSION', p_api_version);
1228: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1229: COMMIT;
1230: WHEN INVALID_VALIDATION_TYPE THEN
1231: l_errbuf := CZ_UTILS.GET_TEXT('CZ_BV_INVALID_TYPE','TYPE',p_validation_type);
1228: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1229: COMMIT;
1230: WHEN INVALID_VALIDATION_TYPE THEN
1231: l_errbuf := CZ_UTILS.GET_TEXT('CZ_BV_INVALID_TYPE','TYPE',p_validation_type);
1232: set_fnd_message('CZ_BV_INVALID_TYPE','TYPE',p_validation_type);
1233: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1234: COMMIT;
1235: WHEN NO_INPUT_RECORDS THEN
1236: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_config_tbl','PROC',l_api_name );
1233: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1234: COMMIT;
1235: WHEN NO_INPUT_RECORDS THEN
1236: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_config_tbl','PROC',l_api_name );
1237: set_fnd_message('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_config_tbl','PROC',l_api_name);
1238: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1239: COMMIT;
1240: WHEN INPUT_TREE_MODE_NULL THEN
1241: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);
1238: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1239: COMMIT;
1240: WHEN INPUT_TREE_MODE_NULL THEN
1241: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);
1242: set_fnd_message('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);
1243: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1244: COMMIT;
1245: WHEN NO_VALIDATION_CONTEXT THEN
1246: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);
1243: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1244: COMMIT;
1245: WHEN NO_VALIDATION_CONTEXT THEN
1246: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);
1247: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context, null, null);
1248: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1249: COMMIT;
1250: WHEN INVALID_CONTEXT THEN
1251: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);
1248: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1249: COMMIT;
1250: WHEN INVALID_CONTEXT THEN
1251: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);
1252: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context, null, null);
1253: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1254: COMMIT;
1255: WHEN INVALID_CONTAINER_HDR THEN
1256: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_SESSION_HDR','HDRID',l_config_hdr_id,'REV',l_config_rev_nbr);
1253: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1254: COMMIT;
1255: WHEN INVALID_CONTAINER_HDR THEN
1256: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_SESSION_HDR','HDRID',l_config_hdr_id,'REV',l_config_rev_nbr);
1257: set_fnd_message('CZ_NET_API_NO_SESSION_HDR','HDRID',l_config_hdr_id,'REV',l_config_rev_nbr);
1258: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1259: delete_configuration(x_config_model_tbl);
1260: x_config_model_tbl.DELETE;
1261: COMMIT;
1264: 'modelInstType', l_model_instantiation_type,
1265: 'compInstType' , l_component_instance_type,
1266: 'Hdr',l_config_hdr_id,
1267: 'Rev',l_config_rev_nbr);
1268: set_fnd_message('CZ_NET_API_INVALID_INST_HDR',
1269: 'modelInstType', l_model_instantiation_type,
1270: 'compInstType' , l_component_instance_type,
1271: 'Hdr',l_config_hdr_id,
1272: 'Rev',l_config_rev_nbr);
1275: x_config_model_tbl.DELETE;
1276: COMMIT;
1277: WHEN INVALID_INV_ORG_ID THEN
1278: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',l_main_config_hdr_id,'REV',l_main_config_rev_nbr);
1279: set_fnd_message('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',l_main_config_hdr_id,'REV',l_main_config_rev_nbr);
1280: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1281: delete_configuration(x_config_model_tbl);
1282: x_config_model_tbl.DELETE;
1283: COMMIT;
1282: x_config_model_tbl.DELETE;
1283: COMMIT;
1284: WHEN INVALID_OUT_INV_ORG_ID THEN
1285: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',v_output_cfg_hdr_id,'REV',v_output_cfg_rev_nbr);
1286: set_fnd_message('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',v_output_cfg_hdr_id,'REV',v_output_cfg_rev_nbr);
1287: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1288: IF x_config_model_tbl.COUNT>0 AND p_validation_type<>CZ_API_PUB.VALIDATE_RETURN THEN
1289: delete_configuration(x_config_model_tbl);
1290: x_config_model_tbl.DELETE;
1291: END IF;
1292: COMMIT;
1293: WHEN INVALID_TREE_MODE_ERR THEN
1294: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);
1295: set_fnd_message('CZ_NET_API_INVALID_TREE_MODE','MODE',p_tree_copy_mode,'PROC',l_api_name);
1296: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1297: delete_configuration(x_config_model_tbl);
1298: x_config_model_tbl.DELETE;
1299: COMMIT;
1298: x_config_model_tbl.DELETE;
1299: COMMIT;
1300: WHEN ORG_ID_EXCEP THEN
1301: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_DIFF_ORGS');
1302: set_fnd_message('CZ_NET_API_DIFF_ORGS',null,null, null, null);
1303: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1304: delete_configuration(x_config_model_tbl);
1305: x_config_model_tbl.DELETE;
1306: COMMIT;
1305: x_config_model_tbl.DELETE;
1306: COMMIT;
1307: WHEN COPY_CONFIG_FAILURE_EXCEP THEN
1308: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_COPY_CONFIG_ERR', 'HDR',l_main_config_hdr_id,'REV',l_main_config_rev_nbr,'ERR',l_copy_config_msg);
1309: set_fnd_message('CZ_NET_API_COPY_CONFIG_ERR','HDR',l_main_config_hdr_id,'REV',l_main_config_rev_nbr,'ERR',l_copy_config_msg,null,null);
1310: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1311: delete_configuration(x_config_model_tbl);
1312: x_config_model_tbl.DELETE;
1313: COMMIT;
1312: x_config_model_tbl.DELETE;
1313: COMMIT;
1314: WHEN INVALID_HEADER_EXCEP THEN
1315: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_SESSION_HDR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1316: set_fnd_message('CZ_NET_API_NO_SESSION_HDR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1317: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1318: delete_configuration(x_config_model_tbl);
1319: x_config_model_tbl.DELETE;
1320: COMMIT;
1319: x_config_model_tbl.DELETE;
1320: COMMIT;
1321: WHEN BATCH_VALID_ERR THEN
1322: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_BV_ERR', 'STATUS', l_batch_validate_msg);
1323: set_fnd_message('CZ_NET_API_BV_ERR', 'STATUS', l_batch_validate_msg,null,null);
1324: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1325: delete_configuration(x_config_model_tbl);
1326: x_config_model_tbl.DELETE;
1327: COMMIT;
1327: COMMIT;
1328: WHEN PARSE_XML_ERROR THEN
1329: l_config_err_msg := get_terminate_msg(v_xml_str);
1330: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_PARSE_BV_XML_ERR','Err',l_config_err_msg,1,2000);
1331: set_fnd_message('CZ_NET_API_PARSE_BV_XML_ERR', 'ERR', substr(v_xml_str,1,2000),null,null);
1332: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1333: delete_configuration(x_config_model_tbl);
1334: x_config_model_tbl.DELETE;
1335: COMMIT;
1667: COMMIT;
1668: EXCEPTION
1669: WHEN G_INCOMPATIBLE_API THEN
1670: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_VERSION_ERR', 'CODEVERSION', l_api_version, 'VERSION', p_api_version);
1671: set_fnd_message('CZ_NET_API_VERSION_ERR','CODEVERSION',l_api_version, 'VERSION', p_api_version);
1672: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1673: COMMIT;
1674: WHEN NO_INPUT_RECORDS THEN
1675: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_instance_tbl','PROC',l_api_name );
1672: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1673: COMMIT;
1674: WHEN NO_INPUT_RECORDS THEN
1675: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_instance_tbl','PROC',l_api_name );
1676: set_fnd_message('CZ_NET_API_NO_INPUT_HDRS','TABLE','p_instance_tbl','PROC',l_api_name);
1677: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1678: COMMIT;
1679: WHEN INVALID_HEADER_TYPE THEN
1680: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_INST_HDR','modelInstType', l_model_instantiation_type,
1679: WHEN INVALID_HEADER_TYPE THEN
1680: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_INST_HDR','modelInstType', l_model_instantiation_type,
1681: 'compInstType',l_component_instance_type,'Hdr',l_config_hdr_id,
1682: 'Rev',l_config_rev_nbr);
1683: set_fnd_message('CZ_NET_API_INVALID_INST_HDR','modelInstType', l_model_instantiation_type,
1684: 'compInstType',l_component_instance_type,'Hdr',l_config_hdr_id,
1685: 'Rev',l_config_rev_nbr);
1686: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1687: COMMIT;
1686: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1687: COMMIT;
1688: WHEN INVALID_CONTEXT THEN
1689: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX', 'CTX', p_validation_context);
1690: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX',p_validation_context, null, null);
1691: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1692: COMMIT;
1693: WHEN NO_VALIDATION_CONTEXT THEN
1694: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context);
1691: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1692: COMMIT;
1693: WHEN NO_VALIDATION_CONTEXT THEN
1694: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context);
1695: set_fnd_message('CZ_NET_API_INVALID_VAL_CTX','CTX', p_validation_context, null, null);
1696: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1697: COMMIT;
1698: WHEN INVALID_INV_ORG_ID THEN
1699: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1696: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1697: COMMIT;
1698: WHEN INVALID_INV_ORG_ID THEN
1699: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1700: set_fnd_message('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1701: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1702: COMMIT;
1703: WHEN MODEL_ORG_EXCEP THEN
1704: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_MODELID_ORGID_ERR',
1707: 'HDRID',p_config_hdr_id,
1708: 'REVNBR',p_config_rev_nbr,
1709: 'ITEM2',p_inventory_item_id,
1710: 'ORGID2',p_organization_id);
1711: set_fnd_message('CZ_NET_API_MODELID_ORGID_ERR',
1712: 'ITEM1', l_inventory_item_id,
1713: 'ORGID1',l_organization_id,
1714: 'HDRID', p_config_hdr_id,
1715: 'REVNBR',p_config_rev_nbr,
1718: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1719: COMMIT;
1720: WHEN BATCH_VALID_ERR THEN
1721: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_BV_ERR', 'STATUS', l_batch_validate_msg);
1722: set_fnd_message('CZ_NET_API_BV_ERR', 'STATUS', l_batch_validate_msg, null, null);
1723: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1724: COMMIT;
1725: WHEN PARSE_XML_ERROR THEN
1726: l_config_err_msg := get_terminate_msg(v_xml_str);
1724: COMMIT;
1725: WHEN PARSE_XML_ERROR THEN
1726: l_config_err_msg := get_terminate_msg(v_xml_str);
1727: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_PARSE_BV_XML_ERR','ERR',l_config_err_msg);
1728: set_fnd_message('CZ_NET_API_NO_CFG_HDR', 'ERR', substr(v_xml_str,1,2000),null,null);
1729: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1730: COMMIT;
1731: WHEN GEN_CONFIG_TREE_ERR THEN
1732: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_TREE_GEN_ERR','HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1729: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1730: COMMIT;
1731: WHEN GEN_CONFIG_TREE_ERR THEN
1732: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_TREE_GEN_ERR','HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1733: set_fnd_message('CZ_NET_API_TREE_GEN_ERR', 'HDR',l_config_hdr_id,'REV',l_config_rev_nbr);
1734: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1735: COMMIT;
1736: WHEN OTHERS THEN
1737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1903: );
1904:
1905: -- in case of publication look up failure
1906: IF (l_model_id IS NULL) THEN
1907: fnd_message.set_name('CZ', 'CZ_NO_PUB_MODEL');
1908: fnd_message.set_token('inventory_item_id', p_inventory_item_id);
1909: fnd_message.set_token('organization', p_organization_id);
1910: fnd_msg_pub.add;
1911: RAISE FND_API.G_EXC_ERROR;
1904:
1905: -- in case of publication look up failure
1906: IF (l_model_id IS NULL) THEN
1907: fnd_message.set_name('CZ', 'CZ_NO_PUB_MODEL');
1908: fnd_message.set_token('inventory_item_id', p_inventory_item_id);
1909: fnd_message.set_token('organization', p_organization_id);
1910: fnd_msg_pub.add;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;
1905: -- in case of publication look up failure
1906: IF (l_model_id IS NULL) THEN
1907: fnd_message.set_name('CZ', 'CZ_NO_PUB_MODEL');
1908: fnd_message.set_token('inventory_item_id', p_inventory_item_id);
1909: fnd_message.set_token('organization', p_organization_id);
1910: fnd_msg_pub.add;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;
1913:
1912: END IF;
1913:
1914: -- must be a network container model
1915: IF (NOT is_container_pvt(l_model_id)) THEN
1916: fnd_message.set_name('CZ', 'CZ_NOT_CONTAINER_MODEL');
1917: fnd_message.set_token('model', l_model_id);
1918: fnd_msg_pub.add;
1919:
1920: RAISE FND_API.G_EXC_ERROR;
1913:
1914: -- must be a network container model
1915: IF (NOT is_container_pvt(l_model_id)) THEN
1916: fnd_message.set_name('CZ', 'CZ_NOT_CONTAINER_MODEL');
1917: fnd_message.set_token('model', l_model_id);
1918: fnd_msg_pub.add;
1919:
1920: RAISE FND_API.G_EXC_ERROR;
1921: END IF;
2037: AND deleted_flag = NO_FLAG;
2038:
2039: EXCEPTION
2040: WHEN NO_DATA_FOUND THEN
2041: fnd_message.set_name('CZ','CZ_NO_CFG_ITEM');
2042: fnd_message.set_token('hdr_id','p_config_hdr_id');
2043: fnd_message.set_token('revision','p_config_hdr_id');
2044: fnd_message.set_token('item', p_config_item_id);
2045: fnd_msg_pub.add;
2038:
2039: EXCEPTION
2040: WHEN NO_DATA_FOUND THEN
2041: fnd_message.set_name('CZ','CZ_NO_CFG_ITEM');
2042: fnd_message.set_token('hdr_id','p_config_hdr_id');
2043: fnd_message.set_token('revision','p_config_hdr_id');
2044: fnd_message.set_token('item', p_config_item_id);
2045: fnd_msg_pub.add;
2046: RAISE FND_API.G_EXC_ERROR;
2039: EXCEPTION
2040: WHEN NO_DATA_FOUND THEN
2041: fnd_message.set_name('CZ','CZ_NO_CFG_ITEM');
2042: fnd_message.set_token('hdr_id','p_config_hdr_id');
2043: fnd_message.set_token('revision','p_config_hdr_id');
2044: fnd_message.set_token('item', p_config_item_id);
2045: fnd_msg_pub.add;
2046: RAISE FND_API.G_EXC_ERROR;
2047: END;
2040: WHEN NO_DATA_FOUND THEN
2041: fnd_message.set_name('CZ','CZ_NO_CFG_ITEM');
2042: fnd_message.set_token('hdr_id','p_config_hdr_id');
2043: fnd_message.set_token('revision','p_config_hdr_id');
2044: fnd_message.set_token('item', p_config_item_id);
2045: fnd_msg_pub.add;
2046: RAISE FND_API.G_EXC_ERROR;
2047: END;
2048:
2113: ,l_model_instantiation_type
2114: ,l_component_instance_type
2115: );
2116: IF (l_model_instantiation_type = NO_FLAG) THEN
2117: fnd_message.set_name('CZ','CZ_NO_CFG');
2118: fnd_message.set_token('hdr_id','p_config_hdr_id');
2119: fnd_message.set_token('revision','p_config_hdr_id');
2120: fnd_msg_pub.add;
2121: RAISE FND_API.G_EXC_ERROR;
2114: ,l_component_instance_type
2115: );
2116: IF (l_model_instantiation_type = NO_FLAG) THEN
2117: fnd_message.set_name('CZ','CZ_NO_CFG');
2118: fnd_message.set_token('hdr_id','p_config_hdr_id');
2119: fnd_message.set_token('revision','p_config_hdr_id');
2120: fnd_msg_pub.add;
2121: RAISE FND_API.G_EXC_ERROR;
2122: END IF;
2115: );
2116: IF (l_model_instantiation_type = NO_FLAG) THEN
2117: fnd_message.set_name('CZ','CZ_NO_CFG');
2118: fnd_message.set_token('hdr_id','p_config_hdr_id');
2119: fnd_message.set_token('revision','p_config_hdr_id');
2120: fnd_msg_pub.add;
2121: RAISE FND_API.G_EXC_ERROR;
2122: END IF;
2123:
2321: IF (SQL%ROWCOUNT > 0) THEN
2322: x_return_status := FND_API.G_RET_STS_SUCCESS;
2323: ELSE
2324: x_return_status := FND_API.G_RET_STS_ERROR;
2325: set_fnd_message('CZ_IB_API_NO_DEACTIVATE','ConfigHdrId',p_config_hdr_id, 'ConfigRevNbr', p_config_rev_nbr);
2326: END IF;
2327: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
2328:
2329: EXCEPTION
2328:
2329: EXCEPTION
2330: WHEN REMOVE_IB_ERR THEN
2331: x_return_status := FND_API.G_RET_STS_ERROR;
2332: set_fnd_message('CZ_IB_DEACT_REMOVE_IB_ERR',
2333: 'ConfigHdrId', p_config_hdr_id,
2334: 'ConfigRevNbr', p_config_rev_nbr,
2335: 'ConfigItemId', l_config_item_id,
2336: 'RunId', l_run_id);