DBA Data[Home] [Help]

APPS.OKC_XPRT_QA_PVT dependencies on FND_MSG_PUB

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

292: G_MODULE||l_api_name,
293: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
294: END IF;
295:
296: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
297: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
298: END IF;
299: x_return_status := G_RET_STS_UNEXP_ERROR ;
300: x_msg_data := SQLERRM;

Line 297: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

293: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
294: END IF;
295:
296: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
297: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
298: END IF;
299: x_return_status := G_RET_STS_UNEXP_ERROR ;
300: x_msg_data := SQLERRM;
301: x_msg_count := 1;

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

618: g_Module || l_Api_Name,
619: '4000: Leaving ' || g_Pkg_Name || '.' || l_Api_Name);
620: END IF;
621:
622: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN
623: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);
624: END IF;
625: x_Return_Status := g_Ret_Sts_Unexp_Error;
626: x_msg_data := SQLERRM;

Line 623: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);

619: '4000: Leaving ' || g_Pkg_Name || '.' || l_Api_Name);
620: END IF;
621:
622: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN
623: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);
624: END IF;
625: x_Return_Status := g_Ret_Sts_Unexp_Error;
626: x_msg_data := SQLERRM;
627: x_msg_count := 1;

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

624: END IF;
625: x_Return_Status := g_Ret_Sts_Unexp_Error;
626: x_msg_data := SQLERRM;
627: x_msg_count := 1;
628: Fnd_Msg_Pub.Count_And_Get(p_Encoded => 'F',
629: p_Count => x_Msg_Count,
630: p_Data => x_Msg_Data);
631:
632: END check_circular_dependency;

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

846: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
847: END IF;
848:
849: x_return_status := G_RET_STS_ERROR ;
850: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
851:
852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
853: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
854: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

856: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
857: END IF;
858:
859: x_return_status := G_RET_STS_UNEXP_ERROR ;
860: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
861:
862: WHEN OTHERS THEN
863: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

865: G_MODULE||l_api_name,
866: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
867: END IF;
868:
869: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
870: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
871: END IF;
872: x_return_status := G_RET_STS_UNEXP_ERROR ;
873: x_msg_data := SQLERRM;

Line 870: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

866: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
867: END IF;
868:
869: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
870: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
871: END IF;
872: x_return_status := G_RET_STS_UNEXP_ERROR ;
873: x_msg_data := SQLERRM;
874: x_msg_count := 1;

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

871: END IF;
872: x_return_status := G_RET_STS_UNEXP_ERROR ;
873: x_msg_data := SQLERRM;
874: x_msg_count := 1;
875: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
876:
877: END check_expired_clauses;
878:
879: ---------------------------------------------------

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

1039: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1040: END IF;
1041:
1042: x_return_status := G_RET_STS_ERROR ;
1043: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1044:
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1047: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

1049: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1050: END IF;
1051:
1052: x_return_status := G_RET_STS_UNEXP_ERROR ;
1053: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1054:
1055: WHEN OTHERS THEN
1056: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1057: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

1058: G_MODULE||l_api_name,
1059: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1060: END IF;
1061:
1062: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1063: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1064: END IF;
1065: x_return_status := G_RET_STS_UNEXP_ERROR ;
1066: x_msg_data := SQLERRM;

Line 1063: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1059: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1060: END IF;
1061:
1062: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1063: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1064: END IF;
1065: x_return_status := G_RET_STS_UNEXP_ERROR ;
1066: x_msg_data := SQLERRM;
1067: x_msg_count := 1;

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

1064: END IF;
1065: x_return_status := G_RET_STS_UNEXP_ERROR ;
1066: x_msg_data := SQLERRM;
1067: x_msg_count := 1;
1068: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1069:
1070: END check_draft_clauses;
1071:
1072: ---------------------------------------------------

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

1455: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1456: END IF;
1457:
1458: x_return_status := G_RET_STS_ERROR ;
1459: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1460:
1461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1462: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

1465: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1466: END IF;
1467:
1468: x_return_status := G_RET_STS_UNEXP_ERROR ;
1469: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1470:
1471: WHEN OTHERS THEN
1472: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1473: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

1474: G_MODULE||l_api_name,
1475: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1476: END IF;
1477:
1478: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1480: END IF;
1481: x_return_status := G_RET_STS_UNEXP_ERROR ;
1482: x_msg_data := SQLERRM;

Line 1479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1475: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1476: END IF;
1477:
1478: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1480: END IF;
1481: x_return_status := G_RET_STS_UNEXP_ERROR ;
1482: x_msg_data := SQLERRM;
1483: x_msg_count := 1;

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

1480: END IF;
1481: x_return_status := G_RET_STS_UNEXP_ERROR ;
1482: x_msg_data := SQLERRM;
1483: x_msg_count := 1;
1484: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1485:
1486: END check_invalid_vset_qst;
1487:
1488:

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

1939: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1940: END IF;
1941:
1942: x_return_status := G_RET_STS_ERROR ;
1943: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1944:
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

1949: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1950: END IF;
1951:
1952: x_return_status := G_RET_STS_UNEXP_ERROR ;
1953: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1954:
1955: WHEN OTHERS THEN
1956: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1957: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

1958: G_MODULE||l_api_name,
1959: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1960: END IF;
1961:
1962: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1963: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1964: END IF;
1965: x_return_status := G_RET_STS_UNEXP_ERROR ;
1966: x_msg_data := SQLERRM;

Line 1963: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1959: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1960: END IF;
1961:
1962: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1963: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1964: END IF;
1965: x_return_status := G_RET_STS_UNEXP_ERROR ;
1966: x_msg_data := SQLERRM;
1967: x_msg_count := 1;

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

1964: END IF;
1965: x_return_status := G_RET_STS_UNEXP_ERROR ;
1966: x_msg_data := SQLERRM;
1967: x_msg_count := 1;
1968: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1969:
1970: END check_invalid_vset_var;
1971:
1972: ---------------------------------------------------

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

2089: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2090: END IF;
2091:
2092: x_return_status := G_RET_STS_ERROR ;
2093: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2094:
2095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2096: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2097: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2099: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2100: END IF;
2101:
2102: x_return_status := G_RET_STS_UNEXP_ERROR ;
2103: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2104:
2105: WHEN OTHERS THEN
2106: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2107: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2108: G_MODULE||l_api_name,
2109: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2110: END IF;
2111:
2112: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2114: END IF;
2115: x_return_status := G_RET_STS_UNEXP_ERROR ;
2116: x_msg_data := SQLERRM;

Line 2113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2109: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2110: END IF;
2111:
2112: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2113: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2114: END IF;
2115: x_return_status := G_RET_STS_UNEXP_ERROR ;
2116: x_msg_data := SQLERRM;
2117: x_msg_count := 1;

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

2114: END IF;
2115: x_return_status := G_RET_STS_UNEXP_ERROR ;
2116: x_msg_data := SQLERRM;
2117: x_msg_count := 1;
2118: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2119:
2120: END check_invalid_questions;
2121:
2122: ---------------------------------------------------

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

2227: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2228: END IF;
2229:
2230: x_return_status := G_RET_STS_ERROR ;
2231: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2232:
2233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2237: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2238: END IF;
2239:
2240: x_return_status := G_RET_STS_UNEXP_ERROR ;
2241: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2242:
2243: WHEN OTHERS THEN
2244: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2245: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2246: G_MODULE||l_api_name,
2247: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2248: END IF;
2249:
2250: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2252: END IF;
2253: x_return_status := G_RET_STS_UNEXP_ERROR ;
2254: x_msg_data := SQLERRM;

Line 2251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2247: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2248: END IF;
2249:
2250: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2252: END IF;
2253: x_return_status := G_RET_STS_UNEXP_ERROR ;
2254: x_msg_data := SQLERRM;
2255: x_msg_count := 1;

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

2252: END IF;
2253: x_return_status := G_RET_STS_UNEXP_ERROR ;
2254: x_msg_data := SQLERRM;
2255: x_msg_count := 1;
2256: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2257:
2258: END check_rule_templates;
2259:
2260:

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

2493: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2494: END IF;
2495:
2496: x_return_status := G_RET_STS_ERROR ;
2497: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2498:
2499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2500: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2501: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2503: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2504: END IF;
2505:
2506: x_return_status := G_RET_STS_UNEXP_ERROR ;
2507: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2508:
2509: WHEN OTHERS THEN
2510: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2511: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2512: G_MODULE||l_api_name,
2513: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2514: END IF;
2515:
2516: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2517: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2518: END IF;
2519: x_return_status := G_RET_STS_UNEXP_ERROR ;
2520: x_msg_data := SQLERRM;

Line 2517: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2513: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2514: END IF;
2515:
2516: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2517: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2518: END IF;
2519: x_return_status := G_RET_STS_UNEXP_ERROR ;
2520: x_msg_data := SQLERRM;
2521: x_msg_count := 1;

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

2518: END IF;
2519: x_return_status := G_RET_STS_UNEXP_ERROR ;
2520: x_msg_data := SQLERRM;
2521: x_msg_count := 1;
2522: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2523:
2524: END check_invalid_udv_procedure;
2525:
2526:

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

2918: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2919: END IF;
2920:
2921: x_return_status := G_RET_STS_ERROR ;
2922: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2923:
2924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2925: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2926: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2928: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2929: END IF;
2930:
2931: x_return_status := G_RET_STS_UNEXP_ERROR ;
2932: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2933:
2934: WHEN OTHERS THEN
2935: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2936: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2937: G_MODULE||l_api_name,
2938: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2939: END IF;
2940:
2941: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2942: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2943: END IF;
2944: x_return_status := G_RET_STS_UNEXP_ERROR ;
2945: x_msg_data := SQLERRM;

Line 2942: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

2938: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2939: END IF;
2940:
2941: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2942: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2943: END IF;
2944: x_return_status := G_RET_STS_UNEXP_ERROR ;
2945: x_msg_data := SQLERRM;
2946: x_msg_count := 1;

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

2943: END IF;
2944: x_return_status := G_RET_STS_UNEXP_ERROR ;
2945: x_msg_data := SQLERRM;
2946: x_msg_count := 1;
2947: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2948:
2949: END qa_rules;
2950:
2951: /*

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

3090: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3091: END IF;
3092:
3093: x_return_status := G_RET_STS_ERROR ;
3094: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3095:
3096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3098: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

3100: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3101: END IF;
3102:
3103: x_return_status := G_RET_STS_UNEXP_ERROR ;
3104: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3105:
3106: WHEN OTHERS THEN
3107: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3108: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

3109: G_MODULE||l_api_name,
3110: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3111: END IF;
3112:
3113: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3115: END IF;
3116: x_return_status := G_RET_STS_UNEXP_ERROR ;
3117: x_msg_data := SQLERRM;

Line 3114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

3110: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3111: END IF;
3112:
3113: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
3115: END IF;
3116: x_return_status := G_RET_STS_UNEXP_ERROR ;
3117: x_msg_data := SQLERRM;
3118: x_msg_count := 1;

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

3115: END IF;
3116: x_return_status := G_RET_STS_UNEXP_ERROR ;
3117: x_msg_data := SQLERRM;
3118: x_msg_count := 1;
3119: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3120:
3121: END sync_rules;
3122:
3123: END OKC_XPRT_QA_PVT ;