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.BIS_COLLECTION_UTILITIES dependencies on FND_MESSAGE

Line 672: fnd_message.set_name('BIS','BIS_DBI_CURR_OUTPUT_HDR');

668: l_temp varchar2(1000) := null;
669: BEGIN
670:
671:
672: fnd_message.set_name('BIS','BIS_DBI_CURR_OUTPUT_HDR');
673: l_msg := fnd_message.get || l_newline;
674:
675:
676: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');

Line 673: l_msg := fnd_message.get || l_newline;

669: BEGIN
670:
671:
672: fnd_message.set_name('BIS','BIS_DBI_CURR_OUTPUT_HDR');
673: l_msg := fnd_message.get || l_newline;
674:
675:
676: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');
677: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );

Line 676: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');

672: fnd_message.set_name('BIS','BIS_DBI_CURR_OUTPUT_HDR');
673: l_msg := fnd_message.get || l_newline;
674:
675:
676: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');
677: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );
678: l_temp := l_temp|| substr(g_space, 1, g_length_rate_type - length(l_temp))||g_indenting;
679: l_msg := l_msg || l_temp;
680:

Line 677: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );

673: l_msg := fnd_message.get || l_newline;
674:
675:
676: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');
677: l_temp:=substr(fnd_message.get, 1,g_length_rate_type );
678: l_temp := l_temp|| substr(g_space, 1, g_length_rate_type - length(l_temp))||g_indenting;
679: l_msg := l_msg || l_temp;
680:
681:

Line 683: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');

679: l_msg := l_msg || l_temp;
680:
681:
682:
683: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');
684: l_temp := substr(fnd_message.get, 1, g_length_from_currency);
685: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
686: l_msg := l_msg || l_temp;
687:

Line 684: l_temp := substr(fnd_message.get, 1, g_length_from_currency);

680:
681:
682:
683: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');
684: l_temp := substr(fnd_message.get, 1, g_length_from_currency);
685: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
686: l_msg := l_msg || l_temp;
687:
688: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');

Line 688: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');

684: l_temp := substr(fnd_message.get, 1, g_length_from_currency);
685: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
686: l_msg := l_msg || l_temp;
687:
688: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');
689: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );
690: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
691: l_msg := l_msg || l_temp;
692:

Line 689: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );

685: l_temp := l_temp || substr(g_space, 1, g_length_from_currency - length(l_temp)) || g_indenting;
686: l_msg := l_msg || l_temp;
687:
688: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');
689: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );
690: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
691: l_msg := l_msg || l_temp;
692:
693: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');

Line 693: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');

689: l_temp:=substr(fnd_message.get, 1,g_length_to_currency );
690: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
691: l_msg := l_msg || l_temp;
692:
693: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');
694: l_temp:=substr(fnd_message.get, 1,g_length_date );
695: l_temp := l_temp || substr(g_space, 1, g_length_date - length(l_temp));
696: l_msg := l_msg || l_temp || l_newline;
697:

Line 694: l_temp:=substr(fnd_message.get, 1,g_length_date );

690: l_temp := l_temp || substr(g_space, 1, g_length_to_currency - length(l_temp)) || g_indenting;
691: l_msg := l_msg || l_temp;
692:
693: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');
694: l_temp:=substr(fnd_message.get, 1,g_length_date );
695: l_temp := l_temp || substr(g_space, 1, g_length_date - length(l_temp));
696: l_msg := l_msg || l_temp || l_newline;
697:
698: l_temp := substr(g_line, 1, g_length_rate_type)||g_indenting||

Line 763: fnd_message.set_name('BIS','BIS_DBI_CURR_OUTPUT_HDR');

759:
760: BEGIN
761:
762:
763: fnd_message.set_name('BIS','BIS_DBI_CURR_OUTPUT_HDR');
764: l_msg := fnd_message.get;
765: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
766: fnd_file.put_line(FND_FILE.OUTPUT, '');
767:

Line 764: l_msg := fnd_message.get;

760: BEGIN
761:
762:
763: fnd_message.set_name('BIS','BIS_DBI_CURR_OUTPUT_HDR');
764: l_msg := fnd_message.get;
765: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
766: fnd_file.put_line(FND_FILE.OUTPUT, '');
767:
768:

Line 769: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');

765: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
766: fnd_file.put_line(FND_FILE.OUTPUT, '');
767:
768:
769: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');
770: l_msg:=substr(fnd_message.get, 1,g_length_rate_type );
771: l_msg := l_msg|| substr(g_space, 1, g_length_rate_type - length(l_msg))||g_indenting;
772: fnd_file.put(FND_FILE.OUTPUT, l_msg);
773:

Line 770: l_msg:=substr(fnd_message.get, 1,g_length_rate_type );

766: fnd_file.put_line(FND_FILE.OUTPUT, '');
767:
768:
769: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');
770: l_msg:=substr(fnd_message.get, 1,g_length_rate_type );
771: l_msg := l_msg|| substr(g_space, 1, g_length_rate_type - length(l_msg))||g_indenting;
772: fnd_file.put(FND_FILE.OUTPUT, l_msg);
773:
774:

Line 776: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');

772: fnd_file.put(FND_FILE.OUTPUT, l_msg);
773:
774:
775:
776: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');
777: l_msg:=substr(fnd_message.get, 1, g_length_from_currency);
778: l_msg := l_msg || substr(g_space, 1, g_length_from_currency - length(l_msg)) || g_indenting;
779: fnd_file.put(FND_FILE.OUTPUT, l_msg);
780:

Line 777: l_msg:=substr(fnd_message.get, 1, g_length_from_currency);

773:
774:
775:
776: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');
777: l_msg:=substr(fnd_message.get, 1, g_length_from_currency);
778: l_msg := l_msg || substr(g_space, 1, g_length_from_currency - length(l_msg)) || g_indenting;
779: fnd_file.put(FND_FILE.OUTPUT, l_msg);
780:
781:

Line 782: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');

778: l_msg := l_msg || substr(g_space, 1, g_length_from_currency - length(l_msg)) || g_indenting;
779: fnd_file.put(FND_FILE.OUTPUT, l_msg);
780:
781:
782: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');
783: l_msg:=substr(fnd_message.get, 1,g_length_to_currency );
784: l_msg := l_msg || substr(g_space, 1, g_length_to_currency - length(l_msg)) || g_indenting;
785: fnd_file.put(FND_FILE.OUTPUT, l_msg);
786:

Line 783: l_msg:=substr(fnd_message.get, 1,g_length_to_currency );

779: fnd_file.put(FND_FILE.OUTPUT, l_msg);
780:
781:
782: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');
783: l_msg:=substr(fnd_message.get, 1,g_length_to_currency );
784: l_msg := l_msg || substr(g_space, 1, g_length_to_currency - length(l_msg)) || g_indenting;
785: fnd_file.put(FND_FILE.OUTPUT, l_msg);
786:
787:

Line 788: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');

784: l_msg := l_msg || substr(g_space, 1, g_length_to_currency - length(l_msg)) || g_indenting;
785: fnd_file.put(FND_FILE.OUTPUT, l_msg);
786:
787:
788: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');
789: l_msg:=substr(fnd_message.get, 1,g_length_date );
790: l_msg := l_msg || substr(g_space, 1, g_length_date - length(l_msg));
791: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
792:

Line 789: l_msg:=substr(fnd_message.get, 1,g_length_date );

785: fnd_file.put(FND_FILE.OUTPUT, l_msg);
786:
787:
788: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');
789: l_msg:=substr(fnd_message.get, 1,g_length_date );
790: l_msg := l_msg || substr(g_space, 1, g_length_date - length(l_msg));
791: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
792:
793:

Line 889: fnd_message.set_name('BIS','BIS_DBI_UOM_OUTPUT_HDR');

885: IS
886: l_msg varchar2(3000):=null;
887: BEGIN
888:
889: fnd_message.set_name('BIS','BIS_DBI_UOM_OUTPUT_HDR');
890: l_msg := fnd_message.get;
891: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
892: fnd_file.put_line(FND_FILE.OUTPUT, '');
893:

Line 890: l_msg := fnd_message.get;

886: l_msg varchar2(3000):=null;
887: BEGIN
888:
889: fnd_message.set_name('BIS','BIS_DBI_UOM_OUTPUT_HDR');
890: l_msg := fnd_message.get;
891: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
892: fnd_file.put_line(FND_FILE.OUTPUT, '');
893:
894: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_UOM');

Line 894: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_UOM');

890: l_msg := fnd_message.get;
891: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
892: fnd_file.put_line(FND_FILE.OUTPUT, '');
893:
894: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_UOM');
895: l_msg:=substr(fnd_message.get, 1, g_length_from_to_uom);
896: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
897: fnd_file.put(FND_FILE.OUTPUT, l_msg);
898:

Line 895: l_msg:=substr(fnd_message.get, 1, g_length_from_to_uom);

891: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
892: fnd_file.put_line(FND_FILE.OUTPUT, '');
893:
894: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_UOM');
895: l_msg:=substr(fnd_message.get, 1, g_length_from_to_uom);
896: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
897: fnd_file.put(FND_FILE.OUTPUT, l_msg);
898:
899: fnd_message.set_name('BIS','BIS_DBI_COL_TO_UOM');

Line 899: fnd_message.set_name('BIS','BIS_DBI_COL_TO_UOM');

895: l_msg:=substr(fnd_message.get, 1, g_length_from_to_uom);
896: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
897: fnd_file.put(FND_FILE.OUTPUT, l_msg);
898:
899: fnd_message.set_name('BIS','BIS_DBI_COL_TO_UOM');
900: l_msg:=substr(fnd_message.get, 1,g_length_from_to_uom);
901: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
902: fnd_file.put(FND_FILE.OUTPUT, l_msg);
903:

Line 900: l_msg:=substr(fnd_message.get, 1,g_length_from_to_uom);

896: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
897: fnd_file.put(FND_FILE.OUTPUT, l_msg);
898:
899: fnd_message.set_name('BIS','BIS_DBI_COL_TO_UOM');
900: l_msg:=substr(fnd_message.get, 1,g_length_from_to_uom);
901: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
902: fnd_file.put(FND_FILE.OUTPUT, l_msg);
903:
904: fnd_message.set_name('BIS','BIS_DBI_COL_INVENTORY_ITEM');

Line 904: fnd_message.set_name('BIS','BIS_DBI_COL_INVENTORY_ITEM');

900: l_msg:=substr(fnd_message.get, 1,g_length_from_to_uom);
901: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
902: fnd_file.put(FND_FILE.OUTPUT, l_msg);
903:
904: fnd_message.set_name('BIS','BIS_DBI_COL_INVENTORY_ITEM');
905: l_msg:=substr(fnd_message.get, 1, g_length_inventory_item );
906: l_msg := l_msg || substr(g_space, 1, g_length_inventory_item - length(l_msg));
907: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
908:

Line 905: l_msg:=substr(fnd_message.get, 1, g_length_inventory_item );

901: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
902: fnd_file.put(FND_FILE.OUTPUT, l_msg);
903:
904: fnd_message.set_name('BIS','BIS_DBI_COL_INVENTORY_ITEM');
905: l_msg:=substr(fnd_message.get, 1, g_length_inventory_item );
906: l_msg := l_msg || substr(g_space, 1, g_length_inventory_item - length(l_msg));
907: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
908:
909: l_msg := substr(g_line, 1, g_length_from_to_uom)||g_indenting||

Line 953: fnd_message.set_name('BIS','BIS_DBI_CONTRACT_OUTPUT_HDR');

949: l_msg varchar2(3000):=null;
950: l_tmp varchar2(300):= null;
951: BEGIN
952:
953: fnd_message.set_name('BIS','BIS_DBI_CONTRACT_OUTPUT_HDR');
954: l_msg := fnd_message.get;
955: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
956: fnd_file.put_line(FND_FILE.OUTPUT, '');
957:

Line 954: l_msg := fnd_message.get;

950: l_tmp varchar2(300):= null;
951: BEGIN
952:
953: fnd_message.set_name('BIS','BIS_DBI_CONTRACT_OUTPUT_HDR');
954: l_msg := fnd_message.get;
955: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
956: fnd_file.put_line(FND_FILE.OUTPUT, '');
957:
958: l_msg := '';

Line 959: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_NO');

955: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
956: fnd_file.put_line(FND_FILE.OUTPUT, '');
957:
958: l_msg := '';
959: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_NO');
960: l_tmp:=substr(fnd_message.get, 1, g_length_contract_no);
961: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_contract_no - length(l_tmp)) || g_indenting;
962:
963: fnd_message.set_name('BIS','BIS_DBI_COL_STATUS');

Line 960: l_tmp:=substr(fnd_message.get, 1, g_length_contract_no);

956: fnd_file.put_line(FND_FILE.OUTPUT, '');
957:
958: l_msg := '';
959: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_NO');
960: l_tmp:=substr(fnd_message.get, 1, g_length_contract_no);
961: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_contract_no - length(l_tmp)) || g_indenting;
962:
963: fnd_message.set_name('BIS','BIS_DBI_COL_STATUS');
964: l_tmp:=substr(fnd_message.get, 1, g_length_status);

Line 963: fnd_message.set_name('BIS','BIS_DBI_COL_STATUS');

959: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_NO');
960: l_tmp:=substr(fnd_message.get, 1, g_length_contract_no);
961: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_contract_no - length(l_tmp)) || g_indenting;
962:
963: fnd_message.set_name('BIS','BIS_DBI_COL_STATUS');
964: l_tmp:=substr(fnd_message.get, 1, g_length_status);
965: l_msg := l_msg || l_tmp||substr(g_space, 1, g_length_status - length(l_tmp)) || g_indenting;
966:
967: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');

Line 964: l_tmp:=substr(fnd_message.get, 1, g_length_status);

960: l_tmp:=substr(fnd_message.get, 1, g_length_contract_no);
961: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_contract_no - length(l_tmp)) || g_indenting;
962:
963: fnd_message.set_name('BIS','BIS_DBI_COL_STATUS');
964: l_tmp:=substr(fnd_message.get, 1, g_length_status);
965: l_msg := l_msg || l_tmp||substr(g_space, 1, g_length_status - length(l_tmp)) || g_indenting;
966:
967: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');
968: l_tmp:=substr(fnd_message.get, 1,g_length_rate_type );

Line 967: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');

963: fnd_message.set_name('BIS','BIS_DBI_COL_STATUS');
964: l_tmp:=substr(fnd_message.get, 1, g_length_status);
965: l_msg := l_msg || l_tmp||substr(g_space, 1, g_length_status - length(l_tmp)) || g_indenting;
966:
967: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');
968: l_tmp:=substr(fnd_message.get, 1,g_length_rate_type );
969: l_msg := l_msg|| l_tmp||substr(g_space, 1, g_length_rate_type - length(l_tmp))||g_indenting;
970:
971:

Line 968: l_tmp:=substr(fnd_message.get, 1,g_length_rate_type );

964: l_tmp:=substr(fnd_message.get, 1, g_length_status);
965: l_msg := l_msg || l_tmp||substr(g_space, 1, g_length_status - length(l_tmp)) || g_indenting;
966:
967: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');
968: l_tmp:=substr(fnd_message.get, 1,g_length_rate_type );
969: l_msg := l_msg|| l_tmp||substr(g_space, 1, g_length_rate_type - length(l_tmp))||g_indenting;
970:
971:
972: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');

Line 972: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');

968: l_tmp:=substr(fnd_message.get, 1,g_length_rate_type );
969: l_msg := l_msg|| l_tmp||substr(g_space, 1, g_length_rate_type - length(l_tmp))||g_indenting;
970:
971:
972: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');
973: l_tmp:=substr(fnd_message.get, 1, g_length_from_currency);
974: l_msg := l_msg || l_tmp||substr(g_space, 1, g_length_from_currency - length(l_tmp)) || g_indenting;
975:
976: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');

Line 973: l_tmp:=substr(fnd_message.get, 1, g_length_from_currency);

969: l_msg := l_msg|| l_tmp||substr(g_space, 1, g_length_rate_type - length(l_tmp))||g_indenting;
970:
971:
972: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');
973: l_tmp:=substr(fnd_message.get, 1, g_length_from_currency);
974: l_msg := l_msg || l_tmp||substr(g_space, 1, g_length_from_currency - length(l_tmp)) || g_indenting;
975:
976: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');
977: l_tmp:=substr(fnd_message.get, 1,g_length_to_currency );

Line 976: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');

972: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');
973: l_tmp:=substr(fnd_message.get, 1, g_length_from_currency);
974: l_msg := l_msg || l_tmp||substr(g_space, 1, g_length_from_currency - length(l_tmp)) || g_indenting;
975:
976: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');
977: l_tmp:=substr(fnd_message.get, 1,g_length_to_currency );
978: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_to_currency - length(l_tmp)) || g_indenting;
979:
980: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');

Line 977: l_tmp:=substr(fnd_message.get, 1,g_length_to_currency );

973: l_tmp:=substr(fnd_message.get, 1, g_length_from_currency);
974: l_msg := l_msg || l_tmp||substr(g_space, 1, g_length_from_currency - length(l_tmp)) || g_indenting;
975:
976: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');
977: l_tmp:=substr(fnd_message.get, 1,g_length_to_currency );
978: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_to_currency - length(l_tmp)) || g_indenting;
979:
980: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');
981: l_tmp:=substr(fnd_message.get, 1,g_length_date );

Line 980: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');

976: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');
977: l_tmp:=substr(fnd_message.get, 1,g_length_to_currency );
978: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_to_currency - length(l_tmp)) || g_indenting;
979:
980: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');
981: l_tmp:=substr(fnd_message.get, 1,g_length_date );
982: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_date - length(l_tmp)) || g_indenting;
983:
984: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_ID');

Line 981: l_tmp:=substr(fnd_message.get, 1,g_length_date );

977: l_tmp:=substr(fnd_message.get, 1,g_length_to_currency );
978: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_to_currency - length(l_tmp)) || g_indenting;
979:
980: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');
981: l_tmp:=substr(fnd_message.get, 1,g_length_date );
982: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_date - length(l_tmp)) || g_indenting;
983:
984: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_ID');
985: l_tmp:=substr(fnd_message.get, 1,g_length_contract_id );

Line 984: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_ID');

980: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');
981: l_tmp:=substr(fnd_message.get, 1,g_length_date );
982: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_date - length(l_tmp)) || g_indenting;
983:
984: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_ID');
985: l_tmp:=substr(fnd_message.get, 1,g_length_contract_id );
986: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_contract_id - length(l_tmp));
987:
988: ---fnd_file.put_line(fnd_file.LOG, 'L_MSG IS : '||l_msg);

Line 985: l_tmp:=substr(fnd_message.get, 1,g_length_contract_id );

981: l_tmp:=substr(fnd_message.get, 1,g_length_date );
982: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_date - length(l_tmp)) || g_indenting;
983:
984: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_ID');
985: l_tmp:=substr(fnd_message.get, 1,g_length_contract_id );
986: l_msg := l_msg ||l_tmp|| substr(g_space, 1, g_length_contract_id - length(l_tmp));
987:
988: ---fnd_file.put_line(fnd_file.LOG, 'L_MSG IS : '||l_msg);
989: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

Line 1092: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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
1093: fnd_message.set_token('ERRNO' ,SQLCODE);
1094: fnd_message.set_token('REASON', SQLERRM);
1095: fnd_message.set_token('ROUTINE', l_proc);
1096: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);

Line 1093: fnd_message.set_token('ERRNO' ,SQLCODE);

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
1093: fnd_message.set_token('ERRNO' ,SQLCODE);
1094: fnd_message.set_token('REASON', SQLERRM);
1095: fnd_message.set_token('ROUTINE', l_proc);
1096: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);
1097: RAISE;

Line 1094: fnd_message.set_token('REASON', SQLERRM);

1090: Exception WHEN OTHERS THEN
1091: /*Generic Exception Handling block.*/
1092: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1093: fnd_message.set_token('ERRNO' ,SQLCODE);
1094: fnd_message.set_token('REASON', SQLERRM);
1095: fnd_message.set_token('ROUTINE', l_proc);
1096: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);
1097: RAISE;
1098: end get_last_failure_period;

Line 1095: fnd_message.set_token('ROUTINE', l_proc);

1091: /*Generic Exception Handling block.*/
1092: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1093: fnd_message.set_token('ERRNO' ,SQLCODE);
1094: fnd_message.set_token('REASON', SQLERRM);
1095: fnd_message.set_token('ROUTINE', l_proc);
1096: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);
1097: RAISE;
1098: end get_last_failure_period;
1099:

Line 1096: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);

1092: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1093: fnd_message.set_token('ERRNO' ,SQLCODE);
1094: fnd_message.set_token('REASON', SQLERRM);
1095: fnd_message.set_token('ROUTINE', l_proc);
1096: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);
1097: RAISE;
1098: end get_last_failure_period;
1099:
1100: /*

Line 1136: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message

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);
1138: fnd_message.set_token('REASON', SQLERRM);
1139: fnd_message.set_token('ROUTINE', l_proc);
1140: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);

Line 1137: fnd_message.set_token('ERRNO' ,SQLCODE);

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);
1138: fnd_message.set_token('REASON', SQLERRM);
1139: fnd_message.set_token('ROUTINE', l_proc);
1140: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);
1141: RAISE;

Line 1138: fnd_message.set_token('REASON', SQLERRM);

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);
1138: fnd_message.set_token('REASON', SQLERRM);
1139: fnd_message.set_token('ROUTINE', l_proc);
1140: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);
1141: RAISE;
1142: end get_last_failure_period;

Line 1139: fnd_message.set_token('ROUTINE', l_proc);

1135: /*Generic Exception Handling block.*/
1136: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1137: fnd_message.set_token('ERRNO' ,SQLCODE);
1138: fnd_message.set_token('REASON', SQLERRM);
1139: fnd_message.set_token('ROUTINE', l_proc);
1140: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);
1141: RAISE;
1142: end get_last_failure_period;
1143:

Line 1140: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);

1136: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
1137: fnd_message.set_token('ERRNO' ,SQLCODE);
1138: fnd_message.set_token('REASON', SQLERRM);
1139: fnd_message.set_token('ROUTINE', l_proc);
1140: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);
1141: RAISE;
1142: end get_last_failure_period;
1143:
1144: END BIS_COLLECTION_UTILITIES;