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.OE_CREDIT_INTERFACE_UTIL dependencies on OE_DEBUG_PUB

Line 363: OE_DEBUG_PUB.Add(' ');

359:
360: BEGIN
361: IF G_debug_flag = 'Y'
362: THEN
363: OE_DEBUG_PUB.Add(' ');
364: OE_DEBUG_PUB.ADD('OEXUCERB: IN Get_exposure_amount',1);
365: END IF;
366:
367: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 364: OE_DEBUG_PUB.ADD('OEXUCERB: IN Get_exposure_amount',1);

360: BEGIN
361: IF G_debug_flag = 'Y'
362: THEN
363: OE_DEBUG_PUB.Add(' ');
364: OE_DEBUG_PUB.ADD('OEXUCERB: IN Get_exposure_amount',1);
365: END IF;
366:
367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368:

Line 371: OE_DEBUG_PUB.Add('Exposure Input parameters ');

367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368:
369: IF G_debug_flag = 'Y'
370: THEN
371: OE_DEBUG_PUB.Add('Exposure Input parameters ');
372: OE_DEBUG_PUB.Add('--------------------------------------');
373: OE_DEBUG_PUB.Add('p_customer_id = '|| p_customer_id, 1);
374: OE_DEBUG_PUB.Add('p_site_use_id = '|| p_site_use_id, 1);
375: OE_DEBUG_PUB.Add('p_header_id = '|| p_header_id);

Line 372: OE_DEBUG_PUB.Add('--------------------------------------');

368:
369: IF G_debug_flag = 'Y'
370: THEN
371: OE_DEBUG_PUB.Add('Exposure Input parameters ');
372: OE_DEBUG_PUB.Add('--------------------------------------');
373: OE_DEBUG_PUB.Add('p_customer_id = '|| p_customer_id, 1);
374: OE_DEBUG_PUB.Add('p_site_use_id = '|| p_site_use_id, 1);
375: OE_DEBUG_PUB.Add('p_header_id = '|| p_header_id);
376: OE_DEBUG_PUB.Add('p_credit_check_rule_id = '|| p_credit_check_rule_rec.credit_check_rule_id);

Line 373: OE_DEBUG_PUB.Add('p_customer_id = '|| p_customer_id, 1);

369: IF G_debug_flag = 'Y'
370: THEN
371: OE_DEBUG_PUB.Add('Exposure Input parameters ');
372: OE_DEBUG_PUB.Add('--------------------------------------');
373: OE_DEBUG_PUB.Add('p_customer_id = '|| p_customer_id, 1);
374: OE_DEBUG_PUB.Add('p_site_use_id = '|| p_site_use_id, 1);
375: OE_DEBUG_PUB.Add('p_header_id = '|| p_header_id);
376: OE_DEBUG_PUB.Add('p_credit_check_rule_id = '|| p_credit_check_rule_rec.credit_check_rule_id);
377: OE_DEBUG_PUB.Add('Conversion type = '|| p_credit_check_rule_rec.conversion_type);

Line 374: OE_DEBUG_PUB.Add('p_site_use_id = '|| p_site_use_id, 1);

370: THEN
371: OE_DEBUG_PUB.Add('Exposure Input parameters ');
372: OE_DEBUG_PUB.Add('--------------------------------------');
373: OE_DEBUG_PUB.Add('p_customer_id = '|| p_customer_id, 1);
374: OE_DEBUG_PUB.Add('p_site_use_id = '|| p_site_use_id, 1);
375: OE_DEBUG_PUB.Add('p_header_id = '|| p_header_id);
376: OE_DEBUG_PUB.Add('p_credit_check_rule_id = '|| p_credit_check_rule_rec.credit_check_rule_id);
377: OE_DEBUG_PUB.Add('Conversion type = '|| p_credit_check_rule_rec.conversion_type);
378: OE_DEBUG_PUB.Add('p_credit_level = '|| p_credit_level, 1);

Line 375: OE_DEBUG_PUB.Add('p_header_id = '|| p_header_id);

371: OE_DEBUG_PUB.Add('Exposure Input parameters ');
372: OE_DEBUG_PUB.Add('--------------------------------------');
373: OE_DEBUG_PUB.Add('p_customer_id = '|| p_customer_id, 1);
374: OE_DEBUG_PUB.Add('p_site_use_id = '|| p_site_use_id, 1);
375: OE_DEBUG_PUB.Add('p_header_id = '|| p_header_id);
376: OE_DEBUG_PUB.Add('p_credit_check_rule_id = '|| p_credit_check_rule_rec.credit_check_rule_id);
377: OE_DEBUG_PUB.Add('Conversion type = '|| p_credit_check_rule_rec.conversion_type);
378: OE_DEBUG_PUB.Add('p_credit_level = '|| p_credit_level, 1);
379: OE_DEBUG_PUB.Add('p_limit_curr_code = '|| p_limit_curr_code);

Line 376: OE_DEBUG_PUB.Add('p_credit_check_rule_id = '|| p_credit_check_rule_rec.credit_check_rule_id);

372: OE_DEBUG_PUB.Add('--------------------------------------');
373: OE_DEBUG_PUB.Add('p_customer_id = '|| p_customer_id, 1);
374: OE_DEBUG_PUB.Add('p_site_use_id = '|| p_site_use_id, 1);
375: OE_DEBUG_PUB.Add('p_header_id = '|| p_header_id);
376: OE_DEBUG_PUB.Add('p_credit_check_rule_id = '|| p_credit_check_rule_rec.credit_check_rule_id);
377: OE_DEBUG_PUB.Add('Conversion type = '|| p_credit_check_rule_rec.conversion_type);
378: OE_DEBUG_PUB.Add('p_credit_level = '|| p_credit_level, 1);
379: OE_DEBUG_PUB.Add('p_limit_curr_code = '|| p_limit_curr_code);
380: OE_DEBUG_PUB.Add('p_global_exposure_flag = '|| p_global_exposure_flag, 1);

Line 377: OE_DEBUG_PUB.Add('Conversion type = '|| p_credit_check_rule_rec.conversion_type);

373: OE_DEBUG_PUB.Add('p_customer_id = '|| p_customer_id, 1);
374: OE_DEBUG_PUB.Add('p_site_use_id = '|| p_site_use_id, 1);
375: OE_DEBUG_PUB.Add('p_header_id = '|| p_header_id);
376: OE_DEBUG_PUB.Add('p_credit_check_rule_id = '|| p_credit_check_rule_rec.credit_check_rule_id);
377: OE_DEBUG_PUB.Add('Conversion type = '|| p_credit_check_rule_rec.conversion_type);
378: OE_DEBUG_PUB.Add('p_credit_level = '|| p_credit_level, 1);
379: OE_DEBUG_PUB.Add('p_limit_curr_code = '|| p_limit_curr_code);
380: OE_DEBUG_PUB.Add('p_global_exposure_flag = '|| p_global_exposure_flag, 1);
381: OE_DEBUG_PUB.Add(' l_include_tax_flag = '|| l_include_tax_flag );

Line 378: OE_DEBUG_PUB.Add('p_credit_level = '|| p_credit_level, 1);

374: OE_DEBUG_PUB.Add('p_site_use_id = '|| p_site_use_id, 1);
375: OE_DEBUG_PUB.Add('p_header_id = '|| p_header_id);
376: OE_DEBUG_PUB.Add('p_credit_check_rule_id = '|| p_credit_check_rule_rec.credit_check_rule_id);
377: OE_DEBUG_PUB.Add('Conversion type = '|| p_credit_check_rule_rec.conversion_type);
378: OE_DEBUG_PUB.Add('p_credit_level = '|| p_credit_level, 1);
379: OE_DEBUG_PUB.Add('p_limit_curr_code = '|| p_limit_curr_code);
380: OE_DEBUG_PUB.Add('p_global_exposure_flag = '|| p_global_exposure_flag, 1);
381: OE_DEBUG_PUB.Add(' l_include_tax_flag = '|| l_include_tax_flag );
382: OE_DEBUG_PUB.Add(' l_freight_charges_flag = '|| l_freight_charges_flag );

Line 379: OE_DEBUG_PUB.Add('p_limit_curr_code = '|| p_limit_curr_code);

375: OE_DEBUG_PUB.Add('p_header_id = '|| p_header_id);
376: OE_DEBUG_PUB.Add('p_credit_check_rule_id = '|| p_credit_check_rule_rec.credit_check_rule_id);
377: OE_DEBUG_PUB.Add('Conversion type = '|| p_credit_check_rule_rec.conversion_type);
378: OE_DEBUG_PUB.Add('p_credit_level = '|| p_credit_level, 1);
379: OE_DEBUG_PUB.Add('p_limit_curr_code = '|| p_limit_curr_code);
380: OE_DEBUG_PUB.Add('p_global_exposure_flag = '|| p_global_exposure_flag, 1);
381: OE_DEBUG_PUB.Add(' l_include_tax_flag = '|| l_include_tax_flag );
382: OE_DEBUG_PUB.Add(' l_freight_charges_flag = '|| l_freight_charges_flag );
383: OE_DEBUG_PUB.Add(' l_include_returns_flag = '|| l_include_returns_flag );

Line 380: OE_DEBUG_PUB.Add('p_global_exposure_flag = '|| p_global_exposure_flag, 1);

376: OE_DEBUG_PUB.Add('p_credit_check_rule_id = '|| p_credit_check_rule_rec.credit_check_rule_id);
377: OE_DEBUG_PUB.Add('Conversion type = '|| p_credit_check_rule_rec.conversion_type);
378: OE_DEBUG_PUB.Add('p_credit_level = '|| p_credit_level, 1);
379: OE_DEBUG_PUB.Add('p_limit_curr_code = '|| p_limit_curr_code);
380: OE_DEBUG_PUB.Add('p_global_exposure_flag = '|| p_global_exposure_flag, 1);
381: OE_DEBUG_PUB.Add(' l_include_tax_flag = '|| l_include_tax_flag );
382: OE_DEBUG_PUB.Add(' l_freight_charges_flag = '|| l_freight_charges_flag );
383: OE_DEBUG_PUB.Add(' l_include_returns_flag = '|| l_include_returns_flag );
384: OE_DEBUG_PUB.Add(' l_include_uninvoiced_flag= '|| l_include_uninvoiced_flag );

Line 381: OE_DEBUG_PUB.Add(' l_include_tax_flag = '|| l_include_tax_flag );

377: OE_DEBUG_PUB.Add('Conversion type = '|| p_credit_check_rule_rec.conversion_type);
378: OE_DEBUG_PUB.Add('p_credit_level = '|| p_credit_level, 1);
379: OE_DEBUG_PUB.Add('p_limit_curr_code = '|| p_limit_curr_code);
380: OE_DEBUG_PUB.Add('p_global_exposure_flag = '|| p_global_exposure_flag, 1);
381: OE_DEBUG_PUB.Add(' l_include_tax_flag = '|| l_include_tax_flag );
382: OE_DEBUG_PUB.Add(' l_freight_charges_flag = '|| l_freight_charges_flag );
383: OE_DEBUG_PUB.Add(' l_include_returns_flag = '|| l_include_returns_flag );
384: OE_DEBUG_PUB.Add(' l_include_uninvoiced_flag= '|| l_include_uninvoiced_flag );
385:

Line 382: OE_DEBUG_PUB.Add(' l_freight_charges_flag = '|| l_freight_charges_flag );

378: OE_DEBUG_PUB.Add('p_credit_level = '|| p_credit_level, 1);
379: OE_DEBUG_PUB.Add('p_limit_curr_code = '|| p_limit_curr_code);
380: OE_DEBUG_PUB.Add('p_global_exposure_flag = '|| p_global_exposure_flag, 1);
381: OE_DEBUG_PUB.Add(' l_include_tax_flag = '|| l_include_tax_flag );
382: OE_DEBUG_PUB.Add(' l_freight_charges_flag = '|| l_freight_charges_flag );
383: OE_DEBUG_PUB.Add(' l_include_returns_flag = '|| l_include_returns_flag );
384: OE_DEBUG_PUB.Add(' l_include_uninvoiced_flag= '|| l_include_uninvoiced_flag );
385:
386: OE_DEBUG_PUB.Add('--------------End Parameters---------- ');

Line 383: OE_DEBUG_PUB.Add(' l_include_returns_flag = '|| l_include_returns_flag );

379: OE_DEBUG_PUB.Add('p_limit_curr_code = '|| p_limit_curr_code);
380: OE_DEBUG_PUB.Add('p_global_exposure_flag = '|| p_global_exposure_flag, 1);
381: OE_DEBUG_PUB.Add(' l_include_tax_flag = '|| l_include_tax_flag );
382: OE_DEBUG_PUB.Add(' l_freight_charges_flag = '|| l_freight_charges_flag );
383: OE_DEBUG_PUB.Add(' l_include_returns_flag = '|| l_include_returns_flag );
384: OE_DEBUG_PUB.Add(' l_include_uninvoiced_flag= '|| l_include_uninvoiced_flag );
385:
386: OE_DEBUG_PUB.Add('--------------End Parameters---------- ');
387: END IF;

Line 384: OE_DEBUG_PUB.Add(' l_include_uninvoiced_flag= '|| l_include_uninvoiced_flag );

380: OE_DEBUG_PUB.Add('p_global_exposure_flag = '|| p_global_exposure_flag, 1);
381: OE_DEBUG_PUB.Add(' l_include_tax_flag = '|| l_include_tax_flag );
382: OE_DEBUG_PUB.Add(' l_freight_charges_flag = '|| l_freight_charges_flag );
383: OE_DEBUG_PUB.Add(' l_include_returns_flag = '|| l_include_returns_flag );
384: OE_DEBUG_PUB.Add(' l_include_uninvoiced_flag= '|| l_include_uninvoiced_flag );
385:
386: OE_DEBUG_PUB.Add('--------------End Parameters---------- ');
387: END IF;
388:

Line 386: OE_DEBUG_PUB.Add('--------------End Parameters---------- ');

382: OE_DEBUG_PUB.Add(' l_freight_charges_flag = '|| l_freight_charges_flag );
383: OE_DEBUG_PUB.Add(' l_include_returns_flag = '|| l_include_returns_flag );
384: OE_DEBUG_PUB.Add(' l_include_uninvoiced_flag= '|| l_include_uninvoiced_flag );
385:
386: OE_DEBUG_PUB.Add('--------------End Parameters---------- ');
387: END IF;
388:
389: IF p_credit_level = 'SITE'
390: THEN

Line 401: OE_DEBUG_PUB.ADD(' Customer ID : ' || l_customer_id ,1);

397: AND su.cust_acct_site_id = cas.cust_acct_site_id ;
398:
399: IF G_debug_flag = 'Y'
400: THEN
401: OE_DEBUG_PUB.ADD(' Customer ID : ' || l_customer_id ,1);
402: END IF;
403: EXCEPTION
404: WHEN NO_DATA_FOUND
405: THEN

Line 408: OE_DEBUG_PUB.ADD(' No Data found for Customer ID using Site Use ID',1);

404: WHEN NO_DATA_FOUND
405: THEN
406: IF G_debug_flag = 'Y'
407: THEN
408: OE_DEBUG_PUB.ADD(' No Data found for Customer ID using Site Use ID',1);
409: END IF;
410: END;
411: END IF;
412:

Line 418: OE_DEBUG_PUB.Add('Begin AR Exposure calculation ');

414: THEN
415: -- Select total amount exposure using CUSTOMER/SITE CURSORs
416: IF G_debug_flag = 'Y'
417: THEN
418: OE_DEBUG_PUB.Add('Begin AR Exposure calculation ');
419: END IF;
420:
421: -- The exposure calculation must be done for all the usage currencies
422: -- as part of the multi currency set up.

Line 434: OE_DEBUG_PUB.ADD(' ');

430: l_current_usage_cur := NULL ;
431:
432: IF G_debug_flag = 'Y'
433: THEN
434: OE_DEBUG_PUB.ADD(' ');
435: OE_DEBUG_PUB.ADD('############################### ');
436: OE_DEBUG_PUB.ADD('USAGE CURR = '|| p_usage_curr(i).usage_curr_code );
437: OE_DEBUG_PUB.ADD('############################### ');
438: OE_DEBUG_PUB.ADD(' ');

Line 435: OE_DEBUG_PUB.ADD('############################### ');

431:
432: IF G_debug_flag = 'Y'
433: THEN
434: OE_DEBUG_PUB.ADD(' ');
435: OE_DEBUG_PUB.ADD('############################### ');
436: OE_DEBUG_PUB.ADD('USAGE CURR = '|| p_usage_curr(i).usage_curr_code );
437: OE_DEBUG_PUB.ADD('############################### ');
438: OE_DEBUG_PUB.ADD(' ');
439: END IF;

Line 436: OE_DEBUG_PUB.ADD('USAGE CURR = '|| p_usage_curr(i).usage_curr_code );

432: IF G_debug_flag = 'Y'
433: THEN
434: OE_DEBUG_PUB.ADD(' ');
435: OE_DEBUG_PUB.ADD('############################### ');
436: OE_DEBUG_PUB.ADD('USAGE CURR = '|| p_usage_curr(i).usage_curr_code );
437: OE_DEBUG_PUB.ADD('############################### ');
438: OE_DEBUG_PUB.ADD(' ');
439: END IF;
440:

Line 437: OE_DEBUG_PUB.ADD('############################### ');

433: THEN
434: OE_DEBUG_PUB.ADD(' ');
435: OE_DEBUG_PUB.ADD('############################### ');
436: OE_DEBUG_PUB.ADD('USAGE CURR = '|| p_usage_curr(i).usage_curr_code );
437: OE_DEBUG_PUB.ADD('############################### ');
438: OE_DEBUG_PUB.ADD(' ');
439: END IF;
440:
441: l_current_usage_cur := p_usage_curr(i).usage_curr_code ;

Line 438: OE_DEBUG_PUB.ADD(' ');

434: OE_DEBUG_PUB.ADD(' ');
435: OE_DEBUG_PUB.ADD('############################### ');
436: OE_DEBUG_PUB.ADD('USAGE CURR = '|| p_usage_curr(i).usage_curr_code );
437: OE_DEBUG_PUB.ADD('############################### ');
438: OE_DEBUG_PUB.ADD(' ');
439: END IF;
440:
441: l_current_usage_cur := p_usage_curr(i).usage_curr_code ;
442:

Line 450: OE_DEBUG_PUB.Add('Select cust_glb_orders ');

446: IF l_include_uninvoiced_flag = 'Y'
447: THEN
448: IF G_debug_flag = 'Y'
449: THEN
450: OE_DEBUG_PUB.Add('Select cust_glb_orders ');
451: END IF;
452:
453: OPEN cust_glb_orders(p_usage_curr(i).usage_curr_code);
454: FETCH cust_glb_orders INTO l_total_on_order;

Line 458: OE_DEBUG_PUB.ADD(' l_total_on_order = ' || nvl(l_total_on_order,0));

454: FETCH cust_glb_orders INTO l_total_on_order;
455:
456: IF G_debug_flag = 'Y'
457: THEN
458: OE_DEBUG_PUB.ADD(' l_total_on_order = ' || nvl(l_total_on_order,0));
459: END IF;
460:
461: IF cust_glb_orders%NOTFOUND
462: THEN

Line 464: OE_DEBUG_PUB.Add('No Uninvoiced order amount found ');

460:
461: IF cust_glb_orders%NOTFOUND
462: THEN
463: l_total_on_order := 0 ;
464: OE_DEBUG_PUB.Add('No Uninvoiced order amount found ');
465: END IF;
466: CLOSE cust_glb_orders;
467: END IF;
468:

Line 473: OE_DEBUG_PUB.Add('Select cust_glb_orders_return ');

469: IF l_include_returns_flag = 'Y'
470: THEN
471: IF G_debug_flag = 'Y'
472: THEN
473: OE_DEBUG_PUB.Add('Select cust_glb_orders_return ');
474: END IF;
475:
476: OPEN cust_glb_orders_return(p_usage_curr(i).usage_curr_code);
477: FETCH cust_glb_orders_return INTO l_total_on_return;

Line 481: OE_DEBUG_PUB.ADD(' l_total_on_return = ' || nvl(l_total_on_return,0));

477: FETCH cust_glb_orders_return INTO l_total_on_return;
478:
479: IF G_debug_flag = 'Y'
480: THEN
481: OE_DEBUG_PUB.ADD(' l_total_on_return = ' || nvl(l_total_on_return,0));
482: END IF;
483:
484: IF cust_glb_orders_return%NOTFOUND
485: THEN

Line 487: OE_DEBUG_PUB.Add('No Return order amount found ');

483:
484: IF cust_glb_orders_return%NOTFOUND
485: THEN
486: l_total_on_return := 0 ;
487: OE_DEBUG_PUB.Add('No Return order amount found ');
488: END IF;
489:
490: CLOSE cust_glb_orders_return;
491: END IF;

Line 497: OE_DEBUG_PUB.Add('Select cust_glb_orders_freight1 ');

493: IF l_freight_charges_flag ='Y'
494: THEN
495: IF G_debug_flag = 'Y'
496: THEN
497: OE_DEBUG_PUB.Add('Select cust_glb_orders_freight1 ');
498: END IF;
499:
500: OPEN cust_glb_orders_freight1 (p_usage_curr(i).usage_curr_code);
501: FETCH cust_glb_orders_freight1 INTO l_total_on_freight1;

Line 505: OE_DEBUG_PUB.ADD(' l_total_on_freight1 = ' || nvl(l_total_on_freight1,0));

501: FETCH cust_glb_orders_freight1 INTO l_total_on_freight1;
502:
503: IF G_debug_flag = 'Y'
504: THEN
505: OE_DEBUG_PUB.ADD(' l_total_on_freight1 = ' || nvl(l_total_on_freight1,0));
506: END IF;
507:
508: IF cust_glb_orders_freight1%NOTFOUND
509: THEN

Line 511: OE_DEBUG_PUB.Add('No Freight order amount found ');

507:
508: IF cust_glb_orders_freight1%NOTFOUND
509: THEN
510: l_total_on_freight1 := 0 ;
511: OE_DEBUG_PUB.Add('No Freight order amount found ');
512: END IF;
513:
514: CLOSE cust_glb_orders_freight1;
515:

Line 518: OE_DEBUG_PUB.Add('Select cust_glb_orders_freight2 ');

514: CLOSE cust_glb_orders_freight1;
515:
516: IF G_debug_flag = 'Y'
517: THEN
518: OE_DEBUG_PUB.Add('Select cust_glb_orders_freight2 ');
519: END IF;
520:
521: OPEN cust_glb_orders_freight2 (p_usage_curr(i).usage_curr_code);
522: FETCH cust_glb_orders_freight2 INTO l_total_on_freight2;

Line 526: OE_DEBUG_PUB.ADD(' l_total_on_freight2 = ' || nvl(l_total_on_freight2,0));

522: FETCH cust_glb_orders_freight2 INTO l_total_on_freight2;
523:
524: IF G_debug_flag = 'Y'
525: THEN
526: OE_DEBUG_PUB.ADD(' l_total_on_freight2 = ' || nvl(l_total_on_freight2,0));
527: END IF;
528:
529: IF cust_glb_orders_freight2%NOTFOUND
530: THEN

Line 532: OE_DEBUG_PUB.Add('No Freight order amount found ');

528:
529: IF cust_glb_orders_freight2%NOTFOUND
530: THEN
531: l_total_on_freight2 := 0 ;
532: OE_DEBUG_PUB.Add('No Freight order amount found ');
533: END IF;
534:
535: CLOSE cust_glb_orders_freight2;
536: END IF;

Line 542: OE_DEBUG_PUB.Add('Select cust_reg_orders ');

538: IF l_include_uninvoiced_flag = 'Y'
539: THEN
540: IF G_debug_flag = 'Y'
541: THEN
542: OE_DEBUG_PUB.Add('Select cust_reg_orders ');
543: END IF;
544:
545: OPEN cust_reg_orders(p_usage_curr(i).usage_curr_code);
546: FETCH cust_reg_orders INTO l_total_on_order;

Line 550: OE_DEBUG_PUB.ADD(' l_total_on_order = ' || nvl(l_total_on_order,0));

546: FETCH cust_reg_orders INTO l_total_on_order;
547:
548: IF G_debug_flag = 'Y'
549: THEN
550: OE_DEBUG_PUB.ADD(' l_total_on_order = ' || nvl(l_total_on_order,0));
551: END IF;
552:
553: IF cust_reg_orders%NOTFOUND
554: THEN

Line 556: OE_DEBUG_PUB.Add('No Uninvoiced order amount found ');

552:
553: IF cust_reg_orders%NOTFOUND
554: THEN
555: l_total_on_order := 0 ;
556: OE_DEBUG_PUB.Add('No Uninvoiced order amount found ');
557: END IF;
558:
559: CLOSE cust_reg_orders;
560: END IF;

Line 566: OE_DEBUG_PUB.Add('Select cust_reg_orders_return ');

562: IF l_include_returns_flag = 'Y'
563: THEN
564: IF G_debug_flag = 'Y'
565: THEN
566: OE_DEBUG_PUB.Add('Select cust_reg_orders_return ');
567: END IF;
568:
569: OPEN cust_reg_orders_return(p_usage_curr(i).usage_curr_code);
570: FETCH cust_reg_orders_return INTO l_total_on_return;

Line 574: OE_DEBUG_PUB.ADD(' l_total_on_return = ' || nvl(l_total_on_return,0));

570: FETCH cust_reg_orders_return INTO l_total_on_return;
571:
572: IF G_debug_flag = 'Y'
573: THEN
574: OE_DEBUG_PUB.ADD(' l_total_on_return = ' || nvl(l_total_on_return,0));
575: END IF;
576:
577: IF cust_reg_orders_return%NOTFOUND
578: THEN

Line 580: OE_DEBUG_PUB.Add('No Return order amount found ');

576:
577: IF cust_reg_orders_return%NOTFOUND
578: THEN
579: l_total_on_return := 0 ;
580: OE_DEBUG_PUB.Add('No Return order amount found ');
581: END IF;
582:
583: CLOSE cust_reg_orders_return;
584: END IF;

Line 590: OE_DEBUG_PUB.Add('Select open cust_reg_orders_freight1 ');

586: IF l_freight_charges_flag ='Y'
587: THEN
588: IF G_debug_flag = 'Y'
589: THEN
590: OE_DEBUG_PUB.Add('Select open cust_reg_orders_freight1 ');
591: END IF;
592:
593: OPEN cust_reg_orders_freight1 (p_usage_curr(i).usage_curr_code);
594: FETCH cust_reg_orders_freight1 INTO l_total_on_freight1;

Line 598: OE_DEBUG_PUB.ADD(' l_total_on_freight1 = ' || nvl(l_total_on_freight1,0));

594: FETCH cust_reg_orders_freight1 INTO l_total_on_freight1;
595:
596: IF G_debug_flag = 'Y'
597: THEN
598: OE_DEBUG_PUB.ADD(' l_total_on_freight1 = ' || nvl(l_total_on_freight1,0));
599: END IF;
600:
601: IF cust_reg_orders_freight1%NOTFOUND
602: THEN

Line 604: OE_DEBUG_PUB.Add('No Freight order amount found ');

600:
601: IF cust_reg_orders_freight1%NOTFOUND
602: THEN
603: l_total_on_freight1 := 0 ;
604: OE_DEBUG_PUB.Add('No Freight order amount found ');
605: END IF;
606:
607: CLOSE cust_reg_orders_freight1;
608:

Line 611: OE_DEBUG_PUB.Add('Select open cust_reg_orders_freight2 ');

607: CLOSE cust_reg_orders_freight1;
608:
609: IF G_debug_flag = 'Y'
610: THEN
611: OE_DEBUG_PUB.Add('Select open cust_reg_orders_freight2 ');
612: END IF;
613:
614: OPEN cust_reg_orders_freight2 (p_usage_curr(i).usage_curr_code);
615: FETCH cust_reg_orders_freight2 INTO l_total_on_freight2;

Line 619: OE_DEBUG_PUB.ADD(' l_total_on_freight2 = ' || nvl(l_total_on_freight2,0));

615: FETCH cust_reg_orders_freight2 INTO l_total_on_freight2;
616:
617: IF G_debug_flag = 'Y'
618: THEN
619: OE_DEBUG_PUB.ADD(' l_total_on_freight2 = ' || nvl(l_total_on_freight2,0));
620: END IF;
621:
622: IF cust_reg_orders_freight2%NOTFOUND
623: THEN

Line 625: OE_DEBUG_PUB.Add('No Freight order amount found ');

621:
622: IF cust_reg_orders_freight2%NOTFOUND
623: THEN
624: l_total_on_freight2 := 0 ;
625: OE_DEBUG_PUB.Add('No Freight order amount found ');
626: END IF;
627:
628: CLOSE cust_reg_orders_freight2;
629: END IF;

Line 644: OE_DEBUG_PUB.ADD(' ');

640: + NVL(l_cum_total_on_freight1,0) + NVL(l_cum_total_on_freight2,0);
641:
642: IF G_debug_flag = 'Y'
643: THEN
644: OE_DEBUG_PUB.ADD(' ');
645: OE_DEBUG_PUB.ADD(' l_cum_total_on_order = ' || nvl(l_cum_total_on_order,0));
646: OE_DEBUG_PUB.ADD(' l_cum_total_on_return = ' || nvl(l_cum_total_on_return,0));
647: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight1 = ' || nvl(l_total_on_freight1,0));
648: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight2 = ' || nvl(l_total_on_freight2,0));

Line 645: OE_DEBUG_PUB.ADD(' l_cum_total_on_order = ' || nvl(l_cum_total_on_order,0));

641:
642: IF G_debug_flag = 'Y'
643: THEN
644: OE_DEBUG_PUB.ADD(' ');
645: OE_DEBUG_PUB.ADD(' l_cum_total_on_order = ' || nvl(l_cum_total_on_order,0));
646: OE_DEBUG_PUB.ADD(' l_cum_total_on_return = ' || nvl(l_cum_total_on_return,0));
647: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight1 = ' || nvl(l_total_on_freight1,0));
648: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight2 = ' || nvl(l_total_on_freight2,0));
649: OE_DEBUG_PUB.ADD(' l_usage_total_exposure = ' || nvl(l_usage_total_exposure,0));

Line 646: OE_DEBUG_PUB.ADD(' l_cum_total_on_return = ' || nvl(l_cum_total_on_return,0));

642: IF G_debug_flag = 'Y'
643: THEN
644: OE_DEBUG_PUB.ADD(' ');
645: OE_DEBUG_PUB.ADD(' l_cum_total_on_order = ' || nvl(l_cum_total_on_order,0));
646: OE_DEBUG_PUB.ADD(' l_cum_total_on_return = ' || nvl(l_cum_total_on_return,0));
647: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight1 = ' || nvl(l_total_on_freight1,0));
648: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight2 = ' || nvl(l_total_on_freight2,0));
649: OE_DEBUG_PUB.ADD(' l_usage_total_exposure = ' || nvl(l_usage_total_exposure,0));
650:

Line 647: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight1 = ' || nvl(l_total_on_freight1,0));

643: THEN
644: OE_DEBUG_PUB.ADD(' ');
645: OE_DEBUG_PUB.ADD(' l_cum_total_on_order = ' || nvl(l_cum_total_on_order,0));
646: OE_DEBUG_PUB.ADD(' l_cum_total_on_return = ' || nvl(l_cum_total_on_return,0));
647: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight1 = ' || nvl(l_total_on_freight1,0));
648: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight2 = ' || nvl(l_total_on_freight2,0));
649: OE_DEBUG_PUB.ADD(' l_usage_total_exposure = ' || nvl(l_usage_total_exposure,0));
650:
651: OE_DEBUG_PUB.ADD(' Call currency conversion for exposure ' );

Line 648: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight2 = ' || nvl(l_total_on_freight2,0));

644: OE_DEBUG_PUB.ADD(' ');
645: OE_DEBUG_PUB.ADD(' l_cum_total_on_order = ' || nvl(l_cum_total_on_order,0));
646: OE_DEBUG_PUB.ADD(' l_cum_total_on_return = ' || nvl(l_cum_total_on_return,0));
647: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight1 = ' || nvl(l_total_on_freight1,0));
648: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight2 = ' || nvl(l_total_on_freight2,0));
649: OE_DEBUG_PUB.ADD(' l_usage_total_exposure = ' || nvl(l_usage_total_exposure,0));
650:
651: OE_DEBUG_PUB.ADD(' Call currency conversion for exposure ' );
652: OE_DEBUG_PUB.Add(' GL_CURRENCY = '|| OE_Credit_Engine_GRP.GL_currency );

Line 649: OE_DEBUG_PUB.ADD(' l_usage_total_exposure = ' || nvl(l_usage_total_exposure,0));

645: OE_DEBUG_PUB.ADD(' l_cum_total_on_order = ' || nvl(l_cum_total_on_order,0));
646: OE_DEBUG_PUB.ADD(' l_cum_total_on_return = ' || nvl(l_cum_total_on_return,0));
647: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight1 = ' || nvl(l_total_on_freight1,0));
648: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight2 = ' || nvl(l_total_on_freight2,0));
649: OE_DEBUG_PUB.ADD(' l_usage_total_exposure = ' || nvl(l_usage_total_exposure,0));
650:
651: OE_DEBUG_PUB.ADD(' Call currency conversion for exposure ' );
652: OE_DEBUG_PUB.Add(' GL_CURRENCY = '|| OE_Credit_Engine_GRP.GL_currency );
653: END IF;

Line 651: OE_DEBUG_PUB.ADD(' Call currency conversion for exposure ' );

647: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight1 = ' || nvl(l_total_on_freight1,0));
648: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight2 = ' || nvl(l_total_on_freight2,0));
649: OE_DEBUG_PUB.ADD(' l_usage_total_exposure = ' || nvl(l_usage_total_exposure,0));
650:
651: OE_DEBUG_PUB.ADD(' Call currency conversion for exposure ' );
652: OE_DEBUG_PUB.Add(' GL_CURRENCY = '|| OE_Credit_Engine_GRP.GL_currency );
653: END IF;
654:
655: IF OE_Credit_Engine_GRP.GL_currency IS NULL

Line 652: OE_DEBUG_PUB.Add(' GL_CURRENCY = '|| OE_Credit_Engine_GRP.GL_currency );

648: OE_DEBUG_PUB.ADD(' l_cum_total_on_freight2 = ' || nvl(l_total_on_freight2,0));
649: OE_DEBUG_PUB.ADD(' l_usage_total_exposure = ' || nvl(l_usage_total_exposure,0));
650:
651: OE_DEBUG_PUB.ADD(' Call currency conversion for exposure ' );
652: OE_DEBUG_PUB.Add(' GL_CURRENCY = '|| OE_Credit_Engine_GRP.GL_currency );
653: END IF;
654:
655: IF OE_Credit_Engine_GRP.GL_currency IS NULL
656: THEN

Line 657: OE_DEBUG_PUB.ADD(' Call GET_GL_currency ');

653: END IF;
654:
655: IF OE_Credit_Engine_GRP.GL_currency IS NULL
656: THEN
657: OE_DEBUG_PUB.ADD(' Call GET_GL_currency ');
658:
659: OE_Credit_Engine_GRP.GL_currency := OE_CREDIT_CHECK_UTIL.GET_GL_currency ;
660:
661: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = ' || OE_Credit_Engine_GRP.GL_currency );

Line 661: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = ' || OE_Credit_Engine_GRP.GL_currency );

657: OE_DEBUG_PUB.ADD(' Call GET_GL_currency ');
658:
659: OE_Credit_Engine_GRP.GL_currency := OE_CREDIT_CHECK_UTIL.GET_GL_currency ;
660:
661: OE_DEBUG_PUB.ADD(' GL_CURRENCY after = ' || OE_Credit_Engine_GRP.GL_currency );
662: END IF;
663:
664: l_limit_total_exposure :=
665: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

Line 678: OE_DEBUG_PUB.ADD('l_total_exposure = ' || nvl(l_total_exposure,0));

674: l_total_exposure := NVL(l_total_exposure,0) + NVL(l_limit_total_exposure,0) ;
675:
676: IF G_debug_flag = 'Y'
677: THEN
678: OE_DEBUG_PUB.ADD('l_total_exposure = ' || nvl(l_total_exposure,0));
679: END IF;
680:
681: l_cum_total_on_order := 0;
682: l_cum_total_on_return := 0;

Line 701: OE_DEBUG_PUB.Add(' ');

697: x_exposure_amount := NVL(l_total_exposure,0) ;
698:
699: IF G_debug_flag = 'Y'
700: THEN
701: OE_DEBUG_PUB.Add(' ');
702: OE_DEBUG_PUB.Add('---------------##########----------------' );
703: OE_DEBUG_PUB.Add(' ');
704: OE_DEBUG_PUB.Add('Total exposure amount in Interface table = '|| x_exposure_amount,1);
705: OE_DEBUG_PUB.Add(' ');

Line 702: OE_DEBUG_PUB.Add('---------------##########----------------' );

698:
699: IF G_debug_flag = 'Y'
700: THEN
701: OE_DEBUG_PUB.Add(' ');
702: OE_DEBUG_PUB.Add('---------------##########----------------' );
703: OE_DEBUG_PUB.Add(' ');
704: OE_DEBUG_PUB.Add('Total exposure amount in Interface table = '|| x_exposure_amount,1);
705: OE_DEBUG_PUB.Add(' ');
706: OE_DEBUG_PUB.Add('-------------- ##########----------------' );

Line 703: OE_DEBUG_PUB.Add(' ');

699: IF G_debug_flag = 'Y'
700: THEN
701: OE_DEBUG_PUB.Add(' ');
702: OE_DEBUG_PUB.Add('---------------##########----------------' );
703: OE_DEBUG_PUB.Add(' ');
704: OE_DEBUG_PUB.Add('Total exposure amount in Interface table = '|| x_exposure_amount,1);
705: OE_DEBUG_PUB.Add(' ');
706: OE_DEBUG_PUB.Add('-------------- ##########----------------' );
707: OE_DEBUG_PUB.Add(' ');

Line 704: OE_DEBUG_PUB.Add('Total exposure amount in Interface table = '|| x_exposure_amount,1);

700: THEN
701: OE_DEBUG_PUB.Add(' ');
702: OE_DEBUG_PUB.Add('---------------##########----------------' );
703: OE_DEBUG_PUB.Add(' ');
704: OE_DEBUG_PUB.Add('Total exposure amount in Interface table = '|| x_exposure_amount,1);
705: OE_DEBUG_PUB.Add(' ');
706: OE_DEBUG_PUB.Add('-------------- ##########----------------' );
707: OE_DEBUG_PUB.Add(' ');
708: OE_DEBUG_PUB.ADD('OEXUCERB: OUT NOCOPY Get_exposure_amount ',1);

Line 705: OE_DEBUG_PUB.Add(' ');

701: OE_DEBUG_PUB.Add(' ');
702: OE_DEBUG_PUB.Add('---------------##########----------------' );
703: OE_DEBUG_PUB.Add(' ');
704: OE_DEBUG_PUB.Add('Total exposure amount in Interface table = '|| x_exposure_amount,1);
705: OE_DEBUG_PUB.Add(' ');
706: OE_DEBUG_PUB.Add('-------------- ##########----------------' );
707: OE_DEBUG_PUB.Add(' ');
708: OE_DEBUG_PUB.ADD('OEXUCERB: OUT NOCOPY Get_exposure_amount ',1);
709: END IF;

Line 706: OE_DEBUG_PUB.Add('-------------- ##########----------------' );

702: OE_DEBUG_PUB.Add('---------------##########----------------' );
703: OE_DEBUG_PUB.Add(' ');
704: OE_DEBUG_PUB.Add('Total exposure amount in Interface table = '|| x_exposure_amount,1);
705: OE_DEBUG_PUB.Add(' ');
706: OE_DEBUG_PUB.Add('-------------- ##########----------------' );
707: OE_DEBUG_PUB.Add(' ');
708: OE_DEBUG_PUB.ADD('OEXUCERB: OUT NOCOPY Get_exposure_amount ',1);
709: END IF;
710:

Line 707: OE_DEBUG_PUB.Add(' ');

703: OE_DEBUG_PUB.Add(' ');
704: OE_DEBUG_PUB.Add('Total exposure amount in Interface table = '|| x_exposure_amount,1);
705: OE_DEBUG_PUB.Add(' ');
706: OE_DEBUG_PUB.Add('-------------- ##########----------------' );
707: OE_DEBUG_PUB.Add(' ');
708: OE_DEBUG_PUB.ADD('OEXUCERB: OUT NOCOPY Get_exposure_amount ',1);
709: END IF;
710:
711: EXCEPTION

Line 708: OE_DEBUG_PUB.ADD('OEXUCERB: OUT NOCOPY Get_exposure_amount ',1);

704: OE_DEBUG_PUB.Add('Total exposure amount in Interface table = '|| x_exposure_amount,1);
705: OE_DEBUG_PUB.Add(' ');
706: OE_DEBUG_PUB.Add('-------------- ##########----------------' );
707: OE_DEBUG_PUB.Add(' ');
708: OE_DEBUG_PUB.ADD('OEXUCERB: OUT NOCOPY Get_exposure_amount ',1);
709: END IF;
710:
711: EXCEPTION
712: WHEN GL_CURRENCY_API.NO_RATE THEN

Line 713: OE_DEBUG_PUB.ADD('EXCEPTION: GL_CURRENCY_API.NO_RATE in get_exposure_amount',1);

709: END IF;
710:
711: EXCEPTION
712: WHEN GL_CURRENCY_API.NO_RATE THEN
713: OE_DEBUG_PUB.ADD('EXCEPTION: GL_CURRENCY_API.NO_RATE in get_exposure_amount',1);
714: OE_DEBUG_PUB.ADD('l_current_usage_cur = '|| l_current_usage_cur );
715: x_conversion_status(1).usage_curr_code := l_current_usage_cur ;
716:
717: fnd_message.set_name('ONT', 'OE_CONVERSION_ERROR');

Line 714: OE_DEBUG_PUB.ADD('l_current_usage_cur = '|| l_current_usage_cur );

710:
711: EXCEPTION
712: WHEN GL_CURRENCY_API.NO_RATE THEN
713: OE_DEBUG_PUB.ADD('EXCEPTION: GL_CURRENCY_API.NO_RATE in get_exposure_amount',1);
714: OE_DEBUG_PUB.ADD('l_current_usage_cur = '|| l_current_usage_cur );
715: x_conversion_status(1).usage_curr_code := l_current_usage_cur ;
716:
717: fnd_message.set_name('ONT', 'OE_CONVERSION_ERROR');
718: OE_DEBUG_PUB.ADD('Exception table added ');

Line 718: OE_DEBUG_PUB.ADD('Exception table added ');

714: OE_DEBUG_PUB.ADD('l_current_usage_cur = '|| l_current_usage_cur );
715: x_conversion_status(1).usage_curr_code := l_current_usage_cur ;
716:
717: fnd_message.set_name('ONT', 'OE_CONVERSION_ERROR');
718: OE_DEBUG_PUB.ADD('Exception table added ');
719: WHEN OTHERS THEN
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
722: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, '