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.JMF_SHIKYU_RPT_CUR_PVT dependencies on FND_LOG

Line 92: g_debug_level NUMBER := fnd_log.g_current_runtime_level;

88: --=============================================
89: -- GLOBAL VARIABLES
90: --=============================================
91:
92: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
93: g_proc_level NUMBER := fnd_log.level_procedure;
94:
95: g_rate_not_found VARCHAR2(1) := 'N';
96:

Line 93: g_proc_level NUMBER := fnd_log.level_procedure;

89: -- GLOBAL VARIABLES
90: --=============================================
91:
92: g_debug_level NUMBER := fnd_log.g_current_runtime_level;
93: g_proc_level NUMBER := fnd_log.level_procedure;
94:
95: g_rate_not_found VARCHAR2(1) := 'N';
96:
97: --g_unexp_level NUMBER := fnd_log.level_unexpected;

Line 97: --g_unexp_level NUMBER := fnd_log.level_unexpected;

93: g_proc_level NUMBER := fnd_log.level_procedure;
94:
95: g_rate_not_found VARCHAR2(1) := 'N';
96:
97: --g_unexp_level NUMBER := fnd_log.level_unexpected;
98: g_excep_level NUMBER := fnd_log.level_exception;
99:
100: --========================================================================
101: -- PROCEDURE : cuar_get_cost_data PUBLIC

Line 98: g_excep_level NUMBER := fnd_log.level_exception;

94:
95: g_rate_not_found VARCHAR2(1) := 'N';
96:
97: --g_unexp_level NUMBER := fnd_log.level_unexpected;
98: g_excep_level NUMBER := fnd_log.level_exception;
99:
100: --========================================================================
101: -- PROCEDURE : cuar_get_cost_data PUBLIC
102: -- PARAMETERS: p_cost_type_id cost type id

Line 133: --g_debug_level := fnd_log.g_current_runtime_level;

129:
130:
131: BEGIN
132:
133: --g_debug_level := fnd_log.g_current_runtime_level;
134:
135: IF (g_proc_level >= g_debug_level)
136: THEN
137: fnd_log.STRING(g_proc_level

Line 137: fnd_log.STRING(g_proc_level

133: --g_debug_level := fnd_log.g_current_runtime_level;
134:
135: IF (g_proc_level >= g_debug_level)
136: THEN
137: fnd_log.STRING(g_proc_level
138: ,g_module_prefix || l_api_name || '.begin'
139: ,NULL);
140: END IF;
141:

Line 186: fnd_log.STRING(g_excep_level

182: EXCEPTION
183: WHEN no_data_found THEN
184: IF (g_excep_level >= g_debug_level)
185: THEN
186: fnd_log.STRING(g_excep_level
187: ,g_module_prefix || l_api_name || '.exception'
188: ,'no_data_found');
189: END IF;
190: WHEN OTHERS THEN

Line 194: fnd_log.STRING(g_excep_level

190: WHEN OTHERS THEN
191:
192: IF (g_excep_level >= g_debug_level)
193: THEN
194: fnd_log.STRING(g_excep_level
195: ,g_module_prefix || l_api_name || '.exception'
196: ,SQLERRM);
197: END IF;
198: END cuar_get_cost_data;

Line 376: -- g_debug_level := fnd_log.g_current_runtime_level;

372: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;--Added to display release number(When unreceived then mean release_num)
373:
374: BEGIN
375:
376: -- g_debug_level := fnd_log.g_current_runtime_level;
377:
378: IF (g_proc_level >= g_debug_level)
379: THEN
380: fnd_log.STRING(g_proc_level

Line 380: fnd_log.STRING(g_proc_level

376: -- g_debug_level := fnd_log.g_current_runtime_level;
377:
378: IF (g_proc_level >= g_debug_level)
379: THEN
380: fnd_log.STRING(g_proc_level
381: ,g_module_prefix || l_api_name || '.begin'
382: ,NULL);
383: END IF;
384: l_func_currency_code := p_func_currency_code;

Line 444: fnd_log.STRING(g_excep_level

440:
441:
442: fnd_file.put_line(fnd_file.LOG, l_message );
443:
444: fnd_log.STRING(g_excep_level
445: ,g_module_prefix || l_api_name || '.exception'
446: ,l_message);
447:
448: END IF;

Line 472: fnd_log.STRING(g_excep_level

468:
469: l_message := fnd_message.GET();
470:
471: fnd_file.put_line(fnd_file.LOG, l_message);
472: fnd_log.STRING(g_excep_level
473: ,g_module_prefix || l_api_name || '.exception'
474: ,l_message);
475:
476: END IF;

Line 537: fnd_log.STRING(g_excep_level

533: EXCEPTION
534: WHEN no_data_found THEN
535: IF (g_excep_level >= g_debug_level)
536: THEN
537: fnd_log.STRING(g_excep_level
538: ,g_module_prefix || l_api_name || '.exception'
539: ,'no_data_found');
540: END IF;
541: WHEN OTHERS THEN

Line 547: fnd_log.STRING(g_excep_level

543: ROLLBACK;
544:
545: IF (g_excep_level >= g_debug_level)
546: THEN
547: fnd_log.STRING(g_excep_level
548: ,g_module_prefix || l_api_name || '.exception'
549: ,SQLERRM);
550: END IF;
551: END cuar_get_unreceived_po;

Line 688: --g_debug_level := fnd_log.g_current_runtime_level;

684: l_order_line_id jmf_shikyu_cur_rpt_temp.order_line_id%TYPE;
685: l_message varchar2(200);
686:
687: BEGIN
688: --g_debug_level := fnd_log.g_current_runtime_level;
689:
690: IF (g_proc_level >= g_debug_level)
691: THEN
692: fnd_log.STRING(g_proc_level

Line 692: fnd_log.STRING(g_proc_level

688: --g_debug_level := fnd_log.g_current_runtime_level;
689:
690: IF (g_proc_level >= g_debug_level)
691: THEN
692: fnd_log.STRING(g_proc_level
693: ,g_module_prefix || l_api_name || '.begin'
694: ,NULL);
695: END IF;
696: l_func_currency_code := p_func_currency_code;

Line 756: fnd_log.STRING(g_excep_level

752:
753: l_message := fnd_message.GET();
754:
755: fnd_file.put_line(fnd_file.LOG, l_message);
756: fnd_log.STRING(g_excep_level
757: ,g_module_prefix || l_api_name || '.exception'
758: ,l_message);
759:
760: END IF;

Line 785: fnd_log.STRING(g_excep_level

781: ,l_order_num);
782:
783:
784: fnd_file.put_line(fnd_file.LOG, l_message);
785: fnd_log.STRING(g_excep_level
786: ,g_module_prefix || l_api_name || '.exception'
787: ,l_message);
788:
789: END IF;

Line 851: fnd_log.STRING(g_excep_level

847: EXCEPTION
848: WHEN no_data_found THEN
849: IF (g_excep_level >= g_debug_level)
850: THEN
851: fnd_log.STRING(g_excep_level
852: ,g_module_prefix || l_api_name || '.exception'
853: ,'no_data_found');
854: END IF;
855: WHEN OTHERS THEN

Line 861: fnd_log.STRING(g_excep_level

857: ROLLBACK;
858:
859: IF (g_excep_level >= g_debug_level)
860: THEN
861: fnd_log.STRING(g_excep_level
862: ,g_module_prefix || l_api_name || '.exception'
863: ,SQLERRM);
864: END IF;
865: END cuar_get_unshipped_so;

Line 967: --g_debug_level := fnd_log.g_current_runtime_level;

963: l_message VARCHAR2(100);
964: l_actual_shipment_date Date;
965:
966: BEGIN
967: --g_debug_level := fnd_log.g_current_runtime_level;
968:
969: IF (g_proc_level >= g_debug_level)
970: THEN
971: fnd_log.STRING(g_proc_level

Line 971: fnd_log.STRING(g_proc_level

967: --g_debug_level := fnd_log.g_current_runtime_level;
968:
969: IF (g_proc_level >= g_debug_level)
970: THEN
971: fnd_log.STRING(g_proc_level
972: ,g_module_prefix || l_api_name || '.begin'
973: ,NULL);
974: END IF;
975: --set_of_book_id

Line 1030: fnd_log.STRING(g_excep_level

1026: fnd_file.put_line(fnd_file.LOG, l_message);
1027: --l_message := 'RMA order with the number ' || l_cur_rcv_order_number || '-' ||
1028: -- l_cur_rcv_line_number ||
1029: -- ' doesn''t refer to any original sales order';
1030: fnd_log.STRING(g_excep_level
1031: ,g_module_prefix || l_api_name || '.evaluate'
1032: ,l_message);
1033:
1034: END IF; -- (g_proc_level >= g_debug_level)

Line 1087: fnd_log.STRING(g_excep_level

1083: WHEN no_data_found THEN
1084: l_no_appropriate_so_flag := 'Y';
1085: IF (g_excep_level >= g_debug_level)
1086: THEN
1087: fnd_log.STRING(g_excep_level
1088: ,g_module_prefix || l_api_name || '.exception'
1089: ,'no_data_found');
1090: END IF; --(g_proc_level >= g_debug_level)
1091: WHEN OTHERS THEN

Line 1094: fnd_log.STRING(g_excep_level

1090: END IF; --(g_proc_level >= g_debug_level)
1091: WHEN OTHERS THEN
1092: IF (g_excep_level >= g_debug_level)
1093: THEN
1094: fnd_log.STRING(g_excep_level
1095: ,g_module_prefix || l_api_name || '.exception'
1096: ,SQLERRM);
1097: END IF; --(g_proc_level >= g_debug_level)
1098: END;

Line 1122: fnd_log.STRING(g_excep_level

1118:
1119: l_message := fnd_message.GET();
1120:
1121: fnd_file.put_line(fnd_file.LOG, l_message);
1122: fnd_log.STRING(g_excep_level
1123: ,g_module_prefix || l_api_name || '.evaluate'
1124: ,l_message);
1125:
1126: END IF;--(g_proc_level >= g_debug_level)

Line 1143: fnd_log.STRING(g_excep_level

1139: IF (g_excep_level >= g_debug_level)
1140: THEN
1141:
1142: fnd_file.put_line(fnd_file.LOG, l_message);
1143: fnd_log.STRING(g_excep_level
1144: ,g_module_prefix || l_api_name || '.evaluate'
1145: ,l_message);
1146: END IF;--(g_proc_level >= g_debug_level)
1147: END IF; --l_cur_rcv_ordered_quantity < l_cur_rcv_shipped_quantity

Line 1252: fnd_log.STRING(g_excep_level

1248: WHEN OTHERS THEN
1249: ROLLBACK;
1250: IF (g_excep_level >= g_debug_level)
1251: THEN
1252: fnd_log.STRING(g_excep_level
1253: ,g_module_prefix || l_api_name || '.exception'
1254: ,SQLERRM);
1255: END IF;
1256: END cuar_get_rma_so;

Line 1279: -- g_debug_level := fnd_log.g_current_runtime_level;

1275:
1276: BEGIN
1277: l_api_name := 'is_current_period' ;
1278:
1279: -- g_debug_level := fnd_log.g_current_runtime_level;
1280:
1281: SELECT 1
1282: INTO l_number
1283: FROM ORG_ACCT_PERIODS

Line 1295: fnd_log.STRING(g_excep_level

1291: EXCEPTION
1292: WHEN no_data_found THEN
1293: IF (g_excep_level >= g_debug_level)
1294: THEN
1295: fnd_log.STRING(g_excep_level
1296: ,g_module_prefix || l_api_name || '.exception'
1297: ,'no_data_found');
1298: END IF;
1299:

Line 1305: fnd_log.STRING(g_excep_level

1301: WHEN OTHERS THEN
1302: ROLLBACK;
1303: IF (g_excep_level >= g_debug_level)
1304: THEN
1305: fnd_log.STRING(g_excep_level
1306: ,g_module_prefix || l_api_name || '.exception'
1307: ,SQLERRM);
1308: END IF;
1309: END is_current_period ;

Line 1334: -- g_debug_level := fnd_log.g_current_runtime_level;

1330: BEGIN
1331:
1332: l_api_name := 'cuar_get_item_cost' ;
1333:
1334: -- g_debug_level := fnd_log.g_current_runtime_level;
1335:
1336: SELECT item_cost
1337: INTO l_item_cost
1338: FROM cst_item_costs cost

Line 1347: fnd_log.STRING(g_excep_level

1343: EXCEPTION
1344: WHEN no_data_found THEN
1345: IF (g_excep_level >= g_debug_level)
1346: THEN
1347: fnd_log.STRING(g_excep_level
1348: ,g_module_prefix || l_api_name || '.exception'
1349: ,'no_data_found');
1350: END IF;
1351: RETURN(0);

Line 1357: fnd_log.STRING(g_excep_level

1353: WHEN OTHERS THEN
1354: ROLLBACK;
1355: IF (g_excep_level >= g_debug_level)
1356: THEN
1357: fnd_log.STRING(g_excep_level
1358: ,g_module_prefix || l_api_name || '.exception'
1359: ,SQLERRM);
1360: END IF;
1361:

Line 1385: --g_debug_level := fnd_log.g_current_runtime_level;

1381: BEGIN
1382:
1383: l_api_name := 'get_uom_primary' ;
1384:
1385: --g_debug_level := fnd_log.g_current_runtime_level;
1386:
1387: SELECT primary_unit_of_measure
1388: INTO l_primary_uom
1389: FROM mtl_system_items_b

Line 1398: fnd_log.STRING(g_excep_level

1394: EXCEPTION
1395: WHEN no_data_found THEN
1396: IF (g_excep_level >= g_debug_level)
1397: THEN
1398: fnd_log.STRING(g_excep_level
1399: ,g_module_prefix || l_api_name || '.exception'
1400: ,'no_data_found');
1401: END IF;
1402: RETURN(NULL);

Line 1408: fnd_log.STRING(g_excep_level

1404: WHEN OTHERS THEN
1405: ROLLBACK;
1406: IF (g_excep_level >= g_debug_level)
1407: THEN
1408: fnd_log.STRING(g_excep_level
1409: ,g_module_prefix || l_api_name || '.exception'
1410: ,SQLERRM);
1411: END IF;
1412:

Line 1435: --g_debug_level := fnd_log.g_current_runtime_level;

1431: BEGIN
1432:
1433: l_api_name := 'get_uom_primary_code' ;
1434:
1435: --g_debug_level := fnd_log.g_current_runtime_level;
1436:
1437: SELECT primary_uom_code
1438: INTO l_primary_uom_code
1439: FROM mtl_system_items_b

Line 1448: fnd_log.STRING(g_excep_level

1444: EXCEPTION
1445: WHEN no_data_found THEN
1446: IF (g_excep_level >= g_debug_level)
1447: THEN
1448: fnd_log.STRING(g_excep_level
1449: ,g_module_prefix || l_api_name || '.exception'
1450: ,'no_data_found');
1451: END IF;
1452: RETURN(NULL);

Line 1458: fnd_log.STRING(g_excep_level

1454: WHEN OTHERS THEN
1455: ROLLBACK;
1456: IF (g_excep_level >= g_debug_level)
1457: THEN
1458: fnd_log.STRING(g_excep_level
1459: ,g_module_prefix || l_api_name || '.exception'
1460: ,SQLERRM);
1461: END IF;
1462:

Line 1527: g_debug_level := fnd_log.g_current_runtime_level;

1523: l_api_name VARCHAR2(30);
1524: BEGIN
1525: l_api_name := 'get_uom_primary_qty_from_code' ;
1526:
1527: g_debug_level := fnd_log.g_current_runtime_level;
1528:
1529: l_primary_uom := get_uom_primary(p_inventory_item_id => p_inventory_item_id
1530: ,p_org_id => p_org_id);
1531: SELECT mtl_units_of_measure.unit_of_measure

Line 1548: fnd_log.STRING(g_excep_level

1544: EXCEPTION
1545: WHEN no_data_found THEN
1546: IF (g_excep_level >= g_debug_level)
1547: THEN
1548: fnd_log.STRING(g_excep_level
1549: ,g_module_prefix || l_api_name || '.exception'
1550: ,'no_data_found');
1551: END IF;
1552: RETURN(0);

Line 1558: fnd_log.STRING(g_excep_level

1554: WHEN OTHERS THEN
1555: ROLLBACK;
1556: IF (g_excep_level >= g_debug_level)
1557: THEN
1558: fnd_log.STRING(g_excep_level
1559: ,g_module_prefix || l_api_name || '.exception'
1560: ,SQLERRM);
1561: END IF;
1562: