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.38.12020000.2 2012/07/03 05:42:35 spingali 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 121: OKS_CHANGE_STATUS_PVT.check_allowed_status(x_return_status => x_return_status,

117: END IF;
118:
119: /*Added for bug 13024593*/
120:
121: OKS_CHANGE_STATUS_PVT.check_allowed_status(x_return_status => x_return_status,
122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,
124: p_id => p_id,
125: p_old_sts_code => l_old_sts_code,

Line 198: 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');

194: WHEN FND_API.G_EXC_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196:
197: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: 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');
199: END IF;
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 205: 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);

201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
203:
204: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: 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);
206: END IF;
207:
208: WHEN OTHERS THEN
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

208: WHEN OTHERS THEN
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
210:
211: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
212: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'200: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
213: END IF;
214:
215: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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

375: end if;
376:
377: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
378: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
379: '440: Calling oks_change_status_pvt.update_line_status ');
380: END IF;
381:
382: -- cgopinee bugfix for 9259068
383: IF (p_chrv_tbl(i).new_sts_code<>p_chrv_tbl(i).old_sts_code) THEN

Line 384: OKS_CHANGE_STATUS_PVT.G_HEADER_STATUS_CHANGED :='Y';

380: END IF;
381:
382: -- cgopinee bugfix for 9259068
383: IF (p_chrv_tbl(i).new_sts_code<>p_chrv_tbl(i).old_sts_code) THEN
384: OKS_CHANGE_STATUS_PVT.G_HEADER_STATUS_CHANGED :='Y';
385: END if;
386:
387: OKS_CHANGE_STATUS_PVT.update_line_status(
388: x_return_status => x_return_status,

Line 387: OKS_CHANGE_STATUS_PVT.update_line_status(

383: IF (p_chrv_tbl(i).new_sts_code<>p_chrv_tbl(i).old_sts_code) THEN
384: OKS_CHANGE_STATUS_PVT.G_HEADER_STATUS_CHANGED :='Y';
385: END if;
386:
387: OKS_CHANGE_STATUS_PVT.update_line_status(
388: x_return_status => x_return_status,
389: x_msg_data => x_msg_data,
390: x_msg_count => x_msg_count,
391: p_init_msg_list => l_init_msg_list,

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

539: WHEN FND_API.G_EXC_ERROR THEN
540: x_return_status := FND_API.G_RET_STS_ERROR ;
541:
542: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
543: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'490: Leaving OKS_CHANGE_STATUS_PVT: FND_API.G_EXC_ERROR');
544: END IF;
545:
546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 550: 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);

546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
548:
549: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
550: 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);
551: END IF;
552:
553: WHEN OTHERS THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

553: WHEN OTHERS THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
555:
556: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
558: END IF;
559:
560: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
561: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

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

658: EXCEPTION
659: WHEN FND_API.G_EXC_ERROR THEN
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
662: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
663: END IF;
664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 669: 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);

665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
668: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
669: 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);
670: END IF;
671: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
672:
673: WHEN OKC_API.G_EXC_WARNING THEN

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

672:
673: WHEN OKC_API.G_EXC_WARNING THEN
674: x_return_status := OKC_API.G_RET_STS_WARNING;
675: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
676: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'320: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');
677: END IF;
678:
679: WHEN OTHERS THEN
680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

677: END IF;
678:
679: WHEN OTHERS THEN
680: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'330: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
682: END IF;
683:
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
685: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 1390: IF OKS_CHANGE_STATUS_PVT.G_HEADER_STATUS_CHANGED <> 'Y' THEN

1386:
1387: l_clev_tbl(x_num).call_action_asmblr := 'N';
1388:
1389: --CGOPINEE BUGFIX FOR BUG9259068
1390: IF OKS_CHANGE_STATUS_PVT.G_HEADER_STATUS_CHANGED <> 'Y' THEN
1391: l_clev_tbl(x_num).call_action_asmblr := 'Y';
1392: END IF;
1393:
1394: if((p_validate_status = 'Y') and (p_cle_id IS NOT NULL)) then

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

1746: EXCEPTION
1747: WHEN FND_API.G_EXC_ERROR THEN
1748: x_return_status := FND_API.G_RET_STS_ERROR;
1749: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'740: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1751: END IF;
1752: if (c_lines%ISOPEN) then
1753: close c_lines;
1754: end if;

Line 1760: 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);

1756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758:
1759: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1760: 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);
1761: END IF;
1762:
1763: if (c_lines%ISOPEN) then
1764: close c_lines;

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

1767: WHEN OKC_API.G_EXC_WARNING then
1768: x_return_status := OKC_API.G_RET_STS_WARNING;
1769:
1770: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1771: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'760: Leaving OKS_CHANGE_STATUS_PVT : OKC_API.G_EXC_WARNING');
1772: END IF;
1773:
1774: if(c_lines%ISOPEN) then
1775: close c_lines;

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

1776: end if;
1777:
1778: WHEN OTHERS THEN
1779: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1780: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'770: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
1781: END IF;
1782:
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1784: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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

1917:
1918: WHEN FND_API.G_EXC_ERROR then
1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving OKS_CHANGE_STATUS_PVT : FND_API.G_EXC_ERROR');
1922: END IF;
1923:
1924: WHEN NO_DATA_FOUND then
1925: x_return_status := FND_API.G_RET_STS_ERROR;

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

1926: FND_MESSAGE.set_name('OKS','OKS_CHANGE_STAT_NOT_ALLOWED'); -- set the message here
1927: fnd_msg_pub.add;
1928:
1929: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1930: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'510: Leaving OKS_CHANGE_STATUS_PVT : NO_DATA_FOUND');
1931: END IF;
1932:
1933: WHEN OTHERS then
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1932:
1933: WHEN OTHERS then
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1936: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'520: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
1937: END IF;
1938:
1939: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1940: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

Line 2427: 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');

2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425:
2426: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2427: 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');
2428: END IF;
2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2434: 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);

2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2432:
2433: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2434: 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);
2435: END IF;
2436:
2437: WHEN OTHERS THEN
2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2437: WHEN OTHERS THEN
2438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2439:
2440: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2441: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1320: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
2442: END IF;
2443:
2444: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2445: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

Line 2553: 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');

2549: WHEN FND_API.G_EXC_ERROR THEN
2550: x_return_status := FND_API.G_RET_STS_ERROR;
2551:
2552: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2553: 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');
2554: END IF;
2555:
2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2560: 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);

2556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2558:
2559: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: 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);
2561: END IF;
2562:
2563: WHEN OTHERS THEN
2564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2563: WHEN OTHERS THEN
2564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2565:
2566: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2567: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1190: Leaving OKS_CHANGE_STATUS_PVT because of EXCEPTION: '||sqlerrm);
2568: END IF;
2569:
2570: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2571: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name, SQLERRM );

Line 2624: end oks_change_status_pvt;

2620:
2621:
2622: ---
2623:
2624: end oks_change_status_pvt;