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

Line 55: arp_message.set_line('CP_CMERGE_BB8.MERGE()+');

51: BEGIN
52:
53: /* Put the header in the report to identify the block to be run */
54:
55: arp_message.set_line('CP_CMERGE_BB8.MERGE()+');
56:
57: IF ( process_mode = 'LOCK' ) Then
58: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
59: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );

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

54:
55: arp_message.set_line('CP_CMERGE_BB8.MERGE()+');
56:
57: IF ( process_mode = 'LOCK' ) Then
58: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
59: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );
60: message_text := 'The locking is done in block CSP_CMERGE_BB8';
61: arp_message.set_line(message_text);
62: ELSE

Line 59: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );

55: arp_message.set_line('CP_CMERGE_BB8.MERGE()+');
56:
57: IF ( process_mode = 'LOCK' ) Then
58: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
59: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );
60: message_text := 'The locking is done in block CSP_CMERGE_BB8';
61: arp_message.set_line(message_text);
62: ELSE
63: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

Line 61: arp_message.set_line(message_text);

57: IF ( process_mode = 'LOCK' ) Then
58: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
59: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );
60: message_text := 'The locking is done in block CSP_CMERGE_BB8';
61: arp_message.set_line(message_text);
62: ELSE
63: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
64: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );
65: message_text := 'The merge is done in block CSP_CMERGE_BB8';

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

59: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );
60: message_text := 'The locking is done in block CSP_CMERGE_BB8';
61: arp_message.set_line(message_text);
62: ELSE
63: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
64: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );
65: message_text := 'The merge is done in block CSP_CMERGE_BB8';
66: arp_message.set_line(message_text);
67: END IF;

Line 64: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );

60: message_text := 'The locking is done in block CSP_CMERGE_BB8';
61: arp_message.set_line(message_text);
62: ELSE
63: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
64: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );
65: message_text := 'The merge is done in block CSP_CMERGE_BB8';
66: arp_message.set_line(message_text);
67: END IF;
68:

Line 66: arp_message.set_line(message_text);

62: ELSE
63: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
64: arp_message.set_token('TABLE_NAME', 'CS_INCIDENTS',FALSE );
65: message_text := 'The merge is done in block CSP_CMERGE_BB8';
66: arp_message.set_line(message_text);
67: END IF;
68:
69: /* merge the CS_INCIDENTS table update bill_to_site_use_id */
70:

Line 72: arp_message.set_line(message_text);

68:
69: /* merge the CS_INCIDENTS table update bill_to_site_use_id */
70:
71: message_text := '***-- Procedure CS_MERGE_BILL_TO_SITE_ID --**';
72: arp_message.set_line(message_text);
73:
74: CS_MERGE_BILL_TO_SITE_ID( req_id, set_number, process_mode );
75:
76: message_text := '***-- End CS_MERGE_BILL_TO_SITE_ID --**';

Line 77: arp_message.set_line(message_text);

73:
74: CS_MERGE_BILL_TO_SITE_ID( req_id, set_number, process_mode );
75:
76: message_text := '***-- End CS_MERGE_BILL_TO_SITE_ID --**';
77: arp_message.set_line(message_text);
78:
79: /* merge the CS_INCIDENTS table update install_site_use_id */
80:
81: message_text := '***-- Procedure CS_MERGE_INSTALL_SITE_ID --**';

Line 82: arp_message.set_line(message_text);

78:
79: /* merge the CS_INCIDENTS table update install_site_use_id */
80:
81: message_text := '***-- Procedure CS_MERGE_INSTALL_SITE_ID --**';
82: arp_message.set_line(message_text);
83:
84: CS_MERGE_INSTALL_SITE_ID( req_id, set_number, process_mode );
85:
86: message_text := '***-- End CS_MERGE_INSTALL_SITE_ID --**';

Line 87: arp_message.set_line(message_text);

83:
84: CS_MERGE_INSTALL_SITE_ID( req_id, set_number, process_mode );
85:
86: message_text := '***-- End CS_MERGE_INSTALL_SITE_ID --**';
87: arp_message.set_line(message_text);
88:
89: /* merge the CS_INCIDENTS table update ship_to_site_use_id */
90:
91: message_text := '***-- Procedure CS_MERGE_SHIP_TO_SITE_ID --**';

Line 92: arp_message.set_line(message_text);

88:
89: /* merge the CS_INCIDENTS table update ship_to_site_use_id */
90:
91: message_text := '***-- Procedure CS_MERGE_SHIP_TO_SITE_ID --**';
92: arp_message.set_line(message_text);
93:
94: CS_MERGE_SHIP_TO_SITE_ID( req_id, set_number, process_mode );
95:
96: message_text := '***-- End CS_MERGE_SHIP_TO_SITE_ID --**';

Line 97: arp_message.set_line(message_text);

93:
94: CS_MERGE_SHIP_TO_SITE_ID( req_id, set_number, process_mode );
95:
96: message_text := '***-- End CS_MERGE_SHIP_TO_SITE_ID --**';
97: arp_message.set_line(message_text);
98:
99:
100: /* merge the CS_INCIDENTS table update the customer_id */
101:

Line 103: arp_message.set_line(message_text);

99:
100: /* merge the CS_INCIDENTS table update the customer_id */
101:
102: message_text := '***-- Procedure CS_MERGE_CUSTOMER_ID --**';
103: arp_message.set_line(message_text);
104:
105: CS_MERGE_CUSTOMER_ID( req_id, set_number, process_mode );
106:
107: message_text := '***-- End CS_MERGE_CUSTOMER_ID --**';

Line 108: arp_message.set_line(message_text);

104:
105: CS_MERGE_CUSTOMER_ID( req_id, set_number, process_mode );
106:
107: message_text := '***-- End CS_MERGE_CUSTOMER_ID --**';
108: arp_message.set_line(message_text);
109:
110: /* The merge of CS_INCIDENTS is complete, use a cursor to
111: check to make sure all data has been updated. If not report it to the
112: log file. */

Line 120: arp_message.set_line(message_text);

116: /* Report that the process for CS_INCIDENTS is complete */
117:
118: IF ( process_mode = 'LOCK' ) Then
119: message_text := '** LOCKING completed for table CS_INCIDENTS **';
120: arp_message.set_line(message_text);
121: ELSE
122: message_text := '** MERGE completed for table CS_INCIDENTS **';
123: arp_message.set_line(message_text);
124: END IF;

Line 123: arp_message.set_line(message_text);

119: message_text := '** LOCKING completed for table CS_INCIDENTS **';
120: arp_message.set_line(message_text);
121: ELSE
122: message_text := '** MERGE completed for table CS_INCIDENTS **';
123: arp_message.set_line(message_text);
124: END IF;
125:
126: arp_message.set_line('CP_CMERGE_BB8.MERGE()-');
127:

Line 126: arp_message.set_line('CP_CMERGE_BB8.MERGE()-');

122: message_text := '** MERGE completed for table CS_INCIDENTS **';
123: arp_message.set_line(message_text);
124: END IF;
125:
126: arp_message.set_line('CP_CMERGE_BB8.MERGE()-');
127:
128: END MERGE;
129:
130: /* ------------------------------------------------------------------------*/

Line 164: arp_message.set_line(message_text);

160:
161: IF ( process_mode = 'LOCK' ) Then
162:
163: message_text := 'LOCKING the bill_to_site_use_id ( 1/6 )';
164: arp_message.set_line(message_text);
165:
166: OPEN LOCK_BILL_TO_SITE_ID ( req_id, set_number );
167: CLOSE LOCK_BILL_TO_SITE_ID;
168:

Line 170: arp_message.set_line(message_text);

166: OPEN LOCK_BILL_TO_SITE_ID ( req_id, set_number );
167: CLOSE LOCK_BILL_TO_SITE_ID;
168:
169: message_text := 'Locked the bill_to_site_use_id';
170: arp_message.set_line(message_text);
171:
172: ELSE
173:
174: message_text := 'Updating the bill_to_site_use_id ( 1/6 )';

Line 175: arp_message.set_line(message_text);

171:
172: ELSE
173:
174: message_text := 'Updating the bill_to_site_use_id ( 1/6 )';
175: arp_message.set_line(message_text);
176:
177: UPDATE CS_INCIDENTS yt
178: SET
179: yt.bill_to_site_use_id =

Line 197: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');

193: WHERE RACM.PROCESS_FLAG = 'N'
194: AND RACM.REQUEST_ID = req_id
195: AND RACM.SET_NUMBER = set_number );
196:
197: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
198: number_of_rows := sql%rowcount;
199: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
200: message_text := 'Done with the update of bill_to_site_use_id';
201: arp_message.set_line(message_text);

Line 199: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );

195: AND RACM.SET_NUMBER = set_number );
196:
197: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
198: number_of_rows := sql%rowcount;
199: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
200: message_text := 'Done with the update of bill_to_site_use_id';
201: arp_message.set_line(message_text);
202:
203: END IF;

Line 201: arp_message.set_line(message_text);

197: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
198: number_of_rows := sql%rowcount;
199: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
200: message_text := 'Done with the update of bill_to_site_use_id';
201: arp_message.set_line(message_text);
202:
203: END IF;
204:
205: EXCEPTION

Line 210: arp_message.set_line(message_text);

206: WHEN NO_DATA_FOUND THEN
207:
208: message_text :=
209: 'Bill_to_site_use_id NOT found -- proceeding *** ';
210: arp_message.set_line(message_text);
211: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
212: number_of_rows := sql%rowcount;
213: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
214: message_text := 'Done with the update of bill_to_site_use_id';

Line 211: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');

207:
208: message_text :=
209: 'Bill_to_site_use_id NOT found -- proceeding *** ';
210: arp_message.set_line(message_text);
211: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
212: number_of_rows := sql%rowcount;
213: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
214: message_text := 'Done with the update of bill_to_site_use_id';
215: arp_message.set_line(message_text);

Line 213: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );

209: 'Bill_to_site_use_id NOT found -- proceeding *** ';
210: arp_message.set_line(message_text);
211: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
212: number_of_rows := sql%rowcount;
213: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
214: message_text := 'Done with the update of bill_to_site_use_id';
215: arp_message.set_line(message_text);
216:
217: WHEN OTHERS THEN

Line 215: arp_message.set_line(message_text);

211: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
212: number_of_rows := sql%rowcount;
213: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
214: message_text := 'Done with the update of bill_to_site_use_id';
215: arp_message.set_line(message_text);
216:
217: WHEN OTHERS THEN
218:
219: message_text := SUBSTR(SQLERRM,1,70);

Line 220: arp_message.set_error('CS_MERGE_BILL_TO_SITE_ID',

216:
217: WHEN OTHERS THEN
218:
219: message_text := SUBSTR(SQLERRM,1,70);
220: arp_message.set_error('CS_MERGE_BILL_TO_SITE_ID',
221: message_text);
222: raise;
223:
224: END CS_MERGE_BILL_TO_SITE_ID;

Line 256: arp_message.set_line(message_text);

252: BEGIN
253: IF ( process_mode = 'LOCK' ) Then
254:
255: message_text := 'LOCKING the install_site_use_id ( 2/6 )';
256: arp_message.set_line(message_text);
257:
258: OPEN LOCK_INSTALL_SITE_ID ( req_id, set_number );
259: CLOSE LOCK_INSTALL_SITE_ID;
260:

Line 262: arp_message.set_line(message_text);

258: OPEN LOCK_INSTALL_SITE_ID ( req_id, set_number );
259: CLOSE LOCK_INSTALL_SITE_ID;
260:
261: message_text := 'Done locking Install_site_use_id';
262: arp_message.set_line(message_text);
263:
264: ELSE
265:
266: message_text :=

Line 268: arp_message.set_line(message_text);

264: ELSE
265:
266: message_text :=
267: 'Starting to update the install_site_use_id ( 2/6 )';
268: arp_message.set_line(message_text);
269:
270: UPDATE CS_INCIDENTS yt
271: SET
272: yt.install_site_use_id =

Line 290: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');

286: WHERE RACM.PROCESS_FLAG = 'N'
287: AND RACM.REQUEST_ID = req_id
288: AND RACM.SET_NUMBER = set_number );
289:
290: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
291: number_of_rows := sql%rowcount;
292: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
293: message_text := 'Done with the update of Install_site_use_id';
294: arp_message.set_line(message_text);

Line 292: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );

288: AND RACM.SET_NUMBER = set_number );
289:
290: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
291: number_of_rows := sql%rowcount;
292: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
293: message_text := 'Done with the update of Install_site_use_id';
294: arp_message.set_line(message_text);
295:
296: END IF;

Line 294: arp_message.set_line(message_text);

290: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
291: number_of_rows := sql%rowcount;
292: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
293: message_text := 'Done with the update of Install_site_use_id';
294: arp_message.set_line(message_text);
295:
296: END IF;
297:
298: EXCEPTION

Line 303: arp_message.set_line(message_text);

299: WHEN NO_DATA_FOUND THEN
300:
301: message_text :=
302: 'Install_site_use_id NOT found -- proceeding ***';
303: arp_message.set_line(message_text);
304: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
305: number_of_rows := sql%rowcount;
306: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
307: message_text := 'Done with the update of Install_site_use_id';

Line 304: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');

300:
301: message_text :=
302: 'Install_site_use_id NOT found -- proceeding ***';
303: arp_message.set_line(message_text);
304: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
305: number_of_rows := sql%rowcount;
306: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
307: message_text := 'Done with the update of Install_site_use_id';
308: arp_message.set_line(message_text);

Line 306: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );

302: 'Install_site_use_id NOT found -- proceeding ***';
303: arp_message.set_line(message_text);
304: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
305: number_of_rows := sql%rowcount;
306: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
307: message_text := 'Done with the update of Install_site_use_id';
308: arp_message.set_line(message_text);
309:
310: WHEN OTHERS THEN

Line 308: arp_message.set_line(message_text);

304: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
305: number_of_rows := sql%rowcount;
306: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
307: message_text := 'Done with the update of Install_site_use_id';
308: arp_message.set_line(message_text);
309:
310: WHEN OTHERS THEN
311:
312: message_text := SUBSTR(SQLERRM,1,70);

Line 313: arp_message.set_error('CS_MERGE_INSTALL_SITE_ID',

309:
310: WHEN OTHERS THEN
311:
312: message_text := SUBSTR(SQLERRM,1,70);
313: arp_message.set_error('CS_MERGE_INSTALL_SITE_ID',
314: message_text);
315: raise;
316:
317: END CS_MERGE_INSTALL_SITE_ID;

Line 349: arp_message.set_line(message_text);

345: BEGIN
346: IF ( process_mode = 'LOCK' ) Then
347:
348: message_text := 'LOCKING the ship_to_site_use_id ( 3/6 )';
349: arp_message.set_line(message_text);
350:
351: OPEN LOCK_SHIP_SITE_ID ( req_id, set_number );
352: CLOSE LOCK_SHIP_SITE_ID;
353:

Line 355: arp_message.set_line(message_text);

351: OPEN LOCK_SHIP_SITE_ID ( req_id, set_number );
352: CLOSE LOCK_SHIP_SITE_ID;
353:
354: message_text := 'Done locking ship_to_site_use_id';
355: arp_message.set_line(message_text);
356:
357: ELSE
358:
359: message_text := 'Starting to update the ship_to_site_use_id ( 3/6 )';

Line 360: arp_message.set_line(message_text);

356:
357: ELSE
358:
359: message_text := 'Starting to update the ship_to_site_use_id ( 3/6 )';
360: arp_message.set_line(message_text);
361:
362: UPDATE CS_INCIDENTS yt
363: SET
364: yt.ship_to_site_use_id =

Line 382: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');

378: WHERE RACM.PROCESS_FLAG = 'N'
379: AND RACM.REQUEST_ID = req_id
380: AND RACM.SET_NUMBER = set_number );
381:
382: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
383: number_of_rows := sql%rowcount;
384: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
385: message_text := 'Done with the update of ship_to_site_use_id';
386: arp_message.set_line(message_text);

Line 384: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );

380: AND RACM.SET_NUMBER = set_number );
381:
382: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
383: number_of_rows := sql%rowcount;
384: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
385: message_text := 'Done with the update of ship_to_site_use_id';
386: arp_message.set_line(message_text);
387:
388: END IF;

Line 386: arp_message.set_line(message_text);

382: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
383: number_of_rows := sql%rowcount;
384: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
385: message_text := 'Done with the update of ship_to_site_use_id';
386: arp_message.set_line(message_text);
387:
388: END IF;
389:
390: EXCEPTION

Line 394: arp_message.set_line(message_text);

390: EXCEPTION
391: WHEN NO_DATA_FOUND THEN
392:
393: message_text := 'ship_to_site_use_id NOT found -- proceeding ***';
394: arp_message.set_line(message_text);
395: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
396: number_of_rows := sql%rowcount;
397: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
398: message_text := 'Done with the update of ship_to_site_use_id';

Line 395: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');

391: WHEN NO_DATA_FOUND THEN
392:
393: message_text := 'ship_to_site_use_id NOT found -- proceeding ***';
394: arp_message.set_line(message_text);
395: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
396: number_of_rows := sql%rowcount;
397: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
398: message_text := 'Done with the update of ship_to_site_use_id';
399: arp_message.set_line(message_text);

Line 397: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );

393: message_text := 'ship_to_site_use_id NOT found -- proceeding ***';
394: arp_message.set_line(message_text);
395: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
396: number_of_rows := sql%rowcount;
397: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
398: message_text := 'Done with the update of ship_to_site_use_id';
399: arp_message.set_line(message_text);
400:
401: WHEN OTHERS THEN

Line 399: arp_message.set_line(message_text);

395: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
396: number_of_rows := sql%rowcount;
397: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
398: message_text := 'Done with the update of ship_to_site_use_id';
399: arp_message.set_line(message_text);
400:
401: WHEN OTHERS THEN
402:
403: message_text := SUBSTR(SQLERRM,1,70);

Line 404: arp_message.set_error('CS_MERGE_SHIP_TO_SITE_ID',

400:
401: WHEN OTHERS THEN
402:
403: message_text := SUBSTR(SQLERRM,1,70);
404: arp_message.set_error('CS_MERGE_SHIP_TO_SITE_ID',
405: message_text);
406: raise;
407:
408: END CS_MERGE_SHIP_TO_SITE_ID;

Line 439: arp_message.set_line(message_text);

435: BEGIN
436: IF ( process_mode = 'LOCK' ) Then
437:
438: message_text := 'LOCKING the customer_id ( 6/6 )';
439: arp_message.set_line(message_text);
440:
441: OPEN LOCK_CUSTOMER_ID ( req_id, set_number );
442: CLOSE LOCK_CUSTOMER_ID;
443:

Line 445: arp_message.set_line(message_text);

441: OPEN LOCK_CUSTOMER_ID ( req_id, set_number );
442: CLOSE LOCK_CUSTOMER_ID;
443:
444: message_text := 'Done locking customer_id';
445: arp_message.set_line(message_text);
446:
447: ELSE
448:
449: message_text := 'Starting to update the customer_id ( 6/6 )';

Line 450: arp_message.set_line(message_text);

446:
447: ELSE
448:
449: message_text := 'Starting to update the customer_id ( 6/6 )';
450: arp_message.set_line(message_text);
451:
452: UPDATE CS_INCIDENTS yt
453: SET
454: yt.customer_id = ( SELECT DISTINCT RACM.CUSTOMER_ID

Line 470: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');

466: WHERE RACM.PROCESS_FLAG = 'N'
467: AND RACM.REQUEST_ID = req_id
468: AND RACM.SET_NUMBER = set_number );
469:
470: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
471: number_of_rows := sql%rowcount;
472: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
473: message_text := 'Done with the update of customer_id';
474: arp_message.set_line(message_text);

Line 472: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );

468: AND RACM.SET_NUMBER = set_number );
469:
470: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
471: number_of_rows := sql%rowcount;
472: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
473: message_text := 'Done with the update of customer_id';
474: arp_message.set_line(message_text);
475:
476: END IF;

Line 474: arp_message.set_line(message_text);

470: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
471: number_of_rows := sql%rowcount;
472: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
473: message_text := 'Done with the update of customer_id';
474: arp_message.set_line(message_text);
475:
476: END IF;
477:
478: EXCEPTION

Line 482: arp_message.set_line(message_text);

478: EXCEPTION
479: WHEN NO_DATA_FOUND THEN
480:
481: message_text := 'Customer_id NOT found -- proceeding *** ';
482: arp_message.set_line(message_text);
483: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
484: number_of_rows := sql%rowcount;
485: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
486: message_text := 'Done with the update of customer_id';

Line 483: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');

479: WHEN NO_DATA_FOUND THEN
480:
481: message_text := 'Customer_id NOT found -- proceeding *** ';
482: arp_message.set_line(message_text);
483: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
484: number_of_rows := sql%rowcount;
485: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
486: message_text := 'Done with the update of customer_id';
487: arp_message.set_line(message_text);

Line 485: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );

481: message_text := 'Customer_id NOT found -- proceeding *** ';
482: arp_message.set_line(message_text);
483: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
484: number_of_rows := sql%rowcount;
485: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
486: message_text := 'Done with the update of customer_id';
487: arp_message.set_line(message_text);
488:
489: WHEN OTHERS THEN

Line 487: arp_message.set_line(message_text);

483: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
484: number_of_rows := sql%rowcount;
485: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
486: message_text := 'Done with the update of customer_id';
487: arp_message.set_line(message_text);
488:
489: WHEN OTHERS THEN
490:
491: message_text := SUBSTR(SQLERRM,1,70);

Line 492: arp_message.set_error('CS_MERGE_CUSTOMER_ID',

488:
489: WHEN OTHERS THEN
490:
491: message_text := SUBSTR(SQLERRM,1,70);
492: arp_message.set_error('CS_MERGE_CUSTOMER_ID',
493: message_text);
494: raise;
495:
496: END CS_MERGE_CUSTOMER_ID;

Line 561: arp_message.set_line(message_text);

557: BEGIN
558: IF ( process_mode <> 'LOCK' ) Then
559:
560: message_text := '***-- Procedure CS_CHECK_MERGE_DATA --**';
561: arp_message.set_line(message_text);
562:
563:
564: OPEN CS_CHECK;
565:

Line 574: arp_message.set_line(message_text);

570:
571: EXIT WHEN CS_CHECK%NOTFOUND;
572: message_text :=
573: 'WARNING, Following Product Serial Num. has address(s) not merged ';
574: arp_message.set_line(message_text);
575: message_text := current_serial_number;
576: arp_message.set_line(message_text);
577:
578: END LOOP;

Line 576: arp_message.set_line(message_text);

572: message_text :=
573: 'WARNING, Following Product Serial Num. has address(s) not merged ';
574: arp_message.set_line(message_text);
575: message_text := current_serial_number;
576: arp_message.set_line(message_text);
577:
578: END LOOP;
579:
580: CLOSE CS_CHECK;

Line 583: arp_message.set_line(message_text);

579:
580: CLOSE CS_CHECK;
581:
582: message_text := '***-- End CS_CHECK_MERGE_DATA --**';
583: arp_message.set_line(message_text);
584:
585: END IF;
586:
587: EXCEPTION

Line 592: arp_message.set_error('CS_CHECK_MERGE_DATA',

588:
589: WHEN OTHERS THEN
590:
591: message_text := SUBSTR(SQLERRM,1,70);
592: arp_message.set_error('CS_CHECK_MERGE_DATA',
593: message_text);
594: raise;
595:
596: END CS_CHECK_MERGE_DATA;