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.FV_GTAS_AGENCY_ID_UPGRADE dependencies on FND_FILE

Line 66: fnd_file.put_line(fnd_file.log, 'When others error: '||sqlerrm);

62: COMMIT;
63:
64: log(l_module, 'End');
65: EXCEPTION WHEN OTHERS THEN
66: fnd_file.put_line(fnd_file.log, 'When others error: '||sqlerrm);
67: p_err_buff := 'When others error: '||sqlerrm;
68: p_err_code := sqlcode;
69: END main;
70: -------------------------------------------------------------------------

Line 112: fnd_file.put_line(fnd_file.log, 'Table owner: '||l_tab_owner);

108: SELECT product_code
109: INTO l_tab_owner
110: FROM fnd_application
111: WHERE application_id = 222;
112: fnd_file.put_line(fnd_file.log, 'Table owner: '||l_tab_owner);
113:
114: SELECT 'Y'
115: INTO l_cust_col_exists
116: FROM all_tab_columns

Line 120: fnd_file.put_line(fnd_file.log, l_blank_line);

116: FROM all_tab_columns
117: WHERE table_name = 'HZ_CUST_ACCOUNTS'
118: AND column_name = 'TRADING_PARTNER_AGENCY_ID'
119: AND owner = l_tab_owner;
120: fnd_file.put_line(fnd_file.log, l_blank_line);
121: fnd_file.put_line(fnd_file.log, 'New customer column exists.');
122:
123: EXCEPTION WHEN NO_DATA_FOUND THEN
124: fnd_file.put_line(fnd_file.log, l_blank_line);

Line 121: fnd_file.put_line(fnd_file.log, 'New customer column exists.');

117: WHERE table_name = 'HZ_CUST_ACCOUNTS'
118: AND column_name = 'TRADING_PARTNER_AGENCY_ID'
119: AND owner = l_tab_owner;
120: fnd_file.put_line(fnd_file.log, l_blank_line);
121: fnd_file.put_line(fnd_file.log, 'New customer column exists.');
122:
123: EXCEPTION WHEN NO_DATA_FOUND THEN
124: fnd_file.put_line(fnd_file.log, l_blank_line);
125: fnd_file.put_line(fnd_file.log, 'New customer column does not exist.');

Line 124: fnd_file.put_line(fnd_file.log, l_blank_line);

120: fnd_file.put_line(fnd_file.log, l_blank_line);
121: fnd_file.put_line(fnd_file.log, 'New customer column exists.');
122:
123: EXCEPTION WHEN NO_DATA_FOUND THEN
124: fnd_file.put_line(fnd_file.log, l_blank_line);
125: fnd_file.put_line(fnd_file.log, 'New customer column does not exist.');
126:
127: SELECT gtas_customer_attribute
128: INTO l_gtas_cust_attribute

Line 125: fnd_file.put_line(fnd_file.log, 'New customer column does not exist.');

121: fnd_file.put_line(fnd_file.log, 'New customer column exists.');
122:
123: EXCEPTION WHEN NO_DATA_FOUND THEN
124: fnd_file.put_line(fnd_file.log, l_blank_line);
125: fnd_file.put_line(fnd_file.log, 'New customer column does not exist.');
126:
127: SELECT gtas_customer_attribute
128: INTO l_gtas_cust_attribute
129: FROM fv_system_parameters;

Line 130: fnd_file.put_line(fnd_file.log, l_blank_line);

126:
127: SELECT gtas_customer_attribute
128: INTO l_gtas_cust_attribute
129: FROM fv_system_parameters;
130: fnd_file.put_line(fnd_file.log, l_blank_line);
131: fnd_file.put_line(fnd_file.log,'gtas_customer_attribute: '||l_gtas_cust_attribute);
132:
133: IF l_gtas_cust_attribute IS NULL THEN
134: fnd_file.put_line(fnd_file.log, l_blank_line);

Line 131: fnd_file.put_line(fnd_file.log,'gtas_customer_attribute: '||l_gtas_cust_attribute);

127: SELECT gtas_customer_attribute
128: INTO l_gtas_cust_attribute
129: FROM fv_system_parameters;
130: fnd_file.put_line(fnd_file.log, l_blank_line);
131: fnd_file.put_line(fnd_file.log,'gtas_customer_attribute: '||l_gtas_cust_attribute);
132:
133: IF l_gtas_cust_attribute IS NULL THEN
134: fnd_file.put_line(fnd_file.log, l_blank_line);
135: fnd_file.put_line(fnd_file.log,'GTAS Customer Attribute is null');

Line 134: fnd_file.put_line(fnd_file.log, l_blank_line);

130: fnd_file.put_line(fnd_file.log, l_blank_line);
131: fnd_file.put_line(fnd_file.log,'gtas_customer_attribute: '||l_gtas_cust_attribute);
132:
133: IF l_gtas_cust_attribute IS NULL THEN
134: fnd_file.put_line(fnd_file.log, l_blank_line);
135: fnd_file.put_line(fnd_file.log,'GTAS Customer Attribute is null');
136: l_err_string := 'GTAS Customer Attribute is null. Please set this up'||
137: ' in the Define Federal System Parameters form and'||
138: ' rerun this process.';

Line 135: fnd_file.put_line(fnd_file.log,'GTAS Customer Attribute is null');

131: fnd_file.put_line(fnd_file.log,'gtas_customer_attribute: '||l_gtas_cust_attribute);
132:
133: IF l_gtas_cust_attribute IS NULL THEN
134: fnd_file.put_line(fnd_file.log, l_blank_line);
135: fnd_file.put_line(fnd_file.log,'GTAS Customer Attribute is null');
136: l_err_string := 'GTAS Customer Attribute is null. Please set this up'||
137: ' in the Define Federal System Parameters form and'||
138: ' rerun this process.';
139: fnd_file.put_line(fnd_file.log, l_err_string);

Line 139: fnd_file.put_line(fnd_file.log, l_err_string);

135: fnd_file.put_line(fnd_file.log,'GTAS Customer Attribute is null');
136: l_err_string := 'GTAS Customer Attribute is null. Please set this up'||
137: ' in the Define Federal System Parameters form and'||
138: ' rerun this process.';
139: fnd_file.put_line(fnd_file.log, l_err_string);
140: g_err_buff := l_err_string;
141: g_err_code := 2;
142: RETURN;
143: END IF;

Line 151: fnd_file.put_line(fnd_file.log, l_blank_line);

147: SELECT factsI_customer_attribute, factsI_vendor_attribute
148: INTO l_facts1_cust_attribute, l_facts1_vend_attribute
149: FROM fv_system_parameters;
150:
151: fnd_file.put_line(fnd_file.log, l_blank_line);
152: fnd_file.put_line(fnd_file.log,'l_facts1_cust_attribute: '||l_facts1_cust_attribute);
153: fnd_file.put_line(fnd_file.log,'l_facts1_vend_attribute: '||l_facts1_vend_attribute);
154:
155: IF (l_facts1_cust_attribute IS NULL OR l_facts1_vend_attribute IS NULL) THEN

Line 152: fnd_file.put_line(fnd_file.log,'l_facts1_cust_attribute: '||l_facts1_cust_attribute);

148: INTO l_facts1_cust_attribute, l_facts1_vend_attribute
149: FROM fv_system_parameters;
150:
151: fnd_file.put_line(fnd_file.log, l_blank_line);
152: fnd_file.put_line(fnd_file.log,'l_facts1_cust_attribute: '||l_facts1_cust_attribute);
153: fnd_file.put_line(fnd_file.log,'l_facts1_vend_attribute: '||l_facts1_vend_attribute);
154:
155: IF (l_facts1_cust_attribute IS NULL OR l_facts1_vend_attribute IS NULL) THEN
156: fnd_file.put_line(fnd_file.log, l_blank_line);

Line 153: fnd_file.put_line(fnd_file.log,'l_facts1_vend_attribute: '||l_facts1_vend_attribute);

149: FROM fv_system_parameters;
150:
151: fnd_file.put_line(fnd_file.log, l_blank_line);
152: fnd_file.put_line(fnd_file.log,'l_facts1_cust_attribute: '||l_facts1_cust_attribute);
153: fnd_file.put_line(fnd_file.log,'l_facts1_vend_attribute: '||l_facts1_vend_attribute);
154:
155: IF (l_facts1_cust_attribute IS NULL OR l_facts1_vend_attribute IS NULL) THEN
156: fnd_file.put_line(fnd_file.log, l_blank_line);
157: fnd_file.put_line(fnd_file.log,'GTAS Customer Attribute is null');

Line 156: fnd_file.put_line(fnd_file.log, l_blank_line);

152: fnd_file.put_line(fnd_file.log,'l_facts1_cust_attribute: '||l_facts1_cust_attribute);
153: fnd_file.put_line(fnd_file.log,'l_facts1_vend_attribute: '||l_facts1_vend_attribute);
154:
155: IF (l_facts1_cust_attribute IS NULL OR l_facts1_vend_attribute IS NULL) THEN
156: fnd_file.put_line(fnd_file.log, l_blank_line);
157: fnd_file.put_line(fnd_file.log,'GTAS Customer Attribute is null');
158: l_err_string := 'FACTS1 Customer or Vendor Attribute is null. Please set this up'||
159: ' in the Define Federal System Parameters form and'||
160: ' rerun this process.';

Line 157: fnd_file.put_line(fnd_file.log,'GTAS Customer Attribute is null');

153: fnd_file.put_line(fnd_file.log,'l_facts1_vend_attribute: '||l_facts1_vend_attribute);
154:
155: IF (l_facts1_cust_attribute IS NULL OR l_facts1_vend_attribute IS NULL) THEN
156: fnd_file.put_line(fnd_file.log, l_blank_line);
157: fnd_file.put_line(fnd_file.log,'GTAS Customer Attribute is null');
158: l_err_string := 'FACTS1 Customer or Vendor Attribute is null. Please set this up'||
159: ' in the Define Federal System Parameters form and'||
160: ' rerun this process.';
161: fnd_file.put_line(fnd_file.log,l_err_string);

Line 161: fnd_file.put_line(fnd_file.log,l_err_string);

157: fnd_file.put_line(fnd_file.log,'GTAS Customer Attribute is null');
158: l_err_string := 'FACTS1 Customer or Vendor Attribute is null. Please set this up'||
159: ' in the Define Federal System Parameters form and'||
160: ' rerun this process.';
161: fnd_file.put_line(fnd_file.log,l_err_string);
162: g_err_buff := l_err_string;
163: g_err_code := 2;
164: RETURN;
165: END IF;

Line 204: --fnd_file.put_line(fnd_file.log, l_aid_select);

200: )
201: and substr(c.'||l_attrib||',1,2) is not null '||
202: l_where_clause ;
203:
204: --fnd_file.put_line(fnd_file.log, l_aid_select);
205: IF c_aid_select%ISOPEN THEN close c_aid_select; END IF;
206: OPEN c_aid_select FOR l_aid_select;
207: LOOP
208: FETCH c_aid_select INTO l_account_id, l_account_name, l_agency_id, l_main_acct;

Line 212: fnd_file.put_line(fnd_file.output,'Agency ID not found for the following Customers/Suppliers:');

208: FETCH c_aid_select INTO l_account_id, l_account_name, l_agency_id, l_main_acct;
209: EXIT WHEN c_aid_select%NOTFOUND;
210:
211: IF NOT l_hdr_printed THEN
212: fnd_file.put_line(fnd_file.output,'Agency ID not found for the following Customers/Suppliers:');
213: fnd_file.put_line(fnd_file.output,'Please update them manually.');
214: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
215: fnd_file.put_line(fnd_file.output,'Customer Customer/Supplier Agency ID');
216: fnd_file.put_line(fnd_file.output,'Account ID/ Name ');

Line 213: fnd_file.put_line(fnd_file.output,'Please update them manually.');

209: EXIT WHEN c_aid_select%NOTFOUND;
210:
211: IF NOT l_hdr_printed THEN
212: fnd_file.put_line(fnd_file.output,'Agency ID not found for the following Customers/Suppliers:');
213: fnd_file.put_line(fnd_file.output,'Please update them manually.');
214: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
215: fnd_file.put_line(fnd_file.output,'Customer Customer/Supplier Agency ID');
216: fnd_file.put_line(fnd_file.output,'Account ID/ Name ');
217: fnd_file.put_line(fnd_file.output,'Supplier ID');

Line 214: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));

210:
211: IF NOT l_hdr_printed THEN
212: fnd_file.put_line(fnd_file.output,'Agency ID not found for the following Customers/Suppliers:');
213: fnd_file.put_line(fnd_file.output,'Please update them manually.');
214: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
215: fnd_file.put_line(fnd_file.output,'Customer Customer/Supplier Agency ID');
216: fnd_file.put_line(fnd_file.output,'Account ID/ Name ');
217: fnd_file.put_line(fnd_file.output,'Supplier ID');
218: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));

Line 215: fnd_file.put_line(fnd_file.output,'Customer Customer/Supplier Agency ID');

211: IF NOT l_hdr_printed THEN
212: fnd_file.put_line(fnd_file.output,'Agency ID not found for the following Customers/Suppliers:');
213: fnd_file.put_line(fnd_file.output,'Please update them manually.');
214: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
215: fnd_file.put_line(fnd_file.output,'Customer Customer/Supplier Agency ID');
216: fnd_file.put_line(fnd_file.output,'Account ID/ Name ');
217: fnd_file.put_line(fnd_file.output,'Supplier ID');
218: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));
219: l_hdr_printed := TRUE;

Line 216: fnd_file.put_line(fnd_file.output,'Account ID/ Name ');

212: fnd_file.put_line(fnd_file.output,'Agency ID not found for the following Customers/Suppliers:');
213: fnd_file.put_line(fnd_file.output,'Please update them manually.');
214: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
215: fnd_file.put_line(fnd_file.output,'Customer Customer/Supplier Agency ID');
216: fnd_file.put_line(fnd_file.output,'Account ID/ Name ');
217: fnd_file.put_line(fnd_file.output,'Supplier ID');
218: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));
219: l_hdr_printed := TRUE;
220: END IF;

Line 217: fnd_file.put_line(fnd_file.output,'Supplier ID');

213: fnd_file.put_line(fnd_file.output,'Please update them manually.');
214: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
215: fnd_file.put_line(fnd_file.output,'Customer Customer/Supplier Agency ID');
216: fnd_file.put_line(fnd_file.output,'Account ID/ Name ');
217: fnd_file.put_line(fnd_file.output,'Supplier ID');
218: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));
219: l_hdr_printed := TRUE;
220: END IF;
221:

Line 218: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));

214: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
215: fnd_file.put_line(fnd_file.output,'Customer Customer/Supplier Agency ID');
216: fnd_file.put_line(fnd_file.output,'Account ID/ Name ');
217: fnd_file.put_line(fnd_file.output,'Supplier ID');
218: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));
219: l_hdr_printed := TRUE;
220: END IF;
221:
222: IF NOT l_sub_hdr_printed THEN

Line 223: fnd_file.put_line(fnd_file.output,l_party_type);

219: l_hdr_printed := TRUE;
220: END IF;
221:
222: IF NOT l_sub_hdr_printed THEN
223: fnd_file.put_line(fnd_file.output,l_party_type);
224: l_sub_hdr_printed := TRUE;
225: END IF;
226:
227: fnd_file.put_line(fnd_file.output, RPAD(l_account_id,15,' ')||RPAD(NVL(l_account_name,' '),40,' ')||

Line 227: fnd_file.put_line(fnd_file.output, RPAD(l_account_id,15,' ')||RPAD(NVL(l_account_name,' '),40,' ')||

223: fnd_file.put_line(fnd_file.output,l_party_type);
224: l_sub_hdr_printed := TRUE;
225: END IF;
226:
227: fnd_file.put_line(fnd_file.output, RPAD(l_account_id,15,' ')||RPAD(NVL(l_account_name,' '),40,' ')||
228: l_agency_id);
229:
230:
231: END LOOP;

Line 261: --fnd_file.put_line(fnd_file.log, l_aid_select);

257: l_aid_select := l_col_select ||
258: ' WHERE NVL(substr(c.'||l_attrib||',1,2),-99) IN (''48'',''95'') '||
259: l_where_clause ;
260:
261: --fnd_file.put_line(fnd_file.log, l_aid_select);
262:
263: IF c_aid_select%ISOPEN THEN close c_aid_select; END IF;
264: OPEN c_aid_select FOR l_aid_select;
265: LOOP

Line 270: fnd_file.put_line(fnd_file.output,' ');

266: FETCH c_aid_select INTO l_party_name;
267: EXIT WHEN c_aid_select%NOTFOUND;
268:
269: IF NOT l_hdr_printed THEN
270: fnd_file.put_line(fnd_file.output,' ');
271: fnd_file.put_line(fnd_file.output,' ');
272: fnd_file.put_line(fnd_file.output,' ');
273: fnd_file.put_line(fnd_file.output,'Agency ID not updated for the following.');
274: fnd_file.put_line(fnd_file.output,'Please check and rectify as necessary.');

Line 271: fnd_file.put_line(fnd_file.output,' ');

267: EXIT WHEN c_aid_select%NOTFOUND;
268:
269: IF NOT l_hdr_printed THEN
270: fnd_file.put_line(fnd_file.output,' ');
271: fnd_file.put_line(fnd_file.output,' ');
272: fnd_file.put_line(fnd_file.output,' ');
273: fnd_file.put_line(fnd_file.output,'Agency ID not updated for the following.');
274: fnd_file.put_line(fnd_file.output,'Please check and rectify as necessary.');
275: fnd_file.put_line(fnd_file.output, rpad('-',80,'-'));

Line 272: fnd_file.put_line(fnd_file.output,' ');

268:
269: IF NOT l_hdr_printed THEN
270: fnd_file.put_line(fnd_file.output,' ');
271: fnd_file.put_line(fnd_file.output,' ');
272: fnd_file.put_line(fnd_file.output,' ');
273: fnd_file.put_line(fnd_file.output,'Agency ID not updated for the following.');
274: fnd_file.put_line(fnd_file.output,'Please check and rectify as necessary.');
275: fnd_file.put_line(fnd_file.output, rpad('-',80,'-'));
276: fnd_file.put_line(fnd_file.output,'Supplier/Customer Name');

Line 273: fnd_file.put_line(fnd_file.output,'Agency ID not updated for the following.');

269: IF NOT l_hdr_printed THEN
270: fnd_file.put_line(fnd_file.output,' ');
271: fnd_file.put_line(fnd_file.output,' ');
272: fnd_file.put_line(fnd_file.output,' ');
273: fnd_file.put_line(fnd_file.output,'Agency ID not updated for the following.');
274: fnd_file.put_line(fnd_file.output,'Please check and rectify as necessary.');
275: fnd_file.put_line(fnd_file.output, rpad('-',80,'-'));
276: fnd_file.put_line(fnd_file.output,'Supplier/Customer Name');
277: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

Line 274: fnd_file.put_line(fnd_file.output,'Please check and rectify as necessary.');

270: fnd_file.put_line(fnd_file.output,' ');
271: fnd_file.put_line(fnd_file.output,' ');
272: fnd_file.put_line(fnd_file.output,' ');
273: fnd_file.put_line(fnd_file.output,'Agency ID not updated for the following.');
274: fnd_file.put_line(fnd_file.output,'Please check and rectify as necessary.');
275: fnd_file.put_line(fnd_file.output, rpad('-',80,'-'));
276: fnd_file.put_line(fnd_file.output,'Supplier/Customer Name');
277: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
278: l_hdr_printed := TRUE;

Line 275: fnd_file.put_line(fnd_file.output, rpad('-',80,'-'));

271: fnd_file.put_line(fnd_file.output,' ');
272: fnd_file.put_line(fnd_file.output,' ');
273: fnd_file.put_line(fnd_file.output,'Agency ID not updated for the following.');
274: fnd_file.put_line(fnd_file.output,'Please check and rectify as necessary.');
275: fnd_file.put_line(fnd_file.output, rpad('-',80,'-'));
276: fnd_file.put_line(fnd_file.output,'Supplier/Customer Name');
277: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
278: l_hdr_printed := TRUE;
279: END IF;

Line 276: fnd_file.put_line(fnd_file.output,'Supplier/Customer Name');

272: fnd_file.put_line(fnd_file.output,' ');
273: fnd_file.put_line(fnd_file.output,'Agency ID not updated for the following.');
274: fnd_file.put_line(fnd_file.output,'Please check and rectify as necessary.');
275: fnd_file.put_line(fnd_file.output, rpad('-',80,'-'));
276: fnd_file.put_line(fnd_file.output,'Supplier/Customer Name');
277: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
278: l_hdr_printed := TRUE;
279: END IF;
280:

Line 277: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

273: fnd_file.put_line(fnd_file.output,'Agency ID not updated for the following.');
274: fnd_file.put_line(fnd_file.output,'Please check and rectify as necessary.');
275: fnd_file.put_line(fnd_file.output, rpad('-',80,'-'));
276: fnd_file.put_line(fnd_file.output,'Supplier/Customer Name');
277: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
278: l_hdr_printed := TRUE;
279: END IF;
280:
281: IF NOT l_sub_hdr_printed THEN

Line 282: fnd_file.put_line(fnd_file.output,' ');

278: l_hdr_printed := TRUE;
279: END IF;
280:
281: IF NOT l_sub_hdr_printed THEN
282: fnd_file.put_line(fnd_file.output,' ');
283: fnd_file.put_line(fnd_file.output,l_party_type);
284:
285: l_sub_hdr_printed := TRUE;
286: END IF;

Line 283: fnd_file.put_line(fnd_file.output,l_party_type);

279: END IF;
280:
281: IF NOT l_sub_hdr_printed THEN
282: fnd_file.put_line(fnd_file.output,' ');
283: fnd_file.put_line(fnd_file.output,l_party_type);
284:
285: l_sub_hdr_printed := TRUE;
286: END IF;
287:

Line 288: fnd_file.put_line(fnd_file.output, l_party_name);

284:
285: l_sub_hdr_printed := TRUE;
286: END IF;
287:
288: fnd_file.put_line(fnd_file.output, l_party_name);
289:
290:
291: END LOOP;
292:

Line 325: fnd_file.put_line(fnd_file.log,' ');

321: and SUBSTR(c.'||l_attrib||',1,2) IS NOT NULL
322: and c.customer_class_code = ''FEDERAL''
323: and SUBSTR(c.'||l_attrib||',1,2) NOT IN (''48'', ''95'') ';
324:
325: fnd_file.put_line(fnd_file.log,' ');
326: fnd_file.put_line(fnd_file.log,' ');
327: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
328: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.TRADING_PARTNER_AGENCY_ID');
329:

Line 326: fnd_file.put_line(fnd_file.log,' ');

322: and c.customer_class_code = ''FEDERAL''
323: and SUBSTR(c.'||l_attrib||',1,2) NOT IN (''48'', ''95'') ';
324:
325: fnd_file.put_line(fnd_file.log,' ');
326: fnd_file.put_line(fnd_file.log,' ');
327: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
328: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.TRADING_PARTNER_AGENCY_ID');
329:
330: ELSE

Line 327: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');

323: and SUBSTR(c.'||l_attrib||',1,2) NOT IN (''48'', ''95'') ';
324:
325: fnd_file.put_line(fnd_file.log,' ');
326: fnd_file.put_line(fnd_file.log,' ');
327: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
328: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.TRADING_PARTNER_AGENCY_ID');
329:
330: ELSE
331: --Update dff column in hz_cust_accounts_all

Line 328: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.TRADING_PARTNER_AGENCY_ID');

324:
325: fnd_file.put_line(fnd_file.log,' ');
326: fnd_file.put_line(fnd_file.log,' ');
327: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
328: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.TRADING_PARTNER_AGENCY_ID');
329:
330: ELSE
331: --Update dff column in hz_cust_accounts_all
332: l_update_statement :=

Line 352: fnd_file.put_line(fnd_file.log,' ');

348: and SUBSTR(c.'||l_attrib||',1,2) IS NOT NULL
349: and c.customer_class_code = ''FEDERAL''
350: and SUBSTR(c.'||l_attrib||',1,2) NOT IN (''48'', ''95'') ';
351:
352: fnd_file.put_line(fnd_file.log,' ');
353: fnd_file.put_line(fnd_file.log,' ');
354: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
355: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.'||l_gtas_cust_attribute);
356: END IF;

Line 353: fnd_file.put_line(fnd_file.log,' ');

349: and c.customer_class_code = ''FEDERAL''
350: and SUBSTR(c.'||l_attrib||',1,2) NOT IN (''48'', ''95'') ';
351:
352: fnd_file.put_line(fnd_file.log,' ');
353: fnd_file.put_line(fnd_file.log,' ');
354: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
355: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.'||l_gtas_cust_attribute);
356: END IF;
357:

Line 354: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');

350: and SUBSTR(c.'||l_attrib||',1,2) NOT IN (''48'', ''95'') ';
351:
352: fnd_file.put_line(fnd_file.log,' ');
353: fnd_file.put_line(fnd_file.log,' ');
354: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
355: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.'||l_gtas_cust_attribute);
356: END IF;
357:
358:

Line 355: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.'||l_gtas_cust_attribute);

351:
352: fnd_file.put_line(fnd_file.log,' ');
353: fnd_file.put_line(fnd_file.log,' ');
354: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
355: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.'||l_gtas_cust_attribute);
356: END IF;
357:
358:
359: EXECUTE IMMEDIATE l_update_statement;

Line 382: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');

378: and SUBSTR(c.'||l_attrib||',1,2) IS NOT NULL
379: and vendor_type_lookup_code = ''FEDERAL''
380: and SUBSTR(c.'||l_attrib||',1,2) NOT IN (''48'', ''95'') ';
381:
382: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
383: fnd_file.put_line(fnd_file.log,'Updated ap_suppliers.global_attribute5');
384: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
385:
386: EXECUTE IMMEDIATE l_update_statement;

Line 383: fnd_file.put_line(fnd_file.log,'Updated ap_suppliers.global_attribute5');

379: and vendor_type_lookup_code = ''FEDERAL''
380: and SUBSTR(c.'||l_attrib||',1,2) NOT IN (''48'', ''95'') ';
381:
382: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
383: fnd_file.put_line(fnd_file.log,'Updated ap_suppliers.global_attribute5');
384: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
385:
386: EXECUTE IMMEDIATE l_update_statement;
387: END IF;

Line 384: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');

380: and SUBSTR(c.'||l_attrib||',1,2) NOT IN (''48'', ''95'') ';
381:
382: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
383: fnd_file.put_line(fnd_file.log,'Updated ap_suppliers.global_attribute5');
384: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
385:
386: EXECUTE IMMEDIATE l_update_statement;
387: END IF;
388: END LOOP;

Line 460: fnd_file.put_line(fnd_file.output,' ');

456:
457: FOR no_aid_row IN c_aid_NOT_exISts
458: LOOP
459: IF NOT l_hdr_printed THEN
460: fnd_file.put_line(fnd_file.output,' ');
461: fnd_file.put_line(fnd_file.output,' ');
462: fnd_file.put_line(fnd_file.output,'Agency ID/Main Acct NOT found in mapping table for the following:');
463: fnd_file.put_line(fnd_file.output,'Please verify.');
464: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));

Line 461: fnd_file.put_line(fnd_file.output,' ');

457: FOR no_aid_row IN c_aid_NOT_exISts
458: LOOP
459: IF NOT l_hdr_printed THEN
460: fnd_file.put_line(fnd_file.output,' ');
461: fnd_file.put_line(fnd_file.output,' ');
462: fnd_file.put_line(fnd_file.output,'Agency ID/Main Acct NOT found in mapping table for the following:');
463: fnd_file.put_line(fnd_file.output,'Please verify.');
464: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
465: fnd_file.put_line(fnd_file.output,'Ledger ID Agency ID Main Acct SUB Acct Dept Xfer');

Line 462: fnd_file.put_line(fnd_file.output,'Agency ID/Main Acct NOT found in mapping table for the following:');

458: LOOP
459: IF NOT l_hdr_printed THEN
460: fnd_file.put_line(fnd_file.output,' ');
461: fnd_file.put_line(fnd_file.output,' ');
462: fnd_file.put_line(fnd_file.output,'Agency ID/Main Acct NOT found in mapping table for the following:');
463: fnd_file.put_line(fnd_file.output,'Please verify.');
464: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
465: fnd_file.put_line(fnd_file.output,'Ledger ID Agency ID Main Acct SUB Acct Dept Xfer');
466: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));

Line 463: fnd_file.put_line(fnd_file.output,'Please verify.');

459: IF NOT l_hdr_printed THEN
460: fnd_file.put_line(fnd_file.output,' ');
461: fnd_file.put_line(fnd_file.output,' ');
462: fnd_file.put_line(fnd_file.output,'Agency ID/Main Acct NOT found in mapping table for the following:');
463: fnd_file.put_line(fnd_file.output,'Please verify.');
464: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
465: fnd_file.put_line(fnd_file.output,'Ledger ID Agency ID Main Acct SUB Acct Dept Xfer');
466: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));
467: l_hdr_printed := TRUE;

Line 464: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));

460: fnd_file.put_line(fnd_file.output,' ');
461: fnd_file.put_line(fnd_file.output,' ');
462: fnd_file.put_line(fnd_file.output,'Agency ID/Main Acct NOT found in mapping table for the following:');
463: fnd_file.put_line(fnd_file.output,'Please verify.');
464: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
465: fnd_file.put_line(fnd_file.output,'Ledger ID Agency ID Main Acct SUB Acct Dept Xfer');
466: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));
467: l_hdr_printed := TRUE;
468: END IF;

Line 465: fnd_file.put_line(fnd_file.output,'Ledger ID Agency ID Main Acct SUB Acct Dept Xfer');

461: fnd_file.put_line(fnd_file.output,' ');
462: fnd_file.put_line(fnd_file.output,'Agency ID/Main Acct NOT found in mapping table for the following:');
463: fnd_file.put_line(fnd_file.output,'Please verify.');
464: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
465: fnd_file.put_line(fnd_file.output,'Ledger ID Agency ID Main Acct SUB Acct Dept Xfer');
466: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));
467: l_hdr_printed := TRUE;
468: END IF;
469:

Line 466: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));

462: fnd_file.put_line(fnd_file.output,'Agency ID/Main Acct NOT found in mapping table for the following:');
463: fnd_file.put_line(fnd_file.output,'Please verify.');
464: fnd_file.put_line(fnd_file.output, rpad('-',75,'-'));
465: fnd_file.put_line(fnd_file.output,'Ledger ID Agency ID Main Acct SUB Acct Dept Xfer');
466: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));
467: l_hdr_printed := TRUE;
468: END IF;
469:
470: fnd_file.put_line(fnd_file.output, RPAD(no_aid_row.set_of_books_id,15,' ')||

Line 470: fnd_file.put_line(fnd_file.output, RPAD(no_aid_row.set_of_books_id,15,' ')||

466: fnd_file.put_line(fnd_file.output,rpad('-',75,'-'));
467: l_hdr_printed := TRUE;
468: END IF;
469:
470: fnd_file.put_line(fnd_file.output, RPAD(no_aid_row.set_of_books_id,15,' ')||
471: RPAD(no_aid_row.treasury_dept_code,15,' ')||RPAD(no_aid_row.treasury_acct_code,15,' ')||
472: RPAD(no_aid_row.TAFS_SUB_ACCT,15,' ')||no_aid_row.dept_transfer);
473:
474:

Line 479: fnd_file.put_line(fnd_file.log, 'rec.star_dept_reg '|| rec.star_dept_reg);

475: END LOOP;
476:
477: FOR rec IN c_aid_fed_tas_map
478: LOOP
479: fnd_file.put_line(fnd_file.log, 'rec.star_dept_reg '|| rec.star_dept_reg);
480: fnd_file.put_line(fnd_file.log, 'rec.star_main_acct '|| rec.star_main_acct);
481: fnd_file.put_line(fnd_file.log, 'rec.star_dept_xfer '|| rec.star_dept_xfer);
482: fnd_file.put_line(fnd_file.log, 'rec.sub '|| rec.sub);
483: fnd_file.put_line(fnd_file.log, 'rec.treasury_dept_code '|| rec.treasury_dept_code);

Line 480: fnd_file.put_line(fnd_file.log, 'rec.star_main_acct '|| rec.star_main_acct);

476:
477: FOR rec IN c_aid_fed_tas_map
478: LOOP
479: fnd_file.put_line(fnd_file.log, 'rec.star_dept_reg '|| rec.star_dept_reg);
480: fnd_file.put_line(fnd_file.log, 'rec.star_main_acct '|| rec.star_main_acct);
481: fnd_file.put_line(fnd_file.log, 'rec.star_dept_xfer '|| rec.star_dept_xfer);
482: fnd_file.put_line(fnd_file.log, 'rec.sub '|| rec.sub);
483: fnd_file.put_line(fnd_file.log, 'rec.treasury_dept_code '|| rec.treasury_dept_code);
484: fnd_file.put_line(fnd_file.log, 'rec.treasury_acct_code '|| rec.treasury_acct_code);

Line 481: fnd_file.put_line(fnd_file.log, 'rec.star_dept_xfer '|| rec.star_dept_xfer);

477: FOR rec IN c_aid_fed_tas_map
478: LOOP
479: fnd_file.put_line(fnd_file.log, 'rec.star_dept_reg '|| rec.star_dept_reg);
480: fnd_file.put_line(fnd_file.log, 'rec.star_main_acct '|| rec.star_main_acct);
481: fnd_file.put_line(fnd_file.log, 'rec.star_dept_xfer '|| rec.star_dept_xfer);
482: fnd_file.put_line(fnd_file.log, 'rec.sub '|| rec.sub);
483: fnd_file.put_line(fnd_file.log, 'rec.treasury_dept_code '|| rec.treasury_dept_code);
484: fnd_file.put_line(fnd_file.log, 'rec.treasury_acct_code '|| rec.treasury_acct_code);
485: fnd_file.put_line(fnd_file.log, 'rec.treasury_symbol_id '|| rec.treasury_symbol_id);

Line 482: fnd_file.put_line(fnd_file.log, 'rec.sub '|| rec.sub);

478: LOOP
479: fnd_file.put_line(fnd_file.log, 'rec.star_dept_reg '|| rec.star_dept_reg);
480: fnd_file.put_line(fnd_file.log, 'rec.star_main_acct '|| rec.star_main_acct);
481: fnd_file.put_line(fnd_file.log, 'rec.star_dept_xfer '|| rec.star_dept_xfer);
482: fnd_file.put_line(fnd_file.log, 'rec.sub '|| rec.sub);
483: fnd_file.put_line(fnd_file.log, 'rec.treasury_dept_code '|| rec.treasury_dept_code);
484: fnd_file.put_line(fnd_file.log, 'rec.treasury_acct_code '|| rec.treasury_acct_code);
485: fnd_file.put_line(fnd_file.log, 'rec.treasury_symbol_id '|| rec.treasury_symbol_id);
486: fnd_file.put_line(fnd_file.log, 'rec.aid '|| rec.aid);

Line 483: fnd_file.put_line(fnd_file.log, 'rec.treasury_dept_code '|| rec.treasury_dept_code);

479: fnd_file.put_line(fnd_file.log, 'rec.star_dept_reg '|| rec.star_dept_reg);
480: fnd_file.put_line(fnd_file.log, 'rec.star_main_acct '|| rec.star_main_acct);
481: fnd_file.put_line(fnd_file.log, 'rec.star_dept_xfer '|| rec.star_dept_xfer);
482: fnd_file.put_line(fnd_file.log, 'rec.sub '|| rec.sub);
483: fnd_file.put_line(fnd_file.log, 'rec.treasury_dept_code '|| rec.treasury_dept_code);
484: fnd_file.put_line(fnd_file.log, 'rec.treasury_acct_code '|| rec.treasury_acct_code);
485: fnd_file.put_line(fnd_file.log, 'rec.treasury_symbol_id '|| rec.treasury_symbol_id);
486: fnd_file.put_line(fnd_file.log, 'rec.aid '|| rec.aid);
487: fnd_file.put_line(fnd_file.log, 'rec.ata '|| rec.ata);

Line 484: fnd_file.put_line(fnd_file.log, 'rec.treasury_acct_code '|| rec.treasury_acct_code);

480: fnd_file.put_line(fnd_file.log, 'rec.star_main_acct '|| rec.star_main_acct);
481: fnd_file.put_line(fnd_file.log, 'rec.star_dept_xfer '|| rec.star_dept_xfer);
482: fnd_file.put_line(fnd_file.log, 'rec.sub '|| rec.sub);
483: fnd_file.put_line(fnd_file.log, 'rec.treasury_dept_code '|| rec.treasury_dept_code);
484: fnd_file.put_line(fnd_file.log, 'rec.treasury_acct_code '|| rec.treasury_acct_code);
485: fnd_file.put_line(fnd_file.log, 'rec.treasury_symbol_id '|| rec.treasury_symbol_id);
486: fnd_file.put_line(fnd_file.log, 'rec.aid '|| rec.aid);
487: fnd_file.put_line(fnd_file.log, 'rec.ata '|| rec.ata);
488:

Line 485: fnd_file.put_line(fnd_file.log, 'rec.treasury_symbol_id '|| rec.treasury_symbol_id);

481: fnd_file.put_line(fnd_file.log, 'rec.star_dept_xfer '|| rec.star_dept_xfer);
482: fnd_file.put_line(fnd_file.log, 'rec.sub '|| rec.sub);
483: fnd_file.put_line(fnd_file.log, 'rec.treasury_dept_code '|| rec.treasury_dept_code);
484: fnd_file.put_line(fnd_file.log, 'rec.treasury_acct_code '|| rec.treasury_acct_code);
485: fnd_file.put_line(fnd_file.log, 'rec.treasury_symbol_id '|| rec.treasury_symbol_id);
486: fnd_file.put_line(fnd_file.log, 'rec.aid '|| rec.aid);
487: fnd_file.put_line(fnd_file.log, 'rec.ata '|| rec.ata);
488:
489: l_UPDATE_fed_tas:= TRUE;

Line 486: fnd_file.put_line(fnd_file.log, 'rec.aid '|| rec.aid);

482: fnd_file.put_line(fnd_file.log, 'rec.sub '|| rec.sub);
483: fnd_file.put_line(fnd_file.log, 'rec.treasury_dept_code '|| rec.treasury_dept_code);
484: fnd_file.put_line(fnd_file.log, 'rec.treasury_acct_code '|| rec.treasury_acct_code);
485: fnd_file.put_line(fnd_file.log, 'rec.treasury_symbol_id '|| rec.treasury_symbol_id);
486: fnd_file.put_line(fnd_file.log, 'rec.aid '|| rec.aid);
487: fnd_file.put_line(fnd_file.log, 'rec.ata '|| rec.ata);
488:
489: l_UPDATE_fed_tas:= TRUE;
490:

Line 487: fnd_file.put_line(fnd_file.log, 'rec.ata '|| rec.ata);

483: fnd_file.put_line(fnd_file.log, 'rec.treasury_dept_code '|| rec.treasury_dept_code);
484: fnd_file.put_line(fnd_file.log, 'rec.treasury_acct_code '|| rec.treasury_acct_code);
485: fnd_file.put_line(fnd_file.log, 'rec.treasury_symbol_id '|| rec.treasury_symbol_id);
486: fnd_file.put_line(fnd_file.log, 'rec.aid '|| rec.aid);
487: fnd_file.put_line(fnd_file.log, 'rec.ata '|| rec.ata);
488:
489: l_UPDATE_fed_tas:= TRUE;
490:
491: IF rec.star_dept_xfer IS NOT NULL THEN

Line 574: fnd_file.put_line(fnd_file.log,SQLERRM);

570: sysdate,
571: fnd_global.user_id);
572: EXCEPTION
573: WHEN OTHERS THEN
574: fnd_file.put_line(fnd_file.log,SQLERRM);
575: END;
576:
577: UPDATE fv_treasury_symbols
578: SET department_id = rec.aid,

Line 627: fnd_file.put_line(fnd_file.log, 'Updating fv_facts_federal_accounts with new agency id');

623: END IF;
624: END IF;
625: END LOOP;
626:
627: fnd_file.put_line(fnd_file.log, 'Updating fv_facts_federal_accounts with new agency id');
628: fnd_file.put_line(fnd_file.log, 'Updating fv_treasury_symbols with new allocation transfer agency id');
629: fnd_file.put_line(fnd_file.log, 'Updated: '||SQL%ROWCOUNT||' rows.');
630:
631: EXCEPTION WHEN OTHERS THEN

Line 628: fnd_file.put_line(fnd_file.log, 'Updating fv_treasury_symbols with new allocation transfer agency id');

624: END IF;
625: END LOOP;
626:
627: fnd_file.put_line(fnd_file.log, 'Updating fv_facts_federal_accounts with new agency id');
628: fnd_file.put_line(fnd_file.log, 'Updating fv_treasury_symbols with new allocation transfer agency id');
629: fnd_file.put_line(fnd_file.log, 'Updated: '||SQL%ROWCOUNT||' rows.');
630:
631: EXCEPTION WHEN OTHERS THEN
632: g_err_buff := 'When OTHERS ERROR in upgrade_fed_accounts_agency_id: '||sqlerrm;

Line 629: fnd_file.put_line(fnd_file.log, 'Updated: '||SQL%ROWCOUNT||' rows.');

625: END LOOP;
626:
627: fnd_file.put_line(fnd_file.log, 'Updating fv_facts_federal_accounts with new agency id');
628: fnd_file.put_line(fnd_file.log, 'Updating fv_treasury_symbols with new allocation transfer agency id');
629: fnd_file.put_line(fnd_file.log, 'Updated: '||SQL%ROWCOUNT||' rows.');
630:
631: EXCEPTION WHEN OTHERS THEN
632: g_err_buff := 'When OTHERS ERROR in upgrade_fed_accounts_agency_id: '||sqlerrm;
633: g_err_code := sqlcode;

Line 642: fnd_file.put_line(fnd_file.log, 'Deleted all records FROM fv_facts_bud_fed_accts AND fv_facts_budget_accounts');

638: BEGIN
639: DELETE FROM fv_facts_bud_fed_accts;
640: DELETE FROM fv_facts_budget_accounts;
641:
642: fnd_file.put_line(fnd_file.log, 'Deleted all records FROM fv_facts_bud_fed_accts AND fv_facts_budget_accounts');
643: EXCEPTION
644: WHEN OTHERS THEN
645: g_err_buff := 'When Others Error: '||SQLERRM;
646: g_err_code := sqlcode;

Line 652: fnd_file.put_line(fnd_file.log, 'Updating Fed Non-Fed Code in ap_suppliers.');

648: -----------------------------------------------------------------------------------
649: --Update ap_suppliers.global_attribute4 (which is fed nonfed code GDF)
650: PROCEDURE UPGRADE_FEDNONFED_CODE IS
651: BEGIN
652: fnd_file.put_line(fnd_file.log, 'Updating Fed Non-Fed Code in ap_suppliers.');
653:
654: UPDATE ap_suppliers
655: SET global_attribute4 = 'F',
656: global_attribute_category = 'FV.US.APXVDMVD.GTAS_DATA',

Line 667: fnd_file.put_line(fnd_file.log, 'Updated Fed Non-Fed Code in ap_suppliers.');

663: global_attribute20 = 1
664: WHERE vendor_type_lookup_code <> 'FEDERAL'
665: AND global_attribute_category IS NULL;
666:
667: fnd_file.put_line(fnd_file.log, 'Updated Fed Non-Fed Code in ap_suppliers.');
668:
669: EXCEPTION
670: WHEN OTHERS THEN
671: g_err_buff := 'When Others Error: '||SQLERRM;

Line 701: FND_FILE.PUT_LINE(FND_FILE.LOG,

697: SET fund_category = 'E'
698: WHERE fund_category = 'C';
699: EXCEPTION
700: WHEN OTHERS THEN
701: FND_FILE.PUT_LINE(FND_FILE.LOG,
702: 'When others error: '||l_module||' Fund Category upgrade'||' '||SQLERRM);
703: END;
704: -- 2) Upgrade Fund Type in Define Treasury Account Symbols form
705: BEGIN

Line 716: FND_FILE.PUT_LINE(FND_FILE.LOG,

712: AND (receipt_account_indicator = 'N' OR
713: receipt_account_indicator IS NULL);
714: EXCEPTION
715: WHEN OTHERS THEN
716: FND_FILE.PUT_LINE(FND_FILE.LOG,
717: 'When others error: '||l_module||' F Fund Type 1 upgrade'||' '||SQLERRM);
718: END;
719:
720: BEGIN

Line 728: FND_FILE.PUT_LINE(FND_FILE.LOG,

724: fund_group_code BETWEEN 3600 AND 3799)
725: AND receipt_account_indicator = 'Y';
726: EXCEPTION
727: WHEN OTHERS THEN
728: FND_FILE.PUT_LINE(FND_FILE.LOG,
729: 'When others error: '||l_module||' Fund Type 2 upgrade'||' '||SQLERRM);
730: END;
731:
732: BEGIN

Line 739: FND_FILE.PUT_LINE(FND_FILE.LOG,

735: WHERE fund_group_code BETWEEN 5000 AND 5999
736: AND (receipt_account_indicator = 'N' OR receipt_account_indicator IS NULL);
737: EXCEPTION
738: WHEN OTHERS THEN
739: FND_FILE.PUT_LINE(FND_FILE.LOG,
740: 'When others error: '||l_module||' Fund Type 3 upgrade'||' '||SQLERRM);
741: END;
742:
743: BEGIN

Line 750: FND_FILE.PUT_LINE(FND_FILE.LOG,

746: WHERE fund_group_code BETWEEN 5000 AND 5999
747: AND receipt_account_indicator = 'Y';
748: EXCEPTION
749: WHEN OTHERS THEN
750: FND_FILE.PUT_LINE(FND_FILE.LOG,
751: 'When others error: '||l_module||' Fund Type 4 upgrade'||' '||SQLERRM);
752: END;
753:
754: BEGIN

Line 760: FND_FILE.PUT_LINE(FND_FILE.LOG,

756: SET fund_type = 'EP'
757: WHERE fund_group_code BETWEEN 4000 AND 4499;
758: EXCEPTION
759: WHEN OTHERS THEN
760: FND_FILE.PUT_LINE(FND_FILE.LOG,
761: 'When others error: '||l_module||' Fund Type 5 upgrade'||' '||SQLERRM);
762: END;
763:
764: BEGIN

Line 770: FND_FILE.PUT_LINE(FND_FILE.LOG,

766: SET fund_type = 'ER'
767: WHERE fund_group_code BETWEEN 4500 AND 4999;
768: EXCEPTION
769: WHEN OTHERS THEN
770: FND_FILE.PUT_LINE(FND_FILE.LOG,
771: 'When others error: '||l_module||' Fund Type 6 upgrade'||' '||SQLERRM);
772: END;
773:
774: BEGIN

Line 780: FND_FILE.PUT_LINE(FND_FILE.LOG,

776: SET fund_type = 'EM'
777: WHERE fund_group_code BETWEEN 3900 AND 3959;
778: EXCEPTION
779: WHEN OTHERS THEN
780: FND_FILE.PUT_LINE(FND_FILE.LOG,
781: 'When others error: '||l_module||' Fund Type 7 upgrade'||' '||SQLERRM);
782: END;
783:
784: BEGIN

Line 790: FND_FILE.PUT_LINE(FND_FILE.LOG,

786: SET fund_type = 'EC'
787: WHERE fund_group_code BETWEEN 3960 AND 3999;
788: EXCEPTION
789: WHEN OTHERS THEN
790: FND_FILE.PUT_LINE(FND_FILE.LOG,
791: 'When others error: '||l_module||' Fund Type 8 upgrade'||' '||SQLERRM);
792: END;
793:
794: BEGIN

Line 800: FND_FILE.PUT_LINE(FND_FILE.LOG,

796: SET fund_type = 'DF'
797: WHERE fund_group_code BETWEEN 6000 AND 6999;
798: EXCEPTION
799: WHEN OTHERS THEN
800: FND_FILE.PUT_LINE(FND_FILE.LOG,
801: 'When others error: '||l_module||' Fund Type 9 upgrade'||' '||SQLERRM);
802: END;
803:
804: BEGIN

Line 812: FND_FILE.PUT_LINE(FND_FILE.LOG,

808: OR (fund_group_code BETWEEN 8500 AND 8999)
809: AND (receipt_account_indicator = 'N' OR receipt_account_indicator IS NULL);
810: EXCEPTION
811: WHEN OTHERS THEN
812: FND_FILE.PUT_LINE(FND_FILE.LOG,
813: 'When others error: '||l_module||' Fund Type 10 upgrade'||' '||SQLERRM);
814: END;
815:
816: BEGIN

Line 824: FND_FILE.PUT_LINE(FND_FILE.LOG,

820: OR (fund_group_code BETWEEN 8500 AND 8999)
821: AND receipt_account_indicator = 'Y';
822: EXCEPTION
823: WHEN OTHERS THEN
824: FND_FILE.PUT_LINE(FND_FILE.LOG,
825: 'When others error: '||l_module||' Fund Type 11 upgrade'||' '||SQLERRM);
826: END;
827:
828: BEGIN

Line 834: FND_FILE.PUT_LINE(FND_FILE.LOG,

830: SET fund_type = 'TR'
831: WHERE fund_group_code BETWEEN 8400 AND 8499;
832: EXCEPTION
833: WHEN OTHERS THEN
834: FND_FILE.PUT_LINE(FND_FILE.LOG,
835: 'When others error: '||l_module||' Fund Type 12 upgrade'||' '||SQLERRM);
836: END;
837:
838: BEGIN

Line 845: FND_FILE.PUT_LINE(FND_FILE.LOG,

841: WHERE (fund_group_code BETWEEN 3500 AND 3599 OR
842: fund_group_code BETWEEN 3800 AND 3899);
843: EXCEPTION
844: WHEN OTHERS THEN
845: FND_FILE.PUT_LINE(FND_FILE.LOG,
846: 'When others error: '||l_module||' Fund Type 13 upgrade'||' '||SQLERRM);
847: END;
848:
849: EXCEPTION

Line 851: FND_FILE.PUT_LINE(FND_FILE.LOG,

847: END;
848:
849: EXCEPTION
850: WHEN OTHERS THEN
851: FND_FILE.PUT_LINE(FND_FILE.LOG,
852: 'When others error: '||l_module||'Fund Group Upgrade'||' '||SQLERRM);
853: END;
854:
855: -- Add treasury_symbol_id to all the treasury symbols, without id, defined in

Line 887: FND_FILE.PUT_LINE(FND_FILE.LOG,

883:
884: END LOOP;
885: EXCEPTION
886: WHEN NO_DATA_FOUND THEN
887: FND_FILE.PUT_LINE(FND_FILE.LOG,
888: 'When NO_DATA_FOUND error: '||l_module||
889: 'Trading Partner - Treasury Symbol Id addition'||' '||SQLERRM);
890:
891: WHEN OTHERS THEN

Line 892: FND_FILE.PUT_LINE(FND_FILE.LOG,

888: 'When NO_DATA_FOUND error: '||l_module||
889: 'Trading Partner - Treasury Symbol Id addition'||' '||SQLERRM);
890:
891: WHEN OTHERS THEN
892: FND_FILE.PUT_LINE(FND_FILE.LOG,
893: 'When others error: '||l_module||'Trading Partner - Treasury Symbol Id addition'||' '||SQLERRM);
894:
895: END;
896:

Line 983: FND_FILE.PUT_LINE(FND_FILE.LOG,

979: ' migrated succesfully');
980: END LOOP;
981: EXCEPTION
982: WHEN NO_DATA_FOUND THEN
983: FND_FILE.PUT_LINE(FND_FILE.LOG,
984: 'When NO_DATA_FOUND error: '||l_module||
985: 'Trading Partner BETC Mappings Migration'||' '||SQLERRM);
986:
987: WHEN OTHERS THEN

Line 988: FND_FILE.PUT_LINE(FND_FILE.LOG,

984: 'When NO_DATA_FOUND error: '||l_module||
985: 'Trading Partner BETC Mappings Migration'||' '||SQLERRM);
986:
987: WHEN OTHERS THEN
988: FND_FILE.PUT_LINE(FND_FILE.LOG,
989: 'When others error: '||l_module||
990: 'Trading Partner BETC Mappings Migration'||' '||SQLERRM);
991: END;
992:

Line 1020: FND_FILE.PUT_LINE(FND_FILE.LOG,

1016: fund_group_code BETWEEN 3600 AND 3799);
1017:
1018: EXCEPTION
1019: WHEN OTHERS THEN
1020: FND_FILE.PUT_LINE(FND_FILE.LOG,
1021: 'When others error: '||l_module||
1022: 'Availability Type and Authority Duration Code Upgrade'||
1023: ' '||SQLERRM);
1024: END;

Line 1034: FND_FILE.PUT_LINE(FND_FILE.LOG,

1030: SET outlays_bea_category_code = bea_category
1031: WHERE outlays_bea_category_code IS NULL;
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: FND_FILE.PUT_LINE(FND_FILE.LOG,
1035: 'When others error: '||l_module||
1036: 'Outlays BEA Category Code upgrade '||' '||SQLERRM);
1037: END;
1038:

Line 1046: FND_FILE.PUT_LINE(FND_FILE.LOG,

1042: SET gtas_reportable_indicator ='Y'
1043: WHERE FACTS_REPORTABLE_INDICATOR IS NOT NULL;
1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: FND_FILE.PUT_LINE(FND_FILE.LOG,
1047: 'When others error: '||l_module||
1048: 'GTAS Reportable Indicator upgrade '||' '||SQLERRM);
1049: END;
1050:

Line 1057: FND_FILE.PUT_LINE(FND_FILE.LOG,

1053: DELETE FROM fv_facts_bud_fed_accts;
1054: DELETE FROM fv_facts_budget_accounts;
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: FND_FILE.PUT_LINE(FND_FILE.LOG,
1058: 'When others error: '||l_module||
1059: 'Budget Codes Table upgrade '||' '||SQLERRM);
1060: END;
1061:

Line 1068: FND_FILE.PUT_LINE(FND_FILE.LOG,'When others error: '||

1064:
1065: COMMIT;
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: FND_FILE.PUT_LINE(FND_FILE.LOG,'When others error: '||
1069: l_module||' '||SQLERRM);
1070: END;
1071: --------------------------------------------------------------------------------
1072: PROCEDURE LOG

Line 1122: FND_FILE.PUT_LINE(FND_FILE.LOG,'This event has already been run!');

1118: p_module_name =>l_module_name
1119: );
1120:
1121: ELSE
1122: FND_FILE.PUT_LINE(FND_FILE.LOG,'This event has already been run!');
1123: END IF;
1124:
1125: log(l_module, 'End');
1126: