DBA Data[Home] [Help]

APPS.PQP_FTE_UTILITIES dependencies on FND_FILE

Line 148: fnd_file.put_line(fnd_file.log,p_trace_message);

144: IF NOT g_is_concurrent_program_run THEN
145: pqp_utilities.debug(p_trace_message, p_trace_location);
146: ELSE
147: IF p_trace_location IS NULL THEN
148: fnd_file.put_line(fnd_file.log,p_trace_message);
149: ELSE
150: fnd_file.put_line(fnd_file.log,RPAD(p_trace_message,80,' ')||TO_CHAR(p_trace_location));
151: END IF;
152: END IF;

Line 150: fnd_file.put_line(fnd_file.log,RPAD(p_trace_message,80,' ')||TO_CHAR(p_trace_location));

146: ELSE
147: IF p_trace_location IS NULL THEN
148: fnd_file.put_line(fnd_file.log,p_trace_message);
149: ELSE
150: fnd_file.put_line(fnd_file.log,RPAD(p_trace_message,80,' ')||TO_CHAR(p_trace_location));
151: END IF;
152: END IF;
153: END debug;
154: --

Line 182: fnd_file.put_line(fnd_file.log,RPAD(p_proc_name,80,' ')||'+0');

178: BEGIN
179: IF NOT g_is_concurrent_program_run THEN
180: pqp_utilities.debug_enter(p_proc_name, p_trace_on);
181: ELSE
182: fnd_file.put_line(fnd_file.log,RPAD(p_proc_name,80,' ')||'+0');
183: END IF;
184: END debug_enter;
185: --
186: --

Line 197: fnd_file.put_line(fnd_file.log,RPAD(p_proc_name,80,' ')||'-0');

193: BEGIN
194: IF NOT g_is_concurrent_program_run THEN
195: pqp_utilities.debug_exit(p_proc_name, p_trace_off);
196: ELSE
197: fnd_file.put_line(fnd_file.log,RPAD(p_proc_name,80,' ')||'-0');
198: END IF;
199: END debug_exit;
200: --
201: --

Line 345: fnd_file.put_line

341:
342: WHILE i IS NOT NULL
343: LOOP
344:
345: fnd_file.put_line
346: (fnd_file.output
347: ,convert_record_to_outputstring(g_output_file_records(i))
348: );
349:

Line 346: (fnd_file.output

342: WHILE i IS NOT NULL
343: LOOP
344:
345: fnd_file.put_line
346: (fnd_file.output
347: ,convert_record_to_outputstring(g_output_file_records(i))
348: );
349:
350: i := g_output_file_records.NEXT(i);

Line 2135: fnd_file.put_line

2131: debug('p_calculation_date_txt:'||p_calculation_date);
2132: END IF;
2133:
2134: /* Corrected and added as a part of Bug#10239082 Starts
2135: fnd_file.put_line
2136: (fnd_file.log
2137: ,'Calculate FTE For Assignments - '||
2138: fnd_date.date_to_displaydate(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2139: ); */

Line 2136: (fnd_file.log

2132: END IF;
2133:
2134: /* Corrected and added as a part of Bug#10239082 Starts
2135: fnd_file.put_line
2136: (fnd_file.log
2137: ,'Calculate FTE For Assignments - '||
2138: fnd_date.date_to_displaydate(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2139: ); */
2140: fnd_file.put_line

Line 2140: fnd_file.put_line

2136: (fnd_file.log
2137: ,'Calculate FTE For Assignments - '||
2138: fnd_date.date_to_displaydate(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2139: ); */
2140: fnd_file.put_line
2141: (fnd_file.log
2142: ,'Calculate FTE For Assignments - '||
2143: fnd_date.date_to_displaydate(SYSDATE, calendar_aware => FND_DATE.calendar_aware_alt)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2144: );

Line 2141: (fnd_file.log

2137: ,'Calculate FTE For Assignments - '||
2138: fnd_date.date_to_displaydate(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2139: ); */
2140: fnd_file.put_line
2141: (fnd_file.log
2142: ,'Calculate FTE For Assignments - '||
2143: fnd_date.date_to_displaydate(SYSDATE, calendar_aware => FND_DATE.calendar_aware_alt)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2144: );
2145: /* Corrected and added as a part of Bug#10239082 Ends */

Line 2175: fnd_file.put_line

2171: INTO l_log_string
2172: FROM per_business_groups_perf
2173: WHERE business_group_id = l_business_group_id;
2174:
2175: fnd_file.put_line
2176: (fnd_file.log
2177: ,RPAD('Business Group',30,' ')||':'||l_log_string
2178: );
2179:

Line 2176: (fnd_file.log

2172: FROM per_business_groups_perf
2173: WHERE business_group_id = l_business_group_id;
2174:
2175: fnd_file.put_line
2176: (fnd_file.log
2177: ,RPAD('Business Group',30,' ')||':'||l_log_string
2178: );
2179:
2180: l_log_string := NULL;

Line 2194: fnd_file.put_line

2190: WHERE b.payroll_id = a.payroll_id
2191: );
2192: END IF;
2193:
2194: fnd_file.put_line
2195: (fnd_file.log
2196: ,RPAD('Payroll Name',30,' ')||':'||l_log_string
2197: );
2198:

Line 2195: (fnd_file.log

2191: );
2192: END IF;
2193:
2194: fnd_file.put_line
2195: (fnd_file.log
2196: ,RPAD('Payroll Name',30,' ')||':'||l_log_string
2197: );
2198:
2199: fnd_file.put_line

Line 2199: fnd_file.put_line

2195: (fnd_file.log
2196: ,RPAD('Payroll Name',30,' ')||':'||l_log_string
2197: );
2198:
2199: fnd_file.put_line
2200: (fnd_file.log
2201: ,RPAD('Contract Type',30,' ')||':'||p_contract_type
2202: );
2203: /* Corrected and added as a part of Bug#10239082 Starts

Line 2200: (fnd_file.log

2196: ,RPAD('Payroll Name',30,' ')||':'||l_log_string
2197: );
2198:
2199: fnd_file.put_line
2200: (fnd_file.log
2201: ,RPAD('Contract Type',30,' ')||':'||p_contract_type
2202: );
2203: /* Corrected and added as a part of Bug#10239082 Starts
2204: fnd_file.put_line

Line 2204: fnd_file.put_line

2200: (fnd_file.log
2201: ,RPAD('Contract Type',30,' ')||':'||p_contract_type
2202: );
2203: /* Corrected and added as a part of Bug#10239082 Starts
2204: fnd_file.put_line
2205: (fnd_file.log
2206: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date)
2207: ); */
2208: fnd_file.put_line

Line 2205: (fnd_file.log

2201: ,RPAD('Contract Type',30,' ')||':'||p_contract_type
2202: );
2203: /* Corrected and added as a part of Bug#10239082 Starts
2204: fnd_file.put_line
2205: (fnd_file.log
2206: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date)
2207: ); */
2208: fnd_file.put_line
2209: (fnd_file.log

Line 2208: fnd_file.put_line

2204: fnd_file.put_line
2205: (fnd_file.log
2206: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date)
2207: ); */
2208: fnd_file.put_line
2209: (fnd_file.log
2210: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date, calendar_aware => FND_DATE.calendar_aware_alt)
2211: );
2212: /* Corrected and added as a part of Bug#10239082 Ends */

Line 2209: (fnd_file.log

2205: (fnd_file.log
2206: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date)
2207: ); */
2208: fnd_file.put_line
2209: (fnd_file.log
2210: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date, calendar_aware => FND_DATE.calendar_aware_alt)
2211: );
2212: /* Corrected and added as a part of Bug#10239082 Ends */
2213:

Line 2217: fnd_file.put_line(fnd_file.log, l_message);

2213:
2214: /* if P_Payroll_ID IS NULL AND P_Contract_Type IS NULL then
2215: fnd_message.set_name('PQP', 'PQP_230686_FTE_PROG_FAIL_PARAM');
2216: l_message := fnd_message.get;
2217: fnd_file.put_line(fnd_file.log, l_message);
2218: fnd_message.raise_error;
2219: */
2220:
2221: IF (p_contract_type IS NOT NULL AND p_payroll_id IS NOT NULL)

Line 2289: fnd_file.put_line

2285: IF g_debug THEN
2286: debug(l_proc_name,l_proc_step);
2287: END IF;
2288:
2289: fnd_file.put_line
2290: (fnd_file.log
2291: ,'Number of Assignments To Process: '||l_assignment.COUNT
2292: );
2293:

Line 2290: (fnd_file.log

2286: debug(l_proc_name,l_proc_step);
2287: END IF;
2288:
2289: fnd_file.put_line
2290: (fnd_file.log
2291: ,'Number of Assignments To Process: '||l_assignment.COUNT
2292: );
2293:
2294:

Line 2295: fnd_file.put_line

2291: ,'Number of Assignments To Process: '||l_assignment.COUNT
2292: );
2293:
2294:
2295: fnd_file.put_line
2296: (fnd_file.log
2297: ,'Error Log:'
2298: );
2299:

Line 2296: (fnd_file.log

2292: );
2293:
2294:
2295: fnd_file.put_line
2296: (fnd_file.log
2297: ,'Error Log:'
2298: );
2299:
2300:

Line 2307: fnd_file.put_line

2303: WHILE i IS NOT NULL
2304: LOOP
2305:
2306: IF i = l_assignment.FIRST() THEN
2307: fnd_file.put_line
2308: (fnd_file.output
2309: ,RPAD('Status',30,' ')||g_column_separator||
2310: RPAD('Employee Number',20,' ')||g_column_separator||
2311: RPAD('Assignment_Number',30,' ')||g_column_separator||

Line 2308: (fnd_file.output

2304: LOOP
2305:
2306: IF i = l_assignment.FIRST() THEN
2307: fnd_file.put_line
2308: (fnd_file.output
2309: ,RPAD('Status',30,' ')||g_column_separator||
2310: RPAD('Employee Number',20,' ')||g_column_separator||
2311: RPAD('Assignment_Number',30,' ')||g_column_separator||
2312: RPAD('Effective Date',15,' ')||g_column_separator||

Line 2325: fnd_file.put_line

2321: RPAD('Period Divisor',15,' ')||g_column_separator||
2322: RPAD('Message',255,' ')
2323: );
2324:
2325: fnd_file.put_line
2326: (fnd_file.output
2327: ,RPAD('-',30,'-')||g_column_separator||
2328: RPAD('-',20,'-')||g_column_separator||
2329: RPAD('-',30,'-')||g_column_separator||

Line 2326: (fnd_file.output

2322: RPAD('Message',255,' ')
2323: );
2324:
2325: fnd_file.put_line
2326: (fnd_file.output
2327: ,RPAD('-',30,'-')||g_column_separator||
2328: RPAD('-',20,'-')||g_column_separator||
2329: RPAD('-',30,'-')||g_column_separator||
2330: RPAD('-',15,'-')||g_column_separator||

Line 2482: fnd_file.put_line

2478: l_errored := l_errored + 1;
2479:
2480: IF l_errored = 1 THEN
2481:
2482: fnd_file.put_line
2483: (fnd_file.log
2484: ,RPAD('Employee Number',15,' ')||g_column_separator||RPAD('Error Message',255,' ')
2485: );
2486:

Line 2483: (fnd_file.log

2479:
2480: IF l_errored = 1 THEN
2481:
2482: fnd_file.put_line
2483: (fnd_file.log
2484: ,RPAD('Employee Number',15,' ')||g_column_separator||RPAD('Error Message',255,' ')
2485: );
2486:
2487: fnd_file.put_line

Line 2487: fnd_file.put_line

2483: (fnd_file.log
2484: ,RPAD('Employee Number',15,' ')||g_column_separator||RPAD('Error Message',255,' ')
2485: );
2486:
2487: fnd_file.put_line
2488: (fnd_file.log
2489: ,RPAD('-',15,'-')||g_column_separator||RPAD('-',255,'-')
2490: );
2491:

Line 2488: (fnd_file.log

2484: ,RPAD('Employee Number',15,' ')||g_column_separator||RPAD('Error Message',255,' ')
2485: );
2486:
2487: fnd_file.put_line
2488: (fnd_file.log
2489: ,RPAD('-',15,'-')||g_column_separator||RPAD('-',255,'-')
2490: );
2491:
2492: END IF;

Line 2494: fnd_file.put_line

2490: );
2491:
2492: END IF;
2493:
2494: fnd_file.put_line
2495: (fnd_file.log
2496: ,RPAD(NVL(g_output_file_records(g_output_file_records.LAST).employee_number
2497: ,'Asg_Id:'||l_assignment(i)
2498: )

Line 2495: (fnd_file.log

2491:
2492: END IF;
2493:
2494: fnd_file.put_line
2495: (fnd_file.log
2496: ,RPAD(NVL(g_output_file_records(g_output_file_records.LAST).employee_number
2497: ,'Asg_Id:'||l_assignment(i)
2498: )
2499: ,15,' '

Line 2523: fnd_file.put_line

2519:
2520: ERRBUF := null;
2521: RETCODE:= 0;
2522:
2523: fnd_file.put_line
2524: (fnd_file.log
2525: ,'Number of Assignments Processed:'||l_processed
2526: );
2527:

Line 2524: (fnd_file.log

2520: ERRBUF := null;
2521: RETCODE:= 0;
2522:
2523: fnd_file.put_line
2524: (fnd_file.log
2525: ,'Number of Assignments Processed:'||l_processed
2526: );
2527:
2528: fnd_file.put_line

Line 2528: fnd_file.put_line

2524: (fnd_file.log
2525: ,'Number of Assignments Processed:'||l_processed
2526: );
2527:
2528: fnd_file.put_line
2529: (fnd_file.log
2530: ,'Number of Assignments Errored:'||l_errored
2531: );
2532:

Line 2529: (fnd_file.log

2525: ,'Number of Assignments Processed:'||l_processed
2526: );
2527:
2528: fnd_file.put_line
2529: (fnd_file.log
2530: ,'Number of Assignments Errored:'||l_errored
2531: );
2532:
2533: