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.5 2006/06/02 15:42:25 ggadhams arhmapss.pls $ */
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 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 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 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 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 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 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 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 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 413: ARP_PROCESS_BR_BATCHES.Validate_GL_Date

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

Line 417: ARP_PROCESS_BR_BATCHES.Validate_Maturity_Date

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

Line 421: ARP_PROCESS_BR_BATCHES.Validate_Batch_Source

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

Line 426: ARP_PROCESS_BR_BATCHES.Validate_Currency

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

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 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 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 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 774: ARP_PROCESS_BR_BATCHES.validate_batch (l_batch_rec);

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

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

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

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 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 1047: ARP_PROCESS_BR_BATCHES.validate_batch (l_batch_rec);

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

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

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

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 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 1237: ARP_PROCESS_BR_BATCHES.validate_delete_batch (p_batch_id);

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

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 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 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:

Line 1697: END ARP_PROCESS_BR_BATCHES;

1693:
1694: END br_create ;
1695:
1696:
1697: END ARP_PROCESS_BR_BATCHES;