DBA Data[Home] [Help]

APPS.BIS_COLLECTION_UTILITIES dependencies on FND_FILE

Line 296: -- FND_FILE.RELEASE_NAMES(g_object_name||'.log', g_object_name||'.out');

292: p_attribute9,
293: p_attribute10);
294: -- Bug#5400214 :: This API is not required as FND takes care of the Log/Output file
295: -- names on its own; plus these apis causes the same name to be re-used
296: -- FND_FILE.RELEASE_NAMES(g_object_name||'.log', g_object_name||'.out');
297: commit;
298:
299:
300: ---The following code is added for KPI end to end support

Line 525: FND_FILE.PUT_NAMES(p_log_file, p_out_file, l_dir);

521: -- Need to add a call to getUtlFileDir as this is a public API and
522: -- teams may call this directly with invalid directories
523:
524: l_dir := getUtlFileDir;
525: FND_FILE.PUT_NAMES(p_log_file, p_out_file, l_dir);
526:
527: END put_names;
528:
529: /*

Line 571: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(p_text, l_start, 250));

567: if l_end >= l_len then
568: l_end:=l_len;
569: last_reached:=true;
570: end if;
571: FND_FILE.PUT_LINE(FND_FILE.LOG,substr(p_text, l_start, 250));
572: l_start:=l_start+250;
573: if last_reached then
574: exit;
575: end if;

Line 636: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,substr(p_text, l_start, 250));

632: if l_end >= l_len then
633: l_end:=l_len;
634: last_reached:=true;
635: end if;
636: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,substr(p_text, l_start, 250));
637: l_start:=l_start+250;
638: if last_reached then
639: exit;
640: end if;

Line 765: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

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:
769: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');

Line 766: fnd_file.put_line(FND_FILE.OUTPUT, '');

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:
769: fnd_message.set_name('BIS','BIS_DBI_COL_RATE_TYPE');
770: l_msg:=substr(fnd_message.get, 1,g_length_rate_type );

Line 772: fnd_file.put(FND_FILE.OUTPUT, l_msg);

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:
775:
776: fnd_message.set_name('BIS','BIS_DBI_COL_FROM_CURRENCY');

Line 779: fnd_file.put(FND_FILE.OUTPUT, l_msg);

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:
782: fnd_message.set_name('BIS','BIS_DBI_COL_TO_CURRENCY');
783: l_msg:=substr(fnd_message.get, 1,g_length_to_currency );

Line 785: fnd_file.put(FND_FILE.OUTPUT, l_msg);

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:
788: fnd_message.set_name('BIS','BIS_DBI_COL_DATE');
789: l_msg:=substr(fnd_message.get, 1,g_length_date );

Line 791: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

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:
794: /*fnd_file.put_line(FND_FILE.OUTPUT,
795: '------------'||g_indenting ||'-----------------'||g_indenting||

Line 794: /*fnd_file.put_line(FND_FILE.OUTPUT,

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:
794: /*fnd_file.put_line(FND_FILE.OUTPUT,
795: '------------'||g_indenting ||'-----------------'||g_indenting||
796: '---------------'||g_indenting||'-------------');
797: */
798: l_msg := substr(g_line, 1, g_length_rate_type)||g_indenting||

Line 803: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

799: substr(g_line, 1, g_length_from_currency)||g_indenting||
800: substr(g_line, 1, g_length_to_currency)||g_indenting||
801: substr(g_line, 1, g_length_date);
802:
803: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
804:
805:
806: END;
807:

Line 826: fnd_file.put(FND_FILE.OUTPUT, l_msg);

822: l_user_rate_type:=get_user_rate_type(p_rate_type);
823: ----l_msg:=substr(p_rate_type, 1,g_length_rate_type );
824: l_msg:=substr(l_user_rate_type, 1,g_length_rate_type );
825: l_msg := l_msg || substr(g_space, 1, g_length_rate_type - length(l_msg))|| g_indenting;
826: fnd_file.put(FND_FILE.OUTPUT, l_msg);
827:
828:
829: l_msg:=substr(p_from_currency, 1, g_length_from_currency);
830: l_msg := l_msg || substr(g_space, 1, g_length_from_currency - length(l_msg)) || g_indenting;

Line 831: fnd_file.put(FND_FILE.OUTPUT, l_msg);

827:
828:
829: l_msg:=substr(p_from_currency, 1, g_length_from_currency);
830: l_msg := l_msg || substr(g_space, 1, g_length_from_currency - length(l_msg)) || g_indenting;
831: fnd_file.put(FND_FILE.OUTPUT, l_msg);
832:
833:
834: l_msg:=substr(p_to_currency, 1,g_length_to_currency );
835: l_msg := l_msg || substr(g_space, 1, g_length_to_currency - length(l_msg)) || g_indenting;

Line 836: fnd_file.put(FND_FILE.OUTPUT, l_msg);

832:
833:
834: l_msg:=substr(p_to_currency, 1,g_length_to_currency );
835: l_msg := l_msg || substr(g_space, 1, g_length_to_currency - length(l_msg)) || g_indenting;
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 );

Line 846: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

842: l_msg := substr(p_date_override, 1,g_length_date );
843: END IF;
844:
845: l_msg := l_msg || substr(g_space, 1, g_length_date - length(l_msg)) || g_indenting;
846: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
847:
848:
849: END;
850:

Line 891: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

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');
895: l_msg:=substr(fnd_message.get, 1, g_length_from_to_uom);

Line 892: fnd_file.put_line(FND_FILE.OUTPUT, '');

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');
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;

Line 897: fnd_file.put(FND_FILE.OUTPUT, l_msg);

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');
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;

Line 902: 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');
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));

Line 907: fnd_file.put_line(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||
910: substr(g_line, 1, g_length_from_to_uom)||g_indenting||
911: substr(g_line, 1, g_length_inventory_item);

Line 913: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

909: l_msg := substr(g_line, 1, g_length_from_to_uom)||g_indenting||
910: substr(g_line, 1, g_length_from_to_uom)||g_indenting||
911: substr(g_line, 1, g_length_inventory_item);
912:
913: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
914: END;
915:
916: /*
917: From UOM To UOM Inventory Item

Line 933: fnd_file.put(FND_FILE.OUTPUT, l_msg);

929: l_msg varchar2(1000) := null;
930: BEGIN
931: l_msg:=substr(p_from_uom, 1, g_length_from_to_uom);
932: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
933: fnd_file.put(FND_FILE.OUTPUT, l_msg);
934:
935: l_msg:=substr(p_to_uom, 1,g_length_from_to_uom );
936: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
937: fnd_file.put(FND_FILE.OUTPUT, l_msg);

Line 937: fnd_file.put(FND_FILE.OUTPUT, l_msg);

933: fnd_file.put(FND_FILE.OUTPUT, l_msg);
934:
935: l_msg:=substr(p_to_uom, 1,g_length_from_to_uom );
936: l_msg := l_msg || substr(g_space, 1, g_length_from_to_uom - length(l_msg)) || g_indenting;
937: fnd_file.put(FND_FILE.OUTPUT, l_msg);
938:
939: l_msg := substr(p_inventory_item, 1,g_length_inventory_item);
940: l_msg := l_msg || substr(g_space, 1, g_length_inventory_item - length(l_msg)) || g_indenting;
941: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

Line 941: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

937: fnd_file.put(FND_FILE.OUTPUT, l_msg);
938:
939: l_msg := substr(p_inventory_item, 1,g_length_inventory_item);
940: l_msg := l_msg || substr(g_space, 1, g_length_inventory_item - length(l_msg)) || g_indenting;
941: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
942: END;
943:
944:
945: /* Missing UOM header */

Line 955: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

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 := '';
959: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_NO');

Line 956: fnd_file.put_line(FND_FILE.OUTPUT, '');

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 := '';
959: fnd_message.set_name('BIS','BIS_DBI_COL_CONTRACT_NO');
960: l_tmp:=substr(fnd_message.get, 1, g_length_contract_no);

Line 988: ---fnd_file.put_line(fnd_file.LOG, 'L_MSG IS : '||l_msg);

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);
990:
991:
992: l_msg := substr(g_line, 1, g_length_contract_no)||g_indenting||

Line 989: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

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);
990:
991:
992: l_msg := substr(g_line, 1, g_length_contract_no)||g_indenting||
993: substr(g_line, 1, g_length_status)||g_indenting||

Line 1000: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

996: substr(g_line, 1, g_length_to_currency)||g_indenting||
997: substr(g_line, 1, g_length_date)||g_indenting||
998: substr(g_line, 1, g_length_contract_id);
999:
1000: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
1001: END;
1002:
1003: /*
1004: From UOM To UOM Inventory Item

Line 1028: fnd_file.put(FND_FILE.OUTPUT, l_msg);

1024: BEGIN
1025:
1026: l_msg:=substr(p_contract_no, 1, g_length_contract_no);
1027: l_msg := l_msg || substr(g_space, 1, g_length_contract_no - length(l_msg)) || g_indenting;
1028: fnd_file.put(FND_FILE.OUTPUT, l_msg);
1029:
1030: l_msg:=substr(p_contract_status, 1,g_length_status );
1031: l_msg := l_msg || substr(g_space, 1, g_length_status - length(l_msg)) || g_indenting;
1032: fnd_file.put(FND_FILE.OUTPUT, l_msg);

Line 1032: fnd_file.put(FND_FILE.OUTPUT, l_msg);

1028: fnd_file.put(FND_FILE.OUTPUT, l_msg);
1029:
1030: l_msg:=substr(p_contract_status, 1,g_length_status );
1031: l_msg := l_msg || substr(g_space, 1, g_length_status - length(l_msg)) || g_indenting;
1032: fnd_file.put(FND_FILE.OUTPUT, l_msg);
1033:
1034: ----the following code is for bug 4260678
1035: l_user_rate_type:=get_user_rate_type(p_rate_type);
1036: --l_msg:=substr(p_rate_type, 1,g_length_rate_type );

Line 1040: fnd_file.put(FND_FILE.OUTPUT, l_msg);

1036: --l_msg:=substr(p_rate_type, 1,g_length_rate_type );
1037: l_msg:=substr(l_user_rate_type, 1,g_length_rate_type );
1038:
1039: l_msg := l_msg || substr(g_space, 1, g_length_rate_type - length(l_msg))|| g_indenting;
1040: fnd_file.put(FND_FILE.OUTPUT, l_msg);
1041:
1042:
1043: l_msg:=substr(p_from_currency, 1, g_length_from_currency);
1044: l_msg := l_msg || substr(g_space, 1, g_length_from_currency - length(l_msg)) || g_indenting;

Line 1045: fnd_file.put(FND_FILE.OUTPUT, l_msg);

1041:
1042:
1043: l_msg:=substr(p_from_currency, 1, g_length_from_currency);
1044: l_msg := l_msg || substr(g_space, 1, g_length_from_currency - length(l_msg)) || g_indenting;
1045: fnd_file.put(FND_FILE.OUTPUT, l_msg);
1046:
1047:
1048: l_msg:=substr(p_to_currency, 1,g_length_to_currency );
1049: l_msg := l_msg || substr(g_space, 1, g_length_to_currency - length(l_msg)) || g_indenting;

Line 1050: fnd_file.put(FND_FILE.OUTPUT, l_msg);

1046:
1047:
1048: l_msg:=substr(p_to_currency, 1,g_length_to_currency );
1049: l_msg := l_msg || substr(g_space, 1, g_length_to_currency - length(l_msg)) || g_indenting;
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 );

Line 1060: fnd_file.put(FND_FILE.OUTPUT, l_msg);

1056: l_msg := substr(p_date_override, 1,g_length_date );
1057: END IF;
1058:
1059: l_msg := l_msg || substr(g_space, 1, g_length_date - length(l_msg)) || g_indenting;
1060: fnd_file.put(FND_FILE.OUTPUT, l_msg);
1061:
1062:
1063: l_msg := substr(p_contract_id, 1,g_length_contract_id);
1064: l_msg := l_msg || substr(g_space, 1, g_length_contract_id - length(l_msg)) || g_indenting;

Line 1065: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);

1061:
1062:
1063: l_msg := substr(p_contract_id, 1,g_length_contract_id);
1064: l_msg := l_msg || substr(g_space, 1, g_length_contract_id - length(l_msg)) || g_indenting;
1065: fnd_file.put_line(FND_FILE.OUTPUT, l_msg);
1066: END;
1067:
1068: /*
1069: * Added for enhancement 3183157