APPS.AR_DEPOSIT_API_PUB dependencies on ARP_UTIL

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 147: arp_util.debug('pg_profile_enable_cc :'

143: ar_deposit_lib_pvt.pg_profile_def_x_rate_type
144: := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
145: END IF;
146:
147: arp_util.debug('pg_profile_enable_cc :'
148: ||ar_deposit_lib_pvt.pg_profile_enable_cc);
149: arp_util.debug('pg_profile_trxln_excpt_flag :'
150: ||ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag);
151: arp_util.debug('pg_profile_doc_seq :'

Line 149: arp_util.debug('pg_profile_trxln_excpt_flag :'

145: END IF;
146:
147: arp_util.debug('pg_profile_enable_cc :'
148: ||ar_deposit_lib_pvt.pg_profile_enable_cc);
149: arp_util.debug('pg_profile_trxln_excpt_flag :'
150: ||ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag);
151: arp_util.debug('pg_profile_doc_seq :'
152: || ar_deposit_lib_pvt.pg_profile_doc_seq);
153: arp_util.debug('pg_profile_batch_source :'

Line 151: arp_util.debug('pg_profile_doc_seq :'

147: arp_util.debug('pg_profile_enable_cc :'
148: ||ar_deposit_lib_pvt.pg_profile_enable_cc);
149: arp_util.debug('pg_profile_trxln_excpt_flag :'
150: ||ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag);
151: arp_util.debug('pg_profile_doc_seq :'
152: || ar_deposit_lib_pvt.pg_profile_doc_seq);
153: arp_util.debug('pg_profile_batch_source :'
154: ||ar_deposit_lib_pvt.pg_profile_batch_source);
155: arp_util.debug('pg_profile_def_x_rate_type :'

Line 153: arp_util.debug('pg_profile_batch_source :'

149: arp_util.debug('pg_profile_trxln_excpt_flag :'
150: ||ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag);
151: arp_util.debug('pg_profile_doc_seq :'
152: || ar_deposit_lib_pvt.pg_profile_doc_seq);
153: arp_util.debug('pg_profile_batch_source :'
154: ||ar_deposit_lib_pvt.pg_profile_batch_source);
155: arp_util.debug('pg_profile_def_x_rate_type :'
156: ||ar_deposit_lib_pvt.pg_profile_def_x_rate_type);
157: arp_util.debug('pg_profile_dsp_inv_rate :'

Line 155: arp_util.debug('pg_profile_def_x_rate_type :'

151: arp_util.debug('pg_profile_doc_seq :'
152: || ar_deposit_lib_pvt.pg_profile_doc_seq);
153: arp_util.debug('pg_profile_batch_source :'
154: ||ar_deposit_lib_pvt.pg_profile_batch_source);
155: arp_util.debug('pg_profile_def_x_rate_type :'
156: ||ar_deposit_lib_pvt.pg_profile_def_x_rate_type);
157: arp_util.debug('pg_profile_dsp_inv_rate :'
158: ||ar_deposit_lib_pvt.pg_profile_dsp_inv_rate);
159: arp_util.debug('pg_profile_cc_rate_type :'

Line 157: arp_util.debug('pg_profile_dsp_inv_rate :'

153: arp_util.debug('pg_profile_batch_source :'
154: ||ar_deposit_lib_pvt.pg_profile_batch_source);
155: arp_util.debug('pg_profile_def_x_rate_type :'
156: ||ar_deposit_lib_pvt.pg_profile_def_x_rate_type);
157: arp_util.debug('pg_profile_dsp_inv_rate :'
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:

Line 159: arp_util.debug('pg_profile_cc_rate_type :'

155: arp_util.debug('pg_profile_def_x_rate_type :'
156: ||ar_deposit_lib_pvt.pg_profile_def_x_rate_type);
157: arp_util.debug('pg_profile_dsp_inv_rate :'
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:

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 188: | arp_util.debug(

184: |
185: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
186: | Enter a list of all local procedures and funtions which
187: | this package calls.
188: | arp_util.debug(
189: | FND_API.Compatible_API_Call
190: | FND_API.G_EXC_UNEXPECTED_ERROR
191: | FND_API.to_Boolean
192: | FND_MSG_PUB.initialize

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 650: arp_util.debug('initialize local variable ');

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: +-----------------------------------------------------------------------*/
654:

Line 786: arp_util.debug('Save point defined and calling compatible API call ');

782: | Standard start of API savepoint |
783: +------------------------------------*/
784:
785: SAVEPOINT Create_Deposit_PVT;
786: arp_util.debug('Save point defined and calling compatible API call ');
787: /*--------------------------------------------------+
788: | Standard call to check for call compatibility |
789: +--------------------------------------------------*/
790:

Line 839: arp_util.debug('Before initialize_profile_globals ');

835: ELSE
836: /*-------------------------------------------------+
837: | Initialize the profile option package variables |
838: +-------------------------------------------------*/
839: arp_util.debug('Before initialize_profile_globals ');
840: initialize_profile_globals;
841: arp_util.debug('After initialize_profile_globals');
842:
843:

Line 841: arp_util.debug('After initialize_profile_globals');

837: | Initialize the profile option package variables |
838: +-------------------------------------------------*/
839: arp_util.debug('Before initialize_profile_globals ');
840: initialize_profile_globals;
841: arp_util.debug('After initialize_profile_globals');
842:
843:
844: /*--------------------------------------------------------------------------+
845: | Getting all id 's required for commitment creation from name or number |

Line 908: arp_util.debug('l_receipt_method_id'||to_char(l_receipt_method_id));

904: l_deposit_date,
905: l_id_return_status --out
906: );
907:
908: arp_util.debug('l_receipt_method_id'||to_char(l_receipt_method_id));
909: /*----------------------------------------------------------------------------+
910: | Getting some of the defaulted values for depsoit creations |
911: +----------------------------------------------------------------------------*/
912:

Line 1023: arp_util.debug('l_term_id := '||to_char(l_term_id));

1019: 'N',
1020: 'Y'
1021: );
1022: END IF;
1023: arp_util.debug('l_term_id := '||to_char(l_term_id));
1024: arp_util.debug('l_default_term_id := '||to_char(l_default_term_id));
1025:
1026: IF l_cust_trx_type_id is NULL and
1027: l_default_cust_trx_type_id is NULL THEN

Line 1024: arp_util.debug('l_default_term_id := '||to_char(l_default_term_id));

1020: 'Y'
1021: );
1022: END IF;
1023: arp_util.debug('l_term_id := '||to_char(l_term_id));
1024: arp_util.debug('l_default_term_id := '||to_char(l_default_term_id));
1025:
1026: IF l_cust_trx_type_id is NULL and
1027: l_default_cust_trx_type_id is NULL THEN
1028:

Line 1092: arp_util.debug('l_receipt_method_id'||

1088: l_fin_bank_account_num,
1089: l_fin_bank_name,
1090: l_fin_bank_branch_name,
1091: l_fin_bank_branch_id);
1092: arp_util.debug('l_receipt_method_id'||
1093: to_char(l_receipt_method_id));
1094: arp_util.debug('l_cust_bank_account_id'||
1095: to_char(l_cust_bank_account_id));
1096: arp_util.debug('l_fin_receipt_method_id'||

Line 1094: arp_util.debug('l_cust_bank_account_id'||

1090: l_fin_bank_branch_name,
1091: l_fin_bank_branch_id);
1092: arp_util.debug('l_receipt_method_id'||
1093: to_char(l_receipt_method_id));
1094: arp_util.debug('l_cust_bank_account_id'||
1095: to_char(l_cust_bank_account_id));
1096: arp_util.debug('l_fin_receipt_method_id'||
1097: to_char(l_fin_receipt_method_id));
1098: arp_util.debug('l_fin_customer_bank_account_id'||

Line 1096: arp_util.debug('l_fin_receipt_method_id'||

1092: arp_util.debug('l_receipt_method_id'||
1093: to_char(l_receipt_method_id));
1094: arp_util.debug('l_cust_bank_account_id'||
1095: to_char(l_cust_bank_account_id));
1096: arp_util.debug('l_fin_receipt_method_id'||
1097: to_char(l_fin_receipt_method_id));
1098: arp_util.debug('l_fin_customer_bank_account_id'||
1099: to_char(l_fin_customer_bank_account_id));
1100:

Line 1098: arp_util.debug('l_fin_customer_bank_account_id'||

1094: arp_util.debug('l_cust_bank_account_id'||
1095: to_char(l_cust_bank_account_id));
1096: arp_util.debug('l_fin_receipt_method_id'||
1097: to_char(l_fin_receipt_method_id));
1098: arp_util.debug('l_fin_customer_bank_account_id'||
1099: to_char(l_fin_customer_bank_account_id));
1100:
1101: END IF;
1102:

Line 1185: arp_util.debug('x_return_status : '||x_return_status);

1181: /*------------------------------------------------------------+
1182: | If any errors - including validation failures - occurred, |
1183: | rollback any changes and return an error status. |
1184: +------------------------------------------------------------*/
1185: arp_util.debug('x_return_status : '||x_return_status);
1186: arp_util.debug('l_doc_seq_status : '||l_doc_seq_status);
1187: IF (
1188: x_return_status <> FND_API.G_RET_STS_SUCCESS
1189: OR l_doc_seq_status <> FND_API.G_RET_STS_SUCCESS

Line 1186: arp_util.debug('l_doc_seq_status : '||l_doc_seq_status);

1182: | If any errors - including validation failures - occurred, |
1183: | rollback any changes and return an error status. |
1184: +------------------------------------------------------------*/
1185: arp_util.debug('x_return_status : '||x_return_status);
1186: arp_util.debug('l_doc_seq_status : '||l_doc_seq_status);
1187: IF (
1188: x_return_status <> FND_API.G_RET_STS_SUCCESS
1189: OR l_doc_seq_status <> FND_API.G_RET_STS_SUCCESS
1190: )

Line 1207: arp_util.debug('Error(s) occurred.

1203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1204: p_count => x_msg_count,
1205: p_data => x_msg_data);
1206:
1207: arp_util.debug('Error(s) occurred.
1208: Rolling back and setting status to ERROR');
1209: Return;
1210: END IF;
1211: arp_util.debug('x_return_status '||x_return_status);

Line 1211: arp_util.debug('x_return_status '||x_return_status);

1207: arp_util.debug('Error(s) occurred.
1208: Rolling back and setting status to ERROR');
1209: Return;
1210: END IF;
1211: arp_util.debug('x_return_status '||x_return_status);
1212:
1213: /*---------------------------------------------------------------------+
1214: | Bug 6620785 Get and validate default legal entity id |
1215: +--------------------------------------------------------------------*/

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 1419: arp_util.debug('arp_process_header_insrt_cover.insert_header_cover: l_new_status'||l_new_status );

1415: X_new_trx_number := l_new_trx_number;
1416: X_new_customer_trx_id := l_new_customer_trx_id;
1417: X_new_customer_trx_line_id := l_new_customer_trx_line_id;
1418: X_new_rowid := l_new_rowid;
1419: arp_util.debug('arp_process_header_insrt_cover.insert_header_cover: l_new_status'||l_new_status );
1420: EXCEPTION
1421: WHEN Others THEN
1422: FND_MESSAGE.SET_NAME('AR','AR_DAPI_INSERT_HEADER_ST');
1423: FND_MSG_PUB.Add;

Line 1551: arp_util.debug('committing');

1547: +--------------------------------*/
1548:
1549: IF FND_API.To_Boolean( p_commit )
1550: THEN
1551: arp_util.debug('committing');
1552: Commit;
1553: END IF;
1554:
1555: arp_util.debug('AR_DEPOSIT_API_PUB.Create_Deposit()- ');

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 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 1667: arp_util.debug('initialize local variable ');

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 |
1671: +------------------------------------*/

Line 1674: arp_util.debug('Save point defined and calling compatible API call ');

1670: | Standard start of API savepoint |
1671: +------------------------------------*/
1672:
1673: SAVEPOINT Create_non_rev_sales_PVT;
1674: arp_util.debug('Save point defined and calling compatible API call ');
1675: /*--------------------------------------------------+
1676: | Standard call to check for call compatibility |
1677: +--------------------------------------------------*/
1678:

Line 1726: arp_util.debug('Before initialize_profile_globals ');

1722:
1723: /*-------------------------------------------------+
1724: | Initialize the profile option package variables |
1725: +-------------------------------------------------*/
1726: arp_util.debug('Before initialize_profile_globals ');
1727: initialize_profile_globals;
1728: arp_util.debug('After initialize_profile_globals');
1729:
1730:

Line 1728: arp_util.debug('After initialize_profile_globals');

1724: | Initialize the profile option package variables |
1725: +-------------------------------------------------*/
1726: arp_util.debug('Before initialize_profile_globals ');
1727: initialize_profile_globals;
1728: arp_util.debug('After initialize_profile_globals');
1729:
1730:
1731: l_amount := 0;
1732:

Line 1957: arp_util.debug('Error(s) occurred.

1953: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1954: p_count => x_msg_count,
1955: p_data => x_msg_data);
1956:
1957: arp_util.debug('Error(s) occurred.
1958: Rolling back and setting status to ERROR');
1959:
1960: Return;
1961: END IF;

Line 1963: arp_util.debug('x_return_status '||x_return_status);

1959:
1960: Return;
1961: END IF;
1962:
1963: arp_util.debug('x_return_status '||x_return_status);
1964:
1965: BEGIN
1966: arp_process_salescredit.insert_salescredit_cover(
1967: l_api_name,

Line 2025: arp_util.debug('committing');

2021: +--------------------------------*/
2022:
2023: IF FND_API.To_Boolean( p_commit )
2024: THEN
2025: arp_util.debug('committing');
2026: Commit;
2027: END IF;
2028:
2029: arp_util.debug('AR_DEPOSIT_API_PUB.insert_non_rev_salescredit()- ');

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 2156: arp_util.debug('customer_trx_id'|| p_customer_trx_id);

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

Line 2157: arp_util.debug('payment_trxn_extension_id'|| p_payment_trxn_extension_id);

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

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 2197: arp_util.debug('customer_trx_id'|| p_customer_trx_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 */
2201:

Line 2259: arp_util.debug('FAILED: ' ||l_response_rec.result_code,0);

2255: END IF;
2256:
2257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2258:
2259: arp_util.debug('FAILED: ' ||l_response_rec.result_code,0);
2260:
2261: p_return_status := FND_API.G_RET_STS_ERROR ;
2262:
2263: END IF;

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: