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.20 2007/10/17 21:57:39 mantyaku noship $ */
3:
4: G_LOG_TIMESTAMP_FORMAT CONSTANT VARCHAR2( 30 ) := 'dd-mon-yyyy hh:mi:ss.ff';
5:

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

465: l_attr_missing BOOLEAN;
466: l_attr_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
467: l_old_attr_id NUMBER;
468: BEGIN
469: Debug_Conc_Log('Starting EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage');
470:
471: l_delimeter := NVL(EGO_COMMON_PVT.GET_OPTION_VALUE('EGO_SKU_CONCAT_VA_DELIM'), '.');
472: SELECT SET_PROCESS_ID, INVENTORY_ITEM_ID, ITEM_NUMBER, ORGANIZATION_ID, ITEM_CATALOG_GROUP_ID, STYLE_ITEM_ID
473: INTO l_batch_id, l_sku_item_id, l_item_number, l_org_id, l_category_id, l_style_item_id

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

502: Debug_Conc_Log('l_concat_value='||l_concat_value);
503:
504: IF l_attr_missing THEN
505: Debug_Conc_Log('Some Variant attributes are missing');
506: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Error');
507: x_sku_exists := false;
508: x_var_attrs_missing := true;
509: x_err_text := 'Some Variant attributes are missing';
510: RETURN 0;

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

536: l_user_id
537: );
538:
539: Debug_Conc_Log('Inserted Successfully');
540: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Success');
541: x_sku_exists := false;
542: x_var_attrs_missing := false;
543: x_err_text := NULL;
544: RETURN 0;

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

543: x_err_text := NULL;
544: RETURN 0;
545: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN
546: Debug_Conc_Log('SKU Already exists');
547: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Error');
548: x_sku_exists := true;
549: x_var_attrs_missing := false;
550: x_err_text := 'SKU Already exists';
551: RETURN 0;

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

555: x_sku_exists := true;
556: x_var_attrs_missing := true;
557: x_err_text := 'Unexpected Error in Validate_SKU_Variant_Usage - ' || SQLERRM;
558: Debug_Conc_Log(x_err_text);
559: Debug_Conc_Log('Done EGO_STYLE_SKU_ITEM_PVT.Validate_SKU_Variant_Usage with Unexpected error');
560: RETURN SQLCODE;
561: END Validate_SKU_Variant_Usage;
562:
563: FUNCTION Default_Style_Variant_Attrs(p_inventory_item_id IN NUMBER,

Line 933: END EGO_STYLE_SKU_ITEM_PVT;

929: x_msg_data := SQLERRM;
930: END Propagate_Category_To_SKUs;
931:
932:
933: END EGO_STYLE_SKU_ITEM_PVT;