DBA Data[Home] [Help]

APPS.PA_TASK_MANAGER dependencies on FND_FILE

Line 172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);

168: /* Code added for Bug#2701884, starts here */
169: IF l_debug_mode = 'Y' then
170: if x_msg_count = 0 then
171: tm_out(p_project_id, p_task_manager_person_id, l_tmp_str);
172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);
173: end if;
174: END IF;
175: /* Code added for Bug#2701884, ends here */
176:

Line 239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);

235: /* Code added for Bug#2701884, starts here */
236: IF l_debug_mode = 'Y' then
237: if x_msg_count = 0 then
238: tm_out(p_project_id, p_task_manager_person_id, l_tmp_str);
239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);
240: end if;
241: END IF;
242: /* Code added for Bug#2701884, ends here */
243:

Line 316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active);

312: END LOOP;
313: /* Code added for Bug#2701884, starts here */
314: if x_msg_count = 0 then
315: tm_out(p_project_id, p_task_manager_person_id, l_tmp_str);
316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active);
317: end if;
318: /* Code added for Bug#2701884, ends here */
319: END IF;
320:

Line 375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);

371: /* Code added for Bug#2701884, starts here */
372: IF l_debug_mode = 'Y' then
373: if x_msg_count = 0 then
374: tm_out(p_project_id, p_task_manager_person_id, l_tmp_str);
375: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);
376: end if;
377: END IF;
378: /* Code added for Bug#2701884, ends here */
379:

Line 441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);

437: /* Code added for Bug#2701884, starts here */
438: IF l_debug_mode = 'Y' then
439: if x_msg_count = 0 then
440: tm_out(p_project_id, p_task_manager_person_id, l_tmp_str);
441: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);
442: end if;
443: END IF;
444: /* Code added for Bug#2701884, ends here */
445:

Line 518: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active);

514: END LOOP;
515: /* Code added for Bug#2701884, starts here */
516: if x_msg_count = 0 then
517: tm_out(p_project_id, p_task_manager_person_id, l_tmp_str);
518: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active);
519: end if;
520: /* Code added for Bug#2701884, ends here * /
521: END IF;
522:

Line 577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);

573: /* Code added for Bug#2701884, starts here */
574: IF l_debug_mode = 'Y' then
575: if x_msg_count = 0 then
576: tm_out(p_project_id, p_task_manager_person_id, l_tmp_str);
577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);
578: end if;
579: END IF;
580: /* Code added for Bug#2701884, ends here */
581:

Line 642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);

638: /* Code added for Bug#2701884, starts here */
639: IF l_debug_mode = 'Y' then
640: if x_msg_count = 0 then
641: tm_out(p_project_id, p_task_manager_person_id, l_tmp_str);
642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active_tmp);
643: end if;
644: END IF;
645: /* Code added for Bug#2701884, ends here */
646:

Line 717: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active);

713: END LOOP;
714: /* Code added for Bug#2701884, starts here */
715: if x_msg_count = 0 then
716: tm_out(p_project_id, p_task_manager_person_id, l_tmp_str);
717: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active);
718: end if;
719: /* Code added for Bug#2701884, ends here */
720: END IF;
721: end if;

Line 919: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active);

915: END LOOP;
916: /* Code added for Bug#2701884, starts here */
917: if x_msg_count = 0 then
918: tm_out(l_selprojs_rec.project_id, l_seltaskmgrs_rec.task_manager_person_id, l_tmp_str);
919: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||l_start_date_active||' to '||l_end_date_active);
920: end if;
921: /* Code added for Bug#2701884, ends here */
922: END IF;
923:

Line 970: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(sysdate,'HH:MI:SS: ')|| p_message);

966: /* procedure to print the debug messages in the log file */
967:
968: procedure tm_log (p_message IN VARCHAR2) IS
969: begin
970: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(sysdate,'HH:MI:SS: ')|| p_message);
971: exception
972: when others then
973: raise;
974: end tm_log;

Line 1008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(l_proj_num,30,' ')||' '||rpad(l_emp_name,30,' ')||' '||substr(p_message,1,x));

1004: tm_log('len_msg:'||len_msg);
1005:
1006: if len_msg > 60 then
1007: x := 60;
1008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(l_proj_num,30,' ')||' '||rpad(l_emp_name,30,' ')||' '||substr(p_message,1,x));
1009: l_count_msg := floor(len_msg/60);
1010:
1011: for i in 2..l_count_msg loop
1012: tm_log('i:'||i);

Line 1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||substr(p_message, ((i-1)*60)+1, 60));

1009: l_count_msg := floor(len_msg/60);
1010:
1011: for i in 2..l_count_msg loop
1012: tm_log('i:'||i);
1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||substr(p_message, ((i-1)*60)+1, 60));
1014: x := i*60;
1015: end loop;
1016:
1017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||substr(p_message,x+1,len_msg));

Line 1017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||substr(p_message,x+1,len_msg));

1013: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||substr(p_message, ((i-1)*60)+1, 60));
1014: x := i*60;
1015: end loop;
1016:
1017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||substr(p_message,x+1,len_msg));
1018: else
1019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(l_proj_num,30,' ')||' '||rpad(l_emp_name,30,' ')||' '||p_message);
1020: end if;
1021:

Line 1019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(l_proj_num,30,' ')||' '||rpad(l_emp_name,30,' ')||' '||p_message);

1015: end loop;
1016:
1017: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(' ',30,' ')||' '||rpad(' ',30,' ')||' '||substr(p_message,x+1,len_msg));
1018: else
1019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' '||rpad(l_proj_num,30,' ')||' '||rpad(l_emp_name,30,' ')||' '||p_message);
1020: end if;
1021:
1022: end tm_out;
1023:

Line 1056: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1052:
1053: SELECT ' '||rpad(l_sob_name,30,' ')||lpad(l_tmp_str,75,' ')||sysdate
1054: INTO l_tblock
1055: FROM DUAL;
1056: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
1058: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1059:
1060: l_tmp_str := fnd_message.get_string('PA', 'PA_TM_RPT_HDR');

Line 1057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);

1053: SELECT ' '||rpad(l_sob_name,30,' ')||lpad(l_tmp_str,75,' ')||sysdate
1054: INTO l_tblock
1055: FROM DUAL;
1056: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
1058: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1059:
1060: l_tmp_str := fnd_message.get_string('PA', 'PA_TM_RPT_HDR');
1061:

Line 1058: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);

1054: INTO l_tblock
1055: FROM DUAL;
1056: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
1058: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1059:
1060: l_tmp_str := fnd_message.get_string('PA', 'PA_TM_RPT_HDR');
1061:
1062: SELECT lpad(l_tmp_str,66+length(l_tmp_str)/2,' ')

Line 1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);

1062: SELECT lpad(l_tmp_str,66+length(l_tmp_str)/2,' ')
1063: INTO l_tblock
1064: FROM DUAL;
1065:
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
1067: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1068:
1069:
1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');

Line 1067: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);

1063: INTO l_tblock
1064: FROM DUAL;
1065:
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
1067: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1068:
1069:
1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
1071: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');

1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_tblock);
1067: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1068:
1069:
1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
1071: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1072:
1073: l_tmp_str := fnd_message.get_string('PA', 'PA_TM_PROJ_NUM');
1074: l_tmp_str := ' '||rpad(l_tmp_str, 30, ' ');

Line 1071: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1067: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1068:
1069:
1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
1071: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1072:
1073: l_tmp_str := fnd_message.get_string('PA', 'PA_TM_PROJ_NUM');
1074: l_tmp_str := ' '||rpad(l_tmp_str, 30, ' ');
1075:

Line 1086: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);

1082: SELECT l_tmp_str||' '||l_tmp_str2||' '||l_tmp_str3
1083: INTO l_tblock
1084: FROM DUAL;
1085:
1086: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);
1087:
1088: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1089: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
1090: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 1088: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1084: FROM DUAL;
1085:
1086: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);
1087:
1088: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1089: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
1090: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1091:
1092: end;

Line 1089: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');

1085:
1086: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);
1087:
1088: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1089: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
1090: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1091:
1092: end;
1093:

Line 1090: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1086: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_tblock);
1087:
1088: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1089: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'----------------------------------------------------------------------------------------------------------------------------------');
1090: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1091:
1092: end;
1093:
1094: