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.MSC_X_NETTING_PKG dependencies on MSC_X_EXCEPTION_DETAILS

Line 919: -- insert to the msc_x_exception_details table by bulk

915: END IF;
916:
917:
918: --================================================
919: -- insert to the msc_x_exception_details table by bulk
920: --=================================================
921:
922: populate_exception_data(a_company_id,
923: a_company_name,

Line 1042: -- the flag back to normal in msc_x_exception_details table

1038: --=================================================================
1039: -- A profile option to set the workflow notification on/off
1040: -- By default it is set to "Y" and let it launch the workflow
1041: -- notification. If it is set to 'N', no need to send and set
1042: -- the flag back to normal in msc_x_exception_details table
1043: --====================================================================
1044:
1045:
1046: -----------------------------------------------------------

Line 1069: update msc_x_exception_details

1065:
1066: IF l_request_id=0 THEN
1067: FND_FILE.PUT_LINE(FND_FILE.LOG,'Launch Exception Workflow request failed');
1068: begin
1069: update msc_x_exception_details
1070: set version = null, last_update_login = null
1071: where plan_id = -1
1072: and version = 'CURRENT'
1073: and exception_group in (1,2,3,4,5,6,7,8,9,10);

Line 1086: update msc_x_exception_details

1082: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Workflow process completed at' || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1083: ELSE
1084: --Reset the records for which the no notifications need to sent
1085: begin
1086: update msc_x_exception_details
1087: set version = null, last_update_login = null
1088: where plan_id = -1
1089: and version = 'CURRENT'
1090: and exception_group in (1,2,3,4,5,6,7,8,9,10);

Line 1253: -- insert to the msc_x_exception_details table by bulk

1249: and sr_instance_id = G_SR_INSTANCE_ID;
1250: END IF;
1251:
1252: --================================================
1253: -- insert to the msc_x_exception_details table by bulk
1254: --=================================================
1255:
1256: populate_exception_data(a_company_id,
1257: a_company_name,

Line 1757: select msc_x_exception_details_s.nextval

1753: ) IS
1754: l_ex_dtl_id Number;
1755: l_user_id Number := fnd_global.user_id;
1756: BEGIN
1757: select msc_x_exception_details_s.nextval
1758: into l_ex_dtl_id
1759: from dual;
1760:
1761: insert into msc_x_exception_details ( exception_detail_id,

Line 1761: insert into msc_x_exception_details ( exception_detail_id,

1757: select msc_x_exception_details_s.nextval
1758: into l_ex_dtl_id
1759: from dual;
1760:
1761: insert into msc_x_exception_details ( exception_detail_id,
1762: exception_type,
1763: exception_type_name,
1764: exception_group,
1765: exception_group_name,

Line 2164: FROM msc_x_exception_details ed

2160:
2161: if p_trx_id2 is null then
2162: SELECT ed.exception_detail_id
2163: INTO l_exception_detail_id
2164: FROM msc_x_exception_details ed
2165: WHERE ed.plan_id = G_PLAN_ID
2166: AND ed.inventory_item_id = p_item_id
2167: AND ed.company_id = p_company_id
2168: AND ed.company_site_id = p_company_site_id

Line 2175: FROM msc_x_exception_details ed

2171: else
2172:
2173: SELECT ed.exception_detail_id
2174: INTO l_exception_detail_id
2175: FROM msc_x_exception_details ed
2176: WHERE ed.plan_id = G_PLAN_ID
2177: AND ed.inventory_item_id = p_item_id
2178: AND ed.company_id = p_company_id
2179: AND ed.company_site_id = p_company_site_id

Line 2208: FROM msc_x_exception_details

2204: SELECT 1
2205: INTO l_ret_flag
2206: FROM dual
2207: WHERE EXISTS (SELECT 'x'
2208: FROM msc_x_exception_details
2209: WHERE plan_id = G_PLAN_ID
2210: AND company_id = p_company_id
2211: AND company_site_id = p_company_site_id
2212: AND inventory_item_id = p_item_id

Line 2245: FROM msc_sup_dem_entries sd, msc_x_exception_details med

2241: med.supplier_site_id,
2242: med.exception_group,
2243: med.exception_type,
2244: med.exception_detail_id
2245: FROM msc_sup_dem_entries sd, msc_x_exception_details med
2246: WHERE sd.plan_id = G_PLAN_ID
2247: AND sd.quantity = 0
2248: AND nvl(sd.last_update_login,-1) = -99
2249: AND sd.last_refresh_number >= p_refresh_number

Line 2264: FROM msc_sup_dem_entries sd, msc_x_exception_details med

2260: med.supplier_site_id,
2261: med.exception_group,
2262: med.exception_type,
2263: med.exception_detail_id
2264: FROM msc_sup_dem_entries sd, msc_x_exception_details med
2265: WHERE sd.plan_id = G_PLAN_ID
2266: AND sd.quantity = 0
2267: AND nvl(sd.last_update_login, -1) = -99
2268: AND sd.last_refresh_number >= p_refresh_number

Line 2320: delete msc_x_exception_details

2316:
2317: delete_wf_notification(l_item_type, l_item_key);
2318: BEGIN
2319: --dbms_output.put_line('---Maintaining exceptions details');
2320: delete msc_x_exception_details
2321: where plan_id = G_PLAN_ID
2322: and company_id = l_company_id
2323: and company_site_id = l_company_site_id
2324: and inventory_item_id = l_item_id

Line 2389: FROM msc_x_exception_details

2385: supplier_site_id,
2386: exception_group,
2387: exception_type,
2388: exception_detail_id
2389: FROM msc_x_exception_details
2390: WHERE nvl(plan_id,G_PLAN_ID) = G_PLAN_ID --6603563
2391: and trunc(last_update_date ) < trunc(sysdate) - p_days;
2392:
2393:

Line 2431: delete msc_x_exception_details

2427: delete_wf_notification(l_item_type, l_item_key);
2428:
2429: BEGIN
2430:
2431: delete msc_x_exception_details
2432: where exception_detail_id = l_exception_detail_id;
2433:
2434: l_row := SQL%ROWCOUNT;
2435:

Line 2559: delete from msc_x_exception_details ex

2555: END IF;
2556:
2557: IF (p_type = EXECUTION_ORDER) then
2558: IF (p_curr_exc_type is not null) THEN
2559: delete from msc_x_exception_details ex
2560: where ex.plan_id = G_PLAN_ID
2561: and ex.company_id = p_company_id
2562: and ex.company_site_id = p_company_site_id
2563: and nvl(ex.customer_id,-1) = nvl(p_customer_id,-1)

Line 2592: delete from msc_x_exception_details ex

2588:
2589: IF (p_obs_exc_type is not null) THEN
2590: l_row := 0;
2591:
2592: delete from msc_x_exception_details ex
2593: where ex.plan_id = G_PLAN_ID
2594: and ex.company_id = p_company_id
2595: and ex.company_site_id = p_company_site_id
2596: and nvl(ex.customer_id,-1) = nvl(p_customer_id,-1)

Line 2625: delete from msc_x_exception_details ex

2621:
2622: ELSIF (p_type in (SUPPLY_PLANNING,DEMAND_PLANNING,VMI)) then
2623:
2624: IF (p_curr_exc_type is not null) THEN
2625: delete from msc_x_exception_details ex
2626: where ex.plan_id = G_PLAN_ID
2627: and ex.company_id = p_company_id
2628: and ex.company_site_id = p_company_site_id
2629: and nvl(ex.customer_id,-1) = nvl(p_customer_id,-1)

Line 2654: delete from msc_x_exception_details ex

2650: ----dbms_output.put_line('delete item exception');
2651: END IF;
2652: IF (p_obs_exc_type is not null) THEN
2653: l_row := 0;
2654: delete from msc_x_exception_details ex
2655: where ex.plan_id = G_PLAN_ID
2656: and ex.company_id = p_company_id
2657: and ex.company_site_id = p_company_site_id
2658: and nvl(ex.customer_id,-1) = nvl(p_customer_id,-1)

Line 2683: delete from msc_x_exception_details ex

2679: ----dbms_output.put_line('delete item exception');
2680: END IF;
2681: ELSE
2682: IF (p_curr_exc_type is not null) THEN
2683: delete from msc_x_exception_details ex
2684: where ex.plan_id = G_PLAN_ID
2685: and ex.company_id = p_company_id
2686: and ex.company_site_id = p_company_site_id
2687: and nvl(ex.customer_id,-1) = nvl(p_customer_id,-1)

Line 2714: delete from msc_x_exception_details ex

2710: ----dbms_output.put_line('delete item exception');
2711: END IF;
2712: IF (p_obs_exc_type is not null) THEN
2713: l_row := 0;
2714: delete from msc_x_exception_details ex
2715: where ex.plan_id = G_PLAN_ID
2716: and ex.company_id = p_company_id
2717: and ex.company_site_id = p_company_site_id
2718: and nvl(ex.customer_id,-1) = nvl(p_customer_id,-1)

Line 3062: insert into msc_x_exception_details (

3058: --dbms_output.put_line('Populate exception data ' || a_company_id.COUNT);
3059:
3060: IF a_company_id IS NOT NULL AND a_company_id.COUNT > 0 THEN
3061: FORALL i in 1..a_company_id.COUNT
3062: insert into msc_x_exception_details (
3063: exception_detail_id,
3064: exception_type,
3065: exception_type_name,
3066: exception_group,

Line 3118: msc_x_exception_details_s.nextval,

3114: end_order_line_number,
3115: exception_basis
3116: )
3117: values (
3118: msc_x_exception_details_s.nextval,
3119: a_exception_type(i),
3120: a_exception_type_name(i),
3121: a_exception_group(i),
3122: a_exception_group_name(i),

Line 3353: delete msc_x_exception_details

3349: --======================================================================
3350: -- archive the order execution exceptions
3351: --======================================================================
3352: FORALL i in 1..t_item_list.COUNT
3353: delete msc_x_exception_details
3354: where inventory_item_id = t_item_list(i)
3355: and company_id = t_company_list(i)
3356: and company_site_id = t_company_site_list(i)
3357: and nvl(customer_id,-1) = nvl(t_customer_list(i),-1)

Line 3396: delete msc_x_exception_details

3392: --===============================================================
3393: -- archive bucket data with date range
3394: --===============================================================
3395: FORALL i in 1..t_item_list.COUNT
3396: delete msc_x_exception_details
3397: where inventory_item_id = t_item_list(i)
3398: and company_id = t_company_list(i)
3399: and company_site_id = t_company_site_list(i)
3400: and nvl(customer_id,-1) = nvl(t_customer_list(i),-1)

Line 3437: delete msc_x_exception_details

3433: --===============================================================
3434: -- archive bucket data without date range
3435: --===============================================================
3436: FORALL i in 1..t_item_list.COUNT
3437: delete msc_x_exception_details
3438: where inventory_item_id = t_item_list(i)
3439: and company_id = t_company_list(i)
3440: and company_site_id = t_company_site_list(i)
3441: and nvl(customer_id,-1) = nvl(t_customer_list(i),-1)

Line 3476: delete msc_x_exception_details

3472: --======================================================================
3473: -- archive the potential late order exceptions
3474: --======================================================================
3475: FORALL i in 1..t_item_list.COUNT
3476: delete msc_x_exception_details
3477: where inventory_item_id = t_item_list(i)
3478: and company_id = t_company_list(i)
3479: and company_site_id = t_company_site_list(i)
3480: and nvl(customer_id,-1) = nvl(t_customer_list(i),-1)

Line 3561: from msc_x_exception_details

3557: where plan_id = -1
3558: and publisher_order_type in (3,14)
3559: and last_refresh_number > p_refresh_number
3560: and exists (select 1
3561: from msc_x_exception_details
3562: where plan_id = -1
3563: and inventory_item_id = sd.inventory_item_id
3564: and exception_type in (5,25)
3565: and company_id = sd.publisher_id

Line 3584: from msc_x_exception_details

3580: where plan_id = -1
3581: and publisher_order_type = 2
3582: and last_refresh_number > p_refresh_number
3583: and exists (select 1
3584: from msc_x_exception_details
3585: where plan_id = -1
3586: and inventory_item_id = sd.inventory_item_id
3587: and exception_type in (5,25)
3588: and company_id = sd.supplier_id

Line 3608: from msc_x_exception_details

3604: where plan_id = -1
3605: and publisher_order_type = 2
3606: and last_refresh_number > p_refresh_number
3607: and exists (select 1
3608: from msc_x_exception_details
3609: where plan_id = -1
3610: and inventory_item_id = sd.inventory_item_id
3611: and exception_type in (6,26)
3612: and company_id = sd.publisher_id

Line 3631: from msc_x_exception_details

3627: where plan_id = -1
3628: and publisher_order_type in (3,14)
3629: and last_refresh_number > p_refresh_number
3630: and exists (select 1
3631: from msc_x_exception_details
3632: where plan_id = -1
3633: and inventory_item_id = sd.inventory_item_id
3634: and exception_type in (6,26)
3635: and company_id = sd.customer_id

Line 3671: update msc_x_exception_details

3667: --dbms_output.put_line('Count of 5-25 ' || b_publisher_id.COUNT);
3668: IF (b_publisher_id is not null and b_publisher_id.COUNT > 0) THEN
3669: FORALL j in 1..b_publisher_id.COUNT
3670:
3671: update msc_x_exception_details
3672: set item_name = b_item_name(j),
3673: item_description = b_item_desc(j),
3674: customer_item_name = b_customer_item_name(j),
3675: supplier_item_name = b_supplier_item_name(j)

Line 3701: update msc_x_exception_details

3697: --dbms_output.put_line('Count ' || b_publisher_id.COUNT);
3698: IF (b_publisher_id is not null and b_publisher_id.COUNT > 0) THEN
3699: FORALL j in 1..b_publisher_id.COUNT
3700:
3701: update msc_x_exception_details
3702: set item_name = b_item_name(j),
3703: item_description = b_item_desc(j),
3704: customer_item_name = b_customer_item_name(j),
3705: supplier_item_name = b_supplier_item_name(j)