DBA Data[Home] [Help]

APPS.AP_CREDIT_CARD_TRXN_LOADER_PKG dependencies on FND_FILE

Line 54: fnd_file.put_line(fnd_file.log, 'Parsing p_indatafilename '|| p_indatafilename);

50:
51: --
52: -- Parse the indatafilename for the path and filename
53: --
54: fnd_file.put_line(fnd_file.log, 'Parsing p_indatafilename '|| p_indatafilename);
55: l_ntdir := instrb(p_indatafilename, '\', -1);
56: l_unixdir := instrb(p_indatafilename, '/', -1);
57: if (l_ntdir > 0) then
58: l_indatapathname := substrb(p_indatafilename, 0, l_ntdir-1);

Line 67: fnd_file.put_line(fnd_file.log, 'l_ntdir '|| to_char(l_ntdir));

63: else
64: l_indatapathname := '';
65: l_indatafilename := p_indatafilename;
66: end if;
67: fnd_file.put_line(fnd_file.log, 'l_ntdir '|| to_char(l_ntdir));
68: fnd_file.put_line(fnd_file.log, 'l_unixdir '|| to_char(l_unixdir));
69: fnd_file.put_line(fnd_file.log, 'l_indatapathname '|| l_indatapathname);
70: fnd_file.put_line(fnd_file.log, 'l_indatafilename '|| l_indatafilename);
71:

Line 68: fnd_file.put_line(fnd_file.log, 'l_unixdir '|| to_char(l_unixdir));

64: l_indatapathname := '';
65: l_indatafilename := p_indatafilename;
66: end if;
67: fnd_file.put_line(fnd_file.log, 'l_ntdir '|| to_char(l_ntdir));
68: fnd_file.put_line(fnd_file.log, 'l_unixdir '|| to_char(l_unixdir));
69: fnd_file.put_line(fnd_file.log, 'l_indatapathname '|| l_indatapathname);
70: fnd_file.put_line(fnd_file.log, 'l_indatafilename '|| l_indatafilename);
71:
72: --

Line 69: fnd_file.put_line(fnd_file.log, 'l_indatapathname '|| l_indatapathname);

65: l_indatafilename := p_indatafilename;
66: end if;
67: fnd_file.put_line(fnd_file.log, 'l_ntdir '|| to_char(l_ntdir));
68: fnd_file.put_line(fnd_file.log, 'l_unixdir '|| to_char(l_unixdir));
69: fnd_file.put_line(fnd_file.log, 'l_indatapathname '|| l_indatapathname);
70: fnd_file.put_line(fnd_file.log, 'l_indatafilename '|| l_indatafilename);
71:
72: --
73: -- Parse the outdatafilename for the path and filename

Line 70: fnd_file.put_line(fnd_file.log, 'l_indatafilename '|| l_indatafilename);

66: end if;
67: fnd_file.put_line(fnd_file.log, 'l_ntdir '|| to_char(l_ntdir));
68: fnd_file.put_line(fnd_file.log, 'l_unixdir '|| to_char(l_unixdir));
69: fnd_file.put_line(fnd_file.log, 'l_indatapathname '|| l_indatapathname);
70: fnd_file.put_line(fnd_file.log, 'l_indatafilename '|| l_indatafilename);
71:
72: --
73: -- Parse the outdatafilename for the path and filename
74: --

Line 75: fnd_file.put_line(fnd_file.log, 'Parsing p_outdatafilename '|| p_outdatafilename);

71:
72: --
73: -- Parse the outdatafilename for the path and filename
74: --
75: fnd_file.put_line(fnd_file.log, 'Parsing p_outdatafilename '|| p_outdatafilename);
76: l_ntdir := instrb(p_outdatafilename, '\', -1);
77: l_unixdir := instrb(p_outdatafilename, '/', -1);
78: if (l_ntdir > 0) then
79: l_outdatapathname := substrb(p_outdatafilename, 0, l_ntdir-1);

Line 88: fnd_file.put_line(fnd_file.log, 'l_ntdir '|| to_char(l_ntdir));

84: else
85: l_outdatapathname := '';
86: l_outdatafilename := p_outdatafilename;
87: end if;
88: fnd_file.put_line(fnd_file.log, 'l_ntdir '|| to_char(l_ntdir));
89: fnd_file.put_line(fnd_file.log, 'l_unixdir '|| to_char(l_unixdir));
90: fnd_file.put_line(fnd_file.log, 'l_outdatapathname '|| l_outdatapathname);
91: fnd_file.put_line(fnd_file.log, 'l_outdatafilename '|| l_outdatafilename);
92:

Line 89: fnd_file.put_line(fnd_file.log, 'l_unixdir '|| to_char(l_unixdir));

85: l_outdatapathname := '';
86: l_outdatafilename := p_outdatafilename;
87: end if;
88: fnd_file.put_line(fnd_file.log, 'l_ntdir '|| to_char(l_ntdir));
89: fnd_file.put_line(fnd_file.log, 'l_unixdir '|| to_char(l_unixdir));
90: fnd_file.put_line(fnd_file.log, 'l_outdatapathname '|| l_outdatapathname);
91: fnd_file.put_line(fnd_file.log, 'l_outdatafilename '|| l_outdatafilename);
92:
93: --

Line 90: fnd_file.put_line(fnd_file.log, 'l_outdatapathname '|| l_outdatapathname);

86: l_outdatafilename := p_outdatafilename;
87: end if;
88: fnd_file.put_line(fnd_file.log, 'l_ntdir '|| to_char(l_ntdir));
89: fnd_file.put_line(fnd_file.log, 'l_unixdir '|| to_char(l_unixdir));
90: fnd_file.put_line(fnd_file.log, 'l_outdatapathname '|| l_outdatapathname);
91: fnd_file.put_line(fnd_file.log, 'l_outdatafilename '|| l_outdatafilename);
92:
93: --
94: -- Open the in/outdatafiles for read/write

Line 91: fnd_file.put_line(fnd_file.log, 'l_outdatafilename '|| l_outdatafilename);

87: end if;
88: fnd_file.put_line(fnd_file.log, 'l_ntdir '|| to_char(l_ntdir));
89: fnd_file.put_line(fnd_file.log, 'l_unixdir '|| to_char(l_unixdir));
90: fnd_file.put_line(fnd_file.log, 'l_outdatapathname '|| l_outdatapathname);
91: fnd_file.put_line(fnd_file.log, 'l_outdatafilename '|| l_outdatafilename);
92:
93: --
94: -- Open the in/outdatafiles for read/write
95: --

Line 96: fnd_file.put_line(fnd_file.log, 'Opening p_indatafilename '|| p_indatafilename);

92:
93: --
94: -- Open the in/outdatafiles for read/write
95: --
96: fnd_file.put_line(fnd_file.log, 'Opening p_indatafilename '|| p_indatafilename);
97: l_indatafileptr := utl_file.fopen(l_indatapathname, l_indatafilename, 'r');
98: fnd_file.put_line(fnd_file.log, 'Opening p_outdatafilename '|| p_outdatafilename);
99: l_outdatafileptr := utl_file.fopen(l_outdatapathname, l_outdatafilename, 'w');
100:

Line 98: fnd_file.put_line(fnd_file.log, 'Opening p_outdatafilename '|| p_outdatafilename);

94: -- Open the in/outdatafiles for read/write
95: --
96: fnd_file.put_line(fnd_file.log, 'Opening p_indatafilename '|| p_indatafilename);
97: l_indatafileptr := utl_file.fopen(l_indatapathname, l_indatafilename, 'r');
98: fnd_file.put_line(fnd_file.log, 'Opening p_outdatafilename '|| p_outdatafilename);
99: l_outdatafileptr := utl_file.fopen(l_outdatapathname, l_outdatafilename, 'w');
100:
101: fnd_file.put_line(fnd_file.log, 'p_cardbrand '|| p_cardbrand);
102: l_numrecs := 0;

Line 101: fnd_file.put_line(fnd_file.log, 'p_cardbrand '|| p_cardbrand);

97: l_indatafileptr := utl_file.fopen(l_indatapathname, l_indatafilename, 'r');
98: fnd_file.put_line(fnd_file.log, 'Opening p_outdatafilename '|| p_outdatafilename);
99: l_outdatafileptr := utl_file.fopen(l_outdatapathname, l_outdatafilename, 'w');
100:
101: fnd_file.put_line(fnd_file.log, 'p_cardbrand '|| p_cardbrand);
102: l_numrecs := 0;
103: --
104: -- Preformat MasterCard by duplicating the addendum type which
105: -- is stored in position(44-46) in the transaction record

Line 133: fnd_file.put_line(fnd_file.log, 'Number of records preformatted '|| to_char(l_numrecs));

129: exit;
130: end;
131: end loop;
132: end if;
133: fnd_file.put_line(fnd_file.log, 'Number of records preformatted '|| to_char(l_numrecs));
134:
135: --
136: -- Close the in/outdatafiles
137: --

Line 138: fnd_file.put_line(fnd_file.log, 'Closing p_indatafilename '|| p_indatafilename);

134:
135: --
136: -- Close the in/outdatafiles
137: --
138: fnd_file.put_line(fnd_file.log, 'Closing p_indatafilename '|| p_indatafilename);
139: utl_file.fclose(l_indatafileptr);
140: fnd_file.put_line(fnd_file.log, 'Closing p_outdatafilename '|| p_outdatafilename);
141: utl_file.fclose(l_outdatafileptr);
142:

Line 140: fnd_file.put_line(fnd_file.log, 'Closing p_outdatafilename '|| p_outdatafilename);

136: -- Close the in/outdatafiles
137: --
138: fnd_file.put_line(fnd_file.log, 'Closing p_indatafilename '|| p_indatafilename);
139: utl_file.fclose(l_indatafileptr);
140: fnd_file.put_line(fnd_file.log, 'Closing p_outdatafilename '|| p_outdatafilename);
141: utl_file.fclose(l_outdatafileptr);
142:
143: EXCEPTION
144: WHEN OTHERS THEN