16: px_acdv_tbl IN OUT NOCOPY acdv_tbl_type,
17: px_acnv_tbl IN OUT NOCOPY acnv_tbl_type
18: )
19: AS
20: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
21: l_iln_id PLS_INTEGER;
22: l_kle_id NUMBER;
23: l_clmv_tbl clmv_tbl_type := px_clmv_tbl;
24: x_clmv_tbl clmv_tbl_type;
54: where cle.cle_id = p_cle_id and
55: cle.lse_id = lse.id and
56: lse.LTY_CODE = 'FIXED_ASSET';
57: BEGIN
58: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
59: G_PKG_NAME,
60: p_init_msg_list,
61: l_api_version,
62: p_api_version,
61: l_api_version,
62: p_api_version,
63: '_PROCESS',
64: x_return_status);
65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
66: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
67: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
68: RAISE OKC_API.G_EXCEPTION_ERROR;
69: END IF;
62: p_api_version,
63: '_PROCESS',
64: x_return_status);
65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
66: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
67: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
68: RAISE OKC_API.G_EXCEPTION_ERROR;
69: END IF;
70:
63: '_PROCESS',
64: x_return_status);
65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
66: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
67: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
68: RAISE OKC_API.G_EXCEPTION_ERROR;
69: END IF;
70:
71:
64: x_return_status);
65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
66: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
67: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
68: RAISE OKC_API.G_EXCEPTION_ERROR;
69: END IF;
70:
71:
72: --Populate the Master
94: END;
95: END IF;
96: -- End of wraper code generated automatically by Debug code generator for okl_ins_claims_pub.insert_INS_CLAIMS
97:
98: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
101: RAISE OKC_API.G_EXCEPTION_ERROR;
102: END IF;
95: END IF;
96: -- End of wraper code generated automatically by Debug code generator for okl_ins_claims_pub.insert_INS_CLAIMS
97:
98: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
101: RAISE OKC_API.G_EXCEPTION_ERROR;
102: END IF;
103: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
96: -- End of wraper code generated automatically by Debug code generator for okl_ins_claims_pub.insert_INS_CLAIMS
97:
98: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
101: RAISE OKC_API.G_EXCEPTION_ERROR;
102: END IF;
103: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
104: px_clmv_tbl := x_clmv_tbl;
97:
98: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
101: RAISE OKC_API.G_EXCEPTION_ERROR;
102: END IF;
103: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
104: px_clmv_tbl := x_clmv_tbl;
105: END IF;
99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
101: RAISE OKC_API.G_EXCEPTION_ERROR;
102: END IF;
103: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
104: px_clmv_tbl := x_clmv_tbl;
105: END IF;
106: --dkagrawa commnted following code and moved down inside loop
107: --bug#4878489
113: FETCH l_fav_csr INTO l_kle_id;
114: CLOSE l_fav_csr;
115:
116: -- if l_dummy_var is still set to default ,data was not found
117: IF (l_iln_id =OKC_API.G_MISS_NUM OR l_iln_id IS NULL) THEN
118: OKC_API.set_message(p_app_name => G_APP_NAME,
119: p_msg_name => G_NO_PARENT_RECORD,
120: p_token1 => G_COL_NAME_TOKEN,
121: p_token1_value => 'LOCATION ID',
114: CLOSE l_fav_csr;
115:
116: -- if l_dummy_var is still set to default ,data was not found
117: IF (l_iln_id =OKC_API.G_MISS_NUM OR l_iln_id IS NULL) THEN
118: OKC_API.set_message(p_app_name => G_APP_NAME,
119: p_msg_name => G_NO_PARENT_RECORD,
120: p_token1 => G_COL_NAME_TOKEN,
121: p_token1_value => 'LOCATION ID',
122: p_token2 => g_child_table_token, --3745151
123: p_token2_value => 'OKX_INSTALL_ITEMS_V',--3745151
124: p_token3 => g_parent_table_token,
125: p_token3_value => 'OKX_ITEM_INSTS_LINES_V');
126: -- notify caller of an error
127: x_return_status := OKC_API.G_RET_STS_ERROR;
128: END IF;
129: */
130: -- Populate the foreign key for the line
131: IF (l_acdv_tbl.COUNT > 0) THEN
138:
139: OPEN l_fav_csr(l_acdv_tbl(i).kle_id);
140: FETCH l_fav_csr INTO l_kle_id;
141: CLOSE l_fav_csr;
142: IF (l_iln_id =OKC_API.G_MISS_NUM OR l_iln_id IS NULL) THEN
143: OKC_API.set_message(p_app_name => G_APP_NAME,
144: p_msg_name => G_NO_PARENT_RECORD,
145: p_token1 => G_COL_NAME_TOKEN,
146: p_token1_value => 'LOCATION ID',
139: OPEN l_fav_csr(l_acdv_tbl(i).kle_id);
140: FETCH l_fav_csr INTO l_kle_id;
141: CLOSE l_fav_csr;
142: IF (l_iln_id =OKC_API.G_MISS_NUM OR l_iln_id IS NULL) THEN
143: OKC_API.set_message(p_app_name => G_APP_NAME,
144: p_msg_name => G_NO_PARENT_RECORD,
145: p_token1 => G_COL_NAME_TOKEN,
146: p_token1_value => 'LOCATION ID',
147: p_token2 => g_child_table_token, --3745151
148: p_token2_value => 'OKX_INSTALL_ITEMS_V',--3745151
149: p_token3 => g_parent_table_token,
150: p_token3_value => 'OKX_ITEM_INSTS_LINES_V');
151: -- notify caller of an error
152: x_return_status := OKC_API.G_RET_STS_ERROR;
153: END IF;
154: --Bug#4878489 end
155: l_acdv_tbl(i).clm_id := px_clmv_tbl(1).id;
156: l_acdv_tbl(i).isp_id := 1;
183: END;
184: END IF;
185: -- End of wraper code generated automatically by Debug code generator for okl_asset_cndtns_pub.insert_asset_cndtns
186:
187: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
190: RAISE OKC_API.G_EXCEPTION_ERROR;
191: END IF;
184: END IF;
185: -- End of wraper code generated automatically by Debug code generator for okl_asset_cndtns_pub.insert_asset_cndtns
186:
187: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
190: RAISE OKC_API.G_EXCEPTION_ERROR;
191: END IF;
192: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
185: -- End of wraper code generated automatically by Debug code generator for okl_asset_cndtns_pub.insert_asset_cndtns
186:
187: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
190: RAISE OKC_API.G_EXCEPTION_ERROR;
191: END IF;
192: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
193: null;
186:
187: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
188: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
190: RAISE OKC_API.G_EXCEPTION_ERROR;
191: END IF;
192: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
193: null;
194: --px_acdv_tbl := x_acdv_tbl;
188: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
190: RAISE OKC_API.G_EXCEPTION_ERROR;
191: END IF;
192: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
193: null;
194: --px_acdv_tbl := x_acdv_tbl;
195: END IF;
196:
223: END;
224: END IF;
225: -- End of wraper code generated automatically by Debug code generator for okl_asset_cndtn_lns_pub.insert_asset_cndtn_lns
226:
227: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
228: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
229: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
230: RAISE OKC_API.G_EXCEPTION_ERROR;
231: END IF;
224: END IF;
225: -- End of wraper code generated automatically by Debug code generator for okl_asset_cndtn_lns_pub.insert_asset_cndtn_lns
226:
227: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
228: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
229: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
230: RAISE OKC_API.G_EXCEPTION_ERROR;
231: END IF;
232: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
225: -- End of wraper code generated automatically by Debug code generator for okl_asset_cndtn_lns_pub.insert_asset_cndtn_lns
226:
227: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
228: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
229: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
230: RAISE OKC_API.G_EXCEPTION_ERROR;
231: END IF;
232: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
233: px_acnv_tbl := x_acnv_tbl;
226:
227: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
228: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
229: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
230: RAISE OKC_API.G_EXCEPTION_ERROR;
231: END IF;
232: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
233: px_acnv_tbl := x_acnv_tbl;
234: END IF;
228: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
229: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
230: RAISE OKC_API.G_EXCEPTION_ERROR;
231: END IF;
232: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
233: px_acnv_tbl := x_acnv_tbl;
234: END IF;
235:
236: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
232: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
233: px_acnv_tbl := x_acnv_tbl;
234: END IF;
235:
236: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
237:
238: EXCEPTION
239: WHEN OKC_API.G_EXCEPTION_ERROR THEN
240: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
235:
236: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
237:
238: EXCEPTION
239: WHEN OKC_API.G_EXCEPTION_ERROR THEN
240: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
241: p_pkg_name => G_PKG_NAME,
242: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
243: x_msg_count => x_msg_count,
236: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
237:
238: EXCEPTION
239: WHEN OKC_API.G_EXCEPTION_ERROR THEN
240: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
241: p_pkg_name => G_PKG_NAME,
242: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
243: x_msg_count => x_msg_count,
244: x_msg_data => x_msg_data,
238: EXCEPTION
239: WHEN OKC_API.G_EXCEPTION_ERROR THEN
240: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
241: p_pkg_name => G_PKG_NAME,
242: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
243: x_msg_count => x_msg_count,
244: x_msg_data => x_msg_data,
245: p_api_type => '_PROCESS');
246:
243: x_msg_count => x_msg_count,
244: x_msg_data => x_msg_data,
245: p_api_type => '_PROCESS');
246:
247: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
248: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
249: p_pkg_name => G_PKG_NAME,
250: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
251: x_msg_count => x_msg_count,
244: x_msg_data => x_msg_data,
245: p_api_type => '_PROCESS');
246:
247: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
248: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
249: p_pkg_name => G_PKG_NAME,
250: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
251: x_msg_count => x_msg_count,
252: x_msg_data => x_msg_data,
246:
247: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
248: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
249: p_pkg_name => G_PKG_NAME,
250: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
251: x_msg_count => x_msg_count,
252: x_msg_data => x_msg_data,
253: p_api_type => '_PROCESS');
254:
252: x_msg_data => x_msg_data,
253: p_api_type => '_PROCESS');
254:
255: WHEN OTHERS THEN
256: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
257: p_pkg_name => G_PKG_NAME,
258: p_exc_name => 'OTHERS',
259: x_msg_count => x_msg_count,
260: x_msg_data => x_msg_data,
300: END;
301: END IF;
302: Okl_Streams_Pub.update_streams (
303: p_api_version => l_api_version,
304: p_init_msg_list => Okc_Api.G_FALSE ,
305: x_return_status => X_return_status ,
306: x_msg_count => x_msg_count,
307: x_msg_data => x_msg_data ,
308: p_stmv_tbl => l_stmv_tbl,
313: END;
314: END IF;
315: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
316:
317: IF (X_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
318:
319: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
320: ELSIF (X_return_status = OKC_API.G_RET_STS_ERROR) THEN
321:
315: -- End of wraper code generated automatically by Debug code generator for Okl_Streams_Pub.update_streams
316:
317: IF (X_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
318:
319: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
320: ELSIF (X_return_status = OKC_API.G_RET_STS_ERROR) THEN
321:
322: RAISE OKC_API.G_EXCEPTION_ERROR;
323: END IF;
316:
317: IF (X_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
318:
319: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
320: ELSIF (X_return_status = OKC_API.G_RET_STS_ERROR) THEN
321:
322: RAISE OKC_API.G_EXCEPTION_ERROR;
323: END IF;
324:
318:
319: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
320: ELSIF (X_return_status = OKC_API.G_RET_STS_ERROR) THEN
321:
322: RAISE OKC_API.G_EXCEPTION_ERROR;
323: END IF;
324:
325: END IF ;
326: END IF ;