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 DBMS_UTILITY

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 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 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 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 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 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 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 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 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 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 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 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 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);