DBA Data[Home] [Help]

APPS.ARP_CMERGE dependencies on ARP_MESSAGE

Line 59: arp_message.set_line( 'ARP_CMERGE.INSERT_FULL_MERGE_EVENT()+');

55:
56: BEGIN
57:
58: IF PG_DEBUG in ('Y', 'C') THEN
59: arp_message.set_line( 'ARP_CMERGE.INSERT_FULL_MERGE_EVENT()+');
60: END IF;
61:
62: IF process_mode='LOCK' THEN
63: NULL;

Line 88: arp_message.set_line( 'GL Date : '|| l_valid_gl_date);

84: RAISE error_defaulting_gl_date;
85: END IF;
86:
87: IF PG_DEBUG in ('Y', 'C') THEN
88: arp_message.set_line( 'GL Date : '|| l_valid_gl_date);
89: END IF ;
90:
91: INSERT INTO xla_events_gt
92: (application_id

Line 112: arp_message.set_line( 'Error in getting XLA subledger options');

108: FROM XLA_SUBLEDGER_OPTIONS_V
109: WHERE APPLICATION_ID = 222
110: AND LEDGER_ID = arp_global.set_of_books_id;
111: EXCEPTION WHEN OTHERS THEN
112: arp_message.set_line( 'Error in getting XLA subledger options');
113: arp_message.set_line( 'Parameters:- Application id: 222, Ledger id: ' || arp_global.set_of_books_id);
114: arp_message.set_line( 'SQl Error : ' || sqlerrm);
115: END;
116:

Line 113: arp_message.set_line( 'Parameters:- Application id: 222, Ledger id: ' || arp_global.set_of_books_id);

109: WHERE APPLICATION_ID = 222
110: AND LEDGER_ID = arp_global.set_of_books_id;
111: EXCEPTION WHEN OTHERS THEN
112: arp_message.set_line( 'Error in getting XLA subledger options');
113: arp_message.set_line( 'Parameters:- Application id: 222, Ledger id: ' || arp_global.set_of_books_id);
114: arp_message.set_line( 'SQl Error : ' || sqlerrm);
115: END;
116:
117: IF PG_DEBUG in ('Y', 'C') THEN

Line 114: arp_message.set_line( 'SQl Error : ' || sqlerrm);

110: AND LEDGER_ID = arp_global.set_of_books_id;
111: EXCEPTION WHEN OTHERS THEN
112: arp_message.set_line( 'Error in getting XLA subledger options');
113: arp_message.set_line( 'Parameters:- Application id: 222, Ledger id: ' || arp_global.set_of_books_id);
114: arp_message.set_line( 'SQl Error : ' || sqlerrm);
115: END;
116:
117: IF PG_DEBUG in ('Y', 'C') THEN
118: arp_message.set_line ('p_accounting_mode = '|| p_accounting_mode);

Line 118: arp_message.set_line ('p_accounting_mode = '|| p_accounting_mode);

114: arp_message.set_line( 'SQl Error : ' || sqlerrm);
115: END;
116:
117: IF PG_DEBUG in ('Y', 'C') THEN
118: arp_message.set_line ('p_accounting_mode = '|| p_accounting_mode);
119: arp_message.set_line ('p_transfer_to_gl_flag = '|| p_transfer_to_gl_flag);
120: arp_message.set_line ('p_post_in_gl_flag = '|| p_post_in_gl_flag);
121: END IF;
122:

Line 119: arp_message.set_line ('p_transfer_to_gl_flag = '|| p_transfer_to_gl_flag);

115: END;
116:
117: IF PG_DEBUG in ('Y', 'C') THEN
118: arp_message.set_line ('p_accounting_mode = '|| p_accounting_mode);
119: arp_message.set_line ('p_transfer_to_gl_flag = '|| p_transfer_to_gl_flag);
120: arp_message.set_line ('p_post_in_gl_flag = '|| p_post_in_gl_flag);
121: END IF;
122:
123: For C1 IN select_merge_cust(req_id , set_num) LOOP

Line 120: arp_message.set_line ('p_post_in_gl_flag = '|| p_post_in_gl_flag);

116:
117: IF PG_DEBUG in ('Y', 'C') THEN
118: arp_message.set_line ('p_accounting_mode = '|| p_accounting_mode);
119: arp_message.set_line ('p_transfer_to_gl_flag = '|| p_transfer_to_gl_flag);
120: arp_message.set_line ('p_post_in_gl_flag = '|| p_post_in_gl_flag);
121: END IF;
122:
123: For C1 IN select_merge_cust(req_id , set_num) LOOP
124:

Line 126: arp_message.set_line ('Calling xla_third_party_merge_pub.third_party_merge');

122:
123: For C1 IN select_merge_cust(req_id , set_num) LOOP
124:
125: IF PG_DEBUG in ('Y', 'C') THEN
126: arp_message.set_line ('Calling xla_third_party_merge_pub.third_party_merge');
127: arp_message.set_line ('p_original_third_party_id = '|| C1.duplicate_id);
128: arp_message.set_line ('p_original_site_id = '|| C1.duplicate_site_id);
129: arp_message.set_line ('p_new_third_party_id = '|| C1.customer_id);
130: arp_message.set_line ('p_new_site_id = '|| C1.customer_site_id);

Line 127: arp_message.set_line ('p_original_third_party_id = '|| C1.duplicate_id);

123: For C1 IN select_merge_cust(req_id , set_num) LOOP
124:
125: IF PG_DEBUG in ('Y', 'C') THEN
126: arp_message.set_line ('Calling xla_third_party_merge_pub.third_party_merge');
127: arp_message.set_line ('p_original_third_party_id = '|| C1.duplicate_id);
128: arp_message.set_line ('p_original_site_id = '|| C1.duplicate_site_id);
129: arp_message.set_line ('p_new_third_party_id = '|| C1.customer_id);
130: arp_message.set_line ('p_new_site_id = '|| C1.customer_site_id);
131: END IF;

Line 128: arp_message.set_line ('p_original_site_id = '|| C1.duplicate_site_id);

124:
125: IF PG_DEBUG in ('Y', 'C') THEN
126: arp_message.set_line ('Calling xla_third_party_merge_pub.third_party_merge');
127: arp_message.set_line ('p_original_third_party_id = '|| C1.duplicate_id);
128: arp_message.set_line ('p_original_site_id = '|| C1.duplicate_site_id);
129: arp_message.set_line ('p_new_third_party_id = '|| C1.customer_id);
130: arp_message.set_line ('p_new_site_id = '|| C1.customer_site_id);
131: END IF;
132:

Line 129: arp_message.set_line ('p_new_third_party_id = '|| C1.customer_id);

125: IF PG_DEBUG in ('Y', 'C') THEN
126: arp_message.set_line ('Calling xla_third_party_merge_pub.third_party_merge');
127: arp_message.set_line ('p_original_third_party_id = '|| C1.duplicate_id);
128: arp_message.set_line ('p_original_site_id = '|| C1.duplicate_site_id);
129: arp_message.set_line ('p_new_third_party_id = '|| C1.customer_id);
130: arp_message.set_line ('p_new_site_id = '|| C1.customer_site_id);
131: END IF;
132:
133: xla_third_party_merge_pub.third_party_merge(

Line 130: arp_message.set_line ('p_new_site_id = '|| C1.customer_site_id);

126: arp_message.set_line ('Calling xla_third_party_merge_pub.third_party_merge');
127: arp_message.set_line ('p_original_third_party_id = '|| C1.duplicate_id);
128: arp_message.set_line ('p_original_site_id = '|| C1.duplicate_site_id);
129: arp_message.set_line ('p_new_third_party_id = '|| C1.customer_id);
130: arp_message.set_line ('p_new_site_id = '|| C1.customer_site_id);
131: END IF;
132:
133: xla_third_party_merge_pub.third_party_merge(
134: x_errbuf => x_errbuf,

Line 155: arp_message.set_line ('x_retcode = '|| x_retcode);

151: p_transfer_to_gl_flag => p_transfer_to_gl_flag,
152: p_post_in_gl_flag => p_post_in_gl_flag);
153:
154: IF PG_DEBUG in ('Y', 'C') THEN
155: arp_message.set_line ('x_retcode = '|| x_retcode);
156: END IF ;
157:
158: IF x_retcode <> 'S' THEN
159: RAISE fnd_api.g_exc_error;

Line 167: arp_message.set_line( 'ARP_CMERGE.INSERT_FULL_MERGE_EVENT()-');

163:
164: END IF ;
165:
166: IF PG_DEBUG in ('Y', 'C') THEN
167: arp_message.set_line( 'ARP_CMERGE.INSERT_FULL_MERGE_EVENT()-');
168: END IF;
169:
170: EXCEPTION
171: WHEN error_defaulting_gl_date THEN

Line 172: arp_message.set_line( 'default_gl_date Error in insert_full_merge_event ' || sqlerrm);

168: END IF;
169:
170: EXCEPTION
171: WHEN error_defaulting_gl_date THEN
172: arp_message.set_line( 'default_gl_date Error in insert_full_merge_event ' || sqlerrm);
173: RAISE;
174: WHEN OTHERS THEN
175: arp_message.set_line( 'Others Error in insert_full_merge_event '|| sqlerrm);
176: RAISE;

Line 175: arp_message.set_line( 'Others Error in insert_full_merge_event '|| sqlerrm);

171: WHEN error_defaulting_gl_date THEN
172: arp_message.set_line( 'default_gl_date Error in insert_full_merge_event ' || sqlerrm);
173: RAISE;
174: WHEN OTHERS THEN
175: arp_message.set_line( 'Others Error in insert_full_merge_event '|| sqlerrm);
176: RAISE;
177:
178: END insert_full_merge_event ;
179:

Line 214: arp_message.set_name('AR','AR_CUST_SITE_DRAFT_CBI') ;

210: CLOSE c;
211:
212: EXCEPTION
213: WHEN DRAFT_CBI THEN
214: arp_message.set_name('AR','AR_CUST_SITE_DRAFT_CBI') ;
215: arp_message.set_error('ARP_CMERGE_ARCON.AR_CIN') ;
216: raise;
217:
218: end MERGE_VALIDATION;

Line 215: arp_message.set_error('ARP_CMERGE_ARCON.AR_CIN') ;

211:
212: EXCEPTION
213: WHEN DRAFT_CBI THEN
214: arp_message.set_name('AR','AR_CUST_SITE_DRAFT_CBI') ;
215: arp_message.set_error('ARP_CMERGE_ARCON.AR_CIN') ;
216: raise;
217:
218: end MERGE_VALIDATION;
219:

Line 222: arp_message.set_line( 'ARP_CMERGE.MERGE()+' );

218: end MERGE_VALIDATION;
219:
220: begin
221:
222: arp_message.set_line( 'ARP_CMERGE.MERGE()+' );
223:
224: merge_validation(req_id , set_num );
225:
226: arp_cmerge_aratc.merge(req_id, set_num, process_mode);

Line 235: arp_message.set_line( 'ARP_CMERGE.MERGE()-' );

231: arp_cmerge_artrx.merge(req_id, set_num, process_mode);
232:
233: insert_full_merge_event(req_id, set_num, process_mode);
234:
235: arp_message.set_line( 'ARP_CMERGE.MERGE()-' );
236:
237: EXCEPTION
238: when others then
239: raise;