[Home] [Help]
365: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
366: END IF;
367:
368: x_return_status := G_RET_STS_ERROR ;
369: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
373: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
375: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
376: END IF;
377:
378: x_return_status := G_RET_STS_UNEXP_ERROR ;
379: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
380:
381: WHEN OTHERS THEN
382: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
384: G_MODULE||l_api_name,
385: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
386: END IF;
387:
388: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
389: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
390: END IF;
391: x_return_status := G_RET_STS_UNEXP_ERROR ;
392: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
385: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
386: END IF;
387:
388: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
389: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
390: END IF;
391: x_return_status := G_RET_STS_UNEXP_ERROR ;
392: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
393:
388: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
389: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
390: END IF;
391: x_return_status := G_RET_STS_UNEXP_ERROR ;
392: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
393:
394: END check_import_status;
395:
396: ---------------------------------------------------
633: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
634: END IF;
635:
636: x_return_status := G_RET_STS_ERROR ;
637: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
641: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
643: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
644: END IF;
645:
646: x_return_status := G_RET_STS_UNEXP_ERROR ;
647: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
648:
649: WHEN OTHERS THEN
650: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
651: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
652: G_MODULE||l_api_name,
653: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
654: END IF;
655:
656: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
658: END IF;
659: x_return_status := G_RET_STS_UNEXP_ERROR ;
660: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
653: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
654: END IF;
655:
656: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
658: END IF;
659: x_return_status := G_RET_STS_UNEXP_ERROR ;
660: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
661:
656: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
658: END IF;
659: x_return_status := G_RET_STS_UNEXP_ERROR ;
660: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
661:
662: END delete_test_publications;
663:
664:
893: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
894: END IF;
895:
896: x_return_status := G_RET_STS_ERROR ;
897: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
898:
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
903: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
904: END IF;
905:
906: x_return_status := G_RET_STS_UNEXP_ERROR ;
907: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
908:
909: WHEN OTHERS THEN
910: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
912: G_MODULE||l_api_name,
913: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
914: END IF;
915:
916: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
917: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
918: END IF;
919: x_return_status := G_RET_STS_UNEXP_ERROR ;
920: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
913: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
914: END IF;
915:
916: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
917: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
918: END IF;
919: x_return_status := G_RET_STS_UNEXP_ERROR ;
920: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
921:
916: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
917: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
918: END IF;
919: x_return_status := G_RET_STS_UNEXP_ERROR ;
920: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
921:
922: END create_test_publication;
923:
924: /*
1723: g_Module || l_Api_Name,
1724: '4000: Leaving ' || g_Pkg_Name || '.' || l_Api_Name);
1725: END IF;
1726:
1727: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN
1728: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);
1729: END IF;
1730: x_Return_Status := g_Ret_Sts_Unexp_Error;
1731: Fnd_Msg_Pub.Count_And_Get(p_Encoded => 'F',
1724: '4000: Leaving ' || g_Pkg_Name || '.' || l_Api_Name);
1725: END IF;
1726:
1727: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN
1728: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);
1729: END IF;
1730: x_Return_Status := g_Ret_Sts_Unexp_Error;
1731: Fnd_Msg_Pub.Count_And_Get(p_Encoded => 'F',
1732: p_Count => x_Msg_Count,
1727: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.g_Msg_Lvl_Unexp_Error) THEN
1728: Fnd_Msg_Pub.Add_Exc_Msg(g_Pkg_Name, l_Api_Name);
1729: END IF;
1730: x_Return_Status := g_Ret_Sts_Unexp_Error;
1731: Fnd_Msg_Pub.Count_And_Get(p_Encoded => 'F',
1732: p_Count => x_Msg_Count,
1733: p_Data => x_Msg_Data);
1734:
1735: END Populate_Questions_Order;
2144: ROLLBACK TO g_create_prod_publication;
2145: END IF;
2146:
2147: x_return_status := G_RET_STS_ERROR ;
2148: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2149:
2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2151: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2152: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2158: ROLLBACK TO g_create_prod_publication;
2159: END IF;
2160:
2161: x_return_status := G_RET_STS_UNEXP_ERROR ;
2162: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2163:
2164: WHEN OTHERS THEN
2165: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2166: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2171: IF (p_calling_mode = 'PUBLISH' OR p_calling_mode = 'DISABLE' OR p_calling_mode = 'SYNC') THEN
2172: ROLLBACK TO g_create_prod_publication;
2173: END IF;
2174:
2175: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2177: END IF;
2178: x_return_status := G_RET_STS_UNEXP_ERROR ;
2179: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2172: ROLLBACK TO g_create_prod_publication;
2173: END IF;
2174:
2175: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2177: END IF;
2178: x_return_status := G_RET_STS_UNEXP_ERROR ;
2179: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2180:
2175: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2177: END IF;
2178: x_return_status := G_RET_STS_UNEXP_ERROR ;
2179: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2180:
2181: END create_production_publication;
2182:
2183: ------------------------------------------------------------------------------
2308: -- Initialize message list if p_init_msg_list is set to TRUE.
2309: --
2310: IF FND_API.to_Boolean( p_init_msg_list )
2311: THEN
2312: FND_MSG_PUB.initialize;
2313: END IF;
2314:
2315: --
2316: -- Initialize API return status to success
2489:
2490: WHEN FND_API.G_EXC_ERROR THEN
2491:
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: FND_MSG_PUB.Count_And_Get(
2494: p_count => x_msg_count,
2495: p_data => x_msg_data
2496: );
2497:
2496: );
2497:
2498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2499: x_return_status := FND_API.G_RET_STS_ERROR ;
2500: FND_MSG_PUB.Count_And_Get(
2501: p_count => x_msg_count,
2502: p_data => x_msg_data
2503: );
2504:
2504:
2505: WHEN OTHERS THEN
2506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2507:
2508: IF FND_MSG_PUB.Check_Msg_Level
2509: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2510: THEN
2511: FND_MSG_PUB.Add_Exc_Msg(
2512: G_PKG_NAME ,
2505: WHEN OTHERS THEN
2506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2507:
2508: IF FND_MSG_PUB.Check_Msg_Level
2509: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2510: THEN
2511: FND_MSG_PUB.Add_Exc_Msg(
2512: G_PKG_NAME ,
2513: l_api_name
2507:
2508: IF FND_MSG_PUB.Check_Msg_Level
2509: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2510: THEN
2511: FND_MSG_PUB.Add_Exc_Msg(
2512: G_PKG_NAME ,
2513: l_api_name
2514: );
2515: END IF;
2513: l_api_name
2514: );
2515: END IF;
2516:
2517: FND_MSG_PUB.Count_And_Get(
2518: p_count => x_msg_count,
2519: p_data => x_msg_data
2520: );
2521:
2639: --
2640: -- Initialize message list if p_init_msg_list is set to TRUE.
2641: --
2642: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2643: FND_MSG_PUB.initialize;
2644: END IF;
2645:
2646: --
2647: -- Initialize API return status to success
2768: EXCEPTION
2769: WHEN FND_API.G_EXC_ERROR THEN
2770:
2771: x_return_status := FND_API.G_RET_STS_ERROR ;
2772: FND_MSG_PUB.Count_And_Get(
2773: p_count => x_msg_count,
2774: p_data => x_msg_data
2775: );
2776:
2776:
2777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2778: x_return_status := FND_API.G_RET_STS_ERROR ;
2779:
2780: FND_MSG_PUB.Count_And_Get(
2781: p_count => x_msg_count,
2782: p_data => x_msg_data
2783: );
2784:
2784:
2785: WHEN OTHERS THEN
2786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2787:
2788: IF FND_MSG_PUB.Check_Msg_Level
2789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2790: THEN
2791: FND_MSG_PUB.Add_Exc_Msg(
2792: G_PKG_NAME ,
2785: WHEN OTHERS THEN
2786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2787:
2788: IF FND_MSG_PUB.Check_Msg_Level
2789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2790: THEN
2791: FND_MSG_PUB.Add_Exc_Msg(
2792: G_PKG_NAME ,
2793: l_api_name
2787:
2788: IF FND_MSG_PUB.Check_Msg_Level
2789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2790: THEN
2791: FND_MSG_PUB.Add_Exc_Msg(
2792: G_PKG_NAME ,
2793: l_api_name
2794: );
2795: END IF;
2793: l_api_name
2794: );
2795: END IF;
2796:
2797: FND_MSG_PUB.Count_And_Get(
2798: p_count => x_msg_count,
2799: p_data => x_msg_data
2800: );
2801:
3114: EXCEPTION
3115:
3116: WHEN FND_API.G_EXC_ERROR THEN
3117: x_return_status := FND_API.G_RET_STS_ERROR ;
3118: FND_MSG_PUB.Count_And_Get(
3119: p_count => x_msg_count,
3120: p_data => x_msg_data
3121: );
3122:
3122:
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: x_return_status := FND_API.G_RET_STS_ERROR ;
3125: -- Uncommented this code to get proper error messages for Bug 5000619
3126: FND_MSG_PUB.Count_And_Get(
3127: p_count => x_msg_count,
3128: p_data => x_msg_data
3129: );
3130:
3130:
3131: WHEN OTHERS THEN
3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3133:
3134: IF FND_MSG_PUB.Check_Msg_Level
3135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3136: THEN
3137: FND_MSG_PUB.Add_Exc_Msg(
3138: G_PKG_NAME ,
3131: WHEN OTHERS THEN
3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3133:
3134: IF FND_MSG_PUB.Check_Msg_Level
3135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3136: THEN
3137: FND_MSG_PUB.Add_Exc_Msg(
3138: G_PKG_NAME ,
3139: l_api_name
3133:
3134: IF FND_MSG_PUB.Check_Msg_Level
3135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3136: THEN
3137: FND_MSG_PUB.Add_Exc_Msg(
3138: G_PKG_NAME ,
3139: l_api_name
3140: );
3141: END IF;
3139: l_api_name
3140: );
3141: END IF;
3142:
3143: FND_MSG_PUB.Count_And_Get(
3144: p_count => x_msg_count,
3145: p_data => x_msg_data
3146: );
3147:
3702: CLOSE l_article_in_doc;
3703: END IF;
3704:
3705: x_return_status := FND_API.G_RET_STS_ERROR ;
3706: FND_MSG_PUB.Count_And_Get(
3707: p_count => x_msg_count,
3708: p_data => x_msg_data
3709: );
3710:
3727: THEN
3728: CLOSE l_article_in_doc;
3729: END IF;
3730: x_return_status := FND_API.G_RET_STS_ERROR ;
3731: FND_MSG_PUB.Count_And_Get(
3732: p_count => x_msg_count,
3733: p_data => x_msg_data
3734: );
3735:
3752: THEN
3753: CLOSE l_article_in_doc;
3754: END IF;
3755: x_return_status := FND_API.G_RET_STS_ERROR ;
3756: FND_MSG_PUB.Count_And_Get(
3757: p_count => x_msg_count,
3758: p_data => x_msg_data
3759: );
3760:
3759: );
3760:
3761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3762:
3763: IF FND_MSG_PUB.Check_Msg_Level
3764: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3765: THEN
3766: FND_MSG_PUB.Add_Exc_Msg(
3767: G_PKG_NAME ,
3760:
3761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3762:
3763: IF FND_MSG_PUB.Check_Msg_Level
3764: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3765: THEN
3766: FND_MSG_PUB.Add_Exc_Msg(
3767: G_PKG_NAME ,
3768: l_api_name
3762:
3763: IF FND_MSG_PUB.Check_Msg_Level
3764: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3765: THEN
3766: FND_MSG_PUB.Add_Exc_Msg(
3767: G_PKG_NAME ,
3768: l_api_name
3769: );
3770: END IF;
3768: l_api_name
3769: );
3770: END IF;
3771:
3772: FND_MSG_PUB.Count_And_Get(
3773: p_count => x_msg_count,
3774: p_data => x_msg_data
3775: );
3776:
3907: --
3908: -- Initialize message list if p_init_msg_list is set to TRUE.
3909: --
3910: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3911: FND_MSG_PUB.initialize;
3912: END IF;
3913:
3914: --
3915: -- Initialize API return status to success
4009:
4010: WHEN FND_API.G_EXC_ERROR THEN
4011:
4012: x_return_status := FND_API.G_RET_STS_ERROR ;
4013: FND_MSG_PUB.Count_And_Get(
4014: p_count => x_msg_count,
4015: p_data => x_msg_data
4016: );
4017:
4016: );
4017:
4018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4019: x_return_status := FND_API.G_RET_STS_ERROR ;
4020: FND_MSG_PUB.Count_And_Get(
4021: p_count => x_msg_count,
4022: p_data => x_msg_data
4023: );
4024:
4024:
4025: WHEN OTHERS THEN
4026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4027:
4028: IF FND_MSG_PUB.Check_Msg_Level
4029: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4030: THEN
4031: FND_MSG_PUB.Add_Exc_Msg(
4032: G_PKG_NAME ,
4025: WHEN OTHERS THEN
4026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4027:
4028: IF FND_MSG_PUB.Check_Msg_Level
4029: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4030: THEN
4031: FND_MSG_PUB.Add_Exc_Msg(
4032: G_PKG_NAME ,
4033: l_api_name
4027:
4028: IF FND_MSG_PUB.Check_Msg_Level
4029: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4030: THEN
4031: FND_MSG_PUB.Add_Exc_Msg(
4032: G_PKG_NAME ,
4033: l_api_name
4034: );
4035: END IF;
4033: l_api_name
4034: );
4035: END IF;
4036:
4037: FND_MSG_PUB.Count_And_Get(
4038: p_count => x_msg_count,
4039: p_data => x_msg_data
4040: );
4041:
4148: --
4149: -- Initialize message list if p_init_msg_list is set to TRUE.
4150: --
4151: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4152: FND_MSG_PUB.initialize;
4153: END IF;
4154:
4155: IF (p_config_header_id is NULL OR p_config_rev_nbr is NULL OR
4156: p_document_id is NULL OR p_document_type is NULL)
4336:
4337: WHEN FND_API.G_EXC_ERROR THEN
4338:
4339: x_return_status := FND_API.G_RET_STS_ERROR ;
4340: FND_MSG_PUB.Count_And_Get(
4341: p_count => x_msg_count,
4342: p_data => x_msg_data
4343: );
4344:
4343: );
4344:
4345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4346: x_return_status := FND_API.G_RET_STS_ERROR ;
4347: FND_MSG_PUB.Count_And_Get(
4348: p_count => x_msg_count,
4349: p_data => x_msg_data
4350: );
4351:
4351:
4352: WHEN OTHERS THEN
4353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4354:
4355: IF FND_MSG_PUB.Check_Msg_Level
4356: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4357: THEN
4358: FND_MSG_PUB.Add_Exc_Msg(
4359: G_PKG_NAME ,
4352: WHEN OTHERS THEN
4353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4354:
4355: IF FND_MSG_PUB.Check_Msg_Level
4356: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4357: THEN
4358: FND_MSG_PUB.Add_Exc_Msg(
4359: G_PKG_NAME ,
4360: l_api_name
4354:
4355: IF FND_MSG_PUB.Check_Msg_Level
4356: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4357: THEN
4358: FND_MSG_PUB.Add_Exc_Msg(
4359: G_PKG_NAME ,
4360: l_api_name
4361: );
4362: END IF;
4360: l_api_name
4361: );
4362: END IF;
4363:
4364: FND_MSG_PUB.Count_And_Get(
4365: p_count => x_msg_count,
4366: p_data => x_msg_data
4367: );
4368:
4447: --
4448: -- Initialize message list if p_init_msg_list is set to TRUE.
4449: --
4450: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4451: FND_MSG_PUB.initialize;
4452: END IF;
4453:
4454: IF (p_config_header_id is NULL OR p_config_rev_nbr is NULL OR
4455: p_document_id is NULL OR p_document_type is NULL)
4573:
4574: WHEN FND_API.G_EXC_ERROR THEN
4575:
4576: x_return_status := FND_API.G_RET_STS_ERROR ;
4577: FND_MSG_PUB.Count_And_Get(
4578: p_count => x_msg_count,
4579: p_data => x_msg_data
4580: );
4581:
4580: );
4581:
4582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4583: x_return_status := FND_API.G_RET_STS_ERROR ;
4584: FND_MSG_PUB.Count_And_Get(
4585: p_count => x_msg_count,
4586: p_data => x_msg_data
4587: );
4588:
4588:
4589: WHEN OTHERS THEN
4590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4591:
4592: IF FND_MSG_PUB.Check_Msg_Level
4593: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4594: THEN
4595: FND_MSG_PUB.Add_Exc_Msg(
4596: G_PKG_NAME ,
4589: WHEN OTHERS THEN
4590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4591:
4592: IF FND_MSG_PUB.Check_Msg_Level
4593: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4594: THEN
4595: FND_MSG_PUB.Add_Exc_Msg(
4596: G_PKG_NAME ,
4597: l_api_name
4591:
4592: IF FND_MSG_PUB.Check_Msg_Level
4593: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4594: THEN
4595: FND_MSG_PUB.Add_Exc_Msg(
4596: G_PKG_NAME ,
4597: l_api_name
4598: );
4599: END IF;
4597: l_api_name
4598: );
4599: END IF;
4600:
4601: FND_MSG_PUB.Count_And_Get(
4602: p_count => x_msg_count,
4603: p_data => x_msg_data
4604: );
4605: END update_config_id_rev_nbr;
4669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4670: END IF;
4671: -- Initialize message list if p_init_msg_list is set to TRUE.
4672: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4673: FND_MSG_PUB.initialize;
4674: END IF;
4675:
4676: -- Initialize API return status to success
4677: x_return_status := G_RET_STS_SUCCESS;
4694: close get_doc_article_ver_id;
4695: x_article_id := l_article_id;
4696: x_article_version_id := l_article_version_id;
4697: x_doc_lib := l_doc_lib;
4698: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4699:
4700: EXCEPTION
4701: WHEN FND_API.G_EXC_ERROR THEN
4702: x_return_status := G_RET_STS_ERROR ;
4699:
4700: EXCEPTION
4701: WHEN FND_API.G_EXC_ERROR THEN
4702: x_return_status := G_RET_STS_ERROR ;
4703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4704:
4705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4706: x_return_status := G_RET_STS_UNEXP_ERROR ;
4707: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4704:
4705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4706: x_return_status := G_RET_STS_UNEXP_ERROR ;
4707: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4708:
4709: WHEN OTHERS THEN
4710: IF get_doc_article_ver_id%ISOPEN THEN
4711: CLOSE get_doc_article_ver_id;
4710: IF get_doc_article_ver_id%ISOPEN THEN
4711: CLOSE get_doc_article_ver_id;
4712: END IF;
4713: x_return_status := G_RET_STS_UNEXP_ERROR ;
4714: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4715: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4716: END IF;
4717: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4718: END get_article_details;
4711: CLOSE get_doc_article_ver_id;
4712: END IF;
4713: x_return_status := G_RET_STS_UNEXP_ERROR ;
4714: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4715: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4716: END IF;
4717: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4718: END get_article_details;
4719:
4713: x_return_status := G_RET_STS_UNEXP_ERROR ;
4714: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4715: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
4716: END IF;
4717: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4718: END get_article_details;
4719:
4720: -------------------------FUNCTIONS USED IN RULES PAGES-----------------------------------------------------
4721:
6121: END IF;
6122:
6123: x_return_status := G_RET_STS_ERROR ;
6124: x_msg_data := SQLERRM;
6125: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6126:
6127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6128: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
6132: END IF;
6133:
6134: x_return_status := G_RET_STS_UNEXP_ERROR ;
6135: x_msg_data := SQLERRM;
6136: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6137:
6138: WHEN OTHERS THEN
6139: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6140: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
6141: G_MODULE||l_api_name,
6142: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6143: END IF;
6144:
6145: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6147: END IF;
6148: x_return_status := G_RET_STS_UNEXP_ERROR ;
6149: x_msg_data := SQLERRM;
6142: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6143: END IF;
6144:
6145: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6147: END IF;
6148: x_return_status := G_RET_STS_UNEXP_ERROR ;
6149: x_msg_data := SQLERRM;
6150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6147: END IF;
6148: x_return_status := G_RET_STS_UNEXP_ERROR ;
6149: x_msg_data := SQLERRM;
6150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6151:
6152: END publish_rule_with_no_tmpl;
6153:
6154: ------------------------------------------------------------------------------
6303: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6304: END IF;
6305:
6306: x_return_status := G_RET_STS_ERROR ;
6307: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6308:
6309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
6313: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6314: END IF;
6315:
6316: x_return_status := G_RET_STS_UNEXP_ERROR ;
6317: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6318:
6319: WHEN OTHERS THEN
6320: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6321: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
6322: G_MODULE||l_api_name,
6323: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6324: END IF;
6325:
6326: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6328: END IF;
6329: x_return_status := G_RET_STS_UNEXP_ERROR ;
6330: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6323: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6324: END IF;
6325:
6326: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6328: END IF;
6329: x_return_status := G_RET_STS_UNEXP_ERROR ;
6330: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6331:
6326: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6328: END IF;
6329: x_return_status := G_RET_STS_UNEXP_ERROR ;
6330: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6331:
6332: END check_rules_validity;
6333: -----FUNCTION USED IN RULES PAGES-(2)------------------------------------------------------------------------
6334:
6579: --
6580: -- Initialize message list if p_init_msg_list is set to TRUE.
6581: --
6582: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6583: FND_MSG_PUB.initialize;
6584: END IF;
6585:
6586: --
6587: -- Initialize API return status to success
6614: ) ;
6615:
6616:
6617: -- Standard call to get message count and if count is 1, get message info.
6618: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6619:
6620:
6621: -- end debug log
6622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6634: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6635: END IF;
6636: x_return_status := G_RET_STS_UNEXP_ERROR ;
6637:
6638: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6639: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6640: END IF;
6641:
6642: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6635: END IF;
6636: x_return_status := G_RET_STS_UNEXP_ERROR ;
6637:
6638: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6639: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6640: END IF;
6641:
6642: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6643:
6638: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6639: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6640: END IF;
6641:
6642: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
6643:
6644: END get_publication_id;
6645:
6646:
6733: IF l_get_qa_detail_csr%NOTFOUND THEN
6734: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
6735: FND_MESSAGE.set_token('ARG_NAME', 'p_qa_code');
6736: FND_MESSAGE.set_token('ARG_VALUE', p_qa_code);
6737: FND_MSG_PUB.add;
6738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
6739: END IF;
6740: CLOSE l_get_qa_detail_csr;
6741:
6756: END IF;
6757:
6758: x_return_status := G_RET_STS_UNEXP_ERROR ;
6759:
6760: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6761: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6762: END IF;
6763:
6764: WHEN OTHERS THEN
6757:
6758: x_return_status := G_RET_STS_UNEXP_ERROR ;
6759:
6760: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6761: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6762: END IF;
6763:
6764: WHEN OTHERS THEN
6765: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6768: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6769: END IF;
6770: x_return_status := G_RET_STS_UNEXP_ERROR ;
6771:
6772: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6773: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6774: END IF;
6775:
6776:
6769: END IF;
6770: x_return_status := G_RET_STS_UNEXP_ERROR ;
6771:
6772: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
6773: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6774: END IF;
6775:
6776:
6777: END get_qa_code_detail;
6853: --
6854: -- Initialize message list if p_init_msg_list is set to TRUE.
6855: --
6856: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6857: FND_MSG_PUB.initialize;
6858: END IF;
6859:
6860: --
6861: -- Initialize API return status to success
6972: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6973: END IF;
6974:
6975: x_return_status := FND_API.G_RET_STS_ERROR ;
6976: FND_MSG_PUB.Count_And_Get(
6977: p_count => x_msg_count,
6978: p_data => x_msg_data
6979: );
6980:
6985: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
6986: END IF;
6987:
6988: x_return_status := FND_API.G_RET_STS_ERROR ;
6989: FND_MSG_PUB.Count_And_Get(
6990: p_count => x_msg_count,
6991: p_data => x_msg_data
6992: );
6993:
6999: END IF;
7000:
7001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7002:
7003: IF FND_MSG_PUB.Check_Msg_Level
7004: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7005: THEN
7006: FND_MSG_PUB.Add_Exc_Msg(
7007: G_PKG_NAME ,
7000:
7001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7002:
7003: IF FND_MSG_PUB.Check_Msg_Level
7004: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7005: THEN
7006: FND_MSG_PUB.Add_Exc_Msg(
7007: G_PKG_NAME ,
7008: l_api_name
7002:
7003: IF FND_MSG_PUB.Check_Msg_Level
7004: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7005: THEN
7006: FND_MSG_PUB.Add_Exc_Msg(
7007: G_PKG_NAME ,
7008: l_api_name
7009: );
7010: END IF;
7008: l_api_name
7009: );
7010: END IF;
7011:
7012: FND_MSG_PUB.Count_And_Get(
7013: p_count => x_msg_count,
7014: p_data => x_msg_data);
7015: END enable_expert_button;
7016:
7170: --
7171: -- Initialize message list if p_init_msg_list is set to TRUE.
7172: --
7173: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7174: FND_MSG_PUB.initialize;
7175: END IF;
7176:
7177: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'N' THEN --only if it is configurator
7178: IF (p_config_header_id IS NULL OR p_config_rev_nbr IS NULL)
7272:
7273: WHEN FND_API.G_EXC_ERROR THEN
7274:
7275: x_return_status := FND_API.G_RET_STS_ERROR ;
7276: FND_MSG_PUB.Count_And_Get(
7277: p_count => x_msg_count,
7278: p_data => x_msg_data
7279: );
7280:
7279: );
7280:
7281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7282: x_return_status := FND_API.G_RET_STS_ERROR ;
7283: FND_MSG_PUB.Count_And_Get(
7284: p_count => x_msg_count,
7285: p_data => x_msg_data
7286: );
7287:
7287:
7288: WHEN OTHERS THEN
7289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7290:
7291: IF FND_MSG_PUB.Check_Msg_Level
7292: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7293: THEN
7294: FND_MSG_PUB.Add_Exc_Msg(
7295: G_PKG_NAME ,
7288: WHEN OTHERS THEN
7289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7290:
7291: IF FND_MSG_PUB.Check_Msg_Level
7292: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7293: THEN
7294: FND_MSG_PUB.Add_Exc_Msg(
7295: G_PKG_NAME ,
7296: l_api_name
7290:
7291: IF FND_MSG_PUB.Check_Msg_Level
7292: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7293: THEN
7294: FND_MSG_PUB.Add_Exc_Msg(
7295: G_PKG_NAME ,
7296: l_api_name
7297: );
7298: END IF;
7296: l_api_name
7297: );
7298: END IF;
7299:
7300: FND_MSG_PUB.Count_And_Get(
7301: p_count => x_msg_count,
7302: p_data => x_msg_data
7303: );
7304:
7382: --
7383: -- Initialize message list if p_init_msg_list is set to TRUE.
7384: --
7385: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7386: FND_MSG_PUB.initialize;
7387: END IF;
7388:
7389:
7390: --
7423:
7424: WHEN FND_API.G_EXC_ERROR THEN
7425:
7426: x_return_status := FND_API.G_RET_STS_ERROR ;
7427: FND_MSG_PUB.Count_And_Get(
7428: p_count => x_msg_count,
7429: p_data => x_msg_data
7430: );
7431:
7430: );
7431:
7432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7433: x_return_status := FND_API.G_RET_STS_ERROR ;
7434: FND_MSG_PUB.Count_And_Get(
7435: p_count => x_msg_count,
7436: p_data => x_msg_data
7437: );
7438:
7438:
7439: WHEN OTHERS THEN
7440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7441:
7442: IF FND_MSG_PUB.Check_Msg_Level
7443: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7444: THEN
7445: FND_MSG_PUB.Add_Exc_Msg(
7446: G_PKG_NAME ,
7439: WHEN OTHERS THEN
7440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7441:
7442: IF FND_MSG_PUB.Check_Msg_Level
7443: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7444: THEN
7445: FND_MSG_PUB.Add_Exc_Msg(
7446: G_PKG_NAME ,
7447: l_api_name
7441:
7442: IF FND_MSG_PUB.Check_Msg_Level
7443: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7444: THEN
7445: FND_MSG_PUB.Add_Exc_Msg(
7446: G_PKG_NAME ,
7447: l_api_name
7448: );
7449: END IF;
7447: l_api_name
7448: );
7449: END IF;
7450:
7451: FND_MSG_PUB.Count_And_Get(
7452: p_count => x_msg_count,
7453: p_data => x_msg_data
7454: );
7455:
7536: --
7537: -- Initialize message list if p_init_msg_list is set to TRUE.
7538: --
7539: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7540: FND_MSG_PUB.initialize;
7541: END IF;
7542:
7543:
7544: --
7590:
7591: WHEN FND_API.G_EXC_ERROR THEN
7592:
7593: x_return_status := FND_API.G_RET_STS_ERROR ;
7594: FND_MSG_PUB.Count_And_Get(
7595: p_count => x_msg_count,
7596: p_data => x_msg_data
7597: );
7598:
7597: );
7598:
7599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7600: x_return_status := FND_API.G_RET_STS_ERROR ;
7601: FND_MSG_PUB.Count_And_Get(
7602: p_count => x_msg_count,
7603: p_data => x_msg_data
7604: );
7605:
7605:
7606: WHEN OTHERS THEN
7607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7608:
7609: IF FND_MSG_PUB.Check_Msg_Level
7610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7611: THEN
7612: FND_MSG_PUB.Add_Exc_Msg(
7613: G_PKG_NAME ,
7606: WHEN OTHERS THEN
7607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7608:
7609: IF FND_MSG_PUB.Check_Msg_Level
7610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7611: THEN
7612: FND_MSG_PUB.Add_Exc_Msg(
7613: G_PKG_NAME ,
7614: l_api_name
7608:
7609: IF FND_MSG_PUB.Check_Msg_Level
7610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7611: THEN
7612: FND_MSG_PUB.Add_Exc_Msg(
7613: G_PKG_NAME ,
7614: l_api_name
7615: );
7616: END IF;
7614: l_api_name
7615: );
7616: END IF;
7617:
7618: FND_MSG_PUB.Count_And_Get(
7619: p_count => x_msg_count,
7620: p_data => x_msg_data
7621: );
7622:
7717: --
7718: -- Initialize message list if p_init_msg_list is set to TRUE.
7719: --
7720: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7721: FND_MSG_PUB.initialize;
7722: END IF;
7723:
7724:
7725: --
7766:
7767: WHEN FND_API.G_EXC_ERROR THEN
7768:
7769: x_return_status := FND_API.G_RET_STS_ERROR ;
7770: FND_MSG_PUB.Count_And_Get(
7771: p_count => x_msg_count,
7772: p_data => x_msg_data
7773: );
7774:
7773: );
7774:
7775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7776: x_return_status := FND_API.G_RET_STS_ERROR ;
7777: FND_MSG_PUB.Count_And_Get(
7778: p_count => x_msg_count,
7779: p_data => x_msg_data
7780: );
7781:
7781:
7782: WHEN OTHERS THEN
7783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7784:
7785: IF FND_MSG_PUB.Check_Msg_Level
7786: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7787: THEN
7788: FND_MSG_PUB.Add_Exc_Msg(
7789: G_PKG_NAME ,
7782: WHEN OTHERS THEN
7783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7784:
7785: IF FND_MSG_PUB.Check_Msg_Level
7786: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7787: THEN
7788: FND_MSG_PUB.Add_Exc_Msg(
7789: G_PKG_NAME ,
7790: l_api_name
7784:
7785: IF FND_MSG_PUB.Check_Msg_Level
7786: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7787: THEN
7788: FND_MSG_PUB.Add_Exc_Msg(
7789: G_PKG_NAME ,
7790: l_api_name
7791: );
7792: END IF;
7790: l_api_name
7791: );
7792: END IF;
7793:
7794: FND_MSG_PUB.Count_And_Get(
7795: p_count => x_msg_count,
7796: p_data => x_msg_data
7797: );
7798:
7925: --
7926: -- Initialize message list if p_init_msg_list is set to TRUE.
7927: --
7928: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7929: FND_MSG_PUB.initialize;
7930: END IF;
7931:
7932:
7933: --
8087:
8088: WHEN FND_API.G_EXC_ERROR THEN
8089:
8090: x_return_status := FND_API.G_RET_STS_ERROR ;
8091: FND_MSG_PUB.Count_And_Get(
8092: p_count => x_msg_count,
8093: p_data => x_msg_data
8094: );
8095:
8094: );
8095:
8096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8097: x_return_status := FND_API.G_RET_STS_ERROR ;
8098: FND_MSG_PUB.Count_And_Get(
8099: p_count => x_msg_count,
8100: p_data => x_msg_data
8101: );
8102:
8102:
8103: WHEN OTHERS THEN
8104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8105:
8106: IF FND_MSG_PUB.Check_Msg_Level
8107: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8108: THEN
8109: FND_MSG_PUB.Add_Exc_Msg(
8110: G_PKG_NAME ,
8103: WHEN OTHERS THEN
8104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8105:
8106: IF FND_MSG_PUB.Check_Msg_Level
8107: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8108: THEN
8109: FND_MSG_PUB.Add_Exc_Msg(
8110: G_PKG_NAME ,
8111: l_api_name
8105:
8106: IF FND_MSG_PUB.Check_Msg_Level
8107: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8108: THEN
8109: FND_MSG_PUB.Add_Exc_Msg(
8110: G_PKG_NAME ,
8111: l_api_name
8112: );
8113: END IF;
8111: l_api_name
8112: );
8113: END IF;
8114:
8115: FND_MSG_PUB.Count_And_Get(
8116: p_count => x_msg_count,
8117: p_data => x_msg_data
8118: );
8119: END get_article_details;
8278: --
8279: -- Initialize message list if p_init_msg_list is set to TRUE.
8280: --
8281: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8282: FND_MSG_PUB.initialize;
8283: END IF;
8284:
8285:
8286: --
8537:
8538: WHEN FND_API.G_EXC_ERROR THEN
8539:
8540: x_return_status := FND_API.G_RET_STS_ERROR ;
8541: FND_MSG_PUB.Count_And_Get(
8542: p_count => x_msg_count,
8543: p_data => x_msg_data
8544: );
8545:
8544: );
8545:
8546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8547: x_return_status := FND_API.G_RET_STS_ERROR ;
8548: FND_MSG_PUB.Count_And_Get(
8549: p_count => x_msg_count,
8550: p_data => x_msg_data
8551: );
8552:
8552:
8553: WHEN OTHERS THEN
8554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8555:
8556: IF FND_MSG_PUB.Check_Msg_Level
8557: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8558: THEN
8559: FND_MSG_PUB.Add_Exc_Msg(
8560: G_PKG_NAME ,
8553: WHEN OTHERS THEN
8554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8555:
8556: IF FND_MSG_PUB.Check_Msg_Level
8557: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8558: THEN
8559: FND_MSG_PUB.Add_Exc_Msg(
8560: G_PKG_NAME ,
8561: l_api_name
8555:
8556: IF FND_MSG_PUB.Check_Msg_Level
8557: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8558: THEN
8559: FND_MSG_PUB.Add_Exc_Msg(
8560: G_PKG_NAME ,
8561: l_api_name
8562: );
8563: END IF;
8561: l_api_name
8562: );
8563: END IF;
8564:
8565: FND_MSG_PUB.Count_And_Get(
8566: p_count => x_msg_count,
8567: p_data => x_msg_data
8568: );
8569:
8650: --
8651: -- Initialize message list if p_init_msg_list is set to TRUE.
8652: --
8653: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8654: FND_MSG_PUB.initialize;
8655: END IF;
8656:
8657: --
8658: -- Check mode and set value for p_sequence_id for 'RUN' - runtime mode only
8957:
8958: WHEN FND_API.G_EXC_ERROR THEN
8959:
8960: x_return_status := FND_API.G_RET_STS_ERROR ;
8961: FND_MSG_PUB.Count_And_Get(
8962: p_count => x_msg_count,
8963: p_data => x_msg_data
8964: );
8965:
8964: );
8965:
8966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8967: x_return_status := FND_API.G_RET_STS_ERROR ;
8968: FND_MSG_PUB.Count_And_Get(
8969: p_count => x_msg_count,
8970: p_data => x_msg_data
8971: );
8972:
8972:
8973: WHEN OTHERS THEN
8974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8975:
8976: IF FND_MSG_PUB.Check_Msg_Level
8977: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8978: THEN
8979: FND_MSG_PUB.Add_Exc_Msg(
8980: G_PKG_NAME ,
8973: WHEN OTHERS THEN
8974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8975:
8976: IF FND_MSG_PUB.Check_Msg_Level
8977: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8978: THEN
8979: FND_MSG_PUB.Add_Exc_Msg(
8980: G_PKG_NAME ,
8981: l_api_name
8975:
8976: IF FND_MSG_PUB.Check_Msg_Level
8977: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8978: THEN
8979: FND_MSG_PUB.Add_Exc_Msg(
8980: G_PKG_NAME ,
8981: l_api_name
8982: );
8983: END IF;
8981: l_api_name
8982: );
8983: END IF;
8984:
8985: FND_MSG_PUB.Count_And_Get(
8986: p_count => x_msg_count,
8987: p_data => x_msg_data
8988: );
8989:
9184: -- Initialize message list if p_init_msg_list is set to TRUE.
9185: --
9186: IF FND_API.to_Boolean( p_init_msg_list )
9187: THEN
9188: FND_MSG_PUB.initialize;
9189: END IF;
9190:
9191:
9192: --
10022: END IF;
10023:
10024: -- Raises error for invalid configuration
10025: FND_MESSAGE.set_name('OKC', G_OKC_INVALID_CONFIG_D);
10026: FND_MSG_PUB.ADD;
10027: RAISE FND_API.G_EXC_ERROR;
10028:
10029: RETURN;
10030:
10233:
10234: --
10235: -- Standard call to get message count and if count is 1, get message info.
10236: --
10237: FND_MSG_PUB.Count_And_Get(
10238: p_count => x_msg_count,
10239: p_data => x_msg_data
10240: );
10241:
10250:
10251: WHEN FND_API.G_EXC_ERROR THEN
10252:
10253: x_return_status := FND_API.G_RET_STS_ERROR ;
10254: FND_MSG_PUB.Count_And_Get(
10255: p_count => x_msg_count,
10256: p_data => x_msg_data
10257: );
10258:
10258:
10259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10260: x_return_status := FND_API.G_RET_STS_ERROR ;
10261: /*
10262: FND_MSG_PUB.Count_And_Get(
10263: p_count => x_msg_count,
10264: p_data => x_msg_data
10265: ); */
10266:
10266:
10267: WHEN OTHERS THEN
10268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10269:
10270: IF FND_MSG_PUB.Check_Msg_Level
10271: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10272: THEN
10273: FND_MSG_PUB.Add_Exc_Msg(
10274: G_PKG_NAME ,
10267: WHEN OTHERS THEN
10268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10269:
10270: IF FND_MSG_PUB.Check_Msg_Level
10271: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10272: THEN
10273: FND_MSG_PUB.Add_Exc_Msg(
10274: G_PKG_NAME ,
10275: l_api_name
10269:
10270: IF FND_MSG_PUB.Check_Msg_Level
10271: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10272: THEN
10273: FND_MSG_PUB.Add_Exc_Msg(
10274: G_PKG_NAME ,
10275: l_api_name
10276: );
10277: END IF;
10275: l_api_name
10276: );
10277: END IF;
10278:
10279: FND_MSG_PUB.Count_And_Get(
10280: p_count => x_msg_count,
10281: p_data => x_msg_data
10282: );
10283:
10342: --
10343: -- Initialize message list if p_init_msg_list is set to TRUE.
10344: --
10345: IF FND_API.to_Boolean( p_init_msg_list ) THEN
10346: FND_MSG_PUB.initialize;
10347: END IF;
10348:
10349: --
10350: -- Initialize API return status to success
10380: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
10381: END IF;
10382:
10383: x_return_status := FND_API.G_RET_STS_ERROR ;
10384: FND_MSG_PUB.Count_And_Get(
10385: p_count => x_msg_count,
10386: p_data => x_msg_data
10387: );
10388:
10393: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
10394: END IF;
10395:
10396: x_return_status := FND_API.G_RET_STS_ERROR ;
10397: FND_MSG_PUB.Count_And_Get(
10398: p_count => x_msg_count,
10399: p_data => x_msg_data
10400: );
10401:
10407: END IF;
10408:
10409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10410:
10411: IF FND_MSG_PUB.Check_Msg_Level
10412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10413: THEN
10414: FND_MSG_PUB.Add_Exc_Msg(
10415: G_PKG_NAME ,
10408:
10409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10410:
10411: IF FND_MSG_PUB.Check_Msg_Level
10412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10413: THEN
10414: FND_MSG_PUB.Add_Exc_Msg(
10415: G_PKG_NAME ,
10416: l_api_name
10410:
10411: IF FND_MSG_PUB.Check_Msg_Level
10412: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10413: THEN
10414: FND_MSG_PUB.Add_Exc_Msg(
10415: G_PKG_NAME ,
10416: l_api_name
10417: );
10418: END IF;
10416: l_api_name
10417: );
10418: END IF;
10419:
10420: FND_MSG_PUB.Count_And_Get(
10421: p_count => x_msg_count,
10422: p_data => x_msg_data);
10423: END is_template_applied;
10424:
10489: --
10490: -- Initialize message list if p_init_msg_list is set to TRUE.
10491: --
10492: IF FND_API.to_Boolean( p_init_msg_list ) THEN
10493: FND_MSG_PUB.initialize;
10494: END IF;
10495:
10496: --
10497: -- Initialize API return status to success
10518: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
10519: END IF;
10520:
10521: x_return_status := FND_API.G_RET_STS_ERROR ;
10522: FND_MSG_PUB.Count_And_Get(
10523: p_count => x_msg_count,
10524: p_data => x_msg_data
10525: );
10526:
10531: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
10532: END IF;
10533:
10534: x_return_status := FND_API.G_RET_STS_ERROR ;
10535: FND_MSG_PUB.Count_And_Get(
10536: p_count => x_msg_count,
10537: p_data => x_msg_data
10538: );
10539:
10545: END IF;
10546:
10547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10548:
10549: IF FND_MSG_PUB.Check_Msg_Level
10550: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10551: THEN
10552: FND_MSG_PUB.Add_Exc_Msg(
10553: G_PKG_NAME ,
10546:
10547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10548:
10549: IF FND_MSG_PUB.Check_Msg_Level
10550: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10551: THEN
10552: FND_MSG_PUB.Add_Exc_Msg(
10553: G_PKG_NAME ,
10554: l_api_name
10548:
10549: IF FND_MSG_PUB.Check_Msg_Level
10550: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10551: THEN
10552: FND_MSG_PUB.Add_Exc_Msg(
10553: G_PKG_NAME ,
10554: l_api_name
10555: );
10556: END IF;
10554: l_api_name
10555: );
10556: END IF;
10557:
10558: FND_MSG_PUB.Count_And_Get(
10559: p_count => x_msg_count,
10560: p_data => x_msg_data);
10561: END get_current_config_dtls;
10562:
10913: --
10914: -- Initialize message list if p_init_msg_list is set to TRUE.
10915: --
10916: IF FND_API.to_Boolean( p_init_msg_list ) THEN
10917: FND_MSG_PUB.initialize;
10918: END IF;
10919:
10920: IF (p_document_id is NULL OR p_document_type is NULL)
10921: THEN
11042:
11043: WHEN FND_API.G_EXC_ERROR THEN
11044:
11045: x_return_status := FND_API.G_RET_STS_ERROR ;
11046: FND_MSG_PUB.Count_And_Get(
11047: p_count => x_msg_count,
11048: p_data => x_msg_data
11049: );
11050:
11049: );
11050:
11051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11052: x_return_status := FND_API.G_RET_STS_ERROR ;
11053: FND_MSG_PUB.Count_And_Get(
11054: p_count => x_msg_count,
11055: p_data => x_msg_data
11056: );
11057:
11057:
11058: WHEN OTHERS THEN
11059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11060:
11061: IF FND_MSG_PUB.Check_Msg_Level
11062: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11063: THEN
11064: FND_MSG_PUB.Add_Exc_Msg(
11065: G_PKG_NAME ,
11058: WHEN OTHERS THEN
11059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
11060:
11061: IF FND_MSG_PUB.Check_Msg_Level
11062: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11063: THEN
11064: FND_MSG_PUB.Add_Exc_Msg(
11065: G_PKG_NAME ,
11066: l_api_name
11060:
11061: IF FND_MSG_PUB.Check_Msg_Level
11062: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11063: THEN
11064: FND_MSG_PUB.Add_Exc_Msg(
11065: G_PKG_NAME ,
11066: l_api_name
11067: );
11068: END IF;
11066: l_api_name
11067: );
11068: END IF;
11069:
11070: FND_MSG_PUB.Count_And_Get(
11071: p_count => x_msg_count,
11072: p_data => x_msg_data
11073: );
11074: