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 456: fnd_file.put_line(fnd_file.LOG

452: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
453: THEN
454: -- Raise error as Paypoint is unknown(E)
455: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
456: fnd_file.put_line(fnd_file.LOG
457: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
458: fnd_file.put_line(fnd_file.LOG, ' ');
459: END IF;
460:

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

454: -- Raise error as Paypoint is unknown(E)
455: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
456: fnd_file.put_line(fnd_file.LOG
457: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
458: fnd_file.put_line(fnd_file.LOG, ' ');
459: END IF;
460:
461:
462: -- Pass context as PQP_GB_PENSERV_BONUS_INFO to get the bonus codes information

Line 481: fnd_file.put_line(fnd_file.LOG,

477: END IF;
478:
479: IF l_alphanum_code IS NOT NULL THEN
480: --
481: fnd_file.put_line(fnd_file.LOG,
482: RPAD(nvl(l_pay_point,' '),6,' ') ||
483: RPAD(nvl(l_bonus_rec.code,' '),4,' ') ||
484: RPAD(nvl(l_bonus_rec.description,' '),34,' ') ||
485: RPAD(nvl(l_bonus_rec.pension_flag,' '),1,' ') ||

Line 494: fnd_file.put_line(fnd_file.LOG

490: RPAD(l_filler2,86,' '));
491: --
492: -- Raise error as Special characters are not permitted in the allowance code(E)
493: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
494: fnd_file.put_line(fnd_file.LOG
495: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
496:
497: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');
498:

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

493: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
494: fnd_file.put_line(fnd_file.LOG
495: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
496:
497: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');
498:
499: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);
500:
501: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);

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

495: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
496:
497: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');
498:
499: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);
500:
501: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);
502: fnd_file.put_line(fnd_file.log, ' ');
503: fnd_file.put_line(fnd_file.log, ' ');

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

497: fnd_file.put_line(fnd_file.log, 'INTERFACE : Bonus');
498:
499: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);
500:
501: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);
502: fnd_file.put_line(fnd_file.log, ' ');
503: fnd_file.put_line(fnd_file.log, ' ');
504: --
505:

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

498:
499: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);
500:
501: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);
502: fnd_file.put_line(fnd_file.log, ' ');
503: fnd_file.put_line(fnd_file.log, ' ');
504: --
505:
506: --

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

499: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_bonus_rec.element_name);
500:
501: fnd_file.put_line(fnd_file.log, 'BONUS CODE : '|| l_alphanum_code);
502: fnd_file.put_line(fnd_file.log, ' ');
503: fnd_file.put_line(fnd_file.log, ' ');
504: --
505:
506: --
507: ELSE

Line 531: fnd_file.put_line(fnd_file.output,

527: -- insert correct bonus information into output file
528: FOR l_bonus_index IN l_bonus_codes.FIRST..l_bonus_codes.LAST
529: LOOP
530:
531: fnd_file.put_line(fnd_file.output,
532: l_bonus_codes(l_bonus_index).pay_point ||
533: l_bonus_codes(l_bonus_index).bonus_code ||
534: l_bonus_codes(l_bonus_index).bonus_descr ||
535: l_bonus_codes(l_bonus_index).pension_flag ||

Line 588: fnd_file.put_line(fnd_file.LOG

584: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
585: THEN
586: -- Raise error as Paypoint is unknown(E)
587: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
588: fnd_file.put_line(fnd_file.LOG
589: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
590: fnd_file.put_line(fnd_file.LOG, ' ');
591: END IF;
592: --Pass context as PQP_GB_PENSERV_ALLOWANCE_INFO to get the allowance codes information

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

586: -- Raise error as Paypoint is unknown(E)
587: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
588: fnd_file.put_line(fnd_file.LOG
589: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
590: fnd_file.put_line(fnd_file.LOG, ' ');
591: END IF;
592: --Pass context as PQP_GB_PENSERV_ALLOWANCE_INFO to get the allowance codes information
593: FOR l_allowance_rec IN csr_get_extra_allow_info
594: (p_from_date => p_from_date

Line 611: fnd_file.put_line(fnd_file.LOG,

607: END IF;
608:
609: IF l_alphanum_code IS NOT NULL THEN
610: --
611: fnd_file.put_line(fnd_file.LOG,
612: RPAD(nvl(l_pay_point,' '),6,' ') ||
613: RPAD(nvl(l_allowance_rec.code,' '),10,' ') ||
614: RPAD(nvl(l_allowance_rec.description,' '),34,' ') ||
615: RPAD(nvl(l_allowance_rec.pension_flag,' '),1,' ') ||

Line 625: fnd_file.put_line(fnd_file.LOG

621: RPAD(l_filler2,79,' '));
622: --
623: -- Raise error as Special characters are not permitted in the allowance code(E)
624: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
625: fnd_file.put_line(fnd_file.LOG
626: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
627:
628: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');
629:

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

624: hr_utility.set_message(805, 'BEN_94458_PEN_SPCL_CHAR_CHK');
625: fnd_file.put_line(fnd_file.LOG
626: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
627:
628: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');
629:
630: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);
631:
632: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);

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

626: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
627:
628: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');
629:
630: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);
631:
632: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);
633: fnd_file.put_line(fnd_file.log, ' ');
634: fnd_file.put_line(fnd_file.log, ' ');

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

628: fnd_file.put_line(fnd_file.log, 'INTERFACE : Allowance');
629:
630: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);
631:
632: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);
633: fnd_file.put_line(fnd_file.log, ' ');
634: fnd_file.put_line(fnd_file.log, ' ');
635: --
636: ELSE

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

629:
630: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);
631:
632: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);
633: fnd_file.put_line(fnd_file.log, ' ');
634: fnd_file.put_line(fnd_file.log, ' ');
635: --
636: ELSE
637: --

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

630: fnd_file.put_line(fnd_file.log, 'ELEMENT : '|| l_allowance_rec.element_name);
631:
632: fnd_file.put_line(fnd_file.log, 'ALLOWANCE CODE : '|| l_alphanum_code);
633: fnd_file.put_line(fnd_file.log, ' ');
634: fnd_file.put_line(fnd_file.log, ' ');
635: --
636: ELSE
637: --
638: -- increase the counter

Line 662: fnd_file.put_line(fnd_file.output,

658: -- insert correct allowance information into output file
659: FOR l_allowance_index IN l_allowance_codes.FIRST..l_allowance_codes.LAST
660: LOOP
661:
662: fnd_file.put_line(fnd_file.output,
663: l_allowance_codes(l_allowance_index).pay_point ||
664: l_allowance_codes(l_allowance_index).allowance_code ||
665: l_allowance_codes(l_allowance_index).allowance_descr ||
666: l_allowance_codes(l_allowance_index).pension_flag ||

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

720: FETCH csr_get_ext_rslt_id INTO l_ext_rslt_id;
721:
722: IF csr_get_ext_rslt_id%NOTFOUND THEN
723: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
724: fnd_file.put_line(fnd_file.log, 'Error: '
725: || fnd_message.get);
726: fnd_file.put_line(fnd_file.log, ' ');
727: CLOSE csr_get_ext_rslt_id;
728: fnd_message.raise_error;

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

722: IF csr_get_ext_rslt_id%NOTFOUND THEN
723: fnd_message.set_name ('BEN', 'BEN_91873_EXT_NOT_FOUND');
724: fnd_file.put_line(fnd_file.log, 'Error: '
725: || fnd_message.get);
726: fnd_file.put_line(fnd_file.log, ' ');
727: CLOSE csr_get_ext_rslt_id;
728: fnd_message.raise_error;
729: END IF; -- End if of row not found check ...
730: CLOSE csr_get_ext_rslt_id;

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

911: -- IMP!! -- remove this later
912: -- g_debug := TRUE;
913: --***************************************
914:
915: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
916: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
917:
918: IF (p_submit_request_y_n = 'N') THEN
919: fnd_file.put_line(fnd_file.log, 'First call to ' || l_proc_name );

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

912: -- g_debug := TRUE;
913: --***************************************
914:
915: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
916: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
917:
918: IF (p_submit_request_y_n = 'N') THEN
919: fnd_file.put_line(fnd_file.log, 'First call to ' || l_proc_name );
920: ELSE

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

915: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
916: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
917:
918: IF (p_submit_request_y_n = 'N') THEN
919: fnd_file.put_line(fnd_file.log, 'First call to ' || l_proc_name );
920: ELSE
921: fnd_file.put_line(fnd_file.log, 'Second call to ' || l_proc_name );
922: END IF;
923:

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

917:
918: IF (p_submit_request_y_n = 'N') THEN
919: fnd_file.put_line(fnd_file.log, 'First call to ' || l_proc_name );
920: ELSE
921: fnd_file.put_line(fnd_file.log, 'Second call to ' || l_proc_name );
922: END IF;
923:
924:
925: -- 115.60

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

1042: fnd_message.set_name('PQP', 'PQP_230228_PSI_EXT_SUBMIT_ERR');
1043: fnd_message.set_token('EXTNAME',g_ext_dtls(1).extract_name);
1044: l_err_msg := fnd_message.get;
1045: errbuf := l_err_msg;
1046: fnd_file.put_line(fnd_file.log, l_err_msg);
1047: l_err_msg := NULL;
1048: END IF;
1049:
1050: COMMIT;

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

1131: fnd_message.set_name('PQP', 'PQP_230228_PSI_EXT_SUBMIT_ERR');
1132: fnd_message.set_token('EXTNAME',l_ext_names(i).extract_name);
1133: l_err_msg := fnd_message.get;
1134: errbuf := l_err_msg;
1135: fnd_file.put_line(fnd_file.log, l_err_msg);
1136: l_err_msg := NULL;
1137: EXIT;
1138: END IF;
1139:

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

1143: g_ext_dtls(i).extract_code := l_ext_names(i).extract_code;
1144: g_ext_dtls(i).short_name := l_extract_shortname;
1145: g_ext_dtls(i).request_id := l_request_id;
1146:
1147: -- fnd_file.put_line(fnd_file.log, 'Request ID: ' ||l_request_id || ' Extract Name: '|| l_ext_names(i).extract_name);
1148:
1149: /*
1150: g_ext_dtls(i).extract_rslt_id := get_ext_rslt_frm_req
1151: (p_request_id => l_request_id

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

1174: OR
1175: (l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL'
1176: ) THEN
1177:
1178: fnd_file.put_line(fnd_file.log, l_message);
1179:
1180: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1181: fnd_message.set_token('EXTNAME',l_ext_names(i).extract_name);
1182: l_err_msg := fnd_message.get;

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

1180: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1181: fnd_message.set_token('EXTNAME',l_ext_names(i).extract_name);
1182: l_err_msg := fnd_message.get;
1183: errbuf := l_err_msg;
1184: fnd_file.put_line(fnd_file.log, l_err_msg);
1185: l_retcode := PROGRAM_FAILURE ;
1186: l_err_msg:= NULL;
1187: -- EXIT;
1188:

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

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

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

1245: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1246: fnd_message.set_token('EXTNAME',g_ext_dtls(l_index).extract_name);
1247: l_err_msg := fnd_message.get;
1248: errbuf := l_err_msg;
1249: fnd_file.put_line(fnd_file.log, l_err_msg);
1250: l_retcode := PROGRAM_FAILURE ;
1251: l_err_msg:= NULL;
1252: -- EXIT;
1253: END IF; -- (l_dev_phase = 'COMPLETE'

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

1251: l_err_msg:= NULL;
1252: -- EXIT;
1253: END IF; -- (l_dev_phase = 'COMPLETE'
1254:
1255: -- fnd_file.put_line(fnd_file.log, 'Completed the extract' || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
1256: fnd_file.put_line(fnd_file.log, 'Completed the extract' || ' : ' || get_time);
1257:
1258: debug('Completed Request ID :'||
1259: to_char(g_ext_dtls(l_index).request_id), 160);

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

1252: -- EXIT;
1253: END IF; -- (l_dev_phase = 'COMPLETE'
1254:
1255: -- fnd_file.put_line(fnd_file.log, 'Completed the extract' || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
1256: fnd_file.put_line(fnd_file.log, 'Completed the extract' || ' : ' || get_time);
1257:
1258: debug('Completed Request ID :'||
1259: to_char(g_ext_dtls(l_index).request_id), 160);
1260: END IF;

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

1349: fnd_message.set_name('PQP', 'PQP_230228_PSI_EXT_SUBMIT_ERR');
1350: fnd_message.set_token('EXTNAME','PenServer Control Totals Process');
1351: l_err_msg := fnd_message.get;
1352: errbuf := l_err_msg;
1353: fnd_file.put_line(fnd_file.log, l_err_msg);
1354: l_err_msg := NULL;
1355: END IF;
1356:
1357: COMMIT;

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

1374: OR
1375: (l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL'
1376: ) THEN
1377:
1378: fnd_file.put_line(fnd_file.log, l_message);
1379:
1380: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1381: fnd_message.set_token('EXTNAME','PenServer Control Totals');
1382: l_err_msg := fnd_message.get;

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

1380: fnd_message.set_name('PQP', 'PQP_230229_PSI_EXT_EXEC_ERR');
1381: fnd_message.set_token('EXTNAME','PenServer Control Totals');
1382: l_err_msg := fnd_message.get;
1383: errbuf := l_err_msg;
1384: fnd_file.put_line(fnd_file.log, l_err_msg);
1385: l_retcode := PROGRAM_FAILURE ;
1386: l_err_msg:= NULL;
1387:
1388: END IF; -- (l_dev_phase = 'COMPLETE'

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

1401: RETURN;
1402: END IF;
1403:
1404: -- Write a summary in the log file
1405: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1406: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1407: fnd_file.put_line(fnd_file.log, ' ');
1408: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1409: fnd_file.put_line(fnd_file.log, ' ');

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

1402: END IF;
1403:
1404: -- Write a summary in the log file
1405: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1406: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1407: fnd_file.put_line(fnd_file.log, ' ');
1408: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1409: fnd_file.put_line(fnd_file.log, ' ');
1410: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');

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

1403:
1404: -- Write a summary in the log file
1405: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1406: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1407: fnd_file.put_line(fnd_file.log, ' ');
1408: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1409: fnd_file.put_line(fnd_file.log, ' ');
1410: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');
1411: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');

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

1404: -- Write a summary in the log file
1405: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1406: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1407: fnd_file.put_line(fnd_file.log, ' ');
1408: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1409: fnd_file.put_line(fnd_file.log, ' ');
1410: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');
1411: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');
1412:

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

1405: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1406: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1407: fnd_file.put_line(fnd_file.log, ' ');
1408: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1409: fnd_file.put_line(fnd_file.log, ' ');
1410: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');
1411: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');
1412:
1413:

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

1406: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1407: fnd_file.put_line(fnd_file.log, ' ');
1408: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1409: fnd_file.put_line(fnd_file.log, ' ');
1410: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');
1411: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');
1412:
1413:
1414: l_extract_count := 0;

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

1407: fnd_file.put_line(fnd_file.log, ' ');
1408: fnd_file.put_line(fnd_file.log, 'PenServer Interface Process completed successfully.');
1409: fnd_file.put_line(fnd_file.log, ' ');
1410: fnd_file.put_line(fnd_file.log, ' Extract Name Request Id ');
1411: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------------------------------------------- ------------ ');
1412:
1413:
1414: l_extract_count := 0;
1415: l_index := g_ext_dtls.FIRST;

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

1418: LOOP
1419:
1420: IF g_ext_dtls(l_index).extract_name IS NOT NULL
1421: THEN
1422: fnd_file.put(fnd_file.log, rpad(g_ext_dtls(l_index).extract_name, 100));
1423: fnd_file.put_line(fnd_file.log, rpad(g_ext_dtls(l_index).request_id, 15));
1424:
1425: l_extract_count := l_extract_count + 1;
1426: END IF;

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

1419:
1420: IF g_ext_dtls(l_index).extract_name IS NOT NULL
1421: THEN
1422: fnd_file.put(fnd_file.log, rpad(g_ext_dtls(l_index).extract_name, 100));
1423: fnd_file.put_line(fnd_file.log, rpad(g_ext_dtls(l_index).request_id, 15));
1424:
1425: l_extract_count := l_extract_count + 1;
1426: END IF;
1427:

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

1428: l_index := g_ext_dtls.NEXT(l_index);
1429:
1430: END LOOP; -- WHILE l_index IS NOT NULL
1431:
1432: fnd_file.put_line(fnd_file.log, 'Total Extracts processed :' ||to_char(l_extract_count));
1433: fnd_file.put_line(fnd_file.log, ' ');
1434:
1435: fnd_file.put_line(fnd_file.log, ' ');
1436: fnd_file.put_line(fnd_file.log, '********************************************************************** ');

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

1429:
1430: END LOOP; -- WHILE l_index IS NOT NULL
1431:
1432: fnd_file.put_line(fnd_file.log, 'Total Extracts processed :' ||to_char(l_extract_count));
1433: fnd_file.put_line(fnd_file.log, ' ');
1434:
1435: fnd_file.put_line(fnd_file.log, ' ');
1436: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1437: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');

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

1431:
1432: fnd_file.put_line(fnd_file.log, 'Total Extracts processed :' ||to_char(l_extract_count));
1433: fnd_file.put_line(fnd_file.log, ' ');
1434:
1435: fnd_file.put_line(fnd_file.log, ' ');
1436: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1437: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1438:
1439:

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

1432: fnd_file.put_line(fnd_file.log, 'Total Extracts processed :' ||to_char(l_extract_count));
1433: fnd_file.put_line(fnd_file.log, ' ');
1434:
1435: fnd_file.put_line(fnd_file.log, ' ');
1436: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1437: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1438:
1439:
1440: -- the follwoing ELSE is for the case when this process is NOT a parent

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

1433: fnd_file.put_line(fnd_file.log, ' ');
1434:
1435: fnd_file.put_line(fnd_file.log, ' ');
1436: fnd_file.put_line(fnd_file.log, '********************************************************************** ');
1437: fnd_file.put_line(fnd_file.log, '---------------------------------------------------------------------- ');
1438:
1439:
1440: -- the follwoing ELSE is for the case when this process is NOT a parent
1441: -- it is in fact one of the threads launched by Penserver Interface Process

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

1602: );
1603: ELSE
1604:
1605:
1606: -- fnd_file.put_line(fnd_file.log, 'calling ben_process' || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
1607: fnd_file.put_line(fnd_file.log, 'calling ben_process' || ' : ' || get_time);
1608:
1609: IF p_extract_type <> '1PED' -- cutover/code extract (full profile)
1610: THEN

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

1603: ELSE
1604:
1605:
1606: -- fnd_file.put_line(fnd_file.log, 'calling ben_process' || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
1607: fnd_file.put_line(fnd_file.log, 'calling ben_process' || ' : ' || get_time);
1608:
1609: IF p_extract_type <> '1PED' -- cutover/code extract (full profile)
1610: THEN
1611: ben_ext_thread.process

Line 1830: fnd_file.put_line(fnd_file.LOG

1826: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> l_pay_point)
1827: THEN
1828: -- Raise error as Paypoint is unknown(E)
1829: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
1830: fnd_file.put_line(fnd_file.LOG
1831: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
1832: fnd_file.put_line(fnd_file.LOG, ' ');
1833: END IF;
1834:

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

1828: -- Raise error as Paypoint is unknown(E)
1829: hr_utility.set_message(805, 'BEN_94453_INV_PAYPOINT');
1830: fnd_file.put_line(fnd_file.LOG
1831: , RPAD('Error', 30) || ': ' || hr_utility.get_message);
1832: fnd_file.put_line(fnd_file.LOG, ' ');
1833: END IF;
1834:
1835:
1836: debug('p_parent_request_id ' || p_parent_request_id, 20);

Line 2590: fnd_file.put_line(fnd_file.output,

2586: l_cntrl_tot(1).benef_det_tot_rec :=rtrim(ltrim(to_char(0, '0999999999'))); */
2587:
2588: debug ('Before writing into file');
2589: -- insert control totals information into output file
2590: fnd_file.put_line(fnd_file.output,
2591: l_cntrl_tot(1).pay_point ||
2592: l_cntrl_tot(1).file_extract_date ||
2593: l_cntrl_tot(1).seq_num ||
2594: l_cntrl_tot(1).basic_cnt ||

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

3219: Begin
3220:
3221: debug_enter(l_proc_name);
3222:
3223: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
3224: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
3225:
3226: -- 115.60
3227: -- this happens when persons are rejected at the system extract level

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

3220:
3221: debug_enter(l_proc_name);
3222:
3223: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
3224: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
3225:
3226: -- 115.60
3227: -- this happens when persons are rejected at the system extract level
3228: -- in such cases, set_shared_globals doesnt get called, and the globals

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

3288: AND ext_rslt_id = ben_ext_thread.g_ext_rslt_id;
3289:
3290: debug_exit(l_proc_name);
3291:
3292: -- fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
3293: fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || ' : ' || get_time);
3294:
3295: EXCEPTION
3296: WHEN others THEN

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

3289:
3290: debug_exit(l_proc_name);
3291:
3292: -- fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
3293: fnd_file.put_line(fnd_file.log, 'Done : ' || l_proc_name || ' : ' || get_time);
3294:
3295: EXCEPTION
3296: WHEN others THEN
3297: IF SQLCODE <> hr_utility.hr_error_number

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

3997: g_debug := pqp_gb_psi_functions.check_debug(p_business_group_id);
3998:
3999: debug_enter(l_proc_name);
4000:
4001: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
4002: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
4003:
4004:
4005: debug('Entering set_shared_globals ...',10);

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

3998:
3999: debug_enter(l_proc_name);
4000:
4001: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
4002: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
4003:
4004:
4005: debug('Entering set_shared_globals ...',10);
4006: debug ('p_business_group_id:'||p_business_group_id);

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

4381:
4382: debug_enter(l_proc_name);
4383:
4384: IF (g_count = 0) THEN
4385: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
4386: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
4387: g_count := 1;
4388: END IF;
4389:

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

4382: debug_enter(l_proc_name);
4383:
4384: IF (g_count = 0) THEN
4385: -- fnd_file.put_line(fnd_file.log, l_proc_name || to_char(SYSDATE,'dd-Mon-yyyy hh:mm:ss am'));
4386: fnd_file.put_line(fnd_file.log, l_proc_name || ' : ' || get_time);
4387: g_count := 1;
4388: END IF;
4389:
4390: