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.ARW_CM_COVER dependencies on ARP_UTIL

Line 49: arp_util.debug('get_doc_seq()+');

45:
46: BEGIN
47:
48: IF PG_DEBUG in ('Y', 'C') THEN
49: arp_util.debug('get_doc_seq()+');
50: END IF;
51:
52: p_return_status := FND_API.G_RET_STS_SUCCESS;
53:

Line 60: arp_util.debug('get_doc_seq: ' || 'UNIQUE:SEQ : '|| unique_seq_numbers);

56: -- P - partially Used
57: -- N - Not used
58:
59: IF PG_DEBUG in ('Y', 'C') THEN
60: arp_util.debug('get_doc_seq: ' || 'UNIQUE:SEQ : '|| unique_seq_numbers);
61: arp_util.debug('get_doc_seq: ' || 'p_complete_flag : ' || p_complete_flag);
62: END IF;
63:
64:

Line 61: arp_util.debug('get_doc_seq: ' || 'p_complete_flag : ' || p_complete_flag);

57: -- N - Not used
58:
59: IF PG_DEBUG in ('Y', 'C') THEN
60: arp_util.debug('get_doc_seq: ' || 'UNIQUE:SEQ : '|| unique_seq_numbers);
61: arp_util.debug('get_doc_seq: ' || 'p_complete_flag : ' || p_complete_flag);
62: END IF;
63:
64:
65: IF ( NVL( unique_seq_numbers, 'N') <> 'N' ) THEN

Line 91: arp_util.debug('Doc sequence return status :'||to_char(nvl(l_doc_seq_ret_stat,-99)));

87: 'Y',
88: 'Y');
89:
90: IF PG_DEBUG in ('Y', 'C') THEN
91: arp_util.debug('Doc sequence return status :'||to_char(nvl(l_doc_seq_ret_stat,-99)));
92: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
93: arp_util.debug('l_db_sequence_name :'|| l_db_sequence_name);
94: arp_util.debug('l_doc_sequence_type :' || l_doc_sequence_type);
95: arp_util.debug('l_doc_sequence_id :'||to_char(nvl(p_doc_sequence_id,-99)));

Line 92: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);

88: 'Y');
89:
90: IF PG_DEBUG in ('Y', 'C') THEN
91: arp_util.debug('Doc sequence return status :'||to_char(nvl(l_doc_seq_ret_stat,-99)));
92: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
93: arp_util.debug('l_db_sequence_name :'|| l_db_sequence_name);
94: arp_util.debug('l_doc_sequence_type :' || l_doc_sequence_type);
95: arp_util.debug('l_doc_sequence_id :'||to_char(nvl(p_doc_sequence_id,-99)));
96: END IF;

Line 93: arp_util.debug('l_db_sequence_name :'|| l_db_sequence_name);

89:
90: IF PG_DEBUG in ('Y', 'C') THEN
91: arp_util.debug('Doc sequence return status :'||to_char(nvl(l_doc_seq_ret_stat,-99)));
92: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
93: arp_util.debug('l_db_sequence_name :'|| l_db_sequence_name);
94: arp_util.debug('l_doc_sequence_type :' || l_doc_sequence_type);
95: arp_util.debug('l_doc_sequence_id :'||to_char(nvl(p_doc_sequence_id,-99)));
96: END IF;
97:

Line 94: arp_util.debug('l_doc_sequence_type :' || l_doc_sequence_type);

90: IF PG_DEBUG in ('Y', 'C') THEN
91: arp_util.debug('Doc sequence return status :'||to_char(nvl(l_doc_seq_ret_stat,-99)));
92: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
93: arp_util.debug('l_db_sequence_name :'|| l_db_sequence_name);
94: arp_util.debug('l_doc_sequence_type :' || l_doc_sequence_type);
95: arp_util.debug('l_doc_sequence_id :'||to_char(nvl(p_doc_sequence_id,-99)));
96: END IF;
97:
98: IF l_doc_seq_ret_stat = -8 THEN

Line 95: arp_util.debug('l_doc_sequence_id :'||to_char(nvl(p_doc_sequence_id,-99)));

91: arp_util.debug('Doc sequence return status :'||to_char(nvl(l_doc_seq_ret_stat,-99)));
92: arp_util.debug('l_doc_sequence_name :'||l_doc_sequence_name);
93: arp_util.debug('l_db_sequence_name :'|| l_db_sequence_name);
94: arp_util.debug('l_doc_sequence_type :' || l_doc_sequence_type);
95: arp_util.debug('l_doc_sequence_id :'||to_char(nvl(p_doc_sequence_id,-99)));
96: END IF;
97:
98: IF l_doc_seq_ret_stat = -8 THEN
99: --this is the case of Always Used

Line 101: arp_util.debug('The doc sequence does not exist for the current document');

97:
98: IF l_doc_seq_ret_stat = -8 THEN
99: --this is the case of Always Used
100: IF PG_DEBUG in ('Y', 'C') THEN
101: arp_util.debug('The doc sequence does not exist for the current document');
102: END IF;
103: p_return_status := FND_API.G_RET_STS_ERROR;
104: --Error message
105: FND_MESSAGE.Set_Name( 'AR','AR_RAPI_DOC_SEQ_NOT_EXIST_A');

Line 110: arp_util.debug('The doc sequence does not exist for the current document');

106: FND_MSG_PUB.Add;
107: ELSIF l_doc_seq_ret_stat = -2 THEN
108: --this is the case of Partially Used
109: IF PG_DEBUG in ('Y', 'C') THEN
110: arp_util.debug('The doc sequence does not exist for the current document');
111: END IF;
112: --Warning
113: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS) THEN
114: FND_MESSAGE.SET_NAME('AR','AR_RAPI_DOC_SEQ_NOT_EXIST_P');

Line 126: arp_util.debug('Automatic Document Numbering case ');

122: /*------------------------------------+
123: | Automatic Document Numbering case |
124: +------------------------------------*/
125: IF PG_DEBUG in ('Y', 'C') THEN
126: arp_util.debug('Automatic Document Numbering case ');
127: END IF;
128:
129: l_doc_seq_ret_stat :=
130: fnd_seqnum.get_seq_val (

Line 147: arp_util.debug('l_doc_sequence_value :'||to_char(nvl(p_doc_sequence_value,-99)));

143: FND_MESSAGE.Set_Name('AR', 'AR_RAPI_DOC_SEQ_AUTOMATIC');
144: FND_MSG_PUB.Add;
145: END IF;
146: p_doc_sequence_value := l_doc_sequence_value;
147: arp_util.debug('l_doc_sequence_value :'||to_char(nvl(p_doc_sequence_value,-99)));
148: IF PG_DEBUG in ('Y', 'C') THEN
149: arp_util.debug('p_doc_sequence_id : '|| to_char(p_doc_sequence_id));
150: END IF;
151:

Line 149: arp_util.debug('p_doc_sequence_id : '|| to_char(p_doc_sequence_id));

145: END IF;
146: p_doc_sequence_value := l_doc_sequence_value;
147: arp_util.debug('l_doc_sequence_value :'||to_char(nvl(p_doc_sequence_value,-99)));
148: IF PG_DEBUG in ('Y', 'C') THEN
149: arp_util.debug('p_doc_sequence_id : '|| to_char(p_doc_sequence_id));
150: END IF;
151:
152: ELSIF ( p_doc_sequence_id IS NOT NULL
153: AND p_doc_sequence_value IS NOT NULL) THEN

Line 198: arp_util.debug('EXCEPTION: no_data_found raised');

194: | is mandatory. |
195: +------------------------------------------*/
196:
197: IF PG_DEBUG in ('Y', 'C') THEN
198: arp_util.debug('EXCEPTION: no_data_found raised');
199: END IF;
200: IF (unique_seq_numbers = 'A' ) THEN
201: p_return_status := FND_API.G_RET_STS_ERROR;
202: FND_MESSAGE.Set_Name( 'FND','UNIQUE-ALWAYS USED');

Line 211: arp_util.debug('EXCEPTION: Unhandled exception in doc sequence assignment');

207: END IF;
208:
209: WHEN OTHERS THEN
210: IF PG_DEBUG in ('Y', 'C') THEN
211: arp_util.debug('EXCEPTION: Unhandled exception in doc sequence assignment');
212: END IF;
213: raise;
214:
215: END;

Line 219: arp_util.debug('get_doc_seq()+');

215: END;
216:
217: END IF;
218: IF PG_DEBUG in ('Y', 'C') THEN
219: arp_util.debug('get_doc_seq()+');
220: END IF;
221: END get_doc_seq;
222:
223:

Line 456: arp_util.debug('create_header_cm()+');

452: l_msg_count NUMBER;
453:
454: BEGIN
455: IF PG_DEBUG in ('Y', 'C') THEN
456: arp_util.debug('create_header_cm()+');
457: END IF;
458:
459: /*------------------------------------+
460: | Standard start of API savepoint |

Line 585: arp_util.debug('EXCEPTION Calling arp_process_credit_util.get_credited_trx_details.');

581: EXCEPTION
582: WHEN OTHERS THEN
583: ROLLBACK TO Credit_Transaction_Pub;
584: IF PG_DEBUG in ('Y', 'C') THEN
585: arp_util.debug('EXCEPTION Calling arp_process_credit_util.get_credited_trx_details.');
586: END IF;
587: /*Bug3041195: Commented out this portion as it would overwrite errors
588: raised by get_credited_trx_details*/
589: -- fnd_message.set_name( 'AR', 'AR_RAXTRX-1666');

Line 595: arp_util.debug('l_line_orig = ' || to_char(l_line_orig));

591: RAISE e_unexpected_error;
592: END;
593:
594: IF PG_DEBUG in ('Y', 'C') THEN
595: arp_util.debug('l_line_orig = ' || to_char(l_line_orig));
596: END IF;
597:
598:
599: -- VCRISOST 01/29/03 : bug 2775884, null amount and null percent means zero dispute

Line 677: arp_util.debug('l_line_orig = ' || to_char(l_line_orig));

673: l_computed_tax_percent := 0;
674: END IF;
675:
676: IF PG_DEBUG in ('Y', 'C') THEN
677: arp_util.debug('l_line_orig = ' || to_char(l_line_orig));
678: arp_util.debug('l_line_amount = ' || to_char(l_line_amount));
679: arp_util.debug('l_line_percent = ' || to_char(l_line_percent));
680: arp_util.debug('l_freight_amount = ' || to_char(l_freight_amount));
681: arp_util.debug('l_freight_percent = ' || to_char(l_freight_percent));

Line 678: arp_util.debug('l_line_amount = ' || to_char(l_line_amount));

674: END IF;
675:
676: IF PG_DEBUG in ('Y', 'C') THEN
677: arp_util.debug('l_line_orig = ' || to_char(l_line_orig));
678: arp_util.debug('l_line_amount = ' || to_char(l_line_amount));
679: arp_util.debug('l_line_percent = ' || to_char(l_line_percent));
680: arp_util.debug('l_freight_amount = ' || to_char(l_freight_amount));
681: arp_util.debug('l_freight_percent = ' || to_char(l_freight_percent));
682: arp_util.debug('l_computed_tax_amount = ' ||to_char(l_computed_tax_amount));

Line 679: arp_util.debug('l_line_percent = ' || to_char(l_line_percent));

675:
676: IF PG_DEBUG in ('Y', 'C') THEN
677: arp_util.debug('l_line_orig = ' || to_char(l_line_orig));
678: arp_util.debug('l_line_amount = ' || to_char(l_line_amount));
679: arp_util.debug('l_line_percent = ' || to_char(l_line_percent));
680: arp_util.debug('l_freight_amount = ' || to_char(l_freight_amount));
681: arp_util.debug('l_freight_percent = ' || to_char(l_freight_percent));
682: arp_util.debug('l_computed_tax_amount = ' ||to_char(l_computed_tax_amount));
683: arp_util.debug('l_computed_tax_percent = '||to_char(l_computed_tax_percent));

Line 680: arp_util.debug('l_freight_amount = ' || to_char(l_freight_amount));

676: IF PG_DEBUG in ('Y', 'C') THEN
677: arp_util.debug('l_line_orig = ' || to_char(l_line_orig));
678: arp_util.debug('l_line_amount = ' || to_char(l_line_amount));
679: arp_util.debug('l_line_percent = ' || to_char(l_line_percent));
680: arp_util.debug('l_freight_amount = ' || to_char(l_freight_amount));
681: arp_util.debug('l_freight_percent = ' || to_char(l_freight_percent));
682: arp_util.debug('l_computed_tax_amount = ' ||to_char(l_computed_tax_amount));
683: arp_util.debug('l_computed_tax_percent = '||to_char(l_computed_tax_percent));
684: END IF;

Line 681: arp_util.debug('l_freight_percent = ' || to_char(l_freight_percent));

677: arp_util.debug('l_line_orig = ' || to_char(l_line_orig));
678: arp_util.debug('l_line_amount = ' || to_char(l_line_amount));
679: arp_util.debug('l_line_percent = ' || to_char(l_line_percent));
680: arp_util.debug('l_freight_amount = ' || to_char(l_freight_amount));
681: arp_util.debug('l_freight_percent = ' || to_char(l_freight_percent));
682: arp_util.debug('l_computed_tax_amount = ' ||to_char(l_computed_tax_amount));
683: arp_util.debug('l_computed_tax_percent = '||to_char(l_computed_tax_percent));
684: END IF;
685:

Line 682: arp_util.debug('l_computed_tax_amount = ' ||to_char(l_computed_tax_amount));

678: arp_util.debug('l_line_amount = ' || to_char(l_line_amount));
679: arp_util.debug('l_line_percent = ' || to_char(l_line_percent));
680: arp_util.debug('l_freight_amount = ' || to_char(l_freight_amount));
681: arp_util.debug('l_freight_percent = ' || to_char(l_freight_percent));
682: arp_util.debug('l_computed_tax_amount = ' ||to_char(l_computed_tax_amount));
683: arp_util.debug('l_computed_tax_percent = '||to_char(l_computed_tax_percent));
684: END IF;
685:
686: --

Line 683: arp_util.debug('l_computed_tax_percent = '||to_char(l_computed_tax_percent));

679: arp_util.debug('l_line_percent = ' || to_char(l_line_percent));
680: arp_util.debug('l_freight_amount = ' || to_char(l_freight_amount));
681: arp_util.debug('l_freight_percent = ' || to_char(l_freight_percent));
682: arp_util.debug('l_computed_tax_amount = ' ||to_char(l_computed_tax_amount));
683: arp_util.debug('l_computed_tax_percent = '||to_char(l_computed_tax_percent));
684: END IF;
685:
686: --
687: -- Default complete flag :

Line 714: arp_util.debug('EXCEPTION: select from ra_customer_trx_cr_trx_v returns no data');

710: --- not exist in the system.
711: --- Proposed error message : AR_RAXTRX-1666 Your credit memo
712: --- transaction can only credit an invoice or a debit memo line
713: IF PG_DEBUG in ('Y', 'C') THEN
714: arp_util.debug('EXCEPTION: select from ra_customer_trx_cr_trx_v returns no data');
715: END IF;
716:
717: fnd_message.set_name( 'AR', 'AR_RAXTRX-1666');
718: l_message_name := 'AR_RAXTRX-1666' ;

Line 723: arp_util.debug('EXCEPTION: Debug point 1 : Unknown Error fetching credited trx details ');

719: RAISE e_handled_error;
720:
721: WHEN OTHERS THEN
722: IF PG_DEBUG in ('Y', 'C') THEN
723: arp_util.debug('EXCEPTION: Debug point 1 : Unknown Error fetching credited trx details ');
724: END IF;
725: l_debug_point := 1;
726: l_ue_message := SUBSTR('Error fetching credited trx details ' || SQLERRM, 1, 2000);
727: RAISE e_unexpected_error;

Line 790: arp_util.debug(' Org from arp_global is ' || arp_global.sysparam.org_id

786: -- 5885313 commented out init routine here.
787: -- arp_global.init_global;
788:
789: IF PG_DEBUG in ('Y', 'C') THEN
790: arp_util.debug(' Org from arp_global is ' || arp_global.sysparam.org_id
791: || ' , SOB from arp_global is '|| arp_global.sysparam.set_of_books_id
792: || ' , SOB from trx_global is '|| arp_trx_global.system_info.system_parameters.set_of_books_id
793: );
794: END IF;

Line 885: arp_util.debug('l_cm_header.batch_source_id = '

881:
882:
883:
884: IF PG_DEBUG in ('Y', 'C') THEN
885: arp_util.debug('l_cm_header.batch_source_id = '
886: || to_char(l_cm_header.batch_source_id));
887: arp_util.debug('l_cm_header.cust_trx_type_id = '
888: || to_char(l_cm_header.cust_trx_type_id));
889: arp_util.debug('l_cm_header.primary_salesrep_id = '

Line 887: arp_util.debug('l_cm_header.cust_trx_type_id = '

883:
884: IF PG_DEBUG in ('Y', 'C') THEN
885: arp_util.debug('l_cm_header.batch_source_id = '
886: || to_char(l_cm_header.batch_source_id));
887: arp_util.debug('l_cm_header.cust_trx_type_id = '
888: || to_char(l_cm_header.cust_trx_type_id));
889: arp_util.debug('l_cm_header.primary_salesrep_id = '
890: || to_char(l_cm_header.primary_salesrep_id));
891: arp_util.debug('l_cm_header.bill_to_customer_id = '

Line 889: arp_util.debug('l_cm_header.primary_salesrep_id = '

885: arp_util.debug('l_cm_header.batch_source_id = '
886: || to_char(l_cm_header.batch_source_id));
887: arp_util.debug('l_cm_header.cust_trx_type_id = '
888: || to_char(l_cm_header.cust_trx_type_id));
889: arp_util.debug('l_cm_header.primary_salesrep_id = '
890: || to_char(l_cm_header.primary_salesrep_id));
891: arp_util.debug('l_cm_header.bill_to_customer_id = '
892: || to_char(l_cm_header.bill_to_customer_id));
893: arp_util.debug('l_cm_header.bill_to_site_use_id = '

Line 891: arp_util.debug('l_cm_header.bill_to_customer_id = '

887: arp_util.debug('l_cm_header.cust_trx_type_id = '
888: || to_char(l_cm_header.cust_trx_type_id));
889: arp_util.debug('l_cm_header.primary_salesrep_id = '
890: || to_char(l_cm_header.primary_salesrep_id));
891: arp_util.debug('l_cm_header.bill_to_customer_id = '
892: || to_char(l_cm_header.bill_to_customer_id));
893: arp_util.debug('l_cm_header.bill_to_site_use_id = '
894: || to_char(l_cm_header.bill_to_site_use_id));
895: arp_util.debug('l_cm_header.bill_to_contact_id = '

Line 893: arp_util.debug('l_cm_header.bill_to_site_use_id = '

889: arp_util.debug('l_cm_header.primary_salesrep_id = '
890: || to_char(l_cm_header.primary_salesrep_id));
891: arp_util.debug('l_cm_header.bill_to_customer_id = '
892: || to_char(l_cm_header.bill_to_customer_id));
893: arp_util.debug('l_cm_header.bill_to_site_use_id = '
894: || to_char(l_cm_header.bill_to_site_use_id));
895: arp_util.debug('l_cm_header.bill_to_contact_id = '
896: || to_char(l_cm_header.bill_to_contact_id));
897: arp_util.debug('l_cm_header.ship_to_customer_id = '

Line 895: arp_util.debug('l_cm_header.bill_to_contact_id = '

891: arp_util.debug('l_cm_header.bill_to_customer_id = '
892: || to_char(l_cm_header.bill_to_customer_id));
893: arp_util.debug('l_cm_header.bill_to_site_use_id = '
894: || to_char(l_cm_header.bill_to_site_use_id));
895: arp_util.debug('l_cm_header.bill_to_contact_id = '
896: || to_char(l_cm_header.bill_to_contact_id));
897: arp_util.debug('l_cm_header.ship_to_customer_id = '
898: || to_char(l_cm_header.ship_to_customer_id));
899: arp_util.debug('l_cm_header.ship_to_site_use_id = '

Line 897: arp_util.debug('l_cm_header.ship_to_customer_id = '

893: arp_util.debug('l_cm_header.bill_to_site_use_id = '
894: || to_char(l_cm_header.bill_to_site_use_id));
895: arp_util.debug('l_cm_header.bill_to_contact_id = '
896: || to_char(l_cm_header.bill_to_contact_id));
897: arp_util.debug('l_cm_header.ship_to_customer_id = '
898: || to_char(l_cm_header.ship_to_customer_id));
899: arp_util.debug('l_cm_header.ship_to_site_use_id = '
900: || to_char(l_cm_header.ship_to_site_use_id));
901: arp_util.debug('l_cm_header.ship_to_contact_id = '

Line 899: arp_util.debug('l_cm_header.ship_to_site_use_id = '

895: arp_util.debug('l_cm_header.bill_to_contact_id = '
896: || to_char(l_cm_header.bill_to_contact_id));
897: arp_util.debug('l_cm_header.ship_to_customer_id = '
898: || to_char(l_cm_header.ship_to_customer_id));
899: arp_util.debug('l_cm_header.ship_to_site_use_id = '
900: || to_char(l_cm_header.ship_to_site_use_id));
901: arp_util.debug('l_cm_header.ship_to_contact_id = '
902: || to_char(l_cm_header.ship_to_contact_id));
903: arp_util.debug('l_cm_header.receipt_method_id = '

Line 901: arp_util.debug('l_cm_header.ship_to_contact_id = '

897: arp_util.debug('l_cm_header.ship_to_customer_id = '
898: || to_char(l_cm_header.ship_to_customer_id));
899: arp_util.debug('l_cm_header.ship_to_site_use_id = '
900: || to_char(l_cm_header.ship_to_site_use_id));
901: arp_util.debug('l_cm_header.ship_to_contact_id = '
902: || to_char(l_cm_header.ship_to_contact_id));
903: arp_util.debug('l_cm_header.receipt_method_id = '
904: || to_char(l_cm_header.receipt_method_id));
905: arp_util.debug('l_cm_header.paying_customer_id = '

Line 903: arp_util.debug('l_cm_header.receipt_method_id = '

899: arp_util.debug('l_cm_header.ship_to_site_use_id = '
900: || to_char(l_cm_header.ship_to_site_use_id));
901: arp_util.debug('l_cm_header.ship_to_contact_id = '
902: || to_char(l_cm_header.ship_to_contact_id));
903: arp_util.debug('l_cm_header.receipt_method_id = '
904: || to_char(l_cm_header.receipt_method_id));
905: arp_util.debug('l_cm_header.paying_customer_id = '
906: || to_char(l_cm_header.paying_customer_id));
907: arp_util.debug('l_cm_header.customer_bank_account_id = '

Line 905: arp_util.debug('l_cm_header.paying_customer_id = '

901: arp_util.debug('l_cm_header.ship_to_contact_id = '
902: || to_char(l_cm_header.ship_to_contact_id));
903: arp_util.debug('l_cm_header.receipt_method_id = '
904: || to_char(l_cm_header.receipt_method_id));
905: arp_util.debug('l_cm_header.paying_customer_id = '
906: || to_char(l_cm_header.paying_customer_id));
907: arp_util.debug('l_cm_header.customer_bank_account_id = '
908: || to_char(l_cm_header.customer_bank_account_id));
909: arp_util.debug('l_cm_header.printing_option = '

Line 907: arp_util.debug('l_cm_header.customer_bank_account_id = '

903: arp_util.debug('l_cm_header.receipt_method_id = '
904: || to_char(l_cm_header.receipt_method_id));
905: arp_util.debug('l_cm_header.paying_customer_id = '
906: || to_char(l_cm_header.paying_customer_id));
907: arp_util.debug('l_cm_header.customer_bank_account_id = '
908: || to_char(l_cm_header.customer_bank_account_id));
909: arp_util.debug('l_cm_header.printing_option = '
910: || l_cm_header.printing_option);
911: arp_util.debug('l_cm_header.set_of_books_id = '

Line 909: arp_util.debug('l_cm_header.printing_option = '

905: arp_util.debug('l_cm_header.paying_customer_id = '
906: || to_char(l_cm_header.paying_customer_id));
907: arp_util.debug('l_cm_header.customer_bank_account_id = '
908: || to_char(l_cm_header.customer_bank_account_id));
909: arp_util.debug('l_cm_header.printing_option = '
910: || l_cm_header.printing_option);
911: arp_util.debug('l_cm_header.set_of_books_id = '
912: || to_char(l_cm_header.set_of_books_id));
913: arp_util.debug('l_cm_header.legal_entity_id = '

Line 911: arp_util.debug('l_cm_header.set_of_books_id = '

907: arp_util.debug('l_cm_header.customer_bank_account_id = '
908: || to_char(l_cm_header.customer_bank_account_id));
909: arp_util.debug('l_cm_header.printing_option = '
910: || l_cm_header.printing_option);
911: arp_util.debug('l_cm_header.set_of_books_id = '
912: || to_char(l_cm_header.set_of_books_id));
913: arp_util.debug('l_cm_header.legal_entity_id = '
914: || to_char(l_cm_header.legal_entity_id));
915: END IF;

Line 913: arp_util.debug('l_cm_header.legal_entity_id = '

909: arp_util.debug('l_cm_header.printing_option = '
910: || l_cm_header.printing_option);
911: arp_util.debug('l_cm_header.set_of_books_id = '
912: || to_char(l_cm_header.set_of_books_id));
913: arp_util.debug('l_cm_header.legal_entity_id = '
914: || to_char(l_cm_header.legal_entity_id));
915: END IF;
916:
917:

Line 928: arp_util.debug('Error: l_cm_header.cust_trx_type_id IS NULL');

924: ELSE
925: IF l_cm_header.cust_trx_type_id IS NULL THEN
926: ROLLBACK TO Credit_Transaction_Pub;
927: IF PG_DEBUG in ('Y', 'C') THEN
928: arp_util.debug('Error: l_cm_header.cust_trx_type_id IS NULL');
929: END IF;
930: fnd_message.set_name( 'AR', 'AR_TW_BAD_DATE_TRX_TYPE');
931: l_message_name := 'AR_TW_BAD_DATE_TRX_TYPE' ;
932: RAISE e_handled_error;

Line 1179: arp_util.debug('l_compute_tax = ' || l_compute_tax);

1175:
1176: l_compute_tax := p_compute_tax;
1177:
1178: IF PG_DEBUG in ('Y', 'C') THEN
1179: arp_util.debug('l_compute_tax = ' || l_compute_tax);
1180: END IF;
1181:
1182: --
1183: -- call the entity handler

Line 1214: arp_util.debug('EXCEPTION: Debug point 2 : Error Calling arp_process_credit.insert_header.');

1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: ROLLBACK TO Credit_Transaction_Pub;
1213: IF PG_DEBUG in ('Y', 'C') THEN
1214: arp_util.debug('EXCEPTION: Debug point 2 : Error Calling arp_process_credit.insert_header.');
1215: END IF;
1216: l_debug_point := 2;
1217: l_ue_message := SUBSTR('EXCEPTION: Error Calling arp_process_credit.insert_header '
1218: || SQLERRM, 1, 2000);

Line 1262: arp_util.debug('EXCEPTION: Debug point 3 : Error Calling arp_process_header.post_commit.');

1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: ROLLBACK TO Credit_Transaction_Pub;
1261: IF PG_DEBUG in ('Y', 'C') THEN
1262: arp_util.debug('EXCEPTION: Debug point 3 : Error Calling arp_process_header.post_commit.');
1263: END IF;
1264: l_debug_point := 3;
1265: l_ue_message := SUBSTR('Error Calling arp_process_header.post_commit '
1266: || SQLERRM, 1, 2000);

Line 1298: arp_util.debug('create_header_cm: ' || 'l_copy_doc_number_flag = ' || l_copy_doc_number_flag);

1294: END IF;
1295:
1296:
1297: IF PG_DEBUG in ('Y', 'C') THEN
1298: arp_util.debug('create_header_cm: ' || 'l_copy_doc_number_flag = ' || l_copy_doc_number_flag);
1299: arp_util.debug('create_header_cm: ' || 'doc_sequence_value = ' || to_char(l_cm_header.doc_sequence_value));
1300: arp_util.debug('create_header_cm: ' || 'doc_sequence_id = ' || to_char(l_cm_header.doc_sequence_id));
1301: END IF;
1302:

Line 1299: arp_util.debug('create_header_cm: ' || 'doc_sequence_value = ' || to_char(l_cm_header.doc_sequence_value));

1295:
1296:
1297: IF PG_DEBUG in ('Y', 'C') THEN
1298: arp_util.debug('create_header_cm: ' || 'l_copy_doc_number_flag = ' || l_copy_doc_number_flag);
1299: arp_util.debug('create_header_cm: ' || 'doc_sequence_value = ' || to_char(l_cm_header.doc_sequence_value));
1300: arp_util.debug('create_header_cm: ' || 'doc_sequence_id = ' || to_char(l_cm_header.doc_sequence_id));
1301: END IF;
1302:
1303: -- check copy_doc_number_flag

Line 1300: arp_util.debug('create_header_cm: ' || 'doc_sequence_id = ' || to_char(l_cm_header.doc_sequence_id));

1296:
1297: IF PG_DEBUG in ('Y', 'C') THEN
1298: arp_util.debug('create_header_cm: ' || 'l_copy_doc_number_flag = ' || l_copy_doc_number_flag);
1299: arp_util.debug('create_header_cm: ' || 'doc_sequence_value = ' || to_char(l_cm_header.doc_sequence_value));
1300: arp_util.debug('create_header_cm: ' || 'doc_sequence_id = ' || to_char(l_cm_header.doc_sequence_id));
1301: END IF;
1302:
1303: -- check copy_doc_number_flag
1304: IF l_cm_header.doc_sequence_value is not null THEN

Line 1331: arp_util.debug('create_header_cm: ' || 'Debug point 4 : Error Processing Doc Seq No.');

1327: EXCEPTION
1328: WHEN OTHERS THEN
1329: ROLLBACK TO Credit_Transaction_Pub;
1330: IF PG_DEBUG in ('Y', 'C') THEN
1331: arp_util.debug('create_header_cm: ' || 'Debug point 4 : Error Processing Doc Seq No.');
1332: END IF;
1333: l_debug_point := 4;
1334: l_ue_message := SUBSTR(' Error Processing Doc Seq No ' || SQLERRM, 1, 2000);
1335: RAISE e_unexpected_error;

Line 1341: arp_util.debug('create_header_cm: ' || 'p_customer_trx_id = ' || to_char(p_customer_trx_id));

1337:
1338: p_customer_trx_id := l_customer_trx_id;
1339:
1340: IF PG_DEBUG in ('Y', 'C') THEN
1341: arp_util.debug('create_header_cm: ' || 'p_customer_trx_id = ' || to_char(p_customer_trx_id));
1342: arp_util.debug('create_header_cm: ' || 'p_trx_number = ' || p_trx_number);
1343: arp_util.debug('create_header_cm: ' || 'l_compute_tax = ' || l_compute_tax);
1344: arp_util.debug('create_header_cm: ' || 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
1345: arp_util.debug('create_header_cm: ' || 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));

Line 1342: arp_util.debug('create_header_cm: ' || 'p_trx_number = ' || p_trx_number);

1338: p_customer_trx_id := l_customer_trx_id;
1339:
1340: IF PG_DEBUG in ('Y', 'C') THEN
1341: arp_util.debug('create_header_cm: ' || 'p_customer_trx_id = ' || to_char(p_customer_trx_id));
1342: arp_util.debug('create_header_cm: ' || 'p_trx_number = ' || p_trx_number);
1343: arp_util.debug('create_header_cm: ' || 'l_compute_tax = ' || l_compute_tax);
1344: arp_util.debug('create_header_cm: ' || 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
1345: arp_util.debug('create_header_cm: ' || 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
1346: arp_util.debug('create_header_cm: ' || 'p_status = ' || p_status);

Line 1343: arp_util.debug('create_header_cm: ' || 'l_compute_tax = ' || l_compute_tax);

1339:
1340: IF PG_DEBUG in ('Y', 'C') THEN
1341: arp_util.debug('create_header_cm: ' || 'p_customer_trx_id = ' || to_char(p_customer_trx_id));
1342: arp_util.debug('create_header_cm: ' || 'p_trx_number = ' || p_trx_number);
1343: arp_util.debug('create_header_cm: ' || 'l_compute_tax = ' || l_compute_tax);
1344: arp_util.debug('create_header_cm: ' || 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
1345: arp_util.debug('create_header_cm: ' || 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
1346: arp_util.debug('create_header_cm: ' || 'p_status = ' || p_status);
1347: arp_util.debug('create_header_cm()-');

Line 1344: arp_util.debug('create_header_cm: ' || 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));

1340: IF PG_DEBUG in ('Y', 'C') THEN
1341: arp_util.debug('create_header_cm: ' || 'p_customer_trx_id = ' || to_char(p_customer_trx_id));
1342: arp_util.debug('create_header_cm: ' || 'p_trx_number = ' || p_trx_number);
1343: arp_util.debug('create_header_cm: ' || 'l_compute_tax = ' || l_compute_tax);
1344: arp_util.debug('create_header_cm: ' || 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
1345: arp_util.debug('create_header_cm: ' || 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
1346: arp_util.debug('create_header_cm: ' || 'p_status = ' || p_status);
1347: arp_util.debug('create_header_cm()-');
1348: END IF;

Line 1345: arp_util.debug('create_header_cm: ' || 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));

1341: arp_util.debug('create_header_cm: ' || 'p_customer_trx_id = ' || to_char(p_customer_trx_id));
1342: arp_util.debug('create_header_cm: ' || 'p_trx_number = ' || p_trx_number);
1343: arp_util.debug('create_header_cm: ' || 'l_compute_tax = ' || l_compute_tax);
1344: arp_util.debug('create_header_cm: ' || 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
1345: arp_util.debug('create_header_cm: ' || 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
1346: arp_util.debug('create_header_cm: ' || 'p_status = ' || p_status);
1347: arp_util.debug('create_header_cm()-');
1348: END IF;
1349:

Line 1346: arp_util.debug('create_header_cm: ' || 'p_status = ' || p_status);

1342: arp_util.debug('create_header_cm: ' || 'p_trx_number = ' || p_trx_number);
1343: arp_util.debug('create_header_cm: ' || 'l_compute_tax = ' || l_compute_tax);
1344: arp_util.debug('create_header_cm: ' || 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
1345: arp_util.debug('create_header_cm: ' || 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
1346: arp_util.debug('create_header_cm: ' || 'p_status = ' || p_status);
1347: arp_util.debug('create_header_cm()-');
1348: END IF;
1349:
1350: EXCEPTION

Line 1347: arp_util.debug('create_header_cm()-');

1343: arp_util.debug('create_header_cm: ' || 'l_compute_tax = ' || l_compute_tax);
1344: arp_util.debug('create_header_cm: ' || 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
1345: arp_util.debug('create_header_cm: ' || 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
1346: arp_util.debug('create_header_cm: ' || 'p_status = ' || p_status);
1347: arp_util.debug('create_header_cm()-');
1348: END IF;
1349:
1350: EXCEPTION
1351: -- bug 2290738 : populate error table with message and pass value to p_status

Line 1355: arp_util.debug('EXCEPTION WHEN e_handled_error : create_header_cm');

1351: -- bug 2290738 : populate error table with message and pass value to p_status
1352:
1353: WHEN e_handled_error THEN
1354: IF PG_DEBUG in ('Y', 'C') THEN
1355: arp_util.debug('EXCEPTION WHEN e_handled_error : create_header_cm');
1356: END IF;
1357: p_status := 'e_handled_error';
1358:
1359: ROLLBACK TO Credit_Transaction_Pub;

Line 1368: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '

1364: fnd_message.set_name( 'AR', l_message_name);
1365: FND_MSG_PUB.Add;
1366:
1367: IF PG_DEBUG in ('Y', 'C') THEN
1368: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '
1369: || p_errors(1).message_name);
1370: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '
1371: || p_errors(1).encoded_message);
1372: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '

Line 1370: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '

1366:
1367: IF PG_DEBUG in ('Y', 'C') THEN
1368: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '
1369: || p_errors(1).message_name);
1370: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '
1371: || p_errors(1).encoded_message);
1372: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '
1373: || p_errors(1).translated_message);
1374: END IF;

Line 1372: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '

1368: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '
1369: || p_errors(1).message_name);
1370: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '
1371: || p_errors(1).encoded_message);
1372: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '
1373: || p_errors(1).translated_message);
1374: END IF;
1375:
1376: WHEN e_unexpected_error THEN

Line 1378: arp_util.debug('EXCEPTION WHEN e_unexpected_error : create_header_cm');

1374: END IF;
1375:
1376: WHEN e_unexpected_error THEN
1377: IF PG_DEBUG in ('Y', 'C') THEN
1378: arp_util.debug('EXCEPTION WHEN e_unexpected_error : create_header_cm');
1379: END IF;
1380: p_status := 'e_unexpected_error';
1381:
1382: ROLLBACK TO Credit_Transaction_Pub;

Line 1405: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '

1401: fnd_message.set_encoded(p_errors(1).encoded_message);
1402: FND_MSG_PUB.Add;
1403: END IF;
1404: IF PG_DEBUG in ('Y', 'C') THEN
1405: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '
1406: || p_errors(1).message_name);
1407: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '
1408: || p_errors(1).encoded_message);
1409: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '

Line 1407: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '

1403: END IF;
1404: IF PG_DEBUG in ('Y', 'C') THEN
1405: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '
1406: || p_errors(1).message_name);
1407: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '
1408: || p_errors(1).encoded_message);
1409: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '
1410: || p_errors(1).translated_message);
1411: END IF;

Line 1409: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '

1405: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '
1406: || p_errors(1).message_name);
1407: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '
1408: || p_errors(1).encoded_message);
1409: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '
1410: || p_errors(1).translated_message);
1411: END IF;
1412:
1413: WHEN OTHERS THEN

Line 1415: arp_util.debug('EXCEPTION WHEN OTHERS : create_header_cm');

1411: END IF;
1412:
1413: WHEN OTHERS THEN
1414: IF PG_DEBUG in ('Y', 'C') THEN
1415: arp_util.debug('EXCEPTION WHEN OTHERS : create_header_cm');
1416: END IF;
1417: p_status := 'others';
1418:
1419: ROLLBACK TO Credit_Transaction_Pub;

Line 1431: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '

1427: FND_MSG_PUB.Add;
1428:
1429: p_errors(1).translated_message := fnd_message.get;
1430: IF PG_DEBUG in ('Y', 'C') THEN
1431: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '
1432: || p_errors(1).message_name);
1433: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '
1434: || p_errors(1).encoded_message);
1435: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '

Line 1433: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '

1429: p_errors(1).translated_message := fnd_message.get;
1430: IF PG_DEBUG in ('Y', 'C') THEN
1431: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '
1432: || p_errors(1).message_name);
1433: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '
1434: || p_errors(1).encoded_message);
1435: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '
1436: || p_errors(1).translated_message);
1437: arp_util.debug('create_header_cm: ' || 'EXCEPTION WHEN OTHERS : credit_transaction');

Line 1435: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '

1431: arp_util.debug('create_header_cm: ' || 'p_errors(1).message_name = '
1432: || p_errors(1).message_name);
1433: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '
1434: || p_errors(1).encoded_message);
1435: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '
1436: || p_errors(1).translated_message);
1437: arp_util.debug('create_header_cm: ' || 'EXCEPTION WHEN OTHERS : credit_transaction');
1438: END IF;
1439: END create_header_cm;

Line 1437: arp_util.debug('create_header_cm: ' || 'EXCEPTION WHEN OTHERS : credit_transaction');

1433: arp_util.debug('create_header_cm: ' || 'p_errors(1).encoded_message = '
1434: || p_errors(1).encoded_message);
1435: arp_util.debug('create_header_cm: ' || 'p_errors(1).translated_message = '
1436: || p_errors(1).translated_message);
1437: arp_util.debug('create_header_cm: ' || 'EXCEPTION WHEN OTHERS : credit_transaction');
1438: END IF;
1439: END create_header_cm;
1440:
1441: /*======================================================+

Line 1725: arp_util.debug('create_line_cm()+');

1721:
1722: BEGIN
1723:
1724: IF PG_DEBUG in ('Y', 'C') THEN
1725: arp_util.debug('create_line_cm()+');
1726: END IF;
1727:
1728: /*------------------------------------+
1729: | Standard start of API savepoint |

Line 1854: arp_util.debug('EXCEPTION: Error Calling arp_process_credit_util.get_credited_trx_details.');

1850: EXCEPTION
1851: WHEN OTHERS THEN
1852: ROLLBACK TO Credit_Transaction_Pub;
1853: IF PG_DEBUG in ('Y', 'C') THEN
1854: arp_util.debug('EXCEPTION: Error Calling arp_process_credit_util.get_credited_trx_details.');
1855: END IF;
1856: /*Bug3041196: Commented out this portion as it was overwriting message
1857: names set by get_credited_trx_details*/
1858: -- fnd_message.set_name( 'AR', 'AR_RAXTRX-1666');

Line 1897: arp_util.debug('EXCEPTION: Debug point 1 : Unknown Error fetching credited trx details ');

1893: l_message_name := 'AR_RAXTRX-1666' ;
1894: RAISE e_handled_error;
1895: WHEN OTHERS THEN
1896: IF PG_DEBUG in ('Y', 'C') THEN
1897: arp_util.debug('EXCEPTION: Debug point 1 : Unknown Error fetching credited trx details ');
1898: END IF;
1899: l_debug_point := 1;
1900: l_ue_message := SUBSTR('Error fetching credited trx details ' || SQLERRM, 1, 2000);
1901: RAISE e_unexpected_error;

Line 2031: arp_util.debug( 'l_cm_header.batch_source_id = '

2027: --
2028: -- However, if values have been passed in, use those
2029: --
2030: IF PG_DEBUG in ('Y', 'C') THEN
2031: arp_util.debug( 'l_cm_header.batch_source_id = '
2032: || to_char(l_cm_header.batch_source_id));
2033: arp_util.debug( 'l_cm_header.cust_trx_type_id = '
2034: || to_char(l_cm_header.cust_trx_type_id));
2035: arp_util.debug( 'l_cm_header.primary_salesrep_id = '

Line 2033: arp_util.debug( 'l_cm_header.cust_trx_type_id = '

2029: --
2030: IF PG_DEBUG in ('Y', 'C') THEN
2031: arp_util.debug( 'l_cm_header.batch_source_id = '
2032: || to_char(l_cm_header.batch_source_id));
2033: arp_util.debug( 'l_cm_header.cust_trx_type_id = '
2034: || to_char(l_cm_header.cust_trx_type_id));
2035: arp_util.debug( 'l_cm_header.primary_salesrep_id = '
2036: || to_char(l_cm_header.primary_salesrep_id));
2037: arp_util.debug( 'l_cm_header.bill_to_customer_id = '

Line 2035: arp_util.debug( 'l_cm_header.primary_salesrep_id = '

2031: arp_util.debug( 'l_cm_header.batch_source_id = '
2032: || to_char(l_cm_header.batch_source_id));
2033: arp_util.debug( 'l_cm_header.cust_trx_type_id = '
2034: || to_char(l_cm_header.cust_trx_type_id));
2035: arp_util.debug( 'l_cm_header.primary_salesrep_id = '
2036: || to_char(l_cm_header.primary_salesrep_id));
2037: arp_util.debug( 'l_cm_header.bill_to_customer_id = '
2038: || to_char(l_cm_header.bill_to_customer_id));
2039: arp_util.debug( 'l_cm_header.bill_to_site_use_id = '

Line 2037: arp_util.debug( 'l_cm_header.bill_to_customer_id = '

2033: arp_util.debug( 'l_cm_header.cust_trx_type_id = '
2034: || to_char(l_cm_header.cust_trx_type_id));
2035: arp_util.debug( 'l_cm_header.primary_salesrep_id = '
2036: || to_char(l_cm_header.primary_salesrep_id));
2037: arp_util.debug( 'l_cm_header.bill_to_customer_id = '
2038: || to_char(l_cm_header.bill_to_customer_id));
2039: arp_util.debug( 'l_cm_header.bill_to_site_use_id = '
2040: || to_char(l_cm_header.bill_to_site_use_id));
2041: arp_util.debug( 'l_cm_header.bill_to_contact_id = '

Line 2039: arp_util.debug( 'l_cm_header.bill_to_site_use_id = '

2035: arp_util.debug( 'l_cm_header.primary_salesrep_id = '
2036: || to_char(l_cm_header.primary_salesrep_id));
2037: arp_util.debug( 'l_cm_header.bill_to_customer_id = '
2038: || to_char(l_cm_header.bill_to_customer_id));
2039: arp_util.debug( 'l_cm_header.bill_to_site_use_id = '
2040: || to_char(l_cm_header.bill_to_site_use_id));
2041: arp_util.debug( 'l_cm_header.bill_to_contact_id = '
2042: || to_char(l_cm_header.bill_to_contact_id));
2043: arp_util.debug( 'l_cm_header.ship_to_customer_id = '

Line 2041: arp_util.debug( 'l_cm_header.bill_to_contact_id = '

2037: arp_util.debug( 'l_cm_header.bill_to_customer_id = '
2038: || to_char(l_cm_header.bill_to_customer_id));
2039: arp_util.debug( 'l_cm_header.bill_to_site_use_id = '
2040: || to_char(l_cm_header.bill_to_site_use_id));
2041: arp_util.debug( 'l_cm_header.bill_to_contact_id = '
2042: || to_char(l_cm_header.bill_to_contact_id));
2043: arp_util.debug( 'l_cm_header.ship_to_customer_id = '
2044: || to_char(l_cm_header.ship_to_customer_id));
2045: arp_util.debug( 'l_cm_header.ship_to_site_use_id = '

Line 2043: arp_util.debug( 'l_cm_header.ship_to_customer_id = '

2039: arp_util.debug( 'l_cm_header.bill_to_site_use_id = '
2040: || to_char(l_cm_header.bill_to_site_use_id));
2041: arp_util.debug( 'l_cm_header.bill_to_contact_id = '
2042: || to_char(l_cm_header.bill_to_contact_id));
2043: arp_util.debug( 'l_cm_header.ship_to_customer_id = '
2044: || to_char(l_cm_header.ship_to_customer_id));
2045: arp_util.debug( 'l_cm_header.ship_to_site_use_id = '
2046: || to_char(l_cm_header.ship_to_site_use_id));
2047: arp_util.debug( 'l_cm_header.ship_to_contact_id = '

Line 2045: arp_util.debug( 'l_cm_header.ship_to_site_use_id = '

2041: arp_util.debug( 'l_cm_header.bill_to_contact_id = '
2042: || to_char(l_cm_header.bill_to_contact_id));
2043: arp_util.debug( 'l_cm_header.ship_to_customer_id = '
2044: || to_char(l_cm_header.ship_to_customer_id));
2045: arp_util.debug( 'l_cm_header.ship_to_site_use_id = '
2046: || to_char(l_cm_header.ship_to_site_use_id));
2047: arp_util.debug( 'l_cm_header.ship_to_contact_id = '
2048: || to_char(l_cm_header.ship_to_contact_id));
2049: arp_util.debug( 'l_cm_header.receipt_method_id = '

Line 2047: arp_util.debug( 'l_cm_header.ship_to_contact_id = '

2043: arp_util.debug( 'l_cm_header.ship_to_customer_id = '
2044: || to_char(l_cm_header.ship_to_customer_id));
2045: arp_util.debug( 'l_cm_header.ship_to_site_use_id = '
2046: || to_char(l_cm_header.ship_to_site_use_id));
2047: arp_util.debug( 'l_cm_header.ship_to_contact_id = '
2048: || to_char(l_cm_header.ship_to_contact_id));
2049: arp_util.debug( 'l_cm_header.receipt_method_id = '
2050: || to_char(l_cm_header.receipt_method_id));
2051: arp_util.debug( 'l_cm_header.paying_customer_id = '

Line 2049: arp_util.debug( 'l_cm_header.receipt_method_id = '

2045: arp_util.debug( 'l_cm_header.ship_to_site_use_id = '
2046: || to_char(l_cm_header.ship_to_site_use_id));
2047: arp_util.debug( 'l_cm_header.ship_to_contact_id = '
2048: || to_char(l_cm_header.ship_to_contact_id));
2049: arp_util.debug( 'l_cm_header.receipt_method_id = '
2050: || to_char(l_cm_header.receipt_method_id));
2051: arp_util.debug( 'l_cm_header.paying_customer_id = '
2052: || to_char(l_cm_header.paying_customer_id));
2053: arp_util.debug( 'l_cm_header.customer_bank_account_id = '

Line 2051: arp_util.debug( 'l_cm_header.paying_customer_id = '

2047: arp_util.debug( 'l_cm_header.ship_to_contact_id = '
2048: || to_char(l_cm_header.ship_to_contact_id));
2049: arp_util.debug( 'l_cm_header.receipt_method_id = '
2050: || to_char(l_cm_header.receipt_method_id));
2051: arp_util.debug( 'l_cm_header.paying_customer_id = '
2052: || to_char(l_cm_header.paying_customer_id));
2053: arp_util.debug( 'l_cm_header.customer_bank_account_id = '
2054: || to_char(l_cm_header.customer_bank_account_id));
2055: arp_util.debug( 'l_cm_header.printing_option = '

Line 2053: arp_util.debug( 'l_cm_header.customer_bank_account_id = '

2049: arp_util.debug( 'l_cm_header.receipt_method_id = '
2050: || to_char(l_cm_header.receipt_method_id));
2051: arp_util.debug( 'l_cm_header.paying_customer_id = '
2052: || to_char(l_cm_header.paying_customer_id));
2053: arp_util.debug( 'l_cm_header.customer_bank_account_id = '
2054: || to_char(l_cm_header.customer_bank_account_id));
2055: arp_util.debug( 'l_cm_header.printing_option = '
2056: || l_cm_header.printing_option);
2057: arp_util.debug( 'l_cm_header.set_of_books_id = '

Line 2055: arp_util.debug( 'l_cm_header.printing_option = '

2051: arp_util.debug( 'l_cm_header.paying_customer_id = '
2052: || to_char(l_cm_header.paying_customer_id));
2053: arp_util.debug( 'l_cm_header.customer_bank_account_id = '
2054: || to_char(l_cm_header.customer_bank_account_id));
2055: arp_util.debug( 'l_cm_header.printing_option = '
2056: || l_cm_header.printing_option);
2057: arp_util.debug( 'l_cm_header.set_of_books_id = '
2058: || to_char(l_cm_header.set_of_books_id));
2059: arp_util.debug( 'l_cm_header.legal_entity_id = '

Line 2057: arp_util.debug( 'l_cm_header.set_of_books_id = '

2053: arp_util.debug( 'l_cm_header.customer_bank_account_id = '
2054: || to_char(l_cm_header.customer_bank_account_id));
2055: arp_util.debug( 'l_cm_header.printing_option = '
2056: || l_cm_header.printing_option);
2057: arp_util.debug( 'l_cm_header.set_of_books_id = '
2058: || to_char(l_cm_header.set_of_books_id));
2059: arp_util.debug( 'l_cm_header.legal_entity_id = '
2060: || to_char(l_cm_header.legal_entity_id));
2061: END IF;

Line 2059: arp_util.debug( 'l_cm_header.legal_entity_id = '

2055: arp_util.debug( 'l_cm_header.printing_option = '
2056: || l_cm_header.printing_option);
2057: arp_util.debug( 'l_cm_header.set_of_books_id = '
2058: || to_char(l_cm_header.set_of_books_id));
2059: arp_util.debug( 'l_cm_header.legal_entity_id = '
2060: || to_char(l_cm_header.legal_entity_id));
2061: END IF;
2062:
2063: --- Assign individual in parameter values to l_cm_header

Line 2073: arp_util.debug( 'Error: l_cm_header.cust_trx_type_id IS NULL');

2069: ELSE
2070: IF l_cm_header.cust_trx_type_id IS NULL THEN
2071: ROLLBACK TO Credit_Transaction_Pub;
2072: IF PG_DEBUG in ('Y', 'C') THEN
2073: arp_util.debug( 'Error: l_cm_header.cust_trx_type_id IS NULL');
2074: END IF;
2075: fnd_message.set_name( 'AR', 'AR_TW_BAD_DATE_TRX_TYPE');
2076: l_message_name := 'AR_TW_BAD_DATE_TRX_TYPE' ;
2077: RAISE e_handled_error;

Line 2328: arp_util.debug( 'l_compute_tax = ' || l_compute_tax);

2324: l_compute_tax := 'N';
2325: END IF;
2326:
2327: IF PG_DEBUG in ('Y', 'C') THEN
2328: arp_util.debug( 'l_compute_tax = ' || l_compute_tax);
2329: END IF;
2330:
2331: --
2332: -- call the entity handler

Line 2369: arp_util.debug( 'Debug point 2 : Error Calling arp_process_credit.insert_header.');

2365: EXCEPTION
2366: WHEN OTHERS THEN
2367: ROLLBACK TO Credit_Transaction_Pub;
2368: IF PG_DEBUG in ('Y', 'C') THEN
2369: arp_util.debug( 'Debug point 2 : Error Calling arp_process_credit.insert_header.');
2370: END IF;
2371: l_debug_point := 2;
2372: l_ue_message := SUBSTR('Error Calling arp_process_credit.insert_header '
2373: || SQLERRM, 1, 2000);

Line 2506: arp_util.debug( 'Debug point 9 : Error fetching credit line details');

2502: RAISE e_handled_error;
2503: WHEN OTHERS THEN
2504: ROLLBACK TO Credit_Transaction_Pub;
2505: IF PG_DEBUG in ('Y', 'C') THEN
2506: arp_util.debug( 'Debug point 9 : Error fetching credit line details');
2507: END IF;
2508: l_debug_point := 9;
2509: l_ue_message := SUBSTR('Error fetching credit line details '
2510: || SQLERRM, 1, 2000);

Line 2517: arp_util.debug( 'Before Insert line loop');

2513:
2514: -----------------------------Insert_line------------------------
2515: BEGIN
2516: IF PG_DEBUG in ('Y', 'C') THEN
2517: arp_util.debug( 'Before Insert line loop');
2518: END IF;
2519:
2520: FOR i IN 1..l_credited_trx_line_tbl.COUNT
2521: LOOP

Line 2533: arp_util.debug( 'Before Insert line call');

2529: END IF;
2530: */
2531:
2532: IF PG_DEBUG in ('Y', 'C') THEN
2533: arp_util.debug( 'Before Insert line call');
2534: END IF;
2535: ARP_PROCESS_CREDIT.insert_line(
2536: p_form_name => p_form_name,
2537: p_form_version => 1.0 ,

Line 2558: arp_util.debug( 'After Insert line call');

2554: p_status => p_status
2555: );
2556:
2557: IF PG_DEBUG in ('Y', 'C') THEN
2558: arp_util.debug( 'After Insert line call');
2559: END IF;
2560: END LOOP;
2561: EXCEPTION
2562: WHEN OTHERS THEN

Line 2565: arp_util.debug( 'Debug point 8 : Error inserting credit line details');

2561: EXCEPTION
2562: WHEN OTHERS THEN
2563: ROLLBACK TO Credit_Transaction_Pub;
2564: IF PG_DEBUG in ('Y', 'C') THEN
2565: arp_util.debug( 'Debug point 8 : Error inserting credit line details');
2566: END IF;
2567: l_err_mesg := SQLERRM;
2568: IF PG_DEBUG in ('Y', 'C') THEN
2569: arp_util.debug( l_err_mesg);

Line 2569: arp_util.debug( l_err_mesg);

2565: arp_util.debug( 'Debug point 8 : Error inserting credit line details');
2566: END IF;
2567: l_err_mesg := SQLERRM;
2568: IF PG_DEBUG in ('Y', 'C') THEN
2569: arp_util.debug( l_err_mesg);
2570: END IF;
2571: l_debug_point := 8;
2572: l_ue_message := SUBSTR('Error inserting credit line details '
2573: || SQLERRM, 1, 2000);

Line 2617: arp_util.debug( 'Debug point 3 : Error Calling arp_process_header.post_commit.');

2613: EXCEPTION
2614: WHEN OTHERS THEN
2615: ROLLBACK TO Credit_Transaction_Pub;
2616: IF PG_DEBUG in ('Y', 'C') THEN
2617: arp_util.debug( 'Debug point 3 : Error Calling arp_process_header.post_commit.');
2618: END IF;
2619: l_debug_point := 3;
2620: l_ue_message := SUBSTR('Error Calling arp_process_header.post_commit '
2621: || SQLERRM, 1, 2000);

Line 2654: arp_util.debug( 'l_copy_doc_number_flag = ' || l_copy_doc_number_flag);

2650: END IF;
2651:
2652:
2653: IF PG_DEBUG in ('Y', 'C') THEN
2654: arp_util.debug( 'l_copy_doc_number_flag = ' || l_copy_doc_number_flag);
2655: arp_util.debug( 'doc_sequence_value = ' || to_char(l_cm_header.doc_sequence_value));
2656: arp_util.debug( 'doc_sequence_id = ' || to_char(l_cm_header.doc_sequence_id));
2657: END IF;
2658:

Line 2655: arp_util.debug( 'doc_sequence_value = ' || to_char(l_cm_header.doc_sequence_value));

2651:
2652:
2653: IF PG_DEBUG in ('Y', 'C') THEN
2654: arp_util.debug( 'l_copy_doc_number_flag = ' || l_copy_doc_number_flag);
2655: arp_util.debug( 'doc_sequence_value = ' || to_char(l_cm_header.doc_sequence_value));
2656: arp_util.debug( 'doc_sequence_id = ' || to_char(l_cm_header.doc_sequence_id));
2657: END IF;
2658:
2659: -- check copy_doc_number_flag

Line 2656: arp_util.debug( 'doc_sequence_id = ' || to_char(l_cm_header.doc_sequence_id));

2652:
2653: IF PG_DEBUG in ('Y', 'C') THEN
2654: arp_util.debug( 'l_copy_doc_number_flag = ' || l_copy_doc_number_flag);
2655: arp_util.debug( 'doc_sequence_value = ' || to_char(l_cm_header.doc_sequence_value));
2656: arp_util.debug( 'doc_sequence_id = ' || to_char(l_cm_header.doc_sequence_id));
2657: END IF;
2658:
2659: -- check copy_doc_number_flag
2660: IF l_cm_header.doc_sequence_value is not null THEN

Line 2686: arp_util.debug( 'Debug point 4 : Error Processing Doc Seq No.');

2682: EXCEPTION
2683: WHEN OTHERS THEN
2684: ROLLBACK TO Credit_Transaction_Pub;
2685: IF PG_DEBUG in ('Y', 'C') THEN
2686: arp_util.debug( 'Debug point 4 : Error Processing Doc Seq No.');
2687: END IF;
2688: l_debug_point := 4;
2689: l_ue_message := SUBSTR(' Error Processing Doc Seq No ' || SQLERRM, 1, 2000);
2690: RAISE e_unexpected_error;

Line 2695: arp_util.debug( 'p_customer_trx_id = ' || to_char(p_customer_trx_id));

2691: END ;
2692:
2693: p_customer_trx_id := l_customer_trx_id;
2694: IF PG_DEBUG in ('Y', 'C') THEN
2695: arp_util.debug( 'p_customer_trx_id = ' || to_char(p_customer_trx_id));
2696: arp_util.debug( 'p_trx_number = ' || p_trx_number);
2697: arp_util.debug( 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
2698: arp_util.debug( 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
2699: arp_util.debug( 'p_status = ' || p_status);

Line 2696: arp_util.debug( 'p_trx_number = ' || p_trx_number);

2692:
2693: p_customer_trx_id := l_customer_trx_id;
2694: IF PG_DEBUG in ('Y', 'C') THEN
2695: arp_util.debug( 'p_customer_trx_id = ' || to_char(p_customer_trx_id));
2696: arp_util.debug( 'p_trx_number = ' || p_trx_number);
2697: arp_util.debug( 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
2698: arp_util.debug( 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
2699: arp_util.debug( 'p_status = ' || p_status);
2700: arp_util.debug('create_line_cm()-');

Line 2697: arp_util.debug( 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));

2693: p_customer_trx_id := l_customer_trx_id;
2694: IF PG_DEBUG in ('Y', 'C') THEN
2695: arp_util.debug( 'p_customer_trx_id = ' || to_char(p_customer_trx_id));
2696: arp_util.debug( 'p_trx_number = ' || p_trx_number);
2697: arp_util.debug( 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
2698: arp_util.debug( 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
2699: arp_util.debug( 'p_status = ' || p_status);
2700: arp_util.debug('create_line_cm()-');
2701: END IF;

Line 2698: arp_util.debug( 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));

2694: IF PG_DEBUG in ('Y', 'C') THEN
2695: arp_util.debug( 'p_customer_trx_id = ' || to_char(p_customer_trx_id));
2696: arp_util.debug( 'p_trx_number = ' || p_trx_number);
2697: arp_util.debug( 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
2698: arp_util.debug( 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
2699: arp_util.debug( 'p_status = ' || p_status);
2700: arp_util.debug('create_line_cm()-');
2701: END IF;
2702:

Line 2699: arp_util.debug( 'p_status = ' || p_status);

2695: arp_util.debug( 'p_customer_trx_id = ' || to_char(p_customer_trx_id));
2696: arp_util.debug( 'p_trx_number = ' || p_trx_number);
2697: arp_util.debug( 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
2698: arp_util.debug( 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
2699: arp_util.debug( 'p_status = ' || p_status);
2700: arp_util.debug('create_line_cm()-');
2701: END IF;
2702:
2703: EXCEPTION

Line 2700: arp_util.debug('create_line_cm()-');

2696: arp_util.debug( 'p_trx_number = ' || p_trx_number);
2697: arp_util.debug( 'p_computed_tax_percent = ' || to_char(p_computed_tax_percent));
2698: arp_util.debug( 'p_computed_tax_amount = ' || to_char(p_computed_tax_amount));
2699: arp_util.debug( 'p_status = ' || p_status);
2700: arp_util.debug('create_line_cm()-');
2701: END IF;
2702:
2703: EXCEPTION
2704: -- bug 2290738 : populate error table with message and pass value to p_status

Line 2708: arp_util.debug('EXCEPTION WHEN e_handled_error : create_line_cm');

2704: -- bug 2290738 : populate error table with message and pass value to p_status
2705:
2706: WHEN e_handled_error THEN
2707: IF PG_DEBUG in ('Y', 'C') THEN
2708: arp_util.debug('EXCEPTION WHEN e_handled_error : create_line_cm');
2709: END IF;
2710: p_status := 'e_handled_error';
2711:
2712: ROLLBACK TO Credit_Transaction_Pub;

Line 2721: arp_util.debug( 'p_errors(1).message_name = '

2717: fnd_message.set_name( 'AR', l_message_name);
2718: FND_MSG_PUB.Add;
2719:
2720: IF PG_DEBUG in ('Y', 'C') THEN
2721: arp_util.debug( 'p_errors(1).message_name = '
2722: || p_errors(1).message_name);
2723: arp_util.debug( 'p_errors(1).encoded_message = '
2724: || p_errors(1).encoded_message);
2725: arp_util.debug( 'p_errors(1).translated_message = '

Line 2723: arp_util.debug( 'p_errors(1).encoded_message = '

2719:
2720: IF PG_DEBUG in ('Y', 'C') THEN
2721: arp_util.debug( 'p_errors(1).message_name = '
2722: || p_errors(1).message_name);
2723: arp_util.debug( 'p_errors(1).encoded_message = '
2724: || p_errors(1).encoded_message);
2725: arp_util.debug( 'p_errors(1).translated_message = '
2726: || p_errors(1).translated_message);
2727: END IF;

Line 2725: arp_util.debug( 'p_errors(1).translated_message = '

2721: arp_util.debug( 'p_errors(1).message_name = '
2722: || p_errors(1).message_name);
2723: arp_util.debug( 'p_errors(1).encoded_message = '
2724: || p_errors(1).encoded_message);
2725: arp_util.debug( 'p_errors(1).translated_message = '
2726: || p_errors(1).translated_message);
2727: END IF;
2728:
2729: WHEN e_unexpected_error THEN

Line 2731: arp_util.debug('EXCEPTION WHEN e_unexpected_error : create_line_cm');

2727: END IF;
2728:
2729: WHEN e_unexpected_error THEN
2730: IF PG_DEBUG in ('Y', 'C') THEN
2731: arp_util.debug('EXCEPTION WHEN e_unexpected_error : create_line_cm');
2732: END IF;
2733: p_status := 'e_unexpected_error';
2734:
2735: ROLLBACK TO Credit_Transaction_Pub;

Line 2758: arp_util.debug( 'p_errors(1).message_name = '

2754: fnd_message.set_encoded(p_errors(1).encoded_message);
2755: FND_MSG_PUB.Add;
2756: END IF;
2757: IF PG_DEBUG in ('Y', 'C') THEN
2758: arp_util.debug( 'p_errors(1).message_name = '
2759: || p_errors(1).message_name);
2760: arp_util.debug( 'p_errors(1).encoded_message = '
2761: || p_errors(1).encoded_message);
2762: arp_util.debug( 'p_errors(1).translated_message = '

Line 2760: arp_util.debug( 'p_errors(1).encoded_message = '

2756: END IF;
2757: IF PG_DEBUG in ('Y', 'C') THEN
2758: arp_util.debug( 'p_errors(1).message_name = '
2759: || p_errors(1).message_name);
2760: arp_util.debug( 'p_errors(1).encoded_message = '
2761: || p_errors(1).encoded_message);
2762: arp_util.debug( 'p_errors(1).translated_message = '
2763: || p_errors(1).translated_message);
2764: END IF;

Line 2762: arp_util.debug( 'p_errors(1).translated_message = '

2758: arp_util.debug( 'p_errors(1).message_name = '
2759: || p_errors(1).message_name);
2760: arp_util.debug( 'p_errors(1).encoded_message = '
2761: || p_errors(1).encoded_message);
2762: arp_util.debug( 'p_errors(1).translated_message = '
2763: || p_errors(1).translated_message);
2764: END IF;
2765:
2766: WHEN OTHERS THEN

Line 2768: arp_util.debug('EXCEPTION WHEN OTHERS : create_line_cm');

2764: END IF;
2765:
2766: WHEN OTHERS THEN
2767: IF PG_DEBUG in ('Y', 'C') THEN
2768: arp_util.debug('EXCEPTION WHEN OTHERS : create_line_cm');
2769: END IF;
2770: p_status := 'others';
2771:
2772: ROLLBACK TO Credit_Transaction_Pub;

Line 2784: arp_util.debug( 'p_errors(1).message_name = '

2780: FND_MSG_PUB.Add;
2781:
2782: p_errors(1).translated_message := fnd_message.get;
2783: IF PG_DEBUG in ('Y', 'C') THEN
2784: arp_util.debug( 'p_errors(1).message_name = '
2785: || p_errors(1).message_name);
2786: arp_util.debug( 'p_errors(1).encoded_message = '
2787: || p_errors(1).encoded_message);
2788: arp_util.debug( 'p_errors(1).translated_message = '

Line 2786: arp_util.debug( 'p_errors(1).encoded_message = '

2782: p_errors(1).translated_message := fnd_message.get;
2783: IF PG_DEBUG in ('Y', 'C') THEN
2784: arp_util.debug( 'p_errors(1).message_name = '
2785: || p_errors(1).message_name);
2786: arp_util.debug( 'p_errors(1).encoded_message = '
2787: || p_errors(1).encoded_message);
2788: arp_util.debug( 'p_errors(1).translated_message = '
2789: || p_errors(1).translated_message);
2790: END IF;

Line 2788: arp_util.debug( 'p_errors(1).translated_message = '

2784: arp_util.debug( 'p_errors(1).message_name = '
2785: || p_errors(1).message_name);
2786: arp_util.debug( 'p_errors(1).encoded_message = '
2787: || p_errors(1).encoded_message);
2788: arp_util.debug( 'p_errors(1).translated_message = '
2789: || p_errors(1).translated_message);
2790: END IF;
2791:
2792: END create_line_cm;