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

Line 138: arp_standard.debug(l_debug_info);

134: ----------------------------------------------------------------------------------------
135: l_debug_info := 'Fetch the message used as the confirmation message subject';
136: -----------------------------------------------------------------------------------------
137: IF (PG_DEBUG = 'Y') THEN
138: arp_standard.debug(l_debug_info);
139: END IF;
140: FND_MESSAGE.SET_NAME (p_subject_msg_appl, p_subject_msg_name);
141: FND_MESSAGE.set_token('CUSTOMER_NAME',p_customer_name);
142: l_subject := FND_MESSAGE.get;

Line 148: arp_standard.debug(l_debug_info);

144: /*----------------------------------------------------------------------------------------
145: l_debug_info := 'Fetch the message used as the confirmation message body';
146: -----------------------------------------------------------------------------------------
147: IF (PG_DEBUG = 'Y') THEN
148: arp_standard.debug(l_debug_info);
149: END IF;
150: FND_MESSAGE.SET_NAME (p_body_msg_appl, p_body_msg_name);
151: l_body := FND_MESSAGE.get;*/
152:

Line 157: arp_standard.debug(l_debug_info);

153: ----------------------------------------------------------------------------------------
154: l_debug_info := 'Create a Workflow process for sending iReceivables Print Notification(ARIPRNTF)';
155: -----------------------------------------------------------------------------------------
156: IF (PG_DEBUG = 'Y') THEN
157: arp_standard.debug(l_debug_info);
158: END IF;
159: WF_ENGINE.CREATEPROCESS('ARIPRNTF',
160: p_request_id,
161: 'ARI_PRINT_NOTIFICATION_PROCESS');

Line 232: arp_standard.debug(l_debug_info);

228: ----------------------------------------------------------------------------------------
229: l_debug_info := 'Start the notification process';
230: -----------------------------------------------------------------------------------------
231: IF (PG_DEBUG = 'Y') THEN
232: arp_standard.debug(l_debug_info);
233: END IF;
234: WF_ENGINE.STARTPROCESS('ARIPRNTF',
235: p_request_id);
236:

Line 240: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

236:
237: EXCEPTION
238: WHEN OTHERS THEN
239: IF (PG_DEBUG = 'Y') THEN
240: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
241: arp_standard.debug(' - No of Requests: '||p_requests);
242: arp_standard.debug(' - User Name : '||p_user_name);
243: arp_standard.debug(' - Customer Name : '||p_customer_name);
244: arp_standard.debug(' - Requests List : '||p_parameter);

Line 241: arp_standard.debug(' - No of Requests: '||p_requests);

237: EXCEPTION
238: WHEN OTHERS THEN
239: IF (PG_DEBUG = 'Y') THEN
240: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
241: arp_standard.debug(' - No of Requests: '||p_requests);
242: arp_standard.debug(' - User Name : '||p_user_name);
243: arp_standard.debug(' - Customer Name : '||p_customer_name);
244: arp_standard.debug(' - Requests List : '||p_parameter);
245: arp_standard.debug(' - Concurrent Request Id : '||p_request_id);

Line 242: arp_standard.debug(' - User Name : '||p_user_name);

238: WHEN OTHERS THEN
239: IF (PG_DEBUG = 'Y') THEN
240: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
241: arp_standard.debug(' - No of Requests: '||p_requests);
242: arp_standard.debug(' - User Name : '||p_user_name);
243: arp_standard.debug(' - Customer Name : '||p_customer_name);
244: arp_standard.debug(' - Requests List : '||p_parameter);
245: arp_standard.debug(' - Concurrent Request Id : '||p_request_id);
246: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 243: arp_standard.debug(' - Customer Name : '||p_customer_name);

239: IF (PG_DEBUG = 'Y') THEN
240: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
241: arp_standard.debug(' - No of Requests: '||p_requests);
242: arp_standard.debug(' - User Name : '||p_user_name);
243: arp_standard.debug(' - Customer Name : '||p_customer_name);
244: arp_standard.debug(' - Requests List : '||p_parameter);
245: arp_standard.debug(' - Concurrent Request Id : '||p_request_id);
246: arp_standard.debug('ERROR =>'|| SQLERRM);
247: END IF;

Line 244: arp_standard.debug(' - Requests List : '||p_parameter);

240: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
241: arp_standard.debug(' - No of Requests: '||p_requests);
242: arp_standard.debug(' - User Name : '||p_user_name);
243: arp_standard.debug(' - Customer Name : '||p_customer_name);
244: arp_standard.debug(' - Requests List : '||p_parameter);
245: arp_standard.debug(' - Concurrent Request Id : '||p_request_id);
246: arp_standard.debug('ERROR =>'|| SQLERRM);
247: END IF;
248:

Line 245: arp_standard.debug(' - Concurrent Request Id : '||p_request_id);

241: arp_standard.debug(' - No of Requests: '||p_requests);
242: arp_standard.debug(' - User Name : '||p_user_name);
243: arp_standard.debug(' - Customer Name : '||p_customer_name);
244: arp_standard.debug(' - Requests List : '||p_parameter);
245: arp_standard.debug(' - Concurrent Request Id : '||p_request_id);
246: arp_standard.debug('ERROR =>'|| SQLERRM);
247: END IF;
248:
249: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 246: arp_standard.debug('ERROR =>'|| SQLERRM);

242: arp_standard.debug(' - User Name : '||p_user_name);
243: arp_standard.debug(' - Customer Name : '||p_customer_name);
244: arp_standard.debug(' - Requests List : '||p_parameter);
245: arp_standard.debug(' - Concurrent Request Id : '||p_request_id);
246: arp_standard.debug('ERROR =>'|| SQLERRM);
247: END IF;
248:
249: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
250: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 311: arp_standard.debug('- Currency Code: '||p_currency_code);

307: min_acct_unit => l_min_acct_unit /* minimum value by which amt can vary */
308: );
309:
310: IF (PG_DEBUG = 'Y') THEN
311: arp_standard.debug('- Currency Code: '||p_currency_code);
312: arp_standard.debug('- Precision: '||l_precision);
313: arp_standard.debug('- Extended Precision: '||l_ext_precision);
314: arp_standard.debug('- Minimum Accounting Unit: '||l_min_acct_unit);
315: END IF;

Line 312: arp_standard.debug('- Precision: '||l_precision);

308: );
309:
310: IF (PG_DEBUG = 'Y') THEN
311: arp_standard.debug('- Currency Code: '||p_currency_code);
312: arp_standard.debug('- Precision: '||l_precision);
313: arp_standard.debug('- Extended Precision: '||l_ext_precision);
314: arp_standard.debug('- Minimum Accounting Unit: '||l_min_acct_unit);
315: END IF;
316:

Line 313: arp_standard.debug('- Extended Precision: '||l_ext_precision);

309:
310: IF (PG_DEBUG = 'Y') THEN
311: arp_standard.debug('- Currency Code: '||p_currency_code);
312: arp_standard.debug('- Precision: '||l_precision);
313: arp_standard.debug('- Extended Precision: '||l_ext_precision);
314: arp_standard.debug('- Minimum Accounting Unit: '||l_min_acct_unit);
315: END IF;
316:
317: ---------------------------------------------------------------------------

Line 314: arp_standard.debug('- Minimum Accounting Unit: '||l_min_acct_unit);

310: IF (PG_DEBUG = 'Y') THEN
311: arp_standard.debug('- Currency Code: '||p_currency_code);
312: arp_standard.debug('- Precision: '||l_precision);
313: arp_standard.debug('- Extended Precision: '||l_ext_precision);
314: arp_standard.debug('- Minimum Accounting Unit: '||l_min_acct_unit);
315: END IF;
316:
317: ---------------------------------------------------------------------------
318: l_debug_info := 'Round the input amount based on the precision information';

Line 323: arp_standard.debug('- Unrounded Amount: '||p_amount);

319: ---------------------------------------------------------------------------
320: l_return_amt := round(p_amount,l_precision);
321:
322: IF (PG_DEBUG = 'Y') THEN
323: arp_standard.debug('- Unrounded Amount: '||p_amount);
324: arp_standard.debug('- Rounded Amount: '||l_return_amt);
325: END IF;
326:
327: RETURN l_return_amt;

Line 324: arp_standard.debug('- Rounded Amount: '||l_return_amt);

320: l_return_amt := round(p_amount,l_precision);
321:
322: IF (PG_DEBUG = 'Y') THEN
323: arp_standard.debug('- Unrounded Amount: '||p_amount);
324: arp_standard.debug('- Rounded Amount: '||l_return_amt);
325: END IF;
326:
327: RETURN l_return_amt;
328:

Line 332: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: IF (PG_DEBUG = 'Y') THEN
332: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
333: arp_standard.debug('Input Amount: '||p_amount);
334: arp_standard.debug('Rounded Amount: '||l_return_amt);
335: arp_standard.debug('Currency: '||p_currency_code);
336: arp_standard.debug('Precision: '||l_precision);

Line 333: arp_standard.debug('Input Amount: '||p_amount);

329: EXCEPTION
330: WHEN OTHERS THEN
331: IF (PG_DEBUG = 'Y') THEN
332: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
333: arp_standard.debug('Input Amount: '||p_amount);
334: arp_standard.debug('Rounded Amount: '||l_return_amt);
335: arp_standard.debug('Currency: '||p_currency_code);
336: arp_standard.debug('Precision: '||l_precision);
337: arp_standard.debug('ERROR =>'|| SQLERRM);

Line 334: arp_standard.debug('Rounded Amount: '||l_return_amt);

330: WHEN OTHERS THEN
331: IF (PG_DEBUG = 'Y') THEN
332: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
333: arp_standard.debug('Input Amount: '||p_amount);
334: arp_standard.debug('Rounded Amount: '||l_return_amt);
335: arp_standard.debug('Currency: '||p_currency_code);
336: arp_standard.debug('Precision: '||l_precision);
337: arp_standard.debug('ERROR =>'|| SQLERRM);
338: END IF;

Line 335: arp_standard.debug('Currency: '||p_currency_code);

331: IF (PG_DEBUG = 'Y') THEN
332: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
333: arp_standard.debug('Input Amount: '||p_amount);
334: arp_standard.debug('Rounded Amount: '||l_return_amt);
335: arp_standard.debug('Currency: '||p_currency_code);
336: arp_standard.debug('Precision: '||l_precision);
337: arp_standard.debug('ERROR =>'|| SQLERRM);
338: END IF;
339:

Line 336: arp_standard.debug('Precision: '||l_precision);

332: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
333: arp_standard.debug('Input Amount: '||p_amount);
334: arp_standard.debug('Rounded Amount: '||l_return_amt);
335: arp_standard.debug('Currency: '||p_currency_code);
336: arp_standard.debug('Precision: '||l_precision);
337: arp_standard.debug('ERROR =>'|| SQLERRM);
338: END IF;
339:
340: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 337: arp_standard.debug('ERROR =>'|| SQLERRM);

333: arp_standard.debug('Input Amount: '||p_amount);
334: arp_standard.debug('Rounded Amount: '||l_return_amt);
335: arp_standard.debug('Currency: '||p_currency_code);
336: arp_standard.debug('Precision: '||l_precision);
337: arp_standard.debug('ERROR =>'|| SQLERRM);
338: END IF;
339:
340: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
341: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 368: arp_standard.debug(l_debug_info);

364: ----------------------------------------------------------------------------------------
365: l_debug_info := 'Fetch hash value by sending lookup code, type and user env language';
366: -----------------------------------------------------------------------------------------
367: IF (PG_DEBUG = 'Y') THEN
368: arp_standard.debug(l_debug_info);
369: END IF;
370:
371: IF p_lookup_code IS NOT NULL AND
372: p_lookup_type IS NOT NULL THEN

Line 393: arp_standard.debug(l_debug_info);

389: ----------------------------------------------------------------------------------------
390: l_debug_info := 'Setting lookup meaning into page lookups rec';
391: -----------------------------------------------------------------------------------------
392: IF (PG_DEBUG = 'Y') THEN
393: arp_standard.debug(l_debug_info);
394: END IF;
395:
396: pg_ar_lookups_rec(l_hash_value) := l_meaning;
397:

Line 409: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

405: WHEN no_data_found THEN
406: return(null);
407: WHEN OTHERS THEN
408: IF (PG_DEBUG = 'Y') THEN
409: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
410: arp_standard.debug('ERROR =>'|| SQLERRM);
411: arp_standard.debug('Debug Info : '||l_debug_info);
412: END IF;
413:

Line 410: arp_standard.debug('ERROR =>'|| SQLERRM);

406: return(null);
407: WHEN OTHERS THEN
408: IF (PG_DEBUG = 'Y') THEN
409: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
410: arp_standard.debug('ERROR =>'|| SQLERRM);
411: arp_standard.debug('Debug Info : '||l_debug_info);
412: END IF;
413:
414: END;

Line 411: arp_standard.debug('Debug Info : '||l_debug_info);

407: WHEN OTHERS THEN
408: IF (PG_DEBUG = 'Y') THEN
409: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
410: arp_standard.debug('ERROR =>'|| SQLERRM);
411: arp_standard.debug('Debug Info : '||l_debug_info);
412: END IF;
413:
414: END;
415:

Line 427: arp_standard.debug(l_debug_info);

423: ----------------------------------------------------------------------------------------
424: l_debug_info := 'Fetch site use id';
425: -----------------------------------------------------------------------------------------
426: IF (PG_DEBUG = 'Y') THEN
427: arp_standard.debug(l_debug_info);
428: END IF;
429:
430: IF G_PRV_ADDRESS_ID <> p_address_id THEN
431: G_PRV_ADDRESS_ID := p_address_id;

Line 440: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

436:
437: EXCEPTION
438: WHEN OTHERS THEN
439: IF (PG_DEBUG = 'Y') THEN
440: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
441: arp_standard.debug('ERROR =>'|| SQLERRM);
442: arp_standard.debug('Debug Info : '||l_debug_info);
443: END IF;
444:

Line 441: arp_standard.debug('ERROR =>'|| SQLERRM);

437: EXCEPTION
438: WHEN OTHERS THEN
439: IF (PG_DEBUG = 'Y') THEN
440: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
441: arp_standard.debug('ERROR =>'|| SQLERRM);
442: arp_standard.debug('Debug Info : '||l_debug_info);
443: END IF;
444:
445:

Line 442: arp_standard.debug('Debug Info : '||l_debug_info);

438: WHEN OTHERS THEN
439: IF (PG_DEBUG = 'Y') THEN
440: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
441: arp_standard.debug('ERROR =>'|| SQLERRM);
442: arp_standard.debug('Debug Info : '||l_debug_info);
443: END IF;
444:
445:
446:

Line 478: arp_standard.debug(l_debug_info);

474: ----------------------------------------------------------------------------------------
475: l_debug_info := 'Fetch Bill to Site use id';
476: -----------------------------------------------------------------------------------------
477: IF (PG_DEBUG = 'Y') THEN
478: arp_standard.debug(l_debug_info);
479: END IF;
480:
481: FOR c01_rec IN c01 (p_address_id) LOOP
482: l_site_uses := l_site_uses || l_separator || site_use_meaning(c01_rec.site_use_code);

Line 499: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: IF (PG_DEBUG = 'Y') THEN
499: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
500: arp_standard.debug('ERROR =>'|| SQLERRM);
501: arp_standard.debug('Debug Info : '||l_debug_info);
502: END IF;
503:

Line 500: arp_standard.debug('ERROR =>'|| SQLERRM);

496: EXCEPTION
497: WHEN OTHERS THEN
498: IF (PG_DEBUG = 'Y') THEN
499: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
500: arp_standard.debug('ERROR =>'|| SQLERRM);
501: arp_standard.debug('Debug Info : '||l_debug_info);
502: END IF;
503:
504:

Line 501: arp_standard.debug('Debug Info : '||l_debug_info);

497: WHEN OTHERS THEN
498: IF (PG_DEBUG = 'Y') THEN
499: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
500: arp_standard.debug('ERROR =>'|| SQLERRM);
501: arp_standard.debug('Debug Info : '||l_debug_info);
502: END IF;
503:
504:
505:

Line 522: arp_standard.debug(l_debug_info);

518: ----------------------------------------------------------------------------------------
519: l_debug_info := 'Fetch lookup meaning for site use';
520: -----------------------------------------------------------------------------------------
521: IF (PG_DEBUG = 'Y') THEN
522: arp_standard.debug(l_debug_info);
523: END IF;
524:
525: l_meaning := get_lookup_meaning('SITE_USE_CODE', p_site_use);
526:

Line 532: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

528:
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF (PG_DEBUG = 'Y') THEN
532: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
533: arp_standard.debug('ERROR =>'|| SQLERRM);
534: arp_standard.debug('Debug Info : '||l_debug_info);
535: END IF;
536:

Line 533: arp_standard.debug('ERROR =>'|| SQLERRM);

529: EXCEPTION
530: WHEN OTHERS THEN
531: IF (PG_DEBUG = 'Y') THEN
532: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
533: arp_standard.debug('ERROR =>'|| SQLERRM);
534: arp_standard.debug('Debug Info : '||l_debug_info);
535: END IF;
536:
537: END;

Line 534: arp_standard.debug('Debug Info : '||l_debug_info);

530: WHEN OTHERS THEN
531: IF (PG_DEBUG = 'Y') THEN
532: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
533: arp_standard.debug('ERROR =>'|| SQLERRM);
534: arp_standard.debug('Debug Info : '||l_debug_info);
535: END IF;
536:
537: END;
538:

Line 1536: arp_standard.debug(l_debug_info);

1532: ----------------------------------------------------------------------------------------
1533: l_debug_info := 'Fetch Bill to Location';
1534: -----------------------------------------------------------------------------------------
1535: IF (PG_DEBUG = 'Y') THEN
1536: arp_standard.debug(l_debug_info);
1537: END IF;
1538:
1539: FOR c01_rec IN c01 (p_address_id) LOOP
1540: l_site_uses := l_site_uses || l_separator ||c01_rec.location;

Line 1553: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

1549:
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: IF (PG_DEBUG = 'Y') THEN
1553: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1554: arp_standard.debug('ERROR =>'|| SQLERRM);
1555: arp_standard.debug('Debug Info : '||l_debug_info);
1556: END IF;
1557:

Line 1554: arp_standard.debug('ERROR =>'|| SQLERRM);

1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: IF (PG_DEBUG = 'Y') THEN
1553: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1554: arp_standard.debug('ERROR =>'|| SQLERRM);
1555: arp_standard.debug('Debug Info : '||l_debug_info);
1556: END IF;
1557:
1558: END;

Line 1555: arp_standard.debug('Debug Info : '||l_debug_info);

1551: WHEN OTHERS THEN
1552: IF (PG_DEBUG = 'Y') THEN
1553: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1554: arp_standard.debug('ERROR =>'|| SQLERRM);
1555: arp_standard.debug('Debug Info : '||l_debug_info);
1556: END IF;
1557:
1558: END;
1559:

Line 1602: arp_standard.debug(l_debug_info);

1598: ----------------------------------------------------------------------------------------
1599: l_debug_info := 'Fetch Bill to Site use id';
1600: -----------------------------------------------------------------------------------------
1601: IF (PG_DEBUG = 'Y') THEN
1602: arp_standard.debug(l_debug_info);
1603: END IF;
1604:
1605: FOR c01_rec IN c01 (p_address_id) LOOP
1606: l_site_use_codes := l_site_use_codes || l_separator || c01_rec.site_use_code;

Line 1623: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

1619:
1620: EXCEPTION
1621: WHEN OTHERS THEN
1622: IF (PG_DEBUG = 'Y') THEN
1623: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1624: arp_standard.debug('ERROR =>'|| SQLERRM);
1625: arp_standard.debug('Debug Info : '||l_debug_info);
1626: END IF;
1627:

Line 1624: arp_standard.debug('ERROR =>'|| SQLERRM);

1620: EXCEPTION
1621: WHEN OTHERS THEN
1622: IF (PG_DEBUG = 'Y') THEN
1623: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1624: arp_standard.debug('ERROR =>'|| SQLERRM);
1625: arp_standard.debug('Debug Info : '||l_debug_info);
1626: END IF;
1627:
1628:

Line 1625: arp_standard.debug('Debug Info : '||l_debug_info);

1621: WHEN OTHERS THEN
1622: IF (PG_DEBUG = 'Y') THEN
1623: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1624: arp_standard.debug('ERROR =>'|| SQLERRM);
1625: arp_standard.debug('Debug Info : '||l_debug_info);
1626: END IF;
1627:
1628:
1629:

Line 1697: arp_standard.debug(G_PKG_NAME || l_procedure_name || '+');

1693: --------------------------------------------------------------------
1694: l_debug_info := 'In debug mode, log we have entered this procedure';
1695: --------------------------------------------------------------------
1696: IF (PG_DEBUG = 'Y') THEN
1697: arp_standard.debug(G_PKG_NAME || l_procedure_name || '+');
1698: END IF;
1699:
1700: l_customer_trx_id := p_event.GetValueForParameter('CUSTOMER_TRX_ID');
1701: l_org_id := p_event.GetValueForParameter('ORG_ID');

Line 1708: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);

1704: l_application_id := p_event.GetValueForParameter('RESP_APPL_ID');
1705:
1706: IF (PG_DEBUG = 'Y') THEN
1707:
1708: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);
1709: arp_standard.debug ('l_org_id ='||l_org_id);
1710: arp_standard.debug ('l_user_id ='||l_user_id);
1711: arp_standard.debug ('l_resp_id ='||l_resp_id);
1712: arp_standard.debug ('l_application_id ='||l_application_id);

Line 1709: arp_standard.debug ('l_org_id ='||l_org_id);

1705:
1706: IF (PG_DEBUG = 'Y') THEN
1707:
1708: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);
1709: arp_standard.debug ('l_org_id ='||l_org_id);
1710: arp_standard.debug ('l_user_id ='||l_user_id);
1711: arp_standard.debug ('l_resp_id ='||l_resp_id);
1712: arp_standard.debug ('l_application_id ='||l_application_id);
1713: END IF;

Line 1710: arp_standard.debug ('l_user_id ='||l_user_id);

1706: IF (PG_DEBUG = 'Y') THEN
1707:
1708: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);
1709: arp_standard.debug ('l_org_id ='||l_org_id);
1710: arp_standard.debug ('l_user_id ='||l_user_id);
1711: arp_standard.debug ('l_resp_id ='||l_resp_id);
1712: arp_standard.debug ('l_application_id ='||l_application_id);
1713: END IF;
1714:

Line 1711: arp_standard.debug ('l_resp_id ='||l_resp_id);

1707:
1708: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);
1709: arp_standard.debug ('l_org_id ='||l_org_id);
1710: arp_standard.debug ('l_user_id ='||l_user_id);
1711: arp_standard.debug ('l_resp_id ='||l_resp_id);
1712: arp_standard.debug ('l_application_id ='||l_application_id);
1713: END IF;
1714:
1715: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);

Line 1712: arp_standard.debug ('l_application_id ='||l_application_id);

1708: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);
1709: arp_standard.debug ('l_org_id ='||l_org_id);
1710: arp_standard.debug ('l_user_id ='||l_user_id);
1711: arp_standard.debug ('l_resp_id ='||l_resp_id);
1712: arp_standard.debug ('l_application_id ='||l_application_id);
1713: END IF;
1714:
1715: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
1716:

Line 1732: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_id || '+');

1728: and aps.org_id = l_org_id
1729: and sites.site_use_id = aps.customer_site_use_id;
1730:
1731: IF (PG_DEBUG = 'Y') THEN
1732: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_id || '+');
1733: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_acct_site_id || '+');
1734: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
1735: END IF;
1736:

Line 1733: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_acct_site_id || '+');

1729: and sites.site_use_id = aps.customer_site_use_id;
1730:
1731: IF (PG_DEBUG = 'Y') THEN
1732: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_id || '+');
1733: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_acct_site_id || '+');
1734: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
1735: END IF;
1736:
1737: --------------------------------------------------------------------

Line 1734: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');

1730:
1731: IF (PG_DEBUG = 'Y') THEN
1732: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_id || '+');
1733: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_acct_site_id || '+');
1734: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
1735: END IF;
1736:
1737: --------------------------------------------------------------------
1738: l_debug_info := 'creating workflow process';

Line 1782: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS') || '+');

1778: l_debug_info := 'Starting Workflow..';
1779: ----------------------------------------------------------------------------
1780:
1781: IF (PG_DEBUG = 'Y') THEN
1782: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS') || '+');
1783: END IF;
1784:
1785: WF_ENGINE.StartProcess(l_itemtype,l_customer_trx_id);
1786:

Line 1793: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: IF (PG_DEBUG = 'Y') THEN
1793: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1794: arp_standard.debug('ERROR =>'|| SQLERRM);
1795: arp_standard.debug('Debug Info : '||l_debug_info);
1796: END IF;
1797: RETURN 'ERROR';

Line 1794: arp_standard.debug('ERROR =>'|| SQLERRM);

1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: IF (PG_DEBUG = 'Y') THEN
1793: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1794: arp_standard.debug('ERROR =>'|| SQLERRM);
1795: arp_standard.debug('Debug Info : '||l_debug_info);
1796: END IF;
1797: RETURN 'ERROR';
1798:

Line 1795: arp_standard.debug('Debug Info : '||l_debug_info);

1791: WHEN OTHERS THEN
1792: IF (PG_DEBUG = 'Y') THEN
1793: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1794: arp_standard.debug('ERROR =>'|| SQLERRM);
1795: arp_standard.debug('Debug Info : '||l_debug_info);
1796: END IF;
1797: RETURN 'ERROR';
1798:
1799: END invoke_invoice_email_notwf;

Line 1853: arp_standard.debug(l_debug_info);

1849: ----------------------------------------------------------------------------------------
1850: l_debug_info := 'fetches all email addres at account level for all self sevice users';
1851: -----------------------------------------------------------------------------------------
1852: IF (PG_DEBUG = 'Y') THEN
1853: arp_standard.debug(l_debug_info);
1854: END IF;
1855:
1856: FOR contact_rec in contact_cur(p_customer_id) LOOP
1857:

Line 1876: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_contact_email_addrs || '+');

1872: ----------------------------------------------------------------------------------------
1873: l_debug_info := 'emails at account level';
1874: -----------------------------------------------------------------------------------------
1875: IF (PG_DEBUG = 'Y') THEN
1876: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_contact_email_addrs || '+');
1877: END IF;
1878:
1879: ----------------------------------------------------------------------------------------
1880: l_debug_info := 'fetches all email addres at site level for all self sevice users';

Line 1903: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_contact_email_addrs || '+');

1899: ----------------------------------------------------------------------------------------
1900: l_debug_info := 'emails at account and site level';
1901: -----------------------------------------------------------------------------------------
1902: IF (PG_DEBUG = 'Y') THEN
1903: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_contact_email_addrs || '+');
1904: END IF;
1905:
1906: RETURN l_contact_email_addrs;
1907:

Line 1911: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

1907:
1908: EXCEPTION
1909: WHEN OTHERS THEN
1910: IF (PG_DEBUG = 'Y') THEN
1911: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1912: arp_standard.debug('ERROR =>'|| SQLERRM);
1913: arp_standard.debug('Debug Info : '||l_debug_info);
1914: END IF;
1915: RETURN 'ERROR';

Line 1912: arp_standard.debug('ERROR =>'|| SQLERRM);

1908: EXCEPTION
1909: WHEN OTHERS THEN
1910: IF (PG_DEBUG = 'Y') THEN
1911: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1912: arp_standard.debug('ERROR =>'|| SQLERRM);
1913: arp_standard.debug('Debug Info : '||l_debug_info);
1914: END IF;
1915: RETURN 'ERROR';
1916:

Line 1913: arp_standard.debug('Debug Info : '||l_debug_info);

1909: WHEN OTHERS THEN
1910: IF (PG_DEBUG = 'Y') THEN
1911: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1912: arp_standard.debug('ERROR =>'|| SQLERRM);
1913: arp_standard.debug('Debug Info : '||l_debug_info);
1914: END IF;
1915: RETURN 'ERROR';
1916:
1917: END ;

Line 1961: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_trx_id || '+');

1957: l_customer_trx_id:= wf_engine.GetItemAttrText(itemtype => l_itemtype,
1958: itemkey => l_itemkey,
1959: aname => 'ARI_INV_NUM');
1960: IF (PG_DEBUG = 'Y') THEN
1961: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_trx_id || '+');
1962: END IF;
1963:
1964: -----------------------------------------------------------
1965: l_debug_info := 'Retrieve ARI_CUST_ACCT_NUM Item Attribute';

Line 1972: arp_standard.debug(G_PKG_NAME || l_procedure_name || p_customer_id || '+');

1968: p_customer_id:= wf_engine.GetItemAttrText(itemtype => l_itemtype,
1969: itemkey => l_itemkey,
1970: aname => 'ARI_CUST_ACCT_NUM');
1971: IF (PG_DEBUG = 'Y') THEN
1972: arp_standard.debug(G_PKG_NAME || l_procedure_name || p_customer_id || '+');
1973: END IF;
1974:
1975: ---------------------------------------------------------------
1976: l_debug_info := 'Retrieve ARI_CUST_ACCT_SITE_NUM Item Attribute';

Line 1984: arp_standard.debug(G_PKG_NAME || l_procedure_name || p_customer_acct_site_id || '+');

1980: itemkey => l_itemkey,
1981: aname => 'ARI_CUST_ACCT_SITE_NUM');
1982:
1983: IF (PG_DEBUG = 'Y') THEN
1984: arp_standard.debug(G_PKG_NAME || l_procedure_name || p_customer_acct_site_id || '+');
1985: END IF;
1986:
1987: --------------------------------------------------------------------------
1988: l_debug_info := 'selecting all the attributes required to send in notification';

Line 1999: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');

1995: and aps.customer_id = p_customer_id
1996: and aps.term_id = t.term_id(+);
1997:
1998: IF (PG_DEBUG = 'Y') THEN
1999: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
2000: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_amt_due || '+');
2001: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_curr_code || '+');
2002: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_due_date || '+');
2003: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_nanme || '+');

Line 2000: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_amt_due || '+');

1996: and aps.term_id = t.term_id(+);
1997:
1998: IF (PG_DEBUG = 'Y') THEN
1999: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
2000: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_amt_due || '+');
2001: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_curr_code || '+');
2002: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_due_date || '+');
2003: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_nanme || '+');
2004: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_desc || '+');

Line 2001: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_curr_code || '+');

1997:
1998: IF (PG_DEBUG = 'Y') THEN
1999: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
2000: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_amt_due || '+');
2001: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_curr_code || '+');
2002: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_due_date || '+');
2003: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_nanme || '+');
2004: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_desc || '+');
2005: END IF;

Line 2002: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_due_date || '+');

1998: IF (PG_DEBUG = 'Y') THEN
1999: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
2000: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_amt_due || '+');
2001: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_curr_code || '+');
2002: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_due_date || '+');
2003: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_nanme || '+');
2004: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_desc || '+');
2005: END IF;
2006:

Line 2003: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_nanme || '+');

1999: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
2000: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_amt_due || '+');
2001: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_curr_code || '+');
2002: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_due_date || '+');
2003: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_nanme || '+');
2004: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_desc || '+');
2005: END IF;
2006:
2007: --------------------------------------------------------------------------

Line 2004: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_desc || '+');

2000: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_amt_due || '+');
2001: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_curr_code || '+');
2002: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_inv_due_date || '+');
2003: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_nanme || '+');
2004: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_term_desc || '+');
2005: END IF;
2006:
2007: --------------------------------------------------------------------------
2008: l_debug_info := 'fetching all contacts emails to send notification ';

Line 2014: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_email || '+');

2010:
2011: l_email := get_contact_emails(p_customer_id,p_customer_acct_site_id);
2012:
2013: IF (PG_DEBUG = 'Y') THEN
2014: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_email || '+');
2015: END IF;
2016:
2017: ------------------------------------------------------------------------------------------
2018: l_debug_info := 'check if emails exits , if yes creating adhoc user , if no invoice complete ';

Line 2029: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'adhoc username :: ' || l_adhoc_user_name || '+');

2025: l_adhoc_user_name := l_role_prefix || l_customer_trx_id;
2026: l_adhoc_user_display_name := l_adhoc_user_name;
2027:
2028: IF (PG_DEBUG = 'Y') THEN
2029: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'adhoc username :: ' || l_adhoc_user_name || '+');
2030: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'adhoc display name :: ' || l_adhoc_user_display_name || '+');
2031: END IF;
2032:
2033: -----------------------------------------------------

Line 2030: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'adhoc display name :: ' || l_adhoc_user_display_name || '+');

2026: l_adhoc_user_display_name := l_adhoc_user_name;
2027:
2028: IF (PG_DEBUG = 'Y') THEN
2029: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'adhoc username :: ' || l_adhoc_user_name || '+');
2030: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'adhoc display name :: ' || l_adhoc_user_display_name || '+');
2031: END IF;
2032:
2033: -----------------------------------------------------
2034: l_debug_info := 'checking for is role already exists';

Line 2049: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_role_exists :: ' || l_role_exists || '+');

2045: l_role_exists:= 0;
2046: end;
2047:
2048: IF (PG_DEBUG = 'Y') THEN
2049: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_role_exists :: ' || l_role_exists || '+');
2050: END IF;
2051:
2052: if l_role_exists = 0 then
2053:

Line 2135: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

2131: rslt := 'COMPLETE:' || 'N';
2132: wf_core.context('ARI_UTILITIES','DET_IF_SEND_EMAIL',l_itemtype,
2133: l_itemkey,to_char(actid),funcmode);
2134: IF (PG_DEBUG = 'Y') THEN
2135: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2136: arp_standard.debug('ERROR =>'|| SQLERRM);
2137: arp_standard.debug('Debug Info : '||l_debug_info);
2138: END IF;
2139: raise;

Line 2136: arp_standard.debug('ERROR =>'|| SQLERRM);

2132: wf_core.context('ARI_UTILITIES','DET_IF_SEND_EMAIL',l_itemtype,
2133: l_itemkey,to_char(actid),funcmode);
2134: IF (PG_DEBUG = 'Y') THEN
2135: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2136: arp_standard.debug('ERROR =>'|| SQLERRM);
2137: arp_standard.debug('Debug Info : '||l_debug_info);
2138: END IF;
2139: raise;
2140:

Line 2137: arp_standard.debug('Debug Info : '||l_debug_info);

2133: l_itemkey,to_char(actid),funcmode);
2134: IF (PG_DEBUG = 'Y') THEN
2135: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2136: arp_standard.debug('ERROR =>'|| SQLERRM);
2137: arp_standard.debug('Debug Info : '||l_debug_info);
2138: END IF;
2139: raise;
2140:
2141: end det_if_send_email;

Line 2312: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

2308:
2309: EXCEPTION
2310: WHEN OTHERS THEN
2311: IF (PG_DEBUG = 'Y') THEN
2312: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2313: arp_standard.debug('ERROR =>'|| SQLERRM);
2314: arp_standard.debug('Debug Info : '||l_debug_info);
2315: END IF;
2316: ROLLBACK TO CANCEL_DISPUTE;

Line 2313: arp_standard.debug('ERROR =>'|| SQLERRM);

2309: EXCEPTION
2310: WHEN OTHERS THEN
2311: IF (PG_DEBUG = 'Y') THEN
2312: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2313: arp_standard.debug('ERROR =>'|| SQLERRM);
2314: arp_standard.debug('Debug Info : '||l_debug_info);
2315: END IF;
2316: ROLLBACK TO CANCEL_DISPUTE;
2317: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2314: arp_standard.debug('Debug Info : '||l_debug_info);

2310: WHEN OTHERS THEN
2311: IF (PG_DEBUG = 'Y') THEN
2312: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2313: arp_standard.debug('ERROR =>'|| SQLERRM);
2314: arp_standard.debug('Debug Info : '||l_debug_info);
2315: END IF;
2316: ROLLBACK TO CANCEL_DISPUTE;
2317: p_return_status := FND_API.G_RET_STS_ERROR;
2318: END cancel_dispute;