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 GL_INTERFACE

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

1839: END;
1840:
1841: -- ##########################################################################
1842: -- This procedure transfers the summarized lines from psp_enc_summary_lines
1843: -- with gl_project_flag = 'G' to gl_interface
1844:
1845: -- This procedure transfers the summarized lines from PSP_ENC_SUMMARY_LINES table
1846: -- to GL_INTERFACE table and kicks off the JOURNAL IMPORT program in GL and sends
1847: -- ENC_CONTROL_ID and END_DATE for the relevant TIME_PERIOD_ID

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

1842: -- This procedure transfers the summarized lines from psp_enc_summary_lines
1843: -- with gl_project_flag = 'G' to gl_interface
1844:
1845: -- This procedure transfers the summarized lines from PSP_ENC_SUMMARY_LINES table
1846: -- to GL_INTERFACE table and kicks off the JOURNAL IMPORT program in GL and sends
1847: -- ENC_CONTROL_ID and END_DATE for the relevant TIME_PERIOD_ID
1848: -- and GROUP_ID into the tie back procedure
1849: -- ##########################################################################
1850: /****** Commented for Create and Update multi thread enh.

Line 2000: SELECT gl_interface_control_s.nextval

1996: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1998: END IF;
1999:
2000: SELECT gl_interface_control_s.nextval
2001: INTO l_group_id
2002: FROM dual;
2003:
2004: OPEN enc_control_cur;

Line 2177: insert into gl_interface_control(

2173: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
2174: INTO l_int_run_id
2175: FROM dual;
2176:
2177: insert into gl_interface_control(
2178: je_source_name,
2179: status,
2180: interface_run_id,
2181: group_id,

Line 2273: --- added this wrapper loop on delete gl_interface for 2444657

2269:
2270: For Bug fix 1776606
2271: * /
2272:
2273: --- added this wrapper loop on delete gl_interface for 2444657
2274: --- this is to ensure that all interface recs are purged, incase
2275: -- the previous Ssummarize and Transfer did not
2276: for i in 1..gl_tie_tab.count
2277: loop

Line 2279: delete gl_interface

2275: -- the previous Ssummarize and Transfer did not
2276: for i in 1..gl_tie_tab.count
2277: loop
2278: if gl_tie_tab(i).r_group_id is not null then
2279: delete gl_interface
2280: where group_id = gl_tie_tab(i).r_group_id
2281: and user_je_source_name = l_user_je_source
2282: and set_of_books_id = l_sob_id;
2283:

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

2357: SELECT enc_control_id
2358: FROM psp_enc_controls
2359: WHERE payroll_action_id = p_payroll_action_id;
2360: BEGIN
2361: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering Transfer to GL Interface');
2362:
2363: l_created_by := fnd_global.user_id;
2364: l_tie_back_failed := NULL;
2365: l_summarization_option := NVL(fnd_profile.value('PSP_ENABLE_ENC_SUMM_GL'),'N');

Line 2392: SELECT gl_interface_control_s.nextval

2388: END IF;
2389:
2390: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);
2391:
2392: SELECT gl_interface_control_s.nextval
2393: INTO l_group_id
2394: FROM dual;
2395:
2396: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_group_id: ' || l_group_id);

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

2410: AND pesl2.superceded_line_id IS NOT NULL)
2411: AND payroll_action_id = p_payroll_action_id;
2412:
2413: 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 count: '||sql%rowcount);
2414: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'Inserting into gl_interface');
2415: INSERT INTO gl_interface
2416: (status, set_of_books_id, accounting_date,
2417: currency_code, date_created, created_by,
2418: actual_flag, user_je_category_name, user_je_source_name,

Line 2415: INSERT INTO gl_interface

2411: AND payroll_action_id = p_payroll_action_id;
2412:
2413: 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 count: '||sql%rowcount);
2414: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'Inserting into gl_interface');
2415: INSERT INTO gl_interface
2416: (status, set_of_books_id, accounting_date,
2417: currency_code, date_created, created_by,
2418: actual_flag, user_je_category_name, user_je_source_name,
2419: encumbrance_type_id, code_combination_id, entered_dr,

Line 2469: INSERT INTO gl_interface_control

2465: FROM DUAL;
2466:
2467: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_int_run_id: ' || l_int_run_id);
2468:
2469: INSERT INTO gl_interface_control
2470: (je_source_name, status, interface_run_id,
2471: group_id, set_of_books_id)
2472: VALUES (l_user_je_source, 'S', l_int_run_id,
2473: l_group_id, g_set_of_books_id);

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

2471: group_id, set_of_books_id)
2472: VALUES (l_user_je_source, 'S', l_int_run_id,
2473: l_group_id, g_set_of_books_id);
2474:
2475: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted control record into gl_interface_control');
2476: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Before submitting Journal Import');
2477:
2478: req_id := fnd_request.submit_request( 'SQLGL',
2479: 'GLLEZL',

Line 2566: DELETE gl_interface

2562: END IF;
2563: END LOOP;
2564:
2565: FORALL recno IN 1..r_groups.group_id.COUNT
2566: DELETE gl_interface
2567: WHERE group_id = r_groups.group_id(recno)
2568: AND user_je_source_name = l_user_je_source
2569: AND set_of_books_id = g_set_of_books_id;
2570:

Line 2577: 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 count: '||g_bulk_row_count);

2573: loop
2574: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
2575: end loop;
2576:
2577: 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 count: '||g_bulk_row_count);
2578:
2579: FORALL recno IN 1..r_groups.group_id.COUNT
2580: UPDATE psp_enc_summary_lines
2581: SET group_id = NULL

Line 2746: FROM gl_interface

2742:
2743: CURSOR gl_tie_back_reject_cur IS
2744: SELECT status,
2745: reference6
2746: FROM gl_interface
2747: WHERE user_je_source_name = 'OLD'
2748: AND set_of_books_id = p_set_of_books_id
2749: AND group_id = p_group_id
2750: AND reference6 IN (SELECT 'E:' || enc_summary_line_id -- Introduced for bug fix 3953230

Line 2878: l_cnt_gl_interface NUMBER;

2874: l_task_id NUMBER(15);
2875: l_status VARCHAR2(50);
2876: l_reference6 VARCHAR2(100);
2877: l_enc_ref VARCHAR2(100);
2878: l_cnt_gl_interface NUMBER;
2879: l_enc_summary_line_id NUMBER(10);
2880: l_gl_project_flag VARCHAR2(1);
2881: l_suspense_ac_failed VARCHAR2(1) := 'N';
2882: l_suspense_ac_not_found VARCHAR2(1) := 'N';

Line 2913: from gl_interface

2909: l_status VARCHAR2(30);
2910: begin
2911: select count(*)
2912: into l_cnt
2913: from gl_interface
2914: where user_je_source_name = 'OLD'
2915: and set_of_books_id = p_set_of_books_id
2916: and group_id = p_group_id
2917: and status = 'NEW';

Line 2928: delete from gl_interface

2924: -- for some reason. Return FALSE in this case. So cleanup the tables and try to transfer
2925: -- again after summarization in the second pass.
2926: -- -------------------------------------------------------------------------------------------
2927:
2928: delete from gl_interface
2929: where user_je_source_name = 'OLD'
2930: and set_of_books_id = p_set_of_books_id
2931: and group_id = p_group_id;
2932:

Line 2950: INTO l_cnt_gl_interface

2946:
2947: IF (PROCESS_COMPLETE) THEN
2948:
2949: SELECT count(*)
2950: INTO l_cnt_gl_interface
2951: FROM gl_interface
2952: WHERE user_je_source_name = 'OLD'
2953: AND set_of_books_id = p_set_of_books_id
2954: AND group_id = p_group_id;

Line 2951: FROM gl_interface

2947: IF (PROCESS_COMPLETE) THEN
2948:
2949: SELECT count(*)
2950: INTO l_cnt_gl_interface
2951: FROM gl_interface
2952: WHERE user_je_source_name = 'OLD'
2953: AND set_of_books_id = p_set_of_books_id
2954: AND group_id = p_group_id;
2955:

Line 2956: IF l_cnt_gl_interface > 0 THEN

2952: WHERE user_je_source_name = 'OLD'
2953: AND set_of_books_id = p_set_of_books_id
2954: AND group_id = p_group_id;
2955:
2956: IF l_cnt_gl_interface > 0 THEN
2957: / * Start bug#2142865 Moved the code after loop to above * /
2958: UPDATE psp_enc_controls
2959: SET gl_phase = 'TieBack'
2960: WHERE run_id = g_run_id;

Line 3210: ELSIF l_cnt_gl_interface = 0 THEN

3206: END IF;
3207:
3208: END IF;
3209:
3210: ELSIF l_cnt_gl_interface = 0 THEN
3211: --
3212: OPEN gl_tie_back_success_cur;
3213: LOOP
3214: FETCH gl_tie_back_success_cur INTO l_enc_summary_line_id,

Line 3347: FROM gl_interface

3343: p_mode IN VARCHAR2,
3344: p_return_status OUT NOCOPY VARCHAR2) IS
3345: CURSOR int_count_cur IS
3346: SELECT COUNT(1)
3347: FROM gl_interface
3348: WHERE user_je_source_name = 'OLD'
3349: AND set_of_books_id = p_set_of_books_id
3350: AND group_id = p_group_id;
3351:

Line 3363: FROM gl_interface

3359:
3360: CURSOR gl_tie_back_reject_cur IS
3361: SELECT status,
3362: TO_NUMBER(trim(substr(reference6,3)))
3363: FROM gl_interface
3364: WHERE user_je_source_name = 'OLD'
3365: AND set_of_books_id = p_set_of_books_id
3366: AND group_id = p_group_id;
3367:

Line 3444: l_cnt_gl_interface NUMBER;

3440: l_organization_account_id NUMBER(9);
3441: l_susp_glccid NUMBER(15);
3442: l_orig_org_name hr_all_organization_units_tl.name%TYPE;
3443: l_orig_org_id NUMBER(15);
3444: l_cnt_gl_interface NUMBER;
3445: l_gl_project_flag VARCHAR2(1);
3446: l_suspense_ac_failed VARCHAR2(1);
3447: l_suspense_ac_not_found VARCHAR2(1);
3448: l_susp_ac_found VARCHAR2(10);

Line 3496: FROM gl_interface

3492: FUNCTION PROCESS_COMPLETE RETURN BOOLEAN IS
3493: l_cnt NUMBER;
3494: CURSOR int_count_cur IS
3495: SELECT COUNT(1)
3496: FROM gl_interface
3497: WHERE user_je_source_name = 'OLD'
3498: AND set_of_books_id = p_set_of_books_id
3499: AND group_id = p_group_id
3500: AND status = 'NEW';

Line 3528: DELETE FROM gl_interface

3524: IF l_cnt = 0 THEN
3525: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK.PROCESS_COMPLETE');
3526: RETURN TRUE;
3527: ELSIF l_cnt > 0 THEN
3528: DELETE FROM gl_interface
3529: WHERE user_je_source_name = 'OLD'
3530: AND set_of_books_id = p_set_of_books_id
3531: AND group_id = p_group_id;
3532: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface count: '||sql%rowcount);

Line 3532: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface count: '||sql%rowcount);

3528: DELETE FROM gl_interface
3529: WHERE user_je_source_name = 'OLD'
3530: AND set_of_books_id = p_set_of_books_id
3531: AND group_id = p_group_id;
3532: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from gl_interface count: '||sql%rowcount);
3533:
3534: DELETE FROM psp_enc_summary_lines
3535: WHERE group_id = p_group_id;
3536: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted from psp_enc_summary_lines '||sql%rowcount);

Line 3553: FETCH int_count_cur INTO l_cnt_gl_interface;

3549: l_suspense_ac_not_found := 'N';
3550:
3551: IF (PROCESS_COMPLETE) THEN
3552: OPEN int_count_cur;
3553: FETCH int_count_cur INTO l_cnt_gl_interface;
3554: CLOSE int_count_cur;
3555:
3556: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_cnt_gl_interface: ' || l_cnt_gl_interface);
3557:

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

3552: OPEN int_count_cur;
3553: FETCH int_count_cur INTO l_cnt_gl_interface;
3554: CLOSE int_count_cur;
3555:
3556: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_cnt_gl_interface: ' || l_cnt_gl_interface);
3557:
3558: IF (l_cnt_gl_interface > 0) THEN
3559: OPEN gl_tie_back_reject_cur;
3560: FETCH gl_tie_back_reject_cur BULK COLLECT INTO r_interface.status, r_interface.enc_summary_line_id;

Line 3558: IF (l_cnt_gl_interface > 0) THEN

3554: CLOSE int_count_cur;
3555:
3556: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_cnt_gl_interface: ' || l_cnt_gl_interface);
3557:
3558: IF (l_cnt_gl_interface > 0) THEN
3559: OPEN gl_tie_back_reject_cur;
3560: FETCH gl_tie_back_reject_cur BULK COLLECT INTO r_interface.status, r_interface.enc_summary_line_id;
3561: CLOSE gl_tie_back_reject_cur;
3562:

Line 3790: ELSIF (l_cnt_gl_interface = 0) THEN

3786: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
3787: end loop;
3788:
3789: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Summarize count: '||g_bulk_row_count);
3790: ELSIF (l_cnt_gl_interface = 0) THEN
3791: OPEN gl_tie_back_success_cur;
3792: FETCH gl_tie_back_success_cur BULK COLLECT INTO r_interface.enc_summary_line_id, r_interface.enc_control_id, r_interface.dr_cr_flag, r_interface.summary_amount;
3793: CLOSE gl_tie_back_success_cur;
3794:

Line 3922: -- This procedure inserts data into gl_interface

3918: END gl_enc_tie_back;
3919: -- End of changes for Create and Update multi thread enh.
3920:
3921: -- ##########################################################################
3922: -- This procedure inserts data into gl_interface
3923: -- ##########################################################################
3924:
3925:
3926: PROCEDURE insert_into_gl_int (

Line 3975: INSERT INTO GL_INTERFACE(

3971: P_ATTRIBUTE30 IN VARCHAR2,
3972: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
3973: BEGIN
3974:
3975: INSERT INTO GL_INTERFACE(
3976: STATUS,
3977: SET_OF_BOOKS_ID,
3978: ACCOUNTING_DATE,
3979: CURRENCY_CODE,

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

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;
4085:

Line 6035: l_cnt_gl_interface NUMBER;

6031: l_susp_glccid NUMBER(15);
6032: l_new_gl_code_combination_id NUMBER(15);
6033: l_orig_org_name hr_all_organization_units_tl.name%TYPE;
6034: l_orig_org_id NUMBER(15);
6035: l_cnt_gl_interface NUMBER;
6036: l_autopop_status VARCHAR2(1);
6037: l_gl_project_flag VARCHAR2(1);
6038: l_suspense_ac_failed VARCHAR2(1);
6039: l_suspense_ac_not_found VARCHAR2(1);