eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CH_ACCOUNT_MERGE_PKG dependencies on ARP_MESSAGE

Line 16: arp_message.set_line('CRM_MERGE.SR_MERGE()+');

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 );

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

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 );

Line 20: 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:

Line 22: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

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:

Line 23: arp_message.set_token('TABLE_NAME', 'CS_ESTIMATE_DETAILS',FALSE );

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

Line 30: arp_message.set_line(message_text);

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 );

Line 37: arp_message.set_line(message_text);

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:

Line 44: arp_message.set_line(message_text);

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;

Line 47: arp_message.set_line(message_text);

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:

Line 50: arp_message.set_line('CRM_MERGE.SR_MERGE()-');

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

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

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');

Line 130: ARP_MESSAGE.SET_TOKEN('TABLE_NAME',' CS_ESTIMATE_DETAILS',FALSE);

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:

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

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

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

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

Line 233: arp_message.set_name('CS','CS_ACCT_MERGE_NOT_ALLOWED');

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');

Line 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: