APPS.ZX_GLOBAL_STRUCTURES_PKG dependencies on FND_API

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89: application_id = c_application_id
90: and org_id = c_org_id;
91: BEGIN
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'get_product_options_info'||'.BEGIN','ZX_GLOBAL_STRUCTURES_PKG: get_product_options_info()+ ');
97: END IF;

Line 114: x_return_status := FND_API.G_RET_STS_ERROR;

110: g_zx_proudct_options_tbl(l_tbl_index) := x_product_options_rec;
111: close c_product_options;
112: EXCEPTION
113: WHEN NO_DATA_FOUND THEN
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: IF c_product_options%isopen then
116: close c_product_options;
117: END IF;
118: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

129: when others then
130: If c_product_options%isopen then
131: close c_product_options;
132: end if;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
135: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||'get_product_options_info','Exception: '||SQLCODE||' ; '||SQLERRM);
136: END IF;
137: END get_product_options_info;

Line 186: x_return_status := FND_API.G_RET_STS_SUCCESS;

182: ORDER BY event_class_mapping_id NULLS LAST;
183:
184: BEGIN
185:
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
189: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'get_product_options_info'||'.BEGIN','ZX_GLOBAL_STRUCTURES_PKG: get_product_options_info()+ ');
190: END IF;

Line 217: x_return_status := FND_API.G_RET_STS_ERROR;

213: g_zx_proudct_options_tbl(l_tbl_index) := x_product_options_rec;
214: close c_product_options;
215: EXCEPTION
216: WHEN NO_DATA_FOUND THEN
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: IF c_product_options%isopen then
219: close c_product_options;
220: END IF;
221: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232: when others then
233: If c_product_options%isopen then
234: close c_product_options;
235: end if;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
238: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||'get_product_options_info','Exception: '||SQLCODE||' ; '||SQLERRM);
239: END IF;
240: END get_product_options_info;

Line 266: x_return_status := FND_API.G_RET_STS_SUCCESS;

262: --IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
263: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'get_regimes_usages_info'||'.BEGIN','ZX_GLOBAL_STRUCTURES_PKG: get_regimes_usages_info()+ ');
264: --END IF;
265:
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267: l_tbl_index := dbms_utility.get_hash_value(p_tax_regime_code||to_char(p_first_pty_org_id), 1, 8192);
268:
269: IF G_REGIMES_USAGES_TBL.exists(l_tbl_index) then
270: x_regime_usage_id := G_REGIMES_USAGES_TBL(l_tbl_index).regime_usage_id;