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_NETTING_PKG

Line 1: PACKAGE BODY MSC_X_NETTING_PKG AS

1: PACKAGE BODY MSC_X_NETTING_PKG AS
2: /* $Header: MSCXNETB.pls 120.6 2008/01/07 10:15:08 dejoshi ship $ */
3:
4: TYPE ExcpTblTyp IS TABLE OF VARCHAR2(80);
5:

Line 1425: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.populate_exception_org');

1421: END IF;
1422:
1423: EXCEPTION
1424: when others then
1425: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.populate_exception_org');
1426: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
1427: return;
1428: END POPULATE_EXCEPTION_ORG;
1429:

Line 1869: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.add_exception_details');

1865: );
1866:
1867: EXCEPTION
1868: when others then
1869: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.add_exception_details');
1870: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
1871: return;
1872: END ADD_EXCEPTION_DETAILS;
1873:

Line 2747: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.delete_obsolete_exceptions');

2743: END IF;
2744:
2745: exception
2746: when others then
2747: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.delete_obsolete_exceptions');
2748: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
2749: return;
2750:
2751: END delete_obsolete_exceptions;

Line 2997: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.add_to_exception_tbl');

2993:
2994:
2995: EXCEPTION
2996: when others then
2997: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.add_to_exception_tbl');
2998: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
2999: --dbms_output.put_line('add_to_exception_tbl error ' || sqlerrm);
3000: return;
3001: END add_to_exception_tbl;

Line 3233: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.populate_exception_data');

3229:
3230: EXCEPTION
3231: when others then
3232: --dbms_output.put_line('Error in Populate_exception_date ' || sqlerrm);
3233: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.populate_exception_data');
3234: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
3235: return;
3236: END POPULATE_EXCEPTION_DATA;
3237:

Line 3309: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.add_to_delete_tbl');

3305: t_date2_list(t_item_list.COUNT) := p_date2;
3306:
3307: EXCEPTION
3308: WHEN others then
3309: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.add_to_delete_tbl');
3310: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
3311: --dbms_output.put_line('add_to_delete_tbl error ' || sqlerrm);
3312: return;
3313: END add_to_delete_tbl;

Line 3484: and exception_group = msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER

3480: and nvl(customer_id,-1) = nvl(t_customer_list(i),-1)
3481: and nvl(customer_site_id,-1) = nvl(t_customer_site_list(i),-1)
3482: and nvl(supplier_id,-1) = nvl(t_supplier_list(i),-1)
3483: and nvl(supplier_site_id ,-1) = nvl(t_supplier_site_list(i),-1)
3484: and exception_group = msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER
3485: and exception_type = msc_x_netting_pkg.G_EXCEP13
3486: and transaction_id1 = t_trxid1_list(i)
3487: and nvl(last_update_login,-1) <> G_MAGIC_NUMBER;
3488:

Line 3485: and exception_type = msc_x_netting_pkg.G_EXCEP13

3481: and nvl(customer_site_id,-1) = nvl(t_customer_site_list(i),-1)
3482: and nvl(supplier_id,-1) = nvl(t_supplier_list(i),-1)
3483: and nvl(supplier_site_id ,-1) = nvl(t_supplier_site_list(i),-1)
3484: and exception_group = msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER
3485: and exception_type = msc_x_netting_pkg.G_EXCEP13
3486: and transaction_id1 = t_trxid1_list(i)
3487: and nvl(last_update_login,-1) <> G_MAGIC_NUMBER;
3488:
3489: FOR i in 1..t_item_list.COUNT LOOP

Line 3503: and ex.inventory_item_id = msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER

3499: ex.last_update_date = sysdate
3500: where ex.plan_id = G_PLAN_ID
3501: and ex.company_id = t_company_list(i)
3502: and ex.company_site_id = t_company_site_list(i)
3503: and ex.inventory_item_id = msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER
3504: and ex.exception_group = msc_x_netting_pkg.G_EXCEP13
3505: and ex.exception_type = t_type_list(i)
3506: and ex.version = 0
3507: and nvl(last_update_login,-1) <> G_MAGIC_NUMBER;

Line 3504: and ex.exception_group = msc_x_netting_pkg.G_EXCEP13

3500: where ex.plan_id = G_PLAN_ID
3501: and ex.company_id = t_company_list(i)
3502: and ex.company_site_id = t_company_site_list(i)
3503: and ex.inventory_item_id = msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER
3504: and ex.exception_group = msc_x_netting_pkg.G_EXCEP13
3505: and ex.exception_type = t_type_list(i)
3506: and ex.version = 0
3507: and nvl(last_update_login,-1) <> G_MAGIC_NUMBER;
3508:

Line 3535: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.archive_exception');

3531:
3532:
3533: EXCEPTION
3534: when others then
3535: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.archive_exception');
3536: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
3537: return;
3538: END archive_exception;
3539:

Line 3640: b_publisher_id msc_x_netting_pkg.number_arr;

3636: and company_site_id = sd.customer_site_id
3637: and supplier_id = sd.publisher_id
3638: and supplier_site_id = sd.publisher_site_id);
3639:
3640: b_publisher_id msc_x_netting_pkg.number_arr;
3641: b_publisher_site_id msc_x_netting_pkg.number_arr;
3642: b_supplier_id msc_x_netting_pkg.number_arr;
3643: b_supplier_site_id msc_x_netting_pkg.number_arr;
3644: b_customer_id msc_x_netting_pkg.number_arr;

Line 3641: b_publisher_site_id msc_x_netting_pkg.number_arr;

3637: and supplier_id = sd.publisher_id
3638: and supplier_site_id = sd.publisher_site_id);
3639:
3640: b_publisher_id msc_x_netting_pkg.number_arr;
3641: b_publisher_site_id msc_x_netting_pkg.number_arr;
3642: b_supplier_id msc_x_netting_pkg.number_arr;
3643: b_supplier_site_id msc_x_netting_pkg.number_arr;
3644: b_customer_id msc_x_netting_pkg.number_arr;
3645: b_customer_site_id msc_x_netting_pkg.number_arr;

Line 3642: b_supplier_id msc_x_netting_pkg.number_arr;

3638: and supplier_site_id = sd.publisher_site_id);
3639:
3640: b_publisher_id msc_x_netting_pkg.number_arr;
3641: b_publisher_site_id msc_x_netting_pkg.number_arr;
3642: b_supplier_id msc_x_netting_pkg.number_arr;
3643: b_supplier_site_id msc_x_netting_pkg.number_arr;
3644: b_customer_id msc_x_netting_pkg.number_arr;
3645: b_customer_site_id msc_x_netting_pkg.number_arr;
3646: b_item_id msc_x_netting_pkg.number_arr;

Line 3643: b_supplier_site_id msc_x_netting_pkg.number_arr;

3639:
3640: b_publisher_id msc_x_netting_pkg.number_arr;
3641: b_publisher_site_id msc_x_netting_pkg.number_arr;
3642: b_supplier_id msc_x_netting_pkg.number_arr;
3643: b_supplier_site_id msc_x_netting_pkg.number_arr;
3644: b_customer_id msc_x_netting_pkg.number_arr;
3645: b_customer_site_id msc_x_netting_pkg.number_arr;
3646: b_item_id msc_x_netting_pkg.number_arr;
3647: b_item_name msc_x_netting_pkg.itemnameList;

Line 3644: b_customer_id msc_x_netting_pkg.number_arr;

3640: b_publisher_id msc_x_netting_pkg.number_arr;
3641: b_publisher_site_id msc_x_netting_pkg.number_arr;
3642: b_supplier_id msc_x_netting_pkg.number_arr;
3643: b_supplier_site_id msc_x_netting_pkg.number_arr;
3644: b_customer_id msc_x_netting_pkg.number_arr;
3645: b_customer_site_id msc_x_netting_pkg.number_arr;
3646: b_item_id msc_x_netting_pkg.number_arr;
3647: b_item_name msc_x_netting_pkg.itemnameList;
3648: b_item_desc msc_x_netting_pkg.itemdescList;

Line 3645: b_customer_site_id msc_x_netting_pkg.number_arr;

3641: b_publisher_site_id msc_x_netting_pkg.number_arr;
3642: b_supplier_id msc_x_netting_pkg.number_arr;
3643: b_supplier_site_id msc_x_netting_pkg.number_arr;
3644: b_customer_id msc_x_netting_pkg.number_arr;
3645: b_customer_site_id msc_x_netting_pkg.number_arr;
3646: b_item_id msc_x_netting_pkg.number_arr;
3647: b_item_name msc_x_netting_pkg.itemnameList;
3648: b_item_desc msc_x_netting_pkg.itemdescList;
3649: b_customer_item_name msc_x_netting_pkg.itemnameList;

Line 3646: b_item_id msc_x_netting_pkg.number_arr;

3642: b_supplier_id msc_x_netting_pkg.number_arr;
3643: b_supplier_site_id msc_x_netting_pkg.number_arr;
3644: b_customer_id msc_x_netting_pkg.number_arr;
3645: b_customer_site_id msc_x_netting_pkg.number_arr;
3646: b_item_id msc_x_netting_pkg.number_arr;
3647: b_item_name msc_x_netting_pkg.itemnameList;
3648: b_item_desc msc_x_netting_pkg.itemdescList;
3649: b_customer_item_name msc_x_netting_pkg.itemnameList;
3650: b_supplier_item_name msc_x_netting_pkg.itemnameList;

Line 3647: b_item_name msc_x_netting_pkg.itemnameList;

3643: b_supplier_site_id msc_x_netting_pkg.number_arr;
3644: b_customer_id msc_x_netting_pkg.number_arr;
3645: b_customer_site_id msc_x_netting_pkg.number_arr;
3646: b_item_id msc_x_netting_pkg.number_arr;
3647: b_item_name msc_x_netting_pkg.itemnameList;
3648: b_item_desc msc_x_netting_pkg.itemdescList;
3649: b_customer_item_name msc_x_netting_pkg.itemnameList;
3650: b_supplier_item_name msc_x_netting_pkg.itemnameList;
3651:

Line 3648: b_item_desc msc_x_netting_pkg.itemdescList;

3644: b_customer_id msc_x_netting_pkg.number_arr;
3645: b_customer_site_id msc_x_netting_pkg.number_arr;
3646: b_item_id msc_x_netting_pkg.number_arr;
3647: b_item_name msc_x_netting_pkg.itemnameList;
3648: b_item_desc msc_x_netting_pkg.itemdescList;
3649: b_customer_item_name msc_x_netting_pkg.itemnameList;
3650: b_supplier_item_name msc_x_netting_pkg.itemnameList;
3651:
3652:

Line 3649: b_customer_item_name msc_x_netting_pkg.itemnameList;

3645: b_customer_site_id msc_x_netting_pkg.number_arr;
3646: b_item_id msc_x_netting_pkg.number_arr;
3647: b_item_name msc_x_netting_pkg.itemnameList;
3648: b_item_desc msc_x_netting_pkg.itemdescList;
3649: b_customer_item_name msc_x_netting_pkg.itemnameList;
3650: b_supplier_item_name msc_x_netting_pkg.itemnameList;
3651:
3652:
3653: BEGIN

Line 3650: b_supplier_item_name msc_x_netting_pkg.itemnameList;

3646: b_item_id msc_x_netting_pkg.number_arr;
3647: b_item_name msc_x_netting_pkg.itemnameList;
3648: b_item_desc msc_x_netting_pkg.itemdescList;
3649: b_customer_item_name msc_x_netting_pkg.itemnameList;
3650: b_supplier_item_name msc_x_netting_pkg.itemnameList;
3651:
3652:
3653: BEGIN
3654:

Line 3719: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.update_item');

3715:
3716:
3717: EXCEPTION
3718: when others then
3719: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING_PKG.update_item');
3720: MSC_SCE_LOADS_PKG.LOG_MESSAGE(SQLERRM);
3721: --dbms_output.put_line('Error in update item');
3722: return;
3723: END UPDATE_ITEM;

Line 3725: END MSC_X_NETTING_PKG;

3721: --dbms_output.put_line('Error in update item');
3722: return;
3723: END UPDATE_ITEM;
3724:
3725: END MSC_X_NETTING_PKG;
3726: