12: BEGIN
13:
14: ---Put the header in the report to identify the block to be run
15:
16: arp_message.set_line('CRM_MERGE.SR_MERGE()+');
17:
18: IF ( process_mode = 'LOCK' ) Then
19: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
20: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
15:
16: arp_message.set_line('CRM_MERGE.SR_MERGE()+');
17:
18: IF ( process_mode = 'LOCK' ) Then
19: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
20: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
21: ELSE
22: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
23: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
16: arp_message.set_line('CRM_MERGE.SR_MERGE()+');
17:
18: IF ( process_mode = 'LOCK' ) Then
19: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
20: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
21: ELSE
22: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
23: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
24:
18: IF ( process_mode = 'LOCK' ) Then
19: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
20: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
21: ELSE
22: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
23: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
24:
25: END IF;
26:
19: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
20: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
21: ELSE
22: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
23: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );
24:
25: END IF;
26:
27: ----Merge the CS_ESTIMATE_DETAILS table update the account_id
26:
27: ----Merge the CS_ESTIMATE_DETAILS table update the account_id
28:
29: message_text := '***-- Procedure CS_CH_MERGE_CUST_ACCOUNT_ID --**';
30: arp_message.set_line(message_text);
31:
32: ---dbms_output.put_line('am going to call small proc');
33:
34: CS_CH_MERGE_CUST_ACCOUNT_ID( req_id, set_number, process_mode );
33:
34: CS_CH_MERGE_CUST_ACCOUNT_ID( req_id, set_number, process_mode );
35:
36: message_text := '***-- End CS_CH_MERGE_CUST_ACCOUNT_ID --**';
37: arp_message.set_line(message_text);
38:
39:
40: ---Report that the process for CS_ESTIMATE_DETAILS is complete
41:
40: ---Report that the process for CS_ESTIMATE_DETAILS is complete
41:
42: IF ( process_mode = 'LOCK' ) Then
43: message_text := '** LOCKING completed for table CS_ESTIMATE_DETAILS **';
44: arp_message.set_line(message_text);
45: ELSE
46: message_text := '** MERGE completed for table CS_ESTIMATE_DETAILS **';
47: arp_message.set_line(message_text);
48: END IF;
43: message_text := '** LOCKING completed for table CS_ESTIMATE_DETAILS **';
44: arp_message.set_line(message_text);
45: ELSE
46: message_text := '** MERGE completed for table CS_ESTIMATE_DETAILS **';
47: arp_message.set_line(message_text);
48: END IF;
49:
50: arp_message.set_line('CRM_MERGE.SR_MERGE()-');
51:
46: message_text := '** MERGE completed for table CS_ESTIMATE_DETAILS **';
47: arp_message.set_line(message_text);
48: END IF;
49:
50: arp_message.set_line('CRM_MERGE.SR_MERGE()-');
51:
52: END MERGE_CUST_ACCOUNTS;
53:
54: -- The following procedure merges the following columns from CS_ESTIMATE_DETAILS
125: BEGIN
126: IF process_mode='LOCK' THEN
127: NULL;
128: ELSE
129: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
130: ARP_MESSAGE.SET_TOKEN('TABLE_NAME',' CS_ESTIMATE_DETAILS',FALSE);
131:
132: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
133: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
126: IF process_mode='LOCK' THEN
127: NULL;
128: ELSE
129: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
130: ARP_MESSAGE.SET_TOKEN('TABLE_NAME',' CS_ESTIMATE_DETAILS',FALSE);
131:
132: HZ_ACCT_MERGE_UTIL.load_set(set_number, req_id);
133: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
134:
223: END IF;
224:
225: END LOOP;
226:
227: arp_message.set_name('AR','AR_ROWS_UPDATED');
228: arp_message.set_token('NUM_ROWS',to_char(l_count));
229: END IF;
230:
231: EXCEPTION
224:
225: END LOOP;
226:
227: arp_message.set_name('AR','AR_ROWS_UPDATED');
228: arp_message.set_token('NUM_ROWS',to_char(l_count));
229: END IF;
230:
231: EXCEPTION
232: WHEN DIFFERENT_PARTIES THEN
229: END IF;
230:
231: EXCEPTION
232: WHEN DIFFERENT_PARTIES THEN
233: arp_message.set_name('CS','CS_ACCT_MERGE_NOT_ALLOWED');
234: RAISE;
235:
236: WHEN OTHERS THEN
237: arp_message.set_line( 'CS_CH_MERGE_CUST_ACCOUNT_ID');
233: arp_message.set_name('CS','CS_ACCT_MERGE_NOT_ALLOWED');
234: RAISE;
235:
236: WHEN OTHERS THEN
237: arp_message.set_line( 'CS_CH_MERGE_CUST_ACCOUNT_ID');
238: RAISE;
239:
240: END CS_CH_MERGE_CUST_ACCOUNT_ID;
241: