899: EXCEPTION
900:
901: when FND_API.G_EXC_ERROR then
902: /* Bug 4075170 Start */
903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
904: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
905: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
906: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
907: ||'failed due to the following error');
900:
901: when FND_API.G_EXC_ERROR then
902: /* Bug 4075170 Start */
903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
904: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
905: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
906: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
907: ||'failed due to the following error');
908: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
901: when FND_API.G_EXC_ERROR then
902: /* Bug 4075170 Start */
903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
904: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
905: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
906: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
907: ||'failed due to the following error');
908: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
909: /* Bug 4075170 End */
902: /* Bug 4075170 Start */
903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
904: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
905: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
906: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
907: ||'failed due to the following error');
908: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
909: /* Bug 4075170 End */
910:
904: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
905: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
906: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
907: ||'failed due to the following error');
908: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
909: /* Bug 4075170 End */
910:
911: p_return_status := FND_API.G_RET_STS_ERROR;
912:
911: p_return_status := FND_API.G_RET_STS_ERROR;
912:
913: when FND_API.G_EXC_UNEXPECTED_ERROR then
914: /* Bug 4075170 Start */
915: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
918: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
919: ||'failed due to the following error');
912:
913: when FND_API.G_EXC_UNEXPECTED_ERROR then
914: /* Bug 4075170 Start */
915: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
918: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
919: ||'failed due to the following error');
920: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
913: when FND_API.G_EXC_UNEXPECTED_ERROR then
914: /* Bug 4075170 Start */
915: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
918: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
919: ||'failed due to the following error');
920: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
921: /* Bug 4075170 End */
914: /* Bug 4075170 Start */
915: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
918: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
919: ||'failed due to the following error');
920: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
921: /* Bug 4075170 End */
922:
916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
918: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
919: ||'failed due to the following error');
920: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
921: /* Bug 4075170 End */
922:
923: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924:
923: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924:
925: when OTHERS then
926: /* Bug 4075170 Start */
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
931: ||'failed due to the following error');
924:
925: when OTHERS then
926: /* Bug 4075170 Start */
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
931: ||'failed due to the following error');
932: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
925: when OTHERS then
926: /* Bug 4075170 Start */
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
931: ||'failed due to the following error');
932: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
933: /* Bug 4075170 End */
926: /* Bug 4075170 Start */
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
931: ||'failed due to the following error');
932: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
933: /* Bug 4075170 End */
934:
928: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: WHEN OTHERS');
930: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
931: ||'failed due to the following error');
932: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
933: /* Bug 4075170 End */
934:
935: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
936: