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: FND_MESSAGE.set_token ('GL_DATE', TO_CHAR (p_gl_date));
30: app_exception.raise_exception;

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

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

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

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

Line 47: arp_util.debug( '');

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 92: arp_util.debug( '');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 386: | arp_util.debug |

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

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

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

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

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

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

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

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

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

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

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

Line 459: | arp_util.debug |

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 517: | arp_util.debug |

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 623: | arp_util.debug |

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 893: | arp_util.debug |

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1194: | arp_util.debug |

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1285: | arp_util.debug |

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

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

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

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

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

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

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

Line 1493: | arp_util.debug |

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

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

1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: IF PG_DEBUG in ('Y', 'C') THEN
1534: arp_util.debug('>>>>>>>>>> EXCEPTION : ARP_PROCESS_BR_BATCHES.Submit_Print () ');
1535: END IF;
1536: RAISE;
1537:
1538: END submit_print;

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

1613:
1614: BEGIN
1615:
1616: IF PG_DEBUG in ('Y', 'C') THEN
1617: arp_util.debug('ARP_PROCESS_BR_BATCHES.br_create(+)');
1618: END IF;
1619:
1620: --Bug 5051673
1621: SELECT org_id

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

1681:
1682: COMMIT;
1683:
1684: IF PG_DEBUG in ('Y', 'C') THEN
1685: arp_util.debug('ARP_PROCESS_BR_BATCHES.br_create(-)');
1686: END IF;
1687:
1688: EXCEPTION
1689: WHEN OTHERS THEN

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

1687:
1688: EXCEPTION
1689: WHEN OTHERS THEN
1690: IF PG_DEBUG in ('Y', 'C') THEN
1691: arp_util.debug('>>>>>>>>>>> EXCEPTION : ARP_PROCESS_BR_BATCHES.br_create() ');
1692: END IF;
1693:
1694: END br_create ;
1695: