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_LIQ_TRAN dependencies on GL_INTERFACE

Line 2636: -- with gl_project_flag = 'G' to gl_interface

2632: End of comment for bug fix 4625734 *****/
2633:
2634: -- ##########################################################################
2635: -- This procedure transfers the liquidated lines from psp_enc_summary_lines
2636: -- with gl_project_flag = 'G' to gl_interface
2637:
2638: -- This procedure transfers the liquidated lines from PSP_ENC_SUMMARY_LINES table
2639: -- to GL_INTERFACE table and kicks off the JOURNAL IMPORT program in GL and sends
2640: -- ENC_CONTROL_ID and END_DATE for the relevant TIME_PERIOD_ID

Line 2639: -- to GL_INTERFACE table and kicks off the JOURNAL IMPORT program in GL and sends

2635: -- This procedure transfers the liquidated lines from psp_enc_summary_lines
2636: -- with gl_project_flag = 'G' to gl_interface
2637:
2638: -- This procedure transfers the liquidated lines from PSP_ENC_SUMMARY_LINES table
2639: -- to GL_INTERFACE table and kicks off the JOURNAL IMPORT program in GL and sends
2640: -- ENC_CONTROL_ID and END_DATE for the relevant TIME_PERIOD_ID
2641: -- and GROUP_ID into the tie back procedure
2642: -- ##########################################################################
2643:

Line 2793: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering Transfer to GL Interface');

2789: FROM psp_enc_summary_lines
2790: WHERE group_id = l_group_id;
2791: -- End of changes for bug fix 4507892
2792: BEGIN
2793: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering Transfer to GL Interface');
2794:
2795: l_created_by := fnd_global.user_id;
2796:
2797: -- gl_tie_tab.delete; Commented for bug fix 4625734

Line 2823: SELECT gl_interface_control_s.nextval

2819: END IF;
2820:
2821: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);
2822:
2823: SELECT gl_interface_control_s.nextval
2824: INTO l_group_id
2825: FROM dual;
2826:
2827: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_group_id: ' || l_group_id);

Line 2848: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into gl_interface');

2844: AND pec.set_of_books_id = g_sob_id
2845: AND pec.gl_phase = 'Summarize');*/
2846:
2847: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated group_id in psp_enc_summary_lines for new liquidation lines');
2848: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into gl_interface');
2849:
2850: INSERT INTO gl_interface
2851: (status, set_of_books_id, accounting_date,
2852: currency_code, date_created, created_by,

Line 2850: INSERT INTO gl_interface

2846:
2847: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated group_id in psp_enc_summary_lines for new liquidation lines');
2848: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into gl_interface');
2849:
2850: INSERT INTO gl_interface
2851: (status, set_of_books_id, accounting_date,
2852: currency_code, date_created, created_by,
2853: actual_flag, user_je_category_name, user_je_source_name,
2854: encumbrance_type_id, code_combination_id, entered_dr,

Line 2987: --insert into psp_stout values(3, 'before inserting into gl interface');

2983: ELSIF int_rec.dr_cr_flag = 'D' THEN
2984: l_ent_cr := NULL;
2985: l_ent_dr := int_rec.summary_amount;
2986: END IF;
2987: --insert into psp_stout values(3, 'before inserting into gl interface');
2988: -- insert into psp_stout values(4, 'sline id is '||to_char(int_rec.enc_summary_line_id));
2989:
2990:
2991: insert_into_gl_int(

Line 3040: --dbms_output.put_line('Insert into gl_interface failed');

3036: INT_REC.ATTRIBUTE30,
3037: L_RETURN_STATUS);
3038:
3039: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3040: --dbms_output.put_line('Insert into gl_interface failed');
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: END IF;
3043:
3044: END LOOP; --int_cur loop

Line 3081: insert into gl_interface_control(

3077: FROM dual;
3078:
3079: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_int_run_id: ' || l_int_run_id);
3080:
3081: insert into gl_interface_control(
3082: je_source_name,
3083: status,
3084: interface_run_id,
3085: group_id,

Line 3095: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted control record into gl_interface_control');

3091: l_group_id,
3092: g_sob_id
3093: );
3094:
3095: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted control record into gl_interface_control');
3096: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Journal Import');
3097:
3098: req_id := fnd_request.submit_request(
3099: 'SQLGL',

Line 3218: --- added this wrapper LOOP on delete gl_interface for 2444657

3214: END LOOP;
3215: -- End of changes for bug fix 4625734
3216:
3217: /***** Commented the following for bug fix 4625734 as the distinct group is fetched as prt of bug fix 4625734
3218: --- added this wrapper LOOP on delete gl_interface for 2444657
3219: --- this is to ensure that all interface recs are purged, in case
3220: -- the previous Liquidation did not.
3221: for i in 1..gl_tie_tab.count
3222: loop

Line 3224: delete gl_interface

3220: -- the previous Liquidation did not.
3221: for i in 1..gl_tie_tab.count
3222: loop
3223: if gl_tie_tab(i).r_group_id is not null then
3224: delete gl_interface
3225: where group_id = gl_tie_tab(i).r_group_id
3226: and user_je_source_name = l_user_je_source
3227: and set_of_books_id = l_sob_id;
3228:

Line 3244: DELETE gl_interface

3240: End of comment for bug fix 4625734 *****/
3241:
3242: -- Introduced the following for bug fix 4625734
3243: FORALL recno IN 1..r_groups.group_id.COUNT
3244: DELETE gl_interface
3245: WHERE group_id = r_groups.group_id(recno)
3246: AND user_je_source_name = l_user_je_source
3247: AND set_of_books_id = g_sob_id;
3248:

Line 3249: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted groups from gl_interface for which gl_enc_tie_back is complete');

3245: WHERE group_id = r_groups.group_id(recno)
3246: AND user_je_source_name = l_user_je_source
3247: AND set_of_books_id = g_sob_id;
3248:
3249: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted groups from gl_interface for which gl_enc_tie_back is complete');
3250: -- End of changes for bug fix 4625734
3251:
3252: COMMIT; -- moved commit below del stmnt for 2479579
3253:

Line 3393: FROM gl_interface

3389: p_return_status OUT NOCOPY VARCHAR2
3390: ) IS
3391: CURSOR int_count_cur IS
3392: SELECT COUNT(1)
3393: FROM gl_interface
3394: WHERE user_je_source_name = 'OLD'
3395: AND set_of_books_id = p_set_of_books_id
3396: AND group_id = p_group_id;
3397:

Line 3410: FROM gl_interface

3406:
3407: CURSOR gl_tie_back_reject_cur IS
3408: SELECT status,
3409: to_number(trim(substr(reference6,3))) --- 4072324
3410: FROM gl_interface
3411: WHERE user_je_source_name = 'OLD'
3412: AND set_of_books_id = p_set_of_books_id
3413: AND group_id = p_group_id;
3414: /***** Commented for bug fix 4625734

Line 3541: l_cnt_gl_interface NUMBER;

3537: -- l_award_id NUMBER(15);
3538: -- l_task_id NUMBER(15);
3539: -- l_status VARCHAR2(50);
3540: -- l_reference6 VARCHAR2(100);
3541: l_cnt_gl_interface NUMBER;
3542: -- l_enc_summary_line_id NUMBER(10);
3543: -- l_gl_project_flag VARCHAR2(1);
3544: -- l_suspense_ac_failed VARCHAR2(1) := 'N'; Commented for Enh. 2768298 Removal of suspense posting in Liquidation
3545: -- l_reversal_ac_failed VARCHAR2(1) := 'N';

Line 3590: FROM gl_interface

3586: l_cnt NUMBER;
3587: -- Introduced the following for bug fix 4625734
3588: CURSOR int_count_cur IS
3589: SELECT COUNT(1)
3590: FROM gl_interface
3591: WHERE user_je_source_name = 'OLD'
3592: AND set_of_books_id = p_set_of_books_id
3593: AND group_id = p_group_id
3594: AND status = 'NEW';

Line 3619: from gl_interface

3615: begin
3616: /***** Changed the following SELECT into CURSOR for bug fix 4625734
3617: select count(*)
3618: into l_cnt
3619: from gl_interface
3620: where user_je_source_name = 'OLD'
3621: and set_of_books_id = p_set_of_books_id
3622: and group_id = p_group_id
3623: and status = 'NEW';

Line 3645: delete from gl_interface

3641: -- for some reason. Return FALSE in this case. So cleanup the tables and try to transfer
3642: -- again after summarization in the second pass.
3643: -- -------------------------------------------------------------------------------------------
3644:
3645: delete from gl_interface
3646: where user_je_source_name = 'OLD'
3647: and set_of_books_id = p_set_of_books_id
3648: and group_id = p_group_id;
3649:

Line 3650: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface');

3646: where user_je_source_name = 'OLD'
3647: and set_of_books_id = p_set_of_books_id
3648: and group_id = p_group_id;
3649:
3650: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface');
3651:
3652: -- Introduced the following for bug fix 4625734
3653: OPEN superceded_line_id_cur;
3654: FETCH superceded_line_id_cur BULK COLLECT INTO r_superceded_lines.superceded_line_id;

Line 3708: INTO l_cnt_gl_interface

3704: IF (PROCESS_COMPLETE) THEN
3705:
3706: /***** Commented the following for bug fix 4625734
3707: SELECT count(*)
3708: INTO l_cnt_gl_interface
3709: FROM gl_interface
3710: WHERE user_je_source_name = 'OLD'
3711: AND set_of_books_id = p_set_of_books_id
3712: AND group_id = p_group_id;

Line 3709: FROM gl_interface

3705:
3706: /***** Commented the following for bug fix 4625734
3707: SELECT count(*)
3708: INTO l_cnt_gl_interface
3709: FROM gl_interface
3710: WHERE user_je_source_name = 'OLD'
3711: AND set_of_books_id = p_set_of_books_id
3712: AND group_id = p_group_id;
3713: End of comment for bug fix 4625734 *****/

Line 3716: FETCH int_count_cur INTO l_cnt_gl_interface;

3712: AND group_id = p_group_id;
3713: End of comment for bug fix 4625734 *****/
3714:
3715: OPEN int_count_cur;
3716: FETCH int_count_cur INTO l_cnt_gl_interface;
3717: CLOSE int_count_cur;
3718:
3719: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_cnt_gl_interface: ' || l_cnt_gl_interface);
3720:

Line 3719: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_cnt_gl_interface: ' || l_cnt_gl_interface);

3715: OPEN int_count_cur;
3716: FETCH int_count_cur INTO l_cnt_gl_interface;
3717: CLOSE int_count_cur;
3718:
3719: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_cnt_gl_interface: ' || l_cnt_gl_interface);
3720:
3721: IF (l_cnt_gl_interface > 0) THEN
3722: OPEN gl_tie_back_reject_cur;
3723: FETCH gl_tie_back_reject_cur BULK COLLECT INTO r_interface.status, r_interface.enc_summary_line_id;

Line 3721: IF (l_cnt_gl_interface > 0) THEN

3717: CLOSE int_count_cur;
3718:
3719: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_cnt_gl_interface: ' || l_cnt_gl_interface);
3720:
3721: IF (l_cnt_gl_interface > 0) THEN
3722: OPEN gl_tie_back_reject_cur;
3723: FETCH gl_tie_back_reject_cur BULK COLLECT INTO r_interface.status, r_interface.enc_summary_line_id;
3724: CLOSE gl_tie_back_reject_cur;
3725:

Line 3778: ELSIF (l_cnt_gl_interface = 0) THEN

3774:
3775: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_enc_controls resetting gl_phase to Summarize SQL%ROWCOUNT: ' || SQL%ROWCOUNT);
3776:
3777:
3778: ELSIF (l_cnt_gl_interface = 0) THEN
3779: g_accepted_group_id := p_group_id;
3780:
3781: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_accepted_group_id: ' || g_accepted_group_id);
3782:

Line 3818: IF l_cnt_gl_interface > 0 THEN

3814: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase, summ_gl_dr_amount, summ_gl_cr_amount in psp_enc_controls SQL%ROWCOUNT: ' || SQL%ROWCOUNT);
3815: END IF;
3816:
3817: /***** Commented the following for bug fix 4625734
3818: IF l_cnt_gl_interface > 0 THEN
3819:
3820: OPEN gl_tie_back_reject_cur;
3821: LOOP
3822: FETCH gl_tie_back_reject_cur INTO l_status,l_enc_ref;

Line 4133: ELSIF l_cnt_gl_interface = 0 THEN

4129: end if;
4130: END IF;
4131: * /
4132:
4133: ELSIF l_cnt_gl_interface = 0 THEN
4134: g_accepted_group_id := p_group_id; --- for 3477373
4135: --
4136: OPEN gl_tie_back_success_cur;
4137: LOOP

Line 4246: -- This procedure inserts data into gl_interface

4242: END gl_enc_tie_back;
4243:
4244: /***** Commented the following procedure as part of bug fix 4625734
4245: --* ##########################################################################
4246: -- This procedure inserts data into gl_interface
4247: -- ##########################################################################
4248:
4249: PROCEDURE insert_into_gl_int (
4250: P_SET_OF_BOOKS_ID IN NUMBER,

Line 4298: INSERT INTO GL_INTERFACE(

4294: P_ATTRIBUTE30 IN VARCHAR2,
4295: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
4296: BEGIN
4297:
4298: INSERT INTO GL_INTERFACE(
4299: STATUS,
4300: SET_OF_BOOKS_ID,
4301: ACCOUNTING_DATE,
4302: CURRENCY_CODE,

Line 4398: --dbms_output.put_line('Insert into gl_interface successful.................');

4394: P_ATTRIBUTE27,
4395: P_ATTRIBUTE28,
4396: P_ATTRIBUTE29,
4397: P_ATTRIBUTE30);
4398: --dbms_output.put_line('Insert into gl_interface successful.................');
4399:
4400: p_return_status := fnd_api.g_ret_sts_success;
4401:
4402: EXCEPTION

Line 4404: --dbms_output.put_line('Error while inserting into gl_interface..........');

4400: p_return_status := fnd_api.g_ret_sts_success;
4401:
4402: EXCEPTION
4403: WHEN OTHERS THEN
4404: --dbms_output.put_line('Error while inserting into gl_interface..........');
4405: g_error_api_path := 'insert_into_gl_int:'||g_error_api_path;
4406: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','insert_into_gl_int');
4407: p_return_status := fnd_api.g_ret_sts_unexp_error;
4408: