66:
67: IF process_mode='LOCK' THEN
68: NULL;
69: ELSE
70: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
71: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','XDP_ORDER_HEADERS',FALSE);
72: HZ_ACCT_MERGE_UTIL.load_set(set_number, request_id);
73: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
74:
67: IF process_mode='LOCK' THEN
68: NULL;
69: ELSE
70: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
71: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','XDP_ORDER_HEADERS',FALSE);
72: HZ_ACCT_MERGE_UTIL.load_set(set_number, request_id);
73: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
74:
75: open merged_records;
137: EXIT;
138: END IF;
139: END LOOP;
140:
141: arp_message.set_name('AR','AR_ROWS_UPDATED');
142: arp_message.set_token('NUM_ROWS',to_char(l_count));
143: END IF;
144:
145: IF process_mode='LOCK' THEN
138: END IF;
139: END LOOP;
140:
141: arp_message.set_name('AR','AR_ROWS_UPDATED');
142: arp_message.set_token('NUM_ROWS',to_char(l_count));
143: END IF;
144:
145: IF process_mode='LOCK' THEN
146: NULL;
144:
145: IF process_mode='LOCK' THEN
146: NULL;
147: ELSE
148: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
149: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','XDP_ORDER_LINE_ITEMS',FALSE);
150: HZ_ACCT_MERGE_UTIL.load_set(set_number, request_id);
151: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
152:
145: IF process_mode='LOCK' THEN
146: NULL;
147: ELSE
148: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
149: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','XDP_ORDER_LINE_ITEMS',FALSE);
150: HZ_ACCT_MERGE_UTIL.load_set(set_number, request_id);
151: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
152:
153: open merged_records1;
215: EXIT;
216: END IF;
217: END LOOP;
218:
219: arp_message.set_name('AR','AR_ROWS_UPDATED');
220: arp_message.set_token('NUM_ROWS',to_char(l_count));
221: END IF;
222: EXCEPTION
223: WHEN OTHERS THEN
216: END IF;
217: END LOOP;
218:
219: arp_message.set_name('AR','AR_ROWS_UPDATED');
220: arp_message.set_token('NUM_ROWS',to_char(l_count));
221: END IF;
222: EXCEPTION
223: WHEN OTHERS THEN
224: /* Report the error in the log table and reraise the exception */
222: EXCEPTION
223: WHEN OTHERS THEN
224: /* Report the error in the log table and reraise the exception */
225: /* The exception MUST be reraised */
226: arp_message.set_error('CRM_MERGE.XDP_PARTY_MERGE');
227: raise;
228:
229: END account_merge;
230: