319: l_output6 VARCHAR2(2000) := NULL;
320: BEGIN
321: JG_UTILITY_PKG.log( '> JG_ALLOCATE_JOURNALS_PKG.write_report_titles');
322: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_unalloc_request_id IS NULL) THEN
323: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE1');
324: FND_MESSAGE.set_token('SOB_NAME', RPAD(JG_JOURNAL_ALLOCATIONS_PKG.G_set_of_books_name, 67));
325: -- Bug 876171: The following line is too long for a row of length 180 characters
326: -- FND_MESSAGE.set_token('DATE_TIME', LPAD(fnd_date.date_to_charDT(SYSDATE), 90));
327: FND_MESSAGE.set_token('DATE_TIME', LPAD(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'), 76));
320: BEGIN
321: JG_UTILITY_PKG.log( '> JG_ALLOCATE_JOURNALS_PKG.write_report_titles');
322: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_unalloc_request_id IS NULL) THEN
323: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE1');
324: FND_MESSAGE.set_token('SOB_NAME', RPAD(JG_JOURNAL_ALLOCATIONS_PKG.G_set_of_books_name, 67));
325: -- Bug 876171: The following line is too long for a row of length 180 characters
326: -- FND_MESSAGE.set_token('DATE_TIME', LPAD(fnd_date.date_to_charDT(SYSDATE), 90));
327: FND_MESSAGE.set_token('DATE_TIME', LPAD(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'), 76));
328: l_output1 := FND_MESSAGE.get;
322: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_unalloc_request_id IS NULL) THEN
323: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE1');
324: FND_MESSAGE.set_token('SOB_NAME', RPAD(JG_JOURNAL_ALLOCATIONS_PKG.G_set_of_books_name, 67));
325: -- Bug 876171: The following line is too long for a row of length 180 characters
326: -- FND_MESSAGE.set_token('DATE_TIME', LPAD(fnd_date.date_to_charDT(SYSDATE), 90));
327: FND_MESSAGE.set_token('DATE_TIME', LPAD(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'), 76));
328: l_output1 := FND_MESSAGE.get;
329: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
330: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
323: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE1');
324: FND_MESSAGE.set_token('SOB_NAME', RPAD(JG_JOURNAL_ALLOCATIONS_PKG.G_set_of_books_name, 67));
325: -- Bug 876171: The following line is too long for a row of length 180 characters
326: -- FND_MESSAGE.set_token('DATE_TIME', LPAD(fnd_date.date_to_charDT(SYSDATE), 90));
327: FND_MESSAGE.set_token('DATE_TIME', LPAD(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'), 76));
328: l_output1 := FND_MESSAGE.get;
329: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
330: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
331: l_output2 := FND_MESSAGE.get;
324: FND_MESSAGE.set_token('SOB_NAME', RPAD(JG_JOURNAL_ALLOCATIONS_PKG.G_set_of_books_name, 67));
325: -- Bug 876171: The following line is too long for a row of length 180 characters
326: -- FND_MESSAGE.set_token('DATE_TIME', LPAD(fnd_date.date_to_charDT(SYSDATE), 90));
327: FND_MESSAGE.set_token('DATE_TIME', LPAD(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'), 76));
328: l_output1 := FND_MESSAGE.get;
329: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
330: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
331: l_output2 := FND_MESSAGE.get;
332: l_output3 := JG_JOURNAL_ALLOCATIONS_PKG.G_period_name;
325: -- Bug 876171: The following line is too long for a row of length 180 characters
326: -- FND_MESSAGE.set_token('DATE_TIME', LPAD(fnd_date.date_to_charDT(SYSDATE), 90));
327: FND_MESSAGE.set_token('DATE_TIME', LPAD(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'), 76));
328: l_output1 := FND_MESSAGE.get;
329: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
330: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
331: l_output2 := FND_MESSAGE.get;
332: l_output3 := JG_JOURNAL_ALLOCATIONS_PKG.G_period_name;
333: l_output310 := JG_JOURNAL_ALLOCATIONS_PKG.G_currency_code;
326: -- FND_MESSAGE.set_token('DATE_TIME', LPAD(fnd_date.date_to_charDT(SYSDATE), 90));
327: FND_MESSAGE.set_token('DATE_TIME', LPAD(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'), 76));
328: l_output1 := FND_MESSAGE.get;
329: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
330: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
331: l_output2 := FND_MESSAGE.get;
332: l_output3 := JG_JOURNAL_ALLOCATIONS_PKG.G_period_name;
333: l_output310 := JG_JOURNAL_ALLOCATIONS_PKG.G_currency_code;
334: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING2');
327: FND_MESSAGE.set_token('DATE_TIME', LPAD(TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'), 76));
328: l_output1 := FND_MESSAGE.get;
329: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
330: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
331: l_output2 := FND_MESSAGE.get;
332: l_output3 := JG_JOURNAL_ALLOCATIONS_PKG.G_period_name;
333: l_output310 := JG_JOURNAL_ALLOCATIONS_PKG.G_currency_code;
334: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING2');
335: l_output4 := FND_MESSAGE.GET;
330: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
331: l_output2 := FND_MESSAGE.get;
332: l_output3 := JG_JOURNAL_ALLOCATIONS_PKG.G_period_name;
333: l_output310 := JG_JOURNAL_ALLOCATIONS_PKG.G_currency_code;
334: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING2');
335: l_output4 := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING3');
337: l_output5 := FND_MESSAGE.GET;
338: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING1');
331: l_output2 := FND_MESSAGE.get;
332: l_output3 := JG_JOURNAL_ALLOCATIONS_PKG.G_period_name;
333: l_output310 := JG_JOURNAL_ALLOCATIONS_PKG.G_currency_code;
334: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING2');
335: l_output4 := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING3');
337: l_output5 := FND_MESSAGE.GET;
338: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING1');
339: l_output6 := FND_MESSAGE.GET;
332: l_output3 := JG_JOURNAL_ALLOCATIONS_PKG.G_period_name;
333: l_output310 := JG_JOURNAL_ALLOCATIONS_PKG.G_currency_code;
334: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING2');
335: l_output4 := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING3');
337: l_output5 := FND_MESSAGE.GET;
338: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING1');
339: l_output6 := FND_MESSAGE.GET;
340: ELSE
333: l_output310 := JG_JOURNAL_ALLOCATIONS_PKG.G_currency_code;
334: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING2');
335: l_output4 := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING3');
337: l_output5 := FND_MESSAGE.GET;
338: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING1');
339: l_output6 := FND_MESSAGE.GET;
340: ELSE
341: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_U_REPORT_TITLE1');
334: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING2');
335: l_output4 := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING3');
337: l_output5 := FND_MESSAGE.GET;
338: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING1');
339: l_output6 := FND_MESSAGE.GET;
340: ELSE
341: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_U_REPORT_TITLE1');
342: FND_MESSAGE.set_token('DATE_TIME', fnd_date.date_to_charDT(SYSDATE));
335: l_output4 := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING3');
337: l_output5 := FND_MESSAGE.GET;
338: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING1');
339: l_output6 := FND_MESSAGE.GET;
340: ELSE
341: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_U_REPORT_TITLE1');
342: FND_MESSAGE.set_token('DATE_TIME', fnd_date.date_to_charDT(SYSDATE));
343: l_output1 := FND_MESSAGE.get;
337: l_output5 := FND_MESSAGE.GET;
338: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING1');
339: l_output6 := FND_MESSAGE.GET;
340: ELSE
341: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_U_REPORT_TITLE1');
342: FND_MESSAGE.set_token('DATE_TIME', fnd_date.date_to_charDT(SYSDATE));
343: l_output1 := FND_MESSAGE.get;
344: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
345: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
338: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_ERR_HEADING1');
339: l_output6 := FND_MESSAGE.GET;
340: ELSE
341: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_U_REPORT_TITLE1');
342: FND_MESSAGE.set_token('DATE_TIME', fnd_date.date_to_charDT(SYSDATE));
343: l_output1 := FND_MESSAGE.get;
344: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
345: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
346: l_output2 := FND_MESSAGE.get;
339: l_output6 := FND_MESSAGE.GET;
340: ELSE
341: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_U_REPORT_TITLE1');
342: FND_MESSAGE.set_token('DATE_TIME', fnd_date.date_to_charDT(SYSDATE));
343: l_output1 := FND_MESSAGE.get;
344: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
345: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
346: l_output2 := FND_MESSAGE.get;
347: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING2');
340: ELSE
341: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_U_REPORT_TITLE1');
342: FND_MESSAGE.set_token('DATE_TIME', fnd_date.date_to_charDT(SYSDATE));
343: l_output1 := FND_MESSAGE.get;
344: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
345: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
346: l_output2 := FND_MESSAGE.get;
347: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING2');
348: l_output4 := FND_MESSAGE.GET;
341: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_U_REPORT_TITLE1');
342: FND_MESSAGE.set_token('DATE_TIME', fnd_date.date_to_charDT(SYSDATE));
343: l_output1 := FND_MESSAGE.get;
344: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
345: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
346: l_output2 := FND_MESSAGE.get;
347: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING2');
348: l_output4 := FND_MESSAGE.GET;
349: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING3');
342: FND_MESSAGE.set_token('DATE_TIME', fnd_date.date_to_charDT(SYSDATE));
343: l_output1 := FND_MESSAGE.get;
344: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
345: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
346: l_output2 := FND_MESSAGE.get;
347: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING2');
348: l_output4 := FND_MESSAGE.GET;
349: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING3');
350: l_output5 := FND_MESSAGE.GET;
343: l_output1 := FND_MESSAGE.get;
344: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
345: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
346: l_output2 := FND_MESSAGE.get;
347: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING2');
348: l_output4 := FND_MESSAGE.GET;
349: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING3');
350: l_output5 := FND_MESSAGE.GET;
351: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING1');
344: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_REPORT_TITLE2');
345: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
346: l_output2 := FND_MESSAGE.get;
347: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING2');
348: l_output4 := FND_MESSAGE.GET;
349: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING3');
350: l_output5 := FND_MESSAGE.GET;
351: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING1');
352: l_output6 := FND_MESSAGE.GET;
345: FND_MESSAGE.set_token('CONC_REQUEST_ID', TO_CHAR(JG_JOURNAL_ALLOCATIONS_PKG.G_request_id));
346: l_output2 := FND_MESSAGE.get;
347: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING2');
348: l_output4 := FND_MESSAGE.GET;
349: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING3');
350: l_output5 := FND_MESSAGE.GET;
351: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING1');
352: l_output6 := FND_MESSAGE.GET;
353: END IF;
346: l_output2 := FND_MESSAGE.get;
347: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING2');
348: l_output4 := FND_MESSAGE.GET;
349: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING3');
350: l_output5 := FND_MESSAGE.GET;
351: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING1');
352: l_output6 := FND_MESSAGE.GET;
353: END IF;
354: JG_UTILITY_PKG.out(l_output1);
347: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING2');
348: l_output4 := FND_MESSAGE.GET;
349: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING3');
350: l_output5 := FND_MESSAGE.GET;
351: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING1');
352: l_output6 := FND_MESSAGE.GET;
353: END IF;
354: JG_UTILITY_PKG.out(l_output1);
355: JG_UTILITY_PKG.out(l_output2);
348: l_output4 := FND_MESSAGE.GET;
349: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING3');
350: l_output5 := FND_MESSAGE.GET;
351: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_UNALLOC_HDING1');
352: l_output6 := FND_MESSAGE.GET;
353: END IF;
354: JG_UTILITY_PKG.out(l_output1);
355: JG_UTILITY_PKG.out(l_output2);
356: JG_UTILITY_PKG.out(l_output3);
377: l_line_output2 VARCHAR2(2000) := NULL;
378: l_line_output3 VARCHAR2(2000) := NULL;
379: BEGIN
380: JG_UTILITY_PKG.log('> JG_ALLOCATE_JOURNALS_PKG.write_report_headings');
381: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING1');
382: l_line_output1 := FND_MESSAGE.GET;
383: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING2');
384: l_line_output2 := FND_MESSAGE.GET;
385: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING3');
378: l_line_output3 VARCHAR2(2000) := NULL;
379: BEGIN
380: JG_UTILITY_PKG.log('> JG_ALLOCATE_JOURNALS_PKG.write_report_headings');
381: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING1');
382: l_line_output1 := FND_MESSAGE.GET;
383: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING2');
384: l_line_output2 := FND_MESSAGE.GET;
385: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING3');
386: l_line_output3 := FND_MESSAGE.GET;
379: BEGIN
380: JG_UTILITY_PKG.log('> JG_ALLOCATE_JOURNALS_PKG.write_report_headings');
381: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING1');
382: l_line_output1 := FND_MESSAGE.GET;
383: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING2');
384: l_line_output2 := FND_MESSAGE.GET;
385: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING3');
386: l_line_output3 := FND_MESSAGE.GET;
387: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
380: JG_UTILITY_PKG.log('> JG_ALLOCATE_JOURNALS_PKG.write_report_headings');
381: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING1');
382: l_line_output1 := FND_MESSAGE.GET;
383: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING2');
384: l_line_output2 := FND_MESSAGE.GET;
385: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING3');
386: l_line_output3 := FND_MESSAGE.GET;
387: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
388: JG_UTILITY_PKG.out(l_line_output1);
381: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING1');
382: l_line_output1 := FND_MESSAGE.GET;
383: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING2');
384: l_line_output2 := FND_MESSAGE.GET;
385: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING3');
386: l_line_output3 := FND_MESSAGE.GET;
387: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
388: JG_UTILITY_PKG.out(l_line_output1);
389: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
382: l_line_output1 := FND_MESSAGE.GET;
383: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING2');
384: l_line_output2 := FND_MESSAGE.GET;
385: FND_MESSAGE.SET_NAME (JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name ,'JG_ZZ_JGZZTAJA_HEADING3');
386: l_line_output3 := FND_MESSAGE.GET;
387: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
388: JG_UTILITY_PKG.out(l_line_output1);
389: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
390: JG_UTILITY_PKG.out(l_line_output2);
488:
489: -- If the next line is for a new cc range and i<>1, then insert the line separator
490: IF i <> 1 THEN
491: IF JG_CREATE_JOURNALS_PKG.alloc_lines_arr(i).cc_range_id <> JG_CREATE_JOURNALS_PKG.alloc_lines_arr(i-1).cc_range_id THEN
492: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_CCRNGE_SEPRATOR');
493: l_cc_range_separator := FND_MESSAGE.get;
494: JG_UTILITY_PKG.out(RPAD(' ', 115)||l_cc_range_separator);
495: END IF;
496: END IF;
489: -- If the next line is for a new cc range and i<>1, then insert the line separator
490: IF i <> 1 THEN
491: IF JG_CREATE_JOURNALS_PKG.alloc_lines_arr(i).cc_range_id <> JG_CREATE_JOURNALS_PKG.alloc_lines_arr(i-1).cc_range_id THEN
492: FND_MESSAGE.set_name(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_CCRNGE_SEPRATOR');
493: l_cc_range_separator := FND_MESSAGE.get;
494: JG_UTILITY_PKG.out(RPAD(' ', 115)||l_cc_range_separator);
495: END IF;
496: END IF;
497:
529: -- Output appopriate message if no rows allocated
530: IF JG_CREATE_JOURNALS_PKG.i = 0 THEN
531: -- Bug 876171: Add a new line before the no-data-found token
532: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
533: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_NO_DATA_FOUND');
534: -- Bug 876171: Replace the following line with new lines
535: -- JG_UTILITY_PKG.out(FND_MESSAGE.GET);
536: l_no_data_message := FND_MESSAGE.GET;
537: JG_UTILITY_PKG.out(RPAD(' ', 75)||RPAD(l_no_data_message,30)||RPAD(' ', 75));
531: -- Bug 876171: Add a new line before the no-data-found token
532: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
533: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_NO_DATA_FOUND');
534: -- Bug 876171: Replace the following line with new lines
535: -- JG_UTILITY_PKG.out(FND_MESSAGE.GET);
536: l_no_data_message := FND_MESSAGE.GET;
537: JG_UTILITY_PKG.out(RPAD(' ', 75)||RPAD(l_no_data_message,30)||RPAD(' ', 75));
538: ELSE
539: --
532: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
533: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_NO_DATA_FOUND');
534: -- Bug 876171: Replace the following line with new lines
535: -- JG_UTILITY_PKG.out(FND_MESSAGE.GET);
536: l_no_data_message := FND_MESSAGE.GET;
537: JG_UTILITY_PKG.out(RPAD(' ', 75)||RPAD(l_no_data_message,30)||RPAD(' ', 75));
538: ELSE
539: --
540: -- Print totals
538: ELSE
539: --
540: -- Print totals
541: --
542: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_TOTAL_SEPARATOR');
543: l_total_separator := FND_MESSAGE.GET;
544: JG_UTILITY_PKG.out(l_total_separator);
545: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_TOTAL');
546: l_total_message := FND_MESSAGE.GET;
539: --
540: -- Print totals
541: --
542: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_TOTAL_SEPARATOR');
543: l_total_separator := FND_MESSAGE.GET;
544: JG_UTILITY_PKG.out(l_total_separator);
545: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_TOTAL');
546: l_total_message := FND_MESSAGE.GET;
547: JG_UTILITY_PKG.out(RPAD(' ', 41)||RPAD(l_total_message, 40)||
541: --
542: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_TOTAL_SEPARATOR');
543: l_total_separator := FND_MESSAGE.GET;
544: JG_UTILITY_PKG.out(l_total_separator);
545: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_TOTAL');
546: l_total_message := FND_MESSAGE.GET;
547: JG_UTILITY_PKG.out(RPAD(' ', 41)||RPAD(l_total_message, 40)||
548: LPAD(SUBSTR(NVL(TO_CHAR(lp_total_fiscal_accted_dr_amt,
549: JG_JOURNAL_ALLOCATIONS_PKG.G_func_currency_format_mask), ' '), 1, 15), 15)||' '||
542: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_TOTAL_SEPARATOR');
543: l_total_separator := FND_MESSAGE.GET;
544: JG_UTILITY_PKG.out(l_total_separator);
545: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_JGZZTAJA_TOTAL');
546: l_total_message := FND_MESSAGE.GET;
547: JG_UTILITY_PKG.out(RPAD(' ', 41)||RPAD(l_total_message, 40)||
548: LPAD(SUBSTR(NVL(TO_CHAR(lp_total_fiscal_accted_dr_amt,
549: JG_JOURNAL_ALLOCATIONS_PKG.G_func_currency_format_mask), ' '), 1, 15), 15)||' '||
550: LPAD(SUBSTR(NVL(TO_CHAR(lp_total_fiscal_accted_cr_amt,
1187:
1188: JG_UTILITY_PKG.debug('Invalid Journal Line found');
1189: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_Error_Handling <> 'I') THEN
1190: JG_JOURNAL_ALLOCATIONS_PKG.G_retcode := '1';
1191: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name,l_err_msg_code);
1192: JG_CREATE_JOURNALS_PKG.write_error_to_output;
1193:
1194: -- Bug 876171: Set up l_fail_ndf_flag for no-data-found token
1195: l_fail_ndf_flag :=1;
1293: -- Bug 876171: Add new lines to print no-data-found token
1294: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_unalloc_request_id IS NULL) THEN
1295: IF l_fail_ndf_flag = 0 THEN
1296: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
1297: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_NO_DATA_FOUND');
1298: l_no_data_found_message := FND_MESSAGE.GET;
1299: JG_UTILITY_PKG.out(RPAD(' ',75)||RPAD(l_no_data_found_message,30)||RPAD(' ',75));
1300: END IF;
1301: ELSE
1294: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_unalloc_request_id IS NULL) THEN
1295: IF l_fail_ndf_flag = 0 THEN
1296: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
1297: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_NO_DATA_FOUND');
1298: l_no_data_found_message := FND_MESSAGE.GET;
1299: JG_UTILITY_PKG.out(RPAD(' ',75)||RPAD(l_no_data_found_message,30)||RPAD(' ',75));
1300: END IF;
1301: ELSE
1302: IF l_unal_ndf_flag = 0 THEN
1300: END IF;
1301: ELSE
1302: IF l_unal_ndf_flag = 0 THEN
1303: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
1304: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_NO_DATA_FOUND');
1305: l_no_data_found_message := FND_MESSAGE.GET;
1306: JG_UTILITY_PKG.out(RPAD(' ',45)||RPAD(l_no_data_found_message,30)||RPAD(' ',105));
1307: END IF;
1308: END IF;
1301: ELSE
1302: IF l_unal_ndf_flag = 0 THEN
1303: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
1304: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_NO_DATA_FOUND');
1305: l_no_data_found_message := FND_MESSAGE.GET;
1306: JG_UTILITY_PKG.out(RPAD(' ',45)||RPAD(l_no_data_found_message,30)||RPAD(' ',105));
1307: END IF;
1308: END IF;
1309:
1329: -- Bug 876171: Add the following output lines for end-of-report token
1330: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_unalloc_request_id IS NULL) THEN
1331: IF JG_CREATE_JOURNALS_PKG.i > 0 OR l_fail_ndf_flag > 0 THEN
1332: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
1333: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_END_OF_REPORT');
1334: l_eof_message := FND_MESSAGE.GET;
1335: JG_UTILITY_PKG.out(RPAD(' ',75)||RPAD(l_eof_message,30)||RPAD(' ', 75));
1336: END IF;
1337: ELSE
1330: IF (JG_JOURNAL_ALLOCATIONS_PKG.G_unalloc_request_id IS NULL) THEN
1331: IF JG_CREATE_JOURNALS_PKG.i > 0 OR l_fail_ndf_flag > 0 THEN
1332: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
1333: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_END_OF_REPORT');
1334: l_eof_message := FND_MESSAGE.GET;
1335: JG_UTILITY_PKG.out(RPAD(' ',75)||RPAD(l_eof_message,30)||RPAD(' ', 75));
1336: END IF;
1337: ELSE
1338: IF l_unal_ndf_flag > 0 THEN
1336: END IF;
1337: ELSE
1338: IF l_unal_ndf_flag > 0 THEN
1339: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
1340: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_END_OF_REPORT');
1341: l_eof_message := FND_MESSAGE.GET;
1342: JG_UTILITY_PKG.out(RPAD(' ',45)||RPAD(l_eof_message,30)||RPAD(' ', 105));
1343: END IF;
1344: END IF;
1337: ELSE
1338: IF l_unal_ndf_flag > 0 THEN
1339: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,1);
1340: FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name, 'JG_ZZ_END_OF_REPORT');
1341: l_eof_message := FND_MESSAGE.GET;
1342: JG_UTILITY_PKG.out(RPAD(' ',45)||RPAD(l_eof_message,30)||RPAD(' ', 105));
1343: END IF;
1344: END IF;
1345: