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.OEP_CMERGE_OENTS dependencies on ARP_MESSAGE

Line 59: arp_message.set_line( 'OEP_CMERGE_OENTS.OE_AR()+' );

55: for update nowait;
56:
57: BEGIN
58:
59: arp_message.set_line( 'OEP_CMERGE_OENTS.OE_AR()+' );
60:
61: /*-----------------------------+
62: | SO_NOTE_ADDITION_RULES |
63: +-----------------------------*/

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

64: /* both customer and site level */
65:
66: IF( process_mode = 'LOCK' ) THEN
67:
68: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
69: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
70:
71: open c1;
72: close c1;

Line 69: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );

65:
66: IF( process_mode = 'LOCK' ) THEN
67:
68: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
69: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
70:
71: open c1;
72: close c1;
73:

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

83: ELSE
84:
85:
86: /* site level update */
87: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
88: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
89:
90: UPDATE SO_NOTE_ADDITION_RULES a
91: set (entity_value) = (select distinct m.customer_site_id

Line 88: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );

84:
85:
86: /* site level update */
87: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
88: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
89:
90: UPDATE SO_NOTE_ADDITION_RULES a
91: set (entity_value) = (select distinct m.customer_site_id
92: from ra_customer_merges m

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

106: and entity_id = 1009;
107:
108: g_count := sql%rowcount;
109:
110: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
111: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
112:
113:
114: /* site level update */

Line 111: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

107:
108: g_count := sql%rowcount;
109:
110: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
111: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
112:
113:
114: /* site level update */
115: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

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

111: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
112:
113:
114: /* site level update */
115: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
116: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
117:
118: UPDATE SO_NOTE_ADDITION_RULES a
119: set (entity_value) = (select distinct m.customer_site_id

Line 116: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );

112:
113:
114: /* site level update */
115: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
116: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
117:
118: UPDATE SO_NOTE_ADDITION_RULES a
119: set (entity_value) = (select distinct m.customer_site_id
120: from ra_customer_merges m

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

134: and entity_id = 1008;
135:
136: g_count := sql%rowcount;
137:
138: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
139: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
140:
141:
142: /* site level update */

Line 139: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

135:
136: g_count := sql%rowcount;
137:
138: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
139: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
140:
141:
142: /* site level update */
143: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

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

139: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
140:
141:
142: /* site level update */
143: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
144: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
145:
146: UPDATE SO_NOTE_ADDITION_RULES a
147: set (entity_value) = (select distinct m.customer_site_id

Line 144: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );

140:
141:
142: /* site level update */
143: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
144: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
145:
146: UPDATE SO_NOTE_ADDITION_RULES a
147: set (entity_value) = (select distinct m.customer_site_id
148: from ra_customer_merges m

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

162: and entity_id = 1003;
163:
164: g_count := sql%rowcount;
165:
166: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
167: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
168:
169:
170: /* customer level update */

Line 167: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

163:
164: g_count := sql%rowcount;
165:
166: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
167: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
168:
169:
170: /* customer level update */
171: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

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

167: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
168:
169:
170: /* customer level update */
171: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
172: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
173:
174: UPDATE SO_NOTE_ADDITION_RULES a
175: set entity_value = (select distinct m.customer_id

Line 172: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );

168:
169:
170: /* customer level update */
171: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
172: arp_message.set_token( 'TABLE_NAME', 'SO_NOTE_ADDITION_RULES', FALSE );
173:
174: UPDATE SO_NOTE_ADDITION_RULES a
175: set entity_value = (select distinct m.customer_id
176: from ra_customer_merges m

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

190: and entity_id = 1000;
191:
192: g_count := sql%rowcount;
193:
194: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
195: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
196:
197: END IF;
198:

Line 195: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

191:
192: g_count := sql%rowcount;
193:
194: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
195: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
196:
197: END IF;
198:
199: arp_message.set_line( 'OEP_CMERGE_OENTS.OE_AR()-' );

Line 199: arp_message.set_line( 'OEP_CMERGE_OENTS.OE_AR()-' );

195: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
196:
197: END IF;
198:
199: arp_message.set_line( 'OEP_CMERGE_OENTS.OE_AR()-' );
200:
201:
202: EXCEPTION
203: when others then

Line 204: arp_message.set_error( 'OEP_CMERGE_OENTS.OE_AR');

200:
201:
202: EXCEPTION
203: when others then
204: arp_message.set_error( 'OEP_CMERGE_OENTS.OE_AR');
205: raise;
206:
207: END;
208:

Line 216: arp_message.set_line( 'OEP_CMERGE_OEORD.MERGE()+' );

212:
213: PROCEDURE MERGE (REQ_ID NUMBER, SET_NUM NUMBER, PROCESS_MODE VARCHAR2) IS
214: BEGIN
215:
216: arp_message.set_line( 'OEP_CMERGE_OEORD.MERGE()+' );
217:
218: oe_ar( req_id, set_num, process_mode );
219:
220: arp_message.set_line( 'OEP_CMERGE_OENTS.MERGE()-' );

Line 220: arp_message.set_line( 'OEP_CMERGE_OENTS.MERGE()-' );

216: arp_message.set_line( 'OEP_CMERGE_OEORD.MERGE()+' );
217:
218: oe_ar( req_id, set_num, process_mode );
219:
220: arp_message.set_line( 'OEP_CMERGE_OENTS.MERGE()-' );
221:
222: EXCEPTION
223: when others then
224: raise;