DBA Data[Home] [Help]

APPS.PAY_KW_ANNUAL_REPORTS dependencies on FND_FILE

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

548: Else
549: l_second_social := 0;
550: End If;
551:
552: /*fnd_file.put_line(fnd_file.log,' l_first_social '|| l_first_social);
553: fnd_file.put_line(fnd_file.log,' l_assact_one '|| l_assact_one);
554: fnd_file.put_line(fnd_file.log,' l_social_id '|| l_social_id);*/
555:
556: l_monthly_sal := l_monthly_earning - (l_first_social+l_second_social) ; /* modified Oct 2012 */

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

549: l_second_social := 0;
550: End If;
551:
552: /*fnd_file.put_line(fnd_file.log,' l_first_social '|| l_first_social);
553: fnd_file.put_line(fnd_file.log,' l_assact_one '|| l_assact_one);
554: fnd_file.put_line(fnd_file.log,' l_social_id '|| l_social_id);*/
555:
556: l_monthly_sal := l_monthly_earning - (l_first_social+l_second_social) ; /* modified Oct 2012 */
557:

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

550: End If;
551:
552: /*fnd_file.put_line(fnd_file.log,' l_first_social '|| l_first_social);
553: fnd_file.put_line(fnd_file.log,' l_assact_one '|| l_assact_one);
554: fnd_file.put_line(fnd_file.log,' l_social_id '|| l_social_id);*/
555:
556: l_monthly_sal := l_monthly_earning - (l_first_social+l_second_social) ; /* modified Oct 2012 */
557:
558: l_total := l_monthly_earning;

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

648:
649: /*EXCEPTION
650: WHEN utl_file.invalid_path then
651: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
652: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
653: hr_utility.raise_error;
654: --
655: WHEN utl_file.invalid_mode then
656: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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

653: hr_utility.raise_error;
654: --
655: WHEN utl_file.invalid_mode then
656: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
657: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
658: hr_utility.raise_error;
659: --
660: WHEN utl_file.invalid_filehandle then
661: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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

658: hr_utility.raise_error;
659: --
660: WHEN utl_file.invalid_filehandle then
661: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
662: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
663: hr_utility.raise_error;
664: --
665: WHEN utl_file.invalid_operation then
666: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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

663: hr_utility.raise_error;
664: --
665: WHEN utl_file.invalid_operation then
666: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
667: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
668: hr_utility.raise_error;
669: --
670: WHEN utl_file.read_error then
671: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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

668: hr_utility.raise_error;
669: --
670: WHEN utl_file.read_error then
671: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
672: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
673: hr_utility.raise_error;
674: --
675: WHEN others THEN
676: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

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

674: --
675: WHEN others THEN
676: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
677: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
678: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
679: hr_utility.raise_error;*/
680:
681: END report55;
682: ------------------------------------------------------------------------------------

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

1152:
1153: l_current_supp_contri := t_store_recs(x).supp_bal_value;
1154: l_fm_l_current_supp_contri := to_char(l_current_supp_contri,lg_format_mask);
1155:
1156: /*fnd_file.put_line(fnd_file.log,' new '|| l_new || ' rejoin ' || l_rejoin || ' term ' || l_termination || ' ' ||t_store_assact(j).assignment_action_id); */
1157:
1158: /** Populate the XML file **/
1159:
1160: 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 1296: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));

1292:
1293: hr_utility.set_location('Finished creating xml data for Procedure REPORT56 ',20);
1294:
1295: If l_df_flag <> 'Y' then
1296: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));
1297: End If;
1298:
1299: WritetoCLOB ( l_xfdf_blob );
1300:

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

1301:
1302: /*EXCEPTION
1303: WHEN utl_file.invalid_path then
1304: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
1305: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1306: hr_utility.raise_error;
1307: --
1308: WHEN utl_file.invalid_mode then
1309: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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

1306: hr_utility.raise_error;
1307: --
1308: WHEN utl_file.invalid_mode then
1309: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
1310: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1311: hr_utility.raise_error;
1312: --
1313: WHEN utl_file.invalid_filehandle then
1314: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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

1311: hr_utility.raise_error;
1312: --
1313: WHEN utl_file.invalid_filehandle then
1314: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
1315: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1316: hr_utility.raise_error;
1317: --
1318: WHEN utl_file.invalid_operation then
1319: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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

1316: hr_utility.raise_error;
1317: --
1318: WHEN utl_file.invalid_operation then
1319: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
1320: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1321: hr_utility.raise_error;
1322: --
1323: WHEN utl_file.read_error then
1324: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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

1321: hr_utility.raise_error;
1322: --
1323: WHEN utl_file.read_error then
1324: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
1325: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1326: hr_utility.raise_error;
1327: --
1328: WHEN others THEN
1329: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

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

1327: --
1328: WHEN others THEN
1329: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1330: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1331: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1332: hr_utility.raise_error;*/
1333:
1334: END report56;
1335: -------------------------------------------------------------------------------------------

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

2545:
2546: hr_utility.set_location('Finished creating xml data for Procedure REPORT103 ',20);
2547:
2548: If l_df_flag <> 'Y' then
2549: fnd_file.put_line(fnd_file.log,get_lookup_meaning('KW_FORM_LABELS','NDF'));
2550: End If;
2551:
2552: WritetoCLOB ( l_xfdf_blob );
2553:

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

2553:
2554: /*EXCEPTION
2555: WHEN utl_file.invalid_path then
2556: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
2557: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2558: hr_utility.raise_error;
2559: --
2560: WHEN utl_file.invalid_mode then
2561: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');

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

2558: hr_utility.raise_error;
2559: --
2560: WHEN utl_file.invalid_mode then
2561: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
2562: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2563: hr_utility.raise_error;
2564: --
2565: WHEN utl_file.invalid_filehandle then
2566: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');

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

2563: hr_utility.raise_error;
2564: --
2565: WHEN utl_file.invalid_filehandle then
2566: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
2567: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2568: hr_utility.raise_error;
2569: --
2570: WHEN utl_file.invalid_operation then
2571: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');

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

2568: hr_utility.raise_error;
2569: --
2570: WHEN utl_file.invalid_operation then
2571: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
2572: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2573: hr_utility.raise_error;
2574: --
2575: WHEN utl_file.read_error then
2576: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');

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

2573: hr_utility.raise_error;
2574: --
2575: WHEN utl_file.read_error then
2576: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
2577: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2578: hr_utility.raise_error;
2579: --
2580: WHEN others THEN
2581: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

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

2579: --
2580: WHEN others THEN
2581: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
2582: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
2583: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
2584: hr_utility.raise_error;*/
2585:
2586: END report103;
2587: -------------------------------------------------------------------------------------------

Line 2688: fnd_file.put_line(fnd_file.log,l_varchar_buffer);

2684: end if;
2685: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
2686: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
2687: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
2688: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
2689: 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));
2690:
2691: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
2692: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);