DBA Data[Home] [Help]

APPS.EGO_GTIN_ATTRS_PVT dependencies on EGO_GTIN_PVT

Line 3621: -- populating variable for passing to EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES

3617: Debug_Msg('Starting Do_Post_UCCnet_Attrs_Action for Item,Org='||i.INVENTORY_ITEM_ID||','||i.ORGANIZATION_ID);
3618: l_attribute_names := EGO_VARCHAR_TBL_TYPE(null);
3619: l_attr_diffs := EGO_USER_ATTR_DIFF_TABLE();
3620: FOR j IN c_intf_row_attrs(i.INVENTORY_ITEM_ID, i.ORGANIZATION_ID) LOOP
3621: -- populating variable for passing to EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES
3622: l_attribute_names.EXTEND;
3623: l_attribute_names(l_attribute_names.COUNT) := j.ATTR_INT_NAME;
3624: -- populating variable for passing to EGO_GTIN_PVT.Item_Propagate_Attributes
3625: l_attr_diffs.EXTEND();

Line 3624: -- populating variable for passing to EGO_GTIN_PVT.Item_Propagate_Attributes

3620: FOR j IN c_intf_row_attrs(i.INVENTORY_ITEM_ID, i.ORGANIZATION_ID) LOOP
3621: -- populating variable for passing to EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES
3622: l_attribute_names.EXTEND;
3623: l_attribute_names(l_attribute_names.COUNT) := j.ATTR_INT_NAME;
3624: -- populating variable for passing to EGO_GTIN_PVT.Item_Propagate_Attributes
3625: l_attr_diffs.EXTEND();
3626: l_attr_diffs(l_attr_diffs.LAST) := EGO_USER_ATTR_DIFF_OBJ
3627: ( attr_id => j.ATTR_ID
3628: , attr_name => j.ATTR_INT_NAME

Line 3643: Debug_Msg('Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES');

3639: );
3640: END LOOP;
3641:
3642: IF l_attribute_names.COUNT > 0 THEN
3643: Debug_Msg('Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES');
3644: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(
3645: i.INVENTORY_ITEM_ID,
3646: i.ORGANIZATION_ID,
3647: l_attribute_names,

Line 3644: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(

3640: END LOOP;
3641:
3642: IF l_attribute_names.COUNT > 0 THEN
3643: Debug_Msg('Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES');
3644: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(
3645: i.INVENTORY_ITEM_ID,
3646: i.ORGANIZATION_ID,
3647: l_attribute_names,
3648: FND_API.G_FALSE,

Line 3653: Debug_Msg('Finished Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES with status='||l_return_status);

3649: l_return_status,
3650: l_msg_count,
3651: l_msg_data);
3652:
3653: Debug_Msg('Finished Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES with status='||l_return_status);
3654: IF l_return_status <> 'S' THEN
3655: ERROR_HANDLER.Add_Error_Message
3656: (
3657: p_message_text => l_msg_data

Line 3670: Debug_Msg('Calling EGO_GTIN_PVT.Item_Propagate_Attributes');

3666: END IF; -- end IF l_return_st
3667: END IF; -- end IF l_attribute_names.COUN
3668:
3669: IF l_attr_diffs.COUNT > 0 THEN
3670: Debug_Msg('Calling EGO_GTIN_PVT.Item_Propagate_Attributes');
3671: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3672: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(i.INVENTORY_ITEM_ID))
3673: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(i.ORGANIZATION_ID))
3674: );

Line 3682: EGO_GTIN_PVT.Item_Propagate_Attributes

3678:
3679: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
3680:
3681: l_msg_data := NULL;
3682: EGO_GTIN_PVT.Item_Propagate_Attributes
3683: ( p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
3684: , p_class_code_name_value_pairs => l_class_code_name_value_pairs
3685: , p_data_level_name_value_pairs => l_data_level_name_value_pairs
3686: , p_attr_diffs => l_attr_diffs

Line 3690: Debug_Msg('Finished Calling EGO_GTIN_PVT.Item_Propagate_Attributes with '||l_msg_data);

3686: , p_attr_diffs => l_attr_diffs
3687: , p_transaction_type => 'UPDATE'
3688: , x_error_message => l_msg_data
3689: );
3690: Debug_Msg('Finished Calling EGO_GTIN_PVT.Item_Propagate_Attributes with '||l_msg_data);
3691: IF l_msg_data IS NOT NULL THEN
3692: ERROR_HANDLER.Add_Error_Message
3693: (
3694: p_message_text => l_msg_data

Line 3720: Debug_Msg('Calling EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES');

3716: END LOOP; --FOR j IN c_intf_row_extn_attrs(i.INVENTORY_ITEM_ID, i.ORGANIZATION_ID, i.ATTR_GROUP_INT_NAME) LOOP
3717:
3718: -- calling PROCESS_EXTN_ATTRIBUTE_UPDATES
3719: IF l_attribute_names.COUNT > 0 THEN
3720: Debug_Msg('Calling EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES');
3721: EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES(
3722: i.INVENTORY_ITEM_ID,
3723: i.ORGANIZATION_ID,
3724: l_attribute_names,

Line 3721: EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES(

3717:
3718: -- calling PROCESS_EXTN_ATTRIBUTE_UPDATES
3719: IF l_attribute_names.COUNT > 0 THEN
3720: Debug_Msg('Calling EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES');
3721: EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES(
3722: i.INVENTORY_ITEM_ID,
3723: i.ORGANIZATION_ID,
3724: l_attribute_names,
3725: i.ATTR_GROUP_INT_NAME,

Line 3731: Debug_Msg('Finished Calling EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES with status='||l_return_status);

3727: l_return_status,
3728: l_msg_count,
3729: l_msg_data);
3730:
3731: Debug_Msg('Finished Calling EGO_GTIN_PVT.PROCESS_EXTN_ATTRIBUTE_UPDATES with status='||l_return_status);
3732: IF l_return_status <> 'S' THEN
3733: ERROR_HANDLER.Add_Error_Message
3734: (
3735: p_message_text => l_msg_data

Line 6483: Debug_Msg('Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES');

6479: END IF; -- IF p_multi_row_attrs_table.FIRST IS NOT NULL THEN
6480: Debug_Msg('Done, Processing multi row attributes');
6481:
6482: IF l_attribute_names.COUNT > 0 THEN
6483: Debug_Msg('Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES');
6484: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(
6485: p_inventory_item_id,
6486: p_organization_id,
6487: l_attribute_names,

Line 6484: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(

6480: Debug_Msg('Done, Processing multi row attributes');
6481:
6482: IF l_attribute_names.COUNT > 0 THEN
6483: Debug_Msg('Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES');
6484: EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES(
6485: p_inventory_item_id,
6486: p_organization_id,
6487: l_attribute_names,
6488: FND_API.G_FALSE,

Line 6493: Debug_Msg('Finished Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES with status='||l_return_status);

6489: l_return_status,
6490: l_msg_count,
6491: l_msg_data);
6492:
6493: Debug_Msg('Finished Calling EGO_GTIN_PVT.PROCESS_ATTRIBUTE_UPDATES with status='||l_return_status);
6494: IF l_return_status <> 'S' THEN
6495: Debug_Msg('Error msg - '|| l_msg_data);
6496: IF FND_API.To_Boolean(p_init_error_handler) THEN
6497: ERROR_HANDLER.Initialize;