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_SUM_TRANS dependencies on DBMS_UTILITY

Line 322: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

318: psp_message_s.print_error(p_mode => FND_FILE.LOG,
319: p_print_header => FND_API.G_TRUE);
320: retcode := 2;
321: WHEN OTHERS THEN
322: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
323:
324: /* Introduced as part of Bug fix #1776606 */
325: ROLLBACK;
326: /* Commented as part of Bug fix #1776606

Line 449: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

445: end loop;
446: /* Introduced as part of Bug fix #1776606 */
447: EXCEPTION
448: WHEN OTHERS THEN
449: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
450:
451: g_error_api_path := 'MARK_BATCH_BEGIN: ' || g_error_api_path;
452: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_BEGIN');
453: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

618:
619: /* Introduced as part of Bug fix #1776606 */
620: EXCEPTION
621: WHEN OTHERS THEN
622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
623:
624: g_error_api_path := 'MARK_BATCH_END: ' || g_error_api_path;
625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_END');
626: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1120: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1121: p_return_status := fnd_api.g_ret_sts_unexp_error;
1122: WHEN OTHERS THEN
1123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1124:
1125: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1126: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
1127: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1273: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1269: --
1270: p_return_status := fnd_api.g_ret_sts_success;
1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1274:
1275: --dbms_output.put_line('Errrrrrrrrrrrrrrrrrrrrrrrrrrorrrrrrrrrrr.........');
1276: g_error_api_path := 'INSERT_INTO_SUMMARY_LINES:'||g_error_api_path;
1277: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');

Line 1712: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1708: WHEN RETURN_BACK THEN
1709: p_return_status := fnd_api.g_ret_sts_success;
1710:
1711: WHEN OTHERS THEN
1712: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1713:
1714: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1715: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1716: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1739: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1735: fnd_message.set_token('PRODUCT',l_product);
1736: fnd_msg_pub.add;
1737: p_return_status := fnd_api.g_ret_sts_unexp_error;
1738: WHEN OTHERS THEN
1739: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1740:
1741: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1742: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1743: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1762: fnd_message.set_token('PRODUCT',l_product);
1763: fnd_msg_pub.add;
1764: p_return_status := fnd_api.g_ret_sts_unexp_error;
1765: WHEN OTHERS THEN
1766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1767:
1768: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1769: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');
1770: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1791: fnd_message.set_token('PRODUCT',l_product);
1792: fnd_msg_pub.add;
1793: p_return_status := fnd_api.g_ret_sts_unexp_error;
1794: WHEN OTHERS THEN
1795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1796:
1797: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;
1798: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');
1799: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2721: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

2717: fnd_msg_pub.add;
2718: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2719:
2720: WHEN OTHERS THEN
2721: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2722:
2723: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2724: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
2725: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2940: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

2936: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2937: p_return_status := fnd_api.g_ret_sts_unexp_error;
2938:
2939: WHEN OTHERS THEN
2940: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2941:
2942: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2943: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2944: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3115: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3111: --dbms_output.put_line('DDDDDDDDDDDDDDDDDGL Interface Inserted ....................');
3112: p_return_status := fnd_api.g_ret_sts_success;
3113: EXCEPTION
3114: WHEN OTHERS THEN
3115: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3116:
3117: --dbms_output.put_line('Error while inserting .........................');
3118: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
3119: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');

Line 3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3643: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3644: p_return_status := fnd_api.g_ret_sts_unexp_error;
3645: WHEN OTHERS THEN
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3647:
3648: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3649: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
3650: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

4288: WHEN RETURN_BACK THEN
4289: p_return_status := fnd_api.g_ret_sts_success;
4290:
4291: WHEN OTHERS THEN
4292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4293:
4294: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4295: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');
4296: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4617: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

4613: end loop;
4614:
4615: exception
4616: when others then
4617: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4618:
4619: return FALSE;
4620: end PROCESS_COMPLETE;
4621:

Line 5493: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

5489: fnd_msg_pub.add;
5490: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5491:
5492: WHEN OTHERS THEN
5493: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5494: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5495: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');
5496: p_return_status := fnd_api.g_ret_sts_unexp_error;
5497: END;

Line 5622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

5618: p_return_status := fnd_api.g_ret_sts_success;
5619: EXCEPTION
5620:
5621: WHEN OTHERS THEN
5622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5623: -- dbms_output.put_line('Error while inserting .........................');
5624: g_error_api_path := 'INSERT_INTO_PA_INTERFACE:'||g_error_api_path;
5625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_PA_INTERFACE');
5626: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 6280: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

6276: end loop;
6277:
6278: EXCEPTION
6279: when others then
6280: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6281: hr_utility.trace( 'SandT_Supercede-->send notifications --> GET_RECEIVER_TYPES when others '||sqlerrm);
6282: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_RECEIVER_TYPES');
6283: raise;
6284: END GET_RECEIVER_TYPES;

Line 6386: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

6382: wf_engine.StartProcess(itemtype => 'PSPERAVL',
6383: itemkey => l_wf_itemkey);
6384: EXCEPTION
6385: when others then
6386: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6387:
6388: hr_utility.trace( 'SandT_Supercede-->send notifications --> call_wf when others '||sqlerrm);
6389: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CALL_WF');
6390: raise;

Line 6507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

6503: end loop;
6504: end if;
6505: EXCEPTION
6506: when others then
6507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6508:
6509: hr_utility.trace( 'SandT_Supercede-->send notifications when others '||sqlerrm);
6510: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SEND_NOTIFICATIONS');
6511: raise;

Line 6879: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

6875: t_tolerance_sline.delete;
6876: hr_utility.trace( 'SandT_Supercede--> EXITING');
6877: EXCEPTION
6878: when others then
6879: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6880: hr_utility.trace( 'SandT_Supercede--> when others in supercede_er'||sqlerrm) ;
6881: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');
6882: p_return_status := fnd_api.g_ret_sts_unexp_error;
6883: END supercede_er;