DBA Data[Home] [Help]

APPS.FUN_CUSTOMERMERGE_PKG dependencies on ARP_MESSAGE

Line 60: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

56: BEGIN
57: IF process_mode='LOCK' THEN
58: NULL;
59: ELSE
60: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
61: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FUN_NET_CUSTOMERS_ALL',FALSE);
62: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
63:
64: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

Line 61: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FUN_NET_CUSTOMERS_ALL',FALSE);

57: IF process_mode='LOCK' THEN
58: NULL;
59: ELSE
60: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
61: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FUN_NET_CUSTOMERS_ALL',FALSE);
62: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
63:
64: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
65:

Line 142: arp_message.set_name('AR','AR_ROWS_UPDATED');

138: EXIT;
139: END IF;
140: END LOOP;
141:
142: arp_message.set_name('AR','AR_ROWS_UPDATED');
143: arp_message.set_token('NUM_ROWS',to_char(l_count));
144:
145: /* If there is more than one record that has the same agreement_id,cust_account_id and cust_site_use_id then update the customer priority of the records to the highest priority amongst them */
146: BEGIN

Line 143: arp_message.set_token('NUM_ROWS',to_char(l_count));

139: END IF;
140: END LOOP;
141:
142: arp_message.set_name('AR','AR_ROWS_UPDATED');
143: arp_message.set_token('NUM_ROWS',to_char(l_count));
144:
145: /* If there is more than one record that has the same agreement_id,cust_account_id and cust_site_use_id then update the customer priority of the records to the highest priority amongst them */
146: BEGIN
147: UPDATE FUN_NET_CUSTOMERS_ALL yt SET

Line 194: arp_message.set_line( 'Merge_Customer');

190: END;
191: END IF;
192: EXCEPTION
193: WHEN OTHERS THEN
194: arp_message.set_line( 'Merge_Customer');
195: RAISE;
196: END Merge_Customer;
197: END FUN_CustomerMerge_PKG;