DBA Data[Home] [Help]

APPS.AR_DEPOSIT_API_PUB dependencies on AR_DEPOSIT_API_PUB

Line 1: Package BODY AR_DEPOSIT_API_PUB AS

1: Package BODY AR_DEPOSIT_API_PUB AS
2: /* $Header: ARXCDEPB.pls 120.28 2008/09/30 10:11:32 nemani ship $ */
3:
4: /*=======================================================================+
5: | Package Global Constants

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_DEPOSIT_API_PUB';

3:
4: /*=======================================================================+
5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_DEPOSIT_API_PUB';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 64: | required by AR_DEPOSIT_API_PUB.Create_Deposit to create deposit.

60: | DESCRIPTION
61: | Enter a brief description of what the package procedure does.
62: | ----------------------------------------
63: | This procedure does the following: Initialize all profile option values
64: | required by AR_DEPOSIT_API_PUB.Create_Deposit to create deposit.
65: | Values are set at public variables in ar_deposit_lib_pvt package spec
66: |
67: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
68: | Enter a list of all local procedures and functions which

Line 70: | AR_DEPOSIT_API_PUB.Create_Deposit

66: |
67: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
68: | Enter a list of all local procedures and functions which
69: | are call this package.
70: | AR_DEPOSIT_API_PUB.Create_Deposit
71: |
72: |
73: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
74: | Enter a list of all local procedures and funtions which

Line 95: arp_util.debug('AR_DEPOSIT_API_PUB.initialize_profile_globals()+ ');

91: *=======================================================================*/
92: PROCEDURE initialize_profile_globals IS
93: l_dummy varchar2(1);
94: BEGIN
95: arp_util.debug('AR_DEPOSIT_API_PUB.initialize_profile_globals()+ ');
96: IF ar_deposit_lib_pvt.pg_profile_batch_source = FND_API.G_MISS_NUM THEN
97: ar_deposit_lib_pvt.pg_profile_batch_source
98: := fnd_profile.value('AR_RA_BATCH_SOURCE');
99: --To make sure that Batch derived from profile option belongs to same org

Line 162: arp_util.debug('AR_DEPOSIT_API_PUB.initialize_profile_globals()- ');

158: ||ar_deposit_lib_pvt.pg_profile_dsp_inv_rate);
159: arp_util.debug('pg_profile_cc_rate_type :'
160: ||ar_deposit_lib_pvt.pg_profile_cc_rate_type);
161:
162: arp_util.debug('AR_DEPOSIT_API_PUB.initialize_profile_globals()- ');
163:
164: END initialize_profile_globals;
165:
166: /*========================================================================

Line 649: arp_util.debug('AR_DEPOSIT_API_PUB.Create_Deposit()+ ');

645: l_payment_trxn_extension_id NUMBER;
646: l_legal_entity_id NUMBER;
647: BEGIN
648: --assignment to local variables
649: arp_util.debug('AR_DEPOSIT_API_PUB.Create_Deposit()+ ');
650: arp_util.debug('initialize local variable ');
651: /*-----------------------------------------------------------------------+
652: | Local Variable initializations |
653: +-----------------------------------------------------------------------*/

Line 929: 'AR_DEPOSIT_API_PUB',

925: l_ship_to_customer_id,
926: l_ship_to_site_use_id,
927: l_default_salesrep_id,
928: l_dft_bill_to_contact_id,
929: 'AR_DEPOSIT_API_PUB',
930: l_dft_return_status);
931:
932:
933:

Line 1218: arp_util.debug ('AR_DEPOSIT_API_PUB.populate_legal_entity(+)' );

1214: | Bug 6620785 Get and validate default legal entity id |
1215: +--------------------------------------------------------------------*/
1216: BEGIN
1217: IF pg_debug = 'Y' THEN
1218: arp_util.debug ('AR_DEPOSIT_API_PUB.populate_legal_entity(+)' );
1219: END IF;
1220:
1221: l_legal_entity_id := arp_legal_entity_util.get_default_le(
1222: l_sold_to_customer_id,

Line 1233: arp_util.debug ('AR_DEPOSIT_API_PUB.populate_legal_entity(-)' );

1229: Return;
1230: END IF;
1231:
1232: IF pg_debug = 'Y' THEN
1233: arp_util.debug ('AR_DEPOSIT_API_PUB.populate_legal_entity(-)' );
1234: END IF;
1235:
1236: EXCEPTION
1237: WHEN Others THEN

Line 1499: arp_process_header.post_commit( 'AR_DEPOSIT_API_PUB',

1495:
1496: IF l_new_customer_trx_id IS NOT NULL
1497: THEN
1498: BEGIN
1499: arp_process_header.post_commit( 'AR_DEPOSIT_API_PUB',
1500: 1.0,
1501: l_new_customer_trx_id,
1502: NULL,
1503: 'Y',

Line 1555: arp_util.debug('AR_DEPOSIT_API_PUB.Create_Deposit()- ');

1551: arp_util.debug('committing');
1552: Commit;
1553: END IF;
1554:
1555: arp_util.debug('AR_DEPOSIT_API_PUB.Create_Deposit()- ');
1556: END CREATE_DEPOSIT;
1557: /*========================================================================
1558: | PUBLIC PROCEDURE insert_non_rev_salescredit
1559: |

Line 1571: | AR_DEPOSIT_API_PUB.insert_non_rev_salescredit

1567: |
1568: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
1569: | Enter a list of all local procedures and functions which
1570: | are call this package.
1571: | AR_DEPOSIT_API_PUB.insert_non_rev_salescredit
1572: | Parameter
1573: | p_deposit_number
1574: | p_customer_trx_id
1575: | p_salesrep_number

Line 1647: l_desc_flex_rec ar_deposit_api_pub.attr_rec_type;

1643: l_salesrep_number ra_salesreps.salesrep_number%type;
1644: l_salesrep_id ra_cust_trx_line_salesreps.salesrep_id%type;
1645: l_non_revenue_amount_split ra_cust_trx_line_salesreps.non_revenue_amount_split%type;
1646: l_non_revenue_percent_split ra_cust_trx_line_salesreps.non_revenue_percent_split%type;
1647: l_desc_flex_rec ar_deposit_api_pub.attr_rec_type;
1648: l_dflex_val_return_status varchar2(1000);
1649: l_nosales_val_return_status varchar2(1000);
1650: l_dept_no_return_status varchar2(1000);
1651: l_sales_val_return_status varchar2(1000);

Line 1666: arp_util.debug('AR_DEPOSIT_API_PUB.insert_non_rev_salescredit()+ ');

1662: l_org_id NUMBER;
1663: BEGIN
1664:
1665: --assignment to local variables
1666: arp_util.debug('AR_DEPOSIT_API_PUB.insert_non_rev_salescredit()+ ');
1667: arp_util.debug('initialize local variable ');
1668:
1669: /*------------------------------------+
1670: | Standard start of API savepoint |

Line 2029: arp_util.debug('AR_DEPOSIT_API_PUB.insert_non_rev_salescredit()- ');

2025: arp_util.debug('committing');
2026: Commit;
2027: END IF;
2028:
2029: arp_util.debug('AR_DEPOSIT_API_PUB.insert_non_rev_salescredit()- ');
2030:
2031: END insert_non_rev_salescredit;
2032:
2033:

Line 2077: arp_util.debug('AR_DEPOSIT_API_PUB.set_profile_for_testing()+ ');

2073: p_profile_dsp_inv_rate VARCHAR2,
2074: p_profile_def_x_rate_type VARCHAR2
2075: ) IS
2076: BEGIN
2077: arp_util.debug('AR_DEPOSIT_API_PUB.set_profile_for_testing()+ ');
2078:
2079: ar_deposit_lib_pvt.pg_profile_batch_source := p_profile_batch_source;
2080: ar_deposit_lib_pvt.pg_profile_doc_seq := p_profile_doc_seq;
2081: ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag := p_profile_trxln_excpt;

Line 2087: arp_util.debug('AR_DEPOSIT_API_PUB.set_profile_for_testing()- ');

2083: ar_deposit_lib_pvt.pg_profile_cc_rate_type := p_profile_cc_rate_type;
2084: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate := p_profile_dsp_inv_rate;
2085: ar_deposit_lib_pvt.pg_profile_def_x_rate_type := p_profile_def_x_rate_type;
2086:
2087: arp_util.debug('AR_DEPOSIT_API_PUB.set_profile_for_testing()- ');
2088:
2089: END set_profile_for_testing;
2090:
2091:

Line 2155: arp_util.debug('AR_DEPOSIT_API_PUB.create_trxn_extension()'|| SQLERRM);

2151:
2152:
2153: BEGIN
2154:
2155: arp_util.debug('AR_DEPOSIT_API_PUB.create_trxn_extension()'|| SQLERRM);
2156: arp_util.debug('customer_trx_id'|| p_customer_trx_id);
2157: arp_util.debug('payment_trxn_extension_id'|| p_payment_trxn_extension_id);
2158:
2159:

Line 2196: arp_util.debug('AR_DEPOSIT_API_PUB.create_trxn_extension()'|| SQLERRM);

2192: where trxn_extension_id = p_payment_trxn_extension_id;
2193:
2194:
2195:
2196: arp_util.debug('AR_DEPOSIT_API_PUB.create_trxn_extension()'|| SQLERRM);
2197: arp_util.debug('customer_trx_id'|| p_customer_trx_id);
2198:
2199:
2200: /* pouplate values into the variables */

Line 2268: arp_util.debug('AR_DEPOSIT_API_PUB.create_trxn_extension()'|| SQLERRM);

2264:
2265:
2266: END IF ; /* payment_trxn_extension_id is not null */
2267:
2268: arp_util.debug('AR_DEPOSIT_API_PUB.create_trxn_extension()'|| SQLERRM);
2269: EXCEPTION
2270: WHEN OTHERS THEN
2271: p_return_status := FND_API.G_RET_STS_ERROR ;
2272:

Line 2273: arp_util.debug('AR_DEPOSIT_API_PUB.create_trxn_extension()'|| SQLERRM);

2269: EXCEPTION
2270: WHEN OTHERS THEN
2271: p_return_status := FND_API.G_RET_STS_ERROR ;
2272:
2273: arp_util.debug('AR_DEPOSIT_API_PUB.create_trxn_extension()'|| SQLERRM);
2274: END copy_trxn_extension;
2275:
2276:
2277:

Line 2295: END AR_DEPOSIT_API_PUB;

2291: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate := FND_API.G_MISS_CHAR;
2292: ar_deposit_lib_pvt.pg_profile_def_x_rate_type := FND_API.G_MISS_CHAR;
2293:
2294:
2295: END AR_DEPOSIT_API_PUB;