254: G_MODULE||l_api_name,
255: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
256: END IF;
257:
258: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
260: END IF;
261: x_return_status := G_RET_STS_UNEXP_ERROR ;
262: x_msg_data := SQLERRM;
255: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
256: END IF;
257:
258: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
260: END IF;
261: x_return_status := G_RET_STS_UNEXP_ERROR ;
262: x_msg_data := SQLERRM;
263: x_msg_count := 1;
580: g_Module || l_Api_Name,
581: '4000: Leaving ' || g_Pkg_Name || '.' || l_Api_Name);
582: END IF;
583:
584: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN
585: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);
586: END IF;
587: x_Return_Status := g_Ret_Sts_Unexp_Error;
588: x_msg_data := SQLERRM;
581: '4000: Leaving ' || g_Pkg_Name || '.' || l_Api_Name);
582: END IF;
583:
584: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN
585: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);
586: END IF;
587: x_Return_Status := g_Ret_Sts_Unexp_Error;
588: x_msg_data := SQLERRM;
589: x_msg_count := 1;
586: END IF;
587: x_Return_Status := g_Ret_Sts_Unexp_Error;
588: x_msg_data := SQLERRM;
589: x_msg_count := 1;
590: Fnd_Msg_Pub.Count_And_Get(p_Encoded => 'F',
591: p_Count => x_Msg_Count,
592: p_Data => x_Msg_Data);
593:
594: END check_circular_dependency;
787: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
788: END IF;
789:
790: x_return_status := G_RET_STS_ERROR ;
791: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
792:
793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
794: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
797: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
798: END IF;
799:
800: x_return_status := G_RET_STS_UNEXP_ERROR ;
801: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
802:
803: WHEN OTHERS THEN
804: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
805: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
806: G_MODULE||l_api_name,
807: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
808: END IF;
809:
810: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
811: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
812: END IF;
813: x_return_status := G_RET_STS_UNEXP_ERROR ;
814: x_msg_data := SQLERRM;
807: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
808: END IF;
809:
810: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
811: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
812: END IF;
813: x_return_status := G_RET_STS_UNEXP_ERROR ;
814: x_msg_data := SQLERRM;
815: x_msg_count := 1;
812: END IF;
813: x_return_status := G_RET_STS_UNEXP_ERROR ;
814: x_msg_data := SQLERRM;
815: x_msg_count := 1;
816: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
817:
818: END check_expired_clauses;
819:
820: ---------------------------------------------------
968: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
969: END IF;
970:
971: x_return_status := G_RET_STS_ERROR ;
972: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
973:
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
976: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
978: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
979: END IF;
980:
981: x_return_status := G_RET_STS_UNEXP_ERROR ;
982: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
983:
984: WHEN OTHERS THEN
985: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
986: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
987: G_MODULE||l_api_name,
988: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
989: END IF;
990:
991: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
992: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
993: END IF;
994: x_return_status := G_RET_STS_UNEXP_ERROR ;
995: x_msg_data := SQLERRM;
988: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
989: END IF;
990:
991: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
992: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
993: END IF;
994: x_return_status := G_RET_STS_UNEXP_ERROR ;
995: x_msg_data := SQLERRM;
996: x_msg_count := 1;
993: END IF;
994: x_return_status := G_RET_STS_UNEXP_ERROR ;
995: x_msg_data := SQLERRM;
996: x_msg_count := 1;
997: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
998:
999: END check_draft_clauses;
1000:
1001: ---------------------------------------------------
1384: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1385: END IF;
1386:
1387: x_return_status := G_RET_STS_ERROR ;
1388: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1389:
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1392: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1394: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1395: END IF;
1396:
1397: x_return_status := G_RET_STS_UNEXP_ERROR ;
1398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1399:
1400: WHEN OTHERS THEN
1401: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1402: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1403: G_MODULE||l_api_name,
1404: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1405: END IF;
1406:
1407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1409: END IF;
1410: x_return_status := G_RET_STS_UNEXP_ERROR ;
1411: x_msg_data := SQLERRM;
1404: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1405: END IF;
1406:
1407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1409: END IF;
1410: x_return_status := G_RET_STS_UNEXP_ERROR ;
1411: x_msg_data := SQLERRM;
1412: x_msg_count := 1;
1409: END IF;
1410: x_return_status := G_RET_STS_UNEXP_ERROR ;
1411: x_msg_data := SQLERRM;
1412: x_msg_count := 1;
1413: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1414:
1415: END check_invalid_vset_qst;
1416:
1417:
1868: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1869: END IF;
1870:
1871: x_return_status := G_RET_STS_ERROR ;
1872: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1873:
1874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1875: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1878: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1879: END IF;
1880:
1881: x_return_status := G_RET_STS_UNEXP_ERROR ;
1882: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1883:
1884: WHEN OTHERS THEN
1885: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1886: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1887: G_MODULE||l_api_name,
1888: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1889: END IF;
1890:
1891: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1892: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1893: END IF;
1894: x_return_status := G_RET_STS_UNEXP_ERROR ;
1895: x_msg_data := SQLERRM;
1888: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1889: END IF;
1890:
1891: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1892: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1893: END IF;
1894: x_return_status := G_RET_STS_UNEXP_ERROR ;
1895: x_msg_data := SQLERRM;
1896: x_msg_count := 1;
1893: END IF;
1894: x_return_status := G_RET_STS_UNEXP_ERROR ;
1895: x_msg_data := SQLERRM;
1896: x_msg_count := 1;
1897: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1898:
1899: END check_invalid_vset_var;
1900:
1901: ---------------------------------------------------
2018: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2019: END IF;
2020:
2021: x_return_status := G_RET_STS_ERROR ;
2022: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2023:
2024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2025: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2026: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2028: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2029: END IF;
2030:
2031: x_return_status := G_RET_STS_UNEXP_ERROR ;
2032: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2033:
2034: WHEN OTHERS THEN
2035: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2037: G_MODULE||l_api_name,
2038: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2039: END IF;
2040:
2041: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2042: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2043: END IF;
2044: x_return_status := G_RET_STS_UNEXP_ERROR ;
2045: x_msg_data := SQLERRM;
2038: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2039: END IF;
2040:
2041: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2042: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2043: END IF;
2044: x_return_status := G_RET_STS_UNEXP_ERROR ;
2045: x_msg_data := SQLERRM;
2046: x_msg_count := 1;
2043: END IF;
2044: x_return_status := G_RET_STS_UNEXP_ERROR ;
2045: x_msg_data := SQLERRM;
2046: x_msg_count := 1;
2047: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2048:
2049: END check_invalid_questions;
2050:
2051: ---------------------------------------------------
2156: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2157: END IF;
2158:
2159: x_return_status := G_RET_STS_ERROR ;
2160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2161:
2162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2166: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2167: END IF;
2168:
2169: x_return_status := G_RET_STS_UNEXP_ERROR ;
2170: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2171:
2172: WHEN OTHERS THEN
2173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2175: G_MODULE||l_api_name,
2176: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2177: END IF;
2178:
2179: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2180: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2181: END IF;
2182: x_return_status := G_RET_STS_UNEXP_ERROR ;
2183: x_msg_data := SQLERRM;
2176: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2177: END IF;
2178:
2179: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2180: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2181: END IF;
2182: x_return_status := G_RET_STS_UNEXP_ERROR ;
2183: x_msg_data := SQLERRM;
2184: x_msg_count := 1;
2181: END IF;
2182: x_return_status := G_RET_STS_UNEXP_ERROR ;
2183: x_msg_data := SQLERRM;
2184: x_msg_count := 1;
2185: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2186:
2187: END check_rule_templates;
2188:
2189:
2422: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2423: END IF;
2424:
2425: x_return_status := G_RET_STS_ERROR ;
2426: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2427:
2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2429: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2432: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2433: END IF;
2434:
2435: x_return_status := G_RET_STS_UNEXP_ERROR ;
2436: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2437:
2438: WHEN OTHERS THEN
2439: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2441: G_MODULE||l_api_name,
2442: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2443: END IF;
2444:
2445: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2446: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2447: END IF;
2448: x_return_status := G_RET_STS_UNEXP_ERROR ;
2449: x_msg_data := SQLERRM;
2442: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2443: END IF;
2444:
2445: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2446: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2447: END IF;
2448: x_return_status := G_RET_STS_UNEXP_ERROR ;
2449: x_msg_data := SQLERRM;
2450: x_msg_count := 1;
2447: END IF;
2448: x_return_status := G_RET_STS_UNEXP_ERROR ;
2449: x_msg_data := SQLERRM;
2450: x_msg_count := 1;
2451: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2452:
2453: END check_invalid_udv_procedure;
2454:
2455:
2841: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2842: END IF;
2843:
2844: x_return_status := G_RET_STS_ERROR ;
2845: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2846:
2847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2851: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2852: END IF;
2853:
2854: x_return_status := G_RET_STS_UNEXP_ERROR ;
2855: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2856:
2857: WHEN OTHERS THEN
2858: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2859: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2860: G_MODULE||l_api_name,
2861: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2862: END IF;
2863:
2864: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2866: END IF;
2867: x_return_status := G_RET_STS_UNEXP_ERROR ;
2868: x_msg_data := SQLERRM;
2861: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2862: END IF;
2863:
2864: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2866: END IF;
2867: x_return_status := G_RET_STS_UNEXP_ERROR ;
2868: x_msg_data := SQLERRM;
2869: x_msg_count := 1;
2866: END IF;
2867: x_return_status := G_RET_STS_UNEXP_ERROR ;
2868: x_msg_data := SQLERRM;
2869: x_msg_count := 1;
2870: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2871:
2872: END qa_rules;
2873:
2874: /*
3003: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3004: END IF;
3005:
3006: x_return_status := G_RET_STS_ERROR ;
3007: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3008:
3009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3010: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3011: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3013: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3014: END IF;
3015:
3016: x_return_status := G_RET_STS_UNEXP_ERROR ;
3017: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3018:
3019: WHEN OTHERS THEN
3020: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3021: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3022: G_MODULE||l_api_name,
3023: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3024: END IF;
3025:
3026: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3027: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3028: END IF;
3029: x_return_status := G_RET_STS_UNEXP_ERROR ;
3030: x_msg_data := SQLERRM;
3023: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3024: END IF;
3025:
3026: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3027: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3028: END IF;
3029: x_return_status := G_RET_STS_UNEXP_ERROR ;
3030: x_msg_data := SQLERRM;
3031: x_msg_count := 1;
3028: END IF;
3029: x_return_status := G_RET_STS_UNEXP_ERROR ;
3030: x_msg_data := SQLERRM;
3031: x_msg_count := 1;
3032: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3033:
3034: END sync_rules;
3035:
3036: END OKC_XPRT_QA_PVT ;