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

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

477: p_print_header => FND_API.G_TRUE);
478: return;
479:
480: WHEN OTHERS THEN
481: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
482: ROLLBACK; --Introduced as part of bug fix 1776606
483: g_error_api_path := 'ENC_SUM_TRANS:'||g_error_api_path;
484: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
485: retcode := 2;

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

553: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'Leaving Enc_Batch_begin ');
554: EXCEPTION
555: /* Introduced as part of bug fix #1776606 */
556: when others then
557: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
558: g_error_api_path := 'ENC_BATCH_BEGIN:'||g_error_api_path;
559: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_BEGIN');
560: p_return_status := fnd_api.g_ret_sts_unexp_error;
561: RAISE;

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

718: END IF;
719: p_return_status := fnd_api.g_ret_sts_success;
720: EXCEPTION
721: WHEN OTHERS THEN
722: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
723: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;
724: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');
725: p_return_status := fnd_api.g_ret_sts_unexp_error;
726: END enc_batch_end;

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

1831: SYSDATE);
1832: p_return_status := fnd_api.g_ret_sts_success;
1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1836: g_error_api_path := 'INSERT_INTO_ENC_SUM_LINES:'||g_error_api_path;
1837: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','INSERT_INTO_ENC_SUM_LINES');
1838: p_return_status := fnd_api.g_ret_sts_unexp_error;
1839: END;

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

2600: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2601: p_return_status := fnd_api.g_ret_sts_unexp_error;
2602: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2603: WHEN OTHERS THEN
2604: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2605: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2606: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');
2607: p_return_status := fnd_api.g_ret_sts_unexp_error;
2608: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');

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

2631: fnd_message.set_token('PRODUCT',l_product);
2632: fnd_msg_pub.add;
2633: p_return_status := fnd_api.g_ret_sts_unexp_error;
2634: WHEN OTHERS THEN
2635: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2636: g_error_api_path := 'gl_je_source:'||g_error_api_path;
2637: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_source');
2638: p_return_status := fnd_api.g_ret_sts_unexp_error;
2639: END;

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

2660: fnd_message.set_token('PRODUCT',l_product);
2661: fnd_msg_pub.add;
2662: p_return_status := fnd_api.g_ret_sts_unexp_error;
2663: WHEN OTHERS THEN
2664: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2665: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
2666: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_cat');
2667: p_return_status := fnd_api.g_ret_sts_unexp_error;
2668: END;

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

2692: fnd_message.set_token('PRODUCT',l_product);
2693: fnd_msg_pub.add;
2694: p_return_status := fnd_api.g_ret_sts_unexp_error;
2695: WHEN OTHERS THEN
2696: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2697: g_error_api_path := 'enc_type:'||g_error_api_path;
2698: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','enc_type');
2699: p_return_status := fnd_api.g_ret_sts_unexp_error;
2700:

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

3909: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3910: p_return_status := fnd_api.g_ret_sts_unexp_error;
3911: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3912: WHEN OTHERS THEN
3913: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3914: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3915: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');
3916: p_return_status := fnd_api.g_ret_sts_unexp_error;
3917: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');

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

4076: p_return_status := fnd_api.g_ret_sts_success;
4077:
4078: EXCEPTION
4079: WHEN OTHERS THEN
4080: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4081: -- dbms_output.put_line('Error while inserting into gl_interface..........');
4082: g_error_api_path := 'insert_into_gl_int:'||g_error_api_path;
4083: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','insert_into_gl_int');
4084: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

5200: WHEN RETURN_BACK THEN
5201: p_return_status := fnd_api.g_ret_sts_success;
5202:
5203: WHEN OTHERS THEN
5204: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5205: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5206: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GMS_INT');
5207: p_return_status := fnd_api.g_ret_sts_unexp_error;
5208: END tr_to_gms_int;

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

6702: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6703: p_return_status := fnd_api.g_ret_sts_unexp_error;
6704: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6705: WHEN OTHERS THEN
6706: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6707: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6708: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');
6709: p_return_status := fnd_api.g_ret_sts_unexp_error;
6710: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');

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

6917: END IF;
6918: p_return_status := fnd_api.g_ret_sts_success;
6919: EXCEPTION
6920: WHEN OTHERS THEN
6921: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6922: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);
6923: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', 'CREATE_SUM_LINES');
6924: p_return_status := fnd_api.g_ret_sts_unexp_error;
6925: END create_sum_lines;

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

7069: p_return_status := fnd_api.g_ret_sts_success;
7070: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
7071: EXCEPTION
7072: WHEN OTHERS THEN
7073: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
7074: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);
7075: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', ' UPDATE_HIERARCHY_DATES');
7076: p_return_status := fnd_api.g_ret_sts_unexp_error;
7077: fnd_file.put_line(fnd_file.log, 'SQLCODE: ' || SQLCODE || ' SQLERRM: ' || SQLERRM);