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_SPLIT_ASSET_COMP_PUB dependencies on OKL_API

Line 29: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

25: p_api_version,
26: l_api_name,
27: G_PKG_NAME ))
28: THEN
29: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
30: END IF;
31:
32: -- Initialize message list if requested
33: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 38: x_return_status := OKL_API.G_RET_STS_SUCCESS;

34: FND_MSG_PUB.initialize;
35: END IF;
36:
37: -- Initialize API status to success
38: x_return_status := OKL_API.G_RET_STS_SUCCESS;
39:
40:
41: /*** Begin API body ****************************************************/
42:

Line 52: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

48: x_msg_data,
49: p_asdv_tbl,
50: x_asdv_tbl);
51:
52: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
53: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
54: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
55: RAISE OKL_API.G_EXCEPTION_ERROR;
56: END IF;

Line 53: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

49: p_asdv_tbl,
50: x_asdv_tbl);
51:
52: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
53: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
54: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
55: RAISE OKL_API.G_EXCEPTION_ERROR;
56: END IF;
57:

Line 54: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

50: x_asdv_tbl);
51:
52: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
53: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
54: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
55: RAISE OKL_API.G_EXCEPTION_ERROR;
56: END IF;
57:
58:

Line 55: RAISE OKL_API.G_EXCEPTION_ERROR;

51:
52: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
53: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
54: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
55: RAISE OKL_API.G_EXCEPTION_ERROR;
56: END IF;
57:
58:
59: /*** End API body ******************************************************/

Line 67: WHEN OKL_API.G_EXCEPTION_ERROR THEN

63: (p_count => x_msg_count,
64: p_data => x_msg_data);
65:
66: EXCEPTION
67: WHEN OKL_API.G_EXCEPTION_ERROR THEN
68: ROLLBACK TO create_split_asset_comp_pub;
69: x_return_status := OKL_API.G_RET_STS_ERROR;
70: FND_MSG_PUB.Count_And_Get
71: (p_count => x_msg_count,

Line 69: x_return_status := OKL_API.G_RET_STS_ERROR;

65:
66: EXCEPTION
67: WHEN OKL_API.G_EXCEPTION_ERROR THEN
68: ROLLBACK TO create_split_asset_comp_pub;
69: x_return_status := OKL_API.G_RET_STS_ERROR;
70: FND_MSG_PUB.Count_And_Get
71: (p_count => x_msg_count,
72: p_data => x_msg_data);
73:

Line 74: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

70: FND_MSG_PUB.Count_And_Get
71: (p_count => x_msg_count,
72: p_data => x_msg_data);
73:
74: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
75: ROLLBACK TO create_split_asset_comp_pub;
76: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
77: FND_MSG_PUB.Count_And_Get
78: (p_count => x_msg_count,

Line 76: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

72: p_data => x_msg_data);
73:
74: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
75: ROLLBACK TO create_split_asset_comp_pub;
76: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
77: FND_MSG_PUB.Count_And_Get
78: (p_count => x_msg_count,
79: p_data => x_msg_data);
80:

Line 83: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

79: p_data => x_msg_data);
80:
81: WHEN OTHERS THEN
82: ROLLBACK TO create_split_asset_comp_pub;
83: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
84: OKL_API.Set_Message(p_app_name => G_APP_NAME,
85: p_msg_name => G_UNEXPECTED_ERROR,
86: p_token1 => G_SQLCODE_TOKEN,
87: p_token1_value => SQLCODE,

Line 84: OKL_API.Set_Message(p_app_name => G_APP_NAME,

80:
81: WHEN OTHERS THEN
82: ROLLBACK TO create_split_asset_comp_pub;
83: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
84: OKL_API.Set_Message(p_app_name => G_APP_NAME,
85: p_msg_name => G_UNEXPECTED_ERROR,
86: p_token1 => G_SQLCODE_TOKEN,
87: p_token1_value => SQLCODE,
88: p_token2 => G_SQLERRM_TOKEN,

Line 121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

117: p_api_version,
118: l_api_name,
119: G_PKG_NAME ))
120: THEN
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: END IF;
123:
124: -- Initialize message list if requested
125: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 130: x_return_status := OKL_API.G_RET_STS_SUCCESS;

126: FND_MSG_PUB.initialize;
127: END IF;
128:
129: -- Initialize API status to success
130: x_return_status := OKL_API.G_RET_STS_SUCCESS;
131:
132:
133: /*** Begin API body ****************************************************/
134: -- OKL_ASD_PVT.update_row(p_api_version,

Line 143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

139: x_msg_data,
140: p_asdv_tbl,
141: x_asdv_tbl);
142:
143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_ERROR;
147: END IF;

Line 144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

140: p_asdv_tbl,
141: x_asdv_tbl);
142:
143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_ERROR;
147: END IF;
148:

Line 145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

141: x_asdv_tbl);
142:
143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_ERROR;
147: END IF;
148:
149: /*** End API body ******************************************************/

Line 146: RAISE OKL_API.G_EXCEPTION_ERROR;

142:
143: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
144: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
145: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
146: RAISE OKL_API.G_EXCEPTION_ERROR;
147: END IF;
148:
149: /*** End API body ******************************************************/
150:

Line 157: WHEN OKL_API.G_EXCEPTION_ERROR THEN

153: (p_count => x_msg_count,
154: p_data => x_msg_data);
155:
156: EXCEPTION
157: WHEN OKL_API.G_EXCEPTION_ERROR THEN
158: ROLLBACK TO update_split_asset_comp_pub;
159: x_return_status := OKL_API.G_RET_STS_ERROR;
160: FND_MSG_PUB.Count_And_Get
161: (p_count => x_msg_count,

Line 159: x_return_status := OKL_API.G_RET_STS_ERROR;

155:
156: EXCEPTION
157: WHEN OKL_API.G_EXCEPTION_ERROR THEN
158: ROLLBACK TO update_split_asset_comp_pub;
159: x_return_status := OKL_API.G_RET_STS_ERROR;
160: FND_MSG_PUB.Count_And_Get
161: (p_count => x_msg_count,
162: p_data => x_msg_data);
163:

Line 164: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

160: FND_MSG_PUB.Count_And_Get
161: (p_count => x_msg_count,
162: p_data => x_msg_data);
163:
164: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
165: ROLLBACK TO update_split_asset_comp_pub;
166: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.Count_And_Get
168: (p_count => x_msg_count,

Line 166: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

162: p_data => x_msg_data);
163:
164: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
165: ROLLBACK TO update_split_asset_comp_pub;
166: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.Count_And_Get
168: (p_count => x_msg_count,
169: p_data => x_msg_data);
170:

Line 173: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

169: p_data => x_msg_data);
170:
171: WHEN OTHERS THEN
172: ROLLBACK TO update_split_asset_comp_pub;
173: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
174: OKL_API.Set_Message(p_app_name => G_APP_NAME,
175: p_msg_name => G_UNEXPECTED_ERROR,
176: p_token1 => G_SQLCODE_TOKEN,
177: p_token1_value => SQLCODE,

Line 174: OKL_API.Set_Message(p_app_name => G_APP_NAME,

170:
171: WHEN OTHERS THEN
172: ROLLBACK TO update_split_asset_comp_pub;
173: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
174: OKL_API.Set_Message(p_app_name => G_APP_NAME,
175: p_msg_name => G_UNEXPECTED_ERROR,
176: p_token1 => G_SQLCODE_TOKEN,
177: p_token1_value => SQLCODE,
178: p_token2 => G_SQLERRM_TOKEN,

Line 209: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

205: p_api_version,
206: l_api_name,
207: G_PKG_NAME ))
208: THEN
209: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
210: END IF;
211:
212: -- Initialize message list if requested
213: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 218: x_return_status := OKL_API.G_RET_STS_SUCCESS;

214: FND_MSG_PUB.initialize;
215: END IF;
216:
217: -- Initialize API status to success
218: x_return_status := OKL_API.G_RET_STS_SUCCESS;
219:
220:
221: /*** Begin API body ****************************************************/
222: -- OKL_ASD_PVT.delete_row(p_api_version,

Line 230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

226: x_msg_count,
227: x_msg_data,
228: p_asdv_tbl);
229:
230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;

Line 231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

227: x_msg_data,
228: p_asdv_tbl);
229:
230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235:

Line 232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

228: p_asdv_tbl);
229:
230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235:
236: /*** End API body ******************************************************/

Line 233: RAISE OKL_API.G_EXCEPTION_ERROR;

229:
230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235:
236: /*** End API body ******************************************************/
237:

Line 244: WHEN OKL_API.G_EXCEPTION_ERROR THEN

240: (p_count => x_msg_count,
241: p_data => x_msg_data);
242:
243: EXCEPTION
244: WHEN OKL_API.G_EXCEPTION_ERROR THEN
245: ROLLBACK TO delete_split_asset_comp_pub;
246: x_return_status := OKL_API.G_RET_STS_ERROR;
247: FND_MSG_PUB.Count_And_Get
248: (p_count => x_msg_count,

Line 246: x_return_status := OKL_API.G_RET_STS_ERROR;

242:
243: EXCEPTION
244: WHEN OKL_API.G_EXCEPTION_ERROR THEN
245: ROLLBACK TO delete_split_asset_comp_pub;
246: x_return_status := OKL_API.G_RET_STS_ERROR;
247: FND_MSG_PUB.Count_And_Get
248: (p_count => x_msg_count,
249: p_data => x_msg_data);
250:

Line 251: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

247: FND_MSG_PUB.Count_And_Get
248: (p_count => x_msg_count,
249: p_data => x_msg_data);
250:
251: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
252: ROLLBACK TO delete_split_asset_comp_pub;
253: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
254: FND_MSG_PUB.Count_And_Get
255: (p_count => x_msg_count,

Line 253: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

249: p_data => x_msg_data);
250:
251: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
252: ROLLBACK TO delete_split_asset_comp_pub;
253: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
254: FND_MSG_PUB.Count_And_Get
255: (p_count => x_msg_count,
256: p_data => x_msg_data);
257:

Line 260: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

256: p_data => x_msg_data);
257:
258: WHEN OTHERS THEN
259: ROLLBACK TO delete_split_asset_comp_pub;
260: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
261: OKL_API.Set_Message(p_app_name => G_APP_NAME,
262: p_msg_name => G_UNEXPECTED_ERROR,
263: p_token1 => G_SQLCODE_TOKEN,
264: p_token1_value => SQLCODE,

Line 261: OKL_API.Set_Message(p_app_name => G_APP_NAME,

257:
258: WHEN OTHERS THEN
259: ROLLBACK TO delete_split_asset_comp_pub;
260: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
261: OKL_API.Set_Message(p_app_name => G_APP_NAME,
262: p_msg_name => G_UNEXPECTED_ERROR,
263: p_token1 => G_SQLCODE_TOKEN,
264: p_token1_value => SQLCODE,
265: p_token2 => G_SQLERRM_TOKEN,

Line 296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

292: p_api_version,
293: l_api_name,
294: G_PKG_NAME ))
295: THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: END IF;
298:
299: -- Initialize message list if requested
300: IF (FND_API.to_Boolean(p_init_msg_list)) THEN

Line 305: x_return_status := OKL_API.G_RET_STS_SUCCESS;

301: FND_MSG_PUB.initialize;
302: END IF;
303:
304: -- Initialize API status to success
305: x_return_status := OKL_API.G_RET_STS_SUCCESS;
306:
307:
308: /*** Begin API body ****************************************************/
309: --

Line 319: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

315: x_msg_count,
316: x_msg_data,
317: p_tal_id);
318: --
319: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
320: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
321: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
322: RAISE OKL_API.G_EXCEPTION_ERROR;
323: END IF;

Line 320: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

316: x_msg_data,
317: p_tal_id);
318: --
319: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
320: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
321: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
322: RAISE OKL_API.G_EXCEPTION_ERROR;
323: END IF;
324:

Line 321: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

317: p_tal_id);
318: --
319: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
320: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
321: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
322: RAISE OKL_API.G_EXCEPTION_ERROR;
323: END IF;
324:
325: /*** End API body ******************************************************/

Line 322: RAISE OKL_API.G_EXCEPTION_ERROR;

318: --
319: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
320: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
321: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
322: RAISE OKL_API.G_EXCEPTION_ERROR;
323: END IF;
324:
325: /*** End API body ******************************************************/
326:

Line 333: WHEN OKL_API.G_EXCEPTION_ERROR THEN

329: (p_count => x_msg_count,
330: p_data => x_msg_data);
331:
332: EXCEPTION
333: WHEN OKL_API.G_EXCEPTION_ERROR THEN
334: ROLLBACK TO process_split_asset_comp_pub;
335: x_return_status := OKL_API.G_RET_STS_ERROR;
336: FND_MSG_PUB.Count_And_Get
337: (p_count => x_msg_count,

Line 335: x_return_status := OKL_API.G_RET_STS_ERROR;

331:
332: EXCEPTION
333: WHEN OKL_API.G_EXCEPTION_ERROR THEN
334: ROLLBACK TO process_split_asset_comp_pub;
335: x_return_status := OKL_API.G_RET_STS_ERROR;
336: FND_MSG_PUB.Count_And_Get
337: (p_count => x_msg_count,
338: p_data => x_msg_data);
339:

Line 340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

336: FND_MSG_PUB.Count_And_Get
337: (p_count => x_msg_count,
338: p_data => x_msg_data);
339:
340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
341: ROLLBACK TO process_split_asset_comp_pub;
342: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Count_And_Get
344: (p_count => x_msg_count,

Line 342: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

338: p_data => x_msg_data);
339:
340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
341: ROLLBACK TO process_split_asset_comp_pub;
342: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.Count_And_Get
344: (p_count => x_msg_count,
345: p_data => x_msg_data);
346:

Line 349: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

345: p_data => x_msg_data);
346:
347: WHEN OTHERS THEN
348: ROLLBACK TO process_split_asset_comp_pub;
349: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
350: OKL_API.Set_Message(p_app_name => G_APP_NAME,
351: p_msg_name => G_UNEXPECTED_ERROR,
352: p_token1 => G_SQLCODE_TOKEN,
353: p_token1_value => SQLCODE,

Line 350: OKL_API.Set_Message(p_app_name => G_APP_NAME,

346:
347: WHEN OTHERS THEN
348: ROLLBACK TO process_split_asset_comp_pub;
349: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
350: OKL_API.Set_Message(p_app_name => G_APP_NAME,
351: p_msg_name => G_UNEXPECTED_ERROR,
352: p_token1 => G_SQLCODE_TOKEN,
353: p_token1_value => SQLCODE,
354: p_token2 => G_SQLERRM_TOKEN,