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.MTL_CROSS_REFERENCES_PVT dependencies on FND_FILE

Line 20: FND_FILE.put_line(FND_FILE.LOG, p_msg);

16: l_err_msg VARCHAR2(240);
17: BEGIN
18: -- If Profile set to TRUE --
19: IF (G_DEBUG = 1) THEN
20: FND_FILE.put_line(FND_FILE.LOG, p_msg);
21: END IF;
22:
23: EXCEPTION
24: WHEN OTHERS THEN

Line 26: FND_FILE.put_line(FND_FILE.LOG, 'LOGGING SQL ERROR => '||l_err_msg);

22:
23: EXCEPTION
24: WHEN OTHERS THEN
25: l_err_msg := SUBSTRB(SQLERRM, 1,240);
26: FND_FILE.put_line(FND_FILE.LOG, 'LOGGING SQL ERROR => '||l_err_msg);
27: END Write_Debug;
28:
29: -- -----------------------------------------------------------------------------
30: -- API Name: Process_XRef

Line 1720: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering process Item Cross References Import.');

1716: AND A.PROCESS_FLAG = 1;
1717:
1718: BEGIN
1719:
1720: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering process Item Cross References Import.');
1721: FND_FILE.PUT_LINE( FND_FILE.log,'Set Process Id : '||to_char(p_data_set_id));
1722: l_err_count := 0; -- start with no errors
1723: RETCODE := 0; -- assumes successful completion
1724:

Line 1721: FND_FILE.PUT_LINE( FND_FILE.log,'Set Process Id : '||to_char(p_data_set_id));

1717:
1718: BEGIN
1719:
1720: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering process Item Cross References Import.');
1721: FND_FILE.PUT_LINE( FND_FILE.log,'Set Process Id : '||to_char(p_data_set_id));
1722: l_err_count := 0; -- start with no errors
1723: RETCODE := 0; -- assumes successful completion
1724:
1725: FOR l_mtl_xref_rec IN c_intf_rows(p_data_set_id) LOOP

Line 2030: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processed '||To_Char(l_proc_rec_count)|| ' records.');

2026: ELSE
2027: RETCODE := 0;
2028: END IF;
2029:
2030: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processed '||To_Char(l_proc_rec_count)|| ' records.');
2031:
2032: FND_FILE.PUT_LINE( FND_FILE.LOG,'Exiting Item Cross References Import.');
2033:
2034: END Process_XRef_Intf_Rows;

Line 2032: FND_FILE.PUT_LINE( FND_FILE.LOG,'Exiting Item Cross References Import.');

2028: END IF;
2029:
2030: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processed '||To_Char(l_proc_rec_count)|| ' records.');
2031:
2032: FND_FILE.PUT_LINE( FND_FILE.LOG,'Exiting Item Cross References Import.');
2033:
2034: END Process_XRef_Intf_Rows;
2035:
2036: -- -----------------------------------------------------------------------------

Line 2110: FND_FILE.PUT_LINE(FND_FILE.LOG,'************************************') ;

2106: );
2107:
2108: -- Output error information into the log file
2109: if (to_number(nvl(fnd_profile.value('CONC_REQUEST_ID'),0)) <> 0) then
2110: FND_FILE.PUT_LINE(FND_FILE.LOG,'************************************') ;
2111: FND_FILE.PUT_LINE(FND_FILE.LOG,'TRANSACTION ID : ' || trans_id);
2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION ID : ' || org_id);
2113: FND_FILE.PUT_LINE(FND_FILE.LOG,'TABLE NAME : ' || tbl_name);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG,'COLUMN NAME : ' || p_column_name);

Line 2111: FND_FILE.PUT_LINE(FND_FILE.LOG,'TRANSACTION ID : ' || trans_id);

2107:
2108: -- Output error information into the log file
2109: if (to_number(nvl(fnd_profile.value('CONC_REQUEST_ID'),0)) <> 0) then
2110: FND_FILE.PUT_LINE(FND_FILE.LOG,'************************************') ;
2111: FND_FILE.PUT_LINE(FND_FILE.LOG,'TRANSACTION ID : ' || trans_id);
2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION ID : ' || org_id);
2113: FND_FILE.PUT_LINE(FND_FILE.LOG,'TABLE NAME : ' || tbl_name);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG,'COLUMN NAME : ' || p_column_name);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG,'MESSAGE NAME : ' || msg_name);

Line 2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION ID : ' || org_id);

2108: -- Output error information into the log file
2109: if (to_number(nvl(fnd_profile.value('CONC_REQUEST_ID'),0)) <> 0) then
2110: FND_FILE.PUT_LINE(FND_FILE.LOG,'************************************') ;
2111: FND_FILE.PUT_LINE(FND_FILE.LOG,'TRANSACTION ID : ' || trans_id);
2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION ID : ' || org_id);
2113: FND_FILE.PUT_LINE(FND_FILE.LOG,'TABLE NAME : ' || tbl_name);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG,'COLUMN NAME : ' || p_column_name);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG,'MESSAGE NAME : ' || msg_name);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR MESSAGE : ' || substrb(error_text,1,2000));

Line 2113: FND_FILE.PUT_LINE(FND_FILE.LOG,'TABLE NAME : ' || tbl_name);

2109: if (to_number(nvl(fnd_profile.value('CONC_REQUEST_ID'),0)) <> 0) then
2110: FND_FILE.PUT_LINE(FND_FILE.LOG,'************************************') ;
2111: FND_FILE.PUT_LINE(FND_FILE.LOG,'TRANSACTION ID : ' || trans_id);
2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION ID : ' || org_id);
2113: FND_FILE.PUT_LINE(FND_FILE.LOG,'TABLE NAME : ' || tbl_name);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG,'COLUMN NAME : ' || p_column_name);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG,'MESSAGE NAME : ' || msg_name);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR MESSAGE : ' || substrb(error_text,1,2000));
2117: end if ;

Line 2114: FND_FILE.PUT_LINE(FND_FILE.LOG,'COLUMN NAME : ' || p_column_name);

2110: FND_FILE.PUT_LINE(FND_FILE.LOG,'************************************') ;
2111: FND_FILE.PUT_LINE(FND_FILE.LOG,'TRANSACTION ID : ' || trans_id);
2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION ID : ' || org_id);
2113: FND_FILE.PUT_LINE(FND_FILE.LOG,'TABLE NAME : ' || tbl_name);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG,'COLUMN NAME : ' || p_column_name);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG,'MESSAGE NAME : ' || msg_name);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR MESSAGE : ' || substrb(error_text,1,2000));
2117: end if ;
2118:

Line 2115: FND_FILE.PUT_LINE(FND_FILE.LOG,'MESSAGE NAME : ' || msg_name);

2111: FND_FILE.PUT_LINE(FND_FILE.LOG,'TRANSACTION ID : ' || trans_id);
2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION ID : ' || org_id);
2113: FND_FILE.PUT_LINE(FND_FILE.LOG,'TABLE NAME : ' || tbl_name);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG,'COLUMN NAME : ' || p_column_name);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG,'MESSAGE NAME : ' || msg_name);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR MESSAGE : ' || substrb(error_text,1,2000));
2117: end if ;
2118:
2119: IF l_inv_debug_level IN(101, 102) THEN

Line 2116: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR MESSAGE : ' || substrb(error_text,1,2000));

2112: FND_FILE.PUT_LINE(FND_FILE.LOG,'ORGANIZATION ID : ' || org_id);
2113: FND_FILE.PUT_LINE(FND_FILE.LOG,'TABLE NAME : ' || tbl_name);
2114: FND_FILE.PUT_LINE(FND_FILE.LOG,'COLUMN NAME : ' || p_column_name);
2115: FND_FILE.PUT_LINE(FND_FILE.LOG,'MESSAGE NAME : ' || msg_name);
2116: FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR MESSAGE : ' || substrb(error_text,1,2000));
2117: end if ;
2118:
2119: IF l_inv_debug_level IN(101, 102) THEN
2120: INVPUTLI.info('INVPUOPI.mtl_log_interface_err: TRANSACTION ID : ' || trans_id);