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_message1 ('JL',
90: 'JL_ZZ_AR_INVALID_ADDRESS',
91: trx_lines_rec.interface_line_attribute1,

Line 110: arp_file.write_log('Master Org='||l_so_org_id,0);

106: l_org_id := mo_global.get_current_org_id;
107: l_so_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_org_id);
108:
109: -- Bug 16471013 - Start
110: arp_file.write_log('Master Org='||l_so_org_id,0);
111: arp_file.write_log('Current Org='||l_org_id,0);
112: arp_file.write_log('Interface Org='||trx_lines_rec.org_id,0);
113: arp_file.write_log('Searching for Org Class Code in Org_ID='||trx_lines_rec.org_id,0);
114:

Line 111: arp_file.write_log('Current Org='||l_org_id,0);

107: l_so_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_org_id);
108:
109: -- Bug 16471013 - Start
110: arp_file.write_log('Master Org='||l_so_org_id,0);
111: arp_file.write_log('Current Org='||l_org_id,0);
112: arp_file.write_log('Interface Org='||trx_lines_rec.org_id,0);
113: arp_file.write_log('Searching for Org Class Code in Org_ID='||trx_lines_rec.org_id,0);
114:
115:

Line 112: arp_file.write_log('Interface Org='||trx_lines_rec.org_id,0);

108:
109: -- Bug 16471013 - Start
110: arp_file.write_log('Master Org='||l_so_org_id,0);
111: arp_file.write_log('Current Org='||l_org_id,0);
112: arp_file.write_log('Interface Org='||trx_lines_rec.org_id,0);
113: arp_file.write_log('Searching for Org Class Code in Org_ID='||trx_lines_rec.org_id,0);
114:
115:
116: BEGIN

Line 113: arp_file.write_log('Searching for Org Class Code in Org_ID='||trx_lines_rec.org_id,0);

109: -- Bug 16471013 - Start
110: arp_file.write_log('Master Org='||l_so_org_id,0);
111: arp_file.write_log('Current Org='||l_org_id,0);
112: arp_file.write_log('Interface Org='||trx_lines_rec.org_id,0);
113: arp_file.write_log('Searching for Org Class Code in Org_ID='||trx_lines_rec.org_id,0);
114:
115:
116: BEGIN
117: SELECT hrl.global_attribute1

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

120: hr_organization_units hrou
121: WHERE hrou.organization_id = trx_lines_rec.org_id
122: AND hrl.location_id = hrou.location_id;
123:
124: arp_file.write_log('Organization class code '||l_organization_class_code,0);
125:
126: EXCEPTION WHEN NO_DATA_FOUND THEN
127: arp_file.write_log('No Org Class Code for ORG_ID '|| trx_lines_rec.org_id,0);
128: END;

Line 127: arp_file.write_log('No Org Class Code for ORG_ID '|| trx_lines_rec.org_id,0);

123:
124: arp_file.write_log('Organization class code '||l_organization_class_code,0);
125:
126: EXCEPTION WHEN NO_DATA_FOUND THEN
127: arp_file.write_log('No Org Class Code for ORG_ID '|| trx_lines_rec.org_id,0);
128: END;
129:
130: IF l_organization_class_code IS NULL THEN
131: arp_file.write_log('Searching for Org Class Code in Org_ID='||l_so_org_id,0);

Line 131: arp_file.write_log('Searching for Org Class Code in Org_ID='||l_so_org_id,0);

127: arp_file.write_log('No Org Class Code for ORG_ID '|| trx_lines_rec.org_id,0);
128: END;
129:
130: IF l_organization_class_code IS NULL THEN
131: arp_file.write_log('Searching for Org Class Code in Org_ID='||l_so_org_id,0);
132: BEGIN
133: SELECT hrl.global_attribute1
134: INTO l_organization_class_code
135: FROM hr_locations hrl,

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

136: hr_organization_units hrou
137: WHERE hrou.organization_id = l_so_org_id
138: AND hrl.location_id = hrou.location_id;
139:
140: arp_file.write_log('Organization class code '||l_organization_class_code,0);
141:
142: EXCEPTION WHEN NO_DATA_FOUND THEN
143: arp_file.write_log('No Org Class Code for SO_ORGANIZATION_ID '|| l_so_org_id,0);
144: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',

Line 143: arp_file.write_log('No Org Class Code for SO_ORGANIZATION_ID '|| l_so_org_id,0);

139:
140: arp_file.write_log('Organization class code '||l_organization_class_code,0);
141:
142: EXCEPTION WHEN NO_DATA_FOUND THEN
143: arp_file.write_log('No Org Class Code for SO_ORGANIZATION_ID '|| l_so_org_id,0);
144: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
145: 'JL_AR_AR_INVALID_ORGANIZATION',
146: trx_lines_rec.interface_line_attribute1,
147: 'JLERRUBS') THEN

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

166: INTO l_tax_category_id
167: FROM jl_ar_ar_doc_letter;
168:
169: EXCEPTION WHEN NO_DATA_FOUND THEN
170: arp_file.write_log('Document letter not set up',0);
171: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
172: 'JL_AR_AR_DOC_LET_NOT_FOUND ',
173: trx_lines_rec.interface_line_attribute1,
174: 'JLERRUBS') THEN

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

188: AND cls.tax_category_id = l_tax_category_id
189: AND cls.tax_category_id = cat.tax_category_id
190: AND cls.tax_attribute_name = cat.org_tax_attribute;
191:
192: arp_file.write_log('Organization condition '||l_org_attribute_name,0);
193: arp_file.write_log('Organization condition value '||l_org_attribute_value,0);
194:
195: EXCEPTION WHEN NO_DATA_FOUND THEN
196: arp_file.write_log('Organization attributes not found',0);

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

189: AND cls.tax_category_id = cat.tax_category_id
190: AND cls.tax_attribute_name = cat.org_tax_attribute;
191:
192: arp_file.write_log('Organization condition '||l_org_attribute_name,0);
193: arp_file.write_log('Organization condition value '||l_org_attribute_value,0);
194:
195: EXCEPTION WHEN NO_DATA_FOUND THEN
196: arp_file.write_log('Organization attributes not found',0);
197: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',

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

192: arp_file.write_log('Organization condition '||l_org_attribute_name,0);
193: arp_file.write_log('Organization condition value '||l_org_attribute_value,0);
194:
195: EXCEPTION WHEN NO_DATA_FOUND THEN
196: arp_file.write_log('Organization attributes not found',0);
197: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
198: 'JL_AR_AR_AI_ATT_CLS_NOT_DEF',
199: trx_lines_rec.interface_line_attribute1,
200: 'JLERRUBS') THEN

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

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

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

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

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

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

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

244: AND att.tax_category_id = l_tax_category_id
245: AND att.tax_attribute_name = cat.cus_tax_attribute
246: AND att.tax_category_id = cat.tax_category_id;
247:
248: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);
249: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
250:
251: EXCEPTION WHEN NO_DATA_FOUND THEN
252: arp_file.write_log('Contributor condition not found ',0);

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

245: AND att.tax_attribute_name = cat.cus_tax_attribute
246: AND att.tax_category_id = cat.tax_category_id;
247:
248: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);
249: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
250:
251: EXCEPTION WHEN NO_DATA_FOUND THEN
252: arp_file.write_log('Contributor condition not found ',0);
253: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',

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

248: arp_file.write_log('Contributor condition '||l_cust_attribute_name,0);
249: arp_file.write_log('Contributor condition value '||l_cust_attribute_value,0);
250:
251: EXCEPTION WHEN NO_DATA_FOUND THEN
252: arp_file.write_log('Contributor condition not found ',0);
253: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
254: 'JL_AR_AR_AI_CU_SIT_PRO_NOT_DEF',
255: trx_lines_rec.interface_line_attribute1,
256: 'JLERRUBS') THEN

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

274: AND org_tax_attribute_value = l_org_attribute_value
275: AND con_tax_attribute_name = l_cust_attribute_name
276: AND con_tax_attribute_value = l_cust_attribute_value
277: AND nvl(trx_lines_rec.trx_date, p_default_date) BETWEEN start_date_active AND end_date_active;
278: arp_file.write_log('Document letter is '||l_document_letter,0);
279:
280: EXCEPTION WHEN NO_DATA_FOUND THEN
281: arp_file.write_log('Document letter not found ',0);
282: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',

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

277: AND nvl(trx_lines_rec.trx_date, p_default_date) BETWEEN start_date_active AND end_date_active;
278: arp_file.write_log('Document letter is '||l_document_letter,0);
279:
280: EXCEPTION WHEN NO_DATA_FOUND THEN
281: arp_file.write_log('Document letter not found ',0);
282: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
283: 'JL_AR_AR_DOC_LET_NOT_FOUND',
284: trx_lines_rec.interface_line_attribute1,
285: 'JLERRUBS') THEN

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

298: AND ty.batch_source_id = src.batch_source_id
299: AND src.global_attribute3 = l_document_letter
300: AND ty.enable_flag = 'Y';
301:
302: arp_file.write_log('Correct Batch source id is '||l_batch_source_id,0);
303:
304: EXCEPTION WHEN NO_DATA_FOUND THEN
305: arp_file.write_log('Batch source not found',0);
306: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',

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

301:
302: arp_file.write_log('Correct Batch source id is '||l_batch_source_id,0);
303:
304: EXCEPTION WHEN NO_DATA_FOUND THEN
305: arp_file.write_log('Batch source not found',0);
306: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
307: 'JL_AR_AR_BT_SRC_NOT_FOUND',
308: trx_lines_rec.interface_line_attribute1,
309: 'JLERRUBS') THEN

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

309: 'JLERRUBS') THEN
310: RAISE error_condition;
311: END IF;
312: WHEN TOO_MANY_ROWS THEN
313: arp_file.write_log('More than one batch source found',0);
314: IF NOT JG_ZZ_AUTO_INVOICE.put_error_message1 ('JL',
315: 'JL_AR_AR_BT_SRC_MORE_FOUND',
316: trx_lines_rec.interface_line_attribute1,
317: 'JLERRUBS') THEN

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

340: 'Original batch source : '||trx_lines_rec.batch_source_name||
341: 'is updated with new batch source :'||l_new_batch_source_name,
342: 'JLUPDUBS',
343: trx_lines_rec.org_id);
344: arp_file.write_log('Updated old batch source '||trx_lines_rec.batch_source_name ||
345: 'to '|| l_new_batch_source_name,0);
346: END IF;
347:
348: END LOOP;

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

349: COMMIT;
350:
351: EXCEPTION
352: WHEN OTHERS THEN
353: arp_file.write_log(sqlerrm,0);
354: END;
355:
356: PROCEDURE JL_AR_AR_UPDATE_BATCH_SOURCE (
357: errbuf OUT NOCOPY varchar2,

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

371: p_low_invoice_dt DATE;
372: p_high_invoice_dt DATE;
373: p_default_dt DATE;
374: BEGIN
375: arp_file.write_log('Calling Update Batch source',0);
376:
377: p_low_gl_dt := fnd_date.canonical_to_date(p_low_gl_date);
378: p_high_gl_dt := fnd_date.canonical_to_date(p_high_gl_date);
379: p_low_ship_dt := fnd_date.canonical_to_date(p_low_ship_date);

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

381: p_low_invoice_dt := fnd_date.canonical_to_date(p_low_invoice_date);
382: p_high_invoice_dt := fnd_date.canonical_to_date(p_high_invoice_date);
383: p_default_dt := fnd_date.canonical_to_date(p_default_date);
384:
385: arp_file.write_log('low gl'||p_low_gl_date,0);
386: arp_file.write_log('high gl'||p_high_gl_date,0);
387: arp_file.write_log('l ship'||p_low_ship_date,0);
388: arp_file.write_log('h ship'||p_high_ship_date,0);
389: arp_file.write_log('l invoice'||p_low_invoice_date,0);

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

382: p_high_invoice_dt := fnd_date.canonical_to_date(p_high_invoice_date);
383: p_default_dt := fnd_date.canonical_to_date(p_default_date);
384:
385: arp_file.write_log('low gl'||p_low_gl_date,0);
386: arp_file.write_log('high gl'||p_high_gl_date,0);
387: arp_file.write_log('l ship'||p_low_ship_date,0);
388: arp_file.write_log('h ship'||p_high_ship_date,0);
389: arp_file.write_log('l invoice'||p_low_invoice_date,0);
390: arp_file.write_log('h invoice'||p_high_invoice_date,0);

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

383: p_default_dt := fnd_date.canonical_to_date(p_default_date);
384:
385: arp_file.write_log('low gl'||p_low_gl_date,0);
386: arp_file.write_log('high gl'||p_high_gl_date,0);
387: arp_file.write_log('l ship'||p_low_ship_date,0);
388: arp_file.write_log('h ship'||p_high_ship_date,0);
389: arp_file.write_log('l invoice'||p_low_invoice_date,0);
390: arp_file.write_log('h invoice'||p_high_invoice_date,0);
391: arp_file.write_log('default'||p_default_date,0);

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

384:
385: arp_file.write_log('low gl'||p_low_gl_date,0);
386: arp_file.write_log('high gl'||p_high_gl_date,0);
387: arp_file.write_log('l ship'||p_low_ship_date,0);
388: arp_file.write_log('h ship'||p_high_ship_date,0);
389: arp_file.write_log('l invoice'||p_low_invoice_date,0);
390: arp_file.write_log('h invoice'||p_high_invoice_date,0);
391: arp_file.write_log('default'||p_default_date,0);
392:

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

385: arp_file.write_log('low gl'||p_low_gl_date,0);
386: arp_file.write_log('high gl'||p_high_gl_date,0);
387: arp_file.write_log('l ship'||p_low_ship_date,0);
388: arp_file.write_log('h ship'||p_high_ship_date,0);
389: arp_file.write_log('l invoice'||p_low_invoice_date,0);
390: arp_file.write_log('h invoice'||p_high_invoice_date,0);
391: arp_file.write_log('default'||p_default_date,0);
392:
393: UPDATE_BATCH_SOURCE(p_low_invoice_dt, p_high_invoice_dt,

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

386: arp_file.write_log('high gl'||p_high_gl_date,0);
387: arp_file.write_log('l ship'||p_low_ship_date,0);
388: arp_file.write_log('h ship'||p_high_ship_date,0);
389: arp_file.write_log('l invoice'||p_low_invoice_date,0);
390: arp_file.write_log('h invoice'||p_high_invoice_date,0);
391: arp_file.write_log('default'||p_default_date,0);
392:
393: UPDATE_BATCH_SOURCE(p_low_invoice_dt, p_high_invoice_dt,
394: p_low_gl_dt, p_high_gl_dt,

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

387: arp_file.write_log('l ship'||p_low_ship_date,0);
388: arp_file.write_log('h ship'||p_high_ship_date,0);
389: arp_file.write_log('l invoice'||p_low_invoice_date,0);
390: arp_file.write_log('h invoice'||p_high_invoice_date,0);
391: arp_file.write_log('default'||p_default_date,0);
392:
393: UPDATE_BATCH_SOURCE(p_low_invoice_dt, p_high_invoice_dt,
394: p_low_gl_dt, p_high_gl_dt,
395: p_low_ship_dt, p_high_ship_dt, p_default_dt);

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

393: UPDATE_BATCH_SOURCE(p_low_invoice_dt, p_high_invoice_dt,
394: p_low_gl_dt, p_high_gl_dt,
395: p_low_ship_dt, p_high_ship_dt, p_default_dt);
396:
397: arp_file.write_log('After update batch source');
398: -- Call to the Batch Source Update error report
399: X_req_id := FND_REQUEST.SUBMIT_REQUEST(
400: 'JL' ,
401: 'JLARRERR',

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

403: SYSDATE,
404: FALSE);
405: EXCEPTION
406: WHEN OTHERS THEN
407: arp_file.write_log(sqlerrm,0);
408:
409: END JL_AR_AR_UPDATE_BATCH_SOURCE;
410:
411:

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

450: message VARCHAR2(240);
451: l_org_id NUMBER;
452:
453: BEGIN
454: arp_file.write_log('JL Submitting Autoinvoice',0);
455:
456: -- Bug#7642995 Start
457: l_org_id := mo_global.get_current_org_id;
458:

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

455:
456: -- Bug#7642995 Start
457: l_org_id := mo_global.get_current_org_id;
458:
459: arp_file.write_log(l_org_id,0);
460:
461: fnd_request.set_org_id(l_org_id);
462:
463: -- Bug#7642995 End