DBA Data[Home] [Help]

APPS.BIS_COLLECTION_UTILITIES dependencies on FND_DATE

Line 357: l_date_disp := fnd_date.date_to_displaydt (l_date);

353: IF (l_date IS NULL) THEN
354: l_date:= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'), 'mm/dd/yyyy');
355: END IF;
356:
357: l_date_disp := fnd_date.date_to_displaydt (l_date);
358: return l_date_disp;
359:
360: Exception
361: WHEN OTHERS THEN

Line 743: l_temp:=substr(fnd_date.date_to_displayDT(p_date), 1,g_length_date );

739: l_msg := l_msg ||l_temp;
740:
741:
742: IF (p_date_override IS NULL) THEN
743: l_temp:=substr(fnd_date.date_to_displayDT(p_date), 1,g_length_date );
744: ELSE
745: l_temp := substr(p_date_override, 1,g_length_date );
746: END IF;
747:

Line 840: l_msg:=substr(fnd_date.date_to_displayDT(p_date), 1,g_length_date );

836: fnd_file.put(FND_FILE.OUTPUT, l_msg);
837:
838:
839: IF (p_date_override IS NULL) THEN
840: l_msg:=substr(fnd_date.date_to_displayDT(p_date), 1,g_length_date );
841: ELSE
842: l_msg := substr(p_date_override, 1,g_length_date );
843: END IF;
844:

Line 1054: l_msg:=substr(fnd_date.date_to_displayDT(p_date), 1,g_length_date );

1050: fnd_file.put(FND_FILE.OUTPUT, l_msg);
1051:
1052:
1053: IF (p_date_override IS NULL) THEN
1054: l_msg:=substr(fnd_date.date_to_displayDT(p_date), 1,g_length_date );
1055: ELSE
1056: l_msg := substr(p_date_override, 1,g_length_date );
1057: END IF;
1058:

Line 1088: l_date_disp := fnd_date.date_to_displaydt (l_date);

1084: status='FAILURE' ) ;
1085: IF (l_date IS NULL) THEN
1086: l_date:= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'), 'mm/dd/yyyy');
1087: END IF;
1088: l_date_disp := fnd_date.date_to_displaydt (l_date);
1089: return l_date_disp;
1090: Exception WHEN OTHERS THEN
1091: /*Generic Exception Handling block.*/
1092: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

Line 1132: p_period_to := fnd_date.date_to_displaydt (l_date_to);

1128: END IF;
1129: IF (l_date_from IS NULL) THEN
1130: l_date_from:= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'), 'mm/dd/yyyy');
1131: END IF;
1132: p_period_to := fnd_date.date_to_displaydt (l_date_to);
1133: p_period_from := fnd_date.date_to_displaydt (l_date_from);
1134: Exception WHEN OTHERS THEN
1135: /*Generic Exception Handling block.*/
1136: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

Line 1133: p_period_from := fnd_date.date_to_displaydt (l_date_from);

1129: IF (l_date_from IS NULL) THEN
1130: l_date_from:= to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'), 'mm/dd/yyyy');
1131: END IF;
1132: p_period_to := fnd_date.date_to_displaydt (l_date_to);
1133: p_period_from := fnd_date.date_to_displaydt (l_date_from);
1134: Exception WHEN OTHERS THEN
1135: /*Generic Exception Handling block.*/
1136: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1137: fnd_message.set_token('ERRNO' ,SQLCODE);