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_PROGRAM_GENERATE_BR dependencies on ARP_PROGRAM_GENERATE_BR

Line 1: PACKAGE BODY ARP_PROGRAM_GENERATE_BR AS

1: PACKAGE BODY ARP_PROGRAM_GENERATE_BR AS
2: /* $Header: ARBRTESB.pls 120.20.12000000.3 2007/07/25 13:38:15 nemani ship $ */
3:
4: --------- Private Procedures
5: PROCEDURE from_automatic_batch_window(

Line 249: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_PROGRAM_GENERATE_BR';

245: p_request_id OUT NOCOPY NUMBER);
246:
247:
248: --------- Global variables
249: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_PROGRAM_GENERATE_BR';
250:
251: TYPE cur_typ IS REF CURSOR;
252:
253: /* Bug 3472744 Declarations for the new pl/sql table included

Line 408: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.auto_create_br_program (+)');

404: l_batch_id RA_BATCHES.batch_id%TYPE;
405:
406: BEGIN
407:
408: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.auto_create_br_program (+)');
409:
410: --------------------------------------------------------------
411: -- Date Conversions
412: --------------------------------------------------------------

Line 442: ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window(

438: -- Process
439: --------------------------------------------------------------
440: IF (p_call = 1) THEN
441:
442: ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window(
443: p_draft_mode,
444: p_print_flag,
445: p_batch_id,
446: l_due_date_low,

Line 462: ARP_PROGRAM_GENERATE_BR.from_conc_request_window(

458: p_site_use_id);
459:
460: ELSIF (p_call = 2) THEN
461:
462: ARP_PROGRAM_GENERATE_BR.from_conc_request_window(
463: p_print_flag,
464: p_batch_source_id,
465: l_batch_date,
466: l_gl_date,

Line 512: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;

508: APP_EXCEPTION.raise_exception;
509: END IF;
510:
511: --Temporary table Drop
512: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
513:
514: /* Bug 3472744 Printing the errored BRs at the end of the log file. */
515: IF (g_num_br_failed > 0)
516: THEN

Line 552: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;

548: END IF;
549: END IF ;
550:
551: --Temporary table Drop
552: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
553:
554: COMMIT;
555:
556: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.auto_create_br_program (-)');

Line 556: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.auto_create_br_program (-)');

552: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
553:
554: COMMIT;
555:
556: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.auto_create_br_program (-)');
557:
558: EXCEPTION
559: WHEN OTHERS THEN
560: --Temporary table Drop

Line 561: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;

557:
558: EXCEPTION
559: WHEN OTHERS THEN
560: --Temporary table Drop
561: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
562: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.auto_create_br_program');
563: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
564: RAISE;
565:

Line 562: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.auto_create_br_program');

558: EXCEPTION
559: WHEN OTHERS THEN
560: --Temporary table Drop
561: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
562: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.auto_create_br_program');
563: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
564: RAISE;
565:
566: END auto_create_br_program;

Line 612: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window (+)');

608: l_request_id NUMBER;
609:
610: BEGIN
611:
612: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window (+)');
613:
614: -- Temporary table Creation
615: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
616:

Line 615: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;

611:
612: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window (+)');
613:
614: -- Temporary table Creation
615: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
616:
617: -- Select the transactions using the users criteria and create the Bills Receivable
618: ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR(
619: p_draft_mode,

Line 618: ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR(

614: -- Temporary table Creation
615: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
616:
617: -- Select the transactions using the users criteria and create the Bills Receivable
618: ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR(
619: p_draft_mode,
620: 1, -- p_call
621: p_batch_id,
622: p_due_date_low,

Line 637: ARP_PROGRAM_GENERATE_BR.update_batch_status(

633: p_customer_id,
634: p_site_use_id);
635: -- Update the batch status to 'CREATION_COMPLETED' if the batch run in Create mode.
636: -- Otherwise, the batch status is updated to 'DRAFT'.
637: ARP_PROGRAM_GENERATE_BR.update_batch_status(
638: p_draft_mode,
639: p_batch_id);
640:
641: /* Bug 3472744 Added the check for number of brs created before

Line 655: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window (-)');

651: print_BR_pvt(p_batch_id,1,l_request_id);
652: END IF;
653: END IF;
654:
655: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window (-)');
656:
657: EXCEPTION
658: WHEN OTHERS THEN
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window');

Line 659: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window');

655: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window (-)');
656:
657: EXCEPTION
658: WHEN OTHERS THEN
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.from_automatic_batch_window');
660: RAISE;
661:
662: END from_automatic_batch_window;
663:

Line 733: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_conc_request_window (+)');

729: l_request_id NUMBER;
730:
731: BEGIN
732:
733: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_conc_request_window (+)');
734:
735: -- Temporary table Creation
736: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
737:

Line 736: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;

732:
733: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_conc_request_window (+)');
734:
735: -- Temporary table Creation
736: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
737:
738: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA
739: ARP_PROGRAM_GENERATE_BR.create_batch_header(
740: p_batch_source_id,

Line 739: ARP_PROGRAM_GENERATE_BR.create_batch_header(

735: -- Temporary table Creation
736: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
737:
738: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA
739: ARP_PROGRAM_GENERATE_BR.create_batch_header(
740: p_batch_source_id,
741: p_batch_date,
742: p_gl_date,
743: p_issue_date,

Line 783: ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR(

779:
780:
781:
782: -- Select the transactions using the users criteria and create the Bills Receivable
783: ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR(
784: 'N', -- p_draft_mode (the user do not have the option of creating a BR batch in Draft Mode, by SRS)
785: 2, -- p_call
786: l_batch_id,
787: p_due_date_low,

Line 803: ARP_PROGRAM_GENERATE_BR.update_batch_status(

799: p_site_use_id);
800:
801:
802: --- The batch status is updated to 'Creation Completed'
803: ARP_PROGRAM_GENERATE_BR.update_batch_status(
804: 'N', -- p_draft_mode
805: l_batch_id);
806:
807: /* Bug 3472744 Added the check for number of brs created before

Line 821: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_conc_request_window (-)');

817: print_BR_pvt(l_batch_id,2,l_request_id);
818: END IF;
819: END IF;
820:
821: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_conc_request_window (-)');
822:
823: EXCEPTION
824: WHEN OTHERS THEN
825: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.from_conc_request_window');

Line 825: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.from_conc_request_window');

821: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.from_conc_request_window (-)');
822:
823: EXCEPTION
824: WHEN OTHERS THEN
825: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.from_conc_request_window');
826: RAISE;
827:
828: END from_conc_request_window;
829:

Line 904: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.create_batch_header (+)');

900: l_name RA_BATCHES.name%TYPE;
901:
902: BEGIN
903:
904: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.create_batch_header (+)');
905:
906: -- The Issue date will be inherited from the Batch date
907: l_issue_date := p_batch_date;
908:

Line 991: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.create_batch_header (-)');

987: p_batch_id := l_batch_id;
988:
989: COMMIT;
990:
991: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.create_batch_header (-)');
992:
993: EXCEPTION
994: WHEN OTHERS THEN
995: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.create_batch_header');

Line 995: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.create_batch_header');

991: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.create_batch_header (-)');
992:
993: EXCEPTION
994: WHEN OTHERS THEN
995: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.create_batch_header');
996: RAISE;
997:
998: END create_batch_header;
999:

Line 1035: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.update_batch_status (+)');

1031:
1032:
1033: BEGIN
1034:
1035: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.update_batch_status (+)');
1036:
1037: -- fetch the batch
1038: arp_tbat_pkg.lock_fetch_p(l_batch_rec,p_batch_id);
1039:

Line 1105: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.update_batch_status (-)');

1101: l_selection_criteria_id);
1102:
1103: COMMIT;
1104:
1105: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.update_batch_status (-)');
1106:
1107: EXCEPTION
1108: WHEN OTHERS THEN
1109: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.update_batch_status');

Line 1109: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.update_batch_status');

1105: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.update_batch_status (-)');
1106:
1107: EXCEPTION
1108: WHEN OTHERS THEN
1109: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.update_batch_status');
1110: RAISE;
1111:
1112: END update_batch_status;
1113:

Line 1300: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR (+)');

1296:
1297: BEGIN
1298:
1299: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
1300: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR (+)');
1301: FND_FILE.PUT_LINE(FND_FILE.LOG,'Dump of Parameters');
1302: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------------------------------------------');
1303: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_due_date_low = ' || p_due_date_low);
1304: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_due_date_high = ' || p_due_date_high);

Line 1358: ARP_PROGRAM_GENERATE_BR.construct_suffixe_select(

1354: -- Setup of the next cursor according to the handled receipt method
1355: -- Bug 3922691 : pass additional parameters to construct_suffixe_select,
1356: -- call new procedure construct_hz
1357:
1358: ARP_PROGRAM_GENERATE_BR.construct_suffixe_select(
1359: l_lead_days,
1360: l_suffixe_select_statement,
1361: p_due_date_low,
1362: p_due_date_high,

Line 1374: ARP_PROGRAM_GENERATE_BR.construct_hz(

1370: p_customer_id,
1371: p_site_use_id,
1372: l_le_id);
1373:
1374: ARP_PROGRAM_GENERATE_BR.construct_hz(
1375: l_receipt_creation_rule_code,
1376: p_customer_id,
1377: l_suffix_hz);
1378:

Line 1455: ARP_PROGRAM_GENERATE_BR.construct_suffixe_select(

1451: END IF;
1452:
1453: -- 4109513 : Now that we have customer_id, rebuild l_trx_select_statement
1454: -- to make it more selective on ps.customer_id
1455: ARP_PROGRAM_GENERATE_BR.construct_suffixe_select(
1456: l_lead_days,
1457: l_suffixe_select_statement,
1458: p_due_date_low,
1459: p_due_date_high,

Line 1471: ARP_PROGRAM_GENERATE_BR.construct_hz(

1467: l_customer_id,
1468: p_site_use_id,
1469: l_le_id);
1470:
1471: ARP_PROGRAM_GENERATE_BR.construct_hz(
1472: l_receipt_creation_rule_code,
1473: l_customer_id,
1474: l_suffix_hz);
1475:

Line 1613: ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM(

1609: END IF;
1610: END IF;
1611:
1612: -- Selection of the Credit/Debit Note with a payment Term of Immediate (term_id = 5)
1613: ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM(
1614: l_lead_days,
1615: l_receipt_creation_rule_code,
1616: p_due_date_low,
1617: p_due_date_high,

Line 1635: ARP_PROGRAM_GENERATE_BR.select_trx_NIMM(

1631: l_customer_bank_account_id2,
1632: l_le_id);
1633:
1634: -- Selection of the "others" transactions
1635: ARP_PROGRAM_GENERATE_BR.select_trx_NIMM(
1636: l_lead_days,
1637: l_receipt_creation_rule_code,
1638: NVL(l_due_date,p_due_date_low),
1639: NVL(l_due_date,p_due_date_high),

Line 1662: ARP_PROGRAM_GENERATE_BR.create_BR(

1658:
1659: -- Creation of the Bills receivable
1660:
1661: -- bug 1808976 : added l_customer_bank_account_id
1662: ARP_PROGRAM_GENERATE_BR.create_BR(
1663: p_draft_mode,
1664: p_call,
1665: p_batch_id,
1666: l_receipt_method_id,

Line 1730: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR (-)');

1726: CLOSE c_receipt_method;
1727:
1728:
1729: FND_FILE.PUT_LINE(FND_FILE.LOG,'The process has generated '||g_num_br_created||' Bills receivable');
1730: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR (-)');
1731:
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR');

Line 1734: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR');

1730: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR (-)');
1731:
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.select_trx_and_create_BR');
1735:
1736: IF c_grouping%ISOPEN THEN
1737: CLOSE c_grouping;
1738: END IF;

Line 1828: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.construct_hz');

1824: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'construct_hz (-)');
1825:
1826: EXCEPTION
1827: WHEN OTHERS THEN
1828: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.construct_hz');
1829: RAISE;
1830: END;
1831:
1832:

Line 1889: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.construct_suffixe_select (+)');

1885: l_trx_select_statement VARCHAR2(4000) := NULL;
1886:
1887: BEGIN
1888:
1889: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.construct_suffixe_select (+)');
1890:
1891: /* modified for tca uptake */
1892:
1893: /* Bug 1744783 : for transactions with multiple payment schedule records,

Line 2067: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.construct_suffixe_select (-)');

2063: END IF;
2064:
2065: p_suffixe_select_statement := l_trx_select_statement;
2066:
2067: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.construct_suffixe_select (-)');
2068:
2069: EXCEPTION
2070: WHEN OTHERS THEN
2071: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.construct_suffixe_select');

Line 2071: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.construct_suffixe_select');

2067: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.construct_suffixe_select (-)');
2068:
2069: EXCEPTION
2070: WHEN OTHERS THEN
2071: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.construct_suffixe_select');
2072: RAISE;
2073:
2074: END construct_suffixe_select;
2075:

Line 2152: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM (+)');

2148: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2149:
2150: BEGIN
2151:
2152: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM (+)');
2153:
2154: l_delete_statement := 'DELETE FROM '|| g_tmp_table_imm;
2155: execute immediate l_delete_statement;
2156:

Line 2159: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM (-)');

2155: execute immediate l_delete_statement;
2156:
2157: IF p_receipt_creation_rule_code = 'PER_INVOICE' THEN
2158: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'grouping rule PER INVOICE -> no DM/CM Immediate');
2159: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM (-)');
2160: RETURN;
2161: END IF;
2162:
2163: -- If a Credit/Debit Note has been created with a payment term of immediate,

Line 2174: ARP_PROGRAM_GENERATE_BR.construct_suffixe_select(

2170: -- Bug 3922691, we cannot re-use p_suffixe_select_statement because the
2171: -- param values for p_due_date_low, p_due_date_high, p_customer_id,
2172: -- p_site_use_id may have changed, need to reconstruct with current values
2173:
2174: ARP_PROGRAM_GENERATE_BR.construct_suffixe_select(
2175: p_lead_days,
2176: l_suffixe_select_statement,
2177: p_due_date_low,
2178: p_due_date_high,

Line 2190: ARP_PROGRAM_GENERATE_BR.construct_hz(

2186: p_customer_id,
2187: p_site_use_id,
2188: p_le_id );
2189:
2190: ARP_PROGRAM_GENERATE_BR.construct_hz(
2191: p_receipt_creation_rule_code,
2192: p_customer_id,
2193: l_suffix_hz);
2194:

Line 2310: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM (-)');

2306: execute immediate l_delete_statement;
2307:
2308: END IF;
2309:
2310: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM (-)');
2311:
2312: EXCEPTION
2313: WHEN OTHERS THEN
2314: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM');

Line 2314: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM');

2310: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM (-)');
2311:
2312: EXCEPTION
2313: WHEN OTHERS THEN
2314: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.select_DM_and_CM_IMM');
2315:
2316: IF c_trx%ISOPEN THEN
2317: CLOSE c_trx;
2318: END IF;

Line 2398: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_NIMM (+)');

2394: l_org_id AR_PAYMENT_SCHEDULES.org_id%TYPE;
2395:
2396: BEGIN
2397:
2398: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_NIMM (+)');
2399:
2400: l_delete_statement := 'DELETE FROM '|| g_tmp_table_nimm;
2401: execute immediate l_delete_statement;
2402:

Line 2408: ARP_PROGRAM_GENERATE_BR.construct_suffixe_select(

2404: -- Bug 3922691, we cannot re-use p_suffixe_select_statement because the
2405: -- param values for p_due_date_low, p_due_date_high, p_customer_id,
2406: -- p_site_use_id may have changed, need to reconstruct with current values
2407:
2408: ARP_PROGRAM_GENERATE_BR.construct_suffixe_select(
2409: p_lead_days,
2410: l_suffixe_select_statement,
2411: p_due_date_low,
2412: p_due_date_high,

Line 2424: ARP_PROGRAM_GENERATE_BR.construct_hz(

2420: p_customer_id,
2421: p_site_use_id,
2422: p_le_id );
2423:
2424: ARP_PROGRAM_GENERATE_BR.construct_hz(
2425: p_receipt_creation_rule_code,
2426: p_customer_id,
2427: l_suffix_hz);
2428:

Line 2551: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_NIMM (-)');

2547:
2548: END LOOP;
2549: CLOSE c_trx;
2550:
2551: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_NIMM (-)');
2552:
2553: EXCEPTION
2554: WHEN OTHERS THEN
2555: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.select_trx_NIMM');

Line 2555: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.select_trx_NIMM');

2551: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.select_trx_NIMM (-)');
2552:
2553: EXCEPTION
2554: WHEN OTHERS THEN
2555: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.select_trx_NIMM');
2556:
2557: IF c_trx%ISOPEN THEN
2558: CLOSE c_trx;
2559: END IF;

Line 2750: program_debug(p_call,'ARP_PROGRAM_GENERATE_BR.create_BR (+)');

2746:
2747: BEGIN
2748:
2749: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
2750: program_debug(p_call,'ARP_PROGRAM_GENERATE_BR.create_BR (+)');
2751: END IF;
2752:
2753: l_return_status := FND_API.G_RET_STS_SUCCESS;
2754:

Line 3891: ARP_PROGRAM_GENERATE_BR.ar_br_insert_into_report_table(

3887: FETCH c_trx INTO l_customer_trx_id, l_assigned_amount;
3888: EXIT WHEN c_trx%NOTFOUND;
3889:
3890: -- Bug 1420183 Added p_receipt_method_id
3891: ARP_PROGRAM_GENERATE_BR.ar_br_insert_into_report_table(
3892: arp_global.request_id,
3893: p_batch_id,
3894: l_bill_id,
3895: NVL(l_bill_number,to_char(g_num_br_created)),

Line 3924: ARP_PROGRAM_GENERATE_BR.ar_br_insert_into_report_table(

3920: FETCH c_trx INTO l_customer_trx_id, l_assigned_amount;
3921: EXIT WHEN c_trx%NOTFOUND;
3922:
3923: -- Bug 1420183 Added p_receipt_method_id
3924: ARP_PROGRAM_GENERATE_BR.ar_br_insert_into_report_table(
3925: arp_global.request_id,
3926: p_batch_id,
3927: l_bill_id,
3928: NVL(l_bill_number,to_char(g_num_br_created)),

Line 3980: program_debug(p_call,'ARP_PROGRAM_GENERATE_BR.create_BR (-)');

3976:
3977: COMMIT;
3978:
3979: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3980: program_debug(p_call,'ARP_PROGRAM_GENERATE_BR.create_BR (-)');
3981: END IF;
3982:
3983:
3984: EXCEPTION

Line 3987: program_debug(p_call,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.create_BR >>>> ROLLBACK');

3983:
3984: EXCEPTION
3985: WHEN OTHERS THEN
3986: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3987: program_debug(p_call,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.create_BR >>>> ROLLBACK');
3988: END IF;
3989: ROLLBACK TO create_BR_SVP;
3990:
3991: IF c_trx%ISOPEN THEN

Line 4124: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION OTHERS: ARP_PROGRAM_GENERATE_BR.AR_BR_INSERT_INTO_REPORT_TABLE ');

4120: l_lead_days);
4121:
4122:
4123: EXCEPTION WHEN OTHERS THEN
4124: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION OTHERS: ARP_PROGRAM_GENERATE_BR.AR_BR_INSERT_INTO_REPORT_TABLE ');
4125: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
4126: IF c_get_receipt_method%ISOPEN THEN
4127: CLOSE c_get_receipt_method;
4128: END IF;

Line 4192: --FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table (+)');

4188: l_user_schema VARCHAR2(30) := USER;
4189:
4190: BEGIN
4191:
4192: --FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table (+)');
4193:
4194: LOOP
4195:
4196:

Line 4331: --FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table (-)');

4327: END IF;
4328:
4329: END LOOP;
4330:
4331: --FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table (-)');
4332:
4333: EXCEPTION
4334: WHEN OTHERS THEN
4335: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table');

Line 4335: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table');

4331: --FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table (-)');
4332:
4333: EXCEPTION
4334: WHEN OTHERS THEN
4335: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table');
4336: RAISE;
4337:
4338: END arbr_cr_tmp_table;
4339:

Line 4373: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.drop_tmp_table (+)');

4369:
4370:
4371: BEGIN
4372:
4373: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.drop_tmp_table (+)');
4374:
4375: ----------------------------------------------------------------------------------------
4376: -- Drop of the temporary table for Transactions with a payment term of non immediate
4377: ----------------------------------------------------------------------------------------

Line 4454: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.drop_tmp_table (-)');

4450: execute immediate query_drop;
4451: END IF;
4452:
4453:
4454: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.drop_tmp_table (-)');
4455:
4456: EXCEPTION
4457: WHEN OTHERS THEN
4458: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.drop_tmp_table');

Line 4458: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.drop_tmp_table');

4454: FND_FILE.PUT_LINE(FND_FILE.LOG,'ARP_PROGRAM_GENERATE_BR.drop_tmp_table (-)');
4455:
4456: EXCEPTION
4457: WHEN OTHERS THEN
4458: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.drop_tmp_table');
4459: RAISE;
4460:
4461: END drop_tmp_table;
4462:

Line 4551: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.run_report_pvt - ROLLBACK');

4547: --FND_FILE.PUT_LINE(FND_FILE.LOG,'run_report_pvt (-)');
4548:
4549: EXCEPTION
4550: WHEN OTHERS THEN
4551: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.run_report_pvt - ROLLBACK');
4552: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
4553: ROLLBACK TO run_report_SVP;
4554:
4555: END run_report_pvt;

Line 4652: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.print_BR_pvt - ROLLBACK');

4648: --FND_FILE.PUT_LINE(FND_FILE.LOG,'print_BR_pvt (-)');
4649:
4650: EXCEPTION
4651: WHEN OTHERS THEN
4652: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION : ARP_PROGRAM_GENERATE_BR.print_BR_pvt - ROLLBACK');
4653: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
4654: ROLLBACK TO print_BR_SVP;
4655:
4656: END print_BR_pvt;

Line 4759: arp_util.debug('ARP_PROGRAM_GENERATE_BR.auto_create_br_API (+)');

4755:
4756: BEGIN
4757:
4758: IF PG_DEBUG in ('Y', 'C') THEN
4759: arp_util.debug('ARP_PROGRAM_GENERATE_BR.auto_create_br_API (+)');
4760: END IF;
4761:
4762: -- Standard call to check for call compatability
4763: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

Line 4801: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;

4797:
4798: CLOSE c_receipt_method;
4799:
4800: -- Temporary table Creation
4801: ARP_PROGRAM_GENERATE_BR.arbr_cr_tmp_table;
4802:
4803: -------------------------------------------------------------------------
4804: -- Setup the transaction select statement
4805: -------------------------------------------------------------------------

Line 4846: ARP_PROGRAM_GENERATE_BR.construct_hz(l_receipt_creation_rule_code,

4842: 'AND ps.customer_trx_id = trx.customer_trx_id '||
4843: 'AND trx.receipt_method_id = pm.receipt_method_id ';
4844:
4845: -- bug 3922691
4846: ARP_PROGRAM_GENERATE_BR.construct_hz(l_receipt_creation_rule_code,
4847: p_customer_id,
4848: l_suffix_hz);
4849:
4850: l_suffixe_select_statement := l_suffixe_select_statement || l_suffix_hz;

Line 4977: ARP_PROGRAM_GENERATE_BR.create_BR(

4973:
4974: -- create the bills receivable
4975:
4976: -- bug 1808976 : pass customer_bank_account_id to create_br
4977: ARP_PROGRAM_GENERATE_BR.create_BR(
4978: 'N', -- p_draft_mode
4979: 3, -- p_call
4980: NULL, -- p_batch_id
4981: l_receipt_method_id,

Line 5019: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;

5015: APP_EXCEPTION.raise_exception;
5016: END IF;
5017:
5018: --Temporary table Drop
5019: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
5020:
5021: IF PG_DEBUG in ('Y', 'C') THEN
5022: arp_util.debug('ARP_PROGRAM_GENERATE_BR.auto_create_br_API (-)');
5023: END IF;

Line 5022: arp_util.debug('ARP_PROGRAM_GENERATE_BR.auto_create_br_API (-)');

5018: --Temporary table Drop
5019: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
5020:
5021: IF PG_DEBUG in ('Y', 'C') THEN
5022: arp_util.debug('ARP_PROGRAM_GENERATE_BR.auto_create_br_API (-)');
5023: END IF;
5024:
5025:
5026:

Line 5030: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROGRAM_GENERATE_BR.auto_create_br_API ');

5026:
5027: EXCEPTION
5028: WHEN FND_API.G_EXC_ERROR THEN
5029: IF PG_DEBUG in ('Y', 'C') THEN
5030: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROGRAM_GENERATE_BR.auto_create_br_API ');
5031: END IF;
5032: x_return_status := FND_API.G_RET_STS_ERROR;
5033:
5034: IF c_grouping%ISOPEN THEN

Line 5046: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;

5042: IF c_trx%ISOPEN THEN
5043: CLOSE c_trx;
5044: END IF;
5045:
5046: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
5047: raise;
5048:
5049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5050: IF PG_DEBUG in ('Y', 'C') THEN

Line 5051: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');

5047: raise;
5048:
5049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5050: IF PG_DEBUG in ('Y', 'C') THEN
5051: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');
5052: END IF;
5053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5054:
5055: IF c_grouping%ISOPEN THEN

Line 5067: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;

5063: IF c_trx%ISOPEN THEN
5064: CLOSE c_trx;
5065: END IF;
5066:
5067: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
5068: raise;
5069:
5070: WHEN OTHERS THEN
5071: IF PG_DEBUG in ('Y', 'C') THEN

Line 5072: arp_util.debug('EXCEPTION OTHERS: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');

5068: raise;
5069:
5070: WHEN OTHERS THEN
5071: IF PG_DEBUG in ('Y', 'C') THEN
5072: arp_util.debug('EXCEPTION OTHERS: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');
5073: END IF;
5074:
5075: IF c_grouping%ISOPEN THEN
5076: CLOSE c_grouping;

Line 5087: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;

5083: IF c_trx%ISOPEN THEN
5084: CLOSE c_trx;
5085: END IF;
5086:
5087: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
5088: IF (SQLCODE = -20001) THEN
5089: x_return_status := FND_API.G_RET_STS_ERROR;
5090: END IF;
5091:

Line 5126: END ARP_PROGRAM_GENERATE_BR;

5122: into g_org_id
5123: from ar_system_parameters;
5124:
5125:
5126: END ARP_PROGRAM_GENERATE_BR;