APPS.CSP_CMERGE_BB3 dependencies on ARP_MESSAGE

Line 54: arp_message.set_line('CP_CMERGE_BB3.MERGE()+');

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

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

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

Line 58: arp_message.set_token('TABLE_NAME', 'CS_SYSTEMS',FALSE );

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

Line 60: arp_message.set_line(message_text);

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

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

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

Line 63: arp_message.set_token('TABLE_NAME', 'CS_SYSTEMS',FALSE );

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

Line 65: arp_message.set_line(message_text);

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

Line 71: arp_message.set_line(message_text);

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

Line 76: arp_message.set_line(message_text);

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

Line 81: arp_message.set_line(message_text);

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

Line 86: arp_message.set_line(message_text);

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

Line 91: arp_message.set_line(message_text);

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

Line 96: arp_message.set_line(message_text);

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

Line 101: arp_message.set_line(message_text);

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

Line 106: arp_message.set_line(message_text);

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

Line 118: arp_message.set_line(message_text);

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

Line 121: arp_message.set_line(message_text);

117: message_text := '** LOCKING completed for table CS_SYSTEMS **';
118: arp_message.set_line(message_text);
119: ELSE
120: message_text := '** MERGE completed for table CS_SYSTEMS **';
121: arp_message.set_line(message_text);
122: END IF;
123:
124: arp_message.set_line('CP_CMERGE_BB3.MERGE()-');
125:

Line 124: arp_message.set_line('CP_CMERGE_BB3.MERGE()-');

120: message_text := '** MERGE completed for table CS_SYSTEMS **';
121: arp_message.set_line(message_text);
122: END IF;
123:
124: arp_message.set_line('CP_CMERGE_BB3.MERGE()-');
125:
126: END MERGE;
127:
128: /* -----------------------------------------------------------------------------*/

Line 162: arp_message.set_line(message_text);

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

Line 168: arp_message.set_line(message_text);

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

Line 173: arp_message.set_line(message_text);

169:
170: ELSE
171:
172: message_text := 'Updating the bill_to_site_use_id ( 1/4 )';
173: arp_message.set_line(message_text);
174:
175: UPDATE CS_SYSTEMS yt
176: SET
177: yt.bill_to_site_use_id =

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

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

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

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

Line 199: arp_message.set_line(message_text);

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

Line 208: arp_message.set_line(message_text);

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

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

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

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

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

Line 213: arp_message.set_line(message_text);

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

Line 218: arp_message.set_error('CS_MERGE_BILL_TO_SITE_ID',

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

Line 254: arp_message.set_line(message_text);

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

Line 260: arp_message.set_line(message_text);

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

Line 266: arp_message.set_line(message_text);

262: ELSE
263:
264: message_text :=
265: 'Starting to update the install_site_use_id ( 2/4 )';
266: arp_message.set_line(message_text);
267:
268: UPDATE CS_SYSTEMS yt
269: SET
270: yt.install_site_use_id =

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

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

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

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

Line 292: arp_message.set_line(message_text);

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

Line 301: arp_message.set_line(message_text);

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

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

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

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

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

Line 306: arp_message.set_line(message_text);

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

Line 311: arp_message.set_error('CS_MERGE_INSTALL_SITE_ID',

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

Line 347: arp_message.set_line(message_text);

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

Line 353: arp_message.set_line(message_text);

349: OPEN LOCK_SHIP_SITE_ID ( req_id, set_number );
350: CLOSE LOCK_SHIP_SITE_ID;
351:
352: message_text := 'Done locking Ship_to_site_use_id';
353: arp_message.set_line(message_text);
354:
355: ELSE
356:
357: message_text := 'Starting to update the Ship_use_site_id ( 3/4 )';

Line 358: arp_message.set_line(message_text);

354:
355: ELSE
356:
357: message_text := 'Starting to update the Ship_use_site_id ( 3/4 )';
358: arp_message.set_line(message_text);
359:
360: UPDATE CS_SYSTEMS yt
361: SET
362: yt.ship_to_site_use_id =

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

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

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

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

Line 384: arp_message.set_line(message_text);

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

Line 392: arp_message.set_line(message_text);

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

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

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

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

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

Line 397: arp_message.set_line(message_text);

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

Line 402: arp_message.set_error('CS_MERGE_SHIP_TO_SITE_ID',

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

Line 438: arp_message.set_line(message_text);

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

Line 444: arp_message.set_line(message_text);

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

Line 449: arp_message.set_line(message_text);

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

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

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

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

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

Line 473: arp_message.set_line(message_text);

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

Line 481: arp_message.set_line(message_text);

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

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

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

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

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

Line 486: arp_message.set_line(message_text);

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

Line 491: arp_message.set_error('CS_MERGE_CUSTOMER_ID',

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

Line 560: arp_message.set_line(message_text);

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

Line 573: arp_message.set_line(message_text);

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

Line 575: arp_message.set_line(message_text);

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

Line 582: arp_message.set_line(message_text);

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

Line 591: arp_message.set_error('CS_CHECK_MERGE_DATA',

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