DBA Data[Home] [Help]

APPS.ENI_DENORM_HRCHY dependencies on FND_LOG

Line 399: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

395: retcode := 2;
396: ROLLBACK;
397: RAISE;
398: WHEN OTHERS THEN
399: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
400: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_DENORM_PARENTS_PROD_HRCHY', 'Error: ' ||
401: sqlerrm || ' .Transaction will be rolled back');
402: end if;
403: errbuf := 'Error :' || sqlerrm;

Line 400: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_DENORM_PARENTS_PROD_HRCHY', 'Error: ' ||

396: ROLLBACK;
397: RAISE;
398: WHEN OTHERS THEN
399: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
400: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_DENORM_PARENTS_PROD_HRCHY', 'Error: ' ||
401: sqlerrm || ' .Transaction will be rolled back');
402: end if;
403: errbuf := 'Error :' || sqlerrm;
404: retcode := 2;

Line 622: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

618: WHERE BATCH_FLAG <> 'NEXT_BATCH'
619: AND OBJECT_TYPE = 'CATEGORY_SET'
620: AND OBJECT_ID = g_catset_id;
621: COMMIT;
622: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
623: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.SYNC_DENORM_PARENTS_PROD_HRCHY', 'Error: ' ||
624: sqlerrm || ' .Transaction will be rolled back');
625: end if;
626: errbuf := 'Error :' || sqlerrm;

Line 623: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.SYNC_DENORM_PARENTS_PROD_HRCHY', 'Error: ' ||

619: AND OBJECT_TYPE = 'CATEGORY_SET'
620: AND OBJECT_ID = g_catset_id;
621: COMMIT;
622: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
623: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.SYNC_DENORM_PARENTS_PROD_HRCHY', 'Error: ' ||
624: sqlerrm || ' .Transaction will be rolled back');
625: end if;
626: errbuf := 'Error :' || sqlerrm;
627: retcode := 2;

Line 954: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

950: retcode := 2;
951: ROLLBACK;
952: RAISE;
953: WHEN OTHERS THEN
954: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
955: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_HIERARCHY', 'Error: ' ||
956: sqlerrm || ' .Transaction will be rolled back');
957: end if;
958: errbuf := 'Error :' || sqlerrm;

Line 955: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_HIERARCHY', 'Error: ' ||

951: ROLLBACK;
952: RAISE;
953: WHEN OTHERS THEN
954: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
955: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_HIERARCHY', 'Error: ' ||
956: sqlerrm || ' .Transaction will be rolled back');
957: end if;
958: errbuf := 'Error :' || sqlerrm;
959: retcode := 2;

Line 1387: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1383:
1384: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Incremental Load of Denorm table complete');
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1388: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.SYNC_HIERARCHY', 'Error: ' ||
1389: sqlerrm || ' .Transaction will be rolled back');
1390: end if;
1391: errbuf := 'Error :' || sqlerrm;

Line 1388: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.SYNC_HIERARCHY', 'Error: ' ||

1384: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Incremental Load of Denorm table complete');
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1388: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.SYNC_HIERARCHY', 'Error: ' ||
1389: sqlerrm || ' .Transaction will be rolled back');
1390: end if;
1391: errbuf := 'Error :' || sqlerrm;
1392: retcode := 2;

Line 1547: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1543: NULL;
1544: END;
1545: EXCEPTION
1546: WHEN OTHERS THEN
1547: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1548: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_PRODUCT_HIERARCHY', 'Error: ' ||
1549: sqlerrm || ' .Transaction will be rolled back');
1550: end if;
1551: errbuf := 'Error :' || sqlerrm;

Line 1548: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_PRODUCT_HIERARCHY', 'Error: ' ||

1544: END;
1545: EXCEPTION
1546: WHEN OTHERS THEN
1547: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1548: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_PRODUCT_HIERARCHY', 'Error: ' ||
1549: sqlerrm || ' .Transaction will be rolled back');
1550: end if;
1551: errbuf := 'Error :' || sqlerrm;
1552: retcode := 2;

Line 2016: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2012: errbuf := SQLERRM || ' Catalog [' || l_product_catalog || '] does not have any categories associated to it.';
2013: retcode := 1;
2014: ROLLBACK;
2015: WHEN OTHERS THEN
2016: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2017: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_OBIEE_HIERARCHY', 'Error: ' ||
2018: sqlerrm || ' .Transaction will be rolled back');
2019: end if;
2020: errbuf := 'Error :' || sqlerrm;

Line 2017: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_OBIEE_HIERARCHY', 'Error: ' ||

2013: retcode := 1;
2014: ROLLBACK;
2015: WHEN OTHERS THEN
2016: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2017: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_OBIEE_HIERARCHY', 'Error: ' ||
2018: sqlerrm || ' .Transaction will be rolled back');
2019: end if;
2020: errbuf := 'Error :' || sqlerrm;
2021: retcode := 2;