DBA Data[Home] [Help]

APPS.PAY_KW_ANNUAL_REPORTS dependencies on FND_FILE

Line 507: /*fnd_file.put_line(fnd_file.log,' l_first_social '|| l_first_social);

503: Else
504: l_first_social := 0;
505: End If;
506:
507: /*fnd_file.put_line(fnd_file.log,' l_first_social '|| l_first_social);
508: fnd_file.put_line(fnd_file.log,' l_assact_one '|| l_assact_one);
509: fnd_file.put_line(fnd_file.log,' l_social_id '|| l_social_id);*/
510:
511: l_monthly_sal := l_monthly_earning - l_first_social;

Line 508: fnd_file.put_line(fnd_file.log,' l_assact_one '|| l_assact_one);

504: l_first_social := 0;
505: End If;
506:
507: /*fnd_file.put_line(fnd_file.log,' l_first_social '|| l_first_social);
508: fnd_file.put_line(fnd_file.log,' l_assact_one '|| l_assact_one);
509: fnd_file.put_line(fnd_file.log,' l_social_id '|| l_social_id);*/
510:
511: l_monthly_sal := l_monthly_earning - l_first_social;
512:

Line 509: fnd_file.put_line(fnd_file.log,' l_social_id '|| l_social_id);*/

505: End If;
506:
507: /*fnd_file.put_line(fnd_file.log,' l_first_social '|| l_first_social);
508: fnd_file.put_line(fnd_file.log,' l_assact_one '|| l_assact_one);
509: fnd_file.put_line(fnd_file.log,' l_social_id '|| l_social_id);*/
510:
511: l_monthly_sal := l_monthly_earning - l_first_social;
512:
513: l_total := l_monthly_earning;

Line 594: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

590:
591: /*EXCEPTION
592: WHEN utl_file.invalid_path then
593: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
594: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
595: hr_utility.raise_error;
596: --
597: WHEN utl_file.invalid_mode then
598: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 599: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

595: hr_utility.raise_error;
596: --
597: WHEN utl_file.invalid_mode then
598: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
599: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
600: hr_utility.raise_error;
601: --
602: WHEN utl_file.invalid_filehandle then
603: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 604: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

600: hr_utility.raise_error;
601: --
602: WHEN utl_file.invalid_filehandle then
603: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
604: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
605: hr_utility.raise_error;
606: --
607: WHEN utl_file.invalid_operation then
608: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 609: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

605: hr_utility.raise_error;
606: --
607: WHEN utl_file.invalid_operation then
608: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
609: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
610: hr_utility.raise_error;
611: --
612: WHEN utl_file.read_error then
613: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 614: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

610: hr_utility.raise_error;
611: --
612: WHEN utl_file.read_error then
613: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
614: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
615: hr_utility.raise_error;
616: --
617: WHEN others THEN
618: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 620: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

616: --
617: WHEN others THEN
618: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
619: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
620: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
621: hr_utility.raise_error;*/
622:
623: END report55;
624: ------------------------------------------------------------------------------------

Line 1098: /*fnd_file.put_line(fnd_file.log,' new '|| l_new || ' rejoin ' || l_rejoin || ' term ' || l_termination || ' ' ||t_store_assact(j).assignment_action_id); */

1094:
1095: l_current_supp_contri := t_store_recs(x).supp_bal_value;
1096: l_fm_l_current_supp_contri := to_char(l_current_supp_contri,lg_format_mask);
1097:
1098: /*fnd_file.put_line(fnd_file.log,' new '|| l_new || ' rejoin ' || l_rejoin || ' term ' || l_termination || ' ' ||t_store_assact(j).assignment_action_id); */
1099:
1100: /** Populate the XML file **/
1101:
1102: If l_termination ='Y' OR (l_rejoin = 'Y' and l_current_supp_contri <>0 ) OR (l_new = 'Y' and l_current_supp_contri <> 0) then

Line 1238: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));

1234:
1235: hr_utility.set_location('Finished creating xml data for Procedure REPORT56 ',20);
1236:
1237: If l_df_flag <> 'Y' then
1238: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));
1239: End If;
1240:
1241: WritetoCLOB ( l_xfdf_blob );
1242:

Line 1247: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1243:
1244: /*EXCEPTION
1245: WHEN utl_file.invalid_path then
1246: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1247: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1248: hr_utility.raise_error;
1249: --
1250: WHEN utl_file.invalid_mode then
1251: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 1252: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1248: hr_utility.raise_error;
1249: --
1250: WHEN utl_file.invalid_mode then
1251: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1252: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1253: hr_utility.raise_error;
1254: --
1255: WHEN utl_file.invalid_filehandle then
1256: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 1257: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1253: hr_utility.raise_error;
1254: --
1255: WHEN utl_file.invalid_filehandle then
1256: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1257: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1258: hr_utility.raise_error;
1259: --
1260: WHEN utl_file.invalid_operation then
1261: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 1262: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1258: hr_utility.raise_error;
1259: --
1260: WHEN utl_file.invalid_operation then
1261: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1262: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1263: hr_utility.raise_error;
1264: --
1265: WHEN utl_file.read_error then
1266: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 1267: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1263: hr_utility.raise_error;
1264: --
1265: WHEN utl_file.read_error then
1266: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1267: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1268: hr_utility.raise_error;
1269: --
1270: WHEN others THEN
1271: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 1273: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1269: --
1270: WHEN others THEN
1271: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1272: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1273: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1274: hr_utility.raise_error;*/
1275:
1276: END report56;
1277: -------------------------------------------------------------------------------------------

Line 2396: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));

2392:
2393: hr_utility.set_location('Finished creating xml data for Procedure REPORT103 ',20);
2394:
2395: If l_df_flag <> 'Y' then
2396: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));
2397: End If;
2398:
2399: WritetoCLOB ( l_xfdf_blob );
2400:

Line 2404: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2400:
2401: /*EXCEPTION
2402: WHEN utl_file.invalid_path then
2403: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2404: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2405: hr_utility.raise_error;
2406: --
2407: WHEN utl_file.invalid_mode then
2408: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

Line 2409: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2405: hr_utility.raise_error;
2406: --
2407: WHEN utl_file.invalid_mode then
2408: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2409: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2410: hr_utility.raise_error;
2411: --
2412: WHEN utl_file.invalid_filehandle then
2413: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

Line 2414: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2410: hr_utility.raise_error;
2411: --
2412: WHEN utl_file.invalid_filehandle then
2413: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2414: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2415: hr_utility.raise_error;
2416: --
2417: WHEN utl_file.invalid_operation then
2418: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

Line 2419: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2415: hr_utility.raise_error;
2416: --
2417: WHEN utl_file.invalid_operation then
2418: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2419: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2420: hr_utility.raise_error;
2421: --
2422: WHEN utl_file.read_error then
2423: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

Line 2424: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2420: hr_utility.raise_error;
2421: --
2422: WHEN utl_file.read_error then
2423: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2424: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2425: hr_utility.raise_error;
2426: --
2427: WHEN others THEN
2428: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

Line 2430: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

2426: --
2427: WHEN others THEN
2428: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2429: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2430: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2431: hr_utility.raise_error;*/
2432:
2433: END report103;
2434: -------------------------------------------------------------------------------------------

Line 2533: /*fnd_file.put_line(fnd_file.log,l_varchar_buffer);*/

2529: end if;
2530: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
2531: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
2532: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
2533: /*fnd_file.put_line(fnd_file.log,l_varchar_buffer);*/
2534: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
2535:
2536: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2537: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);