DBA Data[Home] [Help]

APPS.ISC_DBI_BSA_OBJECTS_C dependencies on FND_MESSAGE

Line 288: bis_collection_utilities.put_line(fnd_message.get_string('BIS', 'BIS_DBI_CURR_NO_LOAD'));

284: fetch missing_currency_conversion into l_record;
285:
286: if missing_currency_conversion%rowcount <> 0 then
287: bis_collection_utilities.put_line('Collection failed because there are missing currency conversion rates.');
288: bis_collection_utilities.put_line(fnd_message.get_string('BIS', 'BIS_DBI_CURR_NO_LOAD'));
289:
290: bis_collection_utilities.writeMissingRateHeader;
291: while missing_currency_conversion%found loop
292: l_total := l_total + 1;

Line 395: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));

391: from fii_time_day;
392:
393: open lines_missing_date;
394: fetch lines_missing_date into l_line;
395: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
396: bis_collection_utilities.put_line_out(' ');
397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')

Line 397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')

393: open lines_missing_date;
394: fetch lines_missing_date into l_line;
395: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
396: bis_collection_utilities.put_line_out(' ');
397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
401: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')

Line 398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')

394: fetch lines_missing_date into l_line;
395: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
396: bis_collection_utilities.put_line_out(' ');
397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
401: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
402: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')

Line 399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')

395: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
396: bis_collection_utilities.put_line_out(' ');
397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
401: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
402: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
403: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));

Line 400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')

396: bis_collection_utilities.put_line_out(' ');
397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
401: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
402: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
403: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
404: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');

Line 401: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')

397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
401: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
402: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
403: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
404: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');
405:

Line 402: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')

398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
401: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
402: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
403: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
404: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');
405:
406: while lines_missing_date%found loop

Line 403: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));

399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
401: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
402: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
403: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
404: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');
405:
406: while lines_missing_date%found loop
407: bis_collection_utilities.put_line_out(rpad(l_line.order_number,18,' ')

Line 1050: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));

1046: from fii_time_day;
1047:
1048: open lines_missing_date;
1049: fetch lines_missing_date into l_line;
1050: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
1051: bis_collection_utilities.put_line_out(' ');
1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')

Line 1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')

1048: open lines_missing_date;
1049: fetch lines_missing_date into l_line;
1050: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
1051: bis_collection_utilities.put_line_out(' ');
1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
1056: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')

Line 1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')

1049: fetch lines_missing_date into l_line;
1050: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
1051: bis_collection_utilities.put_line_out(' ');
1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
1056: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
1057: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')

Line 1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')

1050: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
1051: bis_collection_utilities.put_line_out(' ');
1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
1056: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
1057: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
1058: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));

Line 1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')

1051: bis_collection_utilities.put_line_out(' ');
1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
1056: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
1057: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
1058: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
1059: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');

Line 1056: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')

1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
1056: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
1057: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
1058: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
1059: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');
1060:

Line 1057: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')

1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
1056: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
1057: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
1058: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
1059: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');
1060:
1061: while lines_missing_date%found loop

Line 1058: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));

1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
1056: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
1057: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
1058: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
1059: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');
1060:
1061: while lines_missing_date%found loop
1062: bis_collection_utilities.put_line_out(rpad(l_line.order_number,18,' ')