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.JL_AR_AUTOINV_PKG dependencies on ARP_FILE

Line 57: arp_file.write_log('inside update_batch_source',0);

53: nvl(p_ship_date_to,nvl(ship_date_actual,sysdate)))
54: OR (p_ship_date_from is null and p_ship_date_to is null
55: and ship_date_actual is null));
56: BEGIN
57: arp_file.write_log('inside update_batch_source',0);
58: FOR trx_lines_rec IN
59: trx_lines(p_invoice_date_from, p_invoice_date_to,
60: p_gl_date_from, p_gl_date_to,
61: p_ship_date_from, p_ship_date_to)

Line 64: arp_file.write_log('Processing interface line '||

60: p_gl_date_from, p_gl_date_to,
61: p_ship_date_from, p_ship_date_to)
62: LOOP
63:
64: arp_file.write_log('Processing interface line '||
65: trx_lines_rec.interface_line_attribute1,0);
66:
67: l_contributor_class_code := null;
68: l_organization_class_code := null;

Line 84: arp_file.write_log('Contributor class code '||l_contributor_class_code);

80: SELECT ra.global_attribute8
81: INTO l_contributor_class_code
82: FROM hz_cust_acct_sites ra
83: WHERE ra.cust_acct_site_id = trx_lines_rec.orig_system_address_id;
84: arp_file.write_log('Contributor class code '||l_contributor_class_code);
85:
86: EXCEPTION WHEN NO_DATA_FOUND THEN
87: arp_file.write_log('Address Id invalid '||
88: trx_lines_rec.orig_system_address_id,0);

Line 87: arp_file.write_log('Address Id invalid '||

83: WHERE ra.cust_acct_site_id = trx_lines_rec.orig_system_address_id;
84: arp_file.write_log('Contributor class code '||l_contributor_class_code);
85:
86: EXCEPTION WHEN NO_DATA_FOUND THEN
87: arp_file.write_log('Address Id invalid '||
88: trx_lines_rec.orig_system_address_id,0);
89: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
90: 'JL_ZZ_AR_INVALID_ADDRESS',
91: trx_lines_rec.interface_line_attribute1,

Line 117: arp_file.write_log('Organization class code '||l_organization_class_code,0);

113: hr_organization_units hrou
114: WHERE hrou.organization_id = l_so_org_id
115: AND hrl.location_id = hrou.location_id;
116:
117: arp_file.write_log('Organization class code '||l_organization_class_code,0);
118:
119: EXCEPTION WHEN NO_DATA_FOUND THEN
120: arp_file.write_log('Inv Org Id invalid '|| l_so_org_id,0);
121: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

Line 120: arp_file.write_log('Inv Org Id invalid '|| l_so_org_id,0);

116:
117: arp_file.write_log('Organization class code '||l_organization_class_code,0);
118:
119: EXCEPTION WHEN NO_DATA_FOUND THEN
120: arp_file.write_log('Inv Org Id invalid '|| l_so_org_id,0);
121: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
122: 'JL_AR_AR_INVALID_ORGANIZATION',
123: trx_lines_rec.interface_line_attribute1,
124: 'JLERRUBS') THEN

Line 145: arp_file.write_log('Document letter not set up',0);

141: INTO l_tax_category_id
142: FROM jl_ar_ar_doc_letter;
143:
144: EXCEPTION WHEN NO_DATA_FOUND THEN
145: arp_file.write_log('Document letter not set up',0);
146: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
147: 'JL_AR_AR_DOC_LET_NOT_FOUND ',
148: trx_lines_rec.interface_line_attribute1,
149: 'JLERRUBS') THEN

Line 167: arp_file.write_log('Organization condition '||l_org_attribute_name,0);

163: AND cls.tax_category_id = l_tax_category_id
164: AND cls.tax_category_id = cat.tax_category_id
165: AND cls.tax_attribute_name = cat.org_tax_attribute;
166:
167: arp_file.write_log('Organization condition '||l_org_attribute_name,0);
168: arp_file.write_log('Organization condition value '||l_org_attribute_value,0);
169:
170: EXCEPTION WHEN NO_DATA_FOUND THEN
171: arp_file.write_log('Organization attributes not found',0);

Line 168: arp_file.write_log('Organization condition value '||l_org_attribute_value,0);

164: AND cls.tax_category_id = cat.tax_category_id
165: AND cls.tax_attribute_name = cat.org_tax_attribute;
166:
167: arp_file.write_log('Organization condition '||l_org_attribute_name,0);
168: arp_file.write_log('Organization condition value '||l_org_attribute_value,0);
169:
170: EXCEPTION WHEN NO_DATA_FOUND THEN
171: arp_file.write_log('Organization attributes not found',0);
172: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

Line 171: arp_file.write_log('Organization attributes not found',0);

167: arp_file.write_log('Organization condition '||l_org_attribute_name,0);
168: arp_file.write_log('Organization condition value '||l_org_attribute_value,0);
169:
170: EXCEPTION WHEN NO_DATA_FOUND THEN
171: arp_file.write_log('Organization attributes not found',0);
172: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
173: 'JL_AR_AR_AI_ATT_CLS_NOT_DEF',
174: trx_lines_rec.interface_line_attribute1,
175: 'JLERRUBS') THEN

Line 200: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);

196: AND cus.tax_category_id = l_tax_category_id
197: AND cus.tax_category_id = cat.tax_category_id
198: AND cus.tax_attribute_name = cat.cus_tax_attribute;
199:
200: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);
201: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
202:
203: EXCEPTION WHEN NO_DATA_FOUND THEN
204: arp_file.write_log('Contributor condition not found ',0);

Line 201: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);

197: AND cus.tax_category_id = cat.tax_category_id
198: AND cus.tax_attribute_name = cat.cus_tax_attribute;
199:
200: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);
201: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
202:
203: EXCEPTION WHEN NO_DATA_FOUND THEN
204: arp_file.write_log('Contributor condition not found ',0);
205: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

Line 204: arp_file.write_log('Contributor condition not found ',0);

200: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);
201: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
202:
203: EXCEPTION WHEN NO_DATA_FOUND THEN
204: arp_file.write_log('Contributor condition not found ',0);
205: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
206: 'JL_AR_AR_AI_CU_SIT_PRO_NOT_DEF',
207: trx_lines_rec.interface_line_attribute1,
208: 'JLERRUBS') THEN

Line 223: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);

219: AND att.tax_category_id = l_tax_category_id
220: AND att.tax_attribute_name = cat.cus_tax_attribute
221: AND att.tax_category_id = cat.tax_category_id;
222:
223: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);
224: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
225:
226: EXCEPTION WHEN NO_DATA_FOUND THEN
227: arp_file.write_log('Contributor condition not found ',0);

Line 224: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);

220: AND att.tax_attribute_name = cat.cus_tax_attribute
221: AND att.tax_category_id = cat.tax_category_id;
222:
223: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);
224: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
225:
226: EXCEPTION WHEN NO_DATA_FOUND THEN
227: arp_file.write_log('Contributor condition not found ',0);
228: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

Line 227: arp_file.write_log('Contributor condition not found ',0);

223: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);
224: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
225:
226: EXCEPTION WHEN NO_DATA_FOUND THEN
227: arp_file.write_log('Contributor condition not found ',0);
228: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
229: 'JL_AR_AR_AI_CU_SIT_PRO_NOT_DEF',
230: trx_lines_rec.interface_line_attribute1,
231: 'JLERRUBS') THEN

Line 253: arp_file.write_log('Document letter is '||l_document_letter,0);

249: AND org_tax_attribute_value = l_org_attribute_value
250: AND con_tax_attribute_name = l_cust_attribute_name
251: AND con_tax_attribute_value = l_cust_attribute_value
252: AND nvl(trx_lines_rec.trx_date, p_default_date) BETWEEN start_date_active AND end_date_active;
253: arp_file.write_log('Document letter is '||l_document_letter,0);
254:
255: EXCEPTION WHEN NO_DATA_FOUND THEN
256: arp_file.write_log('Document letter not found ',0);
257: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

Line 256: arp_file.write_log('Document letter not found ',0);

252: AND nvl(trx_lines_rec.trx_date, p_default_date) BETWEEN start_date_active AND end_date_active;
253: arp_file.write_log('Document letter is '||l_document_letter,0);
254:
255: EXCEPTION WHEN NO_DATA_FOUND THEN
256: arp_file.write_log('Document letter not found ',0);
257: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
258: 'JL_AR_AR_DOC_LET_NOT_FOUND',
259: trx_lines_rec.interface_line_attribute1,
260: 'JLERRUBS') THEN

Line 277: arp_file.write_log('Correct Batch source id is '||l_batch_source_id,0);

273: AND ty.batch_source_id = src.batch_source_id
274: AND src.global_attribute3 = l_document_letter
275: AND ty.enable_flag = 'Y';
276:
277: arp_file.write_log('Correct Batch source id is '||l_batch_source_id,0);
278:
279: EXCEPTION WHEN NO_DATA_FOUND THEN
280: arp_file.write_log('Batch source not found',0);
281: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',

Line 280: arp_file.write_log('Batch source not found',0);

276:
277: arp_file.write_log('Correct Batch source id is '||l_batch_source_id,0);
278:
279: EXCEPTION WHEN NO_DATA_FOUND THEN
280: arp_file.write_log('Batch source not found',0);
281: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
282: 'JL_AR_AR_BT_SRC_NOT_FOUND',
283: trx_lines_rec.interface_line_attribute1,
284: 'JLERRUBS') THEN

Line 288: arp_file.write_log('More than one batch source found',0);

284: 'JLERRUBS') THEN
285: RAISE error_condition;
286: END IF;
287: WHEN TOO_MANY_ROWS THEN
288: arp_file.write_log('More than one batch source found',0);
289: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message ('JL',
290: 'JL_AR_AR_BT_SRC_MORE_FOUND',
291: trx_lines_rec.interface_line_attribute1,
292: 'JLERRUBS') THEN

Line 319: arp_file.write_log('Updated old batch source '||trx_lines_rec.batch_source_name ||

315: 'Original batch source : '||trx_lines_rec.batch_source_name||
316: 'is updated with new batch source :'||l_new_batch_source_name,
317: 'JLUPDUBS',
318: trx_lines_rec.org_id);
319: arp_file.write_log('Updated old batch source '||trx_lines_rec.batch_source_name ||
320: 'to '|| l_new_batch_source_name,0);
321: END IF;
322:
323: END LOOP;

Line 328: arp_file.write_log(sqlerrm,0);

324: COMMIT;
325:
326: EXCEPTION
327: WHEN OTHERS THEN
328: arp_file.write_log(sqlerrm,0);
329: END;
330:
331: PROCEDURE JL_AR_AR_UPDATE_BATCH_SOURCE (
332: errbuf OUT NOCOPY varchar2,

Line 350: arp_file.write_log('Calling Update Batch source',0);

346: p_low_invoice_dt DATE;
347: p_high_invoice_dt DATE;
348: p_default_dt DATE;
349: BEGIN
350: arp_file.write_log('Calling Update Batch source',0);
351:
352: p_low_gl_dt := fnd_date.canonical_to_date(p_low_gl_date);
353: p_high_gl_dt := fnd_date.canonical_to_date(p_high_gl_date);
354: p_low_ship_dt := fnd_date.canonical_to_date(p_low_ship_date);

Line 360: arp_file.write_log('low gl'||p_low_gl_date,0);

356: p_low_invoice_dt := fnd_date.canonical_to_date(p_low_invoice_date);
357: p_high_invoice_dt := fnd_date.canonical_to_date(p_high_invoice_date);
358: p_default_dt := fnd_date.canonical_to_date(p_default_date);
359:
360: arp_file.write_log('low gl'||p_low_gl_date,0);
361: arp_file.write_log('high gl'||p_high_gl_date,0);
362: arp_file.write_log('l ship'||p_low_ship_date,0);
363: arp_file.write_log('h ship'||p_high_ship_date,0);
364: arp_file.write_log('l invoice'||p_low_invoice_date,0);

Line 361: arp_file.write_log('high gl'||p_high_gl_date,0);

357: p_high_invoice_dt := fnd_date.canonical_to_date(p_high_invoice_date);
358: p_default_dt := fnd_date.canonical_to_date(p_default_date);
359:
360: arp_file.write_log('low gl'||p_low_gl_date,0);
361: arp_file.write_log('high gl'||p_high_gl_date,0);
362: arp_file.write_log('l ship'||p_low_ship_date,0);
363: arp_file.write_log('h ship'||p_high_ship_date,0);
364: arp_file.write_log('l invoice'||p_low_invoice_date,0);
365: arp_file.write_log('h invoice'||p_high_invoice_date,0);

Line 362: arp_file.write_log('l ship'||p_low_ship_date,0);

358: p_default_dt := fnd_date.canonical_to_date(p_default_date);
359:
360: arp_file.write_log('low gl'||p_low_gl_date,0);
361: arp_file.write_log('high gl'||p_high_gl_date,0);
362: arp_file.write_log('l ship'||p_low_ship_date,0);
363: arp_file.write_log('h ship'||p_high_ship_date,0);
364: arp_file.write_log('l invoice'||p_low_invoice_date,0);
365: arp_file.write_log('h invoice'||p_high_invoice_date,0);
366: arp_file.write_log('default'||p_default_date,0);

Line 363: arp_file.write_log('h ship'||p_high_ship_date,0);

359:
360: arp_file.write_log('low gl'||p_low_gl_date,0);
361: arp_file.write_log('high gl'||p_high_gl_date,0);
362: arp_file.write_log('l ship'||p_low_ship_date,0);
363: arp_file.write_log('h ship'||p_high_ship_date,0);
364: arp_file.write_log('l invoice'||p_low_invoice_date,0);
365: arp_file.write_log('h invoice'||p_high_invoice_date,0);
366: arp_file.write_log('default'||p_default_date,0);
367:

Line 364: arp_file.write_log('l invoice'||p_low_invoice_date,0);

360: arp_file.write_log('low gl'||p_low_gl_date,0);
361: arp_file.write_log('high gl'||p_high_gl_date,0);
362: arp_file.write_log('l ship'||p_low_ship_date,0);
363: arp_file.write_log('h ship'||p_high_ship_date,0);
364: arp_file.write_log('l invoice'||p_low_invoice_date,0);
365: arp_file.write_log('h invoice'||p_high_invoice_date,0);
366: arp_file.write_log('default'||p_default_date,0);
367:
368: UPDATE_BATCH_SOURCE(p_low_invoice_dt, p_high_invoice_dt,

Line 365: arp_file.write_log('h invoice'||p_high_invoice_date,0);

361: arp_file.write_log('high gl'||p_high_gl_date,0);
362: arp_file.write_log('l ship'||p_low_ship_date,0);
363: arp_file.write_log('h ship'||p_high_ship_date,0);
364: arp_file.write_log('l invoice'||p_low_invoice_date,0);
365: arp_file.write_log('h invoice'||p_high_invoice_date,0);
366: arp_file.write_log('default'||p_default_date,0);
367:
368: UPDATE_BATCH_SOURCE(p_low_invoice_dt, p_high_invoice_dt,
369: p_low_gl_dt, p_high_gl_dt,

Line 366: arp_file.write_log('default'||p_default_date,0);

362: arp_file.write_log('l ship'||p_low_ship_date,0);
363: arp_file.write_log('h ship'||p_high_ship_date,0);
364: arp_file.write_log('l invoice'||p_low_invoice_date,0);
365: arp_file.write_log('h invoice'||p_high_invoice_date,0);
366: arp_file.write_log('default'||p_default_date,0);
367:
368: UPDATE_BATCH_SOURCE(p_low_invoice_dt, p_high_invoice_dt,
369: p_low_gl_dt, p_high_gl_dt,
370: p_low_ship_dt, p_high_ship_dt, p_default_dt);

Line 372: arp_file.write_log('After update batch source');

368: UPDATE_BATCH_SOURCE(p_low_invoice_dt, p_high_invoice_dt,
369: p_low_gl_dt, p_high_gl_dt,
370: p_low_ship_dt, p_high_ship_dt, p_default_dt);
371:
372: arp_file.write_log('After update batch source');
373: -- Call to the Batch Source Update error report
374: X_req_id := FND_REQUEST.SUBMIT_REQUEST(
375: 'JL' ,
376: 'JLARRERR',

Line 382: arp_file.write_log(sqlerrm,0);

378: SYSDATE,
379: FALSE);
380: EXCEPTION
381: WHEN OTHERS THEN
382: arp_file.write_log(sqlerrm,0);
383:
384: END JL_AR_AR_UPDATE_BATCH_SOURCE;
385:
386:

Line 429: arp_file.write_log('JL Submitting Autoinvoice',0);

425: message VARCHAR2(240);
426: l_org_id NUMBER;
427:
428: BEGIN
429: arp_file.write_log('JL Submitting Autoinvoice',0);
430:
431: -- Bug#7642995 Start
432: l_org_id := mo_global.get_current_org_id;
433:

Line 434: arp_file.write_log(l_org_id,0);

430:
431: -- Bug#7642995 Start
432: l_org_id := mo_global.get_current_org_id;
433:
434: arp_file.write_log(l_org_id,0);
435:
436: fnd_request.set_org_id(l_org_id);
437:
438: -- Bug#7642995 End