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.AR_MRC_ENGINE dependencies on STANDARD

Line 58: -- arp_standard.debug( 'AR_MRC_ENGINE.Maintain_MRC_Data(+)');

54: BEGIN
55: --{BUG4301323
56: NULL;
57: -- IF PG_DEBUG in ('Y', 'C') THEN
58: -- arp_standard.debug( 'AR_MRC_ENGINE.Maintain_MRC_Data(+)');
59: -- END IF;
60:
61: /*-----------------------------------------------------------------+
62: | Dump the input parameters for debugging purposes |

Line 66: -- arp_standard.debug('Maintain_MRC_Data: ' || ' EVENT Mode : ' || p_event_mode);

62: | Dump the input parameters for debugging purposes |
63: +-----------------------------------------------------------------*/
64:
65: -- IF PG_DEBUG in ('Y', 'C') THEN
66: -- arp_standard.debug('Maintain_MRC_Data: ' || ' EVENT Mode : ' || p_event_mode);
67: -- arp_standard.debug('Maintain_MRC_Data: ' || ' Table Name : ' || p_table_name);
68: -- arp_standard.debug('Maintain_MRC_Data: ' || ' mode : ' || p_mode);
69: -- arp_standard.debug('Maintain_MRC_Data: ' || 'key_value : ' || to_char(p_key_value));
70: -- END IF;

Line 67: -- arp_standard.debug('Maintain_MRC_Data: ' || ' Table Name : ' || p_table_name);

63: +-----------------------------------------------------------------*/
64:
65: -- IF PG_DEBUG in ('Y', 'C') THEN
66: -- arp_standard.debug('Maintain_MRC_Data: ' || ' EVENT Mode : ' || p_event_mode);
67: -- arp_standard.debug('Maintain_MRC_Data: ' || ' Table Name : ' || p_table_name);
68: -- arp_standard.debug('Maintain_MRC_Data: ' || ' mode : ' || p_mode);
69: -- arp_standard.debug('Maintain_MRC_Data: ' || 'key_value : ' || to_char(p_key_value));
70: -- END IF;
71:

Line 68: -- arp_standard.debug('Maintain_MRC_Data: ' || ' mode : ' || p_mode);

64:
65: -- IF PG_DEBUG in ('Y', 'C') THEN
66: -- arp_standard.debug('Maintain_MRC_Data: ' || ' EVENT Mode : ' || p_event_mode);
67: -- arp_standard.debug('Maintain_MRC_Data: ' || ' Table Name : ' || p_table_name);
68: -- arp_standard.debug('Maintain_MRC_Data: ' || ' mode : ' || p_mode);
69: -- arp_standard.debug('Maintain_MRC_Data: ' || 'key_value : ' || to_char(p_key_value));
70: -- END IF;
71:
72: -- IF (p_key_value is NULL) THEN

Line 69: -- arp_standard.debug('Maintain_MRC_Data: ' || 'key_value : ' || to_char(p_key_value));

65: -- IF PG_DEBUG in ('Y', 'C') THEN
66: -- arp_standard.debug('Maintain_MRC_Data: ' || ' EVENT Mode : ' || p_event_mode);
67: -- arp_standard.debug('Maintain_MRC_Data: ' || ' Table Name : ' || p_table_name);
68: -- arp_standard.debug('Maintain_MRC_Data: ' || ' mode : ' || p_mode);
69: -- arp_standard.debug('Maintain_MRC_Data: ' || 'key_value : ' || to_char(p_key_value));
70: -- END IF;
71:
72: -- IF (p_key_value is NULL) THEN
73: -- IF PG_DEBUG in ('Y', 'C') THEN

Line 74: -- arp_standard.debug('Maintain_MRC_Data: ' || 'count of value list =' || to_char(p_key_value_list.count));

70: -- END IF;
71:
72: -- IF (p_key_value is NULL) THEN
73: -- IF PG_DEBUG in ('Y', 'C') THEN
74: -- arp_standard.debug('Maintain_MRC_Data: ' || 'count of value list =' || to_char(p_key_value_list.count));
75: -- END IF;
76: -- END IF;
77:
78: /*-----------------------------------------------------------------+

Line 105: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Called with one of the supported table names ');

101: --}
102: -- ) THEN
103:
104: -- IF PG_DEBUG in ('Y', 'C') THEN
105: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Called with one of the supported table names ');
106: -- END IF;
107: /*-----------------------------------------------------------------+
108: | First we need to check if MRC is enabled. If it is than we |
109: | continue processing. If it is not then we are finished. |

Line 112: -- arp_standard.debug('Maintain_MRC_Data: ' || 'before checking to see if mrc is enabled..');

108: | First we need to check if MRC is enabled. If it is than we |
109: | continue processing. If it is not then we are finished. |
110: +-----------------------------------------------------------------*/
111: -- IF PG_DEBUG in ('Y', 'C') THEN
112: -- arp_standard.debug('Maintain_MRC_Data: ' || 'before checking to see if mrc is enabled..');
113: -- END IF;
114: -- IF (gl_ca_utility_pkg.mrc_enabled(p_sob_id => ar_mc_info.primary_sob_id,
115: -- p_org_id => ar_mc_info.org_id,
116: -- p_appl_id => 222

Line 120: -- arp_standard.debug('Maintain_MRC_Data: ' || 'MRC is enabled... ');

116: -- p_appl_id => 222
117: -- )) THEN
118:
119: -- IF PG_DEBUG in ('Y', 'C') THEN
120: -- arp_standard.debug('Maintain_MRC_Data: ' || 'MRC is enabled... ');
121: -- END IF;
122: /* initialize stucture which will be used to call the mrc api */
123: -- ar_mrc_engine.init_struct (p_table_name,
124: -- p_mode,

Line 135: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Before calling MRC api for Insertion');

131: -- IF ( p_event_mode = 'INSERT' and
132: -- p_table_name <> 'AR_DISTRIBUTIONS' and
133: -- p_table_name <> 'AR_RECEIVABLE_APPLICATIONS') THEN
134: -- IF PG_DEBUG in ('Y', 'C') THEN
135: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Before calling MRC api for Insertion');
136: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** table name ' || mc_init_rec.p_table_name);
137: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mc name ' || mc_init_rec.p_mc_table_name );
138: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** app id ' || to_char(mc_init_rec.p_application_id ) );
139: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mode ' || mc_init_rec.p_mode );

Line 136: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** table name ' || mc_init_rec.p_table_name);

132: -- p_table_name <> 'AR_DISTRIBUTIONS' and
133: -- p_table_name <> 'AR_RECEIVABLE_APPLICATIONS') THEN
134: -- IF PG_DEBUG in ('Y', 'C') THEN
135: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Before calling MRC api for Insertion');
136: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** table name ' || mc_init_rec.p_table_name);
137: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mc name ' || mc_init_rec.p_mc_table_name );
138: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** app id ' || to_char(mc_init_rec.p_application_id ) );
139: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mode ' || mc_init_rec.p_mode );
140: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** key_value ' || to_char(mc_init_rec.p_key_value) );

Line 137: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mc name ' || mc_init_rec.p_mc_table_name );

133: -- p_table_name <> 'AR_RECEIVABLE_APPLICATIONS') THEN
134: -- IF PG_DEBUG in ('Y', 'C') THEN
135: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Before calling MRC api for Insertion');
136: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** table name ' || mc_init_rec.p_table_name);
137: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mc name ' || mc_init_rec.p_mc_table_name );
138: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** app id ' || to_char(mc_init_rec.p_application_id ) );
139: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mode ' || mc_init_rec.p_mode );
140: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** key_value ' || to_char(mc_init_rec.p_key_value) );
141: -- END IF;

Line 138: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** app id ' || to_char(mc_init_rec.p_application_id ) );

134: -- IF PG_DEBUG in ('Y', 'C') THEN
135: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Before calling MRC api for Insertion');
136: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** table name ' || mc_init_rec.p_table_name);
137: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mc name ' || mc_init_rec.p_mc_table_name );
138: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** app id ' || to_char(mc_init_rec.p_application_id ) );
139: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mode ' || mc_init_rec.p_mode );
140: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** key_value ' || to_char(mc_init_rec.p_key_value) );
141: -- END IF;
142: -- BEGIN

Line 139: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mode ' || mc_init_rec.p_mode );

135: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Before calling MRC api for Insertion');
136: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** table name ' || mc_init_rec.p_table_name);
137: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mc name ' || mc_init_rec.p_mc_table_name );
138: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** app id ' || to_char(mc_init_rec.p_application_id ) );
139: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mode ' || mc_init_rec.p_mode );
140: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** key_value ' || to_char(mc_init_rec.p_key_value) );
141: -- END IF;
142: -- BEGIN
143:

Line 140: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** key_value ' || to_char(mc_init_rec.p_key_value) );

136: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** table name ' || mc_init_rec.p_table_name);
137: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mc name ' || mc_init_rec.p_mc_table_name );
138: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** app id ' || to_char(mc_init_rec.p_application_id ) );
139: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** mode ' || mc_init_rec.p_mode );
140: -- arp_standard.debug('Maintain_MRC_Data: ' || '**** key_value ' || to_char(mc_init_rec.p_key_value) );
141: -- END IF;
142: -- BEGIN
143:
144: -- ar_mc_info.insert_mc_data(

Line 156: -- arp_standard.debug('Maintain_MRC_Data: ' || SQLERRM);

152:
153: -- EXCEPTION
154: -- WHEN OTHERS THEN
155: -- IF PG_DEBUG in ('Y', 'C') THEN
156: -- arp_standard.debug('Maintain_MRC_Data: ' || SQLERRM);
157: -- arp_standard.debug('Maintain_MRC_Data: ' || 'error during Insert for ' || p_table_name);
158: -- END IF;
159: -- APP_EXCEPTION.RAISE_EXCEPTION;
160: -- END;

Line 157: -- arp_standard.debug('Maintain_MRC_Data: ' || 'error during Insert for ' || p_table_name);

153: -- EXCEPTION
154: -- WHEN OTHERS THEN
155: -- IF PG_DEBUG in ('Y', 'C') THEN
156: -- arp_standard.debug('Maintain_MRC_Data: ' || SQLERRM);
157: -- arp_standard.debug('Maintain_MRC_Data: ' || 'error during Insert for ' || p_table_name);
158: -- END IF;
159: -- APP_EXCEPTION.RAISE_EXCEPTION;
160: -- END;
161: -- END IF; /* end p_event_mode = INSERT */

Line 168: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Before calling MRC api for Update');

164: -- p_table_name <> 'AR_DISTRIBUTIONS' and
165: -- p_table_name <> 'AR_RECEIVABLE_APPLICATIONS') THEN
166:
167: -- IF PG_DEBUG in ('Y', 'C') THEN
168: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Before calling MRC api for Update');
169: -- END IF;
170: -- BEGIN
171: -- ar_mc_info.update_mc_data(
172: -- p_table_name => mc_init_rec.p_table_name,

Line 183: -- arp_standard.debug('Maintain_MRC_Data: ' || 'error during update for ' || p_table_name);

179:
180: -- EXCEPTION
181: -- WHEN OTHERS THEN
182: -- IF PG_DEBUG in ('Y', 'C') THEN
183: -- arp_standard.debug('Maintain_MRC_Data: ' || 'error during update for ' || p_table_name);
184: -- END IF;
185: -- APP_EXCEPTION.RAISE_EXCEPTION;
186: -- END;
187: -- END IF; /* end p_event_mode = UPDATE */

Line 192: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Before calling MRC api for Deletion');

188:
189: -- IF (p_event_mode = 'DELETE') THEN
190:
191: -- IF PG_DEBUG in ('Y', 'C') THEN
192: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Before calling MRC api for Deletion');
193: -- END IF;
194: -- BEGIN
195: -- ar_mc_info.delete_mc_data(
196: -- p_table_name => mc_init_rec.p_table_name,

Line 206: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Error deleting from: ' ||

202:
203: -- EXCEPTION
204: -- WHEN OTHERS THEN
205: -- IF PG_DEBUG in ('Y', 'C') THEN
206: -- arp_standard.debug('Maintain_MRC_Data: ' || 'Error deleting from: ' ||
207: -- mc_init_rec.p_mc_table_name);
208: -- END IF;
209: -- APP_EXCEPTION.RAISE_EXCEPTION;
210: -- END;

Line 217: -- arp_standard.debug( 'AR_MRC_ENGINE.Maintain_MRC_Data(-)');

213: -- END IF; /* end of mrc is enabled */
214:
215: -- END IF; /* end of checking for specific tables */
216: -- IF PG_DEBUG in ('Y', 'C') THEN
217: -- arp_standard.debug( 'AR_MRC_ENGINE.Maintain_MRC_Data(-)');
218: -- END IF;
219:
220: END Maintain_MRC_Data;
221:

Line 268: -- arp_standard.debug('AR_MRC_ENGINE.init_struct(+)');

264: BEGIN
265: --{BUG#4301323
266: NULL;
267: -- IF PG_DEBUG in ('Y', 'C') THEN
268: -- arp_standard.debug('AR_MRC_ENGINE.init_struct(+)');
269: -- arp_standard.debug('init_struct: ' || 'Table Name : ' || p_table_name);
270: -- END IF;
271:
272: /*----------------------------------+

Line 269: -- arp_standard.debug('init_struct: ' || 'Table Name : ' || p_table_name);

265: --{BUG#4301323
266: NULL;
267: -- IF PG_DEBUG in ('Y', 'C') THEN
268: -- arp_standard.debug('AR_MRC_ENGINE.init_struct(+)');
269: -- arp_standard.debug('init_struct: ' || 'Table Name : ' || p_table_name);
270: -- END IF;
271:
272: /*----------------------------------+
273: | Populate items that are the same |

Line 328: -- arp_standard.debug('AR_MRC_ENGINE.init_struct(-)');

324: -- mc_init_rec.p_mc_table_name := 'RA_MC_TRX_LINE_GL_DIST' ;
325: -- END IF;
326:
327: -- IF PG_DEBUG in ('Y', 'C') THEN
328: -- arp_standard.debug('AR_MRC_ENGINE.init_struct(-)');
329: -- END IF;
330: END init_struct;
331:
332:

Line 386: -- arp_standard.debug('AR_MRC_ENGINE.mrc_bulk_process(+)');

382: BEGIN
383: --{BUG4301323
384: NULL;
385: -- IF PG_DEBUG in ('Y', 'C') THEN
386: -- arp_standard.debug('AR_MRC_ENGINE.mrc_bulk_process(+)');
387: -- arp_standard.debug('mrc_bulk_process: ' || 'CALLING PROGRAM : ' || p_table_name);
388: -- arp_standard.debug('mrc_bulk_process: ' || 'before checking to see if mrc is enabled..');
389: -- END IF;
390: -- IF (gl_ca_utility_pkg.mrc_enabled(p_sob_id => ar_mc_info.primary_sob_id,

Line 387: -- arp_standard.debug('mrc_bulk_process: ' || 'CALLING PROGRAM : ' || p_table_name);

383: --{BUG4301323
384: NULL;
385: -- IF PG_DEBUG in ('Y', 'C') THEN
386: -- arp_standard.debug('AR_MRC_ENGINE.mrc_bulk_process(+)');
387: -- arp_standard.debug('mrc_bulk_process: ' || 'CALLING PROGRAM : ' || p_table_name);
388: -- arp_standard.debug('mrc_bulk_process: ' || 'before checking to see if mrc is enabled..');
389: -- END IF;
390: -- IF (gl_ca_utility_pkg.mrc_enabled(p_sob_id => ar_mc_info.primary_sob_id,
391: -- p_org_id => ar_mc_info.org_id,

Line 388: -- arp_standard.debug('mrc_bulk_process: ' || 'before checking to see if mrc is enabled..');

384: NULL;
385: -- IF PG_DEBUG in ('Y', 'C') THEN
386: -- arp_standard.debug('AR_MRC_ENGINE.mrc_bulk_process(+)');
387: -- arp_standard.debug('mrc_bulk_process: ' || 'CALLING PROGRAM : ' || p_table_name);
388: -- arp_standard.debug('mrc_bulk_process: ' || 'before checking to see if mrc is enabled..');
389: -- END IF;
390: -- IF (gl_ca_utility_pkg.mrc_enabled(p_sob_id => ar_mc_info.primary_sob_id,
391: -- p_org_id => ar_mc_info.org_id,
392: -- p_appl_id => 222

Line 396: -- arp_standard.debug('mrc_bulk_process: ' || 'MRC is enabled... ');

392: -- p_appl_id => 222
393: -- )) THEN
394:
395: -- IF PG_DEBUG in ('Y', 'C') THEN
396: -- arp_standard.debug('mrc_bulk_process: ' || 'MRC is enabled... ');
397: -- END IF;
398: -- IF (p_table_name = 'GL_DIST') THEN
399: -- ar_mc_info.inv_import_cld(p_request_id);
400: -- ELSE

Line 407: -- arp_standard.debug('AR_MRC_ENGINE.mrc_bulk_process(-)');

403: -- END IF;
404: -- END IF;
405:
406: -- IF PG_DEBUG in ('Y', 'C') THEN
407: -- arp_standard.debug('AR_MRC_ENGINE.mrc_bulk_process(-)');
408: -- END IF;
409: END mrc_bulk_process;
410:
411: END AR_MRC_ENGINE;