DBA Data[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_USER_ATTRS_BULK_PVT

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

313: ' WHERE MIN_LEVEL = CATALOG_LEVEL ';
314:
315:
316: 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 ';
317: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEMMGMT_GROUP');
318: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
319: p_api_version => 1.0
320: ,p_application_id => 431
321: ,p_object_name => 'EGO_ITEM'

Line 318: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(

314:
315:
316: 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 ';
317: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEMMGMT_GROUP');
318: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
319: p_api_version => 1.0
320: ,p_application_id => 431
321: ,p_object_name => 'EGO_ITEM'
322: ,p_interface_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

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

349: x_return_status := '0';
350: x_err_msg := NULL;
351: END IF;
352:
353: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEM_GTIN_ATTRS');
354: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
355: p_api_version => 1.0
356: ,p_application_id => 431
357: ,p_object_name => 'EGO_ITEM'

Line 354: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(

350: x_err_msg := NULL;
351: END IF;
352:
353: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEM_GTIN_ATTRS');
354: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
355: p_api_version => 1.0
356: ,p_application_id => 431
357: ,p_object_name => 'EGO_ITEM'
358: ,p_interface_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

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

385: x_return_status := '0';
386: x_err_msg := NULL;
387: END IF;
388:
389: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEM_GTIN_MULTI_ATTRS');
390: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
391: p_api_version => 1.0
392: ,p_application_id => 431
393: ,p_object_name => 'EGO_ITEM'

Line 390: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(

386: x_err_msg := NULL;
387: END IF;
388:
389: Debug_Conc_Log('Call_UDA_Apply_Template: Calling EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table for EGO_ITEM_GTIN_MULTI_ATTRS');
390: EGO_USER_ATTRS_BULK_PVT.Apply_Template_On_Intf_Table(
391: p_api_version => 1.0
392: ,p_application_id => 431
393: ,p_object_name => 'EGO_ITEM'
394: ,p_interface_table_name => 'EGO_ITM_USR_ATTR_INTRFC'

Line 1064: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (

1060: AND miri.PROCESS_FLAG = 1 #';
1061:
1062: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: Created l_entity_sql');
1063:
1064: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (
1065: p_api_version =>1.0
1066: ,p_application_id =>431
1067: ,p_attr_group_type =>'EGO_ITEMMGMT_GROUP'
1068: ,p_object_name =>'EGO_ITEM'

Line 1079: 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);

1075: ,p_extra_column_values => ' ''EXT_DEFAULT_VAL_ROW'' '
1076: ,x_return_status => l_return_status
1077: ,x_msg_data => l_err_msg);
1078:
1079: 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);
1080: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1081: x_return_status := '2';
1082: x_err_msg := l_err_msg;
1083: RETURN;

Line 1141: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (

1137: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
1138: AND msii.PROCESS_FLAG = 1 #';
1139:
1140: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: For GDSN Attributes, Created l_entity_sql');
1141: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (
1142: p_api_version =>1.0
1143: ,p_application_id =>431
1144: ,p_attr_group_type =>'EGO_ITEM_GTIN_ATTRS'
1145: ,p_object_name =>'EGO_ITEM'

Line 1156: 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);

1152: ,p_extra_column_values => ' ''EXT_DEFAULT_VAL_ROW'' '
1153: ,x_return_status => l_return_status
1154: ,x_msg_data => l_err_msg);
1155:
1156: 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);
1157: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1158: x_return_status := '2';
1159: x_err_msg := l_err_msg;
1160: RETURN;

Line 1203: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (

1199: AND eiai.PROCESS_FLAG = 1 #';
1200:
1201: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: For Intersections - Created l_entity_sql');
1202:
1203: EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows (
1204: p_api_version =>1.0
1205: ,p_application_id =>431
1206: ,p_attr_group_type =>'EGO_ITEMMGMT_GROUP'
1207: ,p_object_name =>'EGO_ITEM'

Line 1218: 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);

1214: ,p_extra_column_values => ' ''EXT_DEFAULT_VAL_ROW'' '
1215: ,x_return_status => l_return_status
1216: ,x_msg_data => l_err_msg);
1217:
1218: 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);
1219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1220: x_return_status := '2';
1221: x_err_msg := l_err_msg;
1222: RETURN;