DBA Data[Home] [Help]

APPS.AR_MRC_ENGINE2 dependencies on STANDARD

Line 55: -- arp_standard.debug( 'AR_MRC_ENGINE2.Maintain_MRC_Data2(+)');

51: BEGIN
52: --{BUG4301323
53: NULL;
54: -- IF PG_DEBUG in ('Y', 'C') THEN
55: -- arp_standard.debug( 'AR_MRC_ENGINE2.Maintain_MRC_Data2(+)');
56: -- END IF;
57:
58: /*-----------------------------------------------------------------+
59: | Dump the input parameters for debugging purposes |

Line 63: -- arp_standard.debug('Maintain_MRC_Data2: ' || ' EVENT Mode : ' || p_event_mode);

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

Line 64: -- arp_standard.debug('Maintain_MRC_Data2: ' || ' Table Name : ' || p_table_name);

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

Line 65: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'key_value : ' || to_char(p_key_value));

61:
62: -- IF PG_DEBUG in ('Y', 'C') THEN
63: -- arp_standard.debug('Maintain_MRC_Data2: ' || ' EVENT Mode : ' || p_event_mode);
64: -- arp_standard.debug('Maintain_MRC_Data2: ' || ' Table Name : ' || p_table_name);
65: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'key_value : ' || to_char(p_key_value));
66: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'p_mode : ' || p_mode);
67: -- END IF;
68:
69:

Line 66: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'p_mode : ' || p_mode);

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

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

77:
78: -- IF (p_table_name = 'AR_DISTRIBUTIONS' ) THEN
79:
80: -- IF PG_DEBUG in ('Y', 'C') THEN
81: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'Called with one of the supported table names ');
82: -- END IF;
83: /*-----------------------------------------------------------------+
84: | First we need to check if MRC is enabled. If it is than we |
85: | continue processing. If it is not then we are finished. |

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

84: | First we need to check if MRC is enabled. If it is than we |
85: | continue processing. If it is not then we are finished. |
86: +-----------------------------------------------------------------*/
87: -- IF PG_DEBUG in ('Y', 'C') THEN
88: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'before checking to see if mrc is enabled..');
89: -- END IF;
90: -- IF (gl_ca_utility_pkg.mrc_enabled(p_sob_id => ar_mc_info.primary_sob_id,
91: -- p_org_id => ar_mc_info.org_id,
92: -- p_appl_id => 222

Line 96: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'MRC is enabled... ');

92: -- p_appl_id => 222
93: -- )) THEN
94:
95: -- IF PG_DEBUG in ('Y', 'C') THEN
96: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'MRC is enabled... ');
97: -- END IF;
98:
99: /*------------------------------------------------------------+
100: | Branch based upon the mode of operation |

Line 104: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'THIS MODULE SHOULD NOT BE CALLED FOR Deletion');

100: | Branch based upon the mode of operation |
101: +------------------------------------------------------------*/
102: -- IF (p_event_mode = 'DELETE') THEN
103: -- IF PG_DEBUG in ('Y', 'C') THEN
104: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'THIS MODULE SHOULD NOT BE CALLED FOR Deletion');
105: -- END IF;
106: -- END IF; /* end p_event_mode = DELETE */
107:
108: -- IF ( p_event_mode = 'INSERT') THEN

Line 121: -- arp_standard.debug('Maintain_MRC_Data2: ' || SQLERRM);

117: -- END IF;
118: -- EXCEPTION
119: -- WHEN OTHERS THEN
120: -- IF PG_DEBUG in ('Y', 'C') THEN
121: -- arp_standard.debug('Maintain_MRC_Data2: ' || SQLERRM);
122: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'error during Insert for ' || p_table_name);
123: -- END IF;
124: -- APP_EXCEPTION.RAISE_EXCEPTION;
125: -- END;

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

118: -- EXCEPTION
119: -- WHEN OTHERS THEN
120: -- IF PG_DEBUG in ('Y', 'C') THEN
121: -- arp_standard.debug('Maintain_MRC_Data2: ' || SQLERRM);
122: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'error during Insert for ' || p_table_name);
123: -- END IF;
124: -- APP_EXCEPTION.RAISE_EXCEPTION;
125: -- END;
126: -- END IF; /* end p_event_mode = INSERT */

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

127:
128: -- IF (p_event_mode = 'UPDATE') THEN
129:
130: -- IF PG_DEBUG in ('Y', 'C') THEN
131: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'Before calling MRC api for Update');
132: -- END IF;
133: -- BEGIN
134:
135: -- IF (p_table_name = 'AR_DISTRIBUTIONS') THEN

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

142: -- END IF;
143: -- EXCEPTION
144: -- WHEN OTHERS THEN
145: -- IF PG_DEBUG in ('Y', 'C') THEN
146: -- arp_standard.debug('Maintain_MRC_Data2: ' || 'error during update for ' || p_table_name);
147: -- END IF;
148: -- APP_EXCEPTION.RAISE_EXCEPTION;
149: -- END;
150: -- END IF; /* end p_event_mode = UPDATE */

Line 156: -- arp_standard.debug( 'AR_MRC_ENGINE2.Maintain_MRC_Data2(-)');

152: -- END IF; /* end of mrc is enabled */
153:
154: -- END IF; /* end of checking for specific tables */
155: -- IF PG_DEBUG in ('Y', 'C') THEN
156: -- arp_standard.debug( 'AR_MRC_ENGINE2.Maintain_MRC_Data2(-)');
157: -- END IF;
158:
159: END Maintain_MRC_Data2;
160:

Line 202: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_bulk_process(+)');

198: BEGIN
199: --{BUG#4301323
200: NULL;
201: -- IF PG_DEBUG in ('Y', 'C') THEN
202: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_bulk_process(+)');
203: -- arp_standard.debug('mrc_bulk_process: ' || 'CALLING PROGRAM : ' || p_prog_name);
204: -- arp_standard.debug('mrc_bulk_process: ' || 'before checking to see if mrc is enabled..');
205: -- END IF;
206: -- IF (gl_ca_utility_pkg.mrc_enabled(p_sob_id => ar_mc_info.primary_sob_id,

Line 203: -- arp_standard.debug('mrc_bulk_process: ' || 'CALLING PROGRAM : ' || p_prog_name);

199: --{BUG#4301323
200: NULL;
201: -- IF PG_DEBUG in ('Y', 'C') THEN
202: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_bulk_process(+)');
203: -- arp_standard.debug('mrc_bulk_process: ' || 'CALLING PROGRAM : ' || p_prog_name);
204: -- arp_standard.debug('mrc_bulk_process: ' || 'before checking to see if mrc is enabled..');
205: -- END IF;
206: -- IF (gl_ca_utility_pkg.mrc_enabled(p_sob_id => ar_mc_info.primary_sob_id,
207: -- p_org_id => ar_mc_info.org_id,

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

200: NULL;
201: -- IF PG_DEBUG in ('Y', 'C') THEN
202: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_bulk_process(+)');
203: -- arp_standard.debug('mrc_bulk_process: ' || 'CALLING PROGRAM : ' || p_prog_name);
204: -- arp_standard.debug('mrc_bulk_process: ' || 'before checking to see if mrc is enabled..');
205: -- END IF;
206: -- IF (gl_ca_utility_pkg.mrc_enabled(p_sob_id => ar_mc_info.primary_sob_id,
207: -- p_org_id => ar_mc_info.org_id,
208: -- p_appl_id => 222

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

208: -- p_appl_id => 222
209: -- )) THEN
210:
211: -- IF PG_DEBUG in ('Y', 'C') THEN
212: -- arp_standard.debug('mrc_bulk_process: ' || 'MRC is enabled... ');
213: -- END IF;
214:
215: -- AR_MC_INFO.rec_mrc_bulk_process(
216: -- to_number(p_request_id),

Line 225: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_bulk_process(-)');

221: -- );
222: -- END IF;
223:
224: -- IF PG_DEBUG in ('Y', 'C') THEN
225: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_bulk_process(-)');
226: -- END IF;
227: END mrc_bulk_process;
228:
229: /*===========================================================================

Line 278: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_correct_rounding(+)');

274: BEGIN
275: --{BUG4301323
276: NULL;
277: -- IF PG_DEBUG in ('Y', 'C') THEN
278: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_correct_rounding(+)');
279: -- arp_standard.debug('mrc_correct_rounding: ' || 'before checking to see if mrc is enabled..');
280: -- END IF;
281: -- IF (gl_ca_utility_pkg.mrc_enabled(p_sob_id => ar_mc_info.primary_sob_id,
282: -- p_org_id => ar_mc_info.org_id,

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

275: --{BUG4301323
276: NULL;
277: -- IF PG_DEBUG in ('Y', 'C') THEN
278: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_correct_rounding(+)');
279: -- arp_standard.debug('mrc_correct_rounding: ' || 'before checking to see if mrc is enabled..');
280: -- END IF;
281: -- IF (gl_ca_utility_pkg.mrc_enabled(p_sob_id => ar_mc_info.primary_sob_id,
282: -- p_org_id => ar_mc_info.org_id,
283: -- p_appl_id => 222

Line 286: -- arp_standard.debug('mrc_correct_rounding: ' || 'MRC is enabled... ');

282: -- p_org_id => ar_mc_info.org_id,
283: -- p_appl_id => 222
284: -- )) THEN
285: -- IF PG_DEBUG in ('Y', 'C') THEN
286: -- arp_standard.debug('mrc_correct_rounding: ' || 'MRC is enabled... ');
287: -- END IF;
288:
289: -- IF (rounding_prog_name = 'CORRECT_NONRULE_LINE_RECORDS') THEN
290: -- ar_mc_info.correct_nonrule_line_records(

Line 335: -- arp_standard.debug('INCORRECT arguments to mrc_correct_rounding');

331: -- ELSIF (rounding_prog_name = 'CORRECT_SUSPENSE') THEN
332: -- ar_mc_info.correct_suspense(p_customer_trx_id);
333: -- ELSE
334: -- IF PG_DEBUG in ('Y', 'C') THEN
335: -- arp_standard.debug('INCORRECT arguments to mrc_correct_rounding');
336: -- END IF;
337: -- END IF;
338: -- END IF;
339:

Line 341: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_correct_rounding(-)');

337: -- END IF;
338: -- END IF;
339:
340: -- IF PG_DEBUG in ('Y', 'C') THEN
341: -- arp_standard.debug('AR_MRC_ENGINE2.mrc_correct_rounding(-)');
342: -- END IF;
343: END mrc_correct_rounding;
344:
345: