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

Line 99: l_return_status := okl_api.start_activity(l_api_name,

95: WHERE customer_trx_id = cp_invoice_id;
96: BEGIN
97: l_msg_count := 0;
98: -- Initialize API return status to success
99: l_return_status := okl_api.start_activity(l_api_name,
100: g_pkg_name,
101: l_init_msg_list,
102: l_api_version,
103: l_api_version,

Line 107: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

103: l_api_version,
104: '_PVT',
105: l_return_status);
106:
107: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
108: THEN
109: RAISE okl_api.g_exception_unexpected_error;
110: ELSIF (l_return_status = okl_api.g_ret_sts_error)
111: THEN

Line 109: RAISE okl_api.g_exception_unexpected_error;

105: l_return_status);
106:
107: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
108: THEN
109: RAISE okl_api.g_exception_unexpected_error;
110: ELSIF (l_return_status = okl_api.g_ret_sts_error)
111: THEN
112: RAISE okl_api.g_exception_error;
113: END IF;

Line 110: ELSIF (l_return_status = okl_api.g_ret_sts_error)

106:
107: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
108: THEN
109: RAISE okl_api.g_exception_unexpected_error;
110: ELSIF (l_return_status = okl_api.g_ret_sts_error)
111: THEN
112: RAISE okl_api.g_exception_error;
113: END IF;
114:

Line 112: RAISE okl_api.g_exception_error;

108: THEN
109: RAISE okl_api.g_exception_unexpected_error;
110: ELSIF (l_return_status = okl_api.g_ret_sts_error)
111: THEN
112: RAISE okl_api.g_exception_error;
113: END IF;
114:
115: l_counter := 0;
116: i := l_batch_tbl.FIRST;

Line 125: l_return_status := okl_api.g_ret_sts_error;

121: l_batch_tbl(i).check_number IS NULL AND
122: l_batch_tbl(i).amount IS NULL AND
123: l_batch_tbl.COUNT = 1
124: THEN
125: l_return_status := okl_api.g_ret_sts_error;
126: EXIT;
127: ELSIF l_batch_tbl(i).customer_number IS NULL AND
128: l_batch_tbl(i).check_number IS NULL AND
129: l_batch_tbl(i).amount IS NULL AND

Line 138: x_return_status := okl_api.g_ret_sts_error;

134: l_batch_tbl(i).check_number IS NULL OR
135: l_batch_tbl(i).amount IS NULL
136: THEN
137: -- Message Text: Please enter all mandatory fields
138: x_return_status := okl_api.g_ret_sts_error;
139: okl_api.set_message(p_app_name => 'OKL',
140: p_msg_name => 'OKL_BPD_MISSING_FIELDS');
141: RAISE okl_api.g_exception_error;
142: END IF;

Line 139: okl_api.set_message(p_app_name => 'OKL',

135: l_batch_tbl(i).amount IS NULL
136: THEN
137: -- Message Text: Please enter all mandatory fields
138: x_return_status := okl_api.g_ret_sts_error;
139: okl_api.set_message(p_app_name => 'OKL',
140: p_msg_name => 'OKL_BPD_MISSING_FIELDS');
141: RAISE okl_api.g_exception_error;
142: END IF;
143:

Line 141: RAISE okl_api.g_exception_error;

137: -- Message Text: Please enter all mandatory fields
138: x_return_status := okl_api.g_ret_sts_error;
139: okl_api.set_message(p_app_name => 'OKL',
140: p_msg_name => 'OKL_BPD_MISSING_FIELDS');
141: RAISE okl_api.g_exception_error;
142: END IF;
143:
144: --akrangan cross currency feature modification begin
145: /*

Line 148: IF (nvl(l_batch_tbl(i).khr_id, okl_api.g_miss_num) <>

144: --akrangan cross currency feature modification begin
145: /*
146: --commenting the following code
147: --start code by pgomes on 03/05/2003
148: IF (nvl(l_batch_tbl(i).khr_id, okl_api.g_miss_num) <>
149: okl_api.g_miss_num)
150: THEN
151: OPEN l_khr_curr_csr(l_batch_tbl(i).khr_id);
152:

Line 149: okl_api.g_miss_num)

145: /*
146: --commenting the following code
147: --start code by pgomes on 03/05/2003
148: IF (nvl(l_batch_tbl(i).khr_id, okl_api.g_miss_num) <>
149: okl_api.g_miss_num)
150: THEN
151: OPEN l_khr_curr_csr(l_batch_tbl(i).khr_id);
152:
153: FETCH l_khr_curr_csr

Line 163: RAISE okl_api.g_exception_error;

159: IF (l_temp_currency_code <> l_batch_tbl(i).currency_code)
160: THEN
161: okc_api.set_message(p_app_name => g_app_name,
162: p_msg_name => 'OKL_BPD_BTCH_RCPT_KHR_CURR_ERR');
163: RAISE okl_api.g_exception_error;
164: END IF;
165: ELSIF (nvl(l_batch_tbl(i).consolidated_invoice_id, okl_api.g_miss_num) <>
166: okl_api.g_miss_num)
167: THEN

Line 165: ELSIF (nvl(l_batch_tbl(i).consolidated_invoice_id, okl_api.g_miss_num) <>

161: okc_api.set_message(p_app_name => g_app_name,
162: p_msg_name => 'OKL_BPD_BTCH_RCPT_KHR_CURR_ERR');
163: RAISE okl_api.g_exception_error;
164: END IF;
165: ELSIF (nvl(l_batch_tbl(i).consolidated_invoice_id, okl_api.g_miss_num) <>
166: okl_api.g_miss_num)
167: THEN
168: OPEN l_inv_curr_csr(l_batch_tbl(i).consolidated_invoice_id);
169:

Line 166: okl_api.g_miss_num)

162: p_msg_name => 'OKL_BPD_BTCH_RCPT_KHR_CURR_ERR');
163: RAISE okl_api.g_exception_error;
164: END IF;
165: ELSIF (nvl(l_batch_tbl(i).consolidated_invoice_id, okl_api.g_miss_num) <>
166: okl_api.g_miss_num)
167: THEN
168: OPEN l_inv_curr_csr(l_batch_tbl(i).consolidated_invoice_id);
169:
170: FETCH l_inv_curr_csr

Line 179: RAISE okl_api.g_exception_error;

175: IF (l_temp_currency_code <> l_batch_tbl(i).currency_code)
176: THEN
177: okc_api.set_message(p_app_name => g_app_name,
178: p_msg_name => 'OKL_BPD_BTCH_RCPT_INV_CURR_ERR');
179: RAISE okl_api.g_exception_error;
180: END IF;
181: ELSIF (nvl(l_batch_tbl(i).ar_invoice_id, okl_api.g_miss_num) <>
182: okl_api.g_miss_num)
183: THEN

Line 181: ELSIF (nvl(l_batch_tbl(i).ar_invoice_id, okl_api.g_miss_num) <>

177: okc_api.set_message(p_app_name => g_app_name,
178: p_msg_name => 'OKL_BPD_BTCH_RCPT_INV_CURR_ERR');
179: RAISE okl_api.g_exception_error;
180: END IF;
181: ELSIF (nvl(l_batch_tbl(i).ar_invoice_id, okl_api.g_miss_num) <>
182: okl_api.g_miss_num)
183: THEN
184: OPEN l_ar_inv_curr_csr(l_batch_tbl(i).ar_invoice_id);
185:

Line 182: okl_api.g_miss_num)

178: p_msg_name => 'OKL_BPD_BTCH_RCPT_INV_CURR_ERR');
179: RAISE okl_api.g_exception_error;
180: END IF;
181: ELSIF (nvl(l_batch_tbl(i).ar_invoice_id, okl_api.g_miss_num) <>
182: okl_api.g_miss_num)
183: THEN
184: OPEN l_ar_inv_curr_csr(l_batch_tbl(i).ar_invoice_id);
185:
186: FETCH l_ar_inv_curr_csr

Line 204: x_return_status := okl_api.g_ret_sts_error;

200: --end code by pgomes on 03/05/2003
201: IF l_batch_tbl(i).amount <= 0
202: THEN
203: -- Message Text: The receipt must not have a value of zero
204: x_return_status := okl_api.g_ret_sts_error;
205: okl_api.set_message(p_app_name => g_app_name,
206: p_msg_name => 'OKL_OP_BTCH_RCT_AMT_POS');
207: RAISE okl_api.g_exception_error;
208: END IF;

Line 205: okl_api.set_message(p_app_name => g_app_name,

201: IF l_batch_tbl(i).amount <= 0
202: THEN
203: -- Message Text: The receipt must not have a value of zero
204: x_return_status := okl_api.g_ret_sts_error;
205: okl_api.set_message(p_app_name => g_app_name,
206: p_msg_name => 'OKL_OP_BTCH_RCT_AMT_POS');
207: RAISE okl_api.g_exception_error;
208: END IF;
209:

Line 207: RAISE okl_api.g_exception_error;

203: -- Message Text: The receipt must not have a value of zero
204: x_return_status := okl_api.g_ret_sts_error;
205: okl_api.set_message(p_app_name => g_app_name,
206: p_msg_name => 'OKL_OP_BTCH_RCT_AMT_POS');
207: RAISE okl_api.g_exception_error;
208: END IF;
209:
210: IF l_batch_exists <> 'x'
211: THEN

Line 226: x_return_status := okl_api.g_ret_sts_error;

222:
223: IF l_check_exists IS NOT NULL
224: THEN
225: -- Message Text: Check number already exists for customer.
226: x_return_status := okl_api.g_ret_sts_error;
227: okc_api.set_message(p_app_name => g_app_name,
228: p_msg_name => 'OKL_BPD_CHECK_EXISTS',
229: p_token1 => 'CHECK_NUMBER',
230: p_token1_value => l_check_exists);

Line 231: RAISE okl_api.g_exception_error;

227: okc_api.set_message(p_app_name => g_app_name,
228: p_msg_name => 'OKL_BPD_CHECK_EXISTS',
229: p_token1 => 'CHECK_NUMBER',
230: p_token1_value => l_check_exists);
231: RAISE okl_api.g_exception_error;
232: END IF;
233: END IF;
234:
235: -- count batch lines and add receipts

Line 254: WHEN okl_api.g_exception_error THEN

250: x_return_status := l_return_status;
251: x_msg_count := l_msg_count;
252: x_msg_data := l_msg_data;
253: EXCEPTION
254: WHEN okl_api.g_exception_error THEN
255: x_return_status := okl_api.g_ret_sts_unexp_error;
256: x_msg_count := l_msg_count;
257: x_msg_data := l_msg_data;
258: WHEN okl_api.g_exception_unexpected_error THEN

Line 255: x_return_status := okl_api.g_ret_sts_unexp_error;

251: x_msg_count := l_msg_count;
252: x_msg_data := l_msg_data;
253: EXCEPTION
254: WHEN okl_api.g_exception_error THEN
255: x_return_status := okl_api.g_ret_sts_unexp_error;
256: x_msg_count := l_msg_count;
257: x_msg_data := l_msg_data;
258: WHEN okl_api.g_exception_unexpected_error THEN
259: x_return_status := okl_api.g_ret_sts_error;

Line 258: WHEN okl_api.g_exception_unexpected_error THEN

254: WHEN okl_api.g_exception_error THEN
255: x_return_status := okl_api.g_ret_sts_unexp_error;
256: x_msg_count := l_msg_count;
257: x_msg_data := l_msg_data;
258: WHEN okl_api.g_exception_unexpected_error THEN
259: x_return_status := okl_api.g_ret_sts_error;
260: x_msg_count := l_msg_count;
261: x_msg_data := l_msg_data;
262: WHEN OTHERS THEN

Line 259: x_return_status := okl_api.g_ret_sts_error;

255: x_return_status := okl_api.g_ret_sts_unexp_error;
256: x_msg_count := l_msg_count;
257: x_msg_data := l_msg_data;
258: WHEN okl_api.g_exception_unexpected_error THEN
259: x_return_status := okl_api.g_ret_sts_error;
260: x_msg_count := l_msg_count;
261: x_msg_data := l_msg_data;
262: WHEN OTHERS THEN
263: x_return_status := okl_api.g_ret_sts_unexp_error;

Line 263: x_return_status := okl_api.g_ret_sts_unexp_error;

259: x_return_status := okl_api.g_ret_sts_error;
260: x_msg_count := l_msg_count;
261: x_msg_data := l_msg_data;
262: WHEN OTHERS THEN
263: x_return_status := okl_api.g_ret_sts_unexp_error;
264: okl_api.set_message(p_app_name => g_app_name,
265: p_msg_name => 'OKL_DB_ERROR',
266: p_token1 => 'PROG_NAME',
267: p_token1_value => 'validate_batch_lines',

Line 264: okl_api.set_message(p_app_name => g_app_name,

260: x_msg_count := l_msg_count;
261: x_msg_data := l_msg_data;
262: WHEN OTHERS THEN
263: x_return_status := okl_api.g_ret_sts_unexp_error;
264: okl_api.set_message(p_app_name => g_app_name,
265: p_msg_name => 'OKL_DB_ERROR',
266: p_token1 => 'PROG_NAME',
267: p_token1_value => 'validate_batch_lines',
268: p_token2 => 'SQLCODE',

Line 334: l_return_status := okl_api.start_activity(l_api_name,

330:
331: BEGIN
332: l_msg_count := 0;
333: -- Initialize API return status to success
334: l_return_status := okl_api.start_activity(l_api_name,
335: g_pkg_name,
336: l_init_msg_list,
337: l_api_version,
338: l_api_version,

Line 342: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

338: l_api_version,
339: '_PVT',
340: l_return_status);
341:
342: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
343: THEN
344: RAISE okl_api.g_exception_unexpected_error;
345: ELSIF (l_return_status = okl_api.g_ret_sts_error)
346: THEN

Line 344: RAISE okl_api.g_exception_unexpected_error;

340: l_return_status);
341:
342: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
343: THEN
344: RAISE okl_api.g_exception_unexpected_error;
345: ELSIF (l_return_status = okl_api.g_ret_sts_error)
346: THEN
347: RAISE okl_api.g_exception_error;
348: END IF;

Line 345: ELSIF (l_return_status = okl_api.g_ret_sts_error)

341:
342: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
343: THEN
344: RAISE okl_api.g_exception_unexpected_error;
345: ELSIF (l_return_status = okl_api.g_ret_sts_error)
346: THEN
347: RAISE okl_api.g_exception_error;
348: END IF;
349:

Line 347: RAISE okl_api.g_exception_error;

343: THEN
344: RAISE okl_api.g_exception_unexpected_error;
345: ELSIF (l_return_status = okl_api.g_ret_sts_error)
346: THEN
347: RAISE okl_api.g_exception_error;
348: END IF;
349:
350: --Step 1
351: --Validate the Batch Line

Line 361: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

357: x_return_status => l_return_status,
358: x_msg_count => l_msg_count,
359: x_msg_data => l_msg_data);
360:
361: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
362: THEN
363: RAISE okl_api.g_exception_unexpected_error;
364: ELSIF (l_return_status = okl_api.g_ret_sts_error)
365: THEN

Line 363: RAISE okl_api.g_exception_unexpected_error;

359: x_msg_data => l_msg_data);
360:
361: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
362: THEN
363: RAISE okl_api.g_exception_unexpected_error;
364: ELSIF (l_return_status = okl_api.g_ret_sts_error)
365: THEN
366: RAISE okl_api.g_exception_error;
367: END IF;

Line 364: ELSIF (l_return_status = okl_api.g_ret_sts_error)

360:
361: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
362: THEN
363: RAISE okl_api.g_exception_unexpected_error;
364: ELSIF (l_return_status = okl_api.g_ret_sts_error)
365: THEN
366: RAISE okl_api.g_exception_error;
367: END IF;
368:

Line 366: RAISE okl_api.g_exception_error;

362: THEN
363: RAISE okl_api.g_exception_unexpected_error;
364: ELSIF (l_return_status = okl_api.g_ret_sts_error)
365: THEN
366: RAISE okl_api.g_exception_error;
367: END IF;
368:
369: --Step 2
370: --Prepare Receipt Rec and Table

Line 461: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

457: END;
458: END IF;
459:
460: -- End of wraper code generated automatically by Debug code generator for Okl_Rct_Pub.create_internal_trans
461: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
462: THEN
463: RAISE okl_api.g_exception_unexpected_error;
464: ELSIF (l_return_status = okl_api.g_ret_sts_error)
465: THEN

Line 463: RAISE okl_api.g_exception_unexpected_error;

459:
460: -- End of wraper code generated automatically by Debug code generator for Okl_Rct_Pub.create_internal_trans
461: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
462: THEN
463: RAISE okl_api.g_exception_unexpected_error;
464: ELSIF (l_return_status = okl_api.g_ret_sts_error)
465: THEN
466: RAISE okl_api.g_exception_error;
467: END IF;

Line 464: ELSIF (l_return_status = okl_api.g_ret_sts_error)

460: -- End of wraper code generated automatically by Debug code generator for Okl_Rct_Pub.create_internal_trans
461: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
462: THEN
463: RAISE okl_api.g_exception_unexpected_error;
464: ELSIF (l_return_status = okl_api.g_ret_sts_error)
465: THEN
466: RAISE okl_api.g_exception_error;
467: END IF;
468:

Line 466: RAISE okl_api.g_exception_error;

462: THEN
463: RAISE okl_api.g_exception_unexpected_error;
464: ELSIF (l_return_status = okl_api.g_ret_sts_error)
465: THEN
466: RAISE okl_api.g_exception_error;
467: END IF;
468:
469: -- EXIT WHEN (i = l_batch_tbl.LAST);
470: --i := i + 1;

Line 478: WHEN okl_api.g_exception_error THEN

474: x_return_status := l_return_status;
475: x_msg_count := l_msg_count;
476: x_msg_data := l_msg_data;
477: EXCEPTION
478: WHEN okl_api.g_exception_error THEN
479: x_return_status := okl_api.g_ret_sts_unexp_error;
480: x_msg_count := l_msg_count;
481: x_msg_data := l_msg_data;
482: WHEN okl_api.g_exception_unexpected_error THEN

Line 479: x_return_status := okl_api.g_ret_sts_unexp_error;

475: x_msg_count := l_msg_count;
476: x_msg_data := l_msg_data;
477: EXCEPTION
478: WHEN okl_api.g_exception_error THEN
479: x_return_status := okl_api.g_ret_sts_unexp_error;
480: x_msg_count := l_msg_count;
481: x_msg_data := l_msg_data;
482: WHEN okl_api.g_exception_unexpected_error THEN
483: x_return_status := okl_api.g_ret_sts_error;

Line 482: WHEN okl_api.g_exception_unexpected_error THEN

478: WHEN okl_api.g_exception_error THEN
479: x_return_status := okl_api.g_ret_sts_unexp_error;
480: x_msg_count := l_msg_count;
481: x_msg_data := l_msg_data;
482: WHEN okl_api.g_exception_unexpected_error THEN
483: x_return_status := okl_api.g_ret_sts_error;
484: x_msg_count := l_msg_count;
485: x_msg_data := l_msg_data;
486: WHEN OTHERS THEN

Line 483: x_return_status := okl_api.g_ret_sts_error;

479: x_return_status := okl_api.g_ret_sts_unexp_error;
480: x_msg_count := l_msg_count;
481: x_msg_data := l_msg_data;
482: WHEN okl_api.g_exception_unexpected_error THEN
483: x_return_status := okl_api.g_ret_sts_error;
484: x_msg_count := l_msg_count;
485: x_msg_data := l_msg_data;
486: WHEN OTHERS THEN
487: x_return_status := okl_api.g_ret_sts_unexp_error;

Line 487: x_return_status := okl_api.g_ret_sts_unexp_error;

483: x_return_status := okl_api.g_ret_sts_error;
484: x_msg_count := l_msg_count;
485: x_msg_data := l_msg_data;
486: WHEN OTHERS THEN
487: x_return_status := okl_api.g_ret_sts_unexp_error;
488: okl_api.set_message(p_app_name => 'OKL',
489: p_msg_name => 'OKL_DB_ERROR',
490: p_token1 => 'PROG_NAME',
491: p_token1_value => 'update_batch_lines',

Line 488: okl_api.set_message(p_app_name => 'OKL',

484: x_msg_count := l_msg_count;
485: x_msg_data := l_msg_data;
486: WHEN OTHERS THEN
487: x_return_status := okl_api.g_ret_sts_unexp_error;
488: okl_api.set_message(p_app_name => 'OKL',
489: p_msg_name => 'OKL_DB_ERROR',
490: p_token1 => 'PROG_NAME',
491: p_token1_value => 'update_batch_lines',
492: p_token2 => 'SQLCODE',

Line 553: l_return_status := okl_api.start_activity(l_api_name,

549: AND rownum = 1;
550: BEGIN
551: l_msg_count := 0;
552: -- Initialize API return status to success
553: l_return_status := okl_api.start_activity(l_api_name,
554: g_pkg_name,
555: l_init_msg_list,
556: l_api_version,
557: l_api_version,

Line 561: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

557: l_api_version,
558: '_PVT',
559: l_return_status);
560:
561: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
562: THEN
563: RAISE okl_api.g_exception_unexpected_error;
564: ELSIF (l_return_status = okl_api.g_ret_sts_error)
565: THEN

Line 563: RAISE okl_api.g_exception_unexpected_error;

559: l_return_status);
560:
561: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
562: THEN
563: RAISE okl_api.g_exception_unexpected_error;
564: ELSIF (l_return_status = okl_api.g_ret_sts_error)
565: THEN
566: RAISE okl_api.g_exception_error;
567: END IF;

Line 564: ELSIF (l_return_status = okl_api.g_ret_sts_error)

560:
561: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
562: THEN
563: RAISE okl_api.g_exception_unexpected_error;
564: ELSIF (l_return_status = okl_api.g_ret_sts_error)
565: THEN
566: RAISE okl_api.g_exception_error;
567: END IF;
568:

Line 566: RAISE okl_api.g_exception_error;

562: THEN
563: RAISE okl_api.g_exception_unexpected_error;
564: ELSIF (l_return_status = okl_api.g_ret_sts_error)
565: THEN
566: RAISE okl_api.g_exception_error;
567: END IF;
568:
569: --Step 1
570: --Validate the Batch Line

Line 580: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

576: x_return_status => l_return_status,
577: x_msg_count => l_msg_count,
578: x_msg_data => l_msg_data);
579:
580: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
581: THEN
582: RAISE okl_api.g_exception_unexpected_error;
583: ELSIF (l_return_status = okl_api.g_ret_sts_error)
584: THEN

Line 582: RAISE okl_api.g_exception_unexpected_error;

578: x_msg_data => l_msg_data);
579:
580: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
581: THEN
582: RAISE okl_api.g_exception_unexpected_error;
583: ELSIF (l_return_status = okl_api.g_ret_sts_error)
584: THEN
585: RAISE okl_api.g_exception_error;
586: END IF;

Line 583: ELSIF (l_return_status = okl_api.g_ret_sts_error)

579:
580: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
581: THEN
582: RAISE okl_api.g_exception_unexpected_error;
583: ELSIF (l_return_status = okl_api.g_ret_sts_error)
584: THEN
585: RAISE okl_api.g_exception_error;
586: END IF;
587:

Line 585: RAISE okl_api.g_exception_error;

581: THEN
582: RAISE okl_api.g_exception_unexpected_error;
583: ELSIF (l_return_status = okl_api.g_ret_sts_error)
584: THEN
585: RAISE okl_api.g_exception_error;
586: END IF;
587:
588: --Step 2
589: --Prepare Receipt Rec and Table

Line 677: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

673: END;
674: END IF;
675:
676: -- End of wraper code generated automatically by Debug code generator for Okl_Rct_Pub.create_internal_trans
677: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
678: THEN
679: RAISE okl_api.g_exception_unexpected_error;
680: ELSIF (l_return_status = okl_api.g_ret_sts_error)
681: THEN

Line 679: RAISE okl_api.g_exception_unexpected_error;

675:
676: -- End of wraper code generated automatically by Debug code generator for Okl_Rct_Pub.create_internal_trans
677: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
678: THEN
679: RAISE okl_api.g_exception_unexpected_error;
680: ELSIF (l_return_status = okl_api.g_ret_sts_error)
681: THEN
682: RAISE okl_api.g_exception_error;
683: END IF;

Line 680: ELSIF (l_return_status = okl_api.g_ret_sts_error)

676: -- End of wraper code generated automatically by Debug code generator for Okl_Rct_Pub.create_internal_trans
677: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
678: THEN
679: RAISE okl_api.g_exception_unexpected_error;
680: ELSIF (l_return_status = okl_api.g_ret_sts_error)
681: THEN
682: RAISE okl_api.g_exception_error;
683: END IF;
684:

Line 682: RAISE okl_api.g_exception_error;

678: THEN
679: RAISE okl_api.g_exception_unexpected_error;
680: ELSIF (l_return_status = okl_api.g_ret_sts_error)
681: THEN
682: RAISE okl_api.g_exception_error;
683: END IF;
684:
685: --EXIT WHEN (i = l_batch_tbl.LAST);
686: --i := i + 1;

Line 694: WHEN okl_api.g_exception_error THEN

690: x_return_status := l_return_status;
691: x_msg_count := l_msg_count;
692: x_msg_data := l_msg_data;
693: EXCEPTION
694: WHEN okl_api.g_exception_error THEN
695: x_return_status := okl_api.g_ret_sts_unexp_error;
696: x_msg_count := l_msg_count;
697: x_msg_data := l_msg_data;
698: WHEN okl_api.g_exception_unexpected_error THEN

Line 695: x_return_status := okl_api.g_ret_sts_unexp_error;

691: x_msg_count := l_msg_count;
692: x_msg_data := l_msg_data;
693: EXCEPTION
694: WHEN okl_api.g_exception_error THEN
695: x_return_status := okl_api.g_ret_sts_unexp_error;
696: x_msg_count := l_msg_count;
697: x_msg_data := l_msg_data;
698: WHEN okl_api.g_exception_unexpected_error THEN
699: x_return_status := okl_api.g_ret_sts_error;

Line 698: WHEN okl_api.g_exception_unexpected_error THEN

694: WHEN okl_api.g_exception_error THEN
695: x_return_status := okl_api.g_ret_sts_unexp_error;
696: x_msg_count := l_msg_count;
697: x_msg_data := l_msg_data;
698: WHEN okl_api.g_exception_unexpected_error THEN
699: x_return_status := okl_api.g_ret_sts_error;
700: x_msg_count := l_msg_count;
701: x_msg_data := l_msg_data;
702: WHEN OTHERS THEN

Line 699: x_return_status := okl_api.g_ret_sts_error;

695: x_return_status := okl_api.g_ret_sts_unexp_error;
696: x_msg_count := l_msg_count;
697: x_msg_data := l_msg_data;
698: WHEN okl_api.g_exception_unexpected_error THEN
699: x_return_status := okl_api.g_ret_sts_error;
700: x_msg_count := l_msg_count;
701: x_msg_data := l_msg_data;
702: WHEN OTHERS THEN
703: x_return_status := okl_api.g_ret_sts_unexp_error;

Line 703: x_return_status := okl_api.g_ret_sts_unexp_error;

699: x_return_status := okl_api.g_ret_sts_error;
700: x_msg_count := l_msg_count;
701: x_msg_data := l_msg_data;
702: WHEN OTHERS THEN
703: x_return_status := okl_api.g_ret_sts_unexp_error;
704: okl_api.set_message(p_app_name => 'OKL',
705: p_msg_name => 'OKL_DB_ERROR',
706: p_token1 => 'PROG_NAME',
707: p_token1_value => 'insert_batch_lines',

Line 704: okl_api.set_message(p_app_name => 'OKL',

700: x_msg_count := l_msg_count;
701: x_msg_data := l_msg_data;
702: WHEN OTHERS THEN
703: x_return_status := okl_api.g_ret_sts_unexp_error;
704: okl_api.set_message(p_app_name => 'OKL',
705: p_msg_name => 'OKL_DB_ERROR',
706: p_token1 => 'PROG_NAME',
707: p_token1_value => 'insert_batch_lines',
708: p_token2 => 'SQLCODE',

Line 772: l_return_status := okl_api.start_activity(l_api_name,

768: l_upd_batch_tbl okl_btch_dtls_tbl_type;
769: BEGIN
770: l_msg_count := 0;
771: -- Initialize API return status to success
772: l_return_status := okl_api.start_activity(l_api_name,
773: g_pkg_name,
774: l_init_msg_list,
775: l_api_version,
776: l_api_version,

Line 780: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

776: l_api_version,
777: '_PVT',
778: l_return_status);
779:
780: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
781: THEN
782: RAISE okl_api.g_exception_unexpected_error;
783: ELSIF (l_return_status = okl_api.g_ret_sts_error)
784: THEN

Line 782: RAISE okl_api.g_exception_unexpected_error;

778: l_return_status);
779:
780: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
781: THEN
782: RAISE okl_api.g_exception_unexpected_error;
783: ELSIF (l_return_status = okl_api.g_ret_sts_error)
784: THEN
785: RAISE okl_api.g_exception_error;
786: END IF;

Line 783: ELSIF (l_return_status = okl_api.g_ret_sts_error)

779:
780: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
781: THEN
782: RAISE okl_api.g_exception_unexpected_error;
783: ELSIF (l_return_status = okl_api.g_ret_sts_error)
784: THEN
785: RAISE okl_api.g_exception_error;
786: END IF;
787:

Line 785: RAISE okl_api.g_exception_error;

781: THEN
782: RAISE okl_api.g_exception_unexpected_error;
783: ELSIF (l_return_status = okl_api.g_ret_sts_error)
784: THEN
785: RAISE okl_api.g_exception_error;
786: END IF;
787:
788: --Step 1
789: --process the existing receipt rows in the batch

Line 841: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

837: x_return_status => l_return_status,
838: x_msg_count => l_msg_count,
839: x_msg_data => l_msg_data);
840:
841: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
842: THEN
843: RAISE okl_api.g_exception_unexpected_error;
844: ELSIF (l_return_status = okl_api.g_ret_sts_error)
845: THEN

Line 843: RAISE okl_api.g_exception_unexpected_error;

839: x_msg_data => l_msg_data);
840:
841: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
842: THEN
843: RAISE okl_api.g_exception_unexpected_error;
844: ELSIF (l_return_status = okl_api.g_ret_sts_error)
845: THEN
846: RAISE okl_api.g_exception_error;
847: END IF;

Line 844: ELSIF (l_return_status = okl_api.g_ret_sts_error)

840:
841: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
842: THEN
843: RAISE okl_api.g_exception_unexpected_error;
844: ELSIF (l_return_status = okl_api.g_ret_sts_error)
845: THEN
846: RAISE okl_api.g_exception_error;
847: END IF;
848: END IF;

Line 846: RAISE okl_api.g_exception_error;

842: THEN
843: RAISE okl_api.g_exception_unexpected_error;
844: ELSIF (l_return_status = okl_api.g_ret_sts_error)
845: THEN
846: RAISE okl_api.g_exception_error;
847: END IF;
848: END IF;
849:
850: --Step 3

Line 864: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

860: x_return_status => l_return_status,
861: x_msg_count => l_msg_count,
862: x_msg_data => l_msg_data);
863:
864: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
865: THEN
866: RAISE okl_api.g_exception_unexpected_error;
867: ELSIF (l_return_status = okl_api.g_ret_sts_error)
868: THEN

Line 866: RAISE okl_api.g_exception_unexpected_error;

862: x_msg_data => l_msg_data);
863:
864: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
865: THEN
866: RAISE okl_api.g_exception_unexpected_error;
867: ELSIF (l_return_status = okl_api.g_ret_sts_error)
868: THEN
869: RAISE okl_api.g_exception_error;
870: END IF;

Line 867: ELSIF (l_return_status = okl_api.g_ret_sts_error)

863:
864: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
865: THEN
866: RAISE okl_api.g_exception_unexpected_error;
867: ELSIF (l_return_status = okl_api.g_ret_sts_error)
868: THEN
869: RAISE okl_api.g_exception_error;
870: END IF;
871: END IF;

Line 869: RAISE okl_api.g_exception_error;

865: THEN
866: RAISE okl_api.g_exception_unexpected_error;
867: ELSIF (l_return_status = okl_api.g_ret_sts_error)
868: THEN
869: RAISE okl_api.g_exception_error;
870: END IF;
871: END IF;
872:
873: --set output variables

Line 878: WHEN okl_api.g_exception_error THEN

874: x_return_status := l_return_status;
875: x_msg_count := l_msg_count;
876: x_msg_data := l_msg_data;
877: EXCEPTION
878: WHEN okl_api.g_exception_error THEN
879: x_return_status := okl_api.g_ret_sts_unexp_error;
880: x_msg_count := l_msg_count;
881: x_msg_data := l_msg_data;
882: WHEN okl_api.g_exception_unexpected_error THEN

Line 879: x_return_status := okl_api.g_ret_sts_unexp_error;

875: x_msg_count := l_msg_count;
876: x_msg_data := l_msg_data;
877: EXCEPTION
878: WHEN okl_api.g_exception_error THEN
879: x_return_status := okl_api.g_ret_sts_unexp_error;
880: x_msg_count := l_msg_count;
881: x_msg_data := l_msg_data;
882: WHEN okl_api.g_exception_unexpected_error THEN
883: x_return_status := okl_api.g_ret_sts_error;

Line 882: WHEN okl_api.g_exception_unexpected_error THEN

878: WHEN okl_api.g_exception_error THEN
879: x_return_status := okl_api.g_ret_sts_unexp_error;
880: x_msg_count := l_msg_count;
881: x_msg_data := l_msg_data;
882: WHEN okl_api.g_exception_unexpected_error THEN
883: x_return_status := okl_api.g_ret_sts_error;
884: x_msg_count := l_msg_count;
885: x_msg_data := l_msg_data;
886: WHEN OTHERS THEN

Line 883: x_return_status := okl_api.g_ret_sts_error;

879: x_return_status := okl_api.g_ret_sts_unexp_error;
880: x_msg_count := l_msg_count;
881: x_msg_data := l_msg_data;
882: WHEN okl_api.g_exception_unexpected_error THEN
883: x_return_status := okl_api.g_ret_sts_error;
884: x_msg_count := l_msg_count;
885: x_msg_data := l_msg_data;
886: WHEN OTHERS THEN
887: x_return_status := okl_api.g_ret_sts_unexp_error;

Line 887: x_return_status := okl_api.g_ret_sts_unexp_error;

883: x_return_status := okl_api.g_ret_sts_error;
884: x_msg_count := l_msg_count;
885: x_msg_data := l_msg_data;
886: WHEN OTHERS THEN
887: x_return_status := okl_api.g_ret_sts_unexp_error;
888: okl_api.set_message(p_app_name => 'OKL',
889: p_msg_name => 'OKL_DB_ERROR',
890: p_token1 => 'PROG_NAME',
891: p_token1_value => 'process_batch_lines',

Line 888: okl_api.set_message(p_app_name => 'OKL',

884: x_msg_count := l_msg_count;
885: x_msg_data := l_msg_data;
886: WHEN OTHERS THEN
887: x_return_status := okl_api.g_ret_sts_unexp_error;
888: okl_api.set_message(p_app_name => 'OKL',
889: p_msg_name => 'OKL_DB_ERROR',
890: p_token1 => 'PROG_NAME',
891: p_token1_value => 'process_batch_lines',
892: p_token2 => 'SQLCODE',

Line 1052: l_return_status := okl_api.start_activity(l_api_name,

1048: SELECT invoice_currency_code
1049: FROM ra_customer_trx_all
1050: WHERE customer_trx_id = cp_invoice_id;
1051: BEGIN
1052: l_return_status := okl_api.start_activity(l_api_name,
1053: g_pkg_name,
1054: p_init_msg_list,
1055: l_api_version,
1056: p_api_version,

Line 1060: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

1056: p_api_version,
1057: '_PVT',
1058: l_return_status);
1059:
1060: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
1061: THEN
1062: RAISE okl_api.g_exception_unexpected_error;
1063: ELSIF (l_return_status = okl_api.g_ret_sts_error)
1064: THEN

Line 1062: RAISE okl_api.g_exception_unexpected_error;

1058: l_return_status);
1059:
1060: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
1061: THEN
1062: RAISE okl_api.g_exception_unexpected_error;
1063: ELSIF (l_return_status = okl_api.g_ret_sts_error)
1064: THEN
1065: RAISE okl_api.g_exception_error;
1066: END IF;

Line 1063: ELSIF (l_return_status = okl_api.g_ret_sts_error)

1059:
1060: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
1061: THEN
1062: RAISE okl_api.g_exception_unexpected_error;
1063: ELSIF (l_return_status = okl_api.g_ret_sts_error)
1064: THEN
1065: RAISE okl_api.g_exception_error;
1066: END IF;
1067:

Line 1065: RAISE okl_api.g_exception_error;

1061: THEN
1062: RAISE okl_api.g_exception_unexpected_error;
1063: ELSIF (l_return_status = okl_api.g_ret_sts_error)
1064: THEN
1065: RAISE okl_api.g_exception_error;
1066: END IF;
1067:
1068: l_btch_tbl := p_btch_tbl;
1069: l_submitted_batch_total := 0;

Line 1089: IF (l_return_status = okl_api.g_ret_sts_unexp_error)

1085: p_batch_exists => l_batch_exists,
1086: x_return_status => l_return_status,
1087: x_msg_count => x_msg_count,
1088: x_msg_data => x_msg_data);
1089: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
1090: THEN
1091: RAISE okl_api.g_exception_unexpected_error;
1092: ELSIF (l_return_status = okl_api.g_ret_sts_error)
1093: THEN

Line 1091: RAISE okl_api.g_exception_unexpected_error;

1087: x_msg_count => x_msg_count,
1088: x_msg_data => x_msg_data);
1089: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
1090: THEN
1091: RAISE okl_api.g_exception_unexpected_error;
1092: ELSIF (l_return_status = okl_api.g_ret_sts_error)
1093: THEN
1094: RAISE okl_api.g_exception_error;
1095: END IF;

Line 1092: ELSIF (l_return_status = okl_api.g_ret_sts_error)

1088: x_msg_data => x_msg_data);
1089: IF (l_return_status = okl_api.g_ret_sts_unexp_error)
1090: THEN
1091: RAISE okl_api.g_exception_unexpected_error;
1092: ELSIF (l_return_status = okl_api.g_ret_sts_error)
1093: THEN
1094: RAISE okl_api.g_exception_error;
1095: END IF;
1096:

Line 1094: RAISE okl_api.g_exception_error;

1090: THEN
1091: RAISE okl_api.g_exception_unexpected_error;
1092: ELSIF (l_return_status = okl_api.g_ret_sts_error)
1093: THEN
1094: RAISE okl_api.g_exception_error;
1095: END IF;
1096:
1097: okl_api.end_activity(x_msg_count, x_msg_data);
1098: -- NEED TO HANDLE ERRORS AT THIS POINT --

Line 1097: okl_api.end_activity(x_msg_count, x_msg_data);

1093: THEN
1094: RAISE okl_api.g_exception_error;
1095: END IF;
1096:
1097: okl_api.end_activity(x_msg_count, x_msg_data);
1098: -- NEED TO HANDLE ERRORS AT THIS POINT --
1099: EXCEPTION
1100: WHEN g_exception_halt_validation THEN
1101: x_return_status := okl_api.g_ret_sts_error;

Line 1101: x_return_status := okl_api.g_ret_sts_error;

1097: okl_api.end_activity(x_msg_count, x_msg_data);
1098: -- NEED TO HANDLE ERRORS AT THIS POINT --
1099: EXCEPTION
1100: WHEN g_exception_halt_validation THEN
1101: x_return_status := okl_api.g_ret_sts_error;
1102: x_return_status := okl_api.handle_exceptions(l_api_name,
1103: g_pkg_name,
1104: 'OKL_API.G_RET_STS_ERROR',
1105: x_msg_count,

Line 1102: x_return_status := okl_api.handle_exceptions(l_api_name,

1098: -- NEED TO HANDLE ERRORS AT THIS POINT --
1099: EXCEPTION
1100: WHEN g_exception_halt_validation THEN
1101: x_return_status := okl_api.g_ret_sts_error;
1102: x_return_status := okl_api.handle_exceptions(l_api_name,
1103: g_pkg_name,
1104: 'OKL_API.G_RET_STS_ERROR',
1105: x_msg_count,
1106: x_msg_data,

Line 1104: 'OKL_API.G_RET_STS_ERROR',

1100: WHEN g_exception_halt_validation THEN
1101: x_return_status := okl_api.g_ret_sts_error;
1102: x_return_status := okl_api.handle_exceptions(l_api_name,
1103: g_pkg_name,
1104: 'OKL_API.G_RET_STS_ERROR',
1105: x_msg_count,
1106: x_msg_data,
1107: '_PVT');
1108: WHEN okl_api.g_exception_error THEN

Line 1108: WHEN okl_api.g_exception_error THEN

1104: 'OKL_API.G_RET_STS_ERROR',
1105: x_msg_count,
1106: x_msg_data,
1107: '_PVT');
1108: WHEN okl_api.g_exception_error THEN
1109: x_return_status := okl_api.handle_exceptions(l_api_name,
1110: g_pkg_name,
1111: 'OKL_API.G_RET_STS_ERROR',
1112: x_msg_count,

Line 1109: x_return_status := okl_api.handle_exceptions(l_api_name,

1105: x_msg_count,
1106: x_msg_data,
1107: '_PVT');
1108: WHEN okl_api.g_exception_error THEN
1109: x_return_status := okl_api.handle_exceptions(l_api_name,
1110: g_pkg_name,
1111: 'OKL_API.G_RET_STS_ERROR',
1112: x_msg_count,
1113: x_msg_data,

Line 1111: 'OKL_API.G_RET_STS_ERROR',

1107: '_PVT');
1108: WHEN okl_api.g_exception_error THEN
1109: x_return_status := okl_api.handle_exceptions(l_api_name,
1110: g_pkg_name,
1111: 'OKL_API.G_RET_STS_ERROR',
1112: x_msg_count,
1113: x_msg_data,
1114: '_PVT');
1115: WHEN okl_api.g_exception_unexpected_error THEN

Line 1115: WHEN okl_api.g_exception_unexpected_error THEN

1111: 'OKL_API.G_RET_STS_ERROR',
1112: x_msg_count,
1113: x_msg_data,
1114: '_PVT');
1115: WHEN okl_api.g_exception_unexpected_error THEN
1116: x_return_status := okl_api.handle_exceptions(l_api_name,
1117: g_pkg_name,
1118: 'OKL_API.G_RET_STS_ERROR',
1119: x_msg_count,

Line 1116: x_return_status := okl_api.handle_exceptions(l_api_name,

1112: x_msg_count,
1113: x_msg_data,
1114: '_PVT');
1115: WHEN okl_api.g_exception_unexpected_error THEN
1116: x_return_status := okl_api.handle_exceptions(l_api_name,
1117: g_pkg_name,
1118: 'OKL_API.G_RET_STS_ERROR',
1119: x_msg_count,
1120: x_msg_data,

Line 1118: 'OKL_API.G_RET_STS_ERROR',

1114: '_PVT');
1115: WHEN okl_api.g_exception_unexpected_error THEN
1116: x_return_status := okl_api.handle_exceptions(l_api_name,
1117: g_pkg_name,
1118: 'OKL_API.G_RET_STS_ERROR',
1119: x_msg_count,
1120: x_msg_data,
1121: '_PVT');
1122: WHEN OTHERS THEN

Line 1123: x_return_status := okl_api.g_ret_sts_unexp_error;

1119: x_msg_count,
1120: x_msg_data,
1121: '_PVT');
1122: WHEN OTHERS THEN
1123: x_return_status := okl_api.g_ret_sts_unexp_error;
1124: okl_api.set_message(p_app_name => g_app_name,
1125: p_msg_name => g_unexpected_error,
1126: p_token1 => g_sqlcode_token,
1127: p_token1_value => SQLCODE,

Line 1124: okl_api.set_message(p_app_name => g_app_name,

1120: x_msg_data,
1121: '_PVT');
1122: WHEN OTHERS THEN
1123: x_return_status := okl_api.g_ret_sts_unexp_error;
1124: okl_api.set_message(p_app_name => g_app_name,
1125: p_msg_name => g_unexpected_error,
1126: p_token1 => g_sqlcode_token,
1127: p_token1_value => SQLCODE,
1128: p_token2 => g_sqlerrm_token,