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 48: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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