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.JL_CO_GL_NIT_MANAGEMENT dependencies on DUAL

Line 327: ('LEGAL_ENTITY','INDIVIDUAL','FOREIGN_ENTITY','MERCHANT')) THEN -- ER 9435028

323: l_nit_valid := FALSE;
324: END IF;
325:
326: IF (p_nit_rec.nit_type IS NULL) OR (p_nit_rec.nit_type NOT IN
327: ('LEGAL_ENTITY','INDIVIDUAL','FOREIGN_ENTITY','MERCHANT')) THEN -- ER 9435028
328: FND_MESSAGE.SET_NAME('JL','JL_CO_GL_NIT_TYPE_REQUIRED');
329: FND_MESSAGE.SET_TOKEN('IDENTIFIER_TYPE',p_identifier_type,TRUE);
330: FND_MESSAGE.SET_TOKEN('IDENTIFIER',g_gl_je_rec.identifier);
331: FND_MESSAGE.SET_TOKEN('TAXID_TYPE', 'LEGAL_ENTITY, INDIVIDUAL, MERCHANT and FOREIGN_ENTITY'); -- ER 9435028

Line 331: FND_MESSAGE.SET_TOKEN('TAXID_TYPE', 'LEGAL_ENTITY, INDIVIDUAL, MERCHANT and FOREIGN_ENTITY'); -- ER 9435028

327: ('LEGAL_ENTITY','INDIVIDUAL','FOREIGN_ENTITY','MERCHANT')) THEN -- ER 9435028
328: FND_MESSAGE.SET_NAME('JL','JL_CO_GL_NIT_TYPE_REQUIRED');
329: FND_MESSAGE.SET_TOKEN('IDENTIFIER_TYPE',p_identifier_type,TRUE);
330: FND_MESSAGE.SET_TOKEN('IDENTIFIER',g_gl_je_rec.identifier);
331: FND_MESSAGE.SET_TOKEN('TAXID_TYPE', 'LEGAL_ENTITY, INDIVIDUAL, MERCHANT and FOREIGN_ENTITY'); -- ER 9435028
332: FND_MESSAGE.SET_TOKEN('ADD_TEXT',l_add_text,TRUE);
333: l_message_text := FND_MESSAGE.GET;
334: Insert_Error_Rec(l_message_text);
335: l_nit_valid := FALSE;

Line 374: FROM DUAL ;

370: g_login_id);
371:
372: SELECT jl_co_gl_nits_s.currval
373: INTO p_nit_rec.nit_id
374: FROM DUAL ;
375:
376: END IF;
377:
378: ELSIF l_nit_valid THEN

Line 459: FROM DUAL;

455: SELECT p_journal_rec.je_header_id,
456: p_journal_rec.je_line_num,
457: null
458: INTO g_gl_je_rec
459: FROM DUAL;
460:
461: -- Bug 9710493 Start
462: IF p_journal_rec.source in ('Purchasing','Receivables') THEN
463: -- Bug 9710493 End

Line 621: FROM DUAL

617: /* bug 7045429
618: BEGIN
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);

Line 928: FROM DUAL;

924: SELECT p_journal_rec.je_header_id,
925: p_journal_rec.je_line_num,
926: p_journal_rec.ext_nit
927: INTO g_gl_je_rec
928: FROM DUAL;
929:
930: FND_FILE.PUT_LINE(FND_FILE.log,'Generate_ap_trx : Begin ');
931:
932: FOR ap_trx IN ap_detail_lines LOOP

Line 1022: FROM dual;

1018: INTO g_nit_rec.nit,
1019: g_nit_rec.nit_name,
1020: g_nit_rec.nit_type,
1021: g_nit_rec.verifying_digit
1022: FROM dual;
1023:
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: FND_FILE.PUT_LINE(FND_FILE.log,'Exception while inserting NIT information into g_nit_rec '||SQLERRM);

Line 1049: FROM dual;

1045: 'MERCHANT'
1046: INTO g_nit_rec.nit,
1047: g_nit_rec.nit_name,
1048: g_nit_rec.nit_type
1049: FROM dual;
1050: EXCEPTION
1051: WHEN OTHERS THEN
1052: FND_FILE.PUT_LINE(FND_FILE.log,'Exception while inserting NIT information into g_nit_rec '||SQLERRM);
1053: END;

Line 1080: FROM jl_co_gl_nits jlcgn, (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,

1076: g_nit_rec.nit_name,
1077: g_nit_rec.nit_type,
1078: g_nit_rec.verifying_digit,
1079: l_supplier_num
1080: FROM jl_co_gl_nits jlcgn, (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,
1081: aps.vendor_name,
1082: aps.global_attribute10,
1083: aps.global_attribute12,
1084: aps.segment1,

Line 1108: FROM jl_co_gl_nits jlcgn, (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,

1104: g_nit_rec.nit_name,
1105: g_nit_rec.nit_type,
1106: g_nit_rec.verifying_digit,
1107: l_supplier_num
1108: FROM jl_co_gl_nits jlcgn, (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,
1109: aps.vendor_name,
1110: aps.global_attribute10,
1111: aps.global_attribute12,
1112: aps.segment1,

Line 1195: FROM DUAL

1191: /* Commented for bug3840010
1192:
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); */

Line 1247: FROM DUAL

1243: BEGIN
1244:
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);

Line 1312: (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,

1308: p_journal_rec.je_line_num
1309: FROM jl_co_gl_nits jlcgn,
1310: po_headers_all poha,
1311: PO_DISTRIBUTIONS_ALL podis,
1312: (SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099,
1313: aps.vendor_name,aps.global_attribute10,aps.global_attribute12,aps.segment1,
1314: aps.vendor_id
1315: FROM ap_suppliers aps,(select distinct person_id ,national_identifier from per_all_people_f
1316: WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

Line 1351: xla_distribution_links LNK,(SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099, aps.vendor_name,

1347: po_headers_all poha,
1348: PO_DISTRIBUTIONS_ALL podis,
1349: cst_write_offs cwo,
1350: xla_ae_lines AEL, gl_import_references gir,
1351: xla_distribution_links LNK,(SELECT nvl(papf.national_identifier,nvl(aps.individual_1099,aps.num_1099)) num_1099, aps.vendor_name,
1352: aps.global_attribute10, aps.global_attribute12, aps.segment1, aps.vendor_id
1353: FROM ap_suppliers aps,(select distinct person_id , national_identifier
1354: from per_all_people_f
1355: WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

Line 1479: FROM DUAL

1475: BEGIN
1476: FND_FILE.PUT_LINE(FND_FILE.log,'Inside PO - 003');
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);

Line 1569: (SELECT nvl(papf.national_identifier,nvl(pov.individual_1099,pov.num_1099)) num_1099,

1565: g_gl_je_rec.je_header_id,
1566: g_gl_je_rec.je_line_num
1567: FROM jl_co_gl_nits jlcgn,
1568: po_headers_all poha ,
1569: (SELECT nvl(papf.national_identifier,nvl(pov.individual_1099,pov.num_1099)) num_1099,
1570: pov.vendor_name,
1571: pov.global_attribute10,
1572: pov.global_attribute12,
1573: pov.segment1,

Line 1715: FROM DUAL;

1711: SELECT p_journal_rec.je_header_id,
1712: p_journal_rec.je_line_num,
1713: p_journal_rec.ext_nit
1714: INTO g_gl_je_rec
1715: FROM DUAL;
1716:
1717: FOR ar_trx IN ar_detail_lines LOOP
1718:
1719: g_nit_rec := NULL;

Line 1885: FROM DUAL

1881: BEGIN
1882:
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);

Line 1996: FROM DUAL;

1992: SELECT p_journal_rec.je_header_id,
1993: p_journal_rec.je_line_num,
1994: p_journal_rec.ext_nit
1995: INTO g_gl_je_rec
1996: FROM DUAL;
1997: FND_FILE.PUT_LINE(FND_FILE.log,'je_header_id, je_line_num : '||to_char(p_journal_rec.je_header_id)
1998: ||'-'||to_char(p_journal_rec.je_line_num));
1999:
2000: FND_FILE.PUT_LINE(FND_FILE.log,'Opening AR Cursor');

Line 2206: FROM DUAL

2202: BEGIN
2203: FND_FILE.PUT_LINE(FND_FILE.log,'Stage 1');
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);

Line 2257: FROM DUAL

2253: BEGIN
2254: FND_FILE.PUT_LINE(FND_FILE.log,'Stage 3');
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);

Line 2322: FROM DUAL;

2318: p_journal_rec.ext_nit_name,
2319: p_journal_rec.ext_nit_type,
2320: p_journal_rec.ext_nit_v_digit
2321: INTO g_nit_rec
2322: FROM DUAL;
2323:
2324:
2325:
2326: FND_FILE.PUT_LINE(FND_FILE.log,'Values after select into g_nit_rec ');

Line 2358: INTO g_gl_je_rec FROM DUAL;

2354:
2355: SELECT p_journal_rec.je_header_id,
2356: p_journal_rec.je_line_num,
2357: p_journal_rec.ext_nit
2358: INTO g_gl_je_rec FROM DUAL;
2359:
2360: FND_FILE.PUT_LINE(FND_FILE.log,'After select into g_gl_je_rec from p_journal_rec');
2361: FND_FILE.PUT_LINE(FND_FILE.log,'g_gl_je_rec.je_header_id '|| g_gl_je_rec.je_header_id);
2362: FND_FILE.PUT_LINE(FND_FILE.log,'g_gl_je_rec.je_line_num '|| g_gl_je_rec.je_line_num);

Line 2468: FROM DUAL

2464: BEGIN
2465:
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);

Line 3031: FROM DUAL;

3027:
3028:
3029: SELECT TO_NUMBER(NVL(fnd_profile.value('LOGIN_ID'),-1))
3030: INTO g_login_id
3031: FROM DUAL;
3032:
3033: SELECT jl_co_gl_conc_ctrl_s.nextval,
3034: p_sobid,
3035: TO_NUMBER(NVL(fnd_profile.value('USER_ID') ,-1)),

Line 3038: FROM dual;

3034: p_sobid,
3035: TO_NUMBER(NVL(fnd_profile.value('USER_ID') ,-1)),
3036: p_rcid
3037: INTO g_parameter_rec
3038: FROM dual;
3039:
3040: INSERT INTO jl_co_gl_conc_ctrl (
3041: process_id,
3042: set_of_books_id,