eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_EXCESS_PARTS_PVT dependencies on FND_LOG

Line 562: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

558: v_excess_part.INVENTORY_ITEM_ID := l_item_id;
559: v_excess_part.EXCESS_QUANTITY := NVL(inv_rec.TOT_AVAIL_QTY,0) - NVL(inv_rec.SUPPLY_QTY,0) - NVL(inv_rec.MAX_QTY,0);
560: v_excess_part.EXCESS_STATUS := 'P';
561:
562: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
564: 'csp.plsql.CSP_EXCESS_PARTS_PVT.excess_parts',
565: 'Calling populate_excess_list 1');
566: end if;

Line 563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

559: v_excess_part.EXCESS_QUANTITY := NVL(inv_rec.TOT_AVAIL_QTY,0) - NVL(inv_rec.SUPPLY_QTY,0) - NVL(inv_rec.MAX_QTY,0);
560: v_excess_part.EXCESS_STATUS := 'P';
561:
562: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
564: 'csp.plsql.CSP_EXCESS_PARTS_PVT.excess_parts',
565: 'Calling populate_excess_list 1');
566: end if;
567:

Line 682: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

678: v_excess_part.INVENTORY_ITEM_ID := coi.inventory_item_id;
679: v_excess_part.EXCESS_QUANTITY := l_excess;
680: v_excess_part.EXCESS_STATUS := 'P';
681:
682: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
684: 'csp.plsql.CSP_EXCESS_PARTS_PVT.excess_parts',
685: 'Calling populate_excess_list 2');
686: end if;

Line 683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

679: v_excess_part.EXCESS_QUANTITY := l_excess;
680: v_excess_part.EXCESS_STATUS := 'P';
681:
682: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
684: 'csp.plsql.CSP_EXCESS_PARTS_PVT.excess_parts',
685: 'Calling populate_excess_list 2');
686: end if;
687:

Line 795: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

791: v_excess_part.INVENTORY_ITEM_ID := csin.inventory_item_id;
792: v_excess_part.EXCESS_QUANTITY := l_excess;
793: v_excess_part.EXCESS_STATUS := 'P';
794:
795: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
796: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
797: 'csp.plsql.CSP_EXCESS_PARTS_PVT.excess_parts',
798: 'Calling populate_excess_list 3');
799: end if;

Line 796: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

792: v_excess_part.EXCESS_QUANTITY := l_excess;
793: v_excess_part.EXCESS_STATUS := 'P';
794:
795: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
796: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
797: 'csp.plsql.CSP_EXCESS_PARTS_PVT.excess_parts',
798: 'Calling populate_excess_list 3');
799: end if;
800:

Line 1209: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1205: v_excess_part.INVENTORY_ITEM_ID := d.inventory_item_id;
1206: v_excess_part.EXCESS_QUANTITY := d.excess_quantity;
1207: v_excess_part.EXCESS_STATUS := 'O';
1208:
1209: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1211: 'csp.plsql.CSP_EXCESS_PARTS_PVT.excess_parts',
1212: 'Calling populate_excess_list 4');
1213: end if;

Line 1210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1206: v_excess_part.EXCESS_QUANTITY := d.excess_quantity;
1207: v_excess_part.EXCESS_STATUS := 'O';
1208:
1209: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1211: 'csp.plsql.CSP_EXCESS_PARTS_PVT.excess_parts',
1212: 'Calling populate_excess_list 4');
1213: end if;
1214:

Line 2024: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2020: FROM csp_return_routing_rules
2021: WHERE rule_id = v_return_rule_id;
2022: BEGIN
2023:
2024: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2025: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2026: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2027: 'Begin...');
2028: end if;

Line 2025: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2021: WHERE rule_id = v_return_rule_id;
2022: BEGIN
2023:
2024: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2025: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2026: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2027: 'Begin...');
2028: end if;
2029:

Line 2034: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2030: IF p_excess_part.ORGANIZATION_ID IS NOT NULL THEN
2031:
2032: -- set default return information
2033:
2034: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2036: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2037: 'Fetching return information from c_get_return_info');
2038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2031:
2032: -- set default return information
2033:
2034: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2036: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2037: 'Fetching return information from c_get_return_info');
2038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2039: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',

Line 2038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2034: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2035: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2036: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2037: 'Fetching return information from c_get_return_info');
2038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2039: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2040: 'p_excess_part.ORGANIZATION_ID = '
2041: || p_excess_part.ORGANIZATION_ID);
2042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2038: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2039: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2040: 'p_excess_part.ORGANIZATION_ID = '
2041: || p_excess_part.ORGANIZATION_ID);
2042: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2043: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2044: 'p_excess_part.SUBINVENTORY_CODE = '
2045: || p_excess_part.SUBINVENTORY_CODE);
2046: end if;

Line 2053: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2049: p_excess_part.SUBINVENTORY_CODE);
2050: FETCH c_get_return_info INTO v_ret_org_id, v_ret_sub_inv;
2051: CLOSE c_get_return_info;
2052:
2053: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2055: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2056: 'Return information from c_get_return_info');
2057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2050: FETCH c_get_return_info INTO v_ret_org_id, v_ret_sub_inv;
2051: CLOSE c_get_return_info;
2052:
2053: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2055: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2056: 'Return information from c_get_return_info');
2057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2058: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',

Line 2057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2053: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2055: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2056: 'Return information from c_get_return_info');
2057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2058: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2059: 'v_ret_org_id = ' || v_ret_org_id);
2060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2061: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',

Line 2060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2056: 'Return information from c_get_return_info');
2057: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2058: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2059: 'v_ret_org_id = ' || v_ret_org_id);
2060: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2061: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2062: 'v_ret_sub_inv = ' || v_ret_sub_inv);
2063: end if;
2064:

Line 2075: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2071: -- After populating Destination Based on the Setup at
2072: -- Resource Addresses and Subinventort form, we will override it
2073: -- if we found any return routing rule for the given inputs
2074:
2075: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2077: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2078: 'Calling find_best_routing_rule....');
2079: end if;

Line 2076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2072: -- Resource Addresses and Subinventort form, we will override it
2073: -- if we found any return routing rule for the given inputs
2074:
2075: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2077: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2078: 'Calling find_best_routing_rule....');
2079: end if;
2080:

Line 2102: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2098: , x_msg_count => x_msg_count
2099: , x_msg_data => x_msg_data
2100: );
2101:
2102: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2104: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2105: 'returned from find_best_routing_rule with x_return_status = ' || x_return_status
2106: || ' and v_return_rule_id = ' || v_return_rule_id);

Line 2103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2099: , x_msg_data => x_msg_data
2100: );
2101:
2102: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2104: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2105: 'returned from find_best_routing_rule with x_return_status = ' || x_return_status
2106: || ' and v_return_rule_id = ' || v_return_rule_id);
2107: end if;

Line 2114: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2110: open get_rule_destination;
2111: fetch get_rule_destination into v_rule_dest_org_id, v_rule_dest_subinv;
2112: close get_rule_destination;
2113:
2114: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2115: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2116: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2117: 'Destination for rule is: v_rule_dest_org_id=' || v_rule_dest_org_id
2118: || ', v_rule_dest_subinv=' || v_rule_dest_subinv);

Line 2115: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2111: fetch get_rule_destination into v_rule_dest_org_id, v_rule_dest_subinv;
2112: close get_rule_destination;
2113:
2114: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2115: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2116: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2117: 'Destination for rule is: v_rule_dest_org_id=' || v_rule_dest_org_id
2118: || ', v_rule_dest_subinv=' || v_rule_dest_subinv);
2119: end if;

Line 2127: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2123: v_excess_part.RETURN_SUBINVENTORY_NAME := v_rule_dest_subinv;
2124: end if;
2125: end if;
2126:
2127: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2128: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2129: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2130: 'Calling custom code...CSP_EXCESS_PARTS_CUST.excess_parts');
2131: end if;

Line 2128: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2124: end if;
2125: end if;
2126:
2127: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2128: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2129: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2130: 'Calling custom code...CSP_EXCESS_PARTS_CUST.excess_parts');
2131: end if;
2132:

Line 2135: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2131: end if;
2132:
2133: v_excess_records := CSP_EXCESS_PARTS_CUST.excess_parts(v_excess_part);
2134:
2135: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2137: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2138: 'Got v_excess_records with count = ' || v_excess_records.count);
2139: end if;

Line 2136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2132:
2133: v_excess_records := CSP_EXCESS_PARTS_CUST.excess_parts(v_excess_part);
2134:
2135: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2137: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2138: 'Got v_excess_records with count = ' || v_excess_records.count);
2139: end if;
2140:

Line 2144: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2140:
2141: FOR i IN 1..v_excess_records.count LOOP
2142: v_excess_part := v_excess_records(i);
2143:
2144: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2146: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2147: 'p_is_insert_record = ' || p_is_insert_record);
2148: end if;

Line 2145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2141: FOR i IN 1..v_excess_records.count LOOP
2142: v_excess_part := v_excess_records(i);
2143:
2144: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2146: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2147: 'p_is_insert_record = ' || p_is_insert_record);
2148: end if;
2149:

Line 2152: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2148: end if;
2149:
2150: if nvl(p_is_insert_record, 'N') = 'Y' then
2151:
2152: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2153: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2154: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2155: 'Calling csp_excess_lists_pkg.Insert_Row for i = ' || i);
2156: end if;

Line 2153: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2149:
2150: if nvl(p_is_insert_record, 'N') = 'Y' then
2151:
2152: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2153: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2154: 'csp.plsql.CSP_EXCESS_PARTS_PVT.populate_excess_list',
2155: 'Calling csp_excess_lists_pkg.Insert_Row for i = ' || i);
2156: end if;
2157:

Line 2482: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2478: BEGIN
2479:
2480: x_return_status := 'S';
2481:
2482: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2484: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2485: 'Begin...');
2486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 2483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2479:
2480: x_return_status := 'S';
2481:
2482: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2484: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2485: 'Begin...');
2486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2487: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',

Line 2486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2482: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2484: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2485: 'Begin...');
2486: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2487: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2488: 'p_source_type=' || p_source_type
2489: || ', p_source_org_id=' || p_source_org_id
2490: || ', p_source_subinv=' || p_source_subinv

Line 2494: end if; -- End of FND Logger If block

2490: || ', p_source_subinv=' || p_source_subinv
2491: || ', p_source_terr_id=' || p_source_terr_id
2492: || ', p_ret_trans_type=' || p_ret_trans_type
2493: || ', p_item_id=' || p_item_id);
2494: end if; -- End of FND Logger If block
2495:
2496: v_match_rule_id := null;
2497: v_match_rule_weight := null;
2498:

Line 2513: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2509: -- then find out the territory id for this source
2510: -- and then search for Internal Territory type
2511: -- rules for this territory source
2512:
2513: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2515: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2516: 'v_match_rule_id=' || v_match_rule_id
2517: || ', v_match_rule_weight=' || v_match_rule_weight);

Line 2514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2510: -- and then search for Internal Territory type
2511: -- rules for this territory source
2512:
2513: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2515: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2516: 'v_match_rule_id=' || v_match_rule_id
2517: || ', v_match_rule_weight=' || v_match_rule_weight);
2518: end if; -- End of FND Logger If block

Line 2518: end if; -- End of FND Logger If block

2514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2515: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2516: 'v_match_rule_id=' || v_match_rule_id
2517: || ', v_match_rule_weight=' || v_match_rule_weight);
2518: end if; -- End of FND Logger If block
2519:
2520: if v_match_rule_id is null then
2521: open c_Source_Org_Type(p_source_org_id, p_source_subinv);
2522: fetch c_Source_Org_Type into l_Source_Org_Type;

Line 2525: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2521: open c_Source_Org_Type(p_source_org_id, p_source_subinv);
2522: fetch c_Source_Org_Type into l_Source_Org_Type;
2523: close c_Source_Org_Type;
2524:
2525: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2526: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2527: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2528: 'l_Source_Org_Type=' || l_Source_Org_Type);
2529: end if; -- End of FND Logger If block

Line 2526: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2522: fetch c_Source_Org_Type into l_Source_Org_Type;
2523: close c_Source_Org_Type;
2524:
2525: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2526: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2527: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2528: 'l_Source_Org_Type=' || l_Source_Org_Type);
2529: end if; -- End of FND Logger If block
2530:

Line 2529: end if; -- End of FND Logger If block

2525: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2526: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2527: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2528: 'l_Source_Org_Type=' || l_Source_Org_Type);
2529: end if; -- End of FND Logger If block
2530:
2531: if l_Source_Org_Type = 'TECHNICIAN' then
2532:
2533: open c_get_tech_add(p_source_org_id, p_source_subinv);

Line 2557: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2553: l_county,
2554: l_country;
2555: close c_get_ware_hz_loc;
2556:
2557: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2558: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2559: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2560: 'l_hz_location_id=' || l_hz_location_id);
2561: end if; -- End of FND Logger If block

Line 2558: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2554: l_country;
2555: close c_get_ware_hz_loc;
2556:
2557: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2558: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2559: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2560: 'l_hz_location_id=' || l_hz_location_id);
2561: end if; -- End of FND Logger If block
2562:

Line 2561: end if; -- End of FND Logger If block

2557: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2558: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2559: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2560: 'l_hz_location_id=' || l_hz_location_id);
2561: end if; -- End of FND Logger If block
2562:
2563: -- no hz_location_id found? then check for hr_location
2564: if l_hz_location_id is null then
2565:

Line 2579: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2575: end if; -- end of if l_hz_location_id is null
2576:
2577: end if; -- end if if l_Source_Org_Type = 'TECHNICIAN'
2578:
2579: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2580: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2581: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2582: 'l_city=' || l_city
2583: || ', l_postal_code=' || l_postal_code

Line 2580: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2576:
2577: end if; -- end if if l_Source_Org_Type = 'TECHNICIAN'
2578:
2579: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2580: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2581: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2582: 'l_city=' || l_city
2583: || ', l_postal_code=' || l_postal_code
2584: || ', l_state=' || l_state

Line 2588: end if; -- End of FND Logger If block

2584: || ', l_state=' || l_state
2585: || ', l_province=' || l_province
2586: || ', l_county=' || l_county
2587: || ', l_country=' || l_country);
2588: end if; -- End of FND Logger If block
2589:
2590: if l_country is not null then
2591:
2592: -- so, we have geographycal data now

Line 2603: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2599: l_sr_rec.PROVINCE := l_province;
2600: l_sr_rec.COUNTY := l_county;
2601: l_sr_rec.COUNTRY := l_country;
2602:
2603: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2604: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2605: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2606: 'Calling JTY_TERR_SPARES_PVT.process_match_terr_spares ...');
2607: end if; -- End of FND Logger If block

Line 2604: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2600: l_sr_rec.COUNTY := l_county;
2601: l_sr_rec.COUNTRY := l_country;
2602:
2603: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2604: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2605: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2606: 'Calling JTY_TERR_SPARES_PVT.process_match_terr_spares ...');
2607: end if; -- End of FND Logger If block
2608:

Line 2607: end if; -- End of FND Logger If block

2603: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2604: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2605: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2606: 'Calling JTY_TERR_SPARES_PVT.process_match_terr_spares ...');
2607: end if; -- End of FND Logger If block
2608:
2609: JTY_TERR_SPARES_PVT.process_match_terr_spares (
2610: p_api_version_number => 1.0,
2611: p_init_msg_list => fnd_api.g_true,

Line 2622: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2618: x_msg_count => x_msg_count,
2619: X_msg_data => X_msg_data
2620: );
2621:
2622: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2624: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2625: 'Status returned from JTY_TERR_SPARES_PVT.process_match_terr_spares = '
2626: || x_return_status);

Line 2623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2619: X_msg_data => X_msg_data
2620: );
2621:
2622: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2624: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2625: 'Status returned from JTY_TERR_SPARES_PVT.process_match_terr_spares = '
2626: || x_return_status);
2627: end if; -- End of FND Logger If block

Line 2627: end if; -- End of FND Logger If block

2623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2624: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2625: 'Status returned from JTY_TERR_SPARES_PVT.process_match_terr_spares = '
2626: || x_return_status);
2627: end if; -- End of FND Logger If block
2628:
2629: if x_return_status = 'S' then
2630:
2631: begin

Line 2634: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2630:
2631: begin
2632: for c_terr in c_terr_result loop
2633:
2634: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2636: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2637: 'c_terr.terr_id =' || c_terr.terr_id);
2638: end if; -- End of FND Logger If block

Line 2635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2631: begin
2632: for c_terr in c_terr_result loop
2633:
2634: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2636: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2637: 'c_terr.terr_id =' || c_terr.terr_id);
2638: end if; -- End of FND Logger If block
2639:

Line 2638: end if; -- End of FND Logger If block

2634: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2636: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2637: 'c_terr.terr_id =' || c_terr.terr_id);
2638: end if; -- End of FND Logger If block
2639:
2640: l_source_terr_id := c_terr.terr_id;
2641:
2642: if l_source_terr_id is not null then

Line 2657: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2653: end if; -- if l_source_terr_id is not null
2654:
2655: end loop; -- for c_terr in c_terr_result loop
2656:
2657: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2659: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2660: 'FOR loop ended with v_match_rule_id = ' || v_match_rule_id);
2661: end if; -- End of FND Logger If block

Line 2658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2654:
2655: end loop; -- for c_terr in c_terr_result loop
2656:
2657: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2659: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2660: 'FOR loop ended with v_match_rule_id = ' || v_match_rule_id);
2661: end if; -- End of FND Logger If block
2662:

Line 2661: end if; -- End of FND Logger If block

2657: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2659: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2660: 'FOR loop ended with v_match_rule_id = ' || v_match_rule_id);
2661: end if; -- End of FND Logger If block
2662:
2663: exception
2664: when NO_DATA_FOUND then
2665: v_match_rule_id := null;

Line 2694: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2690: close c_Scan_Terr;
2691:
2692: end if; -- End of if p_source_type = 'I'
2693:
2694: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2695: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2696: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2697: 'v_match_rule_id=' || v_match_rule_id
2698: || ', v_match_rule_weight=' || v_match_rule_weight);

Line 2695: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2691:
2692: end if; -- End of if p_source_type = 'I'
2693:
2694: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2695: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2696: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2697: 'v_match_rule_id=' || v_match_rule_id
2698: || ', v_match_rule_weight=' || v_match_rule_weight);
2699: end if; -- End of FND Logger If block

Line 2699: end if; -- End of FND Logger If block

2695: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2696: 'csp.plsql.CSP_EXCESS_PARTS_PVT.find_best_routing_rule',
2697: 'v_match_rule_id=' || v_match_rule_id
2698: || ', v_match_rule_weight=' || v_match_rule_weight);
2699: end if; -- End of FND Logger If block
2700:
2701: if v_match_rule_id is not null then
2702: x_rule_id := v_match_rule_id;
2703: end if;