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.OPI_DBI_BOUNDS_PKG dependencies on FND_PROFILE

Line 42: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

38: l_program_application_id NUMBER ;
39: l_request_id NUMBER ;
40:
41: BEGIN
42: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
43: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
44: l_proc_name := 'maintain_opi_dbi_logs';
45:
46: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);

Line 43: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

39: l_request_id NUMBER ;
40:
41: BEGIN
42: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
43: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
44: l_proc_name := 'maintain_opi_dbi_logs';
45:
46: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
47: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);

Line 331: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

327: l_stmt_no NUMBER :=0;
328: l_proc_name VARCHAR2(40);
329: l_module_name VARCHAR2(40);
330: BEGIN
331: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
332: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
333: l_proc_name := 'call_etl_specific_bound';
334:
335: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN

Line 332: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

328: l_proc_name VARCHAR2(40);
329: l_module_name VARCHAR2(40);
330: BEGIN
331: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
332: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
333: l_proc_name := 'call_etl_specific_bound';
334:
335: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
336: l_debug_msg := 'inside call_etl_specific_bound. '||p_load_type||' load' ;

Line 430: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

426: l_stmt_no NUMBER :=0;
427: l_proc_name VARCHAR2(40);
428: l_module_name VARCHAR2(40);
429: BEGIN
430: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
431: l_proc_name := 'setup_inv_mmt_bounds';
432: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
433:
434: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN

Line 432: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

428: l_module_name VARCHAR2(40);
429: BEGIN
430: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
431: l_proc_name := 'setup_inv_mmt_bounds';
432: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
433:
434: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
435: l_debug_msg := 'inside setup inv mmt bounds '||p_load_type||' load' ;
436: opi_dbi_bounds_pkg.write(g_pkg_name, l_proc_name, l_stmt_no, l_debug_msg);

Line 472: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

468: l_stmt_no NUMBER := 0;
469: l_proc_name VARCHAR2(40);
470: l_module_name VARCHAR2(40);
471: BEGIN
472: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
473: l_proc_name := 'setup_cogs_mmt_bounds';
474:
475:
476: if (p_load_type = 'INIT') then

Line 508: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

504: l_debug_mode VARCHAR2(1);
505: l_stmt_no NUMBER := 0;
506: l_module_name VARCHAR2(40);
507: BEGIN
508: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
509: l_proc_name := 'setup_cogs_mmt_bounds';
510: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
511:
512: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN

Line 510: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

506: l_module_name VARCHAR2(40);
507: BEGIN
508: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
509: l_proc_name := 'setup_cogs_mmt_bounds';
510: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
511:
512: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
513: l_debug_msg := 'inside setup_cc_mmt_bounds '||p_load_type||' load' ;
514: opi_dbi_bounds_pkg.write(g_pkg_name, l_proc_name, l_stmt_no, l_debug_msg);

Line 566: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

562: l_program_application_id NUMBER ;
563: l_request_id NUMBER ;
564:
565: BEGIN
566: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
567: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
568: l_proc_name := 'create_first_mmt_bounds';
569:
570: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);

Line 567: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

563: l_request_id NUMBER ;
564:
565: BEGIN
566: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
567: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
568: l_proc_name := 'create_first_mmt_bounds';
569:
570: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
571: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);

Line 894: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

890: WHERE etl_type = p_etl_type
891: AND driving_table_code = 'MMT';
892:
893: BEGIN
894: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
895: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
896: l_proc_name := 'set_mmt_new_bounds';
897:
898: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);

Line 895: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

891: AND driving_table_code = 'MMT';
892:
893: BEGIN
894: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
895: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
896: l_proc_name := 'set_mmt_new_bounds';
897:
898: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
899: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);

Line 1061: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

1057: l_program_application_id NUMBER ;
1058: l_request_id NUMBER ;
1059:
1060: BEGIN
1061: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1062: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1063: l_proc_name := 'setup_inv_wta_bounds';
1064:
1065: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);

Line 1062: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1058: l_request_id NUMBER ;
1059:
1060: BEGIN
1061: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1062: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1063: l_proc_name := 'setup_inv_wta_bounds';
1064:
1065: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1066: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);

Line 1207: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

1203:
1204:
1205: BEGIN
1206:
1207: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1208: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1209: l_proc_name := 'set_sysdate_bounds';
1210:
1211: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);

Line 1208: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1204:
1205: BEGIN
1206:
1207: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1208: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1209: l_proc_name := 'set_sysdate_bounds';
1210:
1211: l_program_id := NVL(fnd_global.CONC_PROGRAM_ID,-1);
1212: l_program_login_id := NVL(fnd_global.CONC_LOGIN_ID,-1);

Line 1324: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

1320: l_debug_mode VARCHAR2(1);
1321: l_module_name VARCHAR2(40);
1322:
1323: BEGIN
1324: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1325: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1326: l_proc_name := 'set_load_successful';
1327:
1328: l_stmt_no := 10;

Line 1325: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1321: l_module_name VARCHAR2(40);
1322:
1323: BEGIN
1324: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1325: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1326: l_proc_name := 'set_load_successful';
1327:
1328: l_stmt_no := 10;
1329: UPDATE OPI_DBI_CONC_PROG_RUN_LOG

Line 1365: -- l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1361: -- l_debug_mode VARCHAR2(1);
1362: l_proc_name VARCHAR2(40);
1363: -- l_module_name VARCHAR2(40);
1364: BEGIN
1365: -- l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1366: -- l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1367:
1368: /*
1369: insert into mano_log (pkg, proc_name, stmt_no, msg )

Line 1366: -- l_module_name := FND_PROFILE.value('AFLOG_MODULE');

1362: l_proc_name VARCHAR2(40);
1363: -- l_module_name VARCHAR2(40);
1364: BEGIN
1365: -- l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1366: -- l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1367:
1368: /*
1369: insert into mano_log (pkg, proc_name, stmt_no, msg )
1370: select p_pkg_name, p_proc_name, p_stmt_no, p_debug_msg from dual;

Line 1559: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1555: l_debug_mode VARCHAR2(1);
1556: l_module_name VARCHAR2(40);
1557: BEGIN
1558: l_proc_name := 'load_opm_org_ledger_data';
1559: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1560: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1561:
1562: -- Deleting rows from the temp table to avoid any undesirable data.
1563:

Line 1560: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

1556: l_module_name VARCHAR2(40);
1557: BEGIN
1558: l_proc_name := 'load_opm_org_ledger_data';
1559: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1560: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1561:
1562: -- Deleting rows from the temp table to avoid any undesirable data.
1563:
1564: l_stmt_no := 10;