eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_HZ_PLAN dependencies on FND_LOG

Line 1104: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1100: AND SCE_USER_ID = FND_GLOBAL.user_id ;
1101: end if;
1102: EXCEPTION
1103: WHEN no_data_found THEN
1104: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1105: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_user_prefs','No preference set found');
1106: end if;
1107: -- v_pref := null;
1108: -- set_default_prefs;

Line 1105: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_user_prefs','No preference set found');

1101: end if;
1102: EXCEPTION
1103: WHEN no_data_found THEN
1104: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1105: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_user_prefs','No preference set found');
1106: end if;
1107: -- v_pref := null;
1108: -- set_default_prefs;
1109: END;

Line 1174: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1170:
1171:
1172: EXCEPTION
1173: when no_data_found then
1174: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1175: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_user_prefs','No preference set found');
1176: end if;
1177: v_pref := null;
1178: set_default_prefs;

Line 1175: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_user_prefs','No preference set found');

1171:
1172: EXCEPTION
1173: when no_data_found then
1174: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1175: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_user_prefs','No preference set found');
1176: end if;
1177: v_pref := null;
1178: set_default_prefs;
1179:

Line 1181: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1177: v_pref := null;
1178: set_default_prefs;
1179:
1180: when others then
1181: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1182: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_user_prefs',' Other ' || SQLERRM);
1183: end if;
1184: v_pref := null;
1185: set_default_prefs;

Line 1182: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_user_prefs',' Other ' || SQLERRM);

1178: set_default_prefs;
1179:
1180: when others then
1181: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1182: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_user_prefs',' Other ' || SQLERRM);
1183: end if;
1184: v_pref := null;
1185: set_default_prefs;
1186:

Line 1527: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1523:
1524: Exception
1525: when NO_DATA_FOUND then
1526: arg_err_msg := arg_err_msg || ' Bkt gen' || SQLERRM;
1527: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1528: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_bucket_dates',' Bkt gen ' || SQLERRM);
1529: end if;
1530:
1531: return ;

Line 1528: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_bucket_dates',' Bkt gen ' || SQLERRM);

1524: Exception
1525: when NO_DATA_FOUND then
1526: arg_err_msg := arg_err_msg || ' Bkt gen' || SQLERRM;
1527: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1528: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_bucket_dates',' Bkt gen ' || SQLERRM);
1529: end if;
1530:
1531: return ;
1532:

Line 1639: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1635:
1636: EXCEPTION
1637: WHEN OTHERS THEN
1638: arg_err_msg := ' check_for_multiple_sites ' || SQLERRM || ' ' || l_statement;
1639: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1640: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'check_for_multiple_sites', SQLERRM);
1641: end if;
1642: raise;
1643: END check_for_multiple_sites ;

Line 1640: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'check_for_multiple_sites', SQLERRM);

1636: EXCEPTION
1637: WHEN OTHERS THEN
1638: arg_err_msg := ' check_for_multiple_sites ' || SQLERRM || ' ' || l_statement;
1639: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1640: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'check_for_multiple_sites', SQLERRM);
1641: end if;
1642: raise;
1643: END check_for_multiple_sites ;
1644:

Line 1748: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1744:
1745: EXCEPTION
1746: when others then
1747: arg_err_msg := arg_err_msg || ' initialize ' || SQLERRM;
1748: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1749: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'initialize', SQLERRM);
1750: end if;
1751: raise ;
1752: END initialize ;

Line 1749: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'initialize', SQLERRM);

1745: EXCEPTION
1746: when others then
1747: arg_err_msg := arg_err_msg || ' initialize ' || SQLERRM;
1748: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1749: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'initialize', SQLERRM);
1750: end if;
1751: raise ;
1752: END initialize ;
1753:

Line 1778: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1774:
1775: EXCEPTION
1776: when others then
1777: arg_err_msg := arg_err_msg || ' set dates ' || SQLERRM;
1778: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1779: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_date_variables', SQLERRM);
1780: end if;
1781: return ;
1782: END set_date_variables ;

Line 1779: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_date_variables', SQLERRM);

1775: EXCEPTION
1776: when others then
1777: arg_err_msg := arg_err_msg || ' set dates ' || SQLERRM;
1778: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1779: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_date_variables', SQLERRM);
1780: end if;
1781: return ;
1782: END set_date_variables ;
1783:

Line 1805: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1801:
1802: EXCEPTION
1803: when others then
1804: arg_err_msg := arg_err_msg || 'print_query ' || SQLERRM ;
1805: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1806: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'print_query', SQLERRM);
1807: end if;
1808: raise;
1809: END print_query ;

Line 1806: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'print_query', SQLERRM);

1802: EXCEPTION
1803: when others then
1804: arg_err_msg := arg_err_msg || 'print_query ' || SQLERRM ;
1805: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1806: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'print_query', SQLERRM);
1807: end if;
1808: raise;
1809: END print_query ;
1810:

Line 1924: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1920:
1921: return ret_str;
1922: EXCEPTION
1923: when no_data_found then
1924: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1925: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'convert_to_string', 'No data found');
1926: end if;
1927: return null;
1928:

Line 1925: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'convert_to_string', 'No data found');

1921: return ret_str;
1922: EXCEPTION
1923: when no_data_found then
1924: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1925: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'convert_to_string', 'No data found');
1926: end if;
1927: return null;
1928:
1929: when others then

Line 1930: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1926: end if;
1927: return null;
1928:
1929: when others then
1930: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1931: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'convert_to_string', SQLERRM);
1932: end if;
1933: return null;
1934: END;

Line 1931: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'convert_to_string', SQLERRM);

1927: return null;
1928:
1929: when others then
1930: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1931: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'convert_to_string', SQLERRM);
1932: end if;
1933: return null;
1934: END;
1935:

Line 1968: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1964:
1965: return v_array;
1966: EXCEPTION
1967: when no_data_found then
1968: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1969: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_to_array', 'No data found');
1970: end if;
1971: return v_array;
1972:

Line 1969: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_to_array', 'No data found');

1965: return v_array;
1966: EXCEPTION
1967: when no_data_found then
1968: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1969: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_to_array', 'No data found');
1970: end if;
1971: return v_array;
1972:
1973: when others then

Line 1974: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1970: end if;
1971: return v_array;
1972:
1973: when others then
1974: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1975: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_to_array', SQLERRM);
1976: end if;
1977: return v_array;
1978: END;

Line 1975: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_to_array', SQLERRM);

1971: return v_array;
1972:
1973: when others then
1974: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1975: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_to_array', SQLERRM);
1976: end if;
1977: return v_array;
1978: END;
1979:

Line 2074: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2070: end if;
2071:
2072: EXCEPTION
2073: WHEN OTHERS THEN
2074: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2075: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_editable_row', SQLERRM);
2076: end if;
2077: null;
2078: END set_editable_row ;

Line 2075: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_editable_row', SQLERRM);

2071:
2072: EXCEPTION
2073: WHEN OTHERS THEN
2074: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2075: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_editable_row', SQLERRM);
2076: end if;
2077: null;
2078: END set_editable_row ;
2079:

Line 2152: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2148:
2149: EXCEPTION
2150: when others then
2151: arg_err_msg := arg_err_msg || ' set data' || SQLERRM ;
2152: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2153: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_non_qty_data', SQLERRM);
2154: end if;
2155: raise;
2156: END set_non_qty_data;

Line 2153: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_non_qty_data', SQLERRM);

2149: EXCEPTION
2150: when others then
2151: arg_err_msg := arg_err_msg || ' set data' || SQLERRM ;
2152: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2153: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'set_non_qty_data', SQLERRM);
2154: end if;
2155: raise;
2156: END set_non_qty_data;
2157:

Line 2460: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2456:
2457: EXCEPTION
2458: WHEN OTHERS THEN
2459: arg_err_msg := ' calculate_past_due_quantity ' || SQLERRM;
2460: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2461: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'calculate_past_due_quantity', SQLERRM);
2462: end if;
2463: raise;
2464: END calc_past_due_qty ;

Line 2461: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'calculate_past_due_quantity', SQLERRM);

2457: EXCEPTION
2458: WHEN OTHERS THEN
2459: arg_err_msg := ' calculate_past_due_quantity ' || SQLERRM;
2460: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2461: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'calculate_past_due_quantity', SQLERRM);
2462: end if;
2463: raise;
2464: END calc_past_due_qty ;
2465:

Line 2689: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2685: -- commit;
2686: EXCEPTION
2687: when others then
2688: arg_err_msg := arg_err_msg || ' calc bkt data' || SQLERRM;
2689: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2690: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'calculate_bucket_data', SQLERRM);
2691: end if;
2692: raise;
2693: END calculate_bucket_data;

Line 2690: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'calculate_bucket_data', SQLERRM);

2686: EXCEPTION
2687: when others then
2688: arg_err_msg := arg_err_msg || ' calc bkt data' || SQLERRM;
2689: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2690: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'calculate_bucket_data', SQLERRM);
2691: end if;
2692: raise;
2693: END calculate_bucket_data;
2694:

Line 2935: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2931:
2932: EXCEPTION
2933: WHEN OTHERS THEN
2934: arg_err_msg := ' prepare_sql ' || SQLERRM || ' ' || l_statement;
2935: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2936: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'prepare_sql', SQLERRM);
2937: end if;
2938: raise;
2939: END prepare_sql ;

Line 2936: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'prepare_sql', SQLERRM);

2932: EXCEPTION
2933: WHEN OTHERS THEN
2934: arg_err_msg := ' prepare_sql ' || SQLERRM || ' ' || l_statement;
2935: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2936: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'prepare_sql', SQLERRM);
2937: end if;
2938: raise;
2939: END prepare_sql ;
2940:

Line 3074: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3070: end if;
3071: EXCEPTION
3072: when others then
3073: arg_err_msg := arg_err_msg || ' Add companion row ' || SQLERRM;
3074: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3075: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_companion_row', SQLERRM);
3076: end if;
3077: null;
3078: END ;

Line 3075: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_companion_row', SQLERRM);

3071: EXCEPTION
3072: when others then
3073: arg_err_msg := arg_err_msg || ' Add companion row ' || SQLERRM;
3074: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3075: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_companion_row', SQLERRM);
3076: end if;
3077: null;
3078: END ;
3079:

Line 3181: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3177: var_supplier_id(i),var_supplier_site_id(i),v_next_item,0) ;
3178: end if;
3179: EXCEPTION
3180: when others then
3181: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3182: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_companion_row', SQLERRM);
3183: end if;
3184: null;
3185: END ;

Line 3182: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_companion_row', SQLERRM);

3178: end if;
3179: EXCEPTION
3180: when others then
3181: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3182: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_companion_row', SQLERRM);
3183: end if;
3184: null;
3185: END ;
3186:

Line 3192: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3188:
3189:
3190: EXCEPTION
3191: when others then
3192: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3193: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_companion_row', SQLERRM);
3194: end if;
3195:
3196: END add_companion_row ;

Line 3193: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_companion_row', SQLERRM);

3189:
3190: EXCEPTION
3191: when others then
3192: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3193: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'add_companion_row', SQLERRM);
3194: end if;
3195:
3196: END add_companion_row ;
3197:

Line 3243: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3239: WHERE query_id = arg_query_id
3240: AND line_id = var_line_id(i);
3241: EXCEPTION
3242: when others then
3243: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3244: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'correct_next_item', SQLERRM);
3245: end if;
3246: END correct_next_item;
3247:

Line 3244: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'correct_next_item', SQLERRM);

3240: AND line_id = var_line_id(i);
3241: EXCEPTION
3242: when others then
3243: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3244: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'correct_next_item', SQLERRM);
3245: end if;
3246: END correct_next_item;
3247:
3248: /**

Line 3319: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3315: end if;
3316: EXCEPTION
3317: when others then
3318: arg_err_msg := arg_err_msg || ' insert total ' || SQLERRM;
3319: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3320: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_total', SQLERRM);
3321: end if;
3322: if c_Total%ISOPEN then
3323: CLOSE c_Total;

Line 3320: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_total', SQLERRM);

3316: EXCEPTION
3317: when others then
3318: arg_err_msg := arg_err_msg || ' insert total ' || SQLERRM;
3319: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3320: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_total', SQLERRM);
3321: end if;
3322: if c_Total%ISOPEN then
3323: CLOSE c_Total;
3324: end if;

Line 3485: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3481: end if;
3482: EXCEPTION
3483: when others then
3484: arg_err_msg := arg_err_msg || ' insert running total ' || SQLERRM;
3485: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3486: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_running_total', SQLERRM);
3487: end if;
3488: if c_runTotal%ISOPEN then
3489: CLOSE c_runTotal;

Line 3486: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_running_total', SQLERRM);

3482: EXCEPTION
3483: when others then
3484: arg_err_msg := arg_err_msg || ' insert running total ' || SQLERRM;
3485: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3486: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_running_total', SQLERRM);
3487: end if;
3488: if c_runTotal%ISOPEN then
3489: CLOSE c_runTotal;
3490: end if;

Line 3857: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3853: END IF;
3854: EXCEPTION
3855: when others then
3856: arg_err_msg := arg_err_msg || ' insert running total ' || SQLERRM;
3857: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3858: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_running_total', SQLERRM);
3859: end if;
3860: if c_runTotal%ISOPEN then
3861: CLOSE c_runTotal;

Line 3858: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_running_total', SQLERRM);

3854: EXCEPTION
3855: when others then
3856: arg_err_msg := arg_err_msg || ' insert running total ' || SQLERRM;
3857: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3858: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_running_total', SQLERRM);
3859: end if;
3860: if c_runTotal%ISOPEN then
3861: CLOSE c_runTotal;
3862: end if;

Line 3941: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3937: end if;
3938: EXCEPTION
3939: when others then
3940: arg_err_msg := arg_err_msg || ' insert running total ' || SQLERRM;
3941: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3942: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_running_total', SQLERRM);
3943: end if;
3944: if c_runTotal%ISOPEN then
3945: CLOSE c_runTotal;

Line 3942: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_running_total', SQLERRM);

3938: EXCEPTION
3939: when others then
3940: arg_err_msg := arg_err_msg || ' insert running total ' || SQLERRM;
3941: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3942: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'insert_running_total', SQLERRM);
3943: end if;
3944: if c_runTotal%ISOPEN then
3945: CLOSE c_runTotal;
3946: end if;

Line 3971: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3967: BEGIN
3968: get_user_prefs(v_pref);
3969: EXCEPTION
3970: when others then
3971: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3972: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', 'user prefs' || SQLERRM);
3973: end if;
3974: set_default_prefs;
3975: END;

Line 3972: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', 'user prefs' || SQLERRM);

3968: get_user_prefs(v_pref);
3969: EXCEPTION
3970: when others then
3971: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3972: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', 'user prefs' || SQLERRM);
3973: end if;
3974: set_default_prefs;
3975: END;
3976:

Line 4005: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4001: BEGIN
4002: get_user_prefs(v_pref);
4003: EXCEPTION
4004: when others then
4005: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4006: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', 'user prefs' || SQLERRM);
4007: end if;
4008: set_default_prefs;
4009: END;

Line 4006: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', 'user prefs' || SQLERRM);

4002: get_user_prefs(v_pref);
4003: EXCEPTION
4004: when others then
4005: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4006: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', 'user prefs' || SQLERRM);
4007: end if;
4008: set_default_prefs;
4009: END;
4010: get_bucket_dates(arg_from_date, v_calendar_code);

Line 4279: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4275: WHERE query_id = arg_query_id ;
4276:
4277: EXCEPTION
4278: when no_data_found then
4279: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4280: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Get rec cnt '||SQLERRM);
4281: end if;
4282: record_cnt := 0;
4283:

Line 4280: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Get rec cnt '||SQLERRM);

4276:
4277: EXCEPTION
4278: when no_data_found then
4279: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4280: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Get rec cnt '||SQLERRM);
4281: end if;
4282: record_cnt := 0;
4283:
4284: when others then

Line 4285: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4281: end if;
4282: record_cnt := 0;
4283:
4284: when others then
4285: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4286: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Get rec cnt '||SQLERRM);
4287: end if;
4288: record_cnt :=0;
4289: END;

Line 4286: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Get rec cnt '||SQLERRM);

4282: record_cnt := 0;
4283:
4284: when others then
4285: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4286: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Get rec cnt '||SQLERRM);
4287: end if;
4288: record_cnt :=0;
4289: END;
4290:

Line 4324: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4320: end if;
4321: EXCEPTION
4322: when others then
4323: arg_err_msg := arg_err_msg || ' cleanup ' || SQLERRM;
4324: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4325: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Cleanup '||SQLERRM);
4326: end if;
4327:
4328: END;

Line 4325: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Cleanup '||SQLERRM);

4321: EXCEPTION
4322: when others then
4323: arg_err_msg := arg_err_msg || ' cleanup ' || SQLERRM;
4324: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4325: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Cleanup '||SQLERRM);
4326: end if;
4327:
4328: END;
4329:

Line 4386: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4382: end if;
4383: EXCEPTION
4384: when others then
4385: arg_err_msg := arg_err_msg || ' insert records ' || SQLERRM ;
4386: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4387: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Insert record '||SQLERRM);
4388: end if;
4389: raise;
4390:

Line 4387: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Insert record '||SQLERRM);

4383: EXCEPTION
4384: when others then
4385: arg_err_msg := arg_err_msg || ' insert records ' || SQLERRM ;
4386: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4387: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Insert record '||SQLERRM);
4388: end if;
4389: raise;
4390:
4391: END ;

Line 4479: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4475:
4476: EXCEPTION
4477: when others then
4478: arg_err_msg := arg_err_msg || ' Upd owner item etc. ' || SQLERRM;
4479: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4480: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Upd owner item '||SQLERRM);
4481: end if;
4482: END ;
4483: end if;

Line 4480: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Upd owner item '||SQLERRM);

4476: EXCEPTION
4477: when others then
4478: arg_err_msg := arg_err_msg || ' Upd owner item etc. ' || SQLERRM;
4479: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4480: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Upd owner item '||SQLERRM);
4481: end if;
4482: END ;
4483: end if;
4484:

Line 4509: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4505: add_companion_row(arg_query_id);
4506: EXCEPTION
4507: when others then
4508: arg_err_msg := arg_err_msg || ' companion row ' || SQLERRM;
4509: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4510: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity',' companion row '||SQLERRM);
4511: end if;
4512: END;
4513:

Line 4510: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity',' companion row '||SQLERRM);

4506: EXCEPTION
4507: when others then
4508: arg_err_msg := arg_err_msg || ' companion row ' || SQLERRM;
4509: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4510: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity',' companion row '||SQLERRM);
4511: end if;
4512: END;
4513:
4514:

Line 4641: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4637:
4638: EXCEPTION
4639: when no_data_found then
4640: arg_err_msg := arg_err_msg || ' update ' || SQLERRM;
4641: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4642: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Update '||SQLERRM);
4643: end if;
4644:
4645: when others then

Line 4642: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Update '||SQLERRM);

4638: EXCEPTION
4639: when no_data_found then
4640: arg_err_msg := arg_err_msg || ' update ' || SQLERRM;
4641: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4642: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Update '||SQLERRM);
4643: end if;
4644:
4645: when others then
4646: -- do nothing

Line 4648: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4644:
4645: when others then
4646: -- do nothing
4647: arg_err_msg := arg_err_msg || ' update-2' || SQLERRM;
4648: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4649: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Update '||SQLERRM);
4650: end if;
4651:
4652: END;

Line 4649: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Update '||SQLERRM);

4645: when others then
4646: -- do nothing
4647: arg_err_msg := arg_err_msg || ' update-2' || SQLERRM;
4648: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4649: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Update '||SQLERRM);
4650: end if;
4651:
4652: END;
4653:

Line 4687: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4683:
4684: end if;
4685: EXCEPTION
4686: when others then
4687: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4688: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity', 'Run tot '||SQLERRM);
4689: end if;
4690: null;
4691: END;

Line 4688: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity', 'Run tot '||SQLERRM);

4684: end if;
4685: EXCEPTION
4686: when others then
4687: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4688: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity', 'Run tot '||SQLERRM);
4689: end if;
4690: null;
4691: END;
4692:

Line 4724: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4720: END IF;
4721:
4722: EXCEPTION
4723: WHEN others THEN
4724: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4725: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'net_forecast', 'Net Forecast '||SQLERRM);
4726: end if;
4727: END;
4728:

Line 4725: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'net_forecast', 'Net Forecast '||SQLERRM);

4721:
4722: EXCEPTION
4723: WHEN others THEN
4724: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4725: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'net_forecast', 'Net Forecast '||SQLERRM);
4726: end if;
4727: END;
4728:
4729:

Line 4747: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4743: END IF;
4744:
4745: EXCEPTION
4746: WHEN others THEN
4747: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4748: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'total_supply', 'Total Supply '||SQLERRM);
4749: end if;
4750: END;
4751:

Line 4748: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'total_supply', 'Total Supply '||SQLERRM);

4744:
4745: EXCEPTION
4746: WHEN others THEN
4747: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4748: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'total_supply', 'Total Supply '||SQLERRM);
4749: end if;
4750: END;
4751:
4752:

Line 4790: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4786: arg_query_id := -1;
4787: end if;
4788: EXCEPTION
4789: when no_data_found then
4790: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4791: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Upd Bkt flag '||SQLERRM);
4792: end if;
4793:
4794: when others then

Line 4791: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Upd Bkt flag '||SQLERRM);

4787: end if;
4788: EXCEPTION
4789: when no_data_found then
4790: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4791: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Upd Bkt flag '||SQLERRM);
4792: end if;
4793:
4794: when others then
4795: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4795: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4791: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Upd Bkt flag '||SQLERRM);
4792: end if;
4793:
4794: when others then
4795: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4796: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Upd Bkt flag '||SQLERRM);
4797: end if;
4798:
4799: END ;

Line 4796: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Upd Bkt flag '||SQLERRM);

4792: end if;
4793:
4794: when others then
4795: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4796: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module||'populate_bucketed_quantity','Upd Bkt flag '||SQLERRM);
4797: end if;
4798:
4799: END ;
4800:

Line 4810: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4806: end if;
4807:
4808: EXCEPTION
4809: WHEN NO_DATA_FOUND THEN
4810: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4811: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', SQLERRM);
4812: end if;
4813: arg_query_id :=-1;
4814: arg_num_rowset := 0 ;

Line 4811: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', SQLERRM);

4807:
4808: EXCEPTION
4809: WHEN NO_DATA_FOUND THEN
4810: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4811: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', SQLERRM);
4812: end if;
4813: arg_query_id :=-1;
4814: arg_num_rowset := 0 ;
4815: arg_err_msg := arg_err_msg || fnd_message.get_string('MSC','MSC_X_HZ_NODATA');

Line 4822: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4818: close osce_bucketed_plan;
4819: end if;
4820:
4821: WHEN OTHERS THEN
4822: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4823: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', SQLERRM);
4824: end if;
4825: arg_query_id :=-1;
4826: arg_err_msg := arg_err_msg || fnd_message.get_string('MSC','MSC_X_HZ_NODATA');

Line 4823: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', SQLERRM);

4819: end if;
4820:
4821: WHEN OTHERS THEN
4822: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4823: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'populate_bucketed_quantity', SQLERRM);
4824: end if;
4825: arg_query_id :=-1;
4826: arg_err_msg := arg_err_msg || fnd_message.get_string('MSC','MSC_X_HZ_NODATA');
4827: arg_num_rowset := 0 ;

Line 4852: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4848:
4849: return v_name;
4850: EXCEPTION
4851: when no_data_found then
4852: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4853: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_lookup', SQLERRM);
4854: end if;
4855: return null;
4856:

Line 4853: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_lookup', SQLERRM);

4849: return v_name;
4850: EXCEPTION
4851: when no_data_found then
4852: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4853: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_lookup', SQLERRM);
4854: end if;
4855: return null;
4856:
4857: when others then

Line 4858: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4854: end if;
4855: return null;
4856:
4857: when others then
4858: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4859: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_lookup', SQLERRM);
4860: end if;
4861: return null;
4862: END;

Line 4859: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_lookup', SQLERRM);

4855: return null;
4856:
4857: when others then
4858: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4859: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,module || 'get_lookup', SQLERRM);
4860: end if;
4861: return null;
4862: END;
4863: