APPS.FV_DISB_IN_TRANSIT dependencies on GL_INTERFACE_CONTROL

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