[Home] [Help]
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;
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,
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);
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);
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',