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

Line 19: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting concurrent program');

15:
16: l_table c_all_tables%ROWTYPE;
17:
18: BEGIN
19: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Starting concurrent program');
20: IF p_table_name IS NOT NULL
21: THEN
22: l_app_id := -1;
23: SELECT application_id

Line 30: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table ' || p_table_name || ' does not exist in fnd_tables.');

26: WHERE table_name = p_table_name;
27:
28: IF l_app_id = -1
29: THEN
30: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table ' || p_table_name || ' does not exist in fnd_tables.');
31: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Current State not fetched.');
32: RETURN;
33: END IF;
34: l_ret_code := enable_tracking_for_table(l_app_id, p_table_name);

Line 144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Finished fetching current configuration.');

140: errbuf := 'Current state fetched.';
141: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', errbuf);
142: retcode := FND_API.G_RET_STS_SUCCESS;
143: END IF;
144: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Finished fetching current configuration.');
145: EXCEPTION WHEN OTHERS
146: THEN
147: l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', 'Current State not fetched.');
148: errbuf := SQLERRM;

Line 183: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done with ' || p_table_name);

179: IF l_ret_code = 0
180: THEN
181: RETURN l_ret_code;
182: END IF;
183: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done with ' || p_table_name);
184: COMMIT;
185: RETURN 1;
186: END enable_tracking_for_table;
187:

Line 209: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

205: RETURN 1;
206: EXCEPTION
207: WHEN OTHERS
208: THEN
209: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
210: -- dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
211: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Audit Start date not set for ' || p_table_name);
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Audit Start Date not set for ' || p_table_name);
213: RETURN 0;

Line 212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Audit Start Date not set for ' || p_table_name);

208: THEN
209: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
210: -- dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
211: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Audit Start date not set for ' || p_table_name);
212: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Audit Start Date not set for ' || p_table_name);
213: RETURN 0;
214: END set_audit_start_date;
215:
216:

Line 348: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

344: RETURN 1;
345: EXCEPTION
346: WHEN OTHERS
347: THEN
348: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
349: --dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
350: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Shadow trigger not created for ' || p_table_name);
351: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Shadow trigger not created for ' || p_table_name);
352: RETURN 0;

Line 351: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Shadow trigger not created for ' || p_table_name);

347: THEN
348: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
349: --dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
350: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Shadow trigger not created for ' || p_table_name);
351: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Shadow trigger not created for ' || p_table_name);
352: RETURN 0;
353: END create_shadow_trigger;
354:
355: FUNCTION record_current_state

Line 502: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

498: EXECUTE IMMEDIATE l_ins_sql;
499: EXCEPTION
500: WHEN OTHERS
501: THEN
502: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
503: fnd_file.put_line(fnd_file.LOG, 'Not fetched for ' || l_param_rec.column_name);
504: END;
505: END IF;
506: IF p_table_name = 'AP_SUPPLIER_SITES_ALL'

Line 503: fnd_file.put_line(fnd_file.LOG, 'Not fetched for ' || l_param_rec.column_name);

499: EXCEPTION
500: WHEN OTHERS
501: THEN
502: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
503: fnd_file.put_line(fnd_file.LOG, 'Not fetched for ' || l_param_rec.column_name);
504: END;
505: END IF;
506: IF p_table_name = 'AP_SUPPLIER_SITES_ALL'
507: THEN

Line 543: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

539: EXECUTE IMMEDIATE l_ins_sql;
540: EXCEPTION
541: WHEN OTHERS
542: THEN
543: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
544: fnd_file.put_line(fnd_file.LOG, 'Not fetched for ' || l_param_rec.column_name);
545: END;
546: END IF;
547: IF p_table_name <> 'FND_PROFILE_OPTION_VALUES' and p_table_name <> 'AP_SUPPLIERS' and

Line 544: fnd_file.put_line(fnd_file.LOG, 'Not fetched for ' || l_param_rec.column_name);

540: EXCEPTION
541: WHEN OTHERS
542: THEN
543: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
544: fnd_file.put_line(fnd_file.LOG, 'Not fetched for ' || l_param_rec.column_name);
545: END;
546: END IF;
547: IF p_table_name <> 'FND_PROFILE_OPTION_VALUES' and p_table_name <> 'AP_SUPPLIERS' and
548: p_table_name <> 'AP_SUPPLIER_SITES_ALL'

Line 584: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

580: EXECUTE IMMEDIATE l_ins_sql;
581: EXCEPTION
582: WHEN OTHERS
583: THEN
584: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
585: fnd_file.put_line(fnd_file.LOG, 'Not fetched for ' || l_param_rec.column_name);
586: END;
587: END IF;
588:

Line 585: fnd_file.put_line(fnd_file.LOG, 'Not fetched for ' || l_param_rec.column_name);

581: EXCEPTION
582: WHEN OTHERS
583: THEN
584: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
585: fnd_file.put_line(fnd_file.LOG, 'Not fetched for ' || l_param_rec.column_name);
586: END;
587: END IF;
588:
589: END LOOP;

Line 590: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State fetched for table - ' || p_table_name);

586: END;
587: END IF;
588:
589: END LOOP;
590: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State fetched for table - ' || p_table_name);
591: ELSE
592: -- Log that current state already fetched for l_setup_gp_code
593: --dbms_output.put_line('Current State already fetched for table - ' || p_table_name);
594: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State already fetched for table - ' || p_table_name);

Line 594: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State already fetched for table - ' || p_table_name);

590: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State fetched for table - ' || p_table_name);
591: ELSE
592: -- Log that current state already fetched for l_setup_gp_code
593: --dbms_output.put_line('Current State already fetched for table - ' || p_table_name);
594: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State already fetched for table - ' || p_table_name);
595: RETURN 2;
596: END IF;
597: RETURN 1;
598: EXCEPTION

Line 601: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

597: RETURN 1;
598: EXCEPTION
599: WHEN OTHERS
600: THEN
601: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
602: --dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
603: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Current state not fetched for ' || p_table_name);
604: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current state not fetched for ' || p_table_name);
605: RETURN 0;

Line 604: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current state not fetched for ' || p_table_name);

600: THEN
601: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
602: --dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
603: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Current state not fetched for ' || p_table_name);
604: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current state not fetched for ' || p_table_name);
605: RETURN 0;
606: END record_current_state;
607:
608: FUNCTION record_profile_current_state

Line 768: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State fetched for table - ' || p_table_name);

764: '(SELECT PARAMETER_CODE, isp.CREATED_BY, isp.CREATION_DATE, isp.LAST_UPDATE_DATE, isp.LAST_UPDATED_BY, isp.LAST_UPDATE_LOGIN, 1, prof.language, prof.source_lang, prof.user_profile_option_name ' ||
765: 'FROM ita_setup_parameters_b isp, fnd_profile_options_tl prof WHERE ''' || l_setup_gp_code || '.' || ''' || prof.profile_option_name = isp.parameter_code ' ||
766: 'AND (isp.parameter_code, prof.language) NOT IN (SELECT parameter_code, language from ita_setup_parameters_tl))';
767: EXECUTE IMMEDIATE l_ins_param_sql;
768: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State fetched for table - ' || p_table_name);
769: ELSE
770: -- Log that current state already fetched for l_setup_gp_code
771: --dbms_output.put_line('Current State already fetched for table - ' || p_table_name);
772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State already fetched for table - ' || p_table_name);

Line 772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State already fetched for table - ' || p_table_name);

768: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State fetched for table - ' || p_table_name);
769: ELSE
770: -- Log that current state already fetched for l_setup_gp_code
771: --dbms_output.put_line('Current State already fetched for table - ' || p_table_name);
772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current State already fetched for table - ' || p_table_name);
773: RETURN 2;
774: END IF;
775:
776: -- cpetriuc start - bug 5163722

Line 836: WHEN OTHERS THEN fnd_file.PUT_LINE(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));

832: l_update_sql := 'UPDATE ITA_SETUP_CHANGE_HISTORY SET CURRENT_VALUE = ''' || l_profile_value_meaning || ''' WHERE CHANGE_ID = ' || l_change_id;
833: EXECUTE IMMEDIATE l_update_sql;
834:
835: EXCEPTION
836: WHEN OTHERS THEN fnd_file.PUT_LINE(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));
837:
838: END;
839:
840:

Line 848: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

844: RETURN 1;
845: EXCEPTION
846: WHEN OTHERS
847: THEN
848: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
849: --dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
850: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Current state not fetched for ' || p_table_name);
851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current state not fetched for ' || p_table_name);
852: RETURN 0;

Line 851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current state not fetched for ' || p_table_name);

847: THEN
848: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
849: --dbms_output.put_line(SUBSTR (SQLERRM, 1, 2000));
850: --l_ret_val := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Current state not fetched for ' || p_table_name);
851: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Current state not fetched for ' || p_table_name);
852: RETURN 0;
853: END record_profile_current_state;
854:
855:

Line 914: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));

910:
911: EXCEPTION
912: WHEN OTHERS
913: THEN
914: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));
915: fnd_file.put_line(fnd_file.LOG, 'GET_PROFILE_VALUE_MEANING: SQL Statement: ' || l_profile_sql); -- cpetriuc - bug 5638086
916: --dbms_output.put_line(SUBSTR(SQLERRM, 1, 2000));
917: RETURN p_profile_value_code;
918:

Line 915: fnd_file.put_line(fnd_file.LOG, 'GET_PROFILE_VALUE_MEANING: SQL Statement: ' || l_profile_sql); -- cpetriuc - bug 5638086

911: EXCEPTION
912: WHEN OTHERS
913: THEN
914: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));
915: fnd_file.put_line(fnd_file.LOG, 'GET_PROFILE_VALUE_MEANING: SQL Statement: ' || l_profile_sql); -- cpetriuc - bug 5638086
916: --dbms_output.put_line(SUBSTR(SQLERRM, 1, 2000));
917: RETURN p_profile_value_code;
918:
919: END get_profile_value_meaning;

Line 990: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));

986:
987: EXCEPTION
988: WHEN OTHERS
989: THEN
990: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));
991: fnd_file.put_line(fnd_file.LOG, 'STRIP_PROFILE_QUERY: SQL Statement: ' || l_profile_sql); -- cpetriuc - bug 5638086
992: --dbms_output.put_line(SUBSTR(SQLERRM, 1, 2000));
993: RETURN p_profile_sql;
994:

Line 991: fnd_file.put_line(fnd_file.LOG, 'STRIP_PROFILE_QUERY: SQL Statement: ' || l_profile_sql); -- cpetriuc - bug 5638086

987: EXCEPTION
988: WHEN OTHERS
989: THEN
990: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));
991: fnd_file.put_line(fnd_file.LOG, 'STRIP_PROFILE_QUERY: SQL Statement: ' || l_profile_sql); -- cpetriuc - bug 5638086
992: --dbms_output.put_line(SUBSTR(SQLERRM, 1, 2000));
993: RETURN p_profile_sql;
994:
995: END strip_profile_query;

Line 1049: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));

1045:
1046: EXCEPTION
1047: WHEN OTHERS
1048: THEN
1049: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));
1050: fnd_file.put_line(fnd_file.LOG, 'STRIP_DOUBLE_QUOTES: SQL Statement: ' || l_profile_sql);
1051: --dbms_output.put_line(SUBSTR(SQLERRM, 1, 2000));
1052: RETURN p_profile_sql;
1053:

Line 1050: fnd_file.put_line(fnd_file.LOG, 'STRIP_DOUBLE_QUOTES: SQL Statement: ' || l_profile_sql);

1046: EXCEPTION
1047: WHEN OTHERS
1048: THEN
1049: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));
1050: fnd_file.put_line(fnd_file.LOG, 'STRIP_DOUBLE_QUOTES: SQL Statement: ' || l_profile_sql);
1051: --dbms_output.put_line(SUBSTR(SQLERRM, 1, 2000));
1052: RETURN p_profile_sql;
1053:
1054: END strip_double_quotes;

Line 1127: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));

1123:
1124: EXCEPTION
1125: WHEN OTHERS
1126: THEN
1127: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));
1128: fnd_file.put_line(fnd_file.LOG, 'STRIP_ALIASES: SQL Statement: ' || l_profile_sql);
1129: --dbms_output.put_line(SUBSTR(SQLERRM, 1, 2000));
1130: RETURN p_profile_sql;
1131:

Line 1128: fnd_file.put_line(fnd_file.LOG, 'STRIP_ALIASES: SQL Statement: ' || l_profile_sql);

1124: EXCEPTION
1125: WHEN OTHERS
1126: THEN
1127: fnd_file.put_line(fnd_file.LOG, SUBSTR(SQLERRM, 1, 2000));
1128: fnd_file.put_line(fnd_file.LOG, 'STRIP_ALIASES: SQL Statement: ' || l_profile_sql);
1129: --dbms_output.put_line(SUBSTR(SQLERRM, 1, 2000));
1130: RETURN p_profile_sql;
1131:
1132: END strip_aliases;