APPS.EGO_ITEM_BULKLOAD_PKG dependencies on EGO_GTIN_PVT

Line 6864: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES (p_inventory_item_id => l_inventory_item_id ,

6860: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id' ||
6861: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6862: END IF;
6863:
6864: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES (p_inventory_item_id => l_inventory_item_id ,
6865: p_organization_id => l_organization_id ,
6866: p_update_reg => 'Y' ,
6867: x_return_status => l_return_status ,
6868: x_msg_count => l_msg_count,

Line 6871: Write_Debug('GTIN : Clear_Gtin_Attrs. :: Exception from EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES ');

6867: x_return_status => l_return_status ,
6868: x_msg_count => l_msg_count,
6869: x_msg_data => l_msg_data );
6870: IF l_return_status <> 'S' THEN
6871: Write_Debug('GTIN : Clear_Gtin_Attrs. :: Exception from EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES ');
6872: Write_Debug('GTIN : Clear_Gtin_Attrs. ::message ' || l_msg_data );
6873: END IF;
6874:
6875: ELSE

Line 6906: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES (p_inventory_item_id => l_inventory_item_id ,

6902: ' FROM DUAL ) WHERE INVENTORY_ITEM_ID = :inventory_item_id ' ||
6903: ' AND ORGANIZATION_ID = :organization_id ' USING l_inventory_item_id , l_organization_id;
6904: END IF;
6905:
6906: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES (p_inventory_item_id => l_inventory_item_id ,
6907: p_organization_id => l_organization_id ,
6908: p_update_reg => 'N' ,
6909: x_return_status => l_return_status,
6910: x_msg_count => l_msg_count,

Line 6913: Write_Debug('GTIN : Clear_Gtin_Attrs. :: Exception from EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES ');

6909: x_return_status => l_return_status,
6910: x_msg_count => l_msg_count,
6911: x_msg_data => l_msg_data );
6912: IF l_return_status <> 'S' THEN
6913: Write_Debug('GTIN : Clear_Gtin_Attrs. :: Exception from EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES ');
6914: Write_Debug('GTIN : Clear_Gtin_Attrs. ::message ' || l_msg_data );
6915: END IF;
6916:
6917: END IF; --GTID is Each / non-Each