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_BB4 dependencies on ARP_MESSAGE

Line 59: arp_message.set_line('CP_CMERGE_BB4.MERGE()+');

55: BEGIN
56:
57: /* Put the header in the report to identify the block to be run */
58:
59: arp_message.set_line('CP_CMERGE_BB4.MERGE()+');
60:
61: IF ( process_mode = 'LOCK' ) Then
62: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
63: arp_message.set_token('TABLE_NAME', 'CS_TEMPLATES_INTERFACE',FALSE );

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

58:
59: arp_message.set_line('CP_CMERGE_BB4.MERGE()+');
60:
61: IF ( process_mode = 'LOCK' ) Then
62: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
63: arp_message.set_token('TABLE_NAME', 'CS_TEMPLATES_INTERFACE',FALSE );
64: message_text := 'The locking is done in block CSP_CMERGE_BB4';
65: arp_message.set_line(message_text);
66: ELSE

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

59: arp_message.set_line('CP_CMERGE_BB4.MERGE()+');
60:
61: IF ( process_mode = 'LOCK' ) Then
62: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
63: arp_message.set_token('TABLE_NAME', 'CS_TEMPLATES_INTERFACE',FALSE );
64: message_text := 'The locking is done in block CSP_CMERGE_BB4';
65: arp_message.set_line(message_text);
66: ELSE
67: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

Line 65: arp_message.set_line(message_text);

61: IF ( process_mode = 'LOCK' ) Then
62: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
63: arp_message.set_token('TABLE_NAME', 'CS_TEMPLATES_INTERFACE',FALSE );
64: message_text := 'The locking is done in block CSP_CMERGE_BB4';
65: arp_message.set_line(message_text);
66: ELSE
67: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
68: arp_message.set_token('TABLE_NAME', 'CS_TEMPLATES_INTERFACE',FALSE );
69: message_text := 'The merge is done in block CSP_CMERGE_BB4';

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

63: arp_message.set_token('TABLE_NAME', 'CS_TEMPLATES_INTERFACE',FALSE );
64: message_text := 'The locking is done in block CSP_CMERGE_BB4';
65: arp_message.set_line(message_text);
66: ELSE
67: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
68: arp_message.set_token('TABLE_NAME', 'CS_TEMPLATES_INTERFACE',FALSE );
69: message_text := 'The merge is done in block CSP_CMERGE_BB4';
70: arp_message.set_line(message_text);
71: END IF;

Line 68: arp_message.set_token('TABLE_NAME', 'CS_TEMPLATES_INTERFACE',FALSE );

64: message_text := 'The locking is done in block CSP_CMERGE_BB4';
65: arp_message.set_line(message_text);
66: ELSE
67: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
68: arp_message.set_token('TABLE_NAME', 'CS_TEMPLATES_INTERFACE',FALSE );
69: message_text := 'The merge is done in block CSP_CMERGE_BB4';
70: arp_message.set_line(message_text);
71: END IF;
72:

Line 70: arp_message.set_line(message_text);

66: ELSE
67: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
68: arp_message.set_token('TABLE_NAME', 'CS_TEMPLATES_INTERFACE',FALSE );
69: message_text := 'The merge is done in block CSP_CMERGE_BB4';
70: arp_message.set_line(message_text);
71: END IF;
72:
73: /* merge the CS_TEMPLATES_INTERFACE table update system ship to site use id */
74:

Line 76: arp_message.set_line(message_text);

72:
73: /* merge the CS_TEMPLATES_INTERFACE table update system ship to site use id */
74:
75: message_text := '***-- Procedure CS_MERGE_SYS_SHIP_SITE_ID --**';
76: arp_message.set_line(message_text);
77:
78: CS_MERGE_SYS_SHIP_SITE_ID( req_id, set_number, process_mode );
79:
80: message_text := '***-- End CS_MERGE_SYS_SHIP_SITE_ID --**';

Line 81: arp_message.set_line(message_text);

77:
78: CS_MERGE_SYS_SHIP_SITE_ID( req_id, set_number, process_mode );
79:
80: message_text := '***-- End CS_MERGE_SYS_SHIP_SITE_ID --**';
81: arp_message.set_line(message_text);
82:
83: /* merge the CS_TEMPLATES_INTERFACE table update system install site use id */
84:
85: message_text := '***-- Procedure CS_MERGE_SYS_INSTALL_SITE_ID --**';

Line 86: arp_message.set_line(message_text);

82:
83: /* merge the CS_TEMPLATES_INTERFACE table update system install site use id */
84:
85: message_text := '***-- Procedure CS_MERGE_SYS_INSTALL_SITE_ID --**';
86: arp_message.set_line(message_text);
87:
88: CS_MERGE_SYS_INSTALL_SITE_ID( req_id, set_number, process_mode );
89:
90: message_text := '***-- End CS_MERGE_SYS_INSTALL_SITE_ID --**';

Line 91: arp_message.set_line(message_text);

87:
88: CS_MERGE_SYS_INSTALL_SITE_ID( req_id, set_number, process_mode );
89:
90: message_text := '***-- End CS_MERGE_SYS_INSTALL_SITE_ID --**';
91: arp_message.set_line(message_text);
92:
93: /* merge the CS_TEMPLATES_INTERFACE table update cp ship to site use id */
94:
95: message_text := '***-- Procedure CS_MERGE_CP_SHIP_SITE_ID --**';

Line 96: arp_message.set_line(message_text);

92:
93: /* merge the CS_TEMPLATES_INTERFACE table update cp ship to site use id */
94:
95: message_text := '***-- Procedure CS_MERGE_CP_SHIP_SITE_ID --**';
96: arp_message.set_line(message_text);
97:
98: CS_MERGE_CP_SHIP_SITE_ID( req_id, set_number, process_mode );
99:
100: message_text := '***-- End CS_MERGE_CP_SHIP_SITE_ID --**';

Line 101: arp_message.set_line(message_text);

97:
98: CS_MERGE_CP_SHIP_SITE_ID( req_id, set_number, process_mode );
99:
100: message_text := '***-- End CS_MERGE_CP_SHIP_SITE_ID --**';
101: arp_message.set_line(message_text);
102:
103: /* merge the CS_TEMPLATES_INTERFACE table update cp install site use id */
104:
105: message_text := '***-- Procedure CS_MERGE_CP_INSTALL_SITE_ID --**';

Line 106: arp_message.set_line(message_text);

102:
103: /* merge the CS_TEMPLATES_INTERFACE table update cp install site use id */
104:
105: message_text := '***-- Procedure CS_MERGE_CP_INSTALL_SITE_ID --**';
106: arp_message.set_line(message_text);
107:
108: CS_MERGE_CP_INSTALL_SITE_ID( req_id, set_number, process_mode );
109:
110: message_text := '***-- End CS_MERGE_CP_INSTALL_SITE_ID --**';

Line 111: arp_message.set_line(message_text);

107:
108: CS_MERGE_CP_INSTALL_SITE_ID( req_id, set_number, process_mode );
109:
110: message_text := '***-- End CS_MERGE_CP_INSTALL_SITE_ID --**';
111: arp_message.set_line(message_text);
112:
113: /* merge the CS_TEMPLATES_INTERFACE table update the customer_id */
114:
115: message_text := '***-- Procedure CS_MERGE_CUSTOMER_ID --**';

Line 116: arp_message.set_line(message_text);

112:
113: /* merge the CS_TEMPLATES_INTERFACE table update the customer_id */
114:
115: message_text := '***-- Procedure CS_MERGE_CUSTOMER_ID --**';
116: arp_message.set_line(message_text);
117:
118: CS_MERGE_CUSTOMER_ID( req_id, set_number, process_mode );
119:
120: message_text := '***-- End CS_MERGE_CUSTOMER_ID --**';

Line 121: arp_message.set_line(message_text);

117:
118: CS_MERGE_CUSTOMER_ID( req_id, set_number, process_mode );
119:
120: message_text := '***-- End CS_MERGE_CUSTOMER_ID --**';
121: arp_message.set_line(message_text);
122:
123: /* That the merge of CS_TEMPLATES_INTERFACE is complete, use a cursor to
124: check to make sure all data has been updated. If not report it to the
125: log file. */

Line 133: arp_message.set_line(message_text);

129: /* Report that the process for CS_TEMPLATES_INTERFACE is complete */
130:
131: IF ( process_mode = 'LOCK' ) Then
132: message_text := '** LOCKING completed for table CS_TEMPLATES_INTERFACE **';
133: arp_message.set_line(message_text);
134: ELSE
135: message_text := '** MERGE completed for table CS_TEMPLATES_INTERFACE **';
136: arp_message.set_line(message_text);
137: END IF;

Line 136: arp_message.set_line(message_text);

132: message_text := '** LOCKING completed for table CS_TEMPLATES_INTERFACE **';
133: arp_message.set_line(message_text);
134: ELSE
135: message_text := '** MERGE completed for table CS_TEMPLATES_INTERFACE **';
136: arp_message.set_line(message_text);
137: END IF;
138:
139: arp_message.set_line('CP_CMERGE_BB4.MERGE()-');
140:

Line 139: arp_message.set_line('CP_CMERGE_BB4.MERGE()-');

135: message_text := '** MERGE completed for table CS_TEMPLATES_INTERFACE **';
136: arp_message.set_line(message_text);
137: END IF;
138:
139: arp_message.set_line('CP_CMERGE_BB4.MERGE()-');
140:
141: END MERGE;
142:
143: /* -----------------------------------------------------------------------------*/

Line 177: arp_message.set_line(message_text);

173:
174: IF ( process_mode = 'LOCK' ) Then
175:
176: message_text := 'LOCKING the system_ship_to_site_use_id ( 1/5 )';
177: arp_message.set_line(message_text);
178:
179: OPEN LOCK_SYS_SHIP_USE_ID ( req_id, set_number );
180: CLOSE LOCK_SYS_SHIP_USE_ID;
181:

Line 183: arp_message.set_line(message_text);

179: OPEN LOCK_SYS_SHIP_USE_ID ( req_id, set_number );
180: CLOSE LOCK_SYS_SHIP_USE_ID;
181:
182: message_text := 'Locked the system_ship_to_site_use_id';
183: arp_message.set_line(message_text);
184:
185: ELSE
186:
187: message_text := 'Updating the system_ship_to_site_use_id ( 1/5 )';

Line 188: arp_message.set_line(message_text);

184:
185: ELSE
186:
187: message_text := 'Updating the system_ship_to_site_use_id ( 1/5 )';
188: arp_message.set_line(message_text);
189:
190: UPDATE CS_TEMPLATES_INTERFACE yt
191: SET
192: yt.system_ship_to_site_use_id =

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

203: WHERE RACM.PROCESS_FLAG = 'N'
204: AND RACM.REQUEST_ID = req_id
205: AND RACM.SET_NUMBER = set_number );
206:
207: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
208: number_of_rows := sql%rowcount;
209: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
210: message_text := 'Done with the update of system_ship_to_site_use_id';
211: arp_message.set_line(message_text);

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

205: AND RACM.SET_NUMBER = set_number );
206:
207: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
208: number_of_rows := sql%rowcount;
209: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
210: message_text := 'Done with the update of system_ship_to_site_use_id';
211: arp_message.set_line(message_text);
212:
213: END IF;

Line 211: arp_message.set_line(message_text);

207: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
208: number_of_rows := sql%rowcount;
209: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
210: message_text := 'Done with the update of system_ship_to_site_use_id';
211: arp_message.set_line(message_text);
212:
213: END IF;
214:
215: EXCEPTION

Line 220: arp_message.set_line(message_text);

216: WHEN NO_DATA_FOUND THEN
217:
218: message_text :=
219: 'System_ship_to_site_use_id NOT found -- proceeding *** ';
220: arp_message.set_line(message_text);
221: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
222: number_of_rows := sql%rowcount;
223: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
224: message_text := 'Done with the update of system_ship_to_site_use_id';

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

217:
218: message_text :=
219: 'System_ship_to_site_use_id NOT found -- proceeding *** ';
220: arp_message.set_line(message_text);
221: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
222: number_of_rows := sql%rowcount;
223: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
224: message_text := 'Done with the update of system_ship_to_site_use_id';
225: arp_message.set_line(message_text);

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

219: 'System_ship_to_site_use_id NOT found -- proceeding *** ';
220: arp_message.set_line(message_text);
221: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
222: number_of_rows := sql%rowcount;
223: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
224: message_text := 'Done with the update of system_ship_to_site_use_id';
225: arp_message.set_line(message_text);
226:
227: WHEN OTHERS THEN

Line 225: arp_message.set_line(message_text);

221: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
222: number_of_rows := sql%rowcount;
223: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
224: message_text := 'Done with the update of system_ship_to_site_use_id';
225: arp_message.set_line(message_text);
226:
227: WHEN OTHERS THEN
228:
229: message_text := SUBSTR(SQLERRM,1,70);

Line 230: arp_message.set_error('CS_MERGE_SYS_SHIP_SITE_ID',

226:
227: WHEN OTHERS THEN
228:
229: message_text := SUBSTR(SQLERRM,1,70);
230: arp_message.set_error('CS_MERGE_SYS_SHIP_SITE_ID',
231: message_text);
232: raise;
233:
234: END CS_MERGE_SYS_SHIP_SITE_ID;

Line 266: arp_message.set_line(message_text);

262: BEGIN
263: IF ( process_mode = 'LOCK' ) Then
264:
265: message_text := 'LOCKING the system_install_site_use_id ( 2/5 )';
266: arp_message.set_line(message_text);
267:
268: OPEN LOCK_SYS_INSTALL_SITE_ID ( req_id, set_number );
269: CLOSE LOCK_SYS_INSTALL_SITE_ID;
270:

Line 272: arp_message.set_line(message_text);

268: OPEN LOCK_SYS_INSTALL_SITE_ID ( req_id, set_number );
269: CLOSE LOCK_SYS_INSTALL_SITE_ID;
270:
271: message_text := 'Done locking system_install_site_use_id';
272: arp_message.set_line(message_text);
273:
274: ELSE
275:
276: message_text :=

Line 278: arp_message.set_line(message_text);

274: ELSE
275:
276: message_text :=
277: 'Starting to update the system_install_site_use_id ( 2/5 )';
278: arp_message.set_line(message_text);
279:
280: UPDATE CS_TEMPLATES_INTERFACE yt
281: SET
282: yt.system_install_site_use_id =

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

293: WHERE RACM.PROCESS_FLAG = 'N'
294: AND RACM.REQUEST_ID = req_id
295: AND RACM.SET_NUMBER = set_number );
296:
297: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
298: number_of_rows := sql%rowcount;
299: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
300: message_text := 'Done with the update of system_install_site_use_id';
301: arp_message.set_line(message_text);

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

295: AND RACM.SET_NUMBER = set_number );
296:
297: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
298: number_of_rows := sql%rowcount;
299: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
300: message_text := 'Done with the update of system_install_site_use_id';
301: arp_message.set_line(message_text);
302:
303: END IF;

Line 301: arp_message.set_line(message_text);

297: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
298: number_of_rows := sql%rowcount;
299: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
300: message_text := 'Done with the update of system_install_site_use_id';
301: arp_message.set_line(message_text);
302:
303: END IF;
304:
305: EXCEPTION

Line 310: arp_message.set_line(message_text);

306: WHEN NO_DATA_FOUND THEN
307:
308: message_text :=
309: 'System_install_site_use_id NOT found -- proceeding ***';
310: arp_message.set_line(message_text);
311: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
312: number_of_rows := sql%rowcount;
313: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
314: message_text := 'Done with the update of system_install_site_use_id';

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

307:
308: message_text :=
309: 'System_install_site_use_id NOT found -- proceeding ***';
310: arp_message.set_line(message_text);
311: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
312: number_of_rows := sql%rowcount;
313: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
314: message_text := 'Done with the update of system_install_site_use_id';
315: arp_message.set_line(message_text);

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

309: 'System_install_site_use_id NOT found -- proceeding ***';
310: arp_message.set_line(message_text);
311: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
312: number_of_rows := sql%rowcount;
313: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
314: message_text := 'Done with the update of system_install_site_use_id';
315: arp_message.set_line(message_text);
316:
317: WHEN OTHERS THEN

Line 315: arp_message.set_line(message_text);

311: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
312: number_of_rows := sql%rowcount;
313: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
314: message_text := 'Done with the update of system_install_site_use_id';
315: arp_message.set_line(message_text);
316:
317: WHEN OTHERS THEN
318:
319: message_text := SUBSTR(SQLERRM,1,70);

Line 320: arp_message.set_error('CS_MERGE_SYS_INSTALL_SITE_ID',

316:
317: WHEN OTHERS THEN
318:
319: message_text := SUBSTR(SQLERRM,1,70);
320: arp_message.set_error('CS_MERGE_SYS_INSTALL_SITE_ID',
321: message_text);
322: raise;
323:
324: END CS_MERGE_SYS_INSTALL_SITE_ID;

Line 356: arp_message.set_line(message_text);

352: BEGIN
353: IF ( process_mode = 'LOCK' ) Then
354:
355: message_text := 'LOCKING the cp_ship_to_site_use_id ( 3/5 )';
356: arp_message.set_line(message_text);
357:
358: OPEN LOCK_CP_SHIP_SITE_ID ( req_id, set_number );
359: CLOSE LOCK_CP_SHIP_SITE_ID;
360:

Line 362: arp_message.set_line(message_text);

358: OPEN LOCK_CP_SHIP_SITE_ID ( req_id, set_number );
359: CLOSE LOCK_CP_SHIP_SITE_ID;
360:
361: message_text := 'Done locking cp_ship_to_site_use_id';
362: arp_message.set_line(message_text);
363:
364: ELSE
365:
366: message_text := 'Starting to update the cp_ship_to_site_use_id ( 3/5 )';

Line 367: arp_message.set_line(message_text);

363:
364: ELSE
365:
366: message_text := 'Starting to update the cp_ship_to_site_use_id ( 3/5 )';
367: arp_message.set_line(message_text);
368:
369: UPDATE CS_TEMPLATES_INTERFACE yt
370: SET
371: yt.cp_ship_to_site_use_id =

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

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

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

384: AND RACM.SET_NUMBER = set_number );
385:
386: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
387: number_of_rows := sql%rowcount;
388: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
389: message_text := 'Done with the update of cp_ship_to_site_use_id';
390: arp_message.set_line(message_text);
391:
392: END IF;

Line 390: arp_message.set_line(message_text);

386: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
387: number_of_rows := sql%rowcount;
388: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
389: message_text := 'Done with the update of cp_ship_to_site_use_id';
390: arp_message.set_line(message_text);
391:
392: END IF;
393:
394: EXCEPTION

Line 398: arp_message.set_line(message_text);

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

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

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

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

397: message_text := 'Cp_ship_to_site_use_id NOT found -- proceeding ***';
398: arp_message.set_line(message_text);
399: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
400: number_of_rows := sql%rowcount;
401: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
402: message_text := 'Done with the update of cp_ship_to_site_use_id';
403: arp_message.set_line(message_text);
404:
405: WHEN OTHERS THEN

Line 403: arp_message.set_line(message_text);

399: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
400: number_of_rows := sql%rowcount;
401: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
402: message_text := 'Done with the update of cp_ship_to_site_use_id';
403: arp_message.set_line(message_text);
404:
405: WHEN OTHERS THEN
406:
407: message_text := SUBSTR(SQLERRM,1,70);

Line 408: arp_message.set_error('CS_MERGE_CP_SHIP_SITE_ID',

404:
405: WHEN OTHERS THEN
406:
407: message_text := SUBSTR(SQLERRM,1,70);
408: arp_message.set_error('CS_MERGE_CP_SHIP_SITE_ID',
409: message_text);
410: raise;
411:
412: END CS_MERGE_CP_SHIP_SITE_ID;

Line 444: arp_message.set_line(message_text);

440: BEGIN
441: IF ( process_mode = 'LOCK' ) Then
442:
443: message_text := 'LOCKING the cp_install_site_use_id ( 4/5 )';
444: arp_message.set_line(message_text);
445:
446: OPEN LOCK_CP_INSTALL_SITE_ID ( req_id, set_number );
447: CLOSE LOCK_CP_INSTALL_SITE_ID;
448:

Line 450: arp_message.set_line(message_text);

446: OPEN LOCK_CP_INSTALL_SITE_ID ( req_id, set_number );
447: CLOSE LOCK_CP_INSTALL_SITE_ID;
448:
449: message_text := 'Done locking cp_install_site_use_id';
450: arp_message.set_line(message_text);
451:
452: ELSE
453:
454: message_text :=

Line 456: arp_message.set_line(message_text);

452: ELSE
453:
454: message_text :=
455: 'Starting to update the cp_install_site_use_id ( 4/5 )';
456: arp_message.set_line(message_text);
457:
458: UPDATE CS_TEMPLATES_INTERFACE yt
459: SET
460: yt.cp_install_site_use_id =

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

471: WHERE RACM.PROCESS_FLAG = 'N'
472: AND RACM.REQUEST_ID = req_id
473: AND RACM.SET_NUMBER = set_number );
474:
475: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
476: number_of_rows := sql%rowcount;
477: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
478: message_text := 'Done with the update of cp_install_site_use_id';
479: arp_message.set_line(message_text);

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

473: AND RACM.SET_NUMBER = set_number );
474:
475: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
476: number_of_rows := sql%rowcount;
477: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
478: message_text := 'Done with the update of cp_install_site_use_id';
479: arp_message.set_line(message_text);
480:
481: END IF;

Line 479: arp_message.set_line(message_text);

475: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
476: number_of_rows := sql%rowcount;
477: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
478: message_text := 'Done with the update of cp_install_site_use_id';
479: arp_message.set_line(message_text);
480:
481: END IF;
482:
483: EXCEPTION

Line 487: arp_message.set_line(message_text);

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

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

484: WHEN NO_DATA_FOUND THEN
485:
486: message_text := 'cp_install_site_use_id NOT found -- proceeding *** ';
487: arp_message.set_line(message_text);
488: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
489: number_of_rows := sql%rowcount;
490: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
491: message_text := 'Done with the update of cp_install_site_use_id';
492: arp_message.set_line(message_text);

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

486: message_text := 'cp_install_site_use_id NOT found -- proceeding *** ';
487: arp_message.set_line(message_text);
488: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
489: number_of_rows := sql%rowcount;
490: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
491: message_text := 'Done with the update of cp_install_site_use_id';
492: arp_message.set_line(message_text);
493:
494: WHEN OTHERS THEN

Line 492: arp_message.set_line(message_text);

488: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
489: number_of_rows := sql%rowcount;
490: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
491: message_text := 'Done with the update of cp_install_site_use_id';
492: arp_message.set_line(message_text);
493:
494: WHEN OTHERS THEN
495:
496: message_text := SUBSTR(SQLERRM,1,70);

Line 497: arp_message.set_error('CS_MERGE_CP_INSTALL_SITE_ID',

493:
494: WHEN OTHERS THEN
495:
496: message_text := SUBSTR(SQLERRM,1,70);
497: arp_message.set_error('CS_MERGE_CP_INSTALL_SITE_ID',
498: message_text);
499: raise;
500:
501: END CS_MERGE_CP_INSTALL_SITE_ID;

Line 532: arp_message.set_line(message_text);

528: BEGIN
529: IF ( process_mode = 'LOCK' ) Then
530:
531: message_text := 'LOCKING the customer_id ( 5/5 )';
532: arp_message.set_line(message_text);
533:
534: OPEN LOCK_CUSTOMER_ID ( req_id, set_number );
535: CLOSE LOCK_CUSTOMER_ID;
536:

Line 538: arp_message.set_line(message_text);

534: OPEN LOCK_CUSTOMER_ID ( req_id, set_number );
535: CLOSE LOCK_CUSTOMER_ID;
536:
537: message_text := 'Done locking customer_id';
538: arp_message.set_line(message_text);
539:
540: ELSE
541:
542: message_text := 'Starting to update the customer_id ( 5/5 )';

Line 543: arp_message.set_line(message_text);

539:
540: ELSE
541:
542: message_text := 'Starting to update the customer_id ( 5/5 )';
543: arp_message.set_line(message_text);
544:
545: UPDATE CS_TEMPLATES_INTERFACE yt
546: SET
547: yt.customer_id = ( SELECT DISTINCT RACM.CUSTOMER_ID

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

556: WHERE RACM.PROCESS_FLAG = 'N'
557: AND RACM.REQUEST_ID = req_id
558: AND RACM.SET_NUMBER = set_number );
559:
560: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
561: number_of_rows := sql%rowcount;
562: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
563: message_text := 'Done with the update of customer_id';
564: arp_message.set_line(message_text);

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

558: AND RACM.SET_NUMBER = set_number );
559:
560: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
561: number_of_rows := sql%rowcount;
562: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
563: message_text := 'Done with the update of customer_id';
564: arp_message.set_line(message_text);
565:
566: END IF;

Line 564: arp_message.set_line(message_text);

560: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
561: number_of_rows := sql%rowcount;
562: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
563: message_text := 'Done with the update of customer_id';
564: arp_message.set_line(message_text);
565:
566: END IF;
567:
568: EXCEPTION

Line 572: arp_message.set_line(message_text);

568: EXCEPTION
569: WHEN NO_DATA_FOUND THEN
570:
571: message_text := 'Customer_id NOT found -- proceeding *** ';
572: arp_message.set_line(message_text);
573: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
574: number_of_rows := sql%rowcount;
575: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
576: message_text := 'Done with the update of customer_id';

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

569: WHEN NO_DATA_FOUND THEN
570:
571: message_text := 'Customer_id NOT found -- proceeding *** ';
572: arp_message.set_line(message_text);
573: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
574: number_of_rows := sql%rowcount;
575: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
576: message_text := 'Done with the update of customer_id';
577: arp_message.set_line(message_text);

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

571: message_text := 'Customer_id NOT found -- proceeding *** ';
572: arp_message.set_line(message_text);
573: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
574: number_of_rows := sql%rowcount;
575: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
576: message_text := 'Done with the update of customer_id';
577: arp_message.set_line(message_text);
578:
579: WHEN OTHERS THEN

Line 577: arp_message.set_line(message_text);

573: arp_message.set_name( 'CS', 'CS_ROWS_UPDATED');
574: number_of_rows := sql%rowcount;
575: arp_message.set_token( 'NUM_ROWS',to_char( number_of_rows) );
576: message_text := 'Done with the update of customer_id';
577: arp_message.set_line(message_text);
578:
579: WHEN OTHERS THEN
580:
581: message_text := SUBSTR(SQLERRM,1,70);

Line 582: arp_message.set_error('CS_MERGE_CUSTOMER_ID',

578:
579: WHEN OTHERS THEN
580:
581: message_text := SUBSTR(SQLERRM,1,70);
582: arp_message.set_error('CS_MERGE_CUSTOMER_ID',
583: message_text);
584: raise;
585:
586: END CS_MERGE_CUSTOMER_ID;

Line 659: arp_message.set_line(message_text);

655: BEGIN
656: IF ( process_mode <> 'LOCK' ) Then
657:
658: message_text := '***-- Procedure CS_CHECK_MERGE_DATA --**';
659: arp_message.set_line(message_text);
660:
661:
662: OPEN CS_CHECK;
663:

Line 672: arp_message.set_line(message_text);

668:
669: EXIT WHEN CS_CHECK%NOTFOUND;
670: message_text :=
671: 'WARNING, Following access templates interface id has address(s) not merged ';
672: arp_message.set_line(message_text);
673: message_text := templates_interface_id;
674: arp_message.set_line(message_text);
675:
676: END LOOP;

Line 674: arp_message.set_line(message_text);

670: message_text :=
671: 'WARNING, Following access templates interface id has address(s) not merged ';
672: arp_message.set_line(message_text);
673: message_text := templates_interface_id;
674: arp_message.set_line(message_text);
675:
676: END LOOP;
677:
678: CLOSE CS_CHECK;

Line 681: arp_message.set_line(message_text);

677:
678: CLOSE CS_CHECK;
679:
680: message_text := '***-- End CS_CHECK_MERGE_DATA --**';
681: arp_message.set_line(message_text);
682:
683: END IF;
684:
685: EXCEPTION

Line 690: arp_message.set_error('CS_CHECK_MERGE_DATA',

686:
687: WHEN OTHERS THEN
688:
689: message_text := SUBSTR(SQLERRM,1,70);
690: arp_message.set_error('CS_CHECK_MERGE_DATA',
691: message_text);
692: raise;
693:
694: END CS_CHECK_MERGE_DATA;