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_IMPORT_UTIL_PVT dependencies on EGO_USER_ATTRS_BULK_PVT

Line 367: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEMMGMT_GROUP');

363: ' WHERE MIN_LEVEL = CATALOG_LEVEL ';
364:
365:
366: l_class_code_hierarchy_sql := ' SELECT item_catalog_group_id FROM MTL_ITEM_CATALOG_GROUPS_B TEMPL CONNECT BY PRIOR TEMPL.PARENT_CATALOG_GROUP_ID = TEMPL.ITEM_CATALOG_GROUP_ID START WITH TEMPL.ITEM_CATALOG_GROUP_ID = ENTITIES.ITEM_CATALOG_GROUP_ID ';
367: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEMMGMT_GROUP');
368: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
369: p_api_version => 1.0
370: ,p_application_id => 431
371: ,p_object_name => 'EGO_ITEM'

Line 368: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(

364:
365:
366: l_class_code_hierarchy_sql := ' SELECT item_catalog_group_id FROM MTL_ITEM_CATALOG_GROUPS_B TEMPL CONNECT BY PRIOR TEMPL.PARENT_CATALOG_GROUP_ID = TEMPL.ITEM_CATALOG_GROUP_ID START WITH TEMPL.ITEM_CATALOG_GROUP_ID = ENTITIES.ITEM_CATALOG_GROUP_ID ';
367: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEMMGMT_GROUP');
368: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
369: p_api_version => 1.0
370: ,p_application_id => 431
371: ,p_object_name => 'EGO_ITEM'
372: ,p_interface_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

Line 403: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEM_GTIN_ATTRS');

399: x_return_status := '0';
400: x_err_msg := NULL;
401: END IF;
402:
403: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEM_GTIN_ATTRS');
404: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
405: p_api_version => 1.0
406: ,p_application_id => 431
407: ,p_object_name => 'EGO_ITEM'

Line 404: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(

400: x_err_msg := NULL;
401: END IF;
402:
403: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEM_GTIN_ATTRS');
404: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
405: p_api_version => 1.0
406: ,p_application_id => 431
407: ,p_object_name => 'EGO_ITEM'
408: ,p_interface_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

Line 439: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEM_GTIN_MULTI_ATTRS');

435: x_return_status := '0';
436: x_err_msg := NULL;
437: END IF;
438:
439: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEM_GTIN_MULTI_ATTRS');
440: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
441: p_api_version => 1.0
442: ,p_application_id => 431
443: ,p_object_name => 'EGO_ITEM'

Line 440: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(

436: x_err_msg := NULL;
437: END IF;
438:
439: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEM_GTIN_MULTI_ATTRS');
440: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
441: p_api_version => 1.0
442: ,p_application_id => 431
443: ,p_object_name => 'EGO_ITEM'
444: ,p_interface_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

Line 1174: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (

1170: AND miri.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'# #';
1171:
1172: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: Created l_entity_sql');
1173:
1174: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (
1175: p_api_version =>1.0
1176: ,p_application_id =>431
1177: ,p_attr_group_type =>'EGO_ITEMMGMT_GROUP'
1178: ,p_object_name =>'EGO_ITEM'

Line 1189: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: Done EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows l_return_status, l_err_msg='||l_return_status||','||l_err_msg);

1185: ,p_extra_column_values => ' ''EXT_DEFAULT_VAL_ROW'' '
1186: ,x_return_status => l_return_status
1187: ,x_msg_data => l_err_msg);
1188:
1189: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: Done EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows l_return_status, l_err_msg='||l_return_status||','||l_err_msg);
1190: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1191: x_return_status := '2';
1192: x_err_msg := l_err_msg;
1193: RETURN;

Line 1298: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (

1294: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
1295: AND msii.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'# #';
1296:
1297: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: For GDSN Attributes, Created l_entity_sql');
1298: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (
1299: p_api_version =>1.0
1300: ,p_application_id =>431
1301: ,p_attr_group_type =>'EGO_ITEM_GTIN_ATTRS'
1302: ,p_object_name =>'EGO_ITEM'

Line 1313: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: Done EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows l_return_status, l_err_msg='||l_return_status||','||l_err_msg);

1309: ,p_extra_column_values => ' ''EXT_DEFAULT_VAL_ROW'' '
1310: ,x_return_status => l_return_status
1311: ,x_msg_data => l_err_msg);
1312:
1313: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: Done EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows l_return_status, l_err_msg='||l_return_status||','||l_err_msg);
1314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: x_return_status := '2';
1316: x_err_msg := l_err_msg;
1317: RETURN;

Line 1360: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (

1356: AND eiai.PROCESS_FLAG = #' || p_msii_miri_process_flag || q'# #';
1357:
1358: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: For Intersections - Created l_entity_sql');
1359:
1360: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (
1361: p_api_version =>1.0
1362: ,p_application_id =>431
1363: ,p_attr_group_type =>'EGO_ITEMMGMT_GROUP'
1364: ,p_object_name =>'EGO_ITEM'

Line 1375: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: For Intersections - Done EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows l_return_status, l_err_msg='||l_return_status||','||l_err_msg);

1371: ,p_extra_column_values => ' ''EXT_DEFAULT_VAL_ROW'' '
1372: ,x_return_status => l_return_status
1373: ,x_msg_data => l_err_msg);
1374:
1375: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: For Intersections - Done EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows l_return_status, l_err_msg='||l_return_status||','||l_err_msg);
1376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1377: x_return_status := '2';
1378: x_err_msg := l_err_msg;
1379: RETURN;

Line 4228: Decode(attr_ext.data_type,'X',ego_user_attrs_bulk_pvt.Get_date(fl_col.default_value,NULL),

4224: NULL)),
4225: Decode(attr_ext.data_type,'A',fl_col.default_value,
4226: 'C',fl_col.default_value,
4227: NULL),
4228: Decode(attr_ext.data_type,'X',ego_user_attrs_bulk_pvt.Get_date(fl_col.default_value,NULL),
4229: 'Y',ego_user_attrs_bulk_pvt.Get_date(fl_col.default_value,NULL),
4230: NULL)
4231: BULK COLLECT INTO l_attr_group_id,l_attr_group_name,l_attr_name,l_data_type,
4232: l_n_def_value,l_c_def_value,l_d_def_value

Line 4229: 'Y',ego_user_attrs_bulk_pvt.Get_date(fl_col.default_value,NULL),

4225: Decode(attr_ext.data_type,'A',fl_col.default_value,
4226: 'C',fl_col.default_value,
4227: NULL),
4228: Decode(attr_ext.data_type,'X',ego_user_attrs_bulk_pvt.Get_date(fl_col.default_value,NULL),
4229: 'Y',ego_user_attrs_bulk_pvt.Get_date(fl_col.default_value,NULL),
4230: NULL)
4231: BULK COLLECT INTO l_attr_group_id,l_attr_group_name,l_attr_name,l_data_type,
4232: l_n_def_value,l_c_def_value,l_d_def_value
4233: FROM ego_mappings_b MAP,

Line 4338: ego_user_attrs_bulk_pvt.Get_date(l_d_def_value(i)),

4334: l_attr_group_name(i),
4335: l_attr_name(i),
4336: l_n_def_value(i),
4337: l_c_def_value(i),
4338: ego_user_attrs_bulk_pvt.Get_date(l_d_def_value(i)),
4339: 'CREATE',
4340: a.inventory_item_id,
4341: a.organization_id,
4342: /* Bug 13720439 - Start

Line 4457: ego_user_attrs_bulk_pvt.Get_date(l_d_def_value(i)),

4453: l_attr_group_name(i),
4454: l_attr_name(i),
4455: l_n_def_value(i),
4456: l_c_def_value(i),
4457: ego_user_attrs_bulk_pvt.Get_date(l_d_def_value(i)),
4458: 'CREATE',
4459: inventory_item_id,
4460: msii.organization_id,
4461: source_system_reference,

Line 4759: -- for user given data and before the call to EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data api, so that

4755: -- and copying of attributes if any
4756:
4757: -- Bug 10263673 : Start
4758: -- Moving the logic of template application and copy of attributes into EGOCIUAB.pls after the validation of IDs
4759: -- for user given data and before the call to EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data api, so that
4760: -- Application of template is done before defaulting of attr level values.
4761: --
4762: /*
4763: Process_Copy_Options_For_UDAs(retcode => l_retcode,