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

Line 25: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MUT()+' );

21: FOR UPDATE NOWAIT;
22: mut_cust_flag NUMBER; /*Bug#5574255.*/
23:
24: BEGIN
25: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MUT()+' );
26: /*Bug#5574255. Modified code in such a way that LOCKING of rows of
27: MTL_UNIT_TRANSACTIONS or updation of customer_id in MTL_UNIT_TRANSACTIONS
28: happens only if there is at least one row in MTL_UNIT_TRANSACTIONS with
29: non-zero and non-null customer_id.*/

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

46: +-----------------------*/
47: /* try to lock the table first */
48: IF ( mut_cust_flag <> 0) THEN
49: IF (process_mode = 'LOCK') then
50: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
51: arp_message.set_token( 'TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE );
52:
53: OPEN C1;
54: CLOSE C1;

Line 51: arp_message.set_token( 'TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE );

47: /* try to lock the table first */
48: IF ( mut_cust_flag <> 0) THEN
49: IF (process_mode = 'LOCK') then
50: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
51: arp_message.set_token( 'TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE );
52:
53: OPEN C1;
54: CLOSE C1;
55:

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

56: ELSE
57:
58: /* customer level update */
59:
60: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
61: arp_message.set_token('TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE);
62: arp_message.set_line('customer level : customer_id');
63:
64: UPDATE MTL_UNIT_TRANSACTIONS yt

Line 61: arp_message.set_token('TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE);

57:
58: /* customer level update */
59:
60: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
61: arp_message.set_token('TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE);
62: arp_message.set_line('customer level : customer_id');
63:
64: UPDATE MTL_UNIT_TRANSACTIONS yt
65: set customer_id = (select distinct racm.customer_id

Line 62: arp_message.set_line('customer level : customer_id');

58: /* customer level update */
59:
60: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
61: arp_message.set_token('TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE);
62: arp_message.set_line('customer level : customer_id');
63:
64: UPDATE MTL_UNIT_TRANSACTIONS yt
65: set customer_id = (select distinct racm.customer_id
66: from ra_customer_merges racm

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

80:
81: g_count := sql%rowcount;
82:
83: /* Number of rows updates */
84: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
85: arp_message.set_token('NUM_ROWS', to_char(g_count));
86:
87: END IF;
88: END IF;

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

81: g_count := sql%rowcount;
82:
83: /* Number of rows updates */
84: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
85: arp_message.set_token('NUM_ROWS', to_char(g_count));
86:
87: END IF;
88: END IF;
89:

Line 90: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MUT()-' );

86:
87: END IF;
88: END IF;
89:
90: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MUT()-' );
91:
92:
93: EXCEPTION
94: when others then

Line 95: arp_message.set_error( 'INVP_CMERGE_TXHI.INV_MUT');

91:
92:
93: EXCEPTION
94: when others then
95: arp_message.set_error( 'INVP_CMERGE_TXHI.INV_MUT');
96: raise;
97:
98: END;
99: /*------------------------MTL_MOVEMENT_STATISTICS---------------------------*/

Line 140: arp_message.set_line( 'INV_CMERGE_TXHI.INV_MMS()+' );

136: FOR UPDATE NOWAIT;
137:
138: BEGIN
139:
140: arp_message.set_line( 'INV_CMERGE_TXHI.INV_MMS()+' );
141:
142:
143: +--------------------------------------------------+
144: | MTL_MOVEMENT_STATISTICS |

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

146:
147:
148: IF (process_mode = 'LOCK' ) THEN
149:
150: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE' );
151: arp_message.set_token( 'TABLE_NAME', 'MTL_MOVEMENT_STATISTICS',FALSE );
152:
153:
154: -- ** Lock For Customer Level Update **

Line 151: arp_message.set_token( 'TABLE_NAME', 'MTL_MOVEMENT_STATISTICS',FALSE );

147:
148: IF (process_mode = 'LOCK' ) THEN
149:
150: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE' );
151: arp_message.set_token( 'TABLE_NAME', 'MTL_MOVEMENT_STATISTICS',FALSE );
152:
153:
154: -- ** Lock For Customer Level Update **
155: open c1;

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

162: ELSE
163:
164: -- ** CUSTOMER LEVEL UPDATE **
165:
166: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
167: arp_message.set_token('TABLE_NAME', 'MTL_MOVEMENT_STATISTICS', FALSE);
168: arp_message.set_line('customer level : customer_id');
169:
170: UPDATE mtl_movement_statistics mtl

Line 167: arp_message.set_token('TABLE_NAME', 'MTL_MOVEMENT_STATISTICS', FALSE);

163:
164: -- ** CUSTOMER LEVEL UPDATE **
165:
166: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
167: arp_message.set_token('TABLE_NAME', 'MTL_MOVEMENT_STATISTICS', FALSE);
168: arp_message.set_line('customer level : customer_id');
169:
170: UPDATE mtl_movement_statistics mtl
171: SET (ship_to_customer_id,

Line 168: arp_message.set_line('customer level : customer_id');

164: -- ** CUSTOMER LEVEL UPDATE **
165:
166: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
167: arp_message.set_token('TABLE_NAME', 'MTL_MOVEMENT_STATISTICS', FALSE);
168: arp_message.set_line('customer level : customer_id');
169:
170: UPDATE mtl_movement_statistics mtl
171: SET (ship_to_customer_id,
172: bill_to_customer_id) = (

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

195: AND rcm.set_number = set_num);
196:
197: g_count := sql%rowcount;
198: -- Number of rows updates
199: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
200: arp_message.set_token('NUM_ROWS', to_char(g_count));
201:
202:
203: -- ** SITE LEVEL UPDATE **

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

196:
197: g_count := sql%rowcount;
198: -- Number of rows updates
199: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
200: arp_message.set_token('NUM_ROWS', to_char(g_count));
201:
202:
203: -- ** SITE LEVEL UPDATE **
204: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

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

200: arp_message.set_token('NUM_ROWS', to_char(g_count));
201:
202:
203: -- ** SITE LEVEL UPDATE **
204: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
205: arp_message.set_token('TABLE_NAME', 'MTL_MOVEMENT_STATISTICS', FALSE);
206: arp_message.set_line('customer level : customer_site_id');
207:
208: UPDATE mtl_movement_statistics mtl

Line 205: arp_message.set_token('TABLE_NAME', 'MTL_MOVEMENT_STATISTICS', FALSE);

201:
202:
203: -- ** SITE LEVEL UPDATE **
204: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
205: arp_message.set_token('TABLE_NAME', 'MTL_MOVEMENT_STATISTICS', FALSE);
206: arp_message.set_line('customer level : customer_site_id');
207:
208: UPDATE mtl_movement_statistics mtl
209: SET (ship_to_site_use_id,

Line 206: arp_message.set_line('customer level : customer_site_id');

202:
203: -- ** SITE LEVEL UPDATE **
204: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
205: arp_message.set_token('TABLE_NAME', 'MTL_MOVEMENT_STATISTICS', FALSE);
206: arp_message.set_line('customer level : customer_site_id');
207:
208: UPDATE mtl_movement_statistics mtl
209: SET (ship_to_site_use_id,
210: bill_to_site_use_id) = (

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

235:
236: g_count := sql%rowcount;
237:
238: -- Number of rows updates
239: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
240: arp_message.set_token('NUM_ROWS', to_char(g_count));
241:
242: END IF;
243:

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

236: g_count := sql%rowcount;
237:
238: -- Number of rows updates
239: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
240: arp_message.set_token('NUM_ROWS', to_char(g_count));
241:
242: END IF;
243:
244: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MMS()-' );

Line 244: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MMS()-' );

240: arp_message.set_token('NUM_ROWS', to_char(g_count));
241:
242: END IF;
243:
244: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MMS()-' );
245:
246: EXCEPTION
247: when others then
248: arp_message.set_error( 'INVP_CMERGE_TXHI.INV_MMS');

Line 248: arp_message.set_error( 'INVP_CMERGE_TXHI.INV_MMS');

244: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MMS()-' );
245:
246: EXCEPTION
247: when others then
248: arp_message.set_error( 'INVP_CMERGE_TXHI.INV_MMS');
249: raise;
250:
251: END;
252: */

Line 259: arp_message.set_line( 'INVP_CMERGE_TXHI.MERGE()+' );

255:
256: PROCEDURE MERGE (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
257: BEGIN
258:
259: arp_message.set_line( 'INVP_CMERGE_TXHI.MERGE()+' );
260:
261: INV_MUT( req_id, set_num, process_mode );
262:
263: -- call INV_MMS to do customer merge on mtl_movement_statistics table

Line 270: arp_message.set_line ( 'INVP_CMERGE_TXHI.MERGE()-' );

266: -- removing the call
267: --- INV_MMS ( req_id, set_num, process_mode );
268: --
269:
270: arp_message.set_line ( 'INVP_CMERGE_TXHI.MERGE()-' );
271:
272: END MERGE;
273: end INVP_CMERGE_TXHI;