DBA Data[Home] [Help]

APPS.OKC_XPRT_QA_PVT dependencies on FND_MSG_PUB

Line 258: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 259: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 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;
263: x_msg_count := 1;

Line 584: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN

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;

Line 585: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, 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;
589: x_msg_count := 1;

Line 590: Fnd_Msg_Pub.Count_And_Get(p_Encoded => 'F',

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;

Line 791: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 801: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 810: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 811: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 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;
815: x_msg_count := 1;

Line 816: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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: ---------------------------------------------------

Line 972: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 982: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 991: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 992: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 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;
996: x_msg_count := 1;

Line 997: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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: ---------------------------------------------------

Line 1388: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 1398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 1407: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 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;
1412: x_msg_count := 1;

Line 1413: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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:

Line 1872: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 1882: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 1891: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 1892: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 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;
1896: x_msg_count := 1;

Line 1897: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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: ---------------------------------------------------

Line 2022: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 2032: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 2041: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 2042: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 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;
2046: x_msg_count := 1;

Line 2047: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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: ---------------------------------------------------

Line 2160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 2170: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 2179: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 2180: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 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;
2184: x_msg_count := 1;

Line 2185: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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:

Line 2426: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 2436: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 2445: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 2446: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 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;
2450: x_msg_count := 1;

Line 2451: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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:

Line 2845: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 2855: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 2864: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 2865: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 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;
2869: x_msg_count := 1;

Line 2870: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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: /*

Line 3007: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 3017: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ,

Line 3026: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

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;

Line 3027: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, 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;
3031: x_msg_count := 1;

Line 3032: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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 ;