APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on JL_CO_GL_CONC_ERRS

Line 140: identifier jl_co_gl_conc_errs.identifier%type);

136: verifying_digit jl_co_gl_nits.verifying_digit%type);
137:
138: TYPE t_gl_je IS RECORD (je_header_id jl_co_gl_trx.je_header_id%type,
139: je_line_num jl_co_gl_trx.je_line_num%type,
140: identifier jl_co_gl_conc_errs.identifier%type);
141:
142: g_jl_trx jl_co_gl_trx%ROWTYPE;
143: g_journal_rec journals%ROWTYPE;
144: g_parameter_rec t_parameters;

Line 157: INSERT INTO jl_co_gl_conc_errs (message_text,

153: (p_message_text IN VARCHAR2 ) IS
154:
155: BEGIN
156:
157: INSERT INTO jl_co_gl_conc_errs (message_text,
158: process_id,
159: je_header_id,
160: je_line_num,
161: identifier,

Line 198: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;

194: -- insert a new nit record
195:
196: l_master_nit_rec t_nits;
197: l_nit_valid BOOLEAN := TRUE;
198: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;
199: l_add_text VARCHAR2(30):= NULL;
200:
201: BEGIN
202: FND_FILE.PUT_LINE(FND_FILE.log,'Inside Validate NIT');

Line 429: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;

425: PROCEDURE Generate_GL_trx
426: (p_journal_rec IN journals%ROWTYPE ) IS
427:
428: l_add_text VARCHAR2(30):= NULL;
429: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;
430: -- Bug 9710493 Start
431: l_flag Number;
432: l_entity_code Varchar2(30);
433: -- Bug 9710493 End

Line 623: FROM jl_co_gl_conc_errs jlcgce

619: SELECT 'TRUE'
620: INTO g_error_exists
621: FROM DUAL
622: WHERE EXISTS (SELECT '1'
623: FROM jl_co_gl_conc_errs jlcgce
624: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
625: AND jlcgce.je_line_num = p_journal_rec.je_line_num);
626:
627: EXCEPTION

Line 1197: FROM jl_co_gl_conc_errs jlcgce

1193: SELECT 'TRUE'
1194: INTO g_error_exists
1195: FROM DUAL
1196: WHERE EXISTS (SELECT '1'
1197: FROM jl_co_gl_conc_errs jlcgce
1198: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
1199: AND jlcgce.je_line_num = p_journal_rec.je_line_num); */
1200:
1201: -- New statement for bug 3840010

Line 1204: FROM jl_co_gl_conc_errs jlcgce

1200:
1201: -- New statement for bug 3840010
1202: SELECT 'TRUE'
1203: INTO g_error_exists
1204: FROM jl_co_gl_conc_errs jlcgce
1205: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
1206: AND jlcgce.je_line_num = p_journal_rec.je_line_num and rownum = 1;
1207:
1208: EXCEPTION

Line 1249: FROM jl_co_gl_conc_errs jlcgce

1245: SELECT 'TRUE'
1246: INTO g_error_exists
1247: FROM DUAL
1248: WHERE EXISTS (SELECT '1'
1249: FROM jl_co_gl_conc_errs jlcgce
1250: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
1251: AND jlcgce.je_line_num = p_journal_rec.je_line_num);
1252: EXCEPTION
1253: WHEN no_data_found THEN

Line 1481: FROM jl_co_gl_conc_errs jlcgce

1477: SELECT 'TRUE'
1478: INTO g_error_exists
1479: FROM DUAL
1480: WHERE EXISTS (SELECT '1'
1481: FROM jl_co_gl_conc_errs jlcgce
1482: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
1483: AND jlcgce.je_line_num = p_journal_rec.je_line_num);
1484:
1485: EXCEPTION

Line 1887: FROM jl_co_gl_conc_errs jlcgce

1883: SELECT 'TRUE'
1884: INTO g_error_exists
1885: FROM DUAL
1886: WHERE EXISTS (SELECT '1'
1887: FROM jl_co_gl_conc_errs jlcgce
1888: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
1889: AND jlcgce.je_line_num = p_journal_rec.je_line_num);
1890:
1891: EXCEPTION

Line 2208: FROM jl_co_gl_conc_errs jlcgce

2204: SELECT 'TRUE'
2205: INTO g_error_exists
2206: FROM DUAL
2207: WHERE EXISTS (SELECT '1'
2208: FROM jl_co_gl_conc_errs jlcgce
2209: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
2210: AND jlcgce.je_line_num = p_journal_rec.je_line_num);
2211:
2212: EXCEPTION

Line 2259: FROM jl_co_gl_conc_errs jlcgce

2255: SELECT 'TRUE'
2256: INTO g_error_exists
2257: FROM DUAL
2258: WHERE EXISTS (SELECT '1'
2259: FROM jl_co_gl_conc_errs jlcgce
2260: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
2261: AND jlcgce.je_line_num = p_journal_rec.je_line_num);
2262:
2263: EXCEPTION

Line 2470: FROM jl_co_gl_conc_errs jlcgce

2466: SELECT 'TRUE'
2467: INTO g_error_exists
2468: FROM DUAL
2469: WHERE EXISTS (SELECT '1'
2470: FROM jl_co_gl_conc_errs jlcgce
2471: WHERE jlcgce.je_header_id = p_journal_rec.je_header_id
2472: AND jlcgce.je_line_num = p_journal_rec.je_line_num);
2473:
2474: EXCEPTION

Line 2999: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;

2995:
2996: l_request_id NUMBER := 0;
2997: i NUMBER := 1;
2998: l_rows NUMBER := 0;
2999: l_message_text jl_co_gl_conc_errs.message_text%TYPE := NULL;
3000:
3001: BEGIN
3002: FND_FILE.PUT_LINE(FND_FILE.log,'Create_Trx_Balance: Start');
3003: FND_FILE.PUT_LINE(FND_FILE.log,'Ledger ID: '||p_sobid);

Line 3010: DELETE FROM jl_co_gl_conc_errs;

3006:
3007: xla_security_pkg.set_security_context(602);
3008:
3009:
3010: DELETE FROM jl_co_gl_conc_errs;
3011:
3012: -- Find out which segment IS the natural account segment
3013: SELECT application_column_name,
3014: id_flex_num