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

Line 1744: fnd_file.put_line(FND_FILE.LOG,' ');

1740: '150: l_additional_where_clause '||l_additional_where_clause);
1741: END IF;
1742:
1743: -- put sql in log
1744: fnd_file.put_line(FND_FILE.LOG,' ');
1745: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1746: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1747: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1748: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');

Line 1745: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);

1741: END IF;
1742:
1743: -- put sql in log
1744: fnd_file.put_line(FND_FILE.LOG,' ');
1745: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1746: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1747: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1748: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1749: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);

Line 1746: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);

1742:
1743: -- put sql in log
1744: fnd_file.put_line(FND_FILE.LOG,' ');
1745: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1746: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1747: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1748: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1749: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1750: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1747: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);

1743: -- put sql in log
1744: fnd_file.put_line(FND_FILE.LOG,' ');
1745: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1746: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1747: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1748: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1749: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1750: fnd_file.put_line(FND_FILE.LOG,' ');
1751:

Line 1748: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');

1744: fnd_file.put_line(FND_FILE.LOG,' ');
1745: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1746: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1747: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1748: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1749: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1750: fnd_file.put_line(FND_FILE.LOG,' ');
1751:
1752: -- execute the dynamic sql

Line 1749: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);

1745: fnd_file.put_line(FND_FILE.LOG,'Variable : '||rec_rule_variables.variable_name);
1746: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1747: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1748: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1749: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1750: fnd_file.put_line(FND_FILE.LOG,' ');
1751:
1752: -- execute the dynamic sql
1753: BEGIN

Line 1750: fnd_file.put_line(FND_FILE.LOG,' ');

1746: fnd_file.put_line(FND_FILE.LOG,'Dynamic SQL for Valueset: '||rec_rule_variables.value_set_name);
1747: fnd_file.put_line(FND_FILE.LOG,'SELECT '||l_name_col||' , '||l_id_col);
1748: fnd_file.put_line(FND_FILE.LOG,'FROM '||l_table_name||' ');
1749: fnd_file.put_line(FND_FILE.LOG,l_additional_where_clause);
1750: fnd_file.put_line(FND_FILE.LOG,' ');
1751:
1752: -- execute the dynamic sql
1753: BEGIN
1754: -- EXECUTE IMMEDIATE l_sql_stmt