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 1416: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1412:
1413: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Incremental Load of Denorm table complete');
1414: EXCEPTION
1415: WHEN OTHERS THEN
1416: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1417: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.SYNC_HIERARCHY', 'Error: ' ||
1418: sqlerrm || ' .Transaction will be rolled back');
1419: end if;
1420: errbuf := 'Error :' || sqlerrm;

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

1413: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Incremental Load of Denorm table complete');
1414: EXCEPTION
1415: WHEN OTHERS THEN
1416: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1417: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.SYNC_HIERARCHY', 'Error: ' ||
1418: sqlerrm || ' .Transaction will be rolled back');
1419: end if;
1420: errbuf := 'Error :' || sqlerrm;
1421: retcode := 2;

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

1572: NULL;
1573: END;
1574: EXCEPTION
1575: WHEN OTHERS THEN
1576: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1577: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_PRODUCT_HIERARCHY', 'Error: ' ||
1578: sqlerrm || ' .Transaction will be rolled back');
1579: end if;
1580: errbuf := 'Error :' || sqlerrm;

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

1573: END;
1574: EXCEPTION
1575: WHEN OTHERS THEN
1576: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1577: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_PRODUCT_HIERARCHY', 'Error: ' ||
1578: sqlerrm || ' .Transaction will be rolled back');
1579: end if;
1580: errbuf := 'Error :' || sqlerrm;
1581: retcode := 2;

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

2041: errbuf := SQLERRM || ' Catalog [' || l_product_catalog || '] does not have any categories associated to it.';
2042: retcode := 1;
2043: ROLLBACK;
2044: WHEN OTHERS THEN
2045: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2046: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_OBIEE_HIERARCHY', 'Error: ' ||
2047: sqlerrm || ' .Transaction will be rolled back');
2048: end if;
2049: errbuf := 'Error :' || sqlerrm;

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

2042: retcode := 1;
2043: ROLLBACK;
2044: WHEN OTHERS THEN
2045: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2046: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'ENI_DENORM_HRCHY.LOAD_OBIEE_HIERARCHY', 'Error: ' ||
2047: sqlerrm || ' .Transaction will be rolled back');
2048: end if;
2049: errbuf := 'Error :' || sqlerrm;
2050: retcode := 2;