DBA Data[Home] [Help]

APPS.ZX_GLOBAL_STRUCTURES_PKG dependencies on FND_API

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 113: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 132: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 162: x_return_status := FND_API.G_RET_STS_SUCCESS;

158: --IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
159: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'get_regimes_usages_info'||'.BEGIN','ZX_GLOBAL_STRUCTURES_PKG: get_regimes_usages_info()+ ');
160: --END IF;
161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163: l_tbl_index := dbms_utility.get_hash_value(p_tax_regime_code||to_char(p_first_pty_org_id), 1, 8192);
164:
165: IF G_REGIMES_USAGES_TBL.exists(l_tbl_index) then
166: x_regime_usage_id := G_REGIMES_USAGES_TBL(l_tbl_index).regime_usage_id;