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.FV_DISB_IN_TRANSIT dependencies on GL_INTERFACE

Line 300: PROCEDURE populate_gl_interface( x_treasury_confirmation_id IN NUMBER,

296: END get_interface_data;
297:
298: ----------------------------------------------------------------------------------------------------------------------------
299:
300: PROCEDURE populate_gl_interface( x_treasury_confirmation_id IN NUMBER,
301: x_group_id IN NUMBER,
302: v_period IN VARCHAR2,
303: x_err_code IN OUT NOCOPY NUMBER,
304: x_err_stage IN OUT NOCOPY VARCHAR2)

Line 328: v_accounting_date gl_interface.accounting_date%TYPE;

324: v_dr_amount ap_ae_lines_all.entered_dr%TYPE;
325: v_line_type_code ap_ae_lines_all.ae_line_type_code%TYPE;
326: v_functional_curr_code gl_ledgers_public_v.currency_code%TYPE;
327:
328: v_accounting_date gl_interface.accounting_date%TYPE;
329: v_boolean BOOLEAN;
330: c_reference1 gl_interface.reference1%TYPE;
331: v_reference21 gl_interface.reference21%TYPE;
332: v_reference3 gl_interface.reference3%TYPE;

Line 330: c_reference1 gl_interface.reference1%TYPE;

326: v_functional_curr_code gl_ledgers_public_v.currency_code%TYPE;
327:
328: v_accounting_date gl_interface.accounting_date%TYPE;
329: v_boolean BOOLEAN;
330: c_reference1 gl_interface.reference1%TYPE;
331: v_reference21 gl_interface.reference21%TYPE;
332: v_reference3 gl_interface.reference3%TYPE;
333: v_currency_code gl_ledgers_public_v.currency_code%TYPE;
334: v_dr_account_segment_value gl_ussgl_account_pairs.dr_account_segment_value%TYPE;

Line 331: v_reference21 gl_interface.reference21%TYPE;

327:
328: v_accounting_date gl_interface.accounting_date%TYPE;
329: v_boolean BOOLEAN;
330: c_reference1 gl_interface.reference1%TYPE;
331: v_reference21 gl_interface.reference21%TYPE;
332: v_reference3 gl_interface.reference3%TYPE;
333: v_currency_code gl_ledgers_public_v.currency_code%TYPE;
334: v_dr_account_segment_value gl_ussgl_account_pairs.dr_account_segment_value%TYPE;
335: v_cr_account_segment_value gl_ussgl_account_pairs.cr_account_segment_value%TYPE;

Line 332: v_reference3 gl_interface.reference3%TYPE;

328: v_accounting_date gl_interface.accounting_date%TYPE;
329: v_boolean BOOLEAN;
330: c_reference1 gl_interface.reference1%TYPE;
331: v_reference21 gl_interface.reference21%TYPE;
332: v_reference3 gl_interface.reference3%TYPE;
333: v_currency_code gl_ledgers_public_v.currency_code%TYPE;
334: v_dr_account_segment_value gl_ussgl_account_pairs.dr_account_segment_value%TYPE;
335: v_cr_account_segment_value gl_ussgl_account_pairs.cr_account_segment_value%TYPE;
336: v_checkrun_name fv_treasury_confirmations.checkrun_name%TYPE ;

Line 386: l_module_name := g_module_name || 'populate_gl_interface ';

382: AND ac.void_date IS NULL;
383:
384: BEGIN
385:
386: l_module_name := g_module_name || 'populate_gl_interface ';
387: c_flex_qual_name := 'GL_ACCOUNT';
388: c_reference1 := 'Treasury';
389:
390: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'starting populate_gl_interface');

387: c_flex_qual_name := 'GL_ACCOUNT';
388: c_reference1 := 'Treasury';
389:
390: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'starting populate_gl_interface');
392: END IF;
393: x_err_code := 0;
394:
395: -- get the data needed to populate the gl_interface table

Line 395: -- get the data needed to populate the gl_interface table

391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'starting populate_gl_interface');
392: END IF;
393: x_err_code := 0;
394:
395: -- get the data needed to populate the gl_interface table
396: get_interface_data(v_chart_of_accounts_id,
397: v_functional_curr_code, -- base currency
398: x_err_code,
399: x_err_stage);

Line 494: -- gl_interface table

490:
491: get_segment_values(v_combination_id);
492:
493: -- Set reference21 to be the treasury confirmation id to be stored in
494: -- gl_interface table
495: v_reference21 := x_treasury_confirmation_id;
496:
497: -- set reference3 to be the check id to be stored in the gl_interface table
498: v_reference3 := v_check_id;

Line 497: -- set reference3 to be the check id to be stored in the gl_interface table

493: -- Set reference21 to be the treasury confirmation id to be stored in
494: -- gl_interface table
495: v_reference21 := x_treasury_confirmation_id;
496:
497: -- set reference3 to be the check id to be stored in the gl_interface table
498: v_reference3 := v_check_id;
499:
500: -- Overlay natural account segment of the array with the DR account
501: -- segment value and insert into gl_interface

Line 501: -- segment value and insert into gl_interface

497: -- set reference3 to be the check id to be stored in the gl_interface table
498: v_reference3 := v_check_id;
499:
500: -- Overlay natural account segment of the array with the DR account
501: -- segment value and insert into gl_interface
502: IF (v_cr_amount <> 0) THEN
503: a_segments(v_segment_number) := v_dr_account_segment_value;
504: v_amount := v_cr_amount;
505: v_amount_acct := v_cr_acct_amt; -- capture functional amount

Line 513: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'inserting into gl_interface');

509: v_amount_acct := v_dr_acct_amt; -- capture functional amount
510: END IF;
511:
512: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
513: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'inserting into gl_interface');
514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Amount is '||TO_CHAR(v_amount));
515: END IF;
516:
517: INSERT INTO gl_interface(status, set_of_books_id,

Line 517: INSERT INTO gl_interface(status, set_of_books_id,

513: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'inserting into gl_interface');
514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Amount is '||TO_CHAR(v_amount));
515: END IF;
516:
517: INSERT INTO gl_interface(status, set_of_books_id,
518: accounting_date, currency_code,
519: functional_currency_code,
520: user_currency_conversion_type,
521: currency_conversion_date,

Line 577: -- segment value and insert into gl_interface

573: v_org_id, v_treasury_doc_date,
574: x_group_id);
575:
576: -- Overlay natural account segment of the array with the CR account
577: -- segment value and insert into gl_interface
578: --a_segments(v_segment_number) := v_cr_account_segment_value;
579: IF (v_cr_amount <> 0) THEN
580: a_segments(v_segment_number) := v_cr_account_segment_value;
581: ELSE

Line 584: INSERT INTO gl_interface(status, set_of_books_id,

580: a_segments(v_segment_number) := v_cr_account_segment_value;
581: ELSE
582: a_segments(v_segment_number) := v_dr_account_segment_value;
583: END IF;
584: INSERT INTO gl_interface(status, set_of_books_id,
585: accounting_date, currency_code,
586: functional_currency_code,
587: user_currency_conversion_type,
588: currency_conversion_date,

Line 646: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'insert into gl_interface');

642: END LOOP;
643: CLOSE payment_dists_cur;
644:
645: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
646: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'insert into gl_interface');
647: END IF;
648: EXCEPTION
649: WHEN OTHERS THEN
650: g_errmsg := SQLERRM;

Line 653: END populate_gl_interface;

649: WHEN OTHERS THEN
650: g_errmsg := SQLERRM;
651: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_errmsg);
652: RAISE;
653: END populate_gl_interface;
654:
655: ----------------------------------------------------------------------------------------------------------------------------
656: PROCEDURE cleanup_gl_interface( X_treasury_confirmation_id IN NUMBER,
657: v_process_job IN VARCHAR2,

Line 656: PROCEDURE cleanup_gl_interface( X_treasury_confirmation_id IN NUMBER,

652: RAISE;
653: END populate_gl_interface;
654:
655: ----------------------------------------------------------------------------------------------------------------------------
656: PROCEDURE cleanup_gl_interface( X_treasury_confirmation_id IN NUMBER,
657: v_process_job IN VARCHAR2,
658: x_group_id IN NUMBER,
659: X_err_code IN OUT NOCOPY NUMBER,
660: X_err_stage IN OUT NOCOPY VARCHAR2)

Line 664: l_module_name := g_module_name || 'cleanup_gl_interface ';

660: X_err_stage IN OUT NOCOPY VARCHAR2)
661: IS
662: l_module_name VARCHAR2(200);
663: BEGIN
664: l_module_name := g_module_name || 'cleanup_gl_interface ';
665: x_err_code := 0;
666:
667: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'An error has occurred during Journal Import. Please review Journal Import Execution Report.');
668: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'The journal has been removed from the Interface table.');

Line 670: -- Delete records from GL-INTERFACE for a particular group id

666:
667: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'An error has occurred during Journal Import. Please review Journal Import Execution Report.');
668: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'The journal has been removed from the Interface table.');
669: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'After correcting error please reselect Confirm or Back OUT NOCOPY from Treasury Confirmation or resubmit Disbursements in Transit Voided Checks.');
670: -- Delete records from GL-INTERFACE for a particular group id
671: -- and update the confirmation status flag to 'N'
672: DELETE FROM GL_INTERFACE
673: WHERE user_je_source_name = 'Payables'
674: AND set_of_books_id = v_set_of_books_id

Line 672: DELETE FROM GL_INTERFACE

668: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'The journal has been removed from the Interface table.');
669: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'After correcting error please reselect Confirm or Back OUT NOCOPY from Treasury Confirmation or resubmit Disbursements in Transit Voided Checks.');
670: -- Delete records from GL-INTERFACE for a particular group id
671: -- and update the confirmation status flag to 'N'
672: DELETE FROM GL_INTERFACE
673: WHERE user_je_source_name = 'Payables'
674: AND set_of_books_id = v_set_of_books_id
675: AND group_id = x_group_id;
676:

Line 691: X_err_stage := 'There was an error importing GL Interface records. Look at the GL Import Log File.';

687: WHERE treasury_confirmation_id = x_treasury_confirmation_id;
688: END IF;
689:
690: x_err_code := 2;
691: X_err_stage := 'There was an error importing GL Interface records. Look at the GL Import Log File.';
692:
693: EXCEPTION
694: WHEN OTHERS THEN
695: x_err_code := SQLCODE;

Line 697: END cleanup_gl_interface;

693: EXCEPTION
694: WHEN OTHERS THEN
695: x_err_code := SQLCODE;
696: x_err_stage := SQLERRM;
697: END cleanup_gl_interface;
698:
699: ----------------------------------------------------------------------------------------------------------------------------
700:
701: PROCEDURE do_confirm_process( v_treasury_confirmation_id IN NUMBER,

Line 735: -- Assign the group id to be a sequence number from the gl_interface_control seq

731: IF (x_err_code <> 0) THEN
732: RETURN;
733: END IF;
734:
735: -- Assign the group id to be a sequence number from the gl_interface_control seq
736: SELECT gl_interface_control_s.NEXTVAL
737: INTO x_group_id
738: FROM dual;
739:

Line 736: SELECT gl_interface_control_s.NEXTVAL

732: RETURN;
733: END IF;
734:
735: -- Assign the group id to be a sequence number from the gl_interface_control seq
736: SELECT gl_interface_control_s.NEXTVAL
737: INTO x_group_id
738: FROM dual;
739:
740: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 753: -- If dit_flag = 'Y' then populate the gl_interface table

749: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'dit flag = '||v_dit_flag);
751: END IF;
752: IF v_dit_flag = 'Y' THEN
753: -- If dit_flag = 'Y' then populate the gl_interface table
754: -- otherwise do not do anything.
755:
756: fv_disb_in_transit.populate_gl_interface(
757: v_treasury_confirmation_id,

Line 756: fv_disb_in_transit.populate_gl_interface(

752: IF v_dit_flag = 'Y' THEN
753: -- If dit_flag = 'Y' then populate the gl_interface table
754: -- otherwise do not do anything.
755:
756: fv_disb_in_transit.populate_gl_interface(
757: v_treasury_confirmation_id,
758: x_group_id, v_period, x_err_code,x_err_stage);
759:
760: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 761: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'called populate gl_interface from do confirm process');

757: v_treasury_confirmation_id,
758: x_group_id, v_period, x_err_code,x_err_stage);
759:
760: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
761: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'called populate gl_interface from do confirm process');
762: END IF;
763:
764: IF x_err_code <> 0 THEN
765: RETURN;

Line 798: c_reference1 gl_interface.reference1%TYPE;

794: v_cc_id gl_je_lines.code_combination_id%TYPE;
795: v_n_segments NUMBER;
796: -- a_segments fnd_flex_ext.SegmentArray;
797: v_boolean BOOLEAN;
798: c_reference1 gl_interface.reference1%TYPE;
799: v_tc_id gl_interface.reference1%TYPE;
800: v_check_id ap_checks.check_id%TYPE;
801: v_invoice_id gl_je_lines.reference_4%TYPE;
802: v_period gl_period_statuses.period_name%TYPE;

Line 799: v_tc_id gl_interface.reference1%TYPE;

795: v_n_segments NUMBER;
796: -- a_segments fnd_flex_ext.SegmentArray;
797: v_boolean BOOLEAN;
798: c_reference1 gl_interface.reference1%TYPE;
799: v_tc_id gl_interface.reference1%TYPE;
800: v_check_id ap_checks.check_id%TYPE;
801: v_invoice_id gl_je_lines.reference_4%TYPE;
802: v_period gl_period_statuses.period_name%TYPE;
803: v_period_start_date gl_period_statuses.start_date%TYPE;

Line 805: v_accounting_date gl_interface.accounting_date%TYPE;

801: v_invoice_id gl_je_lines.reference_4%TYPE;
802: v_period gl_period_statuses.period_name%TYPE;
803: v_period_start_date gl_period_statuses.start_date%TYPE;
804: v_period_end_date gl_period_statuses.end_date%TYPE;
805: v_accounting_date gl_interface.accounting_date%TYPE;
806: v_cr_acct_amt gl_je_lines.accounted_cr%TYPE;
807: v_dr_acct_amt gl_je_lines.accounted_dr%TYPE;
808: v_curr_con_type gl_je_headers.currency_conversion_type%TYPE;
809: v_curr_con_rate gl_je_headers.currency_conversion_rate%TYPE;

Line 878: -- get data to populate the gl_interface table.

874: END IF;
875:
876:
877:
878: -- get data to populate the gl_interface table.
879: get_interface_data(v_chart_of_accounts_id, v_func_currency_code,
880: x_err_code, x_err_stage);
881:
882: IF x_err_code <> 0 THEN

Line 887: --from the gl_interface_control seq

883: RETURN;
884: END IF;
885:
886: -- Assign the group id to be a sequence number
887: --from the gl_interface_control seq
888:
889: SELECT gl_interface_control_s.NEXTVAL
890: INTO x_group_id
891: FROM dual;

Line 889: SELECT gl_interface_control_s.NEXTVAL

885:
886: -- Assign the group id to be a sequence number
887: --from the gl_interface_control seq
888:
889: SELECT gl_interface_control_s.NEXTVAL
890: INTO x_group_id
891: FROM dual;
892:
893: -- Find the gl_je_lines records that are associated with the

Line 932: INSERT INTO gl_interface(status, set_of_books_id,

928: END IF;
929:
930:
931:
932: INSERT INTO gl_interface(status, set_of_books_id,
933: accounting_date, currency_code,
934: user_currency_conversion_type,
935: currency_conversion_rate,
936: currency_conversion_date,

Line 1024: l_reference1 gl_interface.reference1%TYPE;

1020: l_err_stage VARCHAR2(2000);
1021: l_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
1022: l_org_id NUMBER;
1023: l_func_currency_code gl_ledgers_public_v.currency_code%TYPE;
1024: l_reference1 gl_interface.reference1%TYPE;
1025: l_insert_required BOOLEAN := FALSE;
1026: l_count_void NUMBER := 0;
1027: l_interface_run_id NUMBER;
1028: l_req_id NUMBER;

Line 1212: SELECT gl_interface_control_s.NEXTVAL

1208: END IF;
1209: END IF;
1210:
1211: IF (retcode = '0') THEN
1212: SELECT gl_interface_control_s.NEXTVAL
1213: INTO l_group_id
1214: FROM dual;
1215:
1216: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1296: INSERT INTO gl_interface

1292:
1293:
1294:
1295: BEGIN
1296: INSERT INTO gl_interface
1297: (
1298: status,
1299: set_of_books_id,
1300: accounting_date,

Line 1359: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'insert gl_interface',l_err_stage);

1355: WHEN OTHERS THEN
1356: l_err_code := SQLCODE;
1357: l_err_stage := SQLERRM;
1358: retcode := '2';
1359: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'insert gl_interface',l_err_stage);
1360: EXIT;
1361: END;
1362:
1363: IF (retcode = '0') THEN

Line 1390: l_interface_run_id := gl_interface_control_pkg.get_unique_run_id;

1386:
1387:
1388: IF ((retcode = '0') AND (l_count_void > 0)) THEN
1389: -- Obtain the interface run id
1390: l_interface_run_id := gl_interface_control_pkg.get_unique_run_id;
1391:
1392: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1393: fv_utility.debug_mesg(fnd_log.level_statement,l_module_name,'interface_run_id = '||l_interface_run_id);
1394: END IF;

Line 1399: -- Insert a control record in Gl_INTERFACE record for the Gl

1395: END IF;
1396:
1397:
1398: IF ((retcode = '0') AND (l_count_void > 0)) THEN
1399: -- Insert a control record in Gl_INTERFACE record for the Gl
1400: -- Import to work
1401: BEGIN
1402: INSERT INTO gl_interface_control
1403: (

Line 1402: INSERT INTO gl_interface_control

1398: IF ((retcode = '0') AND (l_count_void > 0)) THEN
1399: -- Insert a control record in Gl_INTERFACE record for the Gl
1400: -- Import to work
1401: BEGIN
1402: INSERT INTO gl_interface_control
1403: (
1404: je_source_name,
1405: status,
1406: interface_run_id,

Line 1423: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'insert gl_interface_control',l_err_stage);

1419: WHEN OTHERS THEN
1420: l_err_code := SQLCODE;
1421: l_err_stage := SQLERRM;
1422: retcode := '2';
1423: fv_utility.log_mesg(fnd_log.level_exception,l_module_name||'insert gl_interface_control',l_err_stage);
1424: END;
1425: END IF;
1426:
1427: IF ((retcode = '0') AND (l_count_void > 0)) THEN

Line 1485: -- Do rows exist in the GL_INTERFACE table ?

1481: END IF;
1482: END IF;
1483:
1484: IF ((retcode = '0') AND (l_count_void > 0)) THEN
1485: -- Do rows exist in the GL_INTERFACE table ?
1486:
1487: SELECT COUNT(*)
1488: INTO l_dummy
1489: FROM gl_interface

Line 1489: FROM gl_interface

1485: -- Do rows exist in the GL_INTERFACE table ?
1486:
1487: SELECT COUNT(*)
1488: INTO l_dummy
1489: FROM gl_interface
1490: WHERE group_id = l_group_id
1491: AND set_of_books_id = v_set_of_books_id
1492: AND user_je_source_name = 'Payables';
1493:

Line 1494: -- If any records exist in GL_INTERFACE then clean them up

1490: WHERE group_id = l_group_id
1491: AND set_of_books_id = v_set_of_books_id
1492: AND user_je_source_name = 'Payables';
1493:
1494: -- If any records exist in GL_INTERFACE then clean them up
1495: IF (l_dummy > 0) THEN
1496: cleanup_gl_interface
1497: (
1498: NULL,

Line 1496: cleanup_gl_interface

1492: AND user_je_source_name = 'Payables';
1493:
1494: -- If any records exist in GL_INTERFACE then clean them up
1495: IF (l_dummy > 0) THEN
1496: cleanup_gl_interface
1497: (
1498: NULL,
1499: NULL,
1500: l_group_id,

Line 1779: x_interface_run_id :=gl_interface_control_pkg.get_unique_run_id;

1775: -- if the v_process_job is 'C' or 'B' then there is a concurrent process
1776: -- to be submitted (c = confirm, b = back out)
1777:
1778: -- Obtain the interface run id
1779: x_interface_run_id :=gl_interface_control_pkg.get_unique_run_id;
1780: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'interface_run_id = '||x_interface_run_id);
1782: END IF;
1783:

Line 1784: -- Insert a control record in Gl_INTERFACE record for the Gl

1780: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'interface_run_id = '||x_interface_run_id);
1782: END IF;
1783:
1784: -- Insert a control record in Gl_INTERFACE record for the Gl
1785: -- Import to work
1786: INSERT INTO gl_interface_control(je_source_name,status,
1787: interface_run_id,group_id,set_of_books_id)
1788: VALUES ('Payables', 'S', x_interface_run_id, x_group_id,

Line 1786: INSERT INTO gl_interface_control(je_source_name,status,

1782: END IF;
1783:
1784: -- Insert a control record in Gl_INTERFACE record for the Gl
1785: -- Import to work
1786: INSERT INTO gl_interface_control(je_source_name,status,
1787: interface_run_id,group_id,set_of_books_id)
1788: VALUES ('Payables', 'S', x_interface_run_id, x_group_id,
1789: v_set_of_books_id);
1790:

Line 1842: -- Do rows exist in the GL_INTERFACE table ?

1838:
1839: v_dummy := 0;
1840:
1841:
1842: -- Do rows exist in the GL_INTERFACE table ?
1843:
1844: SELECT COUNT(*)
1845: INTO v_dummy
1846: FROM gl_interface

Line 1846: FROM gl_interface

1842: -- Do rows exist in the GL_INTERFACE table ?
1843:
1844: SELECT COUNT(*)
1845: INTO v_dummy
1846: FROM gl_interface
1847: WHERE group_id = x_group_id
1848: AND set_of_books_id = v_set_of_books_id
1849: AND user_je_source_name = 'Payables';
1850:

Line 1851: -- If any records exist in GL_INTERFACE then clean them up

1847: WHERE group_id = x_group_id
1848: AND set_of_books_id = v_set_of_books_id
1849: AND user_je_source_name = 'Payables';
1850:
1851: -- If any records exist in GL_INTERFACE then clean them up
1852: IF v_dummy > 0 THEN
1853: fv_disb_in_transit.cleanup_gl_interface(
1854: v_treasury_confirmation_id,
1855: v_process_job,

Line 1853: fv_disb_in_transit.cleanup_gl_interface(

1849: AND user_je_source_name = 'Payables';
1850:
1851: -- If any records exist in GL_INTERFACE then clean them up
1852: IF v_dummy > 0 THEN
1853: fv_disb_in_transit.cleanup_gl_interface(
1854: v_treasury_confirmation_id,
1855: v_process_job,
1856: x_group_id,
1857: x_err_code,