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

Line 7: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: G_MUTE_PROFILE CONSTANT VARCHAR2(30) := 'OKC_SUPPRESS_EMAILS';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ASYNC_PVT';
9: G_LEVEL CONSTANT VARCHAR2(4) := '_PVT';
10: l_api_version CONSTANT NUMBER := 1;
11:

Line 233: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

229: p_wf_par_tbl IN par_tbl_typ
230: ) is
231:
232: l_api_name CONSTANT VARCHAR2(30) := 'WF_CALL';
233: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
234: l_key varchar2(100);
235: c NUMBER;
236: i NUMBER;
237: j NUMBER;

Line 259: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

255: okc_debug.Log('20: p_e_recipient : '||p_e_recipient,2);
256: okc_debug.Log('20: p_s_recipient : '||p_s_recipient,2);
257: END IF;
258:
259: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
260: G_PKG_NAME,
261: p_init_msg_list,
262: l_api_version,
263: p_api_version,

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

262: l_api_version,
263: p_api_version,
264: G_LEVEL,
265: x_return_status);
266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_ERROR;
270: END IF;

Line 267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

263: p_api_version,
264: G_LEVEL,
265: x_return_status);
266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_ERROR;
270: END IF;
271:

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

264: G_LEVEL,
265: x_return_status);
266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_ERROR;
270: END IF;
271:
272: --

Line 269: RAISE OKC_API.G_EXCEPTION_ERROR;

265: x_return_status);
266: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
268: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_ERROR;
270: END IF;
271:
272: --
273: -- create process

Line 416: x_return_status := OKC_API.G_RET_STS_SUCCESS;

412: okc_debug.Log('110: Started WF ',2);
413: END IF;
414:
415: -- commit;
416: x_return_status := OKC_API.G_RET_STS_SUCCESS;
417: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
418:
419: IF (l_debug = 'Y') THEN
420: okc_debug.Log('120: x_msg_count : '||x_msg_count,2);

Line 417: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

413: END IF;
414:
415: -- commit;
416: x_return_status := OKC_API.G_RET_STS_SUCCESS;
417: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
418:
419: IF (l_debug = 'Y') THEN
420: okc_debug.Log('120: x_msg_count : '||x_msg_count,2);
421: okc_debug.Log('130: x_msg_data : '||x_msg_data,2);

Line 430: WHEN OKC_API.G_EXCEPTION_ERROR THEN

426: okc_debug.Reset_Indentation;
427: END IF;
428:
429: EXCEPTION
430: WHEN OKC_API.G_EXCEPTION_ERROR THEN
431: x_return_status := OKC_API.HANDLE_EXCEPTIONS
432: (substr(l_api_name,1,26),
433: G_PKG_NAME,
434: 'OKC_API.G_RET_STS_ERROR',

Line 431: x_return_status := OKC_API.HANDLE_EXCEPTIONS

427: END IF;
428:
429: EXCEPTION
430: WHEN OKC_API.G_EXCEPTION_ERROR THEN
431: x_return_status := OKC_API.HANDLE_EXCEPTIONS
432: (substr(l_api_name,1,26),
433: G_PKG_NAME,
434: 'OKC_API.G_RET_STS_ERROR',
435: x_msg_count,

Line 434: 'OKC_API.G_RET_STS_ERROR',

430: WHEN OKC_API.G_EXCEPTION_ERROR THEN
431: x_return_status := OKC_API.HANDLE_EXCEPTIONS
432: (substr(l_api_name,1,26),
433: G_PKG_NAME,
434: 'OKC_API.G_RET_STS_ERROR',
435: x_msg_count,
436: x_msg_data,
437: G_LEVEL);
438: IF (l_debug = 'Y') THEN

Line 442: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

438: IF (l_debug = 'Y') THEN
439: okc_debug.Log('3000: Leaving ',2);
440: okc_debug.Reset_Indentation;
441: END IF;
442: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
443: x_return_status := OKC_API.HANDLE_EXCEPTIONS
444: (substr(l_api_name,1,26),
445: G_PKG_NAME,
446: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 443: x_return_status := OKC_API.HANDLE_EXCEPTIONS

439: okc_debug.Log('3000: Leaving ',2);
440: okc_debug.Reset_Indentation;
441: END IF;
442: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
443: x_return_status := OKC_API.HANDLE_EXCEPTIONS
444: (substr(l_api_name,1,26),
445: G_PKG_NAME,
446: 'OKC_API.G_RET_STS_UNEXP_ERROR',
447: x_msg_count,

Line 446: 'OKC_API.G_RET_STS_UNEXP_ERROR',

442: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
443: x_return_status := OKC_API.HANDLE_EXCEPTIONS
444: (substr(l_api_name,1,26),
445: G_PKG_NAME,
446: 'OKC_API.G_RET_STS_UNEXP_ERROR',
447: x_msg_count,
448: x_msg_data,
449: G_LEVEL);
450: IF (l_debug = 'Y') THEN

Line 455: x_return_status := OKC_API.HANDLE_EXCEPTIONS

451: okc_debug.Log('4000: Leaving ',2);
452: okc_debug.Reset_Indentation;
453: END IF;
454: WHEN OTHERS THEN
455: x_return_status := OKC_API.HANDLE_EXCEPTIONS
456: (substr(l_api_name,1,26),
457: G_PKG_NAME,
458: 'OTHERS',
459: x_msg_count,

Line 921: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

917: END;
918: END IF;
919:
920: IF p_proc_success_flag = 'S' THEN
921: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
922: p_msg_name => 'OKC_OUTCOME_SUCCESS',
923: p_token1 => 'CONTRACT_NUMBER',
924: p_token1_value => l_contract_number,
925: p_token2 => 'PROCESS_NAME',

Line 928: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

924: p_token1_value => l_contract_number,
925: p_token2 => 'PROCESS_NAME',
926: p_token2_value => l_proc_name);
927:
928: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
929: p_msg_name => 'OKC_OUTCOME_SUCCESS',
930: p_token1 => 'CONTRACT_NUMBER',
931: p_token1_value => l_contract_number,
932: p_token2 => 'PROCESS_NAME',

Line 935: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

931: p_token1_value => l_contract_number,
932: p_token2 => 'PROCESS_NAME',
933: p_token2_value => l_proc_name);
934: ELSE
935: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
936: p_msg_name => 'OKC_OUTCOME_FAILURE',
937: p_token1 => 'CONTRACT_NUMBER',
938: p_token1_value => l_contract_number,
939: p_token2 => 'PROCESS_NAME',

Line 942: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

938: p_token1_value => l_contract_number,
939: p_token2 => 'PROCESS_NAME',
940: p_token2_value => l_proc_name);
941:
942: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
943: p_msg_name => 'OKC_OUTCOME_FAILURE',
944: p_token1 => 'CONTRACT_NUMBER',
945: p_token1_value => l_contract_number,
946: p_token2 => 'PROCESS_NAME',

Line 1580: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1576: p_extra_attr_date IN DATE
1577: ) is
1578:
1579: l_api_name CONSTANT VARCHAR2(30) := 'RESOLVER_CALL';
1580: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1581: l_key varchar2(100);
1582: --
1583: l_proc varchar2(72) := ' OKC_ASYNC_PVT.'||'resolver_call';
1584: --

Line 1593: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

1589: okc_debug.Set_Indentation(l_proc);
1590: okc_debug.Log('10: Entering ',2);
1591: END IF;
1592:
1593: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1594: G_PKG_NAME,
1595: p_init_msg_list,
1596: l_api_version,
1597: p_api_version,

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

1596: l_api_version,
1597: p_api_version,
1598: G_LEVEL,
1599: x_return_status);
1600: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1603: RAISE OKC_API.G_EXCEPTION_ERROR;
1604: END IF;

Line 1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1597: p_api_version,
1598: G_LEVEL,
1599: x_return_status);
1600: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1603: RAISE OKC_API.G_EXCEPTION_ERROR;
1604: END IF;
1605:

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

1598: G_LEVEL,
1599: x_return_status);
1600: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1603: RAISE OKC_API.G_EXCEPTION_ERROR;
1604: END IF;
1605:
1606: --

Line 1603: RAISE OKC_API.G_EXCEPTION_ERROR;

1599: x_return_status);
1600: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1603: RAISE OKC_API.G_EXCEPTION_ERROR;
1604: END IF;
1605:
1606: --
1607: -- create process

Line 1690: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1686: owner => fnd_global.user_name);
1687: wf_engine.StartProcess( itemtype => G_WF_NAME,
1688: itemkey => L_KEY);
1689: -- commit;
1690: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1691: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1692:
1693: IF (l_debug = 'Y') THEN
1694: okc_debug.Log('1000: Leaving ',2);

Line 1691: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1687: wf_engine.StartProcess( itemtype => G_WF_NAME,
1688: itemkey => L_KEY);
1689: -- commit;
1690: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1691: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1692:
1693: IF (l_debug = 'Y') THEN
1694: okc_debug.Log('1000: Leaving ',2);
1695: okc_debug.Reset_Indentation;

Line 1700: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1696: END IF;
1697:
1698:
1699: EXCEPTION
1700: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1701: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1702: (substr(l_api_name,1,26),
1703: G_PKG_NAME,
1704: 'OKC_API.G_RET_STS_ERROR',

Line 1701: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1697:
1698:
1699: EXCEPTION
1700: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1701: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1702: (substr(l_api_name,1,26),
1703: G_PKG_NAME,
1704: 'OKC_API.G_RET_STS_ERROR',
1705: x_msg_count,

Line 1704: 'OKC_API.G_RET_STS_ERROR',

1700: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1701: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1702: (substr(l_api_name,1,26),
1703: G_PKG_NAME,
1704: 'OKC_API.G_RET_STS_ERROR',
1705: x_msg_count,
1706: x_msg_data,
1707: G_LEVEL);
1708: IF (l_debug = 'Y') THEN

Line 1712: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1708: IF (l_debug = 'Y') THEN
1709: okc_debug.Log('3000: Leaving ',2);
1710: okc_debug.Reset_Indentation;
1711: END IF;
1712: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1713: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1714: (substr(l_api_name,1,26),
1715: G_PKG_NAME,
1716: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1713: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1709: okc_debug.Log('3000: Leaving ',2);
1710: okc_debug.Reset_Indentation;
1711: END IF;
1712: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1713: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1714: (substr(l_api_name,1,26),
1715: G_PKG_NAME,
1716: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1717: x_msg_count,

Line 1716: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1712: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1713: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1714: (substr(l_api_name,1,26),
1715: G_PKG_NAME,
1716: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1717: x_msg_count,
1718: x_msg_data,
1719: G_LEVEL);
1720: IF (l_debug = 'Y') THEN

Line 1725: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1721: okc_debug.Log('4000: Leaving ',2);
1722: okc_debug.Reset_Indentation;
1723: END IF;
1724: WHEN OTHERS THEN
1725: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1726: (substr(l_api_name,1,26),
1727: G_PKG_NAME,
1728: 'OTHERS',
1729: x_msg_count,

Line 1987: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1983: p_extra_attr_text IN VARCHAR2 ,
1984: p_extra_attr_date IN DATE
1985: ) is
1986: l_api_name CONSTANT VARCHAR2(30) := 'LOOP_CALL';
1987: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1988: l_key varchar2(100);
1989:
1990: --
1991: CURSOR c_wf_timeout IS

Line 2031: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

2027: okc_debug.Log('20: p_extra_attr_text : '||p_extra_attr_text,2);
2028: okc_debug.Log('20: p_extra_attr_date : '||p_extra_attr_date,2);
2029: END IF;
2030:
2031: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2032: G_PKG_NAME,
2033: p_init_msg_list,
2034: l_api_version,
2035: p_api_version,

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

2039: IF (l_debug = 'Y') THEN
2040: okc_debug.Log('30: l_return_status : '||l_return_status,2);
2041: END IF;
2042:
2043: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2045: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2046: RAISE OKC_API.G_EXCEPTION_ERROR;
2047: END IF;

Line 2044: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2040: okc_debug.Log('30: l_return_status : '||l_return_status,2);
2041: END IF;
2042:
2043: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2045: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2046: RAISE OKC_API.G_EXCEPTION_ERROR;
2047: END IF;
2048:

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

2041: END IF;
2042:
2043: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2045: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2046: RAISE OKC_API.G_EXCEPTION_ERROR;
2047: END IF;
2048:
2049: /* MSENGUPT: The following code is changed from the previous version to make it more effucient. ie. read c_wf_timeout only

Line 2046: RAISE OKC_API.G_EXCEPTION_ERROR;

2042:
2043: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2044: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2045: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2046: RAISE OKC_API.G_EXCEPTION_ERROR;
2047: END IF;
2048:
2049: /* MSENGUPT: The following code is changed from the previous version to make it more effucient. ie. read c_wf_timeout only
2050: if l_timeout_minutes from profile options is NULL...... very less likely */

Line 2172: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2168:
2169: wf_engine.StartProcess( itemtype => G_WF_NAME,
2170: itemkey => L_KEY);
2171: -- commit;
2172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2173: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2174:
2175: IF (l_debug = 'Y') THEN
2176: okc_debug.Log('60: x_return_status : '||x_return_status,2);

Line 2173: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2169: wf_engine.StartProcess( itemtype => G_WF_NAME,
2170: itemkey => L_KEY);
2171: -- commit;
2172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2173: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2174:
2175: IF (l_debug = 'Y') THEN
2176: okc_debug.Log('60: x_return_status : '||x_return_status,2);
2177: END IF;

Line 2187: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2183: END IF;
2184:
2185:
2186: EXCEPTION
2187: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2188: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2189: (substr(l_api_name,1,26),
2190: G_PKG_NAME,
2191: 'OKC_API.G_RET_STS_ERROR',

Line 2188: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2184:
2185:
2186: EXCEPTION
2187: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2188: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2189: (substr(l_api_name,1,26),
2190: G_PKG_NAME,
2191: 'OKC_API.G_RET_STS_ERROR',
2192: x_msg_count,

Line 2191: 'OKC_API.G_RET_STS_ERROR',

2187: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2188: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2189: (substr(l_api_name,1,26),
2190: G_PKG_NAME,
2191: 'OKC_API.G_RET_STS_ERROR',
2192: x_msg_count,
2193: x_msg_data,
2194: G_LEVEL);
2195: IF (l_debug = 'Y') THEN

Line 2199: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2195: IF (l_debug = 'Y') THEN
2196: okc_debug.Log('3000: Leaving ',2);
2197: okc_debug.Reset_Indentation;
2198: END IF;
2199: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2200: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2201: (substr(l_api_name,1,26),
2202: G_PKG_NAME,
2203: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2200: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2196: okc_debug.Log('3000: Leaving ',2);
2197: okc_debug.Reset_Indentation;
2198: END IF;
2199: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2200: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2201: (substr(l_api_name,1,26),
2202: G_PKG_NAME,
2203: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2204: x_msg_count,

Line 2203: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2199: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2200: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2201: (substr(l_api_name,1,26),
2202: G_PKG_NAME,
2203: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2204: x_msg_count,
2205: x_msg_data,
2206: G_LEVEL);
2207: IF (l_debug = 'Y') THEN

Line 2212: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2208: okc_debug.Log('4000: Leaving ',2);
2209: okc_debug.Reset_Indentation;
2210: END IF;
2211: WHEN OTHERS THEN
2212: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2213: (substr(l_api_name,1,26),
2214: G_PKG_NAME,
2215: 'OTHERS',
2216: x_msg_count,