137: G_PKG_NAME, '100: p_number : '||p_number );
138: END IF;
139:
140: If p_number > 3999 then
141: OKC_API.SET_MESSAGE('OKC','OKC_CANT_CONVERT_ROMAN');
142: RAISE FND_API.G_EXC_ERROR ;
143:
144: end if;
145:
234:
235: EXCEPTION
236: WHEN FND_API.G_EXC_ERROR THEN
237: /*IF (l_debug = 'Y') THEN
238: okc_debug.log('300: Leaving convert_to_roman: OKC_API.G_EXCEPTION_ERROR Exception', 2);
239: END IF;*/
240:
241: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
242: FND_LOG.STRING(G_EXCP_LEVEL,
239: END IF;*/
240:
241: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
242: FND_LOG.STRING(G_EXCP_LEVEL,
243: G_PKG_NAME, '300: Leaving convert_to_roman: OKC_API.G_EXCEPTION_ERROR Exception' );
244: END IF;
245:
246: raise;
247:
247:
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: /*IF (l_debug = 'Y') THEN
251: okc_debug.log('400: Leaving convert_to_roman: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
252: END IF;*/
253:
254: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
255: FND_LOG.STRING(G_EXCP_LEVEL,
252: END IF;*/
253:
254: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
255: FND_LOG.STRING(G_EXCP_LEVEL,
256: G_PKG_NAME, '400: Leaving convert_to_roman: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
257: END IF;
258:
259: raise;
260:
365: EXCEPTION
366:
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: /*IF (l_debug = 'Y') THEN
369: okc_debug.log('400: Leaving get_numbering_seq: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
370: END IF;*/
371:
372: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
373: FND_LOG.STRING(G_EXCP_LEVEL,
370: END IF;*/
371:
372: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
373: FND_LOG.STRING(G_EXCP_LEVEL,
374: G_PKG_NAME, '400: Leaving get_numbering_seq: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
375: END IF;
376:
377: raise;
378:
525: EXCEPTION
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: /*IF (l_debug = 'Y') THEN
529: okc_debug.log('400: Leaving section_numbering: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
530: END IF;*/
531:
532: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
533: FND_LOG.STRING(G_EXCP_LEVEL,
530: END IF;*/
531:
532: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
533: FND_LOG.STRING(G_EXCP_LEVEL,
534: G_PKG_NAME, '400: Leaving section_numbering: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
535: END IF;
536:
537: raise;
538:
656:
657: EXCEPTION
658: WHEN FND_API.G_EXC_ERROR THEN
659: /*IF (l_debug = 'Y') THEN
660: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);
661: END IF;*/
662:
663: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
664: FND_LOG.STRING(G_EXCP_LEVEL,
661: END IF;*/
662:
663: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
664: FND_LOG.STRING(G_EXCP_LEVEL,
665: G_PKG_NAME, '2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception' );
666: END IF;
667:
668: Rollback to g_generate_preview;
669: x_return_status := G_RET_STS_ERROR ;
670: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: /*IF (l_debug = 'Y') THEN
674: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);
675: END IF;*/
676:
677: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
678: FND_LOG.STRING(G_EXCP_LEVEL,
675: END IF;*/
676:
677: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
678: FND_LOG.STRING(G_EXCP_LEVEL,
679: G_PKG_NAME, '2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception' );
680: END IF;
681:
682: Rollback to g_generate_preview;
683: x_return_status := G_RET_STS_UNEXP_ERROR ;
684: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
685:
686: WHEN OTHERS THEN
687: /*IF (l_debug = 'Y') THEN
688: okc_debug.log('2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception', 2);
689: END IF;*/
690:
691: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
692: FND_LOG.STRING(G_EXCP_LEVEL,
689: END IF;*/
690:
691: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
692: FND_LOG.STRING(G_EXCP_LEVEL,
693: G_PKG_NAME, '2400: Leaving generate_preview: OKC_API.G_EXCEPTION_ERROR Exception' );
694: END IF;
695:
696: Rollback to g_generate_preview;
697: x_return_status := G_RET_STS_UNEXP_ERROR ;
1139: x_return_status => x_return_status,
1140: x_msg_count => x_msg_count,
1141: x_msg_data => x_msg_data,
1142: p_id => cr.id,
1143: p_label => OKC_API.G_MISS_CHAR,
1144: p_object_version_number => cr.object_version_number
1145: );
1146:
1147: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1281: END IF;
1282: EXCEPTION
1283: WHEN FND_API.G_EXC_ERROR THEN
1284: /*IF (l_debug = 'Y') THEN
1285: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1286: END IF;*/
1287:
1288: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1289: FND_LOG.STRING(G_EXCP_LEVEL,
1286: END IF;*/
1287:
1288: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1289: FND_LOG.STRING(G_EXCP_LEVEL,
1290: G_PKG_NAME, '2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception' );
1291: END IF;
1292:
1293: ROLLBACK TO g_apply_numbering_scheme;
1294: x_return_status := G_RET_STS_ERROR ;
1295: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1296:
1297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1298: /*IF (l_debug = 'Y') THEN
1299: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1300: END IF;*/
1301:
1302: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1303: FND_LOG.STRING(G_EXCP_LEVEL,
1300: END IF;*/
1301:
1302: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1303: FND_LOG.STRING(G_EXCP_LEVEL,
1304: G_PKG_NAME, '2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception' );
1305: END IF;
1306:
1307: ROLLBACK TO g_apply_numbering_scheme;
1308: x_return_status := G_RET_STS_UNEXP_ERROR ;
1309: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1310:
1311: WHEN OTHERS THEN
1312: /*IF (l_debug = 'Y') THEN
1313: okc_debug.log('2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1314: END IF;*/
1315:
1316: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1317: FND_LOG.STRING(G_EXCP_LEVEL,
1314: END IF;*/
1315:
1316: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1317: FND_LOG.STRING(G_EXCP_LEVEL,
1318: G_PKG_NAME, '2400: Leaving apply_numbering_scheme: OKC_API.G_EXCEPTION_ERROR Exception' );
1319: END IF;
1320:
1321: ROLLBACK TO g_apply_numbering_scheme;
1322: x_return_status := G_RET_STS_UNEXP_ERROR ;
1483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1484:
1485: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1486: FND_LOG.STRING(G_EXCP_LEVEL,
1487: G_PKG_NAME, '400: Leaving review_section_numbering: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1488: END IF;
1489:
1490: raise;
1491:
1824: WHEN FND_API.G_EXC_ERROR THEN
1825:
1826: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1827: FND_LOG.STRING(G_EXCP_LEVEL,
1828: G_PKG_NAME, '2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception' );
1829: END IF;
1830:
1831: ROLLBACK TO g_apply_num_scheme_4_Review;
1832: x_return_status := G_RET_STS_ERROR ;
1835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1836:
1837: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1838: FND_LOG.STRING(G_EXCP_LEVEL,
1839: G_PKG_NAME, '2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception' );
1840: END IF;
1841:
1842: ROLLBACK TO g_apply_num_scheme_4_Review;
1843: x_return_status := G_RET_STS_UNEXP_ERROR ;
1844: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1845:
1846: WHEN OTHERS THEN
1847: IF (l_debug = 'Y') THEN
1848: okc_debug.log('2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1849: END IF;
1850:
1851: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1852: FND_LOG.STRING(G_EXCP_LEVEL,
1849: END IF;
1850:
1851: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1852: FND_LOG.STRING(G_EXCP_LEVEL,
1853: G_PKG_NAME, '2400: Leaving apply_num_scheme_4_Review: OKC_API.G_EXCEPTION_ERROR Exception' );
1854: END IF;
1855:
1856: ROLLBACK TO g_apply_num_scheme_4_Review;
1857: x_return_status := G_RET_STS_UNEXP_ERROR ;