eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_BR_BATCHES dependencies on ARP_PROCESS_BR_BATCHES

Line 1: PACKAGE BODY ARP_PROCESS_BR_BATCHES AS

1: PACKAGE BODY ARP_PROCESS_BR_BATCHES AS
2: /* $Header: ARTEBRBB.pls 120.8 2011/07/19 00:38:25 dgaurab ship $ */
3:
4:
5: /*===========================================================================+

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 41: arp_util.debug('ARP_PROCESS_BR_BATCHES.Validate_GL_Date()-');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 414: ARP_PROCESS_BR_BATCHES.Validate_GL_Date

410: arp_util.debug('ARP_PROCESS_BR_BATCHES.validate_batch()+');
411: END IF;
412:
413:
414: ARP_PROCESS_BR_BATCHES.Validate_GL_Date
415: ( p_batch_rec.gl_date ,
416: p_batch_rec.issue_date );
417:
418: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date

Line 418: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date

414: ARP_PROCESS_BR_BATCHES.Validate_GL_Date
415: ( p_batch_rec.gl_date ,
416: p_batch_rec.issue_date );
417:
418: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date
419: ( p_batch_rec.maturity_date ,
420: p_batch_rec.issue_date );
421:
422: ARP_PROCESS_BR_BATCHES.Validate_Batch_Source

Line 422: ARP_PROCESS_BR_BATCHES.Validate_Batch_Source

418: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date
419: ( p_batch_rec.maturity_date ,
420: p_batch_rec.issue_date );
421:
422: ARP_PROCESS_BR_BATCHES.Validate_Batch_Source
423: ( p_batch_rec.batch_source_id ,
424: p_batch_rec.batch_date ,
425: p_batch_rec.issue_date );
426:

Line 427: ARP_PROCESS_BR_BATCHES.Validate_Currency

423: ( p_batch_rec.batch_source_id ,
424: p_batch_rec.batch_date ,
425: p_batch_rec.issue_date );
426:
427: ARP_PROCESS_BR_BATCHES.Validate_Currency
428: ( p_batch_rec.currency_code ,
429: p_batch_rec.issue_date );
430:
431: IF PG_DEBUG in ('Y', 'C') THEN

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

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

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

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

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

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

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

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

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

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

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

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

Line 775: ARP_PROCESS_BR_BATCHES.validate_batch (l_batch_rec);

771: /*-------------------------------------------------------------+
772: | Do required validation for the batch |
773: +-------------------------------------------------------------*/
774:
775: ARP_PROCESS_BR_BATCHES.validate_batch (l_batch_rec);
776:
777:
778: /*---------------------------------------------------------------+
779: | Call Table Handler to insert the batch |

Line 812: ARP_PROCESS_BR_BATCHES.validate_selection (l_sel_rec, p_issue_date);

808: /*-------------------------------------------------------------+
809: | Do required validation for the selection criteria |
810: +-------------------------------------------------------------*/
811:
812: ARP_PROCESS_BR_BATCHES.validate_selection (l_sel_rec, p_issue_date);
813:
814:
815: /*-------------------------------------------------------------+
816: | Call Table Handler to insert the selection |

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

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

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

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

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

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

Line 1048: ARP_PROCESS_BR_BATCHES.validate_batch (l_batch_rec);

1044: /*-------------------------------------------------------------+
1045: | Do required validation for the batch |
1046: +-------------------------------------------------------------*/
1047:
1048: ARP_PROCESS_BR_BATCHES.validate_batch (l_batch_rec);
1049:
1050:
1051: /*---------------------------------------------------------------+
1052: | Call Table Handler to update the batch |

Line 1097: ARP_PROCESS_BR_BATCHES.validate_selection (l_sel_rec, p_issue_date);

1093: /*-------------------------------------------------------------+
1094: | Do required validation for the selection criteria |
1095: +-------------------------------------------------------------*/
1096:
1097: ARP_PROCESS_BR_BATCHES.validate_selection (l_sel_rec, p_issue_date);
1098:
1099:
1100: IF (p_selection_criteria_id IS NULL)
1101: THEN

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

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

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

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

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

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

Line 1238: ARP_PROCESS_BR_BATCHES.validate_delete_batch (p_batch_id);

1234: /*-------------------------------------------------------------+
1235: | Do required validation |
1236: +-------------------------------------------------------------*/
1237:
1238: ARP_PROCESS_BR_BATCHES.validate_delete_batch (p_batch_id);
1239:
1240:
1241: /*---------------------------------------------------------------+
1242: | Delete the selection Criteria if they exist |

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1709: END ARP_PROCESS_BR_BATCHES;

1705:
1706: END br_create ;
1707:
1708:
1709: END ARP_PROCESS_BR_BATCHES;