DBA Data[Home] [Help]

APPS.ARP_LEGAL_ENTITY_UTIL dependencies on ARP_STANDARD

Line 92: arp_standard.debug('arp_legal_entity_util.get_default_le()+');

88: l_legal_entity_id NUMBER := -1;
89:
90: BEGIN
91: IF PG_DEBUG in ('Y', 'C') THEN
92: arp_standard.debug('arp_legal_entity_util.get_default_le()+');
93: arp_standard.debug(' parms:'||p_sold_to_cust_id||':'||
94: p_bill_to_cust_id||':'||
95: p_trx_type_id||':'||
96: p_batch_source_id);

Line 93: arp_standard.debug(' parms:'||p_sold_to_cust_id||':'||

89:
90: BEGIN
91: IF PG_DEBUG in ('Y', 'C') THEN
92: arp_standard.debug('arp_legal_entity_util.get_default_le()+');
93: arp_standard.debug(' parms:'||p_sold_to_cust_id||':'||
94: p_bill_to_cust_id||':'||
95: p_trx_type_id||':'||
96: p_batch_source_id);
97: END IF;

Line 104: l_legal_entity_id := get_default_le_id(arp_standard.sysparm.org_id,

100: five possible sources. */
101:
102: /* Get from org (if there is just one) */
103:
104: l_legal_entity_id := get_default_le_id(arp_standard.sysparm.org_id,
105: arp_standard.sysparm.set_of_books_id);
106:
107: IF l_legal_entity_id <> -1
108: THEN

Line 105: arp_standard.sysparm.set_of_books_id);

101:
102: /* Get from org (if there is just one) */
103:
104: l_legal_entity_id := get_default_le_id(arp_standard.sysparm.org_id,
105: arp_standard.sysparm.set_of_books_id);
106:
107: IF l_legal_entity_id <> -1
108: THEN
109: RETURN l_legal_entity_id;

Line 124: arp_standard.debug(' def from trx_type:' || l_legal_entity_id);

120:
121: IF l_legal_entity_id <> -1
122: THEN
123: IF PG_DEBUG in ('Y', 'C') THEN
124: arp_standard.debug(' def from trx_type:' || l_legal_entity_id);
125: END IF;
126: RETURN l_legal_entity_id;
127: END IF;
128:

Line 131: arp_standard.debug('EXCEPTION: invalid cust_trx_type_id');

127: END IF;
128:
129: EXCEPTION
130: WHEN NO_DATA_FOUND THEN
131: arp_standard.debug('EXCEPTION: invalid cust_trx_type_id');
132: /* Invalid trx_type, but keep going */
133: END;
134:
135: END IF;

Line 149: arp_standard.debug(' def from batch_source:' || l_legal_entity_id);

145:
146: IF l_legal_entity_id <> -1
147: THEN
148: IF PG_DEBUG in ('Y', 'C') THEN
149: arp_standard.debug(' def from batch_source:' || l_legal_entity_id);
150: END IF;
151: RETURN l_legal_entity_id;
152: END IF;
153:

Line 156: arp_standard.debug('EXCEPTION: invalid batch_source_id');

152: END IF;
153:
154: EXCEPTION
155: WHEN NO_DATA_FOUND THEN
156: arp_standard.debug('EXCEPTION: invalid batch_source_id');
157: /* Invalid batch_source */
158: END;
159:
160: END IF;

Line 165: l_legal_entity_id := get_default_legal_context(arp_standard.sysparm.org_id);

161:
162: IF l_legal_entity_id = -1
163: THEN
164: /* If all else fails, return the default_legal_context */
165: l_legal_entity_id := get_default_legal_context(arp_standard.sysparm.org_id);
166: END IF;
167:
168: RETURN l_legal_entity_id;
169:

Line 190: arp_standard.debug('arp_legal_entity_util.get_default_le()+');

186: l_org_return_status VARCHAR2(1);
187:
188: BEGIN
189: IF PG_DEBUG in ('Y', 'C') THEN
190: arp_standard.debug('arp_legal_entity_util.get_default_le()+');
191: arp_standard.debug(' parms:'||p_sold_to_cust_id||':'||
192: p_bill_to_cust_id||':'||
193: p_trx_type_id||':'||
194: p_batch_source_id||':'||

Line 191: arp_standard.debug(' parms:'||p_sold_to_cust_id||':'||

187:
188: BEGIN
189: IF PG_DEBUG in ('Y', 'C') THEN
190: arp_standard.debug('arp_legal_entity_util.get_default_le()+');
191: arp_standard.debug(' parms:'||p_sold_to_cust_id||':'||
192: p_bill_to_cust_id||':'||
193: p_trx_type_id||':'||
194: p_batch_source_id||':'||
195: p_org_id);

Line 199: IF (p_org_id is NOT NULL and NVL(p_org_id,-1) <> arp_standard.sysparm.org_id )

195: p_org_id);
196: END IF;
197:
198:
199: IF (p_org_id is NOT NULL and NVL(p_org_id,-1) <> arp_standard.sysparm.org_id )
200: THEN
201: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id ,
202: p_return_status =>l_org_return_status);
203: END IF;

Line 240: arp_standard.debug('arp_legal_entity_util.Get_Default_LE_ID()+');

236: l_legal_entity_id r_legal_entity_id;
237:
238: BEGIN
239: IF PG_DEBUG in ('Y', 'C') THEN
240: arp_standard.debug('arp_legal_entity_util.Get_Default_LE_ID()+');
241: arp_standard.debug(' parms: ' ||p_org_id||':'||
242: p_sob_id);
243: END IF;
244:

Line 241: arp_standard.debug(' parms: ' ||p_org_id||':'||

237:
238: BEGIN
239: IF PG_DEBUG in ('Y', 'C') THEN
240: arp_standard.debug('arp_legal_entity_util.Get_Default_LE_ID()+');
241: arp_standard.debug(' parms: ' ||p_org_id||':'||
242: p_sob_id);
243: END IF;
244:
245: IF p_org_id = g_org_id AND p_sob_id = g_sob_id

Line 248: arp_standard.debug(' Returning cached LE : ' || g_le_id);

244:
245: IF p_org_id = g_org_id AND p_sob_id = g_sob_id
246: THEN
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_standard.debug(' Returning cached LE : ' || g_le_id);
249: END IF;
250: ELSE
251: g_org_id := p_org_id;
252: g_sob_id := p_sob_id;

Line 263: arp_standard.debug(' Caching and returning LE : ' || g_le_id);

259: operating_unit_id = p_org_id;
260:
261: IF (l_legal_entity_id.COUNT = 1) THEN
262: IF PG_DEBUG in ('Y', 'C') THEN
263: arp_standard.debug(' Caching and returning LE : ' || g_le_id);
264: END IF;
265: g_le_id := l_legal_entity_id(1);
266: ELSE
267: IF PG_DEBUG in ('Y', 'C') THEN

Line 268: arp_standard.debug(' No default LE available, returning -1');

264: END IF;
265: g_le_id := l_legal_entity_id(1);
266: ELSE
267: IF PG_DEBUG in ('Y', 'C') THEN
268: arp_standard.debug(' No default LE available, returning -1');
269: END IF;
270:
271: g_le_id := -1;
272: END IF;

Line 276: arp_standard.debug('arp_legal_entity_util.get_default_le_id()-');

272: END IF;
273: END IF;
274:
275: IF PG_DEBUG in ('Y', 'C') THEN
276: arp_standard.debug('arp_legal_entity_util.get_default_le_id()-');
277: END IF;
278:
279: RETURN g_le_id;
280:

Line 307: arp_standard.debug('arp_legal_entity_util.Get_Default_LE_NAme()+');

303: l_legal_entity_name r_legal_entity_name;
304:
305: BEGIN
306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_standard.debug('arp_legal_entity_util.Get_Default_LE_NAme()+');
308: arp_standard.debug(' parms: ' ||p_org_id||':'||
309: p_sob_id);
310: END IF;
311:

Line 308: arp_standard.debug(' parms: ' ||p_org_id||':'||

304:
305: BEGIN
306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_standard.debug('arp_legal_entity_util.Get_Default_LE_NAme()+');
308: arp_standard.debug(' parms: ' ||p_org_id||':'||
309: p_sob_id);
310: END IF;
311:
312: Select legal_entity_name

Line 347: arp_standard.debug('arp_legal_entity_util.Is_LE_Subscriber()+' );

343: l_subscriber_flag VARCHAR2(1);
344: BEGIN
345: IF PG_DEBUG IN ('Y','C')
346: THEN
347: arp_standard.debug('arp_legal_entity_util.Is_LE_Subscriber()+' );
348: END IF;
349:
350: SELECT USE_LE_AS_SUBSCRIBER_FLAG
351: INTO l_subscriber_flag

Line 366: arp_standard.debug('NO_DATA_FOUND EXCETION : arp_legal_entity_util.Is_LE_Subscriber()');

362: EXCEPTION
363: WHEN NO_DATA_FOUND THEN
364: IF PG_DEBUG IN ('Y','C')
365: THEN
366: arp_standard.debug('NO_DATA_FOUND EXCETION : arp_legal_entity_util.Is_LE_Subscriber()');
367: END IF;
368: fnd_message.set_name('AR','AR_OU_PARTY_NOT_EXIST');
369: fnd_message.set_token('ORG_ID',arp_global.sysparam.org_id);
370: app_exception.raise_exception;

Line 374: arp_standard.debug('OTHERS EXCETION : arp_legal_entity_util.Is_LE_Subscriber()');

370: app_exception.raise_exception;
371: WHEN OTHERS THEN
372: IF PG_DEBUG IN ('Y','C')
373: THEN
374: arp_standard.debug('OTHERS EXCETION : arp_legal_entity_util.Is_LE_Subscriber()');
375: END IF;
376: RAISE;
377: END Is_LE_Subscriber;
378:

Line 408: arp_standard.debug('arp_legal_entity_util.get)default_legal_context()+');

404: l_legal_entity_id NUMBER;
405:
406: BEGIN
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_standard.debug('arp_legal_entity_util.get)default_legal_context()+');
409: arp_standard.debug(' p_org_id: ' ||p_org_id);
410: END IF;
411:
412: IF NVL(g_org_id_dlc, -999) = p_org_id

Line 409: arp_standard.debug(' p_org_id: ' ||p_org_id);

405:
406: BEGIN
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_standard.debug('arp_legal_entity_util.get)default_legal_context()+');
409: arp_standard.debug(' p_org_id: ' ||p_org_id);
410: END IF;
411:
412: IF NVL(g_org_id_dlc, -999) = p_org_id
413: THEN

Line 428: arp_standard.debug(' legal_entity_id [dlc]: ' || l_legal_entity_id);

424: g_le_id_dlc := l_legal_entity_id;
425: END IF;
426:
427: IF PG_DEBUG in ('Y', 'C') THEN
428: arp_standard.debug(' legal_entity_id [dlc]: ' || l_legal_entity_id);
429: arp_standard.debug('arp_legal_entity_util.get_default_legal_context()-');
430: END IF;
431:
432: RETURN l_legal_entity_id;

Line 429: arp_standard.debug('arp_legal_entity_util.get_default_legal_context()-');

425: END IF;
426:
427: IF PG_DEBUG in ('Y', 'C') THEN
428: arp_standard.debug(' legal_entity_id [dlc]: ' || l_legal_entity_id);
429: arp_standard.debug('arp_legal_entity_util.get_default_legal_context()-');
430: END IF;
431:
432: RETURN l_legal_entity_id;
433: