APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on EGO_STYLE_SKU_ITEM_PVT

Line 1: PACKAGE BODY EGO_STYLE_SKU_ITEM_PVT AS

1: PACKAGE BODY EGO_STYLE_SKU_ITEM_PVT AS
2: /* $Header: EGOSITMB.pls 120.22 2010/09/17 07:23:56 ccsingh ship $ */
3:
4: G_LOG_TIMESTAMP_FORMAT CONSTANT VARCHAR2( 30 ) := 'dd-mon-yyyy hh:mi:ss.ff';
5:

Line 533: Debug_Conc_Log('Starting EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage');

529: l_attr_missing BOOLEAN;
530: l_attr_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
531: l_old_attr_id NUMBER;
532: BEGIN
533: Debug_Conc_Log('Starting EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage');
534:
535: l_delimeter := NVL(EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_SKU_CONCAT_VA_DELIM'), '.');
536: SELECT SET_PROCESS_ID, INVENTORY_ITEM_ID, ITEM_NUMBER, ORGANIZATION_ID, ITEM_CATALOG_GROUP_ID, STYLE_ITEM_ID
537: INTO l_batch_id, l_sku_item_id, l_item_number, l_org_id, l_category_id, l_style_item_id

Line 570: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Error');

566: Debug_Conc_Log('l_concat_value='||l_concat_value);
567:
568: IF l_attr_missing THEN
569: Debug_Conc_Log('Some Variant attributes are missing');
570: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Error');
571: x_sku_exists := false;
572: x_var_attrs_missing := true;
573: x_err_text := 'Some Variant attributes are missing';
574: RETURN 0;

Line 604: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Success');

600: l_user_id
601: );
602:
603: Debug_Conc_Log('Inserted Successfully');
604: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Success');
605: x_sku_exists := false;
606: x_var_attrs_missing := false;
607: x_err_text := NULL;
608: RETURN 0;

Line 611: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Error');

607: x_err_text := NULL;
608: RETURN 0;
609: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN
610: Debug_Conc_Log('SKU Already exists');
611: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Error');
612: x_sku_exists := true;
613: x_var_attrs_missing := false;
614: x_err_text := 'SKU Already exists';
615: RETURN 0;

Line 623: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Unexpected error');

619: x_sku_exists := true;
620: x_var_attrs_missing := true;
621: x_err_text := 'Unexpected Error in Validate_SKU_Variant_Usage - ' || SQLERRM;
622: Debug_Conc_Log(x_err_text);
623: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Unexpected error');
624: RETURN SQLCODE;
625: END Validate_SKU_Variant_Usage;
626:
627: FUNCTION Default_Style_Variant_Attrs(p_inventory_item_id IN NUMBER,

Line 1033: END EGO_STYLE_SKU_ITEM_PVT;

1029: WHERE ATTR_GROUP_TYPE = 'EGO_ITEMMGMT_GROUP'
1030: AND APPLICATION_ID = 431
1031: AND DATA_LEVEL_NAME = 'ITEM_LEVEL';
1032:
1033: END EGO_STYLE_SKU_ITEM_PVT;