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.OKL_INS_CLAIM_ASSET_PVT dependencies on OKC_API

Line 20: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

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;

Line 58: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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,

Line 65: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 66: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 67: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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:

Line 68: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 98: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 99: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 100: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) 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;

Line 101: RAISE OKC_API.G_EXCEPTION_ERROR;

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;

Line 103: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) 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;
106: --dkagrawa commnted following code and moved down inside loop
107: --bug#4878489

Line 117: IF (l_iln_id =OKC_API.G_MISS_NUM OR l_iln_id IS NULL) THEN

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',

Line 118: OKC_API.set_message(p_app_name => G_APP_NAME,

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

Line 127: x_return_status := OKC_API.G_RET_STS_ERROR;

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

Line 142: IF (l_iln_id =OKC_API.G_MISS_NUM OR l_iln_id IS NULL) 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',

Line 143: OKC_API.set_message(p_app_name => G_APP_NAME,

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

Line 152: x_return_status := OKC_API.G_RET_STS_ERROR;

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;

Line 187: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 188: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 189: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) 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;

Line 190: RAISE OKC_API.G_EXCEPTION_ERROR;

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;

Line 192: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) 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;
195: END IF;
196:

Line 227: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 228: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 229: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) 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;

Line 230: RAISE OKC_API.G_EXCEPTION_ERROR;

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;

Line 232: IF (x_return_status = Okc_Api.G_RET_STS_SUCCESS) 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;
235:
236: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 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,

Line 239: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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,

Line 240: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 242: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

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:

Line 247: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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,

Line 248: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 250: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

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:

Line 256: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 304: p_init_msg_list => Okc_Api.G_FALSE ,

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,

Line 317: IF (X_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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:

Line 319: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;

Line 320: ELSIF (X_return_status = OKC_API.G_RET_STS_ERROR) THEN

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:

Line 322: RAISE OKC_API.G_EXCEPTION_ERROR;

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 ;