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_SALESCREDIT dependencies on ARP_PROCESS_SALESCREDIT

Line 1: PACKAGE BODY ARP_PROCESS_SALESCREDIT AS

1: PACKAGE BODY ARP_PROCESS_SALESCREDIT AS
2: /* $Header: ARTETLSB.pls 120.9 2005/09/06 20:18:02 mraymond arrt008.sql $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: pg_number_dummy number;

Line 45: arp_util.debug('arp_process_salescredit.val_insert_salescredit()+');

41:
42:
43: BEGIN
44:
45: arp_util.debug('arp_process_salescredit.val_insert_salescredit()+');
46:
47:
48: arp_util.debug('arp_process_salescredit.val_val_insert_salescredit()-');
49:

Line 48: arp_util.debug('arp_process_salescredit.val_val_insert_salescredit()-');

44:
45: arp_util.debug('arp_process_salescredit.val_insert_salescredit()+');
46:
47:
48: arp_util.debug('arp_process_salescredit.val_val_insert_salescredit()-');
49:
50: EXCEPTION
51: WHEN OTHERS THEN
52:

Line 58: 'EXCEPTION: arp_process_salescredit.val_insert_salescredit()');

54: | Display parameters and raise the exception |
55: +---------------------------------------------*/
56:
57: arp_util.debug(
58: 'EXCEPTION: arp_process_salescredit.val_insert_salescredit()');
59:
60: arp_util.debug('');
61: arp_util.debug('---------- val_insert_salescredit() ---------');
62: arp_util.debug('');

Line 101: arp_util.debug('arp_process_salescredit.val_update_salescredit()+');

97:
98:
99: BEGIN
100:
101: arp_util.debug('arp_process_salescredit.val_update_salescredit()+');
102:
103:
104: arp_util.debug('arp_process_salescredit.val_val_update_salescredit()-');
105:

Line 104: arp_util.debug('arp_process_salescredit.val_val_update_salescredit()-');

100:
101: arp_util.debug('arp_process_salescredit.val_update_salescredit()+');
102:
103:
104: arp_util.debug('arp_process_salescredit.val_val_update_salescredit()-');
105:
106: EXCEPTION
107: WHEN OTHERS THEN
108:

Line 114: 'EXCEPTION: arp_process_salescredit.val_update_salescredit()');

110: | Display parameters and raise the exception |
111: +---------------------------------------------*/
112:
113: arp_util.debug(
114: 'EXCEPTION: arp_process_salescredit.val_update_salescredit()');
115:
116:
117: arp_util.debug('');
118: arp_util.debug('---------- val_update_salescredit() ---------');

Line 158: arp_util.debug('arp_process_salescredit.val_delete_salescredit()+');

154:
155:
156: BEGIN
157:
158: arp_util.debug('arp_process_salescredit.val_delete_salescredit()+');
159:
160:
161: arp_util.debug('arp_process_salescredit.val_delete_salescredit()-');
162:

Line 161: arp_util.debug('arp_process_salescredit.val_delete_salescredit()-');

157:
158: arp_util.debug('arp_process_salescredit.val_delete_salescredit()+');
159:
160:
161: arp_util.debug('arp_process_salescredit.val_delete_salescredit()-');
162:
163: EXCEPTION
164: WHEN OTHERS THEN
165:

Line 171: 'EXCEPTION: arp_process_salescredit.val_delete_salescredit()');

167: | Display parameters and raise the exception |
168: +---------------------------------------------*/
169:
170: arp_util.debug(
171: 'EXCEPTION: arp_process_salescredit.val_delete_salescredit()');
172:
173:
174: arp_util.debug('');
175: arp_util.debug('---------- val_update_salescredit() ---------');

Line 241: arp_util.debug('arp_process_salescredit.set_flags()+');

237: l_revised_backout_flag boolean;
238:
239: BEGIN
240:
241: arp_util.debug('arp_process_salescredit.set_flags()+');
242:
243: arp_ctls_pkg.fetch_p(l_old_srep_rec,
244: p_cust_trx_line_salesrep_id);
245:

Line 360: arp_util.debug('arp_process_salescredit.set_flags()-');

356: arp_util.debug('p_revised_backout_flag = ' ||
357: arp_trx_util.boolean_to_varchar2(
358: l_revised_backout_flag));
359:
360: arp_util.debug('arp_process_salescredit.set_flags()-');
361:
362: EXCEPTION
363: WHEN OTHERS THEN
364:

Line 369: arp_util.debug('EXCEPTION: arp_process_salescredit.set_flags()');

365: /*---------------------------------------------+
366: | Display parameters and raise the exception |
367: +---------------------------------------------*/
368:
369: arp_util.debug('EXCEPTION: arp_process_salescredit.set_flags()');
370:
371: arp_util.debug('');
372: arp_util.debug('---------- parameters for set_flags() ---------');
373:

Line 444: arp_util.debug('arp_process_salescredit.run_autoacc_for_scredits()+');

440: l_dist_count NUMBER;
441:
442: BEGIN
443:
444: arp_util.debug('arp_process_salescredit.run_autoacc_for_scredits()+');
445:
446: arp_util.debug('p_customer_trx_id = ' ||
447: to_char( p_customer_trx_id ));
448: arp_util.debug('p_customer_trx_line_id = ' ||

Line 683: arp_util.debug('EXCEPTION: arp_process_salescredit.run_autoacc_for_scredits');

679: pg_trx_header_level_rounding ,
680: 'N',
681: 'N') = 0 -- FALSE
682: THEN
683: arp_util.debug('EXCEPTION: arp_process_salescredit.run_autoacc_for_scredits');
684: arp_util.debug(l_error_message);
685: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
686: APP_EXCEPTION.raise_exception;
687: END IF;

Line 689: arp_util.debug('arp_process_salescredit.run_autoacc_for_scredits()-');

685: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
686: APP_EXCEPTION.raise_exception;
687: END IF;
688:
689: arp_util.debug('arp_process_salescredit.run_autoacc_for_scredits()-');
690:
691: EXCEPTION
692: WHEN OTHERS THEN
693:

Line 699: 'EXCEPTION: arp_process_salescredit.run_autoacc_for_scredits');

695: | Display parameters and raise the exception |
696: +---------------------------------------------*/
697:
698: arp_util.debug(
699: 'EXCEPTION: arp_process_salescredit.run_autoacc_for_scredits');
700:
701: IF (l_errorbuf is not null)
702: THEN arp_util.debug('AutoAccounting error: ' || l_errorbuf);
703: END IF;

Line 770: arp_util.debug('arp_process_salescredit.backout_salesrep()+');

766: l_status2 varchar2(100);
767:
768: BEGIN
769:
770: arp_util.debug('arp_process_salescredit.backout_salesrep()+');
771:
772: l_old_srep_rec := p_old_srep_rec;
773: l_new_srep_rec := p_new_srep_rec;
774:

Line 844: arp_util.debug('arp_process_salescredit.backout_salesrep()-');

840: ELSE p_status := 'OK';
841: END IF;
842: END IF;
843:
844: arp_util.debug('arp_process_salescredit.backout_salesrep()-');
845:
846: EXCEPTION
847: WHEN OTHERS THEN
848: arp_util.debug('EXCEPTION: arp_process_salescredit.backout_salesrep()');

Line 848: arp_util.debug('EXCEPTION: arp_process_salescredit.backout_salesrep()');

844: arp_util.debug('arp_process_salescredit.backout_salesrep()-');
845:
846: EXCEPTION
847: WHEN OTHERS THEN
848: arp_util.debug('EXCEPTION: arp_process_salescredit.backout_salesrep()');
849: RAISE;
850:
851: END;
852:

Line 901: arp_util.debug('arp_process_salescredit.backout_amount()+');

897: l_new_srep_rec ra_cust_trx_line_salesreps%rowtype;
898:
899: BEGIN
900:
901: arp_util.debug('arp_process_salescredit.backout_amount()+');
902:
903: l_old_srep_rec := p_old_srep_rec;
904: l_new_srep_rec := p_new_srep_rec;
905:

Line 949: arp_util.debug('arp_process_salescredit.backout_amount()-');

945: l_cust_trx_line_salesrep_id,
946: p_status );
947: END IF;
948:
949: arp_util.debug('arp_process_salescredit.backout_amount()-');
950:
951: EXCEPTION
952: WHEN OTHERS THEN
953: arp_util.debug('EXCEPTION: arp_process_salescredit.backout_amount()');

Line 953: arp_util.debug('EXCEPTION: arp_process_salescredit.backout_amount()');

949: arp_util.debug('arp_process_salescredit.backout_amount()-');
950:
951: EXCEPTION
952: WHEN OTHERS THEN
953: arp_util.debug('EXCEPTION: arp_process_salescredit.backout_amount()');
954: RAISE;
955:
956: END;
957:

Line 1005: arp_util.debug('arp_process_salescredit.val_tax_from_revenue()+');

1001:
1002: BEGIN
1003:
1004: IF PG_DEBUG in ('Y', 'C') THEN
1005: arp_util.debug('arp_process_salescredit.val_tax_from_revenue()+');
1006: END IF;
1007:
1008: p_status := 'OK';
1009:

Line 1011: arp_util.debug('arp_process_salescredit.val_tax_from_revenue()-');

1007:
1008: p_status := 'OK';
1009:
1010: IF PG_DEBUG in ('Y', 'C') THEN
1011: arp_util.debug('arp_process_salescredit.val_tax_from_revenue()-');
1012: END IF;
1013:
1014: END val_tax_from_revenue;
1015:

Line 1067: arp_util.debug('arp_process_salescredit.insert_salescredit()+');

1063: l_status2 VARCHAR2(100);
1064:
1065: BEGIN
1066:
1067: arp_util.debug('arp_process_salescredit.insert_salescredit()+');
1068:
1069: /*----------------------------------------------+
1070: | Check the form version to determine if it |
1071: | is compatible with the entity handler. |

Line 1080: arp_process_salescredit.val_insert_salescredit(p_srep_rec);

1076: /*-------------------------+
1077: | Do required validation |
1078: +-------------------------*/
1079:
1080: arp_process_salescredit.val_insert_salescredit(p_srep_rec);
1081:
1082: /*----------------------------------------------------------------+
1083: | Lock rows in other tables that reference this customer_trx_id |
1084: +----------------------------------------------------------------*/

Line 1134: arp_util.debug('arp_process_salescredit.insert_salescredit()-');

1130: ELSE p_status := 'OK';
1131: END IF;
1132:
1133:
1134: arp_util.debug('arp_process_salescredit.insert_salescredit()-');
1135:
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138:

Line 1139: arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');

1135:
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138:
1139: arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');
1140:
1141: /*---------------------------------------------+
1142: | Display parameters and raise the exception |
1143: +---------------------------------------------*/

Line 1145: arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');

1141: /*---------------------------------------------+
1142: | Display parameters and raise the exception |
1143: +---------------------------------------------*/
1144:
1145: arp_util.debug('EXCEPTION: arp_process_salescredit.insert_salescredit()');
1146:
1147: arp_util.debug('');
1148: arp_util.debug('---------- insert_salescredit() ---------');
1149:

Line 1238: arp_util.debug('arp_process_salescredit.update_salescredit()+');

1234: l_status4 varchar2(100);
1235:
1236: BEGIN
1237:
1238: arp_util.debug('arp_process_salescredit.update_salescredit()+');
1239:
1240: /*----------------------------------------------+
1241: | Check the form version to determine if it |
1242: | is compatible with the entity handler. |

Line 1264: arp_process_salescredit.val_update_salescredit(p_srep_rec);

1260: /*-------------------------+
1261: | Do required validation |
1262: +-------------------------*/
1263:
1264: arp_process_salescredit.val_update_salescredit(p_srep_rec);
1265:
1266: /*----------------------------------------------------------------+
1267: | Lock rows in other tables that reference this customer_trx_id |
1268: +----------------------------------------------------------------*/

Line 1414: arp_util.debug('arp_process_salescredit.update_salescredit()-');

1410: THEN p_status := l_status4;
1411: ELSE p_status := 'OK';
1412: END IF;
1413:
1414: arp_util.debug('arp_process_salescredit.update_salescredit()-');
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418:

Line 1424: arp_util.debug('EXCEPTION: arp_process_salescredit.update_salescredit()');

1420: /*---------------------------------------------+
1421: | Display parameters and raise the exception |
1422: +---------------------------------------------*/
1423:
1424: arp_util.debug('EXCEPTION: arp_process_salescredit.update_salescredit()');
1425: arp_util.debug('');
1426: arp_util.debug('---------- parameters for update_salescredit() ---------');
1427: arp_util.debug('p_form_name = ' || p_form_name);
1428: arp_util.debug('p_form_version = ' || p_form_version);

Line 1514: arp_util.debug('arp_process_salescredit.delete_salescredit()+');

1510: l_status3 varchar2(100);
1511:
1512: BEGIN
1513:
1514: arp_util.debug('arp_process_salescredit.delete_salescredit()+');
1515:
1516: /*----------------------------------------------+
1517: | Check the form version to determine if it |
1518: | is compatible with the entity handler. |

Line 1527: arp_process_salescredit.val_delete_salescredit(p_srep_rec);

1523: /*-------------------------+
1524: | Do required validation |
1525: +-------------------------*/
1526:
1527: arp_process_salescredit.val_delete_salescredit(p_srep_rec);
1528:
1529: set_flags(p_cust_trx_line_salesrep_id,
1530: p_srep_rec,
1531: p_backout_flag,

Line 1627: arp_util.debug('arp_process_salescredit.delete_salescredit()-');

1623: THEN p_status := l_status3;
1624: ELSE p_status := 'OK';
1625: END IF;
1626:
1627: arp_util.debug('arp_process_salescredit.delete_salescredit()-');
1628:
1629: EXCEPTION
1630: WHEN OTHERS THEN
1631:

Line 1637: arp_util.debug('EXCEPTION: arp_process_salescredit.delete_salescredit()');

1633: /*---------------------------------------------+
1634: | Display parameters and raise the exception |
1635: +---------------------------------------------*/
1636:
1637: arp_util.debug('EXCEPTION: arp_process_salescredit.delete_salescredit()');
1638:
1639: arp_util.debug('');
1640: arp_util.debug('---------- delete_salescredit() ---------');
1641:

Line 1717: arp_util.debug('arp_process_salescredit.create_line_salescredits()+');

1713: p_salesrep_id ra_customer_trx.primary_salesrep_id%type;
1714:
1715: BEGIN
1716:
1717: arp_util.debug('arp_process_salescredit.create_line_salescredits()+');
1718:
1719: /*-------------------------------------+
1720: |Checking whether its Credit Memo |
1721: +-------------------------------------*/

Line 1831: arp_util.debug('arp_process_salescredit.create_line_salescredits()-');

1827: THEN p_status := l_status2;
1828: ELSE p_status := 'OK';
1829: END IF;
1830:
1831: arp_util.debug('arp_process_salescredit.create_line_salescredits()-');
1832:
1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: arp_util.debug(sqlerrm);

Line 1837: 'EXCEPTION: arp_process_salescredit.create_line_salescredits()');

1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: arp_util.debug(sqlerrm);
1836: arp_util.debug(
1837: 'EXCEPTION: arp_process_salescredit.create_line_salescredits()');
1838:
1839:
1840: arp_util.debug('');
1841: arp_util.debug('---- parameters for create_line_salescredits() -----');

Line 1980: arp_util.debug('arp_process_salescredit.insert_salescredit_cover()+');

1976: /* bug 3607146 */
1977: l_scredit_count NUMBER;
1978: BEGIN
1979:
1980: arp_util.debug('arp_process_salescredit.insert_salescredit_cover()+');
1981:
1982: /*------------------------------------------------+
1983: | Populate the salescredit record group with |
1984: | the values passed in as parameters. |

Line 2030: arp_util.debug('arp_process_salescredit.insert_salescredit_cover()-');

2026: /* bug 3607146 */
2027: arp_rounding.correct_scredit_rounding_errs( p_customer_trx_id,
2028: l_scredit_count);
2029:
2030: arp_util.debug('arp_process_salescredit.insert_salescredit_cover()-');
2031:
2032: EXCEPTION
2033: WHEN OTHERS THEN
2034:

Line 2036: 'EXCEPTION: arp_process_salescredit.insert_salescredit_cover()');

2032: EXCEPTION
2033: WHEN OTHERS THEN
2034:
2035: arp_util.debug(
2036: 'EXCEPTION: arp_process_salescredit.insert_salescredit_cover()');
2037:
2038: arp_util.debug('------- parameters for insert_salescredit_cover() ' ||
2039: '---------');
2040: arp_util.debug('p_form_name = ' || p_form_name );

Line 2214: arp_util.debug('arp_process_salescredit.update_salescredit_cover()+');

2210: l_scredit_count NUMBER;
2211:
2212: BEGIN
2213:
2214: arp_util.debug('arp_process_salescredit.update_salescredit_cover()+');
2215:
2216: /*------------------------------------------------+
2217: | Populate the salescredit record group with |
2218: | the values passed in as parameters. |

Line 2272: arp_util.debug('arp_process_salescredit.update_salescredit_cover()-');

2268: /* bug 3607146 */
2269: arp_rounding.correct_scredit_rounding_errs( p_customer_trx_id,
2270: l_scredit_count);
2271:
2272: arp_util.debug('arp_process_salescredit.update_salescredit_cover()-');
2273:
2274: EXCEPTION
2275: WHEN OTHERS THEN
2276:

Line 2278: 'EXCEPTION: arp_process_salescredit.update_salescredit_cover()');

2274: EXCEPTION
2275: WHEN OTHERS THEN
2276:
2277: arp_util.debug(
2278: 'EXCEPTION: arp_process_salescredit.update_salescredit_cover()');
2279:
2280: arp_util.debug('------- parameters for update_salescredit_cover() ' ||
2281: '---------');
2282: arp_util.debug('p_form_name = ' || p_form_name );

Line 2458: arp_util.debug('arp_process_salescredit.delete_salescredit_cover()+');

2454: l_scredit_count NUMBER;
2455:
2456: BEGIN
2457:
2458: arp_util.debug('arp_process_salescredit.delete_salescredit_cover()+');
2459:
2460: /*------------------------------------------------+
2461: | Populate the salescredit record group with |
2462: | the values passed in as parameters. |

Line 2515: arp_util.debug('arp_process_salescredit.delete_salescredit_cover()-');

2511: /* bug 3607146 */
2512: arp_rounding.correct_scredit_rounding_errs( p_customer_trx_id,
2513: l_scredit_count);
2514:
2515: arp_util.debug('arp_process_salescredit.delete_salescredit_cover()-');
2516:
2517: EXCEPTION
2518: WHEN OTHERS THEN
2519:

Line 2521: 'EXCEPTION: arp_process_salescredit.delete_salescredit_cover()');

2517: EXCEPTION
2518: WHEN OTHERS THEN
2519:
2520: arp_util.debug(
2521: 'EXCEPTION: arp_process_salescredit.delete_salescredit_cover()');
2522:
2523: arp_util.debug('------- parameters for delete_salescredit_cover() ' ||
2524: '---------');
2525: arp_util.debug('p_form_name = ' || p_form_name );

Line 2583: END ARP_PROCESS_SALESCREDIT;

2579: pg_base_precision := arp_global.base_precision;
2580: pg_base_min_acc_unit := arp_global.base_min_acc_unit;
2581: pg_trx_header_level_rounding := arp_global.sysparam.trx_header_level_rounding;
2582:
2583: END ARP_PROCESS_SALESCREDIT;