DBA Data[Home] [Help]

APPS.ARP_PROCESS_BR_BATCHES dependencies on ARP_UTIL

Line 23: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_GL_Date()+');

19: p_issue_date IN DATE) IS
20: BEGIN
21:
22: IF PG_DEBUG in ('Y', 'C') THEN
23: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_GL_Date()+');
24: END IF;
25:
26: IF NOT (arp_util.is_gl_date_valid (p_gl_date))
27: THEN

Line 26: IF NOT (arp_util.is_gl_date_valid (p_gl_date))

22: IF PG_DEBUG in ('Y', 'C') THEN
23: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_GL_Date()+');
24: END IF;
25:
26: IF NOT (arp_util.is_gl_date_valid (p_gl_date))
27: THEN
28: FND_MESSAGE.set_name ('AR', 'AR_INVALID_APP_GL_DATE');
29: --Int'l Calendar Project
30: FND_MESSAGE.set_token ('GL_DATE', fnd_date.date_to_chardate (p_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));

Line 41: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_GL_Date()-');

37: app_exception.raise_exception;
38: END IF;
39:
40: IF PG_DEBUG in ('Y', 'C') THEN
41: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_GL_Date()-');
42: END IF;
43:
44: EXCEPTION
45: WHEN OTHERS THEN

Line 47: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_GL_Date()');

43:
44: EXCEPTION
45: WHEN OTHERS THEN
46: IF PG_DEBUG in ('Y', 'C') THEN
47: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_GL_Date()');
48: arp_util.debug( '');
49: arp_util.debug('------ parameters for Validate_GL_Date() -------');
50: arp_util.debug( 'p_gl_date = '|| p_gl_date);
51: arp_util.debug( 'p_issue_date = '|| p_issue_date);

Line 48: arp_util.debug( '');

44: EXCEPTION
45: WHEN OTHERS THEN
46: IF PG_DEBUG in ('Y', 'C') THEN
47: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_GL_Date()');
48: arp_util.debug( '');
49: arp_util.debug('------ parameters for Validate_GL_Date() -------');
50: arp_util.debug( 'p_gl_date = '|| p_gl_date);
51: arp_util.debug( 'p_issue_date = '|| p_issue_date);
52: END IF;

Line 49: arp_util.debug('------ parameters for Validate_GL_Date() -------');

45: WHEN OTHERS THEN
46: IF PG_DEBUG in ('Y', 'C') THEN
47: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_GL_Date()');
48: arp_util.debug( '');
49: arp_util.debug('------ parameters for Validate_GL_Date() -------');
50: arp_util.debug( 'p_gl_date = '|| p_gl_date);
51: arp_util.debug( 'p_issue_date = '|| p_issue_date);
52: END IF;
53: RAISE;

Line 50: arp_util.debug( 'p_gl_date = '|| p_gl_date);

46: IF PG_DEBUG in ('Y', 'C') THEN
47: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_GL_Date()');
48: arp_util.debug( '');
49: arp_util.debug('------ parameters for Validate_GL_Date() -------');
50: arp_util.debug( 'p_gl_date = '|| p_gl_date);
51: arp_util.debug( 'p_issue_date = '|| p_issue_date);
52: END IF;
53: RAISE;
54:

Line 51: arp_util.debug( 'p_issue_date = '|| p_issue_date);

47: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_GL_Date()');
48: arp_util.debug( '');
49: arp_util.debug('------ parameters for Validate_GL_Date() -------');
50: arp_util.debug( 'p_gl_date = '|| p_gl_date);
51: arp_util.debug( 'p_issue_date = '|| p_issue_date);
52: END IF;
53: RAISE;
54:
55: END Validate_GL_Date;

Line 73: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date()+');

69: p_issue_date IN DATE) IS
70: BEGIN
71:
72: IF PG_DEBUG in ('Y', 'C') THEN
73: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date()+');
74: END IF;
75:
76: IF (p_maturity_date IS NOT NULL)
77: THEN

Line 86: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date()-');

82: END IF;
83: END IF;
84:
85: IF PG_DEBUG in ('Y', 'C') THEN
86: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date()-');
87: END IF;
88:
89: EXCEPTION
90: WHEN OTHERS THEN

Line 92: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date()');

88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: IF PG_DEBUG in ('Y', 'C') THEN
92: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date()');
93: arp_util.debug( '');
94: arp_util.debug('------ parameters for Validate_Maturity_Date() -------');
95: arp_util.debug( 'p_maturity_date = '|| p_maturity_date);
96: arp_util.debug( 'p_issue_date = '|| p_issue_date);

Line 93: arp_util.debug( '');

89: EXCEPTION
90: WHEN OTHERS THEN
91: IF PG_DEBUG in ('Y', 'C') THEN
92: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date()');
93: arp_util.debug( '');
94: arp_util.debug('------ parameters for Validate_Maturity_Date() -------');
95: arp_util.debug( 'p_maturity_date = '|| p_maturity_date);
96: arp_util.debug( 'p_issue_date = '|| p_issue_date);
97: END IF;

Line 94: arp_util.debug('------ parameters for Validate_Maturity_Date() -------');

90: WHEN OTHERS THEN
91: IF PG_DEBUG in ('Y', 'C') THEN
92: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date()');
93: arp_util.debug( '');
94: arp_util.debug('------ parameters for Validate_Maturity_Date() -------');
95: arp_util.debug( 'p_maturity_date = '|| p_maturity_date);
96: arp_util.debug( 'p_issue_date = '|| p_issue_date);
97: END IF;
98: RAISE;

Line 95: arp_util.debug( 'p_maturity_date = '|| p_maturity_date);

91: IF PG_DEBUG in ('Y', 'C') THEN
92: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date()');
93: arp_util.debug( '');
94: arp_util.debug('------ parameters for Validate_Maturity_Date() -------');
95: arp_util.debug( 'p_maturity_date = '|| p_maturity_date);
96: arp_util.debug( 'p_issue_date = '|| p_issue_date);
97: END IF;
98: RAISE;
99:

Line 96: arp_util.debug( 'p_issue_date = '|| p_issue_date);

92: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date()');
93: arp_util.debug( '');
94: arp_util.debug('------ parameters for Validate_Maturity_Date() -------');
95: arp_util.debug( 'p_maturity_date = '|| p_maturity_date);
96: arp_util.debug( 'p_issue_date = '|| p_issue_date);
97: END IF;
98: RAISE;
99:
100: END Validate_Maturity_Date;

Line 133: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Batch_Source()+');

129:
130: BEGIN
131:
132: IF PG_DEBUG in ('Y', 'C') THEN
133: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Batch_Source()+');
134: END IF;
135:
136: SELECT start_date, end_date, auto_trx_numbering_flag, copy_doc_number_flag
137: INTO l_start_date, l_end_date, l_auto_trx_numbering_flag, l_copy_doc_number_flag

Line 147: arp_util.debug('Validate_Batch_Source: ' || 'Invalid Source - Flags');

143:
144: IF (l_auto_trx_numbering_flag = 'N' AND l_copy_doc_number_flag = 'N')
145: THEN
146: IF PG_DEBUG in ('Y', 'C') THEN
147: arp_util.debug('Validate_Batch_Source: ' || 'Invalid Source - Flags');
148: END IF;
149: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_INVALID_NUMBERING_SOURCE');
150: app_exception.raise_exception;
151: END IF;

Line 158: arp_util.debug('Validate_Batch_Source: ' || 'Invalid Source - batch date');

154: IF (p_batch_date NOT BETWEEN nvl(l_start_date , p_batch_date)
155: AND nvl(l_end_date , p_batch_date))
156: THEN
157: IF PG_DEBUG in ('Y', 'C') THEN
158: arp_util.debug('Validate_Batch_Source: ' || 'Invalid Source - batch date');
159: END IF;
160: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_BAD_BATCH_DATE_SOURCE');
161: app_exception.raise_exception;
162: END IF;

Line 169: arp_util.debug('Validate_Batch_Source: ' || 'Invalid Source - issue date');

165: IF (p_issue_date NOT BETWEEN nvl(l_start_date , p_issue_date)
166: AND nvl(l_end_date , p_issue_date))
167: THEN
168: IF PG_DEBUG in ('Y', 'C') THEN
169: arp_util.debug('Validate_Batch_Source: ' || 'Invalid Source - issue date');
170: END IF;
171: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_BAD_DATE_SOURCE');
172: app_exception.raise_exception;
173: END IF;

Line 176: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Batch_Source()-');

172: app_exception.raise_exception;
173: END IF;
174:
175: IF PG_DEBUG in ('Y', 'C') THEN
176: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Batch_Source()-');
177: END IF;
178:
179: EXCEPTION
180: WHEN NO_DATA_FOUND THEN

Line 186: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Batch_Source()');

182: app_exception.raise_exception;
183:
184: WHEN OTHERS THEN
185: IF PG_DEBUG in ('Y', 'C') THEN
186: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Batch_Source()');
187: arp_util.debug('Validate_Batch_Source: ' || '');
188: arp_util.debug('------ parameters for Validate_Batch_Source() -------');
189: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_source_id = '|| p_batch_source_id);
190: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_date = '|| p_batch_date);

Line 187: arp_util.debug('Validate_Batch_Source: ' || '');

183:
184: WHEN OTHERS THEN
185: IF PG_DEBUG in ('Y', 'C') THEN
186: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Batch_Source()');
187: arp_util.debug('Validate_Batch_Source: ' || '');
188: arp_util.debug('------ parameters for Validate_Batch_Source() -------');
189: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_source_id = '|| p_batch_source_id);
190: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_date = '|| p_batch_date);
191: arp_util.debug('Validate_Batch_Source: ' || 'p_issue_date = '|| p_issue_date);

Line 188: arp_util.debug('------ parameters for Validate_Batch_Source() -------');

184: WHEN OTHERS THEN
185: IF PG_DEBUG in ('Y', 'C') THEN
186: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Batch_Source()');
187: arp_util.debug('Validate_Batch_Source: ' || '');
188: arp_util.debug('------ parameters for Validate_Batch_Source() -------');
189: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_source_id = '|| p_batch_source_id);
190: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_date = '|| p_batch_date);
191: arp_util.debug('Validate_Batch_Source: ' || 'p_issue_date = '|| p_issue_date);
192: END IF;

Line 189: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_source_id = '|| p_batch_source_id);

185: IF PG_DEBUG in ('Y', 'C') THEN
186: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Batch_Source()');
187: arp_util.debug('Validate_Batch_Source: ' || '');
188: arp_util.debug('------ parameters for Validate_Batch_Source() -------');
189: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_source_id = '|| p_batch_source_id);
190: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_date = '|| p_batch_date);
191: arp_util.debug('Validate_Batch_Source: ' || 'p_issue_date = '|| p_issue_date);
192: END IF;
193: RAISE;

Line 190: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_date = '|| p_batch_date);

186: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Batch_Source()');
187: arp_util.debug('Validate_Batch_Source: ' || '');
188: arp_util.debug('------ parameters for Validate_Batch_Source() -------');
189: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_source_id = '|| p_batch_source_id);
190: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_date = '|| p_batch_date);
191: arp_util.debug('Validate_Batch_Source: ' || 'p_issue_date = '|| p_issue_date);
192: END IF;
193: RAISE;
194:

Line 191: arp_util.debug('Validate_Batch_Source: ' || 'p_issue_date = '|| p_issue_date);

187: arp_util.debug('Validate_Batch_Source: ' || '');
188: arp_util.debug('------ parameters for Validate_Batch_Source() -------');
189: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_source_id = '|| p_batch_source_id);
190: arp_util.debug('Validate_Batch_Source: ' || 'p_batch_date = '|| p_batch_date);
191: arp_util.debug('Validate_Batch_Source: ' || 'p_issue_date = '|| p_issue_date);
192: END IF;
193: RAISE;
194:
195: END Validate_Batch_Source;

Line 218: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Currency()+');

214:
215: BEGIN
216:
217: IF PG_DEBUG in ('Y', 'C') THEN
218: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Currency()+');
219: END IF;
220:
221: IF (p_currency_code IS NOT NULL)
222: THEN

Line 235: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Currency()-');

231: AND CURRENCY_FLAG = 'Y';
232: END IF;
233:
234: IF PG_DEBUG in ('Y', 'C') THEN
235: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Currency()-');
236: END IF;
237:
238: EXCEPTION
239: WHEN NO_DATA_FOUND THEN

Line 245: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Currency()');

241: app_exception.raise_exception;
242:
243: WHEN OTHERS THEN
244: IF PG_DEBUG in ('Y', 'C') THEN
245: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Currency()');
246: arp_util.debug('Validate_Currency: ' || '');
247: arp_util.debug('------ parameters for Validate_Currency() -------');
248: arp_util.debug('Validate_Currency: ' || 'p_currency_code = '|| p_currency_code);
249: arp_util.debug('Validate_Currency: ' || 'p_issue_date = '|| p_issue_date);

Line 246: arp_util.debug('Validate_Currency: ' || '');

242:
243: WHEN OTHERS THEN
244: IF PG_DEBUG in ('Y', 'C') THEN
245: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Currency()');
246: arp_util.debug('Validate_Currency: ' || '');
247: arp_util.debug('------ parameters for Validate_Currency() -------');
248: arp_util.debug('Validate_Currency: ' || 'p_currency_code = '|| p_currency_code);
249: arp_util.debug('Validate_Currency: ' || 'p_issue_date = '|| p_issue_date);
250: END IF;

Line 247: arp_util.debug('------ parameters for Validate_Currency() -------');

243: WHEN OTHERS THEN
244: IF PG_DEBUG in ('Y', 'C') THEN
245: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Currency()');
246: arp_util.debug('Validate_Currency: ' || '');
247: arp_util.debug('------ parameters for Validate_Currency() -------');
248: arp_util.debug('Validate_Currency: ' || 'p_currency_code = '|| p_currency_code);
249: arp_util.debug('Validate_Currency: ' || 'p_issue_date = '|| p_issue_date);
250: END IF;
251: RAISE;

Line 248: arp_util.debug('Validate_Currency: ' || 'p_currency_code = '|| p_currency_code);

244: IF PG_DEBUG in ('Y', 'C') THEN
245: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Currency()');
246: arp_util.debug('Validate_Currency: ' || '');
247: arp_util.debug('------ parameters for Validate_Currency() -------');
248: arp_util.debug('Validate_Currency: ' || 'p_currency_code = '|| p_currency_code);
249: arp_util.debug('Validate_Currency: ' || 'p_issue_date = '|| p_issue_date);
250: END IF;
251: RAISE;
252:

Line 249: arp_util.debug('Validate_Currency: ' || 'p_issue_date = '|| p_issue_date);

245: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Currency()');
246: arp_util.debug('Validate_Currency: ' || '');
247: arp_util.debug('------ parameters for Validate_Currency() -------');
248: arp_util.debug('Validate_Currency: ' || 'p_currency_code = '|| p_currency_code);
249: arp_util.debug('Validate_Currency: ' || 'p_issue_date = '|| p_issue_date);
250: END IF;
251: RAISE;
252:
253: END Validate_Currency;

Line 274: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Receipt_Method()+');

270:
271: BEGIN
272:
273: IF PG_DEBUG in ('Y', 'C') THEN
274: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Receipt_Method()+');
275: END IF;
276:
277: IF (p_receipt_method_id IS NOT NULL)
278: THEN

Line 288: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Receipt_Method()-');

284: AND nvl(rm.end_date , p_issue_date);
285: END IF;
286:
287: IF PG_DEBUG in ('Y', 'C') THEN
288: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_Receipt_Method()-');
289: END IF;
290:
291: EXCEPTION
292: WHEN NO_DATA_FOUND THEN

Line 298: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Receipt_Method()');

294: app_exception.raise_exception;
295:
296: WHEN OTHERS THEN
297: IF PG_DEBUG in ('Y', 'C') THEN
298: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Receipt_Method()');
299: arp_util.debug('Validate_Receipt_Method: ' || '');
300: arp_util.debug('------ parameters for Validate_Receipt_Method () -------');
301: arp_util.debug('Validate_Receipt_Method: ' || 'p_receipt_method_id = '|| p_receipt_method_id);
302: arp_util.debug('Validate_Receipt_Method: ' || 'p_issue_date = '|| p_issue_date);

Line 299: arp_util.debug('Validate_Receipt_Method: ' || '');

295:
296: WHEN OTHERS THEN
297: IF PG_DEBUG in ('Y', 'C') THEN
298: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Receipt_Method()');
299: arp_util.debug('Validate_Receipt_Method: ' || '');
300: arp_util.debug('------ parameters for Validate_Receipt_Method () -------');
301: arp_util.debug('Validate_Receipt_Method: ' || 'p_receipt_method_id = '|| p_receipt_method_id);
302: arp_util.debug('Validate_Receipt_Method: ' || 'p_issue_date = '|| p_issue_date);
303: END IF;

Line 300: arp_util.debug('------ parameters for Validate_Receipt_Method () -------');

296: WHEN OTHERS THEN
297: IF PG_DEBUG in ('Y', 'C') THEN
298: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Receipt_Method()');
299: arp_util.debug('Validate_Receipt_Method: ' || '');
300: arp_util.debug('------ parameters for Validate_Receipt_Method () -------');
301: arp_util.debug('Validate_Receipt_Method: ' || 'p_receipt_method_id = '|| p_receipt_method_id);
302: arp_util.debug('Validate_Receipt_Method: ' || 'p_issue_date = '|| p_issue_date);
303: END IF;
304: RAISE;

Line 301: arp_util.debug('Validate_Receipt_Method: ' || 'p_receipt_method_id = '|| p_receipt_method_id);

297: IF PG_DEBUG in ('Y', 'C') THEN
298: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Receipt_Method()');
299: arp_util.debug('Validate_Receipt_Method: ' || '');
300: arp_util.debug('------ parameters for Validate_Receipt_Method () -------');
301: arp_util.debug('Validate_Receipt_Method: ' || 'p_receipt_method_id = '|| p_receipt_method_id);
302: arp_util.debug('Validate_Receipt_Method: ' || 'p_issue_date = '|| p_issue_date);
303: END IF;
304: RAISE;
305:

Line 302: arp_util.debug('Validate_Receipt_Method: ' || 'p_issue_date = '|| p_issue_date);

298: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Validate_Receipt_Method()');
299: arp_util.debug('Validate_Receipt_Method: ' || '');
300: arp_util.debug('------ parameters for Validate_Receipt_Method () -------');
301: arp_util.debug('Validate_Receipt_Method: ' || 'p_receipt_method_id = '|| p_receipt_method_id);
302: arp_util.debug('Validate_Receipt_Method: ' || 'p_issue_date = '|| p_issue_date);
303: END IF;
304: RAISE;
305:
306: END Validate_Receipt_Method;

Line 330: arp_util.debug('Check_Mandatory_Data: ' || 'Batch Source Missing');

326:
327: IF (p_batch_rec.batch_source_id IS NULL)
328: THEN
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_util.debug('Check_Mandatory_Data: ' || 'Batch Source Missing');
331: END IF;
332: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_BATCH_SOURCE_NULL');
333: app_exception.raise_exception;
334: END IF;

Line 340: arp_util.debug('Check_Mandatory_Data: ' || 'Batch Date Missing');

336:
337: IF (p_batch_rec.batch_date IS NULL)
338: THEN
339: IF PG_DEBUG in ('Y', 'C') THEN
340: arp_util.debug('Check_Mandatory_Data: ' || 'Batch Date Missing');
341: END IF;
342: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_BATCH_DATE_NULL');
343: app_exception.raise_exception;
344: END IF;

Line 350: arp_util.debug('Check_Mandatory_Data: ' || 'GL Date Missing');

346:
347: IF (p_batch_rec.gl_date IS NULL)
348: THEN
349: IF PG_DEBUG in ('Y', 'C') THEN
350: arp_util.debug('Check_Mandatory_Data: ' || 'GL Date Missing');
351: END IF;
352: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_GL_DATE_NULL');
353: app_exception.raise_exception;
354: END IF;

Line 360: arp_util.debug('Check_Mandatory_Data: ' || 'Issue Date Missing');

356:
357: IF (p_batch_rec.issue_date IS NULL)
358: THEN
359: IF PG_DEBUG in ('Y', 'C') THEN
360: arp_util.debug('Check_Mandatory_Data: ' || 'Issue Date Missing');
361: END IF;
362: FND_MESSAGE.SET_NAME ('AR', 'AR_BR_ISSUE_DATE_NULL');
363: app_exception.raise_exception;
364: END IF;

Line 369: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Check_Mandatory_Data()');

365:
366: EXCEPTION
367: WHEN OTHERS THEN
368: IF PG_DEBUG in ('Y', 'C') THEN
369: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Check_Mandatory_Data()');
370: arp_util.debug('Check_Mandatory_Data: ' || '');
371: END IF;
372: RAISE;
373:

Line 370: arp_util.debug('Check_Mandatory_Data: ' || '');

366: EXCEPTION
367: WHEN OTHERS THEN
368: IF PG_DEBUG in ('Y', 'C') THEN
369: arp_util.debug('EXCEPTION: ARP_PROCESS_BR_BATCHES.Check_Mandatory_Data()');
370: arp_util.debug('Check_Mandatory_Data: ' || '');
371: END IF;
372: RAISE;
373:
374: END Check_Mandatory_Data;

Line 387: | arp_util.debug |

383: | |
384: | SCOPE - PRIVATE |
385: | |
386: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
387: | arp_util.debug |
388: | |
389: | ARGUMENTS : IN: |
390: | p_batch_rec |
391: | OUT: |

Line 410: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_batch()+');

406:
407: BEGIN
408:
409: IF PG_DEBUG in ('Y', 'C') THEN
410: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_batch()+');
411: END IF;
412:
413:
414: ARP_PROCESS_BR_BATCHES.Validate_GL_Date

Line 432: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_batch()-');

428: ( p_batch_rec.currency_code ,
429: p_batch_rec.issue_date );
430:
431: IF PG_DEBUG in ('Y', 'C') THEN
432: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_batch()-');
433: END IF;
434:
435: EXCEPTION
436: WHEN OTHERS THEN

Line 438: arp_util.debug('EXCEPTION: arp_process_batch.validate_batch()');

434:
435: EXCEPTION
436: WHEN OTHERS THEN
437: IF PG_DEBUG in ('Y', 'C') THEN
438: arp_util.debug('EXCEPTION: arp_process_batch.validate_batch()');
439: arp_util.debug('validate_batch: ' || '');
440: arp_util.debug('------ parameters for validate_batch() -------');
441: END IF;
442: arp_tbat_pkg.display_batch_rec(p_batch_rec);

Line 439: arp_util.debug('validate_batch: ' || '');

435: EXCEPTION
436: WHEN OTHERS THEN
437: IF PG_DEBUG in ('Y', 'C') THEN
438: arp_util.debug('EXCEPTION: arp_process_batch.validate_batch()');
439: arp_util.debug('validate_batch: ' || '');
440: arp_util.debug('------ parameters for validate_batch() -------');
441: END IF;
442: arp_tbat_pkg.display_batch_rec(p_batch_rec);
443: RAISE;

Line 440: arp_util.debug('------ parameters for validate_batch() -------');

436: WHEN OTHERS THEN
437: IF PG_DEBUG in ('Y', 'C') THEN
438: arp_util.debug('EXCEPTION: arp_process_batch.validate_batch()');
439: arp_util.debug('validate_batch: ' || '');
440: arp_util.debug('------ parameters for validate_batch() -------');
441: END IF;
442: arp_tbat_pkg.display_batch_rec(p_batch_rec);
443: RAISE;
444:

Line 460: | arp_util.debug |

456: | |
457: | SCOPE - PRIVATE |
458: | |
459: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
460: | arp_util.debug |
461: | |
462: | ARGUMENTS : IN: |
463: | p_batch_id |
464: | OUT: |

Line 483: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_delete_batch()+');

479:
480: BEGIN
481:
482: IF PG_DEBUG in ('Y', 'C') THEN
483: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_delete_batch()+');
484: END IF;
485:
486: arp_process_batch.ar_empty_batch(p_batch_id);
487:

Line 489: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_delete_batch()-');

485:
486: arp_process_batch.ar_empty_batch(p_batch_id);
487:
488: IF PG_DEBUG in ('Y', 'C') THEN
489: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_delete_batch()-');
490: END IF;
491:
492:
493: EXCEPTION

Line 496: arp_util.debug('EXCEPTION: arp_process_batch.validate_delete_batch()');

492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: IF PG_DEBUG in ('Y', 'C') THEN
496: arp_util.debug('EXCEPTION: arp_process_batch.validate_delete_batch()');
497: arp_util.debug('validate_delete_batch: ' || '');
498: arp_util.debug('------ parameters for validate_delete_batch() -------');
499: arp_util.debug('validate_delete_batch: ' || 'p_batch_id = '|| p_batch_id);
500: END IF;

Line 497: arp_util.debug('validate_delete_batch: ' || '');

493: EXCEPTION
494: WHEN OTHERS THEN
495: IF PG_DEBUG in ('Y', 'C') THEN
496: arp_util.debug('EXCEPTION: arp_process_batch.validate_delete_batch()');
497: arp_util.debug('validate_delete_batch: ' || '');
498: arp_util.debug('------ parameters for validate_delete_batch() -------');
499: arp_util.debug('validate_delete_batch: ' || 'p_batch_id = '|| p_batch_id);
500: END IF;
501: RAISE;

Line 498: arp_util.debug('------ parameters for validate_delete_batch() -------');

494: WHEN OTHERS THEN
495: IF PG_DEBUG in ('Y', 'C') THEN
496: arp_util.debug('EXCEPTION: arp_process_batch.validate_delete_batch()');
497: arp_util.debug('validate_delete_batch: ' || '');
498: arp_util.debug('------ parameters for validate_delete_batch() -------');
499: arp_util.debug('validate_delete_batch: ' || 'p_batch_id = '|| p_batch_id);
500: END IF;
501: RAISE;
502:

Line 499: arp_util.debug('validate_delete_batch: ' || 'p_batch_id = '|| p_batch_id);

495: IF PG_DEBUG in ('Y', 'C') THEN
496: arp_util.debug('EXCEPTION: arp_process_batch.validate_delete_batch()');
497: arp_util.debug('validate_delete_batch: ' || '');
498: arp_util.debug('------ parameters for validate_delete_batch() -------');
499: arp_util.debug('validate_delete_batch: ' || 'p_batch_id = '|| p_batch_id);
500: END IF;
501: RAISE;
502:
503: END validate_delete_batch;

Line 518: | arp_util.debug |

514: | |
515: | SCOPE - PRIVATE |
516: | |
517: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
518: | arp_util.debug |
519: | |
520: | ARGUMENTS : IN: |
521: | p_sel_rec |
522: | OUT: |

Line 542: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_selection()+');

538:
539: BEGIN
540:
541: IF PG_DEBUG in ('Y', 'C') THEN
542: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_selection()+');
543: END IF;
544:
545: Validate_Receipt_Method ( p_sel_rec.receipt_method_id, p_issue_date);
546:

Line 548: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_selection()-');

544:
545: Validate_Receipt_Method ( p_sel_rec.receipt_method_id, p_issue_date);
546:
547: IF PG_DEBUG in ('Y', 'C') THEN
548: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_selection()-');
549: END IF;
550:
551: EXCEPTION
552: WHEN OTHERS THEN

Line 554: arp_util.debug('EXCEPTION: arp_process_batch.validate_selection()');

550:
551: EXCEPTION
552: WHEN OTHERS THEN
553: IF PG_DEBUG in ('Y', 'C') THEN
554: arp_util.debug('EXCEPTION: arp_process_batch.validate_selection()');
555: arp_util.debug('validate_selection: ' || '');
556: arp_util.debug('------ parameters for validate_selection() -------');
557: END IF;
558: arp_selection_criteria_pkg.display_selection_rec(p_sel_rec);

Line 555: arp_util.debug('validate_selection: ' || '');

551: EXCEPTION
552: WHEN OTHERS THEN
553: IF PG_DEBUG in ('Y', 'C') THEN
554: arp_util.debug('EXCEPTION: arp_process_batch.validate_selection()');
555: arp_util.debug('validate_selection: ' || '');
556: arp_util.debug('------ parameters for validate_selection() -------');
557: END IF;
558: arp_selection_criteria_pkg.display_selection_rec(p_sel_rec);
559: RAISE;

Line 556: arp_util.debug('------ parameters for validate_selection() -------');

552: WHEN OTHERS THEN
553: IF PG_DEBUG in ('Y', 'C') THEN
554: arp_util.debug('EXCEPTION: arp_process_batch.validate_selection()');
555: arp_util.debug('validate_selection: ' || '');
556: arp_util.debug('------ parameters for validate_selection() -------');
557: END IF;
558: arp_selection_criteria_pkg.display_selection_rec(p_sel_rec);
559: RAISE;
560:

Line 578: arp_util.debug('ARP_PROCESS_BR_BATCHES.Is_Selection_Entered()');

574: FUNCTION Is_Selection_Entered (p_sel_rec IN ar_selection_criteria%rowtype ) RETURN BOOLEAN IS
575: BEGIN
576:
577: IF PG_DEBUG in ('Y', 'C') THEN
578: arp_util.debug('ARP_PROCESS_BR_BATCHES.Is_Selection_Entered()');
579: END IF;
580:
581: IF (p_sel_rec.due_date_low IS NULL) AND
582: (p_sel_rec.due_date_high IS NULL) AND

Line 603: arp_util.debug('EXCEPTION: arp_process_batches.Is_Selection_Entered ()');

599:
600: EXCEPTION
601: WHEN OTHERS THEN
602: IF PG_DEBUG in ('Y', 'C') THEN
603: arp_util.debug('EXCEPTION: arp_process_batches.Is_Selection_Entered ()');
604: arp_util.debug('Is_Selection_Entered: ' || '');
605: arp_util.debug('Is_Selection_Entered: ' || '------ parameters for validate_selection() -------');
606: END IF;
607: arp_selection_criteria_pkg.display_selection_rec(p_sel_rec);

Line 604: arp_util.debug('Is_Selection_Entered: ' || '');

600: EXCEPTION
601: WHEN OTHERS THEN
602: IF PG_DEBUG in ('Y', 'C') THEN
603: arp_util.debug('EXCEPTION: arp_process_batches.Is_Selection_Entered ()');
604: arp_util.debug('Is_Selection_Entered: ' || '');
605: arp_util.debug('Is_Selection_Entered: ' || '------ parameters for validate_selection() -------');
606: END IF;
607: arp_selection_criteria_pkg.display_selection_rec(p_sel_rec);
608: RAISE;

Line 605: arp_util.debug('Is_Selection_Entered: ' || '------ parameters for validate_selection() -------');

601: WHEN OTHERS THEN
602: IF PG_DEBUG in ('Y', 'C') THEN
603: arp_util.debug('EXCEPTION: arp_process_batches.Is_Selection_Entered ()');
604: arp_util.debug('Is_Selection_Entered: ' || '');
605: arp_util.debug('Is_Selection_Entered: ' || '------ parameters for validate_selection() -------');
606: END IF;
607: arp_selection_criteria_pkg.display_selection_rec(p_sel_rec);
608: RAISE;
609:

Line 624: | arp_util.debug |

620: | |
621: | SCOPE - PRIVATE |
622: | |
623: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
624: | arp_util.debug |
625: | |
626: | ARGUMENTS : IN: |
627: | p_form_name |
628: | p_form_version |

Line 724: arp_util.debug('arp_process_br_batch.insert_batch()+');

720: l_sel_id ar_selection_criteria.selection_criteria_id%type;
721:
722: BEGIN
723:
724: arp_util.debug('arp_process_br_batch.insert_batch()+');
725:
726: /*-------------------------------------------------------------+
727: | Check the form version to determine if it is compatible |
728: | with the entity handler |

Line 833: arp_util.debug('ARP_PROCESS_BR_BATCHES.insert_batch()-');

829:
830:
831: END IF;
832:
833: arp_util.debug('ARP_PROCESS_BR_BATCHES.insert_batch()-');
834:
835: EXCEPTION
836: WHEN OTHERS THEN
837: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.insert_batch');

Line 837: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.insert_batch');

833: arp_util.debug('ARP_PROCESS_BR_BATCHES.insert_batch()-');
834:
835: EXCEPTION
836: WHEN OTHERS THEN
837: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.insert_batch');
838: arp_util.debug('p_batch_source_id : ' || p_batch_source_id);
839: arp_util.debug('p_batch_date : ' || p_batch_date);
840: arp_util.debug('p_gl_date : ' || p_gl_date);
841: arp_util.debug('p_type : ' || p_type);

Line 838: arp_util.debug('p_batch_source_id : ' || p_batch_source_id);

834:
835: EXCEPTION
836: WHEN OTHERS THEN
837: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.insert_batch');
838: arp_util.debug('p_batch_source_id : ' || p_batch_source_id);
839: arp_util.debug('p_batch_date : ' || p_batch_date);
840: arp_util.debug('p_gl_date : ' || p_gl_date);
841: arp_util.debug('p_type : ' || p_type);
842: arp_util.debug('p_currency_code : ' || p_currency_code);

Line 839: arp_util.debug('p_batch_date : ' || p_batch_date);

835: EXCEPTION
836: WHEN OTHERS THEN
837: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.insert_batch');
838: arp_util.debug('p_batch_source_id : ' || p_batch_source_id);
839: arp_util.debug('p_batch_date : ' || p_batch_date);
840: arp_util.debug('p_gl_date : ' || p_gl_date);
841: arp_util.debug('p_type : ' || p_type);
842: arp_util.debug('p_currency_code : ' || p_currency_code);
843: arp_util.debug('p_comments : ' || p_comments);

Line 840: arp_util.debug('p_gl_date : ' || p_gl_date);

836: WHEN OTHERS THEN
837: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.insert_batch');
838: arp_util.debug('p_batch_source_id : ' || p_batch_source_id);
839: arp_util.debug('p_batch_date : ' || p_batch_date);
840: arp_util.debug('p_gl_date : ' || p_gl_date);
841: arp_util.debug('p_type : ' || p_type);
842: arp_util.debug('p_currency_code : ' || p_currency_code);
843: arp_util.debug('p_comments : ' || p_comments);
844: arp_util.debug('p_attribute_category : ' || p_attribute_category);

Line 841: arp_util.debug('p_type : ' || p_type);

837: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.insert_batch');
838: arp_util.debug('p_batch_source_id : ' || p_batch_source_id);
839: arp_util.debug('p_batch_date : ' || p_batch_date);
840: arp_util.debug('p_gl_date : ' || p_gl_date);
841: arp_util.debug('p_type : ' || p_type);
842: arp_util.debug('p_currency_code : ' || p_currency_code);
843: arp_util.debug('p_comments : ' || p_comments);
844: arp_util.debug('p_attribute_category : ' || p_attribute_category);
845: arp_util.debug('p_attribute1 : ' || p_attribute1);

Line 842: arp_util.debug('p_currency_code : ' || p_currency_code);

838: arp_util.debug('p_batch_source_id : ' || p_batch_source_id);
839: arp_util.debug('p_batch_date : ' || p_batch_date);
840: arp_util.debug('p_gl_date : ' || p_gl_date);
841: arp_util.debug('p_type : ' || p_type);
842: arp_util.debug('p_currency_code : ' || p_currency_code);
843: arp_util.debug('p_comments : ' || p_comments);
844: arp_util.debug('p_attribute_category : ' || p_attribute_category);
845: arp_util.debug('p_attribute1 : ' || p_attribute1);
846: arp_util.debug('p_attribute2 : ' || p_attribute2);

Line 843: arp_util.debug('p_comments : ' || p_comments);

839: arp_util.debug('p_batch_date : ' || p_batch_date);
840: arp_util.debug('p_gl_date : ' || p_gl_date);
841: arp_util.debug('p_type : ' || p_type);
842: arp_util.debug('p_currency_code : ' || p_currency_code);
843: arp_util.debug('p_comments : ' || p_comments);
844: arp_util.debug('p_attribute_category : ' || p_attribute_category);
845: arp_util.debug('p_attribute1 : ' || p_attribute1);
846: arp_util.debug('p_attribute2 : ' || p_attribute2);
847: arp_util.debug('p_attribute3 : ' || p_attribute3);

Line 844: arp_util.debug('p_attribute_category : ' || p_attribute_category);

840: arp_util.debug('p_gl_date : ' || p_gl_date);
841: arp_util.debug('p_type : ' || p_type);
842: arp_util.debug('p_currency_code : ' || p_currency_code);
843: arp_util.debug('p_comments : ' || p_comments);
844: arp_util.debug('p_attribute_category : ' || p_attribute_category);
845: arp_util.debug('p_attribute1 : ' || p_attribute1);
846: arp_util.debug('p_attribute2 : ' || p_attribute2);
847: arp_util.debug('p_attribute3 : ' || p_attribute3);
848: arp_util.debug('p_attribute4 : ' || p_attribute4);

Line 845: arp_util.debug('p_attribute1 : ' || p_attribute1);

841: arp_util.debug('p_type : ' || p_type);
842: arp_util.debug('p_currency_code : ' || p_currency_code);
843: arp_util.debug('p_comments : ' || p_comments);
844: arp_util.debug('p_attribute_category : ' || p_attribute_category);
845: arp_util.debug('p_attribute1 : ' || p_attribute1);
846: arp_util.debug('p_attribute2 : ' || p_attribute2);
847: arp_util.debug('p_attribute3 : ' || p_attribute3);
848: arp_util.debug('p_attribute4 : ' || p_attribute4);
849: arp_util.debug('p_attribute5 : ' || p_attribute5);

Line 846: arp_util.debug('p_attribute2 : ' || p_attribute2);

842: arp_util.debug('p_currency_code : ' || p_currency_code);
843: arp_util.debug('p_comments : ' || p_comments);
844: arp_util.debug('p_attribute_category : ' || p_attribute_category);
845: arp_util.debug('p_attribute1 : ' || p_attribute1);
846: arp_util.debug('p_attribute2 : ' || p_attribute2);
847: arp_util.debug('p_attribute3 : ' || p_attribute3);
848: arp_util.debug('p_attribute4 : ' || p_attribute4);
849: arp_util.debug('p_attribute5 : ' || p_attribute5);
850: arp_util.debug('p_attribute6 : ' || p_attribute6);

Line 847: arp_util.debug('p_attribute3 : ' || p_attribute3);

843: arp_util.debug('p_comments : ' || p_comments);
844: arp_util.debug('p_attribute_category : ' || p_attribute_category);
845: arp_util.debug('p_attribute1 : ' || p_attribute1);
846: arp_util.debug('p_attribute2 : ' || p_attribute2);
847: arp_util.debug('p_attribute3 : ' || p_attribute3);
848: arp_util.debug('p_attribute4 : ' || p_attribute4);
849: arp_util.debug('p_attribute5 : ' || p_attribute5);
850: arp_util.debug('p_attribute6 : ' || p_attribute6);
851: arp_util.debug('p_attribute7 : ' || p_attribute7);

Line 848: arp_util.debug('p_attribute4 : ' || p_attribute4);

844: arp_util.debug('p_attribute_category : ' || p_attribute_category);
845: arp_util.debug('p_attribute1 : ' || p_attribute1);
846: arp_util.debug('p_attribute2 : ' || p_attribute2);
847: arp_util.debug('p_attribute3 : ' || p_attribute3);
848: arp_util.debug('p_attribute4 : ' || p_attribute4);
849: arp_util.debug('p_attribute5 : ' || p_attribute5);
850: arp_util.debug('p_attribute6 : ' || p_attribute6);
851: arp_util.debug('p_attribute7 : ' || p_attribute7);
852: arp_util.debug('p_attribute8 : ' || p_attribute8);

Line 849: arp_util.debug('p_attribute5 : ' || p_attribute5);

845: arp_util.debug('p_attribute1 : ' || p_attribute1);
846: arp_util.debug('p_attribute2 : ' || p_attribute2);
847: arp_util.debug('p_attribute3 : ' || p_attribute3);
848: arp_util.debug('p_attribute4 : ' || p_attribute4);
849: arp_util.debug('p_attribute5 : ' || p_attribute5);
850: arp_util.debug('p_attribute6 : ' || p_attribute6);
851: arp_util.debug('p_attribute7 : ' || p_attribute7);
852: arp_util.debug('p_attribute8 : ' || p_attribute8);
853: arp_util.debug('p_attribute9 : ' || p_attribute9);

Line 850: arp_util.debug('p_attribute6 : ' || p_attribute6);

846: arp_util.debug('p_attribute2 : ' || p_attribute2);
847: arp_util.debug('p_attribute3 : ' || p_attribute3);
848: arp_util.debug('p_attribute4 : ' || p_attribute4);
849: arp_util.debug('p_attribute5 : ' || p_attribute5);
850: arp_util.debug('p_attribute6 : ' || p_attribute6);
851: arp_util.debug('p_attribute7 : ' || p_attribute7);
852: arp_util.debug('p_attribute8 : ' || p_attribute8);
853: arp_util.debug('p_attribute9 : ' || p_attribute9);
854: arp_util.debug('p_attribute10 : ' || p_attribute10);

Line 851: arp_util.debug('p_attribute7 : ' || p_attribute7);

847: arp_util.debug('p_attribute3 : ' || p_attribute3);
848: arp_util.debug('p_attribute4 : ' || p_attribute4);
849: arp_util.debug('p_attribute5 : ' || p_attribute5);
850: arp_util.debug('p_attribute6 : ' || p_attribute6);
851: arp_util.debug('p_attribute7 : ' || p_attribute7);
852: arp_util.debug('p_attribute8 : ' || p_attribute8);
853: arp_util.debug('p_attribute9 : ' || p_attribute9);
854: arp_util.debug('p_attribute10 : ' || p_attribute10);
855: arp_util.debug('p_attribute11 : ' || p_attribute11);

Line 852: arp_util.debug('p_attribute8 : ' || p_attribute8);

848: arp_util.debug('p_attribute4 : ' || p_attribute4);
849: arp_util.debug('p_attribute5 : ' || p_attribute5);
850: arp_util.debug('p_attribute6 : ' || p_attribute6);
851: arp_util.debug('p_attribute7 : ' || p_attribute7);
852: arp_util.debug('p_attribute8 : ' || p_attribute8);
853: arp_util.debug('p_attribute9 : ' || p_attribute9);
854: arp_util.debug('p_attribute10 : ' || p_attribute10);
855: arp_util.debug('p_attribute11 : ' || p_attribute11);
856: arp_util.debug('p_attribute12 : ' || p_attribute12);

Line 853: arp_util.debug('p_attribute9 : ' || p_attribute9);

849: arp_util.debug('p_attribute5 : ' || p_attribute5);
850: arp_util.debug('p_attribute6 : ' || p_attribute6);
851: arp_util.debug('p_attribute7 : ' || p_attribute7);
852: arp_util.debug('p_attribute8 : ' || p_attribute8);
853: arp_util.debug('p_attribute9 : ' || p_attribute9);
854: arp_util.debug('p_attribute10 : ' || p_attribute10);
855: arp_util.debug('p_attribute11 : ' || p_attribute11);
856: arp_util.debug('p_attribute12 : ' || p_attribute12);
857: arp_util.debug('p_attribute13 : ' || p_attribute13);

Line 854: arp_util.debug('p_attribute10 : ' || p_attribute10);

850: arp_util.debug('p_attribute6 : ' || p_attribute6);
851: arp_util.debug('p_attribute7 : ' || p_attribute7);
852: arp_util.debug('p_attribute8 : ' || p_attribute8);
853: arp_util.debug('p_attribute9 : ' || p_attribute9);
854: arp_util.debug('p_attribute10 : ' || p_attribute10);
855: arp_util.debug('p_attribute11 : ' || p_attribute11);
856: arp_util.debug('p_attribute12 : ' || p_attribute12);
857: arp_util.debug('p_attribute13 : ' || p_attribute13);
858: arp_util.debug('p_attribute14 : ' || p_attribute14);

Line 855: arp_util.debug('p_attribute11 : ' || p_attribute11);

851: arp_util.debug('p_attribute7 : ' || p_attribute7);
852: arp_util.debug('p_attribute8 : ' || p_attribute8);
853: arp_util.debug('p_attribute9 : ' || p_attribute9);
854: arp_util.debug('p_attribute10 : ' || p_attribute10);
855: arp_util.debug('p_attribute11 : ' || p_attribute11);
856: arp_util.debug('p_attribute12 : ' || p_attribute12);
857: arp_util.debug('p_attribute13 : ' || p_attribute13);
858: arp_util.debug('p_attribute14 : ' || p_attribute14);
859: arp_util.debug('p_attribute15 : ' || p_attribute15);

Line 856: arp_util.debug('p_attribute12 : ' || p_attribute12);

852: arp_util.debug('p_attribute8 : ' || p_attribute8);
853: arp_util.debug('p_attribute9 : ' || p_attribute9);
854: arp_util.debug('p_attribute10 : ' || p_attribute10);
855: arp_util.debug('p_attribute11 : ' || p_attribute11);
856: arp_util.debug('p_attribute12 : ' || p_attribute12);
857: arp_util.debug('p_attribute13 : ' || p_attribute13);
858: arp_util.debug('p_attribute14 : ' || p_attribute14);
859: arp_util.debug('p_attribute15 : ' || p_attribute15);
860: arp_util.debug('p_issue_date : ' || p_issue_date);

Line 857: arp_util.debug('p_attribute13 : ' || p_attribute13);

853: arp_util.debug('p_attribute9 : ' || p_attribute9);
854: arp_util.debug('p_attribute10 : ' || p_attribute10);
855: arp_util.debug('p_attribute11 : ' || p_attribute11);
856: arp_util.debug('p_attribute12 : ' || p_attribute12);
857: arp_util.debug('p_attribute13 : ' || p_attribute13);
858: arp_util.debug('p_attribute14 : ' || p_attribute14);
859: arp_util.debug('p_attribute15 : ' || p_attribute15);
860: arp_util.debug('p_issue_date : ' || p_issue_date);
861: arp_util.debug('p_maturity_date : ' || p_maturity_date);

Line 858: arp_util.debug('p_attribute14 : ' || p_attribute14);

854: arp_util.debug('p_attribute10 : ' || p_attribute10);
855: arp_util.debug('p_attribute11 : ' || p_attribute11);
856: arp_util.debug('p_attribute12 : ' || p_attribute12);
857: arp_util.debug('p_attribute13 : ' || p_attribute13);
858: arp_util.debug('p_attribute14 : ' || p_attribute14);
859: arp_util.debug('p_attribute15 : ' || p_attribute15);
860: arp_util.debug('p_issue_date : ' || p_issue_date);
861: arp_util.debug('p_maturity_date : ' || p_maturity_date);
862: arp_util.debug('p_special_instructions : ' || p_special_instructions);

Line 859: arp_util.debug('p_attribute15 : ' || p_attribute15);

855: arp_util.debug('p_attribute11 : ' || p_attribute11);
856: arp_util.debug('p_attribute12 : ' || p_attribute12);
857: arp_util.debug('p_attribute13 : ' || p_attribute13);
858: arp_util.debug('p_attribute14 : ' || p_attribute14);
859: arp_util.debug('p_attribute15 : ' || p_attribute15);
860: arp_util.debug('p_issue_date : ' || p_issue_date);
861: arp_util.debug('p_maturity_date : ' || p_maturity_date);
862: arp_util.debug('p_special_instructions : ' || p_special_instructions);
863: arp_util.debug('p_batch_process_status : ' || p_batch_process_status);

Line 860: arp_util.debug('p_issue_date : ' || p_issue_date);

856: arp_util.debug('p_attribute12 : ' || p_attribute12);
857: arp_util.debug('p_attribute13 : ' || p_attribute13);
858: arp_util.debug('p_attribute14 : ' || p_attribute14);
859: arp_util.debug('p_attribute15 : ' || p_attribute15);
860: arp_util.debug('p_issue_date : ' || p_issue_date);
861: arp_util.debug('p_maturity_date : ' || p_maturity_date);
862: arp_util.debug('p_special_instructions : ' || p_special_instructions);
863: arp_util.debug('p_batch_process_status : ' || p_batch_process_status);
864: arp_util.debug('p_name : ' || p_name);

Line 861: arp_util.debug('p_maturity_date : ' || p_maturity_date);

857: arp_util.debug('p_attribute13 : ' || p_attribute13);
858: arp_util.debug('p_attribute14 : ' || p_attribute14);
859: arp_util.debug('p_attribute15 : ' || p_attribute15);
860: arp_util.debug('p_issue_date : ' || p_issue_date);
861: arp_util.debug('p_maturity_date : ' || p_maturity_date);
862: arp_util.debug('p_special_instructions : ' || p_special_instructions);
863: arp_util.debug('p_batch_process_status : ' || p_batch_process_status);
864: arp_util.debug('p_name : ' || p_name);
865: arp_util.debug('p_selection_criteria_id : ' || p_selection_criteria_id);

Line 862: arp_util.debug('p_special_instructions : ' || p_special_instructions);

858: arp_util.debug('p_attribute14 : ' || p_attribute14);
859: arp_util.debug('p_attribute15 : ' || p_attribute15);
860: arp_util.debug('p_issue_date : ' || p_issue_date);
861: arp_util.debug('p_maturity_date : ' || p_maturity_date);
862: arp_util.debug('p_special_instructions : ' || p_special_instructions);
863: arp_util.debug('p_batch_process_status : ' || p_batch_process_status);
864: arp_util.debug('p_name : ' || p_name);
865: arp_util.debug('p_selection_criteria_id : ' || p_selection_criteria_id);
866: arp_util.debug('p_due_date_low : ' || p_due_date_low);

Line 863: arp_util.debug('p_batch_process_status : ' || p_batch_process_status);

859: arp_util.debug('p_attribute15 : ' || p_attribute15);
860: arp_util.debug('p_issue_date : ' || p_issue_date);
861: arp_util.debug('p_maturity_date : ' || p_maturity_date);
862: arp_util.debug('p_special_instructions : ' || p_special_instructions);
863: arp_util.debug('p_batch_process_status : ' || p_batch_process_status);
864: arp_util.debug('p_name : ' || p_name);
865: arp_util.debug('p_selection_criteria_id : ' || p_selection_criteria_id);
866: arp_util.debug('p_due_date_low : ' || p_due_date_low);
867: arp_util.debug('p_due_date_high : ' || p_due_date_high);

Line 864: arp_util.debug('p_name : ' || p_name);

860: arp_util.debug('p_issue_date : ' || p_issue_date);
861: arp_util.debug('p_maturity_date : ' || p_maturity_date);
862: arp_util.debug('p_special_instructions : ' || p_special_instructions);
863: arp_util.debug('p_batch_process_status : ' || p_batch_process_status);
864: arp_util.debug('p_name : ' || p_name);
865: arp_util.debug('p_selection_criteria_id : ' || p_selection_criteria_id);
866: arp_util.debug('p_due_date_low : ' || p_due_date_low);
867: arp_util.debug('p_due_date_high : ' || p_due_date_high);
868: arp_util.debug('p_trx_date_low : ' || p_trx_date_low);

Line 865: arp_util.debug('p_selection_criteria_id : ' || p_selection_criteria_id);

861: arp_util.debug('p_maturity_date : ' || p_maturity_date);
862: arp_util.debug('p_special_instructions : ' || p_special_instructions);
863: arp_util.debug('p_batch_process_status : ' || p_batch_process_status);
864: arp_util.debug('p_name : ' || p_name);
865: arp_util.debug('p_selection_criteria_id : ' || p_selection_criteria_id);
866: arp_util.debug('p_due_date_low : ' || p_due_date_low);
867: arp_util.debug('p_due_date_high : ' || p_due_date_high);
868: arp_util.debug('p_trx_date_low : ' || p_trx_date_low);
869: arp_util.debug('p_trx_date_high : ' || p_trx_date_high);

Line 866: arp_util.debug('p_due_date_low : ' || p_due_date_low);

862: arp_util.debug('p_special_instructions : ' || p_special_instructions);
863: arp_util.debug('p_batch_process_status : ' || p_batch_process_status);
864: arp_util.debug('p_name : ' || p_name);
865: arp_util.debug('p_selection_criteria_id : ' || p_selection_criteria_id);
866: arp_util.debug('p_due_date_low : ' || p_due_date_low);
867: arp_util.debug('p_due_date_high : ' || p_due_date_high);
868: arp_util.debug('p_trx_date_low : ' || p_trx_date_low);
869: arp_util.debug('p_trx_date_high : ' || p_trx_date_high);
870: arp_util.debug('p_cust_trx_type_id : ' || p_cust_trx_type_id);

Line 867: arp_util.debug('p_due_date_high : ' || p_due_date_high);

863: arp_util.debug('p_batch_process_status : ' || p_batch_process_status);
864: arp_util.debug('p_name : ' || p_name);
865: arp_util.debug('p_selection_criteria_id : ' || p_selection_criteria_id);
866: arp_util.debug('p_due_date_low : ' || p_due_date_low);
867: arp_util.debug('p_due_date_high : ' || p_due_date_high);
868: arp_util.debug('p_trx_date_low : ' || p_trx_date_low);
869: arp_util.debug('p_trx_date_high : ' || p_trx_date_high);
870: arp_util.debug('p_cust_trx_type_id : ' || p_cust_trx_type_id);
871: arp_util.debug('p_receipt_method_id : ' || p_receipt_method_id);

Line 868: arp_util.debug('p_trx_date_low : ' || p_trx_date_low);

864: arp_util.debug('p_name : ' || p_name);
865: arp_util.debug('p_selection_criteria_id : ' || p_selection_criteria_id);
866: arp_util.debug('p_due_date_low : ' || p_due_date_low);
867: arp_util.debug('p_due_date_high : ' || p_due_date_high);
868: arp_util.debug('p_trx_date_low : ' || p_trx_date_low);
869: arp_util.debug('p_trx_date_high : ' || p_trx_date_high);
870: arp_util.debug('p_cust_trx_type_id : ' || p_cust_trx_type_id);
871: arp_util.debug('p_receipt_method_id : ' || p_receipt_method_id);
872: arp_util.debug('p_bank_branch_id : ' || p_bank_branch_id);

Line 869: arp_util.debug('p_trx_date_high : ' || p_trx_date_high);

865: arp_util.debug('p_selection_criteria_id : ' || p_selection_criteria_id);
866: arp_util.debug('p_due_date_low : ' || p_due_date_low);
867: arp_util.debug('p_due_date_high : ' || p_due_date_high);
868: arp_util.debug('p_trx_date_low : ' || p_trx_date_low);
869: arp_util.debug('p_trx_date_high : ' || p_trx_date_high);
870: arp_util.debug('p_cust_trx_type_id : ' || p_cust_trx_type_id);
871: arp_util.debug('p_receipt_method_id : ' || p_receipt_method_id);
872: arp_util.debug('p_bank_branch_id : ' || p_bank_branch_id);
873: arp_util.debug('p_trx_number_low : ' || p_trx_number_low);

Line 870: arp_util.debug('p_cust_trx_type_id : ' || p_cust_trx_type_id);

866: arp_util.debug('p_due_date_low : ' || p_due_date_low);
867: arp_util.debug('p_due_date_high : ' || p_due_date_high);
868: arp_util.debug('p_trx_date_low : ' || p_trx_date_low);
869: arp_util.debug('p_trx_date_high : ' || p_trx_date_high);
870: arp_util.debug('p_cust_trx_type_id : ' || p_cust_trx_type_id);
871: arp_util.debug('p_receipt_method_id : ' || p_receipt_method_id);
872: arp_util.debug('p_bank_branch_id : ' || p_bank_branch_id);
873: arp_util.debug('p_trx_number_low : ' || p_trx_number_low);
874: arp_util.debug('p_trx_number_high : ' || p_trx_number_high);

Line 871: arp_util.debug('p_receipt_method_id : ' || p_receipt_method_id);

867: arp_util.debug('p_due_date_high : ' || p_due_date_high);
868: arp_util.debug('p_trx_date_low : ' || p_trx_date_low);
869: arp_util.debug('p_trx_date_high : ' || p_trx_date_high);
870: arp_util.debug('p_cust_trx_type_id : ' || p_cust_trx_type_id);
871: arp_util.debug('p_receipt_method_id : ' || p_receipt_method_id);
872: arp_util.debug('p_bank_branch_id : ' || p_bank_branch_id);
873: arp_util.debug('p_trx_number_low : ' || p_trx_number_low);
874: arp_util.debug('p_trx_number_high : ' || p_trx_number_high);
875: arp_util.debug('p_customer_class_code : ' || p_customer_class_code);

Line 872: arp_util.debug('p_bank_branch_id : ' || p_bank_branch_id);

868: arp_util.debug('p_trx_date_low : ' || p_trx_date_low);
869: arp_util.debug('p_trx_date_high : ' || p_trx_date_high);
870: arp_util.debug('p_cust_trx_type_id : ' || p_cust_trx_type_id);
871: arp_util.debug('p_receipt_method_id : ' || p_receipt_method_id);
872: arp_util.debug('p_bank_branch_id : ' || p_bank_branch_id);
873: arp_util.debug('p_trx_number_low : ' || p_trx_number_low);
874: arp_util.debug('p_trx_number_high : ' || p_trx_number_high);
875: arp_util.debug('p_customer_class_code : ' || p_customer_class_code);
876: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);

Line 873: arp_util.debug('p_trx_number_low : ' || p_trx_number_low);

869: arp_util.debug('p_trx_date_high : ' || p_trx_date_high);
870: arp_util.debug('p_cust_trx_type_id : ' || p_cust_trx_type_id);
871: arp_util.debug('p_receipt_method_id : ' || p_receipt_method_id);
872: arp_util.debug('p_bank_branch_id : ' || p_bank_branch_id);
873: arp_util.debug('p_trx_number_low : ' || p_trx_number_low);
874: arp_util.debug('p_trx_number_high : ' || p_trx_number_high);
875: arp_util.debug('p_customer_class_code : ' || p_customer_class_code);
876: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
877: arp_util.debug('p_customer_id : ' || p_customer_id);

Line 874: arp_util.debug('p_trx_number_high : ' || p_trx_number_high);

870: arp_util.debug('p_cust_trx_type_id : ' || p_cust_trx_type_id);
871: arp_util.debug('p_receipt_method_id : ' || p_receipt_method_id);
872: arp_util.debug('p_bank_branch_id : ' || p_bank_branch_id);
873: arp_util.debug('p_trx_number_low : ' || p_trx_number_low);
874: arp_util.debug('p_trx_number_high : ' || p_trx_number_high);
875: arp_util.debug('p_customer_class_code : ' || p_customer_class_code);
876: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
877: arp_util.debug('p_customer_id : ' || p_customer_id);
878: arp_util.debug('p_site_use_id : ' || p_site_use_id);

Line 875: arp_util.debug('p_customer_class_code : ' || p_customer_class_code);

871: arp_util.debug('p_receipt_method_id : ' || p_receipt_method_id);
872: arp_util.debug('p_bank_branch_id : ' || p_bank_branch_id);
873: arp_util.debug('p_trx_number_low : ' || p_trx_number_low);
874: arp_util.debug('p_trx_number_high : ' || p_trx_number_high);
875: arp_util.debug('p_customer_class_code : ' || p_customer_class_code);
876: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
877: arp_util.debug('p_customer_id : ' || p_customer_id);
878: arp_util.debug('p_site_use_id : ' || p_site_use_id);
879: RAISE;

Line 876: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);

872: arp_util.debug('p_bank_branch_id : ' || p_bank_branch_id);
873: arp_util.debug('p_trx_number_low : ' || p_trx_number_low);
874: arp_util.debug('p_trx_number_high : ' || p_trx_number_high);
875: arp_util.debug('p_customer_class_code : ' || p_customer_class_code);
876: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
877: arp_util.debug('p_customer_id : ' || p_customer_id);
878: arp_util.debug('p_site_use_id : ' || p_site_use_id);
879: RAISE;
880: END;

Line 877: arp_util.debug('p_customer_id : ' || p_customer_id);

873: arp_util.debug('p_trx_number_low : ' || p_trx_number_low);
874: arp_util.debug('p_trx_number_high : ' || p_trx_number_high);
875: arp_util.debug('p_customer_class_code : ' || p_customer_class_code);
876: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
877: arp_util.debug('p_customer_id : ' || p_customer_id);
878: arp_util.debug('p_site_use_id : ' || p_site_use_id);
879: RAISE;
880: END;
881:

Line 878: arp_util.debug('p_site_use_id : ' || p_site_use_id);

874: arp_util.debug('p_trx_number_high : ' || p_trx_number_high);
875: arp_util.debug('p_customer_class_code : ' || p_customer_class_code);
876: arp_util.debug('p_customer_category_code: ' || p_customer_category_code);
877: arp_util.debug('p_customer_id : ' || p_customer_id);
878: arp_util.debug('p_site_use_id : ' || p_site_use_id);
879: RAISE;
880: END;
881:
882:

Line 894: | arp_util.debug |

890: | |
891: | SCOPE - PRIVATE |
892: | |
893: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
894: | arp_util.debug |
895: | |
896: | ARGUMENTS : IN: |
897: | p_form_name |
898: | p_form_version |

Line 993: arp_util.debug('ARP_PROCESS_BR_BATCHES.update_batch()+');

989:
990:
991: BEGIN
992: IF PG_DEBUG in ('Y', 'C') THEN
993: arp_util.debug('ARP_PROCESS_BR_BATCHES.update_batch()+');
994: END IF;
995:
996:
997: /*-------------------------------------------------------------+

Line 1130: arp_util.debug('ARP_PROCESS_BR_BATCHES.update_batch()-');

1126:
1127: END IF;
1128:
1129: IF PG_DEBUG in ('Y', 'C') THEN
1130: arp_util.debug('ARP_PROCESS_BR_BATCHES.update_batch()-');
1131: END IF;
1132:
1133: EXCEPTION
1134: WHEN OTHERS THEN

Line 1136: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.update_batch');

1132:
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: IF PG_DEBUG in ('Y', 'C') THEN
1136: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.update_batch');
1137: arp_util.debug('update_batch: ' || 'p_batch_source_id : ' || p_batch_source_id);
1138: arp_util.debug('update_batch: ' || 'p_batch_date : ' || p_batch_date);
1139: arp_util.debug('update_batch: ' || 'p_gl_date : ' || p_gl_date);
1140: arp_util.debug('update_batch: ' || 'p_type : ' || p_type);

Line 1137: arp_util.debug('update_batch: ' || 'p_batch_source_id : ' || p_batch_source_id);

1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: IF PG_DEBUG in ('Y', 'C') THEN
1136: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.update_batch');
1137: arp_util.debug('update_batch: ' || 'p_batch_source_id : ' || p_batch_source_id);
1138: arp_util.debug('update_batch: ' || 'p_batch_date : ' || p_batch_date);
1139: arp_util.debug('update_batch: ' || 'p_gl_date : ' || p_gl_date);
1140: arp_util.debug('update_batch: ' || 'p_type : ' || p_type);
1141: arp_util.debug('update_batch: ' || 'p_currency_code : ' || p_currency_code);

Line 1138: arp_util.debug('update_batch: ' || 'p_batch_date : ' || p_batch_date);

1134: WHEN OTHERS THEN
1135: IF PG_DEBUG in ('Y', 'C') THEN
1136: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.update_batch');
1137: arp_util.debug('update_batch: ' || 'p_batch_source_id : ' || p_batch_source_id);
1138: arp_util.debug('update_batch: ' || 'p_batch_date : ' || p_batch_date);
1139: arp_util.debug('update_batch: ' || 'p_gl_date : ' || p_gl_date);
1140: arp_util.debug('update_batch: ' || 'p_type : ' || p_type);
1141: arp_util.debug('update_batch: ' || 'p_currency_code : ' || p_currency_code);
1142: arp_util.debug('update_batch: ' || 'p_comments : ' || p_comments);

Line 1139: arp_util.debug('update_batch: ' || 'p_gl_date : ' || p_gl_date);

1135: IF PG_DEBUG in ('Y', 'C') THEN
1136: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.update_batch');
1137: arp_util.debug('update_batch: ' || 'p_batch_source_id : ' || p_batch_source_id);
1138: arp_util.debug('update_batch: ' || 'p_batch_date : ' || p_batch_date);
1139: arp_util.debug('update_batch: ' || 'p_gl_date : ' || p_gl_date);
1140: arp_util.debug('update_batch: ' || 'p_type : ' || p_type);
1141: arp_util.debug('update_batch: ' || 'p_currency_code : ' || p_currency_code);
1142: arp_util.debug('update_batch: ' || 'p_comments : ' || p_comments);
1143: arp_util.debug('update_batch: ' || 'p_attribute_category : ' || p_attribute_category);

Line 1140: arp_util.debug('update_batch: ' || 'p_type : ' || p_type);

1136: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.update_batch');
1137: arp_util.debug('update_batch: ' || 'p_batch_source_id : ' || p_batch_source_id);
1138: arp_util.debug('update_batch: ' || 'p_batch_date : ' || p_batch_date);
1139: arp_util.debug('update_batch: ' || 'p_gl_date : ' || p_gl_date);
1140: arp_util.debug('update_batch: ' || 'p_type : ' || p_type);
1141: arp_util.debug('update_batch: ' || 'p_currency_code : ' || p_currency_code);
1142: arp_util.debug('update_batch: ' || 'p_comments : ' || p_comments);
1143: arp_util.debug('update_batch: ' || 'p_attribute_category : ' || p_attribute_category);
1144: arp_util.debug('update_batch: ' || 'p_attribute1 : ' || p_attribute1);

Line 1141: arp_util.debug('update_batch: ' || 'p_currency_code : ' || p_currency_code);

1137: arp_util.debug('update_batch: ' || 'p_batch_source_id : ' || p_batch_source_id);
1138: arp_util.debug('update_batch: ' || 'p_batch_date : ' || p_batch_date);
1139: arp_util.debug('update_batch: ' || 'p_gl_date : ' || p_gl_date);
1140: arp_util.debug('update_batch: ' || 'p_type : ' || p_type);
1141: arp_util.debug('update_batch: ' || 'p_currency_code : ' || p_currency_code);
1142: arp_util.debug('update_batch: ' || 'p_comments : ' || p_comments);
1143: arp_util.debug('update_batch: ' || 'p_attribute_category : ' || p_attribute_category);
1144: arp_util.debug('update_batch: ' || 'p_attribute1 : ' || p_attribute1);
1145: arp_util.debug('update_batch: ' || 'p_attribute2 : ' || p_attribute2);

Line 1142: arp_util.debug('update_batch: ' || 'p_comments : ' || p_comments);

1138: arp_util.debug('update_batch: ' || 'p_batch_date : ' || p_batch_date);
1139: arp_util.debug('update_batch: ' || 'p_gl_date : ' || p_gl_date);
1140: arp_util.debug('update_batch: ' || 'p_type : ' || p_type);
1141: arp_util.debug('update_batch: ' || 'p_currency_code : ' || p_currency_code);
1142: arp_util.debug('update_batch: ' || 'p_comments : ' || p_comments);
1143: arp_util.debug('update_batch: ' || 'p_attribute_category : ' || p_attribute_category);
1144: arp_util.debug('update_batch: ' || 'p_attribute1 : ' || p_attribute1);
1145: arp_util.debug('update_batch: ' || 'p_attribute2 : ' || p_attribute2);
1146: arp_util.debug('update_batch: ' || 'p_attribute3 : ' || p_attribute3);

Line 1143: arp_util.debug('update_batch: ' || 'p_attribute_category : ' || p_attribute_category);

1139: arp_util.debug('update_batch: ' || 'p_gl_date : ' || p_gl_date);
1140: arp_util.debug('update_batch: ' || 'p_type : ' || p_type);
1141: arp_util.debug('update_batch: ' || 'p_currency_code : ' || p_currency_code);
1142: arp_util.debug('update_batch: ' || 'p_comments : ' || p_comments);
1143: arp_util.debug('update_batch: ' || 'p_attribute_category : ' || p_attribute_category);
1144: arp_util.debug('update_batch: ' || 'p_attribute1 : ' || p_attribute1);
1145: arp_util.debug('update_batch: ' || 'p_attribute2 : ' || p_attribute2);
1146: arp_util.debug('update_batch: ' || 'p_attribute3 : ' || p_attribute3);
1147: arp_util.debug('update_batch: ' || 'p_attribute4 : ' || p_attribute4);

Line 1144: arp_util.debug('update_batch: ' || 'p_attribute1 : ' || p_attribute1);

1140: arp_util.debug('update_batch: ' || 'p_type : ' || p_type);
1141: arp_util.debug('update_batch: ' || 'p_currency_code : ' || p_currency_code);
1142: arp_util.debug('update_batch: ' || 'p_comments : ' || p_comments);
1143: arp_util.debug('update_batch: ' || 'p_attribute_category : ' || p_attribute_category);
1144: arp_util.debug('update_batch: ' || 'p_attribute1 : ' || p_attribute1);
1145: arp_util.debug('update_batch: ' || 'p_attribute2 : ' || p_attribute2);
1146: arp_util.debug('update_batch: ' || 'p_attribute3 : ' || p_attribute3);
1147: arp_util.debug('update_batch: ' || 'p_attribute4 : ' || p_attribute4);
1148: arp_util.debug('update_batch: ' || 'p_attribute5 : ' || p_attribute5);

Line 1145: arp_util.debug('update_batch: ' || 'p_attribute2 : ' || p_attribute2);

1141: arp_util.debug('update_batch: ' || 'p_currency_code : ' || p_currency_code);
1142: arp_util.debug('update_batch: ' || 'p_comments : ' || p_comments);
1143: arp_util.debug('update_batch: ' || 'p_attribute_category : ' || p_attribute_category);
1144: arp_util.debug('update_batch: ' || 'p_attribute1 : ' || p_attribute1);
1145: arp_util.debug('update_batch: ' || 'p_attribute2 : ' || p_attribute2);
1146: arp_util.debug('update_batch: ' || 'p_attribute3 : ' || p_attribute3);
1147: arp_util.debug('update_batch: ' || 'p_attribute4 : ' || p_attribute4);
1148: arp_util.debug('update_batch: ' || 'p_attribute5 : ' || p_attribute5);
1149: arp_util.debug('update_batch: ' || 'p_attribute6 : ' || p_attribute6);

Line 1146: arp_util.debug('update_batch: ' || 'p_attribute3 : ' || p_attribute3);

1142: arp_util.debug('update_batch: ' || 'p_comments : ' || p_comments);
1143: arp_util.debug('update_batch: ' || 'p_attribute_category : ' || p_attribute_category);
1144: arp_util.debug('update_batch: ' || 'p_attribute1 : ' || p_attribute1);
1145: arp_util.debug('update_batch: ' || 'p_attribute2 : ' || p_attribute2);
1146: arp_util.debug('update_batch: ' || 'p_attribute3 : ' || p_attribute3);
1147: arp_util.debug('update_batch: ' || 'p_attribute4 : ' || p_attribute4);
1148: arp_util.debug('update_batch: ' || 'p_attribute5 : ' || p_attribute5);
1149: arp_util.debug('update_batch: ' || 'p_attribute6 : ' || p_attribute6);
1150: arp_util.debug('update_batch: ' || 'p_attribute7 : ' || p_attribute7);

Line 1147: arp_util.debug('update_batch: ' || 'p_attribute4 : ' || p_attribute4);

1143: arp_util.debug('update_batch: ' || 'p_attribute_category : ' || p_attribute_category);
1144: arp_util.debug('update_batch: ' || 'p_attribute1 : ' || p_attribute1);
1145: arp_util.debug('update_batch: ' || 'p_attribute2 : ' || p_attribute2);
1146: arp_util.debug('update_batch: ' || 'p_attribute3 : ' || p_attribute3);
1147: arp_util.debug('update_batch: ' || 'p_attribute4 : ' || p_attribute4);
1148: arp_util.debug('update_batch: ' || 'p_attribute5 : ' || p_attribute5);
1149: arp_util.debug('update_batch: ' || 'p_attribute6 : ' || p_attribute6);
1150: arp_util.debug('update_batch: ' || 'p_attribute7 : ' || p_attribute7);
1151: arp_util.debug('update_batch: ' || 'p_attribute8 : ' || p_attribute8);

Line 1148: arp_util.debug('update_batch: ' || 'p_attribute5 : ' || p_attribute5);

1144: arp_util.debug('update_batch: ' || 'p_attribute1 : ' || p_attribute1);
1145: arp_util.debug('update_batch: ' || 'p_attribute2 : ' || p_attribute2);
1146: arp_util.debug('update_batch: ' || 'p_attribute3 : ' || p_attribute3);
1147: arp_util.debug('update_batch: ' || 'p_attribute4 : ' || p_attribute4);
1148: arp_util.debug('update_batch: ' || 'p_attribute5 : ' || p_attribute5);
1149: arp_util.debug('update_batch: ' || 'p_attribute6 : ' || p_attribute6);
1150: arp_util.debug('update_batch: ' || 'p_attribute7 : ' || p_attribute7);
1151: arp_util.debug('update_batch: ' || 'p_attribute8 : ' || p_attribute8);
1152: arp_util.debug('update_batch: ' || 'p_attribute9 : ' || p_attribute9);

Line 1149: arp_util.debug('update_batch: ' || 'p_attribute6 : ' || p_attribute6);

1145: arp_util.debug('update_batch: ' || 'p_attribute2 : ' || p_attribute2);
1146: arp_util.debug('update_batch: ' || 'p_attribute3 : ' || p_attribute3);
1147: arp_util.debug('update_batch: ' || 'p_attribute4 : ' || p_attribute4);
1148: arp_util.debug('update_batch: ' || 'p_attribute5 : ' || p_attribute5);
1149: arp_util.debug('update_batch: ' || 'p_attribute6 : ' || p_attribute6);
1150: arp_util.debug('update_batch: ' || 'p_attribute7 : ' || p_attribute7);
1151: arp_util.debug('update_batch: ' || 'p_attribute8 : ' || p_attribute8);
1152: arp_util.debug('update_batch: ' || 'p_attribute9 : ' || p_attribute9);
1153: arp_util.debug('update_batch: ' || 'p_attribute10 : ' || p_attribute10);

Line 1150: arp_util.debug('update_batch: ' || 'p_attribute7 : ' || p_attribute7);

1146: arp_util.debug('update_batch: ' || 'p_attribute3 : ' || p_attribute3);
1147: arp_util.debug('update_batch: ' || 'p_attribute4 : ' || p_attribute4);
1148: arp_util.debug('update_batch: ' || 'p_attribute5 : ' || p_attribute5);
1149: arp_util.debug('update_batch: ' || 'p_attribute6 : ' || p_attribute6);
1150: arp_util.debug('update_batch: ' || 'p_attribute7 : ' || p_attribute7);
1151: arp_util.debug('update_batch: ' || 'p_attribute8 : ' || p_attribute8);
1152: arp_util.debug('update_batch: ' || 'p_attribute9 : ' || p_attribute9);
1153: arp_util.debug('update_batch: ' || 'p_attribute10 : ' || p_attribute10);
1154: arp_util.debug('update_batch: ' || 'p_attribute11 : ' || p_attribute11);

Line 1151: arp_util.debug('update_batch: ' || 'p_attribute8 : ' || p_attribute8);

1147: arp_util.debug('update_batch: ' || 'p_attribute4 : ' || p_attribute4);
1148: arp_util.debug('update_batch: ' || 'p_attribute5 : ' || p_attribute5);
1149: arp_util.debug('update_batch: ' || 'p_attribute6 : ' || p_attribute6);
1150: arp_util.debug('update_batch: ' || 'p_attribute7 : ' || p_attribute7);
1151: arp_util.debug('update_batch: ' || 'p_attribute8 : ' || p_attribute8);
1152: arp_util.debug('update_batch: ' || 'p_attribute9 : ' || p_attribute9);
1153: arp_util.debug('update_batch: ' || 'p_attribute10 : ' || p_attribute10);
1154: arp_util.debug('update_batch: ' || 'p_attribute11 : ' || p_attribute11);
1155: arp_util.debug('update_batch: ' || 'p_attribute12 : ' || p_attribute12);

Line 1152: arp_util.debug('update_batch: ' || 'p_attribute9 : ' || p_attribute9);

1148: arp_util.debug('update_batch: ' || 'p_attribute5 : ' || p_attribute5);
1149: arp_util.debug('update_batch: ' || 'p_attribute6 : ' || p_attribute6);
1150: arp_util.debug('update_batch: ' || 'p_attribute7 : ' || p_attribute7);
1151: arp_util.debug('update_batch: ' || 'p_attribute8 : ' || p_attribute8);
1152: arp_util.debug('update_batch: ' || 'p_attribute9 : ' || p_attribute9);
1153: arp_util.debug('update_batch: ' || 'p_attribute10 : ' || p_attribute10);
1154: arp_util.debug('update_batch: ' || 'p_attribute11 : ' || p_attribute11);
1155: arp_util.debug('update_batch: ' || 'p_attribute12 : ' || p_attribute12);
1156: arp_util.debug('update_batch: ' || 'p_attribute13 : ' || p_attribute13);

Line 1153: arp_util.debug('update_batch: ' || 'p_attribute10 : ' || p_attribute10);

1149: arp_util.debug('update_batch: ' || 'p_attribute6 : ' || p_attribute6);
1150: arp_util.debug('update_batch: ' || 'p_attribute7 : ' || p_attribute7);
1151: arp_util.debug('update_batch: ' || 'p_attribute8 : ' || p_attribute8);
1152: arp_util.debug('update_batch: ' || 'p_attribute9 : ' || p_attribute9);
1153: arp_util.debug('update_batch: ' || 'p_attribute10 : ' || p_attribute10);
1154: arp_util.debug('update_batch: ' || 'p_attribute11 : ' || p_attribute11);
1155: arp_util.debug('update_batch: ' || 'p_attribute12 : ' || p_attribute12);
1156: arp_util.debug('update_batch: ' || 'p_attribute13 : ' || p_attribute13);
1157: arp_util.debug('update_batch: ' || 'p_attribute14 : ' || p_attribute14);

Line 1154: arp_util.debug('update_batch: ' || 'p_attribute11 : ' || p_attribute11);

1150: arp_util.debug('update_batch: ' || 'p_attribute7 : ' || p_attribute7);
1151: arp_util.debug('update_batch: ' || 'p_attribute8 : ' || p_attribute8);
1152: arp_util.debug('update_batch: ' || 'p_attribute9 : ' || p_attribute9);
1153: arp_util.debug('update_batch: ' || 'p_attribute10 : ' || p_attribute10);
1154: arp_util.debug('update_batch: ' || 'p_attribute11 : ' || p_attribute11);
1155: arp_util.debug('update_batch: ' || 'p_attribute12 : ' || p_attribute12);
1156: arp_util.debug('update_batch: ' || 'p_attribute13 : ' || p_attribute13);
1157: arp_util.debug('update_batch: ' || 'p_attribute14 : ' || p_attribute14);
1158: arp_util.debug('update_batch: ' || 'p_attribute15 : ' || p_attribute15);

Line 1155: arp_util.debug('update_batch: ' || 'p_attribute12 : ' || p_attribute12);

1151: arp_util.debug('update_batch: ' || 'p_attribute8 : ' || p_attribute8);
1152: arp_util.debug('update_batch: ' || 'p_attribute9 : ' || p_attribute9);
1153: arp_util.debug('update_batch: ' || 'p_attribute10 : ' || p_attribute10);
1154: arp_util.debug('update_batch: ' || 'p_attribute11 : ' || p_attribute11);
1155: arp_util.debug('update_batch: ' || 'p_attribute12 : ' || p_attribute12);
1156: arp_util.debug('update_batch: ' || 'p_attribute13 : ' || p_attribute13);
1157: arp_util.debug('update_batch: ' || 'p_attribute14 : ' || p_attribute14);
1158: arp_util.debug('update_batch: ' || 'p_attribute15 : ' || p_attribute15);
1159: arp_util.debug('update_batch: ' || 'p_issue_date : ' || p_issue_date);

Line 1156: arp_util.debug('update_batch: ' || 'p_attribute13 : ' || p_attribute13);

1152: arp_util.debug('update_batch: ' || 'p_attribute9 : ' || p_attribute9);
1153: arp_util.debug('update_batch: ' || 'p_attribute10 : ' || p_attribute10);
1154: arp_util.debug('update_batch: ' || 'p_attribute11 : ' || p_attribute11);
1155: arp_util.debug('update_batch: ' || 'p_attribute12 : ' || p_attribute12);
1156: arp_util.debug('update_batch: ' || 'p_attribute13 : ' || p_attribute13);
1157: arp_util.debug('update_batch: ' || 'p_attribute14 : ' || p_attribute14);
1158: arp_util.debug('update_batch: ' || 'p_attribute15 : ' || p_attribute15);
1159: arp_util.debug('update_batch: ' || 'p_issue_date : ' || p_issue_date);
1160: arp_util.debug('update_batch: ' || 'p_maturity_date : ' || p_maturity_date);

Line 1157: arp_util.debug('update_batch: ' || 'p_attribute14 : ' || p_attribute14);

1153: arp_util.debug('update_batch: ' || 'p_attribute10 : ' || p_attribute10);
1154: arp_util.debug('update_batch: ' || 'p_attribute11 : ' || p_attribute11);
1155: arp_util.debug('update_batch: ' || 'p_attribute12 : ' || p_attribute12);
1156: arp_util.debug('update_batch: ' || 'p_attribute13 : ' || p_attribute13);
1157: arp_util.debug('update_batch: ' || 'p_attribute14 : ' || p_attribute14);
1158: arp_util.debug('update_batch: ' || 'p_attribute15 : ' || p_attribute15);
1159: arp_util.debug('update_batch: ' || 'p_issue_date : ' || p_issue_date);
1160: arp_util.debug('update_batch: ' || 'p_maturity_date : ' || p_maturity_date);
1161: arp_util.debug('update_batch: ' || 'p_special_instructions : ' || p_special_instructions);

Line 1158: arp_util.debug('update_batch: ' || 'p_attribute15 : ' || p_attribute15);

1154: arp_util.debug('update_batch: ' || 'p_attribute11 : ' || p_attribute11);
1155: arp_util.debug('update_batch: ' || 'p_attribute12 : ' || p_attribute12);
1156: arp_util.debug('update_batch: ' || 'p_attribute13 : ' || p_attribute13);
1157: arp_util.debug('update_batch: ' || 'p_attribute14 : ' || p_attribute14);
1158: arp_util.debug('update_batch: ' || 'p_attribute15 : ' || p_attribute15);
1159: arp_util.debug('update_batch: ' || 'p_issue_date : ' || p_issue_date);
1160: arp_util.debug('update_batch: ' || 'p_maturity_date : ' || p_maturity_date);
1161: arp_util.debug('update_batch: ' || 'p_special_instructions : ' || p_special_instructions);
1162: arp_util.debug('update_batch: ' || 'p_batch_process_status : ' || p_batch_process_status);

Line 1159: arp_util.debug('update_batch: ' || 'p_issue_date : ' || p_issue_date);

1155: arp_util.debug('update_batch: ' || 'p_attribute12 : ' || p_attribute12);
1156: arp_util.debug('update_batch: ' || 'p_attribute13 : ' || p_attribute13);
1157: arp_util.debug('update_batch: ' || 'p_attribute14 : ' || p_attribute14);
1158: arp_util.debug('update_batch: ' || 'p_attribute15 : ' || p_attribute15);
1159: arp_util.debug('update_batch: ' || 'p_issue_date : ' || p_issue_date);
1160: arp_util.debug('update_batch: ' || 'p_maturity_date : ' || p_maturity_date);
1161: arp_util.debug('update_batch: ' || 'p_special_instructions : ' || p_special_instructions);
1162: arp_util.debug('update_batch: ' || 'p_batch_process_status : ' || p_batch_process_status);
1163: arp_util.debug('update_batch: ' || 'p_name : ' || p_name);

Line 1160: arp_util.debug('update_batch: ' || 'p_maturity_date : ' || p_maturity_date);

1156: arp_util.debug('update_batch: ' || 'p_attribute13 : ' || p_attribute13);
1157: arp_util.debug('update_batch: ' || 'p_attribute14 : ' || p_attribute14);
1158: arp_util.debug('update_batch: ' || 'p_attribute15 : ' || p_attribute15);
1159: arp_util.debug('update_batch: ' || 'p_issue_date : ' || p_issue_date);
1160: arp_util.debug('update_batch: ' || 'p_maturity_date : ' || p_maturity_date);
1161: arp_util.debug('update_batch: ' || 'p_special_instructions : ' || p_special_instructions);
1162: arp_util.debug('update_batch: ' || 'p_batch_process_status : ' || p_batch_process_status);
1163: arp_util.debug('update_batch: ' || 'p_name : ' || p_name);
1164: arp_util.debug('update_batch: ' || 'p_selection_criteria_id : ' || p_selection_criteria_id);

Line 1161: arp_util.debug('update_batch: ' || 'p_special_instructions : ' || p_special_instructions);

1157: arp_util.debug('update_batch: ' || 'p_attribute14 : ' || p_attribute14);
1158: arp_util.debug('update_batch: ' || 'p_attribute15 : ' || p_attribute15);
1159: arp_util.debug('update_batch: ' || 'p_issue_date : ' || p_issue_date);
1160: arp_util.debug('update_batch: ' || 'p_maturity_date : ' || p_maturity_date);
1161: arp_util.debug('update_batch: ' || 'p_special_instructions : ' || p_special_instructions);
1162: arp_util.debug('update_batch: ' || 'p_batch_process_status : ' || p_batch_process_status);
1163: arp_util.debug('update_batch: ' || 'p_name : ' || p_name);
1164: arp_util.debug('update_batch: ' || 'p_selection_criteria_id : ' || p_selection_criteria_id);
1165: arp_util.debug('update_batch: ' || 'p_due_date_low : ' || p_due_date_low);

Line 1162: arp_util.debug('update_batch: ' || 'p_batch_process_status : ' || p_batch_process_status);

1158: arp_util.debug('update_batch: ' || 'p_attribute15 : ' || p_attribute15);
1159: arp_util.debug('update_batch: ' || 'p_issue_date : ' || p_issue_date);
1160: arp_util.debug('update_batch: ' || 'p_maturity_date : ' || p_maturity_date);
1161: arp_util.debug('update_batch: ' || 'p_special_instructions : ' || p_special_instructions);
1162: arp_util.debug('update_batch: ' || 'p_batch_process_status : ' || p_batch_process_status);
1163: arp_util.debug('update_batch: ' || 'p_name : ' || p_name);
1164: arp_util.debug('update_batch: ' || 'p_selection_criteria_id : ' || p_selection_criteria_id);
1165: arp_util.debug('update_batch: ' || 'p_due_date_low : ' || p_due_date_low);
1166: arp_util.debug('update_batch: ' || 'p_due_date_high : ' || p_due_date_high);

Line 1163: arp_util.debug('update_batch: ' || 'p_name : ' || p_name);

1159: arp_util.debug('update_batch: ' || 'p_issue_date : ' || p_issue_date);
1160: arp_util.debug('update_batch: ' || 'p_maturity_date : ' || p_maturity_date);
1161: arp_util.debug('update_batch: ' || 'p_special_instructions : ' || p_special_instructions);
1162: arp_util.debug('update_batch: ' || 'p_batch_process_status : ' || p_batch_process_status);
1163: arp_util.debug('update_batch: ' || 'p_name : ' || p_name);
1164: arp_util.debug('update_batch: ' || 'p_selection_criteria_id : ' || p_selection_criteria_id);
1165: arp_util.debug('update_batch: ' || 'p_due_date_low : ' || p_due_date_low);
1166: arp_util.debug('update_batch: ' || 'p_due_date_high : ' || p_due_date_high);
1167: arp_util.debug('update_batch: ' || 'p_trx_date_low : ' || p_trx_date_low);

Line 1164: arp_util.debug('update_batch: ' || 'p_selection_criteria_id : ' || p_selection_criteria_id);

1160: arp_util.debug('update_batch: ' || 'p_maturity_date : ' || p_maturity_date);
1161: arp_util.debug('update_batch: ' || 'p_special_instructions : ' || p_special_instructions);
1162: arp_util.debug('update_batch: ' || 'p_batch_process_status : ' || p_batch_process_status);
1163: arp_util.debug('update_batch: ' || 'p_name : ' || p_name);
1164: arp_util.debug('update_batch: ' || 'p_selection_criteria_id : ' || p_selection_criteria_id);
1165: arp_util.debug('update_batch: ' || 'p_due_date_low : ' || p_due_date_low);
1166: arp_util.debug('update_batch: ' || 'p_due_date_high : ' || p_due_date_high);
1167: arp_util.debug('update_batch: ' || 'p_trx_date_low : ' || p_trx_date_low);
1168: arp_util.debug('update_batch: ' || 'p_trx_date_high : ' || p_trx_date_high);

Line 1165: arp_util.debug('update_batch: ' || 'p_due_date_low : ' || p_due_date_low);

1161: arp_util.debug('update_batch: ' || 'p_special_instructions : ' || p_special_instructions);
1162: arp_util.debug('update_batch: ' || 'p_batch_process_status : ' || p_batch_process_status);
1163: arp_util.debug('update_batch: ' || 'p_name : ' || p_name);
1164: arp_util.debug('update_batch: ' || 'p_selection_criteria_id : ' || p_selection_criteria_id);
1165: arp_util.debug('update_batch: ' || 'p_due_date_low : ' || p_due_date_low);
1166: arp_util.debug('update_batch: ' || 'p_due_date_high : ' || p_due_date_high);
1167: arp_util.debug('update_batch: ' || 'p_trx_date_low : ' || p_trx_date_low);
1168: arp_util.debug('update_batch: ' || 'p_trx_date_high : ' || p_trx_date_high);
1169: arp_util.debug('update_batch: ' || 'p_cust_trx_type_id : ' || p_cust_trx_type_id);

Line 1166: arp_util.debug('update_batch: ' || 'p_due_date_high : ' || p_due_date_high);

1162: arp_util.debug('update_batch: ' || 'p_batch_process_status : ' || p_batch_process_status);
1163: arp_util.debug('update_batch: ' || 'p_name : ' || p_name);
1164: arp_util.debug('update_batch: ' || 'p_selection_criteria_id : ' || p_selection_criteria_id);
1165: arp_util.debug('update_batch: ' || 'p_due_date_low : ' || p_due_date_low);
1166: arp_util.debug('update_batch: ' || 'p_due_date_high : ' || p_due_date_high);
1167: arp_util.debug('update_batch: ' || 'p_trx_date_low : ' || p_trx_date_low);
1168: arp_util.debug('update_batch: ' || 'p_trx_date_high : ' || p_trx_date_high);
1169: arp_util.debug('update_batch: ' || 'p_cust_trx_type_id : ' || p_cust_trx_type_id);
1170: arp_util.debug('update_batch: ' || 'p_receipt_method_id : ' || p_receipt_method_id);

Line 1167: arp_util.debug('update_batch: ' || 'p_trx_date_low : ' || p_trx_date_low);

1163: arp_util.debug('update_batch: ' || 'p_name : ' || p_name);
1164: arp_util.debug('update_batch: ' || 'p_selection_criteria_id : ' || p_selection_criteria_id);
1165: arp_util.debug('update_batch: ' || 'p_due_date_low : ' || p_due_date_low);
1166: arp_util.debug('update_batch: ' || 'p_due_date_high : ' || p_due_date_high);
1167: arp_util.debug('update_batch: ' || 'p_trx_date_low : ' || p_trx_date_low);
1168: arp_util.debug('update_batch: ' || 'p_trx_date_high : ' || p_trx_date_high);
1169: arp_util.debug('update_batch: ' || 'p_cust_trx_type_id : ' || p_cust_trx_type_id);
1170: arp_util.debug('update_batch: ' || 'p_receipt_method_id : ' || p_receipt_method_id);
1171: arp_util.debug('update_batch: ' || 'p_bank_branch_id : ' || p_bank_branch_id);

Line 1168: arp_util.debug('update_batch: ' || 'p_trx_date_high : ' || p_trx_date_high);

1164: arp_util.debug('update_batch: ' || 'p_selection_criteria_id : ' || p_selection_criteria_id);
1165: arp_util.debug('update_batch: ' || 'p_due_date_low : ' || p_due_date_low);
1166: arp_util.debug('update_batch: ' || 'p_due_date_high : ' || p_due_date_high);
1167: arp_util.debug('update_batch: ' || 'p_trx_date_low : ' || p_trx_date_low);
1168: arp_util.debug('update_batch: ' || 'p_trx_date_high : ' || p_trx_date_high);
1169: arp_util.debug('update_batch: ' || 'p_cust_trx_type_id : ' || p_cust_trx_type_id);
1170: arp_util.debug('update_batch: ' || 'p_receipt_method_id : ' || p_receipt_method_id);
1171: arp_util.debug('update_batch: ' || 'p_bank_branch_id : ' || p_bank_branch_id);
1172: arp_util.debug('update_batch: ' || 'p_trx_number_low : ' || p_trx_number_low);

Line 1169: arp_util.debug('update_batch: ' || 'p_cust_trx_type_id : ' || p_cust_trx_type_id);

1165: arp_util.debug('update_batch: ' || 'p_due_date_low : ' || p_due_date_low);
1166: arp_util.debug('update_batch: ' || 'p_due_date_high : ' || p_due_date_high);
1167: arp_util.debug('update_batch: ' || 'p_trx_date_low : ' || p_trx_date_low);
1168: arp_util.debug('update_batch: ' || 'p_trx_date_high : ' || p_trx_date_high);
1169: arp_util.debug('update_batch: ' || 'p_cust_trx_type_id : ' || p_cust_trx_type_id);
1170: arp_util.debug('update_batch: ' || 'p_receipt_method_id : ' || p_receipt_method_id);
1171: arp_util.debug('update_batch: ' || 'p_bank_branch_id : ' || p_bank_branch_id);
1172: arp_util.debug('update_batch: ' || 'p_trx_number_low : ' || p_trx_number_low);
1173: arp_util.debug('update_batch: ' || 'p_trx_number_high : ' || p_trx_number_high);

Line 1170: arp_util.debug('update_batch: ' || 'p_receipt_method_id : ' || p_receipt_method_id);

1166: arp_util.debug('update_batch: ' || 'p_due_date_high : ' || p_due_date_high);
1167: arp_util.debug('update_batch: ' || 'p_trx_date_low : ' || p_trx_date_low);
1168: arp_util.debug('update_batch: ' || 'p_trx_date_high : ' || p_trx_date_high);
1169: arp_util.debug('update_batch: ' || 'p_cust_trx_type_id : ' || p_cust_trx_type_id);
1170: arp_util.debug('update_batch: ' || 'p_receipt_method_id : ' || p_receipt_method_id);
1171: arp_util.debug('update_batch: ' || 'p_bank_branch_id : ' || p_bank_branch_id);
1172: arp_util.debug('update_batch: ' || 'p_trx_number_low : ' || p_trx_number_low);
1173: arp_util.debug('update_batch: ' || 'p_trx_number_high : ' || p_trx_number_high);
1174: arp_util.debug('update_batch: ' || 'p_customer_class_code : ' || p_customer_class_code);

Line 1171: arp_util.debug('update_batch: ' || 'p_bank_branch_id : ' || p_bank_branch_id);

1167: arp_util.debug('update_batch: ' || 'p_trx_date_low : ' || p_trx_date_low);
1168: arp_util.debug('update_batch: ' || 'p_trx_date_high : ' || p_trx_date_high);
1169: arp_util.debug('update_batch: ' || 'p_cust_trx_type_id : ' || p_cust_trx_type_id);
1170: arp_util.debug('update_batch: ' || 'p_receipt_method_id : ' || p_receipt_method_id);
1171: arp_util.debug('update_batch: ' || 'p_bank_branch_id : ' || p_bank_branch_id);
1172: arp_util.debug('update_batch: ' || 'p_trx_number_low : ' || p_trx_number_low);
1173: arp_util.debug('update_batch: ' || 'p_trx_number_high : ' || p_trx_number_high);
1174: arp_util.debug('update_batch: ' || 'p_customer_class_code : ' || p_customer_class_code);
1175: arp_util.debug('update_batch: ' || 'p_customer_category_code: ' || p_customer_category_code);

Line 1172: arp_util.debug('update_batch: ' || 'p_trx_number_low : ' || p_trx_number_low);

1168: arp_util.debug('update_batch: ' || 'p_trx_date_high : ' || p_trx_date_high);
1169: arp_util.debug('update_batch: ' || 'p_cust_trx_type_id : ' || p_cust_trx_type_id);
1170: arp_util.debug('update_batch: ' || 'p_receipt_method_id : ' || p_receipt_method_id);
1171: arp_util.debug('update_batch: ' || 'p_bank_branch_id : ' || p_bank_branch_id);
1172: arp_util.debug('update_batch: ' || 'p_trx_number_low : ' || p_trx_number_low);
1173: arp_util.debug('update_batch: ' || 'p_trx_number_high : ' || p_trx_number_high);
1174: arp_util.debug('update_batch: ' || 'p_customer_class_code : ' || p_customer_class_code);
1175: arp_util.debug('update_batch: ' || 'p_customer_category_code: ' || p_customer_category_code);
1176: arp_util.debug('update_batch: ' || 'p_customer_id : ' || p_customer_id);

Line 1173: arp_util.debug('update_batch: ' || 'p_trx_number_high : ' || p_trx_number_high);

1169: arp_util.debug('update_batch: ' || 'p_cust_trx_type_id : ' || p_cust_trx_type_id);
1170: arp_util.debug('update_batch: ' || 'p_receipt_method_id : ' || p_receipt_method_id);
1171: arp_util.debug('update_batch: ' || 'p_bank_branch_id : ' || p_bank_branch_id);
1172: arp_util.debug('update_batch: ' || 'p_trx_number_low : ' || p_trx_number_low);
1173: arp_util.debug('update_batch: ' || 'p_trx_number_high : ' || p_trx_number_high);
1174: arp_util.debug('update_batch: ' || 'p_customer_class_code : ' || p_customer_class_code);
1175: arp_util.debug('update_batch: ' || 'p_customer_category_code: ' || p_customer_category_code);
1176: arp_util.debug('update_batch: ' || 'p_customer_id : ' || p_customer_id);
1177: arp_util.debug('update_batch: ' || 'p_site_use_id : ' || p_site_use_id);

Line 1174: arp_util.debug('update_batch: ' || 'p_customer_class_code : ' || p_customer_class_code);

1170: arp_util.debug('update_batch: ' || 'p_receipt_method_id : ' || p_receipt_method_id);
1171: arp_util.debug('update_batch: ' || 'p_bank_branch_id : ' || p_bank_branch_id);
1172: arp_util.debug('update_batch: ' || 'p_trx_number_low : ' || p_trx_number_low);
1173: arp_util.debug('update_batch: ' || 'p_trx_number_high : ' || p_trx_number_high);
1174: arp_util.debug('update_batch: ' || 'p_customer_class_code : ' || p_customer_class_code);
1175: arp_util.debug('update_batch: ' || 'p_customer_category_code: ' || p_customer_category_code);
1176: arp_util.debug('update_batch: ' || 'p_customer_id : ' || p_customer_id);
1177: arp_util.debug('update_batch: ' || 'p_site_use_id : ' || p_site_use_id);
1178: END IF;

Line 1175: arp_util.debug('update_batch: ' || 'p_customer_category_code: ' || p_customer_category_code);

1171: arp_util.debug('update_batch: ' || 'p_bank_branch_id : ' || p_bank_branch_id);
1172: arp_util.debug('update_batch: ' || 'p_trx_number_low : ' || p_trx_number_low);
1173: arp_util.debug('update_batch: ' || 'p_trx_number_high : ' || p_trx_number_high);
1174: arp_util.debug('update_batch: ' || 'p_customer_class_code : ' || p_customer_class_code);
1175: arp_util.debug('update_batch: ' || 'p_customer_category_code: ' || p_customer_category_code);
1176: arp_util.debug('update_batch: ' || 'p_customer_id : ' || p_customer_id);
1177: arp_util.debug('update_batch: ' || 'p_site_use_id : ' || p_site_use_id);
1178: END IF;
1179: RAISE;

Line 1176: arp_util.debug('update_batch: ' || 'p_customer_id : ' || p_customer_id);

1172: arp_util.debug('update_batch: ' || 'p_trx_number_low : ' || p_trx_number_low);
1173: arp_util.debug('update_batch: ' || 'p_trx_number_high : ' || p_trx_number_high);
1174: arp_util.debug('update_batch: ' || 'p_customer_class_code : ' || p_customer_class_code);
1175: arp_util.debug('update_batch: ' || 'p_customer_category_code: ' || p_customer_category_code);
1176: arp_util.debug('update_batch: ' || 'p_customer_id : ' || p_customer_id);
1177: arp_util.debug('update_batch: ' || 'p_site_use_id : ' || p_site_use_id);
1178: END IF;
1179: RAISE;
1180: END Update_Batch;

Line 1177: arp_util.debug('update_batch: ' || 'p_site_use_id : ' || p_site_use_id);

1173: arp_util.debug('update_batch: ' || 'p_trx_number_high : ' || p_trx_number_high);
1174: arp_util.debug('update_batch: ' || 'p_customer_class_code : ' || p_customer_class_code);
1175: arp_util.debug('update_batch: ' || 'p_customer_category_code: ' || p_customer_category_code);
1176: arp_util.debug('update_batch: ' || 'p_customer_id : ' || p_customer_id);
1177: arp_util.debug('update_batch: ' || 'p_site_use_id : ' || p_site_use_id);
1178: END IF;
1179: RAISE;
1180: END Update_Batch;
1181:

Line 1195: | arp_util.debug |

1191: | |
1192: | SCOPE - PRIVATE |
1193: | |
1194: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1195: | arp_util.debug |
1196: | |
1197: | ARGUMENTS : IN: |
1198: | p_form_name |
1199: | p_form_version |

Line 1224: arp_util.debug('ARP_PROCESS_BR_BATCHES.delete_batch()+');

1220:
1221: IS
1222:
1223: BEGIN
1224: arp_util.debug('ARP_PROCESS_BR_BATCHES.delete_batch()+');
1225:
1226: /*-------------------------------------------------------------+
1227: | Check the form version to determine if it is compatible |
1228: | with the entity handler |

Line 1258: arp_util.debug('ARP_PROCESS_BR_BATCHES.delete_batch()-');

1254:
1255: arp_tbat_pkg.delete_p (p_batch_id);
1256:
1257:
1258: arp_util.debug('ARP_PROCESS_BR_BATCHES.delete_batch()-');
1259:
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.delete_batch');

Line 1262: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.delete_batch');

1258: arp_util.debug('ARP_PROCESS_BR_BATCHES.delete_batch()-');
1259:
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.delete_batch');
1263:
1264: arp_util.debug('p_form_name : '|| p_form_name);
1265: arp_util.debug('p_form_version : '|| p_form_version);
1266: arp_util.debug('p_batch_id : '|| p_batch_id);

Line 1264: arp_util.debug('p_form_name : '|| p_form_name);

1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.delete_batch');
1263:
1264: arp_util.debug('p_form_name : '|| p_form_name);
1265: arp_util.debug('p_form_version : '|| p_form_version);
1266: arp_util.debug('p_batch_id : '|| p_batch_id);
1267: arp_util.debug('p_selection_criteria_id : '|| p_selection_criteria_id);
1268:

Line 1265: arp_util.debug('p_form_version : '|| p_form_version);

1261: WHEN OTHERS THEN
1262: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.delete_batch');
1263:
1264: arp_util.debug('p_form_name : '|| p_form_name);
1265: arp_util.debug('p_form_version : '|| p_form_version);
1266: arp_util.debug('p_batch_id : '|| p_batch_id);
1267: arp_util.debug('p_selection_criteria_id : '|| p_selection_criteria_id);
1268:
1269: RAISE;

Line 1266: arp_util.debug('p_batch_id : '|| p_batch_id);

1262: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.delete_batch');
1263:
1264: arp_util.debug('p_form_name : '|| p_form_name);
1265: arp_util.debug('p_form_version : '|| p_form_version);
1266: arp_util.debug('p_batch_id : '|| p_batch_id);
1267: arp_util.debug('p_selection_criteria_id : '|| p_selection_criteria_id);
1268:
1269: RAISE;
1270: END;

Line 1267: arp_util.debug('p_selection_criteria_id : '|| p_selection_criteria_id);

1263:
1264: arp_util.debug('p_form_name : '|| p_form_name);
1265: arp_util.debug('p_form_version : '|| p_form_version);
1266: arp_util.debug('p_batch_id : '|| p_batch_id);
1267: arp_util.debug('p_selection_criteria_id : '|| p_selection_criteria_id);
1268:
1269: RAISE;
1270: END;
1271:

Line 1286: | arp_util.debug |

1282: | |
1283: | SCOPE - |
1284: | |
1285: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1286: | arp_util.debug |
1287: | |
1288: | ARGUMENTS : IN: |
1289: | p_form_name |
1290: | p_form_version |

Line 1386: arp_util.debug('ARP_PROCESS_BR_BATCHES.lock_compare_batch ()+');

1382: l_sel_rec ar_selection_criteria%rowtype;
1383:
1384: BEGIN
1385: IF PG_DEBUG in ('Y', 'C') THEN
1386: arp_util.debug('ARP_PROCESS_BR_BATCHES.lock_compare_batch ()+');
1387: END IF;
1388:
1389: /*-------------------------------------------------------------+
1390: | Check the form version to determine if it is compatible |

Line 1471: arp_util.debug('ARP_PROCESS_BR_BATCHES.lock_compare_batch()-');

1467: arp_tbat_pkg.lock_compare_p(l_batch_rec, p_batch_id);
1468:
1469:
1470: IF PG_DEBUG in ('Y', 'C') THEN
1471: arp_util.debug('ARP_PROCESS_BR_BATCHES.lock_compare_batch()-');
1472: END IF;
1473:
1474: EXCEPTION
1475: WHEN OTHERS THEN

Line 1477: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.lock_compare_batch');

1473:
1474: EXCEPTION
1475: WHEN OTHERS THEN
1476: IF PG_DEBUG in ('Y', 'C') THEN
1477: arp_util.debug('EXCEPTION : ARP_PROCESS_BR_BATCHES.lock_compare_batch');
1478: END IF;
1479:
1480: RAISE;
1481: END lock_compare_batch;

Line 1494: | arp_util.debug |

1490: | |
1491: | SCOPE - |
1492: | |
1493: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1494: | arp_util.debug |
1495: | |
1496: | ARGUMENTS : IN: |
1497: | p_format |
1498: | p_BR_ID |

Line 1546: arp_util.debug('>>>>>>>>>> EXCEPTION : ARP_PROCESS_BR_BATCHES.Submit_Print () ');

1542:
1543: EXCEPTION
1544: WHEN OTHERS THEN
1545: IF PG_DEBUG in ('Y', 'C') THEN
1546: arp_util.debug('>>>>>>>>>> EXCEPTION : ARP_PROCESS_BR_BATCHES.Submit_Print () ');
1547: END IF;
1548: RAISE;
1549:
1550: END submit_print;

Line 1629: arp_util.debug('ARP_PROCESS_BR_BATCHES.br_create(+)');

1625:
1626: BEGIN
1627:
1628: IF PG_DEBUG in ('Y', 'C') THEN
1629: arp_util.debug('ARP_PROCESS_BR_BATCHES.br_create(+)');
1630: END IF;
1631:
1632: --Bug 5051673
1633: SELECT org_id

Line 1697: arp_util.debug('ARP_PROCESS_BR_BATCHES.br_create(-)');

1693:
1694: COMMIT;
1695:
1696: IF PG_DEBUG in ('Y', 'C') THEN
1697: arp_util.debug('ARP_PROCESS_BR_BATCHES.br_create(-)');
1698: END IF;
1699:
1700: EXCEPTION
1701: WHEN OTHERS THEN

Line 1703: arp_util.debug('>>>>>>>>>>> EXCEPTION : ARP_PROCESS_BR_BATCHES.br_create() ');

1699:
1700: EXCEPTION
1701: WHEN OTHERS THEN
1702: IF PG_DEBUG in ('Y', 'C') THEN
1703: arp_util.debug('>>>>>>>>>>> EXCEPTION : ARP_PROCESS_BR_BATCHES.br_create() ');
1704: END IF;
1705:
1706: END br_create ;
1707: