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.PSP_ENC_CREATE_LINES dependencies on FND_FILE

Line 519: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' fnd ::: If --- > assignment_id details is inserted in the table '||p_assignmnet_id);

515: CLOSE asgn_end_date_cur;
516:
517: IF l_asgn_end_date IS NULL AND l_assignment_id IS NULL THEN
518:
519: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' fnd ::: If --- > assignment_id details is inserted in the table '||p_assignmnet_id);
520: -- hr_utility.trace(' hr:::If --- > assignment_id details is inserted in the table '||p_assignmnet_id);
521:
522:
523: IF p_payroll_mode = 'Y' OR p_payroll_mode IS NULL THEN

Line 541: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' fnd:::If table --- > insert '||sql%rowcount);

537:
538:
539: insert into psp_asg_end_dates (PAYROLL_ACTION_ID ,ASSIGNMENT_ID ,PAYROLL_ID ,BG_GRP_ID ,ASG_END_DATE ) --jnerella 26/07/2012
540: values(p_payroll_action_id,p_assignmnet_id,p_payroll_id,p_business_group_id,l_asgn_end_date);
541: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' fnd:::If table --- > insert '||sql%rowcount);
542: -- hr_utility.trace(' hr:::If table --- > insert '||sql%rowcount);
543:
544: commit;
545:

Line 550: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' fnd:::Else --> assignment_id already exists in the table'||p_assignmnet_id);

546: return l_asgn_end_date;
547:
548: ELSE
549:
550: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' fnd:::Else --> assignment_id already exists in the table'||p_assignmnet_id);
551: -- hr_utility.trace(' hr::Else --> assignment_id already exists in the table'||p_assignmnet_id);
552: return l_asgn_end_date;
553:
554: END IF;

Line 583: /fnd_file.put_line(fnd_file.log,'getting 1 end_date - payroll: '||p_payroll_id||' as '||p_payroll_end_date_tab(p_payroll_id)); /

579: begin
580:
581: if p_payroll_end_date_tab.exists(p_payroll_id)
582: then
583: /*fnd_file.put_line(fnd_file.log,'getting 1 end_date - payroll: '||p_payroll_id||' as '||p_payroll_end_date_tab(p_payroll_id)); */
584:
585: return p_payroll_end_date_tab(p_payroll_id);
586: else
587:

Line 593: /fnd_file.put_line(fnd_file.log,'getting 2 end_date - payroll: '||p_payroll_id||' as '||p_payroll_end_date_tab(p_payroll_id)); /

589: fetch payroll_pay_end_date_cur into l_payroll_end_date;
590: p_payroll_end_date_tab(p_payroll_id) := l_payroll_end_date;
591: close payroll_pay_end_date_cur;
592:
593: /*fnd_file.put_line(fnd_file.log,'getting 2 end_date - payroll: '||p_payroll_id||' as '||p_payroll_end_date_tab(p_payroll_id)); */
594:
595: return p_payroll_end_date_tab(p_payroll_id);
596:
597: end if;

Line 709: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

705: END IF;
706: Exception
707:
708: WHEN OTHERS THEN
709: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
710: IF (g_error_message IS NULL) THEN
711: g_error_message := 'OBTAIN_ENC_ORG_END_DATE: ' || SQLERRM;
712: END IF;
713: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'OBTAIN_ENC_ORG_END_DATE');

Line 754: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

750: p_return_status := fnd_api.g_ret_sts_success;
751:
752: EXCEPTION
753: WHEN OTHERS THEN
754: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
755: IF (g_error_message IS NULL) THEN
756: g_error_message := 'OBTAIN_ENC_POETA_END_DATE: ' || SQLERRM;
757: END IF;
758: g_error_api_path := SUBSTR(' OBTAIN_ENC_POETA_END_DATE:'||g_error_api_path,1,230);

Line 1537: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

1533: p_return_status := fnd_api.g_ret_sts_success;
1534: EXCEPTION
1535: WHEN DIVIDE_BY_ZERO THEN
1536: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');
1537: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1538: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1539: p_return_status := fnd_api.g_ret_sts_unexp_error;
1540: WHEN OTHERS THEN
1541: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 1538: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);

1534: EXCEPTION
1535: WHEN DIVIDE_BY_ZERO THEN
1536: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');
1537: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1538: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1539: p_return_status := fnd_api.g_ret_sts_unexp_error;
1540: WHEN OTHERS THEN
1541: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1542: IF (g_error_message IS NULL) THEN

Line 1541: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1537: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1538: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1539: p_return_status := fnd_api.g_ret_sts_unexp_error;
1540: WHEN OTHERS THEN
1541: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1542: IF (g_error_message IS NULL) THEN
1543: g_error_message := l_proc_name || ': ' || SQLERRM;
1544: END IF;
1545: fnd_msg_pub.add_exc_msg('PSP', 'DETERMINE_ENC_AMOUNT');

Line 1546: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

1542: IF (g_error_message IS NULL) THEN
1543: g_error_message := l_proc_name || ': ' || SQLERRM;
1544: END IF;
1545: fnd_msg_pub.add_exc_msg('PSP', 'DETERMINE_ENC_AMOUNT');
1546: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1547: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1548: p_return_status := fnd_api.g_ret_sts_unexp_error;
1549: END determine_enc_amount;
1550: -- End of changes for bug fix 3488734

Line 1547: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);

1543: g_error_message := l_proc_name || ': ' || SQLERRM;
1544: END IF;
1545: fnd_msg_pub.add_exc_msg('PSP', 'DETERMINE_ENC_AMOUNT');
1546: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1547: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1548: p_return_status := fnd_api.g_ret_sts_unexp_error;
1549: END determine_enc_amount;
1550: -- End of changes for bug fix 3488734
1551:

Line 1937: fnd_file.put_line(fnd_file.log,'l_person_id: '||l_person_id||', p_assignment_id: '||p_assignment_id);

1933:
1934:
1935: -- Bug 10074228 Added log message as CUEL process fails because of invalid award giving no details
1936:
1937: fnd_file.put_line(fnd_file.log,'l_person_id: '||l_person_id||', p_assignment_id: '||p_assignment_id);
1938: fnd_file.put_line(fnd_file.log,'l_project_id: '||l_project_id||', l_task_id: '||l_task_id
1939: ||', l_award_id: '||l_award_id||', l_expenditure_type: '||l_expenditure_type||', l_effective_date: '||l_effective_date);
1940:
1941:

Line 1938: fnd_file.put_line(fnd_file.log,'l_project_id: '||l_project_id||', l_task_id: '||l_task_id

1934:
1935: -- Bug 10074228 Added log message as CUEL process fails because of invalid award giving no details
1936:
1937: fnd_file.put_line(fnd_file.log,'l_person_id: '||l_person_id||', p_assignment_id: '||p_assignment_id);
1938: fnd_file.put_line(fnd_file.log,'l_project_id: '||l_project_id||', l_task_id: '||l_task_id
1939: ||', l_award_id: '||l_award_id||', l_expenditure_type: '||l_expenditure_type||', l_effective_date: '||l_effective_date);
1940:
1941:
1942:

Line 1988: fnd_file.put_line(fnd_file.log, g_error_message);

1984: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
1985: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
1986: END IF;
1987: g_error_message := fnd_message.get;
1988: fnd_file.put_line(fnd_file.log, g_error_message);
1989: RAISE SUSPENSE_AC_INVALID;
1990: END IF;
1991:
1992: IF ((t_poeta_gl_hier_array(I).r_enc_start_date <= g_enc_org_end_date) AND

Line 2136: fnd_file.put_line(fnd_file.log,'l_person_id: '||l_person_id||', p_assignment_id: '||p_assignment_id);

2132:
2133: IF l_award_status IS NOT NULL THEN
2134: l_patc_status := SUBSTR(l_award_status,1,50);
2135: -- Bug 10067650 Added log message as CUEL process fails because of invalid award giving no details
2136: fnd_file.put_line(fnd_file.log,'l_person_id: '||l_person_id||', p_assignment_id: '||p_assignment_id);
2137: fnd_file.put_line(fnd_file.log,'l_project_id: '||l_project_id||', l_task_id: '||l_task_id
2138: ||', l_award_id: '||l_award_id||', l_expenditure_type: '||l_expenditure_type||', l_effective_date: '||l_effective_date);
2139:
2140: END IF;

Line 2137: fnd_file.put_line(fnd_file.log,'l_project_id: '||l_project_id||', l_task_id: '||l_task_id

2133: IF l_award_status IS NOT NULL THEN
2134: l_patc_status := SUBSTR(l_award_status,1,50);
2135: -- Bug 10067650 Added log message as CUEL process fails because of invalid award giving no details
2136: fnd_file.put_line(fnd_file.log,'l_person_id: '||l_person_id||', p_assignment_id: '||p_assignment_id);
2137: fnd_file.put_line(fnd_file.log,'l_project_id: '||l_project_id||', l_task_id: '||l_task_id
2138: ||', l_award_id: '||l_award_id||', l_expenditure_type: '||l_expenditure_type||', l_effective_date: '||l_effective_date);
2139:
2140: END IF;
2141: END IF;

Line 2184: fnd_file.put_line(fnd_file.log, g_error_message);

2180: fnd_message.set_token('END_DATE', t_poeta_gl_hier_array(i).r_enc_end_date);
2181: fnd_message.set_token('EFFECTIVE_DATE', l_poeta_end_date);
2182: END IF;
2183: g_error_message := fnd_message.get;
2184: fnd_file.put_line(fnd_file.log, g_error_message);
2185: RAISE SUSPENSE_AC_INVALID;
2186: END IF;
2187:
2188: IF ((t_poeta_gl_hier_array(I).r_enc_start_date <= g_enc_org_end_date) AND

Line 3369: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);

3365: EXCEPTION
3366: WHEN suspense_autopop_failed THEN
3367: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3368: p_return_status := fnd_api.g_ret_sts_unexp_error;
3369: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3370: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3372: WHEN OTHERS THEN
3373: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 3370: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

3366: WHEN suspense_autopop_failed THEN
3367: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3368: p_return_status := fnd_api.g_ret_sts_unexp_error;
3369: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3370: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3372: WHEN OTHERS THEN
3373: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3374: IF (g_error_message IS NULL) THEN

Line 3371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);

3367: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3368: p_return_status := fnd_api.g_ret_sts_unexp_error;
3369: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3370: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3372: WHEN OTHERS THEN
3373: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3374: IF (g_error_message IS NULL) THEN
3375: g_error_message := l_proc_name || ': ' || SQLERRM;

Line 3373: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3369: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3370: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3372: WHEN OTHERS THEN
3373: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3374: IF (g_error_message IS NULL) THEN
3375: g_error_message := l_proc_name || ': ' || SQLERRM;
3376: END IF;
3377: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');

Line 3379: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

3375: g_error_message := l_proc_name || ': ' || SQLERRM;
3376: END IF;
3377: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');
3378: p_return_status := fnd_api.g_ret_sts_unexp_error;
3379: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3380: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3381: END create_lines;
3382:
3383: ---------------------- I N S E R T S T A T E M E N T ------------------------------------

Line 3380: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);

3376: END IF;
3377: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');
3378: p_return_status := fnd_api.g_ret_sts_unexp_error;
3379: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3380: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3381: END create_lines;
3382:
3383: ---------------------- I N S E R T S T A T E M E N T ------------------------------------
3384: PROCEDURE insert_into_enc_lines(

Line 3566: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3562: END IF; /* skip inserting lines of zero dollars */
3563: p_return_status := fnd_api.g_ret_sts_success;
3564: EXCEPTION
3565: WHEN OTHERS THEN
3566: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3567: IF (g_error_message IS NULL) THEN
3568: g_error_message := 'INSERT_INTO_ENC_LINES: ' || SQLERRM;
3569: END IF;
3570: fnd_msg_pub.add_exc_msg('PSP_ENC_LINES','INSERT_INTO_ENC_LINES');

Line 3670: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3666: COMMIT;
3667: p_return_status := fnd_api.g_ret_sts_success;
3668: EXCEPTION
3669: WHEN OTHERS THEN
3670: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3671: IF (g_error_message IS NULL) THEN
3672: g_error_message := 'CREATE_CONTROLS: ' || SQLERRM;
3673: END IF;
3674: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3868: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3864: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');
3865: p_return_status := fnd_api.g_ret_sts_unexp_error;
3866:
3867: WHEN OTHERS THEN
3868: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3869: IF (g_error_message IS NULL) THEN
3870: g_error_message := 'DETERMINE_PRO_RATA_DATES: ' || SQLERRM;
3871: END IF;
3872: g_error_api_path := SUBSTR(' DETERMINE_PRO_RATA_DATES'||g_error_api_path,1,230);

Line 4071: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

4067: p_return_status := fnd_api.g_ret_sts_success;
4068:
4069: EXCEPTION
4070: WHEN OTHERS THEN
4071: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4072: IF (g_error_message IS NULL) THEN
4073: g_error_message := 'INSERT_ENC_LINES_FROM_ARRAYS: ' || SQLERRM;
4074: END IF;
4075: g_error_api_path := SUBSTR(' INSERT_ENC_LINES_FROM_ARRAYS:'||g_error_api_path,1,230);

Line 6574: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

6570:
6571: p_return_status := fnd_api.g_ret_sts_success;
6572: EXCEPTION
6573: WHEN OTHERS THEN
6574: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6575: IF (g_error_message IS NULL) THEN
6576: g_error_message := l_proc_name || ': ' || SQLERRM;
6577: END IF;
6578: g_error_api_path := SUBSTR(' SUB_SLICE_ASG_CHUNK:'||g_error_api_path,1,230);

Line 6581: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

6577: END IF;
6578: g_error_api_path := SUBSTR(' SUB_SLICE_ASG_CHUNK:'||g_error_api_path,1,230);
6579: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');
6580: p_return_status := fnd_api.g_ret_sts_unexp_error;
6581: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
6582: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6583: END sub_slice_asg_chunk;
6584: -- End of bug fix 3462452
6585:

Line 6582: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);

6578: g_error_api_path := SUBSTR(' SUB_SLICE_ASG_CHUNK:'||g_error_api_path,1,230);
6579: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');
6580: p_return_status := fnd_api.g_ret_sts_unexp_error;
6581: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
6582: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6583: END sub_slice_asg_chunk;
6584: -- End of bug fix 3462452
6585:
6586: /*

Line 6603: fnd_file.put_line(fnd_file.log,fnd_date.date_to_canonical(SYSDATE) || ' FND :: Initializing the profile option ');

6599: */
6600:
6601: PROCEDURE cel_init(p_payroll_action_id IN NUMBER) IS
6602: BEGIN
6603: fnd_file.put_line(fnd_file.log,fnd_date.date_to_canonical(SYSDATE) || ' FND :: Initializing the profile option ');
6604: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' HR :: Initializing the profile option ');
6605: g_payroll_mode := NVL(FND_PROFILE.VALUE('PSP_USING_ORACLE_PAYROLL'),'Y'); -- 13566809
6606: -- spc_track_cel('Init', NULL, 'Start');
6607: NULL;

Line 6611: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

6607: NULL;
6608: -- spc_track_cel('Init', NULL, 'End');
6609: EXCEPTION
6610: WHEN OTHERS THEN
6611: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6612: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6613: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6614: p_print_header => FND_API.G_TRUE);
6615: END cel_init;

Line 6613: psp_message_s.print_error(p_mode => FND_FILE.LOG,

6609: EXCEPTION
6610: WHEN OTHERS THEN
6611: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6612: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6613: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6614: p_print_header => FND_API.G_TRUE);
6615: END cel_init;
6616:
6617: PROCEDURE cel_range_code (pactid IN NUMBER,

Line 6721: fnd_file.put_line(fnd_file.log, g_warning_message);

6717:
6718: IF (SQL%ROWCOUNT = 0) THEN
6719: fnd_message.set_name('PSP', 'PSP_ENC_NO_LIN_UPD');
6720: g_warning_message := fnd_message.get;
6721: fnd_file.put_line(fnd_file.log, g_warning_message);
6722: psp_general.add_report_error
6723: (p_request_id => l_request_id,
6724: p_message_level => 'N',
6725: p_source_id => NULL,

Line 6737: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);

6733: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' sqlstr: ' || sqlstr);
6734: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6735: EXCEPTION
6736: WHEN NO_UPDATE_REC_FOUND THEN
6737: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6738: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6739: WHEN OTHERS THEN
6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

Line 6738: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);

6734: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6735: EXCEPTION
6736: WHEN NO_UPDATE_REC_FOUND THEN
6737: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6738: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6739: WHEN OTHERS THEN
6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6742: psp_message_s.print_error(p_mode => FND_FILE.LOG,

Line 6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

6736: WHEN NO_UPDATE_REC_FOUND THEN
6737: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6738: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6739: WHEN OTHERS THEN
6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6742: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6743: p_print_header => FND_API.G_TRUE);
6744: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);

Line 6742: psp_message_s.print_error(p_mode => FND_FILE.LOG,

6738: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6739: WHEN OTHERS THEN
6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6742: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6743: p_print_header => FND_API.G_TRUE);
6744: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6745: END cel_range_code;
6746:

Line 6744: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);

6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6742: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6743: p_print_header => FND_API.G_TRUE);
6744: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6745: END cel_range_code;
6746:
6747: PROCEDURE cel_asg_action_code (p_pactid IN NUMBER,
6748: start_asg IN NUMBER,

Line 7242: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');

7238: cel_warnings.percent.DELETE;
7239: END log_cel_warnings;
7240: BEGIN
7241: SAVEPOINT CEL_ARCHIVE;
7242: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7243:
7244: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
7245: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
7246: g_set_of_books_id := l_set_of_books_id;

Line 7328: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' t_assignments.asg_array.COUNT: ' || t_assignments.asg_array.COUNT);

7324: OPEN get_payroll_asg_cur;
7325: FETCH get_payroll_asg_cur BULK COLLECT INTO t_assignments.payroll_array, t_assignments.asg_array, t_assignments.term_date_array;
7326: CLOSE get_payroll_asg_cur;
7327:
7328: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' t_assignments.asg_array.COUNT: ' || t_assignments.asg_array.COUNT);
7329: --Bug 13036705
7330: for k in 1.. t_assignments.asg_array.COUNT
7331: loop
7332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || k||')'||' asg: '||t_assignments.asg_array(k)

Line 7332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || k||')'||' asg: '||t_assignments.asg_array(k)

7328: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' t_assignments.asg_array.COUNT: ' || t_assignments.asg_array.COUNT);
7329: --Bug 13036705
7330: for k in 1.. t_assignments.asg_array.COUNT
7331: loop
7332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || k||')'||' asg: '||t_assignments.asg_array(k)
7333: ||' payroll: '||t_assignments.payroll_array(k)
7334: ||' term date: '||t_assignments.term_date_array(k));
7335:
7336: select count(*)

Line 7341: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' count: '||l_asg_sl_count);

7337: into l_asg_sl_count
7338: from psp_enc_process_assignments
7339: where assignment_id = t_assignments.asg_array(k)
7340: and assignment_status in ('S','L');
7341: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' count: '||l_asg_sl_count);
7342:
7343: end loop;
7344: --Bug 13036705
7345: FOR recno IN 1 ..t_assignments.asg_array.COUNT

Line 7462: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed create_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id || ' element_type_id: ' || l_element_type_id);

7458: p_return_status => l_return_status);
7459: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7461: END IF;
7462: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed create_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id || ' element_type_id: ' || l_element_type_id);
7463: log_cel_warnings;
7464: END IF;
7465: END IF;
7466: IF (g_employee_hours = 'Y') THEN

Line 7511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed create_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id || ' element_type_id: ' || l_element_type_id);

7507: p_return_status => l_return_status);
7508: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7510: END IF;
7511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed create_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id || ' element_type_id: ' || l_element_type_id);
7512: log_cel_warnings;
7513: END IF;
7514: END IF;
7515: END IF;

Line 7520: fnd_file.put_line(fnd_file.log, 'No element found for encumbrance.');

7516:
7517: END LOOP;
7518:
7519: IF (earnings_element_cur%ROWCOUNT = 0) THEN
7520: fnd_file.put_line(fnd_file.log, 'No element found for encumbrance.');
7521: END IF;
7522: CLOSE earnings_element_cur;
7523:
7524: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_enc_lines_array.r_enc_element_type_id.COUNT: ' || t_enc_lines_array.r_enc_element_type_id.COUNT);

Line 7665: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');

7661:
7662: t_assignments.payroll_array.delete;
7663: t_assignments.asg_array.delete;
7664:
7665: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7666: EXCEPTION
7667: WHEN OTHERS THEN
7668: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
7669: log_cel_warnings;

Line 7668: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

7664:
7665: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7666: EXCEPTION
7667: WHEN OTHERS THEN
7668: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
7669: log_cel_warnings;
7670: IF (g_error_message IS NOT NULL) THEN
7671: IF (l_assignment_id IS NOT NULL) THEN
7672: OPEN asg_number_cur(l_enc_begin_date);

Line 7724: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);

7720: p_return_status => l_return_status);
7721: END IF;
7722: END IF;
7723: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
7724: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
7725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7726: ROLLBACK TO CEL_ARCHIVE;
7727: RAISE;
7728: END cel_archive;

Line 7725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');

7721: END IF;
7722: END IF;
7723: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
7724: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
7725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7726: ROLLBACK TO CEL_ARCHIVE;
7727: RAISE;
7728: END cel_archive;
7729:

Line 7775: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);

7771: FROM psp_enc_summary_lines
7772: WHERE payroll_action_id = p_payroll_action_id
7773: AND status_code = 'N';
7774: BEGIN
7775: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);
7776: l_last_update_date := SYSDATE;
7777: l_last_updated_by:= NVL(FND_GLOBAL.USER_ID, -1);
7778: l_request_id := fnd_global.conc_request_id;
7779:

Line 7795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Create and Update Encumbrance process has errors. Please review the Run Results Report for more details.');

7791: FETCH error_check_cur INTO l_error_count;
7792: CLOSE error_check_cur;
7793:
7794: IF (l_error_count > 0) THEN
7795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Create and Update Encumbrance process has errors. Please review the Run Results Report for more details.');
7796: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7797: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7798: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');
7799: l_xml_layout := fnd_request.add_layout('PSP','PSPENRSRTF','en','US','PDF');

Line 7798: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');

7794: IF (l_error_count > 0) THEN
7795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Create and Update Encumbrance process has errors. Please review the Run Results Report for more details.');
7796: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7797: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7798: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');
7799: l_xml_layout := fnd_request.add_layout('PSP','PSPENRSRTF','en','US','PDF');
7800: l_request_id := fnd_request.submit_request('PSP',
7801: 'PSPENRSLT',
7802: '',

Line 7811: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');

7807: TO_CHAR(l_business_group_id),
7808: TO_CHAR(l_set_of_books_id));
7809:
7810: IF l_request_id = 0 THEN
7811: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7812: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7813: fnd_msg_pub.add;
7814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7815: END IF;

Line 7855: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');

7851:
7852: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7853: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7854: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7855: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7856:
7857: DELETE FROM psp_enc_controls pec
7858: WHERE pec.payroll_action_id = p_payroll_action_id
7859: AND NOT EXISTS (SELECT 1

Line 7862: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines in psp_enc_controls which doesnt have a line in psp_enc_lines');

7858: WHERE pec.payroll_action_id = p_payroll_action_id
7859: AND NOT EXISTS (SELECT 1
7860: FROM psp_enc_lines pel
7861: WHERE pel.enc_control_id = pec.enc_control_id);
7862: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines in psp_enc_controls which doesnt have a line in psp_enc_lines');
7863:
7864: UPDATE psp_enc_controls pec
7865: SET (action_code,
7866: number_of_dr, number_of_cr,

Line 7880: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summary columns in psp_enc_controls');

7876: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7877: FROM psp_enc_lines pel
7878: WHERE pel.enc_control_id = pec.enc_control_id)
7879: WHERE payroll_action_id = p_payroll_action_id;
7880: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summary columns in psp_enc_controls');
7881:
7882: IF (l_process_mode = 'TERMINATE') THEN
7883: UPDATE psp_enc_changed_assignments peca
7884: SET payroll_action_id = p_payroll_action_id

Line 7899: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');

7895: 'U', l_last_updated_by, l_last_update_date, NULL, NVL(peca.reference_id, 0),
7896: NVL(peca.action_type, 'U'), p_payroll_action_id, change_date
7897: FROM psp_enc_changed_assignments peca
7898: WHERE payroll_action_id = p_payroll_action_id;
7899: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');
7900:
7901: DELETE psp_enc_changed_assignments peca
7902: WHERE peca.payroll_action_id = p_payroll_action_id;
7903: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted processed change assignment records in psp_enc_change_assignments');

Line 7903: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted processed change assignment records in psp_enc_change_assignments');

7899: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');
7900:
7901: DELETE psp_enc_changed_assignments peca
7902: WHERE peca.payroll_action_id = p_payroll_action_id;
7903: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted processed change assignment records in psp_enc_change_assignments');
7904:
7905: UPDATE psp_enc_processes
7906: SET process_status = 'P'
7907: WHERE payroll_action_id = p_payroll_action_id;

Line 7908: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');

7904:
7905: UPDATE psp_enc_processes
7906: SET process_status = 'P'
7907: WHERE payroll_action_id = p_payroll_action_id;
7908: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');
7909:
7910: UPDATE psp_enc_processes
7911: SET process_status = 'B',
7912: process_phase = 'no_summarize_transfer'

Line 7936: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');

7932: FROM psp_enc_summary_lines pesl
7933: WHERE pesl.payroll_action_id = p_payroll_action_id
7934: AND pesl.status_code = 'N'
7935: AND pesl.superceded_line_id is NOT NULL);
7936: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
7937: END IF;
7938:
7939: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7940: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');

Line 7941: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');

7937: END IF;
7938:
7939: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7940: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7941: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Run Results Report');
7942: l_xml_layout := fnd_request.add_layout('PSP','PSPENRSRTF','en','US','PDF');
7943: l_request_id := fnd_request.submit_request('PSP',
7944: 'PSPENRSLT',
7945: '',

Line 7954: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');

7950: TO_CHAR(l_business_group_id),
7951: TO_CHAR(l_set_of_books_id));
7952:
7953: IF l_request_id = 0 THEN
7954: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Run Results Report submission failed');
7955: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7956: fnd_msg_pub.add;
7957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7958: END IF;

Line 7967: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting data from the temporary dummy table'||sql%rowcount);

7963:
7964: DELETE FROM psp_asg_end_dates
7965: WHERE payroll_action_id = p_payroll_action_id;
7966:
7967: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting data from the temporary dummy table'||sql%rowcount);
7968: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE)|| ' Deleting data from the temporary dummy table'||sql%rowcount);
7969: IF (l_process_mode = 'TERMINATE') THEN
7970: OPEN st_count_cur;
7971: FETCH st_count_cur INTO l_st_count;

Line 7978: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Summarize and Transfer');

7974: IF (l_st_count > 0) THEN
7975: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7976: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');
7977:
7978: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Encumbrance Summarize and Transfer');
7979: l_request_id := fnd_request.submit_request('PSP',
7980: 'PSPENSTR',
7981: '',
7982: '',

Line 7989: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer submission failed');

7985: TO_CHAR(l_business_group_id),
7986: TO_CHAR(l_set_of_books_id));
7987:
7988: IF l_request_id = 0 THEN
7989: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer submission failed');
7990: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
7991: fnd_msg_pub.add;
7992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7993: END IF;

Line 7999: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');

7995: UPDATE psp_enc_processes
7996: SET process_phase = 'deinit_st'
7997: WHERE payroll_action_id = p_payroll_action_id
7998: AND process_code = 'ST';
7999: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
8000:
8001: COMMIT;
8002:
8003: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Encumbrance Summarize and Transfer request to complete');

Line 8003: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Encumbrance Summarize and Transfer request to complete');

7999: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
8000:
8001: COMMIT;
8002:
8003: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Encumbrance Summarize and Transfer request to complete');
8004: call_status := fnd_concurrent.wait_for_request(l_request_id, 10, 0, rphase, rstatus, dphase, dstatus, message);
8005:
8006: IF call_status = FALSE THEN
8007: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');

Line 8007: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');

8003: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Encumbrance Summarize and Transfer request to complete');
8004: call_status := fnd_concurrent.wait_for_request(l_request_id, 10, 0, rphase, rstatus, dphase, dstatus, message);
8005:
8006: IF call_status = FALSE THEN
8007: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer failed');
8008: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');
8009: fnd_msg_pub.add;
8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8011: END IF;

Line 8012: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer completed');

8008: fnd_message.set_name('PSP','PSP_ENC_STR_FAILED');
8009: fnd_msg_pub.add;
8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8011: END IF;
8012: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer completed');
8013: ELSE
8014: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer not required as there arent any new summary lines');
8015: END IF;
8016: END IF;

Line 8014: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer not required as there arent any new summary lines');

8010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8011: END IF;
8012: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer completed');
8013: ELSE
8014: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Encumbrance Summarize and Transfer not required as there arent any new summary lines');
8015: END IF;
8016: END IF;
8017:
8018: COMMIT;

Line 8019: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);

8015: END IF;
8016: END IF;
8017:
8018: COMMIT;
8019: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);
8020: END cel_deinit;
8021:
8022: PROCEDURE verify_changes(p_payroll_id IN NUMBER,
8023: p_assignment_id IN NUMBER,

Line 8460: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

8456: p_enc_line_type: ' || p_enc_line_type);
8457: l_retcode := FND_API.G_RET_STS_SUCCESS;
8458: EXCEPTION
8459: WHEN OTHERS THEN
8460: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
8461: IF (g_error_message IS NULL) THEN
8462: g_error_message := 'VERIFY_CHANGES: ' || SQLERRM;
8463: END IF;
8464: g_error_api_path := SUBSTR('VERIFY_CHANGES:' || g_error_api_path,1,230);

Line 8467: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes

8463: END IF;
8464: g_error_api_path := SUBSTR('VERIFY_CHANGES:' || g_error_api_path,1,230);
8465: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES', 'VERIFY_CHANGES');
8466: l_retcode := fnd_api.g_ret_sts_unexp_error;
8467: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes
8468: p_payroll_id: ' || p_payroll_id || '
8469: p_assignment_id: ' || p_assignment_id || '
8470: p_business_group_id: ' || p_business_group_id || '
8471: p_set_of_books_id: ' || p_set_of_books_id || '

Line 8557: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

8553:
8554: p_return_status := fnd_api.g_ret_sts_success;
8555: EXCEPTION
8556: WHEN OTHERS THEN
8557: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
8558: IF (g_error_message IS NULL) THEN
8559: g_error_message := 'CREATE_LIQ_LINES: ' || SQLERRM;
8560: END IF;
8561: g_error_api_path := SUBSTR('CREATE_LIQ_LINES:' || g_error_api_path,1,230);

Line 8778: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

8774: END IF;
8775: p_return_status := fnd_api.g_ret_sts_success;
8776: EXCEPTION
8777: WHEN OTHERS THEN
8778: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
8779: IF (g_error_message IS NULL) THEN
8780: g_error_message := 'CREATE_SUM_LINES: ' || SQLERRM;
8781: END IF;
8782: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);

Line 8985: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering ENC_PRE_PROCESS

8981:
8982: asg_id_tab t_asg_id_type;
8983: -- Modifications for bug 9862281 end
8984: BEGIN
8985: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering ENC_PRE_PROCESS
8986: p_payroll_action_id: ' || p_payroll_action_id || '
8987: p_payroll_id: ' || p_payroll_id || '
8988: p_process_mode: ' || p_process_mode);
8989:

Line 9055: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Using Oracle Payroll Profile Value: '||FND_PROFILE.VALUE('PSP_USING_ORACLE_PAYROLL'));

9051: and set_of_books_id = l_set_of_books_id
9052: and default_org_flag='Y';
9053: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_prev_enc_end_date = ' || l_prev_enc_end_date);
9054:
9055: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Using Oracle Payroll Profile Value: '||FND_PROFILE.VALUE('PSP_USING_ORACLE_PAYROLL'));
9056:
9057: -- The following profile check is introduced and the insert statements are duplicated
9058: -- to take care of the performance issues caused by outer joins added for the custoemrs
9059: -- who are using Non-Oracle Payroll as in the bug 12769510

Line 9063: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Using Oracle Payroll');

9059: -- who are using Non-Oracle Payroll as in the bug 12769510
9060:
9061: IF NVL(FND_PROFILE.VALUE('PSP_USING_ORACLE_PAYROLL'),'Y') = 'Y' -- Oracle Payroll Profile
9062: THEN
9063: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Using Oracle Payroll');
9064:
9065: g_payroll_mode := 'Y'; --This helps to choose the query for oracle payroll in get_asg_pay_end_date function ----13566809
9066:
9067: IF l_inc_exc_flag = 'Y' THEN

Line 9309: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Using Non-Oracle Payroll');

9305: AND pesl2.payroll_id = p_payroll_id);
9306: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '50 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9307:
9308: ELSE -- NOn-Oracle Payroll profile is set to YES (For Stanford type of customers)
9309: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Using Non-Oracle Payroll');
9310:
9311: g_payroll_mode := 'N'; --this helps to choose the query for non oracle payroll in get_asg_pay_end_date function --13566809
9312:
9313: IF l_inc_exc_flag = 'Y' THEN

Line 9602: fnd_file.put_line(fnd_file.log,fnd_date.date_to_canonical(SYSDATE) || ' Excluded asg ' ||asg_id_tab(rec_i));

9598: FETCH exc_asg_cur BULK COLLECT INTO asg_id_tab;
9599: asg_id_tab := SET(asg_id_tab);
9600:
9601: FOR rec_i IN 1..asg_id_tab.COUNT LOOP
9602: fnd_file.put_line(fnd_file.log,fnd_date.date_to_canonical(SYSDATE) || ' Excluded asg ' ||asg_id_tab(rec_i));
9603:
9604: l_asg_exists := 0;
9605:
9606: BEGIN

Line 9621: fnd_file.put_line(fnd_file.log,fnd_date.date_to_canonical(SYSDATE) || ' Deleted asg ' ||asg_id_tab(rec_i));

9617: WHERE payroll_action_id = p_payroll_action_id
9618: AND payroll_id = p_payroll_id
9619: AND request_id = l_request_id
9620: and assignment_id = asg_id_tab(rec_i);
9621: fnd_file.put_line(fnd_file.log,fnd_date.date_to_canonical(SYSDATE) || ' Deleted asg ' ||asg_id_tab(rec_i));
9622: END;
9623: END LOOP;
9624:
9625: CLOSE exc_asg_cur;

Line 10058: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

10054: p_process_mode: ' || p_process_mode);
10055: p_return_status := fnd_api.g_ret_sts_success;
10056: EXCEPTION
10057: WHEN OTHERS THEN
10058: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10059: IF (g_error_message IS NULL) THEN
10060: g_error_message := 'PSP_ENC_PROCESS: ' || SQLERRM;
10061: END IF;
10062: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

Line 10063: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);

10059: IF (g_error_message IS NULL) THEN
10060: g_error_message := 'PSP_ENC_PROCESS: ' || SQLERRM;
10061: END IF;
10062: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10063: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10064: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
10065: p_payroll_action_id: ' || p_payroll_action_id || '
10066: p_payroll_id: ' || p_payroll_id || '
10067: p_process_mode: ' || p_process_mode);

Line 10064: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS

10060: g_error_message := 'PSP_ENC_PROCESS: ' || SQLERRM;
10061: END IF;
10062: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10063: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10064: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
10065: p_payroll_action_id: ' || p_payroll_action_id || '
10066: p_payroll_id: ' || p_payroll_id || '
10067: p_process_mode: ' || p_process_mode);
10068: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 10116: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);

10112: AND assignment_id = p_assignment_id;
10113:
10114: l_request_id NUMBER(15);
10115: BEGIN
10116: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10117: l_request_id := fnd_global.conc_request_id;
10118:
10119: IF (p_person_id1 IS NULL) THEN
10120: OPEN superceded_line_cur(NULL);

Line 10128: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');

10124: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
10125: UPDATE psp_enc_lines_history
10126: SET change_flag = 'N'
10127: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
10128: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
10129:
10130: DELETE psp_enc_summary_lines
10131: WHERE payroll_action_id = p_payroll_action_id;
10132: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');

Line 10132: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');

10128: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
10129:
10130: DELETE psp_enc_summary_lines
10131: WHERE payroll_action_id = p_payroll_action_id;
10132: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
10133:
10134: DELETE psp_enc_lines
10135: WHERE payroll_action_id = p_payroll_action_id;
10136: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');

Line 10136: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');

10132: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
10133:
10134: DELETE psp_enc_lines
10135: WHERE payroll_action_id = p_payroll_action_id;
10136: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
10137:
10138: DELETE psp_enc_controls
10139: WHERE payroll_action_id = p_payroll_action_id;
10140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');

Line 10140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');

10136: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
10137:
10138: DELETE psp_enc_controls
10139: WHERE payroll_action_id = p_payroll_action_id;
10140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
10141:
10142: DELETE psp_report_errors
10143: WHERE payroll_action_id = p_payroll_action_id;
10144: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');

Line 10144: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');

10140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
10141:
10142: DELETE psp_report_errors
10143: WHERE payroll_action_id = p_payroll_action_id;
10144: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
10145:
10146: UPDATE psp_enc_processes
10147: SET process_status = 'B',
10148: process_phase = 'rollback'

Line 10150: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');

10146: UPDATE psp_enc_processes
10147: SET process_status = 'B',
10148: process_phase = 'rollback'
10149: WHERE payroll_action_id = p_payroll_action_id;
10150: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
10151:
10152: UPDATE psp_enc_process_assignments
10153: SET assignment_status = 'B'
10154: WHERE payroll_action_id = p_payroll_action_id;

Line 10155: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_process_assignments');

10151:
10152: UPDATE psp_enc_process_assignments
10153: SET assignment_status = 'B'
10154: WHERE payroll_action_id = p_payroll_action_id;
10155: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_process_assignments');
10156:
10157: UPDATE psp_enc_changed_assignments
10158: SET payroll_action_id = NULL
10159: WHERE payroll_action_id = p_payroll_action_id;

Line 10160: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');

10156:
10157: UPDATE psp_enc_changed_assignments
10158: SET payroll_action_id = NULL
10159: WHERE payroll_action_id = p_payroll_action_id;
10160: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
10161:
10162: INSERT INTO psp_enc_changed_assignments
10163: (request_id, assignment_id, payroll_id, change_type,
10164: processed_flag, reference_id, action_type, change_date)

Line 10170: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

10166: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date
10167: FROM psp_enc_changed_asg_history pecah
10168: WHERE payroll_action_id = p_payroll_action_id
10169: AND action_type NOT IN ('CR', 'LQ', 'TR');
10170: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10171:
10172: DELETE psp_enc_changed_asg_history
10173: WHERE payroll_action_id = p_payroll_action_id;
10174: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

Line 10174: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

10170: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10171:
10172: DELETE psp_enc_changed_asg_history
10173: WHERE payroll_action_id = p_payroll_action_id;
10174: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10175: ELSE
10176: OPEN asg_cur(p_person_id1, p_assignment_id1);
10177: FETCH asg_cur BULK COLLECT INTO l_assignments;
10178: CLOSE asg_cur;

Line 10246: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');

10242: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
10243: UPDATE psp_enc_lines_history
10244: SET change_flag = 'N'
10245: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
10246: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
10247:
10248: DELETE psp_enc_summary_lines
10249: WHERE payroll_action_id = p_payroll_action_id
10250: AND assignment_id = l_assignments(recno);

Line 10251: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');

10247:
10248: DELETE psp_enc_summary_lines
10249: WHERE payroll_action_id = p_payroll_action_id
10250: AND assignment_id = l_assignments(recno);
10251: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
10252:
10253: DELETE psp_enc_lines
10254: WHERE payroll_action_id = p_payroll_action_id
10255: AND assignment_id = l_assignments(recno);

Line 10256: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');

10252:
10253: DELETE psp_enc_lines
10254: WHERE payroll_action_id = p_payroll_action_id
10255: AND assignment_id = l_assignments(recno);
10256: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
10257:
10258: DELETE psp_enc_controls pec
10259: WHERE payroll_action_id = p_payroll_action_id
10260: AND NOT EXISTS (SELECT 1

Line 10264: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');

10260: AND NOT EXISTS (SELECT 1
10261: FROM psp_enc_lines pel
10262: WHERE payroll_action_id = p_payroll_action_id
10263: AND pel.enc_control_id = pec.enc_control_id);
10264: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
10265:
10266: DELETE psp_report_errors
10267: WHERE payroll_action_id = p_payroll_action_id
10268: AND source_id = l_assignments(recno);

Line 10269: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');

10265:
10266: DELETE psp_report_errors
10267: WHERE payroll_action_id = p_payroll_action_id
10268: AND source_id = l_assignments(recno);
10269: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
10270:
10271: UPDATE psp_enc_process_assignments
10272: SET assignment_status = 'B'
10273: WHERE payroll_action_id = p_payroll_action_id

Line 10275: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment status to ''Rollback'' in psp_enc_process_assignments');

10271: UPDATE psp_enc_process_assignments
10272: SET assignment_status = 'B'
10273: WHERE payroll_action_id = p_payroll_action_id
10274: AND assignment_id = l_assignments(recno);
10275: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment status to ''Rollback'' in psp_enc_process_assignments');
10276:
10277: UPDATE psp_enc_changed_assignments
10278: SET payroll_action_id = NULL
10279: WHERE payroll_action_id = p_payroll_action_id

Line 10281: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');

10277: UPDATE psp_enc_changed_assignments
10278: SET payroll_action_id = NULL
10279: WHERE payroll_action_id = p_payroll_action_id
10280: AND assignment_id = l_assignments(recno);
10281: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
10282:
10283: INSERT INTO psp_enc_changed_assignments
10284: (request_id, assignment_id, payroll_id, change_type,
10285: processed_flag, reference_id, action_type, change_date)

Line 10292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

10288: FROM psp_enc_changed_asg_history pecah
10289: WHERE payroll_action_id = p_payroll_action_id
10290: AND assignment_id = l_assignments(recno)
10291: AND action_type NOT IN ('CR', 'LQ', 'TR');
10292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10293:
10294: DELETE psp_enc_changed_asg_history
10295: WHERE payroll_action_id = p_payroll_action_id
10296: AND assignment_id = l_assignments(recno);

Line 10297: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

10293:
10294: DELETE psp_enc_changed_asg_history
10295: WHERE payroll_action_id = p_payroll_action_id
10296: AND assignment_id = l_assignments(recno);
10297: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10298: END LOOP;
10299:
10300: UPDATE psp_enc_processes
10301: SET process_status = 'B',

Line 10307: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');

10303: WHERE payroll_action_id = p_payroll_action_id
10304: AND NOT EXISTS (SELECT 1
10305: FROM psp_enc_summary_lines
10306: WHERE payroll_action_id = p_payroll_action_id);
10307: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
10308: END IF;
10309:
10310: COMMIT;
10311: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);

Line 10311: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);

10307: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
10308: END IF;
10309:
10310: COMMIT;
10311: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10312: retcode := fnd_api.g_ret_sts_success;
10313: EXCEPTION
10314: WHEN OTHERS THEN
10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

10311: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10312: retcode := fnd_api.g_ret_sts_success;
10313: EXCEPTION
10314: WHEN OTHERS THEN
10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10317: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10319: retcode := fnd_api.g_ret_sts_unexp_error;

Line 10317: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);

10313: EXCEPTION
10314: WHEN OTHERS THEN
10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10317: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10319: retcode := fnd_api.g_ret_sts_unexp_error;
10320: END rollback_cel;
10321:

Line 10318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);

10314: WHEN OTHERS THEN
10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10317: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10319: retcode := fnd_api.g_ret_sts_unexp_error;
10320: END rollback_cel;
10321:
10322: PROCEDURE load_sch_hierarchy (p_assignment_id IN NUMBER,

Line 11567: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

11563: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
11564: p_return_status := fnd_api.g_ret_sts_success;
11565: EXCEPTION
11566: WHEN OTHERS THEN
11567: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
11568: IF (g_error_message IS NULL) THEN
11569: g_error_message := 'LOAD_SCH_HIERARCHY: ' || SQLERRM;
11570: END IF;
11571: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);

Line 11574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');

11570: END IF;
11571: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);
11572: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');
11573: p_return_status := fnd_api.g_ret_sts_unexp_error;
11574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');
11575: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
11576: END load_sch_hierarchy;
11577:
11578: PROCEDURE add_cel_warnings(p_start_date IN DATE DEFAULT NULL,

Line 11575: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');

11571: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);
11572: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');
11573: p_return_status := fnd_api.g_ret_sts_unexp_error;
11574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');
11575: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
11576: END load_sch_hierarchy;
11577:
11578: PROCEDURE add_cel_warnings(p_start_date IN DATE DEFAULT NULL,
11579: p_end_date IN DATE DEFAULT NULL,

Line 12138: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

12134: p_return_status := fnd_api.g_ret_sts_success;
12135: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
12136: EXCEPTION
12137: WHEN OTHERS THEN
12138: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
12139: IF (g_error_message IS NULL) THEN
12140: g_error_message := 'UPDATE_HIERARCHY_DATES: ' || SQLERRM;
12141: END IF;
12142: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);

Line 12145: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');

12141: END IF;
12142: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);
12143: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' UPDATE_HIERARCHY_DATES');
12144: p_return_status := fnd_api.g_ret_sts_unexp_error;
12145: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
12146: END update_hierarchy_dates;
12147:
12148: PROCEDURE clear_sch_hierarchy IS
12149: BEGIN