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 328: fnd_file.put_line

324:
325: WHILE i IS NOT NULL
326: LOOP
327:
328: fnd_file.put_line
329: (fnd_file.output
330: ,convert_record_to_outputstring(g_output_file_records(i))
331: );
332:

Line 329: (fnd_file.output

325: WHILE i IS NOT NULL
326: LOOP
327:
328: fnd_file.put_line
329: (fnd_file.output
330: ,convert_record_to_outputstring(g_output_file_records(i))
331: );
332:
333: i := g_output_file_records.NEXT(i);

Line 2085: fnd_file.put_line

2081: debug('p_contract_type:'||p_contract_type);
2082: debug('p_calculation_date_txt:'||p_calculation_date);
2083: END IF;
2084:
2085: fnd_file.put_line
2086: (fnd_file.log
2087: ,'Calculate FTE For Assignments - '||
2088: fnd_date.date_to_displaydate(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2089: );

Line 2086: (fnd_file.log

2082: debug('p_calculation_date_txt:'||p_calculation_date);
2083: END IF;
2084:
2085: fnd_file.put_line
2086: (fnd_file.log
2087: ,'Calculate FTE For Assignments - '||
2088: fnd_date.date_to_displaydate(SYSDATE)||' '||TO_CHAR(SYSDATE,'HH24:MI:SS')
2089: );
2090:

Line 2120: fnd_file.put_line

2116: INTO l_log_string
2117: FROM per_business_groups_perf
2118: WHERE business_group_id = l_business_group_id;
2119:
2120: fnd_file.put_line
2121: (fnd_file.log
2122: ,RPAD('Business Group',30,' ')||':'||l_log_string
2123: );
2124:

Line 2121: (fnd_file.log

2117: FROM per_business_groups_perf
2118: WHERE business_group_id = l_business_group_id;
2119:
2120: fnd_file.put_line
2121: (fnd_file.log
2122: ,RPAD('Business Group',30,' ')||':'||l_log_string
2123: );
2124:
2125: l_log_string := NULL;

Line 2139: fnd_file.put_line

2135: WHERE b.payroll_id = a.payroll_id
2136: );
2137: END IF;
2138:
2139: fnd_file.put_line
2140: (fnd_file.log
2141: ,RPAD('Payroll Name',30,' ')||':'||l_log_string
2142: );
2143:

Line 2140: (fnd_file.log

2136: );
2137: END IF;
2138:
2139: fnd_file.put_line
2140: (fnd_file.log
2141: ,RPAD('Payroll Name',30,' ')||':'||l_log_string
2142: );
2143:
2144: fnd_file.put_line

Line 2144: fnd_file.put_line

2140: (fnd_file.log
2141: ,RPAD('Payroll Name',30,' ')||':'||l_log_string
2142: );
2143:
2144: fnd_file.put_line
2145: (fnd_file.log
2146: ,RPAD('Contract Type',30,' ')||':'||p_contract_type
2147: );
2148:

Line 2145: (fnd_file.log

2141: ,RPAD('Payroll Name',30,' ')||':'||l_log_string
2142: );
2143:
2144: fnd_file.put_line
2145: (fnd_file.log
2146: ,RPAD('Contract Type',30,' ')||':'||p_contract_type
2147: );
2148:
2149: fnd_file.put_line

Line 2149: fnd_file.put_line

2145: (fnd_file.log
2146: ,RPAD('Contract Type',30,' ')||':'||p_contract_type
2147: );
2148:
2149: fnd_file.put_line
2150: (fnd_file.log
2151: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date)
2152: );
2153:

Line 2150: (fnd_file.log

2146: ,RPAD('Contract Type',30,' ')||':'||p_contract_type
2147: );
2148:
2149: fnd_file.put_line
2150: (fnd_file.log
2151: ,RPAD('Effective On or After',30,' ')||':'||fnd_date.date_to_displaydate(l_calculation_date)
2152: );
2153:
2154:

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

2154:
2155: /* if P_Payroll_ID IS NULL AND P_Contract_Type IS NULL then
2156: fnd_message.set_name('PQP', 'PQP_230686_FTE_PROG_FAIL_PARAM');
2157: l_message := fnd_message.get;
2158: fnd_file.put_line(fnd_file.log, l_message);
2159: fnd_message.raise_error;
2160: */
2161:
2162: IF (p_contract_type IS NOT NULL AND p_payroll_id IS NOT NULL)

Line 2230: fnd_file.put_line

2226: IF g_debug THEN
2227: debug(l_proc_name,l_proc_step);
2228: END IF;
2229:
2230: fnd_file.put_line
2231: (fnd_file.log
2232: ,'Number of Assignments To Process: '||l_assignment.COUNT
2233: );
2234:

Line 2231: (fnd_file.log

2227: debug(l_proc_name,l_proc_step);
2228: END IF;
2229:
2230: fnd_file.put_line
2231: (fnd_file.log
2232: ,'Number of Assignments To Process: '||l_assignment.COUNT
2233: );
2234:
2235:

Line 2236: fnd_file.put_line

2232: ,'Number of Assignments To Process: '||l_assignment.COUNT
2233: );
2234:
2235:
2236: fnd_file.put_line
2237: (fnd_file.log
2238: ,'Error Log:'
2239: );
2240:

Line 2237: (fnd_file.log

2233: );
2234:
2235:
2236: fnd_file.put_line
2237: (fnd_file.log
2238: ,'Error Log:'
2239: );
2240:
2241:

Line 2248: fnd_file.put_line

2244: WHILE i IS NOT NULL
2245: LOOP
2246:
2247: IF i = l_assignment.FIRST() THEN
2248: fnd_file.put_line
2249: (fnd_file.output
2250: ,RPAD('Status',30,' ')||g_column_separator||
2251: RPAD('Employee Number',20,' ')||g_column_separator||
2252: RPAD('Assignment_Number',30,' ')||g_column_separator||

Line 2249: (fnd_file.output

2245: LOOP
2246:
2247: IF i = l_assignment.FIRST() THEN
2248: fnd_file.put_line
2249: (fnd_file.output
2250: ,RPAD('Status',30,' ')||g_column_separator||
2251: RPAD('Employee Number',20,' ')||g_column_separator||
2252: RPAD('Assignment_Number',30,' ')||g_column_separator||
2253: RPAD('Effective Date',15,' ')||g_column_separator||

Line 2266: fnd_file.put_line

2262: RPAD('Period Divisor',15,' ')||g_column_separator||
2263: RPAD('Message',255,' ')
2264: );
2265:
2266: fnd_file.put_line
2267: (fnd_file.output
2268: ,RPAD('-',30,'-')||g_column_separator||
2269: RPAD('-',20,'-')||g_column_separator||
2270: RPAD('-',30,'-')||g_column_separator||

Line 2267: (fnd_file.output

2263: RPAD('Message',255,' ')
2264: );
2265:
2266: fnd_file.put_line
2267: (fnd_file.output
2268: ,RPAD('-',30,'-')||g_column_separator||
2269: RPAD('-',20,'-')||g_column_separator||
2270: RPAD('-',30,'-')||g_column_separator||
2271: RPAD('-',15,'-')||g_column_separator||

Line 2423: fnd_file.put_line

2419: l_errored := l_errored + 1;
2420:
2421: IF l_errored = 1 THEN
2422:
2423: fnd_file.put_line
2424: (fnd_file.log
2425: ,RPAD('Employee Number',15,' ')||g_column_separator||RPAD('Error Message',255,' ')
2426: );
2427:

Line 2424: (fnd_file.log

2420:
2421: IF l_errored = 1 THEN
2422:
2423: fnd_file.put_line
2424: (fnd_file.log
2425: ,RPAD('Employee Number',15,' ')||g_column_separator||RPAD('Error Message',255,' ')
2426: );
2427:
2428: fnd_file.put_line

Line 2428: fnd_file.put_line

2424: (fnd_file.log
2425: ,RPAD('Employee Number',15,' ')||g_column_separator||RPAD('Error Message',255,' ')
2426: );
2427:
2428: fnd_file.put_line
2429: (fnd_file.log
2430: ,RPAD('-',15,'-')||g_column_separator||RPAD('-',255,'-')
2431: );
2432:

Line 2429: (fnd_file.log

2425: ,RPAD('Employee Number',15,' ')||g_column_separator||RPAD('Error Message',255,' ')
2426: );
2427:
2428: fnd_file.put_line
2429: (fnd_file.log
2430: ,RPAD('-',15,'-')||g_column_separator||RPAD('-',255,'-')
2431: );
2432:
2433: END IF;

Line 2435: fnd_file.put_line

2431: );
2432:
2433: END IF;
2434:
2435: fnd_file.put_line
2436: (fnd_file.log
2437: ,RPAD(NVL(g_output_file_records(g_output_file_records.LAST).employee_number
2438: ,'Asg_Id:'||l_assignment(i)
2439: )

Line 2436: (fnd_file.log

2432:
2433: END IF;
2434:
2435: fnd_file.put_line
2436: (fnd_file.log
2437: ,RPAD(NVL(g_output_file_records(g_output_file_records.LAST).employee_number
2438: ,'Asg_Id:'||l_assignment(i)
2439: )
2440: ,15,' '

Line 2464: fnd_file.put_line

2460:
2461: ERRBUF := null;
2462: RETCODE:= 0;
2463:
2464: fnd_file.put_line
2465: (fnd_file.log
2466: ,'Number of Assignments Processed:'||l_processed
2467: );
2468:

Line 2465: (fnd_file.log

2461: ERRBUF := null;
2462: RETCODE:= 0;
2463:
2464: fnd_file.put_line
2465: (fnd_file.log
2466: ,'Number of Assignments Processed:'||l_processed
2467: );
2468:
2469: fnd_file.put_line

Line 2469: fnd_file.put_line

2465: (fnd_file.log
2466: ,'Number of Assignments Processed:'||l_processed
2467: );
2468:
2469: fnd_file.put_line
2470: (fnd_file.log
2471: ,'Number of Assignments Errored:'||l_errored
2472: );
2473:

Line 2470: (fnd_file.log

2466: ,'Number of Assignments Processed:'||l_processed
2467: );
2468:
2469: fnd_file.put_line
2470: (fnd_file.log
2471: ,'Number of Assignments Errored:'||l_errored
2472: );
2473:
2474: