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

Line 11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

7: IS_DEBUG_PROCEDURE_ON BOOLEAN;
8: G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
9:
10: G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
12: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
13: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
14: --start:| 01-MAY-2007 cklee -- Disbursement changes for R12B, bug fixed: |
15: G_ACC_SYS_OPTION VARCHAR2(4);

Line 12: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

8: G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
9:
10: G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
12: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
13: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
14: --start:| 01-MAY-2007 cklee -- Disbursement changes for R12B, bug fixed: |
15: G_ACC_SYS_OPTION VARCHAR2(4);
16: --end:| 01-MAY-2007 cklee -- Disbursement changes for R12B, bug fixed: |

Line 13: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

9:
10: G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
11: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
12: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
13: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
14: --start:| 01-MAY-2007 cklee -- Disbursement changes for R12B, bug fixed: |
15: G_ACC_SYS_OPTION VARCHAR2(4);
16: --end:| 01-MAY-2007 cklee -- Disbursement changes for R12B, bug fixed: |
17:

Line 131: WHEN OKL_API.G_EXCEPTION_ERROR THEN

127: RETURN lx_disb_rules;
128:
129: EXCEPTION
130:
131: WHEN OKL_API.G_EXCEPTION_ERROR THEN
132:
133: x_return_status := G_RET_STS_ERROR;
134: RETURN lx_disb_rules;
135:

Line 136: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

132:
133: x_return_status := G_RET_STS_ERROR;
134: RETURN lx_disb_rules;
135:
136: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
137:
138: x_return_status := G_RET_STS_UNEXP_ERROR;
139: RETURN lx_disb_rules;
140:

Line 143: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

139: RETURN lx_disb_rules;
140:
141: WHEN OTHERS THEN
142:
143: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
144: p_msg_name => G_DB_ERROR,
145: p_token1 => G_PROG_NAME_TOKEN,
146: p_token1_value => l_prog_name,
147: p_token2 => G_SQLCODE_TOKEN,

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

187: -- Declare variables required by APIs
188: ------------------------------------------------------------
189: l_api_version CONSTANT NUMBER := 1;
190: l_api_name CONSTANT VARCHAR2(30) := 'handle_next_invoice_seq';
191: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
192: --
193: l_inv_seq_start okl_disb_rule_vendor_sites.invoice_seq_start%type;
194: l_inv_seq_end okl_disb_rule_vendor_sites.invoice_seq_end%type;
195: l_next_inv_seq okl_disb_rule_vendor_sites.next_inv_seq%type;

Line 209: x_return_status := OKL_API.G_RET_STS_SUCCESS;

205: BEGIN
206: ------------------------------------------------------------
207: -- Start processing
208: ------------------------------------------------------------
209: x_return_status := OKL_API.G_RET_STS_SUCCESS;
210:
211: l_return_status := OKL_API.START_ACTIVITY(
212: p_api_name => l_api_name,
213: p_pkg_name => g_pkg_name,

Line 211: l_return_status := OKL_API.START_ACTIVITY(

207: -- Start processing
208: ------------------------------------------------------------
209: x_return_status := OKL_API.G_RET_STS_SUCCESS;
210:
211: l_return_status := OKL_API.START_ACTIVITY(
212: p_api_name => l_api_name,
213: p_pkg_name => g_pkg_name,
214: p_init_msg_list => p_init_msg_list,
215: l_api_version => l_api_version,

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

216: p_api_version => p_api_version,
217: p_api_type => '_PVT',
218: x_return_status => l_return_status);
219:
220: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;

Line 221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

217: p_api_type => '_PVT',
218: x_return_status => l_return_status);
219:
220: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;
225:

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

218: x_return_status => l_return_status);
219:
220: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;
225:
226: x_next_inv_seq := NULL; -- initial to null

Line 223: RAISE OKL_API.G_EXCEPTION_ERROR;

219:
220: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
222: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
223: RAISE OKL_API.G_EXCEPTION_ERROR;
224: END IF;
225:
226: x_next_inv_seq := NULL; -- initial to null
227:

Line 340: Okl_Api.END_ACTIVITY (

336: ------------------------------------------------------------
337: -- End processing
338: ------------------------------------------------------------
339:
340: Okl_Api.END_ACTIVITY (
341: x_msg_count => x_msg_count,
342: x_msg_data => x_msg_data);
343:
344:

Line 349: WHEN OKL_API.G_EXCEPTION_ERROR THEN

345: EXCEPTION
346: ------------------------------------------------------------
347: -- Exception handling
348: ------------------------------------------------------------
349: WHEN OKL_API.G_EXCEPTION_ERROR THEN
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);
351: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
352: p_api_name => l_api_name,
353: p_pkg_name => G_PKG_NAME,

Line 351: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

347: -- Exception handling
348: ------------------------------------------------------------
349: WHEN OKL_API.G_EXCEPTION_ERROR THEN
350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);
351: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
352: p_api_name => l_api_name,
353: p_pkg_name => G_PKG_NAME,
354: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
355: x_msg_count => x_msg_count,

Line 354: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

350: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);
351: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
352: p_api_name => l_api_name,
353: p_pkg_name => G_PKG_NAME,
354: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_data,
357: p_api_type => '_PVT');
358:

Line 359: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

355: x_msg_count => x_msg_count,
356: x_msg_data => x_msg_data,
357: p_api_type => '_PVT');
358:
359: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
360: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);
361: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
362: p_api_name => l_api_name,
363: p_pkg_name => G_PKG_NAME,

Line 361: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

357: p_api_type => '_PVT');
358:
359: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
360: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);
361: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
362: p_api_name => l_api_name,
363: p_pkg_name => G_PKG_NAME,
364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
365: x_msg_count => x_msg_count,

Line 364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

360: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);
361: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
362: p_api_name => l_api_name,
363: p_pkg_name => G_PKG_NAME,
364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
365: x_msg_count => x_msg_count,
366: x_msg_data => x_msg_data,
367: p_api_type => '_PVT');
368:

Line 371: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

367: p_api_type => '_PVT');
368:
369: WHEN OTHERS THEN
370: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'handle_next_invoice_seq*=> ERROR: '||SQLERRM);
371: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
372: p_api_name => l_api_name,
373: p_pkg_name => G_PKG_NAME,
374: p_exc_name => 'OTHERS',
375: x_msg_count => x_msg_count,

Line 421: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

417: RETURN l_months;
418:
419: ELSE
420:
421: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
422: p_msg_name => 'OKL_INVALID_FREQUENCY_CODE',
423: p_token1 => 'FRQ_CODE',
424: p_token1_value => p_frequency);
425:

Line 426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

422: p_msg_name => 'OKL_INVALID_FREQUENCY_CODE',
423: p_token1 => 'FRQ_CODE',
424: p_token1_value => p_frequency);
425:
426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
427:
428: END IF;
429:
430: EXCEPTION

Line 432: WHEN OKL_API.G_EXCEPTION_ERROR THEN

428: END IF;
429:
430: EXCEPTION
431:
432: WHEN OKL_API.G_EXCEPTION_ERROR THEN
433:
434: x_return_status := G_RET_STS_ERROR;
435:
436: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 436: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

432: WHEN OKL_API.G_EXCEPTION_ERROR THEN
433:
434: x_return_status := G_RET_STS_ERROR;
435:
436: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
437:
438: x_return_status := G_RET_STS_UNEXP_ERROR;
439:
440: WHEN OTHERS THEN

Line 442: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

438: x_return_status := G_RET_STS_UNEXP_ERROR;
439:
440: WHEN OTHERS THEN
441:
442: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
443: p_msg_name => G_DB_ERROR,
444: p_token1 => G_PROG_NAME_TOKEN,
445: p_token1_value => l_prog_name,
446: p_token2 => G_SQLCODE_TOKEN,

Line 487: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR OR lx_return_status = OKL_API.G_RET_STS_ERROR THEN

483:
484: l_months_factor := get_months_factor( p_frequency => p_frequency,
485: x_return_status => lx_return_status);
486:
487: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR OR lx_return_status = OKL_API.G_RET_STS_ERROR THEN
488: l_months_factor := 1; -- Default monthly ??
489: END IF;
490:
491: /* -- OKL invoice dates can be earlier to current date (ssiruvol)

Line 591: Okl_Api.Set_Message(p_app_name => OKL_API.G_APP_NAME,

587:
588: EXCEPTION
589: WHEN OTHERS THEN
590: -- store SQL error message on message stack for caller
591: Okl_Api.Set_Message(p_app_name => OKL_API.G_APP_NAME,
592: p_msg_name => 'OKL_UNEXPECTED_ERROR',
593: p_token1 => 'OKL_SQLCODE',
594: p_token1_value => SQLCODE,
595: p_token2 => 'OKL_SQLERRM',

Line 677: Okl_Api.Set_Message(p_app_name => OKL_API.G_APP_NAME,

673: EXCEPTION
674: WHEN OTHERS THEN
675:
676: -- store SQL error message on message stack for caller
677: Okl_Api.Set_Message(p_app_name => OKL_API.G_APP_NAME,
678: p_msg_name => 'OKL_UNEXPECTED_ERROR',
679: p_token1 => 'OKL_SQLCODE',
680: p_token1_value => SQLCODE,
681: p_token2 => 'OKL_SQLERRM',

Line 755: Okl_Api.Set_Message(p_app_name => OKL_API.G_APP_NAME,

751: EXCEPTION
752: WHEN OTHERS THEN
753:
754: -- store SQL error message on message stack for caller
755: Okl_Api.Set_Message(p_app_name => OKL_API.G_APP_NAME,
756: p_msg_name => 'OKL_UNEXPECTED_ERROR',
757: p_token1 => 'OKL_SQLCODE',
758: p_token1_value => SQLCODE,
759: p_token2 => 'OKL_SQLERRM',

Line 825: Okl_Api.Set_Message(p_app_name => OKL_API.G_APP_NAME,

821: EXCEPTION
822: WHEN OTHERS THEN
823:
824: -- store SQL error message on message stack for caller
825: Okl_Api.Set_Message(p_app_name => OKL_API.G_APP_NAME,
826: p_msg_name => 'OKL_UNEXPECTED_ERROR',
827: p_token1 => 'OKL_SQLCODE',
828: p_token1_value => SQLCODE,
829: p_token2 => 'OKL_SQLERRM',

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

865: -- Declare variables required by APIs
866: ------------------------------------------------------------
867: l_api_version CONSTANT NUMBER := 1;
868: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_CONSOLIDATION_RULES';
869: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
870: ------------------------------------------------------------
871: -- Declare Process variables
872: ------------------------------------------------------------
873: l_msg_index_out NUMBER;

Line 1203: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1199: ------------------------------------------------------------
1200:
1201: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 1');
1202:
1203: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1204:
1205: l_return_status := OKL_API.START_ACTIVITY(
1206: p_api_name => l_api_name,
1207: p_pkg_name => g_pkg_name,

Line 1205: l_return_status := OKL_API.START_ACTIVITY(

1201: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'In PVT 1');
1202:
1203: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1204:
1205: l_return_status := OKL_API.START_ACTIVITY(
1206: p_api_name => l_api_name,
1207: p_pkg_name => g_pkg_name,
1208: p_init_msg_list => p_init_msg_list,
1209: l_api_version => l_api_version,

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

1210: p_api_version => p_api_version,
1211: p_api_type => '_PVT',
1212: x_return_status => l_return_status);
1213:
1214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_ERROR;
1218: END IF;

Line 1215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1211: p_api_type => '_PVT',
1212: x_return_status => l_return_status);
1213:
1214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_ERROR;
1218: END IF;
1219:

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

1212: x_return_status => l_return_status);
1213:
1214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_ERROR;
1218: END IF;
1219:
1220: i := 0;

Line 1217: RAISE OKL_API.G_EXCEPTION_ERROR;

1213:
1214: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1215: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1216: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1217: RAISE OKL_API.G_EXCEPTION_ERROR;
1218: END IF;
1219:
1220: i := 0;
1221:

Line 1603: Okl_Api.END_ACTIVITY (

1599: ------------------------------------------------------------
1600: -- End processing
1601: ------------------------------------------------------------
1602:
1603: Okl_Api.END_ACTIVITY (
1604: x_msg_count => x_msg_count,
1605: x_msg_data => x_msg_data);
1606:
1607:

Line 1612: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1608: EXCEPTION
1609: ------------------------------------------------------------
1610: -- Exception handling
1611: ------------------------------------------------------------
1612: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1613: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
1614: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1615: p_api_name => l_api_name,
1616: p_pkg_name => G_PKG_NAME,

Line 1614: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1610: -- Exception handling
1611: ------------------------------------------------------------
1612: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1613: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
1614: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1615: p_api_name => l_api_name,
1616: p_pkg_name => G_PKG_NAME,
1617: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1618: x_msg_count => x_msg_count,

Line 1617: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1613: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
1614: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1615: p_api_name => l_api_name,
1616: p_pkg_name => G_PKG_NAME,
1617: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1618: x_msg_count => x_msg_count,
1619: x_msg_data => x_msg_data,
1620: p_api_type => '_PVT');
1621:

Line 1622: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1618: x_msg_count => x_msg_count,
1619: x_msg_data => x_msg_data,
1620: p_api_type => '_PVT');
1621:
1622: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1623: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1625: p_api_name => l_api_name,
1626: p_pkg_name => G_PKG_NAME,

Line 1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1620: p_api_type => '_PVT');
1621:
1622: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1623: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1625: p_api_name => l_api_name,
1626: p_pkg_name => G_PKG_NAME,
1627: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1628: x_msg_count => x_msg_count,

Line 1627: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1623: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1625: p_api_name => l_api_name,
1626: p_pkg_name => G_PKG_NAME,
1627: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1628: x_msg_count => x_msg_count,
1629: x_msg_data => x_msg_data,
1630: p_api_type => '_PVT');
1631:

Line 1634: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1630: p_api_type => '_PVT');
1631:
1632: WHEN OTHERS THEN
1633: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
1634: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1635: p_api_name => l_api_name,
1636: p_pkg_name => G_PKG_NAME,
1637: p_exc_name => 'OTHERS',
1638: x_msg_count => x_msg_count,

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

1672: -- Declare variables required by APIs
1673: ------------------------------------------------------------
1674: l_api_version CONSTANT NUMBER := 1;
1675: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_CONSOLIDATION_RULES';
1676: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1677: ------------------------------------------------------------
1678: -- Declare Process variables
1679: ------------------------------------------------------------
1680: l_msg_index_out NUMBER;

Line 2047: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2043: ------------------------------------------------------------
2044:
2045: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 1');
2046:
2047: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2048:
2049: l_return_status := OKL_API.START_ACTIVITY(
2050: p_api_name => l_api_name,
2051: p_pkg_name => g_pkg_name,

Line 2049: l_return_status := OKL_API.START_ACTIVITY(

2045: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'apply_consolidation_rules 1');
2046:
2047: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2048:
2049: l_return_status := OKL_API.START_ACTIVITY(
2050: p_api_name => l_api_name,
2051: p_pkg_name => g_pkg_name,
2052: p_init_msg_list => p_init_msg_list,
2053: l_api_version => l_api_version,

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

2054: p_api_version => p_api_version,
2055: p_api_type => '_PVT',
2056: x_return_status => l_return_status);
2057:
2058: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2060: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2061: RAISE OKL_API.G_EXCEPTION_ERROR;
2062: END IF;

Line 2059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2055: p_api_type => '_PVT',
2056: x_return_status => l_return_status);
2057:
2058: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2060: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2061: RAISE OKL_API.G_EXCEPTION_ERROR;
2062: END IF;
2063:

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

2056: x_return_status => l_return_status);
2057:
2058: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2060: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2061: RAISE OKL_API.G_EXCEPTION_ERROR;
2062: END IF;
2063:
2064: BEGIN -- block to handel trx status update

Line 2061: RAISE OKL_API.G_EXCEPTION_ERROR;

2057:
2058: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2059: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2060: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2061: RAISE OKL_API.G_EXCEPTION_ERROR;
2062: END IF;
2063:
2064: BEGIN -- block to handel trx status update
2065: cin_ln_cnt := 0; -- initial to 0

Line 2180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2176: p_adv_grouping_flag => 'Y',
2177: x_next_inv_seq => l_cin_rec.self_bill_inv_num);
2178:
2179:
2180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2181: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2183: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2184: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');

Line 2182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2178:
2179:
2180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2181: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2183: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2184: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2185: RAISE OKL_API.G_EXCEPTION_ERROR;
2186: ELSIF (x_return_status ='S') THEN

Line 2183: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2179:
2180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2181: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2183: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2184: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2185: RAISE OKL_API.G_EXCEPTION_ERROR;
2186: ELSIF (x_return_status ='S') THEN
2187: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' handle_next_invoice_seq: ' || l_cin_rec.self_bill_inv_num);

Line 2185: RAISE OKL_API.G_EXCEPTION_ERROR;

2181: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2183: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2184: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get and set vendor invoice sequence.');
2185: RAISE OKL_API.G_EXCEPTION_ERROR;
2186: ELSIF (x_return_status ='S') THEN
2187: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' handle_next_invoice_seq: ' || l_cin_rec.self_bill_inv_num);
2188: END IF;
2189:

Line 2224: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2220: x_msg_data => x_msg_data,
2221: p_cin_rec => l_cin_rec,
2222: x_cin_rec => lx_cin_rec);
2223:
2224: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2225: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2228: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');

Line 2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2222: x_cin_rec => lx_cin_rec);
2223:
2224: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2225: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2228: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status ='S') THEN

Line 2227: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2223:
2224: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2225: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2228: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status ='S') THEN
2231: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)Created Consolidated invoices: '||lx_cin_rec.cnsld_ap_inv_id);

Line 2229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2225: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2227: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2228: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)ERROR: Creating Consolidated invoices.');
2229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status ='S') THEN
2231: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' (apply_consolidation_rules)Created Consolidated invoices: '||lx_cin_rec.cnsld_ap_inv_id);
2232: END IF;
2233:

Line 2295: Okl_Api.END_ACTIVITY (

2291: ------------------------------------------------------------
2292: -- End processing
2293: ------------------------------------------------------------
2294:
2295: Okl_Api.END_ACTIVITY (
2296: x_msg_count => x_msg_count,
2297: x_msg_data => x_msg_data);
2298:
2299:

Line 2304: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2300: EXCEPTION
2301: ------------------------------------------------------------
2302: -- Exception handling
2303: ------------------------------------------------------------
2304: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2305: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2306: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2307: p_api_name => l_api_name,
2308: p_pkg_name => G_PKG_NAME,

Line 2306: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2302: -- Exception handling
2303: ------------------------------------------------------------
2304: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2305: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2306: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2307: p_api_name => l_api_name,
2308: p_pkg_name => G_PKG_NAME,
2309: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2310: x_msg_count => x_msg_count,

Line 2309: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2305: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2306: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2307: p_api_name => l_api_name,
2308: p_pkg_name => G_PKG_NAME,
2309: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2310: x_msg_count => x_msg_count,
2311: x_msg_data => x_msg_data,
2312: p_api_type => '_PVT');
2313:

Line 2314: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2310: x_msg_count => x_msg_count,
2311: x_msg_data => x_msg_data,
2312: p_api_type => '_PVT');
2313:
2314: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2315: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2316: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2317: p_api_name => l_api_name,
2318: p_pkg_name => G_PKG_NAME,

Line 2316: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2312: p_api_type => '_PVT');
2313:
2314: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2315: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2316: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2317: p_api_name => l_api_name,
2318: p_pkg_name => G_PKG_NAME,
2319: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2320: x_msg_count => x_msg_count,

Line 2319: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2315: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2316: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2317: p_api_name => l_api_name,
2318: p_pkg_name => G_PKG_NAME,
2319: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2320: x_msg_count => x_msg_count,
2321: x_msg_data => x_msg_data,
2322: p_api_type => '_PVT');
2323:

Line 2326: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2322: p_api_type => '_PVT');
2323:
2324: WHEN OTHERS THEN
2325: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2326: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2327: p_api_name => l_api_name,
2328: p_pkg_name => G_PKG_NAME,
2329: p_exc_name => 'OTHERS',
2330: x_msg_count => x_msg_count,

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

2352: -- Declare Process variables
2353: ------------------------------------------------------------
2354: l_api_version CONSTANT NUMBER := 1;
2355: l_api_name CONSTANT VARCHAR2(30) := 'handle_processing_fee';
2356: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2357: l_msg_index_out NUMBER;
2358: i NUMBER;
2359:
2360: /*

Line 2383: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2379: l_row_found BOOLEAN;
2380: -- r_no_adv_grp c_no_adv_grp%ROWTYPE;
2381: BEGIN
2382:
2383: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2384:
2385: l_return_status := OKL_API.START_ACTIVITY(
2386: p_api_name => l_api_name,
2387: p_pkg_name => g_pkg_name,

Line 2385: l_return_status := OKL_API.START_ACTIVITY(

2381: BEGIN
2382:
2383: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2384:
2385: l_return_status := OKL_API.START_ACTIVITY(
2386: p_api_name => l_api_name,
2387: p_pkg_name => g_pkg_name,
2388: p_init_msg_list => p_init_msg_list,
2389: l_api_version => l_api_version,

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

2390: p_api_version => p_api_version,
2391: p_api_type => '_PVT',
2392: x_return_status => l_return_status);
2393:
2394: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2396: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2397: RAISE OKL_API.G_EXCEPTION_ERROR;
2398: END IF;

Line 2395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2391: p_api_type => '_PVT',
2392: x_return_status => l_return_status);
2393:
2394: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2396: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2397: RAISE OKL_API.G_EXCEPTION_ERROR;
2398: END IF;
2399: /*

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

2392: x_return_status => l_return_status);
2393:
2394: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2396: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2397: RAISE OKL_API.G_EXCEPTION_ERROR;
2398: END IF;
2399: /*
2400:

Line 2397: RAISE OKL_API.G_EXCEPTION_ERROR;

2393:
2394: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2396: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2397: RAISE OKL_API.G_EXCEPTION_ERROR;
2398: END IF;
2399: /*
2400:
2401: Question 1:

Line 2514: Okl_Api.END_ACTIVITY (

2510: ------------------------------------------------------------
2511: -- End processing
2512: ------------------------------------------------------------
2513:
2514: Okl_Api.END_ACTIVITY (
2515: x_msg_count => x_msg_count,
2516: x_msg_data => x_msg_data);
2517:
2518: EXCEPTION

Line 2522: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2518: EXCEPTION
2519: ------------------------------------------------------------
2520: -- Exception handling
2521: ------------------------------------------------------------
2522: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2523: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2524: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2525: p_api_name => l_api_name,
2526: p_pkg_name => G_PKG_NAME,

Line 2524: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2520: -- Exception handling
2521: ------------------------------------------------------------
2522: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2523: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2524: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2525: p_api_name => l_api_name,
2526: p_pkg_name => G_PKG_NAME,
2527: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2528: x_msg_count => x_msg_count,

Line 2527: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2523: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2524: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2525: p_api_name => l_api_name,
2526: p_pkg_name => G_PKG_NAME,
2527: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2528: x_msg_count => x_msg_count,
2529: x_msg_data => x_msg_data,
2530: p_api_type => '_PVT');
2531:

Line 2532: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2528: x_msg_count => x_msg_count,
2529: x_msg_data => x_msg_data,
2530: p_api_type => '_PVT');
2531:
2532: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2533: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2534: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2535: p_api_name => l_api_name,
2536: p_pkg_name => G_PKG_NAME,

Line 2534: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2530: p_api_type => '_PVT');
2531:
2532: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2533: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2534: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2535: p_api_name => l_api_name,
2536: p_pkg_name => G_PKG_NAME,
2537: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2538: x_msg_count => x_msg_count,

Line 2537: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2533: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2534: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2535: p_api_name => l_api_name,
2536: p_pkg_name => G_PKG_NAME,
2537: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2538: x_msg_count => x_msg_count,
2539: x_msg_data => x_msg_data,
2540: p_api_type => '_PVT');
2541:

Line 2544: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2540: p_api_type => '_PVT');
2541:
2542: WHEN OTHERS THEN
2543: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2544: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2545: p_api_name => l_api_name,
2546: p_pkg_name => G_PKG_NAME,
2547: p_exc_name => 'OTHERS',
2548: x_msg_count => x_msg_count,

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

2580: -- Declare Process variables
2581: ------------------------------------------------------------
2582: l_api_version CONSTANT NUMBER := 1;
2583: l_api_name CONSTANT VARCHAR2(30) := 'CONSOLIDATION';
2584: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2585: l_msg_index_out NUMBER;
2586: i NUMBER;
2587:
2588: --Cursor for selecting the Consolidated invoice header attributes

Line 2681: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2677:
2678:
2679: BEGIN
2680:
2681: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2682:
2683: l_return_status := OKL_API.START_ACTIVITY(
2684: p_api_name => l_api_name,
2685: p_pkg_name => g_pkg_name,

Line 2683: l_return_status := OKL_API.START_ACTIVITY(

2679: BEGIN
2680:
2681: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2682:
2683: l_return_status := OKL_API.START_ACTIVITY(
2684: p_api_name => l_api_name,
2685: p_pkg_name => g_pkg_name,
2686: p_init_msg_list => p_init_msg_list,
2687: l_api_version => l_api_version,

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

2688: p_api_version => p_api_version,
2689: p_api_type => '_PVT',
2690: x_return_status => l_return_status);
2691:
2692: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2694: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2695: RAISE OKL_API.G_EXCEPTION_ERROR;
2696: END IF;

Line 2693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2689: p_api_type => '_PVT',
2690: x_return_status => l_return_status);
2691:
2692: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2694: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2695: RAISE OKL_API.G_EXCEPTION_ERROR;
2696: END IF;
2697:

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

2690: x_return_status => l_return_status);
2691:
2692: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2694: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2695: RAISE OKL_API.G_EXCEPTION_ERROR;
2696: END IF;
2697:
2698:

Line 2695: RAISE OKL_API.G_EXCEPTION_ERROR;

2691:
2692: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2694: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2695: RAISE OKL_API.G_EXCEPTION_ERROR;
2696: END IF;
2697:
2698:
2699: --start: 24-APR-2007 cklee -- Disbursement changes for R12B, bug fixed: |

Line 2804: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2800: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPICB.pls call OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs '|| x_return_status);
2801: END;
2802: END IF;
2803: -- End of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
2804: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2805: l_conc_status := 'E';
2806: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
2807: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2808: l_conc_status := 'E';

Line 2807: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2803: -- End of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
2804: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2805: l_conc_status := 'E';
2806: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
2807: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2808: l_conc_status := 'E';
2809: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
2810: ELSIF (x_return_status ='S') THEN
2811: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);

Line 2892: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2888: END;
2889: END IF;
2890: -- End of wraper code generated automatically by Debug code generator for okl_xtl_pay_invs_pub.insert_xtl_pay_invs
2891:
2892: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2893: l_conc_status := 'E';
2894: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
2895: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2896: l_conc_status := 'E';

Line 2895: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2891:
2892: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2893: l_conc_status := 'E';
2894: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
2895: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2896: l_conc_status := 'E';
2897: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
2898: ELSIF (x_return_status ='S') THEN
2899: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);

Line 2909: IF ( NVL(l_conc_status, 'E') = okl_api.g_ret_sts_success ) THEN

2905: END IF;
2906: END IF; --> Debit check
2907: END LOOP; -- > Lines
2908:
2909: IF ( NVL(l_conc_status, 'E') = okl_api.g_ret_sts_success ) THEN
2910: -----------------------------------------------------------------
2911: -- Update internal AP table for Success
2912: -----------------------------------------------------------------
2913: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully Prepared Invoice Number : ' || r_cnsld_hdr.invoice_number);

Line 2957: Okl_Api.END_ACTIVITY (

2953: ------------------------------------------------------------
2954: -- End processing
2955: ------------------------------------------------------------
2956:
2957: Okl_Api.END_ACTIVITY (
2958: x_msg_count => x_msg_count,
2959: x_msg_data => x_msg_data);
2960:
2961: EXCEPTION

Line 2965: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2961: EXCEPTION
2962: ------------------------------------------------------------
2963: -- Exception handling
2964: ------------------------------------------------------------
2965: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2966: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2967: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2968: p_api_name => l_api_name,
2969: p_pkg_name => G_PKG_NAME,

Line 2967: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2963: -- Exception handling
2964: ------------------------------------------------------------
2965: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2966: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2967: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2968: p_api_name => l_api_name,
2969: p_pkg_name => G_PKG_NAME,
2970: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2971: x_msg_count => x_msg_count,

Line 2970: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2966: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2967: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2968: p_api_name => l_api_name,
2969: p_pkg_name => G_PKG_NAME,
2970: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2971: x_msg_count => x_msg_count,
2972: x_msg_data => x_msg_data,
2973: p_api_type => '_PVT');
2974:

Line 2975: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2971: x_msg_count => x_msg_count,
2972: x_msg_data => x_msg_data,
2973: p_api_type => '_PVT');
2974:
2975: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2976: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2977: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2978: p_api_name => l_api_name,
2979: p_pkg_name => G_PKG_NAME,

Line 2977: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2973: p_api_type => '_PVT');
2974:
2975: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2976: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2977: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2978: p_api_name => l_api_name,
2979: p_pkg_name => G_PKG_NAME,
2980: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2981: x_msg_count => x_msg_count,

Line 2980: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2976: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2977: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2978: p_api_name => l_api_name,
2979: p_pkg_name => G_PKG_NAME,
2980: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2981: x_msg_count => x_msg_count,
2982: x_msg_data => x_msg_data,
2983: p_api_type => '_PVT');
2984:

Line 2987: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2983: p_api_type => '_PVT');
2984:
2985: WHEN OTHERS THEN
2986: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
2987: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2988: p_api_name => l_api_name,
2989: p_pkg_name => G_PKG_NAME,
2990: p_exc_name => 'OTHERS',
2991: x_msg_count => x_msg_count,

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

3006: -- Declare variables required by APIs
3007: ------------------------------------------------------------
3008: l_api_version CONSTANT NUMBER := 1;
3009: l_api_name CONSTANT VARCHAR2(30) := 'CONSOLIDATION';
3010: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3011: ------------------------------------------------------------
3012: -- Declare Process variables
3013: ------------------------------------------------------------
3014: l_msg_index_out NUMBER;

Line 3262: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3258: ------------------------------------------------------------
3259: -- Start processing
3260: ------------------------------------------------------------
3261:
3262: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3263:
3264: l_return_status := OKL_API.START_ACTIVITY(
3265: p_api_name => l_api_name,
3266: p_pkg_name => g_pkg_name,

Line 3264: l_return_status := OKL_API.START_ACTIVITY(

3260: ------------------------------------------------------------
3261:
3262: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3263:
3264: l_return_status := OKL_API.START_ACTIVITY(
3265: p_api_name => l_api_name,
3266: p_pkg_name => g_pkg_name,
3267: p_init_msg_list => p_init_msg_list,
3268: l_api_version => l_api_version,

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

3269: p_api_version => p_api_version,
3270: p_api_type => '_PVT',
3271: x_return_status => l_return_status);
3272:
3273: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3275: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3276: RAISE OKL_API.G_EXCEPTION_ERROR;
3277: END IF;

Line 3274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3270: p_api_type => '_PVT',
3271: x_return_status => l_return_status);
3272:
3273: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3275: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3276: RAISE OKL_API.G_EXCEPTION_ERROR;
3277: END IF;
3278:

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

3271: x_return_status => l_return_status);
3272:
3273: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3275: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3276: RAISE OKL_API.G_EXCEPTION_ERROR;
3277: END IF;
3278:
3279: -----------------------------------------------------------------

Line 3276: RAISE OKL_API.G_EXCEPTION_ERROR;

3272:
3273: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3275: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3276: RAISE OKL_API.G_EXCEPTION_ERROR;
3277: END IF;
3278:
3279: -----------------------------------------------------------------
3280: -- Open Invoice cursor in block

Line 3468: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3464: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPICB.pls call OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs ');
3465: END;
3466: END IF;
3467: -- End of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
3468: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3469: l_conc_status := 'E';
3470: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3472: l_conc_status := 'E';

Line 3471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3467: -- End of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
3468: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3469: l_conc_status := 'E';
3470: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3472: l_conc_status := 'E';
3473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3474: ELSIF (x_return_status ='S') THEN
3475: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);

Line 3515: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3511: END;
3512: END IF;
3513: -- End of wraper code generated automatically by Debug code generator for okl_xtl_pay_invs_pub.insert_xtl_pay_invs
3514:
3515: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3516: l_conc_status := 'E';
3517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3519: l_conc_status := 'E';

Line 3518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3514:
3515: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3516: l_conc_status := 'E';
3517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3519: l_conc_status := 'E';
3520: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3521: ELSIF (x_return_status ='S') THEN
3522: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);

Line 3567: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3563: END;
3564: END IF;
3565: -- End of wraper code generated automatically by Debug code generator for okl_trx_ar_invoices_pub.insert_trx_ar_invoices
3566:
3567: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3568: l_conc_status := 'E';
3569: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
3570: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3571: l_conc_status := 'E';

Line 3570: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3566:
3567: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3568: l_conc_status := 'E';
3569: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
3570: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3571: l_conc_status := 'E';
3572: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
3573: ELSIF (x_return_status ='S') THEN
3574: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Header with Id: '||lx_taiv_rec.id);

Line 3612: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3608: END;
3609: END IF;
3610: -- End of wraper code generated automatically by Debug code generator for okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
3611:
3612: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3613: l_conc_status := 'E';
3614: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
3615: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3616: l_conc_status := 'E';

Line 3615: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3611:
3612: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3613: l_conc_status := 'E';
3614: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
3615: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3616: l_conc_status := 'E';
3617: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
3618: ELSIF (x_return_status ='S') THEN
3619: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Line with Id: '||lx_tilv_rec.id);

Line 3647: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3643: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRPICB.pls call Okl_Acc_Call_Pub.CREATE_ACC_TRANS ');
3644: END;
3645: END IF;
3646: -- End of wraper code generated automatically by Debug code generator for Okl_Acc_Call_Pub.CREATE_ACC_TRANS
3647: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3648: l_conc_status := 'E';
3649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
3650: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3651: l_conc_status := 'E';

Line 3650: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3646: -- End of wraper code generated automatically by Debug code generator for Okl_Acc_Call_Pub.CREATE_ACC_TRANS
3647: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3648: l_conc_status := 'E';
3649: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
3650: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3651: l_conc_status := 'E';
3652: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
3653: ELSIF (x_return_status ='S') THEN
3654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ... Accounting Distributions Created.');

Line 3659: IF ( NVL(l_conc_status, 'E') = okl_api.g_ret_sts_success )

3655: END IF;
3656:
3657: END IF;
3658:
3659: IF ( NVL(l_conc_status, 'E') = okl_api.g_ret_sts_success )
3660: THEN
3661: -----------------------------------------------------------------
3662: -- Update internal AP table for Success
3663: -----------------------------------------------------------------

Line 3910: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3906: END;
3907: END IF;
3908: -- End of wraper code generated automatically by Debug code generator for OKL_EXT_PAY_INVS_PUB.insert_ext_pay_invs
3909:
3910: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3911: l_conc_status := 'E';
3912: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3913: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3914: l_conc_status := 'E';

Line 3913: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3909:
3910: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3911: l_conc_status := 'E';
3912: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3913: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3914: l_conc_status := 'E';
3915: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Header.');
3916: ELSIF (x_return_status ='S') THEN
3917: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Header with Id: '||lx_xpiv_rec.id);

Line 3952: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

3948: ,p_xlpv_rec => l_xlpv_rec
3949: ,x_xlpv_rec => lx_xlpv_rec);
3950:
3951:
3952: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3953: l_conc_status := 'E';
3954: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3955: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3956: l_conc_status := 'E';

Line 3955: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

3951:
3952: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3953: l_conc_status := 'E';
3954: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3955: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3956: l_conc_status := 'E';
3957: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating External AP Invoice Line.');
3958: ELSIF (x_return_status ='S') THEN
3959: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created External AP Invoice Line with Id: '||lx_xlpv_rec.id);

Line 4004: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4000: END;
4001: END IF;
4002: -- End of wraper code generated automatically by Debug code generator for okl_trx_ar_invoices_pub.insert_trx_ar_invoices
4003:
4004: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4005: l_conc_status := 'E';
4006: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
4007: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4008: l_conc_status := 'E';

Line 4007: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4003:
4004: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4005: l_conc_status := 'E';
4006: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
4007: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4008: l_conc_status := 'E';
4009: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Header.');
4010: ELSIF (x_return_status ='S') THEN
4011: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Header with Id: '||lx_taiv_rec.id);

Line 4049: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4045: END;
4046: END IF;
4047: -- End of wraper code generated automatically by Debug code generator for okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns
4048:
4049: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4050: l_conc_status := 'E';
4051: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
4052: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4053: l_conc_status := 'E';

Line 4052: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4048:
4049: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4050: l_conc_status := 'E';
4051: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
4052: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4053: l_conc_status := 'E';
4054: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Internal AR Invoice Line.');
4055: ELSIF (x_return_status ='S') THEN
4056: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Internal AR Invoice Line with Id: '||lx_tilv_rec.id);

Line 4085: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4081: END;
4082: END IF;
4083: -- End of wraper code generated automatically by Debug code generator for Okl_Acc_Call_Pub.CREATE_ACC_TRANS
4084:
4085: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4086: l_conc_status := 'E';
4087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
4088: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4089: l_conc_status := 'E';

Line 4088: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4084:
4085: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4086: l_conc_status := 'E';
4087: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
4088: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4089: l_conc_status := 'E';
4090: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Accounting Distributions.');
4091: ELSIF (x_return_status ='S') THEN
4092: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ... Accounting Distributions Created.');

Line 4097: IF ( NVL(l_conc_status, 'E') = okl_api.g_ret_sts_success )

4093: END IF;
4094: END IF;
4095:
4096:
4097: IF ( NVL(l_conc_status, 'E') = okl_api.g_ret_sts_success )
4098: THEN
4099: -----------------------------------------------------------------
4100: -- Update internal AP table for Success
4101: -----------------------------------------------------------------

Line 4155: Okl_Api.END_ACTIVITY (

4151: ------------------------------------------------------------
4152: -- End processing
4153: ------------------------------------------------------------
4154:
4155: Okl_Api.END_ACTIVITY (
4156: x_msg_count => x_msg_count,
4157: x_msg_data => x_msg_data);
4158:
4159:

Line 4164: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4160: EXCEPTION
4161: ------------------------------------------------------------
4162: -- Exception handling
4163: ------------------------------------------------------------
4164: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4166: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4167: p_api_name => l_api_name,
4168: p_pkg_name => G_PKG_NAME,

Line 4166: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4162: -- Exception handling
4163: ------------------------------------------------------------
4164: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4166: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4167: p_api_name => l_api_name,
4168: p_pkg_name => G_PKG_NAME,
4169: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4170: x_msg_count => x_msg_count,

Line 4169: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

4165: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4166: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4167: p_api_name => l_api_name,
4168: p_pkg_name => G_PKG_NAME,
4169: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4170: x_msg_count => x_msg_count,
4171: x_msg_data => x_msg_data,
4172: p_api_type => '_PVT');
4173:

Line 4174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4170: x_msg_count => x_msg_count,
4171: x_msg_data => x_msg_data,
4172: p_api_type => '_PVT');
4173:
4174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4175: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4176: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4177: p_api_name => l_api_name,
4178: p_pkg_name => G_PKG_NAME,

Line 4176: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4172: p_api_type => '_PVT');
4173:
4174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4175: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4176: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4177: p_api_name => l_api_name,
4178: p_pkg_name => G_PKG_NAME,
4179: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4180: x_msg_count => x_msg_count,

Line 4179: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

4175: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4176: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4177: p_api_name => l_api_name,
4178: p_pkg_name => G_PKG_NAME,
4179: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4180: x_msg_count => x_msg_count,
4181: x_msg_data => x_msg_data,
4182: p_api_type => '_PVT');
4183:

Line 4186: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4182: p_api_type => '_PVT');
4183:
4184: WHEN OTHERS THEN
4185: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4186: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4187: p_api_name => l_api_name,
4188: p_pkg_name => G_PKG_NAME,
4189: p_exc_name => 'OTHERS',
4190: x_msg_count => x_msg_count,

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

4211: -- Declare variables required by APIs
4212: ------------------------------------------------------------
4213: l_api_version CONSTANT NUMBER := 1;
4214: l_api_name CONSTANT VARCHAR2(30) := 'CONSOLIDATION';
4215: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4216: ------------------------------------------------------------
4217: -- Declare Process variables
4218: ------------------------------------------------------------
4219: l_msg_index_out NUMBER;

Line 4347: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4343: ------------------------------------------------------------
4344:
4345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Prepare Payables Invoices IN pvt consol');
4346:
4347: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4348:
4349: l_return_status := OKL_API.START_ACTIVITY(
4350: p_api_name => l_api_name,
4351: p_pkg_name => g_pkg_name,

Line 4349: l_return_status := OKL_API.START_ACTIVITY(

4345: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Prepare Payables Invoices IN pvt consol');
4346:
4347: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4348:
4349: l_return_status := OKL_API.START_ACTIVITY(
4350: p_api_name => l_api_name,
4351: p_pkg_name => g_pkg_name,
4352: p_init_msg_list => p_init_msg_list,
4353: l_api_version => l_api_version,

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

4354: p_api_version => p_api_version,
4355: p_api_type => '_PVT',
4356: x_return_status => l_return_status);
4357:
4358: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4359: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4360: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4361: RAISE OKL_API.G_EXCEPTION_ERROR;
4362: END IF;

Line 4359: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4355: p_api_type => '_PVT',
4356: x_return_status => l_return_status);
4357:
4358: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4359: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4360: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4361: RAISE OKL_API.G_EXCEPTION_ERROR;
4362: END IF;
4363:

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

4356: x_return_status => l_return_status);
4357:
4358: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4359: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4360: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4361: RAISE OKL_API.G_EXCEPTION_ERROR;
4362: END IF;
4363:
4364: --start: | 01-May-07 cklee R12 DIsb enhancement project

Line 4361: RAISE OKL_API.G_EXCEPTION_ERROR;

4357:
4358: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4359: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4360: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4361: RAISE OKL_API.G_EXCEPTION_ERROR;
4362: END IF;
4363:
4364: --start: | 01-May-07 cklee R12 DIsb enhancement project
4365: OPEN acc_sys_option;

Line 4453: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4449: p_to_date => p_to_date);
4450:
4451:
4452:
4453: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4454: l_conc_status := 'E';
4455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Cannot Consolidate.');
4456: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4457: l_conc_status := 'E';

Line 4456: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4452:
4453: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4454: l_conc_status := 'E';
4455: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Cannot Consolidate.');
4456: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4457: l_conc_status := 'E';
4458: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Cannot Consolidate.');
4459: ELSIF (x_return_status ='S') THEN
4460: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: ');

Line 4480: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4476: p_cin_rec => l_cin_rec,
4477: x_cin_rec => lx_cin_rec);
4478:
4479:
4480: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4481: l_conc_status := 'E';
4482: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices.');
4483: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4484: l_conc_status := 'E';

Line 4483: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4479:
4480: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4481: l_conc_status := 'E';
4482: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices.');
4483: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4484: l_conc_status := 'E';
4485: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices.');
4486: ELSIF (x_return_status ='S') THEN
4487: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: '||to_char(l_cin_rec.cnsld_ap_inv_id));

Line 4510: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4506: p_tplv_tbl => l_tplv_tbl,
4507: x_tplv_tbl => lx_tplv_tbl);
4508:
4509:
4510: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4511: l_conc_status := 'E';
4512: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices lines.');
4513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4514: l_conc_status := 'E';

Line 4513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4509:
4510: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4511: l_conc_status := 'E';
4512: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices lines.');
4513: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4514: l_conc_status := 'E';
4515: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Creating Consolidated invoices lines.');
4516: ELSIF (x_return_status ='S') THEN
4517: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices lines: '||to_char(lx_tplv_rec.id));

Line 4560: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4556: x_msg_data => x_msg_data);
4557: -- p_from_date => p_from_date,
4558: -- p_to_date => p_to_date);
4559:
4560: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4561: l_conc_status := 'E';
4562: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4563: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4564: l_conc_status := 'E';

Line 4563: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4559:
4560: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4561: l_conc_status := 'E';
4562: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4563: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4564: l_conc_status := 'E';
4565: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4566: ELSIF (x_return_status ='S') THEN
4567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' transferring invoices lines: ');

Line 4574: Okl_Api.END_ACTIVITY (

4570: ------------------------------------------------------------
4571: -- End processing
4572: ------------------------------------------------------------
4573:
4574: Okl_Api.END_ACTIVITY (
4575: x_msg_count => x_msg_count,
4576: x_msg_data => x_msg_data);
4577:
4578:

Line 4583: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4579: EXCEPTION
4580: ------------------------------------------------------------
4581: -- Exception handling
4582: ------------------------------------------------------------
4583: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4584: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4585: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4586: p_api_name => l_api_name,
4587: p_pkg_name => G_PKG_NAME,

Line 4585: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4581: -- Exception handling
4582: ------------------------------------------------------------
4583: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4584: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4585: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4586: p_api_name => l_api_name,
4587: p_pkg_name => G_PKG_NAME,
4588: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4589: x_msg_count => x_msg_count,

Line 4588: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

4584: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4585: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4586: p_api_name => l_api_name,
4587: p_pkg_name => G_PKG_NAME,
4588: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4589: x_msg_count => x_msg_count,
4590: x_msg_data => x_msg_data,
4591: p_api_type => '_PVT');
4592:

Line 4593: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4589: x_msg_count => x_msg_count,
4590: x_msg_data => x_msg_data,
4591: p_api_type => '_PVT');
4592:
4593: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4594: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4595: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4596: p_api_name => l_api_name,
4597: p_pkg_name => G_PKG_NAME,

Line 4595: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4591: p_api_type => '_PVT');
4592:
4593: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4594: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4595: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4596: p_api_name => l_api_name,
4597: p_pkg_name => G_PKG_NAME,
4598: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4599: x_msg_count => x_msg_count,

Line 4598: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

4594: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4595: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4596: p_api_name => l_api_name,
4597: p_pkg_name => G_PKG_NAME,
4598: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4599: x_msg_count => x_msg_count,
4600: x_msg_data => x_msg_data,
4601: p_api_type => '_PVT');
4602:

Line 4605: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4601: p_api_type => '_PVT');
4602:
4603: WHEN OTHERS THEN
4604: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4605: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4606: p_api_name => l_api_name,
4607: p_pkg_name => G_PKG_NAME,
4608: p_exc_name => 'OTHERS',
4609: x_msg_count => x_msg_count,

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

4642: -- Declare variables required by APIs
4643: ------------------------------------------------------------
4644: l_api_version CONSTANT NUMBER := 1;
4645: l_api_name CONSTANT VARCHAR2(30) := 'get_con_parameters';
4646: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4647: ------------------------------------------------------------
4648: -- Declare Process variables
4649: ------------------------------------------------------------
4650: -- l_msg_index_out NUMBER;

Line 4691: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4687: ------------------------------------------------------------
4688:
4689: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 1');
4690:
4691: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4692:
4693: l_return_status := OKL_API.START_ACTIVITY(
4694: p_api_name => l_api_name,
4695: p_pkg_name => g_pkg_name,

Line 4693: l_return_status := OKL_API.START_ACTIVITY(

4689: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'get_con_parameters: 1');
4690:
4691: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4692:
4693: l_return_status := OKL_API.START_ACTIVITY(
4694: p_api_name => l_api_name,
4695: p_pkg_name => g_pkg_name,
4696: p_init_msg_list => p_init_msg_list,
4697: l_api_version => l_api_version,

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

4698: p_api_version => p_api_version,
4699: p_api_type => '_PVT',
4700: x_return_status => l_return_status);
4701:
4702: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4703: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4704: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4705: RAISE OKL_API.G_EXCEPTION_ERROR;
4706: END IF;

Line 4703: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4699: p_api_type => '_PVT',
4700: x_return_status => l_return_status);
4701:
4702: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4703: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4704: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4705: RAISE OKL_API.G_EXCEPTION_ERROR;
4706: END IF;
4707: -----------------------------------------------------------------

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

4700: x_return_status => l_return_status);
4701:
4702: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4703: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4704: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4705: RAISE OKL_API.G_EXCEPTION_ERROR;
4706: END IF;
4707: -----------------------------------------------------------------
4708: -- Open Invoice cursor in block

Line 4705: RAISE OKL_API.G_EXCEPTION_ERROR;

4701:
4702: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4703: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4704: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4705: RAISE OKL_API.G_EXCEPTION_ERROR;
4706: END IF;
4707: -----------------------------------------------------------------
4708: -- Open Invoice cursor in block
4709: -----------------------------------------------------------------

Line 4754: Okl_Api.END_ACTIVITY (

4750: ------------------------------------------------------------
4751: -- End processing
4752: ------------------------------------------------------------
4753:
4754: Okl_Api.END_ACTIVITY (
4755: x_msg_count => x_msg_count,
4756: x_msg_data => x_msg_data);
4757:
4758:

Line 4763: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4759: EXCEPTION
4760: ------------------------------------------------------------
4761: -- Exception handling
4762: ------------------------------------------------------------
4763: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4764: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4765: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4766: p_api_name => l_api_name,
4767: p_pkg_name => G_PKG_NAME,

Line 4765: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4761: -- Exception handling
4762: ------------------------------------------------------------
4763: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4764: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4765: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4766: p_api_name => l_api_name,
4767: p_pkg_name => G_PKG_NAME,
4768: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4769: x_msg_count => x_msg_count,

Line 4768: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

4764: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4765: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4766: p_api_name => l_api_name,
4767: p_pkg_name => G_PKG_NAME,
4768: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4769: x_msg_count => x_msg_count,
4770: x_msg_data => x_msg_data,
4771: p_api_type => '_PVT');
4772:

Line 4773: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4769: x_msg_count => x_msg_count,
4770: x_msg_data => x_msg_data,
4771: p_api_type => '_PVT');
4772:
4773: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4775: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4776: p_api_name => l_api_name,
4777: p_pkg_name => G_PKG_NAME,

Line 4775: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4771: p_api_type => '_PVT');
4772:
4773: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4775: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4776: p_api_name => l_api_name,
4777: p_pkg_name => G_PKG_NAME,
4778: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4779: x_msg_count => x_msg_count,

Line 4778: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

4774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4775: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4776: p_api_name => l_api_name,
4777: p_pkg_name => G_PKG_NAME,
4778: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4779: x_msg_count => x_msg_count,
4780: x_msg_data => x_msg_data,
4781: p_api_type => '_PVT');
4782:

Line 4785: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4781: p_api_type => '_PVT');
4782:
4783: WHEN OTHERS THEN
4784: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4785: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4786: p_api_name => l_api_name,
4787: p_pkg_name => G_PKG_NAME,
4788: p_exc_name => 'OTHERS',
4789: x_msg_count => x_msg_count,

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

4819: -- Declare variables required by APIs
4820: ------------------------------------------------------------
4821: l_api_version CONSTANT NUMBER := 1;
4822: l_api_name CONSTANT VARCHAR2(30) := 'CONSOLIDATION';
4823: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4824: ------------------------------------------------------------
4825: -- Declare Process variables
4826: ------------------------------------------------------------
4827: -- l_msg_index_out NUMBER;

Line 4844: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4840: ------------------------------------------------------------
4841:
4842: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'consolidation 1');
4843:
4844: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4845:
4846: l_return_status := OKL_API.START_ACTIVITY(
4847: p_api_name => l_api_name,
4848: p_pkg_name => g_pkg_name,

Line 4846: l_return_status := OKL_API.START_ACTIVITY(

4842: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'consolidation 1');
4843:
4844: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4845:
4846: l_return_status := OKL_API.START_ACTIVITY(
4847: p_api_name => l_api_name,
4848: p_pkg_name => g_pkg_name,
4849: p_init_msg_list => p_init_msg_list,
4850: l_api_version => l_api_version,

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

4851: p_api_version => p_api_version,
4852: p_api_type => '_PVT',
4853: x_return_status => l_return_status);
4854:
4855: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4857: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4858: RAISE OKL_API.G_EXCEPTION_ERROR;
4859: END IF;

Line 4856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4852: p_api_type => '_PVT',
4853: x_return_status => l_return_status);
4854:
4855: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4857: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4858: RAISE OKL_API.G_EXCEPTION_ERROR;
4859: END IF;
4860: --

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

4853: x_return_status => l_return_status);
4854:
4855: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4857: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4858: RAISE OKL_API.G_EXCEPTION_ERROR;
4859: END IF;
4860: --
4861: get_con_parameters(

Line 4858: RAISE OKL_API.G_EXCEPTION_ERROR;

4854:
4855: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4857: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4858: RAISE OKL_API.G_EXCEPTION_ERROR;
4859: END IF;
4860: --
4861: get_con_parameters(
4862: p_api_version => p_api_version,

Line 4876: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4872: x_vendor_id => l_vendor_id,
4873: x_vendor_site_id => l_vendor_site_id,
4874: x_vpa_id => l_vpa_id);
4875:
4876: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4877: l_conc_status := 'E';
4878: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get_con_parameters failed.');
4879: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4880: l_conc_status := 'E';

Line 4879: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4875:
4876: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4877: l_conc_status := 'E';
4878: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get_con_parameters failed.');
4879: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4880: l_conc_status := 'E';
4881: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: get_con_parameters failed.');
4882: ELSIF (x_return_status ='S') THEN
4883: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' get_con_parameters done: ');

Line 4900: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4896: p_stream_type_purpose => p_stream_type_purpose,
4897: p_from_date => p_from_date,
4898: p_to_date => p_to_date);
4899:
4900: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4901: l_conc_status := 'E';
4902: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: apply_consolidation_rules failed.');
4903: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4904: l_conc_status := 'E';

Line 4903: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4899:
4900: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4901: l_conc_status := 'E';
4902: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: apply_consolidation_rules failed.');
4903: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4904: l_conc_status := 'E';
4905: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: apply_consolidation_rules failed.');
4906: ELSIF (x_return_status ='S') THEN
4907: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Created Consolidated invoices: ');

Line 4917: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4913: x_return_status => x_return_status,
4914: x_msg_count => x_msg_count,
4915: x_msg_data => x_msg_data);
4916:
4917: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4918: l_conc_status := 'E';
4919: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Handle porcessing feet.');
4920: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4921: l_conc_status := 'E';

Line 4920: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4916:
4917: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4918: l_conc_status := 'E';
4919: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Handle porcessing feet.');
4920: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4921: l_conc_status := 'E';
4922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: Handle porcessing feet.');
4923: ELSIF (x_return_status ='S') THEN
4924: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Handle porcessing feet.');

Line 4934: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4930: x_return_status => x_return_status,
4931: x_msg_count => x_msg_count,
4932: x_msg_data => x_msg_data);
4933:
4934: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4935: l_conc_status := 'E';
4936: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4937: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4938: l_conc_status := 'E';

Line 4937: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

4933:
4934: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4935: l_conc_status := 'E';
4936: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4937: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4938: l_conc_status := 'E';
4939: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ERROR: transferring invoices lines.');
4940: ELSIF (x_return_status ='S') THEN
4941: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' transferring invoices lines: ');

Line 4948: Okl_Api.END_ACTIVITY (

4944: ------------------------------------------------------------
4945: -- End processing
4946: ------------------------------------------------------------
4947:
4948: Okl_Api.END_ACTIVITY (
4949: x_msg_count => x_msg_count,
4950: x_msg_data => x_msg_data);
4951:
4952:

Line 4957: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4953: EXCEPTION
4954: ------------------------------------------------------------
4955: -- Exception handling
4956: ------------------------------------------------------------
4957: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4958: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4959: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4960: p_api_name => l_api_name,
4961: p_pkg_name => G_PKG_NAME,

Line 4959: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4955: -- Exception handling
4956: ------------------------------------------------------------
4957: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4958: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4959: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4960: p_api_name => l_api_name,
4961: p_pkg_name => G_PKG_NAME,
4962: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4963: x_msg_count => x_msg_count,

Line 4962: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

4958: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4959: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4960: p_api_name => l_api_name,
4961: p_pkg_name => G_PKG_NAME,
4962: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4963: x_msg_count => x_msg_count,
4964: x_msg_data => x_msg_data,
4965: p_api_type => '_PVT');
4966:

Line 4967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4963: x_msg_count => x_msg_count,
4964: x_msg_data => x_msg_data,
4965: p_api_type => '_PVT');
4966:
4967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4968: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4969: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4970: p_api_name => l_api_name,
4971: p_pkg_name => G_PKG_NAME,

Line 4969: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4965: p_api_type => '_PVT');
4966:
4967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4968: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4969: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4970: p_api_name => l_api_name,
4971: p_pkg_name => G_PKG_NAME,
4972: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4973: x_msg_count => x_msg_count,

Line 4972: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

4968: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4969: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4970: p_api_name => l_api_name,
4971: p_pkg_name => G_PKG_NAME,
4972: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4973: x_msg_count => x_msg_count,
4974: x_msg_data => x_msg_data,
4975: p_api_type => '_PVT');
4976:

Line 4979: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

4975: p_api_type => '_PVT');
4976:
4977: WHEN OTHERS THEN
4978: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
4979: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
4980: p_api_name => l_api_name,
4981: p_pkg_name => G_PKG_NAME,
4982: p_exc_name => 'OTHERS',
4983: x_msg_count => x_msg_count,