APPS.OKC_XPRT_UTIL_PVT dependencies on FND_MSG_PUB

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

363: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
364: END IF;
365:
366: x_return_status := G_RET_STS_ERROR ;
367: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
368:
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

373: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
374: END IF;
375:
376: x_return_status := G_RET_STS_UNEXP_ERROR ;
377: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
378:
379: WHEN OTHERS THEN
380: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
381: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

382: G_MODULE||l_api_name,
383: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
384: END IF;
385:
386: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
388: END IF;
389: x_return_status := G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

383: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
384: END IF;
385:
386: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
388: END IF;
389: x_return_status := G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
391:

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

386: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
388: END IF;
389: x_return_status := G_RET_STS_UNEXP_ERROR ;
390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
391:
392: END check_import_status;
393:
394: ---------------------------------------------------

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

631: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
632: END IF;
633:
634: x_return_status := G_RET_STS_ERROR ;
635: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
636:
637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
638: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
639: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

641: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
642: END IF;
643:
644: x_return_status := G_RET_STS_UNEXP_ERROR ;
645: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
646:
647: WHEN OTHERS THEN
648: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
649: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

650: G_MODULE||l_api_name,
651: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
652: END IF;
653:
654: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
655: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
656: END IF;
657: x_return_status := G_RET_STS_UNEXP_ERROR ;
658: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

651: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
652: END IF;
653:
654: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
655: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
656: END IF;
657: x_return_status := G_RET_STS_UNEXP_ERROR ;
658: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
659:

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

654: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
655: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
656: END IF;
657: x_return_status := G_RET_STS_UNEXP_ERROR ;
658: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
659:
660: END delete_test_publications;
661:
662:

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

891: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
892: END IF;
893:
894: x_return_status := G_RET_STS_ERROR ;
895: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
899: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

901: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
902: END IF;
903:
904: x_return_status := G_RET_STS_UNEXP_ERROR ;
905: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
906:
907: WHEN OTHERS THEN
908: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
909: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

910: G_MODULE||l_api_name,
911: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
912: END IF;
913:
914: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
915: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
916: END IF;
917: x_return_status := G_RET_STS_UNEXP_ERROR ;
918: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

911: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
912: END IF;
913:
914: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
915: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
916: END IF;
917: x_return_status := G_RET_STS_UNEXP_ERROR ;
918: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
919:

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

914: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
915: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
916: END IF;
917: x_return_status := G_RET_STS_UNEXP_ERROR ;
918: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
919:
920: END create_test_publication;
921:
922: /*

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

1721: g_Module || l_Api_Name,
1722: '4000: Leaving ' || g_Pkg_Name || '.' || l_Api_Name);
1723: END IF;
1724:
1725: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN
1726: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);
1727: END IF;
1728: x_Return_Status := g_Ret_Sts_Unexp_Error;
1729: Fnd_Msg_Pub.Count_And_Get(p_Encoded => 'F',

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

1722: '4000: Leaving ' || g_Pkg_Name || '.' || l_Api_Name);
1723: END IF;
1724:
1725: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN
1726: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);
1727: END IF;
1728: x_Return_Status := g_Ret_Sts_Unexp_Error;
1729: Fnd_Msg_Pub.Count_And_Get(p_Encoded => 'F',
1730: p_Count => x_Msg_Count,

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

1725: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN
1726: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);
1727: END IF;
1728: x_Return_Status := g_Ret_Sts_Unexp_Error;
1729: Fnd_Msg_Pub.Count_And_Get(p_Encoded => 'F',
1730: p_Count => x_Msg_Count,
1731: p_Data => x_Msg_Data);
1732:
1733: END Populate_Questions_Order;

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

2142: ROLLBACK TO g_create_prod_publication;
2143: END IF;
2144:
2145: x_return_status := G_RET_STS_ERROR ;
2146: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2147:
2148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2149: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2156: ROLLBACK TO g_create_prod_publication;
2157: END IF;
2158:
2159: x_return_status := G_RET_STS_UNEXP_ERROR ;
2160: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2161:
2162: WHEN OTHERS THEN
2163: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

2169: IF (p_calling_mode = 'PUBLISH' OR p_calling_mode = 'DISABLE' OR p_calling_mode = 'SYNC') THEN
2170: ROLLBACK TO g_create_prod_publication;
2171: END IF;
2172:
2173: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2174: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2175: END IF;
2176: x_return_status := G_RET_STS_UNEXP_ERROR ;
2177: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

2170: ROLLBACK TO g_create_prod_publication;
2171: END IF;
2172:
2173: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2174: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2175: END IF;
2176: x_return_status := G_RET_STS_UNEXP_ERROR ;
2177: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2178:

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

2173: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2174: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2175: END IF;
2176: x_return_status := G_RET_STS_UNEXP_ERROR ;
2177: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2178:
2179: END create_production_publication;
2180:
2181: ------------------------------------------------------------------------------

Line 2310: FND_MSG_PUB.initialize;

2306: -- Initialize message list if p_init_msg_list is set to TRUE.
2307: --
2308: IF FND_API.to_Boolean( p_init_msg_list )
2309: THEN
2310: FND_MSG_PUB.initialize;
2311: END IF;
2312:
2313: --
2314: -- Initialize API return status to success

Line 2491: FND_MSG_PUB.Count_And_Get(

2487:
2488: WHEN FND_API.G_EXC_ERROR THEN
2489:
2490: x_return_status := FND_API.G_RET_STS_ERROR ;
2491: FND_MSG_PUB.Count_And_Get(
2492: p_count => x_msg_count,
2493: p_data => x_msg_data
2494: );
2495:

Line 2498: FND_MSG_PUB.Count_And_Get(

2494: );
2495:
2496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2497: x_return_status := FND_API.G_RET_STS_ERROR ;
2498: FND_MSG_PUB.Count_And_Get(
2499: p_count => x_msg_count,
2500: p_data => x_msg_data
2501: );
2502:

Line 2506: IF FND_MSG_PUB.Check_Msg_Level

2502:
2503: WHEN OTHERS THEN
2504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2505:
2506: IF FND_MSG_PUB.Check_Msg_Level
2507: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2508: THEN
2509: FND_MSG_PUB.Add_Exc_Msg(
2510: G_PKG_NAME ,

Line 2507: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2503: WHEN OTHERS THEN
2504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2505:
2506: IF FND_MSG_PUB.Check_Msg_Level
2507: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2508: THEN
2509: FND_MSG_PUB.Add_Exc_Msg(
2510: G_PKG_NAME ,
2511: l_api_name

Line 2509: FND_MSG_PUB.Add_Exc_Msg(

2505:
2506: IF FND_MSG_PUB.Check_Msg_Level
2507: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2508: THEN
2509: FND_MSG_PUB.Add_Exc_Msg(
2510: G_PKG_NAME ,
2511: l_api_name
2512: );
2513: END IF;

Line 2515: FND_MSG_PUB.Count_And_Get(

2511: l_api_name
2512: );
2513: END IF;
2514:
2515: FND_MSG_PUB.Count_And_Get(
2516: p_count => x_msg_count,
2517: p_data => x_msg_data
2518: );
2519:

Line 2641: FND_MSG_PUB.initialize;

2637: --
2638: -- Initialize message list if p_init_msg_list is set to TRUE.
2639: --
2640: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2641: FND_MSG_PUB.initialize;
2642: END IF;
2643:
2644: --
2645: -- Initialize API return status to success

Line 2770: FND_MSG_PUB.Count_And_Get(

2766: EXCEPTION
2767: WHEN FND_API.G_EXC_ERROR THEN
2768:
2769: x_return_status := FND_API.G_RET_STS_ERROR ;
2770: FND_MSG_PUB.Count_And_Get(
2771: p_count => x_msg_count,
2772: p_data => x_msg_data
2773: );
2774:

Line 2778: FND_MSG_PUB.Count_And_Get(

2774:
2775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2776: x_return_status := FND_API.G_RET_STS_ERROR ;
2777:
2778: FND_MSG_PUB.Count_And_Get(
2779: p_count => x_msg_count,
2780: p_data => x_msg_data
2781: );
2782:

Line 2786: IF FND_MSG_PUB.Check_Msg_Level

2782:
2783: WHEN OTHERS THEN
2784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2785:
2786: IF FND_MSG_PUB.Check_Msg_Level
2787: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2788: THEN
2789: FND_MSG_PUB.Add_Exc_Msg(
2790: G_PKG_NAME ,

Line 2787: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2783: WHEN OTHERS THEN
2784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2785:
2786: IF FND_MSG_PUB.Check_Msg_Level
2787: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2788: THEN
2789: FND_MSG_PUB.Add_Exc_Msg(
2790: G_PKG_NAME ,
2791: l_api_name

Line 2789: FND_MSG_PUB.Add_Exc_Msg(

2785:
2786: IF FND_MSG_PUB.Check_Msg_Level
2787: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2788: THEN
2789: FND_MSG_PUB.Add_Exc_Msg(
2790: G_PKG_NAME ,
2791: l_api_name
2792: );
2793: END IF;

Line 2795: FND_MSG_PUB.Count_And_Get(

2791: l_api_name
2792: );
2793: END IF;
2794:
2795: FND_MSG_PUB.Count_And_Get(
2796: p_count => x_msg_count,
2797: p_data => x_msg_data
2798: );
2799:

Line 3116: FND_MSG_PUB.Count_And_Get(

3112: EXCEPTION
3113:
3114: WHEN FND_API.G_EXC_ERROR THEN
3115: x_return_status := FND_API.G_RET_STS_ERROR ;
3116: FND_MSG_PUB.Count_And_Get(
3117: p_count => x_msg_count,
3118: p_data => x_msg_data
3119: );
3120:

Line 3124: FND_MSG_PUB.Count_And_Get(

3120:
3121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3122: x_return_status := FND_API.G_RET_STS_ERROR ;
3123: -- Uncommented this code to get proper error messages for Bug 5000619
3124: FND_MSG_PUB.Count_And_Get(
3125: p_count => x_msg_count,
3126: p_data => x_msg_data
3127: );
3128:

Line 3132: IF FND_MSG_PUB.Check_Msg_Level

3128:
3129: WHEN OTHERS THEN
3130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3131:
3132: IF FND_MSG_PUB.Check_Msg_Level
3133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3134: THEN
3135: FND_MSG_PUB.Add_Exc_Msg(
3136: G_PKG_NAME ,

Line 3133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3129: WHEN OTHERS THEN
3130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3131:
3132: IF FND_MSG_PUB.Check_Msg_Level
3133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3134: THEN
3135: FND_MSG_PUB.Add_Exc_Msg(
3136: G_PKG_NAME ,
3137: l_api_name

Line 3135: FND_MSG_PUB.Add_Exc_Msg(

3131:
3132: IF FND_MSG_PUB.Check_Msg_Level
3133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3134: THEN
3135: FND_MSG_PUB.Add_Exc_Msg(
3136: G_PKG_NAME ,
3137: l_api_name
3138: );
3139: END IF;

Line 3141: FND_MSG_PUB.Count_And_Get(

3137: l_api_name
3138: );
3139: END IF;
3140:
3141: FND_MSG_PUB.Count_And_Get(
3142: p_count => x_msg_count,
3143: p_data => x_msg_data
3144: );
3145:

Line 3637: FND_MSG_PUB.Count_And_Get(

3633: CLOSE l_article_in_doc;
3634: END IF;
3635:
3636: x_return_status := FND_API.G_RET_STS_ERROR ;
3637: FND_MSG_PUB.Count_And_Get(
3638: p_count => x_msg_count,
3639: p_data => x_msg_data
3640: );
3641:

Line 3662: FND_MSG_PUB.Count_And_Get(

3658: THEN
3659: CLOSE l_article_in_doc;
3660: END IF;
3661: x_return_status := FND_API.G_RET_STS_ERROR ;
3662: FND_MSG_PUB.Count_And_Get(
3663: p_count => x_msg_count,
3664: p_data => x_msg_data
3665: );
3666:

Line 3687: FND_MSG_PUB.Count_And_Get(

3683: THEN
3684: CLOSE l_article_in_doc;
3685: END IF;
3686: x_return_status := FND_API.G_RET_STS_ERROR ;
3687: FND_MSG_PUB.Count_And_Get(
3688: p_count => x_msg_count,
3689: p_data => x_msg_data
3690: );
3691:

Line 3694: IF FND_MSG_PUB.Check_Msg_Level

3690: );
3691:
3692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3693:
3694: IF FND_MSG_PUB.Check_Msg_Level
3695: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3696: THEN
3697: FND_MSG_PUB.Add_Exc_Msg(
3698: G_PKG_NAME ,

Line 3695: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3691:
3692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3693:
3694: IF FND_MSG_PUB.Check_Msg_Level
3695: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3696: THEN
3697: FND_MSG_PUB.Add_Exc_Msg(
3698: G_PKG_NAME ,
3699: l_api_name

Line 3697: FND_MSG_PUB.Add_Exc_Msg(

3693:
3694: IF FND_MSG_PUB.Check_Msg_Level
3695: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3696: THEN
3697: FND_MSG_PUB.Add_Exc_Msg(
3698: G_PKG_NAME ,
3699: l_api_name
3700: );
3701: END IF;

Line 3703: FND_MSG_PUB.Count_And_Get(

3699: l_api_name
3700: );
3701: END IF;
3702:
3703: FND_MSG_PUB.Count_And_Get(
3704: p_count => x_msg_count,
3705: p_data => x_msg_data
3706: );
3707:

Line 3814: FND_MSG_PUB.initialize;

3810: --
3811: -- Initialize message list if p_init_msg_list is set to TRUE.
3812: --
3813: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3814: FND_MSG_PUB.initialize;
3815: END IF;
3816:
3817:
3818: IF (p_config_header_id IS NULL OR p_config_rev_nbr IS NULL)

Line 3899: FND_MSG_PUB.Count_And_Get(

3895:
3896: WHEN FND_API.G_EXC_ERROR THEN
3897:
3898: x_return_status := FND_API.G_RET_STS_ERROR ;
3899: FND_MSG_PUB.Count_And_Get(
3900: p_count => x_msg_count,
3901: p_data => x_msg_data
3902: );
3903:

Line 3906: FND_MSG_PUB.Count_And_Get(

3902: );
3903:
3904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3905: x_return_status := FND_API.G_RET_STS_ERROR ;
3906: FND_MSG_PUB.Count_And_Get(
3907: p_count => x_msg_count,
3908: p_data => x_msg_data
3909: );
3910:

Line 3914: IF FND_MSG_PUB.Check_Msg_Level

3910:
3911: WHEN OTHERS THEN
3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3913:
3914: IF FND_MSG_PUB.Check_Msg_Level
3915: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3916: THEN
3917: FND_MSG_PUB.Add_Exc_Msg(
3918: G_PKG_NAME ,

Line 3915: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3911: WHEN OTHERS THEN
3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3913:
3914: IF FND_MSG_PUB.Check_Msg_Level
3915: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3916: THEN
3917: FND_MSG_PUB.Add_Exc_Msg(
3918: G_PKG_NAME ,
3919: l_api_name

Line 3917: FND_MSG_PUB.Add_Exc_Msg(

3913:
3914: IF FND_MSG_PUB.Check_Msg_Level
3915: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3916: THEN
3917: FND_MSG_PUB.Add_Exc_Msg(
3918: G_PKG_NAME ,
3919: l_api_name
3920: );
3921: END IF;

Line 3923: FND_MSG_PUB.Count_And_Get(

3919: l_api_name
3920: );
3921: END IF;
3922:
3923: FND_MSG_PUB.Count_And_Get(
3924: p_count => x_msg_count,
3925: p_data => x_msg_data
3926: );
3927:

Line 4029: FND_MSG_PUB.initialize;

4025: --
4026: -- Initialize message list if p_init_msg_list is set to TRUE.
4027: --
4028: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4029: FND_MSG_PUB.initialize;
4030: END IF;
4031:
4032: IF (p_config_header_id is NULL OR p_config_rev_nbr is NULL OR
4033: p_document_id is NULL OR p_document_type is NULL)

Line 4183: FND_MSG_PUB.Count_And_Get(

4179:
4180: WHEN FND_API.G_EXC_ERROR THEN
4181:
4182: x_return_status := FND_API.G_RET_STS_ERROR ;
4183: FND_MSG_PUB.Count_And_Get(
4184: p_count => x_msg_count,
4185: p_data => x_msg_data
4186: );
4187:

Line 4190: FND_MSG_PUB.Count_And_Get(

4186: );
4187:
4188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4189: x_return_status := FND_API.G_RET_STS_ERROR ;
4190: FND_MSG_PUB.Count_And_Get(
4191: p_count => x_msg_count,
4192: p_data => x_msg_data
4193: );
4194:

Line 4198: IF FND_MSG_PUB.Check_Msg_Level

4194:
4195: WHEN OTHERS THEN
4196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4197:
4198: IF FND_MSG_PUB.Check_Msg_Level
4199: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4200: THEN
4201: FND_MSG_PUB.Add_Exc_Msg(
4202: G_PKG_NAME ,

Line 4199: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4195: WHEN OTHERS THEN
4196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4197:
4198: IF FND_MSG_PUB.Check_Msg_Level
4199: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4200: THEN
4201: FND_MSG_PUB.Add_Exc_Msg(
4202: G_PKG_NAME ,
4203: l_api_name

Line 4201: FND_MSG_PUB.Add_Exc_Msg(

4197:
4198: IF FND_MSG_PUB.Check_Msg_Level
4199: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4200: THEN
4201: FND_MSG_PUB.Add_Exc_Msg(
4202: G_PKG_NAME ,
4203: l_api_name
4204: );
4205: END IF;

Line 4207: FND_MSG_PUB.Count_And_Get(

4203: l_api_name
4204: );
4205: END IF;
4206:
4207: FND_MSG_PUB.Count_And_Get(
4208: p_count => x_msg_count,
4209: p_data => x_msg_data
4210: );
4211:

Line 4288: FND_MSG_PUB.initialize;

4284: --
4285: -- Initialize message list if p_init_msg_list is set to TRUE.
4286: --
4287: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4288: FND_MSG_PUB.initialize;
4289: END IF;
4290:
4291: IF (p_config_header_id is NULL OR p_config_rev_nbr is NULL OR
4292: p_document_id is NULL OR p_document_type is NULL)

Line 4379: FND_MSG_PUB.Count_And_Get(

4375:
4376: WHEN FND_API.G_EXC_ERROR THEN
4377:
4378: x_return_status := FND_API.G_RET_STS_ERROR ;
4379: FND_MSG_PUB.Count_And_Get(
4380: p_count => x_msg_count,
4381: p_data => x_msg_data
4382: );
4383:

Line 4386: FND_MSG_PUB.Count_And_Get(

4382: );
4383:
4384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4385: x_return_status := FND_API.G_RET_STS_ERROR ;
4386: FND_MSG_PUB.Count_And_Get(
4387: p_count => x_msg_count,
4388: p_data => x_msg_data
4389: );
4390:

Line 4394: IF FND_MSG_PUB.Check_Msg_Level

4390:
4391: WHEN OTHERS THEN
4392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4393:
4394: IF FND_MSG_PUB.Check_Msg_Level
4395: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4396: THEN
4397: FND_MSG_PUB.Add_Exc_Msg(
4398: G_PKG_NAME ,

Line 4395: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4391: WHEN OTHERS THEN
4392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4393:
4394: IF FND_MSG_PUB.Check_Msg_Level
4395: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4396: THEN
4397: FND_MSG_PUB.Add_Exc_Msg(
4398: G_PKG_NAME ,
4399: l_api_name

Line 4397: FND_MSG_PUB.Add_Exc_Msg(

4393:
4394: IF FND_MSG_PUB.Check_Msg_Level
4395: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4396: THEN
4397: FND_MSG_PUB.Add_Exc_Msg(
4398: G_PKG_NAME ,
4399: l_api_name
4400: );
4401: END IF;

Line 4403: FND_MSG_PUB.Count_And_Get(

4399: l_api_name
4400: );
4401: END IF;
4402:
4403: FND_MSG_PUB.Count_And_Get(
4404: p_count => x_msg_count,
4405: p_data => x_msg_data
4406: );
4407: END update_config_id_rev_nbr;

Line 4475: FND_MSG_PUB.initialize;

4471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4472: END IF;
4473: -- Initialize message list if p_init_msg_list is set to TRUE.
4474: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4475: FND_MSG_PUB.initialize;
4476: END IF;
4477:
4478: -- Initialize API return status to success
4479: x_return_status := G_RET_STS_SUCCESS;

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

4496: close get_doc_article_ver_id;
4497: x_article_id := l_article_id;
4498: x_article_version_id := l_article_version_id;
4499: x_doc_lib := l_doc_lib;
4500: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4501:
4502: EXCEPTION
4503: WHEN FND_API.G_EXC_ERROR THEN
4504: x_return_status := G_RET_STS_ERROR ;

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

4501:
4502: EXCEPTION
4503: WHEN FND_API.G_EXC_ERROR THEN
4504: x_return_status := G_RET_STS_ERROR ;
4505: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4506:
4507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4508: x_return_status := G_RET_STS_UNEXP_ERROR ;
4509: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

4505: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4506:
4507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4508: x_return_status := G_RET_STS_UNEXP_ERROR ;
4509: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4510:
4511: WHEN OTHERS THEN
4512: IF get_doc_article_ver_id%ISOPEN THEN
4513: CLOSE get_doc_article_ver_id;

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

4512: IF get_doc_article_ver_id%ISOPEN THEN
4513: CLOSE get_doc_article_ver_id;
4514: END IF;
4515: x_return_status := G_RET_STS_UNEXP_ERROR ;
4516: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4517: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4518: END IF;
4519: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4520: END get_article_details;

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

4513: CLOSE get_doc_article_ver_id;
4514: END IF;
4515: x_return_status := G_RET_STS_UNEXP_ERROR ;
4516: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4517: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4518: END IF;
4519: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4520: END get_article_details;
4521:

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

4515: x_return_status := G_RET_STS_UNEXP_ERROR ;
4516: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4517: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4518: END IF;
4519: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4520: END get_article_details;
4521:
4522: -------------------------FUNCTIONS USED IN RULES PAGES-----------------------------------------------------
4523:

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

5923: END IF;
5924:
5925: x_return_status := G_RET_STS_ERROR ;
5926: x_msg_data := SQLERRM;
5927: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5928:
5929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5930: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

5934: END IF;
5935:
5936: x_return_status := G_RET_STS_UNEXP_ERROR ;
5937: x_msg_data := SQLERRM;
5938: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5939:
5940: WHEN OTHERS THEN
5941: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5942: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

5943: G_MODULE||l_api_name,
5944: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
5945: END IF;
5946:
5947: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5948: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5949: END IF;
5950: x_return_status := G_RET_STS_UNEXP_ERROR ;
5951: x_msg_data := SQLERRM;

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

5944: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
5945: END IF;
5946:
5947: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
5948: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5949: END IF;
5950: x_return_status := G_RET_STS_UNEXP_ERROR ;
5951: x_msg_data := SQLERRM;
5952: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

5948: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
5949: END IF;
5950: x_return_status := G_RET_STS_UNEXP_ERROR ;
5951: x_msg_data := SQLERRM;
5952: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5953:
5954: END publish_rule_with_no_tmpl;
5955:
5956: ------------------------------------------------------------------------------

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

6105: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6106: END IF;
6107:
6108: x_return_status := G_RET_STS_ERROR ;
6109: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6110:
6111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6112: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6113: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

6115: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6116: END IF;
6117:
6118: x_return_status := G_RET_STS_UNEXP_ERROR ;
6119: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6120:
6121: WHEN OTHERS THEN
6122: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6123: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

6124: G_MODULE||l_api_name,
6125: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6126: END IF;
6127:
6128: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6129: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6130: END IF;
6131: x_return_status := G_RET_STS_UNEXP_ERROR ;
6132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

6125: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6126: END IF;
6127:
6128: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6129: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6130: END IF;
6131: x_return_status := G_RET_STS_UNEXP_ERROR ;
6132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6133:

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

6128: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6129: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6130: END IF;
6131: x_return_status := G_RET_STS_UNEXP_ERROR ;
6132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6133:
6134: END check_rules_validity;
6135: -----FUNCTION USED IN RULES PAGES-(2)------------------------------------------------------------------------
6136:

Line 6385: FND_MSG_PUB.initialize;

6381: --
6382: -- Initialize message list if p_init_msg_list is set to TRUE.
6383: --
6384: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6385: FND_MSG_PUB.initialize;
6386: END IF;
6387:
6388: --
6389: -- Initialize API return status to success

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

6416: ) ;
6417:
6418:
6419: -- Standard call to get message count and if count is 1, get message info.
6420: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6421:
6422:
6423: -- end debug log
6424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

6436: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6437: END IF;
6438: x_return_status := G_RET_STS_UNEXP_ERROR ;
6439:
6440: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6441: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6442: END IF;
6443:
6444: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

6437: END IF;
6438: x_return_status := G_RET_STS_UNEXP_ERROR ;
6439:
6440: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6441: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6442: END IF;
6443:
6444: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6445:

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

6440: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6441: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6442: END IF;
6443:
6444: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6445:
6446: END get_publication_id;
6447:
6448:

Line 6539: FND_MSG_PUB.add;

6535: IF l_get_qa_detail_csr%NOTFOUND THEN
6536: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
6537: FND_MESSAGE.set_token('ARG_NAME', 'p_qa_code');
6538: FND_MESSAGE.set_token('ARG_VALUE', p_qa_code);
6539: FND_MSG_PUB.add;
6540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6541: END IF;
6542: CLOSE l_get_qa_detail_csr;
6543:

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

6558: END IF;
6559:
6560: x_return_status := G_RET_STS_UNEXP_ERROR ;
6561:
6562: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6563: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6564: END IF;
6565:
6566: WHEN OTHERS THEN

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

6559:
6560: x_return_status := G_RET_STS_UNEXP_ERROR ;
6561:
6562: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6563: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6564: END IF;
6565:
6566: WHEN OTHERS THEN
6567: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

6570: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6571: END IF;
6572: x_return_status := G_RET_STS_UNEXP_ERROR ;
6573:
6574: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6575: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6576: END IF;
6577:
6578:

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

6571: END IF;
6572: x_return_status := G_RET_STS_UNEXP_ERROR ;
6573:
6574: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6575: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6576: END IF;
6577:
6578:
6579: END get_qa_code_detail;

Line 6657: FND_MSG_PUB.initialize;

6653: --
6654: -- Initialize message list if p_init_msg_list is set to TRUE.
6655: --
6656: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6657: FND_MSG_PUB.initialize;
6658: END IF;
6659:
6660: --
6661: -- Initialize API return status to success

Line 6751: FND_MSG_PUB.Count_And_Get(

6747: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6748: END IF;
6749:
6750: x_return_status := FND_API.G_RET_STS_ERROR ;
6751: FND_MSG_PUB.Count_And_Get(
6752: p_count => x_msg_count,
6753: p_data => x_msg_data
6754: );
6755:

Line 6764: FND_MSG_PUB.Count_And_Get(

6760: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6761: END IF;
6762:
6763: x_return_status := FND_API.G_RET_STS_ERROR ;
6764: FND_MSG_PUB.Count_And_Get(
6765: p_count => x_msg_count,
6766: p_data => x_msg_data
6767: );
6768:

Line 6778: IF FND_MSG_PUB.Check_Msg_Level

6774: END IF;
6775:
6776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6777:
6778: IF FND_MSG_PUB.Check_Msg_Level
6779: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6780: THEN
6781: FND_MSG_PUB.Add_Exc_Msg(
6782: G_PKG_NAME ,

Line 6779: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6775:
6776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6777:
6778: IF FND_MSG_PUB.Check_Msg_Level
6779: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6780: THEN
6781: FND_MSG_PUB.Add_Exc_Msg(
6782: G_PKG_NAME ,
6783: l_api_name

Line 6781: FND_MSG_PUB.Add_Exc_Msg(

6777:
6778: IF FND_MSG_PUB.Check_Msg_Level
6779: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6780: THEN
6781: FND_MSG_PUB.Add_Exc_Msg(
6782: G_PKG_NAME ,
6783: l_api_name
6784: );
6785: END IF;

Line 6787: FND_MSG_PUB.Count_And_Get(

6783: l_api_name
6784: );
6785: END IF;
6786:
6787: FND_MSG_PUB.Count_And_Get(
6788: p_count => x_msg_count,
6789: p_data => x_msg_data);
6790: END enable_expert_button;
6791:

Line 6910: FND_MSG_PUB.initialize;

6906: --
6907: -- Initialize message list if p_init_msg_list is set to TRUE.
6908: --
6909: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6910: FND_MSG_PUB.initialize;
6911: END IF;
6912:
6913:
6914: IF (p_config_header_id IS NULL OR p_config_rev_nbr IS NULL)

Line 6993: FND_MSG_PUB.Count_And_Get(

6989:
6990: WHEN FND_API.G_EXC_ERROR THEN
6991:
6992: x_return_status := FND_API.G_RET_STS_ERROR ;
6993: FND_MSG_PUB.Count_And_Get(
6994: p_count => x_msg_count,
6995: p_data => x_msg_data
6996: );
6997:

Line 7000: FND_MSG_PUB.Count_And_Get(

6996: );
6997:
6998: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6999: x_return_status := FND_API.G_RET_STS_ERROR ;
7000: FND_MSG_PUB.Count_And_Get(
7001: p_count => x_msg_count,
7002: p_data => x_msg_data
7003: );
7004:

Line 7008: IF FND_MSG_PUB.Check_Msg_Level

7004:
7005: WHEN OTHERS THEN
7006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7007:
7008: IF FND_MSG_PUB.Check_Msg_Level
7009: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7010: THEN
7011: FND_MSG_PUB.Add_Exc_Msg(
7012: G_PKG_NAME ,

Line 7009: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7005: WHEN OTHERS THEN
7006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7007:
7008: IF FND_MSG_PUB.Check_Msg_Level
7009: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7010: THEN
7011: FND_MSG_PUB.Add_Exc_Msg(
7012: G_PKG_NAME ,
7013: l_api_name

Line 7011: FND_MSG_PUB.Add_Exc_Msg(

7007:
7008: IF FND_MSG_PUB.Check_Msg_Level
7009: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7010: THEN
7011: FND_MSG_PUB.Add_Exc_Msg(
7012: G_PKG_NAME ,
7013: l_api_name
7014: );
7015: END IF;

Line 7017: FND_MSG_PUB.Count_And_Get(

7013: l_api_name
7014: );
7015: END IF;
7016:
7017: FND_MSG_PUB.Count_And_Get(
7018: p_count => x_msg_count,
7019: p_data => x_msg_data
7020: );
7021:

Line 7103: FND_MSG_PUB.initialize;

7099: --
7100: -- Initialize message list if p_init_msg_list is set to TRUE.
7101: --
7102: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7103: FND_MSG_PUB.initialize;
7104: END IF;
7105:
7106:
7107: --

Line 7144: FND_MSG_PUB.Count_And_Get(

7140:
7141: WHEN FND_API.G_EXC_ERROR THEN
7142:
7143: x_return_status := FND_API.G_RET_STS_ERROR ;
7144: FND_MSG_PUB.Count_And_Get(
7145: p_count => x_msg_count,
7146: p_data => x_msg_data
7147: );
7148:

Line 7151: FND_MSG_PUB.Count_And_Get(

7147: );
7148:
7149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7150: x_return_status := FND_API.G_RET_STS_ERROR ;
7151: FND_MSG_PUB.Count_And_Get(
7152: p_count => x_msg_count,
7153: p_data => x_msg_data
7154: );
7155:

Line 7159: IF FND_MSG_PUB.Check_Msg_Level

7155:
7156: WHEN OTHERS THEN
7157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7158:
7159: IF FND_MSG_PUB.Check_Msg_Level
7160: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7161: THEN
7162: FND_MSG_PUB.Add_Exc_Msg(
7163: G_PKG_NAME ,

Line 7160: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7156: WHEN OTHERS THEN
7157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7158:
7159: IF FND_MSG_PUB.Check_Msg_Level
7160: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7161: THEN
7162: FND_MSG_PUB.Add_Exc_Msg(
7163: G_PKG_NAME ,
7164: l_api_name

Line 7162: FND_MSG_PUB.Add_Exc_Msg(

7158:
7159: IF FND_MSG_PUB.Check_Msg_Level
7160: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7161: THEN
7162: FND_MSG_PUB.Add_Exc_Msg(
7163: G_PKG_NAME ,
7164: l_api_name
7165: );
7166: END IF;

Line 7168: FND_MSG_PUB.Count_And_Get(

7164: l_api_name
7165: );
7166: END IF;
7167:
7168: FND_MSG_PUB.Count_And_Get(
7169: p_count => x_msg_count,
7170: p_data => x_msg_data
7171: );
7172:

Line 7257: FND_MSG_PUB.initialize;

7253: --
7254: -- Initialize message list if p_init_msg_list is set to TRUE.
7255: --
7256: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7257: FND_MSG_PUB.initialize;
7258: END IF;
7259:
7260:
7261: --

Line 7311: FND_MSG_PUB.Count_And_Get(

7307:
7308: WHEN FND_API.G_EXC_ERROR THEN
7309:
7310: x_return_status := FND_API.G_RET_STS_ERROR ;
7311: FND_MSG_PUB.Count_And_Get(
7312: p_count => x_msg_count,
7313: p_data => x_msg_data
7314: );
7315:

Line 7318: FND_MSG_PUB.Count_And_Get(

7314: );
7315:
7316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7317: x_return_status := FND_API.G_RET_STS_ERROR ;
7318: FND_MSG_PUB.Count_And_Get(
7319: p_count => x_msg_count,
7320: p_data => x_msg_data
7321: );
7322:

Line 7326: IF FND_MSG_PUB.Check_Msg_Level

7322:
7323: WHEN OTHERS THEN
7324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7325:
7326: IF FND_MSG_PUB.Check_Msg_Level
7327: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7328: THEN
7329: FND_MSG_PUB.Add_Exc_Msg(
7330: G_PKG_NAME ,

Line 7327: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7323: WHEN OTHERS THEN
7324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7325:
7326: IF FND_MSG_PUB.Check_Msg_Level
7327: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7328: THEN
7329: FND_MSG_PUB.Add_Exc_Msg(
7330: G_PKG_NAME ,
7331: l_api_name

Line 7329: FND_MSG_PUB.Add_Exc_Msg(

7325:
7326: IF FND_MSG_PUB.Check_Msg_Level
7327: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7328: THEN
7329: FND_MSG_PUB.Add_Exc_Msg(
7330: G_PKG_NAME ,
7331: l_api_name
7332: );
7333: END IF;

Line 7335: FND_MSG_PUB.Count_And_Get(

7331: l_api_name
7332: );
7333: END IF;
7334:
7335: FND_MSG_PUB.Count_And_Get(
7336: p_count => x_msg_count,
7337: p_data => x_msg_data
7338: );
7339:

Line 7438: FND_MSG_PUB.initialize;

7434: --
7435: -- Initialize message list if p_init_msg_list is set to TRUE.
7436: --
7437: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7438: FND_MSG_PUB.initialize;
7439: END IF;
7440:
7441:
7442: --

Line 7487: FND_MSG_PUB.Count_And_Get(

7483:
7484: WHEN FND_API.G_EXC_ERROR THEN
7485:
7486: x_return_status := FND_API.G_RET_STS_ERROR ;
7487: FND_MSG_PUB.Count_And_Get(
7488: p_count => x_msg_count,
7489: p_data => x_msg_data
7490: );
7491:

Line 7494: FND_MSG_PUB.Count_And_Get(

7490: );
7491:
7492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7493: x_return_status := FND_API.G_RET_STS_ERROR ;
7494: FND_MSG_PUB.Count_And_Get(
7495: p_count => x_msg_count,
7496: p_data => x_msg_data
7497: );
7498:

Line 7502: IF FND_MSG_PUB.Check_Msg_Level

7498:
7499: WHEN OTHERS THEN
7500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7501:
7502: IF FND_MSG_PUB.Check_Msg_Level
7503: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7504: THEN
7505: FND_MSG_PUB.Add_Exc_Msg(
7506: G_PKG_NAME ,

Line 7503: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7499: WHEN OTHERS THEN
7500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7501:
7502: IF FND_MSG_PUB.Check_Msg_Level
7503: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7504: THEN
7505: FND_MSG_PUB.Add_Exc_Msg(
7506: G_PKG_NAME ,
7507: l_api_name

Line 7505: FND_MSG_PUB.Add_Exc_Msg(

7501:
7502: IF FND_MSG_PUB.Check_Msg_Level
7503: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7504: THEN
7505: FND_MSG_PUB.Add_Exc_Msg(
7506: G_PKG_NAME ,
7507: l_api_name
7508: );
7509: END IF;

Line 7511: FND_MSG_PUB.Count_And_Get(

7507: l_api_name
7508: );
7509: END IF;
7510:
7511: FND_MSG_PUB.Count_And_Get(
7512: p_count => x_msg_count,
7513: p_data => x_msg_data
7514: );
7515:

Line 7635: FND_MSG_PUB.initialize;

7631: --
7632: -- Initialize message list if p_init_msg_list is set to TRUE.
7633: --
7634: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7635: FND_MSG_PUB.initialize;
7636: END IF;
7637:
7638:
7639: --

Line 7764: FND_MSG_PUB.Count_And_Get(

7760:
7761: WHEN FND_API.G_EXC_ERROR THEN
7762:
7763: x_return_status := FND_API.G_RET_STS_ERROR ;
7764: FND_MSG_PUB.Count_And_Get(
7765: p_count => x_msg_count,
7766: p_data => x_msg_data
7767: );
7768:

Line 7771: FND_MSG_PUB.Count_And_Get(

7767: );
7768:
7769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7770: x_return_status := FND_API.G_RET_STS_ERROR ;
7771: FND_MSG_PUB.Count_And_Get(
7772: p_count => x_msg_count,
7773: p_data => x_msg_data
7774: );
7775:

Line 7779: IF FND_MSG_PUB.Check_Msg_Level

7775:
7776: WHEN OTHERS THEN
7777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7778:
7779: IF FND_MSG_PUB.Check_Msg_Level
7780: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7781: THEN
7782: FND_MSG_PUB.Add_Exc_Msg(
7783: G_PKG_NAME ,

Line 7780: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7776: WHEN OTHERS THEN
7777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7778:
7779: IF FND_MSG_PUB.Check_Msg_Level
7780: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7781: THEN
7782: FND_MSG_PUB.Add_Exc_Msg(
7783: G_PKG_NAME ,
7784: l_api_name

Line 7782: FND_MSG_PUB.Add_Exc_Msg(

7778:
7779: IF FND_MSG_PUB.Check_Msg_Level
7780: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7781: THEN
7782: FND_MSG_PUB.Add_Exc_Msg(
7783: G_PKG_NAME ,
7784: l_api_name
7785: );
7786: END IF;

Line 7788: FND_MSG_PUB.Count_And_Get(

7784: l_api_name
7785: );
7786: END IF;
7787:
7788: FND_MSG_PUB.Count_And_Get(
7789: p_count => x_msg_count,
7790: p_data => x_msg_data
7791: );
7792: END get_article_details;

Line 7955: FND_MSG_PUB.initialize;

7951: --
7952: -- Initialize message list if p_init_msg_list is set to TRUE.
7953: --
7954: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7955: FND_MSG_PUB.initialize;
7956: END IF;
7957:
7958:
7959: --

Line 8214: FND_MSG_PUB.Count_And_Get(

8210:
8211: WHEN FND_API.G_EXC_ERROR THEN
8212:
8213: x_return_status := FND_API.G_RET_STS_ERROR ;
8214: FND_MSG_PUB.Count_And_Get(
8215: p_count => x_msg_count,
8216: p_data => x_msg_data
8217: );
8218:

Line 8221: FND_MSG_PUB.Count_And_Get(

8217: );
8218:
8219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8220: x_return_status := FND_API.G_RET_STS_ERROR ;
8221: FND_MSG_PUB.Count_And_Get(
8222: p_count => x_msg_count,
8223: p_data => x_msg_data
8224: );
8225:

Line 8229: IF FND_MSG_PUB.Check_Msg_Level

8225:
8226: WHEN OTHERS THEN
8227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8228:
8229: IF FND_MSG_PUB.Check_Msg_Level
8230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8231: THEN
8232: FND_MSG_PUB.Add_Exc_Msg(
8233: G_PKG_NAME ,

Line 8230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8226: WHEN OTHERS THEN
8227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8228:
8229: IF FND_MSG_PUB.Check_Msg_Level
8230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8231: THEN
8232: FND_MSG_PUB.Add_Exc_Msg(
8233: G_PKG_NAME ,
8234: l_api_name

Line 8232: FND_MSG_PUB.Add_Exc_Msg(

8228:
8229: IF FND_MSG_PUB.Check_Msg_Level
8230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8231: THEN
8232: FND_MSG_PUB.Add_Exc_Msg(
8233: G_PKG_NAME ,
8234: l_api_name
8235: );
8236: END IF;

Line 8238: FND_MSG_PUB.Count_And_Get(

8234: l_api_name
8235: );
8236: END IF;
8237:
8238: FND_MSG_PUB.Count_And_Get(
8239: p_count => x_msg_count,
8240: p_data => x_msg_data
8241: );
8242:

Line 8327: FND_MSG_PUB.initialize;

8323: --
8324: -- Initialize message list if p_init_msg_list is set to TRUE.
8325: --
8326: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8327: FND_MSG_PUB.initialize;
8328: END IF;
8329:
8330: --
8331: -- Check mode and set value for p_sequence_id for 'RUN' - runtime mode only

Line 8634: FND_MSG_PUB.Count_And_Get(

8630:
8631: WHEN FND_API.G_EXC_ERROR THEN
8632:
8633: x_return_status := FND_API.G_RET_STS_ERROR ;
8634: FND_MSG_PUB.Count_And_Get(
8635: p_count => x_msg_count,
8636: p_data => x_msg_data
8637: );
8638:

Line 8641: FND_MSG_PUB.Count_And_Get(

8637: );
8638:
8639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8640: x_return_status := FND_API.G_RET_STS_ERROR ;
8641: FND_MSG_PUB.Count_And_Get(
8642: p_count => x_msg_count,
8643: p_data => x_msg_data
8644: );
8645:

Line 8649: IF FND_MSG_PUB.Check_Msg_Level

8645:
8646: WHEN OTHERS THEN
8647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8648:
8649: IF FND_MSG_PUB.Check_Msg_Level
8650: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8651: THEN
8652: FND_MSG_PUB.Add_Exc_Msg(
8653: G_PKG_NAME ,

Line 8650: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8646: WHEN OTHERS THEN
8647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8648:
8649: IF FND_MSG_PUB.Check_Msg_Level
8650: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8651: THEN
8652: FND_MSG_PUB.Add_Exc_Msg(
8653: G_PKG_NAME ,
8654: l_api_name

Line 8652: FND_MSG_PUB.Add_Exc_Msg(

8648:
8649: IF FND_MSG_PUB.Check_Msg_Level
8650: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8651: THEN
8652: FND_MSG_PUB.Add_Exc_Msg(
8653: G_PKG_NAME ,
8654: l_api_name
8655: );
8656: END IF;

Line 8658: FND_MSG_PUB.Count_And_Get(

8654: l_api_name
8655: );
8656: END IF;
8657:
8658: FND_MSG_PUB.Count_And_Get(
8659: p_count => x_msg_count,
8660: p_data => x_msg_data
8661: );
8662:

Line 8858: FND_MSG_PUB.initialize;

8854: -- Initialize message list if p_init_msg_list is set to TRUE.
8855: --
8856: IF FND_API.to_Boolean( p_init_msg_list )
8857: THEN
8858: FND_MSG_PUB.initialize;
8859: END IF;
8860:
8861:
8862: --

Line 9430: FND_MSG_PUB.ADD;

9426: END IF;
9427:
9428: -- Raises error for invalid configuration
9429: FND_MESSAGE.set_name('OKC', G_OKC_INVALID_CONFIG_D);
9430: FND_MSG_PUB.ADD;
9431: RAISE FND_API.G_EXC_ERROR;
9432:
9433: RETURN;
9434:

Line 9640: FND_MSG_PUB.Count_And_Get(

9636:
9637: --
9638: -- Standard call to get message count and if count is 1, get message info.
9639: --
9640: FND_MSG_PUB.Count_And_Get(
9641: p_count => x_msg_count,
9642: p_data => x_msg_data
9643: );
9644:

Line 9657: FND_MSG_PUB.Count_And_Get(

9653:
9654: WHEN FND_API.G_EXC_ERROR THEN
9655:
9656: x_return_status := FND_API.G_RET_STS_ERROR ;
9657: FND_MSG_PUB.Count_And_Get(
9658: p_count => x_msg_count,
9659: p_data => x_msg_data
9660: );
9661:

Line 9665: FND_MSG_PUB.Count_And_Get(

9661:
9662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9663: x_return_status := FND_API.G_RET_STS_ERROR ;
9664: /*
9665: FND_MSG_PUB.Count_And_Get(
9666: p_count => x_msg_count,
9667: p_data => x_msg_data
9668: ); */
9669:

Line 9673: IF FND_MSG_PUB.Check_Msg_Level

9669:
9670: WHEN OTHERS THEN
9671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9672:
9673: IF FND_MSG_PUB.Check_Msg_Level
9674: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9675: THEN
9676: FND_MSG_PUB.Add_Exc_Msg(
9677: G_PKG_NAME ,

Line 9674: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9670: WHEN OTHERS THEN
9671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9672:
9673: IF FND_MSG_PUB.Check_Msg_Level
9674: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9675: THEN
9676: FND_MSG_PUB.Add_Exc_Msg(
9677: G_PKG_NAME ,
9678: l_api_name

Line 9676: FND_MSG_PUB.Add_Exc_Msg(

9672:
9673: IF FND_MSG_PUB.Check_Msg_Level
9674: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9675: THEN
9676: FND_MSG_PUB.Add_Exc_Msg(
9677: G_PKG_NAME ,
9678: l_api_name
9679: );
9680: END IF;

Line 9682: FND_MSG_PUB.Count_And_Get(

9678: l_api_name
9679: );
9680: END IF;
9681:
9682: FND_MSG_PUB.Count_And_Get(
9683: p_count => x_msg_count,
9684: p_data => x_msg_data
9685: );
9686:

Line 9749: FND_MSG_PUB.initialize;

9745: --
9746: -- Initialize message list if p_init_msg_list is set to TRUE.
9747: --
9748: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9749: FND_MSG_PUB.initialize;
9750: END IF;
9751:
9752: --
9753: -- Initialize API return status to success

Line 9787: FND_MSG_PUB.Count_And_Get(

9783: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
9784: END IF;
9785:
9786: x_return_status := FND_API.G_RET_STS_ERROR ;
9787: FND_MSG_PUB.Count_And_Get(
9788: p_count => x_msg_count,
9789: p_data => x_msg_data
9790: );
9791:

Line 9800: FND_MSG_PUB.Count_And_Get(

9796: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
9797: END IF;
9798:
9799: x_return_status := FND_API.G_RET_STS_ERROR ;
9800: FND_MSG_PUB.Count_And_Get(
9801: p_count => x_msg_count,
9802: p_data => x_msg_data
9803: );
9804:

Line 9814: IF FND_MSG_PUB.Check_Msg_Level

9810: END IF;
9811:
9812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9813:
9814: IF FND_MSG_PUB.Check_Msg_Level
9815: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9816: THEN
9817: FND_MSG_PUB.Add_Exc_Msg(
9818: G_PKG_NAME ,

Line 9815: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9811:
9812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9813:
9814: IF FND_MSG_PUB.Check_Msg_Level
9815: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9816: THEN
9817: FND_MSG_PUB.Add_Exc_Msg(
9818: G_PKG_NAME ,
9819: l_api_name

Line 9817: FND_MSG_PUB.Add_Exc_Msg(

9813:
9814: IF FND_MSG_PUB.Check_Msg_Level
9815: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9816: THEN
9817: FND_MSG_PUB.Add_Exc_Msg(
9818: G_PKG_NAME ,
9819: l_api_name
9820: );
9821: END IF;

Line 9823: FND_MSG_PUB.Count_And_Get(

9819: l_api_name
9820: );
9821: END IF;
9822:
9823: FND_MSG_PUB.Count_And_Get(
9824: p_count => x_msg_count,
9825: p_data => x_msg_data);
9826: END is_template_applied;
9827:

Line 9896: FND_MSG_PUB.initialize;

9892: --
9893: -- Initialize message list if p_init_msg_list is set to TRUE.
9894: --
9895: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9896: FND_MSG_PUB.initialize;
9897: END IF;
9898:
9899: --
9900: -- Initialize API return status to success

Line 9925: FND_MSG_PUB.Count_And_Get(

9921: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
9922: END IF;
9923:
9924: x_return_status := FND_API.G_RET_STS_ERROR ;
9925: FND_MSG_PUB.Count_And_Get(
9926: p_count => x_msg_count,
9927: p_data => x_msg_data
9928: );
9929:

Line 9938: FND_MSG_PUB.Count_And_Get(

9934: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
9935: END IF;
9936:
9937: x_return_status := FND_API.G_RET_STS_ERROR ;
9938: FND_MSG_PUB.Count_And_Get(
9939: p_count => x_msg_count,
9940: p_data => x_msg_data
9941: );
9942:

Line 9952: IF FND_MSG_PUB.Check_Msg_Level

9948: END IF;
9949:
9950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9951:
9952: IF FND_MSG_PUB.Check_Msg_Level
9953: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9954: THEN
9955: FND_MSG_PUB.Add_Exc_Msg(
9956: G_PKG_NAME ,

Line 9953: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9949:
9950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9951:
9952: IF FND_MSG_PUB.Check_Msg_Level
9953: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9954: THEN
9955: FND_MSG_PUB.Add_Exc_Msg(
9956: G_PKG_NAME ,
9957: l_api_name

Line 9955: FND_MSG_PUB.Add_Exc_Msg(

9951:
9952: IF FND_MSG_PUB.Check_Msg_Level
9953: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9954: THEN
9955: FND_MSG_PUB.Add_Exc_Msg(
9956: G_PKG_NAME ,
9957: l_api_name
9958: );
9959: END IF;

Line 9961: FND_MSG_PUB.Count_And_Get(

9957: l_api_name
9958: );
9959: END IF;
9960:
9961: FND_MSG_PUB.Count_And_Get(
9962: p_count => x_msg_count,
9963: p_data => x_msg_data);
9964: END get_current_config_dtls;
9965: