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 1598: arp_standard.debug(l_debug_info);

1594: ----------------------------------------------------------------------------------------
1595: l_debug_info := 'Fetch Bill to Location';
1596: -----------------------------------------------------------------------------------------
1597: IF (PG_DEBUG = 'Y') THEN
1598: arp_standard.debug(l_debug_info);
1599: END IF;
1600:
1601: FOR c01_rec IN c01 (p_address_id) LOOP
1602: l_site_uses := l_site_uses || l_separator ||c01_rec.location;

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

1611:
1612: EXCEPTION
1613: WHEN OTHERS THEN
1614: IF (PG_DEBUG = 'Y') THEN
1615: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1616: arp_standard.debug('ERROR =>'|| SQLERRM);
1617: arp_standard.debug('Debug Info : '||l_debug_info);
1618: END IF;
1619:

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

1612: EXCEPTION
1613: WHEN OTHERS THEN
1614: IF (PG_DEBUG = 'Y') THEN
1615: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1616: arp_standard.debug('ERROR =>'|| SQLERRM);
1617: arp_standard.debug('Debug Info : '||l_debug_info);
1618: END IF;
1619:
1620: END;

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

1613: WHEN OTHERS THEN
1614: IF (PG_DEBUG = 'Y') THEN
1615: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1616: arp_standard.debug('ERROR =>'|| SQLERRM);
1617: arp_standard.debug('Debug Info : '||l_debug_info);
1618: END IF;
1619:
1620: END;
1621:

Line 1664: arp_standard.debug(l_debug_info);

1660: ----------------------------------------------------------------------------------------
1661: l_debug_info := 'Fetch Bill to Site use id';
1662: -----------------------------------------------------------------------------------------
1663: IF (PG_DEBUG = 'Y') THEN
1664: arp_standard.debug(l_debug_info);
1665: END IF;
1666:
1667: FOR c01_rec IN c01 (p_address_id) LOOP
1668: l_site_use_codes := l_site_use_codes || l_separator || c01_rec.site_use_code;

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

1681:
1682: EXCEPTION
1683: WHEN OTHERS THEN
1684: IF (PG_DEBUG = 'Y') THEN
1685: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1686: arp_standard.debug('ERROR =>'|| SQLERRM);
1687: arp_standard.debug('Debug Info : '||l_debug_info);
1688: END IF;
1689:

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

1682: EXCEPTION
1683: WHEN OTHERS THEN
1684: IF (PG_DEBUG = 'Y') THEN
1685: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1686: arp_standard.debug('ERROR =>'|| SQLERRM);
1687: arp_standard.debug('Debug Info : '||l_debug_info);
1688: END IF;
1689:
1690:

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

1683: WHEN OTHERS THEN
1684: IF (PG_DEBUG = 'Y') THEN
1685: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
1686: arp_standard.debug('ERROR =>'|| SQLERRM);
1687: arp_standard.debug('Debug Info : '||l_debug_info);
1688: END IF;
1689:
1690:
1691:

Line 2002: arp_standard.debug('ari_utilities.strip_white_spaces()+');

1998: len_strip_num number := 0;
1999: l_strip_num_char character_tab_typ;
2000: BEGIN
2001: IF PG_DEBUG in ('Y', 'C') THEN
2002: arp_standard.debug('ari_utilities.strip_white_spaces()+');
2003: END IF;
2004:
2005: SELECT lengthb(p_num_to_strip)
2006: INTO len_strip_num

Line 2024: arp_standard.debug('ari_utilities.strip_white_spaces()-');

2020: END IF;
2021: END LOOP;
2022:
2023: IF PG_DEBUG in ('Y', 'C') THEN
2024: arp_standard.debug('ari_utilities.strip_white_spaces()-');
2025: END IF;
2026: EXCEPTION
2027: when OTHERS then
2028: raise;

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

2093: --------------------------------------------------------------------
2094: l_debug_info := 'In debug mode, log we have entered this procedure';
2095: --------------------------------------------------------------------
2096: IF (PG_DEBUG = 'Y') THEN
2097: arp_standard.debug(G_PKG_NAME || l_procedure_name || '+');
2098: END IF;
2099:
2100: l_customer_trx_id := p_event.GetValueForParameter('CUSTOMER_TRX_ID');
2101: l_org_id := p_event.GetValueForParameter('ORG_ID');

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

2104: l_application_id := p_event.GetValueForParameter('RESP_APPL_ID');
2105:
2106: IF (PG_DEBUG = 'Y') THEN
2107:
2108: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);
2109: arp_standard.debug ('l_org_id ='||l_org_id);
2110: arp_standard.debug ('l_user_id ='||l_user_id);
2111: arp_standard.debug ('l_resp_id ='||l_resp_id);
2112: arp_standard.debug ('l_application_id ='||l_application_id);

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

2105:
2106: IF (PG_DEBUG = 'Y') THEN
2107:
2108: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);
2109: arp_standard.debug ('l_org_id ='||l_org_id);
2110: arp_standard.debug ('l_user_id ='||l_user_id);
2111: arp_standard.debug ('l_resp_id ='||l_resp_id);
2112: arp_standard.debug ('l_application_id ='||l_application_id);
2113: END IF;

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

2106: IF (PG_DEBUG = 'Y') THEN
2107:
2108: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);
2109: arp_standard.debug ('l_org_id ='||l_org_id);
2110: arp_standard.debug ('l_user_id ='||l_user_id);
2111: arp_standard.debug ('l_resp_id ='||l_resp_id);
2112: arp_standard.debug ('l_application_id ='||l_application_id);
2113: END IF;
2114:

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

2107:
2108: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);
2109: arp_standard.debug ('l_org_id ='||l_org_id);
2110: arp_standard.debug ('l_user_id ='||l_user_id);
2111: arp_standard.debug ('l_resp_id ='||l_resp_id);
2112: arp_standard.debug ('l_application_id ='||l_application_id);
2113: END IF;
2114:
2115: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);

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

2108: arp_standard.debug ('l_customer_trx_id ='||l_customer_trx_id);
2109: arp_standard.debug ('l_org_id ='||l_org_id);
2110: arp_standard.debug ('l_user_id ='||l_user_id);
2111: arp_standard.debug ('l_resp_id ='||l_resp_id);
2112: arp_standard.debug ('l_application_id ='||l_application_id);
2113: END IF;
2114:
2115: fnd_global.apps_initialize(l_user_id,l_resp_id,l_application_id);
2116:

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

2134: where hp.party_id = hca.party_id
2135: and hca.cust_account_id = l_customer_id;
2136:
2137: IF (PG_DEBUG = 'Y') THEN
2138: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_id || '+');
2139: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_acct_site_id || '+');
2140: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
2141: END IF;
2142:

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

2135: and hca.cust_account_id = l_customer_id;
2136:
2137: IF (PG_DEBUG = 'Y') THEN
2138: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_id || '+');
2139: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_acct_site_id || '+');
2140: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
2141: END IF;
2142:
2143: --------------------------------------------------------------------

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

2136:
2137: IF (PG_DEBUG = 'Y') THEN
2138: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_id || '+');
2139: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_customer_acct_site_id || '+');
2140: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_trx_number || '+');
2141: END IF;
2142:
2143: --------------------------------------------------------------------
2144: l_debug_info := 'creating workflow process';

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

2209: l_debug_info := 'Starting Workflow..';
2210: ----------------------------------------------------------------------------
2211:
2212: IF (PG_DEBUG = 'Y') THEN
2213: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS') || '+');
2214: END IF;
2215:
2216: WF_ENGINE.StartProcess(l_itemtype,l_customer_trx_id);
2217:

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

2220:
2221: EXCEPTION
2222: WHEN OTHERS THEN
2223: IF (PG_DEBUG = 'Y') THEN
2224: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2225: arp_standard.debug('ERROR =>'|| SQLERRM);
2226: arp_standard.debug('Debug Info : '||l_debug_info);
2227: END IF;
2228: RETURN 'ERROR';

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

2221: EXCEPTION
2222: WHEN OTHERS THEN
2223: IF (PG_DEBUG = 'Y') THEN
2224: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2225: arp_standard.debug('ERROR =>'|| SQLERRM);
2226: arp_standard.debug('Debug Info : '||l_debug_info);
2227: END IF;
2228: RETURN 'ERROR';
2229:

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

2222: WHEN OTHERS THEN
2223: IF (PG_DEBUG = 'Y') THEN
2224: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2225: arp_standard.debug('ERROR =>'|| SQLERRM);
2226: arp_standard.debug('Debug Info : '||l_debug_info);
2227: END IF;
2228: RETURN 'ERROR';
2229:
2230: END invoke_invoice_email_notwf;

Line 2290: arp_standard.debug(l_debug_info);

2286: ----------------------------------------------------------------------------------------
2287: l_debug_info := 'fetches all email addres at account level for all self sevice users';
2288: -----------------------------------------------------------------------------------------
2289: IF (PG_DEBUG = 'Y') THEN
2290: arp_standard.debug(l_debug_info);
2291: END IF;
2292:
2293: FOR contact_rec in contact_cur(p_customer_id,NULL) LOOP
2294:

Line 2321: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'emails adhoc user list at Account Level ' || l_user_email_addr_list(i));

2317: ----------------------------------------------------------------------------------------
2318: l_debug_info := 'emails at account level';
2319: -----------------------------------------------------------------------------------------
2320: IF (PG_DEBUG = 'Y') THEN
2321: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'emails adhoc user list at Account Level ' || l_user_email_addr_list(i));
2322: END IF;
2323:
2324: i := i+1;
2325:

Line 2362: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'emails adhoc user list at Site Level ' || l_user_email_addr_list(i));

2358: ----------------------------------------------------------------------------------------
2359: l_debug_info := 'emails at account level';
2360: -----------------------------------------------------------------------------------------
2361: IF (PG_DEBUG = 'Y') THEN
2362: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'emails adhoc user list at Site Level ' || l_user_email_addr_list(i));
2363: END IF;
2364:
2365: i := i+1;
2366:

Line 2374: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'emails adhoc user list after Removing Duplicates ' || l_adhoc_users_list);

2370:
2371: l_adhoc_users_list := remove_duplicate_user_names( l_user_email_list => l_user_email_addr_list);
2372:
2373: IF (PG_DEBUG = 'Y') THEN
2374: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'emails adhoc user list after Removing Duplicates ' || l_adhoc_users_list);
2375: END IF;
2376:
2377: RETURN l_adhoc_users_list;
2378:

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

2378:
2379: EXCEPTION
2380: WHEN OTHERS THEN
2381: IF (PG_DEBUG = 'Y') THEN
2382: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2383: arp_standard.debug('ERROR =>'|| SQLERRM);
2384: arp_standard.debug('Debug Info : '||l_debug_info);
2385: END IF;
2386: RETURN 'ERROR';

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

2379: EXCEPTION
2380: WHEN OTHERS THEN
2381: IF (PG_DEBUG = 'Y') THEN
2382: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2383: arp_standard.debug('ERROR =>'|| SQLERRM);
2384: arp_standard.debug('Debug Info : '||l_debug_info);
2385: END IF;
2386: RETURN 'ERROR';
2387:

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

2380: WHEN OTHERS THEN
2381: IF (PG_DEBUG = 'Y') THEN
2382: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2383: arp_standard.debug('ERROR =>'|| SQLERRM);
2384: arp_standard.debug('Debug Info : '||l_debug_info);
2385: END IF;
2386: RETURN 'ERROR';
2387:
2388: END get_contact_emails_adhoc_list;

Line 2405: arp_standard.debug(l_debug_info);

2401: ----------------------------------------------------------------------------------------
2402: l_debug_info := 'Removes All the Dulicate Uses in the List';
2403: -----------------------------------------------------------------------------------------
2404: IF (PG_DEBUG = 'Y') THEN
2405: arp_standard.debug(l_debug_info);
2406: END IF;
2407:
2408:
2409: for i in 1..v_email_list.count loop

Line 2463: arp_standard.debug(l_debug_info);

2459: ----------------------------------------------------------------------------------------
2460: l_debug_info := 'Checks whether the user is already created are not if created the value will be re-used';
2461: -----------------------------------------------------------------------------------------
2462: IF (PG_DEBUG = 'Y') THEN
2463: arp_standard.debug(l_debug_info);
2464: END IF;
2465:
2466: -- Checks whether the user is already created are not.. if created the loop will exit and re-use the existing value
2467: FOR user_name_by_email_addr_rec in user_name_by_email_addr(p_email_address) LOOP

Line 2471: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'Existing Adhoc user ' || l_adhoc_user_name);

2467: FOR user_name_by_email_addr_rec in user_name_by_email_addr(p_email_address) LOOP
2468:
2469: l_adhoc_user_name := user_name_by_email_addr_rec.name;
2470: IF (PG_DEBUG = 'Y') THEN
2471: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'Existing Adhoc user ' || l_adhoc_user_name);
2472: END IF;
2473: exit when user_name_by_email_addr%rowcount>0;
2474: end loop;
2475:

Line 2485: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'removed the user '|| l_adhoc_user_name ||' from the role ' || l_adhoc_role_name);

2481:
2482: WF_DIRECTORY.RemoveUsersFromAdHocRole (role_name =>l_adhoc_role_name,
2483: role_users => l_adhoc_user_name);
2484: IF (PG_DEBUG = 'Y') THEN
2485: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'removed the user '|| l_adhoc_user_name ||' from the role ' || l_adhoc_role_name);
2486: END IF;
2487: end loop;
2488:
2489:

Line 2533: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_CUSTOMER_TRX_ID ::' || l_customer_trx_id );

2529: l_customer_trx_id:= wf_engine.GetItemAttrText(itemtype => l_itemtype,
2530: itemkey => l_itemkey,
2531: aname => 'ARI_CUSTOMER_TRX_ID');
2532: IF (PG_DEBUG = 'Y') THEN
2533: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_CUSTOMER_TRX_ID ::' || l_customer_trx_id );
2534: END IF;
2535:
2536: -----------------------------------------------------------
2537: l_debug_info := 'Retrieve ARI_TRX_NUM Item Attribute';

Line 2544: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_TRX_NUMBER ::' || l_trx_number);

2540: l_trx_number:= wf_engine.GetItemAttrText(itemtype => l_itemtype,
2541: itemkey => l_itemkey,
2542: aname => 'ARI_TRX_NUMBER');
2543: IF (PG_DEBUG = 'Y') THEN
2544: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_TRX_NUMBER ::' || l_trx_number);
2545: END IF;
2546:
2547: -----------------------------------------------------------
2548: l_debug_info := 'Retrieve ARI_CUST_ACCT_NUM Item Attribute';

Line 2555: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_CUST_ACCT_ID ::' || p_customer_id );

2551: p_customer_id:= wf_engine.GetItemAttrText(itemtype => l_itemtype,
2552: itemkey => l_itemkey,
2553: aname => 'ARI_CUST_ACCT_ID');
2554: IF (PG_DEBUG = 'Y') THEN
2555: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_CUST_ACCT_ID ::' || p_customer_id );
2556: END IF;
2557:
2558: ---------------------------------------------------------------
2559: l_debug_info := 'Retrieve ARI_CUST_ACCT_SITE_ID Item Attribute';

Line 2567: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_CUST_ACCT_SITE_ID ::' || p_customer_acct_site_id );

2563: itemkey => l_itemkey,
2564: aname => 'ARI_CUST_ACCT_SITE_ID');
2565:
2566: IF (PG_DEBUG = 'Y') THEN
2567: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_CUST_ACCT_SITE_ID ::' || p_customer_acct_site_id );
2568: END IF;
2569:
2570: --------------------------------------------------------------------------
2571: l_debug_info := 'selecting all the attributes required to send in notification';

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

2578: and aps.customer_id = p_customer_id
2579: and aps.term_id = t.term_id(+);
2580:
2581: IF (PG_DEBUG = 'Y') THEN
2582: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_number ::'|| l_trx_number );
2583: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_amt_due ::'|| l_trx_amt_due );
2584: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_curr_code ::'||l_trx_curr_code );
2585: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_due_date ::'||l_trx_due_date );
2586: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_name ::'||l_trx_term_name );

Line 2583: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_amt_due ::'|| l_trx_amt_due );

2579: and aps.term_id = t.term_id(+);
2580:
2581: IF (PG_DEBUG = 'Y') THEN
2582: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_number ::'|| l_trx_number );
2583: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_amt_due ::'|| l_trx_amt_due );
2584: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_curr_code ::'||l_trx_curr_code );
2585: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_due_date ::'||l_trx_due_date );
2586: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_name ::'||l_trx_term_name );
2587: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_desc ::'||l_trx_term_desc );

Line 2584: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_curr_code ::'||l_trx_curr_code );

2580:
2581: IF (PG_DEBUG = 'Y') THEN
2582: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_number ::'|| l_trx_number );
2583: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_amt_due ::'|| l_trx_amt_due );
2584: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_curr_code ::'||l_trx_curr_code );
2585: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_due_date ::'||l_trx_due_date );
2586: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_name ::'||l_trx_term_name );
2587: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_desc ::'||l_trx_term_desc );
2588: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_type ::'||l_trx_type );

Line 2585: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_due_date ::'||l_trx_due_date );

2581: IF (PG_DEBUG = 'Y') THEN
2582: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_number ::'|| l_trx_number );
2583: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_amt_due ::'|| l_trx_amt_due );
2584: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_curr_code ::'||l_trx_curr_code );
2585: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_due_date ::'||l_trx_due_date );
2586: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_name ::'||l_trx_term_name );
2587: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_desc ::'||l_trx_term_desc );
2588: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_type ::'||l_trx_type );
2589: END IF;

Line 2586: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_name ::'||l_trx_term_name );

2582: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_number ::'|| l_trx_number );
2583: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_amt_due ::'|| l_trx_amt_due );
2584: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_curr_code ::'||l_trx_curr_code );
2585: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_due_date ::'||l_trx_due_date );
2586: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_name ::'||l_trx_term_name );
2587: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_desc ::'||l_trx_term_desc );
2588: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_type ::'||l_trx_type );
2589: END IF;
2590:

Line 2587: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_desc ::'||l_trx_term_desc );

2583: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_amt_due ::'|| l_trx_amt_due );
2584: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_curr_code ::'||l_trx_curr_code );
2585: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_due_date ::'||l_trx_due_date );
2586: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_name ::'||l_trx_term_name );
2587: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_desc ::'||l_trx_term_desc );
2588: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_type ::'||l_trx_type );
2589: END IF;
2590:
2591: ------------------------------------------------------------------------------------------

Line 2588: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_type ::'||l_trx_type );

2584: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_curr_code ::'||l_trx_curr_code );
2585: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_due_date ::'||l_trx_due_date );
2586: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_name ::'||l_trx_term_name );
2587: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_term_desc ::'||l_trx_term_desc );
2588: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_trx_type ::'||l_trx_type );
2589: END IF;
2590:
2591: ------------------------------------------------------------------------------------------
2592: l_debug_info := 'check if wether to send invoice notification or credit memo notification';

Line 2604: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_result_code ::'||l_result_code );

2600: l_result_code := 'OTHER';
2601: end if;
2602:
2603: IF (PG_DEBUG = 'Y') THEN
2604: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_result_code ::'||l_result_code );
2605: END IF;
2606:
2607: --------------------------------------------------------------------------
2608: l_debug_info := 'fetching all contacts emails adhoc users list to send notification ';

Line 2614: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_users_list ::' || l_users_list );

2610:
2611: l_users_list := get_contact_emails_adhoc_list(p_customer_id,p_customer_acct_site_id);
2612:
2613: IF (PG_DEBUG = 'Y') THEN
2614: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'l_users_list ::' || l_users_list );
2615: END IF;
2616:
2617: ------------------------------------------------------------------------------------------
2618: l_debug_info := 'check if emails exits , if yes creating adhoc user , if no invoice complete ';

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

2625: l_adhoc_user_name := l_role_prefix || l_customer_trx_id;
2626: l_adhoc_user_display_name := l_adhoc_user_name;
2627:
2628: IF (PG_DEBUG = 'Y') THEN
2629: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'adhoc username :: ' || l_adhoc_user_name );
2630: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'adhoc display name :: ' || l_adhoc_user_display_name);
2631: END IF;
2632:
2633: -------------------------------------------------------

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

2626: l_adhoc_user_display_name := l_adhoc_user_name;
2627:
2628: IF (PG_DEBUG = 'Y') THEN
2629: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'adhoc username :: ' || l_adhoc_user_name );
2630: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'adhoc display name :: ' || l_adhoc_user_display_name);
2631: END IF;
2632:
2633: -------------------------------------------------------
2634: l_debug_info := 'if no role exits ,creating a new role';

Line 2641: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_adhoc_user_name || 'Created Role ' );

2637: role_display_name => l_adhoc_user_display_name,
2638: notification_preference => 'MAILHTM2');
2639:
2640: IF (PG_DEBUG = 'Y') THEN
2641: arp_standard.debug(G_PKG_NAME || l_procedure_name || l_adhoc_user_name || 'Created Role ' );
2642: END IF;
2643:
2644: wf_directory.AddUsersToAdhocRole(role_name => l_adhoc_user_name,
2645: role_users => l_users_list);

Line 2650: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'Assigned Users To The Role' || l_adhoc_user_name );

2646:
2647: end if;
2648:
2649: IF (PG_DEBUG = 'Y') THEN
2650: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'Assigned Users To The Role' || l_adhoc_user_name );
2651: END IF;
2652:
2653: --------------------------------------------------------------
2654: l_debug_info := 'Set AR_NOTIFY_ROLES Item Attribute';

Line 2663: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_NOTIFY_ROLES set to :: ' ||l_adhoc_user_name);

2659: 'ARI_NOTIFY_ROLES',
2660: l_adhoc_user_name);
2661:
2662: IF (PG_DEBUG = 'Y') THEN
2663: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_NOTIFY_ROLES set to :: ' ||l_adhoc_user_name);
2664: END IF;
2665: --------------------------------------------------------------
2666: l_debug_info := 'Set ARI_TRX_NUM Item Attribute';
2667: --------------------------------------------------------------

Line 2675: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_NUMBER set to :: ' ||l_trx_number);

2671: 'ARI_TRX_NUMBER',
2672: l_trx_number);
2673:
2674: IF (PG_DEBUG = 'Y') THEN
2675: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_NUMBER set to :: ' ||l_trx_number);
2676: END IF;
2677:
2678: --------------------------------------------------------------
2679: l_debug_info := 'Set ARI_TRX_AMT_DUE Item Attribute';

Line 2688: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_AMT_DUE set to :: ' ||l_trx_amt_due);

2684: 'ARI_TRX_AMT_DUE',
2685: l_trx_amt_due);
2686:
2687: IF (PG_DEBUG = 'Y') THEN
2688: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_AMT_DUE set to :: ' ||l_trx_amt_due);
2689: END IF;
2690:
2691: --------------------------------------------------------------
2692: l_debug_info := 'Set ARI_INV_CUR_CODE Item Attribute';

Line 2701: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_CUR_CODE set to :: ' ||l_trx_curr_code);

2697: 'ARI_TRX_CUR_CODE',
2698: l_trx_curr_code);
2699:
2700: IF (PG_DEBUG = 'Y') THEN
2701: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_CUR_CODE set to :: ' ||l_trx_curr_code);
2702: END IF;
2703:
2704: --------------------------------------------------------------
2705: l_debug_info := 'Set ARI_TRX_DUE_DATE Item Attribute';

Line 2714: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_DUE_DATE set to :: ' ||l_trx_due_date);

2710: 'ARI_TRX_DUE_DATE',
2711: l_trx_due_date);
2712:
2713: IF (PG_DEBUG = 'Y') THEN
2714: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_DUE_DATE set to :: ' ||l_trx_due_date);
2715: END IF;
2716:
2717: --------------------------------------------------------------
2718: l_debug_info := 'Set ARI_TRX_PAY_TERM Item Attribute';

Line 2727: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_PAY_TERM set to :: ' ||l_trx_term_name);

2723: 'ARI_TRX_PAY_TERM',
2724: l_trx_term_name);
2725:
2726: IF (PG_DEBUG = 'Y') THEN
2727: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_PAY_TERM set to :: ' ||l_trx_term_name);
2728: END IF;
2729:
2730: --------------------------------------------------------------
2731: l_debug_info := 'Set ARI_TRX_PAY_TERM_DESC Item Attribute';

Line 2740: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_PAY_TERM_DESC set to :: ' || l_trx_term_desc);

2736: 'ARI_TRX_PAY_TERM_DESC',
2737: l_trx_term_desc);
2738:
2739: IF (PG_DEBUG = 'Y') THEN
2740: arp_standard.debug(G_PKG_NAME || l_procedure_name || ' Attribute ARI_TRX_PAY_TERM_DESC set to :: ' || l_trx_term_desc);
2741: END IF;
2742:
2743: rslt := 'COMPLETE:' || l_result_code;
2744:

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

2747: rslt := 'COMPLETE:' || 'N';
2748: wf_core.context('ARI_UTILITIES','DET_IF_SEND_EMAIL',l_itemtype,
2749: l_itemkey,to_char(actid),funcmode);
2750: IF (PG_DEBUG = 'Y') THEN
2751: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2752: arp_standard.debug('ERROR =>'|| SQLERRM);
2753: arp_standard.debug('Debug Info : '||l_debug_info);
2754: END IF;
2755: raise;

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

2748: wf_core.context('ARI_UTILITIES','DET_IF_SEND_EMAIL',l_itemtype,
2749: l_itemkey,to_char(actid),funcmode);
2750: IF (PG_DEBUG = 'Y') THEN
2751: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2752: arp_standard.debug('ERROR =>'|| SQLERRM);
2753: arp_standard.debug('Debug Info : '||l_debug_info);
2754: END IF;
2755: raise;
2756:

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

2749: l_itemkey,to_char(actid),funcmode);
2750: IF (PG_DEBUG = 'Y') THEN
2751: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2752: arp_standard.debug('ERROR =>'|| SQLERRM);
2753: arp_standard.debug('Debug Info : '||l_debug_info);
2754: END IF;
2755: raise;
2756:
2757: end det_if_send_email;

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

2924:
2925: EXCEPTION
2926: WHEN OTHERS THEN
2927: IF (PG_DEBUG = 'Y') THEN
2928: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2929: arp_standard.debug('ERROR =>'|| SQLERRM);
2930: arp_standard.debug('Debug Info : '||l_debug_info);
2931: END IF;
2932: ROLLBACK TO CANCEL_DISPUTE;

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

2925: EXCEPTION
2926: WHEN OTHERS THEN
2927: IF (PG_DEBUG = 'Y') THEN
2928: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2929: arp_standard.debug('ERROR =>'|| SQLERRM);
2930: arp_standard.debug('Debug Info : '||l_debug_info);
2931: END IF;
2932: ROLLBACK TO CANCEL_DISPUTE;
2933: p_return_status := FND_API.G_RET_STS_ERROR;

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

2926: WHEN OTHERS THEN
2927: IF (PG_DEBUG = 'Y') THEN
2928: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2929: arp_standard.debug('ERROR =>'|| SQLERRM);
2930: arp_standard.debug('Debug Info : '||l_debug_info);
2931: END IF;
2932: ROLLBACK TO CANCEL_DISPUTE;
2933: p_return_status := FND_API.G_RET_STS_ERROR;
2934: END cancel_dispute;

Line 2989: arp_standard.debug('In get_link_filter p_txn_no:'||p_txn_no||'p_txn_type:'||

2985: where trx_number=p_txn_no
2986: and PAYMENT_SCHEDULE_ID = p_payment_schedule_id;
2987: end if;
2988: IF (PG_DEBUG = 'Y') THEN
2989: arp_standard.debug('In get_link_filter p_txn_no:'||p_txn_no||'p_txn_type:'||
2990: p_txn_type||'p_cust_trx_id:'||to_char(p_cust_trx_id)||
2991: 'p_payment_schedule_id:'||to_char(p_payment_schedule_id));
2992: END IF;
2993: l_profile_limit_days := FND_PROFILE.VALUE('ARI_FILTER_TRXDATE_OLDER');

Line 2998: arp_standard.debug('In get_link_filter l_print_flag:'||

2994: l_print_profile := FND_PROFILE.VALUE('ARI_FILTER_DONOTPRINT_TRX');
2995:
2996:
2997: IF (PG_DEBUG = 'Y') THEN
2998: arp_standard.debug('In get_link_filter l_print_flag:'||
2999: l_print_flag||'l_print_profile: '||l_print_profile);
3000: END IF;
3001: if(l_profile_limit_days is not null and l_txn_difference > l_profile_limit_days ) THEN
3002: p_result:= 'Y';

Line 3012: arp_standard.debug('Unexpected Exception in get_link_filter'||SQLERRM);

3008: EXCEPTION
3009: WHEN OTHERS THEN
3010: p_result:= 'N';
3011: IF (PG_DEBUG = 'Y') THEN
3012: arp_standard.debug('Unexpected Exception in get_link_filter'||SQLERRM);
3013: END IF;
3014: return p_result;
3015: END get_link_filter;
3016: