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.EGO_ITEM_PUB dependencies on EGO_USER_ATTRS_DATA_PVT

Line 3875: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Entered Apply_Templ_User_Attrs_To_Item ');

3871: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
3872: START WITH item_catalog_group_id = cp_catalog_category_id;
3873:
3874: BEGIN
3875: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Entered Apply_Templ_User_Attrs_To_Item ');
3876:
3877: x_return_status := G_RET_STS_SUCCESS;
3878:
3879: -- Check for call compatibility

Line 3895: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: Template ID = '||p_template_id);

3891: , to_char(p_organization_id))
3892: );
3893:
3894:
3895: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: Template ID = '||p_template_id);
3896: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode = '||p_mode);
3897:
3898: IF (p_mode <> G_TTYPE_CREATE) THEN
3899:

Line 3896: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode = '||p_mode);

3892: );
3893:
3894:
3895: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: Template ID = '||p_template_id);
3896: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode = '||p_mode);
3897:
3898: IF (p_mode <> G_TTYPE_CREATE) THEN
3899:
3900: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode <> G_TTYPE_CREATE');

Line 3900: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode <> G_TTYPE_CREATE');

3896: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode = '||p_mode);
3897:
3898: IF (p_mode <> G_TTYPE_CREATE) THEN
3899:
3900: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode <> G_TTYPE_CREATE');
3901: -- check if CM exists
3902: IF (EGO_ITEM_AML_PUB.Check_CM_Existance() = G_RET_STS_SUCCESS) THEN
3903:
3904: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: CM Exists!');

Line 3904: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: CM Exists!');

3900: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode <> G_TTYPE_CREATE');
3901: -- check if CM exists
3902: IF (EGO_ITEM_AML_PUB.Check_CM_Existance() = G_RET_STS_SUCCESS) THEN
3903:
3904: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: CM Exists!');
3905:
3906: -- ENG exists
3907: -- check for policy control
3908: l_dynamic_sql :=

Line 3999: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' About to call the UCCnet attrs exclude code');

3995: -- Append to the list of attribute group ids to exclude, the --
3996: -- UCCnet related Attribute groups, as the Template application--
3997: -- is taken care of in Java code for these Attrs. --
3998: -----------------------------------------------------------------
3999: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' About to call the UCCnet attrs exclude code');
4000: l_attr_grp_dyn_sql := '';
4001: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'SELECT DISTINCT ATTRIBUTE_GROUP_ID ';
4002: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'FROM EGO_TEMPL_ATTRIBUTES T ';
4003: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'WHERE T.TEMPLATE_ID = :TEMPL_ID ';

Line 4031: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('load_item_oper_attr_values: Retrieved rows => '||To_char(l_attr_grp_rows_cnt));

4027: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);
4028:
4029: DBMS_SQL.COLUMN_VALUE(l_attr_grp_cursor, 1, l_attr_grp_table);
4030:
4031: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('load_item_oper_attr_values: Retrieved rows => '||To_char(l_attr_grp_rows_cnt));
4032:
4033: FOR i IN 1..l_attr_grp_table.COUNT LOOP
4034:
4035: -----------------------------------------------------------------------

Line 4042: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Attr Grp ID => '|| l_attr_grp_table(i));

4038: IF l_attr_group_ids_to_exclude IS NULL THEN
4039: l_attr_group_ids_to_exclude := EGO_NUMBER_TBL_TYPE();
4040: END IF;
4041:
4042: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Attr Grp ID => '|| l_attr_grp_table(i));
4043: -----------------------------------------------------------------------
4044: -- Add these retrieved Attr Grp IDs to the end of existing:
4045: -- Exclusion Attr Grp IDs table (l_attr_group_ids_to_exclude)
4046: -----------------------------------------------------------------------

Line 4058: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' UCCnet exclusion code complete.');

4054: EXIT WHEN l_attr_grp_rows_cnt < 2500;
4055: END LOOP; --end: Loop for every 2500 rows.
4056: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);
4057:
4058: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' UCCnet exclusion code complete.');
4059:
4060: -----------------------------------------------------------------
4061: -- END: PPEDDAMA (11th October 2004) --
4062: -----------------------------------------------------------------

Line 4069: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_attr_group_ids_to_exclude.COUNT = '||l_attr_group_ids_to_exclude.COUNT);

4065: l_attr_group_ids IS NOT NULL AND
4066: l_attr_group_ids_to_exclude.COUNT > 0 AND
4067: l_attr_group_ids.COUNT > 0 ) THEN
4068:
4069: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_attr_group_ids_to_exclude.COUNT = '||l_attr_group_ids_to_exclude.COUNT);
4070: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_attr_group_ids.COUNT = '||l_attr_group_ids.COUNT);
4071:
4072: -----------------------------------------------------------------
4073: -- don't issue perform dml if all attr grps are excluded

Line 4070: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_attr_group_ids.COUNT = '||l_attr_group_ids.COUNT);

4066: l_attr_group_ids_to_exclude.COUNT > 0 AND
4067: l_attr_group_ids.COUNT > 0 ) THEN
4068:
4069: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_attr_group_ids_to_exclude.COUNT = '||l_attr_group_ids_to_exclude.COUNT);
4070: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_attr_group_ids.COUNT = '||l_attr_group_ids.COUNT);
4071:
4072: -----------------------------------------------------------------
4073: -- don't issue perform dml if all attr grps are excluded
4074: -----------------------------------------------------------------

Line 4076: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_perform_dml is FALSE ');

4072: -----------------------------------------------------------------
4073: -- don't issue perform dml if all attr grps are excluded
4074: -----------------------------------------------------------------
4075: IF (l_attr_group_ids_to_exclude.COUNT = l_attr_group_ids.COUNT) THEN
4076: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_perform_dml is FALSE ');
4077: l_perform_dml := FALSE;
4078: END IF; --end: IF (l_attr_group_ids_to_exclude.COUNT >= ...
4079:
4080: END IF; --end: IF (l_attr_group_ids_to_exclude IS NOT NULL ...

Line 4084: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_perform_dml is TRUE ');

4080: END IF; --end: IF (l_attr_group_ids_to_exclude IS NOT NULL ...
4081:
4082: IF (l_perform_dml = TRUE) THEN
4083:
4084: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_perform_dml is TRUE ');
4085:
4086: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (
4087: p_api_version => 1.0
4088: ,p_template_id => p_template_id

Line 4086: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (

4082: IF (l_perform_dml = TRUE) THEN
4083:
4084: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_perform_dml is TRUE ');
4085:
4086: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (
4087: p_api_version => 1.0
4088: ,p_template_id => p_template_id
4089: ,p_object_name => p_object_name
4090: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs

Line 4101: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (

4097: ,x_msg_count => x_msg_count
4098: ,x_msg_data => x_msg_data
4099: );
4100:
4101: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (
4102: p_api_version => 1.0
4103: ,p_template_id => p_template_id
4104: ,p_object_name => p_object_name
4105: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs

Line 4116: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (

4112: ,x_msg_count => x_msg_count
4113: ,x_msg_data => x_msg_data
4114: );
4115:
4116: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (
4117: p_api_version => 1.0
4118: ,p_template_id => p_template_id
4119: ,p_object_name => p_object_name
4120: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs

Line 4131: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (

4127: ,x_msg_count => x_msg_count
4128: ,x_msg_data => x_msg_data
4129: );
4130:
4131: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (
4132: p_api_version => 1.0
4133: ,p_template_id => p_template_id
4134: ,p_object_name => p_object_name
4135: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs

Line 4148: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item -- Done');

4144: );
4145:
4146: END IF;
4147:
4148: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item -- Done');
4149: EXCEPTION
4150: WHEN OTHERS THEN
4151: IF (l_attr_grp_cursor IS NOT NULL) THEN
4152: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);

Line 4154: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('In Apply_Templ_User_Attrs_To_Item, got exception '||SQLERRM, 3);

4150: WHEN OTHERS THEN
4151: IF (l_attr_grp_cursor IS NOT NULL) THEN
4152: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);
4153: END IF;
4154: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('In Apply_Templ_User_Attrs_To_Item, got exception '||SQLERRM, 3);
4155:
4156: END Apply_Templ_User_Attrs_To_Item;
4157:
4158: ---------------------------------------------------------------------------