[Home] [Help]
271: x_exist_flag := 'N' ;
272:
273: IF G_debug_flag = 'Y'
274: THEN
275: oe_debug_pub.add(' l_jdate => '|| l_jdate );
276: oe_debug_pub.add(' p_credit_level => '|| p_credit_level );
277: oe_debug_pub.add(' p_site_use_id => '|| p_site_use_id );
278: oe_debug_pub.add(' p_customer_id => '|| p_customer_id );
279: oe_debug_pub.add(' p_party_id => '|| p_party_id );
272:
273: IF G_debug_flag = 'Y'
274: THEN
275: oe_debug_pub.add(' l_jdate => '|| l_jdate );
276: oe_debug_pub.add(' p_credit_level => '|| p_credit_level );
277: oe_debug_pub.add(' p_site_use_id => '|| p_site_use_id );
278: oe_debug_pub.add(' p_customer_id => '|| p_customer_id );
279: oe_debug_pub.add(' p_party_id => '|| p_party_id );
280: END IF;
273: IF G_debug_flag = 'Y'
274: THEN
275: oe_debug_pub.add(' l_jdate => '|| l_jdate );
276: oe_debug_pub.add(' p_credit_level => '|| p_credit_level );
277: oe_debug_pub.add(' p_site_use_id => '|| p_site_use_id );
278: oe_debug_pub.add(' p_customer_id => '|| p_customer_id );
279: oe_debug_pub.add(' p_party_id => '|| p_party_id );
280: END IF;
281:
274: THEN
275: oe_debug_pub.add(' l_jdate => '|| l_jdate );
276: oe_debug_pub.add(' p_credit_level => '|| p_credit_level );
277: oe_debug_pub.add(' p_site_use_id => '|| p_site_use_id );
278: oe_debug_pub.add(' p_customer_id => '|| p_customer_id );
279: oe_debug_pub.add(' p_party_id => '|| p_party_id );
280: END IF;
281:
282: BEGIN
275: oe_debug_pub.add(' l_jdate => '|| l_jdate );
276: oe_debug_pub.add(' p_credit_level => '|| p_credit_level );
277: oe_debug_pub.add(' p_site_use_id => '|| p_site_use_id );
278: oe_debug_pub.add(' p_customer_id => '|| p_customer_id );
279: oe_debug_pub.add(' p_party_id => '|| p_party_id );
280: END IF;
281:
282: BEGIN
283:
483: END IF;
484:
485: IF G_debug_flag = 'Y'
486: THEN
487: oe_debug_pub.add( 'Shipping Horizon Julian Date is:' || l_date, 2 );
488: END IF;
489:
490: RETURN l_date;
491:
510: END IF;
511:
512: IF G_debug_flag = 'Y'
513: THEN
514: oe_debug_pub.add( 'Open Receivables Horizon Julian is:' || l_date, 2 );
515: END IF;
516:
517: RETURN l_date;
518:
836:
837:
838: IF G_debug_flag = 'Y'
839: THEN
840: oe_debug_pub.add
841: (b1 || ' ' || b2 || ' ' || b3 || ' ' || b4 || ' ' || b5 || ' ' || b6 || ' '
842: || b7 || ' ' || b8 || ' ' || b9 || ' ' || b10 || ' ' || b11 || ' ' || b12 ||
843: ' '
844: || b13 || ' ' || b14 || ' ' || b15 || ' ' || b16 || ' ' || b17 || ' ' || b18||
846: ' '|| b29 || ' ' || b30 || ' ' || b31 || ' ' || b32 || ' ' || b33 || ' ' || b34||
847: ' '|| b35 || ' ' || b36 || ' ' || b37 ||' ' || b38 ||' ' || b39 ||' ' || b40 ||' ' || b41 ||' ' || b42 ||' ' || b43 ||
848: ' ' || b44 ||' ' || b45 ||' ' || b46 ||' ' || b47 ||' ' || b48, 2 );
849:
850: oe_debug_pub.add( ' Out from balance_types_om_and_ar ');
851: END IF;
852:
853: END balance_types_om_and_ar ;
854:
1032: END IF;
1033:
1034: IF G_debug_flag = 'Y'
1035: THEN
1036: oe_debug_pub.add
1037: (b1 || ' ' || b2 || ' ' || b3 || ' ' || b4 || ' ' || b5 || ' ' || b6 || ' '
1038: || b7 || ' ' || b8 || ' ' || b9 || ' ' || b10 || ' ' || b11 || ' ' || b12 || ' '
1039: || b13 || ' ' || b14 || ' ' || b15 || ' ' || b16 || ' ' || b17 || ' ' || b18||' '
1040: || b23 || ' ' || b24 || ' ' || b25 || ' ' || b26 || ' ' || b27 || ' ' || b28||' '||b29
1039: || b13 || ' ' || b14 || ' ' || b15 || ' ' || b16 || ' ' || b17 || ' ' || b18||' '
1040: || b23 || ' ' || b24 || ' ' || b25 || ' ' || b26 || ' ' || b27 || ' ' || b28||' '||b29
1041: || ' ' || b37 ||' ' || b38 ||' ' || b39 ||' ' || b44, 2 );
1042:
1043: oe_debug_pub.add( ' Out from balance_types_om_nohold ' );
1044: END IF;
1045: END balance_types_om_nohold;
1046: ---------------------------------------------------------------
1047:
1242: END IF;
1243:
1244: IF G_debug_flag = 'Y'
1245: THEN
1246: oe_debug_pub.add
1247: (b1 || ' ' || b2 || ' ' || b3 || ' ' || b4 || ' ' || b5 || ' ' || b6 || ' '
1248: || b7 || ' ' || b8 || ' ' || b9 || ' ' || b10 || ' ' || b11 || ' ' || b12 || ' '
1249: || b13 || ' ' || b14 || ' ' || b15 || ' ' || b16 || ' ' || b17 || ' ' || b18|| ' '
1250: || b30 || ' ' || b31 || ' ' || b32 || ' ' || b33 || ' ' || b34 || ' ' || b35|| ' '
1249: || b13 || ' ' || b14 || ' ' || b15 || ' ' || b16 || ' ' || b17 || ' ' || b18|| ' '
1250: || b30 || ' ' || b31 || ' ' || b32 || ' ' || b33 || ' ' || b34 || ' ' || b35|| ' '
1251: || b36|| ' ' || b40 ||' ' || b41 ||' ' || b42 || b46 ||' ' || b47 ||' ' || b48, 2 );
1252:
1253: oe_debug_pub.add( ' Out from balance_types_om_hold ' );
1254: END IF;
1255: END balance_types_om_hold;
1256:
1257: PROCEDURE balance_types_om
1544: END IF;
1545:
1546: IF G_debug_flag = 'Y'
1547: THEN
1548: oe_debug_pub.add
1549: (b1 || ' ' || b2 || ' ' || b3 || ' ' || b4 || ' ' || b5 || ' ' || b6 || ' '
1550: || b7 || ' ' || b8 || ' ' || b9 || ' ' || b10 || ' ' || b11 || ' ' || b12 || ' '
1551: || b13 || ' ' || b14 || ' ' || b15 || ' ' || b16 || ' ' || b17 || ' ' || b18 || ' '
1552: || b23 || ' ' || b24 || ' ' || b25 || ' ' || b26 || ' ' || b27 || ' ' || b28|| ' '
1553: || b29 || ' ' || b30 || ' ' || b31 || ' ' || b32 || ' ' || b33 || ' ' || b34|| ' '
1554: || b35 || ' ' || b36 || ' ' || b37 ||' ' || b38 ||' ' || b39 ||' ' || b40 ||' ' || b41 ||' ' || b42 ||' ' || b43 ||
1555: ' ' || b44 ||' ' || b45 ||' ' || b46 ||' ' || b47 ||' ' || b48, 2 );
1556:
1557: oe_debug_pub.add( ' Out from balance_types_om ' );
1558: END IF;
1559: END balance_types_om;
1560:
1561: -----------------------------------------------------------
1624:
1625:
1626: IF G_debug_flag = 'Y'
1627: THEN
1628: oe_debug_pub.add
1629: (b1 || ' ' || b2 || ' ' || b3 || ' ' || b4 || ' ' || b5 || ' ' || b6 || ' '
1630: || b7 || ' ' || b8 || ' ' || b9 || ' ' || b10 || ' ' || b11 || ' ' || b12 || ' '
1631: || b13 || ' ' || b14 || ' ' || b15 || ' ' || b16 || ' ' || b17 || ' ' || b18 || ' ' || b21 || ' ' ||b22,2 );
1632:
1629: (b1 || ' ' || b2 || ' ' || b3 || ' ' || b4 || ' ' || b5 || ' ' || b6 || ' '
1630: || b7 || ' ' || b8 || ' ' || b9 || ' ' || b10 || ' ' || b11 || ' ' || b12 || ' '
1631: || b13 || ' ' || b14 || ' ' || b15 || ' ' || b16 || ' ' || b17 || ' ' || b18 || ' ' || b21 || ' ' ||b22,2 );
1632:
1633: oe_debug_pub.add( ' Out from balance_types_ar ');
1634: END IF;
1635:
1636: END balance_types_ar;
1637:
1675: l_date := p_date;
1676:
1677: IF G_debug_flag = 'Y'
1678: THEN
1679: oe_debug_pub.add( 'Into calculate_buckets ');
1680: oe_debug_pub.add( 'p_date =>'|| p_date );
1681: oe_debug_pub.add( 'p_interval =>' || p_interval );
1682: END IF;
1683:
1676:
1677: IF G_debug_flag = 'Y'
1678: THEN
1679: oe_debug_pub.add( 'Into calculate_buckets ');
1680: oe_debug_pub.add( 'p_date =>'|| p_date );
1681: oe_debug_pub.add( 'p_interval =>' || p_interval );
1682: END IF;
1683:
1684: -- the Main Bucket
1677: IF G_debug_flag = 'Y'
1678: THEN
1679: oe_debug_pub.add( 'Into calculate_buckets ');
1680: oe_debug_pub.add( 'p_date =>'|| p_date );
1681: oe_debug_pub.add( 'p_interval =>' || p_interval );
1682: END IF;
1683:
1684: -- the Main Bucket
1685: l_level := G_MAX_BUCKET_LEVEL;
1690: x_main_bucket := l_bucket;
1691:
1692: IF G_debug_flag = 'Y'
1693: THEN
1694: oe_debug_pub.add( 'l_date ==> '|| l_date);
1695: oe_debug_pub.add( 'l_bucket_length ==> '|| l_bucket_length );
1696: oe_debug_pub.add( 'Main Bucket ==> '|| x_main_bucket ,1);
1697: END IF;
1698:
1691:
1692: IF G_debug_flag = 'Y'
1693: THEN
1694: oe_debug_pub.add( 'l_date ==> '|| l_date);
1695: oe_debug_pub.add( 'l_bucket_length ==> '|| l_bucket_length );
1696: oe_debug_pub.add( 'Main Bucket ==> '|| x_main_bucket ,1);
1697: END IF;
1698:
1699: IF p_interval is NOT NULL
1692: IF G_debug_flag = 'Y'
1693: THEN
1694: oe_debug_pub.add( 'l_date ==> '|| l_date);
1695: oe_debug_pub.add( 'l_bucket_length ==> '|| l_bucket_length );
1696: oe_debug_pub.add( 'Main Bucket ==> '|| x_main_bucket ,1);
1697: END IF;
1698:
1699: IF p_interval is NOT NULL
1700: THEN
1729: END LOOP;
1730:
1731: IF G_debug_flag = 'Y'
1732: THEN
1733: oe_debug_pub.add( 'Out of the Main LOOP');
1734: oe_debug_pub.add( '-------------------------------------- ');
1735: oe_debug_pub.add( 'selected buckets: ' );
1736: END IF;
1737:
1730:
1731: IF G_debug_flag = 'Y'
1732: THEN
1733: oe_debug_pub.add( 'Out of the Main LOOP');
1734: oe_debug_pub.add( '-------------------------------------- ');
1735: oe_debug_pub.add( 'selected buckets: ' );
1736: END IF;
1737:
1738: i := x_binary_tbl.FIRST;
1731: IF G_debug_flag = 'Y'
1732: THEN
1733: oe_debug_pub.add( 'Out of the Main LOOP');
1734: oe_debug_pub.add( '-------------------------------------- ');
1735: oe_debug_pub.add( 'selected buckets: ' );
1736: END IF;
1737:
1738: i := x_binary_tbl.FIRST;
1739: WHILE i IS NOT NULL LOOP
1739: WHILE i IS NOT NULL LOOP
1740:
1741: IF G_debug_flag = 'Y'
1742: THEN
1743: oe_debug_pub.add
1744: ( 'Bucket Number: ' || x_binary_tbl(i).bucket || ', '
1745: || 'Bucket Length:' || x_binary_tbl(i).bucket_length, 2 );
1746: END IF;
1747:
1747:
1748: i := x_binary_tbl.NEXT(i);
1749: END LOOP;
1750:
1751: oe_debug_pub.add( '-------------------------------------- ');
1752:
1753: END;
1754: ELSE
1755: oe_debug_pub.add( 'No need to calculate Buckets, no Horizon ');
1751: oe_debug_pub.add( '-------------------------------------- ');
1752:
1753: END;
1754: ELSE
1755: oe_debug_pub.add( 'No need to calculate Buckets, no Horizon ');
1756: END IF;
1757:
1758: IF G_debug_flag = 'Y'
1759: THEN
1756: END IF;
1757:
1758: IF G_debug_flag = 'Y'
1759: THEN
1760: oe_debug_pub.add( 'Out calculate_buckets ');
1761: END IF;
1762:
1763:
1764: END calculate_buckets;
1791: EXCEPTION
1792: WHEN GL_CURRENCY_API.NO_RATE OR
1793: GL_CURRENCY_API.INVALID_CURRENCY
1794: THEN
1795: oe_debug_pub.add( 'conversion exception for '
1796: || p_transactional_currency, 1 );
1797: add_error_currency( g_error_curr_tbl, p_transactional_currency );
1798: END;
1799:
2694: -- are the cursor names.
2695:
2696: IF G_debug_flag = 'Y'
2697: THEN
2698: oe_debug_pub.add( 'Into retrieve_exposure ');
2699: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2700: oe_debug_pub.add( 'p_site_use_id ==> '|| p_site_use_id );
2701: oe_debug_pub.add( 'p_customer_id ==> '|| p_customer_id );
2702: oe_debug_pub.add( 'p_party_id ==> ' || p_party_id );
2695:
2696: IF G_debug_flag = 'Y'
2697: THEN
2698: oe_debug_pub.add( 'Into retrieve_exposure ');
2699: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2700: oe_debug_pub.add( 'p_site_use_id ==> '|| p_site_use_id );
2701: oe_debug_pub.add( 'p_customer_id ==> '|| p_customer_id );
2702: oe_debug_pub.add( 'p_party_id ==> ' || p_party_id );
2703: oe_debug_pub.add( 'p_org_id ==> '|| p_org_id);
2696: IF G_debug_flag = 'Y'
2697: THEN
2698: oe_debug_pub.add( 'Into retrieve_exposure ');
2699: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2700: oe_debug_pub.add( 'p_site_use_id ==> '|| p_site_use_id );
2701: oe_debug_pub.add( 'p_customer_id ==> '|| p_customer_id );
2702: oe_debug_pub.add( 'p_party_id ==> ' || p_party_id );
2703: oe_debug_pub.add( 'p_org_id ==> '|| p_org_id);
2704: oe_debug_pub.add( 'p_include_all_flag ==> '|| p_include_all_flag );
2697: THEN
2698: oe_debug_pub.add( 'Into retrieve_exposure ');
2699: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2700: oe_debug_pub.add( 'p_site_use_id ==> '|| p_site_use_id );
2701: oe_debug_pub.add( 'p_customer_id ==> '|| p_customer_id );
2702: oe_debug_pub.add( 'p_party_id ==> ' || p_party_id );
2703: oe_debug_pub.add( 'p_org_id ==> '|| p_org_id);
2704: oe_debug_pub.add( 'p_include_all_flag ==> '|| p_include_all_flag );
2705: oe_debug_pub.add( 'p_main_bucket ==> '|| p_main_bucket );
2698: oe_debug_pub.add( 'Into retrieve_exposure ');
2699: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2700: oe_debug_pub.add( 'p_site_use_id ==> '|| p_site_use_id );
2701: oe_debug_pub.add( 'p_customer_id ==> '|| p_customer_id );
2702: oe_debug_pub.add( 'p_party_id ==> ' || p_party_id );
2703: oe_debug_pub.add( 'p_org_id ==> '|| p_org_id);
2704: oe_debug_pub.add( 'p_include_all_flag ==> '|| p_include_all_flag );
2705: oe_debug_pub.add( 'p_main_bucket ==> '|| p_main_bucket );
2706: oe_debug_pub.add( 'p_global_exposure_flag ==> '|| p_global_exposure_flag );
2699: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2700: oe_debug_pub.add( 'p_site_use_id ==> '|| p_site_use_id );
2701: oe_debug_pub.add( 'p_customer_id ==> '|| p_customer_id );
2702: oe_debug_pub.add( 'p_party_id ==> ' || p_party_id );
2703: oe_debug_pub.add( 'p_org_id ==> '|| p_org_id);
2704: oe_debug_pub.add( 'p_include_all_flag ==> '|| p_include_all_flag );
2705: oe_debug_pub.add( 'p_main_bucket ==> '|| p_main_bucket );
2706: oe_debug_pub.add( 'p_global_exposure_flag ==> '|| p_global_exposure_flag );
2707: oe_debug_pub.add( 'p_limit_curr_code ==> '|| p_limit_curr_code );
2700: oe_debug_pub.add( 'p_site_use_id ==> '|| p_site_use_id );
2701: oe_debug_pub.add( 'p_customer_id ==> '|| p_customer_id );
2702: oe_debug_pub.add( 'p_party_id ==> ' || p_party_id );
2703: oe_debug_pub.add( 'p_org_id ==> '|| p_org_id);
2704: oe_debug_pub.add( 'p_include_all_flag ==> '|| p_include_all_flag );
2705: oe_debug_pub.add( 'p_main_bucket ==> '|| p_main_bucket );
2706: oe_debug_pub.add( 'p_global_exposure_flag ==> '|| p_global_exposure_flag );
2707: oe_debug_pub.add( 'p_limit_curr_code ==> '|| p_limit_curr_code );
2708: oe_debug_pub.add( 'include_returns_flag ==> '|| p_credit_check_rule_rec.include_returns_flag);
2701: oe_debug_pub.add( 'p_customer_id ==> '|| p_customer_id );
2702: oe_debug_pub.add( 'p_party_id ==> ' || p_party_id );
2703: oe_debug_pub.add( 'p_org_id ==> '|| p_org_id);
2704: oe_debug_pub.add( 'p_include_all_flag ==> '|| p_include_all_flag );
2705: oe_debug_pub.add( 'p_main_bucket ==> '|| p_main_bucket );
2706: oe_debug_pub.add( 'p_global_exposure_flag ==> '|| p_global_exposure_flag );
2707: oe_debug_pub.add( 'p_limit_curr_code ==> '|| p_limit_curr_code );
2708: oe_debug_pub.add( 'include_returns_flag ==> '|| p_credit_check_rule_rec.include_returns_flag);
2709: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2702: oe_debug_pub.add( 'p_party_id ==> ' || p_party_id );
2703: oe_debug_pub.add( 'p_org_id ==> '|| p_org_id);
2704: oe_debug_pub.add( 'p_include_all_flag ==> '|| p_include_all_flag );
2705: oe_debug_pub.add( 'p_main_bucket ==> '|| p_main_bucket );
2706: oe_debug_pub.add( 'p_global_exposure_flag ==> '|| p_global_exposure_flag );
2707: oe_debug_pub.add( 'p_limit_curr_code ==> '|| p_limit_curr_code );
2708: oe_debug_pub.add( 'include_returns_flag ==> '|| p_credit_check_rule_rec.include_returns_flag);
2709: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2710: END IF;
2703: oe_debug_pub.add( 'p_org_id ==> '|| p_org_id);
2704: oe_debug_pub.add( 'p_include_all_flag ==> '|| p_include_all_flag );
2705: oe_debug_pub.add( 'p_main_bucket ==> '|| p_main_bucket );
2706: oe_debug_pub.add( 'p_global_exposure_flag ==> '|| p_global_exposure_flag );
2707: oe_debug_pub.add( 'p_limit_curr_code ==> '|| p_limit_curr_code );
2708: oe_debug_pub.add( 'include_returns_flag ==> '|| p_credit_check_rule_rec.include_returns_flag);
2709: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2710: END IF;
2711:
2704: oe_debug_pub.add( 'p_include_all_flag ==> '|| p_include_all_flag );
2705: oe_debug_pub.add( 'p_main_bucket ==> '|| p_main_bucket );
2706: oe_debug_pub.add( 'p_global_exposure_flag ==> '|| p_global_exposure_flag );
2707: oe_debug_pub.add( 'p_limit_curr_code ==> '|| p_limit_curr_code );
2708: oe_debug_pub.add( 'include_returns_flag ==> '|| p_credit_check_rule_rec.include_returns_flag);
2709: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2710: END IF;
2711:
2712: l_total := 0;
2705: oe_debug_pub.add( 'p_main_bucket ==> '|| p_main_bucket );
2706: oe_debug_pub.add( 'p_global_exposure_flag ==> '|| p_global_exposure_flag );
2707: oe_debug_pub.add( 'p_limit_curr_code ==> '|| p_limit_curr_code );
2708: oe_debug_pub.add( 'include_returns_flag ==> '|| p_credit_check_rule_rec.include_returns_flag);
2709: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++');
2710: END IF;
2711:
2712: l_total := 0;
2713: l_br_site_use_id := NULL ;
2725: ---------------------- Site Level Exposure ----------------------
2726:
2727: IF G_debug_flag = 'Y'
2728: THEN
2729: oe_debug_pub.add( 'exposure at site level ',1);
2730: END IF;
2731:
2732: l_site_use_id := p_site_use_id;
2733:
2732: l_site_use_id := p_site_use_id;
2733:
2734: IF G_debug_flag = 'Y'
2735: THEN
2736: oe_debug_pub.add( 'l_site_use_id => '|| l_site_use_id );
2737: END IF;
2738:
2739: IF NVL(p_include_all_flag,'N') = 'N'
2740: THEN
2739: IF NVL(p_include_all_flag,'N') = 'N'
2740: THEN
2741: IF G_debug_flag = 'Y'
2742: THEN
2743: oe_debug_pub.add('site - NOT all currencies');
2744: END IF;
2745: -- exposure is at site level and for a list of currencies
2746:
2747: -- for each currency in the list, loop
2768: INTO l_balance;
2769: ELSE
2770: IF G_debug_flag = 'Y'
2771: THEN
2772: oe_debug_pub.add('OPEN site_balance_stub_ret_csr');
2773: END IF;
2774:
2775: OPEN site_balance_stub_ret_csr;
2776: FETCH site_balance_stub_ret_csr
2777: INTO l_balance;
2778:
2779: IF G_debug_flag = 'Y'
2780: THEN
2781: oe_debug_pub.add('l_balance='||TO_CHAR(l_balance));
2782: END IF;
2783: END IF;
2784:
2785: IF p_credit_check_rule_rec.open_ar_balance_flag = 'Y'
2800: END IF;
2801:
2802: IF G_debug_flag = 'Y'
2803: THEN
2804: oe_debug_pub.add
2805: ( 'stub cursor at ' || l_currency_code || ' currency with balance '
2806: || l_balance || ' and bucket/length ' || l_bucket
2807: || '/' || l_bucket_length, 2 );
2808:
2805: ( 'stub cursor at ' || l_currency_code || ' currency with balance '
2806: || l_balance || ' and bucket/length ' || l_bucket
2807: || '/' || l_bucket_length, 2 );
2808:
2809: oe_debug_pub.add
2810: ( 'stub cursor at ' || l_currency_code
2811: || ' currency with BR balance '
2812: || l_br_balance || ' and bucket/length ' || l_bucket
2813: || '/' || l_bucket_length, 2 );
2849: INTO l_balance;
2850: ELSE
2851: IF G_debug_flag = 'Y'
2852: THEN
2853: oe_debug_pub.add('OPEN site_balance_ret_csr');
2854: END IF;
2855:
2856: OPEN site_balance_ret_csr;
2857: FETCH site_balance_ret_csr
2860:
2861:
2862: IF G_debug_flag = 'Y'
2863: THEN
2864: oe_debug_pub.add
2865: ( 'cursor at ' || l_currency_code || ' currency with balance '
2866: || l_balance || ' and bucket/length ' || l_bucket || '/'
2867: || l_bucket_length, 2 );
2868: END IF;
2885: add_error_currency( x_error_curr_tbl, l_currency_code );
2886:
2887: IF G_debug_flag = 'Y'
2888: THEN
2889: oe_debug_pub.add( 'conversion exception for '
2890: || l_currency_code, 1 );
2891: END IF;
2892: END;
2893: ----change for the Return project
2906: ELSE
2907: -- exposure is at site level and for all currencies
2908: IF G_debug_flag = 'Y'
2909: THEN
2910: oe_debug_pub.add( 'SITE, ALL currencies ');
2911: END IF;
2912: i := 0;
2913:
2914: --------------------------
2927: WHILE NOT site_balance_all_curr_stub_csr%NOTFOUND
2928: LOOP
2929: IF G_debug_flag = 'Y'
2930: THEN
2931: oe_debug_pub.add
2932: ( '(all) stub cursor at ' || l_currency_code || ' currency with balance '
2933: || l_balance || ' and bucket/length '
2934: || l_bucket || '/' || l_bucket_length, 2 );
2935: END IF;
2957:
2958: EXCEPTION
2959: WHEN GL_CURRENCY_API.NO_RATE OR
2960: GL_CURRENCY_API.INVALID_CURRENCY THEN
2961: oe_debug_pub.add( 'conversion exception for '
2962: || l_currency_code, 1 );
2963: add_error_currency( x_error_curr_tbl, l_currency_code );
2964: END;
2965: ELSE
2962: || l_currency_code, 1 );
2963: add_error_currency( x_error_curr_tbl, l_currency_code );
2964: END;
2965: ELSE
2966: oe_debug_pub.add( 'Currency excluded from usages '
2967: || l_currency_code);
2968: END IF; -- exclude curr list
2969:
2970: FETCH site_balance_all_curr_stub_csr
2983:
2984: ELSE
2985: IF G_debug_flag = 'Y'
2986: THEN
2987: oe_debug_pub.add('OPEN site_bal_all_curr_stub_ret_csr');
2988: END IF;
2989:
2990: OPEN site_bal_all_curr_stub_ret_csr;
2991: FETCH site_bal_all_curr_stub_ret_csr
2995: WHILE NOT site_bal_all_curr_stub_ret_csr%NOTFOUND
2996: LOOP
2997: IF G_debug_flag = 'Y'
2998: THEN
2999: oe_debug_pub.add
3000: ( '(all) stub cursor at ' || l_currency_code || ' currency with balance '
3001: || l_balance || ' and bucket/length '
3002: || l_bucket || '/' || l_bucket_length, 2 );
3003: END IF;
3025:
3026: EXCEPTION
3027: WHEN GL_CURRENCY_API.NO_RATE OR
3028: GL_CURRENCY_API.INVALID_CURRENCY THEN
3029: oe_debug_pub.add( 'conversion exception for '
3030: || l_currency_code, 1 );
3031: add_error_currency( x_error_curr_tbl, l_currency_code );
3032: END;
3033: ELSE
3030: || l_currency_code, 1 );
3031: add_error_currency( x_error_curr_tbl, l_currency_code );
3032: END;
3033: ELSE
3034: oe_debug_pub.add( 'Currency excluded from usages '
3035: || l_currency_code);
3036: END IF; -- exclude curr list
3037:
3038: FETCH site_bal_all_curr_stub_ret_csr
3071: WHILE NOT site_br_all_curr_stub_csr%NOTFOUND
3072: LOOP
3073: IF G_debug_flag = 'Y'
3074: THEN
3075: oe_debug_pub.add
3076: ( '(all) stub cursor at ' || l_currency_code
3077: || ' currency with BR balance '
3078: || l_br_balance || ' and bucket/length '
3079: || l_bucket || '/' || l_bucket_length, 2 );
3101:
3102: EXCEPTION
3103: WHEN GL_CURRENCY_API.NO_RATE OR
3104: GL_CURRENCY_API.INVALID_CURRENCY THEN
3105: oe_debug_pub.add( 'conversion exception for '
3106: || l_currency_code, 1 );
3107: add_error_currency( x_error_curr_tbl, l_currency_code );
3108: END;
3109: ELSE
3106: || l_currency_code, 1 );
3107: add_error_currency( x_error_curr_tbl, l_currency_code );
3108: END;
3109: ELSE
3110: oe_debug_pub.add( 'Currency excluded from usages '
3111: || l_currency_code);
3112: END IF; -- exclude curr list
3113:
3114: FETCH site_br_all_curr_stub_csr
3142: WHILE NOT site_balance_all_curr_csr%NOTFOUND
3143: LOOP
3144: IF G_debug_flag = 'Y'
3145: THEN
3146: oe_debug_pub.add
3147: ( 'cursor at ' || l_currency_code || ' currency with balance '
3148: || l_balance || ' and bucket/length ' || l_bucket
3149: || '/' || l_bucket_length, 2 );
3150: END IF;
3171:
3172: EXCEPTION
3173: WHEN GL_CURRENCY_API.NO_RATE OR
3174: GL_CURRENCY_API.INVALID_CURRENCY THEN
3175: oe_debug_pub.add( 'conversion exception for '
3176: || l_currency_code, 1 );
3177: add_error_currency( x_error_curr_tbl, l_currency_code );
3178: END;
3179: ELSE
3176: || l_currency_code, 1 );
3177: add_error_currency( x_error_curr_tbl, l_currency_code );
3178: END;
3179: ELSE
3180: oe_debug_pub.add( 'Currency excluded from usages ');
3181: END IF; -- exclude curr list
3182:
3183: FETCH site_balance_all_curr_csr
3184: INTO l_balance, l_currency_code;
3200: WHILE NOT site_bal_all_curr_ret_csr%NOTFOUND
3201: LOOP
3202: IF G_debug_flag = 'Y'
3203: THEN
3204: oe_debug_pub.add
3205: ( 'cursor at ' || l_currency_code || ' currency with balance '
3206: || l_balance || ' and bucket/length ' || l_bucket
3207: || '/' || l_bucket_length, 2 );
3208: END IF;
3229:
3230: EXCEPTION
3231: WHEN GL_CURRENCY_API.NO_RATE OR
3232: GL_CURRENCY_API.INVALID_CURRENCY THEN
3233: oe_debug_pub.add( 'conversion exception for '
3234: || l_currency_code, 1 );
3235: add_error_currency( x_error_curr_tbl, l_currency_code );
3236: END;
3237: ELSE
3234: || l_currency_code, 1 );
3235: add_error_currency( x_error_curr_tbl, l_currency_code );
3236: END;
3237: ELSE
3238: oe_debug_pub.add( 'Currency excluded from usages ');
3239: END IF; -- exclude curr list
3240:
3241: FETCH site_bal_all_curr_ret_csr
3242: INTO l_balance, l_currency_code;
3256: ELSIF p_customer_id IS NOT NULL
3257: THEN
3258: IF G_debug_flag = 'Y'
3259: THEN
3260: oe_debug_pub.add( 'exposure at customer level', 1 );
3261: END IF;
3262:
3263: IF NVL(p_include_all_flag,'N') = 'N'
3264: THEN
3266: -- for each currency in the list
3267:
3268: IF G_debug_flag = 'Y'
3269: THEN
3270: oe_debug_pub.add( 'NOT ALL currencies ');
3271: END IF;
3272:
3273: i := p_usage_curr_tbl.FIRST;
3274: WHILE i IS NOT NULL
3282: IF p_global_exposure_flag = 'Y'
3283: THEN
3284: IF G_debug_flag = 'Y'
3285: THEN
3286: oe_debug_pub.add( ' Into CUST global ');
3287: END IF;
3288:
3289: ----change for the Return project
3290: IF NVL(p_credit_check_rule_rec.include_returns_flag,'N') = 'N'
3309: END IF;
3310:
3311: IF G_debug_flag = 'Y'
3312: THEN
3313: oe_debug_pub.add
3314: ( 'global stub cursor at ' || l_currency_code
3315: || ' currency with balance ' || l_balance, 2 );
3316: oe_debug_pub.add
3317: ( 'global stub cursor at ' || l_currency_code
3312: THEN
3313: oe_debug_pub.add
3314: ( 'global stub cursor at ' || l_currency_code
3315: || ' currency with balance ' || l_balance, 2 );
3316: oe_debug_pub.add
3317: ( 'global stub cursor at ' || l_currency_code
3318: || ' currency with BR balance ' || l_br_balance, 2 );
3319: END IF;
3320: BEGIN
3332:
3333: EXCEPTION
3334: WHEN GL_CURRENCY_API.NO_RATE OR
3335: GL_CURRENCY_API.INVALID_CURRENCY THEN
3336: oe_debug_pub.add( 'conversion exception for '
3337: || l_currency_code, 1 );
3338: add_error_currency( x_error_curr_tbl, l_currency_code );
3339: END;
3340: ----change for the Return project
3367: END IF;
3368:
3369: IF G_debug_flag = 'Y'
3370: THEN
3371: oe_debug_pub.add
3372: ( 'cust global cursor at ' || l_currency_code
3373: || ' currency with balance ' || l_balance, 2 );
3374: END IF;
3375: BEGIN
3386:
3387: EXCEPTION
3388: WHEN GL_CURRENCY_API.NO_RATE OR
3389: GL_CURRENCY_API.INVALID_CURRENCY THEN
3390: oe_debug_pub.add( 'conversion exception for '
3391: || l_currency_code, 1 );
3392: add_error_currency( x_error_curr_tbl, l_currency_code );
3393: END;
3394:
3405:
3406: ELSE -- not global cck
3407: IF G_debug_flag = 'Y'
3408: THEN
3409: oe_debug_pub.add( 'Into cust NOT global ');
3410: END IF;
3411:
3412: ----change for the Return project
3413: IF NVL(p_credit_check_rule_rec.include_returns_flag,'N') = 'N'
3433: END IF;
3434:
3435: IF G_debug_flag = 'Y'
3436: THEN
3437: oe_debug_pub.add
3438: ( 'cust stub cursor at ' || l_currency_code
3439: || ' currency with balance ' || l_balance, 2 );
3440: oe_debug_pub.add
3441: ( 'cust stub cursor at ' || l_currency_code
3436: THEN
3437: oe_debug_pub.add
3438: ( 'cust stub cursor at ' || l_currency_code
3439: || ' currency with balance ' || l_balance, 2 );
3440: oe_debug_pub.add
3441: ( 'cust stub cursor at ' || l_currency_code
3442: || ' currency with BR balance ' || l_br_balance, 2 );
3443: END IF;
3444:
3456: l_total := l_total + NVL( l_term, 0 );
3457: EXCEPTION
3458: WHEN GL_CURRENCY_API.NO_RATE OR
3459: GL_CURRENCY_API.INVALID_CURRENCY THEN
3460: oe_debug_pub.add( 'conversion exception for '
3461: || l_currency_code, 1 );
3462: add_error_currency( x_error_curr_tbl, l_currency_code );
3463: END;
3464:
3492: END IF;
3493:
3494: IF G_debug_flag = 'Y'
3495: THEN
3496: oe_debug_pub.add
3497: ( 'cust cursor at ' || l_currency_code
3498: || ' currency with balance ' || l_balance, 2 );
3499: END IF;
3500:
3512:
3513: EXCEPTION
3514: WHEN GL_CURRENCY_API.NO_RATE OR
3515: GL_CURRENCY_API.INVALID_CURRENCY THEN
3516: oe_debug_pub.add( 'conversion exception for '
3517: || l_currency_code, 1 );
3518: add_error_currency( x_error_curr_tbl, l_currency_code );
3519: END;
3520:
3537: -- for each currency in the list
3538:
3539: IF G_debug_flag = 'Y'
3540: THEN
3541: oe_debug_pub.add(' Into ALL currencies ');
3542: END IF;
3543:
3544:
3545: i := 0;
3551: IF p_global_exposure_flag = 'Y'
3552: THEN
3553: IF G_debug_flag = 'Y'
3554: THEN
3555: oe_debug_pub.add( ' Into cust GLOBAL');
3556: END IF;
3557:
3558: ----change for the Return project
3559: IF NVL(p_credit_check_rule_rec.include_returns_flag,'N') = 'N'
3567: WHILE NOT cust_all_curr_stub_csr_global%NOTFOUND
3568: LOOP
3569: IF G_debug_flag = 'Y'
3570: THEN
3571: oe_debug_pub.add
3572: ( '(all) stub global cursor at ' || l_currency_code
3573: || ' currency with balance '
3574: || l_balance || ' and bucket/length '
3575: || l_bucket || '/' || l_bucket_length, 2 );
3597:
3598: EXCEPTION
3599: WHEN GL_CURRENCY_API.NO_RATE
3600: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3601: oe_debug_pub.add( 'conversion exception for '
3602: || l_currency_code, 1 );
3603: add_error_currency( x_error_curr_tbl, l_currency_code );
3604: END;
3605: ELSE
3602: || l_currency_code, 1 );
3603: add_error_currency( x_error_curr_tbl, l_currency_code );
3604: END;
3605: ELSE
3606: oe_debug_pub.add( 'Currency excluded from usages ');
3607: END IF; -- exclude curr list
3608: FETCH cust_all_curr_stub_csr_global
3609: INTO l_balance, l_currency_code;
3610: i := i + 1;
3622: WHILE NOT cust_all_curr_stub_ret_csr_gl%NOTFOUND
3623: LOOP
3624: IF G_debug_flag = 'Y'
3625: THEN
3626: oe_debug_pub.add
3627: ( '(all) stub global cursor at ' || l_currency_code
3628: || ' currency with balance '
3629: || l_balance || ' and bucket/length '
3630: || l_bucket || '/' || l_bucket_length, 2 );
3652:
3653: EXCEPTION
3654: WHEN GL_CURRENCY_API.NO_RATE
3655: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3656: oe_debug_pub.add( 'conversion exception for '
3657: || l_currency_code, 1 );
3658: add_error_currency( x_error_curr_tbl, l_currency_code );
3659: END;
3660: ELSE
3657: || l_currency_code, 1 );
3658: add_error_currency( x_error_curr_tbl, l_currency_code );
3659: END;
3660: ELSE
3661: oe_debug_pub.add( 'Currency excluded from usages ');
3662: END IF; -- exclude curr list
3663:
3664: FETCH cust_all_curr_stub_ret_csr_gl
3665: INTO l_balance, l_currency_code;
3683: l_bucket_length := G_MAX_BUCKET_LENGTH;
3684:
3685: IF G_debug_flag = 'Y'
3686: THEN
3687: oe_debug_pub.add( ' Into cust GLOBAL');
3688: END IF;
3689:
3690: OPEN cust_br_all_curr_stub_csr_gl;
3691: FETCH cust_br_all_curr_stub_csr_gl
3696: WHILE NOT cust_br_all_curr_stub_csr_gl%NOTFOUND
3697: LOOP
3698: IF G_debug_flag = 'Y'
3699: THEN
3700: oe_debug_pub.add
3701: ( '(all) stub global cursor at ' || l_currency_code
3702: || ' currency with BR balance '
3703: || l_br_balance || ' and bucket/length '
3704: || l_bucket || '/' || l_bucket_length, 2 );
3727:
3728: EXCEPTION
3729: WHEN GL_CURRENCY_API.NO_RATE
3730: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3731: oe_debug_pub.add( 'conversion exception for '
3732: || l_currency_code, 1 );
3733: add_error_currency( x_error_curr_tbl, l_currency_code );
3734: END;
3735: ELSE
3732: || l_currency_code, 1 );
3733: add_error_currency( x_error_curr_tbl, l_currency_code );
3734: END;
3735: ELSE
3736: oe_debug_pub.add( 'Currency excluded from usages ');
3737: END IF; -- exclude curr list
3738: FETCH cust_br_all_curr_stub_csr_gl
3739: INTO l_br_balance, l_currency_code;
3740: i := i + 1;
3766: WHILE NOT cust_all_curr_csr_global%NOTFOUND
3767: LOOP
3768: IF G_debug_flag = 'Y'
3769: THEN
3770: oe_debug_pub.add
3771: ( 'cust all global cursor at ' || l_currency_code
3772: || ' currency with balance '
3773: || l_balance || ' and bucket/length '
3774: || l_bucket || '/' || l_bucket_length, 2 );
3797:
3798: EXCEPTION
3799: WHEN GL_CURRENCY_API.NO_RATE OR
3800: GL_CURRENCY_API.INVALID_CURRENCY THEN
3801: oe_debug_pub.add( 'conversion exception for ' ||
3802: l_currency_code, 1 );
3803: add_error_currency( x_error_curr_tbl, l_currency_code );
3804: END;
3805: ELSE
3802: l_currency_code, 1 );
3803: add_error_currency( x_error_curr_tbl, l_currency_code );
3804: END;
3805: ELSE
3806: oe_debug_pub.add( 'Currency excluded from usages ');
3807: END IF; -- exclude curr list
3808: FETCH cust_all_curr_csr_global INTO l_balance, l_currency_code;
3809: i := i + 1;
3810: END LOOP;
3822: WHILE NOT cust_all_curr_ret_csr_global%NOTFOUND
3823: LOOP
3824: IF G_debug_flag = 'Y'
3825: THEN
3826: oe_debug_pub.add
3827: ( 'cust all global cursor at ' || l_currency_code
3828: || ' currency with balance '
3829: || l_balance || ' and bucket/length '
3830: || l_bucket || '/' || l_bucket_length, 2 );
3853:
3854: EXCEPTION
3855: WHEN GL_CURRENCY_API.NO_RATE OR
3856: GL_CURRENCY_API.INVALID_CURRENCY THEN
3857: oe_debug_pub.add( 'conversion exception for ' ||
3858: l_currency_code, 1 );
3859: add_error_currency( x_error_curr_tbl, l_currency_code );
3860: END;
3861: ELSE
3858: l_currency_code, 1 );
3859: add_error_currency( x_error_curr_tbl, l_currency_code );
3860: END;
3861: ELSE
3862: oe_debug_pub.add( 'Currency excluded from usages ');
3863: END IF; -- exclude curr list
3864:
3865: FETCH cust_all_curr_ret_csr_global
3866: INTO l_balance, l_currency_code;
3876:
3877: ELSE -- not global cck
3878: IF G_debug_flag = 'Y'
3879: THEN
3880: oe_debug_pub.add(' Into cust NOT global ');
3881: END IF;
3882:
3883: ----change for the Return project
3884: IF NVL(p_credit_check_rule_rec.include_returns_flag,'N') = 'N'
3892: WHILE NOT customer_all_curr_stub_csr%NOTFOUND
3893: LOOP
3894: IF G_debug_flag = 'Y'
3895: THEN
3896: oe_debug_pub.add
3897: ( '(all) stub cursor at ' || l_currency_code
3898: || ' currency with balance '
3899: || l_balance || ' and bucket/length '
3900: || l_bucket || '/' || l_bucket_length, 2 );
3922:
3923: EXCEPTION
3924: WHEN GL_CURRENCY_API.NO_RATE
3925: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3926: oe_debug_pub.add( 'conversion exception for '
3927: || l_currency_code, 1 );
3928: add_error_currency( x_error_curr_tbl, l_currency_code );
3929: END;
3930: ELSE
3927: || l_currency_code, 1 );
3928: add_error_currency( x_error_curr_tbl, l_currency_code );
3929: END;
3930: ELSE
3931: oe_debug_pub.add(' Currency excluded from usages list ');
3932: END IF;
3933:
3934: FETCH customer_all_curr_stub_csr
3935: INTO l_balance, l_currency_code;
3950: WHILE NOT customer_all_curr_stub_ret_csr%NOTFOUND
3951: LOOP
3952: IF G_debug_flag = 'Y'
3953: THEN
3954: oe_debug_pub.add
3955: ( '(all) stub cursor at ' || l_currency_code
3956: || ' currency with balance '
3957: || l_balance || ' and bucket/length '
3958: || l_bucket || '/' || l_bucket_length, 2 );
3980:
3981: EXCEPTION
3982: WHEN GL_CURRENCY_API.NO_RATE
3983: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
3984: oe_debug_pub.add( 'conversion exception for '
3985: || l_currency_code, 1 );
3986: add_error_currency( x_error_curr_tbl, l_currency_code );
3987: END;
3988: ELSE
3985: || l_currency_code, 1 );
3986: add_error_currency( x_error_curr_tbl, l_currency_code );
3987: END;
3988: ELSE
3989: oe_debug_pub.add(' Currency excluded from usages list ');
3990: END IF;
3991:
3992: FETCH customer_all_curr_stub_ret_csr
3993: INTO l_balance, l_currency_code;
4013: WHILE NOT customer_br_all_curr_stub_csr%NOTFOUND
4014: LOOP
4015: IF G_debug_flag = 'Y'
4016: THEN
4017: oe_debug_pub.add
4018: ( '(all) stub cursor at ' || l_currency_code
4019: || ' currency with BR balance '
4020: || l_br_balance || ' and bucket/length '
4021: || l_bucket || '/' || l_bucket_length, 2 );
4043:
4044: EXCEPTION
4045: WHEN GL_CURRENCY_API.NO_RATE
4046: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4047: oe_debug_pub.add( 'conversion exception for '
4048: || l_currency_code, 1 );
4049: add_error_currency( x_error_curr_tbl, l_currency_code );
4050: END;
4051: ELSE
4048: || l_currency_code, 1 );
4049: add_error_currency( x_error_curr_tbl, l_currency_code );
4050: END;
4051: ELSE
4052: oe_debug_pub.add(' Currency excluded from usages list ');
4053: END IF;
4054:
4055: FETCH customer_br_all_curr_stub_csr
4056: INTO l_br_balance, l_currency_code;
4082: WHILE NOT customer_balance_all_curr_csr%NOTFOUND
4083: LOOP
4084: IF G_debug_flag = 'Y'
4085: THEN
4086: oe_debug_pub.add
4087: ( '(all) cursor at ' || l_currency_code
4088: || ' currency with balance '
4089: || l_balance || ' and bucket/length '
4090: || l_bucket || '/' || l_bucket_length, 2 );
4113: EXCEPTION
4114: WHEN GL_CURRENCY_API.NO_RATE OR
4115: GL_CURRENCY_API.INVALID_CURRENCY THEN
4116:
4117: oe_debug_pub.add( 'conversion exception for '
4118: || l_currency_code, 1 );
4119: add_error_currency( x_error_curr_tbl, l_currency_code );
4120: END;
4121: ELSE
4118: || l_currency_code, 1 );
4119: add_error_currency( x_error_curr_tbl, l_currency_code );
4120: END;
4121: ELSE
4122: oe_debug_pub.add(' Currency excluded from usages list ');
4123: END IF;
4124:
4125: FETCH customer_balance_all_curr_csr
4126: INTO l_balance, l_currency_code;
4139: WHILE NOT customer_bal_all_curr_ret_csr%NOTFOUND
4140: LOOP
4141: IF G_debug_flag = 'Y'
4142: THEN
4143: oe_debug_pub.add
4144: ( '(all) cursor at ' || l_currency_code
4145: || ' currency with balance '
4146: || l_balance || ' and bucket/length '
4147: || l_bucket || '/' || l_bucket_length, 2 );
4170: EXCEPTION
4171: WHEN GL_CURRENCY_API.NO_RATE OR
4172: GL_CURRENCY_API.INVALID_CURRENCY THEN
4173:
4174: oe_debug_pub.add( 'conversion exception for '
4175: || l_currency_code, 1 );
4176: add_error_currency( x_error_curr_tbl, l_currency_code );
4177: END;
4178: ELSE
4175: || l_currency_code, 1 );
4176: add_error_currency( x_error_curr_tbl, l_currency_code );
4177: END;
4178: ELSE
4179: oe_debug_pub.add(' Currency excluded from usages list ');
4180: END IF;
4181:
4182: FETCH customer_bal_all_curr_ret_csr
4183: INTO l_balance, l_currency_code;
4203: THEN
4204:
4205: IF G_debug_flag = 'Y'
4206: THEN
4207: oe_debug_pub.add( 'exposure at Party level ',1);
4208: oe_debug_pub.add( 'g_use_party_hierarchy => '|| g_use_party_hierarchy );
4209: END IF;
4210:
4211: IF NVL(p_include_all_flag,'N') = 'N'
4204:
4205: IF G_debug_flag = 'Y'
4206: THEN
4207: oe_debug_pub.add( 'exposure at Party level ',1);
4208: oe_debug_pub.add( 'g_use_party_hierarchy => '|| g_use_party_hierarchy );
4209: END IF;
4210:
4211: IF NVL(p_include_all_flag,'N') = 'N'
4212: THEN
4211: IF NVL(p_include_all_flag,'N') = 'N'
4212: THEN
4213: IF G_debug_flag = 'Y'
4214: THEN
4215: oe_debug_pub.add( 'NOT ALL currencies ');
4216: END IF;
4217:
4218: IF g_use_party_hierarchy = 'N'
4219: THEN
4253: END IF;
4254:
4255: IF G_debug_flag = 'Y'
4256: THEN
4257: oe_debug_pub.add
4258: ( 'global stub cursor at ' || l_currency_code
4259: || ' currency with balance ' || l_balance, 2 );
4260: oe_debug_pub.add
4261: ( 'global stub cursor at ' || l_currency_code
4256: THEN
4257: oe_debug_pub.add
4258: ( 'global stub cursor at ' || l_currency_code
4259: || ' currency with balance ' || l_balance, 2 );
4260: oe_debug_pub.add
4261: ( 'global stub cursor at ' || l_currency_code
4262: || ' currency with BR balance ' || l_br_balance, 2 );
4263: END IF;
4264: BEGIN
4276:
4277: EXCEPTION
4278: WHEN GL_CURRENCY_API.NO_RATE OR
4279: GL_CURRENCY_API.INVALID_CURRENCY THEN
4280: oe_debug_pub.add( 'conversion exception for '
4281: || l_currency_code, 1 );
4282: add_error_currency( x_error_curr_tbl, l_currency_code );
4283: END;
4284:
4317: END IF;
4318:
4319: IF G_debug_flag = 'Y'
4320: THEN
4321: oe_debug_pub.add
4322: ( 'global cursor at ' || l_currency_code
4323: || ' currency with balance ' || l_balance, 2 );
4324: END IF;
4325: BEGIN
4336:
4337: EXCEPTION
4338: WHEN GL_CURRENCY_API.NO_RATE OR
4339: GL_CURRENCY_API.INVALID_CURRENCY THEN
4340: oe_debug_pub.add( 'conversion exception for '
4341: || l_currency_code, 1 );
4342: add_error_currency( x_error_curr_tbl, l_currency_code );
4343: END;
4344:
4360:
4361: ELSE --- Hierarchy usages
4362: IF G_debug_flag = 'Y'
4363: THEN
4364: oe_debug_pub.add(' Hierarchy Usages ',1);
4365: oe_debug_pub.add(' OE_CREDIT_CHECK_UTIL.G_hierarchy_type => '||
4366: OE_CREDIT_CHECK_UTIL.G_hierarchy_type );
4367: oe_debug_pub.add(' G_MAX_BUCKET_LENGTH => '||
4368: G_MAX_BUCKET_LENGTH);
4361: ELSE --- Hierarchy usages
4362: IF G_debug_flag = 'Y'
4363: THEN
4364: oe_debug_pub.add(' Hierarchy Usages ',1);
4365: oe_debug_pub.add(' OE_CREDIT_CHECK_UTIL.G_hierarchy_type => '||
4366: OE_CREDIT_CHECK_UTIL.G_hierarchy_type );
4367: oe_debug_pub.add(' G_MAX_BUCKET_LENGTH => '||
4368: G_MAX_BUCKET_LENGTH);
4369: END IF;
4363: THEN
4364: oe_debug_pub.add(' Hierarchy Usages ',1);
4365: oe_debug_pub.add(' OE_CREDIT_CHECK_UTIL.G_hierarchy_type => '||
4366: OE_CREDIT_CHECK_UTIL.G_hierarchy_type );
4367: oe_debug_pub.add(' G_MAX_BUCKET_LENGTH => '||
4368: G_MAX_BUCKET_LENGTH);
4369: END IF;
4370:
4371: i := p_usage_curr_tbl.FIRST;
4400: END IF;
4401:
4402: IF G_debug_flag = 'Y'
4403: THEN
4404: oe_debug_pub.add
4405: ( 'global stub cursor at ' || l_currency_code
4406: || ' currency with balance ' || l_balance, 2 );
4407: END IF;
4408:
4421:
4422: EXCEPTION
4423: WHEN GL_CURRENCY_API.NO_RATE OR
4424: GL_CURRENCY_API.INVALID_CURRENCY THEN
4425: oe_debug_pub.add( 'conversion exception for '
4426: || l_currency_code, 1 );
4427: add_error_currency( x_error_curr_tbl, l_currency_code );
4428: END;
4429:
4458: END IF;
4459:
4460: IF G_debug_flag = 'Y'
4461: THEN
4462: oe_debug_pub.add
4463: ( 'global cursor at ' || l_currency_code
4464: || ' currency with balance ' || l_balance, 2 );
4465: END IF;
4466:
4478:
4479: EXCEPTION
4480: WHEN GL_CURRENCY_API.NO_RATE OR
4481: GL_CURRENCY_API.INVALID_CURRENCY THEN
4482: oe_debug_pub.add( 'conversion exception for '
4483: || l_currency_code, 1 );
4484: add_error_currency( x_error_curr_tbl, l_currency_code );
4485: END;
4486:
4504:
4505: ELSE -- level all currencies
4506: IF G_debug_flag = 'Y'
4507: THEN
4508: oe_debug_pub.add(' Into ALL currencies party ');
4509: END IF;
4510:
4511:
4512: i := 0;
4518: IF g_use_party_hierarchy = 'N'
4519: THEN
4520: IF G_debug_flag = 'Y'
4521: THEN
4522: oe_debug_pub.add( ' Into party all curr ');
4523: END IF;
4524:
4525: ---change for the Return project
4526: IF NVL(p_credit_check_rule_rec.include_returns_flag,'N') = 'N'
4534: WHILE NOT party_all_curr_stub_csr_global%NOTFOUND
4535: LOOP
4536: IF G_debug_flag = 'Y'
4537: THEN
4538: oe_debug_pub.add
4539: ( '(all) stub global cursor at ' || l_currency_code
4540: || ' currency with balance '
4541: || l_balance || ' and bucket/length '
4542: || l_bucket || '/' || l_bucket_length, 2 );
4564:
4565: EXCEPTION
4566: WHEN GL_CURRENCY_API.NO_RATE
4567: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4568: oe_debug_pub.add( 'conversion exception for '
4569: || l_currency_code, 1 );
4570: add_error_currency( x_error_curr_tbl, l_currency_code );
4571: END;
4572: ELSE
4569: || l_currency_code, 1 );
4570: add_error_currency( x_error_curr_tbl, l_currency_code );
4571: END;
4572: ELSE
4573: oe_debug_pub.add( 'Currency excluded from usages ');
4574: END IF; -- exclude curr list
4575:
4576: FETCH party_all_curr_stub_csr_global
4577: INTO l_balance, l_currency_code;
4591: WHILE NOT party_all_curr_stub_ret_csr_gl%NOTFOUND
4592: LOOP
4593: IF G_debug_flag = 'Y'
4594: THEN
4595: oe_debug_pub.add
4596: ( '(all) stub global cursor at ' || l_currency_code
4597: || ' currency with balance '
4598: || l_balance || ' and bucket/length '
4599: || l_bucket || '/' || l_bucket_length, 2 );
4621:
4622: EXCEPTION
4623: WHEN GL_CURRENCY_API.NO_RATE
4624: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4625: oe_debug_pub.add( 'conversion exception for '
4626: || l_currency_code, 1 );
4627: add_error_currency( x_error_curr_tbl, l_currency_code );
4628: END;
4629: ELSE
4626: || l_currency_code, 1 );
4627: add_error_currency( x_error_curr_tbl, l_currency_code );
4628: END;
4629: ELSE
4630: oe_debug_pub.add( 'Currency excluded from usages ');
4631: END IF; -- exclude curr list
4632:
4633: FETCH party_all_curr_stub_ret_csr_gl
4634: INTO l_balance, l_currency_code;
4655: LOOP
4656:
4657: IF G_debug_flag = 'Y'
4658: THEN
4659: oe_debug_pub.add
4660: ( '(all) stub global cursor at ' || l_currency_code
4661: || ' currency with BR balance '
4662: || l_br_balance || ' and bucket/length '
4663: || l_bucket || '/' || l_bucket_length, 2 );
4685:
4686: EXCEPTION
4687: WHEN GL_CURRENCY_API.NO_RATE
4688: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
4689: oe_debug_pub.add( 'conversion exception for '
4690: || l_currency_code, 1 );
4691: add_error_currency( x_error_curr_tbl, l_currency_code );
4692: END;
4693: ELSE
4690: || l_currency_code, 1 );
4691: add_error_currency( x_error_curr_tbl, l_currency_code );
4692: END;
4693: ELSE
4694: oe_debug_pub.add( 'Currency excluded from usages ');
4695: END IF; -- exclude curr list
4696:
4697: FETCH party_br_all_curr_stub_csr_gl
4698: INTO l_br_balance, l_currency_code;
4727: LOOP
4728:
4729: IF G_debug_flag = 'Y'
4730: THEN
4731: oe_debug_pub.add
4732: ( 'party all global cursor at ' || l_currency_code
4733: || ' currency with balance '
4734: || l_balance || ' and bucket/length '
4735: || l_bucket || '/' || l_bucket_length, 2 );
4757:
4758: EXCEPTION
4759: WHEN GL_CURRENCY_API.NO_RATE OR
4760: GL_CURRENCY_API.INVALID_CURRENCY THEN
4761: oe_debug_pub.add( 'conversion exception for ' ||
4762: l_currency_code, 1 );
4763: add_error_currency( x_error_curr_tbl, l_currency_code );
4764: END;
4765: ELSE
4762: l_currency_code, 1 );
4763: add_error_currency( x_error_curr_tbl, l_currency_code );
4764: END;
4765: ELSE
4766: oe_debug_pub.add( 'Currency excluded from usages ');
4767: END IF; -- exclude curr list
4768:
4769: FETCH party_all_curr_csr_global INTO l_balance, l_currency_code;
4770:
4786: LOOP
4787:
4788: IF G_debug_flag = 'Y'
4789: THEN
4790: oe_debug_pub.add
4791: ( 'party all global cursor at ' || l_currency_code
4792: || ' currency with balance '
4793: || l_balance || ' and bucket/length '
4794: || l_bucket || '/' || l_bucket_length, 2 );
4816:
4817: EXCEPTION
4818: WHEN GL_CURRENCY_API.NO_RATE OR
4819: GL_CURRENCY_API.INVALID_CURRENCY THEN
4820: oe_debug_pub.add( 'conversion exception for ' ||
4821: l_currency_code, 1 );
4822: add_error_currency( x_error_curr_tbl, l_currency_code );
4823: END;
4824: ELSE
4821: l_currency_code, 1 );
4822: add_error_currency( x_error_curr_tbl, l_currency_code );
4823: END;
4824: ELSE
4825: oe_debug_pub.add( 'Currency excluded from usages ');
4826: END IF; -- exclude curr list
4827:
4828: FETCH party_all_curr_ret_csr_gl
4829: INTO l_balance, l_currency_code;
4841: ELSE -- Hierarchy
4842:
4843: IF G_debug_flag = 'Y'
4844: THEN
4845: oe_debug_pub.add(' Into party Hierarchy ',1);
4846: END IF;
4847:
4848: ---change for the Return project
4849: IF NVL(p_credit_check_rule_rec.include_returns_flag,'N') = 'N'
4859: WHILE NOT party_h_all_curr_stub_csr_gl%NOTFOUND
4860: LOOP
4861: IF G_debug_flag = 'Y'
4862: THEN
4863: oe_debug_pub.add
4864: ( '(all) stub cursor at ' || l_currency_code
4865: || ' currency with balance '
4866: || l_balance || ' and bucket/length '
4867: || l_bucket || '/' || l_bucket_length, 2 );
4890: EXCEPTION
4891: WHEN GL_CURRENCY_API.NO_RATE
4892: OR GL_CURRENCY_API.INVALID_CURRENCY
4893: THEN
4894: oe_debug_pub.add( 'conversion exception for '
4895: || l_currency_code, 1 );
4896: add_error_currency( x_error_curr_tbl, l_currency_code );
4897: END;
4898: ELSE
4895: || l_currency_code, 1 );
4896: add_error_currency( x_error_curr_tbl, l_currency_code );
4897: END;
4898: ELSE
4899: oe_debug_pub.add(' Currency excluded from usages list ');
4900: END IF;
4901:
4902: FETCH party_h_all_curr_stub_csr_gl
4903: INTO l_balance, l_currency_code;
4918: WHILE NOT p_h_all_curr_stub_ret_csr_gl%NOTFOUND
4919: LOOP
4920: IF G_debug_flag = 'Y'
4921: THEN
4922: oe_debug_pub.add
4923: ( '(all) stub cursor at ' || l_currency_code
4924: || ' currency with balance '
4925: || l_balance || ' and bucket/length '
4926: || l_bucket || '/' || l_bucket_length, 2 );
4949: EXCEPTION
4950: WHEN GL_CURRENCY_API.NO_RATE
4951: OR GL_CURRENCY_API.INVALID_CURRENCY
4952: THEN
4953: oe_debug_pub.add( 'conversion exception for '
4954: || l_currency_code, 1 );
4955: add_error_currency( x_error_curr_tbl, l_currency_code );
4956: END;
4957: ELSE
4954: || l_currency_code, 1 );
4955: add_error_currency( x_error_curr_tbl, l_currency_code );
4956: END;
4957: ELSE
4958: oe_debug_pub.add(' Currency excluded from usages list ');
4959: END IF;
4960:
4961: FETCH p_h_all_curr_stub_ret_csr_gl
4962: INTO l_balance, l_currency_code;
4980: WHILE NOT party_br_h_all_curr_stub_gl%NOTFOUND
4981: LOOP
4982: IF G_debug_flag = 'Y'
4983: THEN
4984: oe_debug_pub.add
4985: ( '(all) stub cursor at ' || l_currency_code
4986: || ' currency with BR balance '
4987: || l_BR_balance || ' and bucket/length '
4988: || l_bucket || '/' || l_bucket_length, 2 );
5010:
5011: EXCEPTION
5012: WHEN GL_CURRENCY_API.NO_RATE
5013: OR GL_CURRENCY_API.INVALID_CURRENCY THEN
5014: oe_debug_pub.add( 'conversion exception for '
5015: || l_currency_code, 1 );
5016: add_error_currency( x_error_curr_tbl, l_currency_code );
5017: END;
5018: ELSE
5015: || l_currency_code, 1 );
5016: add_error_currency( x_error_curr_tbl, l_currency_code );
5017: END;
5018: ELSE
5019: oe_debug_pub.add(' Currency excluded from usages list ');
5020: END IF;
5021:
5022: FETCH party_br_h_all_curr_stub_gl
5023: INTO l_br_balance, l_currency_code;
5047: WHILE NOT party_h_all_curr_csr_global%NOTFOUND
5048: LOOP
5049: IF G_debug_flag = 'Y'
5050: THEN
5051: oe_debug_pub.add
5052: ( '(all) cursor at ' || l_currency_code
5053: || ' currency with balance '
5054: || l_balance || ' and bucket/length '
5055: || l_bucket || '/' || l_bucket_length, 2 );
5079: WHEN GL_CURRENCY_API.NO_RATE OR
5080: GL_CURRENCY_API.INVALID_CURRENCY
5081: THEN
5082:
5083: oe_debug_pub.add( 'conversion exception for '
5084: || l_currency_code, 1 );
5085: add_error_currency( x_error_curr_tbl, l_currency_code );
5086: END;
5087: ELSE
5084: || l_currency_code, 1 );
5085: add_error_currency( x_error_curr_tbl, l_currency_code );
5086: END;
5087: ELSE
5088: oe_debug_pub.add(' Currency excluded from usages list ');
5089: END IF;
5090:
5091: FETCH party_h_all_curr_csr_global
5092: INTO l_balance, l_currency_code;
5107: WHILE NOT party_h_all_curr_ret_csr_gl%NOTFOUND
5108: LOOP
5109: IF G_debug_flag = 'Y'
5110: THEN
5111: oe_debug_pub.add
5112: ( '(all) cursor at ' || l_currency_code
5113: || ' currency with balance '
5114: || l_balance || ' and bucket/length '
5115: || l_bucket || '/' || l_bucket_length, 2 );
5139: WHEN GL_CURRENCY_API.NO_RATE OR
5140: GL_CURRENCY_API.INVALID_CURRENCY
5141: THEN
5142:
5143: oe_debug_pub.add( 'conversion exception for '
5144: || l_currency_code, 1 );
5145: add_error_currency( x_error_curr_tbl, l_currency_code );
5146: END;
5147: ELSE
5144: || l_currency_code, 1 );
5145: add_error_currency( x_error_curr_tbl, l_currency_code );
5146: END;
5147: ELSE
5148: oe_debug_pub.add(' Currency excluded from usages list ');
5149: END IF;
5150:
5151: FETCH party_h_all_curr_ret_csr_gl
5152: INTO l_balance, l_currency_code;
5168:
5169:
5170: IF G_debug_flag = 'Y'
5171: THEN
5172: oe_debug_pub.add( ' -------------------------------------');
5173: oe_debug_pub.add( ' Final l_total ===> ' || l_total,1 );
5174: oe_debug_pub.add( ' Return out from retrieve_exposure ');
5175: END IF;
5176:
5169:
5170: IF G_debug_flag = 'Y'
5171: THEN
5172: oe_debug_pub.add( ' -------------------------------------');
5173: oe_debug_pub.add( ' Final l_total ===> ' || l_total,1 );
5174: oe_debug_pub.add( ' Return out from retrieve_exposure ');
5175: END IF;
5176:
5177: return NVL(l_total,0) ;
5170: IF G_debug_flag = 'Y'
5171: THEN
5172: oe_debug_pub.add( ' -------------------------------------');
5173: oe_debug_pub.add( ' Final l_total ===> ' || l_total,1 );
5174: oe_debug_pub.add( ' Return out from retrieve_exposure ');
5175: END IF;
5176:
5177: return NVL(l_total,0) ;
5178:
5178:
5179: EXCEPTION
5180:
5181: WHEN OTHERS THEN
5182: oe_debug_pub.add(SQLERRM );
5183:
5184: IF
5185: FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
5186: THEN
5320: BEGIN
5321:
5322: IF G_debug_flag = 'Y'
5323: THEN
5324: oe_debug_pub.add( 'In OEXVCRXB.Init_Summary_Table ', 1 );
5325: END IF;
5326:
5327: -----------
5328: -- Locks needed for periodic operation (no triggers/table handlers):
5376:
5377:
5378: IF G_debug_flag = 'Y'
5379: THEN
5380: oe_debug_pub.add( 'starting to lock tables', 2 );
5381: END IF;
5382:
5383: LOCK TABLE oe_order_lines_all IN EXCLUSIVE MODE;
5384: LOCK TABLE oe_order_headers_all IN EXCLUSIVE MODE;
5388: LOCK TABLE ar_cash_receipt_history_all IN EXCLUSIVE MODE;
5389:
5390: IF G_debug_flag = 'Y'
5391: THEN
5392: oe_debug_pub.add( 'locked tables', 2 );
5393: END IF;
5394: END IF;
5395:
5396:
5411: --before populating the credit exposure.
5412:
5413: IF G_debug_flag = 'Y'
5414: THEN
5415: oe_debug_pub.add( 'Value of the profile OM: Preserve External Credit Balances is :' || NVL(FND_PROFILE.VALUE('ONT_PRESERVE_EXT_CR_BAL'),'Y'),2);
5416: END IF;
5417:
5418: --8567481 start
5419: l_ret := FND_INSTALLATION.get_app_info('ONT',l_status,l_industry,l_ont_schema);
5445:
5446:
5447: IF G_debug_flag = 'Y'
5448: THEN
5449: oe_debug_pub.add( 'purged summary table at ' || DO_TIME, 2 );
5450: END IF;
5451:
5452: -- Bug 3960616 : Scan all PreCalc CC Rules to find required Balances.
5453: /*14689044 start
5486: when others then
5487: l_cc_level_flag:='Y';
5488: end;
5489:
5490: oe_debug_pub.add( 'Create Past Due Invoice Balance : '||l_past_due_bal);
5491: oe_debug_pub.add( 'Create Orders on Hold Balance : '||l_order_hold_bal);
5492: oe_debug_pub.add( 'Create Freight Charges Balance : '||l_freight_bal);
5493: oe_debug_pub.add( 'Credit Check Level Flag : '||l_cc_level_flag);
5494: 14689044 end*/
5487: l_cc_level_flag:='Y';
5488: end;
5489:
5490: oe_debug_pub.add( 'Create Past Due Invoice Balance : '||l_past_due_bal);
5491: oe_debug_pub.add( 'Create Orders on Hold Balance : '||l_order_hold_bal);
5492: oe_debug_pub.add( 'Create Freight Charges Balance : '||l_freight_bal);
5493: oe_debug_pub.add( 'Credit Check Level Flag : '||l_cc_level_flag);
5494: 14689044 end*/
5495:
5488: end;
5489:
5490: oe_debug_pub.add( 'Create Past Due Invoice Balance : '||l_past_due_bal);
5491: oe_debug_pub.add( 'Create Orders on Hold Balance : '||l_order_hold_bal);
5492: oe_debug_pub.add( 'Create Freight Charges Balance : '||l_freight_bal);
5493: oe_debug_pub.add( 'Credit Check Level Flag : '||l_cc_level_flag);
5494: 14689044 end*/
5495:
5496: --14689044 start
5489:
5490: oe_debug_pub.add( 'Create Past Due Invoice Balance : '||l_past_due_bal);
5491: oe_debug_pub.add( 'Create Orders on Hold Balance : '||l_order_hold_bal);
5492: oe_debug_pub.add( 'Create Freight Charges Balance : '||l_freight_bal);
5493: oe_debug_pub.add( 'Credit Check Level Flag : '||l_cc_level_flag);
5494: 14689044 end*/
5495:
5496: --14689044 start
5497: FOR p_credit_check_rule_rec in credit_check_rules
5675: END LOOP;
5676:
5677: IF G_debug_flag = 'Y'
5678: THEN
5679: oe_debug_pub.add('header_uninvoiced_orders:'||l_header_uninvoiced_orders);
5680: oe_debug_pub.add('line_uninvoiced_orders:'||l_line_uninvoiced_orders);
5681: oe_debug_pub.add('header_uninvoiced_orders_tax:'||l_header_uninvoiced_orders_tax);
5682: oe_debug_pub.add('line_uninvoiced_orders_tax:'||l_line_uninvoiced_orders_tax );
5683: oe_debug_pub.add('header_uninvoiced_freight:'||l_header_uninvoiced_freight);
5676:
5677: IF G_debug_flag = 'Y'
5678: THEN
5679: oe_debug_pub.add('header_uninvoiced_orders:'||l_header_uninvoiced_orders);
5680: oe_debug_pub.add('line_uninvoiced_orders:'||l_line_uninvoiced_orders);
5681: oe_debug_pub.add('header_uninvoiced_orders_tax:'||l_header_uninvoiced_orders_tax);
5682: oe_debug_pub.add('line_uninvoiced_orders_tax:'||l_line_uninvoiced_orders_tax );
5683: oe_debug_pub.add('header_uninvoiced_freight:'||l_header_uninvoiced_freight);
5684: oe_debug_pub.add('line_uninvoiced_freight:'||l_line_uninvoiced_freight);
5677: IF G_debug_flag = 'Y'
5678: THEN
5679: oe_debug_pub.add('header_uninvoiced_orders:'||l_header_uninvoiced_orders);
5680: oe_debug_pub.add('line_uninvoiced_orders:'||l_line_uninvoiced_orders);
5681: oe_debug_pub.add('header_uninvoiced_orders_tax:'||l_header_uninvoiced_orders_tax);
5682: oe_debug_pub.add('line_uninvoiced_orders_tax:'||l_line_uninvoiced_orders_tax );
5683: oe_debug_pub.add('header_uninvoiced_freight:'||l_header_uninvoiced_freight);
5684: oe_debug_pub.add('line_uninvoiced_freight:'||l_line_uninvoiced_freight);
5685: oe_debug_pub.add('header_and_line_freight:'||l_header_and_line_freight );
5678: THEN
5679: oe_debug_pub.add('header_uninvoiced_orders:'||l_header_uninvoiced_orders);
5680: oe_debug_pub.add('line_uninvoiced_orders:'||l_line_uninvoiced_orders);
5681: oe_debug_pub.add('header_uninvoiced_orders_tax:'||l_header_uninvoiced_orders_tax);
5682: oe_debug_pub.add('line_uninvoiced_orders_tax:'||l_line_uninvoiced_orders_tax );
5683: oe_debug_pub.add('header_uninvoiced_freight:'||l_header_uninvoiced_freight);
5684: oe_debug_pub.add('line_uninvoiced_freight:'||l_line_uninvoiced_freight);
5685: oe_debug_pub.add('header_and_line_freight:'||l_header_and_line_freight );
5686: oe_debug_pub.add('invoices:'||l_invoices);
5679: oe_debug_pub.add('header_uninvoiced_orders:'||l_header_uninvoiced_orders);
5680: oe_debug_pub.add('line_uninvoiced_orders:'||l_line_uninvoiced_orders);
5681: oe_debug_pub.add('header_uninvoiced_orders_tax:'||l_header_uninvoiced_orders_tax);
5682: oe_debug_pub.add('line_uninvoiced_orders_tax:'||l_line_uninvoiced_orders_tax );
5683: oe_debug_pub.add('header_uninvoiced_freight:'||l_header_uninvoiced_freight);
5684: oe_debug_pub.add('line_uninvoiced_freight:'||l_line_uninvoiced_freight);
5685: oe_debug_pub.add('header_and_line_freight:'||l_header_and_line_freight );
5686: oe_debug_pub.add('invoices:'||l_invoices);
5687: oe_debug_pub.add('payments_at_risk:'||l_payments_at_risk);
5680: oe_debug_pub.add('line_uninvoiced_orders:'||l_line_uninvoiced_orders);
5681: oe_debug_pub.add('header_uninvoiced_orders_tax:'||l_header_uninvoiced_orders_tax);
5682: oe_debug_pub.add('line_uninvoiced_orders_tax:'||l_line_uninvoiced_orders_tax );
5683: oe_debug_pub.add('header_uninvoiced_freight:'||l_header_uninvoiced_freight);
5684: oe_debug_pub.add('line_uninvoiced_freight:'||l_line_uninvoiced_freight);
5685: oe_debug_pub.add('header_and_line_freight:'||l_header_and_line_freight );
5686: oe_debug_pub.add('invoices:'||l_invoices);
5687: oe_debug_pub.add('payments_at_risk:'||l_payments_at_risk);
5688: oe_debug_pub.add('order_holds:'||l_order_holds);
5681: oe_debug_pub.add('header_uninvoiced_orders_tax:'||l_header_uninvoiced_orders_tax);
5682: oe_debug_pub.add('line_uninvoiced_orders_tax:'||l_line_uninvoiced_orders_tax );
5683: oe_debug_pub.add('header_uninvoiced_freight:'||l_header_uninvoiced_freight);
5684: oe_debug_pub.add('line_uninvoiced_freight:'||l_line_uninvoiced_freight);
5685: oe_debug_pub.add('header_and_line_freight:'||l_header_and_line_freight );
5686: oe_debug_pub.add('invoices:'||l_invoices);
5687: oe_debug_pub.add('payments_at_risk:'||l_payments_at_risk);
5688: oe_debug_pub.add('order_holds:'||l_order_holds);
5689: oe_debug_pub.add('line_holds:'||l_line_holds);
5682: oe_debug_pub.add('line_uninvoiced_orders_tax:'||l_line_uninvoiced_orders_tax );
5683: oe_debug_pub.add('header_uninvoiced_freight:'||l_header_uninvoiced_freight);
5684: oe_debug_pub.add('line_uninvoiced_freight:'||l_line_uninvoiced_freight);
5685: oe_debug_pub.add('header_and_line_freight:'||l_header_and_line_freight );
5686: oe_debug_pub.add('invoices:'||l_invoices);
5687: oe_debug_pub.add('payments_at_risk:'||l_payments_at_risk);
5688: oe_debug_pub.add('order_holds:'||l_order_holds);
5689: oe_debug_pub.add('line_holds:'||l_line_holds);
5690: oe_debug_pub.add('order_tax_holds:'||l_order_tax_holds);
5683: oe_debug_pub.add('header_uninvoiced_freight:'||l_header_uninvoiced_freight);
5684: oe_debug_pub.add('line_uninvoiced_freight:'||l_line_uninvoiced_freight);
5685: oe_debug_pub.add('header_and_line_freight:'||l_header_and_line_freight );
5686: oe_debug_pub.add('invoices:'||l_invoices);
5687: oe_debug_pub.add('payments_at_risk:'||l_payments_at_risk);
5688: oe_debug_pub.add('order_holds:'||l_order_holds);
5689: oe_debug_pub.add('line_holds:'||l_line_holds);
5690: oe_debug_pub.add('order_tax_holds:'||l_order_tax_holds);
5691: oe_debug_pub.add('line_tax_holds:'||l_line_tax_holds);
5684: oe_debug_pub.add('line_uninvoiced_freight:'||l_line_uninvoiced_freight);
5685: oe_debug_pub.add('header_and_line_freight:'||l_header_and_line_freight );
5686: oe_debug_pub.add('invoices:'||l_invoices);
5687: oe_debug_pub.add('payments_at_risk:'||l_payments_at_risk);
5688: oe_debug_pub.add('order_holds:'||l_order_holds);
5689: oe_debug_pub.add('line_holds:'||l_line_holds);
5690: oe_debug_pub.add('order_tax_holds:'||l_order_tax_holds);
5691: oe_debug_pub.add('line_tax_holds:'||l_line_tax_holds);
5692: oe_debug_pub.add('order_freight_holds:'||l_order_freight_holds);
5685: oe_debug_pub.add('header_and_line_freight:'||l_header_and_line_freight );
5686: oe_debug_pub.add('invoices:'||l_invoices);
5687: oe_debug_pub.add('payments_at_risk:'||l_payments_at_risk);
5688: oe_debug_pub.add('order_holds:'||l_order_holds);
5689: oe_debug_pub.add('line_holds:'||l_line_holds);
5690: oe_debug_pub.add('order_tax_holds:'||l_order_tax_holds);
5691: oe_debug_pub.add('line_tax_holds:'||l_line_tax_holds);
5692: oe_debug_pub.add('order_freight_holds:'||l_order_freight_holds);
5693: oe_debug_pub.add('line_freight_holds :'||l_line_freight_holds );
5686: oe_debug_pub.add('invoices:'||l_invoices);
5687: oe_debug_pub.add('payments_at_risk:'||l_payments_at_risk);
5688: oe_debug_pub.add('order_holds:'||l_order_holds);
5689: oe_debug_pub.add('line_holds:'||l_line_holds);
5690: oe_debug_pub.add('order_tax_holds:'||l_order_tax_holds);
5691: oe_debug_pub.add('line_tax_holds:'||l_line_tax_holds);
5692: oe_debug_pub.add('order_freight_holds:'||l_order_freight_holds);
5693: oe_debug_pub.add('line_freight_holds :'||l_line_freight_holds );
5694: oe_debug_pub.add('header_line_freight_holds :'||l_header_line_freight_holds );
5687: oe_debug_pub.add('payments_at_risk:'||l_payments_at_risk);
5688: oe_debug_pub.add('order_holds:'||l_order_holds);
5689: oe_debug_pub.add('line_holds:'||l_line_holds);
5690: oe_debug_pub.add('order_tax_holds:'||l_order_tax_holds);
5691: oe_debug_pub.add('line_tax_holds:'||l_line_tax_holds);
5692: oe_debug_pub.add('order_freight_holds:'||l_order_freight_holds);
5693: oe_debug_pub.add('line_freight_holds :'||l_line_freight_holds );
5694: oe_debug_pub.add('header_line_freight_holds :'||l_header_line_freight_holds );
5695: oe_debug_pub.add('external_exposure :'||l_external_exposure );
5688: oe_debug_pub.add('order_holds:'||l_order_holds);
5689: oe_debug_pub.add('line_holds:'||l_line_holds);
5690: oe_debug_pub.add('order_tax_holds:'||l_order_tax_holds);
5691: oe_debug_pub.add('line_tax_holds:'||l_line_tax_holds);
5692: oe_debug_pub.add('order_freight_holds:'||l_order_freight_holds);
5693: oe_debug_pub.add('line_freight_holds :'||l_line_freight_holds );
5694: oe_debug_pub.add('header_line_freight_holds :'||l_header_line_freight_holds );
5695: oe_debug_pub.add('external_exposure :'||l_external_exposure );
5696: oe_debug_pub.add('past_due_invoices :'||l_past_due_invoices );
5689: oe_debug_pub.add('line_holds:'||l_line_holds);
5690: oe_debug_pub.add('order_tax_holds:'||l_order_tax_holds);
5691: oe_debug_pub.add('line_tax_holds:'||l_line_tax_holds);
5692: oe_debug_pub.add('order_freight_holds:'||l_order_freight_holds);
5693: oe_debug_pub.add('line_freight_holds :'||l_line_freight_holds );
5694: oe_debug_pub.add('header_line_freight_holds :'||l_header_line_freight_holds );
5695: oe_debug_pub.add('external_exposure :'||l_external_exposure );
5696: oe_debug_pub.add('past_due_invoices :'||l_past_due_invoices );
5697: oe_debug_pub.add('br_invoices:'||l_br_invoices);
5690: oe_debug_pub.add('order_tax_holds:'||l_order_tax_holds);
5691: oe_debug_pub.add('line_tax_holds:'||l_line_tax_holds);
5692: oe_debug_pub.add('order_freight_holds:'||l_order_freight_holds);
5693: oe_debug_pub.add('line_freight_holds :'||l_line_freight_holds );
5694: oe_debug_pub.add('header_line_freight_holds :'||l_header_line_freight_holds );
5695: oe_debug_pub.add('external_exposure :'||l_external_exposure );
5696: oe_debug_pub.add('past_due_invoices :'||l_past_due_invoices );
5697: oe_debug_pub.add('br_invoices:'||l_br_invoices);
5698: oe_debug_pub.add('br_payments_at_risk:'||l_br_payments_at_risk);
5691: oe_debug_pub.add('line_tax_holds:'||l_line_tax_holds);
5692: oe_debug_pub.add('order_freight_holds:'||l_order_freight_holds);
5693: oe_debug_pub.add('line_freight_holds :'||l_line_freight_holds );
5694: oe_debug_pub.add('header_line_freight_holds :'||l_header_line_freight_holds );
5695: oe_debug_pub.add('external_exposure :'||l_external_exposure );
5696: oe_debug_pub.add('past_due_invoices :'||l_past_due_invoices );
5697: oe_debug_pub.add('br_invoices:'||l_br_invoices);
5698: oe_debug_pub.add('br_payments_at_risk:'||l_br_payments_at_risk);
5699: oe_debug_pub.add('head_return_uninv_orders:'||l_head_return_uninv_orders);
5692: oe_debug_pub.add('order_freight_holds:'||l_order_freight_holds);
5693: oe_debug_pub.add('line_freight_holds :'||l_line_freight_holds );
5694: oe_debug_pub.add('header_line_freight_holds :'||l_header_line_freight_holds );
5695: oe_debug_pub.add('external_exposure :'||l_external_exposure );
5696: oe_debug_pub.add('past_due_invoices :'||l_past_due_invoices );
5697: oe_debug_pub.add('br_invoices:'||l_br_invoices);
5698: oe_debug_pub.add('br_payments_at_risk:'||l_br_payments_at_risk);
5699: oe_debug_pub.add('head_return_uninv_orders:'||l_head_return_uninv_orders);
5700: oe_debug_pub.add('line_return_uninv_orders:'||l_line_return_uninv_orders);
5693: oe_debug_pub.add('line_freight_holds :'||l_line_freight_holds );
5694: oe_debug_pub.add('header_line_freight_holds :'||l_header_line_freight_holds );
5695: oe_debug_pub.add('external_exposure :'||l_external_exposure );
5696: oe_debug_pub.add('past_due_invoices :'||l_past_due_invoices );
5697: oe_debug_pub.add('br_invoices:'||l_br_invoices);
5698: oe_debug_pub.add('br_payments_at_risk:'||l_br_payments_at_risk);
5699: oe_debug_pub.add('head_return_uninv_orders:'||l_head_return_uninv_orders);
5700: oe_debug_pub.add('line_return_uninv_orders:'||l_line_return_uninv_orders);
5701: oe_debug_pub.add('head_return_uninv_ord_tax:'||l_head_return_uninv_ord_tax);
5694: oe_debug_pub.add('header_line_freight_holds :'||l_header_line_freight_holds );
5695: oe_debug_pub.add('external_exposure :'||l_external_exposure );
5696: oe_debug_pub.add('past_due_invoices :'||l_past_due_invoices );
5697: oe_debug_pub.add('br_invoices:'||l_br_invoices);
5698: oe_debug_pub.add('br_payments_at_risk:'||l_br_payments_at_risk);
5699: oe_debug_pub.add('head_return_uninv_orders:'||l_head_return_uninv_orders);
5700: oe_debug_pub.add('line_return_uninv_orders:'||l_line_return_uninv_orders);
5701: oe_debug_pub.add('head_return_uninv_ord_tax:'||l_head_return_uninv_ord_tax);
5702: oe_debug_pub.add('line_return_uninv_ord_tax:'||l_line_return_uninv_ord_tax);
5695: oe_debug_pub.add('external_exposure :'||l_external_exposure );
5696: oe_debug_pub.add('past_due_invoices :'||l_past_due_invoices );
5697: oe_debug_pub.add('br_invoices:'||l_br_invoices);
5698: oe_debug_pub.add('br_payments_at_risk:'||l_br_payments_at_risk);
5699: oe_debug_pub.add('head_return_uninv_orders:'||l_head_return_uninv_orders);
5700: oe_debug_pub.add('line_return_uninv_orders:'||l_line_return_uninv_orders);
5701: oe_debug_pub.add('head_return_uninv_ord_tax:'||l_head_return_uninv_ord_tax);
5702: oe_debug_pub.add('line_return_uninv_ord_tax:'||l_line_return_uninv_ord_tax);
5703: oe_debug_pub.add('head_return_uninv_freight:'||l_head_return_uninv_freight);
5696: oe_debug_pub.add('past_due_invoices :'||l_past_due_invoices );
5697: oe_debug_pub.add('br_invoices:'||l_br_invoices);
5698: oe_debug_pub.add('br_payments_at_risk:'||l_br_payments_at_risk);
5699: oe_debug_pub.add('head_return_uninv_orders:'||l_head_return_uninv_orders);
5700: oe_debug_pub.add('line_return_uninv_orders:'||l_line_return_uninv_orders);
5701: oe_debug_pub.add('head_return_uninv_ord_tax:'||l_head_return_uninv_ord_tax);
5702: oe_debug_pub.add('line_return_uninv_ord_tax:'||l_line_return_uninv_ord_tax);
5703: oe_debug_pub.add('head_return_uninv_freight:'||l_head_return_uninv_freight);
5704: oe_debug_pub.add('line_return_uninv_freight:'||l_line_return_uninv_freight);
5697: oe_debug_pub.add('br_invoices:'||l_br_invoices);
5698: oe_debug_pub.add('br_payments_at_risk:'||l_br_payments_at_risk);
5699: oe_debug_pub.add('head_return_uninv_orders:'||l_head_return_uninv_orders);
5700: oe_debug_pub.add('line_return_uninv_orders:'||l_line_return_uninv_orders);
5701: oe_debug_pub.add('head_return_uninv_ord_tax:'||l_head_return_uninv_ord_tax);
5702: oe_debug_pub.add('line_return_uninv_ord_tax:'||l_line_return_uninv_ord_tax);
5703: oe_debug_pub.add('head_return_uninv_freight:'||l_head_return_uninv_freight);
5704: oe_debug_pub.add('line_return_uninv_freight:'||l_line_return_uninv_freight);
5705: oe_debug_pub.add('head_line_return_freight :'||l_head_line_return_freight);
5698: oe_debug_pub.add('br_payments_at_risk:'||l_br_payments_at_risk);
5699: oe_debug_pub.add('head_return_uninv_orders:'||l_head_return_uninv_orders);
5700: oe_debug_pub.add('line_return_uninv_orders:'||l_line_return_uninv_orders);
5701: oe_debug_pub.add('head_return_uninv_ord_tax:'||l_head_return_uninv_ord_tax);
5702: oe_debug_pub.add('line_return_uninv_ord_tax:'||l_line_return_uninv_ord_tax);
5703: oe_debug_pub.add('head_return_uninv_freight:'||l_head_return_uninv_freight);
5704: oe_debug_pub.add('line_return_uninv_freight:'||l_line_return_uninv_freight);
5705: oe_debug_pub.add('head_line_return_freight :'||l_head_line_return_freight);
5706: oe_debug_pub.add('order_return_holds :'||l_order_return_holds);
5699: oe_debug_pub.add('head_return_uninv_orders:'||l_head_return_uninv_orders);
5700: oe_debug_pub.add('line_return_uninv_orders:'||l_line_return_uninv_orders);
5701: oe_debug_pub.add('head_return_uninv_ord_tax:'||l_head_return_uninv_ord_tax);
5702: oe_debug_pub.add('line_return_uninv_ord_tax:'||l_line_return_uninv_ord_tax);
5703: oe_debug_pub.add('head_return_uninv_freight:'||l_head_return_uninv_freight);
5704: oe_debug_pub.add('line_return_uninv_freight:'||l_line_return_uninv_freight);
5705: oe_debug_pub.add('head_line_return_freight :'||l_head_line_return_freight);
5706: oe_debug_pub.add('order_return_holds :'||l_order_return_holds);
5707: oe_debug_pub.add('line_return_holds:'||l_line_return_holds);
5700: oe_debug_pub.add('line_return_uninv_orders:'||l_line_return_uninv_orders);
5701: oe_debug_pub.add('head_return_uninv_ord_tax:'||l_head_return_uninv_ord_tax);
5702: oe_debug_pub.add('line_return_uninv_ord_tax:'||l_line_return_uninv_ord_tax);
5703: oe_debug_pub.add('head_return_uninv_freight:'||l_head_return_uninv_freight);
5704: oe_debug_pub.add('line_return_uninv_freight:'||l_line_return_uninv_freight);
5705: oe_debug_pub.add('head_line_return_freight :'||l_head_line_return_freight);
5706: oe_debug_pub.add('order_return_holds :'||l_order_return_holds);
5707: oe_debug_pub.add('line_return_holds:'||l_line_return_holds);
5708: oe_debug_pub.add('order_return_tax_holds:'||l_order_return_tax_holds);
5701: oe_debug_pub.add('head_return_uninv_ord_tax:'||l_head_return_uninv_ord_tax);
5702: oe_debug_pub.add('line_return_uninv_ord_tax:'||l_line_return_uninv_ord_tax);
5703: oe_debug_pub.add('head_return_uninv_freight:'||l_head_return_uninv_freight);
5704: oe_debug_pub.add('line_return_uninv_freight:'||l_line_return_uninv_freight);
5705: oe_debug_pub.add('head_line_return_freight :'||l_head_line_return_freight);
5706: oe_debug_pub.add('order_return_holds :'||l_order_return_holds);
5707: oe_debug_pub.add('line_return_holds:'||l_line_return_holds);
5708: oe_debug_pub.add('order_return_tax_holds:'||l_order_return_tax_holds);
5709: oe_debug_pub.add('line_return_tax_holds :'||l_line_return_tax_holds);
5702: oe_debug_pub.add('line_return_uninv_ord_tax:'||l_line_return_uninv_ord_tax);
5703: oe_debug_pub.add('head_return_uninv_freight:'||l_head_return_uninv_freight);
5704: oe_debug_pub.add('line_return_uninv_freight:'||l_line_return_uninv_freight);
5705: oe_debug_pub.add('head_line_return_freight :'||l_head_line_return_freight);
5706: oe_debug_pub.add('order_return_holds :'||l_order_return_holds);
5707: oe_debug_pub.add('line_return_holds:'||l_line_return_holds);
5708: oe_debug_pub.add('order_return_tax_holds:'||l_order_return_tax_holds);
5709: oe_debug_pub.add('line_return_tax_holds :'||l_line_return_tax_holds);
5710: oe_debug_pub.add('order_return_freight_holds:'||l_order_return_freight_holds);
5703: oe_debug_pub.add('head_return_uninv_freight:'||l_head_return_uninv_freight);
5704: oe_debug_pub.add('line_return_uninv_freight:'||l_line_return_uninv_freight);
5705: oe_debug_pub.add('head_line_return_freight :'||l_head_line_return_freight);
5706: oe_debug_pub.add('order_return_holds :'||l_order_return_holds);
5707: oe_debug_pub.add('line_return_holds:'||l_line_return_holds);
5708: oe_debug_pub.add('order_return_tax_holds:'||l_order_return_tax_holds);
5709: oe_debug_pub.add('line_return_tax_holds :'||l_line_return_tax_holds);
5710: oe_debug_pub.add('order_return_freight_holds:'||l_order_return_freight_holds);
5711: oe_debug_pub.add('line_return_freight_holds:'||l_line_return_freight_holds);
5704: oe_debug_pub.add('line_return_uninv_freight:'||l_line_return_uninv_freight);
5705: oe_debug_pub.add('head_line_return_freight :'||l_head_line_return_freight);
5706: oe_debug_pub.add('order_return_holds :'||l_order_return_holds);
5707: oe_debug_pub.add('line_return_holds:'||l_line_return_holds);
5708: oe_debug_pub.add('order_return_tax_holds:'||l_order_return_tax_holds);
5709: oe_debug_pub.add('line_return_tax_holds :'||l_line_return_tax_holds);
5710: oe_debug_pub.add('order_return_freight_holds:'||l_order_return_freight_holds);
5711: oe_debug_pub.add('line_return_freight_holds:'||l_line_return_freight_holds);
5712: oe_debug_pub.add('h_l_return_freight_holds :'||l_h_l_return_freight_holds );
5705: oe_debug_pub.add('head_line_return_freight :'||l_head_line_return_freight);
5706: oe_debug_pub.add('order_return_holds :'||l_order_return_holds);
5707: oe_debug_pub.add('line_return_holds:'||l_line_return_holds);
5708: oe_debug_pub.add('order_return_tax_holds:'||l_order_return_tax_holds);
5709: oe_debug_pub.add('line_return_tax_holds :'||l_line_return_tax_holds);
5710: oe_debug_pub.add('order_return_freight_holds:'||l_order_return_freight_holds);
5711: oe_debug_pub.add('line_return_freight_holds:'||l_line_return_freight_holds);
5712: oe_debug_pub.add('h_l_return_freight_holds :'||l_h_l_return_freight_holds );
5713: END IF;
5706: oe_debug_pub.add('order_return_holds :'||l_order_return_holds);
5707: oe_debug_pub.add('line_return_holds:'||l_line_return_holds);
5708: oe_debug_pub.add('order_return_tax_holds:'||l_order_return_tax_holds);
5709: oe_debug_pub.add('line_return_tax_holds :'||l_line_return_tax_holds);
5710: oe_debug_pub.add('order_return_freight_holds:'||l_order_return_freight_holds);
5711: oe_debug_pub.add('line_return_freight_holds:'||l_line_return_freight_holds);
5712: oe_debug_pub.add('h_l_return_freight_holds :'||l_h_l_return_freight_holds );
5713: END IF;
5714: --14689044 end
5707: oe_debug_pub.add('line_return_holds:'||l_line_return_holds);
5708: oe_debug_pub.add('order_return_tax_holds:'||l_order_return_tax_holds);
5709: oe_debug_pub.add('line_return_tax_holds :'||l_line_return_tax_holds);
5710: oe_debug_pub.add('order_return_freight_holds:'||l_order_return_freight_holds);
5711: oe_debug_pub.add('line_return_freight_holds:'||l_line_return_freight_holds);
5712: oe_debug_pub.add('h_l_return_freight_holds :'||l_h_l_return_freight_holds );
5713: END IF;
5714: --14689044 end
5715:
5708: oe_debug_pub.add('order_return_tax_holds:'||l_order_return_tax_holds);
5709: oe_debug_pub.add('line_return_tax_holds :'||l_line_return_tax_holds);
5710: oe_debug_pub.add('order_return_freight_holds:'||l_order_return_freight_holds);
5711: oe_debug_pub.add('line_return_freight_holds:'||l_line_return_freight_holds);
5712: oe_debug_pub.add('h_l_return_freight_holds :'||l_h_l_return_freight_holds );
5713: END IF;
5714: --14689044 end
5715:
5716:
5930: -- header bill-to-site level
5931:
5932: IF G_debug_flag = 'Y'
5933: THEN
5934: oe_debug_pub.add( 'Start Inserting into summary tables ',1);
5935: END IF;
5936: --14689044 IF l_cc_level_flag='Y' THEN
5937: IF l_header_uninvoiced_orders ='Y' THEN --14689044
5938: -- balance type 1
6003:
6004:
6005: IF G_debug_flag = 'Y'
6006: THEN
6007: oe_debug_pub.add( 'G_HEADER_UNINVOICED_ORDERS done at ' || DO_TIME, 2);
6008: END IF;
6009: END IF; -- l_cc_level_flag
6010:
6011: --14689044 IF l_cc_level_flag='Y' THEN
6072:
6073:
6074: IF G_debug_flag = 'Y'
6075: THEN
6076: oe_debug_pub.add( 'G_HEADER_UNINVOICED_ORDERS_TAX done at ' || DO_TIME, 2);
6077: END IF;
6078: END IF; -- l_cc_level_flag
6079: ----------------------------------------------
6080: ---------- RETURNS ---------------------------
6146:
6147:
6148: IF G_debug_flag = 'Y'
6149: THEN
6150: oe_debug_pub.add( 'G_HEAD_RETURN_UNINV_ORDERS done at ' || DO_TIME, 2);
6151: END IF;
6152: END IF; -- l_cc_level_flag
6153:
6154: --14689044 IF l_cc_level_flag='Y' THEN
6209: , m.order_org_id;
6210:
6211: IF G_debug_flag = 'Y'
6212: THEN
6213: oe_debug_pub.add( 'G_HEAD_RETURN_UNINV_ORD_TAX done at ' || DO_TIME, 2);
6214: END IF;
6215: END IF; -- l_cc_level_flag
6216:
6217: --------------------------
6289:
6290:
6291: IF G_debug_flag = 'Y'
6292: THEN
6293: oe_debug_pub.add( 'G_LINE_UNINVOICED_ORDERS done at ' || DO_TIME, 2);
6294: END IF;
6295: END IF; --14689044
6296: -- balance type 4
6297: IF l_line_uninvoiced_orders_tax ='Y' THEN --14689044
6356:
6357:
6358: IF G_debug_flag = 'Y'
6359: THEN
6360: oe_debug_pub.add( 'G_LINE_UNINVOICED_ORDERS_TAX done at ' || DO_TIME, 2);
6361: END IF;
6362: END IF; --14689044
6363:
6364: ----------------------------------
6434:
6435:
6436: IF G_debug_flag = 'Y'
6437: THEN
6438: oe_debug_pub.add( 'G_LINE_RETURN_UNINV_ORDERS done at ' || DO_TIME, 2);
6439: END IF;
6440:
6441: END IF; --14689044
6442: -- balance type 26
6499:
6500:
6501: IF G_debug_flag = 'Y'
6502: THEN
6503: oe_debug_pub.add( 'G_LINE_RETURN_UNINV_ORD_TAX done at ' || DO_TIME, 2);
6504: END IF;
6505:
6506: END IF; --14689044
6507: -- Bug 4219133 : Insert Freight Balances only if Freight Charges to be Included
6584:
6585:
6586: IF G_debug_flag = 'Y'
6587: THEN
6588: oe_debug_pub.add( 'G_LINE_UNINVOICED_FREIGHT done at ' || DO_TIME, 2);
6589: END IF;
6590:
6591: --TaxER Start
6592: IF l_tax = 'Y' THEN --14689044
6663:
6664:
6665: IF G_debug_flag = 'Y'
6666: THEN
6667: oe_debug_pub.add( 'G_LINE_UNINVOICED_FREIGHT_T done at ' || DO_TIME, 2);
6668: END IF;
6669: END IF; --14689044
6670: --TaxER End
6671: END IF; -- l_freight_bal
6746:
6747:
6748: IF G_debug_flag = 'Y'
6749: THEN
6750: oe_debug_pub.add( 'G_LINE_RETURN_UNINV_FREIGHT done at ' || DO_TIME, 2);
6751: END IF;
6752:
6753:
6754: --TaxER Start
6822: END IF; --14689044
6823:
6824: IF G_debug_flag = 'Y'
6825: THEN
6826: oe_debug_pub.add( 'G_LINE_RETURN_UNINV_FREIGHT_T done at ' || DO_TIME, 2);
6827: END IF;
6828: --TaxER End
6829: END IF; --14689044
6830: -- Bug 4219133 : Insert Freight Balances only if Freight Charges to be Included.
6908: NVL( m.order_request_date, m.order_creation_date) ) ), 'J' ) );
6909:
6910: IF G_debug_flag = 'Y'
6911: THEN
6912: oe_debug_pub.add( 'G_HEADER_UNINVOICED_FREIGHT done at ' || DO_TIME, 2 );
6913: END IF;
6914:
6915:
6916: --TaxER start
6989: END IF; --14689044
6990:
6991: IF G_debug_flag = 'Y'
6992: THEN
6993: oe_debug_pub.add( 'G_HEADER_UNINVOICED_FREIGHT_T done at ' || DO_TIME, 2 );
6994: END IF;
6995: --14689044 END IF; -- l_cc_level_flag
6996: END IF; -- l_freight_bal
6997:
7070:
7071:
7072: IF G_debug_flag = 'Y'
7073: THEN
7074: oe_debug_pub.add( 'G_HEAD_RETURN_UNINV_FREIGHT done at ' || DO_TIME, 2 );
7075: END IF;
7076:
7077: --TaxER Start
7078: IF l_tax = 'Y' THEN --14689044
7144:
7145:
7146: IF G_debug_flag = 'Y'
7147: THEN
7148: oe_debug_pub.add( 'G_HEAD_RETURN_UNINV_FREIGHT_T done at ' || DO_TIME, 2 );
7149: END IF;
7150: END IF; --14689044
7151: --TaxER End
7152:
7314:
7315:
7316: IF G_debug_flag = 'Y'
7317: THEN
7318: oe_debug_pub.add( 'G_HEADER_AND_LINE_FREIGHT done at ' || DO_TIME, 2 );
7319: END IF;
7320:
7321: --TaxER Start
7322: IF l_tax = 'Y' THEN --14689044
7473:
7474:
7475: IF G_debug_flag = 'Y'
7476: THEN
7477: oe_debug_pub.add( 'G_HEADER_AND_LINE_FREIGHT_T done at ' || DO_TIME, 2 );
7478: END IF;
7479: END IF; --14689044
7480: --TaxER End
7481:
7638: ;
7639:
7640: IF G_debug_flag = 'Y'
7641: THEN
7642: oe_debug_pub.add( 'G_HEAD_LINE_RETURN_FREIGHT done at ' || DO_TIME, 2 );
7643: END IF;
7644:
7645: --TaxER Start
7646: IF l_tax = 'Y' THEN --14689044
7795: --TaxER End
7796:
7797: IF G_debug_flag = 'Y'
7798: THEN
7799: oe_debug_pub.add( 'G_HEAD_LINE_RETURN_FREIGHT_T done at ' || DO_TIME, 2 );
7800: END IF;
7801: END IF; --14689044
7802: --------------------------
7803: -- Holds
7895:
7896:
7897: IF G_debug_flag = 'Y'
7898: THEN
7899: oe_debug_pub.add( 'G_ORDER_HOLDS done at ' || DO_TIME, 2 );
7900: END IF;
7901: END IF; -- l_cc_level_flag
7902:
7903: --14689044 IF l_cc_level_flag='Y' THEN
7974:
7975:
7976: IF G_debug_flag = 'Y'
7977: THEN
7978: oe_debug_pub.add( 'G_ORDER_TAX_HOLDS done at ' || DO_TIME, 2 );
7979: END IF;
7980: END IF; -- l_cc_level_flag
7981: --14689044 END IF; -- IF l_order_hold_bal
7982:
8093:
8094:
8095: IF G_debug_flag = 'Y'
8096: THEN
8097: oe_debug_pub.add( 'G_ORDER_RETURN_HOLDS done at ' || DO_TIME, 2 );
8098: END IF;
8099: END IF; -- l_cc_level_flag
8100:
8101: --14689044 IF l_cc_level_flag='Y' THEN
8168:
8169:
8170: IF G_debug_flag = 'Y'
8171: THEN
8172: oe_debug_pub.add( 'G_ORDER_RETURN_TAX_HOLDS done at ' || DO_TIME, 2 );
8173: END IF;
8174: END IF; -- l_cc_level_flag
8175:
8176: --14689044 IF l_order_hold_bal = 'Y' THEN
8259:
8260:
8261: IF G_debug_flag = 'Y'
8262: THEN
8263: oe_debug_pub.add( 'G_LINE_HOLDS done at ' || DO_TIME, 2 );
8264: END IF;
8265:
8266: END IF; --14689044
8267: -- balance type 14
8338:
8339:
8340: IF G_debug_flag = 'Y'
8341: THEN
8342: oe_debug_pub.add( 'G_LINE_TAX_HOLDS done at ' || DO_TIME, 2 );
8343: END IF;
8344: END IF; -- IF l_order_hold_bal
8345:
8346: --------------------------------
8424:
8425:
8426: IF G_debug_flag = 'Y'
8427: THEN
8428: oe_debug_pub.add( 'G_LINE_RETURN_HOLDS done at ' || DO_TIME, 2 );
8429: END IF;
8430:
8431: END IF; --14689044
8432: -- balance type 33
8498: ;
8499:
8500: IF G_debug_flag = 'Y'
8501: THEN
8502: oe_debug_pub.add( 'G_LINE_RETURN_TAX_HOLDS done at ' || DO_TIME, 2 );
8503: END IF;
8504:
8505: END IF; --14689044
8506:
8594:
8595:
8596: IF G_debug_flag = 'Y'
8597: THEN
8598: oe_debug_pub.add( 'G_LINE_FREIGHT_HOLDS done at ' || DO_TIME, 2 );
8599: END IF;
8600:
8601: --TaxER Start
8602: IF l_tax = 'Y' THEN --14689044
8683:
8684:
8685: IF G_debug_flag = 'Y'
8686: THEN
8687: oe_debug_pub.add( 'G_LINE_FREIGHT_HOLDS_T done at ' || DO_TIME, 2 );
8688: END IF;
8689: END IF; --14689044
8690: --TaxER End
8691: END IF; -- IF l_order_hold_bal
8775:
8776:
8777: IF G_debug_flag = 'Y'
8778: THEN
8779: oe_debug_pub.add( 'G_LINE_RETURN_FREIGHT_HOLDS done at ' || DO_TIME, 2 );
8780: END IF;
8781:
8782: --TaxER Start
8783: IF l_tax = 'Y' THEN --14689044
8859:
8860:
8861: IF G_debug_flag = 'Y'
8862: THEN
8863: oe_debug_pub.add( 'G_LINE_RETURN_FREIGHT_HOLDS_T done at ' || DO_TIME, 2 );
8864: END IF;
8865: END IF; --14689044
8866: --TaxER End
8867:
8956:
8957:
8958: IF G_debug_flag = 'Y'
8959: THEN
8960: oe_debug_pub.add( 'G_ORDER_FREIGHT_HOLDS done at ' || DO_TIME, 2 );
8961: END IF;
8962:
8963: --TaxER Start
8964: IF l_tax = 'Y' THEN --14689044
9045:
9046:
9047: IF G_debug_flag = 'Y'
9048: THEN
9049: oe_debug_pub.add( 'G_ORDER_FREIGHT_HOLDS_T done at ' || DO_TIME, 2 );
9050: END IF;
9051: END IF; --14689044
9052: --TaxER End
9053:
9137: ;
9138:
9139: IF G_debug_flag = 'Y'
9140: THEN
9141: oe_debug_pub.add( 'G_ORDER_RETURN_FREIGHT_HOLDS done at ' || DO_TIME, 2 );
9142: END IF;
9143:
9144: --TaxER Start
9145: IF l_tax = 'Y' THEN --14689044
9222: --TaxER End
9223:
9224: IF G_debug_flag = 'Y'
9225: THEN
9226: oe_debug_pub.add( 'G_ORDER_RETURN_FREIGHT_HOLDS_T done at ' || DO_TIME, 2 );
9227: END IF;
9228: END IF; -- l_cc_level_flag
9229:
9230: --14689044 IF l_order_hold_bal = 'Y' THEN
9325: ;
9326:
9327: IF G_debug_flag = 'Y'
9328: THEN
9329: oe_debug_pub.add( 'G_HEADER_LINE_FREIGHT_HOLDS done at ' || DO_TIME, 2 );
9330: END IF;
9331:
9332: --TaxER Start
9333: IF l_tax = 'Y' THEN --14689044
9422: ;
9423:
9424: IF G_debug_flag = 'Y'
9425: THEN
9426: oe_debug_pub.add( 'G_HEADER_LINE_FREIGHT_HOLDS_T done at ' || DO_TIME, 2 );
9427: END IF;
9428: END IF; --14689044
9429: --TaxER End
9430:
9527: ;
9528:
9529: IF G_debug_flag = 'Y'
9530: THEN
9531: oe_debug_pub.add( 'G_H_L_RETURN_FREIGHT_HOLDS done at ' || DO_TIME, 2 );
9532: END IF;
9533:
9534: --TaxER Start
9535: IF l_tax = 'Y' THEN --14689044
9623: ;
9624:
9625: IF G_debug_flag = 'Y'
9626: THEN
9627: oe_debug_pub.add( 'G_H_L_RETURN_FREIGHT_HOLDS_T done at ' || DO_TIME, 2 );
9628: END IF;
9629: END IF; --14689044
9630: --TaxER End
9631:
9704:
9705:
9706: IF G_debug_flag = 'Y'
9707: THEN
9708: oe_debug_pub.add( 'G_INVOICES done at ' || DO_TIME, 2 );
9709: END IF;
9710:
9711: END IF; --14689044
9712:
9804: ;
9805:
9806: IF G_debug_flag = 'Y'
9807: THEN
9808: oe_debug_pub.add( 'G_PAYMENTS_AT_RISK done at ' || DO_TIME, 2 );
9809: END IF;
9810:
9811: END IF; --14689044
9812: ---------------------- BR ------------------
9879:
9880:
9881: IF G_debug_flag = 'Y'
9882: THEN
9883: oe_debug_pub.add( 'G_BR_INVOICES done at ' || DO_TIME, 2 );
9884: END IF;
9885:
9886: END IF; --14689044
9887: -----------------------------------------
9978: ;
9979:
9980: IF G_debug_flag = 'Y'
9981: THEN
9982: oe_debug_pub.add( 'G_PAYMENTS_AT_RISK done at ' || DO_TIME, 2 );
9983: END IF;
9984:
9985: END IF; --14689044
9986:
10053: ;
10054:
10055: IF G_debug_flag = 'Y'
10056: THEN
10057: oe_debug_pub.add( 'past due invt ' || DO_TIME, 2 );
10058: END IF;
10059:
10060: END IF; -- IF l_past_due_bal
10061:
10060: END IF; -- IF l_past_due_bal
10061:
10062: IF G_debug_flag = 'Y'
10063: THEN
10064: oe_debug_pub.add( ' End of first phase ');
10065: END IF;
10066:
10067:
10068: ----------------------
10088: END IF;
10089:
10090: IF G_debug_flag = 'Y'
10091: THEN
10092: oe_debug_pub.add( 'level 0 records updated at ' || DO_TIME, 2 );
10093: END IF;
10094:
10095: l_level := 1;
10096: l_bucket_length := POWER( 2, l_level );
10182: ;
10183:
10184: IF G_debug_flag = 'Y'
10185: THEN
10186: oe_debug_pub.add( 'level ' || l_level || ' records done at '||DO_TIME, 2 );
10187: END IF;
10188:
10189: l_level := l_level + 1;
10190: l_bucket_length := POWER( 2, l_level );
10254: ;
10255:
10256: IF G_debug_flag = 'Y'
10257: THEN
10258: oe_debug_pub.add( 'level ' || l_level || ' records done at '||DO_TIME, 2 );
10259: END IF;
10260:
10261: l_level := l_level + 1;
10262: l_bucket_length := POWER( 2, l_level );
10264: --14689044 8567481 end */
10265:
10266: IF G_debug_flag = 'Y'
10267: THEN
10268: oe_debug_pub.add( ' Done Inserting into summary table, about to COMMIT');
10269: END IF;
10270:
10271: COMMIT;
10272:
10273: x_retcode := 0;
10274:
10275: IF G_debug_flag = 'Y'
10276: THEN
10277: oe_debug_pub.add( ' after COMMIT command');
10278: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Init_Summary_Table ', 1 );
10279: END IF;
10280:
10281: EXCEPTION
10274:
10275: IF G_debug_flag = 'Y'
10276: THEN
10277: oe_debug_pub.add( ' after COMMIT command');
10278: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Init_Summary_Table ', 1 );
10279: END IF;
10280:
10281: EXCEPTION
10282:
10378:
10379:
10380: IF G_debug_flag = 'Y'
10381: THEN
10382: oe_debug_pub.add( 'IN OEXVCRXB.OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10383: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++++++++++');
10384: oe_debug_pub.add( 'p_customer_id : ' || p_customer_id, 2 );
10385: oe_debug_pub.add( 'p_site_use_id : ' || p_site_use_id, 2 );
10386: oe_debug_pub.add( 'p_party_id : '|| p_party_id ,2);
10379:
10380: IF G_debug_flag = 'Y'
10381: THEN
10382: oe_debug_pub.add( 'IN OEXVCRXB.OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10383: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++++++++++');
10384: oe_debug_pub.add( 'p_customer_id : ' || p_customer_id, 2 );
10385: oe_debug_pub.add( 'p_site_use_id : ' || p_site_use_id, 2 );
10386: oe_debug_pub.add( 'p_party_id : '|| p_party_id ,2);
10387: oe_debug_pub.add( 'p_header_id : ' || p_header_id, 2 );
10380: IF G_debug_flag = 'Y'
10381: THEN
10382: oe_debug_pub.add( 'IN OEXVCRXB.OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10383: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++++++++++');
10384: oe_debug_pub.add( 'p_customer_id : ' || p_customer_id, 2 );
10385: oe_debug_pub.add( 'p_site_use_id : ' || p_site_use_id, 2 );
10386: oe_debug_pub.add( 'p_party_id : '|| p_party_id ,2);
10387: oe_debug_pub.add( 'p_header_id : ' || p_header_id, 2 );
10388: oe_debug_pub.add( 'g_use_party_hierarchy : '|| g_use_party_hierarchy );
10381: THEN
10382: oe_debug_pub.add( 'IN OEXVCRXB.OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10383: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++++++++++');
10384: oe_debug_pub.add( 'p_customer_id : ' || p_customer_id, 2 );
10385: oe_debug_pub.add( 'p_site_use_id : ' || p_site_use_id, 2 );
10386: oe_debug_pub.add( 'p_party_id : '|| p_party_id ,2);
10387: oe_debug_pub.add( 'p_header_id : ' || p_header_id, 2 );
10388: oe_debug_pub.add( 'g_use_party_hierarchy : '|| g_use_party_hierarchy );
10389: oe_debug_pub.add( ' p_include_all_flag => '||
10382: oe_debug_pub.add( 'IN OEXVCRXB.OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10383: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++++++++++');
10384: oe_debug_pub.add( 'p_customer_id : ' || p_customer_id, 2 );
10385: oe_debug_pub.add( 'p_site_use_id : ' || p_site_use_id, 2 );
10386: oe_debug_pub.add( 'p_party_id : '|| p_party_id ,2);
10387: oe_debug_pub.add( 'p_header_id : ' || p_header_id, 2 );
10388: oe_debug_pub.add( 'g_use_party_hierarchy : '|| g_use_party_hierarchy );
10389: oe_debug_pub.add( ' p_include_all_flag => '||
10390: p_include_all_flag );
10383: oe_debug_pub.add( '+++++++++++++++++++++++++++++++++++++++++++');
10384: oe_debug_pub.add( 'p_customer_id : ' || p_customer_id, 2 );
10385: oe_debug_pub.add( 'p_site_use_id : ' || p_site_use_id, 2 );
10386: oe_debug_pub.add( 'p_party_id : '|| p_party_id ,2);
10387: oe_debug_pub.add( 'p_header_id : ' || p_header_id, 2 );
10388: oe_debug_pub.add( 'g_use_party_hierarchy : '|| g_use_party_hierarchy );
10389: oe_debug_pub.add( ' p_include_all_flag => '||
10390: p_include_all_flag );
10391: oe_debug_pub.add(' p_global_exposure_flag => '||
10384: oe_debug_pub.add( 'p_customer_id : ' || p_customer_id, 2 );
10385: oe_debug_pub.add( 'p_site_use_id : ' || p_site_use_id, 2 );
10386: oe_debug_pub.add( 'p_party_id : '|| p_party_id ,2);
10387: oe_debug_pub.add( 'p_header_id : ' || p_header_id, 2 );
10388: oe_debug_pub.add( 'g_use_party_hierarchy : '|| g_use_party_hierarchy );
10389: oe_debug_pub.add( ' p_include_all_flag => '||
10390: p_include_all_flag );
10391: oe_debug_pub.add(' p_global_exposure_flag => '||
10392: p_global_exposure_flag );
10385: oe_debug_pub.add( 'p_site_use_id : ' || p_site_use_id, 2 );
10386: oe_debug_pub.add( 'p_party_id : '|| p_party_id ,2);
10387: oe_debug_pub.add( 'p_header_id : ' || p_header_id, 2 );
10388: oe_debug_pub.add( 'g_use_party_hierarchy : '|| g_use_party_hierarchy );
10389: oe_debug_pub.add( ' p_include_all_flag => '||
10390: p_include_all_flag );
10391: oe_debug_pub.add(' p_global_exposure_flag => '||
10392: p_global_exposure_flag );
10393: oe_debug_pub.add(' p_need_exposure_details => '||
10387: oe_debug_pub.add( 'p_header_id : ' || p_header_id, 2 );
10388: oe_debug_pub.add( 'g_use_party_hierarchy : '|| g_use_party_hierarchy );
10389: oe_debug_pub.add( ' p_include_all_flag => '||
10390: p_include_all_flag );
10391: oe_debug_pub.add(' p_global_exposure_flag => '||
10392: p_global_exposure_flag );
10393: oe_debug_pub.add(' p_need_exposure_details => '||
10394: p_need_exposure_details );
10395: oe_debug_pub.add
10389: oe_debug_pub.add( ' p_include_all_flag => '||
10390: p_include_all_flag );
10391: oe_debug_pub.add(' p_global_exposure_flag => '||
10392: p_global_exposure_flag );
10393: oe_debug_pub.add(' p_need_exposure_details => '||
10394: p_need_exposure_details );
10395: oe_debug_pub.add
10396: ( 'p_credit_check_rule_rec.credit_check_rule_id: '
10397: || p_credit_check_rule_rec.credit_check_rule_id, 2 );
10391: oe_debug_pub.add(' p_global_exposure_flag => '||
10392: p_global_exposure_flag );
10393: oe_debug_pub.add(' p_need_exposure_details => '||
10394: p_need_exposure_details );
10395: oe_debug_pub.add
10396: ( 'p_credit_check_rule_rec.credit_check_rule_id: '
10397: || p_credit_check_rule_rec.credit_check_rule_id, 2 );
10398: oe_debug_pub.add
10399: ( 'p_credit_check_rule_rec.name: '
10394: p_need_exposure_details );
10395: oe_debug_pub.add
10396: ( 'p_credit_check_rule_rec.credit_check_rule_id: '
10397: || p_credit_check_rule_rec.credit_check_rule_id, 2 );
10398: oe_debug_pub.add
10399: ( 'p_credit_check_rule_rec.name: '
10400: || p_credit_check_rule_rec.name, 2 );
10401: oe_debug_pub.add
10402: ( 'p_credit_check_rule_rec.failure_result_code: '
10397: || p_credit_check_rule_rec.credit_check_rule_id, 2 );
10398: oe_debug_pub.add
10399: ( 'p_credit_check_rule_rec.name: '
10400: || p_credit_check_rule_rec.name, 2 );
10401: oe_debug_pub.add
10402: ( 'p_credit_check_rule_rec.failure_result_code: '
10403: || p_credit_check_rule_rec.failure_result_code, 2 );
10404: oe_debug_pub.add
10405: ( 'p_credit_check_rule_rec.open_ar_balance_flag : '
10400: || p_credit_check_rule_rec.name, 2 );
10401: oe_debug_pub.add
10402: ( 'p_credit_check_rule_rec.failure_result_code: '
10403: || p_credit_check_rule_rec.failure_result_code, 2 );
10404: oe_debug_pub.add
10405: ( 'p_credit_check_rule_rec.open_ar_balance_flag : '
10406: || p_credit_check_rule_rec.open_ar_balance_flag, 2 );
10407: oe_debug_pub.add
10408: ( 'p_credit_check_rule_rec.uninvoiced_orders_flag : '
10403: || p_credit_check_rule_rec.failure_result_code, 2 );
10404: oe_debug_pub.add
10405: ( 'p_credit_check_rule_rec.open_ar_balance_flag : '
10406: || p_credit_check_rule_rec.open_ar_balance_flag, 2 );
10407: oe_debug_pub.add
10408: ( 'p_credit_check_rule_rec.uninvoiced_orders_flag : '
10409: || p_credit_check_rule_rec.uninvoiced_orders_flag, 2 );
10410: oe_debug_pub.add
10411: ( 'p_credit_check_rule_rec.orders_on_hold_flag : '
10406: || p_credit_check_rule_rec.open_ar_balance_flag, 2 );
10407: oe_debug_pub.add
10408: ( 'p_credit_check_rule_rec.uninvoiced_orders_flag : '
10409: || p_credit_check_rule_rec.uninvoiced_orders_flag, 2 );
10410: oe_debug_pub.add
10411: ( 'p_credit_check_rule_rec.orders_on_hold_flag : '
10412: || p_credit_check_rule_rec.orders_on_hold_flag, 2 );
10413: oe_debug_pub.add
10414: ( 'p_credit_check_rule_rec.shipping_interval : '
10409: || p_credit_check_rule_rec.uninvoiced_orders_flag, 2 );
10410: oe_debug_pub.add
10411: ( 'p_credit_check_rule_rec.orders_on_hold_flag : '
10412: || p_credit_check_rule_rec.orders_on_hold_flag, 2 );
10413: oe_debug_pub.add
10414: ( 'p_credit_check_rule_rec.shipping_interval : '
10415: || p_credit_check_rule_rec.shipping_interval, 2 );
10416: oe_debug_pub.add
10417: ( 'p_credit_check_rule_rec.open_ar_days : '
10412: || p_credit_check_rule_rec.orders_on_hold_flag, 2 );
10413: oe_debug_pub.add
10414: ( 'p_credit_check_rule_rec.shipping_interval : '
10415: || p_credit_check_rule_rec.shipping_interval, 2 );
10416: oe_debug_pub.add
10417: ( 'p_credit_check_rule_rec.open_ar_days : '
10418: || p_credit_check_rule_rec.open_ar_days, 2 );
10419: oe_debug_pub.add
10420: ( 'p_credit_check_rule_rec.start_date_active : '
10415: || p_credit_check_rule_rec.shipping_interval, 2 );
10416: oe_debug_pub.add
10417: ( 'p_credit_check_rule_rec.open_ar_days : '
10418: || p_credit_check_rule_rec.open_ar_days, 2 );
10419: oe_debug_pub.add
10420: ( 'p_credit_check_rule_rec.start_date_active : '
10421: || p_credit_check_rule_rec.start_date_active, 2 );
10422: oe_debug_pub.add
10423: ( 'p_credit_check_rule_rec.end_date_active : '
10418: || p_credit_check_rule_rec.open_ar_days, 2 );
10419: oe_debug_pub.add
10420: ( 'p_credit_check_rule_rec.start_date_active : '
10421: || p_credit_check_rule_rec.start_date_active, 2 );
10422: oe_debug_pub.add
10423: ( 'p_credit_check_rule_rec.end_date_active : '
10424: || p_credit_check_rule_rec.end_date_active, 2 );
10425: oe_debug_pub.add
10426: ( 'p_credit_check_rule_rec.include_payments_at_risk_flag : '
10421: || p_credit_check_rule_rec.start_date_active, 2 );
10422: oe_debug_pub.add
10423: ( 'p_credit_check_rule_rec.end_date_active : '
10424: || p_credit_check_rule_rec.end_date_active, 2 );
10425: oe_debug_pub.add
10426: ( 'p_credit_check_rule_rec.include_payments_at_risk_flag : '
10427: || p_credit_check_rule_rec.include_payments_at_risk_flag, 2 );
10428: oe_debug_pub.add
10429: ( 'p_credit_check_rule_rec.include_tax_flag : '
10424: || p_credit_check_rule_rec.end_date_active, 2 );
10425: oe_debug_pub.add
10426: ( 'p_credit_check_rule_rec.include_payments_at_risk_flag : '
10427: || p_credit_check_rule_rec.include_payments_at_risk_flag, 2 );
10428: oe_debug_pub.add
10429: ( 'p_credit_check_rule_rec.include_tax_flag : '
10430: || p_credit_check_rule_rec.include_tax_flag, 2 );
10431: oe_debug_pub.add
10432: ( 'p_credit_check_rule_rec.maximum_days_past_due : '
10427: || p_credit_check_rule_rec.include_payments_at_risk_flag, 2 );
10428: oe_debug_pub.add
10429: ( 'p_credit_check_rule_rec.include_tax_flag : '
10430: || p_credit_check_rule_rec.include_tax_flag, 2 );
10431: oe_debug_pub.add
10432: ( 'p_credit_check_rule_rec.maximum_days_past_due : '
10433: || p_credit_check_rule_rec.maximum_days_past_due, 2 );
10434: oe_debug_pub.add
10435: ( 'p_credit_check_rule_rec.QUICK_CR_CHECK_FLAG : '
10430: || p_credit_check_rule_rec.include_tax_flag, 2 );
10431: oe_debug_pub.add
10432: ( 'p_credit_check_rule_rec.maximum_days_past_due : '
10433: || p_credit_check_rule_rec.maximum_days_past_due, 2 );
10434: oe_debug_pub.add
10435: ( 'p_credit_check_rule_rec.QUICK_CR_CHECK_FLAG : '
10436: || p_credit_check_rule_rec.QUICK_CR_CHECK_FLAG, 2 );
10437: oe_debug_pub.add
10438: ( 'p_credit_check_rule_rec.incl_freight_charges_flag : '
10433: || p_credit_check_rule_rec.maximum_days_past_due, 2 );
10434: oe_debug_pub.add
10435: ( 'p_credit_check_rule_rec.QUICK_CR_CHECK_FLAG : '
10436: || p_credit_check_rule_rec.QUICK_CR_CHECK_FLAG, 2 );
10437: oe_debug_pub.add
10438: ( 'p_credit_check_rule_rec.incl_freight_charges_flag : '
10439: || p_credit_check_rule_rec.incl_freight_charges_flag, 2 );
10440: oe_debug_pub.add
10441: ( 'p_credit_check_rule_rec.shipping_horizon : '
10436: || p_credit_check_rule_rec.QUICK_CR_CHECK_FLAG, 2 );
10437: oe_debug_pub.add
10438: ( 'p_credit_check_rule_rec.incl_freight_charges_flag : '
10439: || p_credit_check_rule_rec.incl_freight_charges_flag, 2 );
10440: oe_debug_pub.add
10441: ( 'p_credit_check_rule_rec.shipping_horizon : '
10442: || p_credit_check_rule_rec.shipping_horizon, 2 );
10443: oe_debug_pub.add
10444: ( 'p_credit_check_rule_rec.include_external_exposure_flag : '
10439: || p_credit_check_rule_rec.incl_freight_charges_flag, 2 );
10440: oe_debug_pub.add
10441: ( 'p_credit_check_rule_rec.shipping_horizon : '
10442: || p_credit_check_rule_rec.shipping_horizon, 2 );
10443: oe_debug_pub.add
10444: ( 'p_credit_check_rule_rec.include_external_exposure_flag : '
10445: || p_credit_check_rule_rec.include_external_exposure_flag, 2 );
10446: oe_debug_pub.add
10447: ( 'p_credit_check_rule_rec.include_returns_flag : '
10442: || p_credit_check_rule_rec.shipping_horizon, 2 );
10443: oe_debug_pub.add
10444: ( 'p_credit_check_rule_rec.include_external_exposure_flag : '
10445: || p_credit_check_rule_rec.include_external_exposure_flag, 2 );
10446: oe_debug_pub.add
10447: ( 'p_credit_check_rule_rec.include_returns_flag : '
10448: || p_credit_check_rule_rec.include_returns_flag, 2 );
10449: oe_debug_pub.add
10450: ( 'p_system_parameters_rec.org_id : '
10445: || p_credit_check_rule_rec.include_external_exposure_flag, 2 );
10446: oe_debug_pub.add
10447: ( 'p_credit_check_rule_rec.include_returns_flag : '
10448: || p_credit_check_rule_rec.include_returns_flag, 2 );
10449: oe_debug_pub.add
10450: ( 'p_system_parameters_rec.org_id : '
10451: || p_system_parameters_rec.org_id, 2 );
10452: oe_debug_pub.add
10453: ( 'p_system_parameters_rec.master_organization_id : '
10448: || p_credit_check_rule_rec.include_returns_flag, 2 );
10449: oe_debug_pub.add
10450: ( 'p_system_parameters_rec.org_id : '
10451: || p_system_parameters_rec.org_id, 2 );
10452: oe_debug_pub.add
10453: ( 'p_system_parameters_rec.master_organization_id : '
10454: || p_system_parameters_rec.master_organization_id, 2 );
10455: oe_debug_pub.add( 'p_limit_curr_code: ' || p_limit_curr_code, 2 );
10456: oe_debug_pub.add( 'p_include_all_flag: ' || p_include_all_flag, 2 );
10451: || p_system_parameters_rec.org_id, 2 );
10452: oe_debug_pub.add
10453: ( 'p_system_parameters_rec.master_organization_id : '
10454: || p_system_parameters_rec.master_organization_id, 2 );
10455: oe_debug_pub.add( 'p_limit_curr_code: ' || p_limit_curr_code, 2 );
10456: oe_debug_pub.add( 'p_include_all_flag: ' || p_include_all_flag, 2 );
10457: oe_debug_pub.add( 'p_global_exposure_flag = '|| p_global_exposure_flag );
10458:
10459: END IF;
10452: oe_debug_pub.add
10453: ( 'p_system_parameters_rec.master_organization_id : '
10454: || p_system_parameters_rec.master_organization_id, 2 );
10455: oe_debug_pub.add( 'p_limit_curr_code: ' || p_limit_curr_code, 2 );
10456: oe_debug_pub.add( 'p_include_all_flag: ' || p_include_all_flag, 2 );
10457: oe_debug_pub.add( 'p_global_exposure_flag = '|| p_global_exposure_flag );
10458:
10459: END IF;
10460:
10453: ( 'p_system_parameters_rec.master_organization_id : '
10454: || p_system_parameters_rec.master_organization_id, 2 );
10455: oe_debug_pub.add( 'p_limit_curr_code: ' || p_limit_curr_code, 2 );
10456: oe_debug_pub.add( 'p_include_all_flag: ' || p_include_all_flag, 2 );
10457: oe_debug_pub.add( 'p_global_exposure_flag = '|| p_global_exposure_flag );
10458:
10459: END IF;
10460:
10461: ------------------------------------------------------------------
10476:
10477:
10478: IF G_debug_flag = 'Y'
10479: THEN
10480: oe_debug_pub.add( 'final g_use_party_hierarchy ==> '||
10481: g_use_party_hierarchy );
10482: END IF;
10483: ------------------------------------------------------------------
10484:
10486:
10487: WHILE i IS NOT NULL LOOP
10488: IF G_debug_flag = 'Y'
10489: THEN
10490: oe_debug_pub.add( 'usage curr: '
10491: || p_usage_curr_tbl(i).usage_curr_code, 2 );
10492: END IF;
10493: i := p_usage_curr_tbl.NEXT(i);
10494: END LOOP;
10526: THEN
10527: -- Order Management Summaries
10528: IF G_debug_flag = 'Y'
10529: THEN
10530: oe_debug_pub.add(' OM Balances ');
10531: oe_debug_pub.add(' call balance_types_om ');
10532: END IF;
10533:
10534: balance_types_om( p_credit_check_rule_rec );
10527: -- Order Management Summaries
10528: IF G_debug_flag = 'Y'
10529: THEN
10530: oe_debug_pub.add(' OM Balances ');
10531: oe_debug_pub.add(' call balance_types_om ');
10532: END IF;
10533:
10534: balance_types_om( p_credit_check_rule_rec );
10535:
10551: AND p_credit_check_rule_rec.shipping_interval IS NULL
10552: THEN
10553: IF G_debug_flag = 'Y'
10554: THEN
10555: oe_debug_pub.add(' Call balance_types_om_and_ar ');
10556: END IF;
10557:
10558: balance_types_om_and_ar( p_credit_check_rule_rec );
10559:
10561:
10562: ELSE
10563: IF G_debug_flag = 'Y'
10564: THEN
10565: oe_debug_pub.add(' Select OM and AR exposure separately ');
10566: END IF;
10567: END IF;
10568:
10569: IF G_debug_flag = 'Y'
10567: END IF;
10568:
10569: IF G_debug_flag = 'Y'
10570: THEN
10571: oe_debug_pub.add(' l_both_exposure ==> '|| l_both_exposure );
10572: oe_debug_pub.add(' Call retrieve_exposure ');
10573: END IF;
10574:
10575: l_total := l_total + retrieve_exposure
10568:
10569: IF G_debug_flag = 'Y'
10570: THEN
10571: oe_debug_pub.add(' l_both_exposure ==> '|| l_both_exposure );
10572: oe_debug_pub.add(' Call retrieve_exposure ');
10573: END IF;
10574:
10575: l_total := l_total + retrieve_exposure
10576: ( p_binary_tbl => l_binary_tbl
10588: );
10589:
10590: IF G_debug_flag = 'Y'
10591: THEN
10592: oe_debug_pub.add(' Out of Retreive exposure with total ==> '
10593: || l_total );
10594: END IF;
10595:
10596: ---------------------------------
10599: IF l_both_exposure = 'N'
10600: THEN
10601: IF G_debug_flag = 'Y'
10602: THEN
10603: oe_debug_pub.add(' AR exposure ');
10604: oe_debug_pub.add(' Call balance_types_ar ');
10605: END IF;
10606:
10607: balance_types_ar( p_credit_check_rule_rec );
10600: THEN
10601: IF G_debug_flag = 'Y'
10602: THEN
10603: oe_debug_pub.add(' AR exposure ');
10604: oe_debug_pub.add(' Call balance_types_ar ');
10605: END IF;
10606:
10607: balance_types_ar( p_credit_check_rule_rec );
10608:
10613: , l_main_bucket
10614: , l_binary_tbl
10615: );
10616:
10617: oe_debug_pub.add(' Call retrieve_exposure for AR balance ');
10618:
10619: l_total := l_total + retrieve_exposure
10620: ( p_binary_tbl => l_binary_tbl
10621: , p_site_use_id => p_site_use_id
10632: );
10633:
10634: IF G_debug_flag = 'Y'
10635: THEN
10636: oe_debug_pub.add(' out of AR retrieve_exposure ==> '||
10637: l_total );
10638: END IF;
10639:
10640: ELSE
10639:
10640: ELSE
10641: IF G_debug_flag = 'Y'
10642: THEN
10643: oe_debug_pub.add(' NO need for AR expe as both exp calculated = '
10644: || l_both_exposure );
10645: END IF;
10646: END IF;
10647:
10651:
10652: ------------------------------ support detail exposure ------------
10653: IF G_debug_flag = 'Y'
10654: THEN
10655: oe_debug_pub.add(' support detail exposure ',1);
10656: END IF;
10657:
10658: balance_types_om_hold( p_credit_check_rule_rec );
10659:
10680: );
10681:
10682: IF G_debug_flag = 'Y'
10683: THEN
10684: oe_debug_pub.add(' x_order_hold_amount => '||
10685: x_order_hold_amount );
10686:
10687: oe_debug_pub.add(' x_order_amount => '|| x_order_amount );
10688:
10683: THEN
10684: oe_debug_pub.add(' x_order_hold_amount => '||
10685: x_order_hold_amount );
10686:
10687: oe_debug_pub.add(' x_order_amount => '|| x_order_amount );
10688:
10689: oe_debug_pub.add(' x_ar_amount ' || x_ar_amount );
10690: END IF;
10691: --------------------------------------------------------
10685: x_order_hold_amount );
10686:
10687: oe_debug_pub.add(' x_order_amount => '|| x_order_amount );
10688:
10689: oe_debug_pub.add(' x_ar_amount ' || x_ar_amount );
10690: END IF;
10691: --------------------------------------------------------
10692: balance_types_om_nohold ( p_credit_check_rule_rec );
10693:
10714: );
10715:
10716: IF G_debug_flag = 'Y'
10717: THEN
10718: oe_debug_pub.add(' x_order_amount => '|| x_order_amount );
10719: oe_debug_pub.add(' AR exposure ');
10720: oe_debug_pub.add(' Call balance_types_ar ');
10721: END IF;
10722:
10715:
10716: IF G_debug_flag = 'Y'
10717: THEN
10718: oe_debug_pub.add(' x_order_amount => '|| x_order_amount );
10719: oe_debug_pub.add(' AR exposure ');
10720: oe_debug_pub.add(' Call balance_types_ar ');
10721: END IF;
10722:
10723: balance_types_ar( p_credit_check_rule_rec );
10716: IF G_debug_flag = 'Y'
10717: THEN
10718: oe_debug_pub.add(' x_order_amount => '|| x_order_amount );
10719: oe_debug_pub.add(' AR exposure ');
10720: oe_debug_pub.add(' Call balance_types_ar ');
10721: END IF;
10722:
10723: balance_types_ar( p_credit_check_rule_rec );
10724:
10729: , l_main_bucket
10730: , l_binary_tbl
10731: );
10732:
10733: oe_debug_pub.add(' Call retrieve_exposure for AR balance ');
10734:
10735: x_ar_amount := retrieve_exposure
10736: ( p_binary_tbl => l_binary_tbl
10737: , p_site_use_id => p_site_use_id
10748: );
10749:
10750: IF G_debug_flag = 'Y'
10751: THEN
10752: oe_debug_pub.add(' out of AR retrieve_exposure ==> '||
10753: x_ar_amount );
10754: END IF;
10755:
10756: --bug# 5597791
10755:
10756: --bug# 5597791
10757: IF G_debug_flag = 'Y'
10758: THEN
10759: oe_debug_pub.add(' x_order_hold_amount => '||
10760: x_order_hold_amount );
10761:
10762: oe_debug_pub.add(' x_order_amount => '|| x_order_amount );
10763:
10758: THEN
10759: oe_debug_pub.add(' x_order_hold_amount => '||
10760: x_order_hold_amount );
10761:
10762: oe_debug_pub.add(' x_order_amount => '|| x_order_amount );
10763:
10764: oe_debug_pub.add(' x_ar_amount ' || x_ar_amount );
10765: END IF;
10766:
10760: x_order_hold_amount );
10761:
10762: oe_debug_pub.add(' x_order_amount => '|| x_order_amount );
10763:
10764: oe_debug_pub.add(' x_ar_amount ' || x_ar_amount );
10765: END IF;
10766:
10767: x_total_exposure := nvl(x_order_hold_amount,0) + nvl(x_order_amount,0) + nvl(x_ar_amount,0);
10768:
10772: x_return_status := FND_API.G_RET_STS_SUCCESS;
10773:
10774: IF G_debug_flag = 'Y'
10775: THEN
10776: oe_debug_pub.add(' ');
10777: oe_debug_pub.add(' Total FINAL exposure ==> '|| x_total_exposure,1 );
10778: oe_debug_pub.add(' ');
10779: oe_debug_pub.add('*************************************************');
10780: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10773:
10774: IF G_debug_flag = 'Y'
10775: THEN
10776: oe_debug_pub.add(' ');
10777: oe_debug_pub.add(' Total FINAL exposure ==> '|| x_total_exposure,1 );
10778: oe_debug_pub.add(' ');
10779: oe_debug_pub.add('*************************************************');
10780: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10781: END IF;
10774: IF G_debug_flag = 'Y'
10775: THEN
10776: oe_debug_pub.add(' ');
10777: oe_debug_pub.add(' Total FINAL exposure ==> '|| x_total_exposure,1 );
10778: oe_debug_pub.add(' ');
10779: oe_debug_pub.add('*************************************************');
10780: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10781: END IF;
10782:
10775: THEN
10776: oe_debug_pub.add(' ');
10777: oe_debug_pub.add(' Total FINAL exposure ==> '|| x_total_exposure,1 );
10778: oe_debug_pub.add(' ');
10779: oe_debug_pub.add('*************************************************');
10780: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10781: END IF;
10782:
10783:
10776: oe_debug_pub.add(' ');
10777: oe_debug_pub.add(' Total FINAL exposure ==> '|| x_total_exposure,1 );
10778: oe_debug_pub.add(' ');
10779: oe_debug_pub.add('*************************************************');
10780: oe_debug_pub.add( 'Exiting OE_CREDIT_EXPOSURE_PVT.Get_Exposure', 1 );
10781: END IF;
10782:
10783:
10784: l_total := 0;
10792: x_return_status := FND_API.G_RET_STS_ERROR;
10793:
10794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10796: oe_debug_pub.add(SQLERRM );
10797:
10798: WHEN OTHERS THEN
10799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10800: oe_debug_pub.add(SQLERRM );
10796: oe_debug_pub.add(SQLERRM );
10797:
10798: WHEN OTHERS THEN
10799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
10800: oe_debug_pub.add(SQLERRM );
10801: IF
10802: FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
10803: THEN
10804: -- FND_MSG_PUB.Add_Exc_Msg( l_api_name, 'Get_Exposure' );