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

Line 62: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration started');

58: if (upper(p_Debug_Flag) = 'Y') then
59: l_debug := true;
60: end if;
61:
62: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration started');
63: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
64:
65: Migrate_Perz_Data(ERRBUF,
66: RETCODE,

Line 63: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

59: l_debug := true;
60: end if;
61:
62: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration started');
63: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
64:
65: Migrate_Perz_Data(ERRBUF,
66: RETCODE,
67: p_Debug_Flag);

Line 94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration finished successfully');

90: Migrate_AS_PE_INT_CATEGORIES(ERRBUF,
91: RETCODE,
92: p_Debug_Flag);
93:
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration finished successfully');
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
96:
97: if (l_warning = 'Y') then
98: l_status := fnd_concurrent.set_completion_status('WARNING',FND_MESSAGE.Get_String('AS','API_REQUEST_WARNING_STATUS'));

Line 95: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

91: RETCODE,
92: p_Debug_Flag);
93:
94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration finished successfully');
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
96:
97: if (l_warning = 'Y') then
98: l_status := fnd_concurrent.set_completion_status('WARNING',FND_MESSAGE.Get_String('AS','API_REQUEST_WARNING_STATUS'));
99: end if;

Line 103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in migration '||SQLERRM);

99: end if;
100: EXCEPTION
101: WHEN OTHERS THEN
102: Rollback;
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in migration '||SQLERRM);
104: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
105: IF l_status = TRUE THEN
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
107: END IF ;

Line 106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

102: Rollback;
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in migration '||SQLERRM);
104: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
105: IF l_status = TRUE THEN
106: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
107: END IF ;
108: END Migrate_All;
109:
110: /*

Line 215: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);

211: WHEN OTHERS THEN
212: Rollback;
213: RETCODE := FND_API.G_RET_STS_ERROR;
214: ERRBUF := 'Error in perz data migration '||SQLERRM;
215: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
216: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
217: IF l_status = TRUE THEN
218: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
219: END IF ;

Line 218: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

214: ERRBUF := 'Error in perz data migration '||SQLERRM;
215: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
216: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
217: IF l_status = TRUE THEN
218: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
219: END IF ;
220: END Migrate_Perz_Data;
221:
222: PROCEDURE Process_Perz_Query_Params (

Line 315: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

311: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest type id ' || scr.parameter_value || ')'
312: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');
313: FND_MESSAGE.Set_Token('NAME', p_query_name);
314: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
315: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
316:
317: l_warning := 'Y';
318: exit;
319: end if;

Line 328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

324: -- 'Warning! Ignoring query ' || p_query_name || '(Interest type with id ' || scr.parameter_value || ' not mapped to any product category)'
325: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');
326: FND_MESSAGE.Set_Token('NAME', p_query_name);
327: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
329:
330: l_warning := 'Y';
331: exit;
332: end if;

Line 381: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

377: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest code id ' || l_sec_int_code_id || ')'
378: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING4');
379: FND_MESSAGE.Set_Token('NAME', p_query_name);
380: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);
381: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
382:
383: l_warning := 'Y';
384: exit;
385: end if;

Line 394: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

390: -- 'Warning! Ignoring query ' || p_query_name || '(Interest code with id ' || l_sec_int_code_id || ' not mapped to any product category)'
391: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING5');
392: FND_MESSAGE.Set_Token('NAME', p_query_name);
393: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);
394: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
395:
396: l_warning := 'Y';
397: exit;
398: end if;

Line 410: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

406: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest type id ' || scr.parameter_value || ')'
407: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');
408: FND_MESSAGE.Set_Token('NAME', p_query_name);
409: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
410: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
411:
412: l_warning := 'Y';
413: exit;
414: end if;

Line 423: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

419: -- 'Warning! Ignoring query ' || p_query_name || '(Interest type with id ' || scr.parameter_value || ' not mapped to any product category)'
420: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');
421: FND_MESSAGE.Set_Token('NAME', p_query_name);
422: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
423: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
424:
425: l_warning := 'Y';
426: exit;
427: end if;

Line 473: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured while processing query_id='||p_query_id);

469: end if;
470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured while processing query_id='||p_query_id);
474: RAISE;
475: END Process_Perz_Query_Params;
476:
477: /*

Line 643: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);

639: WHEN OTHERS THEN
640: Rollback;
641: RETCODE := FND_API.G_RET_STS_ERROR;
642: ERRBUF := 'Error in opportunity lines data migration '||SQLERRM;
643: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
644: -- Enable All the triggers (even in case of exception)
645: Enable_Triggers(l_lead_lines_biud,l_lead_lines_after_biud,l_sales_credits_biud,l_sales_credits_after_biud);
646: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
647: IF l_status = TRUE THEN

Line 648: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

644: -- Enable All the triggers (even in case of exception)
645: Enable_Triggers(l_lead_lines_biud,l_lead_lines_after_biud,l_sales_credits_biud,l_sales_credits_after_biud);
646: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
647: IF l_status = TRUE THEN
648: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
649: END IF ;
650: END Migrate_AS_LEAD_LINES_ALL;
651:
652: /*

Line 748: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);

744: WHEN OTHERS THEN
745: Rollback;
746: RETCODE := FND_API.G_RET_STS_ERROR;
747: ERRBUF := 'Error in forecast category data migration '||SQLERRM;
748: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
749: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
750: IF l_status = TRUE THEN
751: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
752: END IF ;

Line 751: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

747: ERRBUF := 'Error in forecast category data migration '||SQLERRM;
748: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
749: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
750: IF l_status = TRUE THEN
751: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
752: END IF ;
753: END Migrate_FST_SALES_CATEGORIES;
754:
755: /*

Line 874: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);

870: WHEN OTHERS THEN
871: Rollback;
872: RETCODE := FND_API.G_RET_STS_ERROR;
873: ERRBUF := 'Error in product interests data migration '||SQLERRM;
874: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
875: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
876: IF l_status = TRUE THEN
877: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
878: END IF ;

Line 877: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

873: ERRBUF := 'Error in product interests data migration '||SQLERRM;
874: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
875: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
876: IF l_status = TRUE THEN
877: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
878: END IF ;
879: END Migrate_AS_INTERESTS_ALL;
880:
881: /*

Line 1000: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);

996: WHEN OTHERS THEN
997: Rollback;
998: RETCODE := FND_API.G_RET_STS_ERROR;
999: ERRBUF := 'Error in opportunity logs data migration '||SQLERRM;
1000: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1001: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1002: IF l_status = TRUE THEN
1003: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1004: END IF ;

Line 1003: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

999: ERRBUF := 'Error in opportunity logs data migration '||SQLERRM;
1000: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1001: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1002: IF l_status = TRUE THEN
1003: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1004: END IF ;
1005: END Migrate_AS_LEAD_LINES_LOG;
1006:
1007: /*

Line 1126: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);

1122: WHEN OTHERS THEN
1123: Rollback;
1124: RETCODE := FND_API.G_RET_STS_ERROR;
1125: ERRBUF := 'Error in sales credits data migration '||SQLERRM;
1126: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1127: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1128: IF l_status = TRUE THEN
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1130: END IF ;

Line 1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

1125: ERRBUF := 'Error in sales credits data migration '||SQLERRM;
1126: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1127: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1128: IF l_status = TRUE THEN
1129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1130: END IF ;
1131: END Migrate_AS_SALES_C_DENORM;
1132:
1133: /*

Line 1231: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);

1227: WHEN OTHERS THEN
1228: Rollback;
1229: RETCODE := FND_API.G_RET_STS_ERROR;
1230: ERRBUF := 'Error in forecast product worksheet data migration '||SQLERRM;
1231: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1232: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1233: IF l_status = TRUE THEN
1234: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1235: END IF ;

Line 1234: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

1230: ERRBUF := 'Error in forecast product worksheet data migration '||SQLERRM;
1231: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1232: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1233: IF l_status = TRUE THEN
1234: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1235: END IF ;
1236: END Migrate_AS_PRODWKS_LINES;
1237:
1238: /*

Line 1304: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);

1300: WHEN OTHERS THEN
1301: Rollback;
1302: RETCODE := FND_API.G_RET_STS_ERROR;
1303: ERRBUF := 'Error in plan element categories '||SQLERRM;
1304: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1305: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1306: IF l_status = TRUE THEN
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1308: END IF ;

Line 1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;

1303: ERRBUF := 'Error in plan element categories '||SQLERRM;
1304: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
1305: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1306: IF l_status = TRUE THEN
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1308: END IF ;
1309: END Migrate_AS_PE_INT_CATEGORIES;
1310:
1311: /*