341:
342: EXCEPTION
343: when others then
344: proceed := 1;
345: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
346: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_for_update', SQLERRM);
347: end if;
348:
349: arg_err_msg := 'MSC_X_HZ_UPDATE@set_for_update ' || SQLERRM;
342: EXCEPTION
343: when others then
344: proceed := 1;
345: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
346: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_for_update', SQLERRM);
347: end if;
348:
349: arg_err_msg := 'MSC_X_HZ_UPDATE@set_for_update ' || SQLERRM;
350: END set_for_update;
746:
747: EXCEPTION
748: when others then
749: proceed := 1;
750: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
751: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_for_insert', SQLERRM);
752: end if;
753: arg_err_msg := 'MSC_X_HZ_UPDATE@set_for_insert ' || SQLERRM;
754: --dbms_output.put_line('pkaligot : 50 : arg_err_msg :' || arg_err_msg );
747: EXCEPTION
748: when others then
749: proceed := 1;
750: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
751: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_for_insert', SQLERRM);
752: end if;
753: arg_err_msg := 'MSC_X_HZ_UPDATE@set_for_insert ' || SQLERRM;
754: --dbms_output.put_line('pkaligot : 50 : arg_err_msg :' || arg_err_msg );
755:
1306: commit;
1307: EXCEPTION
1308: when others then
1309: proceed := 1;
1310: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1311: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'update_supdem_entries', 'update ' || SQLERRM);
1312: end if;
1313: arg_err_msg := 'MSC_X_HZ_UPDATE@update ' || SQLERRM;
1314: END;
1307: EXCEPTION
1308: when others then
1309: proceed := 1;
1310: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1311: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'update_supdem_entries', 'update ' || SQLERRM);
1312: end if;
1313: arg_err_msg := 'MSC_X_HZ_UPDATE@update ' || SQLERRM;
1314: END;
1315: end if;
1363:
1364: EXCEPTION
1365: when others then
1366: proceed := 1;
1367: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1368: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'update_supdem_entries', 'insert ' || SQLERRM);
1369: end if;
1370: arg_err_msg := 'MSC_X_HZ_UPDATE@insert ' || SQLERRM;
1371: --dbms_output.put_line(' pkaligot : 203 : ' || arg_err_msg );
1364: EXCEPTION
1365: when others then
1366: proceed := 1;
1367: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1368: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'update_supdem_entries', 'insert ' || SQLERRM);
1369: end if;
1370: arg_err_msg := 'MSC_X_HZ_UPDATE@insert ' || SQLERRM;
1371: --dbms_output.put_line(' pkaligot : 203 : ' || arg_err_msg );
1372:
1379:
1380:
1381: EXCEPTION
1382: WHEN NO_DATA_FOUND THEN
1383: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1384: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'update_supdem_entries',SQLERRM);
1385: end if;
1386: arg_err_msg := SQLERRM;
1387:
1380:
1381: EXCEPTION
1382: WHEN NO_DATA_FOUND THEN
1383: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1384: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'update_supdem_entries',SQLERRM);
1385: end if;
1386: arg_err_msg := SQLERRM;
1387:
1388: WHEN OTHERS THEN
1385: end if;
1386: arg_err_msg := SQLERRM;
1387:
1388: WHEN OTHERS THEN
1389: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1390: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'update_supdem_entries',SQLERRM);
1391: end if;
1392: arg_err_msg := SQLERRM;
1393:
1386: arg_err_msg := SQLERRM;
1387:
1388: WHEN OTHERS THEN
1389: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1390: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'update_supdem_entries',SQLERRM);
1391: end if;
1392: arg_err_msg := SQLERRM;
1393:
1394: END;