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_INV_VALUE_OPM_INCR_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 136: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' Onhand transactions collected from permanent subledger.');

132:
133: EXECUTE IMMEDIATE lv_sql USING from_transaction_id, to_transaction_id, g_global_start_date,
134: g_global_start_date, g_global_start_date;
135:
136: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' Onhand transactions collected from permanent subledger.');
137: COMMIT;
138:
139: EXCEPTION
140: WHEN OTHERS

Line 142: bis_collection_utilities.put_line ('Refresh_ONH_LED_Current error: '|| sqlerrm);

138:
139: EXCEPTION
140: WHEN OTHERS
141: THEN
142: bis_collection_utilities.put_line ('Refresh_ONH_LED_Current error: '|| sqlerrm);
143: RAISE;
144:
145: END Refresh_ONH_LED_Current;
146:

Line 240: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' Onhand Inventory Revaluation transactions collected from permanent subledger.');

236: led.gl_doc_date';
237:
238: EXECUTE IMMEDIATE lv_sql USING from_transaction_id, to_transaction_id, g_global_start_date;
239:
240: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' Onhand Inventory Revaluation transactions collected from permanent subledger.');
241: COMMIT;
242:
243: EXCEPTION
244: WHEN OTHERS

Line 246: bis_collection_utilities.put_line ('Refresh_RVAL_LED_Current error: '|| sqlerrm);

242:
243: EXCEPTION
244: WHEN OTHERS
245: THEN
246: bis_collection_utilities.put_line ('Refresh_RVAL_LED_Current error: '|| sqlerrm);
247: RAISE;
248:
249: END Refresh_RVAL_LED_Current;
250:

Line 432: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' intransit transactions collected from permanent subledger.');

428: GROUP BY whse_code, item_id, trans_date)';
429:
430: EXECUTE IMMEDIATE lv_sql USING p_from_subledger_id, p_to_subledger_id, g_global_start_date;
431:
432: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' intransit transactions collected from permanent subledger.');
433: COMMIT;
434:
435: EXCEPTION
436: WHEN OTHERS

Line 438: bis_collection_utilities.put_line ('Refresh_ITR_LED_Current: '|| sqlerrm);

434:
435: EXCEPTION
436: WHEN OTHERS
437: THEN
438: bis_collection_utilities.put_line ('Refresh_ITR_LED_Current: '|| sqlerrm);
439: RAISE;
440:
441: END Refresh_ITR_LED_Current;
442:

Line 779: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' Internal Order transactions collected from permanent subledger.');

775: p_from_subledger_id,
776: p_to_subledger_id,
777: g_global_start_date;
778:
779: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' Internal Order transactions collected from permanent subledger.');
780: COMMIT;
781:
782: EXCEPTION
783: WHEN OTHERS

Line 785: bis_collection_utilities.put_line ('Refresh_IOR_LED_Current: '|| sqlerrm);

781:
782: EXCEPTION
783: WHEN OTHERS
784: THEN
785: bis_collection_utilities.put_line ('Refresh_IOR_LED_Current: '|| sqlerrm);
786: RAISE;
787:
788: END Refresh_IOR_LED_Current;
789:

Line 848: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' WIP transactions collected from permanent subledger.');

844: led.transaction_date';
845:
846: EXECUTE IMMEDIATE lv_sql USING from_transaction_id, to_transaction_id, g_global_start_date;
847:
848: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' WIP transactions collected from permanent subledger.');
849: COMMIT;
850:
851: EXCEPTION
852: WHEN OTHERS

Line 854: bis_collection_utilities.put_line ('Refresh_WIP_LED_Current: '|| sqlerrm);

850:
851: EXCEPTION
852: WHEN OTHERS
853: THEN
854: bis_collection_utilities.put_line ('Refresh_WIP_LED_Current: '|| sqlerrm);
855: RAISE;
856:
857: END Refresh_WIP_LED_Current;
858:

Line 962: bis_collection_utilities.put_line(TO_CHAR(SQL%ROWCOUNT) || ' Subledger Net Change rows identified.');

958: AND msi.organization_id = whse.mtl_organization_id
959: AND msi.segment1 = iim.item_no
960: ;
961:
962: bis_collection_utilities.put_line(TO_CHAR(SQL%ROWCOUNT) || ' Subledger Net Change rows identified.');
963:
964: fnd_stats.gather_table_stats(
965: ownname => g_opi_schema,
966: tabname => 'OPI_DBI_OPM_INV_STG',

Line 974: bis_collection_utilities.put_line ('Put_Net_Activity_to_Stg: '|| sqlerrm);

970:
971: EXCEPTION
972: WHEN OTHERS
973: THEN
974: bis_collection_utilities.put_line ('Put_Net_Activity_to_Stg: '|| sqlerrm);
975: RAISE;
976:
977: END Put_Net_Activity_to_Stg;
978:

Line 993: bis_collection_utilities.put_line('Start of collecting daily activity.');

989: l_status VARCHAR2(20);
990: l_return NUMBER;
991:
992: BEGIN
993: bis_collection_utilities.put_line('Start of collecting daily activity.');
994: l_return := 0;
995:
996: BEGIN
997: /* SELECT

Line 1021: bis_collection_utilities.put_line('Missing log record indicates that Initial Load of Inventory did not complete successfully.');

1017:
1018:
1019: EXCEPTION
1020: WHEN OTHERS THEN
1021: bis_collection_utilities.put_line('Missing log record indicates that Initial Load of Inventory did not complete successfully.');
1022: bis_collection_utilities.put_line('Please verify the successful completion of Initial Load before submitting Incremental Load.');
1023: RAISE;
1024: END;
1025:

Line 1022: bis_collection_utilities.put_line('Please verify the successful completion of Initial Load before submitting Incremental Load.');

1018:
1019: EXCEPTION
1020: WHEN OTHERS THEN
1021: bis_collection_utilities.put_line('Missing log record indicates that Initial Load of Inventory did not complete successfully.');
1022: bis_collection_utilities.put_line('Please verify the successful completion of Initial Load before submitting Incremental Load.');
1023: RAISE;
1024: END;
1025:
1026: bis_collection_utilities.put_line('Starting Transaction_ID = ' || to_char(l_from_transaction_id));

Line 1026: bis_collection_utilities.put_line('Starting Transaction_ID = ' || to_char(l_from_transaction_id));

1022: bis_collection_utilities.put_line('Please verify the successful completion of Initial Load before submitting Incremental Load.');
1023: RAISE;
1024: END;
1025:
1026: bis_collection_utilities.put_line('Starting Transaction_ID = ' || to_char(l_from_transaction_id));
1027: bis_collection_utilities.put_line('Ending Transaction_ID = ' || to_char(l_to_transaction_id));
1028: IF (l_to_transaction_id is not NULL AND l_from_transaction_id is not null) THEN
1029: Refresh_ONH_LED_Current(l_from_transaction_id, l_to_transaction_id);
1030: Refresh_RVAL_LED_Current(l_from_transaction_id, l_to_transaction_id);

Line 1027: bis_collection_utilities.put_line('Ending Transaction_ID = ' || to_char(l_to_transaction_id));

1023: RAISE;
1024: END;
1025:
1026: bis_collection_utilities.put_line('Starting Transaction_ID = ' || to_char(l_from_transaction_id));
1027: bis_collection_utilities.put_line('Ending Transaction_ID = ' || to_char(l_to_transaction_id));
1028: IF (l_to_transaction_id is not NULL AND l_from_transaction_id is not null) THEN
1029: Refresh_ONH_LED_Current(l_from_transaction_id, l_to_transaction_id);
1030: Refresh_RVAL_LED_Current(l_from_transaction_id, l_to_transaction_id);
1031: Refresh_ITR_LED_Current(l_from_transaction_id, l_to_transaction_id);

Line 1047: bis_collection_utilities.put_line('End of collecting daily activity.');

1043: --Move_ONH_TST_Current_to_Prior;
1044:
1045: --put call for log
1046:
1047: bis_collection_utilities.put_line('End of collecting daily activity.');
1048: commit;
1049:
1050: return l_return;
1051:

Line 1055: bis_collection_utilities.put_line ('Get_OPM_Net_Activity: '|| sqlerrm);

1051:
1052: EXCEPTION
1053: WHEN OTHERS
1054: THEN
1055: bis_collection_utilities.put_line ('Get_OPM_Net_Activity: '|| sqlerrm);
1056: RAISE;
1057:
1058: END Get_OPM_Net_Activity;
1059:

Line 1082: bis_collection_utilities.put_line(

1078: l_list(1) := 'BIS_GLOBAL_START_DATE';
1079: l_list(2) := 'BIS_PRIMARY_CURRENCY_CODE';
1080: IF (NOT BIS_COMMON_PARAMETERS.CHECK_GLOBAL_PARAMETERS(l_list))
1081: THEN
1082: bis_collection_utilities.put_line(
1083: 'Missing global parameters. ' ||
1084: 'Please setup global_start_date and primary_currency_code first.');
1085: retcode := 1;
1086: return;

Line 1094: bis_collection_utilities.put_line('Set global variables.');

1090:
1091: -- If initial load hasn't been run yet, exit and warn.
1092:
1093: -- set global variables
1094: bis_collection_utilities.put_line('Set global variables.');
1095: l_rows1 := 0;
1096: l_rows2 := 0;
1097: g_sysdate := sysdate;
1098: g_created_by := fnd_global.user_id;

Line 1102: bis_collection_utilities.put_line('Collection started at ' || TO_CHAR(g_sysdate, 'DD-MON-YYYY HH24:MI:SS'));

1098: g_created_by := fnd_global.user_id;
1099: g_last_update_login := fnd_global.login_id;
1100: g_last_updated_by := fnd_global.user_id;
1101:
1102: bis_collection_utilities.put_line('Collection started at ' || TO_CHAR(g_sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1103:
1104: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into g_global_start_date from DUAL;
1105: IF g_global_start_date IS NULL
1106: THEN

Line 1107: bis_collection_utilities.put_line('Global start date is not available. Can not proceed.');

1103:
1104: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into g_global_start_date from DUAL;
1105: IF g_global_start_date IS NULL
1106: THEN
1107: bis_collection_utilities.put_line('Global start date is not available. Can not proceed.');
1108: return;
1109: END IF;
1110:
1111:

Line 1117: bis_collection_utilities.put_line('Fail to collect daily activity into staging table.');

1113:
1114: -- collect new activity
1115: IF (Get_OPM_Net_Activity (errbuf, retcode) = -1)
1116: THEN
1117: bis_collection_utilities.put_line('Fail to collect daily activity into staging table.');
1118: ELSE
1119: COMMIT;
1120: END IF;
1121:

Line 1124: bis_collection_utilities.put_line('Successfully refreshed inventory value base table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));

1120: END IF;
1121:
1122: -- SETUP/WRAPUP: take out wrapup api call, to be safe, put a commit, log message here.
1123: commit;
1124: bis_collection_utilities.put_line('Successfully refreshed inventory value base table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1125: bis_collection_utilities.put_line(TO_CHAR(l_rows1 + l_rows2) || ' rows have been inserted from OPM');
1126: return;
1127:
1128: EXCEPTION

Line 1125: bis_collection_utilities.put_line(TO_CHAR(l_rows1 + l_rows2) || ' rows have been inserted from OPM');

1121:
1122: -- SETUP/WRAPUP: take out wrapup api call, to be safe, put a commit, log message here.
1123: commit;
1124: bis_collection_utilities.put_line('Successfully refreshed inventory value base table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
1125: bis_collection_utilities.put_line(TO_CHAR(l_rows1 + l_rows2) || ' rows have been inserted from OPM');
1126: return;
1127:
1128: EXCEPTION
1129: WHEN OTHERS THEN

Line 1130: bis_collection_utilities.put_line('Failed in refreshing inventory value base table.');

1126: return;
1127:
1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: bis_collection_utilities.put_line('Failed in refreshing inventory value base table.');
1131: bis_collection_utilities.put_line(SQLERRM);
1132: retcode := SQLCODE;
1133: errbuf := SQLERRM;
1134: RAISE_APPLICATION_ERROR(-20000,errbuf);

Line 1131: bis_collection_utilities.put_line(SQLERRM);

1127:
1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: bis_collection_utilities.put_line('Failed in refreshing inventory value base table.');
1131: bis_collection_utilities.put_line(SQLERRM);
1132: retcode := SQLCODE;
1133: errbuf := SQLERRM;
1134: RAISE_APPLICATION_ERROR(-20000,errbuf);
1135: RETURN;