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 4123: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Entered Apply_Templ_User_Attrs_To_Item ');

4119: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
4120: START WITH item_catalog_group_id = cp_catalog_category_id;
4121:
4122: BEGIN
4123: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Entered Apply_Templ_User_Attrs_To_Item ');
4124:
4125: x_return_status := G_RET_STS_SUCCESS;
4126:
4127: -- Check for call compatibility

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

4139: , to_char(p_organization_id))
4140: );
4141:
4142:
4143: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: Template ID = '||p_template_id);
4144: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode = '||p_mode);
4145:
4146: IF (p_mode <> G_TTYPE_CREATE) THEN
4147:

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

4140: );
4141:
4142:
4143: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: Template ID = '||p_template_id);
4144: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode = '||p_mode);
4145:
4146: IF (p_mode <> G_TTYPE_CREATE) THEN
4147:
4148: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode <> G_TTYPE_CREATE');

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

4144: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode = '||p_mode);
4145:
4146: IF (p_mode <> G_TTYPE_CREATE) THEN
4147:
4148: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode <> G_TTYPE_CREATE');
4149: -- check if CM exists
4150: IF (EGO_ITEM_AML_PUB.Check_CM_Existance() = G_RET_STS_SUCCESS) THEN
4151:
4152: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: CM Exists!');

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

4148: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: p_mode <> G_TTYPE_CREATE');
4149: -- check if CM exists
4150: IF (EGO_ITEM_AML_PUB.Check_CM_Existance() = G_RET_STS_SUCCESS) THEN
4151:
4152: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item: CM Exists!');
4153:
4154: -- ENG exists
4155: -- check for policy control
4156: l_dynamic_sql :=

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

4243: -- Append to the list of attribute group ids to exclude, the --
4244: -- UCCnet related Attribute groups, as the Template application--
4245: -- is taken care of in Java code for these Attrs. --
4246: -----------------------------------------------------------------
4247: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' About to call the UCCnet attrs exclude code');
4248: l_attr_grp_dyn_sql := '';
4249: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'SELECT DISTINCT ATTRIBUTE_GROUP_ID ';
4250: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'FROM EGO_TEMPL_ATTRIBUTES T ';
4251: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'WHERE T.TEMPLATE_ID = :TEMPL_ID ';

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

4275: l_attr_grp_rows_cnt := DBMS_SQL.FETCH_ROWS(l_attr_grp_cursor);
4276:
4277: DBMS_SQL.COLUMN_VALUE(l_attr_grp_cursor, 1, l_attr_grp_table);
4278:
4279: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('load_item_oper_attr_values: Retrieved rows => '||To_char(l_attr_grp_rows_cnt));
4280:
4281: FOR i IN 1..l_attr_grp_table.COUNT LOOP
4282:
4283: -----------------------------------------------------------------------

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

4286: IF l_attr_group_ids_to_exclude IS NULL THEN
4287: l_attr_group_ids_to_exclude := EGO_NUMBER_TBL_TYPE();
4288: END IF;
4289:
4290: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Attr Grp ID => '|| l_attr_grp_table(i));
4291: -----------------------------------------------------------------------
4292: -- Add these retrieved Attr Grp IDs to the end of existing:
4293: -- Exclusion Attr Grp IDs table (l_attr_group_ids_to_exclude)
4294: -----------------------------------------------------------------------

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

4302: EXIT WHEN l_attr_grp_rows_cnt < 2500;
4303: END LOOP; --end: Loop for every 2500 rows.
4304: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);
4305:
4306: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' UCCnet exclusion code complete.');
4307:
4308: -----------------------------------------------------------------
4309: -- END: PPEDDAMA (11th October 2004) --
4310: -----------------------------------------------------------------

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

4313: l_attr_group_ids IS NOT NULL AND
4314: l_attr_group_ids_to_exclude.COUNT > 0 AND
4315: l_attr_group_ids.COUNT > 0 ) THEN
4316:
4317: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_attr_group_ids_to_exclude.COUNT = '||l_attr_group_ids_to_exclude.COUNT);
4318: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_attr_group_ids.COUNT = '||l_attr_group_ids.COUNT);
4319:
4320: -----------------------------------------------------------------
4321: -- don't issue perform dml if all attr grps are excluded

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

4314: l_attr_group_ids_to_exclude.COUNT > 0 AND
4315: l_attr_group_ids.COUNT > 0 ) THEN
4316:
4317: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_attr_group_ids_to_exclude.COUNT = '||l_attr_group_ids_to_exclude.COUNT);
4318: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_attr_group_ids.COUNT = '||l_attr_group_ids.COUNT);
4319:
4320: -----------------------------------------------------------------
4321: -- don't issue perform dml if all attr grps are excluded
4322: -----------------------------------------------------------------

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

4320: -----------------------------------------------------------------
4321: -- don't issue perform dml if all attr grps are excluded
4322: -----------------------------------------------------------------
4323: IF (l_attr_group_ids_to_exclude.COUNT = l_attr_group_ids.COUNT) THEN
4324: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_perform_dml is FALSE ');
4325: l_perform_dml := FALSE;
4326: END IF; --end: IF (l_attr_group_ids_to_exclude.COUNT >= ...
4327:
4328: END IF; --end: IF (l_attr_group_ids_to_exclude IS NOT NULL ...

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

4328: END IF; --end: IF (l_attr_group_ids_to_exclude IS NOT NULL ...
4329:
4330: IF (l_perform_dml = TRUE) THEN
4331:
4332: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_perform_dml is TRUE ');
4333:
4334: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (
4335: p_api_version => 1.0
4336: ,p_template_id => p_template_id

Line 4334: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (

4330: IF (l_perform_dml = TRUE) THEN
4331:
4332: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('l_perform_dml is TRUE ');
4333:
4334: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (
4335: p_api_version => 1.0
4336: ,p_template_id => p_template_id
4337: ,p_object_name => p_object_name
4338: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs

Line 4349: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (

4345: ,x_msg_count => x_msg_count
4346: ,x_msg_data => x_msg_data
4347: );
4348:
4349: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (
4350: p_api_version => 1.0
4351: ,p_template_id => p_template_id
4352: ,p_object_name => p_object_name
4353: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs

Line 4364: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (

4360: ,x_msg_count => x_msg_count
4361: ,x_msg_data => x_msg_data
4362: );
4363:
4364: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (
4365: p_api_version => 1.0
4366: ,p_template_id => p_template_id
4367: ,p_object_name => p_object_name
4368: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs

Line 4379: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (

4375: ,x_msg_count => x_msg_count
4376: ,x_msg_data => x_msg_data
4377: );
4378:
4379: EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template (
4380: p_api_version => 1.0
4381: ,p_template_id => p_template_id
4382: ,p_object_name => p_object_name
4383: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs

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

4392: );
4393:
4394: END IF;
4395:
4396: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Apply_Templ_User_Attrs_To_Item -- Done');
4397: EXCEPTION
4398: WHEN OTHERS THEN
4399: IF (l_attr_grp_cursor IS NOT NULL) THEN
4400: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);

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

4398: WHEN OTHERS THEN
4399: IF (l_attr_grp_cursor IS NOT NULL) THEN
4400: DBMS_SQL.Close_Cursor(l_attr_grp_cursor);
4401: END IF;
4402: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('In Apply_Templ_User_Attrs_To_Item, got exception '||SQLERRM, 3);
4403:
4404: END Apply_Templ_User_Attrs_To_Item;
4405:
4406: ---------------------------------------------------------------------------