DBA Data[Home] [Help]

APPS.INVP_CMERGE_SPDM dependencies on ARP_MESSAGE

Line 49: arp_message.set_line( 'INVP_CMERGE_SPDM.INV_MD()+' );

45: FOR UPDATE NOWAIT;
46:
47:
48: BEGIN
49: arp_message.set_line( 'INVP_CMERGE_SPDM.INV_MD()+' );
50:
51: /*------------+
52: | MTL_DEMAND |
53: +------------*/

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

52: | MTL_DEMAND |
53: +------------*/
54: /* try to lock the table first */
55: IF (process_mode = 'LOCK') then
56: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
57: arp_message.set_token( 'TABLE_NAME', 'MTL_DEMAND', FALSE );
58:
59: OPEN C1;
60: CLOSE C1;

Line 57: arp_message.set_token( 'TABLE_NAME', 'MTL_DEMAND', FALSE );

53: +------------*/
54: /* try to lock the table first */
55: IF (process_mode = 'LOCK') then
56: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
57: arp_message.set_token( 'TABLE_NAME', 'MTL_DEMAND', FALSE );
58:
59: OPEN C1;
60: CLOSE C1;
61:

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

68: ELSE
69:
70: /* customer and site level */
71:
72: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
73: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
74: arp_message.set_line('site level update : ship to and bill to site use id');
75:
76: UPDATE MTL_DEMAND yt

Line 73: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);

69:
70: /* customer and site level */
71:
72: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
73: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
74: arp_message.set_line('site level update : ship to and bill to site use id');
75:
76: UPDATE MTL_DEMAND yt
77: set customer_id = (select distinct racm.customer_id

Line 74: arp_message.set_line('site level update : ship to and bill to site use id');

70: /* customer and site level */
71:
72: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
73: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
74: arp_message.set_line('site level update : ship to and bill to site use id');
75:
76: UPDATE MTL_DEMAND yt
77: set customer_id = (select distinct racm.customer_id
78: from ra_customer_merges racm

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

116:
117: g_count := sql%rowcount;
118:
119: /* Number of rows updates */
120: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
121: arp_message.set_token('NUM_ROWS', to_char(g_count));
122:
123:
124: /* site level update */

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

117: g_count := sql%rowcount;
118:
119: /* Number of rows updates */
120: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
121: arp_message.set_token('NUM_ROWS', to_char(g_count));
122:
123:
124: /* site level update */
125: /* for bill to site use id */

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

122:
123:
124: /* site level update */
125: /* for bill to site use id */
126: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
127: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
128: arp_message.set_line('site level update : bill to site use id');
129:
130: UPDATE MTL_DEMAND yt

Line 127: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);

123:
124: /* site level update */
125: /* for bill to site use id */
126: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
127: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
128: arp_message.set_line('site level update : bill to site use id');
129:
130: UPDATE MTL_DEMAND yt
131: set (customer_id,

Line 128: arp_message.set_line('site level update : bill to site use id');

124: /* site level update */
125: /* for bill to site use id */
126: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
127: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
128: arp_message.set_line('site level update : bill to site use id');
129:
130: UPDATE MTL_DEMAND yt
131: set (customer_id,
132: bill_to_site_use_id) = (select distinct racm.customer_id,

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

158:
159: g_count := sql%rowcount;
160:
161: /* Number of rows updates */
162: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
163: arp_message.set_token('NUM_ROWS', to_char(g_count));
164:
165:
166: /* site level update */

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

159: g_count := sql%rowcount;
160:
161: /* Number of rows updates */
162: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
163: arp_message.set_token('NUM_ROWS', to_char(g_count));
164:
165:
166: /* site level update */
167: /* for ship to site use id */

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

165:
166: /* site level update */
167: /* for ship to site use id */
168:
169: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
170: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
171: arp_message.set_line('site level update : ship to site use id');
172:
173: UPDATE MTL_DEMAND yt

Line 170: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);

166: /* site level update */
167: /* for ship to site use id */
168:
169: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
170: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
171: arp_message.set_line('site level update : ship to site use id');
172:
173: UPDATE MTL_DEMAND yt
174: set (customer_id,

Line 171: arp_message.set_line('site level update : ship to site use id');

167: /* for ship to site use id */
168:
169: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
170: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND',FALSE);
171: arp_message.set_line('site level update : ship to site use id');
172:
173: UPDATE MTL_DEMAND yt
174: set (customer_id,
175: ship_to_site_use_id) = (select distinct racm.customer_id,

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

201:
202: g_count := sql%rowcount;
203:
204: /* Number of rows updates */
205: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
206: arp_message.set_token('NUM_ROWS', to_char(g_count));
207:
208: /* customer level update */
209:

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

202: g_count := sql%rowcount;
203:
204: /* Number of rows updates */
205: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
206: arp_message.set_token('NUM_ROWS', to_char(g_count));
207:
208: /* customer level update */
209:
210: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

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

206: arp_message.set_token('NUM_ROWS', to_char(g_count));
207:
208: /* customer level update */
209:
210: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
211: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND', FALSE);
212: arp_message.set_line('customer level : customer_id');
213:
214: UPDATE MTL_DEMAND yt

Line 211: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND', FALSE);

207:
208: /* customer level update */
209:
210: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
211: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND', FALSE);
212: arp_message.set_line('customer level : customer_id');
213:
214: UPDATE MTL_DEMAND yt
215: set customer_id = (select distinct racm.customer_id

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

208: /* customer level update */
209:
210: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
211: arp_message.set_token('TABLE_NAME', 'MTL_DEMAND', FALSE);
212: arp_message.set_line('customer level : customer_id');
213:
214: UPDATE MTL_DEMAND yt
215: set customer_id = (select distinct racm.customer_id
216: from ra_customer_merges racm

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

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

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

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

Line 245: arp_message.set_line( 'INVP_CMERGE_SPDM.INV_MD()-' );

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

Line 250: arp_message.set_error( 'INVP_CMERGE_SPDM.INV_MD');

246:
247:
248: EXCEPTION
249: when others then
250: arp_message.set_error( 'INVP_CMERGE_SPDM.INV_MD');
251: raise;
252:
253: END;
254:

Line 261: arp_message.set_line( 'INVP_CMERGE_SPDM.MERGE()+' );

257:
258: PROCEDURE MERGE (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
259: BEGIN
260:
261: arp_message.set_line( 'INVP_CMERGE_SPDM.MERGE()+' );
262:
263: INV_MD( req_id, set_num, process_mode );
264:
265: arp_message.set_line( 'INVP_CMERGE_SPDM.MERGE()-' );

Line 265: arp_message.set_line( 'INVP_CMERGE_SPDM.MERGE()-' );

261: arp_message.set_line( 'INVP_CMERGE_SPDM.MERGE()+' );
262:
263: INV_MD( req_id, set_num, process_mode );
264:
265: arp_message.set_line( 'INVP_CMERGE_SPDM.MERGE()-' );
266:
267: END MERGE;
268: end INVP_CMERGE_SPDM;