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

Line 77: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

73:
74: BEGIN
75:
76: --Check API version, initialize message list and create savepoint.
77: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
78: G_PKG_NAME,
79: p_init_msg_list,
80: l_api_version,
81: p_api_version,

Line 85: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

81: p_api_version,
82: '_PVT',
83: x_return_status);
84:
85: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;

Line 86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

82: '_PVT',
83: x_return_status);
84:
85: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;
90:

Line 87: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

83: x_return_status);
84:
85: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;
90:
91:

Line 88: RAISE OKL_API.G_EXCEPTION_ERROR;

84:
85: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
88: RAISE OKL_API.G_EXCEPTION_ERROR;
89: END IF;
90:
91:
92: -- SECHAWLA Bug # 2667636 : using sysdate as transaction date for currency conversion routines

Line 118: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR l_insurance_amt <= 0 OR l_insurance_amt IS NULL THEN

114: p_cle_id => l_kle_id,
115: x_formula_value => l_insurance_amt,
116: x_return_status => l_return_status);
117:
118: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS OR l_insurance_amt <= 0 OR l_insurance_amt IS NULL THEN
119: l_insurance_amt := l_floor_price;
120: ELSE
121:
122:

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

136: x_currency_conversion_rate => lx_currency_conversion_rate,
137: x_currency_conversion_date => lx_currency_conversion_date,
138: x_converted_amount => lx_converted_amount );
139:
140: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
143: RAISE OKL_API.G_EXCEPTION_ERROR;
144: END IF;

Line 141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

137: x_currency_conversion_date => lx_currency_conversion_date,
138: x_converted_amount => lx_converted_amount );
139:
140: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
143: RAISE OKL_API.G_EXCEPTION_ERROR;
144: END IF;
145:

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

138: x_converted_amount => lx_converted_amount );
139:
140: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
143: RAISE OKL_API.G_EXCEPTION_ERROR;
144: END IF;
145:
146: l_insurance_amt := lx_converted_amount ;

Line 143: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 186: AND l_party_object_tbl(i).pcp_id <> OKL_API.G_MISS_NUM THEN

182: IF l_party_object_tbl.COUNT > 0 THEN
183: i := l_party_object_tbl.FIRST;
184: LOOP
185: IF l_party_object_tbl(i).pcp_id IS NOT NULL
186: AND l_party_object_tbl(i).pcp_id <> OKL_API.G_MISS_NUM THEN
187: l_contact_method_id := l_party_object_tbl(i).pcp_id;
188: EXIT;
189: END IF;
190: EXIT WHEN (i = l_party_object_tbl.LAST);

Line 207: p_init_msg_list => OKL_API.G_FALSE,

203:
204: -- Call TAPI to insert the row
205: OKL_RELOCATE_ASSETS_PUB.insert_relocate_assets(
206: p_api_version => p_api_version,
207: p_init_msg_list => OKL_API.G_FALSE,
208: x_return_status => l_return_status,
209: x_msg_count => x_msg_count,
210: x_msg_data => x_msg_data,
211: p_rasv_rec => lp_rasv_rec,

Line 214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

210: x_msg_data => x_msg_data,
211: p_rasv_rec => lp_rasv_rec,
212: x_rasv_rec => lx_rasv_rec);
213:
214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
217: RAISE OKL_API.G_EXCEPTION_ERROR;
218: END IF;

Line 215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

211: p_rasv_rec => lp_rasv_rec,
212: x_rasv_rec => lx_rasv_rec);
213:
214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
217: RAISE OKL_API.G_EXCEPTION_ERROR;
218: END IF;
219:

Line 216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

212: x_rasv_rec => lx_rasv_rec);
213:
214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
217: RAISE OKL_API.G_EXCEPTION_ERROR;
218: END IF;
219:
220: -- set return variables

Line 217: RAISE OKL_API.G_EXCEPTION_ERROR;

213:
214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
217: RAISE OKL_API.G_EXCEPTION_ERROR;
218: END IF;
219:
220: -- set return variables
221: x_return_status := l_return_status;

Line 225: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

221: x_return_status := l_return_status;
222: x_rasv_rec := lx_rasv_rec;
223:
224: -- end the transaction
225: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
226:
227: EXCEPTION
228: WHEN OKL_API.G_EXCEPTION_ERROR THEN
229: IF okl_get_khr_kle_csr%ISOPEN THEN

Line 228: WHEN OKL_API.G_EXCEPTION_ERROR THEN

224: -- end the transaction
225: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
226:
227: EXCEPTION
228: WHEN OKL_API.G_EXCEPTION_ERROR THEN
229: IF okl_get_khr_kle_csr%ISOPEN THEN
230: CLOSE okl_get_khr_kle_csr;
231: END IF;
232: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 232: x_return_status := OKL_API.HANDLE_EXCEPTIONS

228: WHEN OKL_API.G_EXCEPTION_ERROR THEN
229: IF okl_get_khr_kle_csr%ISOPEN THEN
230: CLOSE okl_get_khr_kle_csr;
231: END IF;
232: x_return_status := OKL_API.HANDLE_EXCEPTIONS
233: (
234: l_api_name,
235: G_PKG_NAME,
236: 'OKL_API.G_RET_STS_ERROR',

Line 236: 'OKL_API.G_RET_STS_ERROR',

232: x_return_status := OKL_API.HANDLE_EXCEPTIONS
233: (
234: l_api_name,
235: G_PKG_NAME,
236: 'OKL_API.G_RET_STS_ERROR',
237: x_msg_count,
238: x_msg_data,
239: '_PVT'
240: );

Line 241: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

237: x_msg_count,
238: x_msg_data,
239: '_PVT'
240: );
241: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
242: IF okl_get_khr_kle_csr%ISOPEN THEN
243: CLOSE okl_get_khr_kle_csr;
244: END IF;
245: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

Line 245: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

241: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
242: IF okl_get_khr_kle_csr%ISOPEN THEN
243: CLOSE okl_get_khr_kle_csr;
244: END IF;
245: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
246: (
247: l_api_name,
248: G_PKG_NAME,
249: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 249: 'OKL_API.G_RET_STS_UNEXP_ERROR',

245: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
246: (
247: l_api_name,
248: G_PKG_NAME,
249: 'OKL_API.G_RET_STS_UNEXP_ERROR',
250: x_msg_count,
251: x_msg_data,
252: '_PVT'
253: );

Line 258: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

254: WHEN OTHERS THEN
255: IF okl_get_khr_kle_csr%ISOPEN THEN
256: CLOSE okl_get_khr_kle_csr;
257: END IF;
258: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
259: (
260: l_api_name,
261: G_PKG_NAME,
262: 'OTHERS',

Line 289: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

285: x_msg_data OUT NOCOPY VARCHAR2,
286: p_rasv_tbl IN rasv_tbl_type,
287: x_rasv_tbl OUT NOCOPY rasv_tbl_type) AS
288:
289: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
290: l_api_name CONSTANT VARCHAR2(30) := 'create_shipping_instr';
291: i NUMBER := 0;
292:
293: BEGIN

Line 295: OKL_API.init_msg_list(p_init_msg_list);

291: i NUMBER := 0;
292:
293: BEGIN
294:
295: OKL_API.init_msg_list(p_init_msg_list);
296: IF (p_rasv_tbl.COUNT > 0) THEN
297: i := p_rasv_tbl.FIRST;
298: LOOP
299:

Line 309: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

305: x_msg_data => x_msg_data,
306: p_rasv_rec => p_rasv_tbl(i),
307: x_rasv_rec => x_rasv_tbl(i));
308:
309: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
310: IF l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
311: l_return_status := x_return_status;
312: END IF;
313: END IF;

Line 310: IF l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

306: p_rasv_rec => p_rasv_tbl(i),
307: x_rasv_rec => x_rasv_tbl(i));
308:
309: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
310: IF l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
311: l_return_status := x_return_status;
312: END IF;
313: END IF;
314: EXIT WHEN (i = p_rasv_tbl.LAST);

Line 321: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

317: x_return_status := l_return_status;
318: END IF;
319:
320: -- end the transaction
321: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
322: EXCEPTION
323: WHEN OKL_API.G_EXCEPTION_ERROR THEN
324: x_return_status := OKL_API.HANDLE_EXCEPTIONS
325: (

Line 323: WHEN OKL_API.G_EXCEPTION_ERROR THEN

319:
320: -- end the transaction
321: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
322: EXCEPTION
323: WHEN OKL_API.G_EXCEPTION_ERROR THEN
324: x_return_status := OKL_API.HANDLE_EXCEPTIONS
325: (
326: l_api_name,
327: G_PKG_NAME,

Line 324: x_return_status := OKL_API.HANDLE_EXCEPTIONS

320: -- end the transaction
321: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
322: EXCEPTION
323: WHEN OKL_API.G_EXCEPTION_ERROR THEN
324: x_return_status := OKL_API.HANDLE_EXCEPTIONS
325: (
326: l_api_name,
327: G_PKG_NAME,
328: 'OKL_API.G_RET_STS_ERROR',

Line 328: 'OKL_API.G_RET_STS_ERROR',

324: x_return_status := OKL_API.HANDLE_EXCEPTIONS
325: (
326: l_api_name,
327: G_PKG_NAME,
328: 'OKL_API.G_RET_STS_ERROR',
329: x_msg_count,
330: x_msg_data,
331: '_PVT'
332: );

Line 333: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

329: x_msg_count,
330: x_msg_data,
331: '_PVT'
332: );
333: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
334: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
335: (
336: l_api_name,
337: G_PKG_NAME,

Line 334: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

330: x_msg_data,
331: '_PVT'
332: );
333: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
334: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
335: (
336: l_api_name,
337: G_PKG_NAME,
338: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 338: 'OKL_API.G_RET_STS_UNEXP_ERROR',

334: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
335: (
336: l_api_name,
337: G_PKG_NAME,
338: 'OKL_API.G_RET_STS_UNEXP_ERROR',
339: x_msg_count,
340: x_msg_data,
341: '_PVT'
342: );

Line 344: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

340: x_msg_data,
341: '_PVT'
342: );
343: WHEN OTHERS THEN
344: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
345: (
346: l_api_name,
347: G_PKG_NAME,
348: 'OTHERS',

Line 384: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

380:
381: BEGIN
382:
383: --Check API version, initialize message list and create savepoint.
384: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
385: G_PKG_NAME,
386: p_init_msg_list,
387: l_api_version,
388: p_api_version,

Line 392: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

388: p_api_version,
389: '_PVT',
390: x_return_status);
391:
392: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
393: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
394: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_ERROR;
396: END IF;

Line 393: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

389: '_PVT',
390: x_return_status);
391:
392: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
393: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
394: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_ERROR;
396: END IF;
397:

Line 394: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

390: x_return_status);
391:
392: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
393: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
394: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_ERROR;
396: END IF;
397:
398: -- If insurance amount is <=0 then error

Line 395: RAISE OKL_API.G_EXCEPTION_ERROR;

391:
392: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
393: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
394: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
395: RAISE OKL_API.G_EXCEPTION_ERROR;
396: END IF;
397:
398: -- If insurance amount is <=0 then error
399: IF lp_rasv_rec.insurance_amount <= 0

Line 401: OR lp_rasv_rec.insurance_amount = OKL_API.G_MISS_NUM THEN

397:
398: -- If insurance amount is <=0 then error
399: IF lp_rasv_rec.insurance_amount <= 0
400: OR lp_rasv_rec.insurance_amount IS NULL
401: OR lp_rasv_rec.insurance_amount = OKL_API.G_MISS_NUM THEN
402: -- Message: You must enter a positive value for PROMPT.
403: OKL_API.set_message(p_app_name => 'OKL',
404: p_msg_name => 'OKL_AM_REQ_FIELD_POS_ERR',
405: p_token1 => 'PROMPT',

Line 403: OKL_API.set_message(p_app_name => 'OKL',

399: IF lp_rasv_rec.insurance_amount <= 0
400: OR lp_rasv_rec.insurance_amount IS NULL
401: OR lp_rasv_rec.insurance_amount = OKL_API.G_MISS_NUM THEN
402: -- Message: You must enter a positive value for PROMPT.
403: OKL_API.set_message(p_app_name => 'OKL',
404: p_msg_name => 'OKL_AM_REQ_FIELD_POS_ERR',
405: p_token1 => 'PROMPT',
406: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_ASSET_VALUE_FOR_INSURANCE'));
407: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 407: RAISE OKL_API.G_EXCEPTION_ERROR;

403: OKL_API.set_message(p_app_name => 'OKL',
404: p_msg_name => 'OKL_AM_REQ_FIELD_POS_ERR',
405: p_token1 => 'PROMPT',
406: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_ASSET_VALUE_FOR_INSURANCE'));
407: RAISE OKL_API.G_EXCEPTION_ERROR;
408: END IF;
409:
410: -- PAC_ID mandatory
411: IF lp_rasv_rec.pac_id IS NULL

Line 412: OR lp_rasv_rec.pac_id = OKL_API.G_MISS_NUM THEN

408: END IF;
409:
410: -- PAC_ID mandatory
411: IF lp_rasv_rec.pac_id IS NULL
412: OR lp_rasv_rec.pac_id = OKL_API.G_MISS_NUM THEN
413: -- Message: You must enter a value for PROMPT.
414: OKL_API.set_message(p_app_name => 'OKL',
415: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
416: p_token1 => 'PROMPT',

Line 414: OKL_API.set_message(p_app_name => 'OKL',

410: -- PAC_ID mandatory
411: IF lp_rasv_rec.pac_id IS NULL
412: OR lp_rasv_rec.pac_id = OKL_API.G_MISS_NUM THEN
413: -- Message: You must enter a value for PROMPT.
414: OKL_API.set_message(p_app_name => 'OKL',
415: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
416: p_token1 => 'PROMPT',
417: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_CONTACT_METHOD'));
418: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 418: RAISE OKL_API.G_EXCEPTION_ERROR;

414: OKL_API.set_message(p_app_name => 'OKL',
415: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
416: p_token1 => 'PROMPT',
417: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_CONTACT_METHOD'));
418: RAISE OKL_API.G_EXCEPTION_ERROR;
419: END IF;
420:
421: -- IST_ID mandatory
422: IF lp_rasv_rec.ist_id IS NULL

Line 423: OR lp_rasv_rec.ist_id = OKL_API.G_MISS_NUM THEN

419: END IF;
420:
421: -- IST_ID mandatory
422: IF lp_rasv_rec.ist_id IS NULL
423: OR lp_rasv_rec.ist_id = OKL_API.G_MISS_NUM THEN
424: -- Message: You must enter a value for PROMPT.
425: OKL_API.set_message(p_app_name => 'OKL',
426: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
427: p_token1 => 'PROMPT',

Line 425: OKL_API.set_message(p_app_name => 'OKL',

421: -- IST_ID mandatory
422: IF lp_rasv_rec.ist_id IS NULL
423: OR lp_rasv_rec.ist_id = OKL_API.G_MISS_NUM THEN
424: -- Message: You must enter a value for PROMPT.
425: OKL_API.set_message(p_app_name => 'OKL',
426: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
427: p_token1 => 'PROMPT',
428: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_SHIP_TO_PARTY'));
429: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 429: RAISE OKL_API.G_EXCEPTION_ERROR;

425: OKL_API.set_message(p_app_name => 'OKL',
426: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
427: p_token1 => 'PROMPT',
428: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_SHIP_TO_PARTY'));
429: RAISE OKL_API.G_EXCEPTION_ERROR;
430: END IF;
431:
432: -- Call TAPI to update the rec
433: OKL_RELOCATE_ASSETS_PUB.update_relocate_assets(

Line 435: p_init_msg_list => OKL_API.G_FALSE,

431:
432: -- Call TAPI to update the rec
433: OKL_RELOCATE_ASSETS_PUB.update_relocate_assets(
434: p_api_version => p_api_version,
435: p_init_msg_list => OKL_API.G_FALSE,
436: x_return_status => l_return_status,
437: x_msg_count => x_msg_count,
438: x_msg_data => x_msg_data,
439: p_rasv_rec => lp_rasv_rec,

Line 442: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

438: x_msg_data => x_msg_data,
439: p_rasv_rec => lp_rasv_rec,
440: x_rasv_rec => lx_rasv_rec);
441:
442: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
443: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
444: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
445: RAISE OKL_API.G_EXCEPTION_ERROR;
446: END IF;

Line 443: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

439: p_rasv_rec => lp_rasv_rec,
440: x_rasv_rec => lx_rasv_rec);
441:
442: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
443: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
444: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
445: RAISE OKL_API.G_EXCEPTION_ERROR;
446: END IF;
447:

Line 444: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

440: x_rasv_rec => lx_rasv_rec);
441:
442: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
443: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
444: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
445: RAISE OKL_API.G_EXCEPTION_ERROR;
446: END IF;
447:
448: -- set return variables

Line 445: RAISE OKL_API.G_EXCEPTION_ERROR;

441:
442: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
443: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
444: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
445: RAISE OKL_API.G_EXCEPTION_ERROR;
446: END IF;
447:
448: -- set return variables
449: x_return_status := l_return_status;

Line 453: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

449: x_return_status := l_return_status;
450: x_rasv_rec := lx_rasv_rec;
451:
452: -- end the transaction
453: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
454:
455: EXCEPTION
456: WHEN OKL_API.G_EXCEPTION_ERROR THEN
457: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 456: WHEN OKL_API.G_EXCEPTION_ERROR THEN

452: -- end the transaction
453: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
454:
455: EXCEPTION
456: WHEN OKL_API.G_EXCEPTION_ERROR THEN
457: x_return_status := OKL_API.HANDLE_EXCEPTIONS
458: (
459: l_api_name,
460: G_PKG_NAME,

Line 457: x_return_status := OKL_API.HANDLE_EXCEPTIONS

453: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
454:
455: EXCEPTION
456: WHEN OKL_API.G_EXCEPTION_ERROR THEN
457: x_return_status := OKL_API.HANDLE_EXCEPTIONS
458: (
459: l_api_name,
460: G_PKG_NAME,
461: 'OKL_API.G_RET_STS_ERROR',

Line 461: 'OKL_API.G_RET_STS_ERROR',

457: x_return_status := OKL_API.HANDLE_EXCEPTIONS
458: (
459: l_api_name,
460: G_PKG_NAME,
461: 'OKL_API.G_RET_STS_ERROR',
462: x_msg_count,
463: x_msg_data,
464: '_PVT'
465: );

Line 466: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

462: x_msg_count,
463: x_msg_data,
464: '_PVT'
465: );
466: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
467: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
468: (
469: l_api_name,
470: G_PKG_NAME,

Line 467: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

463: x_msg_data,
464: '_PVT'
465: );
466: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
467: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
468: (
469: l_api_name,
470: G_PKG_NAME,
471: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 471: 'OKL_API.G_RET_STS_UNEXP_ERROR',

467: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
468: (
469: l_api_name,
470: G_PKG_NAME,
471: 'OKL_API.G_RET_STS_UNEXP_ERROR',
472: x_msg_count,
473: x_msg_data,
474: '_PVT'
475: );

Line 477: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

473: x_msg_data,
474: '_PVT'
475: );
476: WHEN OTHERS THEN
477: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
478: (
479: l_api_name,
480: G_PKG_NAME,
481: 'OTHERS',

Line 507: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

503: x_msg_data OUT NOCOPY VARCHAR2,
504: p_rasv_tbl IN rasv_tbl_type,
505: x_rasv_tbl OUT NOCOPY rasv_tbl_type) AS
506:
507: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
508: l_api_name CONSTANT VARCHAR2(30) := 'create_shipping_instr';
509: i NUMBER := 0;
510:
511: BEGIN

Line 513: OKL_API.init_msg_list(p_init_msg_list);

509: i NUMBER := 0;
510:
511: BEGIN
512:
513: OKL_API.init_msg_list(p_init_msg_list);
514: IF (p_rasv_tbl.COUNT > 0) THEN
515: i := p_rasv_tbl.FIRST;
516: LOOP
517:

Line 527: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

523: x_msg_data => x_msg_data,
524: p_rasv_rec => p_rasv_tbl(i),
525: x_rasv_rec => x_rasv_tbl(i));
526:
527: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
528: IF l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
529: l_return_status := x_return_status;
530: END IF;
531: END IF;

Line 528: IF l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

524: p_rasv_rec => p_rasv_tbl(i),
525: x_rasv_rec => x_rasv_tbl(i));
526:
527: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
528: IF l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
529: l_return_status := x_return_status;
530: END IF;
531: END IF;
532: EXIT WHEN (i = p_rasv_tbl.LAST);

Line 539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

535: x_return_status := l_return_status;
536: END IF;
537:
538: -- end the transaction
539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
540: EXCEPTION
541: WHEN OKL_API.G_EXCEPTION_ERROR THEN
542: x_return_status := OKL_API.HANDLE_EXCEPTIONS
543: (

Line 541: WHEN OKL_API.G_EXCEPTION_ERROR THEN

537:
538: -- end the transaction
539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
540: EXCEPTION
541: WHEN OKL_API.G_EXCEPTION_ERROR THEN
542: x_return_status := OKL_API.HANDLE_EXCEPTIONS
543: (
544: l_api_name,
545: G_PKG_NAME,

Line 542: x_return_status := OKL_API.HANDLE_EXCEPTIONS

538: -- end the transaction
539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
540: EXCEPTION
541: WHEN OKL_API.G_EXCEPTION_ERROR THEN
542: x_return_status := OKL_API.HANDLE_EXCEPTIONS
543: (
544: l_api_name,
545: G_PKG_NAME,
546: 'OKL_API.G_RET_STS_ERROR',

Line 546: 'OKL_API.G_RET_STS_ERROR',

542: x_return_status := OKL_API.HANDLE_EXCEPTIONS
543: (
544: l_api_name,
545: G_PKG_NAME,
546: 'OKL_API.G_RET_STS_ERROR',
547: x_msg_count,
548: x_msg_data,
549: '_PVT'
550: );

Line 551: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

547: x_msg_count,
548: x_msg_data,
549: '_PVT'
550: );
551: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
552: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
553: (
554: l_api_name,
555: G_PKG_NAME,

Line 552: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

548: x_msg_data,
549: '_PVT'
550: );
551: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
552: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
553: (
554: l_api_name,
555: G_PKG_NAME,
556: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 556: 'OKL_API.G_RET_STS_UNEXP_ERROR',

552: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
553: (
554: l_api_name,
555: G_PKG_NAME,
556: 'OKL_API.G_RET_STS_UNEXP_ERROR',
557: x_msg_count,
558: x_msg_data,
559: '_PVT'
560: );

Line 562: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

558: x_msg_data,
559: '_PVT'
560: );
561: WHEN OTHERS THEN
562: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
563: (
564: l_api_name,
565: G_PKG_NAME,
566: 'OTHERS',

Line 592: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

588: x_msg_data OUT NOCOPY VARCHAR2,
589: p_rasv_rec IN rasv_rec_type,
590: x_rasv_rec OUT NOCOPY rasv_rec_type) AS
591:
592: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
593: l_api_name CONSTANT VARCHAR2(30) := 'send_shipping_instr';
594: lp_rasv_rec rasv_rec_type := p_rasv_rec;
595: lx_rasv_rec rasv_rec_type;
596: l_api_version CONSTANT NUMBER := 1;

Line 601: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

597: l_event_name VARCHAR2(200);
598: BEGIN
599:
600: --Check API version, initialize message list and create savepoint.
601: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
602: G_PKG_NAME,
603: p_init_msg_list,
604: l_api_version,
605: p_api_version,

Line 609: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

605: p_api_version,
606: '_PVT',
607: x_return_status);
608:
609: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
610: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
611: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
612: RAISE OKL_API.G_EXCEPTION_ERROR;
613: END IF;

Line 610: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

606: '_PVT',
607: x_return_status);
608:
609: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
610: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
611: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
612: RAISE OKL_API.G_EXCEPTION_ERROR;
613: END IF;
614:

Line 611: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

607: x_return_status);
608:
609: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
610: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
611: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
612: RAISE OKL_API.G_EXCEPTION_ERROR;
613: END IF;
614:
615: -- Set the date_sent if not set

Line 612: RAISE OKL_API.G_EXCEPTION_ERROR;

608:
609: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
610: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
611: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
612: RAISE OKL_API.G_EXCEPTION_ERROR;
613: END IF;
614:
615: -- Set the date_sent if not set
616: IF lp_rasv_rec.date_shipping_instructions_sen IS NULL

Line 617: OR lp_rasv_rec.date_shipping_instructions_sen = OKL_API.G_MISS_DATE THEN

613: END IF;
614:
615: -- Set the date_sent if not set
616: IF lp_rasv_rec.date_shipping_instructions_sen IS NULL
617: OR lp_rasv_rec.date_shipping_instructions_sen = OKL_API.G_MISS_DATE THEN
618:
619: SELECT SYSDATE INTO lp_rasv_rec.date_shipping_instructions_sen FROM DUAL;
620:
621: END IF;

Line 626: p_init_msg_list => OKL_API.G_FALSE,

622:
623: -- Call the update
624: update_shipping_instr(
625: p_api_version => p_api_version,
626: p_init_msg_list => OKL_API.G_FALSE,
627: x_return_status => l_return_status,
628: x_msg_count => x_msg_count,
629: x_msg_data => x_msg_data,
630: p_rasv_rec => lp_rasv_rec,

Line 633: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

629: x_msg_data => x_msg_data,
630: p_rasv_rec => lp_rasv_rec,
631: x_rasv_rec => lx_rasv_rec);
632:
633: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
634: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
635: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
636: RAISE OKL_API.G_EXCEPTION_ERROR;
637: END IF;

Line 634: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

630: p_rasv_rec => lp_rasv_rec,
631: x_rasv_rec => lx_rasv_rec);
632:
633: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
634: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
635: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
636: RAISE OKL_API.G_EXCEPTION_ERROR;
637: END IF;
638:

Line 635: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

631: x_rasv_rec => lx_rasv_rec);
632:
633: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
634: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
635: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
636: RAISE OKL_API.G_EXCEPTION_ERROR;
637: END IF;
638:
639: -- Based on trans option launch the WF

Line 636: RAISE OKL_API.G_EXCEPTION_ERROR;

632:
633: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
634: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
635: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
636: RAISE OKL_API.G_EXCEPTION_ERROR;
637: END IF;
638:
639: -- Based on trans option launch the WF
640: IF lx_rasv_rec.trans_option_accepted_yn = 'Y' THEN

Line 649: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

645: p_wf_process_name => 'NOTIFY_ITD_PROC',
646: x_return_status => l_return_status);
647:
648: -- Raise exception when error
649: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
650: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
651: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_ERROR;
653: END IF;

Line 650: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

646: x_return_status => l_return_status);
647:
648: -- Raise exception when error
649: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
650: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
651: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_ERROR;
653: END IF;
654:

Line 651: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

647:
648: -- Raise exception when error
649: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
650: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
651: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_ERROR;
653: END IF;
654:
655: -- Launch the Notify Internal Transport Department WF

Line 652: RAISE OKL_API.G_EXCEPTION_ERROR;

648: -- Raise exception when error
649: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
650: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
651: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_ERROR;
653: END IF;
654:
655: -- Launch the Notify Internal Transport Department WF
656: OKL_AM_WF.raise_business_event (

Line 668: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

664: p_wf_process_name => 'SHIPPING_INSTRUCTION_PROC',
665: x_return_status => l_return_status);
666:
667: -- Raise exception when error
668: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
670: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
671: RAISE OKL_API.G_EXCEPTION_ERROR;
672: END IF;

Line 669: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

665: x_return_status => l_return_status);
666:
667: -- Raise exception when error
668: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
670: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
671: RAISE OKL_API.G_EXCEPTION_ERROR;
672: END IF;
673:

Line 670: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

666:
667: -- Raise exception when error
668: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
670: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
671: RAISE OKL_API.G_EXCEPTION_ERROR;
672: END IF;
673:
674: -- Launch the Shipping Instruction WF

Line 671: RAISE OKL_API.G_EXCEPTION_ERROR;

667: -- Raise exception when error
668: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
670: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
671: RAISE OKL_API.G_EXCEPTION_ERROR;
672: END IF;
673:
674: -- Launch the Shipping Instruction WF
675: OKL_AM_WF.raise_business_event (

Line 682: OKL_API.set_message(p_app_name => 'OKL',

678: END IF;
679:
680: -- Set message on stack
681: -- Workflow event EVENT_NAME has been requested.
682: OKL_API.set_message(p_app_name => 'OKL',
683: p_msg_name => 'OKL_AM_WF_EVENT_MSG',
684: p_token1 => 'EVENT_NAME',
685: p_token1_value => l_event_name);
686:

Line 691: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

687: x_return_status := l_return_status;
688: x_rasv_rec := lx_rasv_rec;
689:
690: -- end the transaction
691: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
692: EXCEPTION
693: WHEN OKL_API.G_EXCEPTION_ERROR THEN
694: x_return_status := OKL_API.HANDLE_EXCEPTIONS
695: (

Line 693: WHEN OKL_API.G_EXCEPTION_ERROR THEN

689:
690: -- end the transaction
691: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
692: EXCEPTION
693: WHEN OKL_API.G_EXCEPTION_ERROR THEN
694: x_return_status := OKL_API.HANDLE_EXCEPTIONS
695: (
696: l_api_name,
697: G_PKG_NAME,

Line 694: x_return_status := OKL_API.HANDLE_EXCEPTIONS

690: -- end the transaction
691: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
692: EXCEPTION
693: WHEN OKL_API.G_EXCEPTION_ERROR THEN
694: x_return_status := OKL_API.HANDLE_EXCEPTIONS
695: (
696: l_api_name,
697: G_PKG_NAME,
698: 'OKL_API.G_RET_STS_ERROR',

Line 698: 'OKL_API.G_RET_STS_ERROR',

694: x_return_status := OKL_API.HANDLE_EXCEPTIONS
695: (
696: l_api_name,
697: G_PKG_NAME,
698: 'OKL_API.G_RET_STS_ERROR',
699: x_msg_count,
700: x_msg_data,
701: '_PVT'
702: );

Line 703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

699: x_msg_count,
700: x_msg_data,
701: '_PVT'
702: );
703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
704: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
705: (
706: l_api_name,
707: G_PKG_NAME,

Line 704: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

700: x_msg_data,
701: '_PVT'
702: );
703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
704: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
705: (
706: l_api_name,
707: G_PKG_NAME,
708: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 708: 'OKL_API.G_RET_STS_UNEXP_ERROR',

704: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
705: (
706: l_api_name,
707: G_PKG_NAME,
708: 'OKL_API.G_RET_STS_UNEXP_ERROR',
709: x_msg_count,
710: x_msg_data,
711: '_PVT'
712: );

Line 714: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

710: x_msg_data,
711: '_PVT'
712: );
713: WHEN OTHERS THEN
714: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
715: (
716: l_api_name,
717: G_PKG_NAME,
718: 'OTHERS',

Line 744: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

740: x_msg_data OUT NOCOPY VARCHAR2,
741: p_rasv_tbl IN rasv_tbl_type,
742: x_rasv_tbl OUT NOCOPY rasv_tbl_type) AS
743:
744: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
745: l_api_name CONSTANT VARCHAR2(30) := 'send_shipping_instr';
746: i NUMBER := 0;
747:
748: BEGIN

Line 750: OKL_API.init_msg_list(p_init_msg_list);

746: i NUMBER := 0;
747:
748: BEGIN
749:
750: OKL_API.init_msg_list(p_init_msg_list);
751: IF (p_rasv_tbl.COUNT > 0) THEN
752: i := p_rasv_tbl.FIRST;
753: LOOP
754:

Line 764: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

760: x_msg_data => x_msg_data,
761: p_rasv_rec => p_rasv_tbl(i),
762: x_rasv_rec => x_rasv_tbl(i));
763:
764: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
765: IF l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
766: l_return_status := x_return_status;
767: END IF;
768: END IF;

Line 765: IF l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

761: p_rasv_rec => p_rasv_tbl(i),
762: x_rasv_rec => x_rasv_tbl(i));
763:
764: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
765: IF l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
766: l_return_status := x_return_status;
767: END IF;
768: END IF;
769: EXIT WHEN (i = p_rasv_tbl.LAST);

Line 776: WHEN OKL_API.G_EXCEPTION_ERROR THEN

772: x_return_status := l_return_status;
773: END IF;
774:
775: EXCEPTION
776: WHEN OKL_API.G_EXCEPTION_ERROR THEN
777: x_return_status := OKL_API.HANDLE_EXCEPTIONS
778: (
779: l_api_name,
780: G_PKG_NAME,

Line 777: x_return_status := OKL_API.HANDLE_EXCEPTIONS

773: END IF;
774:
775: EXCEPTION
776: WHEN OKL_API.G_EXCEPTION_ERROR THEN
777: x_return_status := OKL_API.HANDLE_EXCEPTIONS
778: (
779: l_api_name,
780: G_PKG_NAME,
781: 'OKL_API.G_RET_STS_ERROR',

Line 781: 'OKL_API.G_RET_STS_ERROR',

777: x_return_status := OKL_API.HANDLE_EXCEPTIONS
778: (
779: l_api_name,
780: G_PKG_NAME,
781: 'OKL_API.G_RET_STS_ERROR',
782: x_msg_count,
783: x_msg_data,
784: '_PVT'
785: );

Line 786: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

782: x_msg_count,
783: x_msg_data,
784: '_PVT'
785: );
786: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
787: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
788: (
789: l_api_name,
790: G_PKG_NAME,

Line 787: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

783: x_msg_data,
784: '_PVT'
785: );
786: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
787: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
788: (
789: l_api_name,
790: G_PKG_NAME,
791: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 791: 'OKL_API.G_RET_STS_UNEXP_ERROR',

787: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
788: (
789: l_api_name,
790: G_PKG_NAME,
791: 'OKL_API.G_RET_STS_UNEXP_ERROR',
792: x_msg_count,
793: x_msg_data,
794: '_PVT'
795: );

Line 797: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

793: x_msg_data,
794: '_PVT'
795: );
796: WHEN OTHERS THEN
797: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
798: (
799: l_api_name,
800: G_PKG_NAME,
801: 'OTHERS',