eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_PSI_FUNCTIONS dependencies on FND_FILE

Line 520: fnd_file.put_line(fnd_file.LOG

516: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
517: THEN
518: -- Raise error as Paypoint is unknown(E)
519: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
520: fnd_file.put_line(fnd_file.LOG
521: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
522: fnd_file.put_line(fnd_file.LOG, ' ');
523: END IF;
524:

Line 522: fnd_file.put_line(fnd_file.LOG, ' ');

518: -- Raise error as Paypoint is unknown(E)
519: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
520: fnd_file.put_line(fnd_file.LOG
521: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
522: fnd_file.put_line(fnd_file.LOG, ' ');
523: END IF;
524:
525:
526: -- Pass context as PQP_GB_PENSERV_BONUS_INFO to get the bonus codes information

Line 545: fnd_file.put_line(fnd_file.LOG,

541: END IF;
542:
543: IF l_alphanum_code IS NOT NULL THEN
544: --
545: fnd_file.put_line(fnd_file.LOG,
546: RPAD(nvl(l_pay_point,' '),6,' ') ||
547: RPAD(nvl(l_bonus_rec.code,' '),4,' ') ||
548: RPAD(nvl(l_bonus_rec.description,' '),34,' ') ||
549: RPAD(nvl(l_bonus_rec.pension_flag,' '),1,' ') ||

Line 558: fnd_file.put_line(fnd_file.LOG

554: RPAD(l_filler2,86,' '));
555: --
556: -- Raise error as Special characters are not permitted in the allowance code(E)
557: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
558: fnd_file.put_line(fnd_file.LOG
559: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
560:
561: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');
562:

Line 561: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');

557: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
558: fnd_file.put_line(fnd_file.LOG
559: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
560:
561: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');
562:
563: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);
564:
565: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);

Line 563: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);

559: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
560:
561: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');
562:
563: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);
564:
565: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);
566: fnd_file.put_line(fnd_file.log, ' ');
567: fnd_file.put_line(fnd_file.log, ' ');

Line 565: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);

561: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');
562:
563: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);
564:
565: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);
566: fnd_file.put_line(fnd_file.log, ' ');
567: fnd_file.put_line(fnd_file.log, ' ');
568: --
569:

Line 566: fnd_file.put_line(fnd_file.log, ' ');

562:
563: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);
564:
565: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);
566: fnd_file.put_line(fnd_file.log, ' ');
567: fnd_file.put_line(fnd_file.log, ' ');
568: --
569:
570: --

Line 567: fnd_file.put_line(fnd_file.log, ' ');

563: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);
564:
565: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);
566: fnd_file.put_line(fnd_file.log, ' ');
567: fnd_file.put_line(fnd_file.log, ' ');
568: --
569:
570: --
571: ELSE

Line 595: fnd_file.put_line(fnd_file.output,

591: -- insert correct bonus information into output file
592: FOR l_bonus_index IN l_bonus_codes.FIRST..l_bonus_codes.LAST
593: LOOP
594:
595: fnd_file.put_line(fnd_file.output,
596: l_bonus_codes(l_bonus_index).pay_point ||
597: l_bonus_codes(l_bonus_index).bonus_code ||
598: l_bonus_codes(l_bonus_index).bonus_descr ||
599: l_bonus_codes(l_bonus_index).pension_flag ||

Line 652: fnd_file.put_line(fnd_file.LOG

648: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
649: THEN
650: -- Raise error as Paypoint is unknown(E)
651: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
652: fnd_file.put_line(fnd_file.LOG
653: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
654: fnd_file.put_line(fnd_file.LOG, ' ');
655: END IF;
656: --Pass context as PQP_GB_PENSERV_ALLOWANCE_INFO to get the allowance codes information

Line 654: fnd_file.put_line(fnd_file.LOG, ' ');

650: -- Raise error as Paypoint is unknown(E)
651: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
652: fnd_file.put_line(fnd_file.LOG
653: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
654: fnd_file.put_line(fnd_file.LOG, ' ');
655: END IF;
656: --Pass context as PQP_GB_PENSERV_ALLOWANCE_INFO to get the allowance codes information
657: FOR l_allowance_rec IN csr_get_extra_allow_info
658: (p_from_date => p_from_date

Line 675: fnd_file.put_line(fnd_file.LOG,

671: END IF;
672:
673: IF l_alphanum_code IS NOT NULL THEN
674: --
675: fnd_file.put_line(fnd_file.LOG,
676: RPAD(nvl(l_pay_point,' '),6,' ') ||
677: RPAD(nvl(l_allowance_rec.code,' '),10,' ') ||
678: RPAD(nvl(l_allowance_rec.description,' '),34,' ') ||
679: RPAD(nvl(l_allowance_rec.pension_flag,' '),1,' ') ||

Line 689: fnd_file.put_line(fnd_file.LOG

685: RPAD(l_filler2,79,' '));
686: --
687: -- Raise error as Special characters are not permitted in the allowance code(E)
688: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
689: fnd_file.put_line(fnd_file.LOG
690: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
691:
692: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');
693:

Line 692: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');

688: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
689: fnd_file.put_line(fnd_file.LOG
690: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
691:
692: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');
693:
694: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);
695:
696: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);

Line 694: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);

690: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
691:
692: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');
693:
694: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);
695:
696: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);
697: fnd_file.put_line(fnd_file.log, ' ');
698: fnd_file.put_line(fnd_file.log, ' ');

Line 696: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);

692: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');
693:
694: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);
695:
696: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);
697: fnd_file.put_line(fnd_file.log, ' ');
698: fnd_file.put_line(fnd_file.log, ' ');
699: --
700: ELSE

Line 697: fnd_file.put_line(fnd_file.log, ' ');

693:
694: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);
695:
696: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);
697: fnd_file.put_line(fnd_file.log, ' ');
698: fnd_file.put_line(fnd_file.log, ' ');
699: --
700: ELSE
701: --

Line 698: fnd_file.put_line(fnd_file.log, ' ');

694: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);
695:
696: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);
697: fnd_file.put_line(fnd_file.log, ' ');
698: fnd_file.put_line(fnd_file.log, ' ');
699: --
700: ELSE
701: --
702: -- increase the counter

Line 726: fnd_file.put_line(fnd_file.output,

722: -- insert correct allowance information into output file
723: FOR l_allowance_index IN l_allowance_codes.FIRST..l_allowance_codes.LAST
724: LOOP
725:
726: fnd_file.put_line(fnd_file.output,
727: l_allowance_codes(l_allowance_index).pay_point ||
728: l_allowance_codes(l_allowance_index).allowance_code ||
729: l_allowance_codes(l_allowance_index).allowance_descr ||
730: l_allowance_codes(l_allowance_index).pension_flag ||

Line 788: fnd_file.put_line(fnd_file.log, 'Error: '

784: FETCH csr_get_ext_rslt_id INTO l_ext_rslt_id;
785:
786: IF csr_get_ext_rslt_id%NOTFOUND THEN
787: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
788: fnd_file.put_line(fnd_file.log, 'Error: '
789: || fnd_message.get);
790: fnd_file.put_line(fnd_file.log, ' ');
791: CLOSE csr_get_ext_rslt_id;
792: fnd_message.raise_error;

Line 790: fnd_file.put_line(fnd_file.log, ' ');

786: IF csr_get_ext_rslt_id%NOTFOUND THEN
787: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
788: fnd_file.put_line(fnd_file.log, 'Error: '
789: || fnd_message.get);
790: fnd_file.put_line(fnd_file.log, ' ');
791: CLOSE csr_get_ext_rslt_id;
792: fnd_message.raise_error;
793: END IF; -- End if of row not found check ...
794: CLOSE csr_get_ext_rslt_id;

Line 979: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));

975: -- IMP!! -- remove this later
976: -- g_debug := TRUE;
977: --***************************************
978:
979: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
980: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
981:
982: IF (p_submit_request_y_n = 'N') THEN
983: fnd_file.put_line(fnd_file.log, 'First call to ' || l_proc_name );

Line 980: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);

976: -- g_debug := TRUE;
977: --***************************************
978:
979: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
980: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
981:
982: IF (p_submit_request_y_n = 'N') THEN
983: fnd_file.put_line(fnd_file.log, 'First call to ' || l_proc_name );
984: ELSE

Line 983: fnd_file.put_line(fnd_file.log, 'First call to ' || l_proc_name );

979: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
980: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
981:
982: IF (p_submit_request_y_n = 'N') THEN
983: fnd_file.put_line(fnd_file.log, 'First call to ' || l_proc_name );
984: ELSE
985: fnd_file.put_line(fnd_file.log, 'Second call to ' || l_proc_name );
986: END IF;
987:

Line 985: fnd_file.put_line(fnd_file.log, 'Second call to ' || l_proc_name );

981:
982: IF (p_submit_request_y_n = 'N') THEN
983: fnd_file.put_line(fnd_file.log, 'First call to ' || l_proc_name );
984: ELSE
985: fnd_file.put_line(fnd_file.log, 'Second call to ' || l_proc_name );
986: END IF;
987:
988:
989: -- 115.60

Line 1110: fnd_file.put_line(fnd_file.log, l_err_msg);

1106: fnd_message.set_name('PQP', 'PQP_230228_PSI_EXT_SUBMIT_ERR');
1107: fnd_message.set_token('EXTNAME',g_ext_dtls(1).extract_name);
1108: l_err_msg := fnd_message.get;
1109: errbuf := l_err_msg;
1110: fnd_file.put_line(fnd_file.log, l_err_msg);
1111: l_err_msg := NULL;
1112: END IF;
1113:
1114: COMMIT;

Line 1199: fnd_file.put_line(fnd_file.log, l_err_msg);

1195: fnd_message.set_name('PQP', 'PQP_230228_PSI_EXT_SUBMIT_ERR');
1196: fnd_message.set_token('EXTNAME',l_ext_names(i).extract_name);
1197: l_err_msg := fnd_message.get;
1198: errbuf := l_err_msg;
1199: fnd_file.put_line(fnd_file.log, l_err_msg);
1200: l_err_msg := NULL;
1201: EXIT;
1202: END IF;
1203:

Line 1211: -- fnd_file.put_line(fnd_file.log, 'Request ID: ' ||l_request_id || ' Extract Name: '|| l_ext_names(i).extract_name);

1207: g_ext_dtls(i).extract_code := l_ext_names(i).extract_code;
1208: g_ext_dtls(i).short_name := l_extract_shortname;
1209: g_ext_dtls(i).request_id := l_request_id;
1210:
1211: -- fnd_file.put_line(fnd_file.log, 'Request ID: ' ||l_request_id || ' Extract Name: '|| l_ext_names(i).extract_name);
1212:
1213: /*
1214: g_ext_dtls(i).extract_rslt_id := get_ext_rslt_frm_req
1215: (p_request_id => l_request_id

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

1238: OR
1239: (l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL'
1240: ) THEN
1241:
1242: fnd_file.put_line(fnd_file.log, l_message);
1243:
1244: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1245: fnd_message.set_token('EXTNAME',l_ext_names(i).extract_name);
1246: l_err_msg := fnd_message.get;

Line 1248: fnd_file.put_line(fnd_file.log, l_err_msg);

1244: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1245: fnd_message.set_token('EXTNAME',l_ext_names(i).extract_name);
1246: l_err_msg := fnd_message.get;
1247: errbuf := l_err_msg;
1248: fnd_file.put_line(fnd_file.log, l_err_msg);
1249: l_retcode := PROGRAM_FAILURE ;
1250: l_err_msg:= NULL;
1251: -- EXIT;
1252:

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

1303: OR
1304: (l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL'
1305: ) THEN
1306:
1307: fnd_file.put_line(fnd_file.log, l_message);
1308:
1309: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1310: fnd_message.set_token('EXTNAME',g_ext_dtls(l_index).extract_name);
1311: l_err_msg := fnd_message.get;

Line 1313: fnd_file.put_line(fnd_file.log, l_err_msg);

1309: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1310: fnd_message.set_token('EXTNAME',g_ext_dtls(l_index).extract_name);
1311: l_err_msg := fnd_message.get;
1312: errbuf := l_err_msg;
1313: fnd_file.put_line(fnd_file.log, l_err_msg);
1314: l_retcode := PROGRAM_FAILURE ;
1315: l_err_msg:= NULL;
1316: -- EXIT;
1317: END IF; -- (l_dev_phase = 'COMPLETE'

Line 1319: -- fnd_file.put_line(fnd_file.log, 'Completed the extract' || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));

1315: l_err_msg:= NULL;
1316: -- EXIT;
1317: END IF; -- (l_dev_phase = 'COMPLETE'
1318:
1319: -- fnd_file.put_line(fnd_file.log, 'Completed the extract' || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
1320: fnd_file.put_line(fnd_file.log, 'Completed the extract' || ' : ' || get_time);
1321:
1322: debug('Completed Request ID :'||
1323: to_char(g_ext_dtls(l_index).request_id), 160);

Line 1320: fnd_file.put_line(fnd_file.log, 'Completed the extract' || ' : ' || get_time);

1316: -- EXIT;
1317: END IF; -- (l_dev_phase = 'COMPLETE'
1318:
1319: -- fnd_file.put_line(fnd_file.log, 'Completed the extract' || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
1320: fnd_file.put_line(fnd_file.log, 'Completed the extract' || ' : ' || get_time);
1321:
1322: debug('Completed Request ID :'||
1323: to_char(g_ext_dtls(l_index).request_id), 160);
1324: END IF;

Line 1417: fnd_file.put_line(fnd_file.log, l_err_msg);

1413: fnd_message.set_name('PQP', 'PQP_230228_PSI_EXT_SUBMIT_ERR');
1414: fnd_message.set_token('EXTNAME','PenServer Control Totals Process');
1415: l_err_msg := fnd_message.get;
1416: errbuf := l_err_msg;
1417: fnd_file.put_line(fnd_file.log, l_err_msg);
1418: l_err_msg := NULL;
1419: END IF;
1420:
1421: COMMIT;

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

1438: OR
1439: (l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL'
1440: ) THEN
1441:
1442: fnd_file.put_line(fnd_file.log, l_message);
1443:
1444: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1445: fnd_message.set_token('EXTNAME','PenServer Control Totals');
1446: l_err_msg := fnd_message.get;

Line 1448: fnd_file.put_line(fnd_file.log, l_err_msg);

1444: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1445: fnd_message.set_token('EXTNAME','PenServer Control Totals');
1446: l_err_msg := fnd_message.get;
1447: errbuf := l_err_msg;
1448: fnd_file.put_line(fnd_file.log, l_err_msg);
1449: l_retcode := PROGRAM_FAILURE ;
1450: l_err_msg:= NULL;
1451:
1452: END IF; -- (l_dev_phase = 'COMPLETE'

Line 1469: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');

1465: RETURN;
1466: END IF;
1467:
1468: -- Write a summary in the log file
1469: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1470: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1471: fnd_file.put_line(fnd_file.log, ' ');
1472: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1473: fnd_file.put_line(fnd_file.log, ' ');

Line 1470: fnd_file.put_line(fnd_file.log, '********************************************************************** ');

1466: END IF;
1467:
1468: -- Write a summary in the log file
1469: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1470: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1471: fnd_file.put_line(fnd_file.log, ' ');
1472: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1473: fnd_file.put_line(fnd_file.log, ' ');
1474: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');

Line 1471: fnd_file.put_line(fnd_file.log, ' ');

1467:
1468: -- Write a summary in the log file
1469: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1470: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1471: fnd_file.put_line(fnd_file.log, ' ');
1472: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1473: fnd_file.put_line(fnd_file.log, ' ');
1474: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');
1475: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');

Line 1472: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');

1468: -- Write a summary in the log file
1469: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1470: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1471: fnd_file.put_line(fnd_file.log, ' ');
1472: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1473: fnd_file.put_line(fnd_file.log, ' ');
1474: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');
1475: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');
1476:

Line 1473: fnd_file.put_line(fnd_file.log, ' ');

1469: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1470: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1471: fnd_file.put_line(fnd_file.log, ' ');
1472: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1473: fnd_file.put_line(fnd_file.log, ' ');
1474: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');
1475: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');
1476:
1477:

Line 1474: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');

1470: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1471: fnd_file.put_line(fnd_file.log, ' ');
1472: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1473: fnd_file.put_line(fnd_file.log, ' ');
1474: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');
1475: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');
1476:
1477:
1478: l_extract_count := 0;

Line 1475: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');

1471: fnd_file.put_line(fnd_file.log, ' ');
1472: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1473: fnd_file.put_line(fnd_file.log, ' ');
1474: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');
1475: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');
1476:
1477:
1478: l_extract_count := 0;
1479: l_index := g_ext_dtls.FIRST;

Line 1486: fnd_file.put(fnd_file.log, rpad(g_ext_dtls(l_index).extract_name, 100));

1482: LOOP
1483:
1484: IF g_ext_dtls(l_index).extract_name IS NOT NULL
1485: THEN
1486: fnd_file.put(fnd_file.log, rpad(g_ext_dtls(l_index).extract_name, 100));
1487: fnd_file.put_line(fnd_file.log, rpad(g_ext_dtls(l_index).request_id, 15));
1488:
1489: l_extract_count := l_extract_count + 1;
1490: END IF;

Line 1487: fnd_file.put_line(fnd_file.log, rpad(g_ext_dtls(l_index).request_id, 15));

1483:
1484: IF g_ext_dtls(l_index).extract_name IS NOT NULL
1485: THEN
1486: fnd_file.put(fnd_file.log, rpad(g_ext_dtls(l_index).extract_name, 100));
1487: fnd_file.put_line(fnd_file.log, rpad(g_ext_dtls(l_index).request_id, 15));
1488:
1489: l_extract_count := l_extract_count + 1;
1490: END IF;
1491:

Line 1496: fnd_file.put_line(fnd_file.log, 'Total Extracts processed :' ||to_char(l_extract_count));

1492: l_index := g_ext_dtls.NEXT(l_index);
1493:
1494: END LOOP; -- WHILE l_index IS NOT NULL
1495:
1496: fnd_file.put_line(fnd_file.log, 'Total Extracts processed :' ||to_char(l_extract_count));
1497: fnd_file.put_line(fnd_file.log, ' ');
1498:
1499: fnd_file.put_line(fnd_file.log, ' ');
1500: fnd_file.put_line(fnd_file.log, '********************************************************************** ');

Line 1497: fnd_file.put_line(fnd_file.log, ' ');

1493:
1494: END LOOP; -- WHILE l_index IS NOT NULL
1495:
1496: fnd_file.put_line(fnd_file.log, 'Total Extracts processed :' ||to_char(l_extract_count));
1497: fnd_file.put_line(fnd_file.log, ' ');
1498:
1499: fnd_file.put_line(fnd_file.log, ' ');
1500: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1501: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');

Line 1499: fnd_file.put_line(fnd_file.log, ' ');

1495:
1496: fnd_file.put_line(fnd_file.log, 'Total Extracts processed :' ||to_char(l_extract_count));
1497: fnd_file.put_line(fnd_file.log, ' ');
1498:
1499: fnd_file.put_line(fnd_file.log, ' ');
1500: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1501: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1502:
1503:

Line 1500: fnd_file.put_line(fnd_file.log, '********************************************************************** ');

1496: fnd_file.put_line(fnd_file.log, 'Total Extracts processed :' ||to_char(l_extract_count));
1497: fnd_file.put_line(fnd_file.log, ' ');
1498:
1499: fnd_file.put_line(fnd_file.log, ' ');
1500: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1501: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1502:
1503:
1504: -- the follwoing ELSE is for the case when this process is NOT a parent

Line 1501: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');

1497: fnd_file.put_line(fnd_file.log, ' ');
1498:
1499: fnd_file.put_line(fnd_file.log, ' ');
1500: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1501: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1502:
1503:
1504: -- the follwoing ELSE is for the case when this process is NOT a parent
1505: -- it is in fact one of the threads launched by Penserver Interface Process

Line 1670: -- fnd_file.put_line(fnd_file.log, 'calling ben_process' || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));

1666: );
1667: ELSE
1668:
1669:
1670: -- fnd_file.put_line(fnd_file.log, 'calling ben_process' || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
1671: fnd_file.put_line(fnd_file.log, 'calling ben_process' || ' : ' || get_time);
1672:
1673: IF p_extract_type <> '1PED' -- cutover/code extract (full profile)
1674: THEN

Line 1671: fnd_file.put_line(fnd_file.log, 'calling ben_process' || ' : ' || get_time);

1667: ELSE
1668:
1669:
1670: -- fnd_file.put_line(fnd_file.log, 'calling ben_process' || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
1671: fnd_file.put_line(fnd_file.log, 'calling ben_process' || ' : ' || get_time);
1672:
1673: IF p_extract_type <> '1PED' -- cutover/code extract (full profile)
1674: THEN
1675: ben_ext_thread.process

Line 1894: fnd_file.put_line(fnd_file.LOG

1890: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
1891: THEN
1892: -- Raise error as Paypoint is unknown(E)
1893: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
1894: fnd_file.put_line(fnd_file.LOG
1895: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
1896: fnd_file.put_line(fnd_file.LOG, ' ');
1897: END IF;
1898:

Line 1896: fnd_file.put_line(fnd_file.LOG, ' ');

1892: -- Raise error as Paypoint is unknown(E)
1893: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
1894: fnd_file.put_line(fnd_file.LOG
1895: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
1896: fnd_file.put_line(fnd_file.LOG, ' ');
1897: END IF;
1898:
1899:
1900: debug('p_parent_request_id ' || p_parent_request_id, 20);

Line 2654: fnd_file.put_line(fnd_file.output,

2650: l_cntrl_tot(1).benef_det_tot_rec :=rtrim(ltrim(to_char(0, '0999999999'))); */
2651:
2652: debug ('Before writing into file');
2653: -- insert control totals information into output file
2654: fnd_file.put_line(fnd_file.output,
2655: l_cntrl_tot(1).pay_point ||
2656: l_cntrl_tot(1).file_extract_date ||
2657: l_cntrl_tot(1).seq_num ||
2658: l_cntrl_tot(1).basic_cnt ||

Line 3287: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));

3283: Begin
3284:
3285: debug_enter(l_proc_name);
3286:
3287: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
3288: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
3289:
3290: -- 115.60
3291: -- this happens when persons are rejected at the system extract level

Line 3288: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);

3284:
3285: debug_enter(l_proc_name);
3286:
3287: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
3288: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
3289:
3290: -- 115.60
3291: -- this happens when persons are rejected at the system extract level
3292: -- in such cases, set_shared_globals doesnt get called, and the globals

Line 3356: -- fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));

3352: AND ext_rslt_id = ben_ext_thread.g_ext_rslt_id;
3353:
3354: debug_exit(l_proc_name);
3355:
3356: -- fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
3357: fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || ' : ' || get_time);
3358:
3359: EXCEPTION
3360: WHEN others THEN

Line 3357: fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || ' : ' || get_time);

3353:
3354: debug_exit(l_proc_name);
3355:
3356: -- fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
3357: fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || ' : ' || get_time);
3358:
3359: EXCEPTION
3360: WHEN others THEN
3361: IF SQLCODE <> hr_utility.hr_error_number

Line 4065: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));

4061: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
4062:
4063: debug_enter(l_proc_name);
4064:
4065: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
4066: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
4067:
4068:
4069: debug('Entering set_shared_globals ...',10);

Line 4066: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);

4062:
4063: debug_enter(l_proc_name);
4064:
4065: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
4066: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
4067:
4068:
4069: debug('Entering set_shared_globals ...',10);
4070: debug ('p_business_group_id:'||p_business_group_id);

Line 4457: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));

4453:
4454: debug_enter(l_proc_name);
4455:
4456: IF (g_count = 0) THEN
4457: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
4458: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
4459: g_count := 1;
4460: END IF;
4461:

Line 4458: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);

4454: debug_enter(l_proc_name);
4455:
4456: IF (g_count = 0) THEN
4457: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
4458: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
4459: g_count := 1;
4460: END IF;
4461:
4462: