DBA Data[Home] [Help]

APPS.AR_MCC_MERGE dependencies on ARP_MESSAGE

Line 217: arp_message.set_line('AR_MCC_MERGE.Customer_Merge()+');

213:
214: -- initialize the message stack
215: FND_MSG_PUB.Initialize;
216:
217: arp_message.set_line('AR_MCC_MERGE.Customer_Merge()+');
218:
219: AR_MCC_MERGE.Log
220: (AR_MCC_MERGE.G_LOG_PROCEDURE
221: ,'Start of Proc:Customer Merge'

Line 225: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

221: ,'Start of Proc:Customer Merge'
222: );
223:
224: IF process_mode = 'LOCK' THEN
225: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
226: arp_message.set_token('TABLE_NAME', 'HZ_CREDIT_USAGES', FALSE);
227:
228: open check_credit_usage_cur;
229: close check_credit_usage_cur;

Line 226: arp_message.set_token('TABLE_NAME', 'HZ_CREDIT_USAGES', FALSE);

222: );
223:
224: IF process_mode = 'LOCK' THEN
225: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
226: arp_message.set_token('TABLE_NAME', 'HZ_CREDIT_USAGES', FALSE);
227:
228: open check_credit_usage_cur;
229: close check_credit_usage_cur;
230:

Line 236: arp_message.set_line('AR_MCC_MERGE.Customer_Merge()+');

232: (AR_MCC_MERGE.G_LOG_EVENT
233: ,'Rows locked from HZ_CREDIT_USAGES'
234: );
235: ELSE
236: arp_message.set_line('AR_MCC_MERGE.Customer_Merge()+');
237:
238: -- Get each customer account being merged
239: FOR cust_dup IN customer_account_dup_cur LOOP
240:

Line 365: arp_message.set_name('AR', 'AR_ROWS_DELETED');

361: ,'Total rows deleted: ' || to_char(l_total_count)
362: );
363:
364: -- Total number of rows deleted
365: arp_message.set_name('AR', 'AR_ROWS_DELETED');
366: arp_message.set_token('NUM_ROWS', to_char(l_total_count));
367:
368: END IF; -- delete flag check
369:

Line 366: arp_message.set_token('NUM_ROWS', to_char(l_total_count));

362: );
363:
364: -- Total number of rows deleted
365: arp_message.set_name('AR', 'AR_ROWS_DELETED');
366: arp_message.set_token('NUM_ROWS', to_char(l_total_count));
367:
368: END IF; -- delete flag check
369:
370: END LOOP; -- customer account loop

Line 374: arp_message.set_line('AR_MCC_MERGE.Customer_Merge()-');

370: END LOOP; -- customer account loop
371:
372: END IF; -- check for process mode
373:
374: arp_message.set_line('AR_MCC_MERGE.Customer_Merge()-');
375:
376: EXCEPTION
377: WHEN OTHERS THEN
378: arp_message.set_error('AR_MCC_MERGE.Customer_Merge');

Line 378: arp_message.set_error('AR_MCC_MERGE.Customer_Merge');

374: arp_message.set_line('AR_MCC_MERGE.Customer_Merge()-');
375:
376: EXCEPTION
377: WHEN OTHERS THEN
378: arp_message.set_error('AR_MCC_MERGE.Customer_Merge');
379: l_errorcode := SQLCODE;
380: l_errortext := SUBSTR(SQLERRM, 1,200);
381: AR_MCC_MERGE.Log
382: (AR_MCC_MERGE.G_LOG_EXCEPTION