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.OKS_CHANGE_STATUS_PVT dependencies on OKS_CHANGE_STATUS_PVT

Line 1: PACKAGE BODY OKS_CHANGE_STATUS_PVT as

1: PACKAGE BODY OKS_CHANGE_STATUS_PVT as
2: /* $Header: OKSVCSTB.pls 120.27.12010000.2 2008/10/22 12:51:35 ssreekum ship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL MESSAGE CONSTANTS
5: ---------------------------------------------------------------------------

Line 10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_CHANGE_STATUS_PVT';

6: G_FND_APP CONSTANT VARCHAR2(200) := 'OKS';
7: ---------------------------------------------------------------------------
8: -- GLOBAL CONSTANTS
9: ---------------------------------------------------------------------------
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_CHANGE_STATUS_PVT';
11: G_MODULE CONSTANT VARCHAR2(200) := 'oks.plsql.'||G_PKG_NAME||'.';
12: G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
13: ------------------------------------------------------------------------------
14: -- GLOBAL CONSTANTS

Line 90: OKS_CHANGE_STATUS_PVT.check_allowed_status(x_return_status => x_return_status,

86: 'new_sts_code - '||l_new_sts_code ||
87: 'old_sts_code - '||l_old_sts_code );
88: END IF;
89:
90: OKS_CHANGE_STATUS_PVT.check_allowed_status(x_return_status => x_return_status,
91: x_msg_count => x_msg_count,
92: x_msg_data => x_msg_data,
93: p_id => p_id,
94: p_old_sts_code => l_old_sts_code,

Line 167: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

163: WHEN FND_API.G_EXC_ERROR THEN
164: x_return_status := FND_API.G_RET_STS_ERROR;
165:
166: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
167: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'180: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
168: END IF;
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 174: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'190: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172:
173: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'190: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
175: END IF;
176:
177: WHEN OTHERS THEN
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 181: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'200: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

177: WHEN OTHERS THEN
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
179:
180: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
181: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'200: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
182: END IF;
183:
184: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
185: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

Line 341: '440: Calling oks_change_status_pvt.update_line_status ');

337: end if;
338:
339: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
341: '440: Calling oks_change_status_pvt.update_line_status ');
342: END IF;
343:
344: OKS_CHANGE_STATUS_PVT.update_line_status(
345: x_return_status => x_return_status,

Line 344: OKS_CHANGE_STATUS_PVT.update_line_status(

340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
341: '440: Calling oks_change_status_pvt.update_line_status ');
342: END IF;
343:
344: OKS_CHANGE_STATUS_PVT.update_line_status(
345: x_return_status => x_return_status,
346: x_msg_data => x_msg_data,
347: x_msg_count => x_msg_count,
348: p_init_msg_list => l_init_msg_list,

Line 500: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');

496: WHEN FND_API.G_EXC_ERROR THEN
497: x_return_status := FND_API.G_RET_STS_ERROR ;
498:
499: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');
501: END IF;
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 507: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
505:
506: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
507: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
508: END IF;
509:
510: WHEN OTHERS THEN
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 514: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

510: WHEN OTHERS THEN
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
512:
513: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
514: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
515: END IF;
516:
517: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

Line 619: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');

615: EXCEPTION
616: WHEN FND_API.G_EXC_ERROR THEN
617: x_return_status := FND_API.G_RET_STS_ERROR ;
618: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
619: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
620: END IF;
621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
622:
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 626: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'310: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

622:
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
625: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'310: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
627: END IF;
628: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
629:
630: WHEN OKC_API.G_EXC_WARNING THEN

Line 633: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'320: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');

629:
630: WHEN OKC_API.G_EXC_WARNING THEN
631: x_return_status := OKC_API.G_RET_STS_WARNING;
632: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
633: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'320: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');
634: END IF;
635:
636: WHEN OTHERS THEN
637: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 638: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'330: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

634: END IF;
635:
636: WHEN OTHERS THEN
637: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
638: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'330: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
639: END IF;
640:
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
642: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 1696: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'740: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');

1692: EXCEPTION
1693: WHEN FND_API.G_EXC_ERROR THEN
1694: x_return_status := FND_API.G_RET_STS_ERROR;
1695: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1696: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'740: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1697: END IF;
1698: if (c_lines%ISOPEN) then
1699: close c_lines;
1700: end if;

Line 1706: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'750: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);

1702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704:
1705: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1706: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'750: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_UNEXPECTED_ERROR '||SQLERRM);
1707: END IF;
1708:
1709: if (c_lines%ISOPEN) then
1710: close c_lines;

Line 1717: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'760: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');

1713: WHEN OKC_API.G_EXC_WARNING then
1714: x_return_status := OKC_API.G_RET_STS_WARNING;
1715:
1716: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1717: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'760: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');
1718: END IF;
1719:
1720: if(c_lines%ISOPEN) then
1721: close c_lines;

Line 1726: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'770: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

1722: end if;
1723:
1724: WHEN OTHERS THEN
1725: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1726: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'770: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
1727: END IF;
1728:
1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1730: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 1865: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');

1861:
1862: WHEN FND_API.G_EXC_ERROR then
1863: x_return_status := FND_API.G_RET_STS_ERROR;
1864: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1865: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1866: END IF;
1867:
1868: WHEN NO_DATA_FOUND then
1869: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1874: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT : NO_DATA_FOUND');

1870: FND_MESSAGE.set_name('OKS','OKS_CHANGE_STAT_NOT_ALLOWED'); -- set the message here
1871: fnd_msg_pub.add;
1872:
1873: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1874: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT : NO_DATA_FOUND');
1875: END IF;
1876:
1877: WHEN OTHERS then
1878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1880: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'520: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

1876:
1877: WHEN OTHERS then
1878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1879: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1880: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'520: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
1881: END IF;
1882:
1883: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1884: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

Line 2261: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

2257: WHEN FND_API.G_EXC_ERROR THEN
2258: x_return_status := FND_API.G_RET_STS_ERROR;
2259:
2260: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2261: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2262: END IF;
2263:
2264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2268: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1310: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

2264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2266:
2267: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2268: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1310: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2269: END IF;
2270:
2271: WHEN OTHERS THEN
2272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2275: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1320: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

2271: WHEN OTHERS THEN
2272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2273:
2274: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2275: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1320: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
2276: END IF;
2277:
2278: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

Line 2387: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');

2383: WHEN FND_API.G_EXC_ERROR THEN
2384: x_return_status := FND_API.G_RET_STS_ERROR;
2385:
2386: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2387: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1170: Leaving OKS_CHANGE_STATUS_PVT, one or more mandatory parameters missing :FND_API.G_EXC_ERROR');
2388: END IF;
2389:
2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2394: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1180: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);

2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2392:
2393: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2394: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1180: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_UNEXPECTED_ERROR '|| SQLERRM);
2395: END IF;
2396:
2397: WHEN OTHERS THEN
2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2401: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1190: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);

2397: WHEN OTHERS THEN
2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2399:
2400: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2401: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1190: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
2402: END IF;
2403:
2404: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2405: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

Line 2458: end oks_change_status_pvt;

2454:
2455:
2456: ---
2457:
2458: end oks_change_status_pvt;