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

Line 36682: fnd_file.put_line(1, '');

36678: begin
36679: --Initializing global variable
36680:
36681: -- Print the input parameter values
36682: fnd_file.put_line(1, '');
36683: fnd_file.put_line(1, '***********************************************');
36684: fnd_file.put_line(1, '* Process Structure Update Concurrent Program *');
36685: fnd_file.put_line(1, '***********************************************');
36686: fnd_file.put_line(1, '');

Line 36683: fnd_file.put_line(1, '***********************************************');

36679: --Initializing global variable
36680:
36681: -- Print the input parameter values
36682: fnd_file.put_line(1, '');
36683: fnd_file.put_line(1, '***********************************************');
36684: fnd_file.put_line(1, '* Process Structure Update Concurrent Program *');
36685: fnd_file.put_line(1, '***********************************************');
36686: fnd_file.put_line(1, '');
36687: fnd_file.put_line(1,'Parameters List ');

Line 36684: fnd_file.put_line(1, '* Process Structure Update Concurrent Program *');

36680:
36681: -- Print the input parameter values
36682: fnd_file.put_line(1, '');
36683: fnd_file.put_line(1, '***********************************************');
36684: fnd_file.put_line(1, '* Process Structure Update Concurrent Program *');
36685: fnd_file.put_line(1, '***********************************************');
36686: fnd_file.put_line(1, '');
36687: fnd_file.put_line(1,'Parameters List ');
36688: fnd_file.put_line(1,'------------------------------------------------');

Line 36685: fnd_file.put_line(1, '***********************************************');

36681: -- Print the input parameter values
36682: fnd_file.put_line(1, '');
36683: fnd_file.put_line(1, '***********************************************');
36684: fnd_file.put_line(1, '* Process Structure Update Concurrent Program *');
36685: fnd_file.put_line(1, '***********************************************');
36686: fnd_file.put_line(1, '');
36687: fnd_file.put_line(1,'Parameters List ');
36688: fnd_file.put_line(1,'------------------------------------------------');
36689: fnd_file.put_line(1,'Operating Unit : '||p_operating_unit);

Line 36686: fnd_file.put_line(1, '');

36682: fnd_file.put_line(1, '');
36683: fnd_file.put_line(1, '***********************************************');
36684: fnd_file.put_line(1, '* Process Structure Update Concurrent Program *');
36685: fnd_file.put_line(1, '***********************************************');
36686: fnd_file.put_line(1, '');
36687: fnd_file.put_line(1,'Parameters List ');
36688: fnd_file.put_line(1,'------------------------------------------------');
36689: fnd_file.put_line(1,'Operating Unit : '||p_operating_unit);
36690: fnd_file.put_line(1,'From Project Number : '||p_project_num_from);

Line 36687: fnd_file.put_line(1,'Parameters List ');

36683: fnd_file.put_line(1, '***********************************************');
36684: fnd_file.put_line(1, '* Process Structure Update Concurrent Program *');
36685: fnd_file.put_line(1, '***********************************************');
36686: fnd_file.put_line(1, '');
36687: fnd_file.put_line(1,'Parameters List ');
36688: fnd_file.put_line(1,'------------------------------------------------');
36689: fnd_file.put_line(1,'Operating Unit : '||p_operating_unit);
36690: fnd_file.put_line(1,'From Project Number : '||p_project_num_from);
36691: fnd_file.put_line(1,'To Project Number : '||p_project_num_to);

Line 36688: fnd_file.put_line(1,'------------------------------------------------');

36684: fnd_file.put_line(1, '* Process Structure Update Concurrent Program *');
36685: fnd_file.put_line(1, '***********************************************');
36686: fnd_file.put_line(1, '');
36687: fnd_file.put_line(1,'Parameters List ');
36688: fnd_file.put_line(1,'------------------------------------------------');
36689: fnd_file.put_line(1,'Operating Unit : '||p_operating_unit);
36690: fnd_file.put_line(1,'From Project Number : '||p_project_num_from);
36691: fnd_file.put_line(1,'To Project Number : '||p_project_num_to);
36692: fnd_file.put_line(1, '');

Line 36689: fnd_file.put_line(1,'Operating Unit : '||p_operating_unit);

36685: fnd_file.put_line(1, '***********************************************');
36686: fnd_file.put_line(1, '');
36687: fnd_file.put_line(1,'Parameters List ');
36688: fnd_file.put_line(1,'------------------------------------------------');
36689: fnd_file.put_line(1,'Operating Unit : '||p_operating_unit);
36690: fnd_file.put_line(1,'From Project Number : '||p_project_num_from);
36691: fnd_file.put_line(1,'To Project Number : '||p_project_num_to);
36692: fnd_file.put_line(1, '');
36693: fnd_file.put_line(1, '');

Line 36690: fnd_file.put_line(1,'From Project Number : '||p_project_num_from);

36686: fnd_file.put_line(1, '');
36687: fnd_file.put_line(1,'Parameters List ');
36688: fnd_file.put_line(1,'------------------------------------------------');
36689: fnd_file.put_line(1,'Operating Unit : '||p_operating_unit);
36690: fnd_file.put_line(1,'From Project Number : '||p_project_num_from);
36691: fnd_file.put_line(1,'To Project Number : '||p_project_num_to);
36692: fnd_file.put_line(1, '');
36693: fnd_file.put_line(1, '');
36694: fnd_file.put_line(1, 'List of Projects and Structures processed by the concurrent request and their Status');

Line 36691: fnd_file.put_line(1,'To Project Number : '||p_project_num_to);

36687: fnd_file.put_line(1,'Parameters List ');
36688: fnd_file.put_line(1,'------------------------------------------------');
36689: fnd_file.put_line(1,'Operating Unit : '||p_operating_unit);
36690: fnd_file.put_line(1,'From Project Number : '||p_project_num_from);
36691: fnd_file.put_line(1,'To Project Number : '||p_project_num_to);
36692: fnd_file.put_line(1, '');
36693: fnd_file.put_line(1, '');
36694: fnd_file.put_line(1, 'List of Projects and Structures processed by the concurrent request and their Status');
36695: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');

Line 36692: fnd_file.put_line(1, '');

36688: fnd_file.put_line(1,'------------------------------------------------');
36689: fnd_file.put_line(1,'Operating Unit : '||p_operating_unit);
36690: fnd_file.put_line(1,'From Project Number : '||p_project_num_from);
36691: fnd_file.put_line(1,'To Project Number : '||p_project_num_to);
36692: fnd_file.put_line(1, '');
36693: fnd_file.put_line(1, '');
36694: fnd_file.put_line(1, 'List of Projects and Structures processed by the concurrent request and their Status');
36695: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36696: fnd_file.put_line(1, 'Project Number Structure Name Status');

Line 36693: fnd_file.put_line(1, '');

36689: fnd_file.put_line(1,'Operating Unit : '||p_operating_unit);
36690: fnd_file.put_line(1,'From Project Number : '||p_project_num_from);
36691: fnd_file.put_line(1,'To Project Number : '||p_project_num_to);
36692: fnd_file.put_line(1, '');
36693: fnd_file.put_line(1, '');
36694: fnd_file.put_line(1, 'List of Projects and Structures processed by the concurrent request and their Status');
36695: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36696: fnd_file.put_line(1, 'Project Number Structure Name Status');
36697: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');

Line 36694: fnd_file.put_line(1, 'List of Projects and Structures processed by the concurrent request and their Status');

36690: fnd_file.put_line(1,'From Project Number : '||p_project_num_from);
36691: fnd_file.put_line(1,'To Project Number : '||p_project_num_to);
36692: fnd_file.put_line(1, '');
36693: fnd_file.put_line(1, '');
36694: fnd_file.put_line(1, 'List of Projects and Structures processed by the concurrent request and their Status');
36695: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36696: fnd_file.put_line(1, 'Project Number Structure Name Status');
36697: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36698:

Line 36695: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');

36691: fnd_file.put_line(1,'To Project Number : '||p_project_num_to);
36692: fnd_file.put_line(1, '');
36693: fnd_file.put_line(1, '');
36694: fnd_file.put_line(1, 'List of Projects and Structures processed by the concurrent request and their Status');
36695: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36696: fnd_file.put_line(1, 'Project Number Structure Name Status');
36697: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36698:
36699: For i in cur_get_structures loop

Line 36696: fnd_file.put_line(1, 'Project Number Structure Name Status');

36692: fnd_file.put_line(1, '');
36693: fnd_file.put_line(1, '');
36694: fnd_file.put_line(1, 'List of Projects and Structures processed by the concurrent request and their Status');
36695: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36696: fnd_file.put_line(1, 'Project Number Structure Name Status');
36697: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36698:
36699: For i in cur_get_structures loop
36700: l_return_status := 'S';

Line 36697: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');

36693: fnd_file.put_line(1, '');
36694: fnd_file.put_line(1, 'List of Projects and Structures processed by the concurrent request and their Status');
36695: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36696: fnd_file.put_line(1, 'Project Number Structure Name Status');
36697: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36698:
36699: For i in cur_get_structures loop
36700: l_return_status := 'S';
36701: l_msg_count := 0;

Line 36737: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||l_return_status);

36733: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
36734: COMMIT;
36735: END IF;
36736:
36737: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||l_return_status);
36738: Else
36739: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||'A process is already running for this structure');
36740: End If;
36741:

Line 36739: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||'A process is already running for this structure');

36735: END IF;
36736:
36737: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||l_return_status);
36738: Else
36739: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||'A process is already running for this structure');
36740: End If;
36741:
36742: EXCEPTION
36743: WHEN FND_API.G_EXC_ERROR THEN

Line 36755: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||l_return_status||' - '||errbuf);

36751: ,p_msg_data => l_msg_data
36752: ,p_data => l_data
36753: ,p_msg_index_out => l_msg_index_out);
36754: errbuf := l_data;
36755: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||l_return_status||' - '||errbuf);
36756: END IF;
36757: ROLLBACK;
36758:
36759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 36771: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||l_return_status||' - '||errbuf);

36767: ,p_msg_data => l_msg_data
36768: ,p_data => l_data
36769: ,p_msg_index_out => l_msg_index_out);
36770: errbuf := l_data;
36771: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||l_return_status||' - '||errbuf);
36772: END IF;
36773: ROLLBACK;
36774:
36775: WHEN OTHERS THEN

Line 36778: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||l_return_status||' - '||errbuf);

36774:
36775: WHEN OTHERS THEN
36776: l_retcode := '1';
36777: errbuf := SQLERRM;
36778: fnd_file.put_line(1, rpad(i.project_number,30,' ')||rpad(substrb(i.structure_name,1,60),65,' ')||l_return_status||' - '||errbuf);
36779: ROLLBACK;
36780:
36781: end;
36782: end loop;

Line 36783: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');

36779: ROLLBACK;
36780:
36781: end;
36782: end loop;
36783: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36784: fnd_file.put_line(1, '');
36785: fnd_file.put_line(1, '');
36786:
36787: if l_retcode = 1 then

Line 36784: fnd_file.put_line(1, '');

36780:
36781: end;
36782: end loop;
36783: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36784: fnd_file.put_line(1, '');
36785: fnd_file.put_line(1, '');
36786:
36787: if l_retcode = 1 then
36788: retcode := '1';

Line 36785: fnd_file.put_line(1, '');

36781: end;
36782: end loop;
36783: fnd_file.put_line(1, '-----------------------------------------------------------------------------------------------------');
36784: fnd_file.put_line(1, '');
36785: fnd_file.put_line(1, '');
36786:
36787: if l_retcode = 1 then
36788: retcode := '1';
36789: else