1264:
1265: --R12 Uptake on new messages (VKAZHIPU)
1266:
1267: if (l_day_left = 1) then
1268: fnd_message.set_name('FII', 'FII_DATE_LABEL');
1269: else
1270: fnd_message.set_name('FII', 'FII_DATE_LABEL_PLURAL');
1271: end if;
1272:
1266:
1267: if (l_day_left = 1) then
1268: fnd_message.set_name('FII', 'FII_DATE_LABEL');
1269: else
1270: fnd_message.set_name('FII', 'FII_DATE_LABEL_PLURAL');
1271: end if;
1272:
1273: fnd_message.set_token('DAYS',l_day_left,FALSE);
1274: fnd_message.set_token('QUARTER_NUMBER',l_qtr,FALSE);
1269: else
1270: fnd_message.set_name('FII', 'FII_DATE_LABEL_PLURAL');
1271: end if;
1272:
1273: fnd_message.set_token('DAYS',l_day_left,FALSE);
1274: fnd_message.set_token('QUARTER_NUMBER',l_qtr,FALSE);
1275: fnd_message.set_token('YEAR_NUMBER',l_yr,FALSE);
1276: l_label := fnd_message.get;
1277:
1270: fnd_message.set_name('FII', 'FII_DATE_LABEL_PLURAL');
1271: end if;
1272:
1273: fnd_message.set_token('DAYS',l_day_left,FALSE);
1274: fnd_message.set_token('QUARTER_NUMBER',l_qtr,FALSE);
1275: fnd_message.set_token('YEAR_NUMBER',l_yr,FALSE);
1276: l_label := fnd_message.get;
1277:
1278: return l_label;
1271: end if;
1272:
1273: fnd_message.set_token('DAYS',l_day_left,FALSE);
1274: fnd_message.set_token('QUARTER_NUMBER',l_qtr,FALSE);
1275: fnd_message.set_token('YEAR_NUMBER',l_yr,FALSE);
1276: l_label := fnd_message.get;
1277:
1278: return l_label;
1279: end;
1272:
1273: fnd_message.set_token('DAYS',l_day_left,FALSE);
1274: fnd_message.set_token('QUARTER_NUMBER',l_qtr,FALSE);
1275: fnd_message.set_token('YEAR_NUMBER',l_yr,FALSE);
1276: l_label := fnd_message.get;
1277:
1278: return l_label;
1279: end;
1280:
1335: begin
1336: l_from_date := trunc(p_from_date);
1337: l_to_date := trunc(p_to_date);
1338:
1339: fnd_message.set_name('FII','FII_DBI_CHECK_TIME_GAPS');
1340: fnd_message.set_token('FROM_DATE', fnd_date.date_to_displayDT(l_from_date));
1341: fnd_message.set_token('TO_DATE', fnd_date.date_to_displayDT(l_to_date));
1342: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1343: fnd_file.put_line(FND_FILE.OUTPUT, '');
1336: l_from_date := trunc(p_from_date);
1337: l_to_date := trunc(p_to_date);
1338:
1339: fnd_message.set_name('FII','FII_DBI_CHECK_TIME_GAPS');
1340: fnd_message.set_token('FROM_DATE', fnd_date.date_to_displayDT(l_from_date));
1341: fnd_message.set_token('TO_DATE', fnd_date.date_to_displayDT(l_to_date));
1342: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1343: fnd_file.put_line(FND_FILE.OUTPUT, '');
1344:
1337: l_to_date := trunc(p_to_date);
1338:
1339: fnd_message.set_name('FII','FII_DBI_CHECK_TIME_GAPS');
1340: fnd_message.set_token('FROM_DATE', fnd_date.date_to_displayDT(l_from_date));
1341: fnd_message.set_token('TO_DATE', fnd_date.date_to_displayDT(l_to_date));
1342: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1343: fnd_file.put_line(FND_FILE.OUTPUT, '');
1344:
1345: -- handle NULL dates input
1338:
1339: fnd_message.set_name('FII','FII_DBI_CHECK_TIME_GAPS');
1340: fnd_message.set_token('FROM_DATE', fnd_date.date_to_displayDT(l_from_date));
1341: fnd_message.set_token('TO_DATE', fnd_date.date_to_displayDT(l_to_date));
1342: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1343: fnd_file.put_line(FND_FILE.OUTPUT, '');
1344:
1345: -- handle NULL dates input
1346: if (p_from_date is NULL) then
1380: end loop;
1381:
1382: p_has_missing_date := l_has_missing_date;
1383: if p_has_missing_date then
1384: fnd_message.set_name('FII','FII_DBI_TIME_HAS_GAPS');
1385: fnd_message.set_token('FROM_DATE',
1386: fnd_date.date_to_displayDT(l_min_missing_date));
1387: fnd_message.set_token('TO_DATE',
1388: fnd_date.date_to_displayDT(l_max_missing_date));
1381:
1382: p_has_missing_date := l_has_missing_date;
1383: if p_has_missing_date then
1384: fnd_message.set_name('FII','FII_DBI_TIME_HAS_GAPS');
1385: fnd_message.set_token('FROM_DATE',
1386: fnd_date.date_to_displayDT(l_min_missing_date));
1387: fnd_message.set_token('TO_DATE',
1388: fnd_date.date_to_displayDT(l_max_missing_date));
1389: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1383: if p_has_missing_date then
1384: fnd_message.set_name('FII','FII_DBI_TIME_HAS_GAPS');
1385: fnd_message.set_token('FROM_DATE',
1386: fnd_date.date_to_displayDT(l_min_missing_date));
1387: fnd_message.set_token('TO_DATE',
1388: fnd_date.date_to_displayDT(l_max_missing_date));
1389: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1390: fnd_file.put_line(FND_FILE.OUTPUT, '');
1391: else
1385: fnd_message.set_token('FROM_DATE',
1386: fnd_date.date_to_displayDT(l_min_missing_date));
1387: fnd_message.set_token('TO_DATE',
1388: fnd_date.date_to_displayDT(l_max_missing_date));
1389: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1390: fnd_file.put_line(FND_FILE.OUTPUT, '');
1391: else
1392: fnd_message.set_name('FII','FII_DBI_NO_TIME_GAPS');
1393: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1388: fnd_date.date_to_displayDT(l_max_missing_date));
1389: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1390: fnd_file.put_line(FND_FILE.OUTPUT, '');
1391: else
1392: fnd_message.set_name('FII','FII_DBI_NO_TIME_GAPS');
1393: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1394: fnd_file.put_line(FND_FILE.OUTPUT, '');
1395: end if;
1396:
1389: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1390: fnd_file.put_line(FND_FILE.OUTPUT, '');
1391: else
1392: fnd_message.set_name('FII','FII_DBI_NO_TIME_GAPS');
1393: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1394: fnd_file.put_line(FND_FILE.OUTPUT, '');
1395: end if;
1396:
1397: exception